| |
 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 3 - Review Meetings
Preparation for
Production Turnover
-
SQL Loader control cards
-
Backup and recovery
-
Oracle security authorization
-
DBA forms and turnover procedures
-
Contact information and escalation procedures
-
Post production monitoring tools to be used
Post Production Turnover
This final set of meetings is held after the
production turnover is complete. Application logic errors and
performance problem resolution are the prime topics of discussion.
A comparison of the actual performance to the anticipated
performance of the application is also discussed. The review and
correction process, by its nature, is iterative. The problems are
identified, a plan of attack to solve them is agreed upon and
additional meetings are scheduled to review the results. As
additional problems are identified, they are added to the list of
problems to be solved. This iterative process continues until all
major performance issues and application logic errors are
addressed. The post production turnover meetings should include
discussions on:
-
Review performance statistics collected (Oracle
Enterprise Manager, SQL Trace, explain plan, BSTAT /ESTAT, autotrace, Oracle traces, V$ tables and Statspack)
-
Assess SQL coding techniques by reviewing
explain plan output for transactions experiencing performance
problems
-
Index usage
-
Local/join predicates
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
|
|
