SQL Script Objects in DB Cache

Updated: 02-Jun-2005
Version: 1.0

Description

List of what objects are current in the DB Cache

Parameters

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

set serverout on size 1000000
set verify off

col object_name form a30

break on report
compute sum of count(*) on report

spool bufferobj.lst

SELECT o.object_name, o.object_type, count(*)
FROM dba_objects o,sys.x$bh x
WHERE x.obj=o.object_id
AND o.owner<>'SYS'
GROUP BY o.object_name, o.object_type
ORDER BY count(*);

spool off

Related Links

Oracle 10g: (SQL Script) DB Block Buffer

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links