DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
---|---|---|---|---|---|---|
JQHX | 2877231475 | jqhx | 1 | 03-8月 -13 10:08 | 11.2.0.3.0 | NO |
Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
---|---|---|---|---|---|
localhost.localdomain | Linux x86 64-bit | 24 | 12 | 2 | 47.16 |
Snap Id | Snap Time | Sessions | Cursors/Session | |
---|---|---|---|---|
Begin Snap: | 4190 | 03-9月 -13 10:00:40 | 766 | .4 |
End Snap: | 4191 | 03-9月 -13 11:00:05 | 856 | .5 |
Elapsed: | 59.41 (mins) | |||
DB Time: | 3,489.86 (mins) |
Begin | End | |||
---|---|---|---|---|
Buffer Cache: | 3,008M | 3,008M | Std Block Size: | 8K |
Shared Pool Size: | 4,640M | 4,640M | Log Buffer: | 17,552K |
Per Second | Per Transaction | Per Exec | Per Call | |
---|---|---|---|---|
DB Time(s): | 58.7 | 8.1 | 0.23 | 0.23 |
DB CPU(s): | 1.4 | 0.2 | 0.01 | 0.01 |
Redo size: | 2,108,229.9 | 291,041.1 | ||
Logical reads: | 40,046.2 | 5,528.4 | ||
Block changes: | 1,942.6 | 268.2 | ||
Physical reads: | 529.5 | 73.1 | ||
Physical writes: | 350.8 | 48.4 | ||
User calls: | 260.2 | 35.9 | ||
Parses: | 224.7 | 31.0 | ||
Hard parses: | 27.9 | 3.8 | ||
W/A MB processed: | 6.1 | 0.8 | ||
Logons: | 32.1 | 4.4 | ||
Executes: | 257.1 | 35.5 | ||
Rollbacks: | 1.2 | 0.2 | ||
Transactions: | 7.2 |
Buffer Nowait %: | 99.65 | Redo NoWait %: | 84.75 |
Buffer Hit %: | 98.94 | In-memory Sort %: | 100.00 |
Library Hit %: | 93.10 | Soft Parse %: | 87.61 |
Execute to Parse %: | 12.61 | Latch Hit %: | 98.83 |
Parse CPU to Parse Elapsd %: | 51.01 | % Non-Parse CPU: | 93.58 |
Begin | End | |
---|---|---|
Memory Usage %: | 76.59 | 75.59 |
% SQL with executions>1: | 67.32 | 69.47 |
% Memory for SQL w/exec>1: | 78.86 | 83.13 |
Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
---|---|---|---|---|---|
enq: SQ - contention | 4,118 | 96,984 | 23551 | 46.32 | Configuration |
log file switch (checkpoint incomplete) | 1,902 | 64,342 | 33829 | 30.73 | Configuration |
log file sync | 21,087 | 14,278 | 677 | 6.82 | Commit |
buffer busy waits | 243,276 | 7,620 | 31 | 3.64 | Concurrency |
log buffer space | 7,505 | 5,920 | 789 | 2.83 | Configuration |
Load Average Begin | Load Average End | %User | %System | %WIO | %Idle |
---|---|---|---|---|---|
3.53 | 11.04 | 3.5 | 3.2 | 4.6 | 93.2 |
%Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) |
---|---|---|
5.6 | 82.0 | 0.0 |
Begin | End | |
---|---|---|
Host Mem (MB): | 48,288.7 | 48,288.7 |
SGA use (MB): | 7,808.0 | 7,808.0 |
PGA use (MB): | 935.6 | 1,061.1 |
% Host Mem used for SGA+PGA: | 18.11 | 18.37 |
Statistic Name | Time (s) | % of DB Time |
---|---|---|
sql execute elapsed time | 187,980.14 | 89.77 |
sequence load elapsed time | 106,450.87 | 50.84 |
DB CPU | 4,966.61 | 2.37 |
connection management call elapsed time | 3,539.18 | 1.69 |
parse time elapsed | 630.47 | 0.30 |
hard parse elapsed time | 312.87 | 0.15 |
failed parse elapsed time | 137.86 | 0.07 |
hard parse (sharing criteria) elapsed time | 17.57 | 0.01 |
PL/SQL execution elapsed time | 4.62 | 0.00 |
PL/SQL compilation elapsed time | 0.05 | 0.00 |
repeated bind elapsed time | 0.00 | 0.00 |
DB time | 209,391.31 | |
background elapsed time | 13,315.64 | |
background cpu time | 213.94 |
Statistic | Value | End Value |
---|---|---|
BUSY_TIME | 631,438 | |
IDLE_TIME | 8,587,676 | |
IOWAIT_TIME | 422,212 | |
NICE_TIME | 41 | |
SYS_TIME | 298,811 | |
USER_TIME | 323,893 | |
LOAD | 4 | 11 |
RSRC_MGR_CPU_WAIT_TIME | 0 | |
VM_IN_BYTES | 2,069,504 | |
VM_OUT_BYTES | 41,984 | |
PHYSICAL_MEMORY_BYTES | 50,634,383,360 | |
NUM_CPUS | 24 | |
NUM_CPU_CORES | 12 | |
NUM_CPU_SOCKETS | 2 | |
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 |
---|---|---|---|---|---|---|
03-9月 10:00:40 | 3.53 | |||||
03-9月 11:00:05 | 11.04 | 6.85 | 3.51 | 3.24 | 93.15 | 4.58 |
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %DB time |
---|---|---|---|---|---|
Configuration | 15,486 | 0 | 169,795 | 10964 | 81.09 |
Commit | 21,087 | 0 | 14,278 | 677 | 6.82 |
Concurrency | 329,237 | 0 | 8,657 | 26 | 4.13 |
DB CPU | 4,967 | 2.37 | |||
Application | 138,239 | 0 | 1,398 | 10 | 0.67 |
User I/O | 842,255 | 0 | 819 | 1 | 0.39 |
Other | 8,297 | 52 | 47 | 6 | 0.02 |
Network | 599,418 | 0 | 10 | 0 | 0.00 |
System I/O | 12 | 0 | 0 | 0 | 0.00 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % DB time |
---|---|---|---|---|---|---|
enq: SQ - contention | 4,118 | 0 | 96,984 | 23551 | 0.16 | 46.32 |
log file switch (checkpoint incomplete) | 1,902 | 0 | 64,342 | 33829 | 0.07 | 30.73 |
log file sync | 21,087 | 0 | 14,278 | 677 | 0.82 | 6.82 |
buffer busy waits | 243,276 | 0 | 7,620 | 31 | 9.42 | 3.64 |
log buffer space | 7,505 | 0 | 5,920 | 789 | 0.29 | 2.83 |
log file switch completion | 1,358 | 0 | 1,359 | 1001 | 0.05 | 0.65 |
enq: TX - row lock contention | 184 | 0 | 1,247 | 6776 | 0.01 | 0.60 |
log file switch (private strand flush incomplete) | 59 | 0 | 1,189 | 20147 | 0.00 | 0.57 |
library cache: mutex X | 77,305 | 0 | 955 | 12 | 2.99 | 0.46 |
direct path write temp | 12,670 | 0 | 700 | 55 | 0.49 | 0.33 |
db file sequential read | 440,847 | 0 | 87 | 0 | 17.07 | 0.04 |
enq: KO - fast object checkpoint | 3 | 0 | 79 | 26359 | 0.00 | 0.04 |
SQL*Net break/reset to client | 138,052 | 0 | 72 | 1 | 5.35 | 0.03 |
latch: In memory undo latch | 119 | 0 | 64 | 534 | 0.00 | 0.03 |
latch free | 934 | 0 | 37 | 40 | 0.04 | 0.02 |
db file scattered read | 242,350 | 0 | 13 | 0 | 9.39 | 0.01 |
direct path read | 3,600 | 0 | 9 | 3 | 0.14 | 0.00 |
read by other session | 134,819 | 0 | 8 | 0 | 5.22 | 0.00 |
SQL*Net message from dblink | 78 | 0 | 8 | 104 | 0.00 | 0.00 |
latch: shared pool | 3,755 | 0 | 8 | 2 | 0.15 | 0.00 |
cursor: pin S wait on X | 534 | 0 | 7 | 13 | 0.02 | 0.00 |
enq: FB - contention | 1,803 | 0 | 7 | 4 | 0.07 | 0.00 |
enq: TX - index contention | 118 | 0 | 3 | 23 | 0.00 | 0.00 |
SQL*Net more data to client | 83,689 | 0 | 2 | 0 | 3.24 | 0.00 |
enq: HW - contention | 474 | 0 | 1 | 3 | 0.02 | 0.00 |
kksfbc child completion | 21 | 100 | 1 | 51 | 0.00 | 0.00 |
Disk file operations I/O | 2,058 | 0 | 1 | 1 | 0.08 | 0.00 |
enq: TX - contention | 467 | 0 | 1 | 2 | 0.02 | 0.00 |
library cache lock | 128 | 0 | 1 | 7 | 0.00 | 0.00 |
direct path read temp | 5,911 | 0 | 1 | 0 | 0.23 | 0.00 |
latch: cache buffers chains | 3,531 | 0 | 1 | 0 | 0.14 | 0.00 |
SQL*Net message to client | 515,536 | 0 | 1 | 0 | 19.96 | 0.00 |
latch: enqueue hash chains | 190 | 0 | 1 | 3 | 0.01 | 0.00 |
latch: redo allocation | 503 | 0 | 0 | 1 | 0.02 | 0.00 |
latch: cache buffer handles | 7 | 0 | 0 | 40 | 0.00 | 0.00 |
cursor: mutex S | 10 | 0 | 0 | 11 | 0.00 | 0.00 |
latch: row cache objects | 338 | 0 | 0 | 0 | 0.01 | 0.00 |
latch: object queue header operation | 61 | 0 | 0 | 1 | 0.00 | 0.00 |
cursor: pin S | 119 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: redo writing | 70 | 0 | 0 | 0 | 0.00 | 0.00 |
cursor: mutex X | 3 | 0 | 0 | 4 | 0.00 | 0.00 |
latch: active service list | 11 | 0 | 0 | 1 | 0.00 | 0.00 |
asynch descriptor resize | 4,251 | 100 | 0 | 0 | 0.16 | 0.00 |
SQL*Net more data from client | 43 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: messages | 13 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: undo global data | 3 | 0 | 0 | 0 | 0.00 | 0.00 |
SQL*Net message from client | 515,470 | 0 | 2,753,895 | 5342 | 19.96 | |
jobq slave wait | 7,491 | 100 | 3,750 | 501 | 0.29 | |
single-task message | 6 | 0 | 1 | 173 | 0.00 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
---|---|---|---|---|---|---|
db file async I/O submit | 741 | 0 | 10,069 | 13588 | 0.03 | 75.62 |
log file parallel write | 9,998 | 0 | 990 | 99 | 0.39 | 7.44 |
log file switch (checkpoint incomplete) | 30 | 0 | 604 | 20136 | 0.00 | 4.54 |
buffer busy waits | 42 | 0 | 228 | 5433 | 0.00 | 1.71 |
control file parallel write | 4,515 | 0 | 199 | 44 | 0.17 | 1.49 |
Data file init write | 6,156 | 0 | 192 | 31 | 0.24 | 1.44 |
latch free | 8,763 | 0 | 79 | 9 | 0.34 | 0.59 |
rdbms ipc reply | 35 | 83 | 63 | 1792 | 0.00 | 0.47 |
enq: CF - contention | 222 | 0 | 44 | 198 | 0.01 | 0.33 |
log buffer space | 33 | 0 | 42 | 1276 | 0.00 | 0.32 |
Disk file operations I/O | 862 | 0 | 35 | 40 | 0.03 | 0.26 |
enq: JD - contention | 1 | 0 | 33 | 33422 | 0.00 | 0.25 |
latch: call allocation | 6,038 | 0 | 21 | 3 | 0.23 | 0.16 |
db file sequential read | 1,396 | 0 | 19 | 13 | 0.05 | 0.14 |
control file sequential read | 919,018 | 0 | 17 | 0 | 35.59 | 0.13 |
Log archive I/O | 7,492 | 0 | 15 | 2 | 0.29 | 0.11 |
log file switch (private strand flush incomplete) | 2 | 0 | 14 | 7042 | 0.00 | 0.11 |
db file single write | 916 | 0 | 14 | 15 | 0.04 | 0.10 |
log file switch completion | 5 | 0 | 6 | 1127 | 0.00 | 0.04 |
latch: shared pool | 1,415 | 0 | 4 | 3 | 0.05 | 0.03 |
os thread startup | 137 | 0 | 4 | 29 | 0.01 | 0.03 |
log file sequential read | 8,010 | 0 | 3 | 0 | 0.31 | 0.02 |
log file single write | 206 | 0 | 3 | 14 | 0.01 | 0.02 |
asynch descriptor resize | 112,297 | 100 | 1 | 0 | 4.35 | 0.01 |
log file sync | 3 | 0 | 1 | 368 | 0.00 | 0.01 |
direct path sync | 2 | 0 | 0 | 172 | 0.00 | 0.00 |
SQL*Net message to client | 448,149 | 0 | 0 | 0 | 17.36 | 0.00 |
db file scattered read | 2 | 0 | 0 | 58 | 0.00 | 0.00 |
ADR block file read | 16 | 0 | 0 | 4 | 0.00 | 0.00 |
LGWR wait for redo copy | 470 | 0 | 0 | 0 | 0.02 | 0.00 |
ADR block file write | 5 | 0 | 0 | 9 | 0.00 | 0.00 |
latch: cache buffers lru chain | 157 | 0 | 0 | 0 | 0.01 | 0.00 |
latch: active service list | 40 | 0 | 0 | 0 | 0.00 | 0.00 |
direct path write | 53 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: In memory undo latch | 10 | 0 | 0 | 1 | 0.00 | 0.00 |
latch: redo allocation | 12 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: enqueue hash chains | 11 | 0 | 0 | 0 | 0.00 | 0.00 |
reliable message | 13 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: cache buffers chains | 3 | 0 | 0 | 0 | 0.00 | 0.00 |
rdbms ipc message | 141,128 | 12 | 55,438 | 393 | 5.47 | |
DIAG idle wait | 7,477 | 100 | 7,485 | 1001 | 0.29 | |
Space Manager: slave idle wait | 1,132 | 97 | 5,557 | 4909 | 0.04 | |
SQL*Net message from client | 560,286 | 0 | 4,709 | 8 | 21.70 | |
shared server idle wait | 126 | 100 | 3,780 | 30002 | 0.00 | |
Streams AQ: qmn coordinator idle wait | 268 | 50 | 3,753 | 14005 | 0.01 | |
Streams AQ: qmn slave idle wait | 134 | 0 | 3,753 | 28009 | 0.01 | |
dispatcher timer | 62 | 100 | 3,720 | 60003 | 0.00 | |
pmon timer | 5,506 | 20 | 3,673 | 667 | 0.21 | |
smon timer | 25 | 36 | 3,623 | 144928 | 0.00 | |
class slave wait | 21 | 0 | 0 | 0 | 0.00 |
% of Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Total Waits | <1ms | <2ms | <4ms | <8ms | <16ms | <32ms | <=1s | >1s |
ADR block file read | 16 | 75.0 | 6.3 | 12.5 | 6.3 | ||||
ADR block file write | 5 | 40.0 | 60.0 | ||||||
ADR file lock | 6 | 100.0 | |||||||
ARCH wait for archivelog lock | 108 | 100.0 | |||||||
Data file init write | 6156 | .3 | 60.3 | 7.7 | .0 | .1 | .1 | 31.4 | .0 |
Disk file operations I/O | 2991 | 89.2 | 7.1 | 3.5 | .2 | ||||
LGWR wait for redo copy | 474 | 97.0 | 2.3 | .6 | |||||
Log archive I/O | 7592 | 2.2 | 88.5 | 8.6 | .1 | .2 | .2 | .3 | |
SQL*Net break/reset to client | 141.6K | 94.4 | .1 | 2.0 | 2.5 | .7 | .2 | .1 | |
SQL*Net message from dblink | 78 | 100.0 | |||||||
SQL*Net message to client | 981K | 100.0 | .0 | ||||||
SQL*Net message to dblink | 72 | 100.0 | |||||||
SQL*Net more data from client | 43 | 100.0 | |||||||
SQL*Net more data to client | 84K | 100.0 | |||||||
asynch descriptor resize | 118.9K | 100.0 | |||||||
buffer busy waits | 247.6K | 99.4 | .2 | .1 | .1 | .0 | .0 | .1 | .2 |
buffer deadlock | 20 | 100.0 | |||||||
control file parallel write | 4612 | .5 | 19.4 | 35.3 | 44.7 | .1 | |||
control file sequential read | 947.7K | 100.0 | .0 | .0 | .0 | .0 | .0 | ||
cursor: mutex S | 10 | 100.0 | |||||||
cursor: mutex X | 3 | 66.7 | 33.3 | ||||||
cursor: pin S | 120 | 96.7 | .8 | .8 | 1.7 | ||||
cursor: pin S wait on X | 551 | 7.3 | 11.4 | 1.5 | 1.5 | 56.3 | 16.3 | 5.8 | |
db file async I/O submit | 748 | .1 | .7 | 3.3 | 4.7 | 15.6 | 75.5 | ||
db file scattered read | 242.5K | 100.0 | .0 | .0 | .0 | .0 | .0 | .0 | |
db file sequential read | 442.6K | 99.6 | .0 | .0 | .0 | .0 | .1 | .2 | .0 |
db file single write | 936 | .1 | 1.8 | 18.5 | 46.7 | 28.1 | 4.8 | ||
direct path read | 3585 | 90.5 | 1.8 | .7 | 3.0 | 1.1 | .7 | 2.2 | |
direct path read temp | 5911 | 99.8 | .0 | .0 | .0 | .0 | .0 | .1 | |
direct path sync | 2 | 100.0 | |||||||
direct path write | 53 | 100.0 | |||||||
direct path write temp | 12.7K | .0 | .1 | 3.9 | 9.2 | 21.7 | 65.0 | ||
enq: CF - contention | 227 | 10.6 | 1.8 | 1.3 | .9 | 85.0 | .4 | ||
enq: FB - contention | 1803 | 97.9 | .2 | .1 | .3 | .4 | .9 | .2 | |
enq: HW - contention | 474 | 81.6 | 12.4 | 3.2 | 1.1 | 1.7 | |||
enq: JD - contention | 1 | 100.0 | |||||||
enq: KO - fast object checkpoint | 3 | 100.0 | |||||||
enq: SQ - contention | 4338 | .6 | .9 | .7 | .8 | .8 | .6 | 20.1 | 75.4 |
enq: TX - contention | 468 | 96.4 | .6 | .2 | 2.8 | ||||
enq: TX - index contention | 118 | 15.3 | 2.5 | 14.4 | 6.8 | 7.6 | 22.9 | 30.5 | |
enq: TX - row lock contention | 187 | 9.6 | 5.9 | 4.3 | 3.2 | 2.7 | 8.0 | 28.3 | 38.0 |
kksfbc child completion | 22 | 100.0 | |||||||
latch free | 9851 | 2.2 | .1 | .2 | 52.9 | 34.5 | 4.4 | 5.7 | |
latch: In memory undo latch | 129 | 25.6 | 1.6 | 3.1 | 3.9 | 3.9 | 44.2 | 17.8 | |
latch: active service list | 51 | 80.4 | 19.6 | ||||||
latch: cache buffer handles | 7 | 100.0 | |||||||
latch: cache buffers chains | 3548 | 98.9 | .4 | .2 | .3 | .0 | .1 | .1 | |
latch: cache buffers lru chain | 164 | 95.1 | 3.7 | .6 | .6 | ||||
latch: call allocation | 6188 | 63.5 | 8.3 | 5.6 | 7.2 | 8.3 | 6.5 | .7 | |
latch: enqueue hash chains | 224 | 75.0 | 7.1 | 9.8 | 2.2 | 3.1 | 2.2 | .4 | |
latch: messages | 13 | 100.0 | |||||||
latch: object queue header operation | 63 | 85.7 | 4.8 | 6.3 | 3.2 | ||||
latch: redo allocation | 545 | 80.4 | 8.6 | 5.9 | 3.5 | 1.5 | .2 | ||
latch: redo writing | 72 | 98.6 | 1.4 | ||||||
latch: row cache objects | 346 | 91.0 | 6.1 | 2.9 | |||||
latch: shared pool | 5243 | 80.9 | 5.5 | 5.7 | 4.2 | .9 | 1.0 | 1.8 | |
latch: undo global data | 3 | 100.0 | |||||||
library cache load lock | 1 | 100.0 | |||||||
library cache lock | 130 | 16.2 | 18.5 | 8.5 | 26.2 | 22.3 | 6.9 | 1.5 | |
library cache: mutex X | 78.9K | 28.5 | .7 | .3 | .1 | 50.4 | 11.8 | 8.1 | |
log buffer space | 7756 | .2 | .1 | .2 | .5 | 1.4 | 2.4 | 63.9 | 31.2 |
log file parallel write | 9995 | .5 | 8.7 | 29.5 | 34.8 | 23.5 | 2.9 | ||
log file sequential read | 8120 | 100.0 | .0 | .0 | |||||
log file single write | 210 | 1.9 | 31.0 | 42.9 | 18.1 | 6.2 | |||
log file switch (checkpoint incomplete) | 1984 | .1 | .1 | .1 | .1 | 8.8 | 91.0 | ||
log file switch (private strand flush incomplete) | 61 | 1.6 | 23.0 | 75.4 | |||||
log file switch completion | 1381 | .1 | .2 | 52.9 | 46.9 | ||||
log file sync | 21.4K | .2 | 2.9 | 11.5 | 16.1 | 37.2 | 32.1 | ||
os thread startup | 140 | .7 | 93.6 | 5.7 | |||||
rdbms ipc reply | 35 | 14.3 | 85.7 | ||||||
read by other session | 134.8K | 100.0 | .0 | .0 | .0 | .0 | .0 | .0 | |
reliable message | 16 | 100.0 | |||||||
DIAG idle wait | 7656 | 100.0 | |||||||
SQL*Net message from client | 1095.3K | 66.1 | 5.3 | 14.5 | 3.2 | .8 | .4 | .8 | 9.1 |
Space Manager: slave idle wait | 1167 | .1 | .4 | 99.5 | |||||
Streams AQ: qmn coordinator idle wait | 274 | 49.6 | .4 | 50.0 | |||||
Streams AQ: qmn slave idle wait | 137 | 100.0 | |||||||
class slave wait | 22 | 100.0 | |||||||
dispatcher timer | 64 | 100.0 | |||||||
jobq slave wait | 7624 | .0 | 100.0 | ||||||
pmon timer | 5642 | 30.7 | .4 | .7 | 1.3 | 2.1 | 3.6 | 39.6 | 21.6 |
rdbms ipc message | 145.3K | 54.4 | 3.3 | 2.1 | 2.1 | 3.0 | 3.4 | 25.5 | 6.1 |
shared server idle wait | 129 | 100.0 | |||||||
single-task message | 6 | 100.0 | |||||||
smon timer | 22 | 13.6 | 4.5 | 81.8 |
% of Total Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Waits 64ms to 2s | <32ms | <64ms | <1/8s | <1/4s | <1/2s | <1s | <2s | >=2s |
ADR block file read | 1 | 93.8 | 6.3 | ||||||
Data file init write | 1935 | 68.6 | 8.6 | 18.0 | 4.7 | .1 | .0 | .0 | |
Disk file operations I/O | 109 | 96.3 | .2 | 2.5 | .8 | .1 | .1 | ||
Log archive I/O | 19 | 99.7 | .2 | .0 | .0 | ||||
SQL*Net break/reset to client | 178 | 99.9 | .1 | .0 | .0 | ||||
SQL*Net message from dblink | 78 | 76.9 | 12.8 | 2.6 | 7.7 | ||||
buffer busy waits | 448 | 99.7 | .0 | .0 | .0 | .0 | .1 | .1 | .1 |
control file parallel write | 2062 | 55.2 | 32.6 | 9.5 | 1.6 | .8 | .2 | .1 | |
control file sequential read | 35 | 100.0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
cursor: pin S wait on X | 32 | 94.2 | 5.3 | .5 | |||||
db file async I/O submit | 137 | 8.8 | 4.8 | 4.4 | 2.7 | 1.3 | 2.4 | 2.7 | 72.9 |
db file scattered read | 73 | 100.0 | .0 | .0 | .0 | .0 | .0 | .0 | |
db file sequential read | 938 | 99.8 | .2 | .0 | .0 | .0 | .0 | .0 | |
db file single write | 45 | 95.2 | 4.4 | .3 | .1 | ||||
direct path read | 79 | 97.8 | 1.3 | .7 | .1 | .1 | |||
direct path read temp | 3 | 99.9 | .0 | .0 | |||||
direct path sync | 2 | 100.0 | |||||||
direct path write temp | 8238 | 35.0 | 30.6 | 30.6 | 3.5 | .3 | .1 | ||
enq: CF - contention | 193 | 14.5 | 2.6 | 18.9 | 51.1 | 11.9 | .4 | .4 | |
enq: FB - contention | 19 | 98.9 | .3 | .5 | .1 | .1 | .2 | ||
enq: HW - contention | 8 | 98.3 | 1.5 | .2 | |||||
enq: SQ - contention | 1083 | 4.4 | 1.2 | 2.5 | 3.0 | 5.3 | 8.1 | 4.8 | 70.6 |
enq: TX - contention | 13 | 97.2 | 2.6 | .2 | |||||
enq: TX - index contention | 36 | 69.5 | 22.9 | 7.6 | |||||
enq: TX - row lock contention | 70 | 33.7 | 2.7 | 1.6 | 2.1 | 15.5 | 6.4 | 9.1 | 28.9 |
kksfbc child completion | 22 | 100.0 | |||||||
latch free | 563 | 94.3 | 4.0 | 1.5 | .1 | .1 | |||
latch: In memory undo latch | 78 | 38.0 | 3.1 | .8 | 3.1 | 12.4 | 24.8 | 16.3 | 1.6 |
latch: cache buffer handles | 7 | 100.0 | |||||||
latch: cache buffers chains | 3 | 99.9 | .0 | .1 | |||||
latch: call allocation | 44 | 99.3 | .7 | ||||||
latch: enqueue hash chains | 1 | 99.6 | .4 | ||||||
latch: shared pool | 95 | 98.2 | 1.2 | .4 | .1 | .1 | |||
library cache lock | 2 | 98.5 | 1.5 | ||||||
library cache: mutex X | 6417 | 91.9 | 6.6 | 1.3 | .2 | ||||
log buffer space | 7028 | 5.0 | 5.8 | 8.3 | 10.3 | 14.5 | 25.0 | 26.7 | 4.4 |
log file parallel write | 2614 | 73.5 | 12.7 | 4.5 | 1.9 | 1.7 | 2.7 | 2.6 | .3 |
log file sequential read | 1 | 100.0 | .0 | ||||||
log file single write | 13 | 93.8 | 5.7 | .5 | |||||
log file switch (checkpoint incomplete) | 185 | .2 | .1 | 6.3 | 1.6 | .4 | .4 | .6 | 90.5 |
log file switch (private strand flush incomplete) | 14 | 1.6 | 6.6 | 9.8 | 6.6 | 75.4 | |||
log file switch completion | 1363 | .3 | .7 | 3.0 | 5.9 | 13.0 | 30.2 | 45.8 | 1.0 |
log file sync | 13.9K | 30.7 | 11.4 | 6.8 | 5.6 | 5.1 | 8.3 | 27.8 | 4.3 |
os thread startup | 8 | 94.3 | 2.1 | 1.4 | 1.4 | .7 | |||
rdbms ipc reply | 35 | 2.9 | 11.4 | 85.7 | |||||
read by other session | 31 | 100.0 | .0 | .0 | .0 | .0 |
% of Total Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Waits 4s to 2m | <2s | <4s | <8s | <16s | <32s | < 1m | < 2m | >=2m |
Data file init write | 1 | 100.0 | .0 | ||||||
Disk file operations I/O | 2 | 99.9 | .1 | ||||||
buffer busy waits | 240 | 99.9 | .0 | .0 | .0 | .0 | .0 | .0 | |
control file parallel write | 5 | 99.9 | .1 | .0 | |||||
control file sequential read | 5 | 100.0 | .0 | ||||||
db file async I/O submit | 545 | 27.1 | 6.3 | 7.2 | 23.8 | 28.9 | 6.0 | .7 | |
db file scattered read | 1 | 100.0 | .0 | ||||||
db file sequential read | 10 | 100.0 | .0 | .0 | .0 | ||||
enq: CF - contention | 1 | 99.6 | .4 | ||||||
enq: JD - contention | 1 | 100.0 | |||||||
enq: KO - fast object checkpoint | 3 | 33.3 | 33.3 | 33.3 | |||||
enq: SQ - contention | 3062 | 29.4 | 3.4 | 3.3 | 9.2 | 25.5 | 23.6 | 5.6 | |
enq: TX - row lock contention | 54 | 71.1 | 10.2 | 2.7 | 1.1 | 9.1 | 4.8 | 1.1 | |
latch: In memory undo latch | 2 | 98.4 | 1.6 | ||||||
log buffer space | 344 | 95.6 | 3.4 | 1.1 | |||||
log file parallel write | 32 | 99.7 | .2 | .1 | |||||
log file switch (checkpoint incomplete) | 1795 | 9.5 | 1.7 | 3.2 | 6.7 | 28.6 | 42.0 | 8.3 | |
log file switch (private strand flush incomplete) | 46 | 24.6 | 6.6 | 47.5 | 21.3 | ||||
log file switch completion | 14 | 99.0 | 1.0 | ||||||
log file sync | 928 | 95.7 | 3.2 | 1.2 | .0 |
Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) |
---|---|---|---|---|
SYS$USERS | 198,608 | 4,870 | 1,885 | 140,929 |
SYS$BACKGROUND | 0 | 0 | 0 | 45 |
jqhx.localdomain | 0 | 0 | 0 | 0 |
jqhxXDB | 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 | 842195 | 819 | 327787 | 8652 | 0 | 0 | 599017 | 10 |
SYS$BACKGROUND | 9360 | 251 | 211 | 232 | 0 | 0 | 0 | 0 |
Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
129,280.89 | 16,374 | 7.90 | 61.74 | 0.02 | 0.00 | 2rgmdtpdz21yq | BEGIN proc_locationinfo(:1, :2... | |
128,009.58 | 16,380 | 7.81 | 61.13 | 0.01 | 0.00 | 79c9nwfb1cjqq | INSERT INTO T_LOCATION_INFO(F_... | |
26,695.15 | 7 | 3,813.59 | 12.75 | 0.69 | 0.03 | 08n2ck8z2c9wf | INSERT INTO F_PAR_EXC (ID, FSS... | |
3,633.85 | 1,112 | 3.27 | 1.74 | 0.02 | 0.00 | 4m7m0t6fjcs5x | update seq$ set increment$=:2,... | |
727.37 | 5 | 145.47 | 0.35 | 4.68 | 95.89 | d8ccpd7xxc1r3 | SELECT * FROM (SELECT DISTINCT... | |
581.96 | 60 | 9.70 | 0.28 | 0.01 | 0.00 | aq8yqxyyb40nn | update sys.job$ set this_date=... | |
255.44 | 17 | 15.03 | 0.12 | 0.01 | 0.00 | fkx9dq22y7mfc | INSERT INTO T_USER_LOG(ID, YHC... | |
243.62 | 6 | 40.60 | 0.12 | 0.01 | 0.00 | 4q7r5qcsmj9sx | INSERT INTO T_USER_LOG(ID, YHC... | |
208.68 | 11 | 18.97 | 0.10 | 0.01 | 0.00 | 5z5qgbd591awz | insert into t_id_card(f_id, f_... | |
208.38 | 5 | 41.68 | 0.10 | 0.01 | 0.00 | fyakfbwrt6wzc | INSERT INTO T_CO_LOG(ID, YHCZ,... |
CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
183.46 | 7 | 26.21 | 3.69 | 26,695.15 | 0.69 | 0.03 | 08n2ck8z2c9wf | INSERT INTO F_PAR_EXC (ID, FSS... | |
93.87 | 353,741 | 0.00 | 1.89 | 93.82 | 100.06 | 0.00 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
48.07 | 116,952 | 0.00 | 0.97 | 50.69 | 94.83 | 0.00 | 0k8522rmdzg4k | select privilege# from sysauth... | |
40.56 | 116,884 | 0.00 | 0.82 | 39.54 | 102.59 | 0.00 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
35.91 | 16 | 2.24 | 0.72 | 36.74 | 97.74 | 0.00 | 6n108h5t57a1c | SELECT * FROM (SELECT DISTINCT... | |
35.88 | 13 | 2.76 | 0.72 | 35.85 | 100.09 | 0.00 | 7hynf8h9wgrp5 | SELECT DISTINCT * FROM V_US_CO... | |
34.05 | 5 | 6.81 | 0.69 | 727.37 | 4.68 | 95.89 | d8ccpd7xxc1r3 | SELECT * FROM (SELECT DISTINCT... | |
30.57 | 16,374 | 0.00 | 0.62 | 129,280.89 | 0.02 | 0.00 | 2rgmdtpdz21yq | BEGIN proc_locationinfo(:1, :2... | |
29.32 | 116,887 | 0.00 | 0.59 | 31.38 | 93.44 | 0.00 | 459f3z9u4fb3u | select value$ from props$ wher... | |
20.69 | 116,889 | 0.00 | 0.42 | 22.30 | 92.77 | 0.00 | 5ur69atw3vfhj | select decode(failover_method,... |
User I/O Time (s) | Executions | UIO per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
697.45 | 5 | 139.49 | 65.19 | 727.37 | 4.68 | 95.89 | d8ccpd7xxc1r3 | SELECT * FROM (SELECT DISTINCT... | |
37.92 | 53 | 0.72 | 3.54 | 154.10 | 1.22 | 24.61 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
15.56 | 1,399 | 0.01 | 1.45 | 172.26 | 0.64 | 9.03 | d5jz0t3f6r3bd | INSERT INTO SMS_SEND (ID, YWMC... | |
7.88 | 7 | 1.13 | 0.74 | 26,695.15 | 0.69 | 0.03 | 08n2ck8z2c9wf | INSERT INTO F_PAR_EXC (ID, FSS... | |
5.17 | 256 | 0.02 | 0.48 | 50.47 | 0.38 | 10.24 | 167wxs395avun | INSERT INTO SMS_SEND (ID, YWMC... | |
3.27 | 1 | 3.27 | 0.31 | 8.87 | 63.29 | 36.88 | 1dvscgrr5mvnt | SELECT * FROM (SELECT DISTINCT... | |
0.71 | 3 | 0.24 | 0.07 | 1.91 | 62.35 | 37.07 | 2vy72b63rxzq6 | SELECT * FROM (SELECT DISTINCT... | |
0.52 | 16,374 | 0.00 | 0.05 | 129,280.89 | 0.02 | 0.00 | 2rgmdtpdz21yq | BEGIN proc_locationinfo(:1, :2... | |
0.52 | 16,380 | 0.00 | 0.05 | 128,009.58 | 0.01 | 0.00 | 79c9nwfb1cjqq | INSERT INTO T_LOCATION_INFO(F_... | |
0.16 | 1 | 0.16 | 0.02 | 0.16 | 1.21 | 98.68 | 39ax31acw29z6 | Oracle Enterprise Manager.current metric purge | WITH MET AS (SELECT DISTINCT M... |
Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
11,620,268 | 7 | 1,660,038.29 | 8.14 | 26,695.15 | .7 | 0 | 08n2ck8z2c9wf | INSERT INTO F_PAR_EXC (ID, FSS... | |
3,283,288 | 353,741 | 9.28 | 2.30 | 93.82 | 100.1 | 0 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
704,714 | 116,952 | 6.03 | 0.49 | 50.69 | 94.8 | 0 | 0k8522rmdzg4k | select privilege# from sysauth... | |
379,615 | 1 | 379,615.00 | 0.27 | 33.42 | 8.4 | 0 | 4nvpc4u7w1z7g | UPDATE F_PAR SET DQZT=0, SJC='... | |
366,317 | 193 | 1,898.02 | 0.26 | 9.19 | 99.8 | 0 | bngd3h7xxyz19 | UPDATE SMS_RECV SET CLZT=1, DQ... | |
366,314 | 193 | 1,898.00 | 0.26 | 7.51 | 99.7 | 0 | 8cacvv4vp0bbm | UPDATE SMS_RECV SET CLZT=1, DQ... | |
350,659 | 116,887 | 3.00 | 0.25 | 31.38 | 93.4 | 0 | 459f3z9u4fb3u | select value$ from props$ wher... | |
250,201 | 3 | 83,400.33 | 0.18 | 87.51 | 3.4 | 0 | 7u7fwuv8z8fjf | SELECT V.GUID, V.ZHMC, V.SJHM,... | |
233,776 | 116,889 | 2.00 | 0.16 | 22.30 | 92.8 | 0 | 5ur69atw3vfhj | select decode(failover_method,... | |
163,572 | 27,262 | 6.00 | 0.11 | 7.72 | 97.5 | 0 | 4htx4ts19yknq | select f_ip, to_char(f_invalid... |
Physical Reads | Executions | Reads per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
242,097 | 7 | 34,585.29 | 12.83 | 26,695.15 | 0.69 | 0.03 | 08n2ck8z2c9wf | INSERT INTO F_PAR_EXC (ID, FSS... | |
143,285 | 5 | 28,657.00 | 7.59 | 727.37 | 4.68 | 95.89 | d8ccpd7xxc1r3 | SELECT * FROM (SELECT DISTINCT... | |
1,730 | 1 | 1,730.00 | 0.09 | 33.42 | 8.40 | 0.05 | 4nvpc4u7w1z7g | UPDATE F_PAR SET DQZT=0, SJC='... | |
1,689 | 3 | 563.00 | 0.09 | 87.51 | 3.41 | 0.02 | 7u7fwuv8z8fjf | SELECT V.GUID, V.ZHMC, V.SJHM,... | |
1,497 | 1,399 | 1.07 | 0.08 | 172.26 | 0.64 | 9.03 | d5jz0t3f6r3bd | INSERT INTO SMS_SEND (ID, YWMC... | |
1,200 | 1 | 1,200.00 | 0.06 | 8.87 | 63.29 | 36.88 | 1dvscgrr5mvnt | SELECT * FROM (SELECT DISTINCT... | |
1,148 | 53 | 21.66 | 0.06 | 154.10 | 1.22 | 24.61 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
346 | 16,374 | 0.02 | 0.02 | 129,280.89 | 0.02 | 0.00 | 2rgmdtpdz21yq | BEGIN proc_locationinfo(:1, :2... | |
346 | 16,380 | 0.02 | 0.02 | 128,009.58 | 0.01 | 0.00 | 79c9nwfb1cjqq | INSERT INTO T_LOCATION_INFO(F_... | |
225 | 256 | 0.88 | 0.01 | 50.47 | 0.38 | 10.24 | 167wxs395avun | INSERT INTO SMS_SEND (ID, YWMC... |
UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
21,342 | 21,342 | 7 | 3,048.86 | 0.00 | 3.08 | 08n2ck8z2c9wf | INSERT INTO F_PAR_EXC (ID, FSS... | |
5,831 | 5,831 | 5 | 1,166.20 | 0.00 | 0.84 | d8ccpd7xxc1r3 | SELECT * FROM (SELECT DISTINCT... | |
1,550 | 1,550 | 1 | 1,550.00 | 0.00 | 0.22 | 4nvpc4u7w1z7g | UPDATE F_PAR SET DQZT=0, SJC='... | |
1,107 | 1,107 | 53 | 20.89 | 0.00 | 0.16 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
975 | 975 | 3 | 325.00 | 0.00 | 0.14 | 7u7fwuv8z8fjf | SELECT V.GUID, V.ZHMC, V.SJHM,... | |
346 | 346 | 16,374 | 0.02 | 0.00 | 0.05 | 2rgmdtpdz21yq | BEGIN proc_locationinfo(:1, :2... | |
346 | 346 | 16,380 | 0.02 | 0.00 | 0.05 | 79c9nwfb1cjqq | INSERT INTO T_LOCATION_INFO(F_... | |
225 | 225 | 256 | 0.88 | 0.00 | 0.03 | 167wxs395avun | INSERT INTO SMS_SEND (ID, YWMC... | |
80 | 80 | 1 | 80.00 | 0.00 | 0.01 | 1dvscgrr5mvnt | SELECT * FROM (SELECT DISTINCT... | |
70 | 70 | 74 | 0.95 | 0.00 | 0.01 | 2zfk3ymatx835 | oracle@bogon (TNS V1-V3) | INSERT INTO "SMS_SEND" "A1" ("... |
Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
353,741 | 4,796,750 | 13.56 | 93.82 | 100.1 | 0 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
116,952 | 353,801 | 3.03 | 50.69 | 94.8 | 0 | 0k8522rmdzg4k | select privilege# from sysauth... | |
116,889 | 116,889 | 1.00 | 22.30 | 92.8 | 0 | 5ur69atw3vfhj | select decode(failover_method,... | |
116,887 | 116,889 | 1.00 | 31.38 | 93.4 | 0 | 459f3z9u4fb3u | select value$ from props$ wher... | |
116,884 | 116,884 | 1.00 | 39.54 | 102.6 | 0 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
27,262 | 27,262 | 1.00 | 7.72 | 97.5 | 0 | 4htx4ts19yknq | select f_ip, to_char(f_invalid... | |
16,380 | 16,380 | 1.00 | 128,009.58 | 0 | 0 | 79c9nwfb1cjqq | INSERT INTO T_LOCATION_INFO(F_... | |
16,374 | 16,378 | 1.00 | 129,280.89 | 0 | 0 | 2rgmdtpdz21yq | BEGIN proc_locationinfo(:1, :2... | |
3,269 | 3,269 | 1.00 | 0.26 | 88.2 | 8.8 | grwydz59pu6mc | select text from view$ where r... | |
1,399 | 1,399 | 1.00 | 172.26 | .6 | 9 | d5jz0t3f6r3bd | INSERT INTO SMS_SEND (ID, YWMC... |
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
116,955 | 353,741 | 14.60 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
116,950 | 116,952 | 14.60 | 0k8522rmdzg4k | select privilege# from sysauth... | |
116,889 | 116,884 | 14.59 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
116,889 | 116,889 | 14.59 | 5ur69atw3vfhj | select decode(failover_method,... | |
116,887 | 116,887 | 14.59 | 459f3z9u4fb3u | select value$ from props$ wher... | |
27,262 | 27,262 | 3.40 | 4htx4ts19yknq | select f_ip, to_char(f_invalid... | |
16,385 | 16,374 | 2.05 | 2rgmdtpdz21yq | BEGIN proc_locationinfo(:1, :2... | |
16,385 | 16,380 | 2.05 | 79c9nwfb1cjqq | INSERT INTO T_LOCATION_INFO(F_... | |
1,059 | 1,112 | 0.13 | 4m7m0t6fjcs5x | update seq$ set increment$=:2,... | |
884 | 3,269 | 0.11 | grwydz59pu6mc | select text from view$ where r... |
Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
2,895,643 | 1 | 0.06 | 70kukc7sj9utm | SELECT * FROM (SELECT DISTINCT... | |
2,216,315 | 1 | 0.05 | bzahms2z5x2qk | SELECT * FROM (SELECT DISTINCT... | |
2,193,171 | 20 | 0.05 | 8qhvuumj0ngbb | SELECT * FROM (SELECT DISTINCT... | |
2,176,907 | 20 | 0.04 | 8qhvuumj0ngbb | SELECT * FROM (SELECT DISTINCT... | |
1,748,938 | 3 | 0.04 | f5qhp77fs8bvv | Oracle SQL Developer | SELECT s.owner, s.synonym_name... |
1,480,103 | 4 | 0.03 | 5gh60az1a4s7w | SELECT * FROM (SELECT DISTINCT... | |
1,479,307 | 2 | 0.03 | fk4u2awrujc6v | SELECT * FROM (SELECT DISTINCT... | |
1,474,263 | 3 | 0.03 | 4gbrkgg3sr7gq | SELECT * FROM (SELECT DISTINCT... | |
1,466,915 | 2 | 0.03 | 5dfm3pju4gjas | SELECT * FROM (SELECT DISTINCT... | |
1,460,375 | 4 | 0.03 | avh53nb5qwq9a | SELECT * FROM (SELECT DISTINCT... | |
1,460,351 | 4 | 0.03 | avh53nb5qwq9a | SELECT * FROM (SELECT DISTINCT... | |
1,450,733 | 20 | 0.03 | bcp1yfzdsfq57 | SELECT * FROM (SELECT DISTINCT... | |
1,450,661 | 6 | 0.03 | 38d79tpwkfvvv | SELECT * FROM (SELECT DISTINCT... | |
1,450,601 | 3 | 0.03 | 2vy72b63rxzq6 | SELECT * FROM (SELECT DISTINCT... | |
1,442,465 | 3 | 0.03 | 2vy72b63rxzq6 | SELECT * FROM (SELECT DISTINCT... | |
1,434,445 | 20 | 0.03 | bcp1yfzdsfq57 | SELECT * FROM (SELECT DISTINCT... | |
1,434,341 | 6 | 0.03 | 38d79tpwkfvvv | SELECT * FROM (SELECT DISTINCT... | |
1,080,981 | 1 | 0.02 | 1dvscgrr5mvnt | SELECT * FROM (SELECT DISTINCT... | |
1,074,535 | 5 | 0.02 | d8ccpd7xxc1r3 | SELECT * FROM (SELECT DISTINCT... |
Version Count | Executions | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|
51 | 1 | a0xc4nq6swjvy | INSERT INTO wri$_adv_addm_fdg ... | |
39 | 0 | 0v3dvmc22qnam | insert into sys.col_usage$ (ob... | |
37 | 1 | b3zgx1xckrwxu | select host, userid, password,... | |
28 | 2 | 69k5bhm12sz98 | SELECT dbin.instance_number, d... | |
26 | 225 | 8vwv6hx92ymmm | UPDATE MGMT_CURRENT_METRICS SE... | |
26 | 225 | 8vwv6hx92ymmm | UPDATE MGMT_CURRENT_METRICS SE... | |
25 | 1 | 23nad9x295gkf | SELECT (m.current_size / 10485... | |
22 | 177 | 08bqjmf8490s2 | SEVERITY EVALUATION | SELECT PARAMETER_VALUE FROM MG... |
22 | 116,884 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
22 | 116,887 | 459f3z9u4fb3u | select value$ from props$ wher... | |
22 | 27,262 | 4htx4ts19yknq | select f_ip, to_char(f_invalid... | |
22 | 116,889 | 5ur69atw3vfhj | select decode(failover_method,... | |
22 | 16,380 | 79c9nwfb1cjqq | INSERT INTO T_LOCATION_INFO(F_... | |
21 | 1 | c8gnrhxma4tas | SELECT owner#, property FROM s... |
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 slow jump 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 | 7 | 0.00 | 0.00 |
CCursor + sql area evicted | 157 | 0.04 | 0.01 |
CPU used by this session | 293,411 | 82.31 | 11.36 |
CPU used when call started | 282,286 | 79.19 | 10.93 |
CR blocks created | 5,348 | 1.50 | 0.21 |
Cached Commit SCN referenced | 558 | 0.16 | 0.02 |
Commit SCN cached | 6 | 0.00 | 0.00 |
DB time | 19,466,632 | 5,460.90 | 753.88 |
DBWR checkpoint buffers written | 921,900 | 258.62 | 35.70 |
DBWR checkpoints | 107 | 0.03 | 0.00 |
DBWR object drop buffers written | 0 | 0.00 | 0.00 |
DBWR revisited being-written buffer | 28 | 0.01 | 0.00 |
DBWR tablespace checkpoint buffers written | 23 | 0.01 | 0.00 |
DBWR thread checkpoint buffers written | 921,329 | 258.46 | 35.68 |
DBWR transaction table writes | 1,639 | 0.46 | 0.06 |
DBWR undo block writes | 25,069 | 7.03 | 0.97 |
HSC Heap Segment Block Changes | 1,751,029 | 491.21 | 67.81 |
HSC IDL Compressed Blocks | 0 | 0.00 | 0.00 |
Heap Segment Array Inserts | 1,721,028 | 482.79 | 66.65 |
Heap Segment Array Updates | 286 | 0.08 | 0.01 |
IMU CR rollbacks | 152 | 0.04 | 0.01 |
IMU Flushes | 843 | 0.24 | 0.03 |
IMU Redo allocation size | 1,216,640 | 341.30 | 47.12 |
IMU commits | 5,351 | 1.50 | 0.21 |
IMU contention | 199 | 0.06 | 0.01 |
IMU ktichg flush | 0 | 0.00 | 0.00 |
IMU pool not allocated | 34,190 | 9.59 | 1.32 |
IMU recursive-transaction flush | 0 | 0.00 | 0.00 |
IMU undo allocation size | 5,622,976 | 1,577.39 | 217.76 |
IMU- failed to get a private strand | 34,190 | 9.59 | 1.32 |
LOB table id lookup cache misses | 0 | 0.00 | 0.00 |
Number of read IOs issued | 3,600 | 1.01 | 0.14 |
PX local messages recv'd | 0 | 0.00 | 0.00 |
PX local messages sent | 0 | 0.00 | 0.00 |
Requests to/from client | 523,006 | 146.72 | 20.25 |
RowCR - row contention | 79 | 0.02 | 0.00 |
RowCR attempts | 174 | 0.05 | 0.01 |
RowCR hits | 95 | 0.03 | 0.00 |
SMON posted for undo segment recovery | 0 | 0.00 | 0.00 |
SMON posted for undo segment shrink | 1 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 523,382 | 146.82 | 20.27 |
SQL*Net roundtrips to/from dblink | 72 | 0.02 | 0.00 |
TBS Extension: bytes extended | 6,442,450,944 | 1,807,277.51 | 249,494.65 |
TBS Extension: files extended | 6 | 0.00 | 0.00 |
TBS Extension: tasks created | 2 | 0.00 | 0.00 |
TBS Extension: tasks executed | 2 | 0.00 | 0.00 |
active txn count during cleanout | 1,005,421 | 282.05 | 38.94 |
application wait time | 140,029 | 39.28 | 5.42 |
auto extends on undo tablespace | 0 | 0.00 | 0.00 |
background checkpoints completed | 100 | 0.03 | 0.00 |
background checkpoints started | 104 | 0.03 | 0.00 |
background timeouts | 17,708 | 4.97 | 0.69 |
branch node splits | 0 | 0.00 | 0.00 |
buffer is not pinned count | 1,649,542 | 462.74 | 63.88 |
buffer is pinned count | 1,743,148 | 489.00 | 67.51 |
bytes received via SQL*Net from client | 92,603,639 | 25,977.76 | 3,586.23 |
bytes received via SQL*Net from dblink | 35,697 | 10.01 | 1.38 |
bytes sent via SQL*Net to client | 458,384,983 | 128,589.08 | 17,751.72 |
bytes sent via SQL*Net to dblink | 24,885 | 6.98 | 0.96 |
calls to get snapshot scn: kcmgss | 926,832 | 260.00 | 35.89 |
calls to kcmgas | 95,327 | 26.74 | 3.69 |
calls to kcmgcs | 2,580,441 | 723.88 | 99.93 |
cell physical IO interconnect bytes | 71,170,379,264 | 19,965,169.64 | 2,756,191.59 |
change write time | 624,719 | 175.25 | 24.19 |
cleanout - number of ktugct calls | 943,459 | 264.67 | 36.54 |
cleanouts and rollbacks - consistent read gets | 1,638 | 0.46 | 0.06 |
cleanouts only - consistent read gets | 61 | 0.02 | 0.00 |
cluster key scan block gets | 4,425 | 1.24 | 0.17 |
cluster key scans | 3,341 | 0.94 | 0.13 |
commit batch performed | 0 | 0.00 | 0.00 |
commit batch requested | 0 | 0.00 | 0.00 |
commit batch/immediate performed | 91 | 0.03 | 0.00 |
commit batch/immediate requested | 91 | 0.03 | 0.00 |
commit cleanout failures: block lost | 44,259 | 12.42 | 1.71 |
commit cleanout failures: buffer being written | 5 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 7 | 0.00 | 0.00 |
commit cleanout failures: cannot pin | 190 | 0.05 | 0.01 |
commit cleanouts | 102,878 | 28.86 | 3.98 |
commit cleanouts successfully completed | 58,417 | 16.39 | 2.26 |
commit immediate performed | 91 | 0.03 | 0.00 |
commit immediate requested | 91 | 0.03 | 0.00 |
commit txn count during cleanout | 476 | 0.13 | 0.02 |
concurrency wait time | 963,323 | 270.24 | 37.31 |
consistent changes | 24,057 | 6.75 | 0.93 |
consistent gets | 134,098,059 | 37,618.04 | 5,193.17 |
consistent gets - examination | 1,804,118 | 506.10 | 69.87 |
consistent gets direct | 229,502 | 64.38 | 8.89 |
consistent gets from cache | 133,868,557 | 37,553.66 | 5,184.28 |
consistent gets from cache (fastpath) | 131,117,273 | 36,781.86 | 5,077.73 |
cursor authentications | 699 | 0.20 | 0.03 |
data blocks consistent reads - undo records applied | 8,121 | 2.28 | 0.31 |
db block changes | 6,924,722 | 1,942.57 | 268.17 |
db block gets | 8,655,540 | 2,428.11 | 335.20 |
db block gets direct | 692 | 0.19 | 0.03 |
db block gets from cache | 8,654,848 | 2,427.91 | 335.17 |
db block gets from cache (fastpath) | 1,404,216 | 393.92 | 54.38 |
deferred (CURRENT) block cleanout applications | 26,348 | 7.39 | 1.02 |
dirty buffers inspected | 35,256 | 9.89 | 1.37 |
enqueue conversions | 1,206 | 0.34 | 0.05 |
enqueue deadlocks | 9 | 0.00 | 0.00 |
enqueue releases | 774,067 | 217.15 | 29.98 |
enqueue requests | 774,258 | 217.20 | 29.98 |
enqueue timeouts | 62 | 0.02 | 0.00 |
enqueue waits | 7,558 | 2.12 | 0.29 |
exchange deadlocks | 20 | 0.01 | 0.00 |
execute count | 916,619 | 257.14 | 35.50 |
failed probes on index block reclamation | 0 | 0.00 | 0.00 |
file io service time | 72 | 0.02 | 0.00 |
file io wait time | 10,454,260,134 | 2,932,695.87 | 404,858.65 |
free buffer inspected | 4,161,323 | 1,167.36 | 161.15 |
free buffer requested | 2,481,373 | 696.09 | 96.10 |
global undo segment hints helped | 0 | 0.00 | 0.00 |
heap block compress | 1,052 | 0.30 | 0.04 |
hot buffers moved to head of LRU | 494,585 | 138.74 | 19.15 |
immediate (CR) block cleanout applications | 1,699 | 0.48 | 0.07 |
immediate (CURRENT) block cleanout applications | 801 | 0.22 | 0.03 |
in call idle wait time | 8,872,551 | 2,488.98 | 343.60 |
index crx upgrade (positioned) | 27 | 0.01 | 0.00 |
index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
index fast full scans (full) | 42 | 0.01 | 0.00 |
index fetch by key | 115,510 | 32.40 | 4.47 |
index scans kdiixs1 | 3,613,426 | 1,013.66 | 139.94 |
leaf node 90-10 splits | 108 | 0.03 | 0.00 |
leaf node splits | 141 | 0.04 | 0.01 |
lob reads | 0 | 0.00 | 0.00 |
lob writes | 46 | 0.01 | 0.00 |
lob writes unaligned | 46 | 0.01 | 0.00 |
logical read bytes from cache | 1,167,551,578,112 | 327,529,030.45 | 45,215,381.38 |
logons cumulative | 114,368 | 32.08 | 4.43 |
max cf enq hold time | 11,200 | 3.14 | 0.43 |
messages received | 144,469 | 40.53 | 5.59 |
messages sent | 144,475 | 40.53 | 5.60 |
min active SCN optimization applied on CR | 0 | 0.00 | 0.00 |
no buffer to keep pinned count | 0 | 0.00 | 0.00 |
no work - consistent read gets | 130,504,563 | 36,609.97 | 5,054.01 |
non-idle wait count | 4,605,468 | 1,291.96 | 178.35 |
non-idle wait time | 21,842,898 | 6,127.51 | 845.90 |
opened cursors cumulative | 1,115,182 | 312.84 | 43.19 |
parse count (describe) | 22 | 0.01 | 0.00 |
parse count (failures) | 70,782 | 19.86 | 2.74 |
parse count (hard) | 99,285 | 27.85 | 3.84 |
parse count (total) | 801,020 | 224.71 | 31.02 |
parse time cpu | 31,891 | 8.95 | 1.24 |
parse time elapsed | 62,522 | 17.54 | 2.42 |
physical read IO requests | 693,407 | 194.52 | 26.85 |
physical read bytes | 15,463,530,496 | 4,337,928.40 | 598,851.00 |
physical read total IO requests | 1,650,088 | 462.89 | 63.90 |
physical read total bytes | 38,872,964,096 | 10,904,892.32 | 1,505,420.34 |
physical read total multi block requests | 21,550 | 6.05 | 0.83 |
physical reads | 1,887,638 | 529.53 | 73.10 |
physical reads cache | 1,513,651 | 424.62 | 58.62 |
physical reads cache prefetch | 829,763 | 232.77 | 32.13 |
physical reads direct | 373,987 | 104.91 | 14.48 |
physical reads direct (lob) | 0 | 0.00 | 0.00 |
physical reads direct temporary tablespace | 144,485 | 40.53 | 5.60 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 756,627 | 212.25 | 29.30 |
physical write bytes | 10,245,079,040 | 2,874,015.05 | 396,757.77 |
physical write total IO requests | 797,243 | 223.65 | 30.87 |
physical write total bytes | 32,297,415,168 | 9,060,277.31 | 1,250,771.25 |
physical write total multi block requests | 40,915 | 11.48 | 1.58 |
physical writes | 1,250,620 | 350.83 | 48.43 |
physical writes direct | 287,260 | 80.58 | 11.12 |
physical writes direct (lob) | 21 | 0.01 | 0.00 |
physical writes direct temporary tablespace | 286,568 | 80.39 | 11.10 |
physical writes from cache | 963,360 | 270.25 | 37.31 |
physical writes non checkpoint | 1,205,932 | 338.30 | 46.70 |
pinned buffers inspected | 263 | 0.07 | 0.01 |
pinned cursors current | 14 | 0.00 | 0.00 |
prefetch clients - default | 24 | 0.01 | 0.00 |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
prefetch warmup blocks flushed out before use | 0 | 0.00 | 0.00 |
prefetched blocks aged out before use | 503 | 0.14 | 0.02 |
process last non-idle time | 3,840 | 1.08 | 0.15 |
recovery block gets from cache | 0 | 0.00 | 0.00 |
recovery blocks read | 0 | 0.00 | 0.00 |
recursive calls | 11,457,978 | 3,214.27 | 443.73 |
recursive cpu usage | 62,174 | 17.44 | 2.41 |
redo KB read | 7,566,505 | 2,122.60 | 293.03 |
redo blocks checksummed by FG (exclusive) | 12,832,877 | 3,599.96 | 496.97 |
redo blocks read for recovery | 0 | 0.00 | 0.00 |
redo blocks written | 15,064,030 | 4,225.86 | 583.38 |
redo buffer allocation retries | 14,864 | 4.17 | 0.58 |
redo entries | 5,103,054 | 1,431.54 | 197.62 |
redo k-bytes read for recovery | 0 | 0.00 | 0.00 |
redo log space requests | 778,425 | 218.37 | 30.15 |
redo log space wait time | 7,067,588 | 1,982.64 | 273.70 |
redo ordering marks | 60,830 | 17.06 | 2.36 |
redo size | 7,515,264,168 | 2,108,229.93 | 291,041.13 |
redo size for direct writes | 5,743,232 | 1,611.13 | 222.42 |
redo subscn max counts | 959,584 | 269.19 | 37.16 |
redo synch long waits | 941 | 0.26 | 0.04 |
redo synch time | 1,468,967 | 412.08 | 56.89 |
redo synch time (usec) | 14,688,959,819 | 4,120,640.88 | 568,854.46 |
redo synch writes | 21,324 | 5.98 | 0.83 |
redo wastage | 2,829,856 | 793.85 | 109.59 |
redo write time | 99,704 | 27.97 | 3.86 |
redo writes | 9,998 | 2.80 | 0.39 |
rollback changes - undo records applied | 114 | 0.03 | 0.00 |
rollbacks only - consistent read gets | 1,237 | 0.35 | 0.05 |
root node splits | 0 | 0.00 | 0.00 |
rows fetched via callback | 78,853 | 22.12 | 3.05 |
scheduler wait time | 0 | 0.00 | 0.00 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 244,325 | 68.54 | 9.46 |
session logical reads | 142,753,651 | 40,046.17 | 5,528.37 |
shared hash latch upgrades - no wait | 119,260 | 33.46 | 4.62 |
shared hash latch upgrades - wait | 164 | 0.05 | 0.01 |
sorts (disk) | 5 | 0.00 | 0.00 |
sorts (memory) | 1,052,815 | 295.34 | 40.77 |
sorts (rows) | 16,242,894 | 4,556.56 | 629.03 |
sql area evicted | 30,798 | 8.64 | 1.19 |
sql area purged | 23 | 0.01 | 0.00 |
summed dirty queue length | 94,003 | 26.37 | 3.64 |
switch current to new buffer | 2,385 | 0.67 | 0.09 |
table fetch by rowid | 134,786 | 37.81 | 5.22 |
table fetch continued row | 252 | 0.07 | 0.01 |
table scan blocks gotten | 127,023,954 | 35,633.57 | 4,919.21 |
table scan rows gotten | 4,156,004,695 | 1,165,869.00 | 160,948.21 |
table scans (direct read) | 3 | 0.00 | 0.00 |
table scans (long tables) | 672 | 0.19 | 0.03 |
table scans (short tables) | 331,968 | 93.13 | 12.86 |
temp space allocated (bytes) | 0 | 0.00 | 0.00 |
total cf enq hold time | 152,320 | 42.73 | 5.90 |
total number of cf enq holders | 134,251 | 37.66 | 5.20 |
total number of times SMON posted | 14 | 0.00 | 0.00 |
transaction rollbacks | 71 | 0.02 | 0.00 |
transaction tables consistent read rollbacks | 0 | 0.00 | 0.00 |
transaction tables consistent reads - undo records applied | 84 | 0.02 | 0.00 |
undo change vector size | 193,090,860 | 54,167.08 | 7,477.77 |
user I/O wait time | 109,005 | 30.58 | 4.22 |
user calls | 927,583 | 260.21 | 35.92 |
user commits | 21,425 | 6.01 | 0.83 |
user rollbacks | 4,397 | 1.23 | 0.17 |
workarea executions - onepass | 10 | 0.00 | 0.00 |
workarea executions - optimal | 477,957 | 134.08 | 18.51 |
write clones created in background | 487 | 0.14 | 0.02 |
write clones created in foreground | 2,473 | 0.69 | 0.10 |
Statistic | Begin Value | End Value |
---|---|---|
opened cursors current | 312 | 392 |
workarea memory allocated | 31,489 | 30,129 |
logons current | 766 | 856 |
session uga memory max | 23,569,646,257,872 | 23,619,087,336,312 |
session pga memory | 118,065,852,624 | 118,279,969,680 |
session pga memory max | 139,435,717,488 | 139,786,186,224 |
session cursor cache count | 483,147,271 | 483,869,138 |
session uga memory | 222,993,844,916,328 | 223,257,268,856,504 |
Statistic | Total | per Hour |
---|---|---|
log switches (derived) | 104 | 105.03 |
Function Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
---|---|---|---|---|---|---|---|---|
LGWR | 14.6G | 267.57 | 4.17984 | 7.3G | 5.76 | 2.09441 | 976.1K | 2.13 |
Others | 7.6G | 5.73 | 2.17856 | 13.4G | 6.11 | 3.84769 | 42.2K | 14.13 |
Buffer Cache Reads | 11.6G | 191.93 | 3.32059 | 0M | 0.00 | 0M | 684.2K | 0.16 |
DBWR | 0M | 0.01 | 0M | 7.4G | 211.15 | 2.13508 | 784 | 13414.30 |
Direct Reads | 2.8G | 2.66 | .815770 | 982M | 1.68 | .275476 | 9503 | 0.93 |
Direct Writes | 0M | 0.00 | 0M | 1.2G | 1.89 | .354024 | 12.7K | 54.50 |
Streams AQ | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 13 | 44.31 |
TOTAL: | 36.5G | 467.89 | 10.4947 | 30.3G | 226.59 | 8.70669 | 1725.5K | 8.12 |
Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read |
---|---|---|---|---|---|---|---|---|
Data File | 13.3G | 193.21 | 3.82329 | 7.4G | 211.44 | 2.13901 | 0.17 | 1.63 |
Control File | 14.8G | 270.74 | 4.26484 | 145M | 2.61 | .040676 | 0.03 | 0.00 |
Log File | 7.3G | 2.29 | 2.09889 | 7.3G | 5.17 | 2.08515 | 0.06 | 0.00 |
Archive Log | 0M | 0.00 | 0M | 7.3G | 2.11 | 2.09525 | ||
Temp File | 1.1G | 1.66 | .316714 | 2.2G | 3.55 | .628098 | 0.00 | 0.07 |
TOTAL: | 36.6G | 467.90 | 10.5037 | 24.3G | 224.89 | 6.98819 | 0.09 | 0.72 |
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 | 14.6G | 267.57 | 4.17984 | 7.3G | 5.78 | 2.10507 | 954K | 0.03 |
LGWR (Control File) | 14.6G | 267.51 | 4.17984 | 33M | 0.59 | .009257 | 953.6K | 0.02 |
LGWR (Log File) | 0M | 0.06 | 0M | 7.3G | 5.18 | 2.09581 | 424 | 6.73 |
Others | 7.6G | 5.75 | 2.18754 | 13.4G | 6.12 | 3.85723 | 21.4K | 1.32 |
Others (Log File) | 7.3G | 2.23 | 2.10030 | 0M | 0.00 | 0M | 7964 | 0.01 |
Others (Archive Log) | 0M | 0.00 | 0M | 7.3G | 2.11 | 2.10002 | 0 | |
Others (Data File) | 8M | 0.27 | .002244 | 6G | 1.99 | 1.72551 | 1916 | 12.07 |
Others (Control File) | 303M | 3.24 | .084999 | 113M | 2.02 | .031699 | 11.5K | 0.45 |
Buffer Cache Reads | 11.6G | 191.98 | 3.32592 | 0M | 0.00 | 0M | 684.3K | 0.16 |
Buffer Cache Reads (Data File) | 11.6G | 191.98 | 3.32592 | 0M | 0.00 | 0M | 684.3K | 0.16 |
DBWR | 0M | 0.01 | 0M | 7.4G | 211.22 | 2.13789 | 30 | 0.00 |
DBWR (Data File) | 0M | 0.00 | 0M | 7.4G | 211.22 | 2.13789 | 0 | |
DBWR (Control File) | 0M | 0.01 | 0M | 0M | 0.00 | 0M | 30 | 0.00 |
Direct Reads | 2.8G | 2.66 | .815770 | 982M | 1.68 | .275476 | 0 | |
Direct Reads (Data File) | 2.8G | 2.66 | .815770 | 982M | 1.68 | .275476 | 0 | |
Direct Writes | 0M | 0.00 | 0M | 1.2G | 1.89 | .354024 | 0 | |
Direct Writes (Data File) | 0M | 0.00 | 0M | 1.2G | 1.89 | .354024 | 0 | |
Streams AQ | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 13 | 44.31 |
Streams AQ (Data File) | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 13 | 44.31 |
TOTAL: | 36.6G | 467.96 | 10.5090 | 30.4G | 226.69 | 8.72970 | 1659.8K | 0.10 |
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
USERCENTER20120220_DATA | 685,493 | 192 | 0.09 | 2.54 | 713,973 | 200 | 496,734 | 13.18 |
USERCENTER_TEMP | 5,911 | 2 | 0.00 | 24.44 | 12,670 | 4 | 0 | 0.00 |
UNDOTBS1 | 73 | 0 | 0.00 | 1.00 | 17,670 | 5 | 411 | 608.42 |
SYSAUX | 1,163 | 0 | 28.49 | 1.05 | 1,168 | 0 | 0 | 0.00 |
SYSTEM | 400 | 0 | 24.38 | 1.00 | 169 | 0 | 1,078 | 975.42 |
USERCENTER_HIS | 2 | 0 | 35.00 | 1.00 | 0 | 0 | 0 | 0.00 |
USERCENTER_INFO | 2 | 0 | 45.00 | 1.00 | 0 | 0 | 0 | 0.00 |
USERS | 2 | 0 | 45.00 | 1.00 | 0 | 0 | 0 | 0.00 |
EXAMPLE | 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 | /opt/oracle/oradata/jqhx/example01.dbf | 1 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
SYSAUX | /opt/oracle/oradata/jqhx/sysaux01.dbf | 1,163 | 0 | 28.49 | 1.05 | 1,168 | 0 | 0 | 0.00 |
SYSTEM | /opt/oracle/oradata/jqhx/system01.dbf | 400 | 0 | 24.38 | 1.00 | 169 | 0 | 1,078 | 975.42 |
UNDOTBS1 | /opt/oracle/oradata/jqhx/undotbs01.dbf | 73 | 0 | 0.00 | 1.00 | 17,670 | 5 | 411 | 608.42 |
USERCENTER20120220_DATA | /opt/oracle/oradata/jqhx/USERCENTER20120220_DATA.dbf | 630,714 | 177 | 0.09 | 2.51 | 2,540 | 1 | 185,452 | 24.04 |
USERCENTER20120220_DATA | /opt/oracle/oradata/jqhx/USERCENTER20120220_DATA1.dbf | 54,268 | 15 | 0.09 | 2.84 | 363,141 | 102 | 165,324 | 7.41 |
USERCENTER20120220_DATA | /opt/oracle/oradata/jqhx/USERCENTER20120220_DATA2.dbf | 511 | 0 | 2.58 | 1.00 | 348,292 | 98 | 145,958 | 5.93 |
USERCENTER_HIS | /opt/oracle/oradata/jqhx/USERCENTER_HIS.dbf | 2 | 0 | 35.00 | 1.00 | 0 | 0 | 0 | 0.00 |
USERCENTER_INFO | /opt/oracle/oradata/jqhx/USERCENTER_INFO.dbf | 2 | 0 | 45.00 | 1.00 | 0 | 0 | 0 | 0.00 |
USERCENTER_TEMP | /opt/oracle/oradata/jqhx/USERCENTER_TEMP.dbf | 5,911 | 2 | 0.00 | 24.44 | 12,670 | 4 | 0 | |
USERS | /opt/oracle/oradata/jqhx/users01.dbf | 2 | 0 | 45.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 | 370,730 | 99 | 142,312,091 | 1,513,576 | 960,560 | 0 | 0 | 505,704 |
MTTR Writes | Log Size Writes | Log Ckpt Writes | Other Settings Writes | Autotune Ckpt Writes | Thread Ckpt Writes |
---|---|---|---|---|---|
0 | 801,739 | 0 | 0 | 548 | 119,590 |
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 | 13 | 1569 | 11574 | 38420 | 580608 | 38420 | |||
E | 0 | 39 | 44894 | 704804 | 580608 | 580608 | 966691 |
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 | 288 | 0.10 | 35 | 1.16 | 40,359,724 | 1 | 199127.00 |
D | 576 | 0.19 | 71 | 1.02 | 35,489,628 | 1 | 144566.00 |
D | 864 | 0.29 | 106 | 1.00 | 34,934,919 | 1 | 138351.00 |
D | 1,152 | 0.38 | 142 | 1.00 | 34,907,299 | 1 | 138042.00 |
D | 1,440 | 0.48 | 177 | 1.00 | 34,906,926 | 1 | 138038.00 |
D | 1,728 | 0.57 | 213 | 1.00 | 34,906,688 | 1 | 138035.00 |
D | 2,016 | 0.67 | 248 | 1.00 | 34,906,509 | 1 | 138033.00 |
D | 2,304 | 0.77 | 284 | 1.00 | 34,906,401 | 1 | 138032.00 |
D | 2,592 | 0.86 | 319 | 1.00 | 34,906,322 | 1 | 138031.00 |
D | 2,880 | 0.96 | 355 | 1.00 | 34,906,262 | 1 | 138030.00 |
D | 3,008 | 1.00 | 371 | 1.00 | 34,906,239 | 1 | 138030.00 |
D | 3,168 | 1.05 | 390 | 1.00 | 34,906,210 | 1 | 138030.00 |
D | 3,456 | 1.15 | 426 | 1.00 | 34,906,157 | 1 | 138029.00 |
D | 3,744 | 1.24 | 461 | 1.00 | 34,906,089 | 1 | 138028.00 |
D | 4,032 | 1.34 | 497 | 1.00 | 34,906,048 | 1 | 138028.00 |
D | 4,320 | 1.44 | 532 | 1.00 | 34,905,304 | 1 | 138020.00 |
D | 4,608 | 1.53 | 568 | 1.00 | 34,903,015 | 1 | 137994.00 |
D | 4,896 | 1.63 | 603 | 1.00 | 34,897,164 | 1 | 137928.00 |
D | 5,184 | 1.72 | 639 | 1.00 | 34,864,113 | 1 | 137558.00 |
D | 5,472 | 1.82 | 674 | 1.00 | 34,813,473 | 1 | 136991.00 |
D | 5,760 | 1.91 | 710 | 0.97 | 33,962,325 | 1 | 129354.00 |
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
89.58 | 21,562 | 2,508 |
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 | 0 | 3,144 | 935.60 | 3.96 | 0.42 | 100.00 | 0.00 | 429,260 |
E | 0 | 3,082 | 1,061.08 | 2.63 | 0.25 | 100.00 | 0.00 | 429,260 |
Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
---|---|---|---|---|---|
2K | 4K | 472,758 | 472,758 | 0 | 0 |
64K | 128K | 432 | 432 | 0 | 0 |
128K | 256K | 368 | 368 | 0 | 0 |
256K | 512K | 110 | 110 | 0 | 0 |
512K | 1024K | 3,066 | 3,066 | 0 | 0 |
1M | 2M | 802 | 802 | 0 | 0 |
2M | 4M | 48 | 48 | 0 | 0 |
4M | 8M | 78 | 78 | 0 | 0 |
8M | 16M | 109 | 109 | 0 | 0 |
16M | 32M | 30 | 30 | 0 | 0 |
32M | 64M | 142 | 142 | 0 | 0 |
64M | 128M | 60 | 60 | 0 | 0 |
128M | 256M | 10 | 0 | 10 | 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 |
---|---|---|---|---|---|---|
524 | 0.13 | 2,362,450.82 | 1,560,062.94 | 60.00 | 9,019 | 744,067,826 |
1,048 | 0.25 | 2,362,450.82 | 378,854.78 | 86.00 | 1,793 | 520,002,585 |
2,096 | 0.50 | 2,362,450.82 | 110,083.97 | 96.00 | 151 | 469,019,026 |
3,144 | 0.75 | 2,362,450.82 | 103,283.19 | 96.00 | 13 | 467,728,976 |
4,192 | 1.00 | 2,362,450.82 | 102,330.97 | 96.00 | 3 | 467,548,347 |
5,030 | 1.20 | 2,362,450.82 | 816.67 | 100.00 | 0 | 448,291,940 |
5,869 | 1.40 | 2,362,450.82 | 816.67 | 100.00 | 0 | 448,291,940 |
6,707 | 1.60 | 2,362,450.82 | 816.67 | 100.00 | 0 | 448,291,940 |
7,546 | 1.80 | 2,362,450.82 | 816.67 | 100.00 | 0 | 448,291,940 |
8,384 | 2.00 | 2,362,450.82 | 816.67 | 100.00 | 0 | 448,291,940 |
12,576 | 3.00 | 2,362,450.82 | 816.67 | 100.00 | 0 | 448,291,940 |
16,768 | 4.00 | 2,362,450.82 | 816.67 | 100.00 | 0 | 448,291,940 |
25,152 | 6.00 | 2,362,450.82 | 816.67 | 100.00 | 0 | 448,291,940 |
33,536 | 8.00 | 2,362,450.82 | 816.67 | 100.00 | 0 | 448,291,940 |
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) |
---|---|---|---|---|---|---|---|---|
2,720 | 0.59 | 367 | 33,272 | 2,370,861 | 0.37 | 4,644,475 | 7.41 | 868,644 |
3,200 | 0.69 | 846 | 54,646 | 3,440,123 | 0.54 | 3,575,213 | 5.71 | 1,100,108 |
3,680 | 0.79 | 1,325 | 76,714 | 4,452,577 | 0.70 | 2,562,759 | 4.09 | 1,308,805 |
4,160 | 0.90 | 1,805 | 98,120 | 5,464,229 | 0.86 | 1,551,107 | 2.48 | 1,517,416 |
4,320 | 0.93 | 1,964 | 103,569 | 5,800,780 | 0.91 | 1,214,556 | 1.94 | 1,586,950 |
4,352 | 0.94 | 1,996 | 104,574 | 5,868,039 | 0.92 | 1,147,297 | 1.83 | 1,600,855 |
4,384 | 0.94 | 2,028 | 105,683 | 5,935,356 | 0.93 | 1,079,980 | 1.72 | 1,614,758 |
4,416 | 0.95 | 2,060 | 106,854 | 6,002,580 | 0.94 | 1,012,756 | 1.62 | 1,628,661 |
4,448 | 0.96 | 2,092 | 108,084 | 6,070,288 | 0.95 | 945,048 | 1.51 | 1,642,722 |
4,480 | 0.97 | 2,123 | 109,186 | 6,137,970 | 0.96 | 877,366 | 1.40 | 1,656,701 |
4,512 | 0.97 | 2,155 | 110,179 | 6,210,918 | 0.97 | 804,418 | 1.28 | 1,671,622 |
4,544 | 0.98 | 2,187 | 111,336 | 6,265,467 | 0.98 | 749,869 | 1.20 | 1,682,692 |
4,576 | 0.99 | 2,219 | 112,338 | 6,305,169 | 0.99 | 710,167 | 1.13 | 1,690,570 |
4,608 | 0.99 | 2,251 | 113,354 | 6,344,528 | 0.99 | 670,808 | 1.07 | 1,698,395 |
4,640 | 1.00 | 2,283 | 114,611 | 6,388,689 | 1.00 | 626,647 | 1.00 | 1,706,908 |
4,672 | 1.01 | 2,314 | 116,109 | 6,389,904 | 1.00 | 625,432 | 1.00 | 1,707,115 |
4,704 | 1.01 | 2,345 | 117,481 | 6,389,965 | 1.00 | 625,371 | 1.00 | 1,707,121 |
4,736 | 1.02 | 2,377 | 118,456 | 6,390,027 | 1.00 | 625,309 | 1.00 | 1,707,127 |
4,768 | 1.03 | 2,409 | 119,284 | 6,390,099 | 1.00 | 625,237 | 1.00 | 1,707,133 |
4,800 | 1.03 | 2,440 | 120,066 | 6,390,164 | 1.00 | 625,172 | 1.00 | 1,707,139 |
4,832 | 1.04 | 2,472 | 120,833 | 6,390,226 | 1.00 | 625,110 | 1.00 | 1,707,144 |
4,864 | 1.05 | 2,504 | 121,646 | 6,390,287 | 1.00 | 625,049 | 1.00 | 1,707,148 |
4,896 | 1.06 | 2,535 | 122,502 | 6,390,341 | 1.00 | 624,995 | 1.00 | 1,707,152 |
4,928 | 1.06 | 2,567 | 123,534 | 6,390,385 | 1.00 | 624,951 | 1.00 | 1,707,155 |
5,120 | 1.10 | 2,759 | 128,897 | 6,390,683 | 1.00 | 624,653 | 1.00 | 1,707,180 |
5,600 | 1.21 | 3,239 | 144,304 | 6,391,329 | 1.00 | 624,007 | 1.00 | 1,707,239 |
6,080 | 1.31 | 3,719 | 164,453 | 6,391,893 | 1.00 | 623,443 | 0.99 | 1,707,289 |
6,560 | 1.41 | 4,198 | 191,141 | 6,392,379 | 1.00 | 622,957 | 0.99 | 1,707,331 |
7,040 | 1.52 | 4,678 | 227,694 | 6,392,903 | 1.00 | 622,433 | 0.99 | 1,707,372 |
7,520 | 1.62 | 5,158 | 269,815 | 6,393,422 | 1.00 | 621,914 | 0.99 | 1,707,412 |
8,000 | 1.72 | 5,638 | 311,978 | 6,394,049 | 1.00 | 621,287 | 0.99 | 1,707,455 |
8,480 | 1.83 | 6,118 | 351,910 | 6,394,776 | 1.00 | 620,560 | 0.99 | 1,707,498 |
8,960 | 1.93 | 6,598 | 385,936 | 6,395,490 | 1.00 | 619,846 | 0.99 | 1,707,541 |
9,440 | 2.03 | 7,078 | 423,180 | 6,396,185 | 1.00 | 619,151 | 0.99 | 1,707,579 |
SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
---|---|---|---|
3,904 | 0.50 | 6,927,606 | 35,489,172,920 |
4,880 | 0.63 | 4,282,549 | 40,358,593,223 |
5,856 | 0.75 | 3,969,172 | 34,934,163,724 |
6,832 | 0.88 | 3,967,982 | 34,906,238,733 |
7,808 | 1.00 | 3,966,786 | 34,906,238,733 |
8,784 | 1.13 | 3,965,602 | 34,906,238,733 |
9,760 | 1.25 | 3,964,412 | 34,906,238,733 |
10,736 | 1.38 | 3,959,652 | 33,960,279,663 |
11,712 | 1.50 | 3,958,462 | 33,960,279,663 |
12,688 | 1.63 | 3,957,669 | 33,960,279,663 |
13,664 | 1.75 | 3,956,479 | 33,960,279,663 |
14,640 | 1.88 | 3,954,893 | 33,960,279,663 |
15,616 | 2.00 | 3,954,496 | 33,960,279,663 |
Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
---|---|---|---|---|---|
32 | 1.00 | 0 | 0 | 0 | 0 |
64 | 2.00 | 0 | 0 | 0 | 0 |
96 | 3.00 | 0 | 0 | 0 | 0 |
128 | 4.00 | 0 | 0 | 0 | 0 |
160 | 5.00 | 0 | 0 | 0 | 0 |
192 | 6.00 | 0 | 0 | 0 | 0 |
224 | 7.00 | 0 | 0 | 0 | 0 |
256 | 8.00 | 0 | 0 | 0 | 0 |
288 | 9.00 | 0 | 0 | 0 | 0 |
320 | 10.00 | 0 | 0 | 0 | 0 |
352 | 11.00 | 0 | 0 | 0 | 0 |
384 | 12.00 | 0 | 0 | 0 | 0 |
416 | 13.00 | 0 | 0 | 0 | 0 |
448 | 14.00 | 0 | 0 | 0 | 0 |
480 | 15.00 | 0 | 0 | 0 | 0 |
512 | 16.00 | 0 | 0 | 0 | 0 |
544 | 17.00 | 0 | 0 | 0 | 0 |
576 | 18.00 | 0 | 0 | 0 | 0 |
608 | 19.00 | 0 | 0 | 0 | 0 |
640 | 20.00 | 0 | 0 | 0 | 0 |
Class | Waits | Total Wait Time (s) | Avg Time (ms) |
---|---|---|---|
data block | 227,109 | 7,053 | 31 |
1st level bmb | 269,397 | 550 | 2 |
undo header | 390 | 244 | 625 |
undo block | 20 | 6 | 319 |
segment header | 5,354 | 4 | 1 |
2nd level bmb | 502 | 0 | 0 |
file header block | 2 | 0 | 0 |
Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
---|---|---|---|---|---|---|
SQ-Sequence Cache | 5,213 | 5,121 | 0 | 4,160 | 97,738 | 23,494.62 |
TX-Transaction (row lock contention) | 189 | 180 | 0 | 187 | 1,252 | 6,697.38 |
KO-Multiple Object Checkpoint (fast object checkpoint) | 30 | 30 | 0 | 3 | 79 | 26,356.67 |
CF-Controlfile Transaction | 270,080 | 270,041 | 39 | 227 | 45 | 199.34 |
JD-Job Queue Date | 784 | 784 | 0 | 1 | 33 | 33,420.00 |
FB-Format Block | 59,737 | 59,737 | 0 | 1,803 | 7 | 3.67 |
TX-Transaction (index contention) | 121 | 121 | 0 | 118 | 3 | 22.63 |
HW-Segment High Water Mark | 5,226 | 5,224 | 2 | 474 | 1 | 2.76 |
TX-Transaction | 23,729 | 23,729 | 0 | 468 | 1 | 1.73 |
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 | 23.32 | 22,858 | 2,168 | 46 | 25.6/51.2 | 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 |
---|---|---|---|---|---|---|---|
03-9月 10:59 | 3,998 | 4,356 | 2,168 | 38 | 51 | 0/0 | 0/0/0/0/0/0 |
03-9月 10:49 | 3,936 | 3,413 | 1,786 | 43 | 45 | 0/0 | 0/0/0/0/0/0 |
03-9月 10:39 | 4,324 | 3,760 | 1,184 | 33 | 35 | 0/0 | 0/0/0/0/0/0 |
03-9月 10:29 | 3,425 | 3,067 | 1,234 | 31 | 36 | 0/0 | 0/0/0/0/0/0 |
03-9月 10:19 | 3,265 | 4,131 | 631 | 46 | 26 | 0/0 | 0/0/0/0/0/0 |
03-9月 10:09 | 4,372 | 4,131 | 1,235 | 35 | 36 | 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 | 1 | 0.00 | 0 | 0 | ||
ASM db client latch | 2,562 | 0.00 | 0 | 0 | ||
ASM map operation hash table | 1 | 0.00 | 0 | 0 | ||
ASM network state latch | 5,393 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 42,771 | 0.00 | 0 | 0 | ||
Change Notification Hash table latch | 1,174 | 0.00 | 0 | 0 | ||
Consistent RBA | 10,104 | 0.00 | 0 | 0 | ||
DML lock allocation | 95,096 | 0.01 | 0.00 | 0 | 0 | |
Event Group Locks | 228,370 | 0.01 | 0.00 | 0 | 0 | |
FAL Queue | 306 | 0.00 | 0 | 0 | ||
FIB s.o chain latch | 639 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 4,930 | 0.06 | 0.00 | 0 | 0 | |
File State Object Pool Parent Latch | 1 | 0.00 | 0 | 0 | ||
I/O Staticstics latch | 1 | 0.00 | 0 | 0 | ||
IPC stats buffer allocation latch | 1 | 0.00 | 0 | 0 | ||
In memory undo latch | 38,970 | 0.37 | 0.91 | 64 | 44,051 | 0.11 |
JS Sh mem access | 9 | 0.00 | 0 | 0 | ||
JS mem alloc latch | 5 | 0.00 | 0 | 0 | ||
JS queue access latch | 6 | 0.00 | 0 | 0 | ||
JS queue state obj latch | 26,422 | 0.00 | 0 | 0 | ||
JS slv state obj latch | 232 | 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 | ||
KMG MMAN ready and startup request latch | 1,279 | 0.00 | 0 | 0 | ||
KTF sga latch | 21 | 0.00 | 0 | 1,194 | 0.00 | |
KWQMN job cache list latch | 3 | 0.00 | 0 | 0 | ||
KWQP Prop Status | 2 | 0.00 | 0 | 0 | ||
KWQS pqsubs latch | 4 | 0.00 | 0 | 0 | ||
KWQS pqueue ctx latch | 67 | 0.00 | 0 | 0 | ||
Locator state objects pool parent latch | 1 | 0.00 | 0 | 0 | ||
Lsod array latch | 1 | 0.00 | 0 | 0 | ||
MQL Tracking Latch | 0 | 0 | 76 | 0.00 | ||
Memory Management Latch | 1 | 0.00 | 0 | 1,279 | 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 | 42 | 0.00 | 0 | 0 | ||
Mutex | 1 | 0.00 | 0 | 0 | ||
Mutex Stats | 1 | 0.00 | 0 | 0 | ||
OS process | 456,843 | 0.00 | 0 | 0 | ||
OS process allocation | 236,341 | 0.09 | 0.00 | 0 | 0 | |
OS process: request allocation | 228,153 | 0.10 | 0.00 | 0 | 0 | |
PL/SQL warning settings | 130,332 | 0.00 | 0.00 | 0 | 0 | |
PX hash array latch | 1 | 0.00 | 0 | 0 | ||
QMT | 1 | 0.00 | 0 | 0 | ||
Real-time plan statistics latch | 23,619 | 0.00 | 0 | 0 | ||
Reserved Space Latch | 414 | 0.00 | 0 | 0 | ||
SGA IO buffer pool latch | 8,055 | 0.02 | 0.00 | 0 | 14,258 | 0.02 |
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 | 123 | 0.00 | 0 | 1,232 | 0.00 | |
SQL memory manager workarea list latch | 450,767 | 0.00 | 0.00 | 0 | 0 | |
Shared B-Tree | 318 | 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 | 963 | 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 | 133,057 | 0.02 | 0.00 | 0 | 0 | |
active service list | 694,470 | 0.32 | 0.02 | 0 | 7,046 | 0.06 |
alert log latch | 207 | 0.00 | 0 | 0 | ||
archive control | 374 | 0.00 | 0 | 0 | ||
archive process latch | 1,028 | 3.79 | 1.00 | 0 | 0 | |
begin backup scn array | 53 | 0.00 | 0 | 0 | ||
buffer pool | 1 | 0.00 | 0 | 0 | ||
business card | 1 | 0.00 | 0 | 0 | ||
cache buffer handles | 1,029,252 | 1.68 | 0.00 | 0 | 0 | |
cache buffers chains | 298,736,904 | 1.27 | 0.00 | 1 | 53,743,534 | 0.00 |
cache buffers lru chain | 973,408 | 0.76 | 0.02 | 0 | 100,878,625 | 0.22 |
cache table scan latch | 242,383 | 0.01 | 0.00 | 0 | 242,383 | 0.01 |
call allocation | 343,199 | 2.87 | 0.71 | 21 | 0 | |
cas latch | 1 | 0.00 | 0 | 0 | ||
change notification client cache latch | 1 | 0.00 | 0 | 0 | ||
channel handle pool latch | 228,184 | 0.04 | 0.01 | 0 | 0 | |
channel operations parent latch | 360,256 | 0.06 | 0.01 | 0 | 0 | |
checkpoint queue latch | 1,523,012 | 0.00 | 0.00 | 0 | 993,203 | 0.07 |
client/application info | 684,687 | 0.00 | 0.00 | 0 | 0 | |
compile environment latch | 114,212 | 0.02 | 0.00 | 0 | 0 | |
corrupted undo seg latch | 413 | 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 | 5,393 | 0.00 | 0 | 0 | ||
cvmap freelist lock | 1 | 0.00 | 0 | 0 | ||
deferred cleanup latch | 5,393 | 0.00 | 0 | 0 | ||
dml lock allocation | 5,393 | 0.00 | 0 | 0 | ||
done queue latch | 1 | 0.00 | 0 | 0 | ||
dummy allocation | 228,267 | 0.83 | 0.01 | 0 | 0 | |
enqueue freelist latch | 1 | 0.00 | 0 | 1,163,939 | 0.00 | |
enqueue hash chains | 1,602,611 | 0.19 | 0.08 | 1 | 35,778 | 0.01 |
enqueues | 53 | 0.00 | 0 | 0 | ||
fifth spare latch | 1 | 0.00 | 0 | 0 | ||
file cache latch | 633 | 0.00 | 0 | 0 | ||
flashback copy | 1 | 0.00 | 0 | 0 | ||
fourth Audit Vault latch | 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 | 114,014 | 0.00 | 0 | 0 | ||
global tx hash mapping | 567 | 0.00 | 0 | 0 | ||
granule operation | 1 | 0.00 | 0 | 0 | ||
hash table column usage latch | 426 | 0.00 | 0 | 4,927,286 | 0.02 | |
hash table modification latch | 102 | 0.00 | 0 | 0 | ||
heartbeat check | 1 | 0.00 | 0 | 0 | ||
internal temp table object number allocation latch | 22 | 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 | 74 | 0.00 | 0 | 73 | 0.00 | |
job_queue_processes free list latch | 150 | 0.00 | 0 | 0 | ||
job_queue_processes parameter latch | 852 | 0.00 | 0 | 0 | ||
k2q lock allocation | 1 | 0.00 | 0 | 0 | ||
kcbtsemkid latch | 104 | 0.00 | 0 | 0 | ||
kdlx hb parent latch | 1 | 0.00 | 0 | 0 | ||
kgb parent | 1 | 0.00 | 0 | 0 | ||
kgnfs mount latch | 1 | 0.00 | 0 | 0 | ||
kokc descriptor allocation latch | 354 | 0.00 | 0 | 0 | ||
ksfv messages | 1 | 0.00 | 0 | 0 | ||
ksim group membership cache | 1 | 0.00 | 0 | 0 | ||
kss move lock | 43 | 0.00 | 0 | 0 | ||
ksuosstats global area | 387 | 0.00 | 0 | 0 | ||
ksv allocation latch | 5,476 | 0.00 | 0 | 0 | ||
ksv class latch | 83 | 0.00 | 0 | 0 | ||
ksv msg queue latch | 1 | 0.00 | 0 | 0 | ||
ksz_so allocation latch | 228,153 | 0.12 | 0.00 | 0 | 0 | |
ktm global data | 98 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 139 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 10,719 | 0.03 | 0.00 | 0 | 0 | |
list of block allocation | 73,057 | 1.38 | 0.79 | 37 | 0 | |
loader state object freelist | 70 | 0.00 | 0 | 0 | ||
lob segment dispenser latch | 1 | 0.00 | 0 | 0 | ||
lob segment hash table latch | 13 | 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 | 2 | 0.00 | 0 | 0 | ||
logminer work area | 1 | 0.00 | 0 | 0 | ||
longop free list parent | 30,183 | 0.00 | 0 | 119 | 0.00 | |
managed standby latch | 204 | 0.00 | 0 | 0 | ||
mapped buffers lru chain | 1 | 0.00 | 0 | 0 | ||
message pool operations parent latch | 49 | 0.00 | 0 | 0 | ||
messages | 646,597 | 6.15 | 0.00 | 0 | 0 | |
mostly latch-free SCN | 10,880 | 0.31 | 0.00 | 0 | 0 | |
msg queue latch | 1 | 0.00 | 0 | 0 | ||
multiblock read objects | 1,358,237 | 0.02 | 0.00 | 0 | 27 | 0.00 |
name-service namespace bucket | 1 | 0.00 | 0 | 0 | ||
ncodef allocation latch | 5,393 | 0.00 | 0 | 0 | ||
object queue header heap | 16,929 | 0.00 | 0 | 9,420 | 0.00 | |
object queue header operation | 7,850,716 | 0.08 | 0.01 | 0 | 0 | |
object stats modification | 61 | 0.00 | 0 | 0 | ||
parallel query alloc buffer | 751 | 0.00 | 0 | 0 | ||
parallel query stats | 1 | 0.00 | 0 | 0 | ||
parameter list | 4,816 | 0.00 | 0 | 0 | ||
parameter table management | 457,494 | 0.12 | 0.20 | 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 | 839,477 | 13.01 | 0.00 | 0 | 906,353 | 4.35 |
process allocation | 228,293 | 4.08 | 1.06 | 80 | 113,903 | 0.22 |
process group creation | 228,153 | 0.11 | 0.00 | 0 | 0 | |
process queue | 1 | 0.00 | 0 | 0 | ||
process queue reference | 1 | 0.00 | 0 | 0 | ||
qmn task queue latch | 560 | 0.18 | 0.00 | 0 | 0 | |
query server freelists | 1 | 0.00 | 0 | 0 | ||
queued dump request | 13 | 0.00 | 0 | 0 | ||
queuing load statistics | 1 | 0.00 | 0 | 0 | ||
recovery domain hash list | 1 | 0.00 | 0 | 0 | ||
redo allocation | 352,052 | 25.22 | 0.01 | 0 | 4,981,430 | 10.56 |
redo copy | 1 | 0.00 | 0 | 5,079,698 | 0.16 | |
redo writing | 816,752 | 26.55 | 0.00 | 0 | 0 | |
reservation so alloc latch | 207 | 0.00 | 0 | 0 | ||
resmgr group change latch | 114,133 | 0.00 | 0.00 | 0 | 0 | |
resmgr:active threads | 228,267 | 0.00 | 1.00 | 0 | 0 | |
resmgr:actses change group | 114,096 | 0.00 | 0 | 0 | ||
resmgr:actses change state | 1 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 228,266 | 1.13 | 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 | 81 | 0.00 | 0 | 0 | ||
resmgr:session queuing | 1 | 0.00 | 0 | 0 | ||
rm cas latch | 1 | 0.00 | 0 | 0 | ||
row cache objects | 31,036,060 | 0.31 | 0.00 | 0 | 279 | 0.00 |
rules engine aggregate statistics | 2 | 0.00 | 0 | 0 | ||
rules engine rule set statistics | 104 | 0.00 | 0 | 0 | ||
second Audit Vault latch | 1 | 0.00 | 0 | 0 | ||
second spare latch | 1 | 0.00 | 0 | 0 | ||
sequence cache | 412,231 | 0.68 | 0.00 | 0 | 0 | |
session allocation | 634,942 | 0.02 | 0.00 | 0 | 406,954 | 0.02 |
session idle bit | 2,143,807 | 0.00 | 0.01 | 0 | 0 | |
session queue latch | 1 | 0.00 | 0 | 0 | ||
session state list latch | 228,410 | 1.21 | 0.01 | 0 | 0 | |
session switching | 119,390 | 0.11 | 0.00 | 0 | 2 | 0.00 |
session timer | 5,638 | 0.00 | 0 | 0 | ||
shared pool | 9,871,872 | 1.11 | 0.05 | 12 | 0 | |
shared pool sim alloc | 1 | 0.00 | 0 | 0 | ||
shared pool simulator | 108,417 | 0.05 | 0.14 | 0 | 0 | |
sim partition latch | 1 | 0.00 | 0 | 0 | ||
simulator hash latch | 18,652,622 | 0.00 | 0.00 | 0 | 0 | |
simulator lru latch | 918,831 | 0.02 | 0.00 | 0 | 12,174,301 | 2.96 |
sort extent pool | 6,671 | 0.00 | 0 | 0 | ||
space background state object latch | 7 | 0.00 | 0 | 0 | ||
space background task latch | 4,942 | 0.16 | 0.00 | 0 | 2,566 | 0.00 |
state object free list | 2 | 0.00 | 0 | 0 | ||
statistics aggregation | 560 | 0.00 | 0 | 0 | ||
tablespace key chain | 1 | 0.00 | 0 | 0 | ||
temp lob duration state obj allocation | 2 | 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 | 178 | 0.00 | 0 | 0 | ||
transaction allocation | 64,333 | 0.01 | 0.40 | 0 | 0 | |
transaction branch allocation | 6,148 | 0.10 | 0.00 | 0 | 0 | |
undo global data | 1,123,988 | 0.03 | 0.01 | 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 | 298,736,904 | 3,802,369 | 3,622 | 3,802,528 |
redo writing | 816,752 | 216,822 | 72 | 216,750 |
post/wait queue | 839,477 | 109,209 | 14 | 109,195 |
shared pool | 9,871,872 | 109,154 | 5,429 | 104,094 |
row cache objects | 31,036,060 | 96,470 | 343 | 96,145 |
redo allocation | 352,052 | 88,802 | 541 | 88,275 |
messages | 646,597 | 39,785 | 13 | 39,772 |
cache buffer handles | 1,029,252 | 17,299 | 9 | 17,292 |
call allocation | 343,199 | 9,864 | 6,965 | 3,916 |
process allocation | 228,293 | 9,316 | 9,898 | 622 |
cache buffers lru chain | 973,408 | 7,377 | 167 | 7,214 |
object queue header operation | 7,850,716 | 6,641 | 62 | 6,579 |
enqueue hash chains | 1,602,611 | 2,972 | 225 | 2,768 |
sequence cache | 412,231 | 2,793 | 4 | 2,789 |
session state list latch | 228,410 | 2,767 | 15 | 2,752 |
resmgr:free threads list | 228,266 | 2,570 | 8 | 2,562 |
active service list | 694,470 | 2,207 | 51 | 2,159 |
dummy allocation | 228,267 | 1,888 | 18 | 1,870 |
list of block allocation | 73,057 | 1,007 | 793 | 246 |
parameter table management | 457,494 | 550 | 108 | 446 |
simulator hash latch | 18,652,622 | 508 | 2 | 506 |
undo global data | 1,123,988 | 380 | 3 | 377 |
OS process: request allocation | 228,153 | 233 | 1 | 232 |
channel operations parent latch | 360,256 | 200 | 1 | 199 |
In memory undo latch | 38,970 | 145 | 132 | 16 |
session idle bit | 2,143,807 | 107 | 1 | 106 |
channel handle pool latch | 228,184 | 85 | 1 | 84 |
shared pool simulator | 108,417 | 56 | 8 | 48 |
archive process latch | 1,028 | 39 | 39 | 0 |
transaction allocation | 64,333 | 5 | 2 | 3 |
resmgr:active threads | 228,267 | 1 | 1 | 0 |
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
In memory undo latch | kticmt: child | 0 | 89 | 9 |
In memory undo latch | ktiFlush: child | 0 | 42 | 108 |
In memory undo latch | ktiFlushMe | 0 | 1 | 0 |
OS process: request allocation | ksoreqholder_delete | 0 | 1 | 0 |
active service list | kswslogon: session logout | 0 | 89 | 64 |
active service list | kswsgsnp: get service name ptr | 0 | 12 | 27 |
active service list | kswsite: service iterator | 0 | 1 | 0 |
active service list | kswslogon: session login | 0 | 1 | 6 |
archive process latch | kcrrsarc | 0 | 39 | 0 |
cache buffer handles | kcbzfs | 0 | 6 | 9 |
cache buffer handles | kcbzgs | 0 | 3 | 0 |
cache buffers chains | kcbgtcr_2 | 0 | 1,600 | 794 |
cache buffers chains | kcbgtcr: fast path (cr pin) | 0 | 1,310 | 1,964 |
cache buffers chains | kcbgcur_2 | 0 | 414 | 39 |
cache buffers chains | kcbchg1: mod cr pin | 0 | 303 | 123 |
cache buffers chains | kcbgtcr: kslbegin excl | 0 | 131 | 122 |
cache buffers chains | kcbgcur: fast path (shr) | 0 | 83 | 109 |
cache buffers chains | kcbzwb | 0 | 74 | 26 |
cache buffers chains | kcbrls: fast release | 0 | 24 | 335 |
cache buffers chains | kcbrls_2 | 0 | 21 | 125 |
cache buffers chains | kcbgcur_4 | 0 | 10 | 33 |
cache buffers chains | kcbgtcr: fast path | 0 | 9 | 3 |
cache buffers chains | kcbchg1: clear MS bit | 0 | 6 | 153 |
cache buffers chains | kcbnew: new latch again | 0 | 4 | 3 |
cache buffers chains | kcbzgb: scan from tail. nowait | 0 | 4 | 0 |
cache buffers chains | kcbzibmlt: multi-block read: nowait | 0 | 4 | 0 |
cache buffers chains | kcbzdh | 0 | 3 | 0 |
cache buffers chains | kcbchg1: mod cur pin | 0 | 2 | 109 |
cache buffers chains | kcbbic2 | 0 | 1 | 3 |
cache buffers chains | kcbget: fast exchange | 0 | 1 | 2 |
cache buffers chains | kcbget: pin buffer | 0 | 1 | 0 |
cache buffers chains | kcbzibmlt: finish free bufs | 0 | 1 | 2 |
cache buffers lru chain | kcbbic2 | 0 | 59 | 162 |
cache buffers lru chain | kcbzgb | 0 | 56 | 5 |
cache buffers lru chain | kcbzgws | 0 | 39 | 0 |
cache buffers lru chain | kcbzar: KSLNBEGIN | 0 | 13 | 0 |
call allocation | ksuxds | 0 | 4,731 | 4,838 |
call allocation | ksudlp: top call | 0 | 2,210 | 1,778 |
call allocation | ksucrp: top call | 0 | 43 | 369 |
call allocation | ksudlc : rec call | 0 | 5 | 4 |
call allocation | ksuprc | 0 | 3 | 4 |
call allocation | ksusroll | 0 | 1 | 0 |
channel handle pool latch | ksrchconnect() | 0 | 1 | 1 |
channel operations parent latch | ksrchdelete_sub() | 0 | 1 | 1 |
dummy allocation | ktcscnfy | 0 | 13 | 13 |
dummy allocation | ktcdod | 0 | 5 | 5 |
enqueue hash chains | ksqrcl | 0 | 197 | 128 |
enqueue hash chains | ksqgtl3 | 0 | 14 | 78 |
enqueue hash chains | ksqcmi: get hash chain latch after wait | 0 | 13 | 21 |
enqueue hash chains | ksqcmi: kslgpl | 0 | 9 | 6 |
enqueue hash chains | ksqcmi: if deadlock detected | 0 | 2 | 2 |
list of block allocation | ktlabl | 0 | 730 | 726 |
list of block allocation | ktcdod | 0 | 62 | 66 |
list of block allocation | ktlbbl | 0 | 1 | 2 |
messages | ksaamb: after wakeup | 0 | 9 | 13 |
messages | ksarcv | 0 | 3 | 0 |
messages | ksarcv: after wait | 0 | 1 | 0 |
object queue header operation | kcbo_switch_cq | 0 | 78 | 55 |
object queue header operation | kcbo_unlink_q | 0 | 13 | 33 |
object queue header operation | kcbo_link_q | 0 | 1 | 3 |
parameter table management | ksp_param_table_free | 0 | 121 | 4 |
parameter table management | kspcpy | 0 | 26 | 4 |
post/wait queue | ksliwat:remove | 0 | 8 | 13 |
post/wait queue | ksliwat:add:nowait | 0 | 5 | 0 |
post/wait queue | ksliwat:add:wait | 0 | 1 | 1 |
process allocation | ksucrp:1 | 0 | 5,953 | 0 |
process allocation | ksudlp | 0 | 2,830 | 3,333 |
process allocation | ksuapc | 0 | 1,118 | 6,566 |
redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 289 | 0 |
redo allocation | kcrfw_redo_gen: redo allocation 3 | 0 | 205 | 527 |
redo allocation | kcrfw_redo_gen: redo allocation 2 | 0 | 38 | 0 |
redo allocation | kcrfw_redo_write: before write | 0 | 8 | 14 |
redo allocation | kcrfw_redo_gen: redo allocation 0 | 0 | 1 | 0 |
redo writing | kcrfws: in loop | 0 | 70 | 72 |
redo writing | kcrfw_cal_target_rba | 0 | 1 | 0 |
redo writing | kcrfwnf: new logfile | 0 | 1 | 0 |
resmgr:active threads | kgskgtwt | 0 | 1 | 0 |
resmgr:free threads list | kskthrcreate | 0 | 8 | 8 |
row cache objects | kqreqd: reget | 0 | 173 | 8 |
row cache objects | kqrpre: find obj | 0 | 103 | 195 |
row cache objects | kqreqd | 0 | 64 | 140 |
row cache objects | kqrso | 0 | 3 | 0 |
sequence cache | kdnnxt: cached seq | 0 | 2 | 3 |
sequence cache | kdnss | 0 | 2 | 1 |
session idle bit | ksupuc: clear busy | 0 | 1 | 1 |
session state list latch | kpseqd | 0 | 9 | 1 |
session state list latch | kpseqa | 0 | 6 | 14 |
shared pool | kghalo | 0 | 4,938 | 4,318 |
shared pool | kghfre | 0 | 181 | 497 |
shared pool | kghalp | 0 | 169 | 149 |
shared pool | kghupr1 | 0 | 123 | 432 |
shared pool | kgh_heap_sizes | 0 | 16 | 22 |
shared pool | kghasp | 0 | 7 | 20 |
shared pool | kghdmp:old | 0 | 3 | 0 |
shared pool simulator | kglsim_upd_newhp | 0 | 8 | 6 |
simulator hash latch | kcbsacc: lookup dba | 0 | 2 | 2 |
transaction allocation | ktcxbr | 0 | 1 | 1 |
transaction allocation | ktiNonImuPoolAllocate | 0 | 1 | 0 |
undo global data | ktudba: KSLBEGIN | 0 | 2 | 94 |
undo global data | kturax | 0 | 1 | 0 |
Mutex Type | Location | Sleeps | Wait Time (ms) |
---|---|---|---|
Library Cache | kgllkdl1 85 | 70,048 | 0 |
Library Cache | kglhdgn2 106 | 68,338 | 0 |
Library Cache | kglget1 1 | 67,686 | 0 |
Library Cache | kglpndl1 95 | 7,099 | 0 |
Library Cache | kglhdgn1 62 | 3,549 | 0 |
Library Cache | kglpin1 4 | 3,214 | 0 |
Cursor Pin | kkslce [KKSCHLPIN2] | 1,924 | 0 |
Library Cache | kgldtin1 42 | 1,485 | 0 |
Library Cache | kgllkc1 57 | 1,384 | 0 |
Library Cache | kglhdgh1 64 | 1,234 | 0 |
Library Cache | kglpnal1 90 | 1,176 | 0 |
Cursor Pin | kksfbc [KKSCHLFSP2] | 54 | 0 |
Cursor Parent | kkscsPruneChild [KKSPRTLOC35] | 30 | 0 |
Cursor Pin | kksLockDelete [KKSCHLPIN6] | 22 | 0 |
Library Cache | kglget2 2 | 20 | 0 |
Cursor Pin | kksfbc [KKSCHLPIN1] | 20 | 0 |
Library Cache | kglrfcl1 79 | 15 | 0 |
Library Cache | kglobpn1 71 | 10 | 0 |
Library Cache | kgllkal3 82 | 4 | 0 |
Library Cache | kglini1 32 | 3 | 0 |
Cursor Parent | kksfbc [KKSPRTLOC3] | 3 | 0 |
Cursor Parent | kkscsAddChildNode [KKSPRTLOC34] | 2 | 0 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | F_PAR | TABLE | 50,360,864 | 35.28 | |
USERCENTER | USERCENTER20120220_DATA | SMS_MASS | TABLE | 23,893,296 | 16.74 | |
USERCENTER | USERCENTER20120220_DATA | SMS_SEND_ENT | TABLE | 21,388,224 | 14.98 | |
USERCENTER | USERCENTER20120220_DATA | SMS_SEND_AH | TABLE | 14,373,536 | 10.07 | |
USERCENTER | USERCENTER20120220_DATA | F_PAR_EXC | TABLE | 9,132,208 | 6.40 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | F_PAR | TABLE | 1,672,935 | 88.63 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_JSHM_TJSJ | INDEX | 872 | 0.05 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_FFHM_TJSJ | INDEX | 659 | 0.03 | |
USERCENTER | USERCENTER20120220_DATA | T_LOCATION_INFO | TABLE | 320 | 0.02 | |
USERCENTER | USERCENTER20120220_DATA | F_PAR_EXC | TABLE | 255 | 0.01 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Read Requests | %Total |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | F_PAR | TABLE | 680,926 | 98.20 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_JSHM_TJSJ | INDEX | 872 | 0.13 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_FFHM_TJSJ | INDEX | 659 | 0.10 | |
USERCENTER | USERCENTER20120220_DATA | T_LOCATION_INFO | TABLE | 320 | 0.05 | |
USERCENTER | USERCENTER20120220_DATA | F_PAR_EXC | TABLE | 255 | 0.04 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | UnOptimized Reads | %Total |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | F_PAR | TABLE | 680,926 | 98.20 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_JSHM_TJSJ | INDEX | 872 | 0.13 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_FFHM_TJSJ | INDEX | 659 | 0.10 | |
USERCENTER | USERCENTER20120220_DATA | T_LOCATION_INFO | TABLE | 320 | 0.05 | |
USERCENTER | USERCENTER20120220_DATA | F_PAR_EXC | TABLE | 255 | 0.04 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Reads | %Total |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | F_PAR | TABLE | 229,174 | 61.28 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Writes | %Total |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | F_PAR_EXC | TABLE | 896,393 | 71.68 | |
USERCENTER | USERCENTER20120220_DATA | T_LOCATION_INFO | TABLE | 5,726 | 0.46 | |
USERCENTER | USERCENTER20120220_DATA | T_USER_LOG | TABLE | 1,177 | 0.09 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_JSHM_TJSJ | INDEX | 1,102 | 0.09 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_FFHM_TJSJ | INDEX | 912 | 0.07 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Write Requests | %Total |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | F_PAR_EXC | TABLE | 692,091 | 91.47 | |
USERCENTER | USERCENTER20120220_DATA | T_LOCATION_INFO | TABLE | 5,278 | 0.70 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_JSHM_TJSJ | INDEX | 1,016 | 0.13 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_FFHM_TJSJ | INDEX | 902 | 0.12 | |
USERCENTER | USERCENTER20120220_DATA | T_USER_LOG | TABLE | 745 | 0.10 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Writes | %Total |
---|---|---|---|---|---|---|
SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_2877231475_4191 | TABLE PARTITION | 671 | 0.23 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Table Scans | %Total |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | F_PAR | TABLE | 663 | 92.86 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | DB Block Changes | % of Capture |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | F_PAR_EXC | TABLE | 4,884,736 | 95.29 | |
USERCENTER | USERCENTER20120220_DATA | T_LOCATION_INFO | TABLE | 176,944 | 3.45 | |
SYS | SYSTEM | SEQ$ | TABLE | 14,272 | 0.28 | |
USERCENTER | USERCENTER20120220_DATA | F_PAR | TABLE | 10,592 | 0.21 | |
USERCENTER | USERCENTER20120220_DATA | T_USER_LOG | TABLE | 9,936 | 0.19 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_FFHM_TJSJ | INDEX | 106 | 34.42 | |
USERCENTER | USERCENTER20120220_DATA | SMS_SEND_XW | TABLE | 75 | 24.35 | |
USERCENTER | USERCENTER20120220_DATA | T_FEE | TABLE | 57 | 18.51 | |
USERCENTER | USERCENTER20120220_DATA | F_PAR | TABLE | 39 | 12.66 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_JSHM_TJSJ | INDEX | 15 | 4.87 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | F_PAR_EXC | TABLE | 296,085 | 97.84 | |
USERCENTER | USERCENTER20120220_DATA | SMS_SEND_XW | TABLE | 3,129 | 1.03 | |
SYS | SYSTEM | SEQ$ | TABLE | 1,013 | 0.33 | |
USERCENTER | USERCENTER20120220_DATA | F_PAR | TABLE | 557 | 0.18 | |
USERCENTER | USERCENTER20120220_DATA | T_FEE | TABLE | 532 | 0.18 |
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
---|---|---|---|---|---|---|
dc_awr_control | 70 | 0.00 | 0 | 2 | 1 | |
dc_files | 10 | 100.00 | 0 | 0 | 10 | |
dc_global_oids | 474 | 0.00 | 0 | 0 | 68 | |
dc_histogram_data | 461,928 | 0.03 | 0 | 0 | 2,876 | |
dc_histogram_defs | 318,061 | 0.27 | 0 | 0 | 3,102 | |
dc_object_grants | 2 | 0.00 | 0 | 0 | 32 | |
dc_objects | 301,963 | 0.02 | 0 | 5 | 2,276 | |
dc_profiles | 114,207 | 0.00 | 0 | 0 | 1 | |
dc_rollback_segments | 33,945 | 0.00 | 0 | 0 | 704 | |
dc_segments | 141,732 | 0.06 | 0 | 18 | 1,127 | |
dc_sequences | 1,078 | 0.09 | 0 | 1,078 | 24 | |
dc_tablespaces | 2,109,005 | 0.00 | 0 | 0 | 11 | |
dc_users | 8,892,407 | 0.00 | 0 | 0 | 132 | |
global database name | 116,571 | 0.00 | 0 | 0 | 1 | |
outstanding_alerts | 55 | 3.64 | 0 | 2 | 9 | |
sch_lj_oids | 5 | 0.00 | 0 | 0 | 51 |
Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
---|---|---|---|---|---|---|
ACCOUNT_STATUS | 228,282 | 0.00 | 0 | 0 | 0 | |
BODY | 1,822 | 0.22 | 2,696 | 0.33 | 5 | 0 |
CLUSTER | 24 | 4.17 | 26 | 3.85 | 0 | 0 |
DBLINK | 228,343 | 0.00 | 0 | 0 | 0 | |
EDITION | 114,218 | 0.00 | 228,419 | 0.00 | 0 | 0 |
INDEX | 84 | 25.00 | 84 | 25.00 | 0 | 0 |
QUEUE | 61 | 0.00 | 199 | 0.00 | 0 | 0 |
RULESET | 0 | 2 | 0.00 | 0 | 0 | |
SCHEMA | 114,241 | 0.00 | 0 | 0 | 0 | |
SQL AREA | 837,840 | 3.25 | 1,950,962 | 7.99 | 71,968 | 23 |
SQL AREA BUILD | 99,335 | 28.50 | 0 | 0 | 0 | |
SQL AREA STATS | 28,359 | 99.42 | 28,349 | 99.42 | 0 | 0 |
SUBSCRIPTION | 13 | 0.00 | 13 | 0.00 | 0 | 0 |
TABLE/PROCEDURE | 172,544 | 0.01 | 462,930 | 0.12 | 462 | 0 |
TRIGGER | 1,449 | 0.00 | 3,114 | 0.22 | 7 | 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 | 3,008.00 | 3,008.00 | 2,528.00 | 3,104.00 | 0 | SHR/DEF |
KEEP buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
PGA Target | 4,192.00 | 4,192.00 | 4,192.00 | 4,768.00 | 0 | SHR/MAN |
RECYCLE buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
SGA Target | 7,808.00 | 7,808.00 | 7,232.00 | 7,808.00 | 0 | GRO/DEF |
Shared IO Pool | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
java pool | 32.00 | 32.00 | 32.00 | 32.00 | 0 | STA/ |
large pool | 32.00 | 32.00 | 32.00 | 32.00 | 0 | STA/ |
shared pool | 4,640.00 | 4,640.00 | 4,448.00 | 4,640.00 | 0 | GRO/DEF |
streams pool | 32.00 | 32.00 | 32.00 | 32.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 | 852.20 | 1.11 | 1.89 | 27 | 27 | 770 | 770 | |
B | Freeable | 78.06 | 0.00 | 1.56 | 2.16 | 10 | 50 | 50 | |
B | SQL | 6.69 | 5.51 | 0.01 | 0.12 | 3 | 13 | 751 | 240 |
B | PL/SQL | 2.59 | 1.10 | 0.00 | 0.01 | 0 | 2 | 767 | 767 |
E | Other | 943.00 | 1.10 | 1.83 | 28 | 28 | 858 | 858 | |
E | Freeable | 125.69 | 0.00 | 1.34 | 1.77 | 10 | 94 | 94 | |
E | SQL | 4.58 | 3.19 | 0.01 | 0.09 | 3 | 13 | 840 | 294 |
E | PL/SQL | 3.39 | 1.67 | 0.00 | 0.01 | 0 | 1 | 856 | 856 |
SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
---|---|---|
Database Buffers | 3,154,116,608 | |
Fixed Size | 2,237,488 | |
Redo Buffers | 17,973,248 | |
Variable Size | 7,281,314,768 |
Pool | Name | Begin MB | End MB | % Diff |
---|---|---|---|---|
java | free memory | 32.00 | 32.00 | 0.00 |
large | PX msg pool | 7.81 | 7.81 | 0.00 |
large | free memory | 24.19 | 24.19 | 0.00 |
shared | ASH buffers | 48.00 | 48.00 | 0.00 |
shared | KGLH0 | 610.97 | 564.31 | -7.64 |
shared | KGLHD | 98.62 | 91.41 | -7.32 |
shared | SQLA | 2,032.24 | 2,032.29 | 0.00 |
shared | dbktb: trace buffer | 46.88 | 46.88 | 0.00 |
shared | event statistics per sess | 56.62 | 56.62 | 0.00 |
shared | free memory | 1,086.05 | 1,132.46 | 4.27 |
shared | kglsim object batch | 78.07 | 78.07 | 0.00 |
shared | ksunfy : SSO free list | 52.78 | 52.78 | 0.00 |
shared | private strands | 64.68 | 64.68 | 0.00 |
streams | free memory | 32.00 | 32.00 | 0.00 |
buffer_cache | 3,008.00 | 3,008.00 | 0.00 | |
fixed_sga | 2.13 | 2.13 | 0.00 | |
log_buffer | 17.14 | 17.14 | 0.00 |
Session Type | First Logon | CPU time(s) | User IO Wait time(s) | SYS IO Wait time(s) |
---|---|---|---|---|
QMON Coordinator | 0803 10:21:13 | 0.00 | 0.00 | 0.00 |
QMON Slaves | 0803 10:21:23 | 0.00 | 0.58 | 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 | 2 | 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(12733) | 2 | 0 | 100.00 | 0.00 | 0.00 | 0.00 | 0.00 | 17.66 |
SYS.AQ$_ALERT_QT_E(12732) | 0 | 0 | 0.00 | 0.00 | ||||
SYSMAN.MGMT_TASK_Q(68711) | 53 | 53 | 0.00 | 0.00 | 0.05 | 44.85 | 0.00 | 0.00 |
Queue Name | Enqueue Msgs/sec | Dequeue Msgs/sec | Avg Enqueue sec / msg | Avg Dequeue sec / msg |
---|---|---|---|---|
SYS.ALERT_QUE(12733) | 0.00 | 0.00 | 0.00 | |
SYS.AQ$_ALERT_QT_E(12732) | 0.00 | 0.00 | ||
SYSMAN.MGMT_TASK_Q(68711) | 0.01 | 0.01 | 0.00 | 0.85 |
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 | |||
LOCALHOST_LOC_3938_JQHX(41)/SYS.ALERT_QUE | 2 | 0 | 0 | 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,902 | 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,901 | 0.00 | 100.00 | 0 | 0 |
Parameter Name | Begin value | End value (if different) |
---|---|---|
audit_file_dest | /opt/oracle/admin/jqhx/adump | |
audit_trail | NONE | |
compatible | 11.2.0.0.0 | |
control_file_record_keep_time | 14 | |
control_files | /opt/oracle/oradata/jqhx/control01.ctl, /opt/oracle/fast_recovery_area/jqhx/control02.ctl | |
db_block_size | 8192 | |
db_domain | localdomain | |
db_name | jqhx | |
db_recovery_file_dest | /opt/oracle/fast_recovery_area | |
db_recovery_file_dest_size | 53687091200 | |
diagnostic_dest | /opt/oracle | |
dispatchers | (PROTOCOL=TCP) (SERVICE=jqhxXDB) | |
memory_target | 12582912000 | |
open_cursors | 300 | |
pga_aggregate_target | 3600 | |
processes | 3000 | |
remote_login_passwordfile | EXCLUSIVE | |
sga_max_size | 10502537216 | |
sga_target | 7549747200 | |
undo_tablespace | UNDOTBS1 |
Parameter Name | Begin value | End value (if different) |
---|---|---|
control_files | /opt/oracle/fast_recovery_area/jqhx/control02.ctl | |
control_files | /opt/oracle/oradata/jqhx/control01.ctl |