Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Home
Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients

 

Free Oracle Tips


 
HTML Text AOL

Free Oracle App Server Tips


 
HTML Text

Oracle support

Oracle training

Oracle tuning

Rednecks!

Remote Oracle

Custom Oracle Training

 

   
  Oracle Tips by Burleson

OCP Instructors Guide for Oracle DBA Certification

Chapter 8 - Miscellaneous Oracle Information

The Foot Rule of Thumb

Create your own test instance and experiment. One of Oracleís great benefits is that it runs virtually anywhere. Create your own test environment. If you arenít sure how something works and the manuals arenít explicit enough, build a test case and execute it. I use my Oracle9i environment on a daily basis to teach others and continue my own database education.

Monitor By Day So You Donít Get Called at Night

Experienced database administrators are able to identify and prevent potential problems before they occur. Daily monitoring scripts that provide information on datafile freespace, extent growth, and disk space utilization help to reduce the number of night time calls.

Daily monitoring of performance statistics allows the DBA to tune proactively instead of reactively. Reviewing these reports daily will reduce the number of performance surprises that occur. The Internet is an endless source of tuning and monitoring scripts. Third-party books are also good sources. Find an author you like (my favorites are Burleson and anyone from TUSC) and implement the scripts they recommend. Tune and tweak them until the fit your own unique requirements.  My own library is a hodge-podge of scripts from various authors.

Run the reports using SQL*Plus as the reporting tool. Donít underestimate the reporting capabilities that SQL*Plus provides. SQL*Plus reports can include report breaks, page breaks, sum commands, min commands, max commands, averages, total lines, subtotal lines, headers, footers, custom column headings and data manipulations. Do not underestimate the power that this tool provides. The SQL*Plus manual contain dozens of formatting and data manipulation commands to help you create custom reports.
 


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

 
 
 

Oracle performance tuning book

 

 

Oracle performance tuning software

 
Oracle performance tuning software
 
Oracle performance Tuning 10g reference poster
 
Oracle training in Linux commands
 
Oracle training Excel
 
 
 
 

 

email BC:


Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracleģ is the registered trademark of Oracle Corporation.