||Oracle Tips by Burleson
Chapter 8 -
Miscellaneous Oracle Information
OCP Instructors Guide for
Oracle DBA Certification
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
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.
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
by Christopher T. Foot
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA