Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

 

   
 

ss

Oracle Tips by Burleson 

Baselines

A baseline is simply a snapshot at a point in time.  Database information can be compared against a baseline to determine if things have gotten better, worse, or stayed the same.  Baselines can be created with the dbms_workload_repository.create_baseline procedure.  Some DBAs might currently be experiencing DBA nirvana where all of the users are happy and engaged in DBA worship.  First, these DBAs should enjoy it while it lasts.  Secondly, these DBAs should create a baseline so when the users start throwing stones, data will be available for comparing the new performance metrics to the ones when things were good.  With any luck, those DBAs will find the cause of the problem and be quickly back on the road to happiness.  

For everyone but that lucky DBA, a baseline should be taken as soon as the system is stable.  For a typical Online Transaction Processing (OLTP) system, this stable time may fall on Monday at mid-day since users in earlier time zones have been at work for several hours and users in later time zones have not yet taken lunch.  On Mondays, many workloads will have a weekend backlog which means that the load will be somewhat higher than that for the rest of the week.  After analyzing this report and making changes which have been properly vetted through the TEST and DEVELOPMENT environments, an additional baseline can be taken at the same time on another Monday and a statistical analysis performed to determine what has changed, whether it is a good change and if the change is what had been expected.

After taking a baseline of a two-hour window of work from one day and another from the next day, the dba_hist_baseline will look something like Figure 9.6.  Notice that the baseline names in this example are simply the date of the baseline in yyyy-mm-dd order.  This makes sorting very easy using only the baseline_name field.  However, baseline name is merely a text field and a baseline called “fred and ginger dance partners” could just as easily be created.


The above book excerpt is from:

Oracle Wait Event Tuning

High Performance with Wait Event Iinterface Analysis 

ISBN 0-9745993-7-9  

Stephen Andert 

http://www.rampant-books.com/book_2004_2_wait_tuning.htm

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster



Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks