 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 7 - Tuning and Performance
Segment-Level Performance Statistics
Collection
When
investigating performance problems, administrators would use the
system-wide statistics contained in the V$ views to review
performance indicators at the instance level. Segment-level
performance statistics can then be used to focus on the specific
tables and indexes that may be causing the problem.
Statistics are captured by setting the
statistics_level dynamic initialization parameter to TRUE
(default) or ALL. Although a small section of the SGA is allocated
to capture this information, there is no significant impact on
database performance.
Three new dynamic performance views are
introduced in Oracle 9i Release 2:
-
v$segstat_name – lists the segment
statistics collected
-
v$segstat – real time monitoring view
of segment-level statistics
-
v$segment_statistics – contains all of
the information in v$segstat plus segment owner, tablespace
name, etc.
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
|
|
