 |
|
Oracle Tips by Burleson |
Easy Oracle Automation
Chapter 4 -
Automatic Workload Repository and Automatic Database
Diagnostic Monitor
Creating Custom AWR Reports
|
STATISTIC_NAME
|
|
cluster wait time
concurrency wait
time
application wait
time
user I/O wait
time enqueue
waits
enqueue
deadlocks
db block
gets
consistent
gets
physical
reads
physical read IO
requests
db block
changes
physical
writes
DBWR buffers scanned
DBWR
checkpoints
hot buffers moved to head of
LRU
shared hash latch upgrades -
wait
redo log space
requests
redo log space wait
time
table scans (short
tables
table scans (long
tables
table fetch continued
row
leaf node
splits
leaf node 90-10
splits
index fast full scans
(full)
session cursor cache
hits
buffer is not pinned
count
workarea executions - multipass
parse time
cpu
parse time
elapsed
parse count (total)
SQL*Net roundtrips to/from
client
sorts
(memory)
sorts
(disk)
sorts
(rows)
|
The above text is
an excerpt from:
Easy Oracle Automation
Oracle10g Automatic
Storage, Memory and Diagnostic Features
ISBN 0-9745993-6-0
by Dr. Arun Kumar R.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
