DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
---|---|---|---|---|---|---|
LINUXS | 570420430 | linuxs | 1 | 24-Sep-09 17:09 | 11.2.0.1.0 | NO |
Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
---|---|---|---|---|---|
stadf26 | Linux IA (32-bit) | 2 | 1 | 1 | 1.98 |
Snap Id | Snap Time | Sessions | Cursors/Session | |
---|---|---|---|---|
Begin Snap: | 876 | 25-Sep-09 11:46:45 | 28 | 1.3 |
End Snap: | 877 | 25-Sep-09 11:51:33 | 28 | 1.3 |
Elapsed: | 4.80 (mins) | |||
DB Time: | 79.35 (mins) |
Begin | End | |||
---|---|---|---|---|
Buffer Cache: | 16M | 16M | Std Block Size: | 8K |
Shared Pool Size: | 100M | 100M | Log Buffer: | 6,504K |
Per Second | Per Transaction | Per Exec | Per Call | |
---|---|---|---|---|
DB Time(s): | 16.5 | 0.3 | 0.08 | 0.04 |
DB CPU(s): | 1.7 | 0.0 | 0.01 | 0.00 |
Redo size: | 1,515,864.8 | 22,955.0 | ||
Logical reads: | 33,745.2 | 511.0 | ||
Block changes: | 10,803.2 | 163.6 | ||
Physical reads: | 1.8 | 0.0 | ||
Physical writes: | 85.1 | 1.3 | ||
User calls: | 396.7 | 6.0 | ||
Parses: | 2.7 | 0.0 | ||
Hard parses: | 0.1 | 0.0 | ||
W/A MB processed: | 0.2 | 0.0 | ||
Logons: | 0.1 | 0.0 | ||
Executes: | 211.7 | 3.2 | ||
Rollbacks: | 0.0 | 0.0 | ||
Transactions: | 66.0 |
Buffer Nowait %: | 96.34 | Redo NoWait %: | 100.00 |
Buffer Hit %: | 100.00 | In-memory Sort %: | 100.00 |
Library Hit %: | 99.88 | Soft Parse %: | 97.44 |
Execute to Parse %: | 98.72 | Latch Hit %: | 98.90 |
Parse CPU to Parse Elapsd %: | 64.71 | % Non-Parse CPU: | 99.95 |
Begin | End | |
---|---|---|
Memory Usage %: | 92.79 | 92.96 |
% SQL with executions>1: | 61.56 | 72.59 |
% Memory for SQL w/exec>1: | 44.53 | 67.62 |
Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
---|---|---|---|---|---|
buffer busy waits | 251,810 | 2,738 | 11 | 57.51 | Concurrency |
enq: TX - row lock contention | 8,254 | 883 | 107 | 18.55 | Application |
DB CPU | 483 | 10.14 | |||
log file sync | 18,534 | 262 | 14 | 5.51 | Commit |
latch: cache buffers chains | 11,173 | 97 | 9 | 2.03 | Concurrency |
Load Average Begin | Load Average End | %User | %System | %WIO | %Idle |
---|---|---|---|---|---|
1.17 | 5.65 | 73.5 | 19.1 | 2.2 | 7.2 |
%Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) |
---|---|---|
85.9 | 92.5 | 0.0 |
Begin | End | |
---|---|---|
Host Mem (MB): | 2,025.4 | 2,025.4 |
SGA use (MB): | 171.6 | 171.6 |
PGA use (MB): | 44.3 | 45.1 |
% Host Mem used for SGA+PGA: | 10.66 | 10.70 |
Statistic Name | Time (s) | % of DB Time |
---|---|---|
sql execute elapsed time | 4,456.18 | 93.60 |
DB CPU | 482.95 | 10.14 |
parse time elapsed | 0.29 | 0.01 |
connection management call elapsed time | 0.27 | 0.01 |
hard parse elapsed time | 0.13 | 0.00 |
PL/SQL execution elapsed time | 0.12 | 0.00 |
repeated bind elapsed time | 0.00 | 0.00 |
DB time | 4,760.81 | |
background elapsed time | 159.74 | |
background cpu time | 11.51 |
Statistic | Value | End Value |
---|---|---|
BUSY_TIME | 53,431 | |
IDLE_TIME | 4,155 | |
IOWAIT_TIME | 1,279 | |
NICE_TIME | 0 | |
SYS_TIME | 10,997 | |
USER_TIME | 42,328 | |
LOAD | 1 | 6 |
PHYSICAL_MEMORY_BYTES | 2,123,755,520 | |
NUM_CPUS | 2 | |
NUM_CPU_CORES | 1 | |
NUM_CPU_SOCKETS | 1 | |
GLOBAL_RECEIVE_SIZE_MAX | 524,288 | |
GLOBAL_SEND_SIZE_MAX | 524,288 | |
TCP_RECEIVE_SIZE_DEFAULT | 87,380 | |
TCP_RECEIVE_SIZE_MAX | 174,760 | |
TCP_RECEIVE_SIZE_MIN | 4,096 | |
TCP_SEND_SIZE_DEFAULT | 16,384 | |
TCP_SEND_SIZE_MAX | 131,072 | |
TCP_SEND_SIZE_MIN | 4,096 |
Snap Time | Load | %busy | %user | %sys | %idle | %iowait |
---|---|---|---|---|---|---|
25-Sep 11:46:45 | 1.17 | |||||
25-Sep 11:51:33 | 5.65 | 92.78 | 73.50 | 19.10 | 7.22 | 2.22 |
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %DB time |
---|---|---|---|---|---|
Concurrency | 271,432 | 0 | 2,870 | 11 | 60.28 |
Application | 8,254 | 0 | 883 | 107 | 18.55 |
DB CPU | 483 | 10.14 | |||
Commit | 18,534 | 0 | 262 | 14 | 5.51 |
Network | 114,145 | 0 | 1 | 0 | 0.02 |
Configuration | 36 | 0 | 1 | 29 | 0.02 |
Other | 115 | 9 | 1 | 7 | 0.02 |
User I/O | 491 | 0 | 0 | 0 | 0.00 |
System I/O | 81 | 0 | 0 | 0 | 0.00 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % DB time |
---|---|---|---|---|---|---|
buffer busy waits | 251,810 | 0 | 2,738 | 11 | 13.25 | 57.51 |
enq: TX - row lock contention | 8,254 | 0 | 883 | 107 | 0.43 | 18.55 |
log file sync | 18,534 | 0 | 262 | 14 | 0.97 | 5.51 |
latch: cache buffers chains | 11,173 | 0 | 97 | 9 | 0.59 | 2.03 |
latch: In memory undo latch | 8,437 | 0 | 34 | 4 | 0.44 | 0.72 |
SQL*Net message to client | 114,145 | 0 | 1 | 0 | 6.00 | 0.02 |
log file switch (checkpoint incomplete) | 25 | 0 | 1 | 36 | 0.00 | 0.02 |
cursor: pin S | 9 | 0 | 1 | 73 | 0.00 | 0.01 |
latch free | 47 | 0 | 0 | 7 | 0.00 | 0.01 |
latch: enqueue hash chains | 33 | 0 | 0 | 8 | 0.00 | 0.01 |
direct path write temp | 51 | 0 | 0 | 2 | 0.00 | 0.00 |
log file switch (private strand flush incomplete) | 1 | 0 | 0 | 79 | 0.00 | 0.00 |
latch: session allocation | 8 | 0 | 0 | 9 | 0.00 | 0.00 |
cursor: pin S wait on X | 3 | 0 | 0 | 24 | 0.00 | 0.00 |
latch: undo global data | 10 | 0 | 0 | 5 | 0.00 | 0.00 |
log file switch completion | 5 | 0 | 0 | 10 | 0.00 | 0.00 |
enq: HW - contention | 5 | 0 | 0 | 6 | 0.00 | 0.00 |
latch: messages | 4 | 0 | 0 | 7 | 0.00 | 0.00 |
Disk file operations I/O | 31 | 0 | 0 | 1 | 0.00 | 0.00 |
db file sequential read | 396 | 0 | 0 | 0 | 0.02 | 0.00 |
direct path sync | 1 | 0 | 0 | 9 | 0.00 | 0.00 |
latch: object queue header operation | 3 | 0 | 0 | 2 | 0.00 | 0.00 |
control file sequential read | 81 | 0 | 0 | 0 | 0.00 | 0.00 |
SQL*Net message from client | 114,145 | 0 | 1,252 | 11 | 6.00 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
---|---|---|---|---|---|---|
log file parallel write | 32,144 | 0 | 78 | 2 | 1.69 | 49.03 |
db file async I/O submit | 263 | 0 | 47 | 180 | 0.01 | 29.68 |
LGWR wait for redo copy | 2,478 | 0 | 7 | 3 | 0.13 | 4.60 |
control file parallel write | 401 | 0 | 5 | 12 | 0.02 | 2.95 |
db file single write | 60 | 0 | 1 | 18 | 0.00 | 0.69 |
enq: CF - contention | 1 | 0 | 0 | 340 | 0.00 | 0.21 |
control file sequential read | 815 | 0 | 0 | 0 | 0.04 | 0.19 |
latch: redo allocation | 32 | 0 | 0 | 5 | 0.00 | 0.11 |
latch: cache buffers chains | 5 | 0 | 0 | 18 | 0.00 | 0.06 |
log file single write | 40 | 0 | 0 | 1 | 0.00 | 0.03 |
latch free | 5 | 0 | 0 | 8 | 0.00 | 0.02 |
latch: cache buffers lru chain | 1 | 0 | 0 | 18 | 0.00 | 0.01 |
latch: redo writing | 1 | 0 | 0 | 11 | 0.00 | 0.01 |
latch: object queue header operation | 1 | 0 | 0 | 10 | 0.00 | 0.01 |
latch: messages | 2 | 0 | 0 | 5 | 0.00 | 0.01 |
db file sequential read | 102 | 0 | 0 | 0 | 0.01 | 0.00 |
rdbms ipc message | 16,713 | 7 | 3,012 | 180 | 0.88 | |
EMON slave idle wait | 285 | 100 | 1,433 | 5028 | 0.01 | |
DIAG idle wait | 563 | 100 | 575 | 1021 | 0.03 | |
smon timer | 1 | 100 | 300 | 300021 | 0.00 | |
Streams AQ: emn coordinator idle wait | 29 | 100 | 291 | 10026 | 0.00 | |
Space Manager: slave idle wait | 58 | 98 | 290 | 5005 | 0.00 | |
pmon timer | 192 | 48 | 289 | 1505 | 0.01 | |
Streams AQ: qmn coordinator idle wait | 17 | 59 | 280 | 16496 | 0.00 | |
Streams AQ: qmn slave idle wait | 10 | 0 | 280 | 28040 | 0.00 | |
SQL*Net message from client | 80 | 0 | 0 | 1 | 0.00 |
% of Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Total Waits | <1ms | <2ms | <4ms | <8ms | <16ms | <32ms | <=1s | >1s |
Disk file operations I/O | 31 | 96.8 | 3.2 | ||||||
LGWR wait for redo copy | 2478 | 58.1 | 10.0 | 11.1 | 11.9 | 6.7 | 1.8 | .5 | |
SQL*Net message to client | 114.2K | 100.0 | .0 | .0 | .0 | .0 | .0 | .0 | |
asynch descriptor resize | 30 | 100.0 | |||||||
buffer busy waits | 251.8K | 37.7 | 22.8 | 6.4 | 5.7 | 6.7 | 9.7 | 11.0 | |
control file parallel write | 401 | 50.1 | 7.7 | 8.7 | 9.5 | 11.2 | 8.2 | 4.5 | |
control file sequential read | 896 | 99.9 | .1 | ||||||
cursor: pin S | 9 | 100.0 | |||||||
cursor: pin S wait on X | 3 | 33.3 | 33.3 | 33.3 | |||||
db file async I/O submit | 263 | .8 | 1.9 | 2.7 | 1.9 | 3.0 | 4.6 | 84.4 | .8 |
db file sequential read | 510 | 99.8 | .2 | ||||||
db file single write | 60 | 31.7 | 10.0 | 10.0 | 8.3 | 13.3 | 21.7 | 5.0 | |
direct path read temp | 9 | 100.0 | |||||||
direct path sync | 1 | 100.0 | |||||||
direct path write | 3 | 100.0 | |||||||
direct path write temp | 51 | 66.7 | 9.8 | 9.8 | 7.8 | 5.9 | |||
enq: CF - contention | 1 | 100.0 | |||||||
enq: HW - contention | 5 | 80.0 | 20.0 | ||||||
enq: TX - row lock contention | 8254 | .2 | .3 | .8 | 1.9 | 5.6 | 12.4 | 78.7 | .2 |
latch free | 52 | 21.2 | 7.7 | 11.5 | 32.7 | 11.5 | 11.5 | 3.8 | |
latch: In memory undo latch | 8438 | 60.5 | 6.6 | 7.8 | 8.9 | 10.3 | 4.8 | 1.0 | |
latch: cache buffers chains | 11.2K | 33.0 | 5.4 | 9.7 | 14.0 | 19.9 | 14.6 | 3.4 | |
latch: cache buffers lru chain | 1 | 100.0 | |||||||
latch: enqueue hash chains | 33 | 6.1 | 9.1 | 24.2 | 21.2 | 24.2 | 15.2 | ||
latch: messages | 6 | 33.3 | 33.3 | 33.3 | |||||
latch: object queue header operation | 4 | 25.0 | 50.0 | 25.0 | |||||
latch: redo allocation | 32 | 40.6 | 3.1 | 12.5 | 28.1 | 9.4 | 6.3 | ||
latch: redo writing | 1 | 100.0 | |||||||
latch: session allocation | 8 | 50.0 | 12.5 | 12.5 | 12.5 | 12.5 | |||
latch: undo global data | 10 | 20.0 | 10.0 | 10.0 | 50.0 | 10.0 | |||
log file parallel write | 32.1K | 66.9 | 10.3 | 7.2 | 8.0 | 5.3 | 1.9 | .4 | .0 |
log file sequential read | 40 | 100.0 | |||||||
log file single write | 40 | 80.0 | 2.5 | 7.5 | 7.5 | 2.5 | |||
log file switch (checkpoint incomplete) | 25 | 8.0 | 36.0 | 16.0 | 16.0 | 24.0 | |||
log file switch (private strand flush incomplete) | 1 | 100.0 | |||||||
log file switch completion | 5 | 100.0 | |||||||
log file sync | 18.5K | 4.2 | 13.3 | 16.2 | 23.3 | 25.6 | 12.9 | 4.4 | .1 |
DIAG idle wait | 563 | 92.7 | 7.3 | ||||||
EMON slave idle wait | 287 | 100.0 | |||||||
SQL*Net message from client | 114.2K | 72.2 | 6.7 | 5.5 | 5.7 | 6.2 | 2.9 | .8 | .0 |
Space Manager: slave idle wait | 58 | 100.0 | |||||||
Streams AQ: emn coordinator idle wait | 29 | 100.0 | |||||||
Streams AQ: qmn coordinator idle wait | 17 | 11.8 | 5.9 | 17.6 | 5.9 | 58.8 | |||
Streams AQ: qmn slave idle wait | 10 | 100.0 | |||||||
pmon timer | 192 | 4.2 | .5 | 1.0 | 37.0 | 57.3 | |||
rdbms ipc message | 16.7K | 22.6 | 1.4 | 5.0 | 13.0 | 26.3 | 18.6 | 7.9 | 5.2 |
smon timer | 1 | 100.0 |
% of Total Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Waits 64ms to 2s | <32ms | <64ms | <1/8s | <1/4s | <1/2s | <1s | <2s | >=2s |
LGWR wait for redo copy | 13 | 99.5 | .2 | .1 | .1 | .0 | |||
SQL*Net message to client | 2 | 100.0 | .0 | .0 | |||||
buffer busy waits | 27.7K | 89.0 | 8.3 | 2.3 | .2 | .1 | .0 | ||
control file parallel write | 18 | 95.5 | 2.5 | .2 | .5 | 1.0 | .2 | ||
control file sequential read | 1 | 99.9 | .1 | ||||||
cursor: pin S | 9 | 44.4 | 55.6 | ||||||
cursor: pin S wait on X | 1 | 66.7 | 33.3 | ||||||
db file async I/O submit | 224 | 14.8 | 6.8 | 16.0 | 46.0 | 13.3 | 2.3 | .8 | |
db file single write | 3 | 95.0 | 1.7 | 3.3 | |||||
enq: CF - contention | 1 | 100.0 | |||||||
enq: TX - row lock contention | 6511 | 21.1 | 23.8 | 26.8 | 21.1 | 6.7 | .5 | .2 | |
latch free | 2 | 96.2 | 3.8 | ||||||
latch: In memory undo latch | 87 | 99.0 | .8 | .1 | .1 | .1 | |||
latch: cache buffers chains | 377 | 96.6 | 3.0 | .2 | .1 | .1 | |||
latch: session allocation | 1 | 87.5 | 12.5 | ||||||
log file parallel write | 144 | 99.6 | .3 | .1 | .0 | .0 | .0 | .0 | |
log file switch (checkpoint incomplete) | 6 | 76.0 | 16.0 | 4.0 | 4.0 | ||||
log file switch (private strand flush incomplete) | 1 | 100.0 | |||||||
log file sync | 832 | 95.5 | 2.7 | .4 | .6 | .5 | .2 | .1 |
Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) |
---|---|---|---|---|
SYS$USERS | 4,761 | 483 | 0 | 9,714 |
SYS$BACKGROUND | 0 | 0 | 0 | 1 |
linuxs.regress.rdbms.dev.us.oracle.com | 0 | 0 | 0 | 0 |
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 |
---|---|---|---|---|---|---|---|---|
SYS$USERS | 491 | 0 | 271432 | 2870 | 0 | 0 | 114145 | 1 |
SYS$BACKGROUND | 162 | 1 | 6 | 0 | 0 | 0 | 0 | 0 |
Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
4,024.85 | 20,000 | 0.20 | 84.54 | 6.64 | 0.00 | b6vvz2u69xdma | stage5@stadf26 (TNS V1-V3) | update myemp set sal = :sal wh... |
404.83 | 20,000 | 0.02 | 8.50 | 41.41 | 0.00 | 087hdmn8v6ur7 | stage4@stadf26 (TNS V1-V3) | select empno, ename from myemp... |
6.18 | 19,999 | 0.00 | 0.13 | 64.98 | 0.02 | 9whcc4w2ws87n | stage5@stadf26 (TNS V1-V3) | select region_id, region_name ... |
0.72 | 1 | 0.72 | 0.02 | 82.79 | 16.42 | 2ntzsd2w869g8 | sqlplus@stadf26 (TNS V1-V3) | begin :bid := DBMS_WORKLOAD_RE... |
0.48 | 1 | 0.48 | 0.01 | 11.24 | 89.95 | 5dfmd823r8dsp | insert into wrh$_memory_resize... | |
0.16 | 18 | 0.01 | 0.00 | 10.46 | 0.42 | 65ybjbqzzub8u | select regflags, numobjs, obja... | |
0.16 | 1 | 0.16 | 0.00 | 86.68 | 0.23 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
0.09 | 189 | 0.00 | 0.00 | 48.74 | 0.00 | bsa0wjtftg3uw | select file# from file$ where ... | |
0.09 | 9 | 0.01 | 0.00 | 73.07 | 2.36 | 718d4y9b3fqtz | MMON_SLAVE | update CRC$_RESULT_CACHE_STATS... |
0.08 | 1 | 0.08 | 0.00 | 90.07 | 12.42 | fdjtrdaz8hpvg | INSERT /*+ APPEND LEADING(@"SE... |
CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
267.39 | 20,000 | 0.01 | 55.37 | 4,024.85 | 6.64 | 0.00 | b6vvz2u69xdma | stage5@stadf26 (TNS V1-V3) | update myemp set sal = :sal wh... |
167.65 | 20,000 | 0.01 | 34.71 | 404.83 | 41.41 | 0.00 | 087hdmn8v6ur7 | stage4@stadf26 (TNS V1-V3) | select empno, ename from myemp... |
4.01 | 19,999 | 0.00 | 0.83 | 6.18 | 64.98 | 0.02 | 9whcc4w2ws87n | stage5@stadf26 (TNS V1-V3) | select region_id, region_name ... |
0.60 | 1 | 0.60 | 0.12 | 0.72 | 82.79 | 16.42 | 2ntzsd2w869g8 | sqlplus@stadf26 (TNS V1-V3) | begin :bid := DBMS_WORKLOAD_RE... |
0.14 | 1 | 0.14 | 0.03 | 0.16 | 86.68 | 0.23 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
0.07 | 1 | 0.07 | 0.01 | 0.08 | 90.07 | 12.42 | fdjtrdaz8hpvg | INSERT /*+ APPEND LEADING(@"SE... | |
0.06 | 9 | 0.01 | 0.01 | 0.09 | 73.07 | 2.36 | 718d4y9b3fqtz | MMON_SLAVE | update CRC$_RESULT_CACHE_STATS... |
0.06 | 2 | 0.03 | 0.01 | 0.07 | 89.96 | 0.77 | bxk1rxvzpa7kj | select a.next_start_date, a.ob... | |
0.05 | 1 | 0.05 | 0.01 | 0.48 | 11.24 | 89.95 | 5dfmd823r8dsp | insert into wrh$_memory_resize... | |
0.04 | 189 | 0.00 | 0.01 | 0.09 | 48.74 | 0.00 | bsa0wjtftg3uw | select file# from file$ where ... |
User I/O Time (s) | Executions | UIO per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
0.43 | 1 | 0.43 | 34.64 | 0.48 | 11.24 | 89.95 | 5dfmd823r8dsp | insert into wrh$_memory_resize... | |
0.12 | 1 | 0.12 | 9.49 | 0.72 | 82.79 | 16.42 | 2ntzsd2w869g8 | sqlplus@stadf26 (TNS V1-V3) | begin :bid := DBMS_WORKLOAD_RE... |
0.01 | 20,000 | 0.00 | 1.09 | 4,024.85 | 6.64 | 0.00 | b6vvz2u69xdma | stage5@stadf26 (TNS V1-V3) | update myemp set sal = :sal wh... |
0.01 | 1 | 0.01 | 0.80 | 0.08 | 90.07 | 12.42 | fdjtrdaz8hpvg | INSERT /*+ APPEND LEADING(@"SE... | |
0.00 | 19 | 0.00 | 0.29 | 0.02 | 54.71 | 19.81 | 9tgj4g8y4rwy8 | select type#, blocks, extents,... | |
0.00 | 9 | 0.00 | 0.17 | 0.09 | 73.07 | 2.36 | 718d4y9b3fqtz | MMON_SLAVE | update CRC$_RESULT_CACHE_STATS... |
0.00 | 11 | 0.00 | 0.13 | 0.00 | 123.90 | 33.64 | 3nkd3g3ju5ph1 | select obj#, type#, ctime, mti... | |
0.00 | 19,999 | 0.00 | 0.12 | 6.18 | 64.98 | 0.02 | 9whcc4w2ws87n | stage5@stadf26 (TNS V1-V3) | select region_id, region_name ... |
0.00 | 20,000 | 0.00 | 0.07 | 404.83 | 41.41 | 0.00 | 087hdmn8v6ur7 | stage4@stadf26 (TNS V1-V3) | select empno, ename from myemp... |
0.00 | 18 | 0.00 | 0.06 | 0.16 | 10.46 | 0.42 | 65ybjbqzzub8u | select regflags, numobjs, obja... |
Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
6,308,624 | 20,000 | 315.43 | 64.94 | 404.83 | 41.41 | 0.00 | 087hdmn8v6ur7 | stage4@stadf26 (TNS V1-V3) | select empno, ename from myemp... |
3,324,222 | 20,000 | 166.21 | 34.22 | 4,024.85 | 6.64 | 0.00 | b6vvz2u69xdma | stage5@stadf26 (TNS V1-V3) | update myemp set sal = :sal wh... |
56,331 | 19,999 | 2.82 | 0.58 | 6.18 | 64.98 | 0.02 | 9whcc4w2ws87n | stage5@stadf26 (TNS V1-V3) | select region_id, region_name ... |
4,263 | 1 | 4,263.00 | 0.04 | 0.72 | 82.79 | 16.42 | 2ntzsd2w869g8 | sqlplus@stadf26 (TNS V1-V3) | begin :bid := DBMS_WORKLOAD_RE... |
1,009 | 1 | 1,009.00 | 0.01 | 0.16 | 86.68 | 0.23 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
750 | 1 | 750.00 | 0.01 | 0.02 | 103.77 | 0.45 | 7qjhf5dzmazsr | SELECT snap_id , OBJ#, DATAOBJ... | |
385 | 189 | 2.04 | 0.00 | 0.09 | 48.74 | 0.00 | bsa0wjtftg3uw | select file# from file$ where ... | |
352 | 1 | 352.00 | 0.00 | 0.08 | 90.07 | 12.42 | fdjtrdaz8hpvg | INSERT /*+ APPEND LEADING(@"SE... | |
255 | 9 | 28.33 | 0.00 | 0.09 | 73.07 | 2.36 | 718d4y9b3fqtz | MMON_SLAVE | update CRC$_RESULT_CACHE_STATS... |
221 | 66 | 3.35 | 0.00 | 0.02 | 104.52 | 0.54 | 5h7w8ykwtb2xt | INSERT INTO SYS.WRI$_ADV_PARAM... |
Physical Reads | Executions | Reads per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
400 | 1 | 400.00 | 79.37 | 0.72 | 82.79 | 16.42 | 2ntzsd2w869g8 | sqlplus@stadf26 (TNS V1-V3) | begin :bid := DBMS_WORKLOAD_RE... |
63 | 1 | 63.00 | 12.50 | 0.48 | 11.24 | 89.95 | 5dfmd823r8dsp | insert into wrh$_memory_resize... | |
15 | 1 | 15.00 | 2.98 | 0.08 | 90.07 | 12.42 | fdjtrdaz8hpvg | INSERT /*+ APPEND LEADING(@"SE... | |
14 | 1 | 14.00 | 2.78 | 0.16 | 86.68 | 0.23 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
13 | 2 | 6.50 | 2.58 | 0.07 | 89.96 | 0.77 | bxk1rxvzpa7kj | select a.next_start_date, a.ob... | |
12 | 1 | 12.00 | 2.38 | 0.02 | 98.26 | 1.53 | f0s0bk5k713yb | insert into wrh$_parameter (sn... | |
11 | 1 | 11.00 | 2.18 | 0.01 | 104.71 | 1.71 | 586b2udq6dbng | insert into wrh$_sysstat (snap... | |
10 | 1 | 10.00 | 1.98 | 0.02 | 101.14 | 1.44 | 84qubbrsr0kfn | insert into wrh$_latch (snap_i... | |
10 | 22 | 0.45 | 1.98 | 0.01 | 103.16 | 6.50 | 96g93hntrzjtr | select /*+ rule */ bucket_cnt,... | |
9 | 1 | 9.00 | 1.79 | 0.02 | 100.87 | 0.82 | 5ax5xu96u2ztd | insert into WRH$_EVENT_HISTOGR... | |
9 | 19,999 | 0.00 | 1.79 | 6.18 | 64.98 | 0.02 | 9whcc4w2ws87n | stage5@stadf26 (TNS V1-V3) | select region_id, region_name ... |
8 | 11 | 0.73 | 1.59 | 0.00 | 123.90 | 33.64 | 3nkd3g3ju5ph1 | select obj#, type#, ctime, mti... | |
8 | 1 | 8.00 | 1.59 | 0.03 | 86.37 | 1.04 | bd4bznqbq73hk | select bo#, intcol# from icold... | |
7 | 9 | 0.78 | 1.39 | 0.09 | 73.07 | 2.36 | 718d4y9b3fqtz | MMON_SLAVE | update CRC$_RESULT_CACHE_STATS... |
7 | 1 | 7.00 | 1.39 | 0.00 | 80.97 | 3.08 | 7g732rx16j8jc | insert into WRH$_SERVICE_STAT ... | |
7 | 5 | 1.40 | 1.39 | 0.03 | 52.24 | 0.75 | 7ng34ruy5awxq | select i.obj#, i.ts#, i.file#,... | |
6 | 1 | 6.00 | 1.19 | 0.00 | 111.17 | 12.45 | 350myuyx0t1d6 | insert into wrh$_tablespace_st... | |
6 | 1 | 6.00 | 1.19 | 0.01 | 104.70 | 1.73 | 4dy1xm4nxc0gf | insert into wrh$_system_event ... | |
6 | 1 | 6.00 | 1.19 | 0.04 | 88.32 | 0.59 | 4rm4183czbs7j | select value, flags, modified_... | |
6 | 19 | 0.32 | 1.19 | 0.02 | 54.71 | 19.81 | 9tgj4g8y4rwy8 | select type#, blocks, extents,... | |
6 | 20,000 | 0.00 | 1.19 | 4,024.85 | 6.64 | 0.00 | b6vvz2u69xdma | stage5@stadf26 (TNS V1-V3) | update myemp set sal = :sal wh... |
UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
430 | 430 | 1 | 430.00 | 0.00 | 95.56 | 2ntzsd2w869g8 | sqlplus@stadf26 (TNS V1-V3) | begin :bid := DBMS_WORKLOAD_RE... |
25 | 25 | 1 | 25.00 | 0.00 | 5.56 | 1cq3qr774cu45 | insert into WRH$_IOSTAT_FILETY... | |
15 | 15 | 1 | 15.00 | 0.00 | 3.33 | fdjtrdaz8hpvg | INSERT /*+ APPEND LEADING(@"SE... | |
13 | 13 | 2 | 6.50 | 0.00 | 2.89 | bxk1rxvzpa7kj | select a.next_start_date, a.ob... | |
11 | 11 | 1 | 11.00 | 0.00 | 2.44 | 71y370j6428cb | insert into wrh$_thread (snap_... | |
10 | 10 | 22 | 0.45 | 0.00 | 2.22 | 96g93hntrzjtr | select /*+ rule */ bucket_cnt,... | |
9 | 9 | 1 | 9.00 | 0.00 | 2.00 | 5dfmd823r8dsp | insert into wrh$_memory_resize... | |
9 | 9 | 19,999 | 0.00 | 0.00 | 2.00 | 9whcc4w2ws87n | stage5@stadf26 (TNS V1-V3) | select region_id, region_name ... |
8 | 8 | 1 | 8.00 | 0.00 | 1.78 | bd4bznqbq73hk | select bo#, intcol# from icold... | |
7 | 7 | 9 | 0.78 | 0.00 | 1.56 | 718d4y9b3fqtz | MMON_SLAVE | update CRC$_RESULT_CACHE_STATS... |
7 | 7 | 5 | 1.40 | 0.00 | 1.56 | 7ng34ruy5awxq | select i.obj#, i.ts#, i.file#,... | |
6 | 6 | 1 | 6.00 | 0.00 | 1.33 | 4rm4183czbs7j | select value, flags, modified_... | |
6 | 6 | 19 | 0.32 | 0.00 | 1.33 | 9tgj4g8y4rwy8 | select type#, blocks, extents,... | |
6 | 6 | 20,000 | 0.00 | 0.00 | 1.33 | b6vvz2u69xdma | stage5@stadf26 (TNS V1-V3) | update myemp set sal = :sal wh... |
5 | 5 | 20,000 | 0.00 | 0.00 | 1.11 | 087hdmn8v6ur7 | stage4@stadf26 (TNS V1-V3) | select empno, ename from myemp... |
5 | 5 | 66 | 0.08 | 0.00 | 1.11 | 5h7w8ykwtb2xt | INSERT INTO SYS.WRI$_ADV_PARAM... |
Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
20,000 | 140,680 | 7.03 | 404.83 | 41.41 | 0.00 | 087hdmn8v6ur7 | stage4@stadf26 (TNS V1-V3) | select empno, ename from myemp... |
20,000 | 1,520,000 | 76.00 | 4,024.85 | 6.64 | 0.00 | b6vvz2u69xdma | stage5@stadf26 (TNS V1-V3) | update myemp set sal = :sal wh... |
19,999 | 20,000 | 1.00 | 6.18 | 64.98 | 0.02 | 9whcc4w2ws87n | stage5@stadf26 (TNS V1-V3) | select region_id, region_name ... |
189 | 189 | 1.00 | 0.09 | 48.74 | 0.00 | bsa0wjtftg3uw | select file# from file$ where ... | |
66 | 66 | 1.00 | 0.02 | 104.52 | 0.54 | 5h7w8ykwtb2xt | INSERT INTO SYS.WRI$_ADV_PARAM... | |
58 | 0 | 0.00 | 0.01 | 135.65 | 0.00 | fq69qg96cd1x1 | STREAMS | select /*+ FIRST_ROWS(1) */ ta... |
57 | 0 | 0.00 | 0.02 | 34.89 | 0.00 | 5ms6rbzdnq16t | select job, nvl2(last_date, 1,... | |
40 | 0 | 0.00 | 0.01 | 109.41 | 0.00 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
36 | 19 | 0.53 | 0.01 | 74.03 | 0.00 | 14s9r0q98gw40 | select queryId, queryflags, se... | |
22 | 18 | 0.82 | 0.01 | 103.16 | 6.50 | 96g93hntrzjtr | select /*+ rule */ bucket_cnt,... |
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
189 | 189 | 24.17 | bsa0wjtftg3uw | select file# from file$ where ... | |
40 | 40 | 5.12 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
36 | 36 | 4.60 | 14s9r0q98gw40 | select queryId, queryflags, se... | |
20 | 20,000 | 2.56 | 087hdmn8v6ur7 | stage4@stadf26 (TNS V1-V3) | select empno, ename from myemp... |
20 | 20 | 2.56 | 0k8522rmdzg4k | select privilege# from sysauth... | |
20 | 20 | 2.56 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
20 | 20 | 2.56 | 459f3z9u4fb3u | select value$ from props$ wher... | |
20 | 20 | 2.56 | 4vs91dcv7u1p6 | stage5@stadf26 (TNS V1-V3) | insert into sys.aud$( sessioni... |
20 | 20 | 2.56 | 5ur69atw3vfhj | select decode(failover_method,... | |
20 | 19,999 | 2.56 | 9whcc4w2ws87n | stage5@stadf26 (TNS V1-V3) | select region_id, region_name ... |
20 | 20,000 | 2.56 | b6vvz2u69xdma | stage5@stadf26 (TNS V1-V3) | update myemp set sal = :sal wh... |
20 | 20 | 2.56 | f711myt0q6cma | stage5@stadf26 (TNS V1-V3) | insert into sys.aud$( sessioni... |
19 | 19 | 2.43 | 9tgj4g8y4rwy8 | select type#, blocks, extents,... | |
18 | 18 | 2.30 | 65ybjbqzzub8u | select regflags, numobjs, obja... | |
9 | 9 | 1.15 | 718d4y9b3fqtz | MMON_SLAVE | update CRC$_RESULT_CACHE_STATS... |
8 | 8 | 1.02 | f3223cb4ng6hq | select next_run_date, obj#, ru... |
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 | 0 | 0.00 | 0.00 |
Batched IO buffer defrag count | 0 | 0.00 | 0.00 |
Batched IO double miss count | 0 | 0.00 | 0.00 |
Batched IO same unit count | 0 | 0.00 | 0.00 |
Batched IO single block count | 0 | 0.00 | 0.00 |
Batched IO vector block count | 0 | 0.00 | 0.00 |
Batched IO vector read count | 0 | 0.00 | 0.00 |
Block Cleanout Optim referenced | 2 | 0.01 | 0.00 |
CCursor + sql area evicted | 0 | 0.00 | 0.00 |
CPU used by this session | 47,429 | 164.75 | 2.49 |
CPU used when call started | 47,382 | 164.59 | 2.49 |
CR blocks created | 12,411 | 43.11 | 0.65 |
Commit SCN cached | 193 | 0.67 | 0.01 |
DB time | 475,529 | 1,651.79 | 25.01 |
DBWR checkpoint buffers written | 570 | 1.98 | 0.03 |
DBWR checkpoints | 20 | 0.07 | 0.00 |
DBWR thread checkpoint buffers written | 570 | 1.98 | 0.03 |
DBWR transaction table writes | 309 | 1.07 | 0.02 |
DBWR undo block writes | 23,340 | 81.07 | 1.23 |
HSC Heap Segment Block Changes | 1,520,516 | 5,281.64 | 79.98 |
Heap Segment Array Inserts | 77 | 0.27 | 0.00 |
Heap Segment Array Updates | 184 | 0.64 | 0.01 |
IMU CR rollbacks | 10,549 | 36.64 | 0.55 |
IMU Flushes | 10,529 | 36.57 | 0.55 |
IMU Redo allocation size | 58,929,176 | 204,695.51 | 3,099.74 |
IMU commits | 447 | 1.55 | 0.02 |
IMU contention | 10,438 | 36.26 | 0.55 |
IMU pool not allocated | 8,544 | 29.68 | 0.45 |
IMU recursive-transaction flush | 1 | 0.00 | 0.00 |
IMU undo allocation size | 75,333,404 | 261,676.99 | 3,962.62 |
IMU- failed to get a private strand | 2,518 | 8.75 | 0.13 |
LOB table id lookup cache misses | 0 | 0.00 | 0.00 |
PX local messages recv'd | 0 | 0.00 | 0.00 |
PX local messages sent | 0 | 0.00 | 0.00 |
SMON posted for undo segment shrink | 0 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 114,145 | 396.49 | 6.00 |
active txn count during cleanout | 247,733 | 860.52 | 13.03 |
application wait time | 88,333 | 306.83 | 4.65 |
background checkpoints completed | 20 | 0.07 | 0.00 |
background checkpoints started | 20 | 0.07 | 0.00 |
background timeouts | 1,192 | 4.14 | 0.06 |
buffer is not pinned count | 102,946 | 357.59 | 5.42 |
buffer is pinned count | 4,043 | 14.04 | 0.21 |
bytes received via SQL*Net from client | 18,786,531 | 65,256.61 | 988.19 |
bytes sent via SQL*Net to client | 19,757,599 | 68,629.70 | 1,039.27 |
calls to get snapshot scn: kcmgss | 1,700,392 | 5,906.46 | 89.44 |
calls to kcmgas | 59,369 | 206.22 | 3.12 |
calls to kcmgcs | 82,260 | 285.74 | 4.33 |
cell physical IO interconnect bytes | 680,854,016 | 2,365,004.38 | 35,813.69 |
change write time | 6,290 | 21.85 | 0.33 |
cleanout - number of ktugct calls | 27,891 | 96.88 | 1.47 |
cleanouts and rollbacks - consistent read gets | 14,299 | 49.67 | 0.75 |
cleanouts only - consistent read gets | 7 | 0.02 | 0.00 |
cluster key scan block gets | 64 | 0.22 | 0.00 |
cluster key scans | 48 | 0.17 | 0.00 |
commit batch/immediate performed | 0 | 0.00 | 0.00 |
commit batch/immediate requested | 0 | 0.00 | 0.00 |
commit cleanout failures: block lost | 0 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 205 | 0.71 | 0.01 |
commit cleanout failures: cannot pin | 2,270 | 7.89 | 0.12 |
commit cleanouts | 19,406 | 67.41 | 1.02 |
commit cleanouts successfully completed | 16,931 | 58.81 | 0.89 |
commit immediate performed | 0 | 0.00 | 0.00 |
commit immediate requested | 0 | 0.00 | 0.00 |
commit txn count during cleanout | 3,887 | 13.50 | 0.20 |
concurrency wait time | 286,980 | 996.85 | 15.10 |
consistent changes | 6,136,561 | 21,315.87 | 322.79 |
consistent gets | 8,087,379 | 28,092.20 | 425.41 |
consistent gets - examination | 6,407,810 | 22,258.07 | 337.06 |
consistent gets from cache | 8,087,379 | 28,092.20 | 425.41 |
consistent gets from cache (fastpath) | 1,665,811 | 5,786.34 | 87.62 |
cursor authentications | 6 | 0.02 | 0.00 |
data blocks consistent reads - undo records applied | 6,125,526 | 21,277.54 | 322.21 |
db block changes | 3,110,097 | 10,803.19 | 163.59 |
db block gets | 1,627,419 | 5,652.98 | 85.60 |
db block gets direct | 19 | 0.07 | 0.00 |
db block gets from cache | 1,627,400 | 5,652.91 | 85.60 |
db block gets from cache (fastpath) | 733 | 2.55 | 0.04 |
deferred (CURRENT) block cleanout applications | 8,772 | 30.47 | 0.46 |
dirty buffers inspected | 21,783 | 75.67 | 1.15 |
enqueue conversions | 99 | 0.34 | 0.01 |
enqueue releases | 69,390 | 241.03 | 3.65 |
enqueue requests | 69,406 | 241.09 | 3.65 |
enqueue timeouts | 16 | 0.06 | 0.00 |
enqueue waits | 8,260 | 28.69 | 0.43 |
execute count | 60,957 | 211.74 | 3.21 |
file io service time | 0 | 0.00 | 0.00 |
file io wait time | 47,032,587 | 163,371.69 | 2,473.97 |
free buffer inspected | 25,125 | 87.27 | 1.32 |
free buffer requested | 42,892 | 148.99 | 2.26 |
heap block compress | 1,700 | 5.91 | 0.09 |
hot buffers moved to head of LRU | 442 | 1.54 | 0.02 |
immediate (CR) block cleanout applications | 14,306 | 49.69 | 0.75 |
immediate (CURRENT) block cleanout applications | 57 | 0.20 | 0.00 |
index crx upgrade (positioned) | 0 | 0.00 | 0.00 |
index fast full scans (full) | 0 | 0.00 | 0.00 |
index fetch by key | 1,600,669 | 5,560.06 | 84.20 |
index scans kdiixs1 | 2,745 | 9.53 | 0.14 |
leaf node 90-10 splits | 13 | 0.05 | 0.00 |
leaf node splits | 18 | 0.06 | 0.00 |
lob reads | 0 | 0.00 | 0.00 |
lob writes | 1 | 0.00 | 0.00 |
lob writes unaligned | 1 | 0.00 | 0.00 |
logons cumulative | 20 | 0.07 | 0.00 |
max cf enq hold time | 510 | 1.77 | 0.03 |
messages received | 16,647 | 57.82 | 0.88 |
messages sent | 16,648 | 57.83 | 0.88 |
min active SCN optimization applied on CR | 0 | 0.00 | 0.00 |
no buffer to keep pinned count | 20 | 0.07 | 0.00 |
no work - consistent read gets | 1,582,384 | 5,496.55 | 83.24 |
non-idle wait count | 870,359 | 3,023.27 | 45.78 |
non-idle wait time | 415,837 | 1,444.45 | 21.87 |
opened cursors cumulative | 926 | 3.22 | 0.05 |
parse count (describe) | 0 | 0.00 | 0.00 |
parse count (failures) | 0 | 0.00 | 0.00 |
parse count (hard) | 20 | 0.07 | 0.00 |
parse count (total) | 782 | 2.72 | 0.04 |
parse time cpu | 22 | 0.08 | 0.00 |
parse time elapsed | 34 | 0.12 | 0.00 |
physical read IO requests | 450 | 1.56 | 0.02 |
physical read bytes | 4,128,768 | 14,341.63 | 217.18 |
physical read total IO requests | 1,449 | 5.03 | 0.08 |
physical read total bytes | 19,378,176 | 67,311.74 | 1,019.31 |
physical read total multi block requests | 0 | 0.00 | 0.00 |
physical reads | 504 | 1.75 | 0.03 |
physical reads cache | 441 | 1.53 | 0.02 |
physical reads cache prefetch | 0 | 0.00 | 0.00 |
physical reads direct | 63 | 0.22 | 0.00 |
physical reads direct temporary tablespace | 63 | 0.22 | 0.00 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 20,267 | 70.40 | 1.07 |
physical write bytes | 200,613,888 | 696,849.42 | 10,552.52 |
physical write total IO requests | 37,132 | 128.98 | 1.95 |
physical write total bytes | 661,475,840 | 2,297,692.64 | 34,794.37 |
physical write total multi block requests | 219 | 0.76 | 0.01 |
physical writes | 24,489 | 85.06 | 1.29 |
physical writes direct | 376 | 1.31 | 0.02 |
physical writes direct temporary tablespace | 357 | 1.24 | 0.02 |
physical writes from cache | 24,113 | 83.76 | 1.27 |
physical writes non checkpoint | 24,055 | 83.56 | 1.27 |
pinned buffers inspected | 128 | 0.44 | 0.01 |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
prefetched blocks aged out before use | 0 | 0.00 | 0.00 |
recovery blocks read | 0 | 0.00 | 0.00 |
recursive calls | 28,490 | 98.96 | 1.50 |
recursive cpu usage | 716 | 2.49 | 0.04 |
redo blocks checksummed by FG (exclusive) | 87,121 | 302.62 | 4.58 |
redo blocks read for recovery | 0 | 0.00 | 0.00 |
redo blocks written | 888,657 | 3,086.83 | 46.74 |
redo buffer allocation retries | 31 | 0.11 | 0.00 |
redo entries | 1,381,973 | 4,800.40 | 72.69 |
redo entries for lost write detection | 418 | 1.45 | 0.02 |
redo k-bytes read for recovery | 0 | 0.00 | 0.00 |
redo k-bytes read total | 0 | 0.00 | 0.00 |
redo log space requests | 60 | 0.21 | 0.00 |
redo log space wait time | 102 | 0.35 | 0.01 |
redo ordering marks | 22,372 | 77.71 | 1.18 |
redo size | 436,397,768 | 1,515,864.79 | 22,955.01 |
redo size for direct writes | 156 | 0.54 | 0.01 |
redo size for lost write detection | 21,736 | 75.50 | 1.14 |
redo subscn max counts | 23,426 | 81.37 | 1.23 |
redo synch time | 26,263 | 91.23 | 1.38 |
redo synch writes | 19,053 | 66.18 | 1.00 |
redo wastage | 4,076,460 | 14,159.93 | 214.43 |
redo write time | 8,210 | 28.52 | 0.43 |
redo writes | 16,072 | 55.83 | 0.85 |
rollback changes - undo records applied | 0 | 0.00 | 0.00 |
rollbacks only - consistent read gets | 4,362 | 15.15 | 0.23 |
rows fetched via callback | 422 | 1.47 | 0.02 |
session cursor cache hits | 380 | 1.32 | 0.02 |
session logical reads | 9,714,798 | 33,745.18 | 511.01 |
shared hash latch upgrades - no wait | 24,330 | 84.51 | 1.28 |
shared hash latch upgrades - wait | 1 | 0.00 | 0.00 |
sorts (memory) | 20,233 | 70.28 | 1.06 |
sorts (rows) | 146,510 | 508.91 | 7.71 |
sql area evicted | 2 | 0.01 | 0.00 |
sql area purged | 0 | 0.00 | 0.00 |
summed dirty queue length | 22,381 | 77.74 | 1.18 |
switch current to new buffer | 5,848 | 20.31 | 0.31 |
table fetch by rowid | 2,709 | 9.41 | 0.14 |
table fetch continued row | 0 | 0.00 | 0.00 |
table scan blocks gotten | 39,026 | 135.56 | 2.05 |
table scan rows gotten | 375,868 | 1,305.61 | 19.77 |
table scans (long tables) | 1 | 0.00 | 0.00 |
table scans (short tables) | 38,803 | 134.79 | 2.04 |
temp space allocated (bytes) | 1,048,576 | 3,642.32 | 55.16 |
total cf enq hold time | 3,260 | 11.32 | 0.17 |
total number of cf enq holders | 57 | 0.20 | 0.00 |
total number of times SMON posted | 0 | 0.00 | 0.00 |
transaction rollbacks | 0 | 0.00 | 0.00 |
undo change vector size | 190,097,116 | 660,318.51 | 9,999.32 |
user I/O wait time | 125 | 0.43 | 0.01 |
user calls | 114,216 | 396.74 | 6.01 |
user commits | 19,011 | 66.04 | 1.00 |
user rollbacks | 0 | 0.00 | 0.00 |
workarea executions - onepass | 2 | 0.01 | 0.00 |
workarea executions - optimal | 20,083 | 69.76 | 1.06 |
write clones created in background | 7 | 0.02 | 0.00 |
write clones created in foreground | 299 | 1.04 | 0.02 |
Statistic | Begin Value | End Value |
---|---|---|
opened cursors current | 36 | 37 |
logons current | 28 | 28 |
session uga memory max | 312,827,736 | 321,378,440 |
session pga memory | 85,994,212 | 86,780,644 |
session pga memory max | 100,739,812 | 102,640,356 |
session cursor cache count | 4,403 | 4,625 |
session uga memory | 167,532,557,916 | 167,533,856,268 |
Statistic | Total | per Hour |
---|---|---|
log switches (derived) | 20 | 250.10 |
Function Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
---|---|---|---|---|---|---|---|---|
LGWR | 6M | 1.56 | .020841 | 438M | 58.13 | 1.52143 | 17K | 4.15 |
DBWR | 0M | 0.00 | 0M | 190M | 70.61 | .659981 | 265 | 178.82 |
Others | 7M | 1.91 | .024315 | 4M | 0.91 | .013894 | 1011 | 9.09 |
Buffer Cache Reads | 4M | 1.56 | .013894 | 0M | 0.00 | 0M | 448 | 0.00 |
Direct Writes | 0M | 0.00 | 0M | 3M | 0.19 | .010420 | 54 | 7.52 |
Direct Reads | 1M | 0.03 | .003473 | 0M | 0.00 | 0M | 9 | 0.00 |
TOTAL: | 18M | 5.06 | .062524 | 635M | 129.84 | 2.20572 | 18.7K | 6.79 |
Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read |
---|---|---|---|---|---|---|---|---|
Log File | 0M | 0.14 | 0M | 434M | 57.43 | 1.50753 | 0.00 | |
Data File | 4M | 1.78 | .013894 | 189M | 70.82 | .656507 | 0.00 | |
Control File | 14M | 3.11 | .048630 | 6M | 1.39 | .020841 | 0.31 | |
Temp File | 0M | 0.03 | 0M | 3M | 0.19 | .010420 | 0.00 | |
TOTAL: | 18M | 5.06 | .062524 | 632M | 129.84 | 2.19530 | 0.19 |
Function/File Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
---|---|---|---|---|---|---|---|---|
LGWR | 6M | 1.56 | .020841 | 438M | 58.13 | 1.52143 | 490 | 0.08 |
LGWR (Log File) | 0M | 0.14 | 0M | 434M | 57.43 | 1.50753 | 80 | 0.48 |
LGWR (Control File) | 6M | 1.42 | .020841 | 4M | 0.69 | .013894 | 410 | 0.00 |
DBWR | 0M | 0.00 | 0M | 190M | 70.61 | .659981 | 0 | |
DBWR (Data File) | 0M | 0.00 | 0M | 190M | 70.61 | .659981 | 0 | |
Others | 8M | 1.91 | .027788 | 4M | 0.91 | .013894 | 609 | 2.22 |
Others (Control File) | 8M | 1.69 | .027788 | 3M | 0.70 | .010420 | 486 | 0.58 |
Others (Data File) | 0M | 0.22 | 0M | 1M | 0.21 | .003473 | 123 | 8.70 |
Buffer Cache Reads | 4M | 1.56 | .013894 | 0M | 0.00 | 0M | 448 | 0.00 |
Buffer Cache Reads (Data File) | 4M | 1.56 | .013894 | 0M | 0.00 | 0M | 448 | 0.00 |
Direct Writes | 0M | 0.00 | 0M | 3M | 0.19 | .010420 | 0 | |
Direct Writes (Data File) | 0M | 0.00 | 0M | 3M | 0.19 | .010420 | 0 | |
Direct Reads | 1M | 0.03 | .003473 | 0M | 0.00 | 0M | 0 | |
Direct Reads (Data File) | 1M | 0.03 | .003473 | 0M | 0.00 | 0M | 0 | |
TOTAL: | 19M | 5.06 | .065998 | 635M | 129.84 | 2.20572 | 1547 | 0.90 |
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
UD1 | 14 | 0 | 0.00 | 1.00 | 19,676 | 68 | 27,234 | 2.73 |
SYSAUX | 343 | 1 | 0.03 | 1.00 | 368 | 1 | 0 | 0.00 |
SYSTEM | 78 | 0 | 0.00 | 1.00 | 39 | 0 | 328,487 | 8.10 |
TEMP | 9 | 0 | 0.00 | 7.00 | 54 | 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) |
---|---|---|---|---|---|---|---|---|---|
SYSAUX | /ade/b/3050220379/oracle/dbs/t_ax1.f | 343 | 1 | 0.03 | 1.00 | 368 | 1 | 0 | 0.00 |
SYSTEM | /ade/b/3050220379/oracle/dbs/t_db1.f | 78 | 0 | 0.00 | 1.00 | 39 | 0 | 328,487 | 8.10 |
TEMP | /ade/b/3050220379/oracle/dbs/t_tmp1.f | 9 | 0 | 0.00 | 7.00 | 54 | 0 | 0 | |
UD1 | /ade/b/3050220379/oracle/dbs/t_undo1.f | 14 | 0 | 0.00 | 1.00 | 19,676 | 68 | 27,234 | 2.73 |
P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits |
---|---|---|---|---|---|---|---|---|
D | 1,984 | 100 | 9,714,556 | 444 | 23,965 | 0 | 0 | 355,722 |
MTTR Writes | Log Size Writes | Log Ckpt Writes | Other Settings Writes | Autotune Ckpt Writes | Thread Ckpt Writes |
---|---|---|---|---|---|
0 | 425 | 0 | 0 | 0 | 145 |
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 | 14 | 221 | 12333 | 12404 | 41472 | 12404 | |||
E | 0 | 15 | 869 | 46453 | 41472 | 41472 | 186720 |
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 | 4 | 0.25 | 0 | 2.04 | 72 | 1 | 724.00 |
D | 8 | 0.50 | 1 | 1.42 | 51 | 1 | 506.00 |
D | 12 | 0.75 | 1 | 1.29 | 46 | 1 | 459.00 |
D | 16 | 1.00 | 2 | 1.00 | 36 | 1 | 355.00 |
D | 20 | 1.25 | 2 | 0.92 | 33 | 1 | 328.00 |
D | 24 | 1.50 | 3 | 0.91 | 32 | 1 | 322.00 |
D | 28 | 1.75 | 3 | 0.89 | 32 | 1 | 315.00 |
D | 32 | 2.00 | 4 | 0.87 | 31 | 1 | 309.00 |
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
89.03 | 62 | 8 |
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) | |
---|---|---|---|---|---|---|---|---|
B | 29 | 4 | 44.32 | 0.00 | 0.00 | 0.00 | 0.00 | 5,939 |
E | 29 | 4 | 45.07 | 0.00 | 0.00 | 0.00 | 0.00 | 5,939 |
Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
---|---|---|---|---|---|
2K | 4K | 20,059 | 20,059 | 0 | 0 |
64K | 128K | 2 | 2 | 0 | 0 |
256K | 512K | 2 | 2 | 0 | 0 |
512K | 1024K | 20 | 20 | 0 | 0 |
2M | 4M | 2 | 0 | 2 | 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 |
---|---|---|---|---|---|---|
15 | 0.50 | 480.26 | 15.23 | 97.00 | 3 | 588,955 |
22 | 0.75 | 480.26 | 15.23 | 97.00 | 3 | 588,955 |
29 | 1.00 | 480.26 | 3.81 | 99.00 | 3 | 575,378 |
35 | 1.20 | 480.26 | 3.81 | 99.00 | 2 | 575,378 |
41 | 1.40 | 480.26 | 0.00 | 100.00 | 1 | 570,852 |
46 | 1.60 | 480.26 | 0.00 | 100.00 | 1 | 570,852 |
52 | 1.80 | 480.26 | 0.00 | 100.00 | 1 | 570,852 |
58 | 2.00 | 480.26 | 0.00 | 100.00 | 0 | 570,852 |
87 | 3.00 | 480.26 | 0.00 | 100.00 | 0 | 570,852 |
116 | 4.00 | 480.26 | 0.00 | 100.00 | 0 | 570,852 |
174 | 6.00 | 480.26 | 0.00 | 100.00 | 0 | 570,852 |
232 | 8.00 | 480.26 | 0.00 | 100.00 | 0 | 570,852 |
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) |
---|---|---|---|---|---|---|---|---|
76 | 0.76 | 4 | 235 | 1,769 | 0.99 | 31 | 2.38 | 22 |
88 | 0.88 | 16 | 957 | 1,775 | 0.99 | 25 | 1.92 | 66 |
100 | 1.00 | 27 | 1,720 | 1,787 | 1.00 | 13 | 1.00 | 67 |
112 | 1.12 | 39 | 2,463 | 1,791 | 1.00 | 9 | 0.69 | 68 |
124 | 1.24 | 51 | 3,238 | 1,791 | 1.00 | 9 | 0.69 | 68 |
136 | 1.36 | 58 | 3,767 | 1,791 | 1.00 | 9 | 0.69 | 68 |
148 | 1.48 | 58 | 3,767 | 1,791 | 1.00 | 9 | 0.69 | 68 |
160 | 1.60 | 58 | 3,767 | 1,791 | 1.00 | 9 | 0.69 | 68 |
172 | 1.72 | 58 | 3,767 | 1,791 | 1.00 | 9 | 0.69 | 68 |
184 | 1.84 | 58 | 3,767 | 1,791 | 1.00 | 9 | 0.69 | 68 |
196 | 1.96 | 58 | 3,767 | 1,791 | 1.00 | 9 | 0.69 | 68 |
208 | 2.08 | 58 | 3,767 | 1,791 | 1.00 | 9 | 0.69 | 68 |
Class | Waits | Total Wait Time (s) | Avg Time (ms) |
---|---|---|---|
data block | 328,487 | 2,662 | 8 |
undo block | 26,873 | 73 | 3 |
undo header | 361 | 2 | 5 |
Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
---|---|---|---|---|---|---|
TX-Transaction (row lock contention) | 8,280 | 8,264 | 16 | 8,254 | 883 | 106.97 |
CF-Controlfile Transaction | 247 | 247 | 0 | 1 | 0 | 340.00 |
HW-Segment High Water Mark | 208 | 208 | 0 | 5 | 0 | 6.00 |
Latch Name | Get Requests | Pct Get Miss | Avg Slps /Miss | Wait Time (s) | NoWait Requests | Pct NoWait Miss |
---|---|---|---|---|---|---|
AQ deq hash table latch | 1 | 0.00 | 0 | 0 | ||
ASM db client latch | 206 | 0.00 | 0 | 0 | ||
ASM map operation hash table | 1 | 0.00 | 0 | 0 | ||
ASM network state latch | 97 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 2,202 | 0.00 | 0 | 0 | ||
Change Notification Hash table latch | 3,213,496 | 0.01 | 0.00 | 0 | 0 | |
Change Notification Latch | 76,000 | 0.01 | 0.25 | 0 | 0 | |
Consistent RBA | 16,111 | 0.00 | 0 | 0 | ||
DML lock allocation | 40,536 | 0.02 | 0.56 | 0 | 0 | |
Event Group Locks | 21 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 60 | 0.00 | 0 | 0 | ||
File State Object Pool Parent Latch | 1 | 0.00 | 0 | 0 | ||
IPC stats buffer allocation latch | 1 | 0.00 | 0 | 0 | ||
In memory undo latch | 326,997 | 3.88 | 0.87 | 34 | 14,043 | 0.04 |
JS Sh mem access | 1 | 0.00 | 0 | 0 | ||
JS queue access latch | 1 | 0.00 | 0 | 0 | ||
JS queue state obj latch | 1,710 | 0.00 | 0 | 0 | ||
JS slv state obj latch | 1 | 0.00 | 0 | 0 | ||
KFC FX Hash Latch | 1 | 0.00 | 0 | 0 | ||
KFC Hash Latch | 1 | 0.00 | 0 | 0 | ||
KFCL LE Freelist | 1 | 0.00 | 0 | 0 | ||
KGNFS-NFS:SHM structure | 1 | 0.00 | 0 | 0 | ||
KGNFS-NFS:SVR LIST | 1 | 0.00 | 0 | 0 | ||
KJC message pool free list | 1 | 0.00 | 0 | 0 | ||
KJCT flow control latch | 1 | 0.00 | 0 | 0 | ||
KKCN reg stat latch | 2 | 0.00 | 0 | 0 | ||
KMG MMAN ready and startup request latch | 95 | 0.00 | 0 | 0 | ||
KTF sga latch | 2 | 0.00 | 0 | 97 | 0.00 | |
Locator state objects pool parent latch | 1 | 0.00 | 0 | 0 | ||
Lsod array latch | 1 | 0.00 | 0 | 0 | ||
MQL Tracking Latch | 0 | 0 | 5 | 0.00 | ||
Memory Management Latch | 1 | 0.00 | 0 | 95 | 0.00 | |
Memory Queue | 1 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #1 | 1 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #2 | 1 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #3 | 1 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #4 | 1 | 0.00 | 0 | 0 | ||
Memory Queue Subscriber | 1 | 0.00 | 0 | 0 | ||
MinActiveScn Latch | 2 | 0.00 | 0 | 0 | ||
Mutex | 1 | 0.00 | 0 | 0 | ||
Mutex Stats | 1 | 0.00 | 0 | 0 | ||
OS process | 61 | 0.00 | 0 | 0 | ||
OS process allocation | 136 | 0.00 | 0 | 0 | ||
OS process: request allocation | 40 | 0.00 | 0 | 0 | ||
PL/SQL warning settings | 22 | 0.00 | 0 | 0 | ||
PX hash array latch | 1 | 0.00 | 0 | 0 | ||
QMT | 1 | 0.00 | 0 | 0 | ||
Real-time plan statistics latch | 5 | 0.00 | 0 | 0 | ||
Result Cache: RC Latch | 39,300 | 0.02 | 0.22 | 0 | 0 | |
Result Cache: SO Latch | 40 | 0.00 | 0 | 0 | ||
SGA IO buffer pool latch | 3,445 | 0.00 | 0 | 3,468 | 0.00 | |
SGA blob parent | 1 | 0.00 | 0 | 0 | ||
SGA bucket locks | 1 | 0.00 | 0 | 0 | ||
SGA heap locks | 1 | 0.00 | 0 | 0 | ||
SGA pool locks | 1 | 0.00 | 0 | 0 | ||
SQL memory manager latch | 41 | 0.00 | 0 | 93 | 0.00 | |
SQL memory manager workarea list latch | 9,063 | 0.00 | 0 | 0 | ||
Shared B-Tree | 11 | 0.00 | 0 | 0 | ||
Streams Generic | 1 | 0.00 | 0 | 0 | ||
Testing | 1 | 0.00 | 0 | 0 | ||
Token Manager | 1 | 0.00 | 0 | 0 | ||
WCR: sync | 1 | 0.00 | 0 | 0 | ||
Write State Object Pool Parent Latch | 1 | 0.00 | 0 | 0 | ||
X$KSFQP | 1 | 0.00 | 0 | 0 | ||
XDB NFS Security Latch | 1 | 0.00 | 0 | 0 | ||
XDB unused session pool | 1 | 0.00 | 0 | 0 | ||
XDB used session pool | 1 | 0.00 | 0 | 0 | ||
active checkpoint queue latch | 631 | 0.00 | 0 | 0 | ||
active service list | 678 | 0.00 | 0 | 522 | 0.00 | |
begin backup scn array | 3 | 0.00 | 0 | 0 | ||
buffer pool | 1 | 0.00 | 0 | 0 | ||
business card | 1 | 0.00 | 0 | 0 | ||
cache buffer handles | 39 | 0.00 | 0 | 0 | ||
cache buffers chains | 31,003,538 | 1.26 | 0.05 | 97 | 35,593 | 1.14 |
cache buffers lru chain | 36,466 | 0.02 | 0.11 | 0 | 79,098 | 0.06 |
call allocation | 236 | 0.00 | 0 | 0 | ||
cas latch | 1 | 0.00 | 0 | 0 | ||
change notification client cache latch | 133,046 | 0.00 | 0.00 | 0 | 0 | |
channel handle pool latch | 41 | 0.00 | 0 | 0 | ||
channel operations parent latch | 1,685 | 0.00 | 0 | 0 | ||
checkpoint queue latch | 37,971 | 0.01 | 0.00 | 0 | 24,495 | 0.01 |
client/application info | 141 | 0.00 | 0 | 0 | ||
compile environment latch | 20 | 0.00 | 0 | 0 | ||
cp cmon/server latch | 1 | 0.00 | 0 | 0 | ||
cp pool latch | 1 | 0.00 | 0 | 0 | ||
cp server hash latch | 1 | 0.00 | 0 | 0 | ||
cp sga latch | 97 | 0.00 | 0 | 0 | ||
cvmap freelist lock | 1 | 0.00 | 0 | 0 | ||
deferred cleanup latch | 97 | 0.00 | 0 | 0 | ||
dml lock allocation | 97 | 0.00 | 0 | 0 | ||
done queue latch | 1 | 0.00 | 0 | 0 | ||
dummy allocation | 41 | 0.00 | 0 | 0 | ||
enqueue hash chains | 162,877 | 0.08 | 1.93 | 0 | 276 | 0.00 |
enqueues | 59,908 | 0.10 | 1.57 | 0 | 0 | |
fifth spare latch | 1 | 0.00 | 0 | 0 | ||
file cache latch | 193 | 0.00 | 0 | 0 | ||
flashback copy | 1 | 0.00 | 0 | 0 | ||
gc element | 1 | 0.00 | 0 | 0 | ||
gcs commit scn state | 1 | 0.00 | 0 | 0 | ||
gcs partitioned table hash | 1 | 0.00 | 0 | 0 | ||
gcs pcm hashed value bucket hash | 1 | 0.00 | 0 | 0 | ||
gcs resource freelist | 1 | 0.00 | 0 | 0 | ||
gcs resource hash | 1 | 0.00 | 0 | 0 | ||
gcs resource scan list | 1 | 0.00 | 0 | 0 | ||
gcs shadows freelist | 1 | 0.00 | 0 | 0 | ||
ges domain table | 1 | 0.00 | 0 | 0 | ||
ges enqueue table freelist | 1 | 0.00 | 0 | 0 | ||
ges group table | 1 | 0.00 | 0 | 0 | ||
ges process hash list | 1 | 0.00 | 0 | 0 | ||
ges process parent latch | 1 | 0.00 | 0 | 0 | ||
ges resource hash list | 1 | 0.00 | 0 | 0 | ||
ges resource scan list | 1 | 0.00 | 0 | 0 | ||
ges resource table freelist | 1 | 0.00 | 0 | 0 | ||
ges value block free list | 1 | 0.00 | 0 | 0 | ||
global KZLD latch for mem in SGA | 20 | 0.00 | 0 | 0 | ||
global tx hash mapping | 1 | 0.00 | 0 | 0 | ||
granule operation | 1 | 0.00 | 0 | 0 | ||
hash table column usage latch | 0 | 0 | 36 | 0.00 | ||
heartbeat check | 1 | 0.00 | 0 | 0 | ||
intra txn parallel recovery | 1 | 0.00 | 0 | 0 | ||
io pool granule metadata list | 1 | 0.00 | 0 | 0 | ||
job workq parent latch | 1 | 0.00 | 0 | 0 | ||
job_queue_processes parameter latch | 62 | 0.00 | 0 | 0 | ||
k2q lock allocation | 1 | 0.00 | 0 | 0 | ||
kcbtsemkid latch | 20 | 0.00 | 0 | 0 | ||
kdlx hb parent latch | 1 | 0.00 | 0 | 0 | ||
kgb parent | 1 | 0.00 | 0 | 0 | ||
kks stats | 75 | 0.00 | 0 | 0 | ||
kokc descriptor allocation latch | 4 | 0.00 | 0 | 0 | ||
kpon sga structure | 1 | 0.00 | 0 | 0 | ||
ksfv messages | 1 | 0.00 | 0 | 0 | ||
kss move lock | 1 | 0.00 | 0 | 0 | ||
ksuosstats global area | 22 | 0.00 | 0 | 0 | ||
ksv allocation latch | 97 | 0.00 | 0 | 0 | ||
ksv class latch | 1 | 0.00 | 0 | 0 | ||
ksv msg queue latch | 1 | 0.00 | 0 | 0 | ||
ksz_so allocation latch | 40 | 0.00 | 0 | 0 | ||
ktm global data | 2 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 10 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 16,175 | 0.02 | 0.00 | 0 | 0 | |
list of block allocation | 59 | 0.00 | 0 | 0 | ||
loader state object freelist | 2 | 0.00 | 0 | 0 | ||
lob segment dispenser latch | 1 | 0.00 | 0 | 0 | ||
lob segment hash table latch | 3 | 0.00 | 0 | 0 | ||
lob segment query latch | 1 | 0.00 | 0 | 0 | ||
lock DBA buffer during media recovery | 1 | 0.00 | 0 | 0 | ||
logical standby cache | 1 | 0.00 | 0 | 0 | ||
logminer context allocation | 1 | 0.00 | 0 | 0 | ||
logminer work area | 1 | 0.00 | 0 | 0 | ||
longop free list parent | 1 | 0.00 | 0 | 0 | ||
mapped buffers lru chain | 1 | 0.00 | 0 | 0 | ||
message pool operations parent latch | 1 | 0.00 | 0 | 0 | ||
messages | 54,836 | 0.01 | 2.17 | 0 | 0 | |
mostly latch-free SCN | 16,274 | 0.17 | 0.26 | 0 | 0 | |
msg queue latch | 1 | 0.00 | 0 | 0 | ||
multiblock read objects | 2 | 0.00 | 0 | 0 | ||
name-service namespace bucket | 1 | 0.00 | 0 | 0 | ||
ncodef allocation latch | 97 | 0.00 | 0 | 0 | ||
object queue header heap | 1,176 | 0.00 | 0 | 140 | 0.00 | |
object queue header operation | 128,910 | 0.01 | 2.38 | 0 | 0 | |
object stats modification | 9 | 0.00 | 0 | 0 | ||
parallel query alloc buffer | 37 | 0.00 | 0 | 0 | ||
parallel query stats | 1 | 0.00 | 0 | 0 | ||
parameter list | 7 | 0.00 | 0 | 0 | ||
parameter table management | 40 | 0.00 | 0 | 0 | ||
peshm | 1 | 0.00 | 0 | 0 | ||
pesom_free_list | 1 | 0.00 | 0 | 0 | ||
pesom_hash_node | 1 | 0.00 | 0 | 0 | ||
post/wait queue | 44,104 | 0.01 | 0.00 | 0 | 38,362 | 0.01 |
process allocation | 40 | 0.00 | 0 | 20 | 0.00 | |
process group creation | 40 | 0.00 | 0 | 0 | ||
process queue | 1 | 0.00 | 0 | 0 | ||
process queue reference | 1 | 0.00 | 0 | 0 | ||
qmn task queue latch | 40 | 10.00 | 1.00 | 0 | 0 | |
query server freelists | 1 | 0.00 | 0 | 0 | ||
queued dump request | 1 | 0.00 | 0 | 0 | ||
queuing load statistics | 1 | 0.00 | 0 | 0 | ||
recovery domain hash list | 1 | 0.00 | 0 | 0 | ||
redo allocation | 75,707 | 0.20 | 0.24 | 0 | 1,381,814 | 0.02 |
redo copy | 1 | 0.00 | 0 | 1,381,920 | 0.22 | |
redo writing | 49,407 | 0.00 | 1.00 | 0 | 0 | |
resmgr group change latch | 20 | 0.00 | 0 | 0 | ||
resmgr:active threads | 41 | 0.00 | 0 | 0 | ||
resmgr:actses change group | 21 | 0.00 | 0 | 0 | ||
resmgr:actses change state | 1 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 40 | 0.00 | 0 | 0 | ||
resmgr:plan CPU method | 1 | 0.00 | 0 | 0 | ||
resmgr:resource group CPU method | 1 | 0.00 | 0 | 0 | ||
resmgr:schema config | 1 | 0.00 | 0 | 0 | ||
resmgr:session queuing | 1 | 0.00 | 0 | 0 | ||
rm cas latch | 1 | 0.00 | 0 | 0 | ||
row cache objects | 6,709 | 0.00 | 0 | 0 | ||
second spare latch | 1 | 0.00 | 0 | 0 | ||
sequence cache | 75 | 0.00 | 0 | 0 | ||
session allocation | 60,313 | 0.03 | 0.38 | 0 | 20,104 | 0.04 |
session idle bit | 248,516 | 0.01 | 0.00 | 0 | 0 | |
session queue latch | 1 | 0.00 | 0 | 0 | ||
session switching | 198 | 0.00 | 0 | 0 | ||
session timer | 113 | 0.00 | 0 | 0 | ||
shared pool | 9,210 | 0.00 | 0 | 0 | ||
shared pool sim alloc | 1 | 0.00 | 0 | 0 | ||
shared pool simulator | 330 | 0.00 | 0 | 0 | ||
sim partition latch | 1 | 0.00 | 0 | 0 | ||
simulator hash latch | 418,226 | 0.00 | 0.00 | 0 | 0 | |
simulator lru latch | 1 | 0.00 | 0 | 415,185 | 0.11 | |
sort extent pool | 111 | 0.00 | 0 | 0 | ||
space background task latch | 214 | 0.00 | 0 | 190 | 0.00 | |
state object free list | 2 | 0.00 | 0 | 0 | ||
statistics aggregation | 336 | 0.00 | 0 | 0 | ||
tablespace key chain | 1 | 0.00 | 0 | 0 | ||
temp lob duration state obj allocation | 1 | 0.00 | 0 | 0 | ||
test excl. parent l0 | 1 | 0.00 | 0 | 0 | ||
test excl. parent2 l0 | 1 | 0.00 | 0 | 0 | ||
third spare latch | 1 | 0.00 | 0 | 0 | ||
threshold alerts latch | 6 | 0.00 | 0 | 0 | ||
transaction allocation | 95 | 0.00 | 0 | 0 | ||
undo global data | 523,684 | 0.01 | 0.53 | 0 | 0 | |
virtual circuit buffers | 1 | 0.00 | 0 | 0 | ||
virtual circuit holder | 1 | 0.00 | 0 | 0 | ||
virtual circuit queues | 1 | 0.00 | 0 | 0 |
Latch Name | Get Requests | Misses | Sleeps | Spin Gets |
---|---|---|---|---|
cache buffers chains | 31,003,538 | 390,259 | 18,194 | 379,083 |
In memory undo latch | 326,997 | 12,691 | 11,092 | 4,289 |
redo allocation | 75,707 | 150 | 36 | 118 |
enqueue hash chains | 162,877 | 125 | 241 | 92 |
undo global data | 523,684 | 62 | 33 | 52 |
enqueues | 59,908 | 60 | 94 | 24 |
mostly latch-free SCN | 16,274 | 27 | 7 | 23 |
session allocation | 60,313 | 21 | 8 | 13 |
object queue header operation | 128,910 | 16 | 38 | 12 |
DML lock allocation | 40,536 | 9 | 5 | 5 |
Result Cache: RC Latch | 39,300 | 9 | 2 | 7 |
cache buffers lru chain | 36,466 | 9 | 1 | 8 |
Change Notification Latch | 76,000 | 8 | 2 | 6 |
messages | 54,836 | 6 | 13 | 0 |
qmn task queue latch | 40 | 4 | 4 | 0 |
redo writing | 49,407 | 1 | 1 | 0 |
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
Change Notification Latch | ktcn_free_invht_storage | 0 | 1 | 0 |
Change Notification Latch | ktcn_free_queryinv_storage | 0 | 1 | 0 |
DML lock allocation | ktaiam | 0 | 4 | 1 |
DML lock allocation | ktaidm | 0 | 1 | 4 |
In memory undo latch | ktichg: child | 0 | 7,138 | 3,102 |
In memory undo latch | ktiFlush: child | 0 | 3,684 | 4,542 |
In memory undo latch | kticmt: child | 0 | 373 | 31 |
In memory undo latch | kturbk | 0 | 2 | 3,522 |
Result Cache: RC Latch | Result Cache: Serialization06 | 0 | 2 | 0 |
cache buffers chains | kcbgtcr: fast path (cr pin) | 0 | 10,022 | 917 |
cache buffers chains | kcbchg1: kslbegin: call CR func | 0 | 2,998 | 2,436 |
cache buffers chains | kcbchg1: kslbegin: bufs not pinned | 0 | 1,510 | 2,617 |
cache buffers chains | kcbrls_1 | 0 | 1,394 | 7,491 |
cache buffers chains | kcbgcur_2 | 0 | 1,183 | 1,962 |
cache buffers chains | kcbgtcr: fast path | 0 | 951 | 906 |
cache buffers chains | kcbzwb | 0 | 272 | 1,976 |
cache buffers chains | kcbnlc | 0 | 187 | 85 |
cache buffers chains | kcb_post_apply: kcbhq62 | 0 | 91 | 16 |
cache buffers chains | kcbso1: set no access | 0 | 31 | 134 |
cache buffers chains | kcb_pre_apply: kcbhq61 | 0 | 30 | 171 |
cache buffers chains | kcbrls_2 | 0 | 16 | 8 |
cache buffers chains | kcbnew: new latch again | 0 | 11 | 0 |
cache buffers chains | kcbzhngcbk1_1 | 0 | 11 | 0 |
cache buffers chains | kcbcge | 0 | 9 | 1 |
cache buffers chains | kcb_commit | 0 | 7 | 15 |
cache buffers chains | kcbgtcr: kslbegin excl | 0 | 6 | 6 |
cache buffers chains | kcbzpbuf | 0 | 4 | 6 |
cache buffers chains | kcb_is_private | 0 | 1 | 3 |
cache buffers chains | kcbcxx | 0 | 1 | 10 |
cache buffers chains | kcbzgb: scan from tail. nowait | 0 | 1 | 0 |
cache buffers lru chain | kcbzgws | 0 | 1 | 0 |
enqueue hash chains | ksqgtl3 | 0 | 215 | 239 |
enqueue hash chains | ksqrcl | 0 | 25 | 1 |
enqueue hash chains | ksqcmi: get hash chain latch after wait | 0 | 1 | 4 |
enqueues | ksqdel | 0 | 56 | 17 |
enqueues | ksqgel: create enqueue | 0 | 38 | 77 |
messages | ksarcv: after wait | 0 | 6 | 0 |
messages | ksaamb: after wakeup | 0 | 5 | 11 |
messages | ksarcv | 0 | 2 | 2 |
mostly latch-free SCN | kcs05 | 0 | 6 | 0 |
mostly latch-free SCN | kcs04 | 0 | 1 | 7 |
object queue header operation | kcbo_switch_mq_bg | 0 | 35 | 0 |
object queue header operation | kcbo_switch_q_bg | 0 | 2 | 0 |
object queue header operation | kcbo_unlink_q | 0 | 1 | 3 |
qmn task queue latch | kwqmnmvtsks: delay to ready list | 0 | 4 | 0 |
redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 36 | 0 |
redo writing | kcrfw_cal_target_rba | 0 | 1 | 0 |
session allocation | ksuxds | 0 | 6 | 8 |
session allocation | ksucri_int : SSO | 0 | 2 | 0 |
undo global data | ktudba: KSLBEGIN | 0 | 32 | 33 |
undo global data | ktudnx:child | 0 | 1 | 0 |
Mutex Type | Location | Sleeps | Wait Time (ms) |
---|---|---|---|
Cursor Pin | kkslce [KKSCHLPIN2] | 6 | 36 |
Cursor Pin | kksLockDelete [KKSCHLPIN6] | 5 | 0 |
Cursor Pin | kksfbc [KKSCHLFSP2] | 4 | 0 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
---|---|---|---|---|---|---|
OCIHOL | SYSTEM | SYS_C004756 | INDEX | 1,600,000 | 16.47 | |
OCIHOL | SYSTEM | MYEMP | TABLE | 1,588,528 | 16.35 | |
OCIHOL | SYSTEM | REGIONS | TABLE | 56,160 | 0.58 | |
SYS | SYSAUX | WRH$_SEG_STAT_OBJ_PK | INDEX | 912 | 0.01 | |
SYS | SYSTEM | AUD$ | TABLE | 352 | 0.00 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
SYS | SYSAUX | WRH$_SQL_PLAN | TABLE | 80 | 15.87 | |
SYS | SYSAUX | WRH$_SQLTEXT | TABLE | 20 | 3.97 | |
SYS | SYSAUX | WRH$_SQL_BIND_METADATA | TABLE | 18 | 3.57 | |
SYS | SYSAUX | WRH$_SQL_PLAN_PK | INDEX | 17 | 3.37 | |
SYS | SYSAUX | WRH$_SYSMETRIC_HISTORY | TABLE | 9 | 1.79 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Read Requests | %Total |
---|---|---|---|---|---|---|
SYS | SYSAUX | WRH$_SQL_PLAN | TABLE | 80 | 17.78 | |
SYS | SYSAUX | WRH$_SQLTEXT | TABLE | 20 | 4.44 | |
SYS | SYSAUX | WRH$_SQL_BIND_METADATA | TABLE | 18 | 4.00 | |
SYS | SYSAUX | WRH$_SQL_PLAN_PK | INDEX | 17 | 3.78 | |
SYS | SYSAUX | WRH$_SYSMETRIC_HISTORY | TABLE | 9 | 2.00 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | UnOptimized Reads | %Total |
---|---|---|---|---|---|---|
SYS | SYSAUX | WRH$_SQL_PLAN | TABLE | 80 | 17.78 | |
SYS | SYSAUX | WRH$_SQLTEXT | TABLE | 20 | 4.44 | |
SYS | SYSAUX | WRH$_SQL_BIND_METADATA | TABLE | 18 | 4.00 | |
SYS | SYSAUX | WRH$_SQL_PLAN_PK | INDEX | 17 | 3.78 | |
SYS | SYSAUX | WRH$_SYSMETRIC_HISTORY | TABLE | 9 | 2.00 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Writes | %Total |
---|---|---|---|---|---|---|
SYS | SYSAUX | WRH$_SQL_PLAN | TABLE | 59 | 0.24 | |
SYS | SYSAUX | WRH$_SQLTEXT | TABLE | 27 | 0.11 | |
SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_570420430_874 | TABLE PARTITION | 21 | 0.09 |
OCIHOL | SYSTEM | MYEMP | TABLE | 20 | 0.08 | |
SYS | SYSAUX | WRH$_SQL_BIND_METADATA | TABLE | 15 | 0.06 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Write Requests | %Total |
---|---|---|---|---|---|---|
SYS | SYSAUX | WRH$_SQL_PLAN | TABLE | 59 | 0.29 | |
SYS | SYSAUX | WRH$_SQLTEXT | TABLE | 26 | 0.13 | |
OCIHOL | SYSTEM | MYEMP | TABLE | 20 | 0.10 | |
SYS | SYSAUX | WRH$_PARAMETER_PK | WRH$_PARAME_570420430_874 | INDEX PARTITION | 14 | 0.07 |
SYS | SYSAUX | WRH$_SQL_BIND_METADATA | TABLE | 14 | 0.07 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Writes | %Total |
---|---|---|---|---|---|---|
SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_570420430_874 | TABLE PARTITION | 19 | 5.05 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Table Scans | %Total |
---|---|---|---|---|---|---|
SYS | SYSAUX | SCHEDULER$_EVENT_LOG | TABLE | 1 | 100.00 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | DB Block Changes | % of Capture |
---|---|---|---|---|---|---|
OCIHOL | SYSTEM | MYEMP | TABLE | 7,486,576 | 99.99 | |
SYS | SYSTEM | INVALIDATION_REGISTRY$ | TABLE | 208 | 0.00 | |
SYS | SYSAUX | CRC$_RESULT_CACHE_STATS | TABLE | 80 | 0.00 | |
SYS | SYSAUX | WRH$_SQL_PLAN | TABLE | 80 | 0.00 | |
SYS | SYSAUX | WRH$_SQLSTAT_INDEX | WRH$_SQLSTA_570420430_874 | INDEX PARTITION | 64 | 0.00 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
---|---|---|---|---|---|---|
OCIHOL | SYSTEM | MYEMP | TABLE | 8,259 | 99.81 | |
SYS | SYSTEM | INVALIDATION_REGISTRY$ | TABLE | 16 | 0.19 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
---|---|---|---|---|---|---|
OCIHOL | SYSTEM | MYEMP | TABLE | 328,486 | 100.00 | |
SYS | SYSTEM | INVALIDATION_REGISTRY$ | TABLE | 2 | 0.00 |
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
---|---|---|---|---|---|---|
dc_awr_control | 9 | 0.00 | 0 | 2 | 1 | |
dc_free_extents | 3 | 0.00 | 0 | 0 | 3 | |
dc_global_oids | 11 | 0.00 | 0 | 0 | 25 | |
dc_histogram_defs | 162 | 13.58 | 0 | 0 | 1,851 | |
dc_objects | 376 | 3.19 | 0 | 0 | 1,033 | |
dc_profiles | 20 | 0.00 | 0 | 0 | 1 | |
dc_rollback_segments | 83 | 0.00 | 0 | 0 | 28 | |
dc_segments | 262 | 7.25 | 0 | 8 | 728 | |
dc_tablespaces | 541 | 0.00 | 0 | 0 | 4 | |
dc_users | 685 | 0.00 | 0 | 0 | 36 | |
global database name | 210 | 0.00 | 0 | 0 | 1 |
Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
---|---|---|---|---|---|---|
BODY | 7 | 0.00 | 9 | 0.00 | 0 | 0 |
CLUSTER | 4 | 0.00 | 4 | 0.00 | 0 | 0 |
DBLINK | 40 | 0.00 | 0 | 0 | 0 | |
EDITION | 20 | 0.00 | 40 | 0.00 | 0 | 0 |
INDEX | 1 | 100.00 | 1 | 100.00 | 0 | 0 |
LOCATION | 11 | 0.00 | 11 | 0.00 | 0 | 0 |
QUEUE | 0 | 57 | 0.00 | 0 | 0 | |
SCHEMA | 48 | 0.00 | 0 | 0 | 0 | |
SQL AREA | 523 | 3.82 | 41,487 | 0.08 | 5 | 0 |
SUBSCRIPTION | 2 | 50.00 | 2 | 50.00 | 0 | 0 |
TABLE/PROCEDURE | 95 | 1.05 | 190 | 7.89 | 8 | 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 | 16.00 | 16.00 | 16.00 | 16.00 | 0 | STA/ |
KEEP buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
PGA Target | 32.00 | 32.00 | 32.00 | 32.00 | 0 | STA/ |
RECYCLE buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
SGA Target | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
Shared IO Pool | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
java pool | 48.00 | 48.00 | 48.00 | 48.00 | 0 | STA/ |
large pool | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
shared pool | 100.00 | 100.00 | 100.00 | 100.00 | 0 | STA/ |
streams pool | 0.00 | 0.00 | 0.00 | 0.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 | 39.03 | 1.39 | 2.01 | 11 | 11 | 28 | 28 | |
Freeable | 4.19 | 0.00 | 0.60 | 0.56 | 2 | 7 | 7 | ||
SQL | 0.65 | 0.57 | 0.04 | 0.12 | 1 | 2 | 17 | 9 | |
PL/SQL | 0.48 | 0.41 | 0.02 | 0.04 | 0 | 0 | 28 | 28 | |
E | Other | 39.42 | 1.41 | 2.03 | 11 | 11 | 28 | 28 | |
Freeable | 4.50 | 0.00 | 0.75 | 0.61 | 2 | 6 | 6 | ||
SQL | 0.70 | 0.60 | 0.04 | 0.13 | 1 | 3 | 17 | 9 | |
PL/SQL | 0.48 | 0.41 | 0.02 | 0.04 | 0 | 0 | 28 | 28 |
SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
---|---|---|
Database Buffers | 16,777,216 | |
Fixed Size | 1,335,276 | |
Redo Buffers | 6,660,096 | |
Variable Size | 155,189,268 |
Pool | Name | Begin MB | End MB | % Diff |
---|---|---|---|---|
java | free memory | 48.00 | 48.00 | 0.00 |
shared | ASH buffers | 4.00 | 4.00 | 0.00 |
shared | CCUR | 3.99 | 4.01 | 0.58 |
shared | FileOpenBlock | 3.79 | 3.79 | 0.00 |
shared | KCB Table Scan Buffer | 3.80 | 3.80 | 0.00 |
shared | KGLH0 | 2.43 | 2.44 | 0.48 |
shared | KGLHD | 1.80 | 1.81 | 0.67 |
shared | KGLS | 2.71 | 2.80 | 3.44 |
shared | KGLSG | 3.52 | 3.52 | 0.00 |
shared | KQR M PO | 1.42 | 1.43 | 0.17 |
shared | KSFD SGA I/O b | 3.79 | 3.79 | 0.00 |
shared | PCUR | 3.21 | 3.24 | 0.72 |
shared | PLMCD | 3.19 | 3.04 | -4.86 |
shared | PX msg pool | 3.14 | 3.14 | 0.00 |
shared | SQLA | 14.15 | 14.27 | 0.85 |
shared | dbktb: trace buffer | 1.56 | 1.56 | 0.00 |
shared | event statistics per sess | 1.84 | 1.84 | 0.00 |
shared | free memory | 7.21 | 7.04 | -2.42 |
shared | kglsim hash table bkts | 2.00 | 2.00 | 0.00 |
shared | kse signatures | 1.83 | 1.83 | 0.00 |
shared | ksunfy : SSO free list | 1.78 | 1.78 | 0.00 |
shared | message pool freequeue | 1.09 | 1.09 | 0.00 |
shared | obj stats allocation chun | 2.21 | 2.21 | 0.00 |
shared | row cache | 3.62 | 3.62 | 0.00 |
buffer_cache | 16.00 | 16.00 | 0.00 | |
fixed_sga | 1.27 | 1.27 | 0.00 | |
log_buffer | 6.35 | 6.35 | 0.00 |
Avg Total Connections | Avg Active Connections | Avg Total Shared Srvrs | Avg Active Shared Srvrs | Avg Total Dispatchers | Avg Active Dispatchers |
---|---|---|---|---|---|
0 | 0 | 0 | 0 | 0 | 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 |
Parameter Name | Begin value | End value (if different) |
---|---|---|
O7_DICTIONARY_ACCESSIBILITY | FALSE | |
_assm_default | FALSE | |
_auto_bmr | disabled | |
_cgs_node_kill_escalation | FALSE | |
_controlfile_enqueue_holding_time | 300 | |
_controlfile_enqueue_holding_time_tracking_size | 25 | |
_controlfile_update_check | HIGH | |
_db_block_bad_write_check | TRUE | |
_db_block_check_for_debug | TRUE | |
_db_cache_process_cr_pin_max | 500 | |
_dead_process_scan_interval | 10 | |
_disable_adaptive_shrunk_aggregation | FALSE | |
_disable_cpu_check | TRUE | |
_diskmon_pipe_name | /ade/b/3050220379/oracle/work/pipe1 | |
_enable_NUMA_support | FALSE | |
_enable_automatic_sqltune | FALSE | |
_fix_control | 6670551:OFF | |
_force_oltp_compress | TRUE | |
_gc_integrity_checks | 2 | |
_ges_dd_debug | 2 | |
_high_priority_processes | VKTM | |
_hm_analysis_oradebug_node_dump_level | 4 | |
_hm_analysis_oradebug_sys_dump_level | 10 | |
_hm_analysis_output_disk | TRUE | |
_kcl_debug | TRUE | |
_kdz_hcc_flags | 15 | |
_kgl_kqr_cap_so_stacks | TRUE | |
_kill_enqueue_blocker | 3 | |
_kse_signature_entries | 60000 | |
_kse_signature_limit | 7 | |
_ksu_diag_kill_time | 30 | |
_ksuitm_addon_trccmd | /ade/b/3050220379/oracle/rdbms/test/tkin/sosd/tkinksuitm.sh | |
_lm_dd_interval | 5 | |
_lm_rcvr_hang_allow_time | 150 | |
_lm_validate_pbatch | TRUE | |
_lm_validate_resource_type | TRUE | |
_log_archive_security_enabled | FALSE | |
_optimizer_autostats_job | FALSE | |
_optimizer_cost_model | fixed | |
_oradbg_pathname | /ade/b/3050220379/oracle/rdbms/utl/oradbg | |
_pgactx_cap_stacks | TRUE | |
_qa_lrg_type | 1 | |
_realfree_heap_mode | 3 | |
_recovery_asserts | TRUE | |
_recovery_verify_writes | TRUE | |
_redo_compatibility_check | TRUE | |
_sga_early_trace | 1 | |
_shared_io_pool_size | 0 | |
_smm_auto_cost_enabled | FALSE | |
_trace_buffers | FGS:512;BGS:1024 | |
_trace_events | 10432:6:ALL, 10435:6:LMON, LMD0, 10427:6:ALL, 10429:6:ALL, 10434:6:LMD0, LMS0, LMS1, LMS2, LMS3, LMS4, LMS5, LMS6, LMS7, LMS8, LMS9, 10401:8:ALL, 10249:5:FGS, 10257:1:ALL, 10720:1:ALL:FAST, 10722:1:ALL:FAST, 10298:1:ALL | |
_trace_files_public | TRUE | |
audit_trail | DB | |
cell_offload_processing | FALSE | |
client_result_cache_size | 65536 | |
commit_point_strength | 1 | |
compatible | 11.2.0.0.0 | |
control_files | /ade/b/3050220379/oracle/dbs/t_cf1.f | |
db_block_checking | true | |
db_block_checksum | true | |
db_block_size | 8192 | |
db_cache_size | 16777216 | |
db_domain | regress.rdbms.dev.us.oracle.com | |
db_name | linuxs | |
diagnostic_dest | /ade/b/3050220379/oracle/log | |
event | 10808 trace name context forever, level 7, 10809 trace name context forever, level 37, 29715 trace name context forever, level 3, 29718 trace name context forever, level 5, 10235 trace name context forever, level 2, 10828 trace name context forever, level 0, 10753 trace name context forever, level 1, 19392 trace name context forever, level 2, 19394 trace name context forever, level 8, 19396 trace name context forever, level 2, 10324 trace name context forever, level 1, 1578 trace name errorstack level 1; na | |
global_names | FALSE | |
ifile | /ade/b/3050220379/oracle/work/tkinit.ora | |
instance_name | linuxs | |
instance_number | 1 | |
java_pool_size | 50331648 | |
log_archive_trace | 8191 | |
log_checkpoints_to_alert | TRUE | |
nls_length_semantics | BYTE | |
open_cursors | 300 | |
open_links | 10 | |
open_links_per_instance | 20 | |
pga_aggregate_target | 30408704 | |
plsql_optimize_level | 2 | |
processes | 100 | |
remote_login_passwordfile | SHARED | |
service_names | linuxs.regress.rdbms.dev.us.oracle.com | |
sessions | 172 | |
shared_pool_size | 104857600 | |
transactions | 21 | |
transactions_per_rollback_segment | 21 | |
undo_management | AUTO |