Snapshot Set | DB Name | DB Id | Instance | Inst num | Release | Cluster | Host | Std Block Size |
---|---|---|---|---|---|---|---|---|
First (1st) | DBM11203 | 2532911053 | DBM11203 | 1 | 11.2.0.3.0 | NO | helicon | 8192 |
Second (2nd) | DBM11203 | 2532911053 | DBM11203 | 1 | 11.2.0.3.0 | NO | helicon | 8192 |
Snapshot Set | Begin Snap Id | Begin Snap Time | End Snap Id | End Snap Time | Avg Active Users | Elapsed Time (min) | DB time (min) |
---|---|---|---|---|---|---|---|
1st | 1822 | 23-Apr-14 18:30:05 (Wed) | 1823 | 23-Apr-14 18:45:06 (Wed) | 7.1 | 15.0 | 106.7 |
2nd | 1826 | 23-Apr-14 19:30:10 (Wed) | 1827 | 23-Apr-14 19:45:13 (Wed) | 14.0 | 15.0 | 210.2 |
%Diff | 96.8 | 0.1 | 96.9 |
1st | 2nd | Diff | %Diff | |
---|---|---|---|---|
Number of CPUs: | 8 | 8 | 0 | 0.0 |
Number of CPU Cores: | 8 | 8 | 0 | 0.0 |
Number of CPU Sockets: | 2 | 2 | 0 | 0.0 |
Physical Memory: | 7974.6M | 7974.6M | 0M | 0.0 |
Load at Start Snapshot: | 6.93 | 8.37 | 1.44 | 20.8 |
Load at End Snapshot: | 7.23 | 14.07 | 6.84 | 94.6 |
%User Time: | 23.79 | 39.62 | 15.83 | 66.5 |
%System Time: | .89 | 1.43 | .54 | 60.7 |
%Idle Time: | 74.79 | 58.14 | -16.65 | -22.3 |
%IO Wait Time: | 21.81 | 30.48 | 8.67 | 39.8 |
1st (M) | 2nd (M) | Diff (M) | %Diff | |
---|---|---|---|---|
Memory Target | ||||
SGA Target | 1,024.0 | 1,024.0 | 0.0 | 0.0 |
Buffer Cache | 728.0 | 728.0 | 0.0 | 0.0 |
Shared Pool | 260.0 | 260.0 | 0.0 | 0.0 |
Large Pool | 8.0 | 8.0 | 0.0 | 0.0 |
Java Pool | 4.0 | 4.0 | 0.0 | 0.0 |
Streams Pool | 8.0 | 8.0 | 0.0 | 0.0 |
PGA Target | 128.0 | 128.0 | 0.0 | 0.0 |
Log Buffer | 7.8 | 7.8 | 0.0 | 0.0 |
1st per sec | 2nd per sec | %Diff | 1st per txn | 2nd per txn | %Diff | |
---|---|---|---|---|---|---|
DB time: | 7.1 | 14.0 | 96.8 | 0.0 | 0.0 | 66.7 |
CPU time: | 1.9 | 3.2 | 68.8 | 0.0 | 0.0 | 0.0 |
Redo size: | 393,267.0 | 552,173.5 | 40.4 | 1,931.8 | 1,933.1 | 0.1 |
Logical reads: | 406,407.8 | 649,091.1 | 59.7 | 1,996.3 | 2,272.4 | 13.8 |
Block changes: | 2,827.7 | 3,948.6 | 39.6 | 13.9 | 13.8 | -0.5 |
Physical reads: | 580.0 | 857.4 | 47.8 | 2.8 | 3.0 | 5.3 |
Physical writes: | 377.6 | 578.1 | 53.1 | 1.9 | 2.0 | 9.2 |
User calls: | 2,896.4 | 4,051.3 | 39.9 | 14.2 | 14.2 | -0.4 |
Parses: | 0.5 | 1.6 | 189.1 | 0.0 | 0.0 | 100.0 |
Hard parses: | 0.0 | 0.4 | 3,600.0 | 0.0 | 0.0 | 0.0 |
W/A MB processed: | 82,999.0 | 85,027.5 | 2.4 | 407.7 | 297.7 | 2.4 |
Logons: | 0.0 | 0.0 | 200.0 | 0.0 | 0.0 | 0.0 |
Executes: | 1,364.7 | 1,914.2 | 40.3 | 6.7 | 6.7 | 0.0 |
Transactions: | 203.6 | 285.6 | 40.3 |
1st | 2nd | Diff | |
---|---|---|---|
% Blocks changed per Read: | 0.7 | 0.6 | -0.1 |
Recursive Call %: | 6.9 | 7.3 | 0.4 |
Rollback per transaction %: | 0.0 | 0.0 | 0.0 |
Rows per Sort: | 36.7 | 13.0 | -23.7 |
Avg DB time per Call (sec): | 0.0 | 0.0 | 0.0 |
1st | 2nd | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Event | Wait Class | Waits | Time(s) | Avg Time(ms) | %DB time | Event | Wait Class | Waits | Time(s) | Avg Time(ms) | %DB time |
db file sequential read | User I/O | 521,361 | 4,574.96 | 8.78 | 71.43 | db file sequential read | User I/O | 772,553 | 9,350.50 | 12.10 | 74.14 |
CPU time | 1,701.44 | 26.57 | CPU time | 2,876.51 | 22.81 | ||||||
log file sync | Commit | 182,739 | 94.43 | 0.52 | 1.47 | log file sync | Commit | 256,684 | 266.83 | 1.04 | 2.12 |
log file parallel write | System I/O | 178,857 | 38.82 | 0.22 | 0.61 | log file parallel write | System I/O | 242,510 | 104.96 | 0.43 | 0.83 |
read by other session | User I/O | 2,754 | 27.00 | 9.81 | 0.42 | read by other session | User I/O | 4,219 | 51.49 | 12.21 | 0.41 |
% of DB time | Time (seconds) | Time per Trans (seconds) | |||||||
---|---|---|---|---|---|---|---|---|---|
Statistic Name | 1st | 2nd | Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff |
DB time | 100.00 | 100.00 | 0.00 | 6,404.55 | 12,612.51 | 96.93 | 0.03 | 0.05 | 66.67 |
DB CPU | 26.57 | 22.81 | -3.76 | 1,701.44 | 2,876.51 | 69.06 | 0.01 | 0.01 | 0.00 |
sql execute elapsed time | 95.47 | 95.34 | -0.13 | 6,114.42 | 12,024.64 | 96.66 | 0.03 | 0.05 | 66.67 |
connection management call elapsed time | 0.00 | 0.06 | 0.06 | 0.00 | 7.39 | 100.00 | 0.00 | 0.00 | 0.00 |
parse time elapsed | 0.42 | 0.45 | 0.03 | 26.87 | 57.06 | 112.36 | 0.00 | 0.00 | 0.00 |
hard parse elapsed time | 0.00 | 0.03 | 0.03 | 0.00 | 3.63 | 100.00 | 0.00 | 0.00 | 0.00 |
hard parse (sharing criteria) elapsed time | 0.00 | 0.00 | 0.00 | 0.00 | 0.47 | 100.00 | 0.00 | 0.00 | 0.00 |
hard parse (bind mismatch) elapsed time | 0.00 | 0.00 | 0.00 | 0.00 | 0.46 | 100.00 | 0.00 | 0.00 | 0.00 |
PL/SQL compilation elapsed time | 0.00 | 0.00 | 0.00 | 0.00 | 0.26 | 100.00 | 0.00 | 0.00 | 0.00 |
sequence load elapsed time | 0.00 | 0.00 | -0.00 | 0.09 | 0.00 | -100.00 | 0.00 | 0.00 | 0.00 |
PL/SQL execution elapsed time | 0.00 | 0.00 | 0.00 | 0.00 | 0.01 | 100.00 | 0.00 | 0.00 | 0.00 |
repeated bind elapsed time | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 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 | 0.00 |
RMAN cpu time (backup/restore) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
failed parse (out of shared memory) elapsed time | 0.00 | 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 | 0.00 |
inbound PL/SQL rpc elapsed time | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
background cpu time | 0.60 | 0.49 | -0.11 | 38.73 | 62.12 | 60.39 | 0.00 | 0.00 | 0.00 |
background elapsed time | 1.68 | 1.76 | 0.08 | 107.51 | 221.86 | 106.36 | 0.00 | 0.00 | 0.00 |
Value (centi-seconds) | per Second (DB time) | per Second (Elapsed Time) | per Trans | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Statistic Name | 1st | 2nd | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff |
BUSY_TIME | 176,851 | 297,133 | 27.61 | 23.56 | -14.67 | 196.16 | 329.10 | 67.77 | 0.96 | 1.15 | 19.79 |
GLOBAL_RECEIVE_SIZE_MAX | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
GLOBAL_SEND_SIZE_MAX | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
IDLE_TIME | 524,631 | 412,759 | 81.92 | 32.73 | -60.05 | 581.92 | 457.17 | -21.44 | 2.86 | 1.60 | -44.06 |
IOWAIT_TIME | 152,976 | 216,362 | 23.89 | 17.15 | -28.21 | 169.68 | 239.64 | 41.23 | 0.83 | 0.84 | 1.20 |
NICE_TIME | 35 | 99 | 0.01 | 0.01 | 0.00 | 0.04 | 0.11 | 175.00 | 0.00 | 0.00 | 0.00 |
RSRC_MGR_CPU_WAIT_TIME | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
SYS_TIME | 6,268 | 10,170 | 0.98 | 0.81 | -17.35 | 6.95 | 11.26 | 62.01 | 0.03 | 0.04 | 33.33 |
TCP_RECEIVE_SIZE_DEFAULT | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
TCP_RECEIVE_SIZE_MAX | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
TCP_RECEIVE_SIZE_MIN | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
TCP_SEND_SIZE_DEFAULT | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
TCP_SEND_SIZE_MAX | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
TCP_SEND_SIZE_MIN | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
USER_TIME | 166,878 | 281,270 | 26.06 | 22.30 | -14.43 | 185.10 | 311.54 | 68.31 | 0.91 | 1.09 | 19.78 |
VM_IN_BYTES | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
VM_OUT_BYTES | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
% of DB time | # Waits/sec (Elapsed Time) | Total Wait Time (sec) | Avg Wait Time (ms) | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Wait Class | 1st | 2nd | Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff |
User I/O | 71.89 | 74.56 | 2.67 | 581.65 | 860.76 | 47.99 | 4,604.22 | 9,403.75 | 104.24 | 8.78 | 12.10 | 37.81 |
Commit | 1.47 | 2.12 | 0.64 | 202.69 | 284.30 | 40.26 | 94.43 | 266.83 | 182.57 | 0.52 | 1.04 | 100.00 |
System I/O | 0.92 | 1.14 | 0.22 | 231.77 | 318.93 | 37.61 | 58.80 | 143.21 | 143.55 | 0.28 | 0.50 | 78.57 |
Concurrency | 0.01 | 0.09 | 0.08 | 1.18 | 3.03 | 156.78 | 0.86 | 11.54 | 1,241.86 | 0.81 | 4.21 | 419.75 |
Configuration | 0.08 | 0.15 | 0.08 | 0.19 | 0.47 | 147.37 | 4.92 | 19.20 | 290.24 | 28.42 | 45.71 | 60.84 |
Network | 0.04 | 0.03 | -0.01 | 1,573.36 | 2,200.07 | 39.83 | 2.48 | 3.83 | 54.44 | 0.00 | 0.00 | 0.00 |
Application | 0.01 | 0.02 | 0.00 | 0.76 | 1.36 | 78.95 | 0.80 | 2.20 | 175.00 | 1.17 | 1.79 | 52.99 |
Other | 0.01 | 0.01 | 0.00 | 1.82 | 4.10 | 125.27 | 0.47 | 1.24 | 163.83 | 0.28 | 0.33 | 17.86 |
% of DB time | # Waits/sec (Elapsed Time) | Total Wait Time (sec) | Avg Wait Time (ms) | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Event | Wait Class | 1st | 2nd | Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff |
db file sequential read | User I/O | 71.43 | 74.14 | 2.70 | 578.29 | 855.68 | 47.97 | 4,574.96 | 9,350.50 | 104.38 | 8.78 | 12.10 | 37.81 |
log file sync | Commit | 1.47 | 2.12 | 0.64 | 202.69 | 284.30 | 40.26 | 94.43 | 266.83 | 182.57 | 0.52 | 1.04 | 100.00 |
log file parallel write | System I/O | 0.61 | 0.83 | 0.23 | 198.39 | 268.60 | 35.39 | 38.82 | 104.96 | 170.38 | 0.22 | 0.43 | 95.45 |
cursor: pin S wait on X | Concurrency | 0.00 | 0.06 | 0.06 | 0.00 | 0.08 | 100.00 | 0.00 | 7.66 | 100.00 | 0.00 | 103.51 | 100.00 |
log file switch (private strand flush incomplete) | Configuration | 0.04 | 0.10 | 0.06 | 0.11 | 0.29 | 163.64 | 2.44 | 12.05 | 393.85 | 24.44 | 45.32 | 85.43 |
db file parallel write | System I/O | 0.22 | 0.18 | -0.04 | 27.90 | 43.49 | 55.88 | 14.37 | 22.91 | 59.43 | 0.57 | 0.58 | 1.75 |
control file sequential read | System I/O | 0.08 | 0.11 | 0.03 | 2.97 | 3.14 | 5.72 | 5.26 | 14.40 | 173.76 | 1.96 | 5.08 | 159.18 |
log file switch (checkpoint incomplete) | Configuration | 0.04 | 0.06 | 0.02 | 0.08 | 0.16 | 100.00 | 2.47 | 7.03 | 184.62 | 33.87 | 47.50 | 40.24 |
db file scattered read | User I/O | 0.02 | 0.01 | -0.02 | 0.13 | 0.10 | -23.08 | 1.50 | 0.97 | -35.33 | 12.39 | 11.05 | -10.82 |
read by other session | User I/O | 0.42 | 0.41 | -0.01 | 3.05 | 4.67 | 53.11 | 27.00 | 51.49 | 90.70 | 9.81 | 12.21 | 24.46 |
SQL*Net message to client | Network | 0.04 | 0.03 | -0.01 | 1,573.36 | 2,200.07 | 39.83 | 2.48 | 3.83 | 54.44 | 0.00 | 0.00 | 0.00 |
library cache lock | Concurrency | 0.00 | 0.01 | 0.01 | 0.00 | 0.06 | 100.00 | 0.00 | 1.04 | 100.00 | 0.00 | 20.73 | 100.00 |
enq: TX - row lock contention | Application | 0.01 | 0.02 | 0.00 | 0.76 | 1.36 | 78.95 | 0.80 | 2.20 | 175.00 | 1.17 | 1.79 | 52.99 |
library cache load lock | Concurrency | 0.00 | 0.00 | 0.00 | 0.00 | 0.03 | 100.00 | 0.00 | 0.52 | 100.00 | 0.00 | 19.15 | 100.00 |
db file parallel read | User I/O | 0.01 | 0.00 | -0.00 | 0.05 | 0.03 | -40.00 | 0.39 | 0.30 | -23.08 | 9.61 | 10.65 | 10.82 |
library cache: mutex X | Concurrency | 0.00 | 0.00 | 0.00 | 0.04 | 0.24 | 500.00 | 0.01 | 0.47 | 4,600.00 | 0.37 | 2.15 | 481.08 |
os thread startup | Concurrency | 0.01 | 0.00 | -0.00 | 0.01 | 0.01 | 0.00 | 0.42 | 0.42 | 0.00 | 35.37 | 38.11 | 7.75 |
kksfbc child completion | Other | 0.00 | 0.00 | 0.00 | 0.00 | 0.01 | 100.00 | 0.00 | 0.31 | 100.00 | 0.00 | 51.10 | 100.00 |
enq: TX - index contention | Concurrency | 0.00 | 0.00 | 0.00 | 0.01 | 0.04 | 300.00 | 0.11 | 0.51 | 363.64 | 15.51 | 16.06 | 3.55 |
latch: cache buffers chains | Concurrency | 0.00 | 0.00 | 0.00 | 0.50 | 1.49 | 198.00 | 0.06 | 0.34 | 466.67 | 0.12 | 0.25 | 108.33 |
direct path read | User I/O | 0.01 | 0.00 | -0.00 | 0.02 | 0.04 | 100.00 | 0.35 | 0.47 | 34.29 | 19.19 | 14.53 | -24.28 |
cursor: pin S | Concurrency | 0.00 | 0.00 | 0.00 | 0.03 | 0.07 | 133.33 | 0.05 | 0.27 | 440.00 | 1.95 | 4.20 | 115.38 |
control file parallel write | System I/O | 0.00 | 0.00 | 0.00 | 0.68 | 0.73 | 7.35 | 0.10 | 0.35 | 250.00 | 0.17 | 0.53 | 211.76 |
buffer busy waits | Concurrency | 0.00 | 0.00 | -0.00 | 0.42 | 0.71 | 69.05 | 0.19 | 0.23 | 21.05 | 0.49 | 0.36 | -26.53 |
LGWR wait for redo copy | Other | 0.00 | 0.00 | 0.00 | 0.92 | 2.92 | 217.39 | 0.05 | 0.23 | 360.00 | 0.07 | 0.09 | 28.57 |
ASM file metadata operation | Other | 0.00 | 0.00 | -0.00 | 0.60 | 0.60 | 0.00 | 0.22 | 0.31 | 40.91 | 0.40 | 0.57 | 42.50 |
enq: HW - contention | Configuration | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.11 | 100.00 | 0.00 | 28.21 | 100.00 |
log file sequential read | System I/O | 0.00 | 0.00 | 0.00 | 0.05 | 0.06 | 20.00 | 0.24 | 0.57 | 137.50 | 5.38 | 10.23 | 90.15 |
enq: JS - queue lock | Other | 0.00 | 0.00 | -0.00 | 0.00 | 0.00 | 0.00 | 0.05 | 0.00 | -100.00 | 50.56 | 0.00 | -100.00 |
latch free | Other | 0.00 | 0.00 | 0.00 | 0.08 | 0.23 | 187.50 | 0.02 | 0.15 | 650.00 | 0.34 | 0.71 | 108.82 |
enq: TX - contention | Other | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.07 | 100.00 | 0.00 | 69.44 | 100.00 |
ADR block file read | Other | 0.00 | 0.00 | -0.00 | 0.02 | 0.02 | 0.00 | 0.09 | 0.11 | 22.22 | 5.43 | 6.61 | 21.73 |
row cache lock | Concurrency | 0.00 | 0.00 | 0.00 | 0.00 | 0.01 | 100.00 | 0.00 | 0.03 | 100.00 | 0.00 | 2.69 | 100.00 |
latch: shared pool | Concurrency | 0.00 | 0.00 | 0.00 | 0.00 | 0.01 | 100.00 | 0.00 | 0.02 | 100.00 | 0.00 | 1.99 | 100.00 |
reliable message | Other | 0.00 | 0.00 | -0.00 | 0.10 | 0.06 | -40.00 | 0.01 | 0.01 | 0.00 | 0.14 | 0.18 | 28.57 |
latch: object queue header operation | Other | 0.00 | 0.00 | 0.00 | 0.02 | 0.06 | 200.00 | 0.00 | 0.02 | 100.00 | 0.25 | 0.31 | 24.00 |
latch: redo allocation | Other | 0.00 | 0.00 | 0.00 | 0.01 | 0.05 | 400.00 | 0.00 | 0.01 | 100.00 | 0.15 | 0.28 | 86.67 |
latch: In memory undo latch | Concurrency | 0.00 | 0.00 | 0.00 | 0.17 | 0.28 | 64.71 | 0.02 | 0.05 | 150.00 | 0.12 | 0.18 | 50.00 |
Disk file operations I/O | User I/O | 0.00 | 0.00 | 0.00 | 0.09 | 0.22 | 144.44 | 0.01 | 0.02 | 100.00 | 0.07 | 0.08 | 14.29 |
ADR block file write | Other | 0.00 | 0.00 | -0.00 | 0.01 | 0.01 | 0.00 | 0.00 | 0.00 | 0.00 | 0.66 | 0.49 | -25.76 |
latch: cache buffers lru chain | Other | 0.00 | 0.00 | 0.00 | 0.01 | 0.02 | 100.00 | 0.00 | 0.01 | 100.00 | 0.09 | 0.25 | 177.78 |
enq: CU - contention | Other | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.65 | 100.00 |
direct path write | User I/O | 0.00 | 0.00 | 0.00 | 0.01 | 0.03 | 200.00 | 0.00 | 0.01 | 100.00 | 0.14 | 0.24 | 71.43 |
CSS initialization | Other | 0.00 | 0.00 | -0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.01 | 100.00 | 4.73 | 6.63 | 40.17 |
latch: enqueue hash chains | Other | 0.00 | 0.00 | 0.00 | 0.02 | 0.03 | 50.00 | 0.00 | 0.01 | 100.00 | 0.23 | 0.31 | 34.78 |
latch: row cache objects | Concurrency | 0.00 | 0.00 | 0.00 | 0.00 | 0.01 | 100.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.28 | 100.00 |
log file single write | System I/O | 0.00 | 0.00 | -0.00 | 0.05 | 0.06 | 20.00 | 0.00 | 0.01 | 100.00 | 0.08 | 0.10 | 25.00 |
db file async I/O submit | System I/O | 0.00 | 0.00 | -0.00 | 1.72 | 2.84 | 65.12 | 0.00 | 0.01 | 100.00 | 0.00 | 0.00 | 0.00 |
latch: redo writing | Configuration | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.35 | 100.00 |
CSS operation: action | Other | 0.00 | 0.00 | -0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.01 | 1.64 | 62.38 |
latch: session allocation | Other | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.17 | 100.00 |
CSS operation: query | Other | 0.00 | 0.00 | -0.00 | 0.01 | 0.01 | 0.00 | 0.00 | 0.00 | 0.00 | 0.09 | 0.12 | 33.33 |
latch: undo global data | Other | 0.00 | 0.00 | -0.00 | 0.00 | 0.01 | 100.00 | 0.00 | 0.00 | 0.00 | 0.23 | 0.18 | -21.74 |
latch: checkpoint queue latch | Other | 0.00 | 0.00 | -0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.13 | 0.04 | -69.23 |
latch: messages | Other | 0.00 | 0.00 | -0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.17 | 0.19 | 11.76 |
ADR file lock | Other | 0.00 | 0.00 | -0.00 | 0.01 | 0.01 | 0.00 | 0.00 | 0.00 | 0.00 | 0.01 | 0.01 | 0.00 |
asynch descriptor resize | Other | 0.00 | 0.00 | 0.00 | 0.03 | 0.07 | 133.33 | 0.00 | 0.00 | 0.00 | 0.01 | 0.01 | 0.00 |
SQL*Net message from client | Idle | 252.02 | 180.99 | -71.03 | 1,573.36 | 2,200.09 | 39.83 | 16,140.84 | 22,827.07 | 41.42 | 11.38 | 11.49 | 0.97 |
Space Manager: slave idle wait | Idle | 45.83 | 17.09 | -28.75 | 0.67 | 0.50 | -25.37 | 2,935.29 | 2,154.86 | -26.59 | 4,835.74 | 4,777.96 | -1.19 |
class slave wait | Idle | 56.30 | 28.71 | -27.60 | 0.26 | 0.30 | 15.38 | 3,605.79 | 3,620.46 | 0.41 | 15,343.79 | 13,559.77 | -11.63 |
DIAG idle wait | Idle | 28.14 | 14.36 | -13.78 | 2.00 | 2.00 | 0.00 | 1,801.98 | 1,810.58 | 0.48 | 1,001.10 | 1,001.43 | 0.03 |
Streams AQ: qmn slave idle wait | Idle | 14.10 | 7.15 | -6.95 | 0.14 | 0.14 | 0.00 | 903.19 | 902.13 | -0.12 | 7,001.47 | 6,993.22 | -0.12 |
Streams AQ: qmn coordinator idle wait | Idle | 14.10 | 7.15 | -6.95 | 0.33 | 0.32 | -3.03 | 903.25 | 902.28 | -0.11 | 3,000.84 | 3,111.31 | 3.68 |
wait for unread message on broadcast channel | Idle | 14.07 | 7.18 | -6.89 | 1.00 | 1.00 | 0.00 | 900.98 | 905.37 | 0.49 | 1,001.09 | 1,001.52 | 0.04 |
ASM background timer | Idle | 14.05 | 7.18 | -6.87 | 0.20 | 0.20 | 0.00 | 900.07 | 905.51 | 0.60 | 5,000.41 | 5,002.80 | 0.05 |
jobq slave wait | Idle | 0.94 | 0.48 | -0.46 | 0.13 | 0.13 | 0.00 | 60.12 | 60.12 | 0.00 | 501.02 | 500.98 | -0.01 |
KSV master wait | Idle | 0.00 | 0.00 | -0.00 | 0.08 | 0.10 | 25.00 | 0.01 | 0.01 | 0.00 | 0.09 | 0.13 | 44.44 |
% of DB time | % CPU Time | % Physical Reads | % Logical Reads | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Service Name | 1st | 2nd | Diff | 1st | 2nd | Diff | 1st | 2nd | Diff | 1st | 2nd | Diff |
DBM11203.antognini.ch | 99.89 | 99.73 | -0.16 | 100.02 | 99.79 | -0.23 | 99.42 | 99.46 | 0.04 | 100.08 | 99.94 | -0.14 |
SYS$USERS | 0.10 | 0.08 | -0.02 | 0.04 | 0.05 | 0.01 | 0.10 | 0.11 | 0.01 | 0.00 | 0.00 | 0.00 |
SYS$BACKGROUND | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.46 | 0.31 | -0.15 | 0.00 | 0.01 | 0.00 |
% CR Blks Received | % Current Blks Received | ||||||
---|---|---|---|---|---|---|---|
Service Name | 1st | 2nd | Diff | 1st | 2nd | Diff | Total Diff |
DBM11203.antognini.ch | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
SYS$BACKGROUND | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
SYS$USERS | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
Elapsed Time % of DB time | Elapsed Time (ms) per Exec | #Exec/sec (DB time) | CPU Time (ms) per Exec | I/O Time (ms) per Exec | Physical Reads per Exec | #Rows Processed per Exec | #Executions | #Plans | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st/2nd/Both | SQL Text |
9bz9sa0abpc48 | 6.24 | 6.24 | -6.24 | 27 | 2.29 | 1 | 27 | 3.21 | 1.00 | 14,671 | insert into customers (custome... | ||||||||||
g8rhybcumtwd6 | 21.09 | 27.33 | 18.35 | 18.35 | -2.74 | 191 | 222 | 1.11 | 0.83 | 175 | 205 | 13 | 11 | 1.10 | 0.63 | 9.99 | 9.99 | 7,086 | 10,442 | 1/ 1/ 1 | SELECT /*+ first_rows index(cu... |
8vvvyuun2urt6 | 9.17 | 36.49 | 10.52 | 28.88 | 1.36 | 6 | 9 | 16.43 | 11.66 | 0 | 0 | 5 | 9 | 0.65 | 0.76 | 1.00 | 1.00 | 105,252 | 147,058 | insert into order_items(ORDER_... | |
5g00dq4fxwnsw | 6.77 | 43.27 | 8.02 | 36.89 | 1.24 | 4 | 7 | 16.43 | 11.66 | 0 | 0 | 4 | 7 | 0.46 | 0.56 | 0.90 | 0.90 | 105,254 | 147,054 | 1/ 1/ 1 | update inventories set quantit... |
2yp5w5a36s5xv | 1.63 | 44.90 | 2.56 | 39.46 | 0.93 | 3 | 6 | 5.75 | 4.12 | 0 | 0 | 3 | 6 | 0.30 | 0.50 | 1.00 | 1.00 | 36,853 | 51,945 | 1/ 1/ 1 | update orders set order_mode =... |
82ud5h0qcg0bf | 29.09 | 73.99 | 28.75 | 68.20 | -0.34 | 15 | 21 | 19.50 | 13.97 | 0 | 0 | 15 | 20 | 1.56 | 1.54 | 1.00 | 1.00 | 124,882 | 176,182 | 1/ 1/ 1 | select customer_id, cust_first... |
gyk686gnaygs2 | 0.82 | 74.80 | 0.67 | 68.87 | -0.15 | 0 | 0 | 34.42 | 24.67 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 5.03 | 5.03 | 220,441 | 311,130 | 1/ 1/ 1 | select product_id, product_nam... |
9zd49du11u7cf | 10.18 | 84.98 | 10.23 | 79.10 | 0.05 | 18 | 25 | 5.75 | 4.12 | 1 | 1 | 17 | 24 | 1.92 | 1.93 | 1.00 | 1.00 | 36,852 | 51,948 | insert into orders(ORDER_ID, O... | |
gshgncvvtv0c6 | 0.36 | 85.35 | 0.34 | 79.44 | -0.03 | 0 | 0 | 19.50 | 13.97 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 1.00 | 1.00 | 124,883 | 176,186 | insert into logon values(:1 , ... | |
gfqas5ahy1x56 | 0.69 | 86.04 | 0.67 | 80.11 | -0.02 | 1 | 2 | 5.75 | 4.12 | 0 | 0 | 1 | 1 | 0.12 | 0.13 | 2.86 | 2.83 | 36,854 | 51,947 | 1/ 1/ 1 | SELECT o.order_id, line_item_i... |
d5j6fbqmu3gjp | 8.24 | 94.28 | 8.23 | 88.35 | -0.01 | 14 | 20 | 5.74 | 4.11 | 0 | 0 | 14 | 20 | 1.78 | 1.81 | 0.93 | 0.96 | 36,752 | 51,887 | 1/ 1/ 1 | SELECT /*+ use_nl */ o.order_i... |
CPU Time % of DB CPU | CPU Time (ms) per Exec | I/O Time (ms) per Exec | #Exec/sec (DB time) | Exec Time (ms) per Exec | Physical Reads per Exec | #Rows Processed per Exec | #Plans | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st/2nd/Both | SQL Text |
g8rhybcumtwd6 | 72.86 | 72.86 | 74.55 | 74.55 | 1.69 | 175 | 205 | 13 | 11 | 1.11 | 0.83 | 191 | 222 | 1.10 | 0.63 | 9.99 | 9.99 | 1/ 1/ 1 | SELECT /*+ first_rows index(cu... |
gyk686gnaygs2 | 2.75 | 75.61 | 2.56 | 77.11 | -0.19 | 0 | 0 | 0 | 0 | 34.42 | 24.67 | 0 | 0 | 0.00 | 0.00 | 5.03 | 5.03 | 1/ 1/ 1 | select product_id, product_nam... |
82ud5h0qcg0bf | 1.89 | 77.49 | 1.81 | 78.92 | -0.07 | 0 | 0 | 15 | 20 | 19.50 | 13.97 | 15 | 21 | 1.56 | 1.54 | 1.00 | 1.00 | 1/ 1/ 1 | select customer_id, cust_first... |
7v0pya6f6qc6s | 0.70 | 78.20 | 0.65 | 79.57 | -0.05 | 0 | 0 | 0 | 0 | 17.15 | 12.31 | 0 | 0 | 0.00 | 0.00 | 10.00 | 10.00 | 1/ 1/ 1 | select p.product_id, product_n... |
dt8dtzvsq5kj5 | 0.64 | 78.83 | 0.59 | 80.16 | -0.05 | 0 | 0 | 0 | 0 | 16.43 | 11.66 | 0 | 0 | 0.00 | 0.00 | 10.00 | 10.00 | 1/ 1/ 1 | select p.product_id, product_n... |
5g00dq4fxwnsw | 0.88 | 79.71 | 0.92 | 81.08 | 0.04 | 0 | 0 | 4 | 7 | 16.43 | 11.66 | 4 | 7 | 0.46 | 0.56 | 0.90 | 0.90 | 1/ 1/ 1 | update inventories set quantit... |
2yp5w5a36s5xv | 0.64 | 80.35 | 0.67 | 81.75 | 0.03 | 0 | 0 | 3 | 6 | 5.75 | 4.12 | 3 | 6 | 0.30 | 0.50 | 1.00 | 1.00 | 1/ 1/ 1 | update orders set order_mode =... |
gshgncvvtv0c6 | 1.00 | 81.35 | 0.98 | 82.72 | -0.02 | 0 | 0 | 0 | 0 | 19.50 | 13.97 | 0 | 0 | 0.00 | 0.00 | 1.00 | 1.00 | insert into logon values(:1 , ... | |
8vvvyuun2urt6 | 1.78 | 83.13 | 1.80 | 84.52 | 0.01 | 0 | 0 | 5 | 9 | 16.43 | 11.66 | 6 | 9 | 0.65 | 0.76 | 1.00 | 1.00 | insert into order_items(ORDER_... | |
9zd49du11u7cf | 1.21 | 84.35 | 1.20 | 85.72 | -0.01 | 1 | 1 | 17 | 24 | 5.75 | 4.12 | 18 | 25 | 1.92 | 1.93 | 1.00 | 1.00 | insert into orders(ORDER_ID, O... | |
d5j6fbqmu3gjp | 0.75 | 85.10 | 0.74 | 86.46 | -0.01 | 0 | 0 | 14 | 20 | 5.74 | 4.11 | 14 | 20 | 1.78 | 1.81 | 0.93 | 0.96 | 1/ 1/ 1 | SELECT /*+ use_nl */ o.order_i... |
I/O Time % of DB time | I/O Time (ms) per Exec | Elapsed Time (ms) per Exec | #Exec/sec (DB time) | CPU Time (ms) per Exec | Physical Reads per Exec | #Rows Processed per Exec | #Executions | #Plans | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st/2nd/Both | SQL Text |
9bz9sa0abpc48 | 6.08 | 6.08 | -6.08 | 27 | 27 | 2.29 | 1 | 3.21 | 1.00 | 14,671 | insert into customers (custome... | ||||||||||
8vvvyuun2urt6 | 8.67 | 14.76 | 10.07 | 10.07 | 1.40 | 5 | 9 | 6 | 9 | 16.43 | 11.66 | 0 | 0 | 0.65 | 0.76 | 1.00 | 1.00 | 105,252 | 147,058 | insert into order_items(ORDER_... | |
5g00dq4fxwnsw | 6.55 | 21.31 | 7.80 | 17.87 | 1.25 | 4 | 7 | 4 | 7 | 16.43 | 11.66 | 0 | 0 | 0.46 | 0.56 | 0.90 | 0.90 | 105,254 | 147,054 | 1/ 1/ 1 | update inventories set quantit... |
2yp5w5a36s5xv | 1.46 | 22.77 | 2.40 | 20.27 | 0.94 | 3 | 6 | 3 | 6 | 5.75 | 4.12 | 0 | 0 | 0.30 | 0.50 | 1.00 | 1.00 | 36,853 | 51,945 | 1/ 1/ 1 | update orders set order_mode =... |
g8rhybcumtwd6 | 1.40 | 24.17 | 0.94 | 21.21 | -0.47 | 13 | 11 | 191 | 222 | 1.11 | 0.83 | 175 | 205 | 1.10 | 0.63 | 9.99 | 9.99 | 7,086 | 10,442 | 1/ 1/ 1 | SELECT /*+ first_rows index(cu... |
82ud5h0qcg0bf | 28.67 | 52.85 | 28.39 | 49.60 | -0.28 | 15 | 20 | 15 | 21 | 19.50 | 13.97 | 0 | 0 | 1.56 | 1.54 | 1.00 | 1.00 | 124,882 | 176,182 | 1/ 1/ 1 | select customer_id, cust_first... |
9zd49du11u7cf | 9.87 | 62.71 | 9.94 | 59.54 | 0.07 | 17 | 24 | 18 | 25 | 5.75 | 4.12 | 1 | 1 | 1.92 | 1.93 | 1.00 | 1.00 | 36,852 | 51,948 | insert into orders(ORDER_ID, O... | |
d5j6fbqmu3gjp | 8.06 | 70.77 | 8.08 | 67.61 | 0.01 | 14 | 20 | 14 | 20 | 5.74 | 4.11 | 0 | 0 | 1.78 | 1.81 | 0.93 | 0.96 | 36,752 | 51,887 | 1/ 1/ 1 | SELECT /*+ use_nl */ o.order_i... |
gfqas5ahy1x56 | 0.56 | 71.34 | 0.57 | 68.19 | 0.01 | 1 | 1 | 1 | 2 | 5.75 | 4.12 | 0 | 0 | 0.12 | 0.13 | 2.86 | 2.83 | 36,854 | 51,947 | 1/ 1/ 1 | SELECT o.order_id, line_item_i... |
gshgncvvtv0c6 | 0.04 | 71.38 | 0.05 | 68.24 | 0.01 | 0 | 0 | 0 | 0 | 19.50 | 13.97 | 0 | 0 | 0.00 | 0.00 | 1.00 | 1.00 | 124,883 | 176,186 | insert into logon values(:1 , ... | |
gyk686gnaygs2 | 0.00 | 71.38 | 0.00 | 68.24 | 0.00 | 0 | 0 | 0 | 0 | 34.42 | 24.67 | 0 | 0 | 0.00 | 0.00 | 5.03 | 5.03 | 220,441 | 311,130 | 1/ 1/ 1 | select product_id, product_nam... |
% Total Gets | Gets per Exec | #Executions | Exec Time (ms) per Exec | CPU Time (ms) per Exec | I/O Time (ms) per Exec | Physical Reads per Exec | #Rows Processed per Exec | #Plans | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st/2nd/Both | SQL Text |
g8rhybcumtwd6 | 95.98 | 95.98 | 0.00 | 0.00 | -95.98 | 49,626.71 | 0.00 | 7,086 | 10,442 | 191 | 222 | 175 | 205 | 13 | 11 | 1.10 | 0.63 | 9.99 | 9.99 | 1/ 1/ 1 | SELECT /*+ first_rows index(cu... |
gyk686gnaygs2 | 1.81 | 97.78 | 1.59 | 1.59 | -0.21 | 30.03 | 30.02 | 220,441 | 311,130 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 5.03 | 5.03 | 1/ 1/ 1 | select product_id, product_nam... |
8vvvyuun2urt6 | 0.38 | 98.16 | 0.33 | 1.93 | -0.05 | 13.28 | 13.28 | 105,252 | 147,058 | 6 | 9 | 0 | 0 | 5 | 9 | 0.65 | 0.76 | 1.00 | 1.00 | insert into order_items(ORDER_... | |
gshgncvvtv0c6 | 0.20 | 98.37 | 0.17 | 2.10 | -0.03 | 5.98 | 5.80 | 124,883 | 176,186 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 1.00 | 1.00 | insert into logon values(:1 , ... | |
dt8dtzvsq5kj5 | 0.20 | 98.57 | 0.18 | 2.28 | -0.03 | 7.06 | 7.06 | 105,252 | 147,059 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 10.00 | 10.00 | 1/ 1/ 1 | select p.product_id, product_n... |
9zd49du11u7cf | 0.19 | 98.76 | 0.17 | 2.45 | -0.02 | 18.99 | 18.77 | 36,852 | 51,948 | 18 | 25 | 1 | 1 | 17 | 24 | 1.92 | 1.93 | 1.00 | 1.00 | insert into orders(ORDER_ID, O... | |
7v0pya6f6qc6s | 0.21 | 98.97 | 0.19 | 2.63 | -0.02 | 7.06 | 7.06 | 109,862 | 155,252 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 10.00 | 10.00 | 1/ 1/ 1 | select p.product_id, product_n... |
gfqas5ahy1x56 | 0.13 | 99.11 | 0.11 | 2.74 | -0.02 | 13.23 | 12.51 | 36,854 | 51,947 | 1 | 2 | 0 | 0 | 1 | 1 | 0.12 | 0.13 | 2.86 | 2.83 | 1/ 1/ 1 | SELECT o.order_id, line_item_i... |
82ud5h0qcg0bf | 0.14 | 99.24 | 0.12 | 2.86 | -0.02 | 4.01 | 4.00 | 124,882 | 176,182 | 15 | 21 | 0 | 0 | 15 | 20 | 1.56 | 1.54 | 1.00 | 1.00 | 1/ 1/ 1 | select customer_id, cust_first... |
5g00dq4fxwnsw | 0.11 | 99.36 | 0.10 | 2.96 | -0.01 | 3.92 | 3.93 | 105,254 | 147,054 | 4 | 7 | 0 | 0 | 4 | 7 | 0.46 | 0.56 | 0.90 | 0.90 | 1/ 1/ 1 | update inventories set quantit... |
2yp5w5a36s5xv | 0.10 | 99.46 | 0.09 | 3.05 | -0.01 | 10.14 | 10.29 | 36,853 | 51,945 | 3 | 6 | 0 | 0 | 3 | 6 | 0.30 | 0.50 | 1.00 | 1.00 | 1/ 1/ 1 | update orders set order_mode =... |
% Total Physical Reads | Physical Reads per Exec | #Executions | Exec Time (ms) per Exec | CPU Time (ms) per Exec | I/O Time (ms) per Exec | #Rows Processed per Exec | #Plans | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st/2nd/Both | SQL Text |
9bz9sa0abpc48 | 9.01 | 9.01 | -9.01 | 3.21 | 14,671 | 27 | 1 | 27 | 1.00 | insert into customers (custome... | |||||||||
82ud5h0qcg0bf | 37.27 | 46.27 | 35.14 | 35.14 | -2.13 | 1.56 | 1.54 | 124,882 | 176,182 | 15 | 21 | 0 | 0 | 15 | 20 | 1.00 | 1.00 | 1/ 1/ 1 | select customer_id, cust_first... |
5g00dq4fxwnsw | 9.19 | 55.47 | 10.70 | 45.84 | 1.51 | 0.46 | 0.56 | 105,254 | 147,054 | 4 | 7 | 0 | 0 | 4 | 7 | 0.90 | 0.90 | 1/ 1/ 1 | update inventories set quantit... |
8vvvyuun2urt6 | 13.01 | 68.47 | 14.49 | 60.33 | 1.49 | 0.65 | 0.76 | 105,252 | 147,058 | 6 | 9 | 0 | 0 | 5 | 9 | 1.00 | 1.00 | insert into order_items(ORDER_... | |
2yp5w5a36s5xv | 2.14 | 70.61 | 3.34 | 63.67 | 1.20 | 0.30 | 0.50 | 36,853 | 51,945 | 3 | 6 | 0 | 0 | 3 | 6 | 1.00 | 1.00 | 1/ 1/ 1 | update orders set order_mode =... |
g8rhybcumtwd6 | 1.49 | 72.10 | 0.84 | 64.51 | -0.64 | 1.10 | 0.63 | 7,086 | 10,442 | 191 | 222 | 175 | 205 | 13 | 11 | 9.99 | 9.99 | 1/ 1/ 1 | SELECT /*+ first_rows index(cu... |
9zd49du11u7cf | 13.52 | 85.62 | 12.94 | 77.46 | -0.57 | 1.92 | 1.93 | 36,852 | 51,948 | 18 | 25 | 1 | 1 | 17 | 24 | 1.00 | 1.00 | insert into orders(ORDER_ID, O... | |
d5j6fbqmu3gjp | 12.55 | 98.16 | 12.16 | 89.62 | -0.38 | 1.78 | 1.81 | 36,752 | 51,887 | 14 | 20 | 0 | 0 | 14 | 20 | 0.93 | 0.96 | 1/ 1/ 1 | SELECT /*+ use_nl */ o.order_i... |
6k3uuf3g8pwh6 | 0.37 | 98.53 | 0.28 | 89.90 | -0.10 | 0.27 | 0.20 | 7,082 | 10,442 | 3 | 4 | 0 | 0 | 3 | 3 | 1.00 | 1.00 | 1/ 1/ 1 | update /*+ index(orders, order... |
gfqas5ahy1x56 | 0.83 | 99.37 | 0.85 | 90.75 | 0.02 | 0.12 | 0.13 | 36,854 | 51,947 | 1 | 2 | 0 | 0 | 1 | 1 | 2.86 | 2.83 | 1/ 1/ 1 | SELECT o.order_id, line_item_i... |
9zus1m3s2675b | 0.09 | 99.46 | 0.10 | 90.85 | 0.01 | 490.00 | 793.00 | 1 | 1 | 3,886 | 6,473 | 630 | 1,279 | 3,140 | 4,950 | 1.00 | 1.00 | DECLARE job BINARY_INTEGER := ... |
% Total UnOptimized Read Requests | Read Requests per Exec | Total Read Requests | %Optimized Reads | #Executions | Exec Time (ms) per Exec | CPU Time (ms) per Exec | I/O Time (ms) per Exec | #Rows Processed per Exec | #Plans | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st/2nd/Both | SQL Text |
82ud5h0qcg0bf | 37.35 | 37.35 | 35.17 | 35.17 | -2.18 | 1.56 | 1.54 | 194,866 | 271,994 | 0.00 | 0.00 | 124,882 | 176,182 | 15 | 21 | 0 | 0 | 15 | 20 | 1.00 | 1.00 | 1/ 1/ 1 | select customer_id, cust_first... |
5g00dq4fxwnsw | 9.21 | 46.56 | 10.71 | 45.88 | 1.50 | 0.46 | 0.56 | 48,066 | 82,831 | 0.00 | 0.00 | 105,254 | 147,054 | 4 | 7 | 0 | 0 | 4 | 7 | 0.90 | 0.90 | 1/ 1/ 1 | update inventories set quantit... |
8vvvyuun2urt6 | 13.03 | 59.60 | 14.51 | 60.38 | 1.47 | 0.65 | 0.76 | 68,010 | 112,210 | 0.00 | 0.00 | 105,252 | 147,058 | 6 | 9 | 0 | 0 | 5 | 9 | 1.00 | 1.00 | insert into order_items(ORDER_... | |
2yp5w5a36s5xv | 2.15 | 61.74 | 3.34 | 63.72 | 1.19 | 0.30 | 0.50 | 11,197 | 25,832 | 0.00 | 0.00 | 36,853 | 51,945 | 3 | 6 | 0 | 0 | 3 | 6 | 1.00 | 1.00 | 1/ 1/ 1 | update orders set order_mode =... |
9bz9sa0abpc48 | 1.09 | 62.83 | -1.09 | 0.39 | 5,680 | 0.00 | 14,671 | 27 | 1 | 27 | 1.00 | insert into customers (custome... | |||||||||||
g8rhybcumtwd6 | 1.49 | 64.32 | 0.85 | 64.57 | -0.64 | 1.10 | 0.63 | 7,777 | 6,546 | 0.00 | 0.00 | 7,086 | 10,442 | 191 | 222 | 175 | 205 | 13 | 11 | 9.99 | 9.99 | 1/ 1/ 1 | SELECT /*+ first_rows index(cu... |
9zd49du11u7cf | 13.55 | 77.87 | 12.95 | 77.53 | -0.59 | 1.92 | 1.93 | 70,673 | 100,193 | 0.00 | 0.00 | 36,852 | 51,948 | 18 | 25 | 1 | 1 | 17 | 24 | 1.00 | 1.00 | insert into orders(ORDER_ID, O... | |
d5j6fbqmu3gjp | 12.57 | 90.44 | 12.18 | 89.70 | -0.40 | 1.78 | 1.81 | 65,598 | 94,166 | 0.00 | 0.00 | 36,752 | 51,887 | 14 | 20 | 0 | 0 | 14 | 20 | 0.93 | 0.96 | 1/ 1/ 1 | SELECT /*+ use_nl */ o.order_i... |
6k3uuf3g8pwh6 | 0.37 | 90.81 | 0.28 | 89.98 | -0.10 | 0.27 | 0.20 | 1,942 | 2,130 | 0.00 | 0.00 | 7,082 | 10,442 | 3 | 4 | 0 | 0 | 3 | 3 | 1.00 | 1.00 | 1/ 1/ 1 | update /*+ index(orders, order... |
gfqas5ahy1x56 | 0.83 | 91.65 | 0.85 | 90.83 | 0.02 | 0.12 | 0.13 | 4,354 | 6,602 | 0.00 | 0.00 | 36,854 | 51,947 | 1 | 2 | 0 | 0 | 1 | 1 | 2.86 | 2.83 | 1/ 1/ 1 | SELECT o.order_id, line_item_i... |
9zus1m3s2675b | 0.16 | 91.80 | 0.15 | 90.98 | -0.01 | 815.00 | 1,126.00 | 815 | 1,126 | 0.00 | 0.00 | 1 | 1 | 3,886 | 6,473 | 630 | 1,279 | 3,140 | 4,950 | 1.00 | 1.00 | DECLARE job BINARY_INTEGER := ... |
#Executions/sec (DB time) | #Executions | Exec Time (ms) per Exec | CPU Time (ms) per Exec | I/O Time (ms) per Exec | Physical Reads per Exec | #Rows Processed per Exec | #Plan | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st/2nd/Both | SQL Text |
gyk686gnaygs2 | 34.42 | 24.67 | -9.75 | 220,441 | 311,130 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 5.03 | 5.03 | 1/ 1/ 1 | select product_id, product_nam... |
82ud5h0qcg0bf | 19.50 | 13.97 | -5.53 | 124,882 | 176,182 | 15 | 21 | 0 | 0 | 15 | 20 | 1.56 | 1.54 | 1.00 | 1.00 | 1/ 1/ 1 | select customer_id, cust_first... |
gshgncvvtv0c6 | 19.50 | 13.97 | -5.53 | 124,883 | 176,186 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 1.00 | 1.00 | insert into logon values(:1 , ... | |
7v0pya6f6qc6s | 17.15 | 12.31 | -4.84 | 109,862 | 155,252 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 10.00 | 10.00 | 1/ 1/ 1 | select p.product_id, product_n... |
5g00dq4fxwnsw | 16.43 | 11.66 | -4.77 | 105,254 | 147,054 | 4 | 7 | 0 | 0 | 4 | 7 | 0.46 | 0.56 | 0.90 | 0.90 | 1/ 1/ 1 | update inventories set quantit... |
8vvvyuun2urt6 | 16.43 | 11.66 | -4.77 | 105,252 | 147,058 | 6 | 9 | 0 | 0 | 5 | 9 | 0.65 | 0.76 | 1.00 | 1.00 | insert into order_items(ORDER_... | |
982zxphp8ht6c | 16.43 | 11.66 | -4.77 | 105,251 | 147,057 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 1.00 | 1.00 | 1/ 1/ 1 | select product_id, product_nam... |
dt8dtzvsq5kj5 | 16.43 | 11.66 | -4.77 | 105,252 | 147,059 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 10.00 | 10.00 | 1/ 1/ 1 | select p.product_id, product_n... |
2yp5w5a36s5xv | 5.75 | 4.12 | -1.64 | 36,853 | 51,945 | 3 | 6 | 0 | 0 | 3 | 6 | 0.30 | 0.50 | 1.00 | 1.00 | 1/ 1/ 1 | update orders set order_mode =... |
gfqas5ahy1x56 | 5.75 | 4.12 | -1.64 | 36,854 | 51,947 | 1 | 2 | 0 | 0 | 1 | 1 | 0.12 | 0.13 | 2.86 | 2.83 | 1/ 1/ 1 | SELECT o.order_id, line_item_i... |
9zd49du11u7cf | 5.75 | 4.12 | -1.64 | 36,852 | 51,948 | 18 | 25 | 1 | 1 | 17 | 24 | 1.92 | 1.93 | 1.00 | 1.00 | insert into orders(ORDER_ID, O... | |
8uk8bquk453q8 | 5.75 | 4.12 | -1.63 | 36,848 | 51,947 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 1.00 | 1.00 | 1/ 1/ 1 | select orders_seq.nextval from... |
% Total Parses | Parses | #Executions | #Plans | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | 1st | 2nd | 1st/2nd/Both | SQL Text |
350f5yrnnmshs | 27.24 | 27.24 | 9.53 | 9.53 | -17.70 | 134 | 137 | 134 | 137 | lock table sys.mon_mods$ in ex... | |
b2gnxm5z6r51n | 0.81 | 28.05 | 10.51 | 20.04 | 9.69 | 4 | 151 | 4 | 151 | lock table sys.col_usage$ in e... | |
9tgj4g8y4rwy8 | 1.60 | 21.64 | 1.60 | 23 | 96 | / 1/ 1 | select type#, blocks, extents,... | ||||
cm5vu20fhtnq1 | 1.18 | 22.83 | 1.18 | 17 | 30 | / 1/ 1 | select /*+ connect_by_filterin... | ||||
0k8522rmdzg4k | 1.04 | 23.87 | 1.04 | 15 | 15 | / 2/ 2 | select privilege# from sysauth... | ||||
0ws7ahf1d78qa | 1.04 | 24.91 | 1.04 | 15 | 15 | / 1/ 1 | select SYS_CONTEXT('USERENV', ... | ||||
2yp5w5a36s5xv | 0.00 | 28.05 | 1.04 | 25.96 | 1.04 | 0 | 15 | 36,853 | 51,945 | 1/ 1/ 1 | update orders set order_mode =... |
459f3z9u4fb3u | 1.04 | 27.00 | 1.04 | 15 | 15 | / 1/ 1 | select value$ from props$ wher... | ||||
5d8b4p888x97a | 0.00 | 28.05 | 1.04 | 28.04 | 1.04 | 0 | 15 | 14,671 | 20,502 | 1/ 1/ 1 | select customer_seq.nextval fr... |
0kkhhb2w93cx0 | 1.02 | 29.07 | -1.02 | 5 | 10 | 1// 1 | update seg$ set type#=:4, bloc... | ||||
1gfaj4z5hn1kf | 0.41 | 29.47 | -0.41 | 2 | 2 | 1// 1 | delete from dependency$ where ... | ||||
20vv6ttajyjzq | 0.41 | 29.88 | -0.41 | 2 | 2 | 1// 1 | delete from access$ where d_ob... | ||||
2pff93c8c626v | 0.41 | 30.28 | -0.41 | 2 | 2 | 1// 1 | select name, address, protocol... | ||||
4m7m0t6fjcs5x | 0.41 | 30.69 | -0.41 | 2 | 10 | 1// 1 | update seq$ set increment$=:2,... | ||||
6abthk1u14yb7 | 0.41 | 31.10 | -0.41 | 2 | 2 | 1// 1 | SELECT VERSION FROM V$INSTANCE | ||||
6xvp6nxs4a9n4 | 0.41 | 31.50 | -0.41 | 2 | 12 | 1// 1 | select nvl(sum(space), 0) from... | ||||
bsa0wjtftg3uw | 1.42 | 32.93 | 1.32 | 29.37 | -0.10 | 7 | 19 | 88 | 111 | 1/ 1/ 1 | select file# from file$ where ... |
% Total Sharable Memory | Sharable Memory Used | Sharable Memory Max | #Executions | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | SQL Text |
9dhn1b8d88dpf | 0.11 | 0.11 | 0.11 | 288,434 | 288,434 | 1 | select OBJOID, CLSOID, RUNTIME... | |||||
bn4b3vjw2mj3u | 0.07 | 0.17 | 0.07 | 178,288 | 178,288 | 4 | SELECT OBJOID, CLSOID, DECODE(... | |||||
c2p21x29vnybg | 0.06 | 0.23 | 0.06 | 154,684 | 154,684 | 1 | SELECT x.inst_id, x.sid_knst, ... | |||||
8jhgd9rm6f17u | 0.06 | 0.28 | 0.06 | 154,423 | 154,423 | 1 | select SID, SERIAL#, CAPTURE#,... | |||||
6ajkhukk78nsr | 0.05 | 0.05 | 0.03 | 0.32 | -0.01 | 132,373 | 95,253 | 132,373 | 95,253 | 1 | 1 | begin prvt_hdm.auto_execute( :... |
6wm3n4d7bnddg | 0.12 | 0.17 | 0.11 | 0.43 | -0.00 | 321,554 | 312,970 | 321,554 | 312,970 | 1 | 1 | SELECT source, (case when tim... |
7r7twx8dzdd8r | 0.07 | 0.23 | 0.07 | 0.50 | -0.00 | 182,732 | 178,660 | 182,732 | 178,660 | 1 | 1 | INSERT INTO STATS$SEG_STAT_OBJ... |
317v5hnvvd49h | 0.05 | 0.28 | 0.05 | 0.55 | 0.00 | 139,928 | 139,944 | 139,928 | 139,944 | 1 | 1 | UPDATE wrh$_seg_stat_obj ob S... |
7k6zct1sya530 | 0.06 | 0.34 | 0.06 | 0.61 | 0.00 | 150,925 | 150,941 | 150,925 | 150,941 | 1 | 1 | insert into WRH$_STREAMS_APPLY... |
1bumcaqpc58vj | 0.05 | 0.39 | 0.05 | 0.66 | 0.00 | 133,903 | 133,903 | 133,903 | 133,903 | 1 | 1 | INSERT INTO STATS$STREAMS_CAPT... |
5dyhfnkzta2zm | 0.06 | 0.45 | 0.06 | 0.71 | 0.00 | 153,605 | 153,605 | 153,605 | 153,605 | 1 | 1 | WITH awr_evts as (SELECT e.eve... |
5h91zx386wbht | 0.07 | 0.52 | 0.07 | 0.79 | 0.00 | 199,210 | 199,210 | 199,210 | 199,210 | 1 | 1 | WITH awr_params as ( SELECT /*... |
6cp74g22fzahf | 0.08 | 0.60 | 0.08 | 0.86 | 0.00 | 216,035 | 216,035 | 216,035 | 216,035 | 1 | 1 | WITH ash as (SELECT ash.event... |
dnhdv2yuma39z | 0.05 | 0.65 | 0.05 | 0.92 | 0.00 | 146,496 | 146,496 | 146,496 | 146,496 | 1 | 1 | INSERT INTO STATS$STREAMS_APPL... |
Version Count | Version Count Max | #Executions | ||||||
---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | SQL Text |
0k8522rmdzg4k | 4 | 4 | 4 | 15 | select privilege# from sysauth... | |||
5ur69atw3vfhj | 4 | 4 | 4 | 15 | select decode(failover_method,... | |||
b3zgx1xckrwxu | 4 | 4 | 4 | 1 | select host, userid, password,... | |||
23buxzfxyp1vy | 3 | -3 | 3 | 1 | SELECT greatest(0, 1000*servi... | |||
23nad9x295gkf | 3 | -3 | 3 | 1 | SELECT (m.current_size / 10485... | |||
4g46czps3t55u | 3 | -3 | 3 | 1 | SELECT sum(case when snap_id ... | |||
4kt3cun8s5fp5 | 3 | 3 | 3 | 2 | select name, password, datats#... | |||
4vs91dcv7u1p6 | 3 | 3 | 3 | 15 | insert into sys.aud$( sessioni... | |||
5uw1u291s3m0k | 3 | -3 | 3 | 1 | SELECT case when cnt = 0 then ... | |||
6sqdp7673k5x3 | 3 | -3 | 3 | 1 | UPDATE wri$_adv_addm_tasks SET... | |||
47mm81hm9sggy | 3 | 3 | 0 | 3 | 3 | 1 | 1 | SELECT sum(case when a.sessio... |
5dyhfnkzta2zm | 3 | 3 | 0 | 3 | 3 | 1 | 1 | WITH awr_evts as (SELECT e.eve... |
5h91zx386wbht | 3 | 3 | 0 | 3 | 3 | 1 | 1 | WITH awr_params as ( SELECT /*... |
6ajkhukk78nsr | 3 | 3 | 0 | 3 | 3 | 1 | 1 | begin prvt_hdm.auto_execute( :... |
6cp74g22fzahf | 3 | 3 | 0 | 3 | 3 | 1 | 1 | WITH ash as (SELECT ash.event... |
% Total Cluster Wait | Cluster Wait Time (sec) | Cluster Wait Time per Exec (sec) | #Executions | #Plans | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st/2nd/Both | SQL Text |
01gmsncqrjrfr | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | / 1/ 1 | insert into WRH$_BUFFERED_QUEU... | |||||
0bma28usvnqt1 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | / 1/ 1 | SELECT text.sql_id FROM WRH$_S... | |||||
0k8522rmdzg4k | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 15 | / 2/ 2 | select privilege# from sysauth... | |||||
0kkhhb2w93cx0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 10 | 1// 1 | update seg$ set type#=:4, bloc... | |||||
0v3dvmc22qnam | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 195 | insert into sys.col_usage$ (ob... | ||||||
0ws7ahf1d78qa | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 15 | / 1/ 1 | select SYS_CONTEXT('USERENV', ... | |||||
14wnf35dahb7v | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | 1// 1 | SELECT A.ID, A.TYPE FROM SYS.W... | |||||
18c2yb5aj919t | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | 1// 1 | SELECT nvl(e1, 0) as e1, nvl(... | |||||
1bumcaqpc58vj | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | 1 | 1/ 1/ 1 | INSERT INTO STATS$STREAMS_CAPT... |
1cq3qr774cu45 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | 1 | 1/ 1/ 1 | insert into WRH$_IOSTAT_FILETY... |
1crajpb7j5tyz | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | 1 | 1/ 1/ 1 | INSERT INTO STATS$SGA_TARGET_A... |
1gfaj4z5hn1kf | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2 | 1// 1 | delete from dependency$ where ... | |||||
1p36ta7p3d7fu | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | 1// 1 | select file#, block#, ts#, blo... | |||||
20vv6ttajyjzq | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2 | 1// 1 | delete from access$ where d_ob... | |||||
23buxzfxyp1vy | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | 1// 1 | SELECT greatest(0, 1000*servi... | |||||
2yp5w5a36s5xv | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 36,853 | 51,945 | 1/ 1/ 1 | update orders set order_mode =... |
317v5hnvvd49h | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | 1 | 1/ 1/ 1 | UPDATE wrh$_seg_stat_obj ob S... |
Value | per Second (DB time) | per Second (Elapsed Time) | per Trans | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Statistic | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff |
db block changes | 2,549,313 | 3,564,963 | 39.84 | 398.05 | 282.65 | -28.99 | 2,827.70 | 3,948.56 | 39.64 | 13.89 | 13.82 | -0.50 |
execute count | 1,230,380 | 1,728,268 | 40.47 | 192.11 | 137.03 | -28.67 | 1,364.74 | 1,914.23 | 40.26 | 6.70 | 6.70 | 0.00 |
logons cumulative | 13 | 27 | 107.69 | 0.00 | 0.00 | 0.00 | 0.01 | 0.03 | 200.00 | 0.00 | 0.00 | 0.00 |
opened cursors cumulative | 1,230,072 | 1,727,506 | 40.44 | 192.06 | 136.97 | -28.68 | 1,364.40 | 1,913.39 | 40.24 | 6.70 | 6.70 | 0.00 |
parse count (total) | 492 | 1,437 | 192.07 | 0.08 | 0.11 | 37.50 | 0.55 | 1.59 | 189.09 | 0.00 | 0.01 | 100.00 |
parse time elapsed | 1,806 | 4,361 | 141.47 | 0.28 | 0.35 | 25.00 | 2.00 | 4.83 | 141.50 | 0.01 | 0.02 | 100.00 |
physical reads | 522,880 | 774,075 | 48.04 | 81.64 | 61.37 | -24.83 | 579.98 | 857.37 | 47.83 | 2.85 | 3.00 | 5.26 |
physical writes | 340,400 | 521,944 | 53.33 | 53.15 | 41.38 | -22.14 | 377.57 | 578.11 | 53.11 | 1.85 | 2.02 | 9.19 |
redo size | 354,549,884 | 498,530,952 | 40.61 | 55,359.07 | 39,526.72 | -28.60 | 393,267.02 | 552,173.50 | 40.41 | 1,931.77 | 1,933.13 | 0.07 |
session logical reads | 366,396,963 | 586,033,175 | 59.94 | 57,208.86 | 46,464.45 | -18.78 | 406,407.81 | 649,091.07 | 59.71 | 1,996.32 | 2,272.43 | 13.83 |
user calls | 2,611,214 | 3,657,716 | 40.08 | 407.71 | 290.01 | -28.87 | 2,896.36 | 4,051.29 | 39.88 | 14.23 | 14.18 | -0.35 |
user commits | 183,536 | 257,888 | 40.51 | 28.66 | 20.45 | -28.65 | 203.58 | 285.64 | 40.31 | 1.00 | 1.00 | 0.00 |
workarea executions - optimal | 274 | 1,032 | 276.64 | 0.04 | 0.08 | 100.00 | 0.30 | 1.14 | 280.00 | 0.00 | 0.00 | 0.00 |
Value | per Second (DB time) | per Second (Elapsed Time) | per Trans | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Statistic | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff |
Batched IO (bound) vector count | 451 | 433 | -3.99 | 0.07 | 0.03 | -57.14 | 0.50 | 0.48 | -4.00 | 0.00 | 0.00 | 0.00 |
Batched IO block miss count | 643 | 768 | 19.44 | 0.10 | 0.06 | -40.00 | 0.71 | 0.85 | 19.72 | 0.00 | 0.00 | 0.00 |
Batched IO buffer defrag count | 7 | 3 | -57.14 | 0.00 | 0.00 | 0.00 | 0.01 | 0.00 | -100.00 | 0.00 | 0.00 | 0.00 |
Batched IO double miss count | 90 | 123 | 36.67 | 0.01 | 0.01 | 0.00 | 0.10 | 0.14 | 40.00 | 0.00 | 0.00 | 0.00 |
Batched IO same unit count | 223 | 263 | 17.94 | 0.03 | 0.02 | -33.33 | 0.25 | 0.29 | 16.00 | 0.00 | 0.00 | 0.00 |
Batched IO single block count | 481 | 494 | 2.70 | 0.08 | 0.04 | -50.00 | 0.53 | 0.55 | 3.77 | 0.00 | 0.00 | 0.00 |
Batched IO vector block count | 123 | 126 | 2.44 | 0.02 | 0.01 | -50.00 | 0.14 | 0.14 | 0.00 | 0.00 | 0.00 | 0.00 |
Batched IO vector read count | 60 | 62 | 3.33 | 0.01 | 0.00 | -100.00 | 0.07 | 0.07 | 0.00 | 0.00 | 0.00 | 0.00 |
Block Cleanout Optim referenced | 3,558 | 6,675 | 87.61 | 0.56 | 0.53 | -5.36 | 3.95 | 7.39 | 87.09 | 0.02 | 0.03 | 50.00 |
CPU used by this session | 162,156 | 274,380 | 69.21 | 25.32 | 21.75 | -14.10 | 179.86 | 303.90 | 68.96 | 0.88 | 1.06 | 20.45 |
CPU used when call started | 162,045 | 274,171 | 69.19 | 25.30 | 21.74 | -14.07 | 179.74 | 303.67 | 68.95 | 0.88 | 1.06 | 20.45 |
CR blocks created | 43,727 | 76,368 | 74.65 | 6.83 | 6.05 | -11.42 | 48.50 | 84.59 | 74.41 | 0.24 | 0.30 | 25.00 |
Cached Commit SCN referenced | 34,730 | 41,731 | 20.16 | 5.42 | 3.31 | -38.93 | 38.52 | 46.22 | 19.99 | 0.19 | 0.16 | -15.79 |
Commit SCN cached | 6,504 | 8,609 | 32.36 | 1.02 | 0.68 | -33.33 | 7.21 | 9.54 | 32.32 | 0.04 | 0.03 | -25.00 |
DBWR checkpoint buffers written | 49,337 | 31,900 | -35.34 | 7.70 | 2.53 | -67.14 | 54.72 | 35.33 | -35.43 | 0.27 | 0.12 | -55.56 |
DBWR checkpoints | 11 | 14 | 27.27 | 0.00 | 0.00 | 0.00 | 0.01 | 0.02 | 100.00 | 0.00 | 0.00 | 0.00 |
DBWR thread checkpoint buffers written | 49,337 | 31,900 | -35.34 | 7.70 | 2.53 | -67.14 | 54.72 | 35.33 | -35.43 | 0.27 | 0.12 | -55.56 |
DBWR transaction table writes | 218 | 285 | 30.73 | 0.03 | 0.02 | -33.33 | 0.24 | 0.32 | 33.33 | 0.00 | 0.00 | 0.00 |
DBWR undo block writes | 16,336 | 24,068 | 47.33 | 2.55 | 1.91 | -25.10 | 18.12 | 26.66 | 47.13 | 0.09 | 0.09 | 0.00 |
HSC Heap Segment Block Changes | 421,099 | 589,972 | 40.10 | 65.75 | 46.78 | -28.85 | 467.08 | 653.45 | 39.90 | 2.29 | 2.29 | 0.00 |
Heap Segment Array Inserts | 169 | 173 | 2.37 | 0.03 | 0.01 | -66.67 | 0.19 | 0.19 | 0.00 | 0.00 | 0.00 | 0.00 |
Heap Segment Array Updates | 15 | 21 | 40.00 | 0.00 | 0.00 | 0.00 | 0.02 | 0.02 | 0.00 | 0.00 | 0.00 | 0.00 |
IMU CR rollbacks | 13,396 | 18,373 | 37.15 | 2.09 | 1.46 | -30.14 | 14.86 | 20.35 | 36.94 | 0.07 | 0.07 | 0.00 |
IMU Flushes | 23,259 | 29,871 | 28.43 | 3.63 | 2.37 | -34.71 | 25.80 | 33.09 | 28.26 | 0.13 | 0.12 | -7.69 |
IMU Redo allocation size | 116,746,320 | 143,624,724 | 23.02 | 18,228.65 | 11,387.48 | -37.53 | 129,495.11 | 159,078.92 | 22.85 | 636.09 | 556.93 | -12.44 |
IMU commits | 154,026 | 168,153 | 9.17 | 24.05 | 13.33 | -44.57 | 170.85 | 186.25 | 9.01 | 0.84 | 0.65 | -22.62 |
IMU contention | 19,872 | 26,336 | 32.53 | 3.10 | 2.09 | -32.58 | 22.04 | 29.17 | 32.35 | 0.11 | 0.10 | -9.09 |
IMU pool not allocated | 6,258 | 59,912 | 857.37 | 0.98 | 4.75 | 384.69 | 6.94 | 66.36 | 856.20 | 0.03 | 0.23 | 666.67 |
IMU undo allocation size | 373,604,528 | 376,000,264 | 0.64 | 58,334.24 | 29,811.70 | -48.90 | 414,402.45 | 416,458.36 | 0.50 | 2,035.59 | 1,458.00 | -28.37 |
IMU- failed to get a private strand | 6,258 | 59,912 | 857.37 | 0.98 | 4.75 | 384.69 | 6.94 | 66.36 | 856.20 | 0.03 | 0.23 | 666.67 |
Requests to/from client | 1,418,864 | 1,988,093 | 40.12 | 221.54 | 157.63 | -28.85 | 1,573.81 | 2,202.01 | 39.92 | 7.73 | 7.71 | -0.26 |
RowCR - row contention | 231 | 276 | 19.48 | 0.04 | 0.02 | -50.00 | 0.26 | 0.31 | 19.23 | 0.00 | 0.00 | 0.00 |
RowCR attempts | 112,607 | 159,698 | 41.82 | 17.58 | 12.66 | -27.99 | 124.90 | 176.88 | 41.62 | 0.61 | 0.62 | 1.64 |
RowCR hits | 111,471 | 156,900 | 40.75 | 17.40 | 12.44 | -28.51 | 123.64 | 173.78 | 40.55 | 0.61 | 0.61 | 0.00 |
SMON posted for undo segment shrink | 24 | 26 | 8.33 | 0.00 | 0.00 | 0.00 | 0.03 | 0.03 | 0.00 | 0.00 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 1,418,872 | 1,988,112 | 40.12 | 221.54 | 157.63 | -28.85 | 1,573.81 | 2,202.04 | 39.92 | 7.73 | 7.71 | -0.26 |
active txn count during cleanout | 55,655 | 60,690 | 9.05 | 8.69 | 4.81 | -44.65 | 61.73 | 67.22 | 8.89 | 0.30 | 0.24 | -20.00 |
background checkpoints completed | 11 | 14 | 27.27 | 0.00 | 0.00 | 0.00 | 0.01 | 0.02 | 100.00 | 0.00 | 0.00 | 0.00 |
background checkpoints started | 11 | 14 | 27.27 | 0.00 | 0.00 | 0.00 | 0.01 | 0.02 | 100.00 | 0.00 | 0.00 | 0.00 |
background timeouts | 4,682 | 4,699 | 0.36 | 0.73 | 0.37 | -49.32 | 5.19 | 5.20 | 0.19 | 0.03 | 0.02 | -33.33 |
branch node splits | 3 | 4 | 33.33 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
buffer is not pinned count | 177,662,097 | 285,236,508 | 60.55 | 27,739.98 | 22,615.37 | -18.47 | 197,062.94 | 315,928.31 | 60.32 | 968.00 | 1,106.05 | 14.26 |
buffer is pinned count | 179,300,974 | 287,542,236 | 60.37 | 27,995.88 | 22,798.18 | -18.57 | 198,880.79 | 318,482.14 | 60.14 | 976.93 | 1,114.99 | 14.13 |
bytes received via SQL*Net from client | 346,648,249 | 485,538,094 | 40.07 | 54,125.31 | 38,496.56 | -28.88 | 384,502.52 | 537,782.60 | 39.86 | 1,888.72 | 1,882.75 | -0.32 |
bytes sent via SQL*Net to client | 767,717,895 | 1,076,635,526 | 40.24 | 119,870.71 | 85,362.54 | -28.79 | 851,553.32 | 1,192,482.85 | 40.04 | 4,182.93 | 4,174.82 | -0.19 |
calls to get snapshot scn: kcmgss | 1,133,782 | 1,594,652 | 40.65 | 177.03 | 126.43 | -28.58 | 1,257.59 | 1,766.24 | 40.45 | 6.18 | 6.18 | 0.00 |
calls to kcmgas | 235,694 | 349,201 | 48.16 | 36.80 | 27.69 | -24.76 | 261.43 | 386.78 | 47.95 | 1.28 | 1.35 | 5.47 |
calls to kcmgcs | 726,676 | 1,018,866 | 40.21 | 113.46 | 80.78 | -28.80 | 806.03 | 1,128.50 | 40.01 | 3.96 | 3.95 | -0.25 |
cell physical IO interconnect bytes | 7,982,754,816 | 11,859,735,552 | 48.57 | 1,246,419.37 | 940,315.54 | -24.56 | 8,854,478.19 | 13,135,857.87 | 48.35 | 43,494.22 | 45,987.93 | 5.73 |
change write time | 1,300 | 2,200 | 69.23 | 0.20 | 0.17 | -15.00 | 1.44 | 2.44 | 69.44 | 0.01 | 0.01 | 0.00 |
cleanout - number of ktugct calls | 32,874 | 46,800 | 42.36 | 5.13 | 3.71 | -27.68 | 36.46 | 51.84 | 42.18 | 0.18 | 0.18 | 0.00 |
cleanouts and rollbacks - consistent read gets | 23,363 | 33,596 | 43.80 | 3.65 | 2.66 | -27.12 | 25.91 | 37.21 | 43.61 | 0.13 | 0.13 | 0.00 |
cleanouts only - consistent read gets | 1,731 | 987 | -42.98 | 0.27 | 0.08 | -70.37 | 1.92 | 1.09 | -43.23 | 0.01 | 0.00 | -100.00 |
cluster key scan block gets | 60 | 3,867 | 6,345.00 | 0.01 | 0.31 | 3,000.00 | 0.07 | 4.28 | 6,014.29 | 0.00 | 0.01 | 100.00 |
cluster key scans | 60 | 3,164 | 5,173.33 | 0.01 | 0.25 | 2,400.00 | 0.07 | 3.50 | 4,900.00 | 0.00 | 0.01 | 100.00 |
commit batch/immediate performed | 18 | 33 | 83.33 | 0.00 | 0.00 | 0.00 | 0.02 | 0.04 | 100.00 | 0.00 | 0.00 | 0.00 |
commit batch/immediate requested | 18 | 33 | 83.33 | 0.00 | 0.00 | 0.00 | 0.02 | 0.04 | 100.00 | 0.00 | 0.00 | 0.00 |
commit cleanout failures: buffer being written | 9 | 39 | 333.33 | 0.00 | 0.00 | 0.00 | 0.01 | 0.04 | 300.00 | 0.00 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 94 | 227 | 141.49 | 0.01 | 0.02 | 100.00 | 0.10 | 0.25 | 150.00 | 0.00 | 0.00 | 0.00 |
commit cleanout failures: cannot pin | 4,927 | 7,538 | 52.99 | 0.77 | 0.60 | -22.08 | 5.47 | 8.35 | 52.65 | 0.03 | 0.03 | 0.00 |
commit cleanouts | 757,256 | 1,058,902 | 39.83 | 118.24 | 83.96 | -28.99 | 839.95 | 1,172.84 | 39.63 | 4.13 | 4.11 | -0.48 |
commit cleanouts successfully completed | 752,226 | 1,051,088 | 39.73 | 117.45 | 83.34 | -29.04 | 834.37 | 1,164.19 | 39.53 | 4.10 | 4.08 | -0.49 |
commit immediate performed | 18 | 33 | 83.33 | 0.00 | 0.00 | 0.00 | 0.02 | 0.04 | 100.00 | 0.00 | 0.00 | 0.00 |
commit immediate requested | 18 | 33 | 83.33 | 0.00 | 0.00 | 0.00 | 0.02 | 0.04 | 100.00 | 0.00 | 0.00 | 0.00 |
commit txn count during cleanout | 47,753 | 72,206 | 51.21 | 7.46 | 5.72 | -23.32 | 52.97 | 79.98 | 50.99 | 0.26 | 0.28 | 7.69 |
consistent changes | 100,357 | 173,518 | 72.90 | 15.67 | 13.76 | -12.19 | 111.32 | 192.19 | 72.65 | 0.55 | 0.67 | 21.82 |
consistent gets | 362,913,878 | 581,211,846 | 60.15 | 56,665.01 | 46,082.19 | -18.68 | 402,544.37 | 643,750.96 | 59.92 | 1,977.34 | 2,253.74 | 13.98 |
consistent gets - examination | 236,188,959 | 379,363,286 | 60.62 | 36,878.31 | 30,078.34 | -18.44 | 261,980.99 | 420,183.25 | 60.39 | 1,286.88 | 1,471.04 | 14.31 |
consistent gets from cache | 362,913,875 | 581,211,847 | 60.15 | 56,665.01 | 46,082.19 | -18.68 | 402,544.37 | 643,750.97 | 59.92 | 1,977.34 | 2,253.74 | 13.98 |
consistent gets from cache (fastpath) | 126,504,818 | 201,512,179 | 59.29 | 19,752.34 | 15,977.17 | -19.11 | 140,319.25 | 223,195.14 | 59.06 | 689.26 | 781.39 | 13.37 |
cursor authentications | 5 | 47 | 840.00 | 0.00 | 0.00 | 0.00 | 0.01 | 0.05 | 400.00 | 0.00 | 0.00 | 0.00 |
data blocks consistent reads - undo records applied | 90,673 | 160,463 | 76.97 | 14.16 | 12.72 | -10.17 | 100.57 | 177.73 | 76.72 | 0.49 | 0.62 | 26.53 |
db block gets | 3,483,003 | 4,822,132 | 38.45 | 543.83 | 382.33 | -29.70 | 3,863.35 | 5,341.00 | 38.25 | 18.98 | 18.70 | -1.48 |
db block gets direct | 27 | 60 | 122.22 | 0.00 | 0.00 | 0.00 | 0.03 | 0.07 | 133.33 | 0.00 | 0.00 | 0.00 |
db block gets from cache | 3,482,976 | 4,822,072 | 38.45 | 543.83 | 382.32 | -29.70 | 3,863.32 | 5,340.93 | 38.25 | 18.98 | 18.70 | -1.48 |
db block gets from cache (fastpath) | 1,190,104 | 1,653,627 | 38.95 | 185.82 | 131.11 | -29.44 | 1,320.06 | 1,831.56 | 38.75 | 6.48 | 6.41 | -1.08 |
deferred (CURRENT) block cleanout applications | 265,326 | 371,815 | 40.14 | 41.43 | 29.48 | -28.84 | 294.30 | 411.82 | 39.93 | 1.45 | 1.44 | -0.69 |
dirty buffers inspected | 209,279 | 363,770 | 73.82 | 32.68 | 28.84 | -11.75 | 232.13 | 402.91 | 73.57 | 1.14 | 1.41 | 23.68 |
enqueue conversions | 579 | 563 | -2.76 | 0.09 | 0.04 | -55.56 | 0.64 | 0.62 | -3.13 | 0.00 | 0.00 | 0.00 |
enqueue releases | 443,391 | 619,926 | 39.81 | 69.23 | 49.15 | -29.00 | 491.81 | 686.63 | 39.61 | 2.42 | 2.40 | -0.83 |
enqueue requests | 443,403 | 619,934 | 39.81 | 69.23 | 49.15 | -29.00 | 491.82 | 686.64 | 39.61 | 2.42 | 2.40 | -0.83 |
enqueue waits | 691 | 1,266 | 83.21 | 0.11 | 0.10 | -9.09 | 0.77 | 1.40 | 81.82 | 0.00 | 0.00 | 0.00 |
free buffer inspected | 568,832 | 865,517 | 52.16 | 88.82 | 68.62 | -22.74 | 630.95 | 958.65 | 51.94 | 3.10 | 3.36 | 8.39 |
free buffer requested | 584,574 | 878,713 | 50.32 | 91.27 | 69.67 | -23.67 | 648.41 | 973.26 | 50.10 | 3.19 | 3.41 | 6.90 |
heap block compress | 576 | 865 | 50.17 | 0.09 | 0.07 | -22.22 | 0.64 | 0.96 | 50.00 | 0.00 | 0.00 | 0.00 |
hot buffers moved to head of LRU | 267,499 | 478,074 | 78.72 | 41.77 | 37.90 | -9.27 | 296.71 | 529.52 | 78.46 | 1.46 | 1.85 | 26.71 |
immediate (CR) block cleanout applications | 25,094 | 34,583 | 37.81 | 3.92 | 2.74 | -30.10 | 27.83 | 38.30 | 37.62 | 0.14 | 0.13 | -7.14 |
immediate (CURRENT) block cleanout applications | 29,435 | 40,597 | 37.92 | 4.60 | 3.22 | -30.00 | 32.65 | 44.97 | 37.73 | 0.16 | 0.16 | 0.00 |
index fast full scans (full) | 2 | 2 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
index fetch by key | 58,944,680 | 94,692,078 | 60.65 | 9,203.56 | 7,507.79 | -18.43 | 65,381.49 | 104,881.06 | 60.41 | 321.16 | 367.18 | 14.33 |
index scans kdiixs1 | 58,760,496 | 94,436,438 | 60.71 | 9,174.81 | 7,487.52 | -18.39 | 65,177.19 | 104,597.92 | 60.48 | 320.16 | 366.19 | 14.38 |
leaf node 90-10 splits | 20 | 18 | -10.00 | 0.00 | 0.00 | 0.00 | 0.02 | 0.02 | 0.00 | 0.00 | 0.00 | 0.00 |
leaf node splits | 1,611 | 1,958 | 21.54 | 0.25 | 0.16 | -36.00 | 1.79 | 2.17 | 21.23 | 0.01 | 0.01 | 0.00 |
lob writes | 80 | 110 | 37.50 | 0.01 | 0.01 | 0.00 | 0.09 | 0.12 | 33.33 | 0.00 | 0.00 | 0.00 |
lob writes unaligned | 80 | 110 | 37.50 | 0.01 | 0.01 | 0.00 | 0.09 | 0.12 | 33.33 | 0.00 | 0.00 | 0.00 |
logical read bytes from cache | 3,001,522,946,048 | 4,800,790,085,632 | 59.95 | 468,654,797.58 | 380,637,283.69 | -18.78 | 3,329,291,715.43 | 5,317,361,079.81 | 59.71 | 16,353,864.89 | 18,615,794.79 | 13.83 |
max cf enq hold time | 10 | 30 | 200.00 | 0.00 | 0.00 | 0.00 | 0.01 | 0.03 | 200.00 | 0.00 | 0.00 | 0.00 |
messages received | 207,981 | 288,184 | 38.56 | 32.47 | 22.85 | -29.63 | 230.69 | 319.19 | 38.36 | 1.13 | 1.12 | -0.88 |
messages sent | 207,981 | 288,184 | 38.56 | 32.47 | 22.85 | -29.63 | 230.69 | 319.19 | 38.36 | 1.13 | 1.12 | -0.88 |
min active SCN optimization applied on CR | 159,883 | 225,820 | 41.24 | 24.96 | 17.90 | -28.29 | 177.34 | 250.12 | 41.04 | 0.87 | 0.88 | 1.15 |
no work - consistent read gets | 125,842,864 | 200,598,432 | 59.40 | 19,648.98 | 15,904.72 | -19.06 | 139,585.01 | 222,183.07 | 59.17 | 685.66 | 777.85 | 13.45 |
non-idle wait count | 2,527,015 | 3,587,074 | 41.95 | 394.57 | 284.41 | -27.92 | 2,802.97 | 3,973.05 | 41.74 | 13.77 | 13.91 | 1.02 |
parse count (hard) | 5 | 332 | 6,540.00 | 0.00 | 0.03 | 100.00 | 0.01 | 0.37 | 3,600.00 | 0.00 | 0.00 | 0.00 |
parse time cpu | 1,883 | 3,139 | 66.70 | 0.29 | 0.25 | -13.79 | 2.09 | 3.48 | 66.51 | 0.01 | 0.01 | 0.00 |
physical read IO requests | 521,753 | 773,429 | 48.24 | 81.47 | 61.32 | -24.73 | 578.73 | 856.65 | 48.02 | 2.84 | 3.00 | 5.63 |
physical read bytes | 4,283,432,960 | 6,341,222,400 | 48.04 | 668,810.95 | 502,772.59 | -24.83 | 4,751,187.36 | 7,023,545.83 | 47.83 | 23,338.38 | 24,589.06 | 5.36 |
physical read total IO requests | 524,482 | 776,320 | 48.02 | 81.89 | 61.55 | -24.84 | 581.76 | 859.85 | 47.80 | 2.86 | 3.01 | 5.24 |
physical read total bytes | 4,327,405,568 | 6,387,666,944 | 47.61 | 675,676.79 | 506,455.01 | -25.04 | 4,799,961.81 | 7,074,987.87 | 47.40 | 23,577.97 | 24,769.15 | 5.05 |
physical read total multi block requests | 5 | 2 | -60.00 | 0.00 | 0.00 | 0.00 | 0.01 | 0.00 | -100.00 | 0.00 | 0.00 | 0.00 |
physical reads cache | 522,825 | 773,993 | 48.04 | 81.63 | 61.37 | -24.82 | 579.92 | 857.28 | 47.83 | 2.85 | 3.00 | 5.26 |
physical reads cache prefetch | 1,170 | 676 | -42.22 | 0.18 | 0.05 | -72.22 | 1.30 | 0.75 | -42.31 | 0.01 | 0.00 | -100.00 |
physical reads direct | 55 | 82 | 49.09 | 0.01 | 0.01 | 0.00 | 0.06 | 0.09 | 50.00 | 0.00 | 0.00 | 0.00 |
physical write IO requests | 236,463 | 383,680 | 62.26 | 36.92 | 30.42 | -17.61 | 262.28 | 424.96 | 62.03 | 1.29 | 1.49 | 15.50 |
physical write bytes | 2,788,556,800 | 4,275,765,248 | 53.33 | 435,402.48 | 339,009.96 | -22.14 | 3,093,069.49 | 4,735,842.92 | 53.11 | 15,193.51 | 16,579.93 | 9.13 |
physical write total IO requests | 597,121 | 876,098 | 46.72 | 93.23 | 69.46 | -25.50 | 662.33 | 970.37 | 46.51 | 3.25 | 3.40 | 4.62 |
physical write total bytes | 3,655,349,248 | 5,472,060,416 | 49.70 | 570,742.58 | 433,859.88 | -23.98 | 4,054,516.39 | 6,060,860.93 | 49.48 | 19,916.25 | 21,218.75 | 6.54 |
physical write total multi block requests | 1,099 | 362 | -67.06 | 0.17 | 0.03 | -82.35 | 1.22 | 0.40 | -67.21 | 0.01 | 0.00 | -100.00 |
physical writes direct | 82 | 130 | 58.54 | 0.01 | 0.01 | 0.00 | 0.09 | 0.14 | 55.56 | 0.00 | 0.00 | 0.00 |
physical writes from cache | 340,318 | 521,814 | 53.33 | 53.14 | 41.37 | -22.15 | 377.48 | 577.96 | 53.11 | 1.85 | 2.02 | 9.19 |
physical writes non checkpoint | 268,955 | 426,917 | 58.73 | 41.99 | 33.85 | -19.39 | 298.33 | 472.85 | 58.50 | 1.47 | 1.66 | 12.93 |
pinned buffers inspected | 39 | 95 | 143.59 | 0.01 | 0.01 | 0.00 | 0.04 | 0.11 | 175.00 | 0.00 | 0.00 | 0.00 |
prefetched blocks aged out before use | 1 | 2 | 100.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
recursive calls | 193,830 | 289,598 | 49.41 | 30.26 | 22.96 | -24.12 | 215.00 | 320.76 | 49.19 | 1.06 | 1.12 | 5.66 |
recursive cpu usage | 1,536 | 2,360 | 53.65 | 0.24 | 0.19 | -20.83 | 1.70 | 2.61 | 53.53 | 0.01 | 0.01 | 0.00 |
redo blocks checksummed by FG (exclusive) | 292,518 | 296,116 | 1.23 | 45.67 | 23.48 | -48.59 | 324.46 | 327.98 | 1.08 | 1.59 | 1.15 | -27.67 |
redo blocks written | 826,743 | 1,147,045 | 38.74 | 129.09 | 90.95 | -29.55 | 917.02 | 1,270.47 | 38.54 | 4.50 | 4.45 | -1.11 |
redo buffer allocation retries | 174 | 443 | 154.60 | 0.03 | 0.04 | 33.33 | 0.19 | 0.49 | 157.89 | 0.00 | 0.00 | 0.00 |
redo entries | 649,827 | 1,192,536 | 83.52 | 101.46 | 94.55 | -6.81 | 720.79 | 1,320.85 | 83.25 | 3.54 | 4.62 | 30.51 |
redo log space requests | 176 | 471 | 167.61 | 0.03 | 0.04 | 33.33 | 0.20 | 0.52 | 160.00 | 0.00 | 0.00 | 0.00 |
redo ordering marks | 6,115 | 11,159 | 82.49 | 0.95 | 0.88 | -7.37 | 6.78 | 12.36 | 82.30 | 0.03 | 0.04 | 33.33 |
redo size for direct writes | 208 | 780 | 275.00 | 0.03 | 0.06 | 100.00 | 0.23 | 0.86 | 273.91 | 0.00 | 0.00 | 0.00 |
redo subscn max counts | 16,125 | 28,537 | 76.97 | 2.52 | 2.26 | -10.32 | 17.89 | 31.61 | 76.69 | 0.09 | 0.11 | 22.22 |
redo synch long waits | 187 | 847 | 352.94 | 0.03 | 0.07 | 133.33 | 0.21 | 0.94 | 347.62 | 0.00 | 0.00 | 0.00 |
redo synch time | 9,601 | 26,962 | 180.82 | 1.50 | 2.14 | 42.67 | 10.65 | 29.86 | 180.38 | 0.05 | 0.10 | 100.00 |
redo synch time (usec) | 96,015,263 | 269,626,508 | 180.82 | 14,991.73 | 21,377.71 | 42.60 | 106,500.21 | 298,638.66 | 180.41 | 523.14 | 1,045.52 | 99.85 |
redo synch writes | 183,545 | 257,926 | 40.52 | 28.66 | 20.45 | -28.65 | 203.59 | 285.68 | 40.32 | 1.00 | 1.00 | 0.00 |
redo wastage | 55,374,424 | 70,121,084 | 26.63 | 8,646.11 | 5,559.65 | -35.70 | 61,421.36 | 77,666.20 | 26.45 | 301.71 | 271.91 | -9.88 |
redo write time | 5,260 | 12,621 | 139.94 | 0.82 | 1.00 | 21.95 | 5.83 | 13.98 | 139.79 | 0.03 | 0.05 | 66.67 |
redo writes | 178,894 | 242,728 | 35.68 | 27.93 | 19.25 | -31.08 | 198.43 | 268.85 | 35.49 | 0.97 | 0.94 | -3.09 |
rollback changes - undo records applied | 48 | 125 | 160.42 | 0.01 | 0.01 | 0.00 | 0.05 | 0.14 | 180.00 | 0.00 | 0.00 | 0.00 |
rollbacks only - consistent read gets | 19,770 | 41,584 | 110.34 | 3.09 | 3.30 | 6.80 | 21.93 | 46.06 | 110.03 | 0.11 | 0.16 | 45.45 |
rows fetched via callback | 58,794,764 | 94,478,496 | 60.69 | 9,180.16 | 7,490.86 | -18.40 | 65,215.20 | 104,644.50 | 60.46 | 320.34 | 366.35 | 14.36 |
session pga memory | 5,621,280 | 36,228,832 | 544.49 | 877.70 | 2,872.45 | 227.27 | 6,235.13 | 40,127.10 | 543.56 | 30.63 | 140.48 | 358.64 |
session pga memory max | 12,223,360 | 59,462,688 | 386.47 | 1,908.54 | 4,714.58 | 147.03 | 13,558.16 | 65,860.95 | 385.77 | 66.60 | 230.58 | 246.22 |
session uga memory | 4,295,894,744 | 4,302,374,568 | 0.15 | 670,756.72 | 341,119.72 | -49.14 | 4,765,009.98 | 4,765,315.43 | 0.01 | 23,406.28 | 16,683.11 | -28.72 |
session uga memory max | 25,936,856 | 49,050,984 | 89.12 | 4,049.75 | 3,889.08 | -3.97 | 28,769.18 | 54,328.93 | 88.84 | 141.32 | 190.20 | 34.59 |
shared hash latch upgrades - no wait | 309,676 | 428,124 | 38.25 | 48.35 | 33.94 | -29.80 | 343.49 | 474.19 | 38.05 | 1.69 | 1.66 | -1.78 |
shared hash latch upgrades - wait | 30 | 54 | 80.00 | 0.00 | 0.00 | 0.00 | 0.03 | 0.06 | 100.00 | 0.00 | 0.00 | 0.00 |
sorts (memory) | 445 | 2,106 | 373.26 | 0.07 | 0.17 | 142.86 | 0.49 | 2.33 | 375.51 | 0.00 | 0.01 | 100.00 |
sorts (rows) | 16,322 | 27,417 | 67.98 | 2.55 | 2.17 | -14.90 | 18.10 | 30.37 | 67.79 | 0.09 | 0.11 | 22.22 |
summed dirty queue length | 1,935,798 | 3,184,848 | 64.52 | 302.25 | 252.52 | -16.45 | 2,147.19 | 3,527.54 | 64.29 | 10.55 | 12.35 | 17.06 |
switch current to new buffer | 342 | 712 | 108.19 | 0.05 | 0.06 | 20.00 | 0.38 | 0.79 | 107.89 | 0.00 | 0.00 | 0.00 |
table fetch by rowid | 119,629,777 | 191,823,399 | 60.35 | 18,678.87 | 15,208.98 | -18.58 | 132,693.45 | 212,463.84 | 60.12 | 651.81 | 743.82 | 14.12 |
table scan blocks gotten | 6,180,629 | 8,684,649 | 40.51 | 965.04 | 688.57 | -28.65 | 6,855.56 | 9,619.13 | 40.31 | 33.68 | 33.68 | 0.00 |
table scan rows gotten | 220,747,132 | 310,139,845 | 40.50 | 34,467.24 | 24,589.87 | -28.66 | 244,852.90 | 343,511.28 | 40.29 | 1,202.75 | 1,202.61 | -0.01 |
table scans (short tables) | 220,455 | 309,789 | 40.52 | 34.42 | 24.56 | -28.65 | 244.53 | 343.12 | 40.32 | 1.20 | 1.20 | 0.00 |
total cf enq hold time | 3,250 | 4,930 | 51.69 | 0.51 | 0.39 | -23.53 | 3.60 | 5.46 | 51.67 | 0.02 | 0.02 | 0.00 |
total number of cf enq holders | 79 | 90 | 13.92 | 0.01 | 0.01 | 0.00 | 0.09 | 0.10 | 11.11 | 0.00 | 0.00 | 0.00 |
total number of times SMON posted | 28 | 41 | 46.43 | 0.00 | 0.00 | 0.00 | 0.03 | 0.05 | 66.67 | 0.00 | 0.00 | 0.00 |
transaction rollbacks | 15 | 32 | 113.33 | 0.00 | 0.00 | 0.00 | 0.02 | 0.04 | 100.00 | 0.00 | 0.00 | 0.00 |
undo change vector size | 119,248,856 | 164,305,732 | 37.78 | 18,619.40 | 13,027.21 | -30.03 | 132,270.93 | 181,985.23 | 37.59 | 649.73 | 637.12 | -1.94 |
write clones created in foreground | 123 | 670 | 444.72 | 0.02 | 0.05 | 150.00 | 0.14 | 0.74 | 428.57 | 0.00 | 0.00 | 0.00 |
Total Reads | Buffer Cache Reads | Direct Reads | Total Writes | DBWR | Direct Writes | LGWR | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff |
4.58 | 6.76 | 47.60 | 4.53 | 6.71 | 48.12 | 0.00 | 0.00 | 0.00 | 3.87 | 5.79 | 49.61 | 2.95 | 4.53 | 53.56 | 0.00 | 0.00 | 0.00 | 0.90 | 1.25 | 38.89 |
Total Reads | Buffer Cache Reads | Direct Reads | Total Writes | DBWR | Direct Writes | LGWR | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff |
581.89 | 861.48 | 48.05 | 578.79 | 858.17 | 48.27 | 0.06 | 0.08 | 33.33 | 662.44 | 972.54 | 46.81 | 262.24 | 425.92 | 62.42 | 0.04 | 0.05 | 25.00 | 399.03 | 545.40 | 36.68 |
Total Reads | Data File Reads | Temp File Reads | Total Writes | Data File Writes | Temp File Writes | Log File Writes | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff |
4.58 | 6.76 | 47.60 | 4.53 | 6.71 | 48.12 | 0.00 | 0.00 | 0.00 | 3.87 | 5.79 | 49.61 | 2.95 | 4.52 | 53.22 | 0.00 | 0.00 | 0.00 | 0.90 | 1.24 | 37.78 |
Total Reads | Data File Reads | Temp File Reads | Total Writes | Data File Writes | Temp File Writes | Log File Writes | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff |
581.88 | 861.47 | 48.05 | 578.86 | 858.27 | 48.27 | 0.00 | 0.00 | 0.00 | 662.45 | 972.30 | 46.77 | 262.30 | 425.76 | 62.32 | 0.00 | 0.00 | 0.00 | 398.78 | 545.06 | 36.68 |
Avg Reads / Sec | Avg Writes / Sec | Reads | Avg Read Time (ms) | Avg Blocks / Read | Writes | Buffer Waits | Avg Buf Wait Time (ms) | IOs per second | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Tablespace | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | Diff |
SOE | 576.60 | 852.39 | 47.83 | 260.19 | 420.86 | 61.75 | 519,831 | 769,580 | 8.78 | 12.11 | 1.00 | 1.00 | 234,576 | 379,976 | 3,270 | 5,012 | 8.39 | 10.30 | 836.79 | 1,273.25 | 436.46 |
UNDOTBS1 | 0.09 | 0.10 | 11.11 | 1.51 | 3.12 | 106.62 | 83 | 89 | 6.02 | 10.67 | 1.00 | 1.00 | 1,363 | 2,817 | 52 | 113 | 0.19 | 0.27 | 1.60 | 3.22 | 1.61 |
SYSTEM | 0.26 | 1.34 | 415.38 | 0.03 | 0.04 | 33.33 | 230 | 1,214 | 10.48 | 9.32 | 3.35 | 1.27 | 26 | 32 | 1 | 63 | 0.00 | 2.38 | 0.28 | 1.38 | 1.10 |
SYSAUX | 1.64 | 1.48 | -9.76 | 0.56 | 0.67 | 19.64 | 1,475 | 1,333 | 6.39 | 6.88 | 1.40 | 1.24 | 502 | 609 | 0 | 0 | 0.00 | 0.00 | 2.19 | 2.15 | -0.04 |
Avg Reads / Sec | Avg Writes / Sec | Reads | Avg Read Time (ms) | Avg Blocks / Read | Writes | Buffer Waits | Avg Buf Wait Time (ms) | IOs per second | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Tablespace | Filename | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | Diff |
SOE | +DATA/dbm11203/datafile/soe.486.836957131 | 576.60 | 852.39 | 47.83 | 260.19 | 420.86 | 61.75 | 519,831 | 769,580 | 8.78 | 12.11 | 1.00 | 1.00 | 234,576 | 379,976 | 3,270 | 5,012 | 8.39 | 10.30 | 836.79 | 1,273.25 | 436.46 |
UNDOTBS1 | +DATA/dbm11203/datafile/undotbs1.461.772715929 | 0.09 | 0.10 | 11.11 | 1.51 | 3.12 | 106.62 | 83 | 89 | 6.02 | 10.67 | 1.00 | 1.00 | 1,363 | 2,817 | 52 | 113 | 0.19 | 0.27 | 1.60 | 3.22 | 1.61 |
SYSTEM | +DATA/dbm11203/datafile/system.459.772715923 | 0.26 | 1.34 | 415.38 | 0.03 | 0.04 | 33.33 | 230 | 1,214 | 10.48 | 9.32 | 3.35 | 1.27 | 26 | 32 | 1 | 63 | 0.00 | 2.38 | 0.28 | 1.38 | 1.10 |
SYSAUX | +DATA/dbm11203/datafile/sysaux.460.772715927 | 1.64 | 1.48 | -9.76 | 0.56 | 0.67 | 19.64 | 1,475 | 1,333 | 6.39 | 6.88 | 1.40 | 1.24 | 502 | 609 | 0 | 0 | 0.00 | 0.00 | 2.19 | 2.15 | -0.04 |
Read Time % of DB time | Avg Read Time (ms) | Reads | Avg Reads per Sec | Avg Blocks per Read | Writes | Avg Writes per 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 |
SOE | +DATA/dbm11203/datafile/soe.486.836957131 | 71.29 | 73.92 | 2.63 | 8.78 | 12.11 | 519,831 | 769,580 | 576.60 | 852.39 | 1.00 | 1.00 | 234,576 | 379,976 | 260.19 | 420.86 | 3,270 | 5,012 | 0.84 | 1.03 |
SYSAUX | +DATA/dbm11203/datafile/sysaux.460.772715927 | 0.15 | 0.07 | -0.07 | 6.39 | 6.88 | 1,475 | 1,333 | 1.64 | 1.48 | 1.40 | 1.24 | 502 | 609 | 0.56 | 0.67 | 0 | 0 | 0.00 | 0.00 |
SYSTEM | +DATA/dbm11203/datafile/system.459.772715923 | 0.04 | 0.09 | 0.05 | 10.48 | 9.32 | 230 | 1,214 | 0.26 | 1.34 | 3.35 | 1.27 | 26 | 32 | 0.03 | 0.04 | 1 | 63 | 0.00 | 0.24 |
UNDOTBS1 | +DATA/dbm11203/datafile/undotbs1.461.772715929 | 0.01 | 0.01 | -0.00 | 6.02 | 10.67 | 83 | 89 | 0.09 | 0.10 | 1.00 | 1.00 | 1,363 | 2,817 | 1.51 | 3.12 | 52 | 113 | 0.02 | 0.03 |
Wait Time % of DB time | Buffer Waits | Avg Buf Wait Time (ms) | Reads | Avg Reads per Sec | Avg Read Time (ms) | Avg Blocks per Read | Writes | Avg Writes per Sec | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Tablespace | Filename | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd |
SOE | +DATA/dbm11203/datafile/soe.486.836957131 | 0.43 | 0.41 | -0.02 | 3,270 | 5,012 | 0.84 | 1.03 | 519,831 | 769,580 | 576.60 | 852.39 | 8.78 | 12.11 | 1.00 | 1.00 | 234,576 | 379,976 | 260 | 421 |
Target MTTR(s) | Estimated MTTR(s) | Recovery Estimated IOs | Actual Redo Blocks | Target Redo Blocks | Log File Size Redo Blocks | Log Ckpt Timeout Redo Blocks | Log Ckpt Interval Redo Blocks | Optimal Log File Size (Mb) | Estimated Cluster Available Time (s) | |
---|---|---|---|---|---|---|---|---|---|---|
B1 | 0 | 19 | 20,987 | 167,937 | 165,888 | 165,888 | 445,422 | |||
E1 | 0 | 19 | 21,454 | 167,685 | 165,888 | 165,888 | 384,637 | |||
B2 | 0 | 18 | 16,165 | 167,866 | 165,888 | 165,888 | 417,367 | |||
E2 | 0 | 18 | 16,018 | 169,373 | 165,888 | 165,888 | 413,717 |
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 | 11,684 | 6,084 | -47.93 | 71 | 73 | 0 | 0 | 0.00 | 0 | 0 |
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 | 128 | 8 | 178.2 | 0.0 | 0.0 | 0.0 | 0.0 | 26,214 |
E1 | 128 | 8 | 181.2 | 0.0 | 0.0 | 0.0 | 0.0 | 26,214 |
B2 | 128 | 8 | 184.9 | 0.0 | 0.0 | 0.0 | 0.0 | 26,214 |
E2 | 128 | 8 | 217.0 | 0.0 | 0.0 | 0.0 | 0.0 | 26,214 |
Wait Time % of 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 | 27.44 | 51.56 | 3,275 | 5,028 | 0.08 | 0.10 | 25.00 |
segment header | 0.00 | 0.00 | 0.00 | 0.00 | 0.09 | 0 | 22 | 0.00 | 0.04 | 100.00 |
3rd level bmb | 0.00 | 0.00 | 0.00 | 0.00 | 0.04 | 0 | 11 | 0.00 | 0.04 | 100.00 |
2nd level bmb | 0.00 | 0.00 | 0.00 | 0.00 | 0.03 | 0 | 9 | 0.00 | 0.03 | 100.00 |
undo header | 0.00 | 0.00 | 0.00 | 0.00 | 0.02 | 28 | 44 | 0.00 | 0.00 | 0.00 |
undo block | 0.00 | 0.00 | -0.00 | 0.01 | 0.01 | 24 | 69 | 0.00 | 0.00 | 0.00 |
1st level bmb | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 2 | 0.00 | 0.00 | 0.00 |
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 |
TX-Transaction (row lock contention) | 0.01 | 0.02 | 0.01 | 1 | 2 | 686 | 1,236 | 686 | 1,236 | 0 | 0 | 684 | 1,230 | 1.17 | 1.80 |
Num Undo Blocks (K) | Number of Transactions | Max Qry Len (s) | Max Tx Concurcy | Min/Max TR (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU | |
---|---|---|---|---|---|---|---|
1st | 31.79 | 369,847 | 939 | 20 | 19.6/29.7 | 0/0 | 0/0/0/0/0/0 |
2nd | 41.51 | 489,055 | 938 | 31 | 19.6/29.6 | 0/0 | 0/0/0/0/0/0 |
% of Total Sleeps | Get Requests | Misses | Spin Gets | Sleeps | Wait Time (cs) | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Latch Name | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | Diff |
In memory undo latch | 21.47 | 12.98 | -8.49 | 1,305,440 | 1,391,681 | 277 | 395 | 120 | 140 | 158 | 257 | 19,007 | 45,258 | 26,251 |
cache buffers chains | 61.14 | 68.43 | 7.29 | 505,924,400 | 804,374,724 | 239,995 | 1,488,116 | 239,545 | 1,486,761 | 450 | 1,355 | 55,570 | 338,795 | 283,225 |
simulator hash latch | 2.99 | 5.05 | 2.06 | 21,646,930 | 34,366,849 | 1,507 | 4,316 | 1,485 | 4,217 | 22 | 100 | 9,841 | 100,030 | 90,189 |
session idle bit | 4.35 | 2.73 | -1.62 | 5,405,487 | 7,568,121 | 438 | 1,281 | 406 | 1,227 | 32 | 54 | 5,565 | 26,212 | 20,647 |
object queue header operation | 1.90 | 2.73 | 0.83 | 2,330,854 | 3,523,023 | 450 | 1,146 | 436 | 1,093 | 14 | 54 | 3,496 | 16,294 | 12,798 |
redo allocation | 1.49 | 2.22 | 0.73 | 900,547 | 1,141,712 | 316 | 1,022 | 305 | 978 | 11 | 44 | 1,762 | 12,289 | 10,527 |
shared pool | 0.00 | 0.71 | 0.71 | 2,350 | 32,027 | 3 | 56 | 3 | 50 | 0 | 14 | 0 | 17,883 | 17,883 |
enqueue hash chains | 1.90 | 1.41 | -0.49 | 888,071 | 1,240,957 | 227 | 459 | 213 | 431 | 14 | 28 | 3,154 | 8,762 | 5,608 |
row cache objects | 0.00 | 0.40 | 0.40 | 8,350 | 55,238 | 2 | 60 | 2 | 52 | 0 | 8 | 0 | 2,242 | 2,242 |
mostly latch-free SCN | 1.77 | 1.46 | -0.30 | 182,081 | 247,788 | 635 | 958 | 622 | 929 | 13 | 29 | 4,930 | 4,677 | -253 |
cache buffers lru chain | 1.36 | 1.16 | -0.20 | 451,916 | 703,390 | 181 | 432 | 171 | 410 | 10 | 23 | 894 | 5,537 | 4,643 |
DML lock allocation | 0.54 | 0.35 | -0.19 | 498,223 | 698,726 | 43 | 84 | 39 | 77 | 4 | 7 | 640 | 2,291 | 1,651 |
messages | 0.27 | 0.15 | -0.12 | 616,540 | 852,994 | 115 | 253 | 113 | 250 | 2 | 3 | 338 | 569 | 231 |
undo global data | 0.41 | 0.30 | -0.10 | 1,065,491 | 1,411,978 | 73 | 266 | 70 | 260 | 3 | 6 | 675 | 1,061 | 386 |
Consistent RBA | 0.00 | 0.10 | 0.10 | 178,907 | 242,581 | 0 | 3 | 0 | 1 | 0 | 2 | 0 | 1,663 | 1,663 |
redo writing | 0.00 | 0.10 | 0.10 | 566,775 | 775,992 | 19 | 49 | 19 | 47 | 0 | 2 | 0 | 698 | 698 |
sequence cache | 0.00 | 0.10 | 0.10 | 154,907 | 216,625 | 23 | 95 | 23 | 93 | 0 | 2 | 0 | 111 | 111 |
session allocation | 0.00 | 0.10 | 0.10 | 183,644 | 257,900 | 19 | 57 | 19 | 55 | 0 | 2 | 0 | 335 | 335 |
checkpoint queue latch | 0.14 | 0.05 | -0.09 | 1,348,925 | 2,062,780 | 41 | 124 | 40 | 123 | 1 | 1 | 134 | 35 | -99 |
ASM map operation hash table | 0.00 | 0.05 | 0.05 | 2,245,333 | 3,306,049 | 1 | 14 | 1 | 13 | 0 | 1 | 0 | 243 | 243 |
post/wait queue | 0.00 | 0.05 | 0.05 | 271,590 | 373,240 | 31 | 49 | 31 | 48 | 0 | 1 | 0 | 410 | 410 |
simulator lru latch | 0.41 | 0.45 | 0.05 | 20,843 | 32,455 | 148 | 413 | 145 | 404 | 3 | 9 | 3,967 | 9,434 | 5,467 |
Wait Time (cs) | Get Requests | Misses | Spin Gets | Sleeps | % of Total Sleeps | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Latch Name | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | Diff |
cache buffers chains | 55,570 | 338,795 | 283,225 | 505,924,400 | 804,374,724 | 239,995 | 1,488,116 | 239,545 | 1,486,761 | 450 | 1,355 | 61.14 | 68.43 | 7.29 |
simulator hash latch | 9,841 | 100,030 | 90,189 | 21,646,930 | 34,366,849 | 1,507 | 4,316 | 1,485 | 4,217 | 22 | 100 | 2.99 | 5.05 | 2.06 |
In memory undo latch | 19,007 | 45,258 | 26,251 | 1,305,440 | 1,391,681 | 277 | 395 | 120 | 140 | 158 | 257 | 21.47 | 12.98 | -8.49 |
session idle bit | 5,565 | 26,212 | 20,647 | 5,405,487 | 7,568,121 | 438 | 1,281 | 406 | 1,227 | 32 | 54 | 4.35 | 2.73 | -1.62 |
shared pool | 0 | 17,883 | 17,883 | 2,350 | 32,027 | 3 | 56 | 3 | 50 | 0 | 14 | 0.00 | 0.71 | 0.71 |
object queue header operation | 3,496 | 16,294 | 12,798 | 2,330,854 | 3,523,023 | 450 | 1,146 | 436 | 1,093 | 14 | 54 | 1.90 | 2.73 | 0.83 |
redo allocation | 1,762 | 12,289 | 10,527 | 900,547 | 1,141,712 | 316 | 1,022 | 305 | 978 | 11 | 44 | 1.49 | 2.22 | 0.73 |
enqueue hash chains | 3,154 | 8,762 | 5,608 | 888,071 | 1,240,957 | 227 | 459 | 213 | 431 | 14 | 28 | 1.90 | 1.41 | -0.49 |
simulator lru latch | 3,967 | 9,434 | 5,467 | 20,843 | 32,455 | 148 | 413 | 145 | 404 | 3 | 9 | 0.41 | 0.45 | 0.05 |
cache buffers lru chain | 894 | 5,537 | 4,643 | 451,916 | 703,390 | 181 | 432 | 171 | 410 | 10 | 23 | 1.36 | 1.16 | -0.20 |
row cache objects | 0 | 2,242 | 2,242 | 8,350 | 55,238 | 2 | 60 | 2 | 52 | 0 | 8 | 0.00 | 0.40 | 0.40 |
Consistent RBA | 0 | 1,663 | 1,663 | 178,907 | 242,581 | 0 | 3 | 0 | 1 | 0 | 2 | 0.00 | 0.10 | 0.10 |
DML lock allocation | 640 | 2,291 | 1,651 | 498,223 | 698,726 | 43 | 84 | 39 | 77 | 4 | 7 | 0.54 | 0.35 | -0.19 |
redo writing | 0 | 698 | 698 | 566,775 | 775,992 | 19 | 49 | 19 | 47 | 0 | 2 | 0.00 | 0.10 | 0.10 |
post/wait queue | 0 | 410 | 410 | 271,590 | 373,240 | 31 | 49 | 31 | 48 | 0 | 1 | 0.00 | 0.05 | 0.05 |
undo global data | 675 | 1,061 | 386 | 1,065,491 | 1,411,978 | 73 | 266 | 70 | 260 | 3 | 6 | 0.41 | 0.30 | -0.10 |
session allocation | 0 | 335 | 335 | 183,644 | 257,900 | 19 | 57 | 19 | 55 | 0 | 2 | 0.00 | 0.10 | 0.10 |
mostly latch-free SCN | 4,930 | 4,677 | -253 | 182,081 | 247,788 | 635 | 958 | 622 | 929 | 13 | 29 | 1.77 | 1.46 | -0.30 |
ASM map operation hash table | 0 | 243 | 243 | 2,245,333 | 3,306,049 | 1 | 14 | 1 | 13 | 0 | 1 | 0.00 | 0.05 | 0.05 |
messages | 338 | 569 | 231 | 616,540 | 852,994 | 115 | 253 | 113 | 250 | 2 | 3 | 0.27 | 0.15 | -0.12 |
sequence cache | 0 | 111 | 111 | 154,907 | 216,625 | 23 | 95 | 23 | 93 | 0 | 2 | 0.00 | 0.10 | 0.10 |
checkpoint queue latch | 134 | 35 | -99 | 1,348,925 | 2,062,780 | 41 | 124 | 40 | 123 | 1 | 1 | 0.14 | 0.05 | -0.09 |
% of Total Logical Reads | Logical Reads | % of Captured Logical Reads | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | %Diff | 1st | 2nd | Diff |
SOE | SOE | PRODUCT_INFORMATION | TABLE | 1.89 | 1.89 | 1.66 | 1.66 | -0.23 | 6,935,312 | 9,718,816 | 40.14 | 1.90 | 1.67 | -0.23 | |
SOE | SOE | CUSTOMERS | TABLE | 15.95 | 17.84 | 16.06 | 17.72 | 0.12 | 58,425,952 | 94,131,216 | 61.11 | 15.98 | 16.15 | 0.17 | |
SOE | SOE | CUSTOMERS_PK | INDEX | 32.03 | 49.87 | 32.06 | 49.78 | 0.03 | 117,354,960 | 187,892,784 | 60.11 | 32.09 | 32.24 | 0.15 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 32.13 | 82.00 | 32.10 | 81.88 | -0.03 | 117,716,448 | 188,119,184 | 59.81 | 32.19 | 32.28 | 0.09 | |
SOE | SOE | ORDERS | TABLE | 16.01 | 98.01 | 16.00 | 97.88 | -0.01 | 58,667,760 | 93,754,880 | 59.81 | 16.04 | 16.09 | 0.04 |
% of Total Physical Reads | Physical Reads | % of Captured Physical Reads | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | %Diff | 1st | 2nd | Diff |
SOE | SOE | CUSTOMERS_PK | INDEX | 19.79 | 19.79 | 18.12 | 18.12 | -1.67 | 103,490 | 140,248 | 35.52 | 19.87 | 18.23 | -1.64 | |
SOE | SOE | INVENTORIES | TABLE | 9.12 | 28.91 | 10.55 | 28.67 | 1.43 | 47,667 | 81,655 | 71.30 | 9.15 | 10.61 | 1.46 | |
SOE | SOE | CUSTOMERS | TABLE | 20.52 | 49.43 | 19.19 | 47.86 | -1.33 | 107,285 | 148,566 | 38.48 | 20.60 | 19.31 | -1.29 | |
SOE | SOE | ORD_CUSTOMER_IX | INDEX | 12.59 | 62.01 | 12.00 | 59.86 | -0.59 | 65,816 | 92,874 | 41.11 | 12.64 | 12.07 | -0.57 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 8.85 | 70.87 | 8.36 | 68.21 | -0.50 | 46,285 | 64,684 | 39.75 | 8.89 | 8.41 | -0.48 |
% of Total Read Requests | Read Requests | % of Captured Read Requests | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | %Diff | 1st | 2nd | Diff |
SOE | SOE | CUSTOMERS_PK | INDEX | 19.84 | 19.84 | 18.13 | 18.13 | -1.70 | 103,490 | 140,249 | 35.52 | 19.90 | 18.24 | -1.66 | |
SOE | SOE | INVENTORIES | TABLE | 9.14 | 28.97 | 10.56 | 28.69 | 1.42 | 47,667 | 81,655 | 71.30 | 9.17 | 10.62 | 1.45 | |
SOE | SOE | CUSTOMERS | TABLE | 20.56 | 49.53 | 19.21 | 47.90 | -1.35 | 107,283 | 148,563 | 38.48 | 20.63 | 19.32 | -1.31 | |
SOE | SOE | ORD_CUSTOMER_IX | INDEX | 12.61 | 62.15 | 12.01 | 59.91 | -0.61 | 65,816 | 92,874 | 41.11 | 12.66 | 12.08 | -0.58 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 8.87 | 71.02 | 8.36 | 68.27 | -0.51 | 46,285 | 64,682 | 39.75 | 8.90 | 8.41 | -0.49 |
% of Total UnOptimized Requests | UnOptimized Requests | % of Captured UnOptimized Reqs | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | %Diff | 1st | 2nd | Diff |
SOE | SOE | CUSTOMERS_PK | INDEX | 19.84 | 19.84 | 18.13 | 18.13 | -1.70 | 103,490 | 140,249 | 35.52 | 19.90 | 18.24 | -1.66 | |
SOE | SOE | INVENTORIES | TABLE | 9.14 | 28.97 | 10.56 | 28.69 | 1.42 | 47,667 | 81,655 | 71.30 | 9.17 | 10.62 | 1.45 | |
SOE | SOE | CUSTOMERS | TABLE | 20.56 | 49.53 | 19.21 | 47.90 | -1.35 | 107,283 | 148,563 | 38.48 | 20.63 | 19.32 | -1.31 | |
SOE | SOE | ORD_CUSTOMER_IX | INDEX | 12.61 | 62.15 | 12.01 | 59.91 | -0.61 | 65,816 | 92,874 | 41.11 | 12.66 | 12.08 | -0.58 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 8.87 | 71.02 | 8.36 | 68.27 | -0.51 | 46,285 | 64,682 | 39.75 | 8.90 | 8.41 | -0.49 |
% of Total Optimized Read Requests | Optimized Requests | % of Captured Optimized Reqs | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | %Diff | 1st | 2nd | Diff |
SYS | SYSTEM | AUD$ | TABLE | 0.00 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | ||||||
SYS | SYSTEM | CCOL$ | TABLE | 0.00 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | ||||||
SYS | SYSTEM | I_CCOL2 | INDEX | 0.00 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | ||||||
SYS | SYSTEM | I_HH_OBJ#_INTCOL# | INDEX | 0.00 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | ||||||
SYS | SYSTEM | I_JOB_NEXT | INDEX | 0.00 | 0.00 | 0.00 | 0 | 100.00 | 0.00 | 0.00 | |||||
SYS | SYSTEM | I_OBJ1 | INDEX | 0.00 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | ||||||
SYS | SYSTEM | OBJ$ | TABLE | 0.00 | 0.00 | 0.00 | 0 | 100.00 | 0.00 | 0.00 | |||||
SYS | SYSTEM | SCHEDULER$_JOB | TABLE | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | |
SYS | SYSAUX | SMON_SCN_TIME | TABLE | 0.00 | 0.00 | 0.00 | 0 | 100.00 | 0.00 | 0.00 | |||||
SYS | SYSAUX | WRI$_ADV_MESSAGE_GROUPS | TABLE | 0.00 | 0.00 | 0.00 | 0 | 100.00 | 0.00 | 0.00 |
% of Total Direct Reads | Direct Reads | % of Captured Direct Reads | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | %Diff | 1st | 2nd | Diff |
SYS | SYSTEM | AUD$ | TABLE | 0.00 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | ||||||
SYS | SYSTEM | CCOL$ | TABLE | 0.00 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | ||||||
SYS | SYSTEM | I_CCOL2 | INDEX | 0.00 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | ||||||
SYS | SYSTEM | I_HH_OBJ#_INTCOL# | INDEX | 0.00 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | ||||||
SYS | SYSTEM | I_JOB_NEXT | INDEX | 0.00 | 0.00 | 0.00 | 0 | 100.00 | 0.00 | 0.00 | |||||
SYS | SYSTEM | I_OBJ1 | INDEX | 0.00 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | ||||||
SYS | SYSTEM | OBJ$ | TABLE | 0.00 | 0.00 | 0.00 | 0 | 100.00 | 0.00 | 0.00 | |||||
SYS | SYSTEM | SCHEDULER$_JOB | TABLE | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | |
SYS | SYSAUX | SMON_SCN_TIME | TABLE | 0.00 | 0.00 | 0.00 | 0 | 100.00 | 0.00 | 0.00 | |||||
SYS | SYSAUX | WRI$_ADV_MESSAGE_GROUPS | TABLE | 0.00 | 0.00 | 0.00 | 0 | 100.00 | 0.00 | 0.00 |
% of Total Physical Writes | Physical Writes | % of Captured Physical Writes | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | %Diff | 1st | 2nd | Diff |
SOE | SOE | ITEM_PRODUCT_IX | INDEX | 8.77 | 8.77 | 12.08 | 12.08 | 3.31 | 29,854 | 63,064 | 111.24 | 9.24 | 12.72 | 3.48 | |
SOE | SOE | ORDER_PK | INDEX | 10.81 | 19.58 | 9.88 | 21.97 | -0.93 | 36,810 | 51,587 | 40.14 | 11.40 | 10.40 | -0.99 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 9.58 | 29.17 | 8.72 | 30.69 | -0.86 | 32,622 | 45,517 | 39.53 | 10.10 | 9.18 | -0.92 | |
SOE | SOE | ORDER_ITEMS_PK | INDEX | 9.56 | 38.73 | 8.72 | 39.40 | -0.84 | 32,536 | 45,490 | 39.81 | 10.07 | 9.17 | -0.90 | |
SOE | SOE | ORD_CUSTOMER_IX | INDEX | 10.38 | 49.10 | 9.60 | 49.00 | -0.78 | 35,321 | 50,087 | 41.81 | 10.94 | 10.10 | -0.83 | |
SOE | SOE | ORD_WAREHOUSE_IX | INDEX | 8.17 | 57.27 | 8.91 | 57.90 | 0.73 | 27,818 | 46,483 | 67.10 | 8.61 | 9.38 | 0.76 | |
SOE | SOE | INVENTORIES | TABLE | 20.08 | 77.35 | 20.06 | 77.96 | -0.02 | 68,342 | 104,693 | 53.19 | 21.16 | 21.12 | -0.04 |
% of Total Write Requests | Write Requests | % of Captured Write Requests | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | %Diff | 1st | 2nd | Diff |
SOE | SOE | INVENTORIES | TABLE | 15.60 | 15.60 | 17.78 | 17.78 | 2.18 | 36,889 | 68,215 | 84.92 | 15.74 | 17.97 | 2.24 | |
SOE | SOE | ORDER_PK | INDEX | 14.61 | 30.21 | 13.07 | 30.85 | -1.55 | 34,555 | 50,136 | 45.09 | 14.74 | 13.21 | -1.53 | |
SOE | SOE | ORD_CUSTOMER_IX | INDEX | 13.71 | 43.93 | 12.34 | 43.19 | -1.37 | 32,424 | 47,348 | 46.03 | 13.83 | 12.48 | -1.36 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 12.47 | 56.39 | 11.20 | 54.38 | -1.27 | 29,477 | 42,964 | 45.75 | 12.58 | 11.32 | -1.26 | |
SOE | SOE | ORDER_ITEMS_PK | INDEX | 12.70 | 69.09 | 11.52 | 65.90 | -1.18 | 30,019 | 44,184 | 47.19 | 12.81 | 11.64 | -1.17 |
% of Total Direct Writes | Direct Writes | % of Captured Direct Writes | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | %Diff | 1st | 2nd | Diff |
SYS | SYSAUX | SYS_LOB0000006339C00038$$ | LOB | 0.00 | 0.00 | 9.23 | 9.23 | 9.23 | 0 | 12 | 100.00 | 0.00 | 20.34 | 20.34 | |
SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_2532911053_1819 | TABLE PARTITION | 32.93 | 32.93 | 36.15 | 45.38 | 3.23 | 27 | 47 | 74.07 | 100.00 | 79.66 | -20.34 |
SYS | SYSTEM | CCOL$ | TABLE | 0.00 | 45.38 | 0.00 | 0 | 0.00 | 0.00 | ||||||
SYS | SYSTEM | I_CCOL2 | INDEX | 0.00 | 45.38 | 0.00 | 0 | 0.00 | 0.00 | ||||||
SYS | SYSTEM | I_JOB_NEXT | INDEX | 0.00 | 32.93 | 0.00 | 0 | 100.00 | 0.00 | 0.00 | |||||
SYS | SYSTEM | I_OBJ1 | INDEX | 0.00 | 45.38 | 0.00 | 0 | 0.00 | 0.00 | ||||||
SYS | SYSTEM | OBJ$ | TABLE | 0.00 | 32.93 | 0.00 | 0 | 100.00 | 0.00 | 0.00 | |||||
SYS | SYSAUX | SMON_SCN_TIME | TABLE | 0.00 | 32.93 | 0.00 | 0 | 100.00 | 0.00 | 0.00 | |||||
SYS | SYSAUX | WRI$_ADV_MESSAGE_GROUPS | TABLE | 0.00 | 32.93 | 0.00 | 0 | 100.00 | 0.00 | 0.00 |
% of Total Table Scans | Table Scans | % of Captured Table Scans | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | %Diff | 1st | 2nd | Diff |
SYS | SYSTEM | AUD$ | TABLE | 0.00 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | ||||||
SYS | SYSTEM | CCOL$ | TABLE | 0.00 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | ||||||
SYS | SYSTEM | I_CCOL2 | INDEX | 0.00 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | ||||||
SYS | SYSTEM | I_HH_OBJ#_INTCOL# | INDEX | 0.00 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | ||||||
SYS | SYSTEM | I_JOB_NEXT | INDEX | 0.00 | 0.00 | 0.00 | 0 | 100.00 | 0.00 | 0.00 | |||||
SYS | SYSTEM | I_OBJ1 | INDEX | 0.00 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | ||||||
SYS | SYSTEM | OBJ$ | TABLE | 0.00 | 0.00 | 0.00 | 0 | 100.00 | 0.00 | 0.00 | |||||
SYS | SYSTEM | SCHEDULER$_JOB | TABLE | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | |
SYS | SYSAUX | SMON_SCN_TIME | TABLE | 0.00 | 0.00 | 0.00 | 0 | 100.00 | 0.00 | 0.00 | |||||
SYS | SYSAUX | WRI$_ADV_MESSAGE_GROUPS | TABLE | 0.00 | 0.00 | 0.00 | 0 | 100.00 | 0.00 | 0.00 |
% of Total Block Changes | DB Block Changes | % of Captured Block Changes | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | %Diff | 1st | 2nd | Diff |
SOE | SOE | ORDERS | TABLE | 2.77 | 2.77 | 4.45 | 4.45 | 1.69 | 70,528 | 158,800 | 125.16 | 13.67 | 15.44 | 1.77 | |
SOE | SOE | ORD_WAREHOUSE_IX | INDEX | 3.13 | 5.90 | 4.44 | 8.90 | 1.31 | 79,824 | 158,336 | 98.36 | 15.47 | 15.39 | -0.08 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 2.48 | 8.38 | 3.63 | 12.52 | 1.15 | 63,184 | 129,296 | 104.63 | 12.24 | 12.57 | 0.33 | |
SOE | SOE | INVENTORIES | TABLE | 2.54 | 10.92 | 2.99 | 15.51 | 0.45 | 64,816 | 106,592 | 64.45 | 12.56 | 10.36 | -2.20 | |
SOE | SOE | ORDER_ITEMS | TABLE | 3.58 | 14.50 | 3.62 | 19.13 | 0.04 | 91,216 | 128,960 | 41.38 | 17.68 | 12.54 | -5.14 |
% of Total | Row Lock Waits | % of Captured | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 2nd | Diff | 1st | 2nd | %Diff | 1st | 1st Total | 2nd | 2nd Total | Diff |
SOE | SOE | ORDERS | TABLE | 100.15 | 99.76 | -0.39 | 685 | 1,227 | 79.12 | 56.94 | 56.94 | 74.68 | 74.68 | 17.74 | |
SOE | SOE | ORD_ORDER_DATE_IX | INDEX | 42.69 | 11.71 | -30.98 | 292 | 144 | -50.68 | 24.27 | 81.21 | 8.76 | 83.44 | -15.51 | |
SOE | SOE | ORD_WAREHOUSE_IX | INDEX | 5.12 | 8.46 | 3.34 | 35 | 104 | 197.14 | 2.91 | 84.12 | 6.33 | 89.77 | 3.42 | |
SOE | SOE | ITEM_PRODUCT_IX | INDEX | 14.04 | 6.42 | -7.61 | 96 | 79 | -17.71 | 7.98 | 92.10 | 4.81 | 94.58 | -3.17 | |
SOE | SOE | CUST_LNAME_IX | INDEX | 3.51 | -3.51 | 24 | 2.00 | 94.10 | -2.00 | ||||||
SOE | SOE | CUST_ACCOUNT_MANAGER_IX | INDEX | 1.79 | 1.79 | 22 | 1.34 | 95.92 | 1.34 |
% of Total Buffer Busy Waits | Buffer Busy Waits | % of Captured Buffer Busy Waits | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | %Diff | 1st | 2nd | Diff |
SOE | SOE | ORDERS | TABLE | 88.83 | 88.83 | 81.82 | 81.82 | -7.01 | 334 | 522 | 56.29 | 96.53 | 92.72 | -3.81 | |
SOE | SOE | ORD_ORDER_DATE_IX | INDEX | 0.80 | 89.63 | 2.04 | 83.86 | 1.24 | 3 | 13 | 333.33 | 0.87 | 2.31 | 1.44 | |
SOE | SOE | CUSTOMERS_PK | INDEX | 1.06 | 90.69 | 0.00 | 83.86 | -1.06 | 4 | 0 | -100.00 | 1.16 | 0.00 | -1.16 | |
SYS | SYSTEM | AUD$ | TABLE | 0.94 | 84.80 | 0.94 | 6 | 1.07 | 1.07 | ||||||
SOE | SOE | ORDER_ITEMS | TABLE | 0.27 | 90.96 | 0.78 | 85.58 | 0.52 | 1 | 5 | 400.00 | 0.29 | 0.89 | 0.60 | |
SOE | SOE | ORDER_PK | INDEX | 0.53 | 91.49 | 0.78 | 86.36 | 0.25 | 2 | 5 | 150.00 | 0.58 | 0.89 | 0.31 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 0.53 | 92.02 | 0.47 | 86.83 | -0.06 | 2 | 3 | 50.00 | 0.58 | 0.53 | -0.05 |
Get Requests per Sec (DB time) | Get Requests per 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 | 19 | 19 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | 2 | 2 | 1 | 1 |
dc_global_oids | 0.00 | 0.00 | 0.00 | 0.01 | 0.06 | 500.00 | 7 | 53 | 0.00 | 5.66 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 24 | 24 |
dc_histogram_data | 0.01 | 0.22 | 2,100.00 | 0.09 | 3.07 | 3,311.11 | 78 | 2,769 | 44.87 | 15.31 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 2,000 | 2,149 |
dc_histogram_defs | 0.01 | 0.43 | 4,200.00 | 0.05 | 5.97 | 11,840.00 | 41 | 5,387 | 12.20 | 29.03 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 2,024 | 2,942 |
dc_object_grants | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 2 | 0.00 | 50.00 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 5 | 10 |
dc_objects | 0.04 | 0.22 | 450.00 | 0.25 | 3.06 | 1,124.00 | 229 | 2,759 | 0.44 | 7.29 | 0 | 0 | 0.00 | 0.00 | 1 | 1 | 1,501 | 1,264 |
dc_profiles | 0.00 | 0.00 | 0.00 | 0.00 | 0.02 | 100.00 | 2 | 17 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 1 | 1 |
dc_rollback_segments | 0.15 | 0.08 | -46.67 | 1.07 | 1.18 | 10.28 | 963 | 1,068 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 78 | 78 |
dc_segments | 0.02 | 0.10 | 400.00 | 0.13 | 1.39 | 969.23 | 121 | 1,253 | 0.00 | 8.70 | 0 | 0 | 0.00 | 0.00 | 10 | 15 | 614 | 463 |
dc_sequences | 0.00 | 0.00 | 0.00 | 0.01 | 0.02 | 100.00 | 10 | 14 | 0.00 | 42.86 | 0 | 0 | 0.00 | 0.00 | 10 | 14 | 5 | 7 |
dc_tablespaces | 0.08 | 0.22 | 175.00 | 0.56 | 3.07 | 448.21 | 506 | 2,769 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 7 | 7 |
dc_users | 0.04 | 0.23 | 475.00 | 0.26 | 3.28 | 1,161.54 | 234 | 2,960 | 0.00 | 0.71 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 46 | 22 |
global database name | 0.10 | 0.05 | -50.00 | 0.68 | 0.70 | 2.94 | 612 | 629 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 1 | 1 |
outstanding_alerts | 0.00 | 0.00 | 0.00 | 0.01 | 0.01 | 0.00 | 8 | 8 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 4 | 4 |
sch_lj_oids | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2 | 2 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 1 | 1 |
Get Requests per Sec (DB Time) | Get Requests per 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 |
ACCOUNT_STATUS | 0.00 | 0.00 | 0.00 | 0.00 | 0.03 | 100.00 | 0 | 30 | 3.33 | 0 | 0 | 0 | 0 | 0 | 0 | |||
BODY | 0.00 | 0.00 | 0.00 | 0.02 | 0.03 | 50.00 | 15 | 30 | 0.00 | 6.67 | 44 | 59 | 0.00 | 5.08 | 0 | 1 | 0 | 0 |
CLUSTER | 0.00 | 0.00 | 0.00 | 0.00 | 0.04 | 100.00 | 2 | 36 | 0.00 | 2.78 | 2 | 36 | 0.00 | 2.78 | 0 | 0 | 0 | 0 |
DBLINK | 0.00 | 0.00 | 0.00 | 0.00 | 0.03 | 100.00 | 1 | 31 | 0.00 | 3.23 | 0 | 0 | 0 | 0 | 0 | 0 | ||
EDITION | 0.00 | 0.00 | 0.00 | 0.01 | 0.03 | 200.00 | 8 | 23 | 0.00 | 0.00 | 8 | 38 | 0.00 | 7.89 | 0 | 0 | 0 | 0 |
INDEX | 0.00 | 0.00 | 0.00 | 0.00 | 0.02 | 100.00 | 0 | 15 | 6.67 | 0 | 15 | 6.67 | 0 | 0 | 0 | 0 | ||
QUEUE | 0.04 | 0.02 | -50.00 | 0.29 | 0.29 | 0.00 | 262 | 266 | 0.00 | 0.00 | 262 | 266 | 0.00 | 0.00 | 0 | 0 | 0 | 0 |
SCHEMA | 0.00 | 0.01 | 100.00 | 0.00 | 0.18 | 100.00 | 1 | 160 | 0.00 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | ||
SQL AREA | 0.06 | 0.12 | 100.00 | 0.41 | 1.63 | 297.56 | 372 | 1,470 | 1.08 | 8.91 | 1,230,463 | 1,728,755 | -0.02 | 0.02 | 1 | 211 | 0 | 0 |
SQL AREA BUILD | 0.00 | 0.03 | 100.00 | 0.01 | 0.39 | 3,800.00 | 5 | 350 | 100.00 | 83.71 | 0 | 0 | 0 | 0 | 0 | 0 | ||
SQL AREA STATS | 0.00 | 0.02 | 100.00 | 0.01 | 0.33 | 3,200.00 | 5 | 300 | 80.00 | 54.00 | 5 | 300 | 80.00 | 54.00 | 0 | 0 | 0 | 0 |
TABLE/PROCEDURE | 0.00 | 0.11 | 100.00 | 0.03 | 1.56 | 5,100.00 | 27 | 1,405 | 0.00 | 8.83 | 103,351 | 147,455 | 0.00 | 0.67 | 1 | 468 | 0 | 0 |
1st | 2nd | % Diff of | |||||||
---|---|---|---|---|---|---|---|---|---|
Category | Summary | Begin Value | End Value | %Diff | Begin Value | End Value | %Diff | Begin Values | End Values |
Freeable | Alloc (KB) | 24,128.00 | 24,704.00 | 2.39 | 25,984.00 | 26,816.00 | 3.20 | 7.69 | 8.55 |
Freeable | Used (KB) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
Freeable | Avg Alloc (KB) | 832.00 | 796.90 | -4.22 | 812.00 | 812.61 | 0.07 | -2.40 | 1.97 |
Freeable | Std Dev Alloc (KB) | 466.24 | 434.02 | -6.91 | 429.31 | 438.32 | 2.10 | -7.92 | 0.99 |
Freeable | Max Alloc (KB) | 1,792.00 | 1,152.00 | -35.71 | 1,152.00 | 1,152.00 | 0.00 | -35.71 | 0.00 |
Freeable | Hist Max Alloc (KB) | ||||||||
Freeable | Num Procs | 29.00 | 31.00 | 6.90 | 32.00 | 33.00 | 3.13 | 10.34 | 6.45 |
Freeable | Num Alloc | 29.00 | 31.00 | 6.90 | 32.00 | 33.00 | 3.13 | 10.34 | 6.45 |
Other | Alloc (KB) | 155,103.87 | 157,590.88 | 1.60 | 158,156.20 | 189,296.55 | 19.69 | 1.97 | 20.12 |
Other | Used (KB) | ||||||||
Other | Avg Alloc (KB) | 2,674.20 | 2,671.03 | -0.12 | 2,680.61 | 2,558.06 | -4.57 | 0.24 | -4.23 |
Other | Std Dev Alloc (KB) | 2,474.61 | 2,455.54 | -0.77 | 2,469.08 | 2,220.21 | -10.08 | -0.22 | -9.58 |
Other | Max Alloc (KB) | 14,327.98 | 14,647.98 | 0.00 | 14,647.98 | 14,647.98 | 0.00 | 2.23 | 2.23 |
Other | Hist Max Alloc (KB) | 25,911.98 | 25,911.98 | 0.00 | 25,911.98 | 25,911.98 | 0.00 | 0.00 | 0.00 |
Other | Num Procs | 58.00 | 59.00 | 1.72 | 59.00 | 74.00 | 25.42 | 1.72 | 25.42 |
Other | Num Alloc | 58.00 | 59.00 | 1.72 | 59.00 | 74.00 | 25.42 | 1.72 | 25.42 |
PL/SQL | Alloc (KB) | 2,467.14 | 2,469.10 | 0.08 | 4,171.00 | 4,537.88 | 8.80 | 69.06 | 83.79 |
PL/SQL | Used (KB) | 2,139.15 | 2,139.37 | 0.01 | 2,469.05 | 2,745.84 | 11.21 | 15.42 | 28.35 |
PL/SQL | Avg Alloc (KB) | 42.54 | 41.85 | -1.62 | 70.69 | 61.32 | -13.26 | 66.20 | 46.53 |
PL/SQL | Std Dev Alloc (KB) | 181.40 | 179.90 | -0.82 | 377.19 | 336.73 | -10.73 | 107.94 | 87.18 |
PL/SQL | Max Alloc (KB) | 1,377.02 | 2,903.63 | 0.00 | 2,903.63 | 2,903.63 | 0.00 | 110.86 | 110.86 |
PL/SQL | Hist Max Alloc (KB) | 1,751.77 | 1,751.77 | 0.00 | 3,820.80 | 3,820.80 | 0.00 | 118.11 | 118.11 |
PL/SQL | Num Procs | 58.00 | 59.00 | 1.72 | 59.00 | 74.00 | 25.42 | 1.72 | 25.42 |
PL/SQL | Num Alloc | 58.00 | 59.00 | 1.72 | 59.00 | 74.00 | 25.42 | 1.72 | 25.42 |
SQL | Alloc (KB) | 839.35 | 833.34 | -0.72 | 1,070.30 | 1,605.10 | 49.97 | 27.51 | 92.61 |
SQL | Used (KB) | 94.56 | 92.43 | -2.26 | 133.24 | 117.38 | -11.90 | 40.90 | 27.00 |
SQL | Avg Alloc (KB) | 20.98 | 20.33 | -3.14 | 26.10 | 29.18 | 11.79 | 24.40 | 43.58 |
SQL | Std Dev Alloc (KB) | 29.93 | 30.04 | 0.38 | 35.69 | 32.51 | -8.90 | 19.24 | 8.21 |
SQL | Max Alloc (KB) | 165.77 | 153.84 | 0.00 | 153.84 | 153.84 | 0.00 | -7.20 | -7.20 |
SQL | Hist Max Alloc (KB) | 9,671.64 | 9,671.64 | 0.00 | 5,335.06 | 5,335.06 | 0.00 | -44.84 | -44.84 |
SQL | Num Procs | 40.00 | 41.00 | 2.50 | 41.00 | 55.00 | 34.15 | 2.50 | 34.15 |
SQL | Num Alloc | 36.00 | 36.00 | 0.00 | 37.00 | 51.00 | 37.84 | 2.78 | 41.67 |
1st | 2nd | % Diff of | ||||||
---|---|---|---|---|---|---|---|---|
SGA regions | Begin Value (KB) | End Value (KB) | %Diff | Begin Value (KB) | End Value (KB) | %Diff | Begin Values | End Values |
Database Buffers | 745,472.00 | 745,472.00 | 0.00 | 745,472.00 | 745,472.00 | 0.00 | 0.00 | 0.00 |
Fixed Size | 2,182.82 | 2,182.82 | 0.00 | 2,182.82 | 2,182.82 | 0.00 | 0.00 | 0.00 |
Redo Buffers | 9,508.00 | 9,508.00 | 0.00 | 9,508.00 | 9,508.00 | 0.00 | 0.00 | 0.00 |
Variable Size | 286,721.18 | 286,721.18 | 0.00 | 286,721.18 | 286,721.18 | 0.00 | 0.00 | 0.00 |
1st | 2nd | %Diff of | |||||||
---|---|---|---|---|---|---|---|---|---|
Pool | Name | Begin Value | End Value | %Diff | Begin Value | End Value | %Diff | Begin Values | End Values |
java pool | free memory | 4,194,304 | 4,194,304 | 0.00 | 4,194,304 | 4,194,304 | 0.00 | 0.00 | 0.00 |
large pool | ASM map operations hashta | 393,216 | 393,216 | 0.00 | 393,216 | 393,216 | 0.00 | 0.00 | 0.00 |
large pool | PX msg pool | 3,894,304 | 3,894,304 | 0.00 | 3,894,304 | 3,894,304 | 0.00 | 0.00 | 0.00 |
large pool | free memory | 4,101,088 | 4,101,088 | 0.00 | 4,101,088 | 4,101,088 | 0.00 | 0.00 | 0.00 |
shared pool | ASH buffers | 16,777,216 | 16,777,216 | 0.00 | 16,777,216 | 16,777,216 | 0.00 | 0.00 | 0.00 |
shared pool | KCB Table Scan Buffer | 3,981,120 | 3,981,120 | 0.00 | 3,981,120 | 3,981,120 | 0.00 | 0.00 | 0.00 |
shared pool | KGLH0 | 19,337,416 | 19,329,344 | -0.04 | 19,305,408 | 17,465,064 | -9.53 | -0.17 | -9.64 |
shared pool | KGLHD | 3,996,784 | 4,004,704 | 0.20 | 4,035,656 | 3,361,472 | -16.71 | 0.97 | -16.06 |
shared pool | KGLS | 4,575,608 | 4,579,656 | 0.09 | 5,113,408 | 5,132,424 | 0.37 | 11.75 | 12.07 |
shared pool | KGLSG | 5,266,008 | 5,266,008 | 0.00 | 5,266,008 | 5,266,008 | 0.00 | 0.00 | 0.00 |
shared pool | KKSSP | 2,854,688 | 2,894,984 | 1.41 | 2,916,088 | 3,738,216 | 28.19 | 2.15 | 29.13 |
shared pool | KSFD SGA I/O b | 3,977,144 | 3,977,144 | 0.00 | 3,977,144 | 3,977,144 | 0.00 | 0.00 | 0.00 |
shared pool | PLMCD | 3,354,032 | 3,354,032 | 0.00 | 4,258,776 | 26.97 | |||
shared pool | SQLA | 23,338,816 | 23,407,920 | 0.30 | 45,819,296 | 22,795,944 | -50.25 | 96.32 | -2.61 |
shared pool | db_block_hash_buckets | 5,836,800 | 5,836,800 | 0.00 | 5,836,800 | 5,836,800 | 0.00 | 0.00 | 0.00 |
shared pool | dbwriter coalesce buffer | 3,979,264 | 3,979,264 | 0.00 | 3,979,264 | 3,979,264 | 0.00 | 0.00 | 0.00 |
shared pool | dirty object counts array | 4,194,304 | 4,194,304 | 0.00 | 4,194,304 | 4,194,304 | 0.00 | 0.00 | 0.00 |
shared pool | event statistics per sess | 3,245,824 | 3,245,824 | 0.00 | 3,245,824 | 3,245,824 | 0.00 | 0.00 | 0.00 |
shared pool | free memory | 91,372,768 | 91,214,776 | -0.17 | 69,082,344 | 94,734,712 | 37.13 | -24.40 | 3.86 |
shared pool | kglsim hash table bkts | 4,194,304 | 4,194,304 | 0.00 | 4,194,304 | 4,194,304 | 0.00 | 0.00 | 0.00 |
shared pool | ksunfy : SSO free list | 3,025,600 | 3,025,600 | 0.00 | 3,025,600 | 3,025,600 | 0.00 | 0.00 | 0.00 |
shared pool | private strands | 3,677,184 | 3,677,184 | 0.00 | 3,677,184 | 3,677,184 | 0.00 | 0.00 | 0.00 |
shared pool | row cache | 7,593,704 | 7,593,704 | 0.00 | 7,593,704 | 7,593,704 | 0.00 | 0.00 | 0.00 |
shared pool | write state object | 3,853,680 | 3,853,680 | 0.00 | 3,853,680 | 3,853,680 | 0.00 | 0.00 | 0.00 |
streams pool | free memory | 8,376,440 | 8,376,440 | 0.00 | 8,376,440 | 8,376,440 | 0.00 | 0.00 | 0.00 |
buffer_cache | 763,363,328 | 763,363,328 | 0.00 | 763,363,328 | 763,363,328 | 0.00 | 0.00 | 0.00 | |
fixed_sga | 2,235,208 | 2,235,208 | 0.00 | 2,235,208 | 2,235,208 | 0.00 | 0.00 | 0.00 | |
log_buffer | 9,736,192 | 9,736,192 | 0.00 | 9,736,192 | 9,736,192 | 0.00 | 0.00 | 0.00 |
CPU Time (sec) | User I/O Time (sec) | System I/O Time (sec) | |||||||
---|---|---|---|---|---|---|---|---|---|
Session Type | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff |
QMON Coordinator | 0.00 | 0.00 | 199.80 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
QMON Slaves | 0.02 | 0.02 | 26.31 | 0.05 | 0.13 | 181.88 | 0.00 | 0.00 | 0.00 |
IO Time (sec) | CPU Time (sec) | |||||||||
---|---|---|---|---|---|---|---|---|---|---|
Session Type | 1st User | 1st System | 1st Total | 2nd User | 2nd System | 2nd Total | Total %Diff | 1st | 2nd | %Diff |
QMON Slaves | 0.05 | 0.00 | 0.05 | 0.13 | 0.00 | 0.13 | 181.88 | 0.02 | 0.02 | 26.31 |
QMON Coordinator | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 199.80 |
Enq Msgs | Enq Msgs/sec | Deq Msgs | Deq Msgs/sec | Spill Msgs | Spill Msgs/sec | %Spill Msgs | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Queue Name | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd |
SYS.SCHEDULER$_EVENT_QUEUE(12613) | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 |
Avg Total Connections | Avg Active Connections | Avg Total Shared Servers | Avg Active Shared Servers | Avg Total Dispatchers | Avg Active Dispatchers | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1st | 2nd | Diff | %Diff | 1st | 2nd | Diff | %Diff | 1st | 2nd | Diff | %Diff | 1st | 2nd | Diff | %Diff | 1st | 2nd | Diff | %Diff | 1st | 2nd | Diff | %Diff |
0 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0.00 |
Common Queue Per Sec | Dispatcher Queue Per Sec | Server Messages Per Sec | Server KB Per Sec | Common Queue Total | Dispatcher Queue Total | Server Total Messages | Server Total KB | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1st | 2nd | Diff | %Diff | 1st | 2nd | Diff | %Diff | 1st | 2nd | Diff | %Diff | 1st | 2nd | Diff | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff |
0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0 | 0 | 0.00 | 0 | 0 | 0.00 | 0 | 0 | 0.00 |
Avg Connections (per Dispatcher) | Avg %Busy | Avg %Idle | Total Queued (all Dispatchers) | Average Queued per Dispatcher | Average Queued Wait (ms) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1st | 2nd | %Diff | 1st | 2nd | Diff | 1st | 2nd | Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff |
0.00 | 0.00 |
1st Period | 2nd Period | |||
---|---|---|---|---|
Parameter Name | Begin Snap Value | End Snap Value | Begin Snap Value | End Snap Value |
audit_file_dest | /u00/app/oracle/admin/DBM11203/a | |||
audit_trail | DB | |||
control_files | +DATA/dbm11203/controlfile/curre | |||
core_dump_dest | /u00/app/oracle/diag/rdbms/dbm11 | |||
cursor_sharing | EXACT | |||
db_block_size | 8192 | |||
db_create_file_dest | +DATA | |||
db_domain | antognini.ch | |||
db_name | DBM11203 | |||
db_recovery_file_dest | +FRA | |||
db_recovery_file_dest_size | 2147483648 | |||
diagnostic_dest | /u00/app/oracle | |||
local_listener | (DESCRIPTION=(ADDRESS=(PROTOCOL= | |||
log_buffer | 8183808 | |||
open_cursors | 30 | |||
optimizer_dynamic_sampling | 2 | |||
optimizer_mode | ALL_ROWS | |||
pga_aggregate_target | 134217728 | |||
plsql_warnings | DISABLE:ALL | |||
processes | 150 | |||
query_rewrite_enabled | TRUE | |||
remote_login_passwordfile | EXCLUSIVE | |||
result_cache_max_size | 2031616 | |||
sga_target | 1073741824 | |||
skip_unusable_indexes | TRUE | |||
undo_tablespace | UNDOTBS1 | |||
user_dump_dest | /u00/app/oracle/diag/rdbms/dbm11 |
1st Period | 2nd Period | |||
---|---|---|---|---|
Parameter Name | Begin Snap Value | End Snap Value | Begin Snap Value | End Snap Value |
control_files | +DATA/dbm11203/controlfile/current.455.772715921 | |||
control_files | +FRA/dbm11203/controlfile/current.332.772715921 |