Hussain
I wish there was. I hope someone will reply with a good method. First,
add up all the blocks for the tables and their indexes you have assigned to
the KEEP pool. Some of them may have grown over the past months and you may
not have enough space allocated for all of them. Check the BHR for the KEEP
pool to see what hit ratio you are getting. It should be 100%. Past that,
you can consider the tables you have assigned to the KEEP pool and other
small tables that you haven't assigned to the KEEP pool to decide if you
have the best candidates assigned. You are looking for small tables that are
accessed a lot. Based on your analysis and the available memory, you may
decide to increase or reduce the size of the KEEP pool. Again, I really hope
you (and I) receive a better reply.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Monday, March 17, 2003 2:14 AM
To: Multiple recipients of list ORACLE-L
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
