Re: How to identify what db objects are on the cache

From: Andrew Allen <andrew.allen_at_handleman.com>
Date: 18 Sep 2002 12:14:01 -0700
Message-ID: <6dae400e.0209181114.13aa819_at_posting.google.com>

elire_at_amdocs.com (Elir) wrote in message news:<e7cbfa45.0209180224.1ec8c113_at_posting.google.com>...
> How to identify what db objects are currently pin on the database cache.

SELECT  c.owner         owner,
        c.name          name,
        c.type          type,
        c.sharable_mem/1024  s_mem_kb,
        c.loads         loads,
        c.executions    p_executions,
        c.locks         p_locks,
        c.pins          p_pins,
        c.kept          kept

  FROM v$db_object_cache c
 where 1 = 1
   and kept = 'YES'
order by kept desc, owner, name, type, c.sharable_mem /

HTH
Andrew Received on Wed Sep 18 2002 - 21:14:01 CEST