DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
---|---|---|---|---|---|---|
JKDB | 1477930046 | jkdb | 1 | 21-9月 -13 13:09 | 11.2.0.1.0 | NO |
Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
---|---|---|---|---|---|
DBSERVER1 | Microsoft Windows x86 64-bit | 32 | 32 | 4 | 127.93 |
Snap Id | Snap Time | Sessions | Cursors/Session | |
---|---|---|---|---|
Begin Snap: | 8851 | 24-9月 -13 09:00:18 | 150 | 6.2 |
End Snap: | 8852 | 24-9月 -13 10:00:32 | 153 | 6.4 |
Elapsed: | 60.23 (mins) | |||
DB Time: | 553.89 (mins) |
Begin | End | |||
---|---|---|---|---|
Buffer Cache: | 18,624M | 18,624M | Std Block Size: | 8K |
Shared Pool Size: | 2,816M | 2,816M | Log Buffer: | 27,696K |
Per Second | Per Transaction | Per Exec | Per Call | |
---|---|---|---|---|
DB Time(s): | 9.2 | 0.1 | 0.03 | 0.03 |
DB CPU(s): | 1.5 | 0.0 | 0.00 | 0.00 |
Redo size: | 191,849.7 | 1,854.6 | ||
Logical reads: | 64,709.2 | 625.5 | ||
Block changes: | 1,151.6 | 11.1 | ||
Physical reads: | 640.1 | 6.2 | ||
Physical writes: | 168.7 | 1.6 | ||
User calls: | 334.2 | 3.2 | ||
Parses: | 126.0 | 1.2 | ||
Hard parses: | 44.8 | 0.4 | ||
W/A MB processed: | 1.0 | 0.0 | ||
Logons: | 0.3 | 0.0 | ||
Executes: | 304.4 | 2.9 | ||
Rollbacks: | 0.0 | 0.0 | ||
Transactions: | 103.5 |
Buffer Nowait %: | 99.99 | Redo NoWait %: | 100.00 |
Buffer Hit %: | 99.77 | In-memory Sort %: | 100.00 |
Library Hit %: | 82.89 | Soft Parse %: | 64.41 |
Execute to Parse %: | 58.61 | Latch Hit %: | 99.89 |
Parse CPU to Parse Elapsd %: | 29.18 | % Non-Parse CPU: | 34.92 |
Begin | End | |
---|---|---|
Memory Usage %: | 62.90 | 62.25 |
% SQL with executions>1: | 57.46 | 61.60 |
% Memory for SQL w/exec>1: | 69.00 | 70.95 |
Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
---|---|---|---|---|---|
row cache lock | 1,579 | 21,973 | 13916 | 66.12 | Concurrency |
DB CPU | 5,424 | 16.32 | |||
db file sequential read | 502,684 | 3,203 | 6 | 9.64 | User I/O |
log file sync | 376,955 | 1,647 | 4 | 4.96 | Commit |
cursor: mutex S | 5,823,872 | 1,117 | 0 | 3.36 | Concurrency |
Load Average Begin | Load Average End | %User | %System | %WIO | %Idle |
---|---|---|---|---|---|
4.9 | 0.4 | 94.7 |
%Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) |
---|---|---|
4.8 | 90.8 | 0.0 |
Begin | End | |
---|---|---|
Host Mem (MB): | 131,004.6 | 131,004.6 |
SGA use (MB): | 22,144.0 | 22,144.0 |
PGA use (MB): | 401.2 | 413.5 |
% Host Mem used for SGA+PGA: | 17.21 | 17.22 |
Statistic Name | Time (s) | % of DB Time |
---|---|---|
connection management call elapsed time | 14,232.51 | 42.83 |
parse time elapsed | 12,234.81 | 36.81 |
sql execute elapsed time | 10,241.56 | 30.82 |
hard parse elapsed time | 8,785.34 | 26.44 |
DB CPU | 5,424.31 | 16.32 |
failed parse elapsed time | 545.40 | 1.64 |
inbound PL/SQL rpc elapsed time | 169.78 | 0.51 |
PL/SQL execution elapsed time | 160.25 | 0.48 |
hard parse (sharing criteria) elapsed time | 9.04 | 0.03 |
PL/SQL compilation elapsed time | 1.24 | 0.00 |
hard parse (bind mismatch) elapsed time | 0.39 | 0.00 |
repeated bind elapsed time | 0.19 | 0.00 |
sequence load elapsed time | 0.05 | 0.00 |
DB time | 33,233.55 | |
background elapsed time | 2,535.25 | |
background cpu time | 151.99 |
Statistic | Value | End Value |
---|---|---|
AVG_BUSY_TIME | 19,068 | |
AVG_IDLE_TIME | 342,111 | |
AVG_SYS_TIME | 1,363 | |
AVG_USER_TIME | 17,595 | |
BUSY_TIME | 614,101 | |
IDLE_TIME | 10,951,309 | |
SYS_TIME | 47,333 | |
USER_TIME | 566,871 | |
VM_IN_BYTES | -2,609,959,125,677,481,984 | |
VM_OUT_BYTES | 2,374,945,116,508,160 | |
PHYSICAL_MEMORY_BYTES | 137,368,281,088 | |
NUM_CPUS | 32 | |
NUM_CPU_CORES | 32 | |
NUM_CPU_SOCKETS | 4 |
Snap Time | Load | %busy | %user | %sys | %idle | %iowait |
---|---|---|---|---|---|---|
24-9月 09:00:18 | 0.00 | |||||
24-9月 10:00:32 | 0.00 | 5.31 | 4.90 | 0.41 | 94.69 | 0.00 |
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %DB time |
---|---|---|---|---|---|
Concurrency | 5,845,564 | 100 | 23,620 | 4 | 71.07 |
DB CPU | 5,424 | 16.32 | |||
User I/O | 530,451 | 0 | 3,258 | 6 | 9.80 |
Commit | 376,955 | 0 | 1,647 | 4 | 4.96 |
Network | 883,508 | 0 | 2 | 0 | 0.01 |
Other | 3,747 | 97 | 2 | 1 | 0.01 |
Application | 4,027 | 0 | 1 | 0 | 0.00 |
System I/O | 446 | 0 | 0 | 1 | 0.00 |
Configuration | 14 | 0 | 0 | 9 | 0.00 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % DB time |
---|---|---|---|---|---|---|
row cache lock | 1,579 | 53 | 21,973 | 13916 | 0.00 | 66.12 |
db file sequential read | 502,684 | 0 | 3,203 | 6 | 1.34 | 9.64 |
log file sync | 376,955 | 0 | 1,647 | 4 | 1.01 | 4.96 |
cursor: mutex S | 5,823,872 | 100 | 1,117 | 0 | 15.58 | 3.36 |
library cache lock | 10,490 | 0 | 427 | 41 | 0.03 | 1.28 |
cursor: pin S wait on X | 11 | 0 | 98 | 8920 | 0.00 | 0.30 |
direct path read | 9,073 | 0 | 36 | 4 | 0.02 | 0.11 |
read by other session | 16,715 | 0 | 16 | 1 | 0.04 | 0.05 |
buffer busy waits | 4,595 | 0 | 4 | 1 | 0.01 | 0.01 |
kksfbc child completion | 31 | 100 | 2 | 55 | 0.00 | 0.01 |
db file scattered read | 243 | 0 | 2 | 7 | 0.00 | 0.00 |
db file parallel read | 67 | 0 | 2 | 23 | 0.00 | 0.00 |
SQL*Net message to client | 856,773 | 0 | 1 | 0 | 2.29 | 0.00 |
latch: row cache objects | 2,084 | 0 | 1 | 0 | 0.01 | 0.00 |
SQL*Net more data to client | 26,082 | 0 | 1 | 0 | 0.07 | 0.00 |
Disk file operations I/O | 1,668 | 0 | 1 | 0 | 0.00 | 0.00 |
SQL*Net break/reset to client | 3,232 | 0 | 1 | 0 | 0.01 | 0.00 |
control file sequential read | 446 | 0 | 0 | 1 | 0.00 | 0.00 |
enq: TX - row lock contention | 793 | 0 | 0 | 0 | 0.00 | 0.00 |
SQL*Net message from dblink | 287 | 0 | 0 | 1 | 0.00 | 0.00 |
latch: shared pool | 556 | 0 | 0 | 0 | 0.00 | 0.00 |
log file switch (private strand flush incomplete) | 2 | 0 | 0 | 57 | 0.00 | 0.00 |
ADR block file read | 36 | 0 | 0 | 3 | 0.00 | 0.00 |
library cache: mutex X | 371 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: In memory undo latch | 749 | 0 | 0 | 0 | 0.00 | 0.00 |
latch free | 64 | 0 | 0 | 1 | 0.00 | 0.00 |
enq: KO - fast object checkpoint | 2 | 0 | 0 | 16 | 0.00 | 0.00 |
ADR block file write | 5 | 0 | 0 | 6 | 0.00 | 0.00 |
latch: cache buffers chains | 1,231 | 0 | 0 | 0 | 0.00 | 0.00 |
SQL*Net more data from client | 81 | 0 | 0 | 0 | 0.00 | 0.00 |
enq: HW - contention | 12 | 0 | 0 | 1 | 0.00 | 0.00 |
asynch descriptor resize | 3,598 | 100 | 0 | 0 | 0.01 | 0.00 |
enq: TX - index contention | 21 | 0 | 0 | 0 | 0.00 | 0.00 |
SQL*Net message from client | 856,768 | 0 | 391,371 | 457 | 2.29 | |
jobq slave wait | 8,631 | 99 | 4,425 | 513 | 0.02 | |
Streams AQ: waiting for messages in the queue | 729 | 99 | 3,613 | 4956 | 0.00 | |
wait for unread message on broadcast channel | 3,623 | 98 | 3,613 | 997 | 0.01 | |
single-task message | 2 | 0 | 0 | 18 | 0.00 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
---|---|---|---|---|---|---|
db file parallel write | 560,417 | 0 | 1,370 | 2 | 1.50 | 54.04 |
log file parallel write | 352,244 | 0 | 985 | 3 | 0.94 | 38.86 |
control file parallel write | 1,767 | 0 | 9 | 5 | 0.00 | 0.35 |
control file sequential read | 4,637 | 0 | 7 | 2 | 0.01 | 0.29 |
db file sequential read | 288 | 0 | 2 | 6 | 0.00 | 0.06 |
os thread startup | 137 | 0 | 2 | 12 | 0.00 | 0.06 |
LGWR wait for redo copy | 1,393 | 0 | 0 | 0 | 0.00 | 0.00 |
Disk file operations I/O | 125 | 0 | 0 | 1 | 0.00 | 0.00 |
direct path write | 6 | 0 | 0 | 7 | 0.00 | 0.00 |
ADR block file read | 13 | 0 | 0 | 2 | 0.00 | 0.00 |
ADR block file write | 5 | 0 | 0 | 5 | 0.00 | 0.00 |
direct path read | 1 | 0 | 0 | 25 | 0.00 | 0.00 |
log file sequential read | 4 | 0 | 0 | 4 | 0.00 | 0.00 |
latch free | 25 | 0 | 0 | 0 | 0.00 | 0.00 |
reliable message | 4 | 0 | 0 | 1 | 0.00 | 0.00 |
latch: messages | 29 | 0 | 0 | 0 | 0.00 | 0.00 |
db file scattered read | 2 | 0 | 0 | 1 | 0.00 | 0.00 |
log file single write | 4 | 0 | 0 | 1 | 0.00 | 0.00 |
rdbms ipc reply | 4 | 0 | 0 | 0 | 0.00 | 0.00 |
log file sync | 2 | 0 | 0 | 1 | 0.00 | 0.00 |
SQL*Net message to client | 2,250 | 0 | 0 | 0 | 0.01 | 0.00 |
asynch descriptor resize | 952 | 100 | 0 | 0 | 0.00 | 0.00 |
latch: redo writing | 14 | 0 | 0 | 0 | 0.00 | 0.00 |
rdbms ipc message | 357,561 | 5 | 51,660 | 144 | 0.96 | |
Streams AQ: waiting for time management or cleanup tasks | 21 | 52 | 20,439 | 973284 | 0.00 | |
DIAG idle wait | 7,128 | 100 | 7,223 | 1013 | 0.02 | |
Streams AQ: qmn coordinator idle wait | 258 | 50 | 3,614 | 14008 | 0.00 | |
Streams AQ: qmn slave idle wait | 132 | 0 | 3,614 | 27380 | 0.00 | |
pmon timer | 1,483 | 81 | 3,613 | 2436 | 0.00 | |
Space Manager: slave idle wait | 721 | 100 | 3,607 | 5002 | 0.00 | |
shared server idle wait | 120 | 100 | 3,602 | 30014 | 0.00 | |
dispatcher timer | 60 | 100 | 3,601 | 60012 | 0.00 | |
smon timer | 12 | 83 | 3,455 | 287919 | 0.00 | |
SQL*Net message from client | 3,033 | 0 | 4 | 1 | 0.01 | |
class slave wait | 15 | 0 | 0 | 0 | 0.00 |
% of Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Total Waits | <1ms | <2ms | <4ms | <8ms | <16ms | <32ms | <=1s | >1s |
ADR block file read | 49 | 57.1 | 4.1 | 8.2 | 22.4 | 6.1 | 2.0 | ||
ADR block file write | 10 | 10.0 | 90.0 | ||||||
ADR file lock | 12 | 100.0 | |||||||
Disk file operations I/O | 1793 | 96.8 | .7 | .6 | 1.2 | .4 | .1 | .2 | |
LGWR wait for redo copy | 1387 | 100.0 | |||||||
SQL*Net break/reset to client | 3254 | 99.9 | .1 | .0 | .0 | ||||
SQL*Net message from dblink | 349 | 92.6 | 3.7 | .6 | 3.2 | ||||
SQL*Net message to client | 858.9K | 100.0 | |||||||
SQL*Net message to dblink | 346 | 100.0 | |||||||
SQL*Net more data from client | 82 | 96.3 | 2.4 | 1.2 | |||||
SQL*Net more data to client | 26.1K | 100.0 | .0 | ||||||
asynch descriptor resize | 4554 | 100.0 | |||||||
buffer busy waits | 4597 | 61.8 | 33.1 | 5.0 | .1 | ||||
buffer deadlock | 2 | 100.0 | |||||||
control file parallel write | 1768 | 54.2 | 3.8 | 3.6 | 6.3 | 30.4 | 1.6 | .1 | |
control file sequential read | 5084 | 87.7 | 1.5 | 1.6 | 2.5 | 6.7 | .1 | ||
cursor: mutex S | 5822.4K | 97.7 | 2.0 | .3 | .0 | .0 | .0 | .0 | |
cursor: pin S | 3 | 100.0 | |||||||
cursor: pin S wait on X | 11 | 9.1 | 63.6 | 9.1 | 18.2 | ||||
db file parallel read | 67 | 1.5 | 20.9 | 65.7 | 11.9 | ||||
db file parallel write | 560.3K | 47.5 | 14.3 | 19.8 | 13.0 | 4.7 | .6 | .0 | |
db file scattered read | 245 | 12.2 | 6.5 | 5.3 | 52.7 | 18.4 | 4.5 | .4 | |
db file sequential read | 503.1K | 13.5 | 1.8 | 22.0 | 46.8 | 11.8 | 2.9 | 1.2 | |
direct path read | 9074 | 14.8 | 7.7 | 60.0 | 11.8 | 4.3 | 1.0 | .4 | |
direct path write | 6 | 66.7 | 33.3 | ||||||
direct path write temp | 1 | 100.0 | |||||||
enq: HW - contention | 12 | 50.0 | 50.0 | ||||||
enq: KO - fast object checkpoint | 2 | 50.0 | 50.0 | ||||||
enq: TX - index contention | 21 | 100.0 | |||||||
enq: TX - row lock contention | 793 | 87.6 | 11.9 | .5 | |||||
kksfbc child completion | 31 | 100.0 | |||||||
latch free | 88 | 78.4 | 18.2 | 3.4 | |||||
latch: In memory undo latch | 749 | 100.0 | |||||||
latch: cache buffers chains | 1231 | 100.0 | |||||||
latch: cache buffers lru chain | 3 | 100.0 | |||||||
latch: checkpoint queue latch | 1 | 100.0 | |||||||
latch: enqueue hash chains | 3 | 100.0 | |||||||
latch: messages | 29 | 100.0 | |||||||
latch: redo allocation | 3 | 100.0 | |||||||
latch: redo writing | 14 | 100.0 | |||||||
latch: row cache objects | 2084 | 89.1 | 6.5 | 3.0 | 1.3 | .0 | .1 | ||
latch: shared pool | 556 | 86.2 | 13.1 | .4 | .2 | .2 | |||
library cache load lock | 2 | 100.0 | |||||||
library cache lock | 10.5K | 13.3 | 5.1 | 6.4 | 9.3 | 13.0 | 16.0 | 36.9 | |
library cache: mutex X | 371 | 98.7 | .3 | .8 | .3 | ||||
log file parallel write | 352K | 72.5 | 2.4 | 3.6 | 6.7 | 13.4 | 1.4 | .0 | |
log file sequential read | 4 | 50.0 | 50.0 | ||||||
log file single write | 4 | 100.0 | |||||||
log file switch (private strand flush incomplete) | 2 | 100.0 | |||||||
log file sync | 376.7K | 57.4 | 6.2 | 4.5 | 9.6 | 17.6 | 4.5 | .2 | |
os thread startup | 137 | 19.7 | 79.6 | .7 | |||||
rdbms ipc reply | 4 | 100.0 | |||||||
read by other session | 16.7K | 89.2 | 1.6 | 2.9 | 4.1 | 1.8 | .3 | .2 | |
reliable message | 6 | 66.7 | 33.3 | ||||||
row cache lock | 1579 | .1 | .4 | .4 | .6 | 3.8 | 2.2 | 92.7 | |
DIAG idle wait | 7120 | 100.0 | |||||||
SQL*Net message from client | 859.7K | 63.7 | 7.7 | 6.3 | 9.6 | 4.3 | 1.2 | 5.1 | 2.2 |
Space Manager: slave idle wait | 721 | 100.0 | |||||||
Streams AQ: qmn coordinator idle wait | 256 | 50.0 | 50.0 | ||||||
Streams AQ: qmn slave idle wait | 131 | 2.3 | 97.7 | ||||||
Streams AQ: waiting for messages in the queue | 729 | .1 | .3 | .1 | .4 | 99.0 | |||
Streams AQ: waiting for time management or cleanup tasks | 21 | 23.8 | 28.6 | 47.6 | |||||
class slave wait | 15 | 100.0 | |||||||
dispatcher timer | 60 | 100.0 | |||||||
jobq slave wait | 8625 | .0 | 100.0 | ||||||
pmon timer | 1484 | 19.1 | 80.9 | ||||||
rdbms ipc message | 357.3K | 23.1 | 8.2 | 13.4 | 28.9 | 14.6 | 4.7 | 3.3 | 3.9 |
shared server idle wait | 121 | 100.0 | |||||||
single-task message | 3 | 33.3 | 66.7 | ||||||
smon timer | 12 | 100.0 | |||||||
wait for unread message on broadcast channel | 3624 | .2 | .6 | .6 | 98.7 |
% of Total Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Waits 64ms to 2s | <32ms | <64ms | <1/8s | <1/4s | <1/2s | <1s | <2s | >=2s |
Disk file operations I/O | 3 | 99.8 | .2 | ||||||
control file parallel write | 1 | 99.9 | .1 | ||||||
cursor: mutex S | 10 | 100.0 | .0 | .0 | .0 | ||||
cursor: pin S wait on X | 1 | 72.7 | 9.1 | 18.2 | |||||
db file parallel read | 8 | 88.1 | 10.4 | 1.5 | |||||
db file parallel write | 65 | 100.0 | .0 | .0 | .0 | ||||
db file scattered read | 1 | 99.6 | .4 | ||||||
db file sequential read | 5935 | 98.8 | .6 | .4 | .2 | .0 | .0 | ||
direct path read | 35 | 99.6 | .2 | .1 | .1 | .0 | |||
kksfbc child completion | 31 | 100.0 | |||||||
library cache lock | 3874 | 63.1 | 16.1 | 13.9 | 5.7 | 1.2 | .0 | ||
log file parallel write | 126 | 100.0 | .0 | .0 | .0 | ||||
log file switch (private strand flush incomplete) | 2 | 100.0 | |||||||
log file sync | 839 | 99.8 | .2 | .0 | .0 | ||||
os thread startup | 1 | 99.3 | .7 | ||||||
read by other session | 30 | 99.8 | .1 | .0 | .0 | .0 | |||
row cache lock | 41 | 5.2 | 1.3 | .1 | .3 | .4 | .4 | 92.2 |
% of Total Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Waits 4s to 2m | <2s | <4s | <8s | <16s | <32s | < 1m | < 2m | >=2m |
cursor: pin S wait on X | 2 | 81.8 | 9.1 | 9.1 | |||||
row cache lock | 1453 | 7.8 | 1.3 | 60.2 | 2.1 | 25.0 | 1.1 | 2.4 | .2 |
% of Total Waits | ||||||||
---|---|---|---|---|---|---|---|---|
Event | Waits 4m to 1h | <2m | <4m | <8m | <1/4h | <1/2h | < 1h | >=1h |
row cache lock | 3 | 99.8 | .2 |
Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) |
---|---|---|---|---|
JKDB | 32,391 | 5,289 | 523 | 231,821 |
SYS$USERS | 839 | 136 | 1,790 | 1,956 |
JKDBXDB | 0 | 0 | 0 | 0 |
SYS$BACKGROUND | 0 | 0 | 0 | 61 |
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 |
---|---|---|---|---|---|---|---|---|
JKDB | 520800 | 3220 | 5698624 | 23235 | 0 | 0 | 881187 | 2 |
SYS$USERS | 9642 | 38 | 146940 | 385 | 0 | 0 | 2313 | 0 |
SYS$BACKGROUND | 415 | 2 | 138 | 2 | 0 | 0 | 0 | 0 |
Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
3,240.03 | 39,453 | 0.08 | 9.75 | 0.24 | 0.00 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
2,781.52 | 8.37 | 86.87 | 4vs91dcv7u1p6 | insert into sys.aud$( sessioni... | ||||
928.13 | 115,001 | 0.01 | 2.79 | 3.78 | 96.66 | b7za0szn758fx | TablesMover.exe | DELETE FROM "CAPTURELIST" WHER... |
745.80 | 2,584 | 0.29 | 2.24 | 99.58 | 0.00 | 2xpqurujh3b0r | InterCMSServer.exe | begin Proc_InsertDevStatus(Dev... |
745.14 | 2,584 | 0.29 | 2.24 | 99.59 | 0.00 | 7540avtkcgmx9 | InterCMSServer.exe | UPDATE CURDEVICESTATUS SET STA... |
633.28 | 84,296 | 0.01 | 1.91 | 6.90 | 92.11 | a3s6pu4n0ttcm | GPS.exe | begin Proc_InsertGPSData(Vehic... |
620.07 | 84,297 | 0.01 | 1.87 | 5.24 | 94.07 | dyn8c65fxx7g6 | GPS.exe | UPDATE CURGPSDATA SET VEHICLEN... |
603.37 | 84,296 | 0.01 | 1.82 | 3.11 | 96.67 | 7cd89mtu3ytgw | GPS.exe | INSERT INTO HISGPSDATA (VEHICL... |
307.40 | 465 | 0.66 | 0.92 | 21.54 | 40.00 | fdy888x3xs0dq | w3wp.exe | begin prc_query(p_tableName=>:... |
254.32 | 2,584 | 0.10 | 0.77 | 99.13 | 0.00 | c12apabd94unq | InterCMSServer.exe | SELECT COUNT(*) FROM DEVICESTA... |
CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
2,416.32 | 44.55 | 2,781.52 | 86.87 | 4vs91dcv7u1p6 | insert into sys.aud$( sessioni... | ||||
742.64 | 2,584 | 0.29 | 13.69 | 745.80 | 99.58 | 0.00 | 2xpqurujh3b0r | InterCMSServer.exe | begin Proc_InsertDevStatus(Dev... |
742.10 | 2,584 | 0.29 | 13.68 | 745.14 | 99.59 | 0.00 | 7540avtkcgmx9 | InterCMSServer.exe | UPDATE CURDEVICESTATUS SET STA... |
252.10 | 2,584 | 0.10 | 4.65 | 254.32 | 99.13 | 0.00 | c12apabd94unq | InterCMSServer.exe | SELECT COUNT(*) FROM DEVICESTA... |
243.49 | 2,562 | 0.10 | 4.49 | 243.81 | 99.87 | 0.00 | gh6w1qbq7x4nx | InterCMSServer.exe | UPDATE DEVICESTATUS A SET ENDT... |
242.66 | 2,584 | 0.09 | 4.47 | 242.91 | 99.90 | 0.00 | arqy5fh5swxja | InterCMSServer.exe | SELECT A.STATUSNO, A.ENDTIME F... |
126.88 | 23,204 | 0.01 | 2.34 | 133.59 | 94.98 | 0.00 | g0kdm9gds168g | DataCollector_ZYJ_Oracle.exe | begin PT_HDPHOTO(t_DeviceID=>:... |
66.22 | 465 | 0.14 | 1.22 | 307.40 | 21.54 | 40.00 | fdy888x3xs0dq | w3wp.exe | begin prc_query(p_tableName=>:... |
63.76 | 23,204 | 0.00 | 1.18 | 63.61 | 100.23 | 0.00 | 64jtwyfuxpkr3 | DataCollector_ZYJ_Oracle.exe | SELECT COUNT(1) FROM HDPHOTOS ... |
56.38 | 23,204 | 0.00 | 1.04 | 62.60 | 90.07 | 0.00 | 2y018xjrv9360 | DataCollector_ZYJ_Oracle.exe | UPDATE HDPHOTOS SET LASTUPDATE... |
User I/O Time (s) | Executions | UIO per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
897.12 | 115,001 | 0.01 | 27.52 | 928.13 | 3.78 | 96.66 | b7za0szn758fx | TablesMover.exe | DELETE FROM "CAPTURELIST" WHER... |
583.31 | 84,297 | 0.01 | 17.89 | 620.07 | 5.24 | 94.07 | dyn8c65fxx7g6 | GPS.exe | UPDATE CURGPSDATA SET VEHICLEN... |
583.31 | 84,296 | 0.01 | 17.89 | 603.37 | 3.11 | 96.67 | 7cd89mtu3ytgw | GPS.exe | INSERT INTO HISGPSDATA (VEHICL... |
583.31 | 84,296 | 0.01 | 17.89 | 633.28 | 6.90 | 92.11 | a3s6pu4n0ttcm | GPS.exe | begin Proc_InsertGPSData(Vehic... |
122.95 | 465 | 0.26 | 3.77 | 307.40 | 21.54 | 40.00 | fdy888x3xs0dq | w3wp.exe | begin prc_query(p_tableName=>:... |
66.62 | 2 | 33.31 | 2.04 | 73.74 | 10.45 | 90.35 | 6x1yqcvu5jc5s | w3wp.exe | SELECT TO_NUMBER(COUNT(*)) FRO... |
0.22 | 741 | 0.00 | 0.01 | 36.74 | 1.02 | 0.61 | 7ng34ruy5awxq | select i.obj#, i.ts#, i.file#,... | |
0.16 | 1 | 0.16 | 0.01 | 4.12 | 96.10 | 3.96 | 4uphfayydzm8b | TablesMover.exe | Select CAPTURELIST.*, CAPTUREL... |
0.14 | 1 | 0.14 | 0.00 | 4.10 | 96.30 | 3.40 | 38r77vn8nj8v8 | TablesMover.exe | Select CAPTURELIST.*, CAPTUREL... |
0.12 | 6 | 0.02 | 0.00 | 0.30 | 52.55 | 41.54 | 2nszajb0qbyvp | DECLARE job BINARY_INTEGER := ... |
Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
66,561,523 | 2,584 | 25,759.10 | 28.46 | 745.80 | 99.58 | 0.00 | 2xpqurujh3b0r | InterCMSServer.exe | begin Proc_InsertDevStatus(Dev... |
66,553,771 | 2,584 | 25,756.10 | 28.46 | 745.14 | 99.59 | 0.00 | 7540avtkcgmx9 | InterCMSServer.exe | UPDATE CURDEVICESTATUS SET STA... |
22,175,888 | 2,584 | 8,582.00 | 9.48 | 242.91 | 99.90 | 0.00 | arqy5fh5swxja | InterCMSServer.exe | SELECT A.STATUSNO, A.ENDTIME F... |
22,175,888 | 2,584 | 8,582.00 | 9.48 | 254.32 | 99.13 | 0.00 | c12apabd94unq | InterCMSServer.exe | SELECT COUNT(*) FROM DEVICESTA... |
21,989,646 | 2,562 | 8,583.00 | 9.40 | 243.81 | 99.87 | 0.00 | gh6w1qbq7x4nx | InterCMSServer.exe | UPDATE DEVICESTATUS A SET ENDT... |
17,462,600 | 23,204 | 752.57 | 7.47 | 133.59 | 94.98 | 0.00 | g0kdm9gds168g | DataCollector_ZYJ_Oracle.exe | begin PT_HDPHOTO(t_DeviceID=>:... |
8,760,693 | 23,204 | 377.55 | 3.75 | 62.60 | 90.07 | 0.00 | 2y018xjrv9360 | DataCollector_ZYJ_Oracle.exe | UPDATE HDPHOTOS SET LASTUPDATE... |
8,667,113 | 23,204 | 373.52 | 3.71 | 63.61 | 100.23 | 0.00 | 64jtwyfuxpkr3 | DataCollector_ZYJ_Oracle.exe | SELECT COUNT(1) FROM HDPHOTOS ... |
2,172,247 | 54 | 40,226.80 | 0.93 | 29.15 | 79.31 | 0.00 | 0b15085bqkbkc | ORACLE.EXE | SELECT "A2"."DEVICEID", "A2"."... |
2,172,019 | 54 | 40,222.57 | 0.93 | 32.69 | 81.42 | 0.00 | bfk31x8d42g67 | ORACLE.EXE | SELECT DISTINCT "A1"."DEVICEID... |
Physical Reads | Executions | Reads per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
133,088 | 115,001 | 1.16 | 5.75 | 928.13 | 3.78 | 96.66 | b7za0szn758fx | TablesMover.exe | DELETE FROM "CAPTURELIST" WHER... |
77,780 | 84,297 | 0.92 | 3.36 | 620.07 | 5.24 | 94.07 | dyn8c65fxx7g6 | GPS.exe | UPDATE CURGPSDATA SET VEHICLEN... |
77,779 | 84,296 | 0.92 | 3.36 | 603.37 | 3.11 | 96.67 | 7cd89mtu3ytgw | GPS.exe | INSERT INTO HISGPSDATA (VEHICL... |
77,779 | 84,296 | 0.92 | 3.36 | 633.28 | 6.90 | 92.11 | a3s6pu4n0ttcm | GPS.exe | begin Proc_InsertGPSData(Vehic... |
66,488 | 465 | 142.98 | 2.87 | 307.40 | 21.54 | 40.00 | fdy888x3xs0dq | w3wp.exe | begin prc_query(p_tableName=>:... |
49,303 | 2 | 24,651.50 | 2.13 | 73.74 | 10.45 | 90.35 | 6x1yqcvu5jc5s | w3wp.exe | SELECT TO_NUMBER(COUNT(*)) FRO... |
29 | 1 | 29.00 | 0.00 | 4.12 | 96.10 | 3.96 | 4uphfayydzm8b | TablesMover.exe | Select CAPTURELIST.*, CAPTUREL... |
27 | 1 | 27.00 | 0.00 | 4.04 | 97.96 | 1.89 | 0zv836yqahwkw | TablesMover.exe | Select CAPTURELIST.*, CAPTUREL... |
23 | 1 | 23.00 | 0.00 | 4.10 | 96.30 | 3.40 | 38r77vn8nj8v8 | TablesMover.exe | Select CAPTURELIST.*, CAPTUREL... |
23 | 1 | 23.00 | 0.00 | 4.05 | 97.42 | 2.88 | b0x81hnmwjn5x | TablesMover.exe | Select CAPTURELIST.*, CAPTUREL... |
UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
133,088 | 133,088 | 115,001 | 1.16 | 0.00 | 25.63 | b7za0szn758fx | TablesMover.exe | DELETE FROM "CAPTURELIST" WHER... |
77,780 | 77,780 | 84,297 | 0.92 | 0.00 | 14.98 | dyn8c65fxx7g6 | GPS.exe | UPDATE CURGPSDATA SET VEHICLEN... |
77,779 | 77,779 | 84,296 | 0.92 | 0.00 | 14.98 | 7cd89mtu3ytgw | GPS.exe | INSERT INTO HISGPSDATA (VEHICL... |
48,289 | 48,289 | 2 | 24,144.50 | 0.00 | 9.30 | 6x1yqcvu5jc5s | w3wp.exe | SELECT TO_NUMBER(COUNT(*)) FRO... |
29 | 29 | 1 | 29.00 | 0.00 | 0.01 | 4uphfayydzm8b | TablesMover.exe | Select CAPTURELIST.*, CAPTUREL... |
27 | 27 | 1 | 27.00 | 0.00 | 0.01 | 0zv836yqahwkw | TablesMover.exe | Select CAPTURELIST.*, CAPTUREL... |
23 | 23 | 1 | 23.00 | 0.00 | 0.00 | 38r77vn8nj8v8 | TablesMover.exe | Select CAPTURELIST.*, CAPTUREL... |
23 | 23 | 1 | 23.00 | 0.00 | 0.00 | b0x81hnmwjn5x | TablesMover.exe | Select CAPTURELIST.*, CAPTUREL... |
6 | 6 | 465 | 0.01 | 0.00 | 0.00 | fdy888x3xs0dq | w3wp.exe | begin prc_query(p_tableName=>:... |
3 | 3 | 1,591 | 0.00 | 0.00 | 0.00 | fnkxtujrrunb8 | TablesCopier.exe | Insert into CAPTURELIST(ListNo... |
Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
134,994 | 134,750 | 1.00 | 13.17 | 98.70 | 0.11 | 2q76h51xvr4xw | TablesCopier.exe | UPDATE CALCVEHFLOW SET ALLVEHS... |
134,985 | 0 | 0.00 | 12.56 | 94.67 | 0.01 | c3szhz60a32mw | TablesCopier.exe | UPDATE VEHPLATEBLACKMAIN SET L... |
115,001 | 115,001 | 1.00 | 928.13 | 3.78 | 96.66 | b7za0szn758fx | TablesMover.exe | DELETE FROM "CAPTURELIST" WHER... |
84,297 | 84,297 | 1.00 | 620.07 | 5.24 | 94.07 | dyn8c65fxx7g6 | GPS.exe | UPDATE CURGPSDATA SET VEHICLEN... |
84,296 | 84,296 | 1.00 | 603.37 | 3.11 | 96.67 | 7cd89mtu3ytgw | GPS.exe | INSERT INTO HISGPSDATA (VEHICL... |
84,296 | 84,296 | 1.00 | 633.28 | 6.90 | 92.11 | a3s6pu4n0ttcm | GPS.exe | begin Proc_InsertGPSData(Vehic... |
39,453 | 55,797 | 1.41 | 3,240.03 | 0.24 | 0.00 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
23,206 | 23,206 | 1.00 | 1.90 | 92.62 | 0.00 | aadqr5sqm5pu0 | DataCollector_ZYJ_Oracle.exe | select count(*) from road |
23,204 | 27,736 | 1.20 | 62.60 | 90.07 | 0.00 | 2y018xjrv9360 | DataCollector_ZYJ_Oracle.exe | UPDATE HDPHOTOS SET LASTUPDATE... |
23,204 | 23,181 | 1.00 | 63.61 | 100.23 | 0.00 | 64jtwyfuxpkr3 | DataCollector_ZYJ_Oracle.exe | SELECT COUNT(1) FROM HDPHOTOS ... |
23,204 | 23,204 | 1.00 | 133.59 | 94.98 | 0.00 | g0kdm9gds168g | DataCollector_ZYJ_Oracle.exe | begin PT_HDPHOTO(t_DeviceID=>:... |
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
84,297 | 84,296 | 18.51 | a3s6pu4n0ttcm | GPS.exe | begin Proc_InsertGPSData(Vehic... |
39,460 | 39,453 | 8.67 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
23,206 | 23,206 | 5.10 | aadqr5sqm5pu0 | DataCollector_ZYJ_Oracle.exe | select count(*) from road |
23,204 | 23,204 | 5.10 | g0kdm9gds168g | DataCollector_ZYJ_Oracle.exe | begin PT_HDPHOTO(t_DeviceID=>:... |
8,184 | 8,184 | 1.80 | 1wr2png6s6xa3 | SELECT /* OPT_DYN_SAMP */ /*+ ... | |
5,385 | 5,385 | 1.18 | 3d1djwagx2831 | w3wp.exe | SELECT PLATFORMID, PLATFORMNAM... |
4,005 | 4,005 | 0.88 | dva2s149vds50 | w3wp.exe | SELECT ID, DEPARTMENTID, EMPLC... |
3,694 | 3,694 | 0.81 | g3hxajqptdbsc | w3wp.exe | SELECT ID, PID, COMPANYID, DEP... |
2,780 | 2,780 | 0.61 | cjaa80k1hvpc1 | select 1 from sys.cdc_change_t... | |
2,584 | 2,584 | 0.57 | 2xpqurujh3b0r | InterCMSServer.exe | begin Proc_InsertDevStatus(Dev... |
Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
51,593,560 | 1.75 | f711myt0q6cma | insert into sys.aud$( sessioni... | ||
30,834,912 | 1.04 | 4vs91dcv7u1p6 | insert into sys.aud$( sessioni... | ||
4,756,389 | 139 | 0.16 | 18naypzfmabd6 | INSERT INTO MGMT_SYSTEM_PERFOR... |
Version Count | Executions | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|
1,219 | f711myt0q6cma | insert into sys.aud$( sessioni... | ||
1,131 | 4vs91dcv7u1p6 | insert into sys.aud$( sessioni... | ||
655 | 465 | fdy888x3xs0dq | w3wp.exe | begin prc_query(p_tableName=>:... |
166 | 139 | 18naypzfmabd6 | INSERT INTO MGMT_SYSTEM_PERFOR... | |
101 | 148 | dkrbkzpyuyq4p | w3wp.exe | Select Contenttype, Decode(Con... |
101 | 148 | dkrbkzpyuyq4p | w3wp.exe | Select Contenttype, Decode(Con... |
80 | 6 | 2nszajb0qbyvp | DECLARE job BINARY_INTEGER := ... | |
70 | 6 | 1att0guk2skhm | select lobtsn, lobrdba, lobobj... | |
34 | 1 | 8x0funf899dka | INSERT INTO wri$_adv_addm_inst... | |
34 | 1 | a0xc4nq6swjvy | INSERT INTO wri$_adv_addm_fdg ... | |
34 | 0 | b41wak2bb7atw | SELECT sum(delta_cpu_time) as... | |
32 | 2,803 | 53saa2zkr6wc3 | select intcol#, nvl(pos#, 0), ... | |
32 | 2 | 97j83n99qkydw | OEM.SystemPool | DELETE FROM MGMT_DUPLICATE_TAR... |
32 | 28 | ddcvbkncpbrax | update "JKDB_SG"."MLOG$_TRAFFI... | |
26 | 3 | 1yzr1rwpsaqh4 | OEM.SystemPool | INSERT INTO MGMT_HA_MTTR (TARG... |
26 | 3 | 4a8d9qrv5thzd | OEM.SystemPool | UPDATE MGMT_HA_MTTR SET COLLEC... |
25 | 60 | 0xqn4sx1ytghr | select /*+ first_rows(1) no_ex... | |
24 | 3 | 05sghzkq6r6yv | select ts#, file#, block#, col... | |
24 | 8 | 3m779j2ytuk15 | update "JKDB_SG"."MLOG$_CURCMS... | |
23 | 6 | 6c9wx6z8w9qpu | select a.default_selectivity f... | |
23 | 1 | 74fnxs1kfd150 | OEM.SystemPool | DELETE FROM MGMT_BLACKOUT_WIND... |
23 | 0 | 8p9z2ztb272bm | SELECT sx.instance_number, sx... | |
23 | 12 | g2hcpty0f43ux | emagent_SQL_oracle_database | begin dbsnmp.mgmt_response.get... |
22 | 129 | 74anujtt8zw4h | select o.owner#, o.name, o.nam... | |
22 | 741 | 7ng34ruy5awxq | select i.obj#, i.ts#, i.file#,... | |
22 | 741 | 7ng34ruy5awxq | select i.obj#, i.ts#, i.file#,... | |
22 | 3 | b3zgx1xckrwxu | select host, userid, password,... | |
22 | 5 | bd4bznqbq73hk | select bo#, intcol# from icold... | |
21 | 0 | 23buxzfxyp1vy | SELECT greatest(0, 1000*servi... | |
21 | 0 | 4g46czps3t55u | SELECT sum(case when snap_id ... |
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 double miss count | 0 | 0.00 | 0.00 |
Batched IO same unit count | 0 | 0.00 | 0.00 |
Batched IO single block count | 0 | 0.00 | 0.00 |
Batched IO vector block count | 0 | 0.00 | 0.00 |
Batched IO vector read count | 0 | 0.00 | 0.00 |
Block Cleanout Optim referenced | 204 | 0.06 | 0.00 |
CCursor + sql area evicted | 687 | 0.19 | 0.00 |
CPU used by this session | 536,683 | 148.51 | 1.44 |
CPU used when call started | 535,938 | 148.31 | 1.43 |
CR blocks created | 9,159 | 2.53 | 0.02 |
Cached Commit SCN referenced | 975 | 0.27 | 0.00 |
Commit SCN cached | 1 | 0.00 | 0.00 |
DB time | 4,476,279 | 1,238.68 | 11.97 |
DBWR checkpoint buffers written | 608,820 | 168.47 | 1.63 |
DBWR checkpoints | 3 | 0.00 | 0.00 |
DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
DBWR tablespace checkpoint buffers written | 16 | 0.00 | 0.00 |
DBWR transaction table writes | 449 | 0.12 | 0.00 |
DBWR undo block writes | 32,192 | 8.91 | 0.09 |
HSC Compressed Segment Block Changes | 0 | 0.00 | 0.00 |
HSC Heap Segment Block Changes | 632,393 | 175.00 | 1.69 |
HSC OLTP Space Saving | 0 | 0.00 | 0.00 |
HSC OLTP positive compression | 0 | 0.00 | 0.00 |
HSC OLTP recursive compression | 0 | 0.00 | 0.00 |
Heap Segment Array Inserts | 143 | 0.04 | 0.00 |
Heap Segment Array Updates | 30,917 | 8.56 | 0.08 |
IMU CR rollbacks | 1,204 | 0.33 | 0.00 |
IMU Flushes | 43,413 | 12.01 | 0.12 |
IMU Redo allocation size | 53,706,796 | 14,861.80 | 143.67 |
IMU commits | 332,445 | 91.99 | 0.89 |
IMU contention | 5,040 | 1.39 | 0.01 |
IMU ktichg flush | 0 | 0.00 | 0.00 |
IMU pool not allocated | 482 | 0.13 | 0.00 |
IMU recursive-transaction flush | 0 | 0.00 | 0.00 |
IMU undo allocation size | 1,125,892,448 | 311,558.18 | 3,011.82 |
IMU- failed to get a private strand | 482 | 0.13 | 0.00 |
LOB table id lookup cache misses | 0 | 0.00 | 0.00 |
Number of read IOs issued | 14,002 | 3.87 | 0.04 |
RowCR - row contention | 2 | 0.00 | 0.00 |
RowCR attempts | 115 | 0.03 | 0.00 |
RowCR hits | 99 | 0.03 | 0.00 |
SMON posted for undo segment recovery | 0 | 0.00 | 0.00 |
SMON posted for undo segment shrink | 2 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 856,705 | 237.07 | 2.29 |
SQL*Net roundtrips to/from dblink | 313 | 0.09 | 0.00 |
active txn count during cleanout | 9,875 | 2.73 | 0.03 |
application wait time | 98 | 0.03 | 0.00 |
background checkpoints completed | 1 | 0.00 | 0.00 |
background checkpoints started | 1 | 0.00 | 0.00 |
background timeouts | 18,688 | 5.17 | 0.05 |
branch node splits | 6 | 0.00 | 0.00 |
buffer is not pinned count | 9,615,073 | 2,660.69 | 25.72 |
buffer is pinned count | 16,257,158 | 4,498.70 | 43.49 |
bytes received via SQL*Net from client | 265,417,848 | 73,446.72 | 710.01 |
bytes received via SQL*Net from dblink | 106,996 | 29.61 | 0.29 |
bytes sent via SQL*Net to client | 594,444,614 | 164,495.36 | 1,590.17 |
bytes sent via SQL*Net to dblink | 147,550 | 40.83 | 0.39 |
calls to get snapshot scn: kcmgss | 1,731,018 | 479.01 | 4.63 |
calls to kcmgas | 554,396 | 153.41 | 1.48 |
calls to kcmgcs | 1,066,870 | 295.23 | 2.85 |
cell physical IO interconnect bytes | 25,727,994,880 | 7,119,478.72 | 68,823.63 |
change write time | 1,474 | 0.41 | 0.00 |
cleanout - number of ktugct calls | 16,956 | 4.69 | 0.05 |
cleanouts and rollbacks - consistent read gets | 650 | 0.18 | 0.00 |
cleanouts only - consistent read gets | 3,096 | 0.86 | 0.01 |
cluster key scan block gets | 14,950 | 4.14 | 0.04 |
cluster key scans | 13,855 | 3.83 | 0.04 |
commit batch performed | 0 | 0.00 | 0.00 |
commit batch requested | 0 | 0.00 | 0.00 |
commit batch/immediate performed | 1,497 | 0.41 | 0.00 |
commit batch/immediate requested | 1,497 | 0.41 | 0.00 |
commit cleanout failures: block lost | 0 | 0.00 | 0.00 |
commit cleanout failures: buffer being written | 1 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 21,548 | 5.96 | 0.06 |
commit cleanout failures: cannot pin | 4,510 | 1.25 | 0.01 |
commit cleanouts | 1,479,019 | 409.28 | 3.96 |
commit cleanouts successfully completed | 1,452,960 | 402.06 | 3.89 |
commit immediate performed | 1,497 | 0.41 | 0.00 |
commit immediate requested | 1,497 | 0.41 | 0.00 |
commit txn count during cleanout | 89,578 | 24.79 | 0.24 |
concurrency wait time | 2,362,200 | 653.67 | 6.32 |
consistent changes | 5,832 | 1.61 | 0.02 |
consistent gets | 228,278,423 | 63,169.45 | 610.66 |
consistent gets - examination | 1,472,775 | 407.55 | 3.94 |
consistent gets direct | 1,789,472 | 495.18 | 4.79 |
consistent gets from cache | 226,488,951 | 62,674.27 | 605.87 |
consistent gets from cache (fastpath) | 222,994,218 | 61,707.20 | 596.52 |
cursor authentications | 2,614 | 0.72 | 0.01 |
data blocks consistent reads - undo records applied | 4,708 | 1.30 | 0.01 |
db block changes | 4,161,735 | 1,151.64 | 11.13 |
db block gets | 5,564,091 | 1,539.70 | 14.88 |
db block gets direct | 122 | 0.03 | 0.00 |
db block gets from cache | 5,563,969 | 1,539.67 | 14.88 |
db block gets from cache (fastpath) | 1,150,546 | 318.38 | 3.08 |
deferred (CURRENT) block cleanout applications | 634,502 | 175.58 | 1.70 |
dirty buffers inspected | 665 | 0.18 | 0.00 |
enqueue conversions | 909 | 0.25 | 0.00 |
enqueue releases | 1,380,827 | 382.10 | 3.69 |
enqueue requests | 1,380,841 | 382.11 | 3.69 |
enqueue timeouts | 3 | 0.00 | 0.00 |
enqueue waits | 828 | 0.23 | 0.00 |
exchange deadlocks | 2 | 0.00 | 0.00 |
execute count | 1,100,122 | 304.43 | 2.94 |
failed probes on index block reclamation | 0 | 0.00 | 0.00 |
file io service time | 0 | 0.00 | 0.00 |
file io wait time | 4,593,690,880 | 1,271,171.14 | 12,288.35 |
free buffer inspected | 644,739 | 178.41 | 1.72 |
free buffer requested | 721,149 | 199.56 | 1.93 |
heap block compress | 11,973 | 3.31 | 0.03 |
hot buffers moved to head of LRU | 595,001 | 164.65 | 1.59 |
immediate (CR) block cleanout applications | 3,746 | 1.04 | 0.01 |
immediate (CURRENT) block cleanout applications | 341,439 | 94.48 | 0.91 |
index crx upgrade (positioned) | 5,564 | 1.54 | 0.01 |
index crx upgrade (prefetch) | 4 | 0.00 | 0.00 |
index fast full scans (full) | 14,886 | 4.12 | 0.04 |
index fetch by key | 1,120,382 | 310.03 | 3.00 |
index scans kdiixs1 | 502,855 | 139.15 | 1.35 |
leaf node 90-10 splits | 41 | 0.01 | 0.00 |
leaf node splits | 1,740 | 0.48 | 0.00 |
lob reads | 460 | 0.13 | 0.00 |
lob writes | 122 | 0.03 | 0.00 |
lob writes unaligned | 122 | 0.03 | 0.00 |
logons cumulative | 1,019 | 0.28 | 0.00 |
max cf enq hold time | 0 | 0.00 | 0.00 |
messages received | 912,976 | 252.64 | 2.44 |
messages sent | 912,977 | 252.64 | 2.44 |
min active SCN optimization applied on CR | 2,177 | 0.60 | 0.01 |
no buffer to keep pinned count | 0 | 0.00 | 0.00 |
no work - consistent read gets | 225,685,515 | 62,451.94 | 603.72 |
non-idle wait count | 8,996,611 | 2,489.55 | 24.07 |
non-idle wait time | 3,090,778 | 855.28 | 8.27 |
opened cursors cumulative | 1,007,946 | 278.92 | 2.70 |
parse count (describe) | 35 | 0.01 | 0.00 |
parse count (failures) | 8,297 | 2.30 | 0.02 |
parse count (hard) | 162,038 | 44.84 | 0.43 |
parse count (total) | 455,297 | 125.99 | 1.22 |
parse time cpu | 353,001 | 97.68 | 0.94 |
parse time elapsed | 1,209,654 | 334.74 | 3.24 |
physical read IO requests | 519,319 | 143.71 | 1.39 |
physical read bytes | 18,948,235,264 | 5,243,376.27 | 50,687.45 |
physical read total IO requests | 524,424 | 145.12 | 1.40 |
physical read total bytes | 19,031,984,128 | 5,266,551.35 | 50,911.48 |
physical read total multi block requests | 14,141 | 3.91 | 0.04 |
physical reads | 2,313,017 | 640.06 | 6.19 |
physical reads cache | 523,528 | 144.87 | 1.40 |
physical reads cache prefetch | 20,232 | 5.60 | 0.05 |
physical reads direct | 1,789,489 | 495.19 | 4.79 |
physical reads direct (lob) | 15 | 0.00 | 0.00 |
physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 560,582 | 155.12 | 1.50 |
physical write bytes | 4,994,162,688 | 1,381,990.13 | 13,359.63 |
physical write total IO requests | 1,284,554 | 355.46 | 3.44 |
physical write total bytes | 6,696,010,752 | 1,852,927.38 | 17,912.15 |
physical write total multi block requests | 2,144 | 0.59 | 0.01 |
physical writes | 609,639 | 168.70 | 1.63 |
physical writes direct | 139 | 0.04 | 0.00 |
physical writes direct (lob) | 3 | 0.00 | 0.00 |
physical writes direct temporary tablespace | 1 | 0.00 | 0.00 |
physical writes from cache | 609,500 | 168.66 | 1.63 |
physical writes non checkpoint | 419,680 | 116.13 | 1.12 |
pinned buffers inspected | 143 | 0.04 | 0.00 |
pinned cursors current | 4 | 0.00 | 0.00 |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
prefetched blocks aged out before use | 1 | 0.00 | 0.00 |
process last non-idle time | 3,728 | 1.03 | 0.01 |
recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
recursive calls | 1,693,967 | 468.76 | 4.53 |
recursive cpu usage | 450,609 | 124.69 | 1.21 |
redo blocks checksummed by FG (exclusive) | 725,190 | 200.68 | 1.94 |
redo blocks written | 1,577,113 | 436.42 | 4.22 |
redo buffer allocation retries | 2 | 0.00 | 0.00 |
redo entries | 1,486,153 | 411.25 | 3.98 |
redo log space requests | 2 | 0.00 | 0.00 |
redo log space wait time | 14 | 0.00 | 0.00 |
redo ordering marks | 7,641 | 2.11 | 0.02 |
redo size | 693,296,420 | 191,849.74 | 1,854.60 |
redo size for direct writes | 408 | 0.11 | 0.00 |
redo subscn max counts | 333,704 | 92.34 | 0.89 |
redo synch time | 187,881 | 51.99 | 0.50 |
redo synch writes | 377,425 | 104.44 | 1.01 |
redo wastage | 88,286,400 | 24,430.71 | 236.17 |
redo write time | 103,584 | 28.66 | 0.28 |
redo writes | 352,170 | 97.45 | 0.94 |
rollback changes - undo records applied | 1,555 | 0.43 | 0.00 |
rollbacks only - consistent read gets | 3,198 | 0.88 | 0.01 |
rows fetched via callback | 328,047 | 90.78 | 0.88 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 333,883 | 92.39 | 0.89 |
session logical reads | 233,842,515 | 64,709.16 | 625.54 |
shared hash latch upgrades - no wait | 54,379 | 15.05 | 0.15 |
shared hash latch upgrades - wait | 4 | 0.00 | 0.00 |
sorts (memory) | 133,084 | 36.83 | 0.36 |
sorts (rows) | 783,133 | 216.71 | 2.09 |
sql area evicted | 153,766 | 42.55 | 0.41 |
sql area purged | 8,297 | 2.30 | 0.02 |
summed dirty queue length | 1,389 | 0.38 | 0.00 |
switch current to new buffer | 153,955 | 42.60 | 0.41 |
table fetch by rowid | 11,307,938 | 3,129.14 | 30.25 |
table fetch continued row | 12,461 | 3.45 | 0.03 |
table scan blocks gotten | 97,466,379 | 26,971.00 | 260.73 |
table scan rows gotten | 14,787,368,108 | 4,091,976.58 | 39,556.93 |
table scans (direct read) | 2 | 0.00 | 0.00 |
table scans (long tables) | 2 | 0.00 | 0.00 |
table scans (short tables) | 313,093 | 86.64 | 0.84 |
temp space allocated (bytes) | 0 | 0.00 | 0.00 |
total cf enq hold time | 1,431 | 0.40 | 0.00 |
total number of cf enq holders | 162 | 0.04 | 0.00 |
total number of times SMON posted | 2 | 0.00 | 0.00 |
transaction rollbacks | 1,497 | 0.41 | 0.00 |
transaction tables consistent read rollbacks | 28 | 0.01 | 0.00 |
transaction tables consistent reads - undo records applied | 322 | 0.09 | 0.00 |
undo change vector size | 242,823,300 | 67,194.33 | 649.56 |
user I/O wait time | 326,045 | 90.22 | 0.87 |
user calls | 1,207,749 | 334.21 | 3.23 |
user commits | 373,825 | 103.45 | 1.00 |
user rollbacks | 0 | 0.00 | 0.00 |
workarea executions - optimal | 79,167 | 21.91 | 0.21 |
write clones created in foreground | 13 | 0.00 | 0.00 |
Statistic | Begin Value | End Value |
---|---|---|
session uga memory | 29,422,732,167,616 | 29,847,993,139,544 |
opened cursors current | 925 | 986 |
workarea memory allocated | 0 | 1,747 |
logons current | 150 | 153 |
session uga memory max | 197,250,583,024 | 198,745,018,944 |
session pga memory | 12,834,822,568 | 13,027,149,640 |
session pga memory max | 18,256,624,760 | 18,625,700,680 |
session cursor cache count | 3,680,810 | 3,707,049 |
Statistic | Total | per Hour |
---|---|---|
log switches (derived) | 1 | 1.00 |
Function Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
---|---|---|---|---|---|---|---|---|
Direct Reads | 13.7G | 3.88 | 3.86856 | 0M | 0.00 | 0M | 0 | |
DBWR | 0M | 0.00 | 0M | 4.7G | 155.13 | 1.31774 | 0 | |
Buffer Cache Reads | 4G | 139.83 | 1.13151 | 0M | 0.00 | 0M | 503.3K | 6.45 |
LGWR | 1M | 0.01 | .000276 | 1.5G | 198.81 | .426150 | 42 | 2.60 |
Others | 79M | 1.41 | .021860 | 83M | 1.46 | .022967 | 6838 | 1.64 |
Direct Writes | 0M | 0.00 | 0M | 1M | 0.01 | .000276 | 0 | |
Streams AQ | 1M | 0.01 | .000276 | 0M | 0.00 | 0M | 30 | 5.20 |
TOTAL: | 17.7G | 145.13 | 5.02248 | 6.2G | 355.41 | 1.76714 | 510.2K | 6.38 |
Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read |
---|---|---|---|---|---|---|---|---|
Data File | 17.6G | 143.73 | 5.00035 | 4.7G | 155.15 | 1.31829 | 6.46 | 6.34 |
Log File | 0M | 0.00 | 0M | 1.5G | 198.80 | .425873 | 4.00 | |
Control File | 80M | 1.41 | .022137 | 83M | 1.47 | .022967 | 1.22 | |
Temp File | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 0.00 | |
TOTAL: | 17.7G | 145.14 | 5.02248 | 6.2G | 355.42 | 1.76714 | 6.41 | 6.34 |
Function/File Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
---|---|---|---|---|---|---|---|---|
Direct Reads | 13.7G | 3.88 | 3.86856 | 0M | 0.00 | 0M | 0 | |
Direct Reads (Data File) | 13.7G | 3.88 | 3.86856 | 0M | 0.00 | 0M | 0 | |
DBWR | 0M | 0.00 | 0M | 4.7G | 155.13 | 1.31774 | 0 | |
DBWR (Data File) | 0M | 0.00 | 0M | 4.7G | 155.13 | 1.31774 | 0 | |
Buffer Cache Reads | 4G | 139.83 | 1.13178 | 0M | 0.00 | 0M | 503.2K | 6.45 |
Buffer Cache Reads (Data File) | 4G | 139.83 | 1.13178 | 0M | 0.00 | 0M | 503.2K | 6.45 |
LGWR | 1M | 0.01 | .000276 | 1.5G | 198.80 | .426150 | 32 | 1.97 |
LGWR (Log File) | 0M | 0.00 | 0M | 1.5G | 198.79 | .425873 | 8 | 4.00 |
LGWR (Control File) | 1M | 0.01 | .000276 | 1M | 0.01 | .000276 | 24 | 1.29 |
Others | 79M | 1.41 | .021860 | 83M | 1.46 | .022967 | 5080 | 1.25 |
Others (Control File) | 79M | 1.40 | .021860 | 82M | 1.46 | .022691 | 5060 | 1.22 |
Others (Data File) | 0M | 0.01 | 0M | 1M | 0.00 | .000276 | 20 | 7.80 |
Streams AQ | 1M | 0.01 | .000276 | 0M | 0.00 | 0M | 30 | 5.20 |
Streams AQ (Data File) | 1M | 0.01 | .000276 | 0M | 0.00 | 0M | 30 | 5.20 |
Direct Writes | 0M | 0.00 | 0M | 1M | 0.01 | .000276 | 0 | |
Direct Writes (Data File) | 0M | 0.00 | 0M | 1M | 0.01 | .000276 | 0 | |
TOTAL: | 17.7G | 145.13 | 5.02276 | 6.2G | 355.40 | 1.76714 | 508.4K | 6.39 |
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
HDCAPTURE | 424,814 | 118 | 6.14 | 1.00 | 470,187 | 130 | 20,480 | 0.80 |
GPS | 77,918 | 22 | 7.50 | 1.00 | 84,383 | 23 | 0 | 0.00 |
SYSTEM | 15,733 | 4 | 0.53 | 113.90 | 249 | 0 | 48 | 0.00 |
JKDB_SG | 495 | 0 | 7.21 | 36.31 | 2,100 | 1 | 4,233 | 1.02 |
UNDOTBS1 | 1 | 0 | 0.00 | 1.00 | 2,491 | 1 | 180 | 0.11 |
SYSAUX | 299 | 0 | 5.52 | 1.09 | 1,375 | 0 | 0 | 0.00 |
TEMP | 1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
USERS | 1 | 0 | 0.00 | 1.00 | 1 | 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) |
---|---|---|---|---|---|---|---|---|---|
GPS | E:\JKDB\GPS | 11,264 | 3 | 7.45 | 1.00 | 12,294 | 3 | 0 | 0.00 |
GPS | E:\JKDB\GPS1 | 16,400 | 5 | 7.54 | 1.00 | 17,709 | 5 | 0 | 0.00 |
GPS | E:\JKDB\GPS2 | 26,449 | 7 | 7.03 | 1.00 | 28,483 | 8 | 0 | 0.00 |
GPS | E:\JKDB\GPS3 | 23,805 | 7 | 8.01 | 1.00 | 25,897 | 7 | 0 | 0.00 |
HDCAPTURE | E:\JKDB\HDCAPTURE | 84,300 | 23 | 7.02 | 1.00 | 109,864 | 30 | 4 | 7.50 |
HDCAPTURE | E:\JKDB\HDCAPTURE1 | 61,164 | 17 | 5.84 | 1.00 | 64,725 | 18 | 143 | 0.14 |
HDCAPTURE | E:\JKDB\HDCAPTURE2 | 74,141 | 21 | 5.11 | 1.00 | 66,607 | 18 | 5,280 | 0.78 |
HDCAPTURE | E:\JKDB\HDCAPTURE3 | 75,962 | 21 | 5.38 | 1.00 | 71,572 | 20 | 10,062 | 0.79 |
HDCAPTURE | E:\JKDB\HDCAPTURE4 | 65,056 | 18 | 5.71 | 1.00 | 63,515 | 18 | 4,959 | 0.87 |
HDCAPTURE | E:\JKDB\HDCAPTURE5 | 34,319 | 9 | 7.54 | 1.00 | 50,207 | 14 | 0 | 0.00 |
HDCAPTURE | E:\JKDB\HDCAPTURE6 | 29,872 | 8 | 8.05 | 1.00 | 43,697 | 12 | 32 | 0.00 |
JKDB_SG | E:\JKDB\JKDB_SG | 286 | 0 | 7.34 | 40.94 | 1,415 | 0 | 3,604 | 1.04 |
JKDB_SG | E:\JKDB\JKDB_SG1 | 209 | 0 | 7.03 | 29.98 | 685 | 0 | 629 | 0.89 |
SYSAUX | E:\JKDB\SYSAUX01.DBF | 299 | 0 | 5.52 | 1.09 | 1,375 | 0 | 0 | 0.00 |
SYSTEM | E:\JKDB\SYSTEM01.DBF | 15,733 | 4 | 0.53 | 113.90 | 249 | 0 | 48 | 0.00 |
TEMP | E:\JKDB\TEMP01.DBF | 1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | |
UNDOTBS1 | E:\JKDB\UNDOTBS01.DBF | 1 | 0 | 0.00 | 1.00 | 2,491 | 1 | 180 | 0.11 |
USERS | E:\JKDB\USERS01.DBF | 1 | 0 | 0.00 | 1.00 | 1 | 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 | 2,294,325 | 100 | 232,033,207 | 523,532 | 609,541 | 0 | 0 | 24,939 |
MTTR Writes | Log Size Writes | Log Ckpt Writes | Other Settings Writes | Autotune Ckpt Writes | Thread Ckpt Writes |
---|---|---|---|---|---|
0 | 0 | 0 | 0 | 608,733 | 0 |
Targt MTTR (s) | Estd MTTR (s) | Recovery Estd IOs | Actual RedoBlks | Target RedoBlks | Log Sz RedoBlks | Log Ckpt Timeout RedoBlks | Log Ckpt Interval RedoBlks | Opt Log Sz(M) | Estd RAC Avail Time | |
---|---|---|---|---|---|---|---|---|---|---|
B | 0 | 35 | 51930 | 133907 | 744105 | 8493417 | 744105 | |||
E | 0 | 36 | 55208 | 147321 | 810050 | 8493417 | 810050 |
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 | 1,856 | 0.10 | 229 | 97.86 | 6,502,886 | 1 | 43576708.00 |
D | 3,712 | 0.20 | 458 | 97.49 | 6,477,959 | 1 | 43408656.00 |
D | 5,568 | 0.30 | 686 | 97.24 | 6,461,562 | 1 | 43298120.00 |
D | 7,424 | 0.40 | 915 | 97.05 | 6,448,763 | 1 | 43211841.00 |
D | 9,280 | 0.50 | 1,144 | 5.06 | 336,461 | 1 | 2006001.00 |
D | 11,136 | 0.60 | 1,373 | 1.18 | 78,348 | 1 | 265940.00 |
D | 12,992 | 0.70 | 1,601 | 1.09 | 72,749 | 1 | 228195.00 |
D | 14,848 | 0.80 | 1,830 | 1.05 | 69,677 | 1 | 207486.00 |
D | 16,704 | 0.90 | 2,059 | 1.03 | 68,121 | 1 | 196995.00 |
D | 18,560 | 1.00 | 2,288 | 1.00 | 66,514 | 1 | 186163.00 |
D | 18,624 | 1.00 | 2,296 | 1.00 | 66,448 | 1 | 185722.00 |
D | 20,416 | 1.10 | 2,517 | 0.97 | 64,548 | 1 | 172911.00 |
D | 22,272 | 1.20 | 2,745 | 0.96 | 63,600 | 1 | 166518.00 |
D | 24,128 | 1.30 | 2,974 | 0.95 | 62,822 | 1 | 161273.00 |
D | 25,984 | 1.40 | 3,203 | 0.94 | 62,140 | 1 | 156680.00 |
D | 27,840 | 1.49 | 3,432 | 0.93 | 61,497 | 1 | 152345.00 |
D | 29,696 | 1.59 | 3,660 | 0.92 | 60,942 | 1 | 148602.00 |
D | 31,552 | 1.69 | 3,889 | 0.91 | 60,401 | 1 | 144954.00 |
D | 33,408 | 1.79 | 4,118 | 0.90 | 59,914 | 1 | 141670.00 |
D | 35,264 | 1.89 | 4,347 | 0.89 | 59,382 | 1 | 138082.00 |
D | 37,120 | 1.99 | 4,576 | 0.88 | 58,634 | 1 | 133039.00 |
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
100.00 | 3,745 | 0 |
PGA Aggr Target(M) | Auto PGA Target(M) | PGA Mem Alloc(M) | W/A PGA Used(M) | %PGA W/A Mem | %Auto W/A Mem | %Man W/A Mem | Global Mem Bound(K) | |
---|---|---|---|---|---|---|---|---|
B | 13,882 | 12,283 | 401.22 | 0.00 | 0.00 | 0.00 | 0.00 | 1,048,576 |
E | 13,882 | 12,278 | 413.51 | 1.71 | 0.41 | 100.00 | 0.00 | 1,048,576 |
Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
---|---|---|---|---|---|
2K | 4K | 74,469 | 74,469 | 0 | 0 |
64K | 128K | 628 | 628 | 0 | 0 |
128K | 256K | 2 | 2 | 0 | 0 |
256K | 512K | 16 | 16 | 0 | 0 |
512K | 1024K | 3,166 | 3,166 | 0 | 0 |
1M | 2M | 866 | 866 | 0 | 0 |
2M | 4M | 10 | 10 | 0 | 0 |
4M | 8M | 2 | 2 | 0 | 0 |
PGA Target Est (MB) | Size Factr | W/A MB Processed | Estd Extra W/A MB Read/ Written to Disk | Estd PGA Cache Hit % | Estd PGA Overalloc Count | Estd Time |
---|---|---|---|---|---|---|
1,735 | 0.13 | 208,816.12 | 0.00 | 100.00 | 0 | 423,634,093 |
3,471 | 0.25 | 208,816.12 | 0.00 | 100.00 | 0 | 423,634,093 |
6,941 | 0.50 | 208,816.12 | 0.00 | 100.00 | 0 | 423,634,093 |
10,412 | 0.75 | 208,816.12 | 0.00 | 100.00 | 0 | 423,634,093 |
13,882 | 1.00 | 208,816.12 | 0.00 | 100.00 | 0 | 423,634,093 |
16,658 | 1.20 | 208,816.12 | 0.00 | 100.00 | 0 | 423,634,093 |
19,435 | 1.40 | 208,816.12 | 0.00 | 100.00 | 0 | 423,634,093 |
22,211 | 1.60 | 208,816.12 | 0.00 | 100.00 | 0 | 423,634,093 |
24,988 | 1.80 | 208,816.12 | 0.00 | 100.00 | 0 | 423,634,093 |
27,764 | 2.00 | 208,816.12 | 0.00 | 100.00 | 0 | 423,634,093 |
41,646 | 3.00 | 208,816.12 | 0.00 | 100.00 | 0 | 423,634,093 |
55,528 | 4.00 | 208,816.12 | 0.00 | 100.00 | 0 | 423,634,093 |
83,292 | 6.00 | 208,816.12 | 0.00 | 100.00 | 0 | 423,634,093 |
111,056 | 8.00 | 208,816.12 | 0.00 | 100.00 | 0 | 423,634,093 |
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) |
---|---|---|---|---|---|---|---|---|
1,920 | 0.67 | 37 | 3,440 | 2,515,907 | 1.00 | 65,789 | 1.06 | 6,370 |
2,240 | 0.78 | 361 | 31,448 | 2,516,261 | 1.00 | 65,435 | 1.05 | 54,749 |
2,560 | 0.89 | 681 | 47,894 | 2,519,014 | 1.00 | 62,682 | 1.01 | 55,193 |
2,880 | 1.00 | 1,001 | 64,178 | 2,519,520 | 1.00 | 62,176 | 1.00 | 55,275 |
3,200 | 1.11 | 1,320 | 80,448 | 2,519,827 | 1.00 | 61,869 | 1.00 | 55,330 |
3,520 | 1.22 | 1,640 | 96,900 | 2,520,037 | 1.00 | 61,659 | 0.99 | 55,370 |
3,840 | 1.33 | 1,960 | 114,055 | 2,520,192 | 1.00 | 61,504 | 0.99 | 55,398 |
4,160 | 1.44 | 2,279 | 130,367 | 2,520,302 | 1.00 | 61,394 | 0.99 | 55,421 |
4,480 | 1.56 | 2,599 | 147,228 | 2,520,392 | 1.00 | 61,304 | 0.99 | 55,439 |
4,800 | 1.67 | 2,919 | 163,829 | 2,520,451 | 1.00 | 61,245 | 0.99 | 55,451 |
5,120 | 1.78 | 3,239 | 180,440 | 2,520,507 | 1.00 | 61,189 | 0.98 | 55,463 |
5,440 | 1.89 | 3,558 | 196,962 | 2,520,553 | 1.00 | 61,143 | 0.98 | 55,473 |
5,760 | 2.00 | 3,878 | 213,549 | 2,520,604 | 1.00 | 61,092 | 0.98 | 55,482 |
SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
---|---|---|---|
5,536 | 0.25 | 44,717,848 | 6,693,282,980 |
8,304 | 0.38 | 44,435,040 | 6,650,751,880 |
11,072 | 0.50 | 44,346,195 | 6,637,575,943 |
13,840 | 0.63 | 620,073 | 80,650,289 |
16,608 | 0.75 | 564,241 | 71,726,798 |
19,376 | 0.88 | 549,913 | 70,118,842 |
22,144 | 1.00 | 528,711 | 66,444,463 |
24,912 | 1.13 | 518,561 | 65,467,729 |
27,680 | 1.25 | 509,361 | 63,966,085 |
30,448 | 1.38 | 503,915 | 63,301,640 |
33,216 | 1.50 | 497,412 | 62,178,728 |
35,984 | 1.63 | 492,865 | 61,673,751 |
38,752 | 1.75 | 484,776 | 60,358,150 |
41,520 | 1.88 | 483,666 | 60,358,150 |
44,288 | 2.00 | 483,666 | 60,358,150 |
Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
---|---|---|---|---|---|
64 | 1.00 | 0 | 0 | 0 | 0 |
128 | 2.00 | 0 | 0 | 0 | 0 |
192 | 3.00 | 0 | 0 | 0 | 0 |
256 | 4.00 | 0 | 0 | 0 | 0 |
320 | 5.00 | 0 | 0 | 0 | 0 |
384 | 6.00 | 0 | 0 | 0 | 0 |
448 | 7.00 | 0 | 0 | 0 | 0 |
512 | 8.00 | 0 | 0 | 0 | 0 |
576 | 9.00 | 0 | 0 | 0 | 0 |
640 | 10.00 | 0 | 0 | 0 | 0 |
704 | 11.00 | 0 | 0 | 0 | 0 |
768 | 12.00 | 0 | 0 | 0 | 0 |
832 | 13.00 | 0 | 0 | 0 | 0 |
896 | 14.00 | 0 | 0 | 0 | 0 |
960 | 15.00 | 0 | 0 | 0 | 0 |
1,024 | 16.00 | 0 | 0 | 0 | 0 |
1,088 | 17.00 | 0 | 0 | 0 | 0 |
1,152 | 18.00 | 0 | 0 | 0 | 0 |
1,216 | 19.00 | 0 | 0 | 0 | 0 |
1,280 | 20.00 | 0 | 0 | 0 | 0 |
Java Pool Size(M) | JP 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 |
---|---|---|---|---|---|---|---|---|
128 | 0.29 | 2 | 96 | 2 | 1.00 | 62,177 | 1.00 | 67 |
192 | 0.43 | 3 | 107 | 2 | 1.00 | 62,177 | 1.00 | 75 |
256 | 0.57 | 3 | 107 | 2 | 1.00 | 62,177 | 1.00 | 75 |
320 | 0.71 | 3 | 107 | 2 | 1.00 | 62,177 | 1.00 | 75 |
384 | 0.86 | 3 | 107 | 2 | 1.00 | 62,177 | 1.00 | 75 |
448 | 1.00 | 3 | 107 | 2 | 1.00 | 62,177 | 1.00 | 75 |
512 | 1.14 | 3 | 107 | 2 | 1.00 | 62,177 | 1.00 | 75 |
576 | 1.29 | 3 | 107 | 2 | 1.00 | 62,177 | 1.00 | 75 |
640 | 1.43 | 3 | 107 | 2 | 1.00 | 62,177 | 1.00 | 75 |
704 | 1.57 | 3 | 107 | 2 | 1.00 | 62,177 | 1.00 | 75 |
768 | 1.71 | 3 | 107 | 2 | 1.00 | 62,177 | 1.00 | 75 |
832 | 1.86 | 3 | 107 | 2 | 1.00 | 62,177 | 1.00 | 75 |
896 | 2.00 | 3 | 107 | 2 | 1.00 | 62,177 | 1.00 | 75 |
960 | 2.14 | 3 | 107 | 2 | 1.00 | 62,177 | 1.00 | 75 |
Class | Waits | Total Wait Time (s) | Avg Time (ms) |
---|---|---|---|
data block | 24,758 | 21 | 1 |
undo header | 179 | 0 | 0 |
1st level bmb | 1 | 0 | 0 |
undo block | 1 | 0 | 0 |
Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
---|---|---|---|---|---|---|
TX-Transaction (row lock contention) | 793 | 793 | 0 | 793 | 0 | 0.37 |
KO-Multiple Object Checkpoint (fast object checkpoint) | 18 | 18 | 0 | 2 | 0 | 23.50 |
TX-Transaction (index contention) | 63 | 63 | 0 | 21 | 0 | 0.00 |
HW-Segment High Water Mark | 382 | 382 | 0 | 12 | 0 | 0.00 |
Undo TS# | Num Undo Blocks (K) | Number of Transactions | Max Qry Len (s) | Max Tx Concurcy | Min/Max TR (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
---|---|---|---|---|---|---|---|
2 | 31.75 | 373,943 | 1,258 | 10 | 6943.9/6972.9 | 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 |
---|---|---|---|---|---|---|---|
24-9月 09:51 | 5,720 | 69,152 | 96 | 8 | 6,944 | 0/0 | 0/0/0/0/0/0 |
24-9月 09:41 | 5,173 | 60,321 | 662 | 10 | 6,951 | 0/0 | 0/0/0/0/0/0 |
24-9月 09:31 | 5,437 | 65,588 | 1,258 | 9 | 6,956 | 0/0 | 0/0/0/0/0/0 |
24-9月 09:21 | 5,280 | 61,580 | 650 | 8 | 6,962 | 0/0 | 0/0/0/0/0/0 |
24-9月 09:11 | 5,167 | 60,593 | 1,247 | 7 | 6,968 | 0/0 | 0/0/0/0/0/0 |
24-9月 09:01 | 4,968 | 56,709 | 639 | 8 | 6,973 | 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 | 186 | 0.00 | 0 | 0 | ||
AQ deq log cmt cbk chunk latch | 12 | 0.00 | 0 | 0 | ||
AQ deq log statistics latch | 5 | 0.00 | 0 | 0 | ||
AQ dequeue txn counter latch | 3,148 | 0.00 | 0 | 0 | ||
AQ ht cmt cbk chunk latch | 22 | 0.00 | 0 | 0 | ||
ASM db client latch | 2,408 | 0.00 | 0 | 0 | ||
ASM map operation hash table | 1 | 0.00 | 0 | 0 | ||
ASM network state latch | 70 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 33,671 | 0.00 | 0 | 0 | ||
Change Notification Hash table latch | 1,202 | 0.00 | 0 | 0 | ||
Consistent RBA | 352,242 | 0.00 | 0.00 | 0 | 0 | |
DML lock allocation | 2,126,288 | 0.00 | 0.00 | 0 | 0 | |
Event Group Locks | 921 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 3,566 | 0.03 | 0.00 | 0 | 0 | |
File State Object Pool Parent Latch | 1 | 0.00 | 0 | 0 | ||
IPC stats buffer allocation latch | 1 | 0.00 | 0 | 0 | ||
In memory undo latch | 2,568,673 | 0.13 | 0.22 | 0 | 379,627 | 0.00 |
JS Sh mem access | 7 | 0.00 | 0 | 0 | ||
JS mem alloc latch | 6 | 0.00 | 0 | 0 | ||
JS queue access latch | 7 | 0.00 | 0 | 0 | ||
JS queue state obj latch | 26,170 | 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,200 | 0.00 | 0 | 0 | ||
KTF sga latch | 18 | 0.00 | 0 | 1,204 | 0.00 | |
KWQMN job cache list latch | 49 | 0.00 | 0 | 0 | ||
KWQP Prop Status | 2 | 0.00 | 0 | 0 | ||
KWQS pqsubs latch | 16 | 0.00 | 0 | 0 | ||
KWQS pqueue ctx latch | 122 | 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 | 71 | 0.00 | ||
Memory Management Latch | 1 | 0.00 | 0 | 1,200 | 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 | 19 | 0.00 | 0 | 0 | ||
Mutex | 1 | 0.00 | 0 | 0 | ||
Mutex Stats | 1 | 0.00 | 0 | 0 | ||
OS process | 3,574 | 0.00 | 0 | 0 | ||
OS process allocation | 3,586 | 0.00 | 0 | 0 | ||
OS process: request allocation | 1,837 | 0.05 | 0.00 | 0 | 0 | |
PL/SQL warning settings | 118,233 | 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 | 30,443 | 0.00 | 0 | 0 | ||
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 | 1 | 0.00 | 0 | 1,197 | 0.00 | |
SQL memory manager workarea list latch | 149,458 | 0.00 | 0.00 | 0 | 0 | |
Shared B-Tree | 471 | 0.00 | 0 | 0 | ||
Streams Generic | 1 | 0.00 | 0 | 0 | ||
Testing | 1 | 0.00 | 0 | 0 | ||
Token Manager | 1 | 0.00 | 0 | 0 | ||
WCR: sync | 1 | 0.00 | 0 | 0 | ||
Write State Object Pool Parent Latch | 1 | 0.00 | 0 | 0 | ||
X$KSFQP | 1 | 0.00 | 0 | 0 | ||
XDB NFS Security Latch | 1 | 0.00 | 0 | 0 | ||
XDB unused session pool | 1 | 0.00 | 0 | 0 | ||
XDB used session pool | 1 | 0.00 | 0 | 0 | ||
active checkpoint queue latch | 565,243 | 0.28 | 0.01 | 0 | 0 | |
active service list | 12,114 | 0.11 | 0.62 | 0 | 3,816 | 0.00 |
begin backup scn array | 7 | 0.00 | 0 | 0 | ||
buffer pool | 1 | 0.00 | 0 | 0 | ||
business card | 1 | 0.00 | 0 | 0 | ||
cache buffer handles | 14,129 | 0.00 | 0 | 0 | ||
cache buffers chains | 481,060,010 | 0.03 | 0.01 | 0 | 669,498 | 0.00 |
cache buffers lru chain | 919,050 | 0.00 | 0.09 | 0 | 1,341,132 | 0.00 |
cache table scan latch | 245 | 0.00 | 0 | 245 | 0.00 | |
call allocation | 38,731 | 0.01 | 0.00 | 0 | 0 | |
cas latch | 1 | 0.00 | 0 | 0 | ||
change notification client cache latch | 1 | 0.00 | 0 | 0 | ||
channel handle pool latch | 1,856 | 0.00 | 0 | 0 | ||
channel operations parent latch | 24,566 | 0.00 | 0.00 | 0 | 0 | |
checkpoint queue latch | 14,591,988 | 0.00 | 0.01 | 0 | 611,651 | 0.00 |
client/application info | 25,023 | 0.00 | 0 | 0 | ||
compile environment latch | 1,019 | 0.00 | 0 | 0 | ||
constraint object allocation | 1,112 | 0.00 | 0 | 0 | ||
corrupted undo seg latch | 6,162 | 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 | 70 | 0.00 | 0 | 0 | ||
cvmap freelist lock | 1 | 0.00 | 0 | 0 | ||
deferred cleanup latch | 70 | 0.00 | 0 | 0 | ||
dml lock allocation | 70 | 0.00 | 0 | 0 | ||
done queue latch | 1 | 0.00 | 0 | 0 | ||
dummy allocation | 2,036 | 0.00 | 0 | 0 | ||
enqueue hash chains | 2,763,521 | 0.03 | 0.00 | 0 | 0 | |
enqueues | 474,516 | 0.04 | 0.02 | 0 | 0 | |
fifth spare latch | 1 | 0.00 | 0 | 0 | ||
file cache latch | 223 | 0.00 | 0 | 0 | ||
flashback copy | 1 | 0.00 | 0 | 0 | ||
gc element | 1 | 0.00 | 0 | 0 | ||
gcs commit scn state | 1 | 0.00 | 0 | 0 | ||
gcs partitioned table hash | 1 | 0.00 | 0 | 0 | ||
gcs pcm hashed value bucket hash | 1 | 0.00 | 0 | 0 | ||
gcs resource freelist | 1 | 0.00 | 0 | 0 | ||
gcs resource hash | 1 | 0.00 | 0 | 0 | ||
gcs resource scan list | 1 | 0.00 | 0 | 0 | ||
gcs shadows freelist | 1 | 0.00 | 0 | 0 | ||
ges domain table | 1 | 0.00 | 0 | 0 | ||
ges enqueue table freelist | 1 | 0.00 | 0 | 0 | ||
ges group table | 1 | 0.00 | 0 | 0 | ||
ges process hash list | 1 | 0.00 | 0 | 0 | ||
ges process parent latch | 1 | 0.00 | 0 | 0 | ||
ges resource hash list | 1 | 0.00 | 0 | 0 | ||
ges resource scan list | 1 | 0.00 | 0 | 0 | ||
ges resource table freelist | 1 | 0.00 | 0 | 0 | ||
ges value block free list | 1 | 0.00 | 0 | 0 | ||
global KZLD latch for mem in SGA | 735 | 0.00 | 0 | 0 | ||
global ctx hash table latch | 1 | 0.00 | 0 | 0 | ||
global tx hash mapping | 6,997 | 0.00 | 0 | 0 | ||
granule operation | 1 | 0.00 | 0 | 0 | ||
hash table column usage latch | 1,036 | 0.00 | 0 | 23,063,905 | 0.13 | |
hash table modification latch | 114 | 0.00 | 0 | 0 | ||
heartbeat check | 1 | 0.00 | 0 | 0 | ||
instance information | 2,892 | 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 | 100 | 0.00 | 0 | 99 | 1.01 | |
job_queue_processes free list latch | 202 | 0.00 | 0 | 0 | ||
job_queue_processes parameter latch | 883 | 0.00 | 0 | 0 | ||
k2q lock allocation | 1 | 0.00 | 0 | 0 | ||
kcbtsemkid latch | 1 | 0.00 | 0 | 0 | ||
kdlx hb parent latch | 1 | 0.00 | 0 | 0 | ||
kgb parent | 1 | 0.00 | 0 | 0 | ||
kks stats | 991,022 | 0.02 | 0.06 | 0 | 0 | |
kokc descriptor allocation latch | 1,130 | 0.00 | 0 | 0 | ||
ksfv messages | 1 | 0.00 | 0 | 0 | ||
kss move lock | 31 | 0.00 | 0 | 0 | ||
ksuosstats global area | 244 | 0.00 | 0 | 0 | ||
ksv allocation latch | 130 | 0.00 | 0 | 0 | ||
ksv class latch | 61 | 0.00 | 0 | 0 | ||
ksv msg queue latch | 1 | 0.00 | 0 | 0 | ||
ksz_so allocation latch | 1,837 | 0.05 | 0.00 | 0 | 0 | |
ktm global data | 22 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 191 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 352,811 | 0.04 | 0.00 | 0 | 0 | |
list of block allocation | 4,116 | 0.00 | 0 | 0 | ||
loader state object freelist | 64 | 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 | 3 | 0.00 | 0 | 2 | 0.00 | |
mapped buffers lru chain | 1 | 0.00 | 0 | 0 | ||
message pool operations parent latch | 153 | 0.00 | 0 | 0 | ||
messages | 2,252,416 | 0.86 | 0.00 | 0 | 0 | |
mostly latch-free SCN | 353,642 | 0.23 | 0.01 | 0 | 0 | |
msg queue latch | 1 | 0.00 | 0 | 0 | ||
multiblock read objects | 1,022 | 0.00 | 0 | 0 | ||
name-service namespace bucket | 1 | 0.00 | 0 | 0 | ||
ncodef allocation latch | 70 | 0.00 | 0 | 0 | ||
object queue header heap | 1,106 | 0.00 | 0 | 815 | 0.00 | |
object queue header operation | 3,095,757 | 0.00 | 0.00 | 0 | 0 | |
object stats modification | 36 | 0.00 | 0 | 0 | ||
parallel query alloc buffer | 481 | 0.00 | 0 | 0 | ||
parallel query stats | 1 | 0.00 | 0 | 0 | ||
parameter list | 7,178 | 0.00 | 0 | 0 | ||
parameter table management | 3,166 | 0.00 | 0 | 0 | ||
peshm | 1 | 0.00 | 0 | 0 | ||
pesom_free_list | 1 | 0.00 | 0 | 0 | ||
pesom_hash_node | 1 | 0.00 | 0 | 0 | ||
policy information | 15,183 | 0.01 | 0.00 | 0 | 0 | |
post/wait queue | 550,247 | 0.00 | 0.00 | 0 | 377,886 | 0.02 |
process allocation | 1,974 | 0.05 | 0.00 | 0 | 920 | 0.00 |
process group creation | 1,837 | 0.00 | 0 | 0 | ||
process queue | 1 | 0.00 | 0 | 0 | ||
process queue reference | 1 | 0.00 | 0 | 0 | ||
qmn task queue latch | 528 | 0.38 | 0.50 | 0 | 0 | |
query server freelists | 1 | 0.00 | 0 | 0 | ||
queued dump request | 12 | 0.00 | 0 | 0 | ||
queuing load statistics | 1 | 0.00 | 0 | 0 | ||
recovery domain hash list | 1 | 0.00 | 0 | 0 | ||
redo allocation | 1,825,646 | 0.04 | 0.00 | 0 | 1,484,682 | 0.37 |
redo copy | 1 | 0.00 | 0 | 1,486,461 | 0.12 | |
redo writing | 1,631,631 | 0.08 | 0.01 | 0 | 0 | |
resmgr group change latch | 1,888 | 0.00 | 0 | 0 | ||
resmgr:active threads | 2,036 | 0.00 | 0 | 0 | ||
resmgr:actses change group | 845 | 0.00 | 0 | 0 | ||
resmgr:actses change state | 1 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 2,035 | 0.10 | 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 | 31 | 0.00 | 0 | 0 | ||
resmgr:session queuing | 1 | 0.00 | 0 | 0 | ||
rm cas latch | 1 | 0.00 | 0 | 0 | ||
row cache objects | 54,096,755 | 0.93 | 0.00 | 1 | 28,608 | 0.01 |
rules engine aggregate statistics | 6 | 0.00 | 0 | 0 | ||
rules engine rule set statistics | 112 | 0.00 | 0 | 0 | ||
second spare latch | 1 | 0.00 | 0 | 0 | ||
sequence cache | 3,315 | 0.00 | 0 | 0 | ||
session allocation | 58,459 | 0.00 | 0.00 | 0 | 19,488 | 0.00 |
session idle bit | 2,434,133 | 0.00 | 0.03 | 0 | 0 | |
session queue latch | 1 | 0.00 | 0 | 0 | ||
session state list latch | 3,417 | 0.20 | 0.00 | 0 | 0 | |
session switching | 4,656 | 0.02 | 0.00 | 0 | 0 | |
session timer | 1,483 | 0.00 | 0 | 0 | ||
shared pool | 8,829,262 | 0.04 | 0.15 | 0 | 0 | |
shared pool sim alloc | 1 | 0.00 | 0 | 0 | ||
shared pool simulator | 1,525,955 | 0.01 | 0.58 | 0 | 0 | |
sim partition latch | 1 | 0.00 | 0 | 0 | ||
simulator hash latch | 14,789,133 | 0.00 | 0.00 | 0 | 0 | |
simulator lru latch | 40,511 | 0.02 | 0.00 | 0 | 14,696,162 | 0.06 |
sort extent pool | 118 | 0.00 | 0 | 0 | ||
space background state object latch | 8 | 0.00 | 0 | 0 | ||
space background task latch | 2,660 | 0.15 | 0.00 | 0 | 2,400 | 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 | 4 | 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 | 162 | 0.00 | 0 | 0 | ||
transaction allocation | 162,175 | 0.00 | 0 | 0 | ||
transaction branch allocation | 9,125 | 0.01 | 0.00 | 0 | 0 | |
undo global data | 2,009,768 | 0.00 | 0.00 | 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 |
---|---|---|---|---|
row cache objects | 54,096,755 | 501,929 | 2,111 | 500,171 |
cache buffers chains | 481,060,010 | 138,226 | 1,232 | 136,998 |
messages | 2,252,416 | 19,353 | 29 | 19,324 |
shared pool | 8,829,262 | 3,838 | 566 | 3,279 |
In memory undo latch | 2,568,673 | 3,416 | 750 | 2,667 |
active checkpoint queue latch | 565,243 | 1,577 | 15 | 1,562 |
redo writing | 1,631,631 | 1,224 | 14 | 1,210 |
mostly latch-free SCN | 353,642 | 807 | 5 | 802 |
enqueue hash chains | 2,763,521 | 728 | 3 | 725 |
redo allocation | 1,825,646 | 715 | 3 | 712 |
enqueues | 474,516 | 196 | 3 | 193 |
kks stats | 991,022 | 159 | 9 | 150 |
checkpoint queue latch | 14,591,988 | 101 | 1 | 100 |
shared pool simulator | 1,525,955 | 85 | 49 | 37 |
session idle bit | 2,434,133 | 39 | 1 | 38 |
cache buffers lru chain | 919,050 | 33 | 3 | 30 |
active service list | 12,114 | 13 | 8 | 6 |
qmn task queue latch | 528 | 2 | 1 | 1 |
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
In memory undo latch | kticmt: child | 0 | 669 | 79 |
In memory undo latch | ktiFlush: child | 0 | 148 | 587 |
In memory undo latch | ktichg: child | 0 | 2 | 66 |
active checkpoint queue latch | kcbbacq: scan active checkpoints | 0 | 15 | 15 |
active service list | kswslogon: session logout | 0 | 8 | 6 |
active service list | kswsite: service iterator | 0 | 1 | 0 |
cache buffers chains | kcbgtcr: fast path (cr pin) | 0 | 970 | 1,251 |
cache buffers chains | kcbgtcr_2 | 0 | 294 | 43 |
cache buffers chains | kcbgcur_2 | 0 | 234 | 194 |
cache buffers chains | kcbrls_1 | 0 | 6 | 15 |
cache buffers chains | kcbchg1: kslbegin: bufs not pinned | 0 | 5 | 1 |
cache buffers chains | kcbgcur: fast path (shr) | 0 | 3 | 2 |
cache buffers chains | kcbrls_2 | 0 | 3 | 2 |
cache buffers chains | kcbzwb | 0 | 3 | 2 |
cache buffers chains | kcbget: exchange | 0 | 2 | 4 |
cache buffers chains | kcbget: pin buffer | 0 | 2 | 0 |
cache buffers chains | kcbgtcr: fast path | 0 | 2 | 0 |
cache buffers chains | kcbgtcr: kslbegin excl | 0 | 1 | 3 |
cache buffers chains | kcbnlc | 0 | 1 | 0 |
cache buffers lru chain | kcbzgws | 0 | 3 | 0 |
checkpoint queue latch | kcbklbc_cql | 0 | 1 | 0 |
enqueue hash chains | ksqgtl3 | 0 | 2 | 3 |
enqueue hash chains | ksqrcl | 0 | 1 | 0 |
enqueues | ksqgel: create enqueue | 0 | 2 | 2 |
enqueues | ksqdel | 0 | 1 | 1 |
kks stats | kksAllocChildStat | 0 | 9 | 9 |
lgwr LWN SCN | kcs023 | 0 | 3 | 0 |
messages | ksarcv | 0 | 25 | 7 |
messages | ksaamb: after wakeup | 0 | 4 | 22 |
mostly latch-free SCN | kcslcu3 | 0 | 2 | 5 |
qmn task queue latch | kwqmnmvtsks: delay to ready list | 0 | 1 | 0 |
redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 3 | 0 |
redo writing | kcrfwcr | 0 | 14 | 14 |
row cache objects | kqrpre: find obj | 0 | 807 | 1,171 |
row cache objects | kqreqd: reget | 0 | 755 | 282 |
row cache objects | kqreqd | 0 | 488 | 558 |
row cache objects | kqrso | 0 | 50 | 32 |
row cache objects | kqrget | 0 | 7 | 49 |
row cache objects | kqrget3 | 0 | 4 | 5 |
session idle bit | ksupuc: clear busy | 0 | 1 | 1 |
shared pool | kghalo | 0 | 336 | 231 |
shared pool | kghupr1 | 0 | 187 | 167 |
shared pool | kghalp | 0 | 17 | 93 |
shared pool | kghfre | 0 | 17 | 49 |
shared pool | kgh_heap_sizes | 0 | 4 | 22 |
shared pool | kgh_next_free | 0 | 4 | 0 |
shared pool | kghfru | 0 | 1 | 0 |
shared pool simulator | kglsim_unpin_simhp | 0 | 45 | 10 |
shared pool simulator | kglsim_scan_lru: scan | 0 | 3 | 25 |
shared pool simulator | kglsim_chg_simhp_free | 0 | 1 | 4 |
Mutex Type | Location | Sleeps | Wait Time (ms) |
---|---|---|---|
hash table | kkshGetNextChild [KKSHBKLOC1] | 9,902,048 | 0 |
Cursor Parent | kkscsPruneChild [KKSPRTLOC35] | 22,773 | 0 |
Cursor Pin | kkslce [KKSCHLPIN2] | 6,293 | 6 |
hash table | kkshhcins [KKSHBKLOC3] | 1,306 | 0 |
hash table | kkshListChanged [KKSHBKLOC10] | 1,019 | 0 |
Library Cache | kglhdgn2 106 | 374 | 0 |
Library Cache | kgllkal3 82 | 217 | 0 |
hash table | kkshhcdel [KKSHBKLOC4] | 81 | 0 |
Library Cache | kglpndl1 95 | 16 | 0 |
Library Cache | kglobpn1 71 | 13 | -0 |
Library Cache | kglpin1 4 | 9 | 0 |
Library Cache | kglpnal1 90 | 6 | -0 |
Library Cache | kglrfcl1 79 | 5 | -0 |
Library Cache | kgllkdl1 85 | 4 | -0 |
Library Cache | kglIsOwnerVersionable 121 | 3 | 0 |
Cursor Pin | kksfbc [KKSCHLFSP2] | 3 | 0 |
Library Cache | kgldtin1 42 | 2 | 0 |
Library Cache | kglhdgn1 62 | 2 | -0 |
Library Cache | kglget2 2 | 1 | -0 |
Library Cache | kgllkc1 57 | 1 | -0 |
Cursor Stat | kkocsStoreBindAwareStats [KKSSTALOC8] | 1 | 0 |
Cursor Pin | kksLockDelete [KKSCHLPIN6] | 1 | 0 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
---|---|---|---|---|---|---|
HDCAPTURE | HDCAPTURE | IDX_CAPTURELIST_OPTIME | INDEX | 121,587,344 | 52.00 | |
JKDB_SG | JKDB_SG | DEVICESTATUS | TABLE | 66,582,016 | 28.47 | |
JKDB_SG | JKDB_SG | HDPHOTOS | TABLE | 17,602,800 | 7.53 | |
HDCAPTURE | HDCAPTURE | CAPTURELIST | TABLE | 7,753,072 | 3.32 | |
JKDB_SG | JKDB_SG | MLOG$_CURDEVICESTATUS1 | TABLE | 6,510,784 | 2.78 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
SYSTEM | SYSTEM | AUD$ | TABLE | 1,789,454 | 77.36 | |
HDCAPTURE | HDCAPTURE | PK_CAPTURELIST | INDEX | 236,350 | 10.22 | |
GPS | GPS | SYS_C0024700 | INDEX | 77,921 | 3.37 | |
HDCAPTURE | HDCAPTURE | CAPTURELIST | TABLE | 70,138 | 3.03 | |
HDCAPTURE | HDCAPTURE | IDX_CAPTURELIST_VEHPLATE | INDEX | 61,948 | 2.68 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Read Requests | %Total |
---|---|---|---|---|---|---|
HDCAPTURE | HDCAPTURE | PK_CAPTURELIST | INDEX | 236,353 | 45.51 | |
GPS | GPS | SYS_C0024700 | INDEX | 77,921 | 15.00 | |
HDCAPTURE | HDCAPTURE | CAPTURELIST | TABLE | 70,138 | 13.51 | |
HDCAPTURE | HDCAPTURE | IDX_CAPTURELIST_VEHPLATE | INDEX | 61,948 | 11.93 | |
HDCAPTURE | HDCAPTURE | IDX_CAPTURELIST_OPTIME | INDEX | 54,305 | 10.46 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | UnOptimized Reads | %Total |
---|---|---|---|---|---|---|
HDCAPTURE | HDCAPTURE | PK_CAPTURELIST | INDEX | 236,353 | 45.51 | |
GPS | GPS | SYS_C0024700 | INDEX | 77,921 | 15.00 | |
HDCAPTURE | HDCAPTURE | CAPTURELIST | TABLE | 70,138 | 13.51 | |
HDCAPTURE | HDCAPTURE | IDX_CAPTURELIST_VEHPLATE | INDEX | 61,948 | 11.93 | |
HDCAPTURE | HDCAPTURE | IDX_CAPTURELIST_OPTIME | INDEX | 54,305 | 10.46 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Reads | %Total |
---|---|---|---|---|---|---|
SYSTEM | SYSTEM | AUD$ | TABLE | 1,789,454 | 100.00 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Writes | %Total |
---|---|---|---|---|---|---|
HDCAPTURE | HDCAPTURE | PK_CAPTURELIST | INDEX | 248,013 | 40.68 | |
HDCAPTURE | HDCAPTURE | IDX_CAPTURELIST_VEHPLATE | INDEX | 218,577 | 35.85 | |
GPS | GPS | SYS_C0024700 | INDEX | 86,012 | 14.11 | |
HDCAPTURE | HDCAPTURE | IDX_CAPTURELIST_OPTIME | INDEX | 7,596 | 1.25 | |
HDCAPTURE | HDCAPTURE | CAPTURELIST | TABLE | 5,475 | 0.90 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Write Requests | %Total |
---|---|---|---|---|---|---|
HDCAPTURE | HDCAPTURE | PK_CAPTURELIST | INDEX | 246,472 | 43.97 | |
HDCAPTURE | HDCAPTURE | IDX_CAPTURELIST_VEHPLATE | INDEX | 210,314 | 37.52 | |
GPS | GPS | SYS_C0024700 | INDEX | 84,080 | 15.00 | |
HDCAPTURE | HDCAPTURE | IDX_CAPTURELIST_OPTIME | INDEX | 6,614 | 1.18 | |
HDCAPTURE | HDCAPTURE | CAPTURELIST | TABLE | 4,185 | 0.75 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Writes | %Total |
---|---|---|---|---|---|---|
SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_1477930046_8845 | TABLE PARTITION | 118 | 84.89 |
SYS | SYSAUX | SYS_LOB0000006213C00038$$ | LOB | 3 | 2.16 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Table Scans | %Total |
---|---|---|---|---|---|---|
SYS | SYSTEM | I_SYSAUTH1 | INDEX | 14,807 | 99.46 | |
SYSTEM | SYSTEM | AUD$ | TABLE | 2 | 0.01 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | DB Block Changes | % of Capture |
---|---|---|---|---|---|---|
HDCAPTURE | HDCAPTURE | PK_CAPTURELIST | INDEX | 208,912 | 41.02 | |
HDCAPTURE | HDCAPTURE | IDX_CAPTURELIST_VEHPLATE | INDEX | 166,912 | 32.78 | |
HDCAPTURE | HDCAPTURE | IDX_CAPTURELIST_OPTIME | INDEX | 47,680 | 9.36 | |
HDCAPTURE | HDCAPTURE | CAPTURELIST | TABLE | 25,872 | 5.08 | |
GPS | GPS | SYS_C0024700 | INDEX | 13,808 | 2.71 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
---|---|---|---|---|---|---|
JKDB_SG | JKDB_SG | HDPHOTOS | TABLE | 796 | 92.67 | |
HDCAPTURE | HDCAPTURE | IDX_CAPTURELIST_OPTIME | INDEX | 21 | 2.44 | |
SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY_PK | WRH$_ACTIVE_1477930046_8845 | INDEX PARTITION | 12 | 1.40 |
SYS | SYSAUX | WRH$_EVENT_HISTOGRAM_PK | WRH$_EVENT__1477930046_8845 | INDEX PARTITION | 6 | 0.70 |
GPS | GPS | SYS_C0024700 | INDEX | 4 | 0.47 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | ITL Waits | % of Capture |
---|---|---|---|---|---|---|
HDCAPTURE | HDCAPTURE | idx_systemlog_optime | INDEX | 1 | 100.00 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
---|---|---|---|---|---|---|
JKDB_SG | JKDB_SG | HDPHOTOS | TABLE | 4,233 | 93.84 | |
HDCAPTURE | HDCAPTURE | IDX_CAPTURELIST_OPTIME | INDEX | 197 | 4.37 | |
SYSTEM | SYSTEM | AUD$ | TABLE | 44 | 0.98 | |
HDCAPTURE | HDCAPTURE | CALCVEHFLOW | TABLE | 32 | 0.71 | |
SYS | SYSTEM | I_SLOG1 | INDEX | 4 | 0.09 |
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
---|---|---|---|---|---|---|
dc_awr_control | 67 | 0.00 | 0 | 2 | 1 | |
dc_files | 17 | 100.00 | 0 | 0 | 0 | |
dc_global_oids | 7,592 | 0.26 | 0 | 0 | 71 | |
dc_histogram_data | 2,339,683 | 0.03 | 0 | 0 | 3,584 | |
dc_histogram_defs | 768,149 | 0.38 | 0 | 2 | 3,960 | |
dc_object_grants | 90,766 | 0.06 | 0 | 0 | 1,746 | |
dc_objects | 1,584,844 | 0.02 | 0 | 8 | 5,910 | |
dc_profiles | 835 | 0.00 | 0 | 0 | 1 | |
dc_rollback_segments | 1,880 | 0.00 | 0 | 0 | 48 | |
dc_segments | 1,111,487 | 0.03 | 0 | 7 | 1,411 | |
dc_sequences | 159 | 1.89 | 0 | 159 | 10 | |
dc_table_scns | 12,987 | 0.01 | 0 | 377 | 22 | |
dc_tablespaces | 6,212,675 | 0.00 | 0 | 0 | 9 | |
dc_users | 8,062,271 | 0.00 | 0 | 27 | 156 | |
global database name | 3,236 | 0.00 | 0 | 0 | 1 | |
outstanding_alerts | 42 | 14.29 | 0 | 6 | 6 | |
sch_lj_oids | 5 | 40.00 | 0 | 0 | 9 |
Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
---|---|---|---|---|---|---|
APP CONTEXT | 2,176 | 0.09 | 2,176 | 0.09 | 0 | 0 |
BODY | 6,022 | 0.91 | 14,640 | 0.66 | 39 | 0 |
CLUSTER | 487 | 0.62 | 161 | 1.86 | 0 | 0 |
DBLINK | 1,572 | 0.13 | 0 | 0 | 0 | |
EDITION | 833 | 0.00 | 1,655 | 0.00 | 0 | 0 |
INDEX | 106 | 18.87 | 85 | 23.53 | 0 | 0 |
OBJECT ID | 1 | 100.00 | 0 | 0 | 0 | |
QUEUE | 8,695 | 0.00 | 10,426 | 0.01 | 1 | 0 |
RULESET | 6 | 0.00 | 6 | 0.00 | 0 | 0 |
SCHEMA | 2,033 | 0.00 | 0 | 0 | 0 | |
SQL AREA | 572,322 | 78.97 | 1,717,232 | 31.92 | 47,417 | 8,295 |
SUBSCRIPTION | 7 | 0.00 | 7 | 100.00 | 7 | 0 |
TABLE/PROCEDURE | 534,786 | 0.05 | 1,115,420 | 0.30 | 2,474 | 0 |
TRIGGER | 273,785 | 0.00 | 361,002 | 0.00 | 13 | 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 | 18,624.00 | 18,624.00 | 16,704.00 | 19,008.00 | 0 | SHR/DEF |
KEEP buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
PGA Target | 13,888.00 | 13,888.00 | 13,888.00 | 13,888.00 | 0 | STA/ |
RECYCLE buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
SGA Target | 22,144.00 | 22,144.00 | 22,144.00 | 22,144.00 | 0 | STA/ |
Shared IO Pool | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
java pool | 448.00 | 448.00 | 448.00 | 448.00 | 0 | SHR/DEF |
large pool | 64.00 | 64.00 | 64.00 | 64.00 | 0 | STA/ |
shared pool | 2,816.00 | 2,816.00 | 2,432.00 | 4,736.00 | 0 | GRO/DEF |
streams pool | 64.00 | 64.00 | 64.00 | 64.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 | 263.49 | 1.73 | 1.24 | 9 | 25 | 152 | 152 | |
Freeable | 104.31 | 0.00 | 0.76 | 0.49 | 4 | 138 | 138 | ||
PL/SQL | 27.33 | 11.60 | 0.18 | 0.36 | 2 | 3 | 150 | 150 | |
SQL | 5.35 | 1.11 | 0.04 | 0.05 | 0 | 21 | 135 | 131 | |
E | Other | 271.22 | 1.75 | 1.24 | 9 | 25 | 155 | 155 | |
Freeable | 106.38 | 0.00 | 0.76 | 0.50 | 4 | 140 | 140 | ||
PL/SQL | 27.83 | 12.20 | 0.18 | 0.35 | 2 | 3 | 153 | 153 | |
SQL | 9.85 | 4.43 | 0.07 | 0.21 | 2 | 27 | 139 | 136 |
SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
---|---|---|
Database Buffers | 19,528,679,424 | |
Fixed Size | 2,186,200 | |
Redo Buffers | 28,360,704 | |
Variable Size | 3,556,770,856 |
Pool | Name | Begin MB | End MB | % Diff |
---|---|---|---|---|
java | JOXLE | 6.89 | 6.89 | 0.00 |
java | free memory | 440.85 | 440.85 | 0.00 |
large | PX msg pool | 7.81 | 7.81 | 0.00 |
large | free memory | 56.19 | 56.19 | 0.00 |
shared | ASH buffers | 50.00 | 50.00 | 0.00 |
shared | CCUR | 191.33 | 182.61 | -4.56 |
shared | FileOpenBlock | 33.47 | 33.47 | 0.00 |
shared | KGH: NO ACCESS | 501.39 | 501.39 | 0.00 |
shared | KGLHD | 59.05 | 56.23 | -4.78 |
shared | PCUR | 167.88 | 161.78 | -3.64 |
shared | SQLA | 829.86 | 829.43 | -0.05 |
shared | db_block_hash_buckets | 89.00 | 89.00 | 0.00 |
shared | free memory | 1,044.65 | 1,063.05 | 1.76 |
shared | kglsim heap | 36.15 | 36.15 | 0.00 |
shared | kglsim object batch | 70.58 | 70.58 | 0.00 |
streams | KTG hash buckets | 1.26 | 1.26 | 0.00 |
streams | free memory | 62.73 | 62.73 | -0.00 |
buffer_cache | 18,624.00 | 18,624.00 | 0.00 | |
fixed_sga | 2.08 | 2.08 | 0.00 | |
log_buffer | 27.05 | 27.05 | 0.00 |
Session Type | First Logon | Foreground CPU time(s) | User IO Wait time(s) | SYS IO Wait time(s) |
---|---|---|---|---|
QMON Slaves | 0921 13:32:10 | 0.05 | 0.15 | 0.00 |
QMON Coordinator | 0921 13:32:00 | 0.00 | 0.00 | 0.00 |
Rule | Evals | No-SQL Eval% | SQL Execs | CPU(s) | Ela(s) | Eval /Sec | SQL per Eval | Ela(s) per Eval | CPU(s) per Eval | Reloads |
---|---|---|---|---|---|---|---|---|---|---|
SYS.ALERT_QUE_R | 6 | 0.00 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 |
Queue Name | Enq Msgs | Deq Msgs | %Exp Msgs | %Delay Msgs | Enq Time(s) | Deq Time(s) | %Transf Time | %Eval Time |
---|---|---|---|---|---|---|---|---|
SYS.ALERT_QUE(12343) | 6 | 6 | 100.00 | 0.00 | 0.18 | 3.75 | 0.00 | 0.44 |
SYSMAN.MGMT_NOTIFY_Q(74054) | 0 | 0 | 0.00 | 0.00 | ||||
SYSMAN.MGMT_TASK_Q(73724) | 61 | 61 | 0.00 | 0.00 | 0.11 | 0.08 | 0.00 | 0.00 |
Queue Name | Enqueue Msgs/sec | Dequeue Msgs/sec | Avg Enqueue sec / msg | Avg Dequeue sec / msg |
---|---|---|---|---|
SYS.ALERT_QUE(12343) | 0.00 | 0.00 | 0.03 | 0.62 |
SYSMAN.MGMT_NOTIFY_Q(74054) | 0.00 | 0.00 | ||
SYSMAN.MGMT_TASK_Q(73724) | 0.02 | 0.02 | 0.00 | 0.00 |
Subscriber/Queue | Enqueue Msgs | Dequeue Msgs | Expire Msgs | Enqueue Msgs/sec | Dequeue Msgs/sec | Expire Msgs/sec |
---|---|---|---|---|---|---|
DBSERVER1_1830_JKDB(22)/SYS.ALERT_QUE | 6 | 6 | 0 | 0.00 | 0.00 | 0.00 |
HAE_SUB(1)/SYS.ALERT_QUE | 0 | 0 | 0 |
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,614 | 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,614 | 0.00 | 100.00 | 0 | 0 |
Parameter Name | Begin value | End value (if different) |
---|---|---|
audit_file_dest | D:\APP\ADMINISTRATOR\ADMIN\JKDB\ADUMP | |
audit_trail | DB | |
compatible | 11.2.0.0.0 | |
control_files | E:\JKDB\CONTROL01.CTL, E:\JKDB\CONTROL02.CTL, E:\JKDB\CONTROL03.CTL | |
db_block_size | 8192 | |
db_domain | ||
db_name | JKDB | |
diagnostic_dest | D:\APP\ADMINISTRATOR | |
dispatchers | (PROTOCOL=TCP) (SERVICE=JKDBXDB) | |
job_queue_processes | 1000 | |
nls_language | SIMPLIFIED CHINESE | |
nls_territory | CHINA | |
open_cursors | 300 | |
pga_aggregate_target | 14556332032 | |
processes | 500 | |
remote_login_passwordfile | EXCLUSIVE | |
sec_case_sensitive_logon | FALSE | |
sessions | 800 | |
sga_target | 23219666944 | |
undo_tablespace | UNDOTBS1 |