report

STATSPACK report for Database DB Id Instance Inst Num Startup Time Release RAC ~~~~~~~~ ----------- ------------ -------- --------------- ----------- --- 1390615422 orcl 1 05-11月-14 12:2 11.2.0.1.0 NO 0 Host Name Platform CPUs Cores Sockets Memory (G) ~~~~ ---------------- ---------------------- ----- ----- ------- ------------ Z Microsoft Windows x86 4 2 1 3.9 Snapshot Snap Id Snap Time Sessions Curs/Sess Comment ~~~~~~~~ ---------- ------------------ -------- --------- ------------------ Begin Snap: 1 05-11月-14 17:36:38 29 4.4 End Snap: 2 05-11月-14 17:36:42 29 4.4 Elapsed: 0.07 (mins) Av Act Sess: 0.3 DB time: 0.02 (mins) DB CPU: 0.02 (mins) Cache Sizes Begin End ~~~~~~~~~~~ ---------- ---------- Buffer Cache: 656M Std Block Size: 8K Shared Pool: 256M Log Buffer: 6,624K Load Profile Per Second Per Transaction Per Exec Per Call ~~~~~~~~~~~~ ------------------ ----------------- ----------- ----------- DB time(s): 0.3 1.4 0.00 0.06 DB CPU(s): 0.3 1.1 0.00 0.05 Redo size: 412,751.0 1,651,004.0 Logical reads: 2,227.0 8,908.0 Block changes: 1,178.5 4,714.0 Physical reads: 0.0 0.0 Physical writes: 0.0 0.0 User calls: 5.3 21.0 Parses: 178.3 713.0 Hard parses: 21.5 86.0 W/A MB processed: 6.9 27.5 Logons: 0.0 0.0 Executes: 338.5 1,354.0 Rollbacks: 0.0 0.0 Transactions: 0.3 Instance Efficiency Indicators ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 100.00 Redo NoWait %: 100.00 Buffer Hit %: 100.00 Optimal W/A Exec %: 100.00 Library Hit %: 91.72 Soft Parse %: 87.94 Execute to Parse %: 47.34 Latch Hit %: 100.00 Parse CPU to Parse Elapsd %: 62.50 % Non-Parse CPU: 94.38 Shared Pool Statistics Begin End ------ --- --- Memory Usage %: 77.73 77.78 % SQL with executions>1: 72.56 75.11 % Memory for SQL w/exec>1: 84.83 88.53 Top 5 Timed Events Avg %Total ~~~~~~~~~~~~~~~~~~ wait Ca

ll Event Waits Time (s) (ms) Time ----------------------------------------- ------------ ----------- ------ ------ CPU time 1 91.2 control file sequential read 307 0 0 8.1 log file parallel write 2 0 2 .4 log file sync 1 0 2 .2 SQL*Net break/reset to client 2 0 0 .0 ------------------------------------------------------------- Host CPU (CPUs: 4 Cores: 2 Sockets: 1) ~~~~~~~~ Load Average Begin End User System Idle WIO WCPU ------- ------- ------- ------- ------- ------- -------- 5.63 2.52 91.93 Note: There is a 25% discrepancy between the OS Stat total CPU time and the total CPU time estimated by Statspack OS Stat CPU time: 12(s) (BUSY_TIME + IDLE_TIME) Statspack CPU time: 16(s) (Elapsed time * num CPUs in end snap) Instance CPU ~~~~~~~~~~~~ % Time (seconds) -------- -------------- Host: Total time (s): 11.9 Host: Busy CPU time (s): 1.0 % of time Host is Busy: 8.1 Instance: Total CPU time (s): 1.0 % of Busy CPU used for Instance: 109.0 Instance: Total Database time (s): 1.4 %DB time waiting for CPU (Resource Mgr): 0.0 Virtual Memory Paging ~~~~~~~~~~~~~~~~~~~~~ KB paged out per sec: ############## KB paged in per sec: ############## Memory Statistics Begin End ~~~~~~~~~~~~~~~~~ ------------ ------------ Host Mem (MB): 3,994.4 3,994.4 SGA use (MB): 1,592.8 1,592.8 PGA use (MB): 96.6 94.9 % Host Mem used for SGA+PGA: 42.3 42.3 ------------------------------------------------------------- Time Model System Stats DB/Inst: ORCL/orcl Snaps: 1-2 -> Ordered by % of DB time desc, Statistic name Statistic Time (s) % DB time ----------------------------------- -------------------- --------- sql execute elapsed time 1.3 99.6 DB CPU 1.0 77.7 parse time elapsed 0.2 13.0 hard parse elapsed time 0.2 11.2 PL/SQL execution elapsed time 0.0 .2 repeated

