Title: Buffer_Pool KEEP
|
how about looking at v$bh and match the objectid
with dba_tables (objects) . Also look at v$sgastat for keep pool
.
-ak
----- Original Message -----
Sent: Monday, March 17, 2003 12:13
AM
Subject: Buffer_Pool KEEP
Hi all,
Is there any way / script to
find whether the tables kept in KEEP Buffer pool performing fine i.e. do they
really need to be in the KEEP buffer pool or should they be removed. Tables
that I want to check are in the buffer pool for over 6 months and I want to
know if I should let them be there or be removed from there.
Regards,
Hussain
DBA
SKMCH&RC
|
