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


Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 

HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

 

 

   
  Oracle Tips by Burleson

Analyze Runs

The analyze runs were scripted and the logs captured. Unfortunately the log from the SSD run was overwritten by a subsequent log and was lost. However, the elapsed time was calculated for both the SCSI and ATA runs. The SCSI analyze run completed in 126.76 seconds. The ATA analyze run required 149.12 seconds to complete.

The percentage difference between these two runs is 15% with the SCSI analyze requiring only 85% of the time required by the ATA architecture to complete the analysis of all schema tables and indexes. The logs from the SCSI and ATA runs are shown in below.

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Jun 2 12:29:34 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected to:

Oracle Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

TO_CHAR(SYSDATE,'D
------------------
02-jun-04 12:29.34

PL/SQL procedure successfully completed.

TO_CHAR(SYSDATE,'D
------------------
02-jun-04 14:36.10

Disconnected from Oracle Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Jun 29 13:27:03 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected to:

Oracle Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

TO_CHAR(SYSDATE,'D                                                     
------------------                                                              29-jun-04 13:27.03                                                             

PL/SQL procedure successfully completed.

TO_CHAR(SYSDATE,'D                                                              ------------------                                                              29-jun-04 15:56.15                                           

Disconnected from Oracle Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

With the completion of analyze, the database is ready to be tested.


The above book excerpt is from:

Oracle Solid State Disk Tuning

High Performance Oracle tuning with RAM disk

ISBN 0-9744486-5-6  

Donald K. Burleson & Mike Ault

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

  
 

Oracle performance tuning software 
 
 
 
 

Oracle performance tuning book

 

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

 

   

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

Oracle® is the registered trademark of Oracle Corporation. 

Hit Counter