| |
 |
|
Oracle Tips by Burleson |
Chapter 1
Oracle Instance Internals Scripts
REM
REM Script to determine sleeps for latches
REM M. R. Ault 2003
REM
col name format a30 heading 'Latch Name'
col gets format 99,999,999,999 heading 'Gets'
col misses format 9,999,999,999 heading 'Misses'
col sleeps format 999,999,999 heading 'Sleeps'
set pages 55
ttitle80 'Latches Contention Report'
spool latches_con
select name,gets,misses,sleeps from v$latch where gets>0 and
misses>0 order
by gets desc
/
spool off
clear columns
ttitle off
The output from the above script should
resemble the following:
Latch
Name Gets Misses Sleeps
-------------------------- ------------ ------------ ------------
cache buffers chains 668,498,922 16,722 1,576
library cache 57,209,901 87,420 9,747
session idle bit 17,831,191 393 7
row cache objects 16,368,218 2,265 24
enqueues 7,239,390 436 14
checkpoint queue latch 6,741,674 133 55
cache buffers lru chain 5,458,113 134 2
redo allocation 5,321,254 938 105
transaction allocation 5,248,223 458 7
The above text is
an excerpt from:
Mike
Ault’s Oracle Internals Monitoring & Tuning Scripts
Written by the world's top DBA and author
of over 20 Oracle books, Mike Ault shares his secrets for Oracle
DBA management scripts. This handy reference is indispensable
for all Oracle professionals who must quickly automate and
manage their Oracle databases with scripts.
This stellar book comes complete with an
online code depot full of over 200 pre-tested Oracle DBA
scripts, and covers all areas of Oracle database administration
including data files, tablespace, table and index management
scripts. Based on more than 20 years full-time experience, Mike
Ault brings his expertise to the public with this fantastic
book. Your time savings from a single script is worth the price
of this great book.
http://www.rampant-books.com/download_adv_mon_tuning.htm
http://rampant-books.com/book_2003_2_audit.htm
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
