kvamdb1$cat awrdiff_1_19654_1_19655.html
Snapshot Set | DB Name | DB Id | Instance | Inst num | Release | Cluster | Host |
---|---|---|---|---|---|---|---|
First (1st) | VAM | 2306309266 | vam1 | 1 | 10.2.0.4.0 | YES | kvamdb1 |
Second (2nd) | VAM | 2306309266 | vam1 | 1 | 10.2.0.4.0 | YES | kvamdb1 |
Snapshot Set | Begin Snap Id | Begin Snap Time | End Snap Id | End Snap Time | Elapsed Time (min) | DB Time (min) | Avg Active Users |
---|---|---|---|---|---|---|---|
1st | 19654 | 09-Feb-12 00:00:14 | 19655 | 09-Feb-12 01:00:43 | 60.49 | 1,667.27 | 27.56 |
2nd | 19655 | 09-Feb-12 01:00:43 | 19656 | 09-Feb-12 02:00:04 | 59.35 | 267.22 | 4.42 |
Configuration Comparison
1st | 2nd | %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: | AUTO | AUTO |
Load Profile
1st Per Sec | 2nd Per Sec | %Diff | 1st Per Txn | 2nd 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 |
1st | 2nd | Diff | |
---|---|---|---|
% 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
1st | 2nd | ||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Waits | Time(s) | Percent Total DB Time | Wait Class | Event | Waits | Time(s) | Percent Total DB Time | Wait Class |
CPU time | 84,712.1 | 84.68 | CPU time | 14,719.9 | 91.81 | ||||
Backup: sbtwrite2 | 369,587 | 7,112.3 | 7.11 | Administrativ | Backup: sbtwrite2 | 349,815 | 6,651.1 | 41.48 | Administrativ |
Backup: sbtbackup | 6 | 2,284.5 | 2.28 | Administrativ | Backup: sbtbackup | 3 | 3,002.2 | 18.73 | Administrativ |
db file sequential read | 413,705 | 1,032.5 | 1.03 | User I/O | db file sequential read | 121,626 | 682.3 | 4.26 | User I/O |
*SQL*Net more data from client | 489,091 | 588.8 | .59 | Network | *SQL*Net more data to client | 9,893,020 | 281.5 | 1.76 | Network |
-SQL*Net more data to client | 10,857,486 | 324.8 | .32 | Network | -SQL*Net more data from client | 525,991 | 62.5 | .39 | Network |
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.
Begin | End | |
---|---|---|
1st Number of Instances: | 2 | 2 |
2nd Number of Instances: | 2 | 2 |
Global Cache Load Profile
1st Per Second | 2nd Per Second | %Diff | 1st Per Txn | 2nd 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%)
First | Second | Diff | |
---|---|---|---|
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
First | Second | %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 |
First | Second | Diff | |
---|---|---|---|
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
First | Second | %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 |
First | Second | Diff | |
---|---|---|---|
% 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 |
% DB Time | # Waits/sec (Elapsed Time) | Avg Wait Time (ms) | |||||||
---|---|---|---|---|---|---|---|---|---|
Event | 1st | 2nd | Diff | 1st | 2nd | %Diff | 1st | 2nd | %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 |
% DB Time | Time (seconds) | Time per Trans (seconds) | ||||||
---|---|---|---|---|---|---|---|---|
Statistic Name | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | %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 |
Value | per Second (DB Time) | per Second (Elapsed Time) | per Trans | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Statistic Name | 1st | 2nd | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %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 |
% DB Time | % CPU Time | % Physical Reads | % Logical Reads | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Service Name | 1st | 2nd | Diff | 1st | 2nd | Diff | 1st | 2nd | Diff | 1st | 2nd | Diff |
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
% CR Blks Received | % Current Blks Received | |||||
---|---|---|---|---|---|---|
Service Name | 1st | 2nd | Diff | 1st | 2nd | Diff |
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
Exec Time % of DB Time | Exec Time (ms) / Exec | #Exec/sec (DB Time) | CPU Time (ms) / Exec | Physical Reads / Exec | #Rows Processed / Exec | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | Multiple Plans | SQL 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
CPU Time % of DB Time | CPU Time (ms) / Exec | #Exec/sec (DB Time) | Exec Time (ms) / Exec | Physical Reads / Exec | #Rows Processed / Exec | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | Multiple Plans | SQL 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
% Total Gets | Gets / Exec | #Executions | Exec Time (ms) / Exec | CPU Time (ms) / Exec | Physical Reads / Exec | #Rows Processed / Exec | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | Multiple Plans | SQL 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
% Total Physical Reads | Physical Reads / Exec | #Executions | Exec Time (ms) / Exec | CPU Time (ms) / Exec | #Rows Processed / Exec | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | Multiple Plans | SQL 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
#Executions/sec (DB Time) | #Executions | Exec Time (ms) / Exec | CPU Time (ms) / Exec | Physical Reads / Exec | #Rows Processed / Exec | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | Multiple Plans | SQL 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
% Total Parses | Parses | #Executions | |||||||
---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | Multiple Plans | SQL 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
Back to SQL Statistics
Back to Top
Value | per Second (DB Time) | per Second (Elapsed Time) | per Trans | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Statistic | 1st | 2nd | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %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
Value | per Second (DB Time) | per Second (Elapsed Time) | per Trans | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Statistic | 1st | 2nd | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %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
Avg Reads / Sec | Avg Writes / Sec | Reads | Avg Read Time (ms) | Avg Blocks / Read | Writes | Buffer Waits | Avg Buf Wait Time (ms) | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Tablespace | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd |
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 |
No data exists for this section of the report.
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) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Tablespace | Filename | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd |
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 |
No data exists for this section of the report.
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 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
1st | 2nd | Diff | 1st | 2nd | %Diff | 1st | 2nd | 1st | 2nd | %Diff | 1st | 2nd |
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(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 Mem | Global 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 Time % DB Time | Total Wait Time (s) | # Waits | Avg Wait Time (ms) | |||||||
---|---|---|---|---|---|---|---|---|---|---|
Class | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | %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
Wait Time % of DB Time | Wait Time | Requests | Successful Gets | Failed Gets | Waits | Avg Wait Time (ms) | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Enqueue Type (Request Reason) | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd |
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
% of Total Sleeps | Get Requests | Misses | Spin Gets | Sleeps | Sleep1 | Sleep2 | Sleep3 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Latch Name | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd |
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 |
% of Total Logical Reads | Logical Reads | ||||||||
---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 2nd | Diff | 1st | 2nd |
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
% of Total Physical Reads | Physical Reads | ||||||||
---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 2nd | Diff | 1st | 2nd |
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
Row Lock Waits | % of Captured | ||||||||
---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 2nd | 1st | 2nd | Diff |
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
ITL Waits | % of Captured | ||||||||
---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 2nd | 1st | 2nd | Diff |
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
% of Total Buffer Waits | Buffer Busy Waits | ||||||||
---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 2nd | Diff | 1st | 2nd |
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
% of Total CR Blocks Received | CR Blocks Received | ||||||||
---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 2nd | Diff | 1st | 2nd |
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
% of Total Current Blocks Received | Current Blocks Received | ||||||||
---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 2nd | Diff | 1st | 2nd |
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
Get Requests / Sec (DB Time) | Get Requests / Sec (Elapsed Time) | Get Requests | Pct Miss | Scan Requests | Pct Miss | Mod Reqs | Final Usage | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cache | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd |
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
GES Requests / Sec (DB Time) | GES Requests / Sec (Elapsed Time) | GES Requests | Conflicts % Requests | Releases % Requests | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cache | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | 1st | 2nd | Diff | 1st | 2nd | Diff |
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
Get Requests / Sec (DB Time) | Get Requests / Sec (Elapsed Time) | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invalidations | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Namespace | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd |
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
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 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Namespace | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd |
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
Size (KB) | ||
---|---|---|
SGA regions | 1st | 2nd |
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
1st | 2nd | ||||||||
---|---|---|---|---|---|---|---|---|---|
Pool | Name | Begin Value | End Value | %Diff | Begin Value | End 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
Parameter Name | 1st End Snap Value | 2nd 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 |
Value | per Second (DB Time) | per Second (Elapsed Time) | per Trans | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Statistic | 1st | 2nd | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %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 |
Value | per Second (DB Time) | per Second (Elapsed Time) | ||||||
---|---|---|---|---|---|---|---|---|
Statistic Name | 1st | 2nd | 1st | 2nd | %Diff | 1st | 2nd | %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 |
per Second (DB Time) | per Second (Elapsed Time) | Total Value | % < 1ms | % < 10ms | % < 100ms | % < 1000ms | % < 10000ms | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Statistic Name | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd |
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 |
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 No | Class | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd |
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 |