/* ************************************************ */
/*                                                  */
/* Script: Display statistics the database objects  */
/*         in cache                                 */
/*                                                  */
/* name:    @c:\oracle\sql\v$db_cach.sql            */
/* date:    24-AUG-95                               */
/* creator: Rick Kupcunas                           */
/*                                                  */
/* ************************************************ */

set pagesize 65;
set linesize 80;
set numwidth 8;

select substr(owner, 1,8) "OWNER",
	substr(name, 1,16) "NAME",
      	substr(type, 1,12)  "TYPE",
      	sharable_mem,
	loads,
	executions,
	pins
   from v$db_object_cache  
  where owner = upper('&&OWNER')
  order by 1 asc, 2 asc, 3 asc;

Prompt:  verify the SORT values; do we have a lot of writes to 
Prompt:  the temporary tablespaces.....

commit;
undefine OWNER;

