kvamdb1$cat awrdiff_1_19654_1_19655.html Workload Repository Compare Period Report

WORKLOAD REPOSITORY COMPARE PERIOD REPORT

Snapshot SetDB NameDB IdInstanceInst numReleaseClusterHost
First (1st)VAM2306309266vam1110.2.0.4.0YESkvamdb1
Second (2nd)VAM2306309266vam1110.2.0.4.0YESkvamdb1

Snapshot SetBegin Snap IdBegin Snap TimeEnd Snap IdEnd Snap TimeElapsed Time (min)DB Time (min)Avg Active Users
1st1965409-Feb-12 00:00:141965509-Feb-12 01:00:43 60.49 1,667.27 27.56
2nd1965509-Feb-12 01:00:431965609-Feb-12 02:00:04 59.35 267.22 4.42

Configuration Comparison

1st2nd%Diff
Buffer Cache: 5,248M 5,248M 0.00
Std Block Size: 8K 8K 0.00
Shared Pool Size: 1,664M 1,664M 0.00
Log Buffer: 14,376K 14,376K 0.00
SGA Target: 8,389M 8,389M 0.00
PGA Aggregate Target: 1,707M 1,707M 0.00
Undo Management:AUTOAUTO 

Load Profile

1st Per Sec2nd Per Sec%Diff1st Per Txn2nd Per Txn%Diff
Redo size: 836,605.78 909,237.73 8.68 10,014.94 13,585.18 35.65
Logical reads: 337,920.82 318,581.86 -5.72 4,045.22 4,760.02 17.67
Block changes: 3,547.34 3,806.42 7.30 42.46 42.46 0.00
Physical reads: 3,425.33 36.27 -98.94 41.00 0.54 -98.68
Physical writes: 146.71 165.64 12.90 1.76 2.47 40.34
User calls: 2,428.29 2,178.03 -10.31 29.07 32.54 11.94
Parses: 343.16 286.16 -16.61 4.11 4.28 4.14
Hard parses: 7.34 6.65 -9.40 0.09 0.10 11.11
Sorts: 40.88 41.23 0.86 0.49 0.62 26.53
Logons: 0.92 0.91 -1.09 0.01 0.01 0.00
Executes: 397.16 337.13 -15.11 4.75 5.04 6.11
Transactions: 83.54 66.93 -19.88   
1st2ndDiff
% Blocks changed per Read: 1.05 1.19 0.15
Recursive Call %: 21.48 21.21 -0.27
Rollback per transaction %: 0.03 0.03 0.00
Rows per Sort: 12.39 11.64 -0.75
Avg Length of Calls (sec): 0.01 0.01 0.00

Top 5 Timed Events

1st2nd
EventWaitsTime(s)Percent Total DB TimeWait ClassEventWaitsTime(s)Percent Total DB TimeWait Class
CPU time  84,712.1 84.68  CPU time  14,719.9 91.81 
Backup: sbtwrite2 369,587 7,112.3 7.11Administrativ Backup: sbtwrite2 349,815 6,651.1 41.48Administrativ
Backup: sbtbackup 6 2,284.5 2.28Administrativ Backup: sbtbackup 3 3,002.2 18.73Administrativ
db file sequential read 413,705 1,032.5 1.03User I/O db file sequential read 121,626 682.3 4.26User I/O
*SQL*Net more data from client 489,091 588.8 .59Network*SQL*Net more data to client 9,893,020 281.5 1.76Network
-SQL*Net more data to client 10,857,486 324.8 .32Network-SQL*Net more data from client 525,991 62.5 .39Network

Events with a "*" did not make the top 5 in the other snapshot set.

Events with a "-" did make the top 5 in the other snapshot set.

RAC Statistics

BeginEnd
1st Number of Instances: 2 2
2nd Number of Instances: 2 2

Global Cache Load Profile

1st Per Second2nd Per Second%Diff1st Per Txn2nd Per Txn%Diff
Global Cache blocks received: 73.30 90.67 23.70 0.88 1.35 53.41
Global Cache blocks served: 248.87 317.36 27.52 2.98 4.74 59.06
GCS/GES messages received: 2,661.09 966.24 -63.69 31.86 14.44 -54.68
GCS/GES messages sent: 1,452.19 436.25 -69.96 17.38 6.52 -62.49
DBWR Fusion writes: 22.32 32.21 44.31 0.27 0.48 77.78

Global Cache Efficiency Percentages (Target local+remote 100%)

FirstSecondDiff
Buffer access - local cache %: 99.12 99.96 0.84
Buffer access - remote cache %: 0.02 0.03 0.01
Buffer access - disk %: 0.86 0.01 -0.85

Global Cache and Enqueue Services - Workload Characteristics

FirstSecond%Diff
Avg global enqueue get time (ms): 0.01 0.01 0.00
Avg global cache cr block receive time (ms): 0.68 0.68 0.00
Avg global cache current block receive time (ms): 0.70 0.68 -2.86
Avg global cache cr block build time (ms): 0.01 0.01 0.00
Avg global cache cr block send time (ms): 0.10 0.10 0.00
Avg global cache cr block flush time (ms): 6.48 14.41 122.38
Avg global cache current block pin time (ms): 0.02 0.02 0.00
Avg global cache current block send time (ms): 0.10 0.09 -10.00
Avg global cache current block flush time (ms): 1.04 1.07 2.88

FirstSecondDiff
Global cache log flushes for cr blocks served %: 1.27 1.03 -0.24
Global cache log flushes for current blocks served %: 0.04 0.05 0.01

Global Cache and Enqueue Services - Messaging Statistics

FirstSecond%Diff
Avg message sent queue time (ms): 0.06 0.03 -50.00
Avg message sent queue time on ksxp (ms): 0.38 0.35 -7.89
Avg message received queue time (ms): 0.02 0.02 0.00
Avg GCS message process time (ms): 0.03 0.06 100.00
Avg GES message process time (ms): 0.03 0.03 0.00

FirstSecondDiff
% of direct sent messages: 50.69 32.50 -18.19
% of indirect sent messages: 47.11 66.46 19.34
% of flow controlled messages: 2.20 1.05 -1.15

Report Details

More Diff-Diff RAC Statistics


Back to Top

Wait Events

 % DB Time # Waits/sec (Elapsed Time) Avg Wait Time (ms)
Event1st2ndDiff1st2nd%Diff1st2nd%Diff
Backup: sbtwrite2 7.11 41.48 34.37 101.84 98.24 -3.53 19.24 19.01 -1.20
Backup: sbtbackup 2.28 18.73 16.44 0.00 0.00 0.00 380,749.01 1,000,730.31 162.83
db file sequential read 1.03 4.26 3.22 113.99 34.16 -70.03 2.50 5.61 124.40
SQL*Net more data to client 0.32 1.76 1.43 2,991.74 2,778.26 -7.14 0.03 0.03 0.00
log file sync 0.20 1.19 0.99 83.68 67.07 -19.85 0.67 0.80 19.40
gc current block 2-way 0.14 1.06 0.92 64.81 83.14 28.28 0.58 0.57 -1.72
log file parallel write 0.14 0.74 0.60 93.34 74.52 -20.16 0.42 0.45 7.14
SQL*Net break/reset to client 0.09 0.37 0.29 45.46 33.74 -25.78 0.52 0.50 -3.85
reliable message 0.05 0.32 0.27 0.10 0.09 -10.00 136.42 169.87 24.52
db file parallel write 0.04 0.29 0.25 45.88 50.28 9.59 0.25 0.26 4.00
log file sequential read 0.04 0.24 0.20 0.89 0.96 7.87 11.46 11.13 -2.88
SQL*Net more data from client 0.59 0.39 -0.20 134.77 147.71 9.60 1.20 0.12 -90.00
gc current grant 2-way 0.02 0.13 0.10 15.32 13.47 -12.08 0.43 0.43 0.00
db file scattered read 0.10 0.00 -0.10 15.13 0.02 -99.87 1.81 3.42 88.95
Backup: sbtclose2 0.12 0.21 0.09 0.00 0.00 0.00 15,302.61 17,132.62 11.96
gc cr block 2-way 0.02 0.09 0.07 7.61 6.62 -13.01 0.60 0.60 0.00
gc current grant busy 0.01 0.08 0.07 4.43 4.77 7.67 0.73 0.76 4.11
library cache lock 0.01 0.06 0.05 6.73 5.80 -13.82 0.47 0.47 0.00
control file sequential read 0.01 0.06 0.05 9.97 7.77 -22.07 0.41 0.35 -14.63
gc current block busy 0.01 0.05 0.04 0.10 0.18 80.00 15.28 11.91 -22.05
gc buffer busy 0.01 0.04 0.04 0.23 0.23 0.00 8.19 8.65 5.62
SQL*Net message to client 0.01 0.04 0.04 2,151.08 1,950.65 -9.32 0.00 0.00 0.00
row cache lock 0.02 0.05 0.03 6.75 5.56 -17.63 0.78 0.43 -44.87
Streams AQ: qmn coordinator waiting for slave to start 0.00 0.03 0.03 0.00 0.00 0.00 4,891.02 4,889.94 -0.02
enq: WF - contention 0.00 0.02 0.02 0.00 0.01 100.00 131.54 196.93 49.71
CGS wait for IPC msg 0.00 0.03 0.02 140.55 136.57 -2.83 0.01 0.01 0.00
enq: FB - contention 0.00 0.02 0.02 1.21 1.31 8.26 0.61 0.66 8.20
enq: TC - contention 0.00 0.02 0.02 0.00 0.00 0.00 297.34 464.04 56.06
enq: TX - index contention 0.00 0.02 0.01 0.07 0.06 -14.29 10.31 13.30 29.00
gc cr block busy 0.00 0.01 0.01 0.46 0.49 6.52 1.19 1.30 9.24
cursor: pin S wait on X 0.00 0.01 0.01 0.04 0.04 0.00 13.21 15.15 14.69
control file parallel write 0.00 0.01 0.01 0.94 0.77 -18.09 0.64 0.65 1.56
gcs log flush sync 0.00 0.01 0.01 0.60 0.54 -10.00 0.53 0.83 56.60
name-service call wait 0.00 0.01 0.01 0.00 0.01 100.00 57.96 55.94 -3.49
Backup: sbtinfo2 0.01 0.02 0.01 0.00 0.00 0.00 1,218.10 1,241.77 1.94
Log archive I/O 0.00 0.01 0.00 0.85 0.93 9.41 0.27 0.26 -3.70
latch free 0.00 0.01 0.00 0.18 0.14 -22.22 1.56 1.84 17.95
gc current multi block request 0.00 0.01 0.00 1.83 2.18 19.13 0.10 0.11 10.00
os thread startup 0.00 0.00 0.00 0.00 0.00 0.00 84.66 49.86 -41.11
DFS lock handle 0.00 0.01 0.00 0.57 0.49 -14.04 0.59 0.47 -20.34
direct path read 0.01 0.01 -0.00 36.49 4.38 -88.00 0.08 0.07 -12.50
enq: TM - contention 0.00 0.00 0.00 0.33 0.33 0.00 0.47 0.53 12.77
log file switch completion 0.00 0.00 0.00 0.01 0.01 0.00 15.29 12.17 -20.41
latch: cache buffers chains 0.00 0.00 0.00 3.19 3.45 8.15 0.04 0.04 0.00
ksxr poll remote instances 0.00 0.00 0.00 12.31 10.26 -16.65 0.01 0.01 0.00
gc cr disk read 0.00 0.00 0.00 0.31 0.26 -16.13 0.59 0.54 -8.47
enq: HW - contention 0.00 0.00 0.00 0.16 0.19 18.75 0.65 0.62 -4.62
enq: KO - fast object checkpoint 0.00 0.00 -0.00 0.01 0.05 400.00 82.79 0.42 -99.49
rdbms ipc reply 0.00 0.00 0.00 0.34 0.27 -20.59 0.41 0.44 7.32
gc cr multi block request 0.00 0.00 0.00 0.30 0.23 -23.33 0.35 0.37 5.71
enq: TT - contention 0.00 0.00 0.00 0.19 0.13 -31.58 0.63 0.64 1.59
ges inquiry response 0.00 0.00 0.00 0.00 0.08 100.00 0.74 0.76 2.70
library cache pin 0.00 0.00 0.00 0.21 0.16 -23.81 0.47 0.47 0.00
RMAN backup & recovery I/O 0.00 0.00 0.00 0.09 0.03 -66.67 7.08 5.98 -15.54
enq: RO - fast object reuse 0.00 0.00 0.00 0.01 0.11 1,000.00 1.18 0.42 -64.41
kksfbc child completion 0.00 0.00 0.00 0.00 0.00 0.00 51.63 55.80 8.08
enq: CF - contention 0.00 0.00 0.00 0.05 0.06 20.00 0.89 0.79 -11.24
latch: shared pool 0.00 0.00 0.00 0.01 0.02 100.00 0.72 2.08 188.89
IPC send completion sync 0.00 0.00 0.00 0.08 0.08 0.00 0.44 0.47 6.82
LGWR wait for redo copy 0.00 0.00 0.00 1.14 1.00 -12.28 0.03 0.03 0.00
gc cr grant 2-way 0.00 0.00 0.00 0.24 0.08 -66.67 0.45 0.41 -8.89
enq: PS - contention 0.00 0.00 0.00 0.05 0.03 -40.00 0.57 0.59 3.51
global enqueue expand wait 0.00 0.00 0.00 0.00 0.00 0.00 14.15 11.91 -15.83
local write wait 0.00 0.00 0.00 0.02 0.01 -50.00 1.27 1.45 14.17
direct path write 0.00 0.00 0.00 0.62 0.72 16.13 0.02 0.02 0.00
gc current retry 0.00 0.00 -0.00 0.00 0.00 0.00 58.31 0.00 -100.00
PX Deq Credit: send blkd 0.00 0.00 0.00 0.05 0.04 -20.00 0.31 0.36 16.13
buffer busy waits 0.00 0.00 0.00 0.24 0.17 -29.17 0.10 0.08 -20.00
read by other session 0.00 0.00 0.00 0.01 0.00 -100.00 2.77 5.34 92.78
PX Deq: reap credit 0.00 0.00 0.00 3.38 1.23 -63.61 0.01 0.01 0.00
enq: JQ - contention 0.00 0.00 0.00 0.00 0.01 100.00 0.73 0.74 1.37
log file single write 0.00 0.00 0.00 0.02 0.02 0.00 0.25 0.33 32.00
enq: SQ - contention 0.00 0.00 0.00 0.00 0.00 0.00 1.47 2.34 59.18
KJC: Wait for msg sends to complete 0.00 0.00 0.00 0.07 0.05 -28.57 0.05 0.11 120.00
enq: TA - contention 0.00 0.00 0.00 0.01 0.01 0.00 0.79 0.79 0.00
db file parallel read 0.00 0.00 -0.00 0.00 0.00 0.00 32.08 0.48 -98.50
library cache load lock 0.00 0.00 0.00 0.00 0.00 0.00 3.52 2.26 -35.80
gc current split 0.00 0.00 -0.00 0.01 0.01 0.00 7.56 0.79 -89.55
enq: WL - contention 0.00 0.00 0.00 0.00 0.00 0.00 0.67 0.77 14.93
enq: US - contention 0.00 0.00 0.00 0.00 0.00 0.00 0.69 0.75 8.70
enq: TX - allocate ITL entry 0.00 0.00 0.00 0.00 0.00 0.00 0.66 0.68 3.03
latch: KCL gc element parent latch 0.00 0.00 0.00 0.03 0.03 0.00 0.06 0.05 -16.67
enq: TX - contention 0.00 0.00 0.00 0.00 0.00 0.00 1.98 4.11 107.58
latch: object queue header operation 0.00 0.00 0.00 0.01 0.01 0.00 0.08 0.09 12.50
buffer deadlock 0.00 0.00 0.00 0.04 0.04 0.00 0.02 0.02 0.00
enq: PI - contention 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.46 100.00
enq: TX - row lock contention 0.00 0.00 -0.00 0.00 0.00 0.00 2.78 0.63 -77.34
PX Deq: Signal ACK 0.00 0.00 0.00 0.02 0.01 -50.00 0.13 0.14 7.69
enq: RS - prevent file delete 0.00 0.00 0.00 0.03 0.00 -100.00 0.74 0.78 5.41
enq: BR - file shrink 0.00 0.00 0.00 0.00 0.00 0.00 0.63 0.69 9.52
latch: cache buffers lru chain 0.00 0.00 0.00 0.00 0.00 0.00 0.07 0.23 228.57
db file single write 0.00 0.00 0.00 0.00 0.00 0.00 0.57 0.33 -42.11
latch: session allocation 0.00 0.00 -0.00 0.00 0.00 0.00 3.13 0.77 -75.40
gc cr failure 0.00 0.00 0.00 0.00 0.00 0.00 0.82 0.66 -19.51
enq: AF - task serialization 0.00 0.00 0.00 0.00 0.00 0.00 0.89 0.48 -46.07
undo segment extension 0.00 0.00 -0.00 0.27 0.02 -92.59 0.00 0.00 0.00
latch: library cache 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.26 100.00
latch: row cache objects 0.00 0.00 0.00 0.00 0.00 0.00 0.87 0.51 -41.38
enq: CT - state 0.00 0.00 0.00 0.00 0.00 0.00 0.51 0.30 -41.18
latch: enqueue hash chains 0.00 0.00 0.00 0.00 0.00 0.00 0.05 0.08 60.00
gc object scan 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.03 100.00
ges2 LMON to wake up LMD - mrcvr 0.00 0.00 -0.00 0.00 0.00 0.00 0.04 0.00 -100.00
latch: messages 0.00 0.00 -0.00 0.00 0.00 0.00 0.19 0.00 -100.00
cursor: mutex X 0.00 0.00 0.00 0.00 0.00 0.00 0.03 0.01 -66.67
latch: redo allocation 0.00 0.00 -0.00 0.00 0.00 0.00 0.06 0.00 -100.00
cursor: pin S 0.00 0.00 -0.00 0.00 0.00 0.00 0.01 0.00 -100.00
latch: gcs resource hash 0.00 0.00 0.00 0.00 0.00 0.00 0.14 0.09 -35.71
latch: redo writing 0.00 0.00 -0.00 0.00 0.00 0.00 0.07 0.00 -100.00
lock escalate retry 0.00 0.00 -0.00 0.00 0.00 0.00 0.01 0.00 -100.00
cr request retry 0.00 0.00 0.00 0.00 0.00 0.00 0.02 0.01 -50.00
latch: ges resource hash list 0.00 0.00 -0.00 0.00 0.00 0.00 0.00 0.00 0.00
SQL*Net message from client 3,043.97 20,426.35 17,382.38 2,150.99 1,950.67 -9.31 390.08 471.48 20.87
jobq slave wait 15.51 107.90 92.38 1.76 2.00 13.64 2,426.71 2,428.95 0.09
gcs remote message 13.76 84.61 70.85 541.20 499.02 -7.79 7.01 7.63 8.84
PX Idle Wait 5.09 32.67 27.58 0.59 0.61 3.39 2,398.47 2,400.65 0.09
Streams AQ: qmn slave idle wait 3.63 22.02 18.38 0.04 0.04 0.00 26,925.22 26,342.05 -2.17
Streams AQ: waiting for time management or cleanup tasks 3.39 21.77 18.38 0.00 0.00 0.00 282,565.80 317,314.18 12.30
ASM background timer 3.55 21.65 18.10 0.68 0.39 -42.65 1,436.69 2,472.68 72.11
Streams AQ: waiting for messages in the queue 3.54 21.63 18.10 0.10 0.10 0.00 9,439.35 9,451.07 0.12
DIAG idle wait 3.55 21.63 18.08 4.76 4.73 -0.63 205.74 205.76 0.01
Streams AQ: qmn coordinator idle wait 3.53 21.61 18.07 0.07 0.07 0.00 13,543.57 13,426.19 -0.87
ges remote message 3.54 21.57 18.03 38.68 36.77 -4.94 25.22 26.41 4.72
class slave wait 3.45 20.64 17.19 0.27 0.10 -62.96 3,512.88 9,562.89 172.22
PX Deq: Execute Reply 0.41 0.00 -0.41 1.46 0.01 -99.32 76.59 0.19 -99.75
PX Deq: Table Q Normal 0.15 0.00 -0.15 0.03 0.00 -100.00 1,603.62 0.00 -100.00
KSV master wait 0.01 0.03 0.01 0.27 0.10 -62.96 12.38 11.32 -8.56
PX Deq: Execution Msg 0.00 0.01 0.01 0.28 0.18 -35.71 1.55 1.69 9.03
PX Deq: Parse Reply 0.00 0.00 -0.00 0.02 0.01 -50.00 9.58 2.35 -75.47
PX Deq: Msg Fragment 0.00 0.00 0.00 0.06 0.07 16.67 0.18 0.19 5.56
PX Deq: Join ACK 0.00 0.00 0.00 0.03 0.01 -66.67 0.80 0.83 3.75
Streams AQ: RAC qmn coordinator idle wait 0.00 0.00 0.00 0.07 0.07 0.00 0.01 0.01 0.00
PX Deq Credit: need buffer 0.00 0.00 -0.00 0.01 0.00 -100.00 0.23 0.00 -100.00


