 |
|
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
|
