 |
|
Oracle Tips by Burleson |
Time Model Statistics Report
The next report section is new in the 10g AWRRPTand not
available in STATSPACK. It is the Time Model Statisticsreport, and it breaks down exactly how the system spent the timeframe
for the report. The following listing shows an example from the test
runs:
Time Model
Statistics DB/Inst: SSD/ssd2 Snaps: 3-4
-> ordered by
Time (seconds) desc
Time %
Total
Statistic
Name (seconds) DB Time
--------------------------------------------- --------------
-----------
DB
time 592.04 100.00
sql execute
elapsed time 586.23 99.02
DB
CPU 203.60 34.39
background
elapsed time 45.51 7.69
background cpu
time 22.46 3.79
PL/SQL execution
elapsed time 1.63 .28
connection
management call elapsed time 1.30 .22
parse time
elapsed .58 .10
sequence load
elapsed time .02 .00
hard parse
(sharing criteria) elapsed time .00 .00
hard parse (bind
mismatch) elapsed time .00 .00
hard parse
elapsed time .00 .00
Java execution
elapsed time .00 .00
failed parse
elapsed time .00 .00
PL/SQL
compilation elapsed time .00 .00
inbound PL/SQL
rpc elapsed time .00 .00
failed parse
(out of shared memory) elapsed t .00 .00
-------------------------------------------------------------
Operating System
Statistics DB/Inst: SSD/ssd2 Snaps: 3-4
Statistic
Name Value
----------------------------------- ------------------
AVG_BUSY_TICKS
11,641
AVG_IDLE_TICKS
349,688
AVG_IN_BYTES
851,628,032
AVG_NICE_TICKS
0
AVG_OUT_BYTES
1,107,304,448
AVG_SYS_TICKS
2,335
AVG_USER_TICKS
9,306
BUSY_TICKS
23,282
IDLE_TICKS
699,377
IN_BYTES
1,703,256,064
NICE_TICKS
0
OUT_BYTES
2,214,608,896
RSRC_MGR_CPU_WAIT_TIME 0
SYS_TICKS
4,670
USER_TICKS
18,612
-------------------------------------------------------------
Between the supplied Oracle internal statistics
and the system time ticks values, one can quickly determine how the
system spent its time for the report interval. In the example report,
the time was spent running SQL. This example was for a 2-CPU system,
so the total time calculates out to 200% rather than 100%.
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
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
