/* ************************************************ */
/*                                                  */
/* Script: Display statistics the shared pool area  */
/*         in cache                                 */
/*                                                  */
/* name:    @c:\oracle\sql\v$lib_ca.sql             */
/* date:    24-AUG-95                               */
/* creator: Rick Kupcunas                           */
/*                                                  */
/* ************************************************ */

set pagesize 65;
set linesize 80;

select sum(pins) "EXECUTIONS",
	sum(reloads) "CACHE MISSES",
      	(sum(reloads)/sum(pins))*100 "RATIO"
   from v$librarycache;

commit;

