|
|
| |
 |
|
Oracle Tips by Burleson |
Chapter 1
Oracle Instance Internals Scripts
|
CLASS |
DEFINITION |
|
extent map |
For locally managed tablespaces this tells
how many extant map waits have occurred. |
|
free list |
This tells you how many waits there have
been on free lists in the database. |
|
save undo block |
A save undo segment is generated when a
tablespace is taken offline in an emergency situation, this
tells how many waits have occurred on a save undo segment block
(undo means rollback). |
|
save undo header |
This tells how many waits have occurred in
a save undo header. |
|
segment header |
A database segment corresponds to a table,
index, cluster, etc. This wait tells how many waits there have
been on a segment header entry. |
|
sort block |
This wait is for sort blocks. |
|
System undo block |
A system undo segment is the SYSTEM
rollback segment in the SYSTEM tablespace. This shows waits on
the system rollback segment blocks. |
|
System undo header |
This shows waits on the system rollback
segment header. |
|
undo block |
This one statistics carries the load for
all normal rollback segment block waits. |
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
|
|
|
|
