 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 7 - Tuning and Performance
Segment-Level Performance Statistics
Collection
Starting with Oracle9i Release 2,
administrators are able to gather statistics at the individual
segment level. Don’t confuse segment-level performance statistics
with optimizer statistics generated from a dbms_stats
execution or SQL ANALYZE statement.
Segment-level performance statistics are a
subset of the statistics captured at the system level. A list of
the statistics captured is as follows:
-
Logical reads – buffers used for consistent
and current reads
-
Buffer busy waits – waits caused by a buffer
that is in use
-
Db block changes – changes applied to buffers
-
Physical reads – number of physical reads
-
Physical writes – number of physical writes
-
Physical reads direct – number of direct reads
-
Physical writes direct – number of direct
writes
-
ITL waits – waits caused by no ITL entry
-
Row lock waits – waits caused by row lock
contention
-
Global cache cr blocks served – Real
Application Cluster statistical information
-
Global cache current blocks served – Real
Application Cluster statistical information
The above text is
an excerpt from:
OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database
Administration Techniques
ISBN 0-9744355-3-8
by Christopher T. Foot
http://www.rampant-books.com/book_2003_2_OCP_print.htm
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
