| |
 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 8 -
Miscellaneous Oracle Information
Conclusion
-
If you don’t want to get called at night, you must monitor by day.
-
Track free space and performance statistics
daily to trend space utilization and database performance.
-
Unless you have a lot of free time, don’t code
scripts. Scour the web and third-party books and modify them to fit
your particular needs.
-
Foreign keys that do not have indexes are
common causes of Oracle performance and locking problems. It is
highly recommended that indexes be created on all foreign keys that
reference rows in parent tables that have the possibility of being
accessed by update and delete statements.
-
Oracle describes the new Oracle9i Flashback
feature as the “Oracle Time Machine”. It may not be a time machine,
but it does allow data to be viewed in the past and it is easy to
use.
-
Use CONSISTENT=Y to maintain a consistent view
of the database when executing full database Exports,
-
Use COMMIT=Y on Imports to reduce the chances
of experiencing rollback/undo segment problems when importing large
tables.
The database administrator, because of his
“general technical expert” title, is often asked to assist in the
evaluation of third-party toolsets and applications. The next
chapter discusses evaluating third party products.
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
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
