Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help on V$DB_OBJECT_CACHE

Help on V$DB_OBJECT_CACHE

From: <anthonywmhui_at_hotmail.com>
Date: Wed, 07 Jul 1999 03:44:13 GMT
Message-ID: <7luiec$1gk$1@nnrp1.deja.com>


Did anyone have more information on V$DB_OBJECT_CACHE. I am going to extract data from this view and I want to know:-

  1. Will objects accessed by Utilities like SQLLOAD, IMP or EXP be cache in this view?
  2. How frequency should I query the view so that I will always get all objects(mainly table name and index name) before they are flushed? Did V$SHARED_POOL_RESERVED contain any information for estimating the frequency.
  3. Is there any other views will store similar information? Other related views

Thanks a lot!

Anthony
Database Design Analyst

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 06 1999 - 22:44:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US