var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: URGENT : How to find which are all the tables are chached in oracle 9i
URGENT : How to find which are all the tables are chached in oracle 9i
Yes, I found it, from dba_tables and the column cache
now how to find the index is cached,
can i cache only index
Check in DBA_INDEXES.
Sathih, I checked in dba_indexes but I do not know is the column which says it is cached or not, I am using oracle9i.
SQL> select owner,name,namespace,pins, kept from v$db_object_cache where namespace= 'INDEX';
hope this help