||Oracle Tips by Burleson
Automatically Generate Oracle KEEP pool
Extrapolating from the above script, we can
write another script that automatically identifies candidates for the
KEEP pool and generates the syntax to move the tables into the pool.
The placement criteria for tables and indexes
into the KEEP buffer are straightforward:
Frequently-accessed tables – The threshold for access can be adjusted
in the script.
buffer residency – Any table that has more than 80% of its blocks in
the data buffer should be cached in the KEEP pool.
The approach to identifying tables for the
KEEP pool is simple. You should assign all objects to the KEEP pool
that have more than 80% of their data blocks in the buffer
are scripts for each method.
text is an excerpt from "Creating
a Self Tuning Oracle Database", by Rampant TechPress. It is only
$9.95 and all scripts in this tips can be immediately downloaded.
Complete Oracle Script Collection Available
shares their personal arsenal of Oracle data dictionary
scripts in this comprehensive download. With decades of
experience using Oracle monitoring scripts and Oracle tuning
scripts, we shares our secrets for navigating the Oracle
Packed with more than 680 ready-to-use Oracle scripts, this is the
definitive collection for every senior Oracle DBA.
would take man-years to develop these scripts from scratch,
making this download the best value in the Oracle industry.