Back to Top

Time Model Statistics

 % DB Time Time (seconds) Time per Trans (seconds)
Statistic Name1st2ndDiff1st2nd1st2nd%Diff
DB time 100.00 100.00 0.00 100,035.96 16,033.01 0.33 0.07 -78.79
DB CPU 84.68 91.81 7.13 84,712.06 14,719.88 0.28 0.06 -78.57
sql execute elapsed time 99.42 96.98 -2.43 99,453.02 15,549.22 0.33 0.07 -78.79
RMAN cpu time (backup/restore) 0.28 1.63 1.34 284.04 260.92 0.00 0.00 0.00
parse time elapsed 0.15 0.75 0.60 154.10 120.19 0.00 0.00 0.00
hard parse elapsed time 0.08 0.40 0.32 83.07 64.59 0.00 0.00 0.00
connection management call elapsed time 0.01 0.09 0.07 14.55 13.78 0.00 0.00 0.00
PL/SQL execution elapsed time 0.01 0.03 0.02 7.88 5.24 0.00 0.00 0.00
sequence load elapsed time 0.00 0.02 0.01 3.71 2.44 0.00 0.00 0.00
hard parse (sharing criteria) elapsed time 0.01 0.01 0.01 6.15 1.84 0.00 0.00 0.00
PL/SQL compilation elapsed time 0.00 0.00 0.00 0.15 0.25 0.00 0.00 0.00
hard parse (bind mismatch) elapsed time 0.00 0.00 0.00 0.30 0.17 0.00 0.00 0.00
repeated bind elapsed time 0.00 0.00 0.00 0.10 0.09 0.00 0.00 0.00
Java execution elapsed time 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
failed parse (out of shared memory) elapsed t 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
failed parse elapsed time 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
inbound PL/SQL rpc elapsed time 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
background elapsed time 10.73 74.76 64.03 10,737.31 11,986.34 0.04 0.05 25.00
background cpu time 1.03 5.24 4.22 1,025.42 840.66 0.00 0.00 0.00


Back to Top

Operating System Statistics

 Value per Second (DB Time) per Second (Elapsed Time) per Trans
Statistic Name1st2nd1st2nd%Diff1st2nd%Diff1st2nd%Diff
AVG_BUSY_TIME 132,787 114,605 1 7 437.59 37 32 -12.05 0 0 9.09
AVG_IDLE_TIME 230,822 240,423 2 15 549.35 64 68 6.16 1 1 32.89
AVG_IOWAIT_TIME 0 0 0 0 0.00 0 0 0.00 0 0 0.00
AVG_SYS_TIME 18,253 16,293 0 1 466.67 5 5 -8.95 0 0 16.67
AVG_USER_TIME 114,423 98,201 1 6 436.84 32 28 -12.53 0 0 7.89
BUSY_TIME 2,126,441 1,835,421 21 114 438.48 586 515 -12.03 7 8 9.84
IDLE_TIME 3,695,034 3,848,493 37 240 549.81 1,018 1,081 6.15 12 16 32.49
IOWAIT_TIME 0 0 0 0 0.00 0 0 0.00 0 0 0.00
LOAD -1 0 -0 0 0.00 -0 0 0.00 -0 0 0.00
OS_CPU_WAIT_TIME 11,600 11,900 0 1 516.67 3 3 4.38 0 0 25.00
PHYSICAL_MEMORY_BYTES 0 0 0 0 0.00 0 0 0.00 0 0 0.00
RSRC_MGR_CPU_WAIT_TIME 0 0 0 0 0.00 0 0 0.00 0 0 0.00
SYS_TIME 293,918 262,392 3 16 456.80 81 74 -9.01 1 1 13.40
USER_TIME 1,832,523 1,573,029 18 98 435.53 505 442 -12.52 6 7 9.27
VM_IN_BYTES 3,407,872 24,936,448 34 1,555 4,465.07 939 7,003 645.76 11 105 830.87
VM_OUT_BYTES 118,472,704 36,937,728 1,184 2,304 94.53 32,645 10,373 -68.22 391 155 -60.34


Back to Top

Service Statistics

Back to Top

Service Statistics

 % DB Time % CPU Time % Physical Reads % Logical Reads
Service Name1st2ndDiff1st2ndDiff1st2ndDiff1st2ndDiff
SYS$USERS 83.86 4.40 -79.46 82.38 4.67 -77.70 98.84 1.30 -97.54 7.86 0.82 -7.05
vam 16.14 95.60 79.46 17.62 95.32 77.70 1.07 88.96 87.89 92.12 99.17 7.05
SYS$BACKGROUND 0.00 0.00 0.00 0.00 0.00 0.00 0.08 9.85 9.77 0.02 0.01 -0.00

Back to Service Statistics
Back to Top

Service Statistics (RAC)

 % CR Blks Received % Current Blks Received
Service Name1st2ndDiff1st2ndDiff
vam 90.76 89.17 -1.59 11.69 9.90 -1.78
SYS$USERS 9.90 8.16 -1.74 1.28 0.91 -0.37
SYS$BACKGROUND 1.95 2.33 0.38 0.25 0.26 0.01

Back to Service Statistics
Back to Top

SQL Statistics

Back to Top

Top 10 SQL Comparison by Execution Time

 Exec Time % of DB Time Exec Time (ms) / Exec #Exec/sec (DB Time) CPU Time (ms) / Exec Physical Reads / Exec #Rows Processed / Exec   
