Oracle Training Oracle Support Development Oracle Apps

Free Oracle Tips

HTML Text

 Home
 Catalog
 Oracle Books
 Oracle Software
 Job Interview
 eBooks
 SQL Server Books
 News
 Oracle Scripts
 Oracle Tuning Book
 Remote DBA
 Oracle Tuning
 

  

 

Rampant Oracle In-Focus Series

 

  Oracle Performance Troubleshooting
with Dictionary Internals SQL & Tuning Scripts

Robin Schumacher
ISBN 0-9727513-4-3 
Publication Date - May 2003
Retail Price $27.95
/  £17.95 

Order now and get 30% off the retail price!

You also receive immediate online access to the code depot!

Only $19.95

Buy it now!


Sample Text:         

If you want a deeper understanding of how the buffer cache is being utilized, there are a few additional queries you can run to gain such insight.  If the keep and recycle buffer caches are being used, you can run the cacheobjcnt.sql  query to get an idea on how many objects have been assigned to each cache:

For the complete listing of the cacheobjcnt.sql  query, please refer to the online Code Depot at http://www.dba-oracle.com/bp/bp_book5_perf.htm.

This query looks at the sys.seg$ view and the output may resemble something like the following:

CACHE     OBJECTS

-----------------

default      2023

keep            5

Finally, you may wish to analyze the buffer cache activity from time to time to see how it is being utilized.  The buffutl.sql  script will show you how full the cache currently is along with the state of the buffers in the cache:

For the complete listing of the buffutl.sql  script, please refer to the online Code Depot at http://www.dba-oracle.com/bp/bp_book5_perf.htm.

This script queries the sys.x$bh, and sys.ts$ views and the output might look something like this:

BUFFER_STATE      AMT_KB

------------------------

being read          5920

free               23568

read/mod           47952

read/notmod            0

 

 

If you're a DBA who's looking for real world Oracle tuning techniques, Oracle scripts, and advice on how to get to the heart of critical Oracle performance problems, then you've come to the right place. Oracle Performance Troubleshooting: With Dictionary Internals SQL & Tuning Scripts was written by one the world's most widely-read DBAs and Oracle internals experts. Robin Schumacher focuses his incredible knowledge of the Oracle data dictionary into a superb book that shows how to quickly troubleshoot and correct Oracle performance problems. 

Plus! The online code depot is available immediately!

http://www.dba-oracle.com/bp/bp_book5_perf.htm


 

 

    P. O. Box 511
Kittrell, NC, 27544