DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
---|---|---|---|---|---|---|
DB11G | 196335337 | DB11G | 1 | 05-Oct-10 12:10 | 11.2.0.2.0 | NO |
Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
---|---|---|---|---|---|
oel5-11gR2-demo.localdomain | Linux x86 64-bit | 1 | 1.96 |
Snap Id | Snap Time | Sessions | Cursors/Session | |
---|---|---|---|---|
Begin Snap: | 70 | 05-Oct-10 16:00:39 | 41 | 4.8 |
End Snap: | 71 | 05-Oct-10 17:00:05 | 40 | 5.1 |
Elapsed: | 59.42 (mins) | |||
DB Time: | 25.37 (mins) |
Begin | End | |||
---|---|---|---|---|
Buffer Cache: | 188M | 188M | Std Block Size: | 8K |
Shared Pool Size: | 288M | 288M | Log Buffer: | 2,328K |
Per Second | Per Transaction | Per Exec | Per Call | |
---|---|---|---|---|
DB Time(s): | 0.4 | 0.0 | 0.01 | 0.06 |
DB CPU(s): | 0.2 | 0.0 | 0.00 | 0.03 |
Redo size: | 20,366.3 | 2,072.8 | ||
Logical reads: | 543.2 | 55.3 | ||
Block changes: | 136.8 | 13.9 | ||
Physical reads: | 22.5 | 2.3 | ||
Physical writes: | 16.3 | 1.7 | ||
User calls: | 7.0 | 0.7 | ||
Parses: | 9.1 | 0.9 | ||
Hard parses: | 0.0 | 0.0 | ||
W/A MB processed: | 1.8 | 0.2 | ||
Logons: | 0.1 | 0.0 | ||
Executes: | 62.0 | 6.3 | ||
Rollbacks: | 0.0 | 0.0 | ||
Transactions: | 9.8 |
Buffer Nowait %: | 100.00 | Redo NoWait %: | 100.00 |
Buffer Hit %: | 95.85 | In-memory Sort %: | 100.00 |
Library Hit %: | 99.99 | Soft Parse %: | 99.94 |
Execute to Parse %: | 85.34 | Latch Hit %: | 99.97 |
Parse CPU to Parse Elapsd %: | 48.26 | % Non-Parse CPU: | 99.68 |
Begin | End | |
---|---|---|
Memory Usage %: | 80.23 | 80.55 |
% SQL with executions>1: | 88.95 | 88.76 |
% Memory for SQL w/exec>1: | 79.35 | 79.70 |
Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
---|---|---|---|---|---|
DB CPU | 819 | 53.81 | |||
log file sync | 11,585 | 139 | 12 | 9.15 | Commit |
db file sequential read | 75,111 | 59 | 1 | 3.85 | User I/O |
latch free | 670 | 10 | 15 | 0.64 | Other |
latch: cache buffers lru chain | 421 | 7 | 17 | 0.46 | Other |
Load Average Begin | Load Average End | %User | %System | %WIO | %Idle |
---|---|---|---|---|---|
2.54 | 0.00 | 22.1 | 4.6 | 0.1 | 72.2 |
%Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) |
---|---|---|
26.9 | 96.9 | 0.0 |
Begin | End | |
---|---|---|
Host Mem (MB): | 2,011.3 | 2,011.3 |
SGA use (MB): | 524.0 | 524.0 |
PGA use (MB): | 127.7 | 127.8 |
% Host Mem used for SGA+PGA: | 32.40 | 32.41 |
Statistic Name | Time (s) | % of DB Time |
---|---|---|
sql execute elapsed time | 1,278.67 | 84.00 |
DB CPU | 819.03 | 53.81 |
PL/SQL execution elapsed time | 446.75 | 29.35 |
parse time elapsed | 5.04 | 0.33 |
repeated bind elapsed time | 0.03 | 0.00 |
sequence load elapsed time | 0.01 | 0.00 |
DB time | 1,522.15 | |
background elapsed time | 419.22 | |
background cpu time | 126.91 |
Statistic | Value | End Value |
---|---|---|
BUSY_TIME | 97,627 | |
IDLE_TIME | 253,770 | |
IOWAIT_TIME | 245 | |
NICE_TIME | 96 | |
SYS_TIME | 16,338 | |
USER_TIME | 77,535 | |
VM_IN_BYTES | 51,990,528 | |
VM_OUT_BYTES | 753,750,016 | |
PHYSICAL_MEMORY_BYTES | 2,109,009,920 | |
NUM_CPUS | 1 | |
GLOBAL_RECEIVE_SIZE_MAX | 4,194,304 | |
GLOBAL_SEND_SIZE_MAX | 1,048,586 | |
TCP_RECEIVE_SIZE_DEFAULT | 87,380 | |
TCP_RECEIVE_SIZE_MAX | 4,194,304 | |
TCP_RECEIVE_SIZE_MIN | 4,096 | |
TCP_SEND_SIZE_DEFAULT | 16,384 | |
TCP_SEND_SIZE_MAX | 4,194,304 | |
TCP_SEND_SIZE_MIN | 4,096 |
Snap Time | Load | %busy | %user | %sys | %idle | %iowait |
---|---|---|---|---|---|---|
05-Oct 16:00:39 | 2.54 | |||||
05-Oct 17:00:05 | 0.00 | 27.78 | 22.06 | 4.65 | 72.22 | 0.07 |
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %DB time |
---|---|---|---|---|---|
DB CPU | 819 | 53.81 | |||
Commit | 11,585 | 0 | 139 | 12 | 9.15 |
User I/O | 75,838 | 0 | 60 | 1 | 3.93 |
Other | 1,978 | 35 | 19 | 10 | 1.26 |
Concurrency | 839 | 0 | 17 | 20 | 1.11 |
Network | 24,252 | 0 | 3 | 0 | 0.20 |
Configuration | 7 | 0 | 0 | 27 | 0.01 |
Application | 10 | 0 | 0 | 17 | 0.01 |
System I/O | 459 | 0 | 0 | 0 | 0.00 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % DB time |
---|---|---|---|---|---|---|
log file sync | 11,585 | 0 | 139 | 12 | 0.33 | 9.15 |
db file sequential read | 75,111 | 0 | 59 | 1 | 2.14 | 3.85 |
latch free | 670 | 0 | 10 | 15 | 0.02 | 0.64 |
latch: cache buffers lru chain | 421 | 0 | 7 | 17 | 0.01 | 0.46 |
library cache: mutex X | 151 | 0 | 6 | 38 | 0.00 | 0.38 |
latch: cache buffers chains | 325 | 0 | 5 | 17 | 0.01 | 0.35 |
SQL*Net message to client | 24,252 | 0 | 3 | 0 | 0.69 | 0.20 |
latch: row cache objects | 200 | 0 | 3 | 15 | 0.01 | 0.20 |
latch: object queue header operation | 94 | 0 | 1 | 12 | 0.00 | 0.07 |
latch: In memory undo latch | 63 | 0 | 1 | 16 | 0.00 | 0.06 |
buffer busy waits | 66 | 0 | 1 | 14 | 0.00 | 0.06 |
latch: redo allocation | 62 | 0 | 1 | 13 | 0.00 | 0.05 |
cursor: pin S | 31 | 0 | 1 | 25 | 0.00 | 0.05 |
db file parallel read | 513 | 0 | 0 | 1 | 0.01 | 0.03 |
read by other session | 21 | 0 | 0 | 20 | 0.00 | 0.03 |
latch: enqueue hash chains | 24 | 0 | 0 | 15 | 0.00 | 0.02 |
Disk file operations I/O | 112 | 0 | 0 | 2 | 0.00 | 0.02 |
latch: redo copy | 7 | 0 | 0 | 27 | 0.00 | 0.01 |
enq: TX - row lock contention | 10 | 0 | 0 | 17 | 0.00 | 0.01 |
db file scattered read | 81 | 0 | 0 | 2 | 0.00 | 0.01 |
latch: session allocation | 8 | 0 | 0 | 16 | 0.00 | 0.01 |
latch: messages | 5 | 0 | 0 | 11 | 0.00 | 0.00 |
latch: shared pool | 2 | 0 | 0 | 16 | 0.00 | 0.00 |
cursor: mutex S | 1 | 0 | 0 | 10 | 0.00 | 0.00 |
control file sequential read | 459 | 0 | 0 | 0 | 0.01 | 0.00 |
asynch descriptor resize | 694 | 100 | 0 | 0 | 0.02 | 0.00 |
PL/SQL lock timer | 141,638 | 100 | 23,548 | 166 | 4.04 | |
jobq slave wait | 7,494 | 100 | 3,845 | 513 | 0.21 | |
SQL*Net message from client | 24,238 | 0 | 3,831 | 158 | 0.69 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
---|---|---|---|---|---|---|
os thread startup | 137 | 0 | 52 | 381 | 0.00 | 12.44 |
log file parallel write | 30,052 | 0 | 44 | 1 | 0.86 | 10.61 |
db file async I/O submit | 16,827 | 0 | 37 | 2 | 0.48 | 8.76 |
control file parallel write | 1,574 | 0 | 3 | 2 | 0.04 | 0.64 |
db file sequential read | 1,064 | 0 | 2 | 2 | 0.03 | 0.43 |
LGWR wait for redo copy | 133 | 0 | 2 | 12 | 0.00 | 0.37 |
control file sequential read | 3,038 | 0 | 1 | 0 | 0.09 | 0.14 |
latch: redo allocation | 46 | 0 | 0 | 8 | 0.00 | 0.09 |
latch: cache buffers lru chain | 26 | 0 | 0 | 13 | 0.00 | 0.08 |
db file scattered read | 123 | 0 | 0 | 1 | 0.00 | 0.04 |
latch free | 12 | 0 | 0 | 11 | 0.00 | 0.03 |
latch: object queue header operation | 8 | 0 | 0 | 10 | 0.00 | 0.02 |
Disk file operations I/O | 70 | 0 | 0 | 1 | 0.00 | 0.02 |
latch: redo writing | 2 | 0 | 0 | 42 | 0.00 | 0.02 |
latch: cache buffers chains | 2 | 0 | 0 | 35 | 0.00 | 0.02 |
reliable message | 5 | 0 | 0 | 11 | 0.00 | 0.01 |
rdbms ipc reply | 7 | 0 | 0 | 7 | 0.00 | 0.01 |
enq: PR - contention | 1 | 0 | 0 | 46 | 0.00 | 0.01 |
latch: messages | 5 | 0 | 0 | 5 | 0.00 | 0.01 |
asynch descriptor resize | 200 | 100 | 0 | 0 | 0.01 | 0.01 |
latch: shared pool | 1 | 0 | 0 | 23 | 0.00 | 0.01 |
direct path sync | 1 | 0 | 0 | 22 | 0.00 | 0.01 |
latch: checkpoint queue latch | 1 | 0 | 0 | 21 | 0.00 | 0.01 |
ADR block file read | 15 | 0 | 0 | 1 | 0.00 | 0.00 |
buffer busy waits | 4 | 0 | 0 | 4 | 0.00 | 0.00 |
latch: enqueue hash chains | 1 | 0 | 0 | 5 | 0.00 | 0.00 |
latch: call allocation | 1 | 0 | 0 | 5 | 0.00 | 0.00 |
latch: In memory undo latch | 4 | 0 | 0 | 1 | 0.00 | 0.00 |
db file single write | 12 | 0 | 0 | 0 | 0.00 | 0.00 |
log file single write | 4 | 0 | 0 | 0 | 0.00 | 0.00 |
ADR block file write | 5 | 0 | 0 | 0 | 0.00 | 0.00 |
direct path write | 2 | 0 | 0 | 1 | 0.00 | 0.00 |
rdbms ipc message | 46,816 | 36 | 42,412 | 906 | 1.34 | |
Streams AQ: waiting for time management or cleanup tasks | 5 | 60 | 7,540 | 1508009 | 0.00 | |
DIAG idle wait | 6,967 | 100 | 7,120 | 1022 | 0.20 | |
Space Manager: slave idle wait | 1,401 | 94 | 6,743 | 4813 | 0.04 | |
dispatcher timer | 60 | 100 | 3,601 | 60011 | 0.00 | |
shared server idle wait | 119 | 100 | 3,572 | 30019 | 0.00 | |
smon timer | 28 | 21 | 3,563 | 127242 | 0.00 | |
pmon timer | 1,184 | 100 | 3,559 | 3005 | 0.03 | |
Streams AQ: qmn coordinator idle wait | 254 | 50 | 3,558 | 14010 | 0.01 | |
Streams AQ: qmn slave idle wait | 130 | 0 | 3,558 | 27371 | 0.00 | |
class slave wait | 19 | 0 | 0 | 0 | 0.00 |
% of Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Total Waits | <1ms | <2ms | <4ms | <8ms | <16ms | <32ms | <=1s | >1s |
ADR block file read | 15 | 86.7 | 6.7 | 6.7 | |||||
ADR block file write | 5 | 100.0 | |||||||
ADR file lock | 6 | 100.0 | |||||||
Disk file operations I/O | 182 | 84.6 | 12.1 | .5 | .5 | .5 | .5 | 1.1 | |
LGWR wait for redo copy | 131 | 8.4 | 5.3 | 19.1 | 15.3 | 30.5 | 18.3 | 3.1 | |
SQL*Net message to client | 24.2K | 99.3 | .1 | .1 | .2 | .3 | .0 | .0 | |
asynch descriptor resize | 901 | 99.9 | .1 | ||||||
buffer busy waits | 70 | 5.7 | 7.1 | 11.4 | 18.6 | 31.4 | 15.7 | 10.0 | |
control file parallel write | 1574 | 34.5 | 51.3 | 11.1 | .8 | 1.7 | .5 | .1 | |
control file sequential read | 3506 | 98.3 | 1.5 | .0 | .1 | .1 | .1 | ||
cursor: mutex S | 1 | 100.0 | |||||||
cursor: pin S | 31 | 12.9 | 3.2 | 12.9 | 12.9 | 25.8 | 16.1 | 16.1 | |
db file async I/O submit | 16.8K | 90.1 | 2.5 | .6 | 1.2 | 1.8 | 2.1 | 1.7 | |
db file parallel read | 513 | 93.4 | 2.9 | .2 | 1.8 | .6 | 1.2 | ||
db file scattered read | 204 | 87.7 | 7.8 | 1.5 | .5 | 1.5 | 1.0 | ||
db file sequential read | 76.2K | 92.2 | 4.5 | .7 | .6 | 1.2 | .6 | .2 | |
db file single write | 12 | 100.0 | |||||||
direct path sync | 1 | 100.0 | |||||||
direct path write | 2 | 100.0 | |||||||
enq: PR - contention | 1 | 100.0 | |||||||
enq: TX - row lock contention | 10 | 30.0 | 10.0 | 60.0 | |||||
latch free | 682 | 4.1 | 1.0 | 6.2 | 24.5 | 31.4 | 26.2 | 6.6 | |
latch: In memory undo latch | 67 | 11.9 | 3.0 | 10.4 | 7.5 | 23.9 | 37.3 | 6.0 | |
latch: cache buffers chains | 326 | 2.1 | 5.5 | 8.3 | 16.0 | 29.1 | 28.2 | 10.7 | |
latch: cache buffers lru chain | 444 | 3.2 | 5.6 | 11.5 | 15.8 | 28.4 | 24.5 | 11.0 | |
latch: call allocation | 1 | 100.0 | |||||||
latch: checkpoint queue latch | 1 | 100.0 | |||||||
latch: enqueue hash chains | 25 | 8.0 | 28.0 | 48.0 | 8.0 | 8.0 | |||
latch: messages | 10 | 10.0 | 20.0 | 30.0 | 30.0 | 10.0 | |||
latch: object queue header operation | 102 | 8.8 | 3.9 | 19.6 | 23.5 | 17.6 | 18.6 | 7.8 | |
latch: redo allocation | 108 | 4.6 | 12.0 | 14.8 | 15.7 | 32.4 | 16.7 | 3.7 | |
latch: redo copy | 7 | 28.6 | 14.3 | 28.6 | 28.6 | ||||
latch: redo writing | 2 | 50.0 | 50.0 | ||||||
latch: row cache objects | 200 | 1.0 | 1.0 | 10.5 | 26.0 | 30.0 | 23.0 | 8.5 | |
latch: session allocation | 7 | 14.3 | 14.3 | 14.3 | 42.9 | 14.3 | |||
latch: shared pool | 3 | 33.3 | 66.7 | ||||||
library cache: mutex X | 149 | 6.0 | 2.0 | 12.8 | 12.1 | 14.1 | 22.1 | 30.9 | |
log file parallel write | 30K | 48.0 | 37.8 | 11.1 | 1.0 | 1.6 | .4 | .0 | |
log file sequential read | 4 | 100.0 | |||||||
log file single write | 4 | 100.0 | |||||||
log file sync | 11.6K | 12.2 | 5.3 | 10.2 | 14.3 | 32.2 | 21.1 | 4.8 | |
os thread startup | 137 | 98.5 | 1.5 | ||||||
rdbms ipc reply | 7 | 42.9 | 14.3 | 14.3 | 28.6 | ||||
read by other session | 21 | 4.8 | 9.5 | 4.8 | 9.5 | 42.9 | 9.5 | 19.0 | |
reliable message | 5 | 20.0 | 20.0 | 20.0 | 40.0 | ||||
DIAG idle wait | 6967 | 90.7 | 9.3 | ||||||
PL/SQL lock timer | 141.5K | 100.0 | |||||||
SQL*Net message from client | 24.2K | 100.0 | |||||||
Space Manager: slave idle wait | 1399 | 1.2 | .1 | .2 | 1.3 | 97.1 | |||
Streams AQ: qmn coordinator idle wait | 254 | 14.6 | 18.5 | 4.3 | 2.8 | 7.1 | 2.8 | 50.0 | |
Streams AQ: qmn slave idle wait | 130 | 2.3 | 97.7 | ||||||
Streams AQ: waiting for time management or cleanup tasks | 5 | 40.0 | 20.0 | 40.0 | |||||
class slave wait | 19 | 100.0 | |||||||
dispatcher timer | 60 | 100.0 | |||||||
jobq slave wait | 7490 | 100.0 | |||||||
pmon timer | 1185 | 100.0 | |||||||
rdbms ipc message | 46.8K | 1.3 | .3 | .7 | 3.1 | 7.5 | 12.9 | 53.8 | 20.4 |
shared server idle wait | 119 | 100.0 | |||||||
smon timer | 28 | 7.1 | 17.9 | 75.0 |
% of Total Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Waits 64ms to 2s | <32ms | <64ms | <1/8s | <1/4s | <1/2s | <1s | <2s | >=2s |
Disk file operations I/O | 2 | 98.9 | .5 | .5 | |||||
LGWR wait for redo copy | 4 | 96.9 | 3.1 | ||||||
SQL*Net message to client | 3 | 100.0 | .0 | .0 | |||||
buffer busy waits | 7 | 90.0 | 8.6 | 1.4 | |||||
control file parallel write | 2 | 99.9 | .1 | .1 | |||||
cursor: pin S | 5 | 83.9 | 12.9 | 3.2 | |||||
db file async I/O submit | 291 | 98.3 | 1.2 | .5 | .0 | .0 | |||
db file scattered read | 2 | 99.0 | .5 | .5 | |||||
db file sequential read | 190 | 99.8 | .2 | .1 | .0 | ||||
enq: PR - contention | 1 | 100.0 | |||||||
latch free | 45 | 93.4 | 5.7 | .9 | |||||
latch: In memory undo latch | 4 | 94.0 | 6.0 | ||||||
latch: cache buffers chains | 35 | 89.3 | 9.5 | 1.2 | |||||
latch: cache buffers lru chain | 49 | 89.0 | 9.0 | 1.6 | .5 | ||||
latch: enqueue hash chains | 2 | 92.0 | 8.0 | ||||||
latch: object queue header operation | 8 | 92.2 | 7.8 | ||||||
latch: redo allocation | 4 | 96.3 | 3.7 | ||||||
latch: redo copy | 2 | 71.4 | 14.3 | 14.3 | |||||
latch: redo writing | 1 | 50.0 | 50.0 | ||||||
latch: row cache objects | 17 | 91.5 | 7.5 | 1.0 | |||||
latch: session allocation | 1 | 85.7 | 14.3 | ||||||
library cache: mutex X | 46 | 69.1 | 22.1 | 6.0 | .7 | .7 | 1.3 | ||
log file parallel write | 10 | 100.0 | .0 | .0 | |||||
log file sync | 553 | 95.2 | 4.6 | .2 | .0 | ||||
os thread startup | 137 | 2.2 | 35.0 | 43.1 | 18.2 | 1.5 | |||
read by other session | 4 | 81.0 | 9.5 | 9.5 |
Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) |
---|---|---|---|---|
DB11G.WORLD | 1,451 | 779 | 76 | 1,873 |
SYS$USERS | 72 | 40 | 2 | 47 |
DB11GXDB | 0 | 0 | 0 | 0 |
SYS$BACKGROUND | 0 | 0 | 3 | 17 |
Service Name | User I/O Total Wts | User I/O Wt Time | Concurcy Total Wts | Concurcy Wt Time | Admin Total Wts | Admin Wt Time | Network Total Wts | Network Wt Time |
---|---|---|---|---|---|---|---|---|
DB11G.WORLD | 74618 | 59 | 837 | 17 | 0 | 0 | 24252 | 3 |
SYS$USERS | 1197 | 1 | 2 | 0 | 0 | 0 | 0 | 0 |
SYS$BACKGROUND | 1268 | 2 | 147 | 52 | 0 | 0 | 0 | 0 |
Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
754.75 | 7,094 | 0.11 | 49.58 | 56.11 | 4.32 | 0w2qpuc6u2zsp | JDBC Thin Client | BEGIN :1 := orderentry.neworde... |
310.42 | 8,494 | 0.04 | 20.39 | 52.68 | 1.99 | 147a57cxq3w5y | JDBC Thin Client | BEGIN :1 := orderentry.browsep... |
169.27 | 21,305 | 0.01 | 11.12 | 57.68 | 4.03 | c13sma6rkr27c | New Order | SELECT PRODUCTS.PRODUCT_ID, PR... |
90.06 | 4,264 | 0.02 | 5.92 | 57.09 | 7.98 | 5yq51dtyc6qf2 | JDBC Thin Client | BEGIN :1 := orderentry.process... |
74.47 | 19,127 | 0.00 | 4.89 | 52.90 | 17.47 | 0yas01u2p9ch4 | New Order | INSERT INTO ORDER_ITEMS(ORDER_... |
58.86 | 25,388 | 0.00 | 3.87 | 44.10 | 0.08 | 0y1prvxqc2ra9 | Browse Products | SELECT PRODUCTS.PRODUCT_ID, PR... |
49.77 | 19,925 | 0.00 | 3.27 | 61.36 | 24.55 | 8dq0v1mjngj7t | Browse and Update Orders | SELECT CUSTOMER_ID, CUST_FIRST... |
46.60 | 7,087 | 0.01 | 3.06 | 46.39 | 14.04 | gvgdv2v90wfa7 | New Order | INSERT INTO ORDERS(ORDER_ID, O... |
44.20 | 1,438 | 0.03 | 2.90 | 53.09 | 22.81 | apgb2g9q2zjh1 | JDBC Thin Client | BEGIN :1 := orderentry.browsea... |
43.85 | 2,914 | 0.02 | 2.88 | 62.21 | 5.85 | dcq9a12vtcnuw | JDBC Thin Client | BEGIN :1 := orderentry.newcust... |
35.38 | 21,055 | 0.00 | 2.32 | 45.45 | 3.30 | 8z3542ffmp562 | New Order | SELECT QUANTITY_ON_HAND FROM P... |
30.85 | 7,094 | 0.00 | 2.03 | 44.82 | 0.05 | 5mddt5kt45rg3 | New Order | UPDATE ORDERS SET ORDER_MODE =... |
26.37 | 4,264 | 0.01 | 1.73 | 52.43 | 27.07 | 5cnawuttguyja | Process Orders | WITH NEED_TO_PROCESS AS (SELEC... |
24.42 | 19,925 | 0.00 | 1.60 | 45.08 | 0.09 | 5raw2bzx227wp | New Order | INSERT INTO LOGON VALUES (:B2 ... |
21.78 | 58 | 0.38 | 1.43 | 53.99 | 3.50 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
21.25 | 4,264 | 0.00 | 1.40 | 45.40 | 0.24 | f9u2k84v884y7 | Process Orders | UPDATE /*+ index(orders, order... |
17.44 | 2,914 | 0.01 | 1.15 | 58.88 | 14.68 | 0bzhqhhj9mpaa | New Customer | INSERT INTO CUSTOMERS(CUSTOMER... |
CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
423.50 | 7,094 | 0.06 | 51.71 | 754.75 | 56.11 | 4.32 | 0w2qpuc6u2zsp | JDBC Thin Client | BEGIN :1 := orderentry.neworde... |
163.53 | 8,494 | 0.02 | 19.97 | 310.42 | 52.68 | 1.99 | 147a57cxq3w5y | JDBC Thin Client | BEGIN :1 := orderentry.browsep... |
97.63 | 21,305 | 0.00 | 11.92 | 169.27 | 57.68 | 4.03 | c13sma6rkr27c | New Order | SELECT PRODUCTS.PRODUCT_ID, PR... |
51.41 | 4,264 | 0.01 | 6.28 | 90.06 | 57.09 | 7.98 | 5yq51dtyc6qf2 | JDBC Thin Client | BEGIN :1 := orderentry.process... |
39.39 | 19,127 | 0.00 | 4.81 | 74.47 | 52.90 | 17.47 | 0yas01u2p9ch4 | New Order | INSERT INTO ORDER_ITEMS(ORDER_... |
30.54 | 19,925 | 0.00 | 3.73 | 49.77 | 61.36 | 24.55 | 8dq0v1mjngj7t | Browse and Update Orders | SELECT CUSTOMER_ID, CUST_FIRST... |
27.28 | 2,914 | 0.01 | 3.33 | 43.85 | 62.21 | 5.85 | dcq9a12vtcnuw | JDBC Thin Client | BEGIN :1 := orderentry.newcust... |
25.96 | 25,388 | 0.00 | 3.17 | 58.86 | 44.10 | 0.08 | 0y1prvxqc2ra9 | Browse Products | SELECT PRODUCTS.PRODUCT_ID, PR... |
23.47 | 1,438 | 0.02 | 2.87 | 44.20 | 53.09 | 22.81 | apgb2g9q2zjh1 | JDBC Thin Client | BEGIN :1 := orderentry.browsea... |
21.62 | 7,087 | 0.00 | 2.64 | 46.60 | 46.39 | 14.04 | gvgdv2v90wfa7 | New Order | INSERT INTO ORDERS(ORDER_ID, O... |
16.08 | 21,055 | 0.00 | 1.96 | 35.38 | 45.45 | 3.30 | 8z3542ffmp562 | New Order | SELECT QUANTITY_ON_HAND FROM P... |
13.83 | 4,264 | 0.00 | 1.69 | 26.37 | 52.43 | 27.07 | 5cnawuttguyja | Process Orders | WITH NEED_TO_PROCESS AS (SELEC... |
13.83 | 7,094 | 0.00 | 1.69 | 30.85 | 44.82 | 0.05 | 5mddt5kt45rg3 | New Order | UPDATE ORDERS SET ORDER_MODE =... |
11.76 | 58 | 0.20 | 1.44 | 21.78 | 53.99 | 3.50 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
11.01 | 19,925 | 0.00 | 1.34 | 24.42 | 45.08 | 0.09 | 5raw2bzx227wp | New Order | INSERT INTO LOGON VALUES (:B2 ... |
10.27 | 2,914 | 0.00 | 1.25 | 17.44 | 58.88 | 14.68 | 0bzhqhhj9mpaa | New Customer | INSERT INTO CUSTOMERS(CUSTOMER... |
9.65 | 4,264 | 0.00 | 1.18 | 21.25 | 45.40 | 0.24 | f9u2k84v884y7 | Process Orders | UPDATE /*+ index(orders, order... |
User I/O Time (s) | Executions | UIO per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
32.63 | 7,094 | 0.00 | 52.71 | 754.75 | 56.11 | 4.32 | 0w2qpuc6u2zsp | JDBC Thin Client | BEGIN :1 := orderentry.neworde... |
13.01 | 19,127 | 0.00 | 21.01 | 74.47 | 52.90 | 17.47 | 0yas01u2p9ch4 | New Order | INSERT INTO ORDER_ITEMS(ORDER_... |
12.22 | 19,925 | 0.00 | 19.74 | 49.77 | 61.36 | 24.55 | 8dq0v1mjngj7t | Browse and Update Orders | SELECT CUSTOMER_ID, CUST_FIRST... |
10.08 | 1,438 | 0.01 | 16.29 | 44.20 | 53.09 | 22.81 | apgb2g9q2zjh1 | JDBC Thin Client | BEGIN :1 := orderentry.browsea... |
7.19 | 4,264 | 0.00 | 11.61 | 90.06 | 57.09 | 7.98 | 5yq51dtyc6qf2 | JDBC Thin Client | BEGIN :1 := orderentry.process... |
7.14 | 4,264 | 0.00 | 11.53 | 26.37 | 52.43 | 27.07 | 5cnawuttguyja | Process Orders | WITH NEED_TO_PROCESS AS (SELEC... |
6.81 | 21,305 | 0.00 | 11.01 | 169.27 | 57.68 | 4.03 | c13sma6rkr27c | New Order | SELECT PRODUCTS.PRODUCT_ID, PR... |
6.54 | 7,087 | 0.00 | 10.57 | 46.60 | 46.39 | 14.04 | gvgdv2v90wfa7 | New Order | INSERT INTO ORDERS(ORDER_ID, O... |
6.17 | 8,494 | 0.00 | 9.97 | 310.42 | 52.68 | 1.99 | 147a57cxq3w5y | JDBC Thin Client | BEGIN :1 := orderentry.browsep... |
4.94 | 1,438 | 0.00 | 7.98 | 9.19 | 39.73 | 53.75 | 0ruh367af7gbw | Browse and Update Orders | SELECT ORDER_ID, ORDER_MODE, C... |
2.67 | 427 | 0.01 | 4.31 | 3.21 | 38.97 | 83.12 | 4tx09gq85z630 | Browse and Update Orders | SELECT ORDER_ID, LINE_ITEM_ID,... |
2.56 | 2,914 | 0.00 | 4.14 | 43.85 | 62.21 | 5.85 | dcq9a12vtcnuw | JDBC Thin Client | BEGIN :1 := orderentry.newcust... |
2.56 | 2,914 | 0.00 | 4.14 | 17.44 | 58.88 | 14.68 | 0bzhqhhj9mpaa | New Customer | INSERT INTO CUSTOMERS(CUSTOMER... |
1.17 | 21,055 | 0.00 | 1.88 | 35.38 | 45.45 | 3.30 | 8z3542ffmp562 | New Order | SELECT QUANTITY_ON_HAND FROM P... |
0.79 | 427 | 0.00 | 1.28 | 1.18 | 52.58 | 67.12 | 3hatpjzrqvfn7 | Browse and Update Orders | UPDATE ORDERS SET ORDER_TOTAL ... |
0.76 | 58 | 0.01 | 1.23 | 21.78 | 53.99 | 3.50 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... |
Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
1,321,946 | 7,094 | 186.35 | 68.26 | 754.75 | 56.11 | 4.32 | 0w2qpuc6u2zsp | JDBC Thin Client | BEGIN :1 := orderentry.neworde... |
599,785 | 21,305 | 28.15 | 30.97 | 169.27 | 57.68 | 4.03 | c13sma6rkr27c | New Order | SELECT PRODUCTS.PRODUCT_ID, PR... |
298,948 | 8,494 | 35.20 | 15.44 | 310.42 | 52.68 | 1.99 | 147a57cxq3w5y | JDBC Thin Client | BEGIN :1 := orderentry.browsep... |
293,800 | 19,127 | 15.36 | 15.17 | 74.47 | 52.90 | 17.47 | 0yas01u2p9ch4 | New Order | INSERT INTO ORDER_ITEMS(ORDER_... |
230,651 | 25,388 | 9.09 | 11.91 | 58.86 | 44.10 | 0.08 | 0y1prvxqc2ra9 | Browse Products | SELECT PRODUCTS.PRODUCT_ID, PR... |
143,033 | 4,264 | 33.54 | 7.39 | 90.06 | 57.09 | 7.98 | 5yq51dtyc6qf2 | JDBC Thin Client | BEGIN :1 := orderentry.process... |
120,546 | 21,055 | 5.73 | 6.22 | 35.38 | 45.45 | 3.30 | 8z3542ffmp562 | New Order | SELECT QUANTITY_ON_HAND FROM P... |
108,478 | 7,087 | 15.31 | 5.60 | 46.60 | 46.39 | 14.04 | gvgdv2v90wfa7 | New Order | INSERT INTO ORDERS(ORDER_ID, O... |
81,774 | 4,264 | 19.18 | 4.22 | 26.37 | 52.43 | 27.07 | 5cnawuttguyja | Process Orders | WITH NEED_TO_PROCESS AS (SELEC... |
81,269 | 2,914 | 27.89 | 4.20 | 43.85 | 62.21 | 5.85 | dcq9a12vtcnuw | JDBC Thin Client | BEGIN :1 := orderentry.newcust... |
79,700 | 19,925 | 4.00 | 4.12 | 49.77 | 61.36 | 24.55 | 8dq0v1mjngj7t | Browse and Update Orders | SELECT CUSTOMER_ID, CUST_FIRST... |
76,922 | 6,817 | 11.28 | 3.97 | 9.47 | 53.23 | 0.43 | 7r7636982atn9 | New Order | UPDATE INVENTORIES SET QUANTIT... |
60,414 | 19,925 | 3.03 | 3.12 | 24.42 | 45.08 | 0.09 | 5raw2bzx227wp | New Order | INSERT INTO LOGON VALUES (:B2 ... |
57,593 | 7,094 | 8.12 | 2.97 | 30.85 | 44.82 | 0.05 | 5mddt5kt45rg3 | New Order | UPDATE ORDERS SET ORDER_MODE =... |
56,995 | 4,264 | 13.37 | 2.94 | 21.25 | 45.40 | 0.24 | f9u2k84v884y7 | Process Orders | UPDATE /*+ index(orders, order... |
54,970 | 2,914 | 18.86 | 2.84 | 17.44 | 58.88 | 14.68 | 0bzhqhhj9mpaa | New Customer | INSERT INTO CUSTOMERS(CUSTOMER... |
27,624 | 58 | 476.28 | 1.43 | 21.78 | 53.99 | 3.50 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
23,926 | 1,438 | 16.64 | 1.24 | 44.20 | 53.09 | 22.81 | apgb2g9q2zjh1 | JDBC Thin Client | BEGIN :1 := orderentry.browsea... |
Physical Reads | Executions | Reads per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
48,097 | 7,094 | 6.78 | 59.84 | 754.75 | 56.11 | 4.32 | 0w2qpuc6u2zsp | JDBC Thin Client | BEGIN :1 := orderentry.neworde... |
27,669 | 19,925 | 1.39 | 34.42 | 49.77 | 61.36 | 24.55 | 8dq0v1mjngj7t | Browse and Update Orders | SELECT CUSTOMER_ID, CUST_FIRST... |
15,084 | 19,127 | 0.79 | 18.77 | 74.47 | 52.90 | 17.47 | 0yas01u2p9ch4 | New Order | INSERT INTO ORDER_ITEMS(ORDER_... |
13,896 | 8,494 | 1.64 | 17.29 | 310.42 | 52.68 | 1.99 | 147a57cxq3w5y | JDBC Thin Client | BEGIN :1 := orderentry.browsep... |
11,675 | 21,305 | 0.55 | 14.53 | 169.27 | 57.68 | 4.03 | c13sma6rkr27c | New Order | SELECT PRODUCTS.PRODUCT_ID, PR... |
7,725 | 7,087 | 1.09 | 9.61 | 46.60 | 46.39 | 14.04 | gvgdv2v90wfa7 | New Order | INSERT INTO ORDERS(ORDER_ID, O... |
6,995 | 1,438 | 4.86 | 8.70 | 44.20 | 53.09 | 22.81 | apgb2g9q2zjh1 | JDBC Thin Client | BEGIN :1 := orderentry.browsea... |
3,856 | 4,264 | 0.90 | 4.80 | 90.06 | 57.09 | 7.98 | 5yq51dtyc6qf2 | JDBC Thin Client | BEGIN :1 := orderentry.process... |
3,809 | 4,264 | 0.89 | 4.74 | 26.37 | 52.43 | 27.07 | 5cnawuttguyja | Process Orders | WITH NEED_TO_PROCESS AS (SELEC... |
2,977 | 1,438 | 2.07 | 3.70 | 9.19 | 39.73 | 53.75 | 0ruh367af7gbw | Browse and Update Orders | SELECT ORDER_ID, ORDER_MODE, C... |
2,551 | 2,914 | 0.88 | 3.17 | 43.85 | 62.21 | 5.85 | dcq9a12vtcnuw | JDBC Thin Client | BEGIN :1 := orderentry.newcust... |
2,539 | 2,914 | 0.87 | 3.16 | 17.44 | 58.88 | 14.68 | 0bzhqhhj9mpaa | New Customer | INSERT INTO CUSTOMERS(CUSTOMER... |
1,943 | 21,055 | 0.09 | 2.42 | 35.38 | 45.45 | 3.30 | 8z3542ffmp562 | New Order | SELECT QUANTITY_ON_HAND FROM P... |
1,542 | 2 | 771.00 | 1.92 | 0.85 | 38.95 | 14.39 | ab3swhv5g138y | select OBJOID, CLSOID, RUNTIME... | |
1,496 | 58 | 25.79 | 1.86 | 21.78 | 53.99 | 3.50 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
1,009 | 57 | 17.70 | 1.26 | 2.25 | 55.20 | 11.25 | 3am9cfkvx7gq1 | CALL MGMT_ADMIN_DATA.EVALUATE_... | |
858 | 427 | 2.01 | 1.07 | 3.21 | 38.97 | 83.12 | 4tx09gq85z630 | Browse and Update Orders | SELECT ORDER_ID, LINE_ITEM_ID,... |
UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
48,097 | 48,097 | 7,094 | 6.78 | 0.00 | 61.77 | 0w2qpuc6u2zsp | JDBC Thin Client | BEGIN :1 := orderentry.neworde... |
27,669 | 27,669 | 19,925 | 1.39 | 0.00 | 35.54 | 8dq0v1mjngj7t | Browse and Update Orders | SELECT CUSTOMER_ID, CUST_FIRST... |
15,084 | 15,084 | 19,127 | 0.79 | 0.00 | 19.37 | 0yas01u2p9ch4 | New Order | INSERT INTO ORDER_ITEMS(ORDER_... |
13,896 | 13,896 | 8,494 | 1.64 | 0.00 | 17.85 | 147a57cxq3w5y | JDBC Thin Client | BEGIN :1 := orderentry.browsep... |
11,675 | 11,675 | 21,305 | 0.55 | 0.00 | 14.99 | c13sma6rkr27c | New Order | SELECT PRODUCTS.PRODUCT_ID, PR... |
7,725 | 7,725 | 7,087 | 1.09 | 0.00 | 9.92 | gvgdv2v90wfa7 | New Order | INSERT INTO ORDERS(ORDER_ID, O... |
6,995 | 6,995 | 1,438 | 4.86 | 0.00 | 8.98 | apgb2g9q2zjh1 | JDBC Thin Client | BEGIN :1 := orderentry.browsea... |
3,856 | 3,856 | 4,264 | 0.90 | 0.00 | 4.95 | 5yq51dtyc6qf2 | JDBC Thin Client | BEGIN :1 := orderentry.process... |
3,809 | 3,809 | 4,264 | 0.89 | 0.00 | 4.89 | 5cnawuttguyja | Process Orders | WITH NEED_TO_PROCESS AS (SELEC... |
2,977 | 2,977 | 1,438 | 2.07 | 0.00 | 3.82 | 0ruh367af7gbw | Browse and Update Orders | SELECT ORDER_ID, ORDER_MODE, C... |
2,551 | 2,551 | 2,914 | 0.88 | 0.00 | 3.28 | dcq9a12vtcnuw | JDBC Thin Client | BEGIN :1 := orderentry.newcust... |
2,539 | 2,539 | 2,914 | 0.87 | 0.00 | 3.26 | 0bzhqhhj9mpaa | New Customer | INSERT INTO CUSTOMERS(CUSTOMER... |
1,943 | 1,943 | 21,055 | 0.09 | 0.00 | 2.50 | 8z3542ffmp562 | New Order | SELECT QUANTITY_ON_HAND FROM P... |
908 | 908 | 58 | 15.66 | 0.00 | 1.17 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
858 | 858 | 427 | 2.01 | 0.00 | 1.10 | 4tx09gq85z630 | Browse and Update Orders | SELECT ORDER_ID, LINE_ITEM_ID,... |
Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
25,388 | 355,432 | 14.00 | 58.86 | 44.10 | 0.08 | 0y1prvxqc2ra9 | Browse Products | SELECT PRODUCTS.PRODUCT_ID, PR... |
21,305 | 96,382 | 4.52 | 169.27 | 57.68 | 4.03 | c13sma6rkr27c | New Order | SELECT PRODUCTS.PRODUCT_ID, PR... |
21,055 | 19,127 | 0.91 | 35.38 | 45.45 | 3.30 | 8z3542ffmp562 | New Order | SELECT QUANTITY_ON_HAND FROM P... |
19,925 | 19,925 | 1.00 | 24.42 | 45.08 | 0.09 | 5raw2bzx227wp | New Order | INSERT INTO LOGON VALUES (:B2 ... |
19,925 | 19,925 | 1.00 | 49.77 | 61.36 | 24.55 | 8dq0v1mjngj7t | Browse and Update Orders | SELECT CUSTOMER_ID, CUST_FIRST... |
19,925 | 19,925 | 1.00 | 11.90 | 48.38 | 0.00 | c749bc43qqfz3 | New Order | SELECT SYSDATE FROM DUAL |
19,127 | 19,127 | 1.00 | 74.47 | 52.90 | 17.47 | 0yas01u2p9ch4 | New Order | INSERT INTO ORDER_ITEMS(ORDER_... |
8,494 | 8,494 | 1.00 | 310.42 | 52.68 | 1.99 | 147a57cxq3w5y | JDBC Thin Client | BEGIN :1 := orderentry.browsep... |
7,094 | 7,094 | 1.00 | 754.75 | 56.11 | 4.32 | 0w2qpuc6u2zsp | JDBC Thin Client | BEGIN :1 := orderentry.neworde... |
7,094 | 7,094 | 1.00 | 30.85 | 44.82 | 0.05 | 5mddt5kt45rg3 | New Order | UPDATE ORDERS SET ORDER_MODE =... |
7,087 | 7,087 | 1.00 | 46.60 | 46.39 | 14.04 | gvgdv2v90wfa7 | New Order | INSERT INTO ORDERS(ORDER_ID, O... |
6,817 | 19,141 | 2.81 | 9.47 | 53.23 | 0.43 | 7r7636982atn9 | New Order | UPDATE INVENTORIES SET QUANTIT... |
4,264 | 4,264 | 1.00 | 26.37 | 52.43 | 27.07 | 5cnawuttguyja | Process Orders | WITH NEED_TO_PROCESS AS (SELEC... |
4,264 | 4,264 | 1.00 | 90.06 | 57.09 | 7.98 | 5yq51dtyc6qf2 | JDBC Thin Client | BEGIN :1 := orderentry.process... |
4,264 | 4,264 | 1.00 | 21.25 | 45.40 | 0.24 | f9u2k84v884y7 | Process Orders | UPDATE /*+ index(orders, order... |
3,329 | 4,737 | 1.42 | 1.04 | 29.87 | 0.00 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
2,914 | 2,914 | 1.00 | 17.44 | 58.88 | 14.68 | 0bzhqhhj9mpaa | New Customer | INSERT INTO CUSTOMERS(CUSTOMER... |
2,914 | 2,914 | 1.00 | 1.07 | 67.42 | 0.00 | 4z3ktqk9zq1j9 | New Customer | SELECT CUSTOMER_SEQ.NEXTVAL FR... |
2,914 | 2,914 | 1.00 | 43.85 | 62.21 | 5.85 | dcq9a12vtcnuw | JDBC Thin Client | BEGIN :1 := orderentry.newcust... |
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
3,329 | 3,329 | 10.28 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
201 | 201 | 0.62 | 350f5yrnnmshs | lock table sys.mon_mods$ in ex... | |
201 | 201 | 0.62 | g00cj285jmgsw | update sys.mon_mods$ set inser... | |
167 | 167 | 0.52 | 08bqjmf8490s2 | SEVERITY EVALUATION | SELECT PARAMETER_VALUE FROM MG... |
126 | 126 | 0.39 | fsbqktj5vw6n9 | select next_run_date, obj#, ru... | |
124 | 371 | 0.38 | 089dbukv1aanh | EM_PING | SELECT SYS_EXTRACT_UTC(SYSTIME... |
94 | 94 | 0.29 | 3m8smr0v7v1m6 | INSERT INTO sys.wri$_adv_messa... | |
92 | 92 | 0.28 | 49s332uhbnsma | declare vsn varchar2(20); beg... | |
88 | 88 | 0.27 | f80h0xb1qvbsk | SELECT sys.wri$_adv_seq_msggro... | |
81 | 81 | 0.25 | 3s58mgk0uy2ws | insert into wrm$_snapshot_deta... |
Statistic | Total | per Second | per Trans |
---|---|---|---|
Batched IO (bound) vector count | 0 | 0.00 | 0.00 |
Batched IO (full) vector count | 0 | 0.00 | 0.00 |
Batched IO block miss count | 2,002 | 0.56 | 0.06 |
Batched IO buffer defrag count | 0 | 0.00 | 0.00 |
Batched IO double miss count | 1,066 | 0.30 | 0.03 |
Batched IO same unit count | 0 | 0.00 | 0.00 |
Batched IO single block count | 553 | 0.16 | 0.02 |
Batched IO vector block count | 1,449 | 0.41 | 0.04 |
Batched IO vector read count | 513 | 0.14 | 0.01 |
Block Cleanout Optim referenced | 83 | 0.02 | 0.00 |
CCursor + sql area evicted | 0 | 0.00 | 0.00 |
CPU used by this session | 75,410 | 21.15 | 2.15 |
CPU used when call started | 72,610 | 20.37 | 2.07 |
CR blocks created | 4,734 | 1.33 | 0.14 |
Cached Commit SCN referenced | 180 | 0.05 | 0.01 |
Commit SCN cached | 391 | 0.11 | 0.01 |
DB time | 2,892,552 | 811.31 | 82.57 |
DBWR checkpoint buffers written | 23,798 | 6.67 | 0.68 |
DBWR checkpoints | 2 | 0.00 | 0.00 |
DBWR parallel query checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR thread checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR transaction table writes | 146 | 0.04 | 0.00 |
DBWR undo block writes | 3,652 | 1.02 | 0.10 |
DDL statements parallelized | 0 | 0.00 | 0.00 |
DFO trees parallelized | 0 | 0.00 | 0.00 |
HSC Heap Segment Block Changes | 86,824 | 24.35 | 2.48 |
Heap Segment Array Inserts | 175 | 0.05 | 0.00 |
Heap Segment Array Updates | 110 | 0.03 | 0.00 |
IMU CR rollbacks | 401 | 0.11 | 0.01 |
IMU Flushes | 8,498 | 2.38 | 0.24 |
IMU Redo allocation size | 21,159,924 | 5,935.01 | 604.05 |
IMU commits | 26,530 | 7.44 | 0.76 |
IMU contention | 6,823 | 1.91 | 0.19 |
IMU ktichg flush | 1 | 0.00 | 0.00 |
IMU pool not allocated | 110 | 0.03 | 0.00 |
IMU undo allocation size | 48,311,696 | 13,550.63 | 1,379.15 |
IMU- failed to get a private strand | 110 | 0.03 | 0.00 |
Number of read IOs issued | 0 | 0.00 | 0.00 |
PX local messages recv'd | 0 | 0.00 | 0.00 |
PX local messages sent | 0 | 0.00 | 0.00 |
Parallel operations not downgraded | 0 | 0.00 | 0.00 |
RowCR - row contention | 437 | 0.12 | 0.01 |
RowCR attempts | 12,044 | 3.38 | 0.34 |
RowCR hits | 11,591 | 3.25 | 0.33 |
SMON posted for undo segment shrink | 5 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 24,245 | 6.80 | 0.69 |
TBS Extension: bytes extended | 0 | 0.00 | 0.00 |
TBS Extension: files extended | 0 | 0.00 | 0.00 |
TBS Extension: tasks created | 6 | 0.00 | 0.00 |
TBS Extension: tasks executed | 6 | 0.00 | 0.00 |
active txn count during cleanout | 6,329 | 1.78 | 0.18 |
application wait time | 16 | 0.00 | 0.00 |
background checkpoints completed | 2 | 0.00 | 0.00 |
background checkpoints started | 2 | 0.00 | 0.00 |
background timeouts | 16,995 | 4.77 | 0.49 |
branch node splits | 2 | 0.00 | 0.00 |
buffer is not pinned count | 857,538 | 240.53 | 24.48 |
buffer is pinned count | 840,664 | 235.79 | 24.00 |
bytes received via SQL*Net from client | 1,744,339 | 489.26 | 49.80 |
bytes sent via SQL*Net to client | 3,424,499 | 960.52 | 97.76 |
calls to get snapshot scn: kcmgss | 203,446 | 57.06 | 5.81 |
calls to kcmgas | 40,798 | 11.44 | 1.16 |
calls to kcmgcs | 3,679 | 1.03 | 0.11 |
cell physical IO interconnect bytes | 1,326,731,776 | 372,126.28 | 37,874.16 |
change write time | 3,951 | 1.11 | 0.11 |
cleanout - number of ktugct calls | 3,420 | 0.96 | 0.10 |
cleanouts and rollbacks - consistent read gets | 2,024 | 0.57 | 0.06 |
cleanouts only - consistent read gets | 18 | 0.01 | 0.00 |
cluster key scan block gets | 2,327 | 0.65 | 0.07 |
cluster key scans | 2,069 | 0.58 | 0.06 |
commit batch performed | 0 | 0.00 | 0.00 |
commit batch requested | 0 | 0.00 | 0.00 |
commit batch/immediate performed | 58 | 0.02 | 0.00 |
commit batch/immediate requested | 58 | 0.02 | 0.00 |
commit cleanout failures: block lost | 0 | 0.00 | 0.00 |
commit cleanout failures: buffer being written | 1 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 17 | 0.00 | 0.00 |
commit cleanout failures: cannot pin | 1,450 | 0.41 | 0.04 |
commit cleanouts | 148,527 | 41.66 | 4.24 |
commit cleanouts successfully completed | 147,059 | 41.25 | 4.20 |
commit immediate performed | 58 | 0.02 | 0.00 |
commit immediate requested | 58 | 0.02 | 0.00 |
commit nowait performed | 0 | 0.00 | 0.00 |
commit nowait requested | 0 | 0.00 | 0.00 |
commit txn count during cleanout | 2,815 | 0.79 | 0.08 |
commit wait/nowait performed | 0 | 0.00 | 0.00 |
commit wait/nowait requested | 0 | 0.00 | 0.00 |
concurrency wait time | 6,914 | 1.94 | 0.20 |
consistent changes | 5,980 | 1.68 | 0.17 |
consistent gets | 1,271,075 | 356.52 | 36.29 |
consistent gets - examination | 891,272 | 249.99 | 25.44 |
consistent gets direct | 1 | 0.00 | 0.00 |
consistent gets from cache | 1,271,074 | 356.52 | 36.29 |
consistent gets from cache (fastpath) | 356,181 | 99.90 | 10.17 |
cursor authentications | 38 | 0.01 | 0.00 |
data blocks consistent reads - undo records applied | 5,644 | 1.58 | 0.16 |
db block changes | 487,584 | 136.76 | 13.92 |
db block gets | 665,518 | 186.67 | 19.00 |
db block gets direct | 6 | 0.00 | 0.00 |
db block gets from cache | 665,512 | 186.67 | 19.00 |
db block gets from cache (fastpath) | 158,812 | 44.54 | 4.53 |
deferred (CURRENT) block cleanout applications | 58,793 | 16.49 | 1.68 |
dirty buffers inspected | 27,743 | 7.78 | 0.79 |
enqueue conversions | 744 | 0.21 | 0.02 |
enqueue releases | 133,032 | 37.31 | 3.80 |
enqueue requests | 133,079 | 37.33 | 3.80 |
enqueue timeouts | 1 | 0.00 | 0.00 |
enqueue waits | 11 | 0.00 | 0.00 |
execute count | 220,922 | 61.96 | 6.31 |
failed probes on index block reclamation | 1 | 0.00 | 0.00 |
file io service time | 398 | 0.11 | 0.01 |
file io wait time | 96,826,292 | 27,158.17 | 2,764.10 |
free buffer inspected | 100,682 | 28.24 | 2.87 |
free buffer requested | 89,651 | 25.15 | 2.56 |
heap block compress | 160 | 0.04 | 0.00 |
hot buffers moved to head of LRU | 79,066 | 22.18 | 2.26 |
immediate (CR) block cleanout applications | 2,042 | 0.57 | 0.06 |
immediate (CURRENT) block cleanout applications | 6,496 | 1.82 | 0.19 |
index crx upgrade (positioned) | 8 | 0.00 | 0.00 |
index fast full scans (direct read) | 0 | 0.00 | 0.00 |
index fast full scans (full) | 5 | 0.00 | 0.00 |
index fast full scans (rowid ranges) | 0 | 0.00 | 0.00 |
index fetch by key | 268,006 | 75.17 | 7.65 |
index scans kdiixs1 | 67,145 | 18.83 | 1.92 |
leaf node 90-10 splits | 41 | 0.01 | 0.00 |
leaf node splits | 444 | 0.12 | 0.01 |
lob reads | 0 | 0.00 | 0.00 |
lob writes | 77 | 0.02 | 0.00 |
lob writes unaligned | 77 | 0.02 | 0.00 |
logons cumulative | 203 | 0.06 | 0.01 |
max cf enq hold time | 0 | 0.00 | 0.00 |
messages received | 46,925 | 13.16 | 1.34 |
messages sent | 46,925 | 13.16 | 1.34 |
min active SCN optimization applied on CR | 13 | 0.00 | 0.00 |
no buffer to keep pinned count | 0 | 0.00 | 0.00 |
no work - consistent read gets | 361,558 | 101.41 | 10.32 |
non-idle wait count | 180,445 | 50.61 | 5.15 |
non-idle wait time | 38,071 | 10.68 | 1.09 |
opened cursors cumulative | 230,168 | 64.56 | 6.57 |
parse count (describe) | 6 | 0.00 | 0.00 |
parse count (failures) | 0 | 0.00 | 0.00 |
parse count (hard) | 19 | 0.01 | 0.00 |
parse count (total) | 32,385 | 9.08 | 0.92 |
parse time cpu | 264 | 0.07 | 0.01 |
parse time elapsed | 547 | 0.15 | 0.02 |
physical read IO requests | 77,861 | 21.84 | 2.22 |
physical read bytes | 658,448,384 | 184,683.86 | 18,796.70 |
physical read total IO requests | 81,389 | 22.83 | 2.32 |
physical read total bytes | 716,040,192 | 200,837.41 | 20,440.77 |
physical read total multi block requests | 26 | 0.01 | 0.00 |
physical reads | 80,377 | 22.54 | 2.29 |
physical reads cache | 80,376 | 22.54 | 2.29 |
physical reads cache prefetch | 3,452 | 0.97 | 0.10 |
physical reads direct | 1 | 0.00 | 0.00 |
physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 44,052 | 12.36 | 1.26 |
physical write bytes | 475,045,888 | 133,242.50 | 13,561.12 |
physical write total IO requests | 77,293 | 21.68 | 2.21 |
physical write total bytes | 610,691,584 | 171,288.87 | 17,433.39 |
physical write total multi block requests | 164 | 0.05 | 0.00 |
physical writes | 57,989 | 16.26 | 1.66 |
physical writes direct | 6 | 0.00 | 0.00 |
physical writes direct (lob) | 1 | 0.00 | 0.00 |
physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
physical writes from cache | 57,983 | 16.26 | 1.66 |
physical writes non checkpoint | 40,859 | 11.46 | 1.17 |
pinned buffers inspected | 0 | 0.00 | 0.00 |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
prefetched blocks aged out before use | 0 | 0.00 | 0.00 |
process last non-idle time | 8,132 | 2.28 | 0.23 |
queries parallelized | 0 | 0.00 | 0.00 |
recursive calls | 381,105 | 106.89 | 10.88 |
recursive cpu usage | 40,775 | 11.44 | 1.16 |
redo blocks checksummed by FG (exclusive) | 35,317 | 9.91 | 1.01 |
redo blocks written | 163,997 | 46.00 | 4.68 |
redo buffer allocation retries | 0 | 0.00 | 0.00 |
redo entries | 190,024 | 53.30 | 5.42 |
redo log space requests | 0 | 0.00 | 0.00 |
redo log space wait time | 0 | 0.00 | 0.00 |
redo ordering marks | 0 | 0.00 | 0.00 |
redo size | 72,611,236 | 20,366.25 | 2,072.83 |
redo size for direct writes | 148 | 0.04 | 0.00 |
redo synch long waits | 1,737 | 0.49 | 0.05 |
redo synch time | 14,020 | 3.93 | 0.40 |
redo synch time (usec) | 140,200,785 | 39,324.00 | 4,002.31 |
redo synch writes | 24,315 | 6.82 | 0.69 |
redo wastage | 9,018,880 | 2,529.65 | 257.46 |
redo write time | 4,734 | 1.33 | 0.14 |
redo writes | 30,047 | 8.43 | 0.86 |
rollback changes - undo records applied | 58 | 0.02 | 0.00 |
rollbacks only - consistent read gets | 103 | 0.03 | 0.00 |
rows fetched via callback | 173,678 | 48.71 | 4.96 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 227,479 | 63.80 | 6.49 |
session logical reads | 1,936,593 | 543.18 | 55.28 |
shared hash latch upgrades - no wait | 56,815 | 15.94 | 1.62 |
shared hash latch upgrades - wait | 18 | 0.01 | 0.00 |
sorts (disk) | 0 | 0.00 | 0.00 |
sorts (memory) | 9,939 | 2.79 | 0.28 |
sorts (rows) | 29,425 | 8.25 | 0.84 |
sql area evicted | 0 | 0.00 | 0.00 |
sql area purged | 0 | 0.00 | 0.00 |
summed dirty queue length | 35,724 | 10.02 | 1.02 |
switch current to new buffer | 137 | 0.04 | 0.00 |
table fetch by rowid | 680,284 | 190.81 | 19.42 |
table fetch continued row | 0 | 0.00 | 0.00 |
table scan blocks gotten | 4,040 | 1.13 | 0.12 |
table scan rows gotten | 296,242 | 83.09 | 8.46 |
table scans (direct read) | 0 | 0.00 | 0.00 |
table scans (long tables) | 0 | 0.00 | 0.00 |
table scans (rowid ranges) | 0 | 0.00 | 0.00 |
table scans (short tables) | 1,473 | 0.41 | 0.04 |
total cf enq hold time | 670 | 0.19 | 0.02 |
total number of cf enq holders | 113 | 0.03 | 0.00 |
total number of times SMON posted | 23 | 0.01 | 0.00 |
transaction rollbacks | 58 | 0.02 | 0.00 |
undo change vector size | 23,981,768 | 6,726.49 | 684.61 |
user I/O wait time | 6,247 | 1.75 | 0.18 |
user calls | 24,841 | 6.97 | 0.71 |
user commits | 35,030 | 9.83 | 1.00 |
workarea executions - onepass | 0 | 0.00 | 0.00 |
workarea executions - optimal | 12,832 | 3.60 | 0.37 |
write clones created in background | 0 | 0.00 | 0.00 |
write clones created in foreground | 16 | 0.00 | 0.00 |
Statistic | Begin Value | End Value |
---|---|---|
session uga memory max | 2,469,805,760 | 2,634,948,776 |
session pga memory | 583,259,336 | 727,967,648 |
session pga memory max | 777,442,504 | 931,325,856 |
session cursor cache count | 12,648 | 15,907 |
session uga memory | 953,553,982,608 | 1,237,033,246,280 |
opened cursors current | 196 | 202 |
workarea memory allocated | 0 | 1,347 |
logons current | 41 | 40 |
Statistic | Total | per Hour |
---|---|---|
log switches (derived) | 2 | 2.02 |
Function Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
---|---|---|---|---|---|---|---|---|
Buffer Cache Reads | 626M | 21.81 | .175582 | 0M | 0.00 | 0M | 77.3K | 0.52 |
DBWR | 0M | 0.00 | 0M | 452M | 12.30 | .126778 | 16.8K | 1.75 |
Others | 54M | 0.98 | .015146 | 49M | 0.88 | .013743 | 6605 | 0.58 |
LGWR | 0M | 0.01 | 0M | 80M | 8.44 | .022438 | 60.1K | 0.96 |
Direct Writes | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 2 | 0.00 |
Streams AQ | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 17 | 2.18 |
TOTAL: | 680M | 22.81 | .190728 | 581M | 21.61 | .162960 | 160.9K | 0.81 |
Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read |
---|---|---|---|---|---|---|---|---|
Data File | 627M | 21.82 | .175863 | 451M | 12.30 | .126498 | 0.51 | 2.00 |
Control File | 54M | 0.98 | .015146 | 49M | 0.88 | .013743 | 0.04 | |
Log File | 0M | 0.00 | 0M | 80M | 8.43 | .022438 | 0.00 | |
Temp File | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 0.00 | |
TOTAL: | 681M | 22.81 | .191009 | 580M | 21.61 | .162680 | 0.49 | 2.00 |
Function/File Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
---|---|---|---|---|---|---|---|---|
Buffer Cache Reads | 626M | 21.81 | .175582 | 0M | 0.00 | 0M | 76.3K | 0.52 |
Buffer Cache Reads (Data File) | 626M | 21.81 | .175582 | 0M | 0.00 | 0M | 76.3K | 0.52 |
DBWR | 0M | 0.00 | 0M | 452M | 12.30 | .126778 | 0 | |
DBWR (Data File) | 0M | 0.00 | 0M | 452M | 12.30 | .126778 | 0 | |
Others | 54M | 0.98 | .015146 | 49M | 0.88 | .013743 | 3497 | 0.04 |
Others (Control File) | 54M | 0.97 | .015146 | 49M | 0.87 | .013743 | 3466 | 0.04 |
Others (Data File) | 0M | 0.01 | 0M | 0M | 0.00 | 0M | 31 | 0.29 |
LGWR | 0M | 0.01 | 0M | 80M | 8.44 | .022438 | 48 | 0.00 |
LGWR (Log File) | 0M | 0.00 | 0M | 80M | 8.43 | .022438 | 8 | 0.00 |
LGWR (Control File) | 0M | 0.01 | 0M | 0M | 0.01 | 0M | 40 | 0.00 |
Streams AQ | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 17 | 2.18 |
Streams AQ (Data File) | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 17 | 2.18 |
Direct Writes | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 0 | |
Direct Writes (Data File) | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 0 | |
TOTAL: | 680M | 22.81 | .190728 | 581M | 21.61 | .162960 | 79.9K | 0.50 |
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
SWINGBENCH | 75,531 | 21 | 0.77 | 1.00 | 42,745 | 12 | 72 | 14.58 |
SYSAUX | 1,519 | 0 | 1.28 | 1.18 | 736 | 0 | 0 | 0.00 |
SYSTEM | 694 | 0 | 0.97 | 4.24 | 57 | 0 | 0 | 0.00 |
UNDOTBS1 | 4 | 0 | 0.00 | 1.00 | 513 | 0 | 19 | 18.95 |
TEMP | 4 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
EXAMPLE | 1 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
USERS | 1 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|---|
EXAMPLE | /u01/app/oracle/oradata/DB11G/example01.dbf | 1 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
SWINGBENCH | /u01/app/oracle/product/11.2.0.2/db_1/dbs/soe.dbf | 75,531 | 21 | 0.77 | 1.00 | 42,745 | 12 | 72 | 14.58 |
SYSAUX | /u01/app/oracle/oradata/DB11G/sysaux01.dbf | 1,519 | 0 | 1.28 | 1.18 | 736 | 0 | 0 | 0.00 |
SYSTEM | /u01/app/oracle/oradata/DB11G/system01.dbf | 694 | 0 | 0.97 | 4.24 | 57 | 0 | 0 | 0.00 |
TEMP | /u01/app/oracle/oradata/DB11G/temp01.dbf | 4 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | |
UNDOTBS1 | /u01/app/oracle/oradata/DB11G/undotbs01.dbf | 4 | 0 | 0.00 | 1.00 | 513 | 0 | 19 | 18.95 |
USERS | /u01/app/oracle/oradata/DB11G/users01.dbf | 1 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits |
---|---|---|---|---|---|---|---|---|
D | 23,077 | 96 | 1,936,612 | 80,376 | 57,983 | 0 | 0 | 91 |
MTTR Writes | Log Size Writes | Log Ckpt Writes | Other Settings Writes | Autotune Ckpt Writes | Thread Ckpt Writes |
---|---|---|---|---|---|
0 | 0 | 0 | 0 | 23,798 | 0 |
Targt MTTR (s) | Estd MTTR (s) | Recovery Estd IOs | Actual RedoBlks | Target RedoBlks | Log Sz RedoBlks | Log Ckpt Timeout RedoBlks | Log Ckpt Interval RedoBlks | Opt Log Sz(M) | Estd RAC Avail Time | |
---|---|---|---|---|---|---|---|---|---|---|
B | 0 | 23 | 4470 | 29931 | 157722 | 165888 | 157722 | |||
E | 0 | 20 | 1102 | 3150 | 18102 | 165888 | 18102 |
P | Size for Est (M) | Size Factor | Buffers (thousands) | Est Phys Read Factor | Estimated Phys Reads (thousands) | Est Phys Read Time | Est %DBtime for Rds |
---|---|---|---|---|---|---|---|
D | 16 | 0.09 | 2 | 3.13 | 976 | 1 | 2306.00 |
D | 32 | 0.17 | 4 | 2.65 | 826 | 1 | 1946.00 |
D | 48 | 0.26 | 6 | 2.21 | 690 | 1 | 1619.00 |
D | 64 | 0.34 | 8 | 1.92 | 600 | 1 | 1402.00 |
D | 80 | 0.43 | 10 | 1.68 | 525 | 1 | 1221.00 |
D | 96 | 0.51 | 12 | 1.50 | 468 | 1 | 1084.00 |
D | 112 | 0.60 | 14 | 1.36 | 424 | 1 | 981.00 |
D | 128 | 0.68 | 16 | 1.25 | 390 | 1 | 898.00 |
D | 144 | 0.77 | 18 | 1.16 | 362 | 1 | 831.00 |
D | 160 | 0.85 | 20 | 1.09 | 340 | 1 | 778.00 |
D | 176 | 0.94 | 22 | 1.03 | 323 | 1 | 736.00 |
D | 188 | 1.00 | 23 | 1.00 | 312 | 1 | 710.00 |
D | 192 | 1.02 | 24 | 0.99 | 309 | 1 | 702.00 |
D | 208 | 1.11 | 26 | 0.95 | 297 | 1 | 674.00 |
D | 224 | 1.19 | 27 | 0.92 | 288 | 1 | 652.00 |
D | 240 | 1.28 | 29 | 0.90 | 281 | 1 | 636.00 |
D | 256 | 1.36 | 31 | 0.88 | 274 | 1 | 620.00 |
D | 272 | 1.45 | 33 | 0.86 | 268 | 1 | 605.00 |
D | 288 | 1.53 | 35 | 0.85 | 264 | 1 | 596.00 |
D | 304 | 1.62 | 37 | 0.84 | 261 | 1 | 588.00 |
D | 320 | 1.70 | 39 | 0.83 | 258 | 1 | 581.00 |
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
100.00 | 6,505 | 0 |
Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
---|---|---|---|---|---|
2K | 4K | 3,677 | 3,677 | 0 | 0 |
64K | 128K | 8 | 8 | 0 | 0 |
256K | 512K | 2 | 2 | 0 | 0 |
512K | 1024K | 9,137 | 9,137 | 0 | 0 |
1M | 2M | 5 | 5 | 0 | 0 |
4M | 8M | 4 | 4 | 0 | 0 |
PGA Target Est (MB) | Size Factr | W/A MB Processed | Estd Extra W/A MB Read/ Written to Disk | Estd PGA Cache Hit % | Estd PGA Overalloc Count | Estd Time |
---|---|---|---|---|---|---|
35 | 0.13 | 26,784.60 | 9,788.70 | 73.00 | 80 | 9,324,596 |
70 | 0.25 | 26,784.60 | 4,335.63 | 86.00 | 62 | 7,934,301 |
140 | 0.50 | 26,784.60 | 2,380.31 | 92.00 | 0 | 7,435,779 |
210 | 0.75 | 26,784.60 | 2,380.31 | 92.00 | 0 | 7,435,779 |
280 | 1.00 | 26,784.60 | 2,380.31 | 92.00 | 0 | 7,435,779 |
336 | 1.20 | 26,784.60 | 1,600.66 | 94.00 | 0 | 7,237,004 |
392 | 1.40 | 26,784.60 | 1,297.62 | 95.00 | 0 | 7,159,740 |
448 | 1.60 | 26,784.60 | 1,133.98 | 96.00 | 0 | 7,118,020 |
504 | 1.80 | 26,784.60 | 1,133.98 | 96.00 | 0 | 7,118,020 |
560 | 2.00 | 26,784.60 | 1,133.98 | 96.00 | 0 | 7,118,020 |
840 | 3.00 | 26,784.60 | 1,133.98 | 96.00 | 0 | 7,118,020 |
1,120 | 4.00 | 26,784.60 | 1,133.98 | 96.00 | 0 | 7,118,020 |
1,680 | 6.00 | 26,784.60 | 1,133.98 | 96.00 | 0 | 7,118,020 |
2,240 | 8.00 | 26,784.60 | 1,133.98 | 96.00 | 0 | 7,118,020 |
Shared Pool Size(M) | SP Size Factr | Est LC Size (M) | Est LC Mem Obj | Est LC Time Saved (s) | Est LC Time Saved Factr | Est LC Load Time (s) | Est LC Load Time Factr | Est LC Mem Obj Hits (K) |
---|---|---|---|---|---|---|---|---|
160 | 0.56 | 30 | 2,235 | 32,982 | 0.99 | 281 | 2.81 | 619 |
192 | 0.67 | 62 | 4,012 | 33,119 | 1.00 | 144 | 1.44 | 650 |
224 | 0.78 | 94 | 5,896 | 33,161 | 1.00 | 102 | 1.02 | 650 |
256 | 0.89 | 108 | 6,815 | 33,163 | 1.00 | 100 | 1.00 | 650 |
288 | 1.00 | 109 | 6,852 | 33,163 | 1.00 | 100 | 1.00 | 650 |
320 | 1.11 | 109 | 6,852 | 33,163 | 1.00 | 100 | 1.00 | 650 |
352 | 1.22 | 109 | 6,852 | 33,163 | 1.00 | 100 | 1.00 | 650 |
384 | 1.33 | 109 | 6,852 | 33,163 | 1.00 | 100 | 1.00 | 650 |
416 | 1.44 | 109 | 6,852 | 33,163 | 1.00 | 100 | 1.00 | 650 |
448 | 1.56 | 109 | 6,852 | 33,163 | 1.00 | 100 | 1.00 | 650 |
480 | 1.67 | 109 | 6,852 | 33,163 | 1.00 | 100 | 1.00 | 650 |
512 | 1.78 | 109 | 6,852 | 33,163 | 1.00 | 100 | 1.00 | 650 |
544 | 1.89 | 109 | 6,852 | 33,163 | 1.00 | 100 | 1.00 | 650 |
576 | 2.00 | 109 | 6,852 | 33,163 | 1.00 | 100 | 1.00 | 650 |
SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
---|---|---|---|
262 | 0.50 | 8,336 | 619,354 |
393 | 0.75 | 7,673 | 367,986 |
524 | 1.00 | 7,517 | 311,562 |
655 | 1.25 | 7,502 | 304,365 |
786 | 1.50 | 7,502 | 304,365 |
917 | 1.75 | 7,502 | 304,365 |
1,048 | 2.00 | 7,502 | 304,365 |
Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
---|---|---|---|---|---|
4 | 0.50 | 0 | 0 | 0 | 0 |
8 | 1.00 | 0 | 0 | 0 | 0 |
12 | 1.50 | 0 | 0 | 0 | 0 |
16 | 2.00 | 0 | 0 | 0 | 0 |
20 | 2.50 | 0 | 0 | 0 | 0 |
24 | 3.00 | 0 | 0 | 0 | 0 |
28 | 3.50 | 0 | 0 | 0 | 0 |
32 | 4.00 | 0 | 0 | 0 | 0 |
36 | 4.50 | 0 | 0 | 0 | 0 |
40 | 5.00 | 0 | 0 | 0 | 0 |
44 | 5.50 | 0 | 0 | 0 | 0 |
48 | 6.00 | 0 | 0 | 0 | 0 |
52 | 6.50 | 0 | 0 | 0 | 0 |
56 | 7.00 | 0 | 0 | 0 | 0 |
60 | 7.50 | 0 | 0 | 0 | 0 |
64 | 8.00 | 0 | 0 | 0 | 0 |
68 | 8.50 | 0 | 0 | 0 | 0 |
72 | 9.00 | 0 | 0 | 0 | 0 |
76 | 9.50 | 0 | 0 | 0 | 0 |
80 | 10.00 | 0 | 0 | 0 | 0 |
Class | Waits | Total Wait Time (s) | Avg Time (ms) |
---|---|---|---|
data block | 72 | 1 | 15 |
undo header | 16 | 0 | 17 |
undo block | 3 | 0 | 30 |
Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
---|---|---|---|---|---|---|
TX-Transaction (row lock contention) | 10 | 10 | 0 | 10 | 0 | 18.00 |
PR-Process Startup | 137 | 137 | 0 | 1 | 0 | 40.00 |
Undo TS# | 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 |
---|---|---|---|---|---|---|---|
2 | 4.08 | 43,639 | 1,136 | 11 | 19.5/31 | 0/0 | 0/0/0/0/0/0 |
End Time | Num Undo Blocks | Number of Transactions | Max Qry Len (s) | Max Tx Concy | Tun Ret (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
---|---|---|---|---|---|---|---|
05-Oct 16:52 | 15 | 68 | 1,136 | 3 | 31 | 0/0 | 0/0/0/0/0/0 |
05-Oct 16:42 | 18 | 90 | 528 | 1 | 22 | 0/0 | 0/0/0/0/0/0 |
05-Oct 16:32 | 830 | 9,859 | 989 | 10 | 30 | 0/0 | 0/0/0/0/0/0 |
05-Oct 16:22 | 989 | 11,198 | 386 | 11 | 19 | 0/0 | 0/0/0/0/0/0 |
05-Oct 16:12 | 1,013 | 11,177 | 992 | 11 | 30 | 0/0 | 0/0/0/0/0/0 |
05-Oct 16:02 | 1,216 | 11,247 | 390 | 11 | 20 | 0/0 | 0/0/0/0/0/0 |
Latch Name | Get Requests | Pct Get Miss | Avg Slps /Miss | Wait Time (s) | NoWait Requests | Pct NoWait Miss |
---|---|---|---|---|---|---|
AQ deq hash table latch | 22 | 0.00 | 0 | 0 | ||
AQ dequeue txn counter latch | 4 | 0.00 | 0 | 0 | ||
AQ disk delete txn counter latch | 4 | 0.00 | 0 | 0 | ||
ASM db client latch | 2,380 | 0.00 | 0 | 0 | ||
ASM map operation hash table | 2 | 0.00 | 0 | 0 | ||
ASM network state latch | 56 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 25,750 | 0.00 | 0 | 0 | ||
Change Notification Hash table latch | 1,181 | 0.00 | 0 | 0 | ||
Consistent RBA | 30,053 | 0.00 | 0 | 0 | ||
DML lock allocation | 135,031 | 0.00 | 1.00 | 0 | 0 | |
Event Group Locks | 139 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 367 | 0.00 | 0 | 0 | ||
File State Object Pool Parent Latch | 2 | 0.00 | 0 | 0 | ||
I/O Staticstics latch | 2 | 0.00 | 0 | 0 | ||
IPC stats buffer allocation latch | 2 | 0.00 | 0 | 0 | ||
In memory undo latch | 209,326 | 0.03 | 1.00 | 1 | 35,910 | 0.00 |
JS Sh mem access | 8 | 0.00 | 0 | 0 | ||
JS mem alloc latch | 6 | 0.00 | 0 | 0 | ||
JS queue access latch | 8 | 0.00 | 0 | 0 | ||
JS queue state obj latch | 25,450 | 0.00 | 0 | 0 | ||
JS slv state obj latch | 238 | 0.00 | 0 | 0 | ||
KFC FX Hash Latch | 2 | 0.00 | 0 | 0 | ||
KFC Hash Latch | 2 | 0.00 | 0 | 0 | ||
KFCL LE Freelist | 2 | 0.00 | 0 | 0 | ||
KGNFS-NFS:SHM structure | 2 | 0.00 | 0 | 0 | ||
KGNFS-NFS:SVR LIST | 2 | 0.00 | 0 | 0 | ||
KJC message pool free list | 2 | 0.00 | 0 | 0 | ||
KJCT flow control latch | 2 | 0.00 | 0 | 0 | ||
KMG MMAN ready and startup request latch | 1,182 | 0.00 | 0 | 0 | ||
KTF sga latch | 21 | 0.00 | 0 | 1,147 | 0.00 | |
KWQMN job cache list latch | 11 | 0.00 | 0 | 0 | ||
KWQP Prop Status | 3 | 0.00 | 0 | 0 | ||
KWQS pqsubs latch | 5 | 0.00 | 0 | 0 | ||
KWQS pqueue ctx latch | 81 | 0.00 | 0 | 0 | ||
Locator state objects pool parent latch | 2 | 0.00 | 0 | 0 | ||
Lsod array latch | 2 | 0.00 | 0 | 0 | ||
MQL Tracking Latch | 0 | 0 | 70 | 0.00 | ||
Memory Management Latch | 2 | 0.00 | 0 | 1,182 | 0.00 | |
Memory Queue | 2 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #1 | 2 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #2 | 2 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #3 | 2 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #4 | 2 | 0.00 | 0 | 0 | ||
Memory Queue Subscriber | 2 | 0.00 | 0 | 0 | ||
MinActiveScn Latch | 38 | 0.00 | 0 | 0 | ||
Mutex | 2 | 0.00 | 0 | 0 | ||
Mutex Stats | 2 | 0.00 | 0 | 0 | ||
OS process | 1,238 | 0.00 | 0 | 0 | ||
OS process allocation | 7,495 | 0.00 | 0 | 0 | ||
OS process: request allocation | 275 | 0.00 | 0 | 0 | ||
PL/SQL warning settings | 384 | 0.00 | 0 | 0 | ||
PX hash array latch | 2 | 0.00 | 0 | 0 | ||
QMT | 2 | 0.00 | 0 | 0 | ||
Real-time plan statistics latch | 826 | 0.00 | 0 | 0 | ||
SGA IO buffer pool latch | 15 | 0.00 | 0 | 15 | 0.00 | |
SGA blob parent | 2 | 0.00 | 0 | 0 | ||
SGA bucket locks | 2 | 0.00 | 0 | 0 | ||
SGA heap locks | 2 | 0.00 | 0 | 0 | ||
SGA pool locks | 2 | 0.00 | 0 | 0 | ||
SQL memory manager latch | 120 | 0.00 | 0 | 1,180 | 0.00 | |
SQL memory manager workarea list latch | 122,983 | 0.00 | 0 | 0 | ||
Shared B-Tree | 359 | 0.00 | 0 | 0 | ||
Streams Generic | 2 | 0.00 | 0 | 0 | ||
Testing | 2 | 0.00 | 0 | 0 | ||
Token Manager | 2 | 0.00 | 0 | 0 | ||
WCR: sync | 2 | 0.00 | 0 | 0 | ||
Write State Object Pool Parent Latch | 2 | 0.00 | 0 | 0 | ||
X$KSFQP | 1 | 0.00 | 0 | 0 | ||
XDB NFS Security Latch | 2 | 0.00 | 0 | 0 | ||
XDB unused session pool | 2 | 0.00 | 0 | 0 | ||
XDB used session pool | 2 | 0.00 | 0 | 0 | ||
active checkpoint queue latch | 18,012 | 0.00 | 0 | 0 | ||
active service list | 7,922 | 0.00 | 0 | 1,740 | 0.00 | |
begin backup scn array | 2 | 0.00 | 0 | 0 | ||
buffer pool | 2 | 0.00 | 0 | 0 | ||
business card | 2 | 0.00 | 0 | 0 | ||
cache buffer handles | 1,456 | 0.00 | 0 | 0 | ||
cache buffers chains | 4,862,566 | 0.02 | 0.42 | 5 | 93,808 | 0.01 |
cache buffers lru chain | 149,042 | 0.30 | 1.01 | 7 | 63,830 | 0.20 |
cache table scan latch | 204 | 0.00 | 0 | 204 | 0.00 | |
call allocation | 1,082 | 0.09 | 1.00 | 0 | 0 | |
cas latch | 2 | 0.00 | 0 | 0 | ||
change notification client cache latch | 2 | 0.00 | 0 | 0 | ||
channel handle pool latch | 293 | 0.00 | 0 | 0 | ||
channel operations parent latch | 19,785 | 0.00 | 0 | 0 | ||
checkpoint queue latch | 138,179 | 0.00 | 1.00 | 0 | 49,722 | 0.02 |
client/application info | 902,294 | 0.07 | 1.00 | 10 | 0 | |
compile environment latch | 203 | 0.00 | 0 | 0 | ||
corrupted undo seg latch | 232 | 0.00 | 0 | 0 | ||
cp cmon/server latch | 2 | 0.00 | 0 | 0 | ||
cp pool latch | 2 | 0.00 | 0 | 0 | ||
cp server hash latch | 2 | 0.00 | 0 | 0 | ||
cp sga latch | 56 | 0.00 | 0 | 0 | ||
cvmap freelist lock | 2 | 0.00 | 0 | 0 | ||
deferred cleanup latch | 56 | 0.00 | 0 | 0 | ||
dml lock allocation | 56 | 0.00 | 0 | 0 | ||
done queue latch | 2 | 0.00 | 0 | 0 | ||
dummy allocation | 409 | 0.00 | 0 | 0 | ||
enqueue hash chains | 266,872 | 0.01 | 1.00 | 0 | 0 | |
enqueues | 59,035 | 0.00 | 0 | 0 | ||
fifth spare latch | 2 | 0.00 | 0 | 0 | ||
file cache latch | 175 | 0.00 | 0 | 0 | ||
flashback copy | 2 | 0.00 | 0 | 0 | ||
fourth Audit Vault latch | 2 | 0.00 | 0 | 0 | ||
gc element | 2 | 0.00 | 0 | 0 | ||
gcs commit scn state | 2 | 0.00 | 0 | 0 | ||
gcs partitioned table hash | 2 | 0.00 | 0 | 0 | ||
gcs pcm hashed value bucket hash | 2 | 0.00 | 0 | 0 | ||
gcs resource freelist | 2 | 0.00 | 0 | 0 | ||
gcs resource hash | 2 | 0.00 | 0 | 0 | ||
gcs resource scan list | 2 | 0.00 | 0 | 0 | ||
gcs shadows freelist | 2 | 0.00 | 0 | 0 | ||
ges domain table | 2 | 0.00 | 0 | 0 | ||
ges enqueue table freelist | 2 | 0.00 | 0 | 0 | ||
ges group table | 2 | 0.00 | 0 | 0 | ||
ges process hash list | 2 | 0.00 | 0 | 0 | ||
ges process parent latch | 2 | 0.00 | 0 | 0 | ||
ges resource hash list | 2 | 0.00 | 0 | 0 | ||
ges resource scan list | 2 | 0.00 | 0 | 0 | ||
ges resource table freelist | 2 | 0.00 | 0 | 0 | ||
ges value block free list | 2 | 0.00 | 0 | 0 | ||
global tx hash mapping | 2 | 0.00 | 0 | 0 | ||
granule operation | 2 | 0.00 | 0 | 0 | ||
hash table column usage latch | 24 | 0.00 | 0 | 4,319 | 0.00 | |
hash table modification latch | 130 | 0.00 | 0 | 0 | ||
heartbeat check | 2 | 0.00 | 0 | 0 | ||
internal temp table object number allocation latch | 8 | 0.00 | 0 | 0 | ||
intra txn parallel recovery | 2 | 0.00 | 0 | 0 | ||
io pool granule metadata list | 2 | 0.00 | 0 | 0 | ||
job workq parent latch | 69 | 0.00 | 0 | 67 | 2.99 | |
job_queue_processes free list latch | 138 | 0.00 | 0 | 0 | ||
job_queue_processes parameter latch | 828 | 0.00 | 0 | 0 | ||
k2q lock allocation | 2 | 0.00 | 0 | 0 | ||
kcbtsemkid latch | 2 | 0.00 | 0 | 0 | ||
kdlx hb parent latch | 2 | 0.00 | 0 | 0 | ||
kgb parent | 2 | 0.00 | 0 | 0 | ||
kgnfs mount latch | 2 | 0.00 | 0 | 0 | ||
kokc descriptor allocation latch | 376 | 0.00 | 0 | 0 | ||
ksfv messages | 2 | 0.00 | 0 | 0 | ||
ksim group membership cache | 2 | 0.00 | 0 | 0 | ||
kss move lock | 40 | 0.00 | 0 | 0 | ||
ksuosstats global area | 244 | 0.00 | 0 | 0 | ||
ksv allocation latch | 133 | 0.00 | 0 | 0 | ||
ksv class latch | 80 | 0.00 | 0 | 0 | ||
ksv msg queue latch | 2 | 0.00 | 0 | 0 | ||
ksz_so allocation latch | 275 | 0.00 | 0 | 0 | ||
ktm global data | 113 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 132 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 30,426 | 0.00 | 0 | 0 | ||
list of block allocation | 201 | 0.00 | 0 | 0 | ||
loader state object freelist | 8 | 0.00 | 0 | 0 | ||
lob segment dispenser latch | 2 | 0.00 | 0 | 0 | ||
lob segment hash table latch | 14 | 0.00 | 0 | 0 | ||
lob segment query latch | 2 | 0.00 | 0 | 0 | ||
lock DBA buffer during media recovery | 2 | 0.00 | 0 | 0 | ||
logical standby cache | 2 | 0.00 | 0 | 0 | ||
logminer context allocation | 3 | 0.00 | 0 | 0 | ||
logminer work area | 2 | 0.00 | 0 | 0 | ||
longop free list parent | 2 | 0.00 | 0 | 0 | ||
mapped buffers lru chain | 2 | 0.00 | 0 | 0 | ||
message pool operations parent latch | 29 | 0.00 | 0 | 0 | ||
messages | 157,985 | 0.01 | 1.00 | 0 | 0 | |
mostly latch-free SCN | 30,426 | 0.00 | 0 | 0 | ||
msg queue latch | 2 | 0.00 | 0 | 0 | ||
multiblock read objects | 1,444 | 0.00 | 0 | 0 | ||
name-service namespace bucket | 2 | 0.00 | 0 | 0 | ||
ncodef allocation latch | 56 | 0.00 | 0 | 0 | ||
object queue header heap | 18,643 | 0.00 | 0 | 573 | 0.00 | |
object queue header operation | 358,954 | 0.03 | 1.01 | 1 | 0 | |
object stats modification | 55 | 0.00 | 0 | 0 | ||
parallel query alloc buffer | 474 | 0.00 | 0 | 0 | ||
parallel query stats | 2 | 0.00 | 0 | 0 | ||
parameter list | 180 | 0.00 | 0 | 0 | ||
parameter table management | 961 | 0.00 | 0 | 0 | ||
peshm | 2 | 0.00 | 0 | 0 | ||
pesom_free_list | 2 | 0.00 | 0 | 0 | ||
pesom_hash_node | 2 | 0.00 | 0 | 0 | ||
post/wait queue | 17,137 | 0.00 | 0 | 11,596 | 0.00 | |
process allocation | 412 | 0.00 | 0 | 137 | 0.00 | |
process group creation | 275 | 0.00 | 0 | 0 | ||
process queue | 2 | 0.00 | 0 | 0 | ||
process queue reference | 2 | 0.00 | 0 | 0 | ||
qmn task queue latch | 520 | 0.19 | 1.00 | 0 | 0 | |
query server freelists | 2 | 0.00 | 0 | 0 | ||
queued dump request | 12 | 0.00 | 0 | 0 | ||
queuing load statistics | 2 | 0.00 | 0 | 0 | ||
recovery domain hash list | 2 | 0.00 | 0 | 0 | ||
redo allocation | 132,458 | 0.08 | 1.00 | 1 | 189,969 | 0.07 |
redo copy | 150 | 4.67 | 1.00 | 0 | 189,884 | 0.15 |
redo writing | 110,655 | 0.00 | 1.00 | 0 | 0 | |
resmgr group change latch | 268,298 | 0.00 | 0 | 0 | ||
resmgr:active threads | 409 | 0.00 | 0 | 0 | ||
resmgr:actses change group | 88 | 0.00 | 0 | 0 | ||
resmgr:actses change state | 2 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 407 | 0.00 | 0 | 0 | ||
resmgr:plan CPU method | 2 | 0.00 | 0 | 0 | ||
resmgr:resource group CPU method | 2 | 0.00 | 0 | 0 | ||
resmgr:schema config | 2 | 0.00 | 0 | 0 | ||
resmgr:session queuing | 2 | 0.00 | 0 | 0 | ||
rm cas latch | 2 | 0.00 | 0 | 0 | ||
row cache objects | 613,453 | 0.03 | 1.00 | 3 | 0 | |
rules engine aggregate statistics | 1 | 0.00 | 0 | 0 | ||
rules engine rule set statistics | 202 | 0.00 | 0 | 0 | ||
second Audit Vault latch | 2 | 0.00 | 0 | 0 | ||
second spare latch | 2 | 0.00 | 0 | 0 | ||
sequence cache | 30,584 | 0.01 | 1.00 | 0 | 0 | |
session allocation | 118,911 | 0.01 | 1.00 | 0 | 0 | |
session idle bit | 108,773 | 0.00 | 0 | 0 | ||
session queue latch | 2 | 0.00 | 0 | 0 | ||
session state list latch | 465 | 0.00 | 0 | 0 | ||
session switching | 748 | 0.00 | 0 | 0 | ||
session timer | 1,184 | 0.00 | 0 | 0 | ||
shared pool | 21,814 | 0.01 | 1.00 | 0 | 0 | |
shared pool sim alloc | 4 | 0.00 | 0 | 0 | ||
shared pool simulator | 70 | 0.00 | 0 | 0 | ||
sim partition latch | 2 | 0.00 | 0 | 0 | ||
simulator hash latch | 115,644 | 0.00 | 1.00 | 0 | 0 | |
simulator lru latch | 5,347 | 0.04 | 1.00 | 0 | 104,867 | 0.38 |
sort extent pool | 108 | 0.00 | 0 | 0 | ||
space background state object latch | 9 | 0.00 | 0 | 0 | ||
space background task latch | 4,063 | 0.22 | 1.11 | 0 | 2,371 | 0.00 |
state object free list | 2 | 0.00 | 0 | 0 | ||
statistics aggregation | 560 | 0.00 | 0 | 0 | ||
tablespace key chain | 2 | 0.00 | 0 | 0 | ||
temp lob duration state obj allocation | 2 | 0.00 | 0 | 0 | ||
test excl. parent l0 | 2 | 0.00 | 0 | 0 | ||
test excl. parent2 l0 | 2 | 0.00 | 0 | 0 | ||
third spare latch | 2 | 0.00 | 0 | 0 | ||
threshold alerts latch | 143 | 0.00 | 0 | 0 | ||
transaction allocation | 910 | 0.00 | 0 | 0 | ||
undo global data | 193,615 | 0.00 | 0 | 0 | ||
virtual circuit buffers | 2 | 0.00 | 0 | 0 | ||
virtual circuit holder | 2 | 0.00 | 0 | 0 | ||
virtual circuit queues | 2 | 0.00 | 0 | 0 |
Latch Name | Get Requests | Misses | Sleeps | Spin Gets |
---|---|---|---|---|
cache buffers chains | 4,862,566 | 779 | 327 | 452 |
client/application info | 902,294 | 665 | 666 | 0 |
cache buffers lru chain | 149,042 | 449 | 455 | 2 |
row cache objects | 613,453 | 200 | 200 | 0 |
redo allocation | 132,458 | 108 | 108 | 0 |
object queue header operation | 358,954 | 102 | 103 | 0 |
In memory undo latch | 209,326 | 67 | 67 | 0 |
enqueue hash chains | 266,872 | 25 | 25 | 0 |
messages | 157,985 | 10 | 10 | 0 |
space background task latch | 4,063 | 9 | 10 | 0 |
redo copy | 150 | 7 | 7 | 0 |
session allocation | 118,911 | 7 | 7 | 0 |
shared pool | 21,814 | 3 | 3 | 0 |
DML lock allocation | 135,031 | 2 | 2 | 0 |
redo writing | 110,655 | 2 | 2 | 0 |
sequence cache | 30,584 | 2 | 2 | 0 |
simulator lru latch | 5,347 | 2 | 2 | 0 |
call allocation | 1,082 | 1 | 1 | 0 |
checkpoint queue latch | 138,179 | 1 | 1 | 0 |
qmn task queue latch | 520 | 1 | 1 | 0 |
simulator hash latch | 115,644 | 1 | 1 | 0 |
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
DML lock allocation | ktaiam | 0 | 1 | 1 |
DML lock allocation | ktaidm | 0 | 1 | 1 |
In memory undo latch | ktiFlush: child | 0 | 34 | 61 |
In memory undo latch | kticmt: child | 0 | 25 | 1 |
In memory undo latch | ktichg: child | 0 | 7 | 3 |
In memory undo latch | ktiFlushMe | 0 | 1 | 0 |
cache buffers chains | kcbgtcr: fast path (cr pin) | 0 | 110 | 25 |
cache buffers chains | kcbgtcr: fast path | 0 | 97 | 51 |
cache buffers chains | kcbgcur: fast path (shr) | 0 | 60 | 6 |
cache buffers chains | kcbget: pin buffer | 0 | 20 | 74 |
cache buffers chains | kcbgtcr: kslbegin shared | 0 | 11 | 2 |
cache buffers chains | kcbgcur_2 | 0 | 10 | 15 |
cache buffers chains | kcbchg1: kslbegin: bufs not pinned | 0 | 7 | 1 |
cache buffers chains | kcbnlc | 0 | 6 | 3 |
cache buffers chains | kcbget: exchange | 0 | 1 | 51 |
cache buffers chains | kcbnew: new latch again | 0 | 1 | 0 |
cache buffers chains | kcbrls_1 | 0 | 1 | 66 |
cache buffers chains | kcbzgb: scan from tail. nowait | 0 | 1 | 0 |
cache buffers chains | kcbzibmlt: multi-block read: nowait | 0 | 1 | 0 |
cache buffers chains | kcbzwb | 0 | 1 | 0 |
cache buffers lru chain | kcbzgws_1 | 0 | 437 | 436 |
cache buffers lru chain | kcbbxsv: move to being written | 0 | 10 | 0 |
cache buffers lru chain | kcbgtcr:CR Scan:KCBRSKIP_2 | 0 | 4 | 0 |
cache buffers lru chain | kcbzgb | 0 | 2 | 1 |
cache buffers lru chain | kcbbic2 | 0 | 1 | 18 |
cache buffers lru chain | kcbzswcu | 0 | 1 | 0 |
call allocation | ksudlp: top call | 0 | 1 | 0 |
checkpoint queue latch | kcbklbc_cql | 0 | 1 | 0 |
client/application info | ksuinfos_modact | 0 | 416 | 563 |
client/application info | kskirefrattrmap | 0 | 250 | 103 |
enqueue hash chains | ksqrcl | 0 | 17 | 0 |
enqueue hash chains | ksqgtl3 | 0 | 8 | 25 |
messages | ksaamb: after wakeup | 0 | 7 | 5 |
messages | ksarcv | 0 | 3 | 1 |
object queue header operation | kcbo_switch_cq | 0 | 46 | 39 |
object queue header operation | kcbo_unlink_q | 0 | 21 | 50 |
object queue header operation | kcbo_link_q | 0 | 16 | 7 |
object queue header operation | kcbo_switch_q_bg | 0 | 13 | 0 |
object queue header operation | kcbo_switch_mq_bg | 0 | 7 | 5 |
qmn task queue latch | kwqmnmvtsks: delay to ready list | 0 | 1 | 0 |
redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 94 | 0 |
redo allocation | kcrfw_post: more space | 0 | 10 | 2 |
redo allocation | kcrfw_redo_gen: redo allocation 3 | 0 | 2 | 63 |
redo allocation | kcrfw_redo_write: before write | 0 | 2 | 43 |
redo copy | kcrfw_redo_gen: nowait | 0 | 7 | 0 |
redo writing | kcrfw_cal_target_rba | 0 | 1 | 1 |
redo writing | kcrfwcr | 0 | 1 | 0 |
row cache objects | kqreqd: reget | 0 | 180 | 0 |
row cache objects | kqrpre: find obj | 0 | 17 | 199 |
row cache objects | kqreqd | 0 | 3 | 1 |
sequence cache | kdnssd | 0 | 2 | 0 |
session allocation | ksucri_int : SSO | 0 | 4 | 6 |
session allocation | ksuxds | 0 | 3 | 1 |
shared pool | kghalo | 0 | 2 | 1 |
shared pool | kghfre | 0 | 1 | 2 |
simulator hash latch | kcbs_lookup_setid: lookup dba | 0 | 1 | 0 |
simulator lru latch | kcbs_simulate: simulate set | 0 | 2 | 0 |
space background task latch | ktsjCreateTask | 0 | 6 | 0 |
space background task latch | ktsj_grab_task | 0 | 4 | 10 |
Mutex Type | Location | Sleeps | Wait Time (ms) |
---|---|---|---|
Library Cache | kglpndl1 95 | 55 | 1,422 |
Library Cache | kglpin1 4 | 53 | 3,257 |
Cursor Pin | kksfbc [KKSCHLFSP2] | 31 | 775 |
Library Cache | kglhdgn2 106 | 25 | 676 |
Library Cache | kglget1 1 | 10 | 278 |
Library Cache | kglobpn1 71 | 6 | 107 |
Cursor Stat | kkocsStoreBindAwareStats [KKSSTALOC8] | 1 | 10 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
---|---|---|---|---|---|---|
SOE | SWINGBENCH | INVENTORY_PK | INDEX | 377,616 | 19.50 | |
SOE | SWINGBENCH | INVENTORIES | TABLE | 163,248 | 8.43 | |
SOE | SWINGBENCH | PRD_DESC_PK | INDEX | 137,568 | 7.10 | |
SOE | SWINGBENCH | PRODUCT_INFORMATION_PK | INDEX | 127,872 | 6.60 | |
SOE | SWINGBENCH | ORDER_PK | INDEX | 126,496 | 6.53 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
SOE | SWINGBENCH | CUSTOMERS | TABLE | 17,196 | 21.39 | |
SOE | SWINGBENCH | CUSTOMERS_PK | INDEX | 14,632 | 18.20 | |
SOE | SWINGBENCH | INVENTORIES | TABLE | 13,690 | 17.03 | |
SOE | SWINGBENCH | ORDER_ITEMS_PK | INDEX | 8,658 | 10.77 | |
SOE | SWINGBENCH | ORD_CUSTOMER_IX | INDEX | 8,145 | 10.13 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Read Requests | %Total |
---|---|---|---|---|---|---|
SOE | SWINGBENCH | CUSTOMERS | TABLE | 17,196 | 22.09 | |
SOE | SWINGBENCH | CUSTOMERS_PK | INDEX | 14,632 | 18.79 | |
SOE | SWINGBENCH | INVENTORIES | TABLE | 13,690 | 17.58 | |
SOE | SWINGBENCH | ORDER_ITEMS_PK | INDEX | 8,658 | 11.12 | |
SOE | SWINGBENCH | ORD_CUSTOMER_IX | INDEX | 8,145 | 10.46 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | UnOptimized Reads | %Total |
---|---|---|---|---|---|---|
SOE | SWINGBENCH | CUSTOMERS | TABLE | 17,196 | 22.09 | |
SOE | SWINGBENCH | CUSTOMERS_PK | INDEX | 14,632 | 18.79 | |
SOE | SWINGBENCH | INVENTORIES | TABLE | 13,690 | 17.58 | |
SOE | SWINGBENCH | ORDER_ITEMS_PK | INDEX | 8,658 | 11.12 | |
SOE | SWINGBENCH | ORD_CUSTOMER_IX | INDEX | 8,145 | 10.46 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Writes | %Total |
---|---|---|---|---|---|---|
SOE | SWINGBENCH | INVENTORIES | TABLE | 16,954 | 29.24 | |
SOE | SWINGBENCH | ORD_CUSTOMER_IX | INDEX | 7,175 | 12.37 | |
SOE | SWINGBENCH | ORDER_ITEMS_PK | INDEX | 7,060 | 12.17 | |
SOE | SWINGBENCH | ITEM_ORDER_IX | INDEX | 7,017 | 12.10 | |
SOE | SWINGBENCH | ITEM_PRODUCT_IX | INDEX | 6,217 | 10.72 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Write Requests | %Total |
---|---|---|---|---|---|---|
SOE | SWINGBENCH | INVENTORIES | TABLE | 12,079 | 27.42 | |
SOE | SWINGBENCH | ORDER_ITEMS_PK | INDEX | 7,060 | 16.03 | |
SOE | SWINGBENCH | ITEM_ORDER_IX | INDEX | 7,017 | 15.93 | |
SOE | SWINGBENCH | ORD_CUSTOMER_IX | INDEX | 6,770 | 15.37 | |
SOE | SWINGBENCH | ITEM_PRODUCT_IX | INDEX | 4,683 | 10.63 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Writes | %Total |
---|---|---|---|---|---|---|
SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_196335337_58 | TABLE PARTITION | 5 | 83.33 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Table Scans | %Total |
---|---|---|---|---|---|---|
SYS | SYSTEM | I_OBJ2 | INDEX | 4 | 80.00 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | DB Block Changes | % of Capture |
---|---|---|---|---|---|---|
SOE | SWINGBENCH | ORDER_ITEMS | TABLE | 21,760 | 16.50 | |
SOE | SWINGBENCH | ITEM_PRODUCT_IX | INDEX | 21,264 | 16.12 | |
SOE | SWINGBENCH | INVENTORIES | TABLE | 19,552 | 14.82 | |
SOE | SWINGBENCH | ORDER_ITEMS_PK | INDEX | 19,200 | 14.56 | |
SOE | SWINGBENCH | ITEM_ORDER_IX | INDEX | 18,928 | 14.35 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
---|---|---|---|---|---|---|
SOE | SWINGBENCH | CUST_EMAIL_IX | INDEX | 15 | 20.00 | |
SOE | SWINGBENCH | CUST_ACCOUNT_MANAGER_IX | INDEX | 12 | 16.00 | |
SOE | SWINGBENCH | ORD_STATUS_IX | INDEX | 12 | 16.00 | |
SOE | SWINGBENCH | ORDERS | TABLE | 10 | 13.33 | |
SOE | SWINGBENCH | ORDER_PK | INDEX | 9 | 12.00 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
---|---|---|---|---|---|---|
SOE | SWINGBENCH | ORDER_PK | INDEX | 22 | 43.14 | |
SOE | SWINGBENCH | LOGON | TABLE | 13 | 25.49 | |
SOE | SWINGBENCH | ORDERS | TABLE | 8 | 15.69 | |
SOE | SWINGBENCH | ORDER_ITEMS | TABLE | 6 | 11.76 | |
SOE | SWINGBENCH | ORD_STATUS_IX | INDEX | 2 | 3.92 |
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
---|---|---|---|---|---|---|
dc_awr_control | 65 | 0.00 | 0 | 2 | 1 | |
dc_files | 6 | 0.00 | 0 | 0 | 6 | |
dc_global_oids | 48,851 | 0.00 | 0 | 0 | 76 | |
dc_histogram_data | 622 | 0.00 | 0 | 0 | 2,138 | |
dc_histogram_defs | 838 | 0.00 | 0 | 0 | 5,633 | |
dc_objects | 49,854 | 0.00 | 0 | 5 | 3,049 | |
dc_profiles | 69 | 0.00 | 0 | 0 | 1 | |
dc_rollback_segments | 849 | 0.00 | 0 | 0 | 22 | |
dc_segments | 82 | 0.00 | 0 | 21 | 976 | |
dc_sequences | 10 | 0.00 | 0 | 10 | 17 | |
dc_tablespaces | 22,645 | 0.00 | 0 | 0 | 9 | |
dc_users | 78,505 | 0.00 | 0 | 0 | 311 | |
global database name | 2,444 | 0.00 | 0 | 0 | 1 | |
outstanding_alerts | 32 | 3.13 | 0 | 1 | 7 | |
sch_lj_oids | 5 | 0.00 | 0 | 0 | 9 |
Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
---|---|---|---|---|---|---|
BODY | 1,056 | 0.00 | 106,922 | 0.00 | 0 | 0 |
CLUSTER | 3 | 0.00 | 3 | 0.00 | 0 | 0 |
DBLINK | 2 | 0.00 | 0 | 0 | 0 | |
EDITION | 82 | 0.00 | 149 | 0.00 | 0 | 0 |
INDEX | 18 | 0.00 | 18 | 0.00 | 0 | 0 |
QUEUE | 75 | 0.00 | 237 | 0.00 | 0 | 0 |
RULESET | 0 | 1 | 0.00 | 0 | 0 | |
SCHEMA | 67 | 0.00 | 0 | 0 | 0 | |
SQL AREA | 1,324 | 0.53 | 225,585 | 0.02 | 0 | 0 |
SQL AREA BUILD | 13 | 53.85 | 0 | 0 | 0 | |
SQL AREA STATS | 13 | 100.00 | 13 | 100.00 | 0 | 0 |
SUBSCRIPTION | 8 | 0.00 | 8 | 0.00 | 0 | 0 |
TABLE/PROCEDURE | 24,659 | 0.00 | 142,203 | 0.00 | 0 | 0 |
TRIGGER | 182 | 0.00 | 236 | 0.00 | 0 | 0 |
Component | Begin Snap Size (Mb) | Current Size (Mb) | Min Size (Mb) | Max Size (Mb) | Oper Count | Last Op Typ/Mod |
---|---|---|---|---|---|---|
ASM Buffer Cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
DEFAULT 16K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
DEFAULT 2K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
DEFAULT 32K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
DEFAULT 4K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
DEFAULT 8K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
DEFAULT buffer cache | 188.00 | 188.00 | 188.00 | 188.00 | 0 | INI/ |
KEEP buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
PGA Target | 280.00 | 280.00 | 280.00 | 280.00 | 0 | STA/ |
RECYCLE buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
SGA Target | 524.00 | 524.00 | 524.00 | 524.00 | 0 | STA/ |
Shared IO Pool | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
java pool | 28.00 | 28.00 | 28.00 | 28.00 | 0 | STA/ |
large pool | 4.00 | 4.00 | 4.00 | 4.00 | 0 | STA/ |
shared pool | 288.00 | 288.00 | 288.00 | 288.00 | 0 | STA/ |
streams pool | 8.00 | 8.00 | 8.00 | 8.00 | 0 | STA/ |
Category | Alloc (MB) | Used (MB) | Avg Alloc (MB) | Std Dev Alloc (MB) | Max Alloc (MB) | Hist Max Alloc (MB) | Num Proc | Num Alloc | |
---|---|---|---|---|---|---|---|---|---|
B | Other | 76.05 | 1.77 | 1.88 | 11 | 17 | 43 | 43 | |
Freeable | 46.88 | 0.00 | 1.67 | 2.43 | 13 | 28 | 28 | ||
PL/SQL | 3.25 | 0.97 | 0.08 | 0.10 | 0 | 11 | 41 | 41 | |
SQL | 1.53 | 0.20 | 0.05 | 0.05 | 0 | 6 | 30 | 24 | |
E | Other | 75.23 | 1.79 | 1.89 | 11 | 17 | 42 | 42 | |
Freeable | 46.63 | 0.00 | 1.73 | 2.55 | 13 | 27 | 27 | ||
PL/SQL | 3.20 | 0.93 | 0.08 | 0.09 | 0 | 11 | 40 | 40 | |
SQL | 2.77 | 1.43 | 0.10 | 0.26 | 1 | 6 | 29 | 24 |
SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
---|---|---|
Database Buffers | 197,132,288 | |
Fixed Size | 2,231,128 | |
Redo Buffers | 2,383,872 | |
Variable Size | 637,535,400 |
Pool | Name | Begin MB | End MB | % Diff |
---|---|---|---|---|
java | free memory | 28.00 | 28.00 | 0.00 |
large | PX msg pool | 0.47 | 0.47 | 0.00 |
large | free memory | 3.53 | 3.53 | 0.00 |
shared | FileOpenBlock | 3.80 | 3.80 | 0.00 |
shared | KCB Table Scan Buffer | 3.80 | 3.80 | 0.00 |
shared | KGLH0 | 39.37 | 39.56 | 0.47 |
shared | KGLHD | 8.77 | 8.79 | 0.22 |
shared | KGLS | 17.38 | 17.38 | 0.00 |
shared | KGLSG | 5.02 | 5.02 | 0.00 |
shared | KQR L PO | 3.28 | 3.28 | 0.03 |
shared | KQR M PO | 3.55 | 3.55 | 0.00 |
shared | KSFD SGA I/O b | 3.79 | 3.79 | 0.00 |
shared | PLDIA | 8.59 | 8.59 | 0.00 |
shared | PLMCD | 8.59 | 8.59 | 0.00 |
shared | SQLA | 52.98 | 53.71 | 1.38 |
shared | event statistics per sess | 3.08 | 3.08 | 0.00 |
shared | free memory | 56.94 | 56.02 | -1.62 |
shared | kglsim hash table bkts | 4.00 | 4.00 | 0.00 |
shared | private strands | 3.51 | 3.51 | 0.00 |
shared | row cache | 7.24 | 7.24 | 0.00 |
streams | free memory | 8.00 | 8.00 | 0.00 |
buffer_cache | 188.00 | 188.00 | 0.00 | |
fixed_sga | 2.13 | 2.13 | 0.00 | |
log_buffer | 2.27 | 2.27 | 0.00 |
Session Type | First Logon | CPU time(s) | User IO Wait time(s) | SYS IO Wait time(s) |
---|---|---|---|---|
QMON Slaves | 1005 12:53:22 | 3.16 | 0.04 | 0.00 |
QMON Coordinator | 1005 12:53:11 | 0.34 | 0.00 | 0.00 |
Rule | Evals | No-SQL Eval% | SQL Execs | CPU(s) | Ela(s) | Eval /Sec | SQL per Eval | Ela(s) per Eval | CPU(s) per Eval | Reloads |
---|---|---|---|---|---|---|---|---|---|---|
SYS.ALERT_QUE_R | 1 | 0.00 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 |
Queue Name | Enq Msgs | Deq Msgs | %Exp Msgs | %Delay Msgs | Enq Time(s) | Deq Time(s) | %Transf Time | %Eval Time |
---|---|---|---|---|---|---|---|---|
SYS.ALERT_QUE(12343) | 1 | 0 | 100.00 | 0.00 | 0.00 | 0.00 | 0.00 | 9.51 |
SYS.AQ$_ALERT_QT_E(12342) | 2 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
SYSMAN.MGMT_TASK_Q(66573) | 64 | 64 | 0.00 | 0.00 | 0.12 | 1.10 | 0.00 | 0.00 |
Queue Name | Enqueue Msgs/sec | Dequeue Msgs/sec | Avg Enqueue sec / msg | Avg Dequeue sec / msg |
---|---|---|---|---|
SYS.ALERT_QUE(12343) | 0.00 | 0.00 | 0.00 | |
SYS.AQ$_ALERT_QT_E(12342) | 0.00 | 0.00 | 0.00 | |
SYSMAN.MGMT_TASK_Q(66573) | 0.02 | 0.02 | 0.00 | 0.02 |
Subscriber/Queue | Enqueue Msgs | Dequeue Msgs | Expire Msgs | Enqueue Msgs/sec | Dequeue Msgs/sec | Expire Msgs/sec |
---|---|---|---|---|---|---|
HAE_SUB(1)/SYS.ALERT_QUE | 0 | 0 | 0 | |||
OEL5_11GR2_DE_3938_DB11G(22)/SYS.ALERT_QUE | 1 | 0 | 2 | 0.00 | 0.00 | 0.00 |
Avg Total Connections | Avg Active Connections | Avg Total Shared Srvrs | Avg Active Shared Srvrs | Avg Total Dispatchers | Avg Active Dispatchers |
---|---|---|---|---|---|
0 | 0 | 1 | 0 | 1 | 0 |
Common Queue Per Sec | Disp Queue Per Sec | Server Msgs/Sec | Server KB/Sec | Common Queue Total | Disp Queue Total | Server Total Msgs | Server Total(KB) |
---|---|---|---|---|---|---|---|
0 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 |
Total Server Time (s) | %Busy | %Idle | Incoming Net % | Outgoing Net % |
---|---|---|---|---|
3,563 | 0.00 | 100.00 | 0.00 | 0.00 |
Name | Avg Conns | Total Disp Time (s) | %Busy | %Idle | Total Queued | Total Queue Wait (s) | Avg Queue Wait (ms) |
---|---|---|---|---|---|---|---|
D000 | 0.00 | 3,563 | 0.00 | 100.00 | 0 | 0 |
Parameter Name | Begin value | End value (if different) |
---|---|---|
audit_file_dest | /u01/app/oracle/admin/DB11G/adump | |
audit_trail | DB | |
compatible | 11.2.0.0.0 | |
control_files | /u01/app/oracle/oradata/DB11G/control01.ctl, /u01/app/oracle/flash_recovery_area/DB11G/control02.ctl | |
db_block_size | 8192 | |
db_create_file_dest | /u01/app/oracle/oradata/DB11G/ | |
db_domain | WORLD | |
db_name | DB11G | |
db_recovery_file_dest | /u01/app/oracle/flash_recovery_area | |
db_recovery_file_dest_size | 4070572032 | |
diagnostic_dest | /u01/app/oracle | |
dispatchers | (PROTOCOL=TCP) (SERVICE=DB11GXDB) | |
event | ||
memory_target | 843055104 | |
open_cursors | 300 | |
processes | 150 | |
remote_login_passwordfile | EXCLUSIVE | |
undo_tablespace | UNDOTBS1 |
Parameter Name | Begin value | End value (if different) |
---|---|---|
control_files | /u01/app/oracle/flash_recovery_area/DB11G/control02.ctl | |
/u01/app/oracle/oradata/DB11G/control01.ctl |