AWRRPT_HTML_TYPE_TABLE(AWRRPT_HTML_TYPE('
Snapshot Set | DB Name | DB Id | Instance | Inst num | Release | Cluster | Host | Std Block Size |
---|---|---|---|---|---|---|---|---|
First (1st) | PWHD | 4252952393 | pwhd | 1 | 11.1.0.6.0 | NO | PDBH | 8192 |
Second (2nd) | PWHD | 4252952393 | pwhd | 1 | 11.1.0.6.0 | NO | PDBH | 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 | 53 | 13-Nov-11 14:04:13 (Sun) | 54 | 13-Nov-11 14:05:07 (Sun) | 1.06 | 0.90 | 0.96 |
2nd | 55 | 13-Nov-11 14:21:42 (Sun) | 56 | 13-Nov-11 14:22:03 (Sun) | 1.19 | 0.34 | 0.41 |
%Diff | 12.26 | -62.22 | -57.23 |
1st | 2nd | Diff | %Diff | |
---|---|---|---|---|
Number of CPUs: | 2 | 2 | 0 | 0.00 |
Number of CPU Cores: | 2 | 2 | 0 | 0.00 |
Number of CPU Sockets: | 1 | 1 | 0 | 0.00 |
Physical Memory: | 4056M | 4056M | 0M | 0.00 |
%User Time: | 54.76 | 56.87 | 2.12 | 3.85 |
%System Time: | 5.47 | 5.97 | .51 | 9.14 |
%Idle Time: | 39.78 | 37.15 | -2.62 | -6.61 |
1st | 2nd | Diff | %Diff | |
---|---|---|---|---|
SGA Target: | 0M | 0.00 | ||
Buffer Cache: | 696M | 664M | -32M | -4.60 |
Shared Pool Size: | 240M | 256M | 16M | 6.67 |
Large Pool Size: | 8M | 8M | 0M | 0.00 |
Java Pool Size: | 16M | 16M | 0M | 0.00 |
Streams Pool Size: | 0M | 16M | 100.00 | |
Log Buffer: | 4,536K | 4,536K | 0K | 0.00 |
PGA Aggregate Target: | 0M | 0.00 | ||
Undo Management: | AUTO | AUTO |
1st per sec | 2nd per sec | %Diff | 1st per txn | 2nd per txn | %Diff | |
---|---|---|---|---|---|---|
DB time: | 1.06 | 1.19 | 12.26 | 1.59 | 1.17 | -26.42 |
CPU time: | 1.02 | 1.07 | < span style="font-style:italic"> 4.90 | 1.53 | 1.05 | -31.37 |
Redo size: | 61,340.61 | 313,507.38 | 411.09 | 91,842.22 | 307,416.38 | 234.72 |
Logical reads: | 22,044.27 | 21,979.41 | -0.29 | 33,005.78 | 21,552.38 | -34.70 |
Block changes: | 368.84 | 1,568.72 | 325.31 | 552.25 | 1,538.24 | 178.54 |
Physical reads: | 0.13 | 2.14 | 1,546.15 | 0.19 | 2.10 | 1,005.26 |
Physical writes: | 10.35 | 18.21 | 75.94 | 15.50 | 17.86 | 15.23 |
User calls: | 3.91 | 5.20 | 32.99 | 5.86 | 5.10 | -12.97 |
Parses: | 16.25 | 46.67 | 187.20 | 24.33 | 45.76 | 88.08 |
Hard parses: | 0.02 | 13.79 | 68,850.00 | 0.03 | 13.52 | 44,966.67 |
Sorts: | 11.98 | 25.35 | 111.60 | 17.94 | 24.86 | 38.57 |
Logons: | 0.07 | 0.19 | 171.43 | 0.11 | 0.19 | 72.73 |
Executes: | 301.11 | 348.14 | 15.62 | 450.83 | 341.38 | -24.28 |
Transactions: | 0.67 | 1.02 | 52.24 |
1st | 2nd | Diff | |
---|---|---|---|
% Blocks changed per Read: | 1.67 | 7.14 | 5.46 |
Recursive Call %: | 99.01 | 99.65 | 0.64 |
Rollback per transaction %: | 8.33 | 4.76 | -3.57 |
Rows per Sort: | 8.80 | 17.40 | 8.61 |
Avg DB time per Call (sec): | 0.27 | 0.23 | -0.04 |
1st | '), AWRRPT_HTML_TYPE('2nd | '), AWRRPT_HTML_TYPE('||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Event | Wait Class | Waits | Time(s) | Avg Time(ms) | %DB time | Event | Wait Class | Waits | Time(s) | Avg Time(ms) | %DB time |
CPU time | 55.05 | 96.06 | CPU time | 21.95 | 89.54 | ||||||
control file sequential read | System I/O | 732 | 0.61 | 0.83 | 1.06 | control file sequential read | System I/O | 727 | 0.50 | 0.68 | 2.02 |
db file sequential read | User I/O | 7 | 0.15 | 21.94 | 0.27 | db file sequential read | User I/O | 48 | 0.44 | 9.23 | 1.81 |
db file parallel write | System I/O | 106 | 0.09 | 0.88 | 0.16 | resmgr:cpu quantum | Scheduler | 11 | 0.27 | 24.50 | 1.10 |
resmgr:cpu quantum | Scheduler | 1 | 0.09 | 93.12 | 0.16 | log file parallel write | System I/O | 46 | 0.18 | 3.81 | 0.71 |
-log file parallel write | System I/O | 47 | 0.03 | 0.63 | 0.05 | -db file parallel write | System I/O | 28 | 0.02 | 0.61 | 0.07 |
% of DB time | '), AWRRPT_HTML_TYPE('Time (seconds) | '), AWRRPT_HTML_TYPE('Time per Trans (seconds) | '), AWRRPT_HTML_TYPE('|||||||
---|---|---|---|---|---|---|---|---|---|
Statistic Name | 1st | 2nd | Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff |
DB time | 100.00 | 100.00 | 0.00 | 57.31 | 24.51 | -57.23 | 1.59 | 1.17 | -26.42 |
DB CPU | 96.06 | 89.54 | -6.52 | 55.05 | 21.95 | -60.13 | 1.5 3 | 1.05 | -31.37 |
parse time elapsed | 0.06 | 4.52 | 4.46 | 0.03 | 1.11 | 3,600.00 | 0.00 | 0.05 | 100.00 |
hard parse elapsed time | 0.00 | 4.38 | 4.38 | 0.00 | 1.07 | 100.00 | 0.00 | 0.05 | 100.00 |
PL/SQL execution elapsed time | 2.04 | 2.58 | 0.53 | 1.17 | 0.63 | -46.15 | 0.03 | 0.03 | 0.00 |
hard parse (sharing criteria) elapsed time | 0.00 | 0.51 | 0.51 | 0.00 | 0.12 | 100.00 | 0.00 | 0.01 | 100 .00 |
PL/SQL compilation elapsed time | 0.00 | 0.08 | 0.08 | 0.00 | 0.02 | 100.00 | 0.00 | 0.00 | 0.00 |
connection management call elapsed time | 0.02 | 0.07 | 0.06 | 0.01 | 0.02 | 100.00 | 0.00 | 0.00 | 0.00 |
sql execute elapsed time | 99.31 | 99.35 | 0.04 | 56.91 | 24.35 | -57.21 | 1.58 | 1.16 | -26.58 |
repeated bind elapsed time | 0.23 | 0.22 | -0.01 | 0.13 | 0.05 | -61.54 | 0.00 | 0.00 | 0.00 |
sequence load elapsed t ime | 0.00 | 0.01 | 0.01 | 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 t | 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 |
hard parse (bind mismatch) 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 elapsed time | 0.81 | 1.16 | 0.35 | 0.46 | 0.29 | -36.96 | 0.01 | 0.01 | 0.00 |
background cpu time | 0.05 | 0.06 | 0.01 | 0.03 | 0.02 | -33.33 | 0.00 | 0.00 | 0.00 |
Value (centi-seconds) | '), AWRRPT_HTML_TYPE('per Second (DB time) | '), AWRRPT_HTML_TYPE('per Second (Elapsed Time) | '), AWRRPT_HTML_TYPE('per Trans | '), AWRRPT_HTML_TYPE('||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Statistic Name | 1st | 2nd | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff |
AVG_BUSY_TIME | 3,249 | 1,288 | 56.69 | 52.54 | -7.32 | 60.28 | 62.55 | 3.77 | 90.25 | 61.33 | -32.04 |
AVG_IDLE_TIME | 2,145 | 761 | 37.43 | 31.04 | -17.07 | 39.80 | 36.96 | -7.14 | 59.58 | 36.24 | -39.17 |
AVG_SYS_TIME | 293 | 122 | 5.11 | 4.98 | -2.54 | 5.44 | 5.92 | 8.82 | 8.14 | 5.81 | -28.62 |
AVG_USER_TIME | 2,954 | 1,166 | 51.54 | 47.56 | -7.72 | 54.80 | 56.62 | 3.32 | 82.06 | 55.52 | -32.34 |
BUSY_TIME | 6,500 | 2,578 | 113.41 | 105.16 | -7.27 | 120.59 | 125.19 | 3.81 | 180.56 | 122.76 | -32.01 |
IDLE_TIME | 4,293 | 1,524 | 74.91 | 62.17 | -17.01 | 79.65 | 74.01 | -7.08 | 119.25 | 72.57 | -39.14 |
RSRC_MGR_CPU_WAIT_TIME | 9 | 27 | 0.16 | 1.10 | 587.50 | 0.17 | 1.31 | 670.59 | 0.25 | 1.29 | 416.00 |
SYS_TIME | 590 | 245 | 10.29 | 9.99 | -2.92 | 10.95 | 11.90 | 8.68 | 16.39 | 11.67 | -28.80 |
USER_TIME | 5,910 | 2,333 | 103.12 | 95.17 | -7.71 | 109.65 | 113.30 | 3.33 | 164.17 | 111.10 | -32.33 |
VM_IN_BYTES | 143,360 | 69,259,264 | 2,501.37 | 2,825,285.87 | 112,849.54 | 2,659.69 | 3,363,406.37 | 126,358.59 | 3,982.22 | 3,298,060.19 | 82,719.64 |
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 | '), AWRRPT_HTML_TYPE('# Waits/sec (Elapsed Time) | '), AWRR PT_HTML_TYPE('Avg Wait Time (ms) | '), AWRRPT_HTML_TYPE('|||||||
---|---|---|---|---|---|---|---|---|---|
Wait Class | 1st | 2nd | Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff |
User I/O | 0.51 | 2.40 | 1.89 | 0.22 | 6.94 | 3,054.55 | 24.12 | 4.11 | -82.96 |
System I/O | 1.32 | 2.83 | 1.51 | 16.90 | 39.58 | 134.20 | 0.83 | 0.85 | 2.41 |
Scheduler | 0.16 | 1.10 | 0.94 | 0.02 | 0.53 | 2,550.00 | 93.12 | 24.50 | -73.69 |
Application | 0.00 | 0.16 | 0.16 | 0.07 | 0.05 | -28.57 | 0.22 | 38.91 | 17,586.36 |
Concurrency | 0.04 | 0.07 | 0.04 | 0.04 | 0.10 | 150.00 | 10.47 | 9.09 | -13.18 |
Network | 0.00 | 0.02 | 0.02 | 3.25 | 4.37 | 34.46 | 0.01 | 0.07 | 600.00 |
Commit | 0.01 | 0.03 | 0.02 | 0.20 | 0.58 | 190.00 | 0.54 | 0.67 | 24.07 |
Other | 0.00 | 0.01 | 0.01 | 0.00 | 0.34 | 100.00 | 0.00 | 0.33 | 100.00 |
% of DB time | '), AWRRPT_HTML_TYPE('# Waits/sec (Elapsed Time) | '), AWRRPT_HTML_TYPE('Avg Wait Time (ms) | '), AWRRPT_HTML_TYPE('||||||||
---|---|---|---|---|---|---|---|---|---|---|
Event | Wait Class | 1st | 2nd | Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff |
db file sequential read | User I/O | 0.27 | 1.81 | 1.54 | 0.13 | 2.33 | 1,692.31 | 21.94 | 9.23 | -57.93 |
control file sequential read | System I/O | 1.06 | 2.02 | 0.96 | 13.58 | 35.30 | 159.94 | 0.83 | 0.68 | -18.07 |
resmgr:cpu quantum | Scheduler | 0.16 | 1.10 | 0.94 | 0.02 | 0.53 | 2,550.00 | 93.12 | 24.50 | -73.69 |
log file parallel write | System I/O | 0.05 | 0.71 | 0.66 | 0.87 | 2.23 | 156.32 | 0.63 | 3.81 | 504.76 |
Data file init write | User I/O | 0.00 | 0.53 | 0.53 | 0.00 | 0.44 | 100.00 | 0.00 | 14.53 | 100.00 |
enq: TX - row lock contention | Application | 0.00 | 0.16 | 0.16 | 0.00 | 0.05 | 100.00 | 0.00 | 38.91 | 100.00 |
db file scattered read | User I/O | 0.13 | 0.00 | -0.12 | 0.04 | 0.05 | 25.00 | 36.06 | 0.54 | -98.50 |
db file parallel write | System I/O | 0.16 | 0.07 | -0.09 | 1.97 | 1.36 | -30.96 | 0.88 | 0.61 | -30.68 |
latch: shared pool | Concurrency | 0.00 | 0.07 | 0.07 | 0.00 | 0.10 | 100.00 | 0.00 | 9.09 | 100.00 |
direct path write | User I/O | 0.11 | 0.06 | -0.06 | 0.06 | 4.08 | 6,700.00 | 21.25 | 0.16 | -99.25 |
os thread startup | Concurrency | 0.04 | 0.00 | -0.04 | 0.02 | 0.00 | -100.00 | 20.93 | 0.00 | -100.00 |
SQL*Net message to client | Network | 0.00 | 0.02 | 0.02 | 3.23 | 4.37 | 35.29 | 0.01 | 0.07 | 600.00 |
log file sync | Commit | 0.01 | 0.03 | 0.02 | 0.20 | 0.58 | 190.00 | 0.54 | 0.67 | 24.07 |
control file parallel write | System I/O | 0.04 | 0.03 | -0.01 | 0.48 | 0.68 | 41.67 | 0.94 | 0.48 | -48.94 |
rdbms ipc reply | Other | 0.00 | 0.01 | 0.01 | 0.00 | 0.19 | 100.00 | 0.00 | 0.56 | 100.00 |
db file single write | User I/O | 0.00 | 0.00 | 0.00 | 0.00 | 0.05 | 100.00 | 0.00 | 0.39 | 100.00 |
SQL*Net break/reset to client | Application | 0.00 | 0.00 | -0.00 | 0.07 | 0.00 | -100.00 | 0.22 | 0.00 | -100.00 |
LGWR wait for redo copy | Other | 0.00 | 0.00 | 0.00 | 0.00 | 0.15 | 100.00 | 0.00 | 0.01 | 100.00 |
SQL*Net more data from client | Network | 0.00 | 0.00 | -0.00 | 0.02 | 0.00 | -100.00 | 0.02 | 0.00 | -100.00 |
buffer busy waits | Concurrency | 0.00 | 0.00 | -0.00 | 0.02 | 0.00 | -100.00 | 0.01 | 0.00 | -100.00 |
SQL*Net message from client | Idle | 2,248.80 | 207.80 | -2,040.99 | 3.25 | 4.32 | 32.92 | 7,364.81 | 572.37 | -92.23 |
fbar timer | Idle | 0.00 | 1,223.84 | 1,223.84 | 0.00 | 0.05 | 100.00 | 0.00 | 300,013.89 | 100.00 |
WCR : replay client notify | Idle | 0.00 | 77.41 | 77.41 | 0.00 | 0.24 | 100.00 | 0.00 | 3,795.20 | 100.00 |
Streams AQ: qmn slave idle wait | Idle | 48.86 | 114.23 | 65.37 | 0.02 | 0.10 | 400.00 | 28,001.83 | 14,000.74 | -50.00 |
Streams AQ: qmn coordinator idle wait | Idle | 48.86 | 114.23 | 65.37 | 0.04 | 0.19 | 375.00 | 14,000.89 | 7,000.35 | -50.00 |
PL/SQL lock timer | Idle | 52.36 | 0.00 | -52.36 | 0.56 | 0.00 | -100.00 | 1,000.27 | 0.00 | -100.00 |
jobq slave wait | Idle | 41.94 | 0.00 | -41.94 | 0.15 | 0.00 | -100.00 | 3,004.28 | 0.00 | -100.00 |
DIAG idle wait | Idle | 188.71 | 163.31 | -25.40 | 2.00 | 1.94 | -3.00 | 1,001.43 | 1,000.84 | -0.06 |
Streams AQ: waiting for messages in the queue | Idle | 122.19 | 102.03 | -20.16 | 0.32 | 0.29 | -9.38 | 4,119.31 | 4,168.45 | 1.19 |
virtual circuit status | Idle | 104.70 | 122.39 | 17.69 | 0.04 | 0.05 | 25.00 | 30,001.69 | 30,001.70 | 0.00 |
Space Manager: slave idle wait | Idle | 95.97 | 81.59 | -14.38 | 0.20 | 0.19 | -5.00 | 5,000.25 | 5,000.26 | 0.00 |
wait for unread message on broadcast channel | Idle | 94.22 | 85.66 | -8.56 | 1.00 | 1.02 | 2.00 | 999.98 | 999.96 | -0.00 |
% of DB time | '), AWRRPT_HTML_TYPE('% CPU Time | '), AWRRPT_HTML_TYPE('% Physical Reads | '), AWRRPT_HTML_TYPE('% Logical Reads | '), AWRRPT_HTML_TYPE('|||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Service Name | 1st | 2nd | Diff | 1st | 2nd | Diff | 1st | 2nd | Diff | 1st | 2nd | Diff |
PWHD | 95.23 | 81.84 | -13.39 | 96.83 | 89.05 | -7.77 | 0.00 | 0.00 | 0.00 | 99.39 | 92.67 | -6.72 |
SYS$USERS | 4.76 | 17.94 | 13.18 | 3.15 | 10.52 | 7.37 | 100.00 | 115.91 | 15.91 | 0.59 | 8.69 | 8.10 |
PWHDXDB | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 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 | 0.00 | 0.00 | 0.00 | 0.01 | 0.00 |
% CR Blks Received | '), AWRRPT_HTML_TYPE('% Current Blks Received | '), AWRRPT_HTML_TYPE(''), AWRRPT_HTML_TYPE(' | |||||
---|---|---|---|---|---|---|---|
Service Name | 1st | 2nd | Diff | 1st | 2nd | Diff | Total Diff |
PWHD | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
PWHDXDB | 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 | '), AWRRPT_HTML_TYPE('Elapsed Time (ms) per Exec | '), AWRRPT_HTML_TYPE('#Exec/sec (DB time) | '), AWRRPT_HTML_TYPE( 'CPU Time (ms) per Exec | '), AWRRPT_HTML_TYPE('Physical Reads per Exec | '), AWRRPT_HTML_TYPE('#Rows Processed per Exec | '), AWRRPT_HTML_TYPE('#Executions | '), AWRRPT_HTML_TYPE('#Plans | '), AWRRPT_HTML_TYPE('||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
bjsc9c4gg59jj | 94.26 | 94.26 | 81.63 | 81.63 | -12.63 | 54,022 | 20,011 | 0.02 | 0.04 | 53,212 | 19,453 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | 1 | '), AWRRPT_HTML_TYPE(' | BEGIN EMDW_LOG.set_context(MGM... |
fyk8b9986ntk7 | 60.46 | 154.72 | 51.48 | 133.12 | -8.97 | 68 | 81 | 8.90 | 6.36 | 67 | 79 | 0.00 | 0.00 | 0.00 | 0.00 | 510 | 156 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT EXECUTION_ID, STATUS, ... |
7r2fggjj3vdnt | 7.78 | 140.90 | 7.78 | 1,908 | 0.04 | 1,061 | 20.00 | 1.00 | 1 | '), AWRRPT_HTML_TYPE(' | begin dbms_workload_replay.st... | ||||||||
7snbfvf2qc0v4 | 6.14 | 147.04 | 6.14 | 1,505 | 0.04 | 359 | 13.00 | 0.00 | 1 | '), AWRRPT_HTML_TYPE(' | begin :1 := dbms_workload_repl... | ||||||||
6ajkhukk78nsr | 0.11 | 154.82 | 2.84 | 149.88 | 2.74 | 62 | 697 | 0.02 | 0.04 | 31 | 515 | 0.00 | 8.00 | 1.00 | 1.00 | 1 | 1 | '), AWRRPT_HTML_TYPE(' | begin prvt_hdm.auto_execute( :... |
9k86ctcaydu0v | 2.60 | 152.48 | 2.60 | 636 | 0.04 | 406 | 0.00 | 0.00 | 1 | / 1/ 1 | '), AWRRPT_HTML_TYPE('select severity_code, message... | ||||||||
b25x9c4k1swgf | 11.35 | 166.17 | 9.59 | 162.07 | -1.76 | 13 | 15 | 8.90 | 6.36 | 13 | 15 | 0.00 | 0.00 | 1.00 | 1.00 | 510 | 156 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('UPDATE MGMT_JOB_EXEC_SUMMARY S... |
< a class="awr" href="#6htq3p9j91y0s">6htq3p9j91y0s | 13.73 | 179.91 | 12.19 | 174.26 | -1.55 | 15 | 19 | 8.90 | 6.40 | 16 | 17 | 0.00 | 0.00 | 1.00 | 1.00 | 510 | 157 | '), AWRRPT_HTML_TYPE(' | INSERT INTO MGMT_JOB_EXEC_SUMM... |
bunssq950snhf | 1.19 | 181.10 | 2.60 | 176.86 | 1.41 | 682 | 638 | 0.02 | 0.04 | 686 | 437 | 0.00 | 0.00 | 8.00 | 7.00 | 1 | 1 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('insert into wrh$_sga_target_ad... |
fz6320qyay15h | < td align="right" class=''awrnclb''>1.12182.21 | -1.12 | 639 | 0.02 | 78 | 5.00 | 1.00 | 1 | '), AWRRPT_HTML_TYPE(' | BEGIN DBMS_WORKLOAD_CAPTURE.ST... | |||||||||
4acgtvgprp2c0 | 0.79 | 183.01 | 0.62 | 177.48 | -0.18 | 1 | 1 | 8.90 | 6.40 | 1 | 1 | 0.00 | 0.00 | 0.00 | 0.00 | 510 | 157 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT DISTINCT JOB_TGT.TARGET... |
4ay7q10wk6nc8 | 2.18 | 185.19 | 2.02 | 179.50 | -0.16 | 2 | 3 | 8.90 | 6.40 | 2 | 3 | 0.00 | 0.00 | 0.00 | 0.00 | 510 | 157 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('INSERT INTO MGMT_JOB_PARAMETER... |
2.25 | 187.44 | 2.12 | 181.62 | -0.13 | 3 | 3 | 8.90 | 6.40 | 3 | 2 | 0.00 | 0.00 | 0.00 | 0.00 | 510 | 157 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('INSERT INTO MGMT_JOB_TARGET(JO... | |
08vznc16ycuag | 0.62 | 188.06 | 0.49 | 182.11 | -0.13 | 0 | 0 | 26.71 | 19.17 | 0 | 0 | 0.00 | 0.00 | 1.00 | 1.00 | 1,531 | 470 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT SYS_GUID() FROM SYS.DUA... |
CPU Time % of DB CPU | '), AWRRPT_HTML_TYPE('CPU Time (ms) per Exec | '), AWRRPT_HTML_TYPE('#Exec/sec (DB time) | '), AWRRPT_HTML_TYPE('Exec Time (ms) per Exec | '), AWRRPT_HTML_TYPE('Physical Reads per Exec | '), AWRRPT_HTML_TYPE('#Ro ws Processed per Exec | '), AWRRPT_HTML_TYPE('#Plans | '), AWRRPT_HTML_TYPE('|||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st/2nd/Both | SQL Text |
bjsc9c4gg59jj | 96.66 | 96.66 | 88.63 | 88.63 | -8.03 | 53,212 | 19,453 | 0.02 | 0.04 | 54,022 | 20,011 | 0.00 | 0.00 | 0.00 | 0.00 | '), AWRRPT_HTML_TYPE(' | BEGIN EMDW_LOG.set_context(MGM... |
fyk8b9986ntk7 | 62.34 | 159.00 | 56.15 | 144.78 | -6.19 | 67 | 79 | 8.90 | 6.36 | 68 | 81 | 0.00 | 0.00 | 0.00 | 0.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT EXECUTION_ID, STATUS, ... |
7r2fggjj3vdnt | 4.83 | 149.61 | 4.83 | 1,061 | 0.04 | 1,908 | 20.00 | 1.00 | '), AWRRPT_HTML_TYPE(' | begin dbms_workload_replay.st... | |||||||
6ajkhukk78nsr | 0.06 | 159.05 | 2.35 | 151.95 | 2.29 | 31 | 515 | 0.02 | 0.04 | 62 | 697 | 0.00 | 8.00 | 1.00 | 1.00 | '), AWRRPT_HTML_TYPE(' | begin prvt_hdm.auto_execute( :... |
6htq3p9j91y0s | 14.45 | 173.51 | 12.51 | 164.46 | -1.94 | 16 | 17 | 8.90 | 6.40 | 15 | 19 | 0.00 | 0.00 | 1.00 | 1.00 | '), AWRRPT_HTML_TYPE(' | INSERT INTO MGMT_JOB_EXEC_SUMM... |
9k86ctcaydu0v | td> | 1.85 | 166.31 | 1.85 | 406 | 0.04 | 636 | 0.00 | 0.00 | / 1/ 1 | '), AWRRPT_HTML_TYPE('select severity_code, message... | ||||||
b25x9c4k1swgf | 11.84 | 185.35 | 10.45 | 176.76 | -1.40 | 13 | 15 | 8.90 | 6.36 | 13 | 15 | 0.00 | 0.00 | 1.00 | 1.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('UPDATE MGMT_JOB_EXEC_SUMMARY S... |
bunssq950snhf | 1.25 | 186.60 | 1.99 | 178.75 | 0.74 | 686 | 437 | 0.02 | 0.04 | 682 | 638 | 0.00 | 0.00 | 8.00 | 7.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('insert into wrh$_sga_target_ad... |
6rm2uy96x1skz | 2.44 | 189.03 | 1.78 | 180.53 | -0.66 | 3 | 2 | 8.90 | 6.40 | 3 | 3 | 0.00 | 0.00 | 0.00 | 0.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('INSERT INTO MGMT_JOB_TARGET(JO... |
7fmujzn3gr8uz | 0.62 | 189.66 | 0.07 | 180.60 | -0.55 | 1 | 0 | 8.90 | 6.40 | 1 | 1 | 0.00 | 0.00 | 0.00 | 0.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT /*+ ORDERED PUSH_SUBQ *... |
08vznc16ycuag | 0.88 | 190.54 | 0.43 | 181.02 | -0.45 | 0 | 0 | 26.71 | 19.17 | 0 | 0 | 0.00 | 0.00 | 1.00 | 1.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT SYS_GUID() FROM SYS.DUA... |
4ay7q10wk6nc8 | 2.21 | 192.75 | 2.49 | 183.51 | 0.28 | 2 | 3 | 8.90 | 6.40 | 2 | 3 | 0.00 | 0.00 | 0.00 | 0.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('INSERT INTO M GMT_JOB_PARAMETER... |
4acgtvgprp2c0 | 0.65 | 193.40 | 0.64 | 184.15 | -0.01 | 1 | 1 | 8.90 | 6.40 | 1 | 1 | 0.00 | 0.00 | 0.00 | 0.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT DISTINCT JOB_TGT.TARGET... |
% Total Gets | '), AWRRPT_HTML_TYPE('Gets per Exec | '), AWRRPT_HTML_TYPE('#Executions | '), AWRRPT_HTML_TYPE('Exec Time (ms) per Exec | '), AWRRPT_HTML_TYPE('CPU Time (ms) per Exec | '), AWRRPT_HTML_TYPE('Physical Reads per Exec | '), AWRRPT_HTML_TYPE('#Rows Processed per Exec | '), AWRRPT_HTML_TYPE('#Plans | '), AWRRPT_HTML_TYPE('||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
fyk8b9986ntk7 | 92.71 | 92.71 | 82.28 | 82.28 | -10.43 | 2,159.99 | 2,387.10 | 510 | 156 | 68 | 81 | 67 | 79 | 0.00 | 0.00 | 0.00 | 0.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT EXECUTION_ID, STATUS, ... |
bjsc9c4gg59jj | 99.41 | 192.12 | 90.11 | 172.39 | -9.30 | 1,181,213.00 | 407,841.00 | 1 | 1 | 54,022 | 20,011 | 53,212 | 19,453 | 0.00 | 0.00 | 0.00 | 0.00 | '), AWRRPT_HTML_TYPE(' | BEGIN EMDW_LOG.set_context(MGM... |
7r2fggjj3vdnt | 6.92 | 179.31 | 6.92 | 31,336.00 | 1 | 1,908 | 1,061 | 20.00 | 1.00 | '), AWRRPT_HTML_TYPE(' | begin dbms_workload_replay.st... | ||||||||
6ajkhukk78nsr | 0.07 | 192.19 | 1.34 | 180.65 | 1.27 | 837.00 | 6,080.00 | 1 | 1 | 62 | 697 | 31 | 515 | 0.00 | 8.00 | 1.00 | 1.00 | '), AWRRPT_HTML_TYPE(' | begin prvt_hdm.auto_execute( :... |
6htq3p9j91y0s | 2.92 | 195.11 | 2.37 | 183.03 | -0.55 | 67.97 | 68.38 | 510 | 157 | 15 | 19 | 16 | 17 | 0.00 | 0.00 | 1.00 | 1.00 | '), AWRRPT_HTML_TYPE(' | INSERT INTO MGMT_JOB_EXEC_SUMM... |
5u0bnvvbvgf68 | 0.50 | 183.52 | 0.50 | 2,254.00 | 1 | 101 | 62 | 0.00 | 1.00 | / 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT NVL(SUM(TABLESPACE_SIZE... | ||||||||
f0dm7wcn7p59h | 0.21 | 195.32 | -0.21 | 5.00 | 510 | 0 | 0 | 0.00 | 1.00 | 1// 1 | '), AWRRPT_HTML_TYPE('SELECT JOB_NAME, JOB_OWNER, ... | ||||||||
fz6320qyay15h | 0.21 | 195.53 | -0.21 | 2,442.00 | 1 | 639 | 78 | 5.00 | 1.00 | '), AWRRPT_HTML_TYPE(' | BEGIN DBMS_WORKLOAD_CAPTURE.ST... | ||||||||
b25x9c4k1swgf | 0.84 | 196.37 | 0.67 | 184.20 | -0.16 | 19.48 | 19.47 | 510 | 156 | 13 | 15 | 13 | 15 | 0.00 | 0.00 | 1.00 | 1.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('UPDATE MGMT_JOB_EXEC_SUMMARY S... |
5dwsqwabg2pxy | 0.60 | 196.97 | 0.49 | 184.68 | -0.11 | 7.00 | 7.00 | 1,020 | 316 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 1.00 | 1.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT COUNT(1) FROM MGMT_VERS... |
bfhwd5nkrwjta | 0.52 | 197.48 | 0.42 | 185.10 | -0.10 | 3.00 | 3.00 | 2,040 | 628 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 1.00 | 1.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT JOB_ID, JOB_TYPE_ID FR... |
fqjyb76axcsaj | 0.40 | 197.88 | 0.33 | 185.43 | -0.07 | 9.31 | 9.43 | 510 | 157 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 1.00 | 1.00 | '), AWRRPT_HTML_TYPE(' | INSERT INTO MGMT_JOB_STATE_CHA... |
4r1 94rhp4wpyu | 0.17 | 198.05 | 0.14 | 185.57 | -0.03 | 4.00 | 4.00 | 510 | 157 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 1.00 | 1.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT JOB_TYPE_ID FROM MGMT_J... |
% Total Physical Reads | '), AWRRPT_HTML_TYPE('Physical Reads per Exec | '), AWRRPT_HTML_TYPE('#Executions | '), AWRRPT_HTML_TYPE('Exec Time (ms) per Exec | '), AWRRPT_HTML_TYPE('CPU Time (ms) per Exec | '), AWRRPT_HTML_TYPE('#Rows Processed per Exec | '), AWRRPT_HTML_TYPE('#Plans | '), AWRRPT_HTML_TYPE('|||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st/2nd/Both | SQL Text |
fz6320qyay15h | 71.43 | 71.43 | -71.43 | 5.00 | 1 | 639 | 78 | 1.00 | '), AWRRPT_HTML_TYPE(' | BEGIN DBMS_WORKLOAD_CAPTURE.ST... | |||||||
7r2fggjj3vdnt | 45.45 | 45.45 | 45.45 | 20.00 | 1 | 1,908 | 1,061 | 1.00 | '), AWRRPT_HTML_TYPE(' | begin dbms_workload_replay.st... | |||||||
46zsasxjf8hb9 | 42.86 | 114.29 | -42.86 | 3.00 | 1 | 34 | 0 | 16.00 | 1// 1 | '), AWRRPT_HTML_TYPE('insert into WRH$_MEM_DYNAMIC_C... | |||||||
7snbfvf2qc0v4 | 29.55 | 75.00 | 29.55 | 13.00 | 1 | 1,505 | 359 | 0.00 | '), AWRRPT_HTML_TYPE(' | begin :1 := dbms_workload_repl... | |||||||
0z1031991bd7w | 28.57 | 142.86 | -28.57 | 2.00 | 1 | 42 | 0 | 148.00 | 1// 1 | '), AWRRPT_HTML_TYPE('insert into wrh$_sysmetric_sum... | |||||||
6ajkhukk78nsr | 0.00 | 142.86 | 18.18 | 93.18 | 18.18 | 0.00 | 8.00 | 1 | 1 | 62 | 697 | 31 | 515 | 1.00 | 1.00 | '), AWRRPT_HTML_TYPE(' | begin prvt_hdm.auto_execute( :... |
6c06mfv01xt2h | 15.91 | 109.09 | 15.91 | 7.00 | 1 | 52 | 0 | 14.00 | / 1/ 1 | '), AWRRPT_HTML_TYPE('update wrh$_seg_stat_obj sso ... | |||||||
1gfaj4z5hn1kf | 14.29 | 157.14 | -14.29 | 0.50 | 2 | 9 | 0 | 0.00 | 1// 1 | '), AWRRPT_HTML_TYPE('delete from dependency$ where ... | |||||||
cvvt9hc9c2br6 | 11.36 | 120.45 | 11.36 | 5.00 | 1 | 24 | 16 | 0.00 | / 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT /*+ ordered use_nl(sta... | |||||||
692wcvj50ytxz | 6.82 | 127.27 | 6.82 | 3.00 | 1 | 56 | 0 | 4.00 | / 1/ 1 | '), AWRRPT_HTML_TYPE('insert into wrh$_resource_limi... | |||||||
94vftcc9jztf1 | 6.82 | 134.09 | 6.82 | 3.00 | 1 | 46 | 16 | 1.00 | '), AWRRPT_HTML_TYPE(' | DECLARE row_count NUMBER ... | |||||||
7ng34ruy5awxq | 4.55 | 138.64 | 4.55 | 0.03 | 67 | 1 | 1 | 1.57 | / 2/ 2 | '), AWRRPT_HTML_TYPE('select i.obj#, i.ts#, i.file#,... | |||||||
83taa7kaw59c1 | 4.55 | 143.18 | 4.55 | 0.03 | 77 | 1 | 0 | 9.51 | / 1/ 1 | '), AWRRPT_HTML_TYPE('select name, intcol#, segcol#,... | |||||||
6wm3n4d7bnddg | 2.27 | 145.45 | 2.27 | 1.00 | 1 | 18 | 16 | 3.00 | / 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT source, (case ... | |||||||
062savj8zgzut | 0.00 | 157.14 | 0.00 | 0.00 | 3 | 0 | 0 | 1.00 | 1// 1 | '), AWRRPT_HTML_TYPE('UPDATE sys.wri$_adv_parameters... | |||||||
089dbukv1aanh | 0.00 | 157.14 | 0.00 | 0.00 | 46 | 0 | 0 | 1.00 | 1// 1 | '), AWRRPT_HTML_TYPE('SELECT SYS_EXTRACT_UTC(SYSTIME... | |||||||
08bqjmf8490s2 | 0.00 | 157.14 | 0.00 | 0.00 | 4 | 0 | 0 | 0.75 | 1// 1 | '), AWRRPT_HTML_TYPE('SELECT PARAMETER_VALUE FROM MG... | |||||||
08vznc16ycuag | 0.00 | 157.14 | 0.00 | 145.45 | 0.00 | 0.00 | 0.00 | 1,531 | 470 | 0 | 0 | 0 | 0 | 1.00 | 1.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT SYS_GUID() FROM SYS.DUA... |
0h6b2sajwb74n | 0.00 | 157.14 | 0.00 | 145.45 | 0.00 | 0.00 | 0.00 | 3 | 5 | 0 | 0 | 0 | 0 | 27.33 | 32.80 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('select privilege#, level from ... |
0k8522rmdzg4k | 0.00 | 157.14 | 0.00 | 145.45 | 0.00 | 0.00 | 0.00 | 2 | 5 | 0 | 0 | 0 | 0 | 1.50 | 1.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('select privilege# from sysauth... |
#Executions/sec (DB time) | '), AWRRPT_HTML_TYPE('#Executions | '), AWRRPT_HTML_TYPE('Exec Time (ms) per Exec | '), AWRRPT_HTML_TYPE('CPU Time (ms) per Exec | '), AWRRPT_HTML_TYPE('Physical Reads per Exec | '), AWRRPT_HTML_TYPE('#Rows Processed per Exec | '), AWRRPT_HTML_TYPE('#Plan | '), AWRRPT_HTML_TYPE('|||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st/2nd/Both | SQL Text |
bfhwd5nkrwjta | 35.59 | 25.62 | -9.98 | 2,040 | 628 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 1.00 | 1.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT JOB_ID, JOB_TYPE_ID FR... |
53saa2zkr6wc3 | 9.46 | 9.46 | 232 | 0 | 0 | 0.00 | 1.34 | / 2/ 2 | '), AWRRPT_HTML_TYPE('select intcol#, nvl(pos#, 0), ... | ||||||
23cha88t29kbg | 8.90 | -8.90 | 510 | 0 | 0 | 0.00 | 1.00 | 1// 1 | '), AWRRPT_HTML_TYPE('SELECT JOB_NAME, JOB_OWNER, ... | ||||||
3824na5bnfhnu | 8.90 | -8.90 | 510 | 0 | 0 | 0.00 | 1.00 | 1// 1 | '), AWRRPT_HTML_TYPE('SELECT NESTED, NESTED_JOB_TYP... | ||||||
08vznc16ycuag | 26.71 | 19.17 | -7.54 | 1,531 | 470 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 1.00 | 1.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT SYS_GUID() FROM SYS.DUA... |
5dwsqwabg2pxy | 17.80 | 12.89 | -4.91 | 1,020 | 316 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 1.00 | 1.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT COUNT(1) FROM MGMT_VERS... |
4acgtvgprp2c0 | 8.90 | 6.40 | -2.49 | 510 | 157 | 1 | 1 | 1 | 1 | 0.00 | 0.00 | 0.00 | 0.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT DISTINCT JOB_TGT.TARGET... |
4ay7q10wk6nc8 | 8.90 | 6.40 | -2.49 | 510 | 157 | 2 | 3 | 2 | 3 | 0.00 | 0.00 | 0.00 | 0.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('INSERT INTO MGMT_JOB_PARAMETER... |
4r194rhp4wpyu | 8.90 | 6.40 | -2.49 | 510 | 157 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 1.00 | 1.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT JOB_TYPE_ID FROM MGMT_J... |
6h6dq383cant6 | 8.90 | 6.40 | -2.49 | 510 | 157 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT MGMT_JOB_PARAMSRC_RECOR... |
6htq3p9j91y0s | 8.90 | 6.40 | -2.49 | 510 | 157 | 15 | 19 | 16 | 17 | 0.00 | 0.00 | 1.00 | 1.00 | '), AWRRPT_HTML_TYPE(' | INSERT INTO MGMT_JOB_EXEC_SUMM... |
6rm2uy96x1skz | 8.90 | 6.40 | -2.49 | 510 | 157 | 3 | 3 | 3 | 2 | 0.00 | 0.00 | 0.00 | 0.00 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('INSERT INTO MGMT_JOB_TARGET(JO... |
% Total Parses | '), AWRRPT_HTML_TYPE('Parses | '), AWRRPT_HTML_TYPE('#Executions | '), AWRRPT_HTML_TYPE('#Plans | '), AWRRPT_HTML_TYPE('||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | 1st | 2nd | 1st/2nd/Both | SQL Text |
6h6dq383cant6 | 58.22 | 58.22 | 16.34 | 16.34 | -41.88 | 510 | 157 | 510 | 157 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT MGMT_JOB_PARAMSRC_RECOR... |
3m8smr0v7v1m6 | 0.23 | 58.45 | 6.66 | 23.00 | 6.43 | 2 | 64 | 2 | 64 | '), AWRRPT_HTML_TYPE(' | INSERT INTO sys.wri$_adv_messa... |
f80h0xb1qvbsk | 0.23 | 58.68 | 5.72 | 28.72 | 5.49 | 2 | 55 | 2 | 55 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT sys.wri$_adv_seq_msggro... |
grwydz59pu6mc | 4.79 | 33.51 | 4.79 | 46 | 46 | / 1/ 1 | '), AWRRPT_HTML_TYPE('select text from view$ where r... | ||||
3sqgkcng6vx8r | 1.46 | 34.96 | 1.46 | 14 | 14 | '), AWRRPT_HTML_TYPE(' | INSERT INTO sys.wri$_adv_ratio... | ||||
3972rvxu3knn3 | 1.37 | 60.05 | -1.37 | 12 | 12 | 1// 1 | '), AWRRPT_HTML_TYPE('delete from sdo_geor_ddl__tabl... | ||||
a6u3yjca29nqc | 1.37 | 61.42 | -1.37 | 12 | 12 | '), AWRRPT_HTML_TYPE(' | declare m_stmt varchar2(512... | ||||
2gxbvynrd71dr | 1.35 | 36.32 | 1.35 | 13 | 13 | '), AWRRPT_HTML_TYPE(' | INSERT INTO sys.wri$_adv_rec_a... | ||||
6qz82dptj0qr7 | 1.35 | 37.67 | 1.35 | 13 | 13 | / 2/ 2 | '), AWRRPT_HTML_TYPE('select l.col#, l.intcol#, l.... | ||||
7gs8x44r7mpnb | 1.35 | 39.02 | 1.35 | 13 | 13 | '), AWRRPT_HTML_TYPE(' | INSERT INTO sys.wri$_adv_actio... | ||||
g5vpd5g3y90qv | 1.35 | 40.37 | 1.35 | 13 | 13 | '), AWRRPT_HTML_TYPE(' | INSERT INTO sys.wri$_adv_recom... | ||||
4bvhj5ctc66fw | 1.04 | 41.42 | 1.04 | 10 | 10 | '), AWRRPT_HTML_TYPE(' | INSERT INTO sys.wri$_adv_objec... | ||||
211pwdjq76067 | 0.68 | 62.10 | -0.68 | 6 | 6 | 1// 1 | '), AWRRPT_HTML_TYPE('SELECT id FROM dba_workload_re... | ||||
08bqjmf8490s2 | 0.46 | 62.56 | -0.46 | 4 | 4 | 1// 1 | '), AWRRPT_HTML_TYPE('SELECT PARAMETER_VALUE FROM MG... | ||||
6097g1430c6p2 | 0.46 | 63.01 | -0.46 | 4 | 3 | '), AWRRPT_HTML_TYPE(' | BEGIN MGMT_PAF_AQ.DEQUEUE_REQU... | ||||
062savj8zgzut | 0.34 | 63.36 | -0.34 | 3 | 3 | 1// 1 | '), AWRRPT_HTML_TYPE('UPDATE sys.wri$_adv_parameters... | ||||
6129566gyvx21 | 0.34 | 63.70 | 0.10 | 41.52 | -0.24 | 3 | 1 | 3 | 1 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT INSTANTIABLE, supertyp... |
089dbukv1aanh | 0.23 | 63.93 | -0.23 | 2 | 46 | 1// 1 | '), AWRRPT_HTML_TYPE('SELECT SYS_EXTRACT_UTC(SYSTIME... | ||||
0h6b2sajwb74n | 0.34 | 64.27 | 0.52 | 42.04 | 0.18 | 3 | 5 | 3 | 5 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('select privilege#, level from ... |
% Total Sharable Memory | '), AWRRPT_HTML_TYPE('Sharable Memory Used | '), AWRRPT_HTML_TYPE('Sharable Memory Max | '), AWRRPT_HTML_TYPE('#Executions | '), AWRRPT_HTML_TYPE('|||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | SQL Text |
9gtqhd3dnpqvg | 0.02 | 0.02 | 0.02 | 61,585 | 61,585 | 2 | '), AWRRPT_HTML_TYPE('select severity_code, message... | |||||
18naypzfmabd6 | 0.02 | 0.02 | -0.02 | 48,129 | 48,129 | 1 | '), AWRRPT_HTML_TYPE(' | INSERT INTO MGMT_SYSTEM_PERFOR... | ||||
08bqjmf8490s2 | 0.02 | 0.03 | -0.02 | 39,896 | 39,896 | 4 | '), AWRRPT_HTML_TYPE(' | SELECT PARAMETER_VALUE FROM MG... | ||||
6c06mfv01xt2h | 0.01 | 0.04 | 0.01 | 38,111 | 38,111 | 1 | '), AWRRPT_HTML_TYPE('update wrh$_seg_stat_obj sso ... | |||||
71y370j6428cb | 0.01 | 0.05 | -0.01 | 34,330 | 34,330 | 1 | '), AWRRPT_HTML_TYPE(' | insert into wrh$_thread (s... | ||||
cb21bacyh3c7d | 0.01 | 0.06 | -0.01 | 24,128 | 24,128 | 2 | '), AWRRPT_HTML_TYPE(' | select metadata from kopm$ wh... | ||||
f318xdxdn0pdc | 0.01 | 0.05 | 0.01 | 25,103 | 25,103 | 1 | '), AWRRPT_HTML_TYPE('insert into wrh$_log (s... | |||||
692wcvj50ytxz | 0.01 | 0.05 | 0.01 | 21,077 | 21,077 | 1 | '), AWRRPT_HTML_TYPE('insert into wrh$_resource_limi... | |||||
c9s3vj1tj3aba | 0.01 | 0.07 | -0.01 | 18,836 | 18,836 | 1 | '), AWRRPT_HTML_TYPE(' | UPDATE WRR$_CAPTURES SET END_T... | ||||
9wvf01xydy23m | 0.01 | 0.07 | -0.01 | 14,707 | 14,707 | 510 | '), AWRRPT_HTML_TYPE(' | SELECT JOB_NAME, JOB_OWNER FR... | ||||
5zafwfnja12x3 | 0.01 | 0.06 | 0.01 | 14,718 | 14,718 | 1 | '), AWRRPT_HTML_TYPE('UPDATE WRR$_REPLAYS SET NUM_CL... | |||||
5xp6xdg6cp1zv | 0.01 | 0.08 | -0.01 | 12,603 | 12,603 | 2 | '), AWRRPT_HTML_TYPE(' | SELECT MAX(VALUE) FROM V$SYSST... | ||||
3972rvxu3knn3 | 0.00 | 0.08 | -0.00 | 8,502 | 8,502 | 12 | '), AWRRPT_HTML_TYPE(' | delete from sdo_geor_ddl__tabl... | ||||
7fmujzn3gr8uz | 0.02 | 0.10 | 0.02 | 0.08 | -0.00 | 56,738 | 56,738 | 56,738 | 56,738 | 510 | 157 | '), AWRRPT_HTML_TYPE('SELECT /*+ ORDERED PUSH_SUBQ *... |
6rm2uy96x1skz | 0.01 | 0.11 | 0.01 | 0.09 | -0.00 | 23,048 | 23,048 | 23,048 | 23,048 | 510 | 157 | '), AWRRPT_HTML_TYPE('INSERT INTO MGMT_JOB_TARGET(JO... |
4acgtvgprp2c0 | 0.01 | 0.12 | 0.01 | 0.1 0 | -0.00 | 18,953 | 18,953 | 18,953 | 18,953 | 510 | 157 | '), AWRRPT_HTML_TYPE('SELECT DISTINCT JOB_TGT.TARGET... |
fqjyb76axcsaj | 0.01 | 0.13 | 0.01 | 0.10 | -0.00 | 16,836 | 16,836 | 16,836 | 16,836 | 510 | 157 | '), AWRRPT_HTML_TYPE('INSERT INTO MGMT_JOB_STATE_CHA... |
08vznc16ycuag | 0.00 | 0.13 | 0.00 | 0.11 | -0.00 | 8,500 | 8,500 | 8,500 | 8,500 | 1,531 | 470 | '), AWRRPT_HTML_TYPE('SELECT SYS_GUID() FROM SYS.DUA... |
Version Count | '), AWRRPT_HTML_TYPE('Version Count Max | '), AWRRPT_HTML_TYPE('#Executions | '), AWRRPT_HTML_TYPE('||||||
---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | SQL Text |
08bqjmf8490s2 | 3 | -3 | 3 | 4 | '), AWRRPT_HTML_TYPE(' | SELECT PARAMETER_VALUE FROM MG... | ||
18naypzfmabd6 | 3 | -3 | 3 | & #160; | 1 | '), AWRRPT_HTML_TYPE(' | INSERT INTO MGMT_SYSTEM_PERFOR... | |
cb21bacyh3c7d | 2 | -2 | 2 | 2 | '), AWRRPT_HTML_TYPE(' | select metadata from kopm$ wh... | ||
3972rvxu3knn3 | 1 | -1 | 1 | 12 | '), AWRRPT_HTML_TYPE(' | delete from sdo_geor_ddl__tabl... | ||
5xp6xdg6cp1zv | 1 | -1 | 1 | 2 | '), AWRRPT_HTML_TYPE(' | SELECT MAX(VALUE) FROM V$SYSST... | ||
5zafwfnja12x3 | 1 | 1 | 1 | 1 | '), AWRRPT_HTML_TYPE('UPDATE WRR$_REPLAYS SET NUM_CL... | |||
692wcvj50ytxz | 1 | 1 | 1 | 1 | '), AWRRPT_HTML_TYPE('insert into wrh$_resource_limi... | |||
6c06mfv01xt2h | 1 | 1 | 1 | 1 | '), AWRRPT_HTML_TYPE('update wrh$_seg_stat_obj sso ... | |||
71y370j6428cb | 1 | -1 | 1 | 1 | '), AWRRPT_HTML_TYPE(' | insert into wrh$_thread (s... | ||
9gtqhd3dnpqvg | 1 | 1 | 1 | 2 | '), AWRRPT_HTML_TYPE('select severity_code, message... | |||
9wvf01xydy23m | 1 | -1 | 1 | 510 | '), AWRRPT_HTML_TYPE(' | SELECT JOB_NAME, JOB_OWNER FR... | ||
c9s3vj1tj3aba | 1 | -1 | 1 | 1 | '), AWRRPT_HTML_TYPE(' | UPDATE WRR$_CAPTURES SET END_T... | ||
f318xdxdn0pdc | 1 | 1 | 1 | 1 | '), AWRRPT_HTML_TYPE('insert into wrh$_log (s... | |||
08vznc16ycuag | 1 | 1 | 0 | 1 | 1 | 1,531 | 470 | '), AWRRPT_HTML_TYPE('SELECT SYS_GUID() FROM SYS.DUA... |
4acgtvgprp2c0 | 1 | 1 | 0 | 1 | 1 | 510 | 157 | '), AWRRPT_HTML_TYPE('SELECT DISTINCT JOB_TGT.TARGET... |
6rm2uy96x1skz | 1 | 1 | 0 | 1 | 1 | 510 | 157 | '), AWRRPT_HTML_TYPE('INSERT INTO MGMT_JOB_TARGET(JO... |
7fmujzn3gr8uz | 1 | 1 | 0 | 1 | 1 | 510 | 157 | '), AWRRPT_HTML_TYPE('SELECT /*+ ORDERED PUSH_SUBQ *... |
fqjyb76axcsaj | 1 | 1 | 0 | 1 | 1 | 510 | 157 | '), AWRRPT_HTML_TYPE('INSERT INTO MGMT_JOB_STATE_CHA... |
% Total Cluster Wait | '), AWRRPT_HTML_TYPE('Cluster Wait Time (sec) | '), AWRRPT_HTML_TYPE('Cluster Wait Time per Exec (sec) | '), AWRRPT_HTML_TYPE('#Executions | '), AWRRPT_HTML_TYPE('#Plans | '), AWRRPT_HTML_TYPE('|||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Id | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st/2nd/Both | SQL Text |
04xtrk7uyhknh | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 7 | / 1/ 1 | '), AWRRPT_HTML_TYPE('select obj#, type#, ctime, mti... | |||||
062savj8zgzut | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3 | 1// 1 | '), AWRRPT_HTML_TYPE('UPDATE sys.wri$_adv_parameters... | |||||
089dbukv1aanh | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 46 | 1// 1 | '), AWRRPT_HTML_TYPE('SELECT SYS_EXTRACT_UTC(SYSTIME... | |||||
08bqjmf8490s2 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4 | 1// 1 | '), AWRRPT_HTML_TYPE('SELECT PARAMETER_VALUE FROM MG... | |||||
08vznc16ycuag | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1,531 | 470 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('SELECT SYS_GUID() FROM SYS.DUA... |
0fr8zhn4ymu3v | 60; | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 13 | / 2/ 2 | '), AWRRPT_HTML_TYPE('select intcol#, type, flags, l... | ||||
0h6b2sajwb74n | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3 | 5 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('select privilege#, level from ... |
0k8522rmdzg4k | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2 | 5 | 1/ 1/ 1 | '), AWRRPT_HTML_TYPE('select privilege# from sysauth... |
0kkhhb2w93cx0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2 | 1// 1 | '), AWRRPT_HTML_TYPE('update seg$ set type#=:4, bloc... | |||||
0m1qhvf6n3n66 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | '), AWRRPT_HTML_TYPE(' | begin :1 := dbms_workload_repl... | |||||
0z1031991bd7w | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | 1// 1 | '), AWRRPT_HTML_TYPE('insert into wrh$_sysmetric_sum... | |||||
18naypzfmabd6 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | '), AWRRPT_HTML_TYPE(' | INSERT INTO MGMT_SYSTEM_PERFOR... | |||||
1cq3qr774cu45 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | / 1/ 1 | '), AWRRPT_HTML_TYPE('insert into WRH$_IOSTAT_FILETY... | |||||
1gfaj4z5hn1kf | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2 | 1// 1 | '), AWRRPT_HTML_TYPE('delete from dependency$ where ... | |||||
1gu8t96d0bdmu | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | / 2/ 2 | '), AWRRPT_HTML_TYPE('select t.ts#, t.file#, t.block... | |||||
2gxbvynrd71dr | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 13 | '), AWRRPT_HTML_TYPE(' | INSERT INTO sys.wri$_adv_rec_a... | |||||
2q93zsrvbdw48 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 30 | / 1/ 1 | '), AWRRPT_HTML_TYPE('select grantee#, privilege#, n... |
Value | '), AWRRPT_HTML_TYPE('per Second (DB time) | '), AWRRPT_HTML_TYPE('per Second (Elapsed Time) | '), AWRRPT_HTML_TYPE('per Trans | '), AWRRPT_HTML_TYPE('||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Statistic | 1st | 2nd | 1st | 2n d | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff |
db block changes | 19,881 | 32,303 | 346.89 | 1,317.73 | 279.87 | 368.84 | 1,568.72 | 325.31 | 552.25 | 1,538.24 | 178.54 |
execute count | 16,230 | 7,169 | 283.18 | 292.44 | 3.27 | 301.11 | 348.14 | 15.62 | 450.83 | 341.38 | -24.28 |
logons cumulative | 4 | 4 | 0.07 | 0.16 | 128.57 | 0.07 | 0.19 | 171.43 | 0.11 | 0.19 | 72.73 |
opened cursors cumulative | 16,195 | 7,125 | 282.57 | 290.65 | 2.86 | 300.46 | 346.01 | 15.16 | 449.86 | 339.29 | -24.58 |
parse count (total) | 876 | 961 | 15.28 | 39.20 | 156.54 | 16.25 | 46.67 | 187.20 | 24.33 | 45.76 | 88.08 |
parse time elapsed | 5 | 30 | 0.09 | 1.22 | 1,255.56 | 0.09 | 1.46 | 1,522.22 | 0.14 | 1.43 | 921.43 |
physical reads | 7 | 44 | 0.12 | 1.79 | 1,391.67 | 0.13 | 2.14 | 1,546.15 | 0.19 | 2.10 | 1,005.26 |
physical writes | 558 | 375 | 9.74 | 15.30 | 57.08 | 10.35 | 18.21 | 75.94 | 15.50 | 17.86 | 15.23 |
redo size | 3,306,320 | 6,455,744 | 57,689.35 | 263,348.49 | 356.49 | 61,3 40.61 | 313,507.38 | 411.09 | 91,842.22 | 307,416.38 | 234.72 |
session cursor cache hits | 15,388 | 6,533 | 268.49 | 266.50 | -0.74 | 285.49 | 317.26 | 11.13 | 427.44 | 311.10 | -27.22 |
session logical reads | 1,188,208 | 452,600 | 20,732.10 | 18,462.86 | -10.95 | 22,044.27 | 21,979.41 | -0.29 | 33,005.78 | 21,552.38 | -34.70 |
user calls | 211 | 107 | 3.68 | 4.36 | 18.48 | 3.91 | 5.20 | 32.99 | 5.86 | 5.10 | -12.97 |
user commits | 33 | 20 | 0.58 | 0.82 | 41.38 | 0.61 | 0.97 | 59.02 | 0.92 | 0.95 | 3.26 |
user rollbacks | 3 | 1 | 0.05 | 0.04 | -20.00 | 0.06 | 0.05 | -16.67 | 0.08 | 0.05 | -37.50 |
workarea executions - optimal | 88 | 208 | 1.54 | 8.48 | 450.65 | 1.63 | 10.10 | 519.63 | 2.44 | 9.90 | 305.74 |
Value | '), AWRRPT_HTML_TYPE('per Second (DB time) | '), AWRRPT_HTML_TYPE('per Second (Elapsed Time) | '), AWRRPT_HTML_TYPE('per Trans | '), AWRRPT_HTML_TYPE('||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Statistic | 1st | 2nd | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | %Diff |
CCursor + sql area evicted | 0 | 48 | 0.00 | 1.96 | 100.00 | 0.00 | 2.33 | 100.00 | 0.00 | 2.29 | 100.00 |
CPU used by this session | 5,496 | 2,167 | 95.90 | 88.40 | -7.82 | 101.96 | 105.24 | 3.22 | 152.67 | 103.19 | -32.41 |
CPU used when call started | 169 | 15 | 2.95 | 0.61 | -79.32 | 3.14 | 0.73 | -76.75 | 4.69 | 0.71 | -84.86 |
CR blocks created | 102 | 41 | 1.78 | 1.67 | -6.18 | 1.89 | 1.99 | 5.29 | 2.83 | 1.95 | -31.10 |
DBWR checkpoint buffers written | 554 | 226 | 9.67 | 9.22 | -4.65 | 10.28 | 10.98 | 6.81 | 15.39 | 10.76 | -30.08 |
DBWR transaction table writes | 4 | 0 | 0.07 | 0.00 | -100.00 | 0.07 | 0.00 | -100.00 | 0.11 | 0.00 | -100.00 |
DBWR undo block writes | 203 | 56 | 3.54 | 2.28 | -35.59 | 3.77 | 2.72 | -27.85 | 5.64 | 2.67 | -52.66 |
HSC Heap Segment Block Changes | 2,256 | 6,308 | 39.36 | 257.32 | 553.76 | 41.85 | 306.33 | 631.97 | 62.67 | 300.38 | 379.30 |
Heap Segment Array Inserts | 66 | 80 | 1.15 | 3.26 | 183.48 | 1.22 | 3.89 | 218.85 | 1.83 | 3.81 | 108.20 |
Heap Segment Array Updates | 12 | 15 | 0.21 | 0.61 | 190.48 | 0.22 | 0.73 | 231.82 | 0.33 | 0.71 | 115.15 |
IMU CR rollbacks | 10 | 2 | 0.17 | 0.08 | -52.94 | 0.19 | 0.10 | -47.37 | 0.28 | 0.10 | -64.29 |
IMU Flushes | 22 | 9 | 0.38 | 0.37 | -2.63 | 0.41 | 0.44 | 7.32 | 0.61 | 0.43 | -29.51 |
IMU Redo allocation size | 41,340 | 36,596 | 721.31 | 1,492.86 | 106.97 | 766.96 | 1,777.20 | 131.72 | 1,148.33 | 1,742.67 | 51.76 |
IMU commits | 31 | 16 | 0.54 | 0.65 | 20.37 | 0.58 | 0.78 | 34.48 | 0.86 | 0.76 | -11.63 |
IMU contention | 1 | 1 | 0.02 | 0.04 | 100.00 | 0.02 | 0.05 | 150.00 | 0.03 | 0.05 | 66.67 |
IMU undo allocation size | 83,220 | 51,996 | 1,452.04 | 2,121.07 | 46.08 | 1,543.94 | 2,525.06 | 63.55 | 2,311.67 | 2,476.00 | 7.11 |
LOB table id lookup cache misses | 0 | 40 | 0.00 | 1.63 | 100.00 | 0.00 | 1.94 | 100.00 | 0.00 | 1.90 | 100.00 |
RowCR - row contention | 31 | 13 | 0.54 | 0.53 | -1.85 | 0.58 | 0.63 | 8.62 | 0.86 | 0.62 | -27.91 |
RowCR attempts | 9,497 | 3,004 | 165.71 | 122.54 | -26.05 | 176.19 | 145.88 | -17.20 | 263.81 | 143.05 | -45.78 |
RowCR hits | 9,466 | 2,991 | 165.16 | 122.01 | -26.13 | 175.62 | 145.25 | -17.29 | 262.94 | 142.43 | -45.83 |
SMON posted for undo segment shrink | 2 | 0 | 0.03 | 0.00 | -100.00 | 0.04 | 0.00 | -100.00 | 0.06 | 0.00 | -100.00 |
SQL*Net roundtrips to/from clien t | 167 | 78 | 2.91 | 3.18 | 9.28 | 3.10 | 3.79 | 22.26 | 4.64 | 3.71 | -20.04 |
Workload Capture: user logins | 2 | 0 | 0.03 | 0.00 | -100.00 | 0.04 | 0.00 | -100.00 | 0.06 | 0.00 | -100.00 |
active txn count during cleanout | 200 | 258 | 3.49 | 10.52 | 201.43 | 3.71 | 12.53 | 237.74 | 5.56 | 12.29 | 121.04 |
auto extends on undo tablespace | 0 | 1 | 0.00 | 0.04 | 100.00 | 0.00 | 0.05 | 100.00 | 0.00 | 0.05 | 100.00 |
background timeouts | 209 | 78 | 3.65 | 3.18 | -12.88 | 3.88 | 3.79 | -2.32 | 5.81 | 3.71 | -36.14 |
buffer is not pinned count | 922,077 | 332,919 | 16,088.59 | 13,580.73 | -15.59 | 17,106.86 | 16,167.40 | -5.49 | 25,613.25 | 15,853.29 | -38.11 |
buffer is pinned count | 93,928,810 | 33,191,752 | 1,638,889.30 | 1,353,987.65 | -17.38 | 1,742,617.21 | 1,611,876.07 | -7.50 | 2,609,133.61 | 1,580,559.62 | -39.42 |
bytes received via SQL*Net from client | 27,547 | 15,859 | 480.65 | 646.93 | 34.59 | 511.07 | 770.15 | 50.69 | 765.19 | 755.19 | -1.31 |
bytes sent via SQL*Net to client | 19,149 | 15,005 | 334.12 | 612.10 | 83.20 | 355.26 | 728.68 | 105 .11 | 531.92 | 714.52 | 34.33 |
calls to get snapshot scn: kcmgss | 24,021 | 12,044 | 419.12 | 491.31 | 17.22 | 445.65 | 584.89 | 31.24 | 667.25 | 573.52 | -14.05 |
calls to kcmgas | 412 | 558 | 7.19 | 22.76 | 216.55 | 7.64 | 27.10 | 254.71 | 11.44 | 26.57 | 132.26 |
calls to kcmgcs | 43 | 146 | 0.75 | 5.96 | 694.67 | 0.80 | 7.09 | 786.25 | 1.19 | 6.95 | 484.03 |
calls to kcmgrs | 29,755 | 20,138 | 519.17 | 821.49 | 58.23 | 552.03 | 977.95 | 77.16 | 826.53 | 958.95 | 16.02 |
change write time | 13 | 9 | 0.23 | 0.37 | 60.87 | 0.24 | 0.44 | 83.33 | 0.36 | 0.43 | 19.44 |
cleanout - number of ktugct calls | 203 | 272 | 3.54 | 11.10 | 213.56 | 3.77 | 13.21 | 250.40 | 5.64 | 12.95 | 129.61 |
cleanouts and rollbacks - consistent read gets | 99 | 36 | 1.73 | 1.47 | -15.03 | 1.84 | 1.75 | -4.89 | 2.75 | 1.71 | -37.82 |
cleanouts only - consistent read gets | 3 | 10 | 0.05 | 0.41 | 720.00 | 0.06 | 0.49 | 716.67 | 0.08 | 0.48 | 500.00 |
cluster key scan block gets | 20 | 152 | 0.35 | 6.20 | 1,671.43 | 0.37 | 7.38 | 1,894.59 | 0.56 | 7.24 | 1,192.86 |
cluster key scans | 20 | 131 | 0.35 | 5.34 | 1,425.71 | 0.37 | 6.36 | 1,618.92 | 0.56 | 6.24 | 1,014.29 |
commit batch/immediate performed | 0 | 4 | 0.00 | 0.16 | 100.00 | 0.00 | 0.19 | 100.00 | 0.00 | 0.19 | 100.00 |
commit batch/immediate requested | 0 | 4 | 0.00 | 0.16 | 100.00 | 0.00 | 0.19 | 100.00 | 0.00 | 0.19 | 100.00 |
commit cleanout failures: callback failure | 2 | 5 | 0.03 | 0.20 | 566.67 | 0.04 | 0.24 | 500.00 | 0.06 | 0.24 | 300.00 |
commit cleanouts | 362 | 636 | 6.32 | 25.94 | 310.44 | 6.72 | 30.89 | 359.67 | 10.06 | 30.29 | 201.09 |
commit cleanouts successfully completed | 360 | 630 | 6.28 | 25.70 | 309.24 | 6.68 | 30.59 | 357.93 | 10.00 | 30.00 | 200.00 |
commit immediate performed | 0 | 4 | 0.00 | 0.16 | 100.00 | 0.00 | 0.19 | 100.00 | 0.00 | 0.19 | 100.00 |
commit immediate requested | 0 | 4 | 0.00 | 0.16 | 100.00 | 0.00 | 0.19 | 100.00 | 0.00 | 0.19 | 100.00 |
commit txn count during cleanout | 36 | 86 | 0.63 | 3.51 | 457.14 | 0.67 | 4.18 | 523.88 | 1.00 | 4.10 | 310.00 |
consistent changes | 717 | 721 | 12.51 | 29.41 | 135.09 | 13.30 | 35.01 | 163.23 | 19.92 | 34.33 | 72.34 |
consistent gets | 1,164,154 | 422,021 | 20,312.40 | 17,215.46 | -15.25 | 21,598.00 | 20,494.42 | -5.11 | 32,337.61 | 20,096.24 | -37.85 |
consistent gets - examination | 26,801 | 12,696 | 467.63 | 517.91 | 10.75 | 497.23 | 616.55 | 24.00 | 744.47 | 604.57 | -18.79 |
consistent gets from cache | 1,164,154 | 422,021 | 20,312.40 | 17,215.46 | -15.25 | 21,598.00 | 20,494.42 | -5.11 | 32,337.61 | 20,096.24 | -37.85 |
consistent gets from cache (fastpath) | 1,124,040 | 404,919 | 19,612.48 | 16,517.82 | -15.78 | 20,853.79 | 19,663.90 | -5.71 | 31,223.33 | 19,281.86 | -38.25 |
cursor authentications | 9 | 70 | 0.16 | 2.86 | 1,687.50 | 0.17 | 3.40 | 1,900.00 | 0.25 | 3.33 | 1,232.00 |
data blocks consistent reads - undo records applied | 702 | 273 | 12.25 | 11.14 | -9.06 | 13.02 | 13.26 | 1.84 | 19.50 | 13.00 | -33.33 |
db block gets | 24,055 | 30,581 | 419.72 | 1,247.49 | 197.22 | 446.28 | 1,485.09 | 232.77 | 668.19 | 1,4 56.24 | 117.94 |
db block gets direct | 4 | 149 | 0.07 | 6.08 | 8,585.71 | 0.07 | 7.24 | 10,242.86 | 0.11 | 7.10 | 6,354.55 |
db block gets from cache | 24,051 | 30,432 | 419.65 | 1,241.41 | 195.82 | 446.21 | 1,477.86 | 231.20 | 668.08 | 1,449.14 | 116.91 |
db block gets from cache (fastpath) | 7,640 | 9,048 | 133.30 | 369.09 | 176.89 | 141.74 | 439.39 | 210.00 | 212.22 | 430.86 | 103.03 |
deferred (CURRENT) block cleanout applications | 204 | 266 | 3.56 | 10.85 | 204.78 | 3.78 | 12.92 | 241.80 | 5.67 | 12.67 | 123.46 |
enqueue conversions | 15 | 24 | 0.26 | 0.98 | 276.92 | 0.28 | 1.17 | 317.86 | 0.42 | 1.14 | 171.43 |
enqueue releases | 899 | 1,202 | 15.69 | 49.03 | 212.49 | 16.68 | 58.37 | 249.94 | 24.97 | 57.24 | 129.24 |
enqueue requests | 912 | 1,208 | 15.91 | 49.28 | 209.74 | 16.92 | 58.66 | 246.69 | 25.33 | 57.52 | 127.08 |
enqueue timeouts | 10 | 4 | 0.17 | 0.16 | -5.88 | 0.19 | 0.19 | 0.00 | 0.28 | 0.19 | -32.14 |
enqueue waits | 0 | 1 | 0.00 | 0.04 | 100.00 | 0.00 | 0.05 | 100.00 | 0.00 | 0.05 | 100.00 |
free buffer requested | 345 | 758 | 6.02 | 30.92 | 413.62 | 6.40 | 36.81 | 475.16 | 9.58 | 36.10 | 276.83 |
heap block compress | 66 | 27 | 1.15 | 1.10 | -4.35 | 1.22 | 1.31 | 7.38 | 1.83 | 1.29 | -29.51 |
immediate (CR) block cleanout applications | 102 | 46 | 1.78 | 1.88 | 5.62 | 1.89 | 2.23 | 17.99 | 2.83 | 2.19 | -22.61 |
immediate (CURRENT) block cleanout applications | 106 | 211 | 1.85 | 8.61 | 365.41 | 1.97 | 10.25 | 420.30 | 2.94 | 10.05 | 241.84 |
index crx upgrade (positioned) | 89 | 16 | 1.55 | 0.65 | -58.06 | 1.65 | 0.78 | -52.73 | 2.47 | 0.76 | -69.23 |
index fetch by key | 14,052 | 5,852 | 245.18 | 238.72 | -2.63 | 260.70 | 284.19 | 9.01 | 390.33 | 278.67 | -28.61 |
index scans kdiixs1 | 4,151 | 2,882 | 72.43 | 117.57 | 62.32 | 77.01 | 139.96 | 81.74 | 115.31 | 137.24 | 19.02 |
leaf node 90-10 splits | 12 | 8 | 0.21 | 0.33 | 57.14 | 0.22 | 0.39 | 77.27 | 0.33 | 0.38 | 15.15 |
leaf node splits | 36 | 72 | 0.63 | 2.94 | 366.67 | 0.67 | 3.50 | 422.39 | 1.00 | 3.43 | 243.00 |
lob reads | 0 | 438 | 0.00 | 17.87 | 100.00 | 0.00 | 21.27 | 100.00 | 0.00 | 20.86 | 100.00 |
lob writes | 6 | 353 | 0.10 | 14.40 | 14,300.00 | 0.11 | 17.14 | 15,481.82 | 0.17 | 16.81 | 9,788.24 |
lob writes unaligned | 6 | 353 | 0.10 | 14.40 | 14,300.00 | 0.11 | 17.14 | 15,481.82 | 0.17 | 16.81 | 9,788.24 |
messages received | 156 | 80 | 2.72 | 3.26 | 19.85 | 2.89 | 3.89 | 34.60 | 4.33 | 3.81 | -12.01 |
messages sent | 156 | 80 | 2.72 | 3.26 | 19.85 | 2.89 | 3.89 | 34.60 | 4.33 | 3.81 | -12.01 |
no work - consistent read gets | 1,122,530 | 403,359 | 19,586.14 | 16,454.18 | -15.99 | 20,825.77 | 19,588.14 | -5.94 | 31,181.39 | 19,207.57 | -38.40 |
parse count (hard) | 1 | 284 | 0.02 | 11.59 | 57,850.00 | 0.02 | 13.79 | 68,850.00 | 0.03 | 13.52 | 44,966.67 |
parse time cpu | 4 | 34 | 0.07 | 1.39 | 1,885.71 | 0.07 | 1.65 | 2,257.14 | 0.11 | 1.62 | 1,372.73 |
physical read IO requests | 4 | 41 | 0.07 td> | 1.67 | 2,285.71 | 0.07 | 1.99 | 2,742.86 | 0.11 | 1.95 | 1,672.73 |
physical read bytes | 57,344 | 360,448 | 1,000.55 | 14,703.72 | 1,369.56 | 1,063.88 | 17,504.27 | 1,545.32 | 1,592.89 | 17,164.19 | 977.55 |
physical read total IO requests | 741 | 781 | 12.93 | 31.86 | 146.40 | 13.75 | 37.93 | 175.85 | 20.58 | 37.19 | 80.71 |
physical read total bytes | 12,091,3 92 | 12,334,080 | 210,973.11 | 503,142.83 | 138.49 | 224,325.93 | 598,974.36 | 167.01 | 335,872.00 | 587,337.14 | 74.87 |
physical reads cache | 7 | 44 | 0.12 | 1.79 | 1,391.67 | 0.13 | 2.14 | 1,546.15 | 0.19 | 2.10 | 1,005.26 |
physical reads cache prefetch | 3 | 3 | 0.05 | 0.12 | 140.00 | 0.06 | 0.15 | 150.00 | 0.08 | 0.14 | 75.00 |
physical reads prefetch warmup | 3 | 3 | 0.05 | 0.12 | 140.00 | 0.06 | 0.15 | 150.00 | 0.08 | 0.14 | 75.00 |
physical write IO requests | 109 | 177 | 1.90 | 7.22 | 280.00 | 2.02 | 8.60 | 325.74 | 3.03 | 8.43 | 178.22 |
physical write bytes | 4,571,136 | 3,072,000 | 79,758.13 | 125,315.77 | 57.12 | 84,806.14 | 149,184.15 | 75.91 | 126,976.00 | 146,285.71 | 15.21 |
physical write total IO requests | 209 | 271 | 3.65 | 11.05 | 202.74 | 3.88 | 13.16 | 239.18 | 5.81 | 12.90 | 122.03 |
physical write total bytes | 8,771,584 | 15,395,328 | 153,048.41 | 628,019.99 | 310.34 | 162,735.09 | 747,636.36 | 359.42 | 243,655.11 | 733,110.86 | 200.88 |
physical write total multi block requests | 32 | 29 | 0.56 | 1.18 | 110.71 | 0.59 | 1.41 | 138.98 | 0.89 | 1.38 | 55.06 |
physical writes direct | 4 | 149 | 0.07 | 6.08 | 8,585.71 | 0.07 | 7.24 | 10,242.86 | 0.11 | 7.10 | 6,354.55 |
physical writes direct (lob) | 4 | 149 | 0.07 | 6.08 | 8,585.71 | 0.07 | 7.24 | 10,242.86 | 0.11 | 7.10 | 6,354.55 |
physical writes from cache | 554 | 226 | 9.67 | 9.22 | -4.65 | 10.28 | 10.98 | 6.81 | 15.39 | 10.76 | -30.08 |
physical writes non checkpoint | 229 | 197 | 4.00 | 8.04 | 101.00 | 4.25 | 9.57 | 125.18 | 6.36 | 9.38 | 47.48 |
process last non-idle time | 0 | 14 | 0.00 | 0.57 | 100.00 | 0.00 | 0.68 | 100.00 | 0.00 | 0.67 | 100.00 |
recursive calls | 21,178 | 30,445 | 369.52 | 1,241.94 | 236.10 | 392.91 | 1,478.49 | 276.29 | 588.28 | 1,449.76 | 146.44 |
recursive cpu usage | 5,453 | 2,149 | 95.15 | 87.66 | -7.87 | 101.17 | 104.36 | 3.15 | 151.47 | 102.33 | -32.44 |
redo blocks checksummed by FG (exclusive) | 1,585 | 2,911 | 27.66 | 118.75 | 329.32 | 29.41 | 141.37 | 380.69 | 44.03 | 138.62 | 214.83 |
redo blocks written | 6,540 | 12,901 | 114.11 | 526.27 | 361.20 | 121.33 | 626.51 | 416.37 | 181.67 | 614.33 | 238.16 |
redo blocks written for direct writes | 156 | 7,792 | 2.72 | 317.86 | 11,586.03 | 2.89 | 378.40 | 12,993.43 | 4.33 | 371.05 | 8,469.28 |
redo entries | 9,982 | 16,459 | 174.17 | 671.41 | 285.49 | 185.19 | 799.29 | 331.61 | 277.28 | 783.76 | 182.66 |
redo ordering marks | 193 | 349 | 3.37 | 14.24 | 322.55 | 3.58 | 16.95 | 373.46 | 5.36 | 16.62 | 210.07 |
redo subscn max counts | 298 | 700 | 5.20 | 28.56 | 449.23 | 5.53 | 33.99 | 514.65 | 8.28 | 33.33 | 302.54 |
redo synch time | 0 | 2 | 0.00 | 0.08 | 100.00 | 0.00 | 0.10 | 100.00 | 0.00 | 0.10 | 100.00 |
redo synch writes | 18 | 17 | 0.31 | 0.69 | 122.58 | 0.33 | 0.83 | 151.52 | 0.50 | 0.81 | 62.00 |
redo wastage | 11,488 | 11,440 | 200.44 | 466.67 | 132.82 | 213.13 | 555.56 | 160.67 | 319.11 | 544.76 | 70.71 |
redo write time | 3 | 21 | 0.05 | 0.86 | 1,620.00 | 0.06 | 1.02 | 1,600.00 | 0.08 | 1.00 | 1,150.00 |
redo writes | 47 | 46 | 0.82 | 1.88 | 129.27 | 0.87 | 2.23 | 156.32 | 1.31 | 2.19 | 67.18 |
rollback changes - undo records applied | 0 | 6 | 0.00 | 0.24 | 100.00 | 0.00 | 0.29 | 100.00 | 0.00 | 0.29 | 100.00 |
rollbacks only - consistent read gets | 3 | 5 | 0.05 | 0.20 | 300.00 | 0.06 | 0.24 | 300.00 | 0.08 | 0.24 | 200.00 |
rows fetched via callback | 13,380 | 5,069 | 233.46 | 206.78 | -11.43 | 248.23 | 246.16 | -0.83 | 371.67 | 241.38 | -35.06 |
session pga memory | 1,943,124 | 1,835,008 | 33,904.03 | 74,855.29 | 120.79 | 36,049.87 | 89,112.67 | 147.19 | 53,975.67 | 87,381.33 | 61.89 |
session pga memory max | -1,202,604 | 22,282,240 | -20,983.28 | 908,957.07 | -4,431.82 | -22,311.35 | 1,082,082.36 | -4,949.92 | -33,405.67 | 1,061,059.05 | -3,276.28 |
ses sion uga memory | 4,296,520,184 | 961,776 | 74,966,572.45 | 39,233.63 | -99.95 | 79,711,326.02 | 46,706.29 | -99.94 | 119,347,782.89 | 45,798.86 | -99.96 |
session uga memory max | 6,893,108 | 7,236,272 | 120,272.37 | 295,188.48 | 145.43 | 127,884.60 | 351,411.81 | 174.79 | 191,475.22 | 344,584.38 | 79.96 |
shared hash latch upgrades - no wait | 13,220 | 4,352 | 230.67 | 177.53 | -23.04 | 245.26 | 211.34 | -13.83 | 367.22 | 207.24 | -43.57 |
sorts (memory) | 646 | 522 | 11.27 | 21.29 | 88.91 | 11.98 | 25.35 | 111.60 | 17.94 | 24.86 | 38.57 |
sorts (rows) | 5,683 | 9,085 | 99.16 | 370.60 | 273.74 | 105.43 | 441.19 | 318.47 | 157.86 | 432.62 | 174.05 |
sql area evicted | 0 | 54 | 0.00 | 2.20 | 100.00 | 0.00 | 2.62 | 100.00 | 0.00 | 100.00 | |
switch current to new buffer | 23 | 27 | 0.40 | 1.10 | 175.00 | 0.43 | 1.31 | 204.65 | 0.64 | 1.29 | 101.56 |
table fetch by rowid | 47,418,467 | 16,758,716 | 827,367.22 | 683,636.54 | -17.37 | 879,732.60 | 813,845.96 | -7.49 | 1,317,179.64 | 798,034.10 | -39.41 |
table fetch continued row | 0 | 8 | 0.00 | 0.33 | 100.00 | 0.00 | 0.39 | 100.00 | 0.00 | 0.38 | 100.00 |
table scan blocks gotten | 8,322 | 5,035 | 145.20 | 205.39 | 41.45 | 154.39 | 244.51 | 58.37 | 231.17 | 239.76 | 3.72 |
table scan rows gotten | 222,220 | 223,996 | 3,877.34 | 9,137.45 | 135.66 | 4,122.74 | 10,877.82 | 163.85 | 6,172.78 | 10,666.48 | 72.80 |
table scans (short tables) | 1,089 | 410 | 19.00 | 16.73 | -11.95 | 20.20 | 19.91 | -1.44 | 30.25 | 19.52 | -35.47 |
total number of times SMON posted | 2 | 0 | 0.03 | 0.00 | -100.00 | 0.04 | 0.00 | -100.00 | 0.06 | 0.00 | -100.00 |
transaction rollbacks | 0 | 4 | 0.00 | 0.16 | 100.00 | 0.00 | 0.19 | 100.00 | 0.00 | 0.19 | 100.00 |
undo change vector size | 1,174,492 | 1,927,636 | 20,492.78 | 78,633.85 | 283.71 | 21,789.80 | 93,610.92 | 329.61 | 32,624.78 | 91,792.19 | 181.36 |
Avg Reads / Sec | '), AWRRPT_HTML_TYPE('Avg Writes / Sec | '), AWRRPT_HTML_TYPE('Reads | '), AWRRPT_HTML_TYPE('Avg Read Time (ms) | '), AWRRPT_HTML_TYPE('Avg Blocks / Read | '), AWRRPT_HTML_TYPE('Writes | '), AWRRPT_HTML_TYPE('Buffer Waits | '), AWRRPT_HTML_TYPE('Avg Buf Wait Time (ms) | '), AWRRPT_HTML_TYPE('IOs per second | '), AWRRPT_HTML_TYPE('|||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Tablespace | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | Diff |
SYSAUX | '), AWRRPT_HTML_TYPE('0.06 | 1.26 | 2,000.00 | 1.47 | 8.30 | 464.63 | 3 | 26 | 46.67 | 8.08 | 2.00 | 1.27 | 79 | 171 | 0 | 0 | 0.00 | 0.00 | 1.52 | 9.57 | 8.05 |
Avg Reads / Sec | '), AWRRPT_HTML_TYPE('Avg Writes / Sec | '), AWRRPT_HTML_TYPE('Reads | '), AWRRPT_HTML_TYPE('Avg Read Time (ms) | '), AWRRPT_HTML_TYPE('Avg Blocks / Read | '), AWRRPT_HTML_TYPE('Writes | '), AWRRPT_HTML_TYPE('Buffer Waits | '), AWRRPT_HTML_TYPE('Avg Buf Wait Time (ms) | '), AWRRPT_HTML_TYPE('IOs per second | '), AWRRPT_HTML_TYPE('||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Tablespace | Filename | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | Diff |
SYSAUX | C:\ORACLE\ORADATA\PWHD\DATAFILE\O1_MF_SYSAUX_5WJTWL17_.DBF | '), AWRRPT_HTML_TYPE('0.06 | 1.26 | 2,000.00 | 1.47 | 8.30 | 464.63 | 3 | 26 | 46.67 | 8.08 | 2.00 | 1.27 | 79 | 171 | 0 | 0 | 0.00 | 0.00 | 1.52 | 9.57 | 8.05 |
Read Time % of DB time | '), AWRRPT_HTML_TYPE('Avg Read Time (ms) | '), AWRRPT_HTML_TYPE('Reads | '), AWRRPT_HTML_TYPE('Avg Reads per Sec | '), AWRRPT_HTML_TYPE('Avg Blocks per Read | '), AWRRPT_HTML_TYPE('Writes | '), AWRRPT_HTML_TYPE('Avg Writes per Sec | '), AWRRPT_HTML_TYPE('Buffer Waits | '), AWRRPT_HTML_TYPE('Avg Buf Wait Time (ms) | '), AWRRPT_HTML_TYPE('||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Tablespace | Filename | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd |
SYSAUX | C:\ORACLE\ORADATA\PWHD\DATAFILE\O1_MF_SYSAUX_5WJTWL17_.DBF | '), AWRRPT_HTML_TYPE('0.24 | 0.86 | 0.61 | 46.67 | 8.08 | 3 | 26 | 0.06 | 1.26 | 2.00 | 1.27 | 79 | 171 | 1.47 | 8.30 | 0 | 0 | 0.00 | 0.00 |
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 | |
---|---|---|---|---|---|---|---|---|
B1 | 0 | 22 | 3,013 | 30,971 | 184,320 | 184,320 | 184,320 | 203,899 |
E1 | 0 | 22 | 3,176 | 31,501 | 184,320 | 184,320 | 184,320 | 204,369 |
B2 | 0 | 22 | 3,000 | 28,062 | 184,320 | 184,320 | 184,320 | 192,509 |
E2 | 0 | 23 | 3,858 | 39,284 | 184,320 | 184,320 | 184,320 | 203,776 |
PGA Cache Hit % | '), AWRRPT_HTML_TYPE('W/A Bytes/Sec (DB time) | '), AWRRPT_HTML_TYPE('W/A MB Processed | '), AWRRPT_HTML_TYPE('Read/Written W/A Bytes/Sec (DB time) | '), AWRRPT_HTML_TYPE('Read/Written W/A MB | '), AWRRPT_HTML_TYPE('||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
1st | 2nd | Diff | 1st | 2nd | %Diff | 1st | 2nd | 1st | 2nd | %Diff th> | 1st | 2nd |
100.00 | 100.00 | 0.00 | 234,432 | 769,606 | 228.28 | 13 | 18 | 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) | |
---|---|---|---|---|---|---|---|---|
Wait Time % of DB time | '), AWRRPT_HTML_TYPE('Total Wait Time (s) | '), AWRRPT_HTML_TYPE('# Waits | '), AWRRPT_HTML_TYPE('Avg Wait Time (ms) | '), AWRRPT_HTML_TYPE('|||||||
---|---|---|---|---|---|---|---|---|---|---|
Class | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | %Diff |
undo header | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | 0 | 0.00 | 0.00 | 0.00 |
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 | 1.64 | 1,158 | 330 | 4 | 19.5/19.5 | 0/0 | 0/0/0/6/40/0 |
2nd | 1.92 | 2,329 | 329 | 5 | 19.5/19.5 | 0/0 | 0/0/0/4/24/0 |
% of Total Sleeps | '), AWRRPT_HTML_TYPE('Get Requests | '), AWRRPT_HTML_TYPE('Misses | '), AWRRPT_HTML_TYPE('Spin Gets | '), AWRRPT_HTML_TYPE('Sleeps | '), AWRRPT_HTML_TYPE('Wait Time (cs) | '), AWRRPT_HTML_TYPE('|||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Latch Name | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | Diff |
shared pool | 0.00 | 100.00 | 100.00 | 3,588 | 27,238 | 0 | 4 | 0 | 2 | 0 | 2 | 0 | 18,188 | 18,188 |
Wait Time (cs) | '), AWRRPT_HTML_TYPE('Get Requests | '), AWRRPT_HTML_TYPE('Misses | '), AWRRPT_HTML_TYPE('Spin Gets | '), AWRRPT_HTML_TYPE('Sleeps | '), AWRRPT_HTML_TYPE('% of Total Sleeps | '), AWRRPT_HTML_TYPE('|||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Latch Name | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | Diff |
shared pool | 0 | 18,188 | 18,188 | 3,588 | 27,238 | 0 | 4 | 0 | 2 | 0 | 2 | 0.00 | 100.00 | 100.00 |
% of Total Logical Reads | '), AWRRPT_HTML_TYPE('Logical Reads | '), AWRRPT_HTML_TYPE('% of Captured Logical Reads | '), AWRRPT_HTML_TYPE('||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | 1st | 2nd | Diff |
SYSMAN | SYSAUX | MGMT_JOB_EXEC_SUMMARY | TABLE | 74.46 | 74.46 | 70.29 | 70.29 | -4.17 | 884,784 | 318,128 | 74.77 | 70.77 | -4.00 | |
SYS | SYSAUX | WRH$_SQL_PLAN_PK | INDEX | 2.58 | 72.87 | 2.58 | 11,680 | 2.60 | 2.60 | |||||
SYS | SYSAUX | WRH$_SQL_PLAN | TABLE | 0.03 | 74.50 | 1.40 | 74.27 | 1.37 | 400 | 6,336 | 0.03 | 1.41 | 1.38 | |
SYSMAN | SYSAUX | MGMT_JOB_EXEC_SUMM_IDX02 | INDEX | 19.73 | 94.23 | 18.48 | 92.75 | -1.25 | 234,480 | 83,648 | 19.82 | 18.61 | -1.21 | |
MYAPP | USERS | ACCOUNTS | TABLE | 0.25 | 94.48 | 0.65 | 93.40 | 0.41 td> | 2,912 | 2,944 | 0.25 | 0.65 | 0.41 | |
SYSMAN | SYSAUX | PK_MGMT_EXEC_SUMM | INDEX | 0.70 | 95.17 | 0.56 | 93.96 | -0.14 | 8,272 | 2,528 | 0.70 | 0.56 | -0.14 | |
SYSMAN | SYSAUX | MGMT_VERSIONS | TABLE | 0.61 | 95.79 | 0.50 | 94.46 | -0.11 | 7,280 | 2,272 | 0.62 | 0.51 | -0.11 | |
SYSMAN | SYSAUX | MGMT_JOB_EXEC_SUMM_IDX05 | INDEX | 0.44 | 96.22 | 0.39 | 94.85 | -0.05 | 5,216 | 1,744 | 0.44 | 0.39 | -0.05 |
% of Total Physical Reads | '), AWRRPT_HTML_TYPE('Physical Reads | '), AWRRPT_HTML_TYPE('% of Captured Physical Reads | '), AWRRPT_HTML_TYPE('||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 1st Total | 2nd | 2nd Total | Diff | 1st | 2nd | 1st | 2nd | Diff |
SYS | SYSAUX | WRH$_SQL_PLAN | TABLE | 57.14 | 57.14 | 0.00 | 0.00 | -57.14 | 4 | 0 | 100.00 | 0.00 | -100.00 | |
SYS | SYSTEM | CDEF$ | TABLE | 4.55 | 4.55 | 4.55 | 2 | 33.33 | 33.33 | |||||
SYS | SYSAUX | WRH$_DB_CACHE_ADVICE_PK | WRH$_DB_CAC_4252952393_43 | INDEX PARTITION | 4.55 | 9.09 | 4.55 | 2 | 33.33 | 33.33 | ||||
SYS | SYSAUX | WRH$_WAITSTAT_P K | WRH$_WAITST_4252952393_43 | INDEX PARTITION | 4.55 | 13.64 | 4.55 | 2 | 33.33 | 33.33 | ||||
SYS | SYSTEM | CCOL$ | TABLE | 0.00 | 13.64 | 0.00 | 0 | 0.00 | 0.00 | |||||
SYS | SYSTEM | I_CDEF2 | INDEX | 0.00 | 13.64 | 0.00 | 0 | 0.00 | 0.00 | |||||
SYS | SYSTEM | KOTAD$ | TABLE | 0.00 | 57.14 | 0.00 | 13.64 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0.00 | |
SYS | SYSTEM | KOTTB$ | TABLE | 0.00 | 57.14 | 0.00 | 13.64 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0.00 | |
SYS | SYSTEM | SYS_C00642 | INDEX | 0.00 | 57.14 | 0.00 | 13.64 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0.00 | |
SYS | SYSTEM | SYS_C00643 | INDEX | 0.00 | 57.14 | 0.00 | 13.64 | 0.0 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
% of Total | '), AWRRPT_HTML_TYPE('Row Lock Waits | '), AWRRPT_HTML_TYPE('% of Captured | '), AWRRPT_HTML_TYPE('||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Owner | Tablespace | Object Name | Subobject Name | Type | 1st | 2nd | Diff | 1st | 2nd | 1st | 1st Total | 2nd | 2nd Total | Diff |
SYS | SYSTEM | WRR$_REPLAYS | TABLE | 100.00 | 100.00 | 1 | 100.00 | 100.00 | 100.00 |
Get Requests per Sec (DB time) | '), AWRRPT_HTML_TYPE('Get Requests per Sec (Elapsed Time) | '), AWRRPT_HTML_TYPE('Get Requests | '), AWRRPT_HTML_TYPE('Pct Miss | '), AWRRPT_HTML_TYPE('Scan Requests | '), AWRRPT_HTML_TYPE('Pct Miss | '), AWRRPT_HTML_TYPE('Mod Reqs | '), AWRRPT_HTML_TYPE('Final Usage | '), AWRRPT_HTML_TYPE('|||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cache | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd |
dc_awr_control | 0.07 | 0.16 | 128.57 | 0.07 | 0.19 | 171.43 | 4 | 4 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | < td align="right" class=''awrclb''>22 | 1 | 1 | |
dc_database_links | 0.05 | 0.33 | 560.00 | 0.06 | 0.39 | 550.00 | 3 | 8 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 1 | 1 |
dc_global_oids | 1.81 | 2.45 | 35.36 | 1.93 | 2.91 | 50.78 | 104 | 60 | 0.00 | 10.00 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 242 | 412 |
dc_histogram_data | 0.00 | 16.81 | 100.00 | 0.00 | 20.01 | 100.00 | 0 | 412 | 0.00 | 3.16 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 680 | 788 |
dc_histogram_defs | 0.05 | 133.15 | 266,200.00 | 0.06 | 158.51 | 264,083.33 | 3 | 3,264 | 0.00 | 18.60 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 5,316 | 5,167 |
dc_object_grants | 0.14 | 4.08 | 2,814.29 | 0.15 | 4.86 | 3,140.00 | 8 | 100 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 226 | 243 |
dc_objects | 4.73 | 125.76 | 2,558.77 | 5.03 | 149.72 | 2,876.54 | 271 | 3,083 | 1.48 | 0.32 | 0 | 0 | 0.00 | 0.00 | 3 | 0 | 5,609 | 4,408 |
dc_profiles | 0.03 | 0.20 | 566.67 | 0.04 | 0.24 | 500.00 | 2 | 5 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 2 | 2 |
dc_rollback_segments | 0.40 | 4.32 | 980.00 | 0.43 | 5.15 | 1,097.67 | 23 | 106 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 22 | 22 |
dc_segments | 0.23 | 56.91 | 24,643.48 | 0.24 | 67.74 | 28,125.00 | 13 | 1,395 | 0.00 | 0.43 | 0 | 0 | 0.00 | 0.00 | 6 | 12 | 1,552 | 1,483 |
dc_sequences | 0.00 | 0.24 | 100.00 | 0.00 | 0.29 | 100.00 | 0 | 6 | 0.00 | 16.67 | 0 | 0 | 0.00 | 0.00 | 0 | 6 | 13 | 6 |
dc_tablespaces | 20.19 | 131.39 | 550.77 | 21.47 | 156.42 | 628.55 | 1,157 | 3,221 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 6 | 7 |
dc_users | 23.35 | 117.52 | 403.30 | 24.82 | 139.91 | 463.70 | 1,338 | 2,881 | 0.07 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 175 | 264 |
global database name | 0.92 | 0.90 | -2.17 | 0.98 | 1.07 | 9.18 | 53 | 22 | 0.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 1 | 2 |
sch_lj_objs | 0.03 | 0.00 | -100.00 | 0.04 | 0.00 | -100.00 | 2 | 0 | 50.00 | 0.00 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 2 | 2 |
Get Requests per Sec (DB Per) | '), AWRRPT_HTML_TYPE('Get Requests per Sec (Elapsed Time) | '), AWRRPT_HTML_TYPE('Get Requests | '), AWRRPT_HTML_TYPE('Pct Miss | '), AWRRPT_HTML_TYPE('Pin Requests | '), AWRRPT_HTML_TYPE('Pct Mi ss | '), AWRRPT_HTML_TYPE('Reloads | '), AWRRPT_HTML_TYPE('Invalidations | '), AWRRPT_HTML_TYPE('|||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Namespace | 1st | 2nd | %Diff | 1st | 2nd | %Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd |
BODY | 0.61 | 0.61 | 0.00 | 0.65 | 0.73 | 12.31 | 35 | 15 | 0.00 | 0.00 | 2,777 | 908 | 0.00 | 0.11 | 0 | 1 | 0 | 0 |
CLUSTER | 0.00 | 1.63 | 100.00 | 0.00 | 1.94 | 100.00 td> | 0 | 40 | 0.00 | 0 | 9 | 0.00 | 0 | 0 | 0 | 0 | ||
INDEX | 0.00 | 3.63 | 100.00 | 0.00 | 4.32 | 100.00 | 0 | 89 | 0.00 | 0 | 71 | 0.00 | 0 | 0 | 0 | 0 | ||
SQL AREA | 3.14 | 18.03 | 474.20 | 3.34 | 21.46 | 542.51 | 180 | 442 | 1.11 | 17.87 | 16,356 | 8,668 | 0.02 | 10.06 | 0 | 226 | 0 | 0 |
TABLE/PROCEDURE | 2.27 | 57.60 | 2,437.44 | 2.41 | 68.57 | 2,745.23 | 130 | 1,412 | 0.77 | 0.71 | 3,452 | 3,370 | 0.03 | 9.91 | 0 | 284 | 0 | 0 |
TRIGGER | 0.23 | 0.16 | -30.43 | 0.24 | 0.19 | -20.83 | 13 | 4 | 0.00 | 0.00 | 3,109 | 1,000 | 0.00 | 0.00 | 0 | 0 | 0 | 0 |
1st | '), AWRRPT_HTML_TYPE('2nd | '), AWRRPT_HTML_TYPE('% Diff of | '), AWRRPT_HTML_TYPE('|||||||
---|---|---|---|---|---|---|---|---|---|
Category | Summary | Begin Value | End Value | %Diff | Begin Value | End Value | %Diff | Begin Values | End Values |
Other | Alloc (KB) | 69,845.29 | 68,054.87 | -2.56 | 68,110.72 | 71,305.73 | 4.69 | -2.48 | 4.78 |
Used (KB) | |||||||||
Avg Alloc (KB) | 1,887.71 | 1,839.32 | -2.56 | 1,891.96 | 1,980.71 | 4.69 | 0.23 | 7.69 | |
Std Dev Alloc (KB) | 1,702.14 | 1,703.01 | 0.05 | 1,748.53 | 1,846.57 | 5.61 | 2.73 | < td align="right" class=''awrncrb''>8.43||
Max Alloc (KB) | 9,401.56 | 9,401.56 | 0.00 | 9,401.56 | 9,401.56 | 0.00 | 0.00 | 0.00 | |
Hist Max Alloc (KB) | 22,937.71 | 22,937.71 | 0.00 | 22,937.71 | 38,725.69 | 68.83 | 0.00 | 68.83 | |
Num Procs | 37.00 | 37.00 | 0.00 | 36.00 | 36.00 | 0.00 | -2.70 | -2.70 | |
Num Alloc | 37.00 | 37.00 | 0.00 | 36.00 | 36.00 | 0.00 | -2.70 | -2.70 | |
PL/SQL | Alloc (KB) | 698.09 | 692.51 | -0.80 | 605.36 | 594.22 | -1.84 | -13.28 | -14.19 |
Used (KB) | 334.45 | 309.07 | -7.59 | 313.36 | 296.10 | -5.51 | -6.31 | -4.20 | |
Avg Alloc (KB) | 19.95 | 19.79 | -0.80 | 17.80 | 17.48 | -1.84 | -10.73 | -11.67 | |
Std Dev Alloc (KB) | 26.09 | 25.86 | -0.87 | 22.78 | 22.45 | -1.42 | -12.69 | -13.18 | |
Max Alloc (KB) | 95.26 | 74.79 | 0.00 | 74.79 | 74.79 | 0.00 | -21.49 | -21.49 | |
Hist Max Alloc (KB) | 95.26 | 95.26 | 0.00 | 323.39 | 323.39 | 0.00 | 239.47 | 239.47 | |
Num Procs | 35.00 | 35.00 | 0.00 | 34.00 | 34.00 | 0.00 | -2.86 | -2.86 | |
Num Alloc | 35.00 | 35.00 | 0.00 | 34.00 | 34.00 | 0.00 | -2.86 | -2.86 | |
SQL | Alloc (KB) | 240,529.93 | 242,005.94 | 0.61 | 264,977.98 | 265,314.12 | 0.13 | 10.16 | 9.63 |
Used (KB) | 204,487.65 | 205,761.19 | 0.62 | 225,239.86 | 225,579.34 | 0.15 | 10.15 | 9.63 | |
Avg Alloc (KB) | 9,621.20 | 9,680.24 | 0.61 | 11,040.75 | 11,054.75 | 0.13 | 14.75 | 14.20 | |
Std Dev Alloc (KB) | 47,692.11 | 47,960.23 | 0.56 | 53,617.52 | 53,704.43 | 0.16 | 12.42 | 11.98 | |
Max Alloc (KB) | 238,543.10 | 263,189.10 | 0.56 | 262,767.07 | 263,189.10 | 0.16 | 10.15 | 9.71 | |
Hist Max Alloc (KB) | 238,609.91 | 239,993.19 | 0.58 | 262,853.22 | 263,293.19 | 0.17 | 10.16 | 9.71 | |
Num Procs | 25.00 | 25.00 | 0.00 | 24.00 | 24.00 | 0.00 | -4.00 | -4.00 | |
Num Alloc | 22.00 | 22.00 | 0.00 | 22.00 | 22.00 | 0.00 | 0.00 | 0.00 |
1st | '), AWRRPT_HTML_TYPE('2nd | '), AWRRPT_HTML_TYPE('% Diff of | '), AWRRPT_HTML_TYPE('||||||
---|---|---|---|---|---|---|---|---|
SGA regions | Begin Value (KB) | End Value (KB) | %Diff | Begin Value (KB) | End Value (KB) | %Diff | Begin Values | End Values |
Database Buffers | 712,704.00 | 712,704.00 | 0.00 | 688,128.00 | 679,936.00 | -1.19 | -3.45 | -4.60 |
Fixed Size | 1,303.11 | 1,303.11 | 0.00 | 1,303.11 | 1,303.11 | 0.00 | 0.00 | 0.00 |
Redo Buffers | 4,536.00 | 4,536.00 | 0.00 | 4,536.00 | 4,536.00 | 0.00 | 0.00 | 0.00 |
Variable Size | 327,680.89 | 327,680.89 | 0.00 | 352,256.89 | 360,448.89 | 2.33 | 7.50 | 10.00 |
1st | '), AWRRPT_HTML_TYPE('2nd | '), AWRRPT_HTML_TYPE('%Diff of | '), AWRRPT_HTML_TYPE('|||||||
---|---|---|---|---|---|---|---|---|---|
Pool | Name | Begin Value | End Value | %Diff | Begin Value | End Value | %Diff | Begin Values | End Values |
java pool | free memory | 7,676,992 | 7,676,992 | 0.00 | 7,676,992 | 7,676,992 | 0.00 | 0.00 | 0.00 |
java pool | joxlod exec hp | 8,822,016 | 8,822,016 | 0.00 | 8,822,016 | 8,822,016 | 0.00 | 0.00 | 0.00 |
java pool | joxs heap | 278,208 | 278,208 | 0.00 | 278,208 | 278,208 | 0.00 | 0.00 | 0.00 |
large pool | free memory | 8,324,160 | 8,324,160 | 0.00 | 8,283,200 | 8,324,160 | 0.49 | -0.49 | 0.00 |
shared pool | ASH buffers | 4,194,304 | 4,194,304 | 0.00 | 4,194,304 | 4,194,304 | 0.00 | 0.00 | 0.00 |
shared pool | CCursor | 10,446,808 | 10,452,092 | 0.05 | 10,607,912 | 11,217,048 | 5.74 | 1.54 | 7.32 |
shared pool | Heap0: KGL | 6,612,368 | 6,615,532 | 0.05 | 6,324,064 | 6,348,124 | 0.38 | -4.36 | -4.04 |
shared pool | KCB Table Scan Buffer | 4,194,816 | 4,194,816 | 0.00 | 4,194,816 | 4,194,816 | 0.00 | 0.00 | 0.00 |
shared pool | KGL buckets | 3,145,728 | 3,145,728 | 0.00 | 3,145,728 | 3,145,728 | 0.0 0 | 0.00 | 0.00 |
shared pool | KGL handle | 7,422,024 | 7,422,840 | 0.01 | 8,493,860 | 8,544,352 | 0.59 | 14.44 | 15.11 |
shared pool | KGLS heap | 8,628,344 | 8,628,344 | 0.00 | 5,517,904 | 6,860,960 | 24.34 | -36.05 | -20.48 |
shared pool | KQR M PO | 5,761,580 | 5,764,140 | 0.04 | 4,634,164 | 4,945,472 | 6.72 | -19.57 | -14.20 |
shared pool | KSFD SGA I/O b | 4,190,228 | 4,190,228 | 0.00 | 4,190,228 | 4,190,228 | 0.00 | 0.00 | 0.00 |
shared pool | PCursor | 4,362,760 | 4,364,864 | 0.05 | 6,408,460 | 6,502,096 | 1.46 | 46.89 | 48.96 |
shared pool | PL/SQL DIANA | 13,344,108 | 13,344,108 | 0.00 | 12,306,788 | 12,466,000 | 1.29 | -7.77 | -6.58 |
shared pool | PL/SQL MPCODE | 16,354,824 | 16,354,824 | 0.00 | 17,304,960 | 17,309,028 | 0.02 | 5.81 | 5.83 |
shared pool | XDB Schema Cac | 7,203,024 | 7,203,024 | 0.00 | 7,203,024 | 7,203,024 | 0.00 | 0.00 | 0.00 |
shared pool | db_block_hash_buckets | 3,147,776 | 3,147,776 | 0.00 | 3,147,776 | 3,147,776 | 0.00 | 0.00 | 0.00 |
shared pool | dbwriter coalesce buffer | 4,194,816 | 4,194,816 | 0.00 | 4,194,816 | 4,194,816 | 0.00 | 0.00 | 0.00 |
shared pool | free memory | 45,234,576 | 45,211,156 | -0.05 | 34,700,044 | 40, 285,056 | 16.10 | -23.29 | -10.90 |
shared pool | row cache | 3,780,216 | 3,780,216 | 0.00 | 3,780,216 | 3,780,216 | 0.00 | 0.00 | 0.00 |
shared pool | sql area | 57,222,796 | 57,230,948 | 0.01 | 73,208,644 | 73,114,576 | -0.13 | 27.94 | 27.75 |
shared pool | type object de | 3,302,292 | 3,302,292 | 0.00 | 4,277,460 | 4,464,036 | 4.36 | 29.53 | 35.18 |
streams pool | free memory | 16,734,756 | 16,734,756 | 0.00 | |||||
buffer_cache | 729,808,896 | 729,808,896 | 0.00 | 704,643,072 | 696,254,464 | -1.19 | -3.45 | -4.60 | |
fixed_sga | 1,334,380 | 1,334,380 | 0.00 | 1,334,380 | 1,334,380 | 0.00 | 0.00 | 0.00 | |
log_buffer | 4,644,864 | 4,644,864 | 0.00 | 4,644,864 | 4,644,864 | 0.00 | 0.00 | 0.00 |
CPU Time (sec) | '), AWRRPT_HTML_TYPE('User I/O Time (sec) | '), AWRRPT_HTML_TYPE('System I/O Time (sec) | '), AWRRPT_HTML_TY PE('|||||||
---|---|---|---|---|---|---|---|---|---|
Session Type | 1st | 2nd | Diff | 1st | 2nd | Diff | 1st | 2nd | Diff |
QMON Slaves | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
QMON Coordinator | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
IO Time (sec) | '), AWRRPT_HTML_T YPE('CPU Time (sec) | '), AWRRPT_HTML_TYPE('|||||||||
---|---|---|---|---|---|---|---|---|---|---|
Session Type | 1st User | 1st System | 1st Total | 2nd User | 2nd System | 2nd Total | Total Diff | 1st | 2nd | Diff |
QMON Slaves | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
QMON Coordinator | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
Evaluations | '), AWRRPT_HTML _TYPE('Fast Evals | '), AWRRPT_HTML_TYPE('SQL Execs | '), AWRRPT_HTML_TYPE('CPU Time (sec) | '), AWRRPT_HTML_TYPE('Elapsed Time (sec) | '), AWRRPT_HTML_TYPE('|||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Ruleset Name | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd |
SYS.ALERT_QUE_R | 0 | 0 | 0 | 0 | 0.00 | 0.00 |
Elapsed Time (Sec) th>'), AWRRPT_HTML_TYPE(' | Fast Evals | '), AWRRPT_HTML_TYPE('SQL Execs | '), AWRRPT_HTML_TYPE('CPU Time (sec) | '), AWRRPT_HTML_TYPE('Evaluations | '), AWRRPT_HTML_TYPE('|||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Ruleset Name | 1st | 2nd | Diff | 1st | 2nd | 1st | 2nd | 1st | 2nd | 1st | 2nd |
SYS.ALERT_QUE_R | 0.00 | 0.00 | 0 | 0 | 0.00 | 0 |
1st Period | '), AWRRPT_HTML_TYPE('2nd Period | '), AWRRPT_HTML_TYPE('|||
---|---|---|---|---|
Parameter Name | Begin Snap Value | End Snap Value | Begin Snap Value | End Snap Value |
__db_cache_size | 729808896 | 704643072 | 696254464 | |
__java_pool_size | 16777216 | |||
__large_pool_size | 8388608 | |||
__oracle_base | C:\oracle | |||
__pga_aggregate_target | 687865856 | |||
__sga_target | 1015021568 | |||
__shared_io_pool_size | 0 | |||
__shared_pool_size | 251658240 | 260046848 | 268435456 | |
__streams_pool_size | 0 | 16777216 | ||
audit_file_dest | C:\ORACLE\ADMIN\PWHD\ADUMP | |||
audit_trail | DB | |||
compatible | 11.1.0.0.0 | |||
control_files | C:\ORACLE\ORADATA\PWHD\CONTROLFI | |||
db_block_size | 8192 | |||
db_create_file_dest | C:\oracle\oradata | |||
db_domain | ||||
db_name | PWHD | |||
diagnostic_dest | C:\ORACLE | |||
dispatchers | (PROTOCOL=TCP) (SERVICE=PWHDXDB) | |||
memory_target | 1702887424 | |||
open_cursors | 300 | |||
processes | 150 | |||
remote_login_passwordfile | EXCLUSIVE | |||
undo_tablespace | UNDOTBS1 |