SQL Id1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2ndMultiple PlansSQL Text
c4s83719x437j 8.20 49.17 40.98 195,203 187,709 0.00 0.00 196,077 188,802 0.02 0.00 29.00 28.10 No select rc.Id as city_id, rn.p...
anwkyts985z77 1.51 9.22 7.71 15 15 0.97 6.19 13 13 0.00 0.00 0.00 0.00 No delete from fsti_alarm_trans w...
gdd5s7nqgssu9 1.50 9.18 7.68 15 15 0.97 6.19 13 13 0.00 0.00 0.02 0.02 No select addition_id from fsti_a...
4a6cx9kqm5r5h 1.65 8.89 7.25 8,364 8,010 0.00 0.01 8,366 8,011 0.00 0.01 303,895.03 306,634.88 No select Identifier, Node, NodeA...
6acqpn0qjrctq   7.01 7.01   2,312   0.03   778   219.80   3,876.71 No INSERT INTO PROD_FZ_WAP_WAP20T...
1dg7znt919y4p 0.43 2.65 2.22 6,530 6,444 0.00 0.00 6,530 6,444 0.00 0.00 0.00 0.00 No Select c.Id As cityid, c.cname...
g269uhxq6ubty 0.32 1.93 1.61 4,278 4,240 0.00 0.00 4,278 4,240 0.00 0.00 0.00 0.00 No Select c.Id As cityid, c.cname...
3rn43k5skpggf 0.14 0.87 0.72 2,043 2,041 0.00 0.00 2,043 2,040 0.00 0.00 7.00 7.00 No SELECT * FROM ( SELE...
9u68cq2puf064 0.11 0.67 0.56 1,625 1,590 0.00 0.00 1,625 1,590 0.00 0.00 1.00 1.00 No Select Count(1) From Res_Servi...
3vzt7yt9tja88 0.13 0.69 0.56 1,765 1,698 0.00 0.00 1,765 1,698 0.00 0.00 7.00 7.00 No SELECT * FROM ( SELE...
5spcdusnvyta6 0.12 0.63 0.51 1,605 1,525 0.00 0.00 1,605 1,525 0.00 0.00 1.00 0.98 No Select Count(1) From Res_Servi...

Back to SQL Statistics
Back to Top

Top 10 SQL Comparison by CPU Time

 CPU Time % of DB Time CPU Time (ms) / Exec #Exec/sec (DB Time) Exec Time (ms) / Exec Physical Reads / Exec #Rows Processed / Exec   
SQL Id1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2ndMultiple PlansSQL Text
c4s83719x437j 8.23 49.46 41.23 196,077 188,802 0.00 0.00 195,203 187,709 0.02 0.00 29.00 28.10 No select rc.Id as city_id, rn.p...
4a6cx9kqm5r5h 1.65 8.89 7.25 8,366 8,011 0.00 0.01 8,364 8,010 0.00 0.01 303,895.03 306,634.88 No select Identifier, Node, NodeA...
anwkyts985z77 1.29 7.79 6.50 13 13 0.97 6.19 15 15 0.00 0.00 0.00 0.00 No delete from fsti_alarm_trans w...
gdd5s7nqgssu9 1.28 7.78 6.50 13 13 0.97 6.19 15 15 0.00 0.00 0.02 0.02 No select addition_id from fsti_a...
6acqpn0qjrctq   2.36 2.36   778   0.03   2,312   219.80   3,876.71 No INSERT INTO PROD_FZ_WAP_WAP20T...
1dg7znt919y4p 0.43 2.65 2.22 6,530 6,444 0.00 0.00 6,530 6,444 0.00 0.00 0.00 0.00 No Select c.Id As cityid, c.cname...
g269uhxq6ubty 0.32 1.93 1.61 4,278 4,240 0.00 0.00 4,278 4,240 0.00 0.00 0.00 0.00 No Select c.Id As cityid, c.cname...
3rn43k5skpggf 0.14 0.87 0.72 2,043 2,040 0.00 0.00 2,043 2,041 0.00 0.00 7.00 7.00 No SELECT * FROM ( SELE...
9u68cq2puf064 0.11 0.67 0.56 1,625 1,590 0.00 0.00 1,625 1,590 0.00 0.00 1.00 1.00 No Select Count(1) From Res_Servi...
3vzt7yt9tja88 0.13 0.69 0.56 1,765 1,698 0.00 0.00 1,765 1,698 0.00 0.00 7.00 7.00 No SELECT * FROM ( SELE...
5spcdusnvyta6 0.12 0.63 0.51 1,605 1,525 0.00 0.00 1,605 1,525 0.00 0.00 1.00 0.98 No Select Count(1) From Res_Servi...

Back to SQL Statistics
Back to Top

Top 10 SQL Comparison by Buffer Gets

 % Total Gets Gets / Exec #Executions Exec Time (ms) / Exec CPU Time (ms) / Exec Physical Reads / Exec #Rows Processed / Exec   
SQL Id1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2ndMultiple PlansSQL Text
c4s83719x437j 47.01 50.00 3.00 13,725,891.45 13,505,875.19 42 42 195,203 187,709 196,077 188,802 0.02 0.00 29.00 28.10 No select rc.Id as city_id, rn.p...
anwkyts985z77 18.03 19.84 1.81 2,269.00 2,269.00 97,457 99,186 15 15 13 13 0.00 0.00 0.00 0.00 No delete from fsti_alarm_trans w...
gdd5s7nqgssu9 18.03 19.84 1.81 2,269.00 2,268.98 97,457 99,186 15 15 13 13 0.00 0.00 0.02 0.02 No select addition_id from fsti_a...
6acqpn0qjrctq   1.42 1.42   33,044.45   486   2,312   778   219.80   3,876.71 No INSERT INTO PROD_FZ_WAP_WAP20T...
4a6cx9kqm5r5h 2.21 2.15 -0.05 137,393.72 137,319.68 197 178 8,364 8,010 8,366 8,011 0.00 0.01 303,895.03 306,634.88 No select Identifier, Node, NodeA...
g269uhxq6ubty 0.54 0.59 0.05 89,848.65 92,370.03 74 73 4,278 4,240 4,278 4,240 0.00 0.00 0.00 0.00 No Select c.Id As cityid, c.cname...
1dg7znt919y4p 0.51 0.55 0.04 93,845.30 93,885.08 66 66 6,530 6,444 6,530 6,444 0.00 0.00 0.00 0.00 No Select c.Id As cityid, c.cname...
3rn43k5skpggf 0.53 0.56 0.03 93,929.81 93,977.51 69 68 2,043 2,041 2,043 2,040 0.00 0.00 7.00 7.00 No SELECT * FROM ( SELE...
3vzt7yt9tja88 0.55 0.52 -0.03 91,184.20 91,183.49 74 65 1,765 1,698 1,765 1,698 0.00 0.00 7.00 7.00 No SELECT * FROM ( SELE...
5spcdusnvyta6 0.55 0.52 -0.03 91,053.03 89,695.94 74 66 1,605 1,525 1,605 1,525 0.00 0.00 1.00 0.98 No Select Count(1) From Res_Servi...
9u68cq2puf064 0.54 0.56 0.03 93,817.41 93,839.71 70 68 1,625 1,590 1,625 1,590 0.00 0.00 1.00 1.00 No Select Count(1) From Res_Servi...

Back to SQL Statistics
Back to Top

Top 10 SQL Comparison by Physical Reads

 % Total Physical Reads Physical Reads / Exec #Executions Exec Time (ms) / Exec CPU Time (ms) / Exec #Rows Processed / Exec   
SQL Id1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2ndMultiple PlansSQL Text
6acqpn0qjrctq   82.70 82.70   219.80   486   2,312   778   3,876.71 No INSERT INTO PROD_FZ_WAP_WAP20T...
6bbzx8bac652f 0.00 0.37 0.36 118.00 118.00 1 4 1,649 1,196 666 518 22.00 22.00 No SELECT t.*, rownum from (SELEC...
8cx33vubmug6b 0.00 0.20 0.20 0.14 0.14 1,979 1,829 22 22 20 20 1.00 1.00 No insert into FSTI_ALARM_HISTORY...
5j90cjhgfvsj8 0.00 0.05 0.05 0.25 0.23 307 296 32 27 27 24 0.95 0.97 No insert into FSTI_ALARM_HISTORY...
gt22pnh04wan8 0.00 0.04 0.04 0.05 0.04 1,322 1,281 25 23 23 21 1.00 1.00 No UPDATE FSTI_ALARM_CURRENT SET ...
1qvjz6ud03wfm   0.02 0.02   0.04   798   14   1   1.00 No insert into prod_res_ne_detect...
43xtg2pbayp29 0.00 0.02 0.02 11.50 6.00 2 4 11,869 11,493 11,847 11,493 1.00 1.00 No DECLARE job BINARY_INTEGER := ...
dxy8awsx01f1x 0.00 0.01 0.01 0.00 0.00 13,918 11,452 1 1 1 1 0.99 0.99 No update PERF_HOST_STORAGE_DAY_M...
gaskb581vzwb1 0.00 0.01 0.01 0.00 0.00 13,735 10,075 1 1 1 1 0.98 1.00 No update PERF_HOST_STORAGE_HOUR_...
98vhmww9mb31y 0.00 0.00 0.00 0.00 0.00 13,781 10,057 1 1 1 1 0.98 1.00 No update PERF_HOST_STORAGE_HOUR_...
f54tpujxcbnc7 0.00 0.00 0.00 0.00 0.00 13,924 11,450 1 1 1 1 0.99 0.99 No update PERF_HOST_STORAGE_DAY_A...
9yuu4zjfdunym 0.00 0.00 0.00 0.01 0.00 5,171 3,883 1 1 1 1 1.00 1.00 No update PERF_INTERFACE_DAY_MIN ...
43gjvgxaba0uf 0.00   -0.00 0.01   5,117   1   1   0.99   No update PERF_INTERFACE_HOUR_MIN...

Back to SQL Statistics
Back to Top

Top 10 SQL Comparison by Executions

 #Executions/sec (DB Time) #Executions Exec Time (ms) / Exec CPU Time (ms) / Exec Physical Reads / Exec #Rows Processed / Exec   
SQL Id1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2ndMultiple PlansSQL Text
2aadvhw5r7gfc 1.91 8.79 6.88 190,969 140,928 0 0 0 0 0.00 0.00 1.86 1.86 No select name, ip from CONF_APP_...
3tjv3vcff9nj1 1.87 8.48 6.61 187,088 136,038 0 0 0 0 0.00 0.00 1.00 1.00 No select net_area_id from CONF_A...
anwkyts985z77 0.97 6.19 5.21 97,457 99,186 15 15 13 13 0.00 0.00 0.00 0.00 No delete from fsti_alarm_trans w...
gdd5s7nqgssu9 0.97 6.19 5.21 97,457 99,186 15 15 13 13 0.00 0.00 0.02 0.02 No select addition_id from fsti_a...
2jfqzrxhrm93b 0.45 1.94 1.49 45,332 31,082 0 0 0 0 0.00 0.00 0.99 0.99 No select /*+ rule */ c.name, u....
8r32rk7uxxkdb 0.20 1.35 1.15 20,126 21,660 0 0 0 0 0.00 0.00 0.05 0.05 No select app_type from res_appli...
a0u5858g45m8n 0.18 1.06 0.88 17,940 17,020 0 0 0 0 0.00 0.00 1.00 1.00 No select count(1) from dual wher...
cgrsx2689bca4   0.75 0.75   12,029   0   0   0.00   1.00 No select count(1) from dual wher...
d2qfc3zqhckw7 0.15 0.70 0.56 14,647 11,266 0 0 0 0 0.00 0.00 1.00 1.00 No select PERF_HOST_STORAGE_SEQ.n...
dn76n760vxs8b 0.42 0.75 0.33 42,000 12,000 2 2 2 2 0.00 0.00 0.01 0.00 No Insert Into Prod_Fz_Qyzj_Rtp_S...

Back to SQL Statistics
Back to Top

Top 10 SQL Comparison by Parse Calls

 % Total Parses Parses #Executions   
SQL Id1st2ndDiff1st2nd1st2ndMultiple PlansSQL Text
dn76n760vxs8b 3.37 1.18 -2.19 42,000 12,000 42,000 12,000 No Insert Into Prod_Fz_Qyzj_Rtp_S...
gdd5s7nqgssu9 7.83 9.73 1.91 97,457 99,186 97,457 99,186 No select addition_id from fsti_a...
anwkyts985z77 7.83 9.73 1.91 97,457 99,185 97,457 99,186 No delete from fsti_alarm_trans w...
3tjv3vcff9nj1 15.00 13.33 -1.67 186,860 135,836 187,088 136,038 No select net_area_id from CONF_A...
2aadvhw5r7gfc 15.34 13.83 -1.51 191,000 140,925 190,969 140,928 No select name, ip from CONF_APP_...
2jfqzrxhrm93b 3.64 3.05 -0.59 45,332 31,082 45,332 31,082 No select /*+ rule */ c.name, u....
8r32rk7uxxkdb 1.62 2.13 0.51 20,126 21,658 20,126 21,660 No select app_type from res_appli...
d2qfc3zqhckw7 1.18 1.11 -0.07 14,646 11,262 14,647 11,266 No select PERF_HOST_STORAGE_SEQ.n...
dxy8awsx01f1x 1.12 1.12 0.01 13,915 11,454 13,918 11,452 No update PERF_HOST_STORAGE_DAY_M...
f54tpujxcbnc7 1.12 1.12 0.01 13,923 11,447 13,924 11,450 No update PERF_HOST_STORAGE_DAY_A...
gqrmhgpq33afw 1.12 1.12 0.00 13,953 11,444 13,957 11,444 No update PERF_HOST_STORAGE_DAY_M...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
1dg7znt919y4pSelect c.Id As cityid, c.cname, p.Id As platformid, n.Id As neid, n.ne_name, p.remark, t.* From res_service_ne_v n, RES_PLATFORM p, FSTI_ALARM_CURRENT t, RES_CITY c, CONF_ALERT_GROUP cp, CONF_ALERT_KEY ck, res_ne_card card, Sec_User_Ne_View sv where n.platform_id=p.id and card.neid(+) = n.ID and n.loopback_ip=t.node and p.city_id=c.Id and t.acknowledged != 1 and Sv.User_Id =327 and n.Id = Sv.Ne_Id and t.clearedtime = to_date('4001-1-1', 'yyyy-mm-dd') and t.alertgroup = cp.id(+) and t.alertkey = ck.key_id(+) and t.sound LIKE '%fjlincm%' and ((remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ')and group_name not in('²É¼¯¸æ¾¯', 'ÐÔÄÜÊý¾ÝÍêÕûÐԸ澯', 'ÒµÎñÊý¾ÝÍêÕûÐԸ澯', 'ÍøÔªÁ¬Í¨ÐԸ澯', '´úÀí¶ËÍøÔªÁ¬Í¨ÐԸ澯') and severity > 4 and remark1 is null ) or (remark not in('ÔöÖµÍø¹Ü') and group_name in ('ÒµÎñÓ¦Óø澯') and severity > 4) or (remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ') and group_name in('É豸ÐÔÄܸ澯') and severity > 4 and Tally > 3) )
1qvjz6ud03wfminsert into prod_res_ne_detect_log(id, neid, dest_ip, is_succ) values(prod_res_ne_detect_log_seq.nextval, :1, :2, :3)
2aadvhw5r7gfcselect name, ip from CONF_APP_SERVER_CLUSTER where net_area_id=:1 and last_activate_time>sysdate-:2 order by id
2jfqzrxhrm93bselect /*+ rule */ c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
3rn43k5skpggfSELECT * FROM ( SELECT A.*, rownum r FROM (Select cp.group_name, ck.key_name, ck.descs, c.Id As Cityid, c.Cname, p.Id As Platformid, n.Id As Neid, nvl(card.machine_name, n.Ne_Name) as ne_name, p.Platform, To_Char(t.Firstoccurrence, 'yyyy-mm-dd hh24:mi:ss') As First_Time, To_Char(t.Lastoccurrence, 'yyyy-mm-dd hh24:mi:ss') As Last_Time, t.* From Res_Service_Ne_v n, Res_Platform p, Fsti_Alarm_Current t, Res_City c, CONF_ALERT_GROUP cp, sec_user_ne_view sv, CONF_ALERT_KEY ck, res_ne_card card Where n.Platform_Id = p.Id and card.neid(+) = n.ID And n.Loopback_Ip = t.Node And p.City_Id = c.Id and n.id = sv.ne_id and sv.user_id =327 And t.Clearedtime = To_Date('4001-1-1', 'yyyy-mm-dd') and t.alertgroup = cp.id(+) and t.alertkey = ck.key_id(+) and ((remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ')and group_name not in('²É¼¯¸æ¾¯', 'ÐÔÄÜÊý¾ÝÍêÕûÐԸ澯', 'ÒµÎñÊý¾ÝÍêÕûÐԸ澯', 'ÍøÔªÁ¬Í¨ÐԸ澯', '´úÀí¶ËÍøÔªÁ¬Í¨ÐԸ澯') and severity > 4 and remark1 is null ) or (remark not in('ÔöÖµÍø¹Ü') and group_name in ('ÒµÎñÓ¦Óø澯') and severity > 4) or (remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ') and group_name in('É豸ÐÔÄܸ澯') and severity > 4 and Tally > 3) ) order by lastoccurrence desc ) A WHERE rownum <= 7 ) B WHERE r > 0
3tjv3vcff9nj1select net_area_id from CONF_APP_SERVER_CLUSTER where name=:1
3vzt7yt9tja88SELECT * FROM ( SELECT A.*, rownum r FROM (Select cp.group_name, ck.key_name, ck.descs, c.Id As Cityid, c.Cname, p.Id As Platformid, n.Id As Neid, nvl(card.machine_name, n.Ne_Name) as ne_name, p.Platform, To_Char(t.Firstoccurrence, 'yyyy-mm-dd hh24:mi:ss') As First_Time, To_Char(t.Lastoccurrence, 'yyyy-mm-dd hh24:mi:ss') As Last_Time, t.* From Res_Service_Ne_v n, Res_Platform p, Fsti_Alarm_Current t, Res_City c, CONF_ALERT_GROUP cp, sec_user_ne_view sv, CONF_ALERT_KEY ck, res_ne_card card Where n.Platform_Id = p.Id and card.neid(+) = n.ID And n.Loopback_Ip = t.Node And p.City_Id = c.Id and n.id = sv.ne_id and sv.user_id =672 And t.Clearedtime = To_Date('4001-1-1', 'yyyy-mm-dd') and t.alertgroup = cp.id(+) and t.alertkey = ck.key_id(+) and ((remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ')and group_name not in('²É¼¯¸æ¾¯', 'ÐÔÄÜÊý¾ÝÍêÕûÐԸ澯', 'ÒµÎñÊý¾ÝÍêÕûÐԸ澯', 'ÍøÔªÁ¬Í¨ÐԸ澯', '´úÀí¶ËÍøÔªÁ¬Í¨ÐԸ澯') and severity > 4 and remark1 is null ) or (remark not in('ÔöÖµÍø¹Ü') and group_name in ('ÒµÎñÓ¦Óø澯') and severity > 4) or (remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ') and group_name in('É豸ÐÔÄܸ澯') and severity > 4 and Tally > 3) ) order by lastoccurrence desc ) A WHERE rownum <= 7 ) B WHERE r > 0
43gjvgxaba0ufupdate PERF_INTERFACE_HOUR_MIN set resid=:1, in_octets_ratio=:2, in_discards_ratio=:3, in_errors_ratio=:4, out_octets_ratio=:5, out_discards_ratio=:6, out_errors_ratio=:7, admin_status_value=:8, oper_status_value=:9, update_time=:10 where ID=:11
43xtg2pbayp29DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN pack_sm_rep.prc_run_5_min; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
4a6cx9kqm5r5hselect Identifier, Node, NodeAlias, AlertGroup, AlertKey, Severity, OriginalSeverity, Summary, Location, Detail, FirstOccurrence, LastOccurrence, LastModified, Tally, Acknowledged, AcknowledgeTime, ClearedTime, Annotated, SmNotified, Remark1, Remark2, Remark3, Remark4, Remark5 from FSTI_ALARM_CURRENT where Clearedtime=to_date('4001-01-01', 'yyyy-mm-dd')
5j90cjhgfvsj8insert into FSTI_ALARM_HISTORY (ID, Identifier, Node, NodeAlias, AlertGroup, AlertKey, Severity, Summary, Detail, EventTime) values(FSTI_ALARM_HISTORY_ID_SEQ.NEXTVAL, :1, :2, :3, :4, :5, :6, :7, :8, :9)
5spcdusnvyta6Select Count(1) From Res_Service_Ne_v n, Res_Platform p, Fsti_Alarm_Current t, Res_City c, sec_user_ne_view sv, CONF_ALERT_GROUP cp, CONF_ALERT_KEY ck, res_ne_card card Where n.Platform_Id = p.Id and card.neid(+) = n.ID And n.Loopback_Ip = t.Node And p.City_Id = c.Id And t.Clearedtime = To_Date('4001-1-1', 'yyyy-mm-dd') and t.alertgroup = cp.id(+)and t.alertkey = ck.key_id(+) and n.id = sv.ne_id and sv.user_id =672 and ((remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ')and group_name not in('²É¼¯¸æ¾¯', 'ÐÔÄÜÊý¾ÝÍêÕûÐԸ澯', 'ÒµÎñÊý¾ÝÍêÕûÐԸ澯', 'ÍøÔªÁ¬Í¨ÐԸ澯', '´úÀí¶ËÍøÔªÁ¬Í¨ÐԸ澯') and severity > 4 and remark1 is null ) or (remark not in('ÔöÖµÍø¹Ü') and group_name in ('ÒµÎñÓ¦Óø澯') and severity > 4) or (remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ') and group_name in('É豸ÐÔÄܸ澯') and severity > 4 and Tally > 3) )
6acqpn0qjrctq INSERT INTO PROD_FZ_WAP_WAP20TRAFFIC (TIMESTAMP, CDRTYPE, WAPGWID, BEARERTYPE, MSISDN, SPID, SERVICEID, USERTYPE, DISCOUNT, SERVICEATTR, STARTTIME, STOPTIME, CONTENTLENGTH, REGIONCODE, ACCESSREGION, CHARGEMODE, INFOFEE, TRAFFICFEE, STATUSCODE, SPDOMAIN, URL, USERAGENT, CHARGEID, ACCTSESSIONID, APN, IMSIL, PDSNIP, QOS, USERNAME, MSIP, BEARPROTOCOLTYPE, TRANSACTIONID, UPLINKTRAFFIC, DOWNLINKTRAFFIC, DESCPORT, SERVICETYPENAME, NODCODE, HOSTIP, RPSTIME, TRANSMITREQUESTTIME, TRANSMITRESPONSETIME, WAPVISITED, NASIP, NASID, CONTENTTYPE, TERMINATEDREASON, DURATION, BILLTYPE, OPERTYPE, SENDRESULT, STATISTICCODE, SP_IP, SP_PORT, WAPGW_PORT, UPDATE_TIME) VALUES (CAST(TO_DATE(:TIMESTAMP, 'yyyymmddhh24miss') AS DATE), :CDRTYPE, :WAPGWID, :BEARERTYPE, :MSISDN, :SPID, :SERVICEID, :USERTYPE, :DISCOUNT, :SERVICEATTR, CAST(TO_DATE(:STARTTIME, 'yyyymmddhh24miss') AS DATE), CAST(TO_DATE(:STOPTIME, 'yyyymmddhh24miss') AS DATE), :CONTENTLENGTH, :REGIONCODE, :ACCESSREGION, :CHARGEMODE, :INFOFEE, :TRAFFICFEE, :STATUSCODE, :SPDOMAIN, :URL, :USERAGENT, :CHARGEID, :ACCTSESSIONID, :APN, :IMSIL, :PDSNIP, :QOS, :USERNAME, :MSIP, :BEARPROTOCOLTYPE, :TRANSACTIONID, :UPLINKTRAFFIC, :DOWNLINKTRAFFIC, :DESCPORT, :SERVICETYPENAME, :NODCODE, :HOSTIP, :RPSTIME, :TRANSMITREQUESTTIME, :TRANSMITRESPONSETIME, :WAPVISITED, :NASIP, :NASID, :CONTENTTYPE, :TERMINATEDREASON, :DURATION, :BILLTYPE, :OPERTYPE, :SENDRESULT, :STATISTICCODE, :SP_IP, :SP_PORT, :WAPGW_PORT, CAST(TO_DATE(:UPDATE_TIME, 'yyyymmddhh24miss') AS DATE))
6bbzx8bac652f SELECT t.*, rownum from (SELECT nvl((f.bytes)/1024/1024, 0) "remain_size", nvl((f.max_block)/1024/1024, 0) "max_free_block", d.status "status", d.tablespace_name "tablespace_name", d.contents "contents", d.extent_management "extent_management", TO_CHAR(NVL(a.bytes / 1024 / 1024, 0), '99999990.900') "space_size", TO_CHAR(NVL(a.bytes - NVL(f.bytes, 0), 0)/1024/1024, '99999999.999') "used_size", TO_CHAR(NVL(NVL(f.bytes, 0) / a.bytes * 100, 0), '990.00') "free_rate", d.logging "logging", (NVL(d.initial_extent, 0) / 1024) "init_extent", (NVL(d.next_extent, 0) / 1024) "next_extent", NVL(d.min_extents, 0) "min_extents", NVL(d.max_extents, 0) "max_extents", NVL(d.pct_increase, 0) "pct_increase", (NVL(d.min_extlen, 0) / 1024) "min_extlen" FROM sys.dba_tablespaces d, (select tablespace_name, sum(bytes) bytes from sys.dba_data_files group by tablespace_name) a, (select tablespace_name, sum(bytes) bytes, max(bytes) max_block from sys.dba_free_space group by tablespace_name) f WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = f.tablespace_name(+) AND NOT (d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY') UNION ALL SELECT nvl((a.bytes - NVL(t.bytes, 0))/1024/1024, 0) "remain_size", nvl((t.max_block)/1024/1024, 0) "max_free_block", d.status "status", d.tablespace_name "tablespace_name", d.contents "contents", d.extent_management "extent_management", TO_CHAR(NVL(a.bytes / 1024 / 1024, 0), '99999990.900') "space_size(M)", TO_CHAR(NVL (t.bytes, 0)/1024/1024, '99999999.999') "used_size(M)", TO_CHAR(NVL((a.bytes - NVL(t.bytes, 0)) / a.bytes * 100, 0), '990.00') "free_rate", d.logging "logging", (d.initial_extent / 1024) "initial_extent", (d.next_extent / 1024) "next_extent", d.min_extents "min_extents", d.max_extents "max_extents", d.pct_increase "pct_increase", (d.min_extlen / 1024) "min_extlen" FROM sys.dba_tablespaces d, (select tablespace_name, sum(bytes) bytes from sys.dba_temp_files group by tablespace_name) a, (select tablespace_name, sum(bytes_used) bytes, max(bytes_cached) max_block from sys.v_$temp_extent_pool group by tablespace_name) t WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = t.tablespace_name(+) AND d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY') t
8cx33vubmug6binsert into FSTI_ALARM_HISTORY (ID, Identifier, Node, NodeAlias, AlertGroup, AlertKey, Severity, Summary, Location, Detail, EventTime, object_id) values(FSTI_ALARM_HISTORY_ID_SEQ.NEXTVAL, :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11)
8r32rk7uxxkdbselect app_type from res_application where neid = :1 and ismonitor=1
98vhmww9mb31yupdate PERF_HOST_STORAGE_HOUR_MIN set resid=:1, used=:2, free=:3, used_percent=:4, update_time=:5 where ID=:6
9u68cq2puf064Select Count(1) From Res_Service_Ne_v n, Res_Platform p, Fsti_Alarm_Current t, Res_City c, sec_user_ne_view sv, CONF_ALERT_GROUP cp, CONF_ALERT_KEY ck, res_ne_card card Where n.Platform_Id = p.Id and card.neid(+) = n.ID And n.Loopback_Ip = t.Node And p.City_Id = c.Id And t.Clearedtime = To_Date('4001-1-1', 'yyyy-mm-dd') and t.alertgroup = cp.id(+)and t.alertkey = ck.key_id(+) and n.id = sv.ne_id and sv.user_id =327 and ((remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ')and group_name not in('²É¼¯¸æ¾¯', 'ÐÔÄÜÊý¾ÝÍêÕûÐԸ澯', 'ÒµÎñÊý¾ÝÍêÕûÐԸ澯', 'ÍøÔªÁ¬Í¨ÐԸ澯', '´úÀí¶ËÍøÔªÁ¬Í¨ÐԸ澯') and severity > 4 and remark1 is null ) or (remark not in('ÔöÖµÍø¹Ü') and group_name in ('ÒµÎñÓ¦Óø澯') and severity > 4) or (remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ') and group_name in('É豸ÐÔÄܸ澯') and severity > 4 and Tally > 3) )
9yuu4zjfdunymupdate PERF_INTERFACE_DAY_MIN set resid=:1, in_octets_ratio=:2, in_discards_ratio=:3, in_errors_ratio=:4, out_octets_ratio=:5, out_discards_ratio=:6, out_errors_ratio=:7, admin_status_value=:8, oper_status_value=:9, update_time=:10 where ID=:11
a0u5858g45m8nselect count(1) from dual where 1=1 AND 4 = 5
anwkyts985z77delete from fsti_alarm_trans where FIRSTOCCURRENCE<sysdate-1/24 and last_send_time is not null
c4s83719x437jselect rc.Id as city_id, rn.platform_id, rn.id as ne_id, osc.node, osc.severity, cic.id category_id, osc.detail from fsti_alarm_current osc, conf_indicator_category cic, conf_alert_key key, res_ne rn, res_platform rp, res_city rc where exists (select ne_id from sec_user_ne_view nv where nv.User_Id = 589 and nv.NE_ID = rn.id) and osc.clearedtime = to_date('4001-1-1', 'yyyy-mm-dd') and lower(key.key_name) = lower(cic.name) and osc.alertkey = key.key_id and rn.loopback_ip = osc.node and rn.platform_id = rp.id and rp.city_id = rc.Id
cgrsx2689bca4select count(1) from dual where 1=1 AND 5 = 5
d2qfc3zqhckw7select PERF_HOST_STORAGE_SEQ.nextval from dual
dn76n760vxs8bInsert Into Prod_Fz_Qyzj_Rtp_Status(Id, Dsp_Id, Element_Id, Date_Type, Update_Time, Input_Enable, Output_Enable, Audio_Ip, Audio_Port, Audio_Tx_Mt, Audio_Tx_Pt, Audio_Rx_Mt, Input_Agc, Output_Agc, Input_Fixgain, Output_Fixgain, Fraction_Lost, Packet_Lost, Overflows)Values(Prod_Fz_Qyzj_Rtp_Status_Seq.Nextval, :1, :2, :3, to_date(:4, 'YYYY-MM-DD HH24:MI:SS'), :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18)
dxy8awsx01f1xupdate PERF_HOST_STORAGE_DAY_MIN set resid=:1, used=:2, free=:3, used_percent=:4, update_time=:5 where ID=:6
f54tpujxcbnc7update PERF_HOST_STORAGE_DAY_AVG set resid=:1, used=:2, free=:3, used_percent=:4, update_time=:5 where ID=:6
g269uhxq6ubtySelect c.Id As cityid, c.cname, p.Id As platformid, n.Id As neid, n.ne_name, p.remark, t.* From res_service_ne_v n, RES_PLATFORM p, FSTI_ALARM_CURRENT t, RES_CITY c, CONF_ALERT_GROUP cp, CONF_ALERT_KEY ck, res_ne_card card, Sec_User_Ne_View sv where n.platform_id=p.id and card.neid(+) = n.ID and n.loopback_ip=t.node and p.city_id=c.Id and t.acknowledged != 1 and Sv.User_Id =672 and n.Id = Sv.Ne_Id and t.clearedtime = to_date('4001-1-1', 'yyyy-mm-dd') and t.alertgroup = cp.id(+) and t.alertkey = ck.key_id(+) and t.sound LIKE '%fjzhangxw%' and ((remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ')and group_name not in('²É¼¯¸æ¾¯', 'ÐÔÄÜÊý¾ÝÍêÕûÐԸ澯', 'ÒµÎñÊý¾ÝÍêÕûÐԸ澯', 'ÍøÔªÁ¬Í¨ÐԸ澯', '´úÀí¶ËÍøÔªÁ¬Í¨ÐԸ澯') and severity > 4 and remark1 is null ) or (remark not in('ÔöÖµÍø¹Ü') and group_name in ('ÒµÎñÓ¦Óø澯') and severity > 4) or (remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ') and group_name in('É豸ÐÔÄܸ澯') and severity > 4 and Tally > 3) )
gaskb581vzwb1update PERF_HOST_STORAGE_HOUR_AVG set resid=:1, used=:2, free=:3, used_percent=:4, update_time=:5 where ID=:6
gdd5s7nqgssu9select addition_id from fsti_alarm_trans where last_send_time is null or (last_send_time<sysdate-1/1440) order by addition_id
gqrmhgpq33afwupdate PERF_HOST_STORAGE_DAY_MAX set resid=:1, used=:2, free=:3, used_percent=:4, update_time=:5 where ID=:6
gt22pnh04wan8UPDATE FSTI_ALARM_CURRENT SET NODE = :B9 , NODEALIAS = :B8 , ALERTGROUP = :B7 , ALERTKEY = :B6 , SEVERITY = :B5 , SUMMARY = :B4 , LOCATION = :B3 , DETAIL = :B2 , LASTOCCURRENCE = :B1 , LASTMODIFIED = :B1 , TALLY = TALLY + 1 , SOUND = :B12 , REMARK5 = :B11 WHERE IDENTIFIER = :B10 AND CLEAREDTIME = TO_DATE('4001-01-01', 'yyyy-mm-dd')

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Key Instance Activity Stats

 Value per Second (DB Time) per Second (Elapsed Time) per Trans
Statistic1st2nd1st2nd%Diff1st2nd%Diff1st2nd%Diff
application wait time 8,866 6,053 0.09 0.38 322.22 2.44 1.70 -30.33 0.03 0.03 0.00
cluster wait time 20,642 23,632 0.21 1.47 600.00 5.69 6.64 16.70 0.07 0.10 42.86
concurrency wait time 3,658 2,483 0.04 0.15 275.00 1.01 0.70 -30.69 0.01 0.01 0.00
db block changes 12,873,827 13,554,154 128.69 845.39 556.92 3,547.34 3,806.42 7.30 42.46 56.87 33.94
execute count 1,441,336 1,200,473 14.41 74.88 419.64 397.16 337.13 -15.11 4.75 5.04 6.11
gc cr block receive time 2,073 1,785 0.02 0.11 450.00 0.57 0.50 -12.28 0.01 0.01 0.00
gc cr blocks received 30,348 26,177 0.30 1.63 443.33 8.36 7.35 -12.08 0.10 0.11 10.00
gc current block receive time 16,607 20,268 0.17 1.26 641.18 4.58 5.69 24.24 0.05 0.09 80.00
gc current blocks received 235,685 296,691 2.36 18.51 684.32 64.94 83.32 28.30 0.78 1.24 58.97
logons cumulative 3,345 3,232 0.03 0.20 566.67 0.92 0.91 -1.09 0.01 0.01 0.00
opened cursors cumulative 1,168,626 944,849 11.68 58.93 404.54 322.01 265.34 -17.60 3.85 3.96 2.86
parse count (total) 1,245,382 1,018,993 12.45 63.56 410.52 343.16 286.16 -16.61 4.11 4.28 4.14
parse time elapsed 13,115 10,874 0.13 0.68 423.08 3.61 3.05 -15.51 0.04 0.05 25.00
physical reads 12,431,049 129,170 124.27 8.06 -93.51 3,425.33 36.27 -98.94 41.00 0.54 -98.68
physical writes 532,444 589,821 5.32 36.79 591.54 146.71 165.64 12.90 1.76 2.47 40.34
redo size 3,036,169,552 3,237,675,532 30,350.78 201,938.15 565.35 836,605.78 909,237.73 8.68 10,014.94 13,585.18 35.65
session cursor cache hits 1,165,994 949,424 11.66 59.22 407.89 321.29 266.63 -17.01 3.85 3.98 3.38
session logical reads 1,226,366,036 1,134,427,957 12,259.25 70,755.79 477.16 337,920.82 318,581.86 -5.72 4,045.22 4,760.02 17.67
user I/O wait time 114,242 68,311 1.14 4.26 273.68 31.48 19.18 -39.07 0.38 0.29 -23.68
user calls 8,812,630 7,755,688 88.09 483.73 449.13 2,428.29 2,178.03 -10.31 29.07 32.54 11.94
user commits 303,073 238,247 3.03 14.86 390.43 83.51 66.91 -19.88 1.00 1.00 0.00
user rollbacks 91 77 0.00 0.00 0.00 0.03 0.02 -33.33 0.00 0.00 0.00
workarea executions - multipass 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
workarea executions - onepass 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
workarea executions - optimal 34,415 32,303 0.34 2.01 491.18 9.48 9.07 -4.32 0.11 0.14 27.27

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

 Value per Second (DB Time) per Second (Elapsed Time) per Trans
Statistic1st2nd1st2nd%Diff1st2nd%Diff1st2nd%Diff
CPU used by this session 1,780,478 1,531,866 17.80 95.54 436.74 490.60 430.19 -12.31 5.87 6.43 9.54
CPU used when call started 1,632,147 1,524,558 16.32 95.09 482.66 449.73 428.14 -4.80 5.38 6.40 18.96
CR blocks created 3,158 2,210 0.03 0.14 366.67 0.87 0.62 -28.74 0.01 0.01 0.00
Cached Commit SCN referenced 240,568 1,940 2.40 0.12 -95.00 66.29 0.54 -99.19 0.79 0.01 -98.73
Commit SCN cached 5 1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
DBWR checkpoint buffers written 440,039 466,910 4.40 29.12 561.82 121.25 131.12 8.14 1.45 1.96 35.17
DBWR checkpoints 43 310 0.00 0.02 100.00 0.01 0.09 800.00 0.00 0.00 0.00
DBWR fusion writes 80,995 114,686 0.81 7.15 782.72 22.32 32.21 44.31 0.27 0.48 77.78
DBWR object drop buffers written 1,442 40 0.01 0.00 -100.00 0.40 0.01 -97.50 0.00 0.00 0.00
DBWR parallel query checkpoint buffers written 14,044 2,646 0.14 0.17 21.43 3.87 0.74 -80.88 0.05 0.01 -80.00
DBWR revisited being-written buffer 9 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
DBWR tablespace checkpoint buffers written 999 177 0.01 0.01 0.00 0.28 0.05 -82.14 0.00 0.00 0.00
DBWR thread checkpoint buffers written 29,137 73,167 0.29 4.56 1,472.41 8.03 20.55 155.92 0.10 0.31 210.00
DBWR transaction table writes 518 489 0.01 0.03 200.00 0.14 0.14 0.00 0.00 0.00 0.00
DBWR undo block writes 136,369 135,841 1.36 8.47 522.79 37.58 38.15 1.52 0.45 0.57 26.67
DFO trees parallelized 26 12 0.00 0.00 0.00 0.01 0.00 -100.00 0.00 0.00 0.00
PX local messages recv'd 968 30 0.01 0.00 -100.00 0.27 0.01 -96.30 0.00 0.00 0.00
PX local messages sent 968 30 0.01 0.00 -100.00 0.27 0.01 -96.30 0.00 0.00 0.00
PX remote messages recv'd 3,075 471 0.03 0.03 0.00 0.85 0.13 -84.71 0.01 0.00 -100.00
PX remote messages sent 3,099 502 0.03 0.03 0.00 0.85 0.14 -83.53 0.01 0.00 -100.00
Parallel operations downgraded to serial 1,152 1,082 0.01 0.07 600.00 0.32 0.30 -6.25 0.00 0.00 0.00
Parallel operations not downgraded 26 12 0.00 0.00 0.00 0.01 0.00 -100.00 0.00 0.00 0.00
RowCR - row contention 34 11 0.00 0.00 0.00 0.01 0.00 -100.00 0.00 0.00 0.00
RowCR attempts 3,203 1,914 0.03 0.12 300.00 0.88 0.54 -38.64 0.01 0.01 0.00
RowCR hits 3,164 1,864 0.03 0.12 300.00 0.87 0.52 -40.23 0.01 0.01 0.00
SMON posted for undo segment shrink 28 21 0.00 0.00 0.00 0.01 0.01 0.00 0.00 0.00 0.00
SQL*Net roundtrips to/from client 7,797,973 6,932,692 77.95 432.40 454.71 2,148.70 1,946.91 -9.39 25.72 29.09 13.10
active txn count during cleanout 138,914 142,276 1.39 8.87 538.13 38.28 39.96 4.39 0.46 0.60 30.43
background checkpoints completed 16 17 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
background checkpoints started 16 17 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
background timeouts 15,237 14,871 0.15 0.93 520.00 4.20 4.18 -0.48 0.05 0.06 20.00
branch node splits 67 90 0.00 0.01 100.00 0.02 0.03 50.00 0.00 0.00 0.00
buffer is not pinned count 77,265,003 72,041,359 772.37 4,493.32 481.76 21,290.10 20,231.40 -4.97 254.86 302.28 18.61
buffer is pinned count 430,197,423 408,390,652 4,300.43 25,471.87 492.31 118,539.38 114,688.51 -3.25 1,419.03 1,713.59 20.76
bytes received via SQL*Net from client 1,336,355,674 1,341,201,611 13,358.75 83,652.54 526.20 368,228.08 376,650.19 2.29 4,408.03 5,627.64 27.67
bytes sent via SQL*Net to client 29,807,037,441 27,121,028,698 297,963.23 1,691,574.80 467.71 8,213,223.76 7,616,409.45 -7.27 98,319.84 113,798.98 15.74
calls to get snapshot scn: kcmgss 2,763,513 2,372,291 27.63 147.96 435.50 761.48 666.21 -12.51 9.12 9.95 9.10
calls to kcmgas 1,235,695 1,180,236 12.35 73.61 496.03 340.49 331.45 -2.65 4.08 4.95 21.32
calls to kcmgcs 121,601 128,471 1.22 8.01 556.56 33.51 36.08 7.67 0.40 0.54 35.00
change write time 7,195 6,893 0.07 0.43 514.29 1.98 1.94 -2.02 0.02 0.03 50.00
cleanout - number of ktugct calls 151,103 159,287 1.51 9.93 557.62 41.64 44.73 7.42 0.50 0.67 34.00
cleanouts and rollbacks - consistent read gets 434 217 0.00 0.01 100.00 0.12 0.06 -50.00 0.00 0.00 0.00
cleanouts only - consistent read gets 1,291 354 0.01 0.02 100.00 0.36 0.10 -72.22 0.00 0.00 0.00
cluster key scan block gets 86,475 69,191 0.86 4.32 402.33 23.83 19.43 -18.46 0.29 0.29 0.00
cluster key scans 68,576 52,095 0.69 3.25 371.01 18.90 14.63 -22.59 0.23 0.22 -4.35
commit batch/immediate performed 44,369 32,071 0.44 2.00 354.55 12.23 9.01 -26.33 0.15 0.13 -13.33
commit batch/immediate requested 44,369 32,071 0.44 2.00 354.55 12.23 9.01 -26.33 0.15 0.13 -13.33
commit cleanout failures: block lost 265 1,002 0.00 0.06 100.00 0.07 0.28 300.00 0.00 0.00 0.00
commit cleanout failures: buffer being written 18 9 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
commit cleanout failures: callback failure 12,382 9,742 0.12 0.61 408.33 3.41 2.74 -19.65 0.04 0.04 0.00
commit cleanout failures: cannot pin 142 130 0.00 0.01 100.00 0.04 0.04 0.00 0.00 0.00 0.00
commit cleanouts 1,325,259 1,362,296 13.25 84.97 541.28 365.17 382.57 4.76 4.37 5.72 30.89
commit cleanouts successfully completed 1,312,452 1,351,413 13.12 84.29 542.45 361.64 379.52 4.94 4.33 5.67 30.95
commit immediate performed 44,369 32,071 0.44 2.00 354.55 12.23 9.01 -26.33 0.15 0.13 -13.33
commit immediate requested 44,369 32,071 0.44 2.00 354.55 12.23 9.01 -26.33 0.15 0.13 -13.33
commit txn count during cleanout 78,684 62,280 0.79 3.88 391.14 21.68 17.49 -19.33 0.26 0.26 0.00
consistent changes 13,508 8,879 0.14 0.55 292.86 3.72 2.49 -33.06 0.04 0.04 0.00
consistent gets 1,210,275,633 1,116,598,034 12,098.41 69,643.71 475.64 333,487.17 313,574.68 -5.97 3,992.15 4,685.21 17.36
consistent gets - examination 3,538,590 3,064,226 35.37 191.12 440.34 975.05 860.53 -11.75 11.67 12.86 10.20
consistent gets direct 1,856,983 3,410 18.56 0.21 -98.87 511.69 0.96 -99.81 6.13 0.01 -99.84
consistent gets from cache 1,198,244,174 1,116,596,194 11,978.13 69,643.60 481.42 330,171.94 313,574.16 -5.03 3,952.46 4,685.20 18.54
current blocks converted for CR 0 1 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
cursor authentications 13,870 12,633 0.14 0.79 464.29 3.82 3.55 -7.07 0.05 0.05 0.00
data blocks consistent reads - undo records applied 11,768 7,966 0.12 0.50 316.67 3.24 2.24 -30.86 0.04 0.03 -25.00
db block gets 16,090,429 17,830,008 160.85 1,112.08 591.38 4,433.66 5,007.21 12.94 53.07 74.81 40.96
db block gets direct 74 158 0.00 0.01 100.00 0.02 0.04 100.00 0.00 0.00 0.00
db block gets from cache 16,088,162 17,829,850 160.82 1,112.07 591.50 4,433.04 5,007.16 12.95 53.07 74.81 40.96
deferred (CURRENT) block cleanout applications 762,829 848,891 7.63 52.95 593.97 210.19 238.39 13.42 2.52 3.56 41.27
dirty buffers inspected 1,050 549 0.01 0.03 200.00 0.29 0.15 -48.28 0.00 0.00 0.00
enqueue conversions 1,826 1,684 0.02 0.11 450.00 0.50 0.47 -6.00 0.01 0.01 0.00
enqueue releases 960,059 795,726 9.60 49.63 416.98 264.54 223.46 -15.53 3.17 3.34 5.36
enqueue requests 960,096 795,761 9.60 49.63 416.98 264.55 223.47 -15.53 3.17 3.34 5.36
enqueue timeouts 44 41 0.00 0.00 0.00 0.01 0.01 0.00 0.00 0.00 0.00
enqueue waits 7,615 8,071 0.08 0.50 525.00 2.10 2.27 8.10 0.03 0.03 0.00
exchange deadlocks 174 182 0.00 0.01 100.00 0.05 0.05 0.00 0.00 0.00 0.00
failed probes on index block reclamation 1 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
free buffer inspected 1,379,727 693,980 13.79 43.28 213.85 380.18 194.89 -48.74 4.55 2.91 -36.04
free buffer requested 1,077,192 727,841 10.77 45.40 321.54 296.82 204.40 -31.14 3.55 3.05 -14.08
gc CPU used by this session 79,186 62,134 0.79 3.88 391.14 21.82 17.45 -20.03 0.26 0.26 0.00
gc cr block build time 154 100 0.00 0.01 100.00 0.04 0.03 -25.00 0.00 0.00 0.00
gc cr block flush time 88 102 0.00 0.01 100.00 0.02 0.03 50.00 0.00 0.00 0.00
gc cr block send time 1,036 663 0.01 0.04 300.00 0.29 0.19 -34.48 0.00 0.00 0.00
gc cr blocks served 107,131 68,952 1.07 4.30 301.87 29.52 19.36 -34.42 0.35 0.29 -17.14
gc current block flush time 31 58 0.00 0.00 0.00 0.01 0.02 100.00 0.00 0.00 0.00
gc current block pin time 1,636 1,731 0.02 0.11 450.00 0.45 0.49 8.89 0.01 0.01 0.00
gc current block send time 7,600 9,409 0.08 0.59 637.50 2.09 2.64 26.32 0.03 0.04 33.33
gc current blocks served 796,074 1,061,111 7.96 66.18 731.41 219.36 297.99 35.85 2.63 4.45 69.20
gc local grants 731,356 333,748 7.31 20.82 184.82 201.52 93.73 -53.49 2.41 1.40 -41.91
gc remote grants 75,446 68,586 0.75 4.28 470.67 20.79 19.26 -7.36 0.25 0.29 16.00
gcs messages sent 5,143,883 1,439,169 51.42 89.76 74.56 1,417.38 404.16 -71.49 16.97 6.04 -64.41
ges messages sent 126,328 114,277 1.26 7.13 465.87 34.81 32.09 -7.81 0.42 0.48 14.29
global enqueue get time 6,601 5,100 0.07 0.32 357.14 1.82 1.43 -21.43 0.02 0.02 0.00
global enqueue gets async 25,656 20,662 0.26 1.29 396.15 7.07 5.80 -17.96 0.08 0.09 12.50
global enqueue gets sync 629,825 532,998 6.30 33.24 427.62 173.55 149.68 -13.75 2.08 2.24 7.69
global enqueue releases 647,612 545,955 6.47 34.05 426.28 178.45 153.32 -14.08 2.14 2.29 7.01
heap block compress 3,031 2,551 0.03 0.16 433.33 0.84 0.72 -14.29 0.01 0.01 0.00
hot buffers moved to head of LRU 289,056 283,813 2.89 17.70 512.46 79.65 79.70 0.06 0.95 1.19 25.26
immediate (CR) block cleanout applications 1,725 571 0.02 0.04 100.00 0.48 0.16 -66.67 0.01 0.00 -100.00
immediate (CURRENT) block cleanout applications 49,522 54,549 0.50 3.40 580.00 13.65 15.32 12.23 0.16 0.23 43.75
index crx upgrade (found) 2,342 1,469 0.02 0.09 350.00 0.65 0.41 -36.92 0.01 0.01 0.00
index crx upgrade (positioned) 236,452 186,215 2.36 11.61 391.95 65.15 52.29 -19.74 0.78 0.78 0.00
index fast full scans (full) 674 638 0.01 0.04 300.00 0.19 0.18 -5.26 0.00 0.00 0.00
index fetch by key 3,400,160 3,062,357 33.99 191.00 461.93 936.90 860.00 -8.21 11.22 12.85 14.53
index scans kdiixs1 396,130 327,898 3.96 20.45 416.41 109.15 92.08 -15.64 1.31 1.38 5.34
leaf node 90-10 splits 238 165 0.00 0.01 100.00 0.07 0.05 -28.57 0.00 0.00 0.00
leaf node splits 15,907 18,538 0.16 1.16 625.00 4.38 5.21 18.95 0.05 0.08 60.00
lob reads 4,782 4,366 0.05 0.27 440.00 1.32 1.23 -6.82 0.02 0.02 0.00
lob writes 281 191 0.00 0.01 100.00 0.08 0.05 -37.50 0.00 0.00 0.00
lob writes unaligned 281 190 0.00 0.01 100.00 0.08 0.05 -37.50 0.00 0.00 0.00
messages received 612,700 563,324 6.12 35.14 474.18 168.83 158.20 -6.30 2.02 2.36 16.83
messages sent 612,508 563,260 6.12 35.13 474.02 168.77 158.18 -6.27 2.02 2.36 16.83
no work - consistent read gets 1,195,394,799 1,112,537,015 11,949.65 69,390.42 480.69 329,386.81 312,434.22 -5.15 3,943.06 4,668.17 18.39
parse count (failures) 4 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
parse count (hard) 26,655 23,673 0.27 1.48 448.15 7.34 6.65 -9.40 0.09 0.10 11.11
parse time cpu 11,999 9,531 0.12 0.59 391.67 3.31 2.68 -19.03 0.04 0.04 0.00
physical read IO requests 591,388 129,181 5.91 8.06 36.38 162.95 36.28 -77.74 1.95 0.54 -72.31
physical read bytes 19,572,736,000 1,062,723,584 195,657.00 66,283.49 -66.12 5,393,198.19 298,445.09 -94.47 64,561.54 4,459.15 -93.09
physical read total IO requests 1,476,661 344,717 14.76 21.50 45.66 406.89 96.81 -76.21 4.87 1.45 -70.23
physical read total bytes ############### 97,554,984,448 1,223,528.96 6,084,634.75 397.30 33,726,031.09 27,396,405.72 -18.77 403,731.62 409,337.64 1.39
physical read total multi block requests 366,219 179,845 3.66 11.22 206.56 100.91 50.51 -49.95 1.21 0.75 -38.02
physical reads cache 522,569 114,123 5.22 7.12 36.40 143.99 32.05 -77.74 1.72 0.48 -72.09
physical reads cache prefetch 63,611 549 0.64 0.03 -95.31 17.53 0.15 -99.14 0.21 0.00 -100.00
physical reads direct 1,866,681 15,604 18.66 0.97 -94.80 514.36 4.38 -99.15 6.16 0.07 -98.86
physical reads direct (lob) 3,216 3,409 0.03 0.21 600.00 0.89 0.96 7.87 0.01 0.01 0.00
physical write IO requests 271,531 307,948 2.71 19.21 608.86 74.82 86.48 15.58 0.90 1.29 43.33
physical write bytes 4,361,781,248 4,831,813,632 43,602.13 301,366.67 591.17 1,201,873.40 1,356,920.18 12.90 14,387.53 20,274.14 40.91
physical write total IO requests 1,003,652 887,716 10.03 55.37 452.04 276.55 249.30 -9.85 3.31 3.72 12.39
physical write total bytes 14,231,140,864 15,252,521,984 142,260.25 951,320.18 568.72 3,921,340.54 4,283,371.91 9.23 46,942.05 63,999.10 36.34
physical write total multi block requests 744,113 604,345 7.44 37.69 406.59 205.04 169.72 -17.23 2.45 2.54 3.67
physical writes direct 2,327 2,711 0.02 0.17 750.00 0.64 0.76 18.75 0.01 0.01 0.00
physical writes direct (lob) 0 92 0.00 0.01 100.00 0.00 0.03 100.00 0.00 0.00 0.00
physical writes from cache 530,117 587,110 5.30 36.62 590.94 146.07 164.88 12.88 1.75 2.46 40.57
physical writes non checkpoint 472,347 520,646 4.72 32.47 587.92 130.15 146.21 12.34 1.56 2.18 39.74
pinned buffers inspected 30 23 0.00 0.00 0.00 0.01 0.01 0.00 0.00 0.00 0.00
prefetched blocks aged out before use 108 2 0.00 0.00 0.00 0.03 0.00 -100.00 0.00 0.00 0.00
process last non-idle time 3,617 3,615 0.04 0.23 475.00 1.00 1.02 2.00 0.01 0.02 100.00
queries parallelized 26 12 0.00 0.00 0.00 0.01 0.00 -100.00 0.00 0.00 0.00
recursive calls 2,411,349 2,088,279 24.10 130.25 440.46 664.44 586.45 -11.74 7.95 8.76 10.19
recursive cpu usage 6,833,537 18,730 68.31 1.17 -98.29 1,882.96 5.26 -99.72 22.54 0.08 -99.65
redo blocks written 6,375,836 6,727,550 63.74 419.61 558.32 1,756.84 1,889.30 7.54 21.03 28.23 34.24
redo buffer allocation retries 41 656 0.00 0.04 100.00 0.01 0.18 1,700.00 0.00 0.00 0.00
redo entries 6,977,064 7,357,926 69.75 458.92 557.95 1,922.51 2,066.33 7.48 23.01 30.87 34.16
redo log space requests 48 663 0.00 0.04 100.00 0.01 0.19 1,800.00 0.00 0.00 0.00
redo log space wait time 79 72 0.00 0.00 0.00 0.02 0.02 0.00 0.00 0.00 0.00
redo ordering marks 136,179 130,890 1.36 8.16 500.00 37.52 36.76 -2.03 0.45 0.55 22.22
redo subscn max counts 7,857 8,431 0.08 0.53 562.50 2.16 2.37 9.72 0.03 0.04 33.33
redo synch time 19,437 18,056 0.19 1.13 494.74 5.36 5.07 -5.41 0.06 0.08 33.33
redo synch writes 347,746 270,536 3.48 16.87 384.77 95.82 75.97 -20.72 1.15 1.14 -0.87
redo wastage 122,716,712 95,431,668 1,226.73 5,952.20 385.21 33,814.16 26,800.11 -20.74 404.79 400.43 -1.08
redo write time 19,026 15,445 0.19 0.96 405.26 5.24 4.34 -17.18 0.06 0.06 0.00
redo writer latching time 13 14 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
redo writes 338,910 265,192 3.39 16.54 387.91 93.39 74.47 -20.26 1.12 1.11 -0.89
rollback changes - undo records applied 88,806 64,198 0.89 4.00 349.44 24.47 18.03 -26.32 0.29 0.27 -6.90
rollbacks only - consistent read gets 2,935 2,525 0.03 0.16 433.33 0.81 0.71 -12.35 0.01 0.01 0.00
rows fetched via callback 536,822 444,837 5.37 27.75 416.76 147.92 124.92 -15.55 1.77 1.87 5.65
session pga memory 871,192,208 77,470,256 8,708.79 4,831.92 -44.52 240,053.93 21,756.00 -90.94 2,873.67 325.06 -88.69
session pga memory max 2,464,716,176 1,290,197,808 24,638.30 80,471.36 226.61 679,143.83 362,326.77 -46.65 8,129.98 5,413.63 -33.41
session uga memory 30,231,986,896 34,437,792,904 302,211.20 2,147,931.16 610.74 8,330,317.08 9,671,179.30 16.10 99,721.56 144,499.89 44.90
session uga memory max 2,409,945,968 2,434,481,888 24,090.80 151,841.89 530.29 664,052.09 683,676.53 2.96 7,949.31 10,215.01 28.50
shared hash latch upgrades - no wait 246,478 194,083 2.46 12.11 392.28 67.92 54.50 -19.76 0.81 0.81 0.00
shared hash latch upgrades - wait 2,395 1,499 0.02 0.09 350.00 0.66 0.42 -36.36 0.01 0.01 0.00
sorts (memory) 148,376 146,798 1.48 9.16 518.92 40.88 41.23 0.86 0.49 0.62 26.53
sorts (rows) 1,838,384 1,708,852 18.38 106.58 479.87 506.56 479.90 -5.26 6.06 7.17 18.32
sql area evicted 26,868 23,345 0.27 1.46 440.74 7.40 6.56 -11.35 0.09 0.10 11.11
sql area purged 8 8 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
summed dirty queue length 17,210 8,576 0.17 0.53 211.76 4.74 2.41 -49.16 0.06 0.04 -33.33
switch current to new buffer 5,214 4,431 0.05 0.28 460.00 1.44 1.24 -13.89 0.02 0.02 0.00
table fetch by rowid 249,247,593 236,191,156 2,491.58 14,731.56 491.25 68,679.29 66,329.66 -3.42 822.15 991.05 20.54
table fetch continued row 8,761 8,132 0.09 0.51 466.67 2.41 2.28 -5.39 0.03 0.03 0.00
table scan blocks gotten 532,992,631 465,385,591 5,328.01 29,026.72 444.79 146,864.23 130,694.42 -11.01 1,758.10 1,952.74 11.07
table scan rows gotten 12,350,020,793 6,591,608,327 123,455.81 411,127.42 233.02 3,403,004.56 1,851,124.03 -45.60 40,737.10 27,658.18 -32.11
table scans (direct read) 411 0 0.00 0.00 0.00 0.11 0.00 -100.00 0.00 0.00 0.00
table scans (long tables) 1,405 47 0.01 0.00 -100.00 0.39 0.01 -97.44 0.00 0.00 0.00
table scans (rowid ranges) 411 47 0.00 0.00 0.00 0.11 0.01 -90.91 0.00 0.00 0.00
table scans (short tables) 223,300 226,587 2.23 14.13 533.63 61.53 63.63 3.41 0.74 0.95 28.38
total number of times SMON posted 781 891 0.01 0.06 500.00 0.22 0.25 13.64 0.00 0.00 0.00
transaction rollbacks 44,369 32,071 0.44 2.00 354.55 12.23 9.01 -26.33 0.15 0.13 -13.33
transaction tables consistent read rollbacks 20 8 0.00 0.00 0.00 0.01 0.00 -100.00 0.00 0.00 0.00
transaction tables consistent reads - undo records applied 2,495 212 0.02 0.01 -50.00 0.69 0.06 -91.30 0.01 0.00 -100.00
undo change vector size 662,325,972 711,737,676 6,620.88 44,392.03 570.49 182,501.58 199,877.58 9.52 2,184.71 2,986.43 36.70
write clones created in background 84 42 0.00 0.00 0.00 0.02 0.01 -50.00 0.00 0.00 0.00
write clones created in foreground 9 12 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

 Avg Reads / Sec Avg Writes / Sec Reads Avg Read Time (ms) Avg Blocks / Read Writes Buffer Waits Avg Buf Wait Time (ms)
Tablespace1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
REP_DATA 89.87 0.03 -99.97 0.04 0.01 -75.00 326,168 117 1.33 0.00 1.20 1.00 149 38 0 0 0.00 0.00
FLOW_DATA 0.19 0.17 -10.53 0.00 0.01 100.00 692 594 1.01 1.11 1.00 1.00 18 18 0 0 0.00 0.00
PERF_INDEX_DATA 1.01 0.53 -47.52 1.66 0.98 -40.96 3,677 1,873 5.27 5.22 1.00 1.00 6,010 3,497 114 76 1.32 0.66
PERF_DATA 0.81 0.25 -69.14 3.13 2.73 -12.78 2,941 883 5.89 5.90 1.00 1.00 11,348 9,717 36 35 0.28 7.43
ALM_INDEX_DATA 0.07 0.04 -42.86 0.31 0.26 -16.13 242 157 5.66 4.46 1.00 1.00 1,112 918 2 1 0.00 0.00
OPER_DATA 55.13 19.31 -64.97 42.71 50.79 18.92 200,092 68,758 1.83 5.15 9.67 1.00 154,988 180,841 724 597 3.72 4.17
RES_CONF_INDEX_DATA 0.03 0.02 -33.33 0.10 0.09 -10.00 114 73 5.44 4.66 1.00 1.00 362 323 5 0 0.00 0.00
SYSTEM 0.12 0.05 -58.33 0.05 0.06 20.00 420 168 4.52 5.60 1.00 1.00 197 218 5 4 2.00 0.00
ITCOL_INDEX_DATA 0.42 0.34 -19.05 0.46 0.38 -17.39 1,518 1,220 5.89 5.35 1.00 1.00 1,685 1,351 12 23 4.17 1.74
ALM_DATA 0.06 0.08 33.33 0.32 0.31 -3.13 212 285 4.48 5.12 1.00 1.00 1,157 1,110 41 4 0.49 5.00
OPER_INDEX_DATA 13.73 14.06 2.40 21.20 25.90 22.17 49,832 50,074 5.32 5.81 1.00 1.00 76,950 92,235 255 183 10.90 15.14
RES_CONF_DATA 1.21 1.05 -13.22 1.49 1.38 -7.38 4,380 3,726 1.16 0.52 1.00 1.01 5,405 4,906 432 347 1.06 1.50
ITCOL_DATA 0.19 0.18 -5.26 0.54 0.48 -11.11 707 632 7.23 6.68 1.00 1.00 1,968 1,695 0 0 0.00 0.00
SYSAUX 0.14 0.14 0.00 0.10 0.09 -10.00 493 489 4.40 3.87 1.00 1.00 348 323 0 0 0.00 0.00
UNDOTBS1 0.00 0.00 0.00 2.85 2.99 4.91 10 10 0.00 5.00 1.00 1.00 10,361 10,632 50 28 0.00 0.36

Back to IO Stats
Back to Top

Top 10 File Comparison by IO

No data exists for this section of the report.

Back to IO Stats
Back to Top

Top 10 File Comparison by Read Time

  Read Time % of DB Time Avg Read Time (ms) Reads Avg Reads / Sec Avg Blocks / Read Writes Avg Writes / Sec Buffer Waits Avg Buf Wait Time (ms)
TablespaceFilename1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
REP_DATA +DG/vam/datafile/rep_data03.dbf 0.11 0.00 -0.11 1.37 0.00 81,276 36 22.40 0.01 1.20 1.00 8 9 0.00 0.00 0 0 0.00 0.00
REP_DATA +DG/vam/datafile/rep_data01.dbf 0.11 0.00 -0.11 1.35 0.00 82,379 18 22.70 0.01 1.20 1.00 125 9 0.03 0.00 0 0 0.00 0.00
REP_DATA +DG/vam/datafile/rep_data02.dbf 0.11 0.00 -0.11 1.32 0.00 81,376 27 22.42 0.01 1.19 1.00 8 11 0.00 0.00 0 0 0.00 0.00
REP_DATA +DG/vam/datafile/rep_data04.dbf 0.10 0.00 -0.10 1.29 0.00 81,137 36 22.36 0.01 1.20 1.00 8 9 0.00 0.00 0 0 0.00 0.00

Back to IO Stats
Back to Top

Top 10 File Comparison by Buffer Waits

No data exists for this section of the report.

Back to IO Stats
Back to Top

Advisory Statistics

Back to Top

PGA Aggregate Summary

PGA Cache Hit % W/A Bytes/Sec (DB Time) W/A MB Processed Read/Written W/A Bytes/Sec (DB Time) Read/Written W/A MB
1st2ndDiff1st2nd%Diff1st2nd1st2nd%Diff1st2nd
100.00 100.00 0.00 53,347 329,531 517.71 5,089 5,039 0 0 0.00 0 0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M)W/A PGA Used(M)%PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B1 1,628 390 2,139.7 7.1 0.3 100.0 0.0 166,700
E1 1,628 102 3,026.1 9.8 0.3 100.0 0.0 166,700
                 
B2 1,628 102 3,026.1 9.8 0.3 100.0 0.0 166,700
E2 1,628 185 2,588.3 7.0 0.3 100.0 0.0 166,700

Back to Advisory Statistics
Back to Top

Wait Stats

Back to Top

Buffer Wait Statistics

 Wait Time % DB Time Total Wait Time (s) # Waits Avg Wait Time (ms)
Class1st2ndDiff1st2nd1st2nd1st2nd%Diff
data block 0.00 0.00 0.00 6.20 6.16 1,574 1,215 0.04 0.05 25.00
segment header 0.00 0.00 0.00 0.01 0.05 3 8 0.03 0.06 100.00
1st level bmb 0.00 0.00 0.00 0.00 0.01 51 52 0.00 0.00 0.00
undo block 0.00 0.00 0.00 0.01 0.01 7 12 0.01 0.01 0.00
2nd level bmb 0.00 0.00 0.00 0.00 0.00 0 1 0.00 0.00 0.00
undo header 0.00 0.00 0.00 0.00 0.00 49 26 0.00 0.00 0.00

Back to Wait Stats
Back to Top

Enqueue Activity

 Wait Time % of DB Time Wait Time Requests Successful Gets Failed Gets Waits Avg Wait Time (ms)
Enqueue Type (Request Reason)1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
WF-AWR Flush 0.00 0.02 0.02 2 4 25 21 25 21 0 0 11 12 171.45 319.50
FB-Format Block 0.00 0.02 0.02 3 4 8,515 8,955 8,515 8,955 0 0 4,270 4,536 0.77 0.81
TC-Tablespace Checkpoint 0.00 0.02 0.02 1 3 6 3 6 3 0 0 2 1 609.00 2,852.00
TX-Transaction (index contention) 0.00 0.02 0.02 3 3 743 336 741 332 0 0 235 202 10.70 13.92
KO-Multiple Object Checkpoint (fast object checkpo 0.00 0.00 -0.00 3 0 116 368 116 368 0 0 28 183 97.07 0.52

Back to Wait Stats
Back to Top

Latch Sleep Breakdown

 % of Total Sleeps Get Requests Misses Spin Gets Sleeps Sleep1 Sleep2 Sleep3
Latch Name1st2ndDiff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
cache buffers chains 92.99 94.56 1.57 2,464,018,642 2,304,165,460 37,554,142 37,236,979 37,543,484 37,225,604 11,572 12,271 0 0 0 0 0 0
gcs remastering latch 4.69 3.36 -1.33 6,658,825 1,543,948 9 9 3 0 584 436 0 0 0 0 0 0
shared pool 0.41 0.46 0.05 1,113,454 967,886 690 744 641 684 51 60 0 0 0 0 0 0
cache buffers lru chain 0.08 0.03 -0.05 1,586,373 1,804,425 4,246 3,537 4,236 3,533 10 4 0 0 0 0 0 0
gcs resource hash 0.06 0.02 -0.04 13,988,376 7,123,829 5,706 2,970 5,700 2,968 7 2 0 0 0 0 0 0
shared pool simulator 0.05 0.01 -0.04 2,188,707 1,792,066 145 103 140 102 6 1 0 0 0 0 0 0
active service list 0.12 0.08 -0.04 23,088 22,853 27 21 12 12 15 11 0 0 0 0 0 0
session allocation 0.05 0.02 -0.03 1,482,180 1,218,913 11,654 8,544 11,648 8,541 6 3 0 0 0 0 0 0
redo allocation 0.02 0.00 -0.02 1,048,846 824,076 2,279 2,127 2,276 2,127 3 0 0 0 0 0 0 0
session idle bit 0.04 0.06 0.02 18,076,831 15,893,402 4,895 4,162 4,890 4,154 5 8 0 0 0 0 0 0
object queue header operation 0.31 0.29 -0.02 4,134,528 3,526,846 2,547 2,315 2,508 2,277 39 38 0 0 0 0 0 0
KCL gc element parent latch 0.85 0.83 -0.02 4,118,627 4,852,483 2,152 2,683 2,047 2,576 106 108 0 0 0 0 0 0
process allocation 0.23 0.22 -0.02 33,955 34,181 42 36 13 8 29 28 0 0 0 0 0 0
mostly latch-free SCN 0.02 0.00 -0.02 348,384 274,175 5,138 4,954 5,136 4,954 2 0 0 0 0 0 0 0
simulator hash latch 0.00 0.02 0.02 87,480,034 68,847,214 7,895 4,091 7,895 4,089 0 2 0 0 0 0 0 0
row cache objects 0.02 0.01 -0.01 2,893,936 2,657,667 2,454 3,237 2,452 3,236 2 1 0 0 0 0 0 0
KJCT flow control latch 0.01 0.00 -0.01 1,953,031 2,263,893 747 919 746 919 1 0 0 0 0 0 0 0
active checkpoint queue latch 0.01 0.00 -0.01 245,181 277,664 7,998 10,984 7,997 10,984 1 0 0 0 0 0 0 0
ges resource hash list 0.01 0.00 -0.01 1,956,919 1,727,163 872 743 871 743 1 0 0 0 0 0 0 0
messages 0.01 0.00 -0.01 1,867,906 1,704,775 13,288 12,997 13,287 12,997 1 0 0 0 0 0 0 0
redo writing 0.01 0.00 -0.01 1,285,748 1,094,467 6,495 8,688 6,494 8,688 1 0 0 0 0 0 0 0
KJC message pool free list 0.00 0.01 0.01 147,190 209,974 785 1,346 785 1,345 0 1 0 0 0 0 0 0
library cache 0.00 0.01 0.01 2,604,737 2,167,566 6,628 4,808 6,628 4,807 0 1 0 0 0 0 0 0
enqueue hash chains 0.01 0.01 -0.00 2,933,034 2,440,829 3,331 2,510 3,330 2,509 1 1 0 0 0 0 0 0
slave class create 0.01 0.01 -0.00 1,940 665 1 1 0 0 1 1 0 0 0 0 0 0


Back to Top

Segment Statistics

Back to Top

Top 5 Segments Comparison by Logical Reads

     % of Total Logical Reads Logical Reads
OwnerTablespaceObject NameSubobject NameType1st2ndDiff1st2nd
VAMT REP_DATA REP_FZ_WAP_TERMINALACCESS   TABLE 6.14 0.00 -6.14 75,238,176 0
VAMT ALM_DATA FSTI_ALARM_TRANS   TABLE 36.85 40.79 3.94 451,919,168 462,680,160
VAMT ALM_INDEX_DATA FSTI_ALARM_CURRENT_CLEAR_ID   INDEX 48.21 51.32 3.11 591,270,992 582,243,280
VAMT ALM_DATA FSTI_ALARM_CURRENT   TABLE 4.91 5.06 0.15 60,207,424 57,419,408
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN PROD_FZ_WAP_20120208 INDEX PARTITION 0.30 0.40 0.10 3,624,240 4,522,704
VAMT OPER_DATA PROD_FZ_PHONENEWSPAPER_STATUS   TABLE 0.25 0.33 0.08 3,016,096 3,744,480

Back to Segment Statistics
Back to Top

Top 5 Segments Comparison by Physical Reads

     % of Total Physical Reads Physical Reads
OwnerTablespaceObject NameSubobject NameType1st2ndDiff1st2nd
VAMT OPER_DATA LOCAL_WAP20_MSISDN PROD_FZ_WAP_20120205 INDEX PARTITION 0.15 15.33 15.18 18,561 19,803
VAMT OPER_DATA PROD_FZ_WAP_WAP20TRAFFIC PROD_FZ_WAP_20120208 TABLE PARTITION 14.91 0.00 -14.91 1,853,502 0
VAMT OPER_DATA LOCAL_WAP20_MSISDN PROD_FZ_WAP_20120204 INDEX PARTITION 0.13 14.91 14.79 15,741 19,265
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN PROD_FZ_WAP_20120204 INDEX PARTITION 0.10 12.82 12.72 12,677 16,556
VAMT OPER_DATA LOCAL_WAP20_MSISDN PROD_FZ_WAP_20120208 INDEX PARTITION 0.23 12.90 12.67 29,194 16,664
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN PROD_FZ_WAP_20120205 INDEX PARTITION 0.11 12.14 12.03 13,649 15,685
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN PROD_FZ_WAP_20120208 INDEX PARTITION 0.15 11.19 11.05 18,403 14,459
VAMT REP_DATA REP_FZ_WAP_TERMINALACCESS   TABLE 3.13 0.00 -3.13 389,662 0

Back to Segment Statistics
Back to Top

Top 5 Segments by Row Lock Waits

     Row Lock Waits % of Captured
OwnerTablespaceObject NameSubobject NameType1st2nd1st2ndDiff
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN PROD_FZ_WAP_20120205 INDEX PARTITION 123 48 21.24 16.90 -4.34
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN PROD_FZ_WAP_20120208 INDEX PARTITION 94 23 16.23 8.10 -8.14
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN PROD_FZ_WAP_20120209 INDEX PARTITION 30   5.18   -5.18
VAMT OPER_DATA LOCAL_WAP20_MSISDN PROD_FZ_WAP_20120205 INDEX PARTITION 29 23 5.01 8.10 3.09
VAMT OPER_DATA LOCAL_WAP20_MSISDN PROD_FZ_WAP_20120208 INDEX PARTITION 87 19 15.03 6.69 -8.34
VAMT OPER_INDEX_DATA UK_PROD_RES_NE_DETECT_LOG   INDEX   25   8.80 8.80

Back to Segment Statistics
Back to Top

Top 5 Segments by ITL Waits

     ITL Waits % of Captured
OwnerTablespaceObject NameSubobject NameType1st2nd1st2ndDiff
VAMT ALM_INDEX_DATA LOCAL_ALARM_STATUS_LASTNODE FSTI_ALARM_STATUS20120301 INDEX PARTITION   1   20.00 20.00
VAMT OPER_DATA LOCAL_WAP20_MSISDN PROD_FZ_WAP_20120208 INDEX PARTITION 4 2 44.44 40.00 -4.44
VAMT ITCOL_INDEX_DATA PK_HOST_STORAGE_ID   INDEX   1   20.00 20.00
VAMT PERF_INDEX_DATA PK_PERF_HOST_SH_AVG_ID   INDEX 1   11.11   -11.11
VAMT PERF_INDEX_DATA PK_PERF_INTERFACE_H_MAX_ID   INDEX   1   20.00 20.00
VAMT PERF_INDEX_DATA UK_PERF_HOST_SH_MIN_RES_UP   INDEX 1   11.11   -11.11
VAMT PERF_INDEX_DATA UK_PERF_INTERFACE_H_MIN_RES_UP   INDEX 1   11.11   -11.11
VAMT ITCOL_INDEX_DATA UN_PERF_ORACLE_ROLLBACK_RESID   INDEX 1   11.11   -11.11

Back to Segment Statistics
Back to Top

Top 5 Segments by Buffer Busy Waits

     % of Total Buffer Waits Buffer Busy Waits
OwnerTablespaceObject NameSubobject NameType1st2ndDiff1st2nd
VAMT OPER_DATA PROD_FZ_WAP_WAP20TRAFFIC PROD_FZ_WAP_20120208 TABLE PARTITION 0.23 51.95 51.73 2 319
VAMT OPER_DATA PROD_FZ_WAP_WAP20TRAFFIC PROD_FZ_WAP_20120205 TABLE PARTITION 48.31 0.00 -48.31 428 0
VAMT OPER_INDEX_DATA UK_PROD_RES_NE_DETECT_LOG   INDEX 6.43 9.28 2.85 57 57
VAMT OPER_DATA PK_PROD_RES_NE_DETECT_LOG   INDEX 7.67 10.42 2.75 68 64
VAMT OPER_INDEX_DATA LC_INDEX_PROD_FZ_MMSC_LOG_SNDR PROD_FZ_MMSC_LOG20120210 INDEX PARTITION 2.82 0.98 -1.84 25 6
VAMT OPER_DATA PROD_FZ_ISMP_TRAFFIC PROD_FZ_ISMP_TRAFFIC20120210 TABLE PARTITION 10.27 8.47 -1.80 91 52
VAMT PERF_INDEX_DATA PK_PERF_HOST_SH_AVG_ID   INDEX 0.23 1.63 1.40 2 10

Back to Segment Statistics
Back to Top

Top 5 Segments by CR Blocks Received

     % of Total CR Blocks Received CR Blocks Received
OwnerTablespaceObject NameSubobject NameType1st2ndDiff1st2nd
VAMT RES_CONF_DATA RES_NE   TABLE 11.55 9.08 -2.48 3,506 2,376
VAMT RES_CONF_DATA CONF_APP_SERVER_CLUSTER   TABLE 11.64 14.06 2.42 3,532 3,681
VAMT RES_CONF_DATA RES_HOST_PROCESS   TABLE 3.97 5.98 2.01 1,205 1,566
VAMT ALM_DATA FSTI_ALARM_CURRENT   TABLE 13.54 14.74 1.21 4,108 3,859
VAMT ALM_DATA FSTI_ALARM_TRANS   TABLE 3.89 4.94 1.05 1,181 1,293
VAMT RES_CONF_DATA RES_ORACLE_SESSION   TABLE 4.21 3.93 -0.28 1,279 1,029
VAMT RES_CONF_DATA RES_HOST_STORAGE   TABLE 4.02 3.77 -0.25 1,219 987

Back to Segment Statistics
Back to Top

Top 5 Segments by Current Blocks Received

     % of Total Current Blocks Received Current Blocks Received
OwnerTablespaceObject NameSubobject NameType1st2ndDiff1st2nd
VAMT OPER_DATA LOCAL_WAP20_MSISDN PROD_FZ_WAP_20120208 INDEX PARTITION 26.22 38.18 11.96 61,796 89,995
VAMT OPER_DATA LOCAL_WAP20_MSISDN PROD_FZ_WAP_20120209 INDEX PARTITION   7.90 7.90   18,614
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN PROD_FZ_WAP_20120208 INDEX PARTITION 17.67 24.06 6.38 41,657 56,697
VAMT OPER_DATA LOCAL_WAP20_MSISDN PROD_FZ_WAP_20120204 INDEX PARTITION 3.30 5.51 2.21 7,781 12,978
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN PROD_FZ_WAP_20120209 INDEX PARTITION 2.30 4.37 2.07 5,409 10,291
VAMT OPER_DATA LOCAL_WAP20_MSISDN PROD_FZ_WAP_20120205 INDEX PARTITION 2.27 4.06 1.79 5,346 9,560

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Back to Top

Dictionary Cache Statistics

 Get Requests / Sec (DB Time) Get Requests / Sec (Elapsed Time) Get Requests Pct Miss Scan Requests Pct Miss Mod Reqs Final Usage
Cache1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
dc_awr_control 0.00 0.00 0.00 0.02 0.02 0.00 66 62 0.00 1.61 0 0 0.00 0.00 2 1 1 1
dc_database_links 0.06 0.39 550.00 1.78 1.75 -1.69 6,460 6,244 0.00 0.00 0 0 0.00 0.00 0 0 1 1
dc_files 0.03 0.16 433.33 0.85 0.72 -15.29 3,084 2,570 58.33 60.00 0 0 0.00 0.00 0 0 257 257
dc_global_oids 0.00 0.02 100.00 0.10 0.10 0.00 357 352 7.28 5.97 0 0 0.00 0.00 0 0 5 5
dc_histogram_data 1.43 7.91 453.15 39.44 35.60 -9.74 143,119 126,750 3.89 3.95 0 0 0.00 0.00 0 0 1,246 1,548
dc_histogram_defs 1.09 5.74 426.61 29.92 25.82 -13.70 108,589 91,957 9.04 9.19 0 0 0.00 0.00 0 3 1,588 2,214
dc_object_grants 0.00 0.00 0.00 0.00 0.00 0.00 4 0 50.00 0.00 0 0 0.00 0.00 0 0 2 0
dc_object_ids 1.44 8.20 469.44 39.61 36.93 -6.77 143,766 131,508 2.35 2.03 0 0 0.00 0.00 0 1 701 774
dc_objects 0.40 2.25 462.50 11.10 10.11 -8.92 40,282 36,001 2.01 1.79 0 0 0.00 0.00 8 7 816 705
dc_profiles 0.03 0.20 566.67 0.89 0.88 -1.12 3,235 3,129 0.00 0.00 0 0 0.00 0.00 0 0 1 1
dc_rollback_segments 0.47 2.76 487.23 12.88 12.42 -3.57 46,733 44,214 0.00 0.00 0 0 0.00 0.00 0 0 799 799
dc_segments 1.05 5.97 468.57 29.08 26.89 -7.53 105,518 95,768 4.72 3.76 0 0 0.00 0.00 280 305 570 767
dc_sequences 0.03 0.12 300.00 0.76 0.56 -26.32 2,767 2,002 13.73 13.44 0 0 0.00 0.00 2,767 2,002 68 40
dc_tablespace_quotas 0.00 0.02 100.00 0.07 0.08 14.29 270 277 28.52 24.55 0 0 0.00 0.00 270 277 1 0
dc_tablespaces 1.66 9.37 464.46 45.70 42.18 -7.70 165,860 150,214 0.04 0.02 0 0 0.00 0.00 0 0 22 22
dc_usernames 0.18 1.07 494.44 4.99 4.80 -3.81 18,120 17,108 0.08 0.05 0 0 0.00 0.00 0 0 6 6
dc_users 2.32 14.70 533.62 63.85 66.17 3.63 231,735 235,624 0.01 0.01 0 0 0.00 0.00 0 0 35 33
outstanding_alerts 0.00 0.02 100.00 0.08 0.08 0.00 277 270 94.58 94.81 0 0 0.00 0.00 11 3 0 0

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Statistics (RAC)

 GES Requests / Sec (DB Time) GES Requests / Sec (Elapsed Time) GES Requests Conflicts % Requests Releases % Requests
Cache1st2nd%Diff1st2nd%Diff1st2nd1st2ndDiff1st2ndDiff
dc_awr_control 0.00 0.00 0.00 0.00 0.00 0.00 4 3 0.00 33.33 33.33 0.00 0.00 0.00
dc_files 0.02 0.10 400.00 0.50 0.43 -14.00 1,799 1,542 0.00 0.00 0.00 100.00 100.00 0.00
dc_global_oids 0.00 0.00 0.00 0.01 0.01 0.00 26 21 0.00 0.00 0.00 100.00 100.00 0.00
dc_histogram_defs 0.10 0.53 430.00 2.71 2.37 -12.55 9,820 8,448 0.00 0.00 0.00 103.12 92.59 -10.53
dc_object_ids 0.03 0.17 466.67 0.94 0.75 -20.21 3,396 2,670 0.03 0.00 -0.03 106.68 96.89 -9.79
dc_objects 0.01 0.04 300.00 0.23 0.18 -21.74 823 650 0.24 0.31 0.06 95.14 115.54 20.40
dc_segments 0.05 0.26 420.00 1.51 1.16 -23.18 5,469 4,131 1.24 1.65 0.40 92.80 80.80 -11.99
dc_sequences 0.06 0.25 316.67 1.52 1.12 -26.32 5,534 4,003 4.01 4.87 0.86 2.96 2.55 -0.42
dc_tablespace_quotas 0.01 0.03 200.00 0.15 0.16 6.67 540 554 13.89 12.27 -1.61 0.37 0.18 -0.19
dc_tablespaces 0.00 0.00 0.00 0.02 0.01 -50.00 65 32 0.00 0.00 0.00 100.00 100.00 0.00
dc_usernames 0.00 0.00 0.00 0.00 0.00 0.00 15 9 0.00 0.00 0.00 93.33 100.00 6.67
dc_users 0.00 0.00 0.00 0.00 0.00 0.00 15 11 0.00 0.00 0.00 93.33 100.00 6.67
outstanding_alerts 0.01 0.03 200.00 0.15 0.15 0.00 545 536 0.00 7.65 7.65 46.97 39.93 -7.05

Back to Dictionary Cache Statistics
Back to Top

Libarary Cache Statistics

Back to Top

Library Cache Activity

 Get Requests / Sec (DB Time) Get Requests / Sec (Elapsed Time) Get Requests Pct Miss Pin Requests Pct Miss Reloads Invalidations
Namespace1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
BODY 0.01 0.03 200.00 0.17 0.14 -17.65 602 514 1.00 1.36 5,666 4,388 0.21 0.30 6 6 0 0
CLUSTER 0.00 0.01 100.00 0.03 0.02 -33.33 115 86 3.48 3.49 221 156 7.24 6.41 12 7 0 0
INDEX 0.00 0.00 0.00 0.02 0.02 0.00 87 63 34.48 47.62 181 124 29.28 33.87 23 12 0 0
SQL AREA 1.17 6.43 449.57 32.15 28.94 -9.98 116,665 103,057 21.67 21.43 1,605,330 1,340,300 5.75 6.36 16,188 14,582 2,331 2,072
TABLE/PROCEDURE 0.39 2.15 451.28 10.72 9.70 -9.51 38,916 34,534 1.84 1.54 453,658 364,589 1.57 1.57 2,667 2,060 0 0
TRIGGER 0.01 0.03 200.00 0.15 0.14 -6.67 555 482 0.18 0.83 5,480 4,863 0.38 0.53 20 22 0 0

Back to Libarary Cache Statistics
Back to Top

Library Cache Activity (RAC)

 GES Lock Requests / Sec (DB Time) GES Lock Requests / Sec (Elapsed Time) GES Lock Requests GES Pin Requests GES Pin Releases GES Inval Requests GES Invalidations
Namespace1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd
CLUSTER 0.00 0.01 100.00 0.06 0.04 -33.33 221 156 4 3 4 3 4 3 0 0
INDEX 0.00 0.01 100.00 0.05 0.03 -40.00 181 124 44 37 31 33 34 33 0 0
TABLE/PROCEDURE 1.18 6.66 464.41 32.60 29.99 -8.01 118,298 106,776 684 489 577 581 492 306 0 0

Back to Libarary Cache Statistics
Back to Top

SGA Statistics

Back to Top

SGA Memory Summary

 Size (KB)
SGA regions1st2nd
Database Buffers 6,406,144.00 6,406,144.00
Fixed Size 2,005.79 2,005.79
Redo Buffers 14,376.00 14,376.00
Variable Size 1,769,474.21 1,769,474.21

Back to SGA Statistics
Back to Top

SGA breakdown difference

  1st 2nd   
PoolNameBegin ValueEnd Value%DiffBegin ValueEnd Value%Diff%Diff of Begin Values%Diff of End Values
java free memory 16,777,216 16,777,216 0.00 16,777,216 16,777,216 0.00 0.00 0.00
large ASM map operations hashta 393,216 393,216 0.00 393,216 393,216 0.00 0.00 0.00
large PX msg pool 1,207,168 1,207,168 0.00 1,207,168 1,207,168 0.00 0.00 0.00
large free memory 31,954,048 31,954,048 0.00 31,954,048 31,954,048 0.00 0.00 0.00
shared ASH buffers 30,408,704 30,408,704 0.00 30,408,704 30,408,704 0.00 0.00 0.00
shared ASM extent pointer array 28,174,832 27,706,648 -1.66 27,706,648 27,995,128 1.04 -1.66 1.04
shared CCursor 58,798,168 57,356,904 -2.45 57,356,904 57,918,856 0.98 -2.45 0.98
shared Cursor Stats 25,620,936 25,620,936 0.00 25,620,936 25,620,936 0.00 0.00 0.00
shared KGH: NO ACCESS 91,792,640 91,792,640 0.00 91,792,640 91,792,640 0.00 0.00 0.00
shared PCursor 39,336,416 38,470,264 -2.20 38,470,264 38,642,432 0.45 -2.20 0.45
shared db_block_hash_buckets 47,185,920 47,185,920 0.00 47,185,920 47,185,920 0.00 0.00 0.00
shared event statistics per sess 20,462,400 20,462,400 0.00 20,462,400 20,462,400 0.00 0.00 0.00
shared free memory 757,644,152 759,693,680 0.27 759,693,680 755,558,392 -0.54 0.27 -0.54
shared gcs resources 137,688,312 137,688,312 0.00 137,688,312 137,688,312 0.00 0.00 0.00
shared gcs shadows 81,849,632 81,849,632 0.00 81,849,632 81,849,632 0.00 0.00 0.00
shared ges enqueues 28,974,912 28,974,912 0.00 28,974,912 28,974,912 0.00 0.00 0.00
shared kglsim heap 34,413,120 34,413,120 0.00 34,413,120 34,413,120 0.00 0.00 0.00
shared kglsim object batch 64,096,032 64,096,032 0.00 64,096,032 64,096,032 0.00 0.00 0.00
shared library cache 77,511,584 77,344,056 -0.22 77,344,056 77,600,984 0.33 -0.22 0.33
shared sql area 73,229,648 70,133,232 -4.23 70,133,232 73,117,400 4.25 -4.23 4.25
shared trace buffer 24,641,536 24,641,536 0.00 24,641,536 24,641,536 0.00 0.00 0.00
streams free memory 16,777,216 16,777,216 0.00 16,777,216 16,777,216 0.00 0.00 0.00
  buffer_cache 6,559,891,456 6,559,891,456 0.00 6,559,891,456 6,559,891,456 0.00 0.00 0.00
  fixed_sga 2,053,928 2,053,928 0.00 2,053,928 2,053,928 0.00 0.00 0.00
  log_buffer 14,721,024 14,721,024 0.00 14,721,024 14,721,024 0.00 0.00 0.00

Back to SGA Statistics
Back to Top

init.ora Parameters

Parameter Name1st End Snap Value2nd End Snap Value (if different)
O7_DICTIONARY_ACCESSIBILITY FALSE  
__db_cache_size 5502926848  
__dg_broker_service_names vam_XPT  
__java_pool_size 16777216  
__large_pool_size 33554432  
__shared_pool_size 1744830464  
__streams_pool_size 16777216  
_immediate_commit_propagation FALSE  
aq_tm_processes 0  
archive_lag_target 0  
asm_power_limit 1  
audit_file_dest /oracle/app/oracle/admin/vam/adu  
audit_sys_operations FALSE  
audit_trail NONE  
background_core_dump partial  
background_dump_dest /oracle/app/oracle/admin/vam/bdu  
backup_tape_io_slaves FALSE  
bitmap_merge_area_size 1048576  
blank_trimming FALSE  
cluster_database TRUE  
cluster_database_instances 2  
commit_point_strength 1  
compatible 10.2.0.3.0  
control_file_record_keep_time 7  
control_files +DG/vam/controlfile/current.256.  
core_dump_dest /oracle/app/oracle/admin/vam/cdu  
cpu_count 16  
create_bitmap_area_size 8388608  
cursor_sharing EXACT  
cursor_space_for_time FALSE  
db_16k_cache_size 0  
db_2k_cache_size 0  
db_32k_cache_size 0  
db_4k_cache_size 0  
db_8k_cache_size 0  
db_block_buffers 0  
db_block_checking FALSE  
db_block_checksum TRUE  
db_block_size 8192  
db_cache_advice ON  
db_cache_size 0  
db_create_file_dest +DG  
db_file_multiblock_read_count 16  
db_files 1000  
db_flashback_retention_target 1440  
db_keep_cache_size 1056964608  
db_name vam  
db_recovery_file_dest +RECOVERYDEST  
db_recovery_file_dest_size 524288000000  
db_recycle_cache_size 0  
db_unique_name vam  
db_writer_processes 2  
dbwr_io_slaves 0  
ddl_wait_for_locks FALSE  
dg_broker_config_file1 /oracle/app/oracle/product/10.2.  
dg_broker_config_file2 /oracle/app/oracle/product/10.2.  
dg_broker_start FALSE  
disk_asynch_io TRUE  
distributed_lock_timeout 60  
dml_locks 9700  
drs_start FALSE  
fast_start_io_target 0  
fast_start_mttr_target 0  
fast_start_parallel_rollback LOW  
file_mapping FALSE  
filesystemio_options asynch  
gcs_server_processes 4  
global_names FALSE  
hash_area_size 131072  
hi_shared_memory_address 0  
hs_autoregister TRUE  
instance_name vam1  
instance_number 1  
instance_type RDBMS  
java_max_sessionspace_size 0  
java_pool_size 0  
java_soft_sessionspace_limit 0  
job_queue_processes 10  
large_pool_size 0  
ldap_directory_access NONE  
license_max_sessions 0  
license_max_users 0  
license_sessions_warning 0  
local_listener VAM  
lock_sga FALSE  
log_archive_dest_1 LOCATION=+RECOVERYDEST/  
log_archive_dest_state_1 enable  
log_archive_dest_state_10 enable  
log_archive_dest_state_2 enable  
log_archive_dest_state_3 enable  
log_archive_dest_state_4 enable  
log_archive_dest_state_5 enable  
log_archive_dest_state_6 enable  
log_archive_dest_state_7 enable  
log_archive_dest_state_8 enable  
log_archive_dest_state_9 enable  
log_archive_format %t_%s_%r.dbf  
log_archive_local_first TRUE  
log_archive_max_processes 2  
log_archive_min_succeed_dest 1  
log_archive_start FALSE  
log_archive_trace 0  
log_buffer 14274560  
log_checkpoint_interval 0  
log_checkpoint_timeout 1800  
log_checkpoints_to_alert FALSE  
logmnr_max_persistent_sessions 1  
max_commit_propagation_delay 700  
max_dump_file_size UNLIMITED  
max_enabled_roles 150  
nls_language AMERICAN  
nls_length_semantics BYTE  
nls_nchar_conv_excp FALSE  
nls_territory AMERICA  
object_cache_max_size_percent 10  
object_cache_optimal_size 102400  
olap_page_pool_size 0  
open_cursors 1000  
open_links 30  
open_links_per_instance 10  
optimizer_dynamic_sampling 2  
optimizer_features_enable 10.2.0.4  
optimizer_index_caching 90  
optimizer_index_cost_adj 20  
optimizer_mode ALL_ROWS  
optimizer_secure_view_merging TRUE  
os_authent_prefix ops$  
os_roles FALSE  
parallel_adaptive_multi_user TRUE  
parallel_automatic_tuning FALSE  
parallel_execution_message_size 2152  
parallel_max_servers 320  
parallel_min_percent 0  
parallel_min_servers 0  
parallel_server TRUE  
parallel_server_instances 2  
parallel_threads_per_cpu 2  
pga_aggregate_target 1707081728  
plsql_code_type INTERPRETED  
plsql_compiler_flags INTERPRETED, NON_DEBUG  
plsql_debug FALSE  
plsql_native_library_subdir_count 0  
plsql_optimize_level 2  
plsql_v2_compatibility FALSE  
plsql_warnings DISABLE:ALL  
pre_11g_enable_capture FALSE  
pre_page_sga FALSE  
processes 2000  
query_rewrite_enabled TRUE  
query_rewrite_integrity enforced  
read_only_open_delayed FALSE  
recovery_parallelism 0  
recyclebin on  
remote_archive_enable true  
remote_dependencies_mode TIMESTAMP  
remote_login_passwordfile EXCLUSIVE  
remote_os_authent FALSE  
remote_os_roles FALSE  
replication_dependency_tracking TRUE  
resource_limit FALSE  
resumable_timeout 0  
serial_reuse disable  
service_names vam  
session_cached_cursors 1000  
session_max_open_files 10  
sessions 2205  
sga_max_size 8388608000  
sga_target 8388608000  
shadow_core_dump partial  
shared_memory_address 0  
shared_pool_reserved_size 89758105  
shared_pool_size 0  
shared_servers 0  
skip_unusable_indexes TRUE  
sort_area_retained_size 0  
sort_area_size 65536  
spfile +DG/vam/spfilevam.ora  
sql92_security FALSE  
sql_trace FALSE  
sql_version NATIVE  
sqltune_category DEFAULT  
standby_archive_dest ?/dbs/arch  
standby_file_management MANUAL  
star_transformation_enabled FALSE  
statistics_level TYPICAL  
streams_pool_size 0  
tape_asynch_io TRUE  
thread 1  
timed_os_statistics 0  
timed_statistics TRUE  
trace_enabled TRUE  
transactions 2425  
transactions_per_rollback_segment 5  
undo_management AUTO  
undo_retention 10800  
undo_tablespace UNDOTBS1  
use_indirect_data_buffers FALSE  
user_dump_dest /oracle/app/oracle/admin/vam/udu  
workarea_size_policy AUTO  


Back to Top

Global Enqueue Statistics

 Value per Second (DB Time) per Second (Elapsed Time) per Trans
Statistic1st2nd1st2nd%Diff1st2nd%Diff1st2nd%Diff
dynamically allocated gcs resources 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
flow control messages received 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
flow control messages sent 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
gcs assume cvt 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
gcs assume no cvt 680,977 938,036 6.81 58.51 759.18 187.64 263.43 40.39 2.25 3.94 75.11
gcs ast xid 21 21 0.00 0.00 0.00 0.01 0.01 0.00 0.00 0.00 0.00
gcs blocked converts 333,300 376,322 3.33 23.47 604.80 91.84 105.68 15.07 1.10 1.58 43.64
gcs blocked cr converts 32,076 26,400 0.32 1.65 415.63 8.84 7.41 -16.18 0.11 0.11 0.00
gcs compatible basts 347 347 0.00 0.02 100.00 0.10 0.10 0.00 0.00 0.00 0.00
gcs compatible cr basts (global) 3,528 3,042 0.04 0.19 375.00 0.97 0.85 -12.37 0.01 0.01 0.00
gcs compatible cr basts (local) 504,226 756,039 5.04 47.16 835.71 138.94 212.32 52.81 1.66 3.17 90.96
gcs dbwr flush pi msgs 79,470 113,332 0.79 7.07 794.94 21.90 31.83 45.34 0.26 0.48 84.62
gcs dbwr write request msgs 40,470 73,787 0.40 4.60 1,050.00 11.15 20.72 85.83 0.13 0.31 138.46
gcs error msgs 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
gcs immediate (compatible) converts 4,042 1,009 0.04 0.06 50.00 1.11 0.28 -74.77 0.01 0.00 -100.00
gcs immediate (null) converts 318,446 271,214 3.18 16.92 432.08 87.75 76.17 -13.20 1.05 1.14 8.57
gcs immediate cr (compatible) converts 31 3 0.00 0.00 0.00 0.01 0.00 -100.00 0.00 0.00 0.00
gcs immediate cr (null) converts 4,361,611 99,173 43.60 6.19 -85.80 1,201.83 27.85 -97.68 14.39 0.42 -97.08
gcs indirect ast 283,651 211,784 2.84 13.21 365.14 78.16 59.48 -23.90 0.94 0.89 -5.32
gcs lms write request msgs 37,762 18,182 0.38 1.13 197.37 10.41 5.11 -50.91 0.12 0.08 -33.33
gcs msgs process time(ms) 309,340 203,603 3.09 12.70 311.00 85.24 57.18 -32.92 1.02 0.85 -16.67
gcs msgs received 9,540,409 3,330,542 95.37 207.73 117.81 2,628.83 935.32 -64.42 31.47 13.97 -55.61
gcs out-of-order msgs 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
gcs pings refused 55 27 0.00 0.00 0.00 0.02 0.01 -50.00 0.00 0.00 0.00
gcs pkey conflicts retry 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
gcs queued converts 4 29 0.00 0.00 0.00 0.00 0.01 100.00 0.00 0.00 0.00
gcs refuse xid 18 10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
gcs regular cr 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
gcs retry convert request 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
gcs side channel msgs actual 26,163 25,608 0.26 1.60 515.38 7.21 7.19 -0.28 0.09 0.11 22.22
gcs side channel msgs logical 329,277 377,988 3.29 23.58 616.72 90.73 106.15 17.00 1.09 1.59 45.87
gcs stale cr 6,463 488,558 0.06 30.47 50,683.33 1.78 137.20 7,607.87 0.02 2.05 10,150.00
gcs undo cr 122,763 125,290 1.23 7.81 534.96 33.83 35.19 4.02 0.40 0.53 32.50
gcs write notification msgs 4,621 10,068 0.05 0.63 1,160.00 1.27 2.83 122.83 0.02 0.04 100.00
gcs writes refused 66 81 0.00 0.01 100.00 0.02 0.02 0.00 0.00 0.00 0.00
ges msgs process time(ms) 3,068 2,866 0.03 0.18 500.00 0.85 0.80 -5.88 0.01 0.01 0.00
ges msgs received 117,095 110,094 1.17 6.87 487.18 32.27 30.92 -4.18 0.39 0.46 17.95
global posts queue time 47 7 0.00 0.00 0.00 0.01 0.00 -100.00 0.00 0.00 0.00
global posts queued 11 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
global posts requested 11 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
global posts sent 11 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
implicit batch messages received 527,920 166,546 5.28 10.39 96.78 145.47 46.77 -67.85 1.74 0.70 -59.77
implicit batch messages sent 42,693 48,925 0.43 3.05 609.30 11.76 13.74 16.84 0.14 0.21 50.00
messages flow controlled 16,018 13,385 0.16 0.83 418.75 4.41 3.76 -14.74 0.05 0.06 20.00
messages queue sent actual 329,103 810,063 3.29 50.52 1,435.56 90.68 227.49 150.87 1.09 3.40 211.93
messages queue sent logical 443,995 875,488 4.44 54.61 1,129.95 122.34 245.86 100.96 1.46 3.67 151.37
messages received actual 1,912,383 1,634,281 19.12 101.93 433.11 526.95 458.96 -12.90 6.31 6.86 8.72
messages received logical 9,661,359 3,441,272 96.58 214.64 122.24 2,662.15 966.41 -63.70 31.87 14.44 -54.69
messages sent directly 369,264 416,058 3.69 25.95 603.25 101.75 116.84 14.83 1.22 1.75 43.44
messages sent indirectly 343,225 850,794 3.43 53.07 1,447.23 94.57 238.93 152.65 1.13 3.57 215.93
messages sent not implicit batched 286,770 761,491 2.87 47.50 1,555.05 79.02 213.85 170.63 0.95 3.20 236.84
messages sent pbatched 4,600,717 818,018 45.99 51.02 10.94 1,267.71 229.72 -81.88 15.18 3.43 -77.40
msgs causing lmd to send msgs 36,126 36,170 0.36 2.26 527.78 9.95 10.16 2.11 0.12 0.15 25.00
msgs causing lms(s) to send msgs 463,061 535,522 4.63 33.40 621.38 127.59 150.39 17.87 1.53 2.25 47.06
msgs received queue time (ms) 206,644 63,325 2.07 3.95 90.82 56.94 17.78 -68.77 0.68 0.27 -60.29
msgs received queued 9,661,396 3,440,294 96.58 214.58 122.18 2,662.16 966.14 -63.71 31.87 14.44 -54.69
msgs sent queue time (ms) 23,163 28,836 0.23 1.80 682.61 6.38 8.10 26.96 0.08 0.12 50.00
msgs sent queue time on ksxp (ms) 412,461 440,817 4.12 27.49 567.23 113.65 123.79 8.92 1.36 1.85 36.03
msgs sent queued 391,400 871,120 3.91 54.33 1,289.51 107.85 244.64 126.83 1.29 3.66 183.72
msgs sent queued on ksxp 1,081,451 1,248,004 10.81 77.84 620.07 297.99 350.48 17.61 3.57 5.24 46.78
process batch messages received 524,406 157,163 5.24 9.80 87.02 144.50 44.14 -69.45 1.73 0.66 -61.85
process batch messages sent 494,346 575,666 4.94 35.91 626.92 136.22 161.66 18.68 1.63 2.42 48.47


Back to Top

Global CR Served Stats

 Value per Second (DB Time) per Second (Elapsed Time)
Statistic Name1st2nd1st2nd%Diff1st2nd%Diff
CR Block Requests 30,884 23,308 0.31 1.45 367.74 8.51 6.55 -23.03
CURRENT Block Requests 125,627 128,021 1.26 7.98 533.33 34.62 35.95 3.84
Data Block Requests 30,884 23,308 0.31 1.45 367.74 8.51 6.55 -23.03
Undo Block Requests 122,764 125,290 1.23 7.81 534.96 33.83 35.19 4.02
TX Block Requests 1,331 1,109 0.01 0.07 600.00 0.37 0.31 -16.22
Current Results 106,821 68,700 1.07 4.28 300.00 29.43 19.29 -34.45
Private Results 1 3 0.00 0.00 0.00 0.00 0.00 0.00
Zero Results 304 239 0.00 0.01 100.00 0.08 0.07 -12.50
Disk Read Results 49,383 82,386 0.49 5.14 948.98 13.61 23.14 70.02
Fail Results 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Fairness Down Converts 5,617 4,280 0.06 0.27 350.00 1.55 1.20 -22.58
Fairness Clears 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Free GC Elements 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Flushes 1,359 708 0.01 0.04 300.00 0.37 0.20 -45.95
Flushes Queued 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Flush Queue Full 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Flush Max Time (us) 0 0 0.00 0.00 0.00 0.00 0.00 0.00
Rejections 49,531 82,525 0.50 5.15 930.00 13.65 23.18 69.82
Errors 0 0 0.00 0.00 0.00 0.00 0.00 0.00


Back to Top

Global CURRENT Served Stats

 per Second (DB Time) per Second (Elapsed Time) Total Value % < 1ms % < 10ms % < 100ms % < 1000ms % < 10000ms
Statistic Name1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
Pins 7.95 66.16 732.20 219.27 297.89 35.86 795,781 1,060,757 99.98 99.99 0.00 0.00 0.02 0.01 0.00 0.00 0.00 0.00
Flushes 0.00 0.03 100.00 0.08 0.15 87.50 298 542 71.81 71.77 28.19 28.04 0.00 0.18 0.00 0.00 0.00 0.00
Writes 0.81 7.15 782.72 22.30 32.20 44.39 80,943 114,670 50.49 62.10 47.21 36.49 2.02 1.11 0.13 0.11 0.15 0.19


Back to Top

Global Cache Transfer Stats

  CR Blks/Sec (DB Time) Current Blks/Sec (DB Time) CR Blks CR Blks % Busy CR Blks % Congested Current Blks Current Blks % Busy Current Blks % Congested
Inst NoClass1st2nd%Diff1st2nd%Diff1st2nd1st2nd1st2nd1st2nd1st2nd1st2nd
2 Others 0.01 0.07 600.00 0.02 0.14 600.00 1,042 1,052 0.58 0.57 1.63 0.00 1,540 2,168 0.78 8.44 0.13 0.00
2 data block 0.24 1.29 437.50 2.33 18.32 686.27 24,098 20,620 6.78 8.19 0.05 0.08 233,489 293,678 0.16 0.15 0.01 0.00
2 undo header 0.02 0.08 300.00 0.00 0.01 100.00 1,639 1,325 1.04 3.02 0.00 0.00 165 112 0.00 2.68 0.00 0.00
2 undo block 0.02 0.09 350.00 0.00 0.00 0.00 1,880 1,458 0.27 0.34 0.00 0.00 0 0 0.00 0.00 0.00 0.00


Back to Top