 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 8 -
Miscellaneous Oracle Information
Monitor By Day So You
Don’t Get Called at Night
The following information from the Oracle V$ performance tables and
data dictionary tables provides a good foundation for daily
proactive monitoring:
-
Datafile freespace.
-
Segments having extent sizes that are
greater than 20.
-
Segments that are 20 extents from reaching
their maxextent size.
-
Disk free space. A neat trick is to run
SQL*Plus on the database server to create the reports and use the
HOST command to issue the operating system command that returns disk
space information. This will include the disk space information in
the SQL*Plus output.
-
Views and stored procedures that have a status
of ‘INVALID’ in dba_objects.
-
Data buffer hit ratios.
-
Shared pool reload statistics.
-
Log buffer flushes.
-
Datafile I/O.
-
Sorts to memory vs. sorts to disk.
-
Rollback/Undo performance indicators.
-
High resource consuming SQL statements.
Once you find the scripts that collect the
aforementioned information, review them to see if they satisfy your
needs, test and then implement them.
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
|
|
