Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients


Free Oracle Tips


Free Oracle App Server Tips


Oracle support

Oracle training

Oracle tuning


Remote Oracle

Custom Oracle Training


  Oracle Tips by Burleson

Sizing the Oracle KEEP Pool

Finally, once the tables and indexes have been loaded into the KEEP buffer pool, the buffer_pool_keep parameter must be increased by the total number of blocks in the migrated tables.

The following script will total the number of blocks that the KEEP pool requires, insuring 100 percent data caching. You should note that the script adds 20 percent to the total to allow for growth in the cached objects. The DBA should run this important script frequently to make sure the KEEP pool always has a DBHR of 100 percent.

See code depot for full scripts

-- ****************************************************************
-- Display correct size for the KEEP pool
-- Copyright (c) 2003 By Donald K. Burleson - All Rights reserved.
-- ****************************************************************

prompt The following will size your init.ora KEEP POOL,
prompt based on Oracle8 KEEP Pool assignment values

. . .
  dba_segments s
  s.buffer_pool = 'KEEP';

This script outputs the Oracle parameter that resizes the KEEP pool for the next re-start of the Oracle instance. The parameter is placed in the init.ora file. You should know that Oracle9i deprecates buffer_pool_keep and it cannot be modified with an alter system command.


We can now bounce the database and the parameter change will take effect.


The above 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

BC 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 data dictionary.

Packed with more than 680 ready-to-use Oracle scripts, this is the definitive collection for every senior Oracle DBA.

It would take man-years to develop these scripts from scratch, making this download the best value in the Oracle industry.




Oracle performance tuning book



Oracle performance tuning software

Oracle performance tuning software
Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel


email BC:

Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.