 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 7 - Tuning and Performance
STATSPACK
Like utlbstat.sql and utlestat.sql,
STATSPACK can be found in the ORACLE_HOME/rdbms/admin/ directory on
UNIX and in the ORACLE_HOME/rdbms81/admin directory on Windows
servers.
V$ TABLES vs. Oracle
BSTAT/ESTAT and STATSPACK
Remember that many V$ tables are cumulative in
nature. They track information since the database has been started.
The information collected by BSTAT/ESTAT and STATSPACK are "snapshots" of information captured during the tool’s
execution. If you are interested in seeing how the database is
performing during a specific time-period, don’t use the V$ tables
since they are cumulative. Pick the time period that you want to run
statistics and run STATSPACK instead.
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
|
|
