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

Home
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


 
HTML Text AOL

Free Oracle App Server Tips


 
HTML Text

Oracle support

Oracle training

Oracle tuning

Rednecks!

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
prompt

select
. . .
from
  dba_segments s
where
  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.

BUFFER_POOL_KEEP=(1456, 3)

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.

http://www.rampant-books.com/download_adv_mon_tuning.htm

 

 

 
 
 

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.