Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 









Oracle Database Tips by Donald Burleson


Finding the Baselines

A critical point is Oracle databases are always changing, and the database that was examined at 10:00 AM may be completely different than the database examined at 3:00 PM.  Does this mean that a broad brush application of SSD is not valid?

When the performance of Oracle disk I/O is examined over time periods, regular signatures appear when the I/O information is aggregated by hours-of-the-day and day-of-the-week as shown in Figure 1.9. 

Most Oracle professionals use Oracle9i STATSPACK or Oracle10g AWR information to gather these baselines.  Once the repeating I/O trends have been identified, it will be possible to apply a broad brush to the use of SSD, placing the fast I/O devices where they will do the most good.

I/O information can be captured at the file level, and this can give insights into the best data files to place on super fast SSD.  The following script extracts the physical read information from the Oracle 10g dba_hist_filestatxsview:

break on begin_interval_time skip 2 

column phyrds  format 999,999,999
column begin_interval_time format a25 

  natural join

The result below shows a running total of physical reads by datafile.  The snapshots are collected every half-hour.  Starting from this script, a where clause criteria could easily be added resulting in a unique time-series exception report.

SQL> @reads 

BEGIN_INTERVAL_TIME       FILENAME                                 PHYRDS
------------------------- --------------------------------------- -------  
24-FEB-04 PM E:\ORACLE\ORA92\FSDEV10G\SYSTEM01.DBF   164,700
                          E:\ORACLE\ORA92\FSDEV10G\UNDOTBS01.DBF   26,082
                          E:\ORACLE\ORA92\FSDEV10G\SYSAUX01.DBF   472,008
                          E:\ORACLE\ORA92\FSDEV10G\USERS01.DBF      1,794                           E:\ORACLE\ORA92\FSDEV10G\T_FS_LSQ.ORA     2,123                                                                                                                                          

24-FEB-04 PM E:\ORACLE\ORA92\FSDEV10G\SYSTEM01.DBF   167,809                           E:\ORACLE\ORA92\FSDEV10G\UNDOTBS01.DBF   26,248                           E:\ORACLE\ORA92\FSDEV10G\SYSAUX01.DBF   476,616                           E:\ORACLE\ORA92\FSDEV10G\USERS01.DBF      1,795                           E:\ORACLE\ORA92\FSDEV10G\T_FS_LSQ.ORA     2,244


25-FEB-04 AM E:\ORACLE\ORA92\FSDEV10G\SYSTEM01.DBF   169,940                           E:\ORACLE\ORA92\FSDEV10G\UNDOTBS01.DBF   26,946                           E:\ORACLE\ORA92\FSDEV10G\SYSAUX01.DBF   483,550                           E:\ORACLE\ORA92\FSDEV10G\USERS01.DBF      1,799                           E:\ORACLE\ORA92\FSDEV10G\T_FS_LSQ.ORA     2,248

Of course, a little tweaking to the script could result in a report on physical writes, read time, write time, single block reads, and a host of other interesting metrics from the dba_hist_filestatxs view.

See code depot for complete scripts

This is an excerpt from the book Oracle RAC & Tuning with Solid State Disk.  You can get it for more than 30% by buying it directly from the publisher and get immediate access to working code examples.

Oracle RAC & Tuning with Solid State Disk
Expert Secrets for High Performance Clustered Grid Computing

Includes Oracle10g!
Get immediate access to working code examples

Buy it now for 30% off - Only $9.95

HTML-DB support:

For HTML-DB development support just call to get an Oracle Certified professional for all HTML-DB development projects.



Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.