bind elapsed time 0.0 .0 DB time 1.3 background elapsed time 0.0 ------------------------------------------------------------- Foreground Wait Events DB/Inst: ORCL/orcl Snaps: 1-2 -> Only events with Total Wait Time (s) >= .001 are shown -> ordered by Total Wait Time desc, Waits desc (idle events last) Avg %Total %Tim Total Wait wait Waits Call Event Waits out Time (s) (ms) /txn Time ---------------------------- ------------ ---- ---------- ------ -------- ------ control file sequential read 306 0 0 0 306.0 7.9 log file sync 1 0 0 2 1.0 .2 SQL*Net message from client 14 0 33 2385 14.0 wait for unread message on b 3 100 3 1000 3.0 ------------------------------------------------------------- Background Wait Events DB/Inst: ORCL/orcl Snaps: 1-2 -> Only events with Total Wait Time (s) >= .001 are shown -> ordered by Total Wait Time desc, Waits desc (idle events last) Avg %Total %Tim Total Wait wait Waits Call Event Waits out Time (s) (ms) /txn Time ---------------------------- ------------ ---- ---------- ------ -------- ------ log file parallel write 2 0 0 2 2.0 .4 control file sequential read 1 0 0 1 1.0 .1 rdbms ipc message 14 86 29 2090 14.0 DIAG idle wait 7 100 7 1000 7.0 Space Manager: slave idle wa 1 100 5 5000 1.0 pmon timer 1 100 3 3000 1.0 ------------------------------------------------------------- Wait Events (fg and bg) DB/Inst: ORCL/orcl Snaps: 1-2 -> s - second, cs - centisecond, ms - millisecond, us - microsecond -> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0 -> Only events with Total Wait Time (s) >= .001 are shown -> ordered by Total Wait Time desc, Waits desc (idle events last) Avg %Total %Tim Total Wait wait Waits Call Event Waits out Time (s) (ms) /txn Time ---------------------------- ------------ ---- ---------- ------ -------- ------ control file sequential read 307 0 0 0 307.0 8.1 log file parallel write 2 0

0 2 2.0 .4 log file sync 1 0 0 2 1.0 .2 SQL*Net message from client 14 0 33 2385 14.0 rdbms ipc message 14 86 29 2090 14.0 DIAG idle wait 7 100 7 1000 7.0 Space Manager: slave idle wa 1 100 5 5000 1.0 pmon timer 1 100 3 3000 1.0 wait for unread message on b 3 100 3 1000 3.0 ------------------------------------------------------------- Wait Event Histogram DB/Inst: ORCL/orcl Snaps: 1-2 -> Total Waits - units: K is 1000, M is 1000000, G is 1000000000 -> % of Waits - column heading: <=1s is truly <1024ms, >1s is truly >=1024ms -> % of Waits - value: .0 indicates value was <.05%, null is truly 0 -> Ordered by Event (idle events last) Total ----------------- % of Waits ------------------ Event Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s -------------------------- ----- ----- ----- ----- ----- ----- ----- ----- ----- SQL*Net break/reset to cli 2 100.0 asynch descriptor resize 53 100.0 control file parallel writ 1 100.0 control file sequential re 307 99.7 .3 log file parallel write 2 100.0 log file sync 1 100.0 DIAG idle wait 7 100.0 SQL*Net message from clien 14 78.6 7.1 14.3 SQL*Net message to client 14 100.0 Space Manager: slave idle 1 100.0 pmon timer 1 100.0 rdbms ipc message 15 40.0 60.0 wait for unread message on 3 100.0 ------------------------------------------------------------- SQL ordered by CPU DB/Inst: ORCL/orcl Snaps: 1-2 -> Total DB CPU (s): 1 -> Captured SQL accounts for 100.0% of Total DB CPU -> SQL reported below exceeded 1.0% of Total DB CPU CPU CPU per Elapsd Old Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value ---------- ------------ ---------- ------ ---------- --------------- ---------- 1.05 1 1.05 100.0 1.35 12,963 2522684317 Module: SQL*Plus BEGIN statspack.snap; END; ------------------------------------------------------------- SQL ordered by E lapsed time for DB: ORCL Instance: orcl Snaps: 1 -2 -> Total DB Time (s): 1 -> Captured SQL accounts for 100.1% of Total DB Time -> SQL reported below exceeded 1.0% of Total DB Time Elapsed Elap per CPU Old Ti

me (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value ---------- ------------ ---------- ------ ---------- --------------- ---------- 1.35 1 1.35 99.9 1.05 3 2522684317 Module: SQL*Plus BEGIN statspack.snap; END; ------------------------------------------------------------- SQL ordered by Gets DB/Inst: ORCL/orcl Snaps: 1-2 -> End Buffer Gets Threshold: 10000 Total Buffer Gets: 8,908 -> Captured SQL accounts for 1.8% of Total Buffer Gets -> SQL reported below exceeded 1.0% of Total Buffer Gets CPU Elapsd Old Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value --------------- ------------ -------------- ------ -------- --------- ---------- 12,963 1 12,963.0 145.5 1.05 1.35 2522684317 Module: SQL*Plus BEGIN statspack.snap; END; ------------------------------------------------------------- Instance Activity Stats DB/Inst: ORCL/orcl Snaps: 1-2 Statistic Total per Second per Trans --------------------------------- ------------------ -------------- ------------ Batched IO (full) vector count 0 0.0 0.0 Batched IO block miss count 0 0.0 0.0 Batched IO double miss count 0 0.0 0.0 Batched IO same unit count 0 0.0 0.0 Batched IO single block count 0 0.0 0.0 Batched IO vector block count 0 0.0 0.0 Batched IO vector read count 0 0.0 0.0 Block Cleanout Optim referenced 0 0.0 0.0 CCursor + sql area evicted 8 2.0 8.0 CPU used by this session 89 22.3 89.0 CPU used when call started 105 26.3 105.0 CR blocks created 2 0.5 2.0 DB time 3,136 784.0 3,136.0 DBWR checkpoint buffers written 0 0.0 0.0 DBWR checkpoints 0 0.0 0.0 DBWR transaction table writes 0 0.0 0.0 DBWR undo block writes 0 0.0 0.0 HSC Compressed Segment Block Chan 0 0.0 0.0 HSC Heap Segment Block Changes 339 84.8 339.0 HSC OLTP Compressed Blocks 0 0.0 0.0 HSC OLTP Non Compressible Blocks 0 0.0 0.0