Re: How often a table is accessed?

From: Tarun <aptconsulting_at_hotmail.com>
Date: 1998/01/19
Message-ID: <34C2C50D.939AE07E@hotmail.com>#1/1

Run the following query. v$db_object_cache has details on objects accessed. The details on the query can be found at www.oracle.com Tips of the day Column.

Cheers.
Tarun Agarwal
aptconsulting_at_hotmail.com

select c.loads, c.executions, c.owner||'.'||c.name name,

       t.tablespace_name tablespace, s.bytes/1024 KB, c.sharable_mem
  from dba_tables        t,
       dba_segments      s,
       v$db_object_cache c
 where c.type  = 'TABLE'
   and c.executions > 0
   and c.name  = t.table_name
   and c.owner = t.owner

   and c.name = s.segment_name
   and c.owner = s.owner
 order by 4, 1 desc, 2 desc, 3
/ Received on Mon Jan 19 1998 - 00:00:00 CST