| |
 |
|
Oracle Tips by Burleson |
Chapter 1
Oracle Instance Internals Scripts
session
allocation 4,700,939 1,920 59
shared pool 4,316,720 1,577 991
messages 3,976,313 7,147 200
enqueue hash chains 3,878,828 838 65
redo writing 3,540,931 42,259 679
undo global data 3,374,722 184 1
process queue reference 2,461,595 1,206 2
dml lock allocation 1,370,771 119 1
list of block allocation 1,290,257 45 18
multiblock read objects 639,872 23 9
cache buffer handles 234,148 3 5
latch wait list 6,730 51 4
parallel query stats 22 5 10
It can be a challenge to monitor locks in
Oracle. Just for v$lock_dpt alone, multiple joins are usually
required to get the desired information. We suggest using the
catblock.sql script, as it creates several useful
views for locks. The catblock.sql script is located in the $ORACLE_HOME/rdbms/admin
directory on UNIX, and in the c:\orant\rdbms\admin directory on NT.
The script creates dba_kgllock, dba_lock, dba_lock_internal, dba_dml_locks, dba_ddl_locks, dba_waiters,
and dba_blockers.
It is best to set echo ON, since many releases
contain errors that must be corrected before it will run properly.
In early Oracle7 releases, there were also permissions problems with
some of the lock views, which required that they be queried from SYS
or INTERNAL only. OEM contains a detailed lock screen in the GUI, as
well as an HTML-based report for locking. The OEM Lock Manager GUI
is shown in Figure 1.1.
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
|
|
