Re: How often a table is accessed?

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

Execute the following. Details on the query are available 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
/

Catcox wrote:

> Does anybody know of some nifty query which would return a list of tables and
> the frequency with which they are accessed by users?
>
> If you know that this is not possible, I'd like to know that too.
>
> Thank you,
>
> Catherine Cox
> catcox_at_aol.com
Received on Mon Jan 19 1998 - 00:00:00 CST