STATSPACK report for
DB Name DB IdInstance Inst Num Release Cluster Host
------------ ----------- ------------ -------- ----------- ------- ------------
GSMSFC1484011727 GSMSFC
1 9.2.0.4.0 NOlocalhost
Snap Id Snap TimeSessions Curs/Sess Comment
------- ------------------ -------- --------- -------------------
Begin Snap: 1 06-Apr-07 13:45:43 2913.6
End Snap: 2 06-Apr-07 13:46:07 2913.9
Elapsed:
0.40 (mins)
Cache Sizes (end)
~~~~~~~~~~~~~~~~~
Buffer Cache: 1,200MStd Block Size: 8K
Shared Pool Size: 304M
Log Buffer: 2,048K
Load Profile
~~~~~~~~~~~~
Per Second Per Transaction
--------------- ---------------
Redo size:
59,151.50
37,358.84
Logical reads:
9,754.17
6,160.53
Block changes:
105.33
66.53
Physical reads:
203.08
128.26
Physical writes:
203.46
128.50
User calls:
2.79
1.76
Parses:
4.08
2.58
Hard parses:
0.83
0.53
Sorts:
3.63
2.29
Logons:
0.00
0.00
Executes:
18.88
11.92
Transactions:
1.58
% Blocks changed per Read:1.08Recursive Call %:93.14
Rollback per transaction %:0.00 Rows per Sort:1077.08
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %:100.00 Redo NoWait %:100.00
BufferHit %:100.00In-memory Sort %: 97.70
Library Hit %: 92.09Soft Parse %: 79.59
Execute to Parse %: 78.37 Latch Hit %:100.00
Parse CPU to Parse Elapsd %:
% Non-Parse CPU:
Shared Pool StatisticsBegin End
------------
Memory Usage %: 92.59 92.59
% SQL with executions>1: 15.14 15.28
% Memory for SQL w/exec>1: 16.03 16.38
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~
% Total
Event
WaitsTime (s) Ela Time
-------------------------------------------- ------------ ----------- --------
log file sync
17 091.55
control file parallel write
8 0 6.56
control file sequential read
58 0.81
direct path read
93 0.52
log file parallel write
39 0.49
-------------------------------------------------------------
Wait Events for DB: GSMSFCInstance: GSMSFCSnaps: 1 -2
-> s- second
-> cs - centisecond - 100th of a second
-> ms - millisecond -1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait waitWaits
Event
Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
log file sync
17
0
040.4
control file parallel write
8
0
010.2
control file sequential read 58
0
001.5
direct path read
93
0
002.4
log file parallel write
39 39
001.0
direct path write
8
0
000.2
db file parallel write
4
0
000.1
SQL*Net message from client
34
0131 38500.9
wakeup time manager
1
1 30300010.0
SQL*Net message to client
34
0
000.9
-------------------------------------------------------------
Background Wait Events for DB: GSMSFCInstance: GSMSFCSnaps: 1 -2
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait waitWaits
Event
Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
control file parallel write
8
0
010.2
log file parallel write
39 39
001.0
control file sequential read
4
0
000.1
db file parallel write
4
0
000.1
rdbms ipc message
132 93 675093.5
pmon timer
8
8 23 29300.2
-------------------------------------------------------------
SQL ordered by Gets for DB: GSMSFCInstance: GSMSFCSnaps: 1 -2
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL includes the resources used by
all SQL statements called within the PL/SQL code.As individual SQL
statements are also reported, it is possible and valid for the summed
total % to exceed 100 |
