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: | 4094 | 30-8月 -13 10:00:40 | 687 | .7 |
End Snap: | 4095 | 30-8月 -13 11:00:44 | 704 | .7 |
Elapsed: | 60.07 (mins) | |||
DB Time: | 65.83 (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): | 1.1 | 0.1 | 0.01 | 0.01 |
DB CPU(s): | 1.2 | 0.1 | 0.01 | 0.01 |
Redo size: | 9,367.9 | 866.0 | ||
Logical reads: | 87,015.8 | 8,044.2 | ||
Block changes: | 54.9 | 5.1 | ||
Physical reads: | 36.9 | 3.4 | ||
Physical writes: | 65.9 | 6.1 | ||
User calls: | 168.9 | 15.6 | ||
Parses: | 160.4 | 14.8 | ||
Hard parses: | 16.1 | 1.5 | ||
W/A MB processed: | 6.6 | 0.6 | ||
Logons: | 20.9 | 1.9 | ||
Executes: | 181.5 | 16.8 | ||
Rollbacks: | 1.9 | 0.2 | ||
Transactions: | 10.8 |
Buffer Nowait %: | 100.00 | Redo NoWait %: | 100.00 |
Buffer Hit %: | 99.99 | In-memory Sort %: | 100.00 |
Library Hit %: | 92.71 | Soft Parse %: | 89.96 |
Execute to Parse %: | 11.62 | Latch Hit %: | 99.69 |
Parse CPU to Parse Elapsd %: | 53.73 | % Non-Parse CPU: | 94.53 |
Begin | End | |
---|---|---|
Memory Usage %: | 73.11 | 73.94 |
% SQL with executions>1: | 65.67 | 58.86 |
% Memory for SQL w/exec>1: | 78.93 | 79.96 |
Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
---|---|---|---|---|---|
DB CPU | 4,266 | 108.00 | |||
library cache: mutex X | 45,954 | 570 | 12 | 14.44 | Concurrency |
enq: TX - row lock contention | 99 | 31 | 313 | 0.78 | Application |
SQL*Net message from dblink | 259 | 14 | 53 | 0.35 | Network |
SQL*Net break/reset to client | 60,270 | 9 | 0 | 0.22 | Application |
Load Average Begin | Load Average End | %User | %System | %WIO | %Idle |
---|---|---|---|---|---|
1.22 | 0.87 | 3.7 | 2.0 | 0.0 | 94.3 |
%Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) |
---|---|---|
5.0 | 87.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): | 1,257.5 | 1,291.5 |
% Host Mem used for SGA+PGA: | 18.77 | 18.84 |
Statistic Name | Time (s) | % of DB Time |
---|---|---|
DB CPU | 4,265.52 | 108.00 |
sql execute elapsed time | 2,295.69 | 58.12 |
connection management call elapsed time | 746.02 | 18.89 |
parse time elapsed | 433.96 | 10.99 |
hard parse elapsed time | 213.00 | 5.39 |
failed parse elapsed time | 39.35 | 1.00 |
hard parse (sharing criteria) elapsed time | 18.00 | 0.46 |
PL/SQL execution elapsed time | 5.45 | 0.14 |
sequence load elapsed time | 1.16 | 0.03 |
PL/SQL compilation elapsed time | 0.30 | 0.01 |
repeated bind elapsed time | 0.00 | 0.00 |
DB time | 3,949.70 | |
background elapsed time | 47.69 | |
background cpu time | 20.76 |
Statistic | Value | End Value |
---|---|---|
BUSY_TIME | 492,815 | |
IDLE_TIME | 8,156,220 | |
IOWAIT_TIME | 952 | |
NICE_TIME | 42 | |
SYS_TIME | 173,247 | |
USER_TIME | 316,005 | |
LOAD | 1 | 1 |
RSRC_MGR_CPU_WAIT_TIME | 0 | |
VM_IN_BYTES | 17,408 | |
VM_OUT_BYTES | 0 | |
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 |
---|---|---|---|---|---|---|
30-8月 10:00:40 | 1.22 | |||||
30-8月 11:00:44 | 0.87 | 5.70 | 3.65 | 2.00 | 94.30 | 0.01 |
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %DB time |
---|---|---|---|---|---|
DB CPU | 4,266 | 108.00 | |||
Concurrency | 49,537 | 0 | 574 | 12 | 14.53 |
Application | 60,369 | 0 | 40 | 1 | 1.00 |
Network | 332,931 | 0 | 14 | 0 | 0.37 |
User I/O | 34,247 | 0 | 10 | 0 | 0.24 |
Commit | 27,888 | 0 | 6 | 0 | 0.16 |
Other | 714 | 88 | 0 | 0 | 0.00 |
Configuration | 51 | 0 | 0 | 1 | 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 |
---|---|---|---|---|---|---|
library cache: mutex X | 45,954 | 0 | 570 | 12 | 1.18 | 14.44 |
enq: TX - row lock contention | 99 | 0 | 31 | 313 | 0.00 | 0.78 |
SQL*Net message from dblink | 259 | 0 | 14 | 53 | 0.01 | 0.35 |
SQL*Net break/reset to client | 60,270 | 0 | 9 | 0 | 1.55 | 0.22 |
direct path write temp | 10,004 | 0 | 8 | 1 | 0.26 | 0.21 |
log file sync | 27,888 | 0 | 6 | 0 | 0.72 | 0.16 |
latch: shared pool | 3,038 | 0 | 2 | 1 | 0.08 | 0.06 |
cursor: pin S wait on X | 41 | 0 | 1 | 18 | 0.00 | 0.02 |
db file sequential read | 18,582 | 0 | 1 | 0 | 0.48 | 0.01 |
SQL*Net message to client | 324,861 | 0 | 0 | 0 | 8.33 | 0.01 |
direct path read temp | 4,611 | 0 | 0 | 0 | 0.12 | 0.01 |
Disk file operations I/O | 593 | 0 | 0 | 0 | 0.02 | 0.01 |
SQL*Net more data to client | 7,546 | 0 | 0 | 0 | 0.19 | 0.00 |
kksfbc child completion | 3 | 100 | 0 | 51 | 0.00 | 0.00 |
enq: TX - index contention | 43 | 0 | 0 | 3 | 0.00 | 0.00 |
buffer busy waits | 129 | 0 | 0 | 0 | 0.00 | 0.00 |
enq: SQ - contention | 48 | 0 | 0 | 1 | 0.00 | 0.00 |
read by other session | 226 | 0 | 0 | 0 | 0.01 | 0.00 |
latch: row cache objects | 213 | 0 | 0 | 0 | 0.01 | 0.00 |
enq: TX - contention | 11 | 0 | 0 | 1 | 0.00 | 0.00 |
cursor: pin S | 38 | 0 | 0 | 0 | 0.00 | 0.00 |
latch free | 62 | 0 | 0 | 0 | 0.00 | 0.00 |
row cache lock | 5 | 0 | 0 | 2 | 0.00 | 0.00 |
library cache lock | 4 | 0 | 0 | 2 | 0.00 | 0.00 |
latch: cache buffers chains | 49 | 0 | 0 | 0 | 0.00 | 0.00 |
enq: HW - contention | 3 | 0 | 0 | 1 | 0.00 | 0.00 |
db file scattered read | 231 | 0 | 0 | 0 | 0.01 | 0.00 |
wait list latch free | 3 | 0 | 0 | 1 | 0.00 | 0.00 |
latch: In memory undo latch | 21 | 0 | 0 | 0 | 0.00 | 0.00 |
SQL*Net more data from client | 21 | 0 | 0 | 0 | 0.00 | 0.00 |
SQL*Net message from client | 324,832 | 0 | 1,819,666 | 5602 | 8.33 | |
jobq slave wait | 7,519 | 100 | 3,764 | 501 | 0.19 | |
single-task message | 15 | 0 | 2 | 161 | 0.00 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
---|---|---|---|---|---|---|
latch free | 5,817 | 0 | 51 | 9 | 0.15 | 105.96 |
log file parallel write | 34,245 | 0 | 6 | 0 | 0.88 | 11.96 |
latch: call allocation | 722 | 0 | 3 | 4 | 0.02 | 5.76 |
os thread startup | 138 | 0 | 2 | 18 | 0.00 | 5.23 |
latch: shared pool | 1,520 | 0 | 2 | 1 | 0.04 | 3.89 |
db file async I/O submit | 7,499 | 0 | 1 | 0 | 0.19 | 2.41 |
asynch descriptor resize | 75,097 | 100 | 1 | 0 | 1.93 | 1.69 |
control file parallel write | 1,399 | 0 | 1 | 0 | 0.04 | 1.08 |
Disk file operations I/O | 104 | 0 | 0 | 3 | 0.00 | 0.56 |
SQL*Net message to client | 299,444 | 0 | 0 | 0 | 7.68 | 0.35 |
Log archive I/O | 30 | 0 | 0 | 2 | 0.00 | 0.11 |
db file sequential read | 54 | 0 | 0 | 1 | 0.00 | 0.08 |
control file sequential read | 3,829 | 0 | 0 | 0 | 0.10 | 0.07 |
ADR block file read | 16 | 0 | 0 | 2 | 0.00 | 0.07 |
latch: active service list | 14 | 0 | 0 | 2 | 0.00 | 0.05 |
library cache: mutex X | 2 | 0 | 0 | 11 | 0.00 | 0.05 |
log file sequential read | 35 | 0 | 0 | 0 | 0.00 | 0.02 |
direct path sync | 1 | 0 | 0 | 3 | 0.00 | 0.01 |
LGWR wait for redo copy | 27 | 0 | 0 | 0 | 0.00 | 0.00 |
rdbms ipc message | 54,514 | 37 | 64,817 | 1189 | 1.40 | |
DIAG idle wait | 7,173 | 100 | 7,181 | 1001 | 0.18 | |
Space Manager: slave idle wait | 1,396 | 98 | 6,900 | 4943 | 0.04 | |
Streams AQ: waiting for time management or cleanup tasks | 6 | 67 | 5,872 | 978670 | 0.00 | |
SQL*Net message from client | 374,386 | 0 | 4,781 | 13 | 9.60 | |
pmon timer | 1,207 | 99 | 3,604 | 2986 | 0.03 | |
dispatcher timer | 60 | 100 | 3,600 | 60003 | 0.00 | |
shared server idle wait | 120 | 100 | 3,600 | 30002 | 0.00 | |
Streams AQ: qmn coordinator idle wait | 256 | 50 | 3,585 | 14004 | 0.01 | |
Streams AQ: qmn slave idle wait | 128 | 0 | 3,585 | 28009 | 0.00 | |
smon timer | 16 | 63 | 3,395 | 212182 | 0.00 | |
class slave wait | 20 | 0 | 0 | 0 | 0.00 |
% of Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Total Waits | <1ms | <2ms | <4ms | <8ms | <16ms | <32ms | <=1s | >1s |
ADR block file read | 16 | 56.3 | 6.3 | 6.3 | 31.3 | ||||
ADR block file write | 5 | 100.0 | |||||||
ADR file lock | 6 | 100.0 | |||||||
ARCH wait for archivelog lock | 1 | 100.0 | |||||||
Disk file operations I/O | 697 | 99.6 | .3 | .1 | |||||
LGWR wait for redo copy | 27 | 100.0 | |||||||
Log archive I/O | 30 | 3.3 | 96.7 | ||||||
SQL*Net break/reset to client | 60.3K | 99.9 | .0 | .0 | .0 | .0 | .0 | ||
SQL*Net message from dblink | 259 | 25.5 | 7.3 | 5.0 | 5.4 | 3.1 | .4 | 53.3 | |
SQL*Net message to client | 624.1K | 100.0 | |||||||
SQL*Net message to dblink | 244 | 100.0 | |||||||
SQL*Net more data from client | 21 | 100.0 | |||||||
SQL*Net more data to client | 7546 | 100.0 | |||||||
asynch descriptor resize | 75.7K | 100.0 | |||||||
buffer busy waits | 129 | 93.8 | 6.2 | ||||||
buffer deadlock | 9 | 100.0 | |||||||
control file parallel write | 1399 | 99.9 | .1 | .1 | |||||
control file sequential read | 3841 | 100.0 | |||||||
cursor: pin S | 39 | 94.9 | 2.6 | 2.6 | |||||
cursor: pin S wait on X | 41 | 4.9 | 31.7 | 2.4 | 43.9 | 9.8 | 7.3 | ||
db file async I/O submit | 7499 | 99.9 | .0 | .0 | .0 | ||||
db file scattered read | 215 | 100.0 | |||||||
db file sequential read | 18.4K | 99.7 | .0 | .1 | .2 | .1 | |||
db file single write | 10 | 100.0 | |||||||
direct path read temp | 4611 | 100.0 | |||||||
direct path sync | 1 | 100.0 | |||||||
direct path write | 22 | 100.0 | |||||||
direct path write temp | 10K | 98.3 | .3 | .2 | .4 | .4 | .1 | .2 | |
enq: FB - contention | 1 | 100.0 | |||||||
enq: HW - contention | 3 | 66.7 | 33.3 | ||||||
enq: SQ - contention | 48 | 83.3 | 14.6 | 2.1 | |||||
enq: TX - contention | 11 | 27.3 | 45.5 | 27.3 | |||||
enq: TX - index contention | 43 | 46.5 | 16.3 | 16.3 | 9.3 | 11.6 | |||
enq: TX - row lock contention | 99 | 1.0 | 1.0 | 2.0 | 96.0 | ||||
kksfbc child completion | 3 | 100.0 | |||||||
latch free | 5877 | 1.1 | .0 | .0 | 58.5 | 37.9 | 2.4 | .1 | |
latch: In memory undo latch | 22 | 100.0 | |||||||
latch: active service list | 16 | 56.3 | 31.3 | 12.5 | |||||
latch: cache buffers chains | 49 | 100.0 | |||||||
latch: call allocation | 724 | 73.3 | .8 | 2.3 | 3.3 | 8.6 | 11.6 | ||
latch: enqueue hash chains | 3 | 100.0 | |||||||
latch: row cache objects | 213 | 97.7 | 1.9 | .5 | |||||
latch: shared pool | 4559 | 74.0 | 9.3 | 11.2 | 4.5 | .8 | .1 | ||
library cache load lock | 2 | 100.0 | |||||||
library cache lock | 4 | 25.0 | 25.0 | 50.0 | |||||
library cache: mutex X | 45.9K | 31.4 | .4 | .1 | .0 | 47.5 | 11.8 | 8.8 | |
log file parallel write | 34.2K | 99.9 | .0 | .0 | .0 | .0 | .0 | .0 | |
log file sequential read | 35 | 100.0 | |||||||
log file single write | 2 | 100.0 | |||||||
log file sync | 27.9K | 99.7 | .1 | .0 | .1 | .1 | .0 | .0 | |
os thread startup | 138 | 5.1 | 94.9 | ||||||
read by other session | 226 | 98.7 | 1.3 | ||||||
reliable message | 8 | 100.0 | |||||||
row cache lock | 5 | 20.0 | 40.0 | 40.0 | |||||
wait list latch free | 5 | 80.0 | 20.0 | ||||||
DIAG idle wait | 7173 | 100.0 | |||||||
SQL*Net message from client | 699K | 79.9 | .8 | 9.0 | .7 | .3 | .3 | 1.4 | 7.5 |
Space Manager: slave idle wait | 1377 | .3 | .3 | .5 | 98.9 | ||||
Streams AQ: qmn coordinator idle wait | 258 | 50.0 | 50.0 | ||||||
Streams AQ: qmn slave idle wait | 129 | 100.0 | |||||||
Streams AQ: waiting for time management or cleanup tasks | 6 | 33.3 | 33.3 | 33.3 | |||||
class slave wait | 20 | 100.0 | |||||||
dispatcher timer | 60 | 100.0 | |||||||
jobq slave wait | 7519 | .1 | .0 | 99.9 | |||||
pmon timer | 1207 | .1 | .4 | 99.5 | |||||
rdbms ipc message | 54.5K | 4.4 | 1.5 | 2.2 | 4.3 | 8.6 | 10.6 | 46.6 | 21.9 |
shared server idle wait | 120 | 100.0 | |||||||
single-task message | 15 | 33.3 | 66.7 | ||||||
smon timer | 20 | 5.0 | 5.0 | 10.0 | 10.0 | 70.0 |
% of Total Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Waits 64ms to 2s | <32ms | <64ms | <1/8s | <1/4s | <1/2s | <1s | <2s | >=2s |
Disk file operations I/O | 1 | 99.9 | .1 | ||||||
SQL*Net break/reset to client | 10 | 100.0 | .0 | ||||||
SQL*Net message from dblink | 138 | 46.7 | 40.9 | 8.5 | 3.9 | ||||
cursor: pin S wait on X | 3 | 92.7 | 4.9 | 2.4 | |||||
db file async I/O submit | 2 | 100.0 | .0 | .0 | |||||
direct path write temp | 25 | 99.8 | .2 | .1 | .0 | ||||
enq: TX - row lock contention | 95 | 4.0 | 9.1 | 4.0 | 8.1 | 74.7 | |||
kksfbc child completion | 3 | 100.0 | |||||||
latch free | 4 | 99.9 | .1 | ||||||
library cache: mutex X | 4043 | 91.2 | 7.1 | 1.6 | .1 | .0 | |||
log file parallel write | 4 | 100.0 | .0 | .0 | .0 | ||||
log file sync | 6 | 100.0 | .0 | .0 | .0 |
Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) |
---|---|---|---|---|
SYS$USERS | 3,951 | 4,267 | 133 | 313,694 |
SYS$BACKGROUND | 0 | 0 | 0 | 30 |
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 | 34251 | 10 | 49504 | 574 | 0 | 0 | 332942 | 14 |
SYS$BACKGROUND | 191 | 0 | 143 | 3 | 0 | 0 | 0 | 0 |
Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
57.48 | 227,906 | 0.00 | 1.46 | 99.98 | 0.00 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
33.07 | 22,120 | 0.00 | 0.84 | 99.92 | 0.33 | 2rgmdtpdz21yq | BEGIN proc_locationinfo(:1, :2... | |
31.87 | 4 | 7.97 | 0.81 | 81.07 | 27.28 | d8ccpd7xxc1r3 | SELECT * FROM (SELECT DISTINCT... | |
30.93 | 74,913 | 0.00 | 0.78 | 96.89 | 0.00 | 0k8522rmdzg4k | select privilege# from sysauth... | |
30.06 | 14 | 2.15 | 0.76 | 100.01 | 0.00 | bapm596n71ksu | SELECT * FROM (SELECT DISTINCT... | |
27.56 | 13 | 2.12 | 0.70 | 99.95 | 0.00 | 0dvt133hht7z1 | SELECT * FROM (SELECT DISTINCT... | |
24.13 | 74,844 | 0.00 | 0.61 | 102.51 | 0.00 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
18.85 | 74,845 | 0.00 | 0.48 | 93.69 | 0.00 | 459f3z9u4fb3u | select value$ from props$ wher... | |
17.86 | 8 | 2.23 | 0.45 | 99.99 | 0.00 | f864vaafk20d4 | SELECT * FROM (SELECT DISTINCT... | |
15.44 | 6 | 2.57 | 0.39 | 99.95 | 0.00 | 4r4scc3q60nf0 | SELECT * FROM (SELECT DISTINCT... |
CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
57.47 | 227,906 | 0.00 | 1.35 | 57.48 | 99.98 | 0.00 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
33.05 | 22,120 | 0.00 | 0.77 | 33.07 | 99.92 | 0.33 | 2rgmdtpdz21yq | BEGIN proc_locationinfo(:1, :2... | |
30.07 | 14 | 2.15 | 0.70 | 30.06 | 100.01 | 0.00 | bapm596n71ksu | SELECT * FROM (SELECT DISTINCT... | |
29.97 | 74,913 | 0.00 | 0.70 | 30.93 | 96.89 | 0.00 | 0k8522rmdzg4k | select privilege# from sysauth... | |
27.55 | 13 | 2.12 | 0.65 | 27.56 | 99.95 | 0.00 | 0dvt133hht7z1 | SELECT * FROM (SELECT DISTINCT... | |
25.84 | 4 | 6.46 | 0.61 | 31.87 | 81.07 | 27.28 | d8ccpd7xxc1r3 | SELECT * FROM (SELECT DISTINCT... | |
24.73 | 74,844 | 0.00 | 0.58 | 24.13 | 102.51 | 0.00 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
17.86 | 8 | 2.23 | 0.42 | 17.86 | 99.99 | 0.00 | f864vaafk20d4 | SELECT * FROM (SELECT DISTINCT... | |
17.66 | 74,845 | 0.00 | 0.41 | 18.85 | 93.69 | 0.00 | 459f3z9u4fb3u | select value$ from props$ wher... | |
15.43 | 6 | 2.57 | 0.36 | 15.44 | 99.95 | 0.00 | 4r4scc3q60nf0 | SELECT * FROM (SELECT DISTINCT... |
User I/O Time (s) | Executions | UIO per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
8.69 | 4 | 2.17 | 88.06 | 31.87 | 81.07 | 27.28 | d8ccpd7xxc1r3 | SELECT * FROM (SELECT DISTINCT... | |
0.17 | 822 | 0.00 | 1.71 | 0.66 | 46.21 | 25.52 | 167wxs395avun | INSERT INTO SMS_SEND (ID, YWMC... | |
0.16 | 1,287 | 0.00 | 1.59 | 0.59 | 85.82 | 26.44 | d5jz0t3f6r3bd | INSERT INTO SMS_SEND (ID, YWMC... | |
0.11 | 22,120 | 0.00 | 1.12 | 33.07 | 99.92 | 0.33 | 2rgmdtpdz21yq | BEGIN proc_locationinfo(:1, :2... | |
0.11 | 22,121 | 0.00 | 1.12 | 13.75 | 100.67 | 0.80 | 79c9nwfb1cjqq | INSERT INTO T_LOCATION_INFO(F_... | |
0.04 | 150 | 0.00 | 0.42 | 0.13 | 96.91 | 31.87 | 2zfk3ymatx835 | oracle@bogon (TNS V1-V3) | INSERT INTO "SMS_SEND" "A1" ("... |
0.00 | 1,504 | 0.00 | 0.05 | 0.72 | 91.90 | 0.69 | 4m7m0t6fjcs5x | update seq$ set increment$=:2,... | |
0.00 | 1 | 0.00 | 0.01 | 0.19 | 100.17 | 0.69 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
0.00 | 67 | 0.00 | 0.01 | 0.03 | 98.83 | 2.90 | a4rpas1bqxyd0 | INSERT INTO SMS_RECV (ID, TJSJ... | |
0.00 | 91 | 0.00 | 0.00 | 0.04 | 111.03 | 1.19 | 0q3c228dffzgt | INSERT INTO SMS_ORDER (ID, LSH... |
Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
2,107,060 | 227,906 | 9.25 | 0.67 | 57.48 | 100 | 0 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
452,770 | 74,913 | 6.04 | 0.14 | 30.93 | 96.9 | 0 | 0k8522rmdzg4k | select privilege# from sysauth... | |
407,864 | 5 | 81,572.80 | 0.13 | 3.16 | 100 | 0 | aup4fgkmr583a | SELECT V.GUID, V.ZHMC, V.SJHM,... | |
341,741 | 180 | 1,898.56 | 0.11 | 8.28 | 99.9 | 0 | bngd3h7xxyz19 | UPDATE SMS_RECV SET CLZT=1, DQ... | |
341,640 | 180 | 1,898.00 | 0.11 | 6.94 | 100 | 0 | 8cacvv4vp0bbm | UPDATE SMS_RECV SET CLZT=1, DQ... | |
224,533 | 74,845 | 3.00 | 0.07 | 18.85 | 93.7 | 0 | 459f3z9u4fb3u | select value$ from props$ wher... | |
161,562 | 22,120 | 7.30 | 0.05 | 33.07 | 99.9 | .3 | 2rgmdtpdz21yq | BEGIN proc_locationinfo(:1, :2... | |
149,690 | 74,843 | 2.00 | 0.05 | 13.36 | 101.3 | 0 | 5ur69atw3vfhj | select decode(failover_method,... | |
139,455 | 22,121 | 6.30 | 0.04 | 13.75 | 100.7 | .8 | 79c9nwfb1cjqq | INSERT INTO T_LOCATION_INFO(F_... | |
132,816 | 22,136 | 6.00 | 0.04 | 5.87 | 98.7 | 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 |
---|---|---|---|---|---|---|---|---|---|
114,050 | 4 | 28,512.50 | 85.74 | 31.87 | 81.07 | 27.28 | d8ccpd7xxc1r3 | SELECT * FROM (SELECT DISTINCT... | |
138 | 1,287 | 0.11 | 0.10 | 0.59 | 85.82 | 26.44 | d5jz0t3f6r3bd | INSERT INTO SMS_SEND (ID, YWMC... | |
73 | 150 | 0.49 | 0.05 | 0.13 | 96.91 | 31.87 | 2zfk3ymatx835 | oracle@bogon (TNS V1-V3) | INSERT INTO "SMS_SEND" "A1" ("... |
68 | 822 | 0.08 | 0.05 | 0.66 | 46.21 | 25.52 | 167wxs395avun | INSERT INTO SMS_SEND (ID, YWMC... | |
34 | 22,120 | 0.00 | 0.03 | 33.07 | 99.92 | 0.33 | 2rgmdtpdz21yq | BEGIN proc_locationinfo(:1, :2... | |
34 | 22,121 | 0.00 | 0.03 | 13.75 | 100.67 | 0.80 | 79c9nwfb1cjqq | INSERT INTO T_LOCATION_INFO(F_... | |
25 | 1 | 25.00 | 0.02 | 0.19 | 100.17 | 0.69 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
2 | 67 | 0.03 | 0.00 | 0.03 | 98.83 | 2.90 | a4rpas1bqxyd0 | INSERT INTO SMS_RECV (ID, TJSJ... | |
1 | 5 | 0.20 | 0.00 | 3.16 | 99.95 | 0.00 | aup4fgkmr583a | SELECT V.GUID, V.ZHMC, V.SJHM,... | |
0 | 1 | 0.00 | 0.00 | 0.00 | 649.35 | 0.00 | 05sghzkq6r6yv | select ts#, file#, block#, col... |
UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
4,611 | 4,611 | 4 | 1,152.75 | 0.00 | 19.75 | d8ccpd7xxc1r3 | SELECT * FROM (SELECT DISTINCT... | |
138 | 138 | 1,287 | 0.11 | 0.00 | 0.59 | d5jz0t3f6r3bd | INSERT INTO SMS_SEND (ID, YWMC... | |
73 | 73 | 150 | 0.49 | 0.00 | 0.31 | 2zfk3ymatx835 | oracle@bogon (TNS V1-V3) | INSERT INTO "SMS_SEND" "A1" ("... |
34 | 34 | 22,120 | 0.00 | 0.00 | 0.15 | 2rgmdtpdz21yq | BEGIN proc_locationinfo(:1, :2... | |
34 | 34 | 22,121 | 0.00 | 0.00 | 0.15 | 79c9nwfb1cjqq | INSERT INTO T_LOCATION_INFO(F_... | |
2 | 2 | 67 | 0.03 | 0.00 | 0.01 | a4rpas1bqxyd0 | INSERT INTO SMS_RECV (ID, TJSJ... | |
0 | 0 | 1 | 0.00 | 0.00 | 05sghzkq6r6yv | select ts#, file#, block#, col... | ||
0 | 0 | 368 | 0.00 | 0.00 | 089dbukv1aanh | EM_PING | SELECT SYS_EXTRACT_UTC(SYSTIME... | |
0 | 0 | 177 | 0.00 | 0.00 | 08bqjmf8490s2 | SEVERITY EVALUATION | SELECT PARAMETER_VALUE FROM MG... | |
0 | 0 | 60 | 0.00 | 0.00 | 08vznc16ycuag | EM_PING | SELECT SYS_GUID() FROM SYS.DUA... |
Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
227,906 | 3,073,389 | 13.49 | 57.48 | 100 | 0 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
74,913 | 227,972 | 3.04 | 30.93 | 96.9 | 0 | 0k8522rmdzg4k | select privilege# from sysauth... | |
74,845 | 74,844 | 1.00 | 18.85 | 93.7 | 0 | 459f3z9u4fb3u | select value$ from props$ wher... | |
74,844 | 74,844 | 1.00 | 24.13 | 102.5 | 0 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
74,843 | 74,845 | 1.00 | 13.36 | 101.3 | 0 | 5ur69atw3vfhj | select decode(failover_method,... | |
22,136 | 22,136 | 1.00 | 5.87 | 98.7 | 0 | 4htx4ts19yknq | select f_ip, to_char(f_invalid... | |
22,121 | 22,107 | 1.00 | 13.75 | 100.7 | .8 | 79c9nwfb1cjqq | INSERT INTO T_LOCATION_INFO(F_... | |
22,120 | 22,121 | 1.00 | 33.07 | 99.9 | .3 | 2rgmdtpdz21yq | BEGIN proc_locationinfo(:1, :2... | |
3,836 | 3,836 | 1.00 | 0.18 | 96.3 | 0 | grwydz59pu6mc | select text from view$ where r... | |
1,504 | 1,504 | 1.00 | 0.72 | 91.9 | .7 | 4m7m0t6fjcs5x | update seq$ set increment$=:2,... |
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
74,913 | 227,906 | 12.96 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
74,912 | 74,913 | 12.96 | 0k8522rmdzg4k | select privilege# from sysauth... | |
74,845 | 74,844 | 12.95 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
74,845 | 74,845 | 12.95 | 459f3z9u4fb3u | select value$ from props$ wher... | |
74,845 | 74,843 | 12.95 | 5ur69atw3vfhj | select decode(failover_method,... | |
22,136 | 22,136 | 3.83 | 4htx4ts19yknq | select f_ip, to_char(f_invalid... | |
22,121 | 22,120 | 3.83 | 2rgmdtpdz21yq | BEGIN proc_locationinfo(:1, :2... | |
22,121 | 22,121 | 3.83 | 79c9nwfb1cjqq | INSERT INTO T_LOCATION_INFO(F_... | |
1,326 | 1,504 | 0.23 | 4m7m0t6fjcs5x | update seq$ set increment$=:2,... | |
374 | 1,287 | 0.06 | d5jz0t3f6r3bd | INSERT INTO SMS_SEND (ID, YWMC... |
Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
4,401,887 | 6 | 0.09 | 5gh60az1a4s7w | SELECT * FROM (SELECT DISTINCT... | |
3,657,075 | 4 | 0.08 | b10jp3ak2bbx5 | SELECT * FROM (SELECT DISTINCT... | |
2,975,993 | 5 | 0.06 | 3va7bfq0j6k2a | SELECT * FROM (SELECT DISTINCT... | |
2,946,661 | 3 | 0.06 | d5fdcdry3r89k | SELECT * FROM (SELECT DISTINCT... | |
2,946,631 | 8 | 0.06 | 5czh73ynvhvt0 | SELECT * FROM (SELECT DISTINCT... | |
2,931,821 | 6 | 0.06 | ffvqzgdcr2fjr | SELECT * FROM (SELECT DISTINCT... | |
2,929,675 | 2 | 0.06 | 4y89c2qwpug31 | SELECT * FROM (SELECT DISTINCT... | |
2,899,587 | 11 | 0.06 | bqpfpt3h5qkns | SELECT * FROM (SELECT DISTINCT... | |
2,212,053 | 3 | 0.05 | d5fdcdry3r89k | SELECT * FROM (SELECT DISTINCT... | |
1,725,143 | 14 | 0.04 | bapm596n71ksu | SELECT * FROM (SELECT DISTINCT... | |
1,699,207 | 6 | 0.03 | 5gh60az1a4s7w | SELECT * FROM (SELECT DISTINCT... | |
1,600,571 | 6 | 0.03 | 4r4scc3q60nf0 | SELECT * FROM (SELECT DISTINCT... | |
1,509,743 | 14 | 0.03 | bapm596n71ksu | SELECT * FROM (SELECT DISTINCT... | |
1,490,583 | 3 | 0.03 | fu9854xtftcsf | SELECT * FROM (SELECT DISTINCT... | |
1,487,783 | 6 | 0.03 | 5gh60az1a4s7w | SELECT * FROM (SELECT DISTINCT... | |
1,487,299 | 2 | 0.03 | c81m7gnggu2z0 | SELECT * FROM (SELECT DISTINCT... | |
1,486,495 | 13 | 0.03 | grqqndp0ayjzd | SELECT * FROM (SELECT DISTINCT... | |
1,484,489 | 9 | 0.03 | dt7r2av4qcz9m | SELECT * FROM (SELECT DISTINCT... | |
1,483,227 | 2 | 0.03 | c81m7gnggu2z0 | SELECT * FROM (SELECT DISTINCT... | |
1,478,829 | 6 | 0.03 | ffvqzgdcr2fjr | SELECT * FROM (SELECT DISTINCT... | |
1,473,473 | 13 | 0.03 | 8az3t0s675hqf | SELECT * FROM (SELECT DISTINCT... | |
1,469,515 | 4 | 0.03 | b10jp3ak2bbx5 | SELECT * FROM (SELECT DISTINCT... | |
1,469,327 | 8 | 0.03 | 5czh73ynvhvt0 | SELECT * FROM (SELECT DISTINCT... | |
1,468,483 | 2 | 0.03 | 4y89c2qwpug31 | SELECT * FROM (SELECT DISTINCT... | |
1,466,193 | 5 | 0.03 | d5bk3k95fw56u | SELECT * FROM (SELECT DISTINCT... | |
1,459,505 | 5 | 0.03 | 486vwb6tb9td8 | SELECT * FROM (SELECT DISTINCT... | |
1,459,091 | 15 | 0.03 | 8qhvuumj0ngbb | SELECT * FROM (SELECT DISTINCT... | |
1,459,083 | 15 | 0.03 | 8qhvuumj0ngbb | SELECT * FROM (SELECT DISTINCT... | |
1,457,211 | 35 | 0.03 | 4gmwwb6mkz29b | SELECT * FROM (SELECT DISTINCT... | |
1,451,377 | 5 | 0.03 | 486vwb6tb9td8 | SELECT * FROM (SELECT DISTINCT... | |
1,449,021 | 30 | 0.03 | 2wkxwatd6t2jy | SELECT * FROM (SELECT DISTINCT... | |
1,211,195 | 6 | 0.02 | 4r4scc3q60nf0 | SELECT * FROM (SELECT DISTINCT... | |
1,151,059 | 3 | 0.02 | 7znyd9jkyrkw5 | SELECT * FROM (SELECT DISTINCT... | |
1,147,653 | 8 | 0.02 | f864vaafk20d4 | SELECT * FROM (SELECT DISTINCT... | |
1,130,013 | 6 | 0.02 | ffvqzgdcr2fjr | SELECT * FROM (SELECT DISTINCT... | |
1,074,255 | 4 | 0.02 | d8ccpd7xxc1r3 | SELECT * FROM (SELECT DISTINCT... |
Version Count | Executions | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|
62 | 1 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
53 | 1 | 6sqdp7673k5x3 | UPDATE wri$_adv_addm_tasks SET... | |
37 | 2 | b3zgx1xckrwxu | select host, userid, password,... | |
36 | 0 | 1n9crga6mbw2x | SELECT nvl(v.first_val, 0), n... | |
35 | 131 | 18naypzfmabd6 | EM_PING | INSERT INTO MGMT_SYSTEM_PERFOR... |
34 | 1 | 8x0funf899dka | INSERT INTO wri$_adv_addm_inst... | |
31 | 1 | 05sghzkq6r6yv | select ts#, file#, block#, col... | |
23 | 1 | akh9zqqkx3wj7 | select 1, max(id) from sys.wri... | |
22 | 177 | 08bqjmf8490s2 | SEVERITY EVALUATION | SELECT PARAMETER_VALUE FROM MG... |
22 | 74,844 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
22 | 74,845 | 459f3z9u4fb3u | select value$ from props$ wher... | |
22 | 22,136 | 4htx4ts19yknq | select f_ip, to_char(f_invalid... | |
22 | 74,843 | 5ur69atw3vfhj | select decode(failover_method,... | |
22 | 22,121 | 79c9nwfb1cjqq | INSERT INTO T_LOCATION_INFO(F_... |
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 | 9 | 0.00 | 0.00 |
CCursor + sql area evicted | 74 | 0.02 | 0.00 |
CPU used by this session | 299,969 | 83.22 | 7.69 |
CPU used when call started | 298,333 | 82.77 | 7.65 |
CR blocks created | 2,340 | 0.65 | 0.06 |
Cached Commit SCN referenced | 275 | 0.08 | 0.01 |
Commit SCN cached | 9 | 0.00 | 0.00 |
DB time | 712,384 | 197.65 | 18.27 |
DBWR checkpoint buffers written | 10,129 | 2.81 | 0.26 |
DBWR checkpoints | 1 | 0.00 | 0.00 |
DBWR object drop buffers written | 0 | 0.00 | 0.00 |
DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
DBWR tablespace checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR thread checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR transaction table writes | 599 | 0.17 | 0.02 |
DBWR undo block writes | 1,816 | 0.50 | 0.05 |
HSC Heap Segment Block Changes | 46,497 | 12.90 | 1.19 |
HSC IDL Compressed Blocks | 0 | 0.00 | 0.00 |
Heap Segment Array Inserts | 124 | 0.03 | 0.00 |
Heap Segment Array Updates | 1,282 | 0.36 | 0.03 |
IMU CR rollbacks | 845 | 0.23 | 0.02 |
IMU Flushes | 2,901 | 0.80 | 0.07 |
IMU Redo allocation size | 3,452,788 | 957.96 | 88.56 |
IMU commits | 29,404 | 8.16 | 0.75 |
IMU contention | 186 | 0.05 | 0.00 |
IMU ktichg flush | 0 | 0.00 | 0.00 |
IMU pool not allocated | 23 | 0.01 | 0.00 |
IMU recursive-transaction flush | 2 | 0.00 | 0.00 |
IMU undo allocation size | 27,797,928 | 7,712.37 | 712.97 |
IMU- failed to get a private strand | 23 | 0.01 | 0.00 |
LOB table id lookup cache misses | 0 | 0.00 | 0.00 |
Number of read IOs issued | 0 | 0.00 | 0.00 |
PX local messages recv'd | 0 | 0.00 | 0.00 |
PX local messages sent | 0 | 0.00 | 0.00 |
Requests to/from client | 324,597 | 90.06 | 8.33 |
RowCR - row contention | 640 | 0.18 | 0.02 |
RowCR attempts | 768 | 0.21 | 0.02 |
RowCR hits | 128 | 0.04 | 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 | 324,815 | 90.12 | 8.33 |
SQL*Net roundtrips to/from dblink | 244 | 0.07 | 0.01 |
TBS Extension: tasks created | 0 | 0.00 | 0.00 |
active txn count during cleanout | 2,290 | 0.64 | 0.06 |
application wait time | 3,960 | 1.10 | 0.10 |
auto extends on undo tablespace | 0 | 0.00 | 0.00 |
background checkpoints completed | 1 | 0.00 | 0.00 |
background checkpoints started | 1 | 0.00 | 0.00 |
background timeouts | 20,007 | 5.55 | 0.51 |
branch node splits | 0 | 0.00 | 0.00 |
buffer is not pinned count | 1,104,912 | 306.55 | 28.34 |
buffer is pinned count | 1,170,819 | 324.84 | 30.03 |
bytes received via SQL*Net from client | 70,152,021 | 19,463.26 | 1,799.28 |
bytes received via SQL*Net from dblink | 110,498 | 30.66 | 2.83 |
bytes sent via SQL*Net to client | 160,728,044 | 44,593.03 | 4,122.39 |
bytes sent via SQL*Net to dblink | 97,938 | 27.17 | 2.51 |
calls to get snapshot scn: kcmgss | 667,286 | 185.13 | 17.11 |
calls to kcmgas | 43,458 | 12.06 | 1.11 |
calls to kcmgcs | 477,110 | 132.37 | 12.24 |
cell physical IO interconnect bytes | 3,249,958,912 | 901,681.59 | 83,355.79 |
change write time | 327 | 0.09 | 0.01 |
cleanout - number of ktugct calls | 1,321 | 0.37 | 0.03 |
cleanouts and rollbacks - consistent read gets | 642 | 0.18 | 0.02 |
cleanouts only - consistent read gets | 10 | 0.00 | 0.00 |
cluster key scan block gets | 3,281 | 0.91 | 0.08 |
cluster key scans | 2,586 | 0.72 | 0.07 |
commit batch performed | 7 | 0.00 | 0.00 |
commit batch requested | 7 | 0.00 | 0.00 |
commit batch/immediate performed | 76 | 0.02 | 0.00 |
commit batch/immediate requested | 76 | 0.02 | 0.00 |
commit cleanout failures: block lost | 0 | 0.00 | 0.00 |
commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 14 | 0.00 | 0.00 |
commit cleanout failures: cannot pin | 41 | 0.01 | 0.00 |
commit cleanouts | 45,920 | 12.74 | 1.18 |
commit cleanouts successfully completed | 45,865 | 12.72 | 1.18 |
commit immediate performed | 69 | 0.02 | 0.00 |
commit immediate requested | 69 | 0.02 | 0.00 |
commit txn count during cleanout | 280 | 0.08 | 0.01 |
concurrency wait time | 57,620 | 15.99 | 1.48 |
consistent changes | 16,219 | 4.50 | 0.42 |
consistent gets | 313,286,251 | 86,919.39 | 8,035.25 |
consistent gets - examination | 628,046 | 174.25 | 16.11 |
consistent gets direct | 8 | 0.00 | 0.00 |
consistent gets from cache | 313,286,221 | 86,919.38 | 8,035.25 |
consistent gets from cache (fastpath) | 312,537,696 | 86,711.71 | 8,016.05 |
cursor authentications | 797 | 0.22 | 0.02 |
data blocks consistent reads - undo records applied | 3,410 | 0.95 | 0.09 |
db block changes | 197,901 | 54.91 | 5.08 |
db block gets | 346,203 | 96.05 | 8.88 |
db block gets direct | 41 | 0.01 | 0.00 |
db block gets from cache | 346,162 | 96.04 | 8.88 |
db block gets from cache (fastpath) | 66,201 | 18.37 | 1.70 |
deferred (CURRENT) block cleanout applications | 39,613 | 10.99 | 1.02 |
dirty buffers inspected | 0 | 0.00 | 0.00 |
enqueue conversions | 1,128 | 0.31 | 0.03 |
enqueue releases | 334,712 | 92.86 | 8.58 |
enqueue requests | 334,726 | 92.87 | 8.59 |
enqueue timeouts | 0 | 0.00 | 0.00 |
enqueue waits | 205 | 0.06 | 0.01 |
exchange deadlocks | 9 | 0.00 | 0.00 |
execute count | 654,170 | 181.50 | 16.78 |
failed probes on index block reclamation | 0 | 0.00 | 0.00 |
file io service time | 0 | 0.00 | 0.00 |
file io wait time | 1,712,078 | 475.01 | 43.91 |
free buffer inspected | 37,443 | 10.39 | 0.96 |
free buffer requested | 28,419 | 7.88 | 0.73 |
global undo segment hints helped | 0 | 0.00 | 0.00 |
heap block compress | 1,196 | 0.33 | 0.03 |
hot buffers moved to head of LRU | 1,669 | 0.46 | 0.04 |
immediate (CR) block cleanout applications | 652 | 0.18 | 0.02 |
immediate (CURRENT) block cleanout applications | 867 | 0.24 | 0.02 |
in call idle wait time | 10,291,911 | 2,855.43 | 263.97 |
index crx upgrade (positioned) | 31 | 0.01 | 0.00 |
index crx upgrade (prefetch) | 1 | 0.00 | 0.00 |
index fast full scans (full) | 33 | 0.01 | 0.00 |
index fetch by key | 117,632 | 32.64 | 3.02 |
index scans kdiixs1 | 2,211,435 | 613.55 | 56.72 |
leaf node 90-10 splits | 23 | 0.01 | 0.00 |
leaf node splits | 74 | 0.02 | 0.00 |
lob reads | 0 | 0.00 | 0.00 |
lob writes | 27 | 0.01 | 0.00 |
lob writes unaligned | 27 | 0.01 | 0.00 |
logical read bytes from cache | 2,569,275,826,176 | 712,830,155.21 | 65,897,453.80 |
logons cumulative | 75,135 | 20.85 | 1.93 |
max cf enq hold time | 0 | 0.00 | 0.00 |
messages received | 41,987 | 11.65 | 1.08 |
messages sent | 41,987 | 11.65 | 1.08 |
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 | 312,134,131 | 86,599.74 | 8,005.70 |
non-idle wait count | 668,820 | 185.56 | 17.15 |
non-idle wait time | 65,427 | 18.15 | 1.68 |
opened cursors cumulative | 776,994 | 215.57 | 19.93 |
parse count (describe) | 3 | 0.00 | 0.00 |
parse count (failures) | 30,135 | 8.36 | 0.77 |
parse count (hard) | 58,032 | 16.10 | 1.49 |
parse count (total) | 578,154 | 160.41 | 14.83 |
parse time cpu | 23,351 | 6.48 | 0.60 |
parse time elapsed | 43,459 | 12.06 | 1.11 |
physical read IO requests | 23,351 | 6.48 | 0.60 |
physical read bytes | 1,089,683,456 | 302,326.13 | 27,948.48 |
physical read total IO requests | 27,247 | 7.56 | 0.70 |
physical read total bytes | 1,183,864,320 | 328,456.05 | 30,364.06 |
physical read total multi block requests | 3,585 | 0.99 | 0.09 |
physical reads | 133,018 | 36.91 | 3.41 |
physical reads cache | 18,960 | 5.26 | 0.49 |
physical reads cache prefetch | 228 | 0.06 | 0.01 |
physical reads direct | 114,058 | 31.64 | 2.93 |
physical reads direct (lob) | 0 | 0.00 | 0.00 |
physical reads direct temporary tablespace | 114,050 | 31.64 | 2.93 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 17,525 | 4.86 | 0.45 |
physical write bytes | 1,945,698,304 | 539,822.31 | 49,903.78 |
physical write total IO requests | 54,678 | 15.17 | 1.40 |
physical write total bytes | 2,066,094,592 | 573,225.54 | 52,991.73 |
physical write total multi block requests | 7,190 | 1.99 | 0.18 |
physical writes | 237,512 | 65.90 | 6.09 |
physical writes direct | 227,383 | 63.09 | 5.83 |
physical writes direct (lob) | 20 | 0.01 | 0.00 |
physical writes direct temporary tablespace | 227,342 | 63.07 | 5.83 |
physical writes from cache | 10,129 | 2.81 | 0.26 |
physical writes non checkpoint | 228,952 | 63.52 | 5.87 |
pinned buffers inspected | 0 | 0.00 | 0.00 |
prefetch clients - default | 0 | 0.00 | 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 | 372 | 0.10 | 0.01 |
process last non-idle time | 3,595 | 1.00 | 0.09 |
recovery block gets from cache | 0 | 0.00 | 0.00 |
recovery blocks read | 0 | 0.00 | 0.00 |
recursive calls | 7,660,252 | 2,125.29 | 196.47 |
recursive cpu usage | 45,156 | 12.53 | 1.16 |
redo KB read | 29,342 | 8.14 | 0.75 |
redo blocks checksummed by FG (exclusive) | 11,351 | 3.15 | 0.29 |
redo blocks read for recovery | 0 | 0.00 | 0.00 |
redo blocks written | 86,765 | 24.07 | 2.23 |
redo buffer allocation retries | 0 | 0.00 | 0.00 |
redo entries | 61,601 | 17.09 | 1.58 |
redo k-bytes read for recovery | 0 | 0.00 | 0.00 |
redo log space requests | 0 | 0.00 | 0.00 |
redo log space wait time | 0 | 0.00 | 0.00 |
redo ordering marks | 472 | 0.13 | 0.01 |
redo size | 33,765,020 | 9,367.90 | 866.01 |
redo size for direct writes | 337,348 | 93.60 | 8.65 |
redo subscn max counts | 1,890 | 0.52 | 0.05 |
redo synch long waits | 0 | 0.00 | 0.00 |
redo synch time | 342 | 0.09 | 0.01 |
redo synch time (usec) | 6,892,316 | 1,912.23 | 176.78 |
redo synch writes | 32,300 | 8.96 | 0.83 |
redo wastage | 9,294,744 | 2,578.77 | 238.39 |
redo write time | 597 | 0.17 | 0.02 |
redo writes | 34,242 | 9.50 | 0.88 |
rollback changes - undo records applied | 88 | 0.02 | 0.00 |
rollbacks only - consistent read gets | 1,713 | 0.48 | 0.04 |
rows fetched via callback | 90,950 | 25.23 | 2.33 |
scheduler wait time | 0 | 0.00 | 0.00 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 171,781 | 47.66 | 4.41 |
session logical reads | 313,633,587 | 87,015.76 | 8,044.16 |
shared hash latch upgrades - no wait | 78,056 | 21.66 | 2.00 |
shared hash latch upgrades - wait | 71 | 0.02 | 0.00 |
sorts (disk) | 4 | 0.00 | 0.00 |
sorts (memory) | 695,525 | 192.97 | 17.84 |
sorts (rows) | 14,927,517 | 4,141.55 | 382.86 |
sql area evicted | 24,492 | 6.80 | 0.63 |
sql area purged | 10 | 0.00 | 0.00 |
summed dirty queue length | 0 | 0.00 | 0.00 |
switch current to new buffer | 6,056 | 1.68 | 0.16 |
table fetch by rowid | 129,471 | 35.92 | 3.32 |
table fetch continued row | 292 | 0.08 | 0.01 |
table scan blocks gotten | 309,909,159 | 85,982.44 | 7,948.63 |
table scan rows gotten | 10,857,902,502 | 3,012,459.87 | 278,486.30 |
table scans (direct read) | 0 | 0.00 | 0.00 |
table scans (long tables) | 3,026 | 0.84 | 0.08 |
table scans (short tables) | 222,088 | 61.62 | 5.70 |
temp space allocated (bytes) | 0 | 0.00 | 0.00 |
total cf enq hold time | 50 | 0.01 | 0.00 |
total number of cf enq holders | 64 | 0.02 | 0.00 |
total number of times SMON posted | 8 | 0.00 | 0.00 |
transaction rollbacks | 76 | 0.02 | 0.00 |
transaction tables consistent reads - undo records applied | 80 | 0.02 | 0.00 |
undo change vector size | 8,206,932 | 2,276.96 | 210.49 |
user I/O wait time | 987 | 0.27 | 0.03 |
user calls | 608,909 | 168.94 | 15.62 |
user commits | 32,286 | 8.96 | 0.83 |
user rollbacks | 6,703 | 1.86 | 0.17 |
workarea executions - onepass | 8 | 0.00 | 0.00 |
workarea executions - optimal | 318,685 | 88.42 | 8.17 |
write clones created in background | 0 | 0.00 | 0.00 |
write clones created in foreground | 0 | 0.00 | 0.00 |
Statistic | Begin Value | End Value |
---|---|---|
opened cursors current | 480 | 463 |
workarea memory allocated | 22,464 | 22,464 |
logons current | 687 | 704 |
session uga memory max | 22,110,358,800,496 | 22,142,530,681,920 |
session pga memory | 102,727,399,344 | 102,889,433,456 |
session pga memory max | 153,334,201,584 | 153,521,649,296 |
session cursor cache count | 453,829,826 | 454,308,958 |
session uga memory | 194,459,108,177,896 | 194,754,914,398,304 |
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 | 891M | 1.28 | .247202 | 794M | 1.34 | .220290 | 4611 | 0.00 |
Direct Writes | 0M | 0.00 | 0M | 983M | 1.44 | .272727 | 10K | 0.28 |
Others | 91M | 1.08 | .025247 | 73M | 0.78 | .020253 | 6705 | 0.02 |
Buffer Cache Reads | 146M | 5.11 | .040506 | 0M | 0.00 | 0M | 18.4K | 0.01 |
DBWR | 0M | 0.00 | 0M | 79M | 2.08 | .021918 | 7499 | 0.02 |
LGWR | 0M | 0.00 | 0M | 42M | 9.52 | .011652 | 68.5K | 0.02 |
TOTAL: | 1.1G | 7.47 | .312956 | 1.9G | 15.17 | .546842 | 115.8K | 0.04 |
Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read |
---|---|---|---|---|---|---|---|---|
Temp File | 891M | 1.28 | .247202 | 1.7G | 2.78 | .492740 | 0.00 | 0.00 |
Data File | 144M | 5.12 | .039951 | 79M | 2.09 | .021918 | 0.02 | |
Control File | 61M | 1.07 | .016924 | 43M | 0.78 | .011930 | 0.00 | 0.00 |
Log File | 29M | 0.01 | .008045 | 42M | 9.52 | .011652 | 0.00 | 0.00 |
Archive Log | 0M | 0.00 | 0M | 29M | 0.01 | .008045 | ||
TOTAL: | 1.1G | 7.47 | .312124 | 1.9G | 15.17 | .546287 | 0.01 | 0.00 |
Function/File Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
---|---|---|---|---|---|---|---|---|
Direct Reads | 891M | 1.28 | .247202 | 794M | 1.34 | .220290 | 0 | |
Direct Reads (Data File) | 891M | 1.28 | .247202 | 794M | 1.34 | .220290 | 0 | |
Direct Writes | 0M | 0.00 | 0M | 983M | 1.44 | .272727 | 0 | |
Direct Writes (Data File) | 0M | 0.00 | 0M | 983M | 1.44 | .272727 | 0 | |
Others | 91M | 1.08 | .025247 | 73M | 0.78 | .020253 | 3898 | 0.01 |
Others (Control File) | 61M | 1.06 | .016924 | 44M | 0.77 | .012207 | 3827 | 0.00 |
Others (Archive Log) | 0M | 0.00 | 0M | 29M | 0.01 | .008045 | 0 | |
Others (Log File) | 29M | 0.01 | .008045 | 0M | 0.00 | 0M | 33 | 0.00 |
Others (Data File) | 1M | 0.01 | .000277 | 0M | 0.00 | 0M | 38 | 0.92 |
Buffer Cache Reads | 146M | 5.11 | .040506 | 0M | 0.00 | 0M | 18.4K | 0.01 |
Buffer Cache Reads (Data File) | 146M | 5.11 | .040506 | 0M | 0.00 | 0M | 18.4K | 0.01 |
DBWR | 0M | 0.00 | 0M | 79M | 2.08 | .021918 | 0 | |
DBWR (Data File) | 0M | 0.00 | 0M | 79M | 2.08 | .021918 | 0 | |
LGWR | 0M | 0.00 | 0M | 42M | 9.52 | .011652 | 18 | 0.00 |
LGWR (Log File) | 0M | 0.00 | 0M | 42M | 9.52 | .011652 | 4 | 0.00 |
LGWR (Control File) | 0M | 0.00 | 0M | 0M | 0.01 | 0M | 14 | 0.00 |
TOTAL: | 1.1G | 7.47 | .312956 | 1.9G | 15.17 | .546842 | 22.3K | 0.01 |
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
USERCENTER20120220_DATA | 18,820 | 5 | 0.03 | 1.01 | 5,445 | 2 | 460 | 0.07 |
USERCENTER_TEMP | 4,611 | 1 | 0.00 | 24.73 | 10,004 | 3 | 0 | 0.00 |
UNDOTBS1 | 0 | 0 | 0.00 | 0.00 | 1,225 | 0 | 5 | 0.00 |
SYSAUX | 34 | 0 | 1.18 | 1.00 | 765 | 0 | 0 | 0.00 |
SYSTEM | 0 | 0 | 0.00 | 0.00 | 86 | 0 | 1 | 0.00 |
Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|---|
SYSAUX | /opt/oracle/oradata/jqhx/sysaux01.dbf | 34 | 0 | 1.18 | 1.00 | 765 | 0 | 0 | 0.00 |
SYSTEM | /opt/oracle/oradata/jqhx/system01.dbf | 0 | 0 | 86 | 0 | 1 | 0.00 | ||
UNDOTBS1 | /opt/oracle/oradata/jqhx/undotbs01.dbf | 0 | 0 | 1,225 | 0 | 5 | 0.00 | ||
USERCENTER20120220_DATA | /opt/oracle/oradata/jqhx/USERCENTER20120220_DATA.dbf | 17,209 | 5 | 0.03 | 1.01 | 2,734 | 1 | 428 | 0.07 |
USERCENTER20120220_DATA | /opt/oracle/oradata/jqhx/USERCENTER20120220_DATA1.dbf | 1,611 | 0 | 0.06 | 1.01 | 2,476 | 1 | 31 | 0.00 |
USERCENTER20120220_DATA | /opt/oracle/oradata/jqhx/USERCENTER20120220_DATA2.dbf | 0 | 0 | 235 | 0 | 1 | 0.00 | ||
USERCENTER_TEMP | /opt/oracle/oradata/jqhx/USERCENTER_TEMP.dbf | 4,611 | 1 | 0.00 | 24.73 | 10,004 | 3 | 0 |
P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits |
---|---|---|---|---|---|---|---|---|
D | 370,736 | 100 | 313,582,948 | 19,039 | 10,129 | 0 | 0 | 466 |
MTTR Writes | Log Size Writes | Log Ckpt Writes | Other Settings Writes | Autotune Ckpt Writes | Thread Ckpt Writes |
---|---|---|---|---|---|
0 | 0 | 0 | 0 | 10,128 | 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 | 12 | 1068 | 12173 | 43802 | 580608 | 43802 | |||
E | 0 | 12 | 680 | 5782 | 29561 | 580608 | 29561 |
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.12 | 39,014,462 | 1 | 173338.00 |
D | 576 | 0.19 | 71 | 1.01 | 35,188,579 | 1 | 138135.00 |
D | 864 | 0.29 | 106 | 1.00 | 34,896,588 | 1 | 135448.00 |
D | 1,152 | 0.38 | 142 | 1.00 | 34,867,803 | 1 | 135183.00 |
D | 1,440 | 0.48 | 177 | 1.00 | 34,867,484 | 1 | 135180.00 |
D | 1,728 | 0.57 | 213 | 1.00 | 34,867,290 | 1 | 135178.00 |
D | 2,016 | 0.67 | 248 | 1.00 | 34,867,154 | 1 | 135177.00 |
D | 2,304 | 0.77 | 284 | 1.00 | 34,867,081 | 1 | 135176.00 |
D | 2,592 | 0.86 | 319 | 1.00 | 34,867,031 | 1 | 135176.00 |
D | 2,880 | 0.96 | 355 | 1.00 | 34,866,996 | 1 | 135176.00 |
D | 3,008 | 1.00 | 371 | 1.00 | 34,866,982 | 1 | 135176.00 |
D | 3,168 | 1.05 | 390 | 1.00 | 34,866,968 | 1 | 135175.00 |
D | 3,456 | 1.15 | 426 | 1.00 | 34,866,941 | 1 | 135175.00 |
D | 3,744 | 1.24 | 461 | 1.00 | 34,866,898 | 1 | 135175.00 |
D | 4,032 | 1.34 | 497 | 1.00 | 34,866,879 | 1 | 135175.00 |
D | 4,320 | 1.44 | 532 | 1.00 | 34,866,122 | 1 | 135168.00 |
D | 4,608 | 1.53 | 568 | 1.00 | 34,863,743 | 1 | 135146.00 |
D | 4,896 | 1.63 | 603 | 1.00 | 34,857,651 | 1 | 135090.00 |
D | 5,184 | 1.72 | 639 | 1.00 | 34,823,241 | 1 | 134773.00 |
D | 5,472 | 1.82 | 674 | 1.00 | 34,788,832 | 1 | 134456.00 |
D | 5,760 | 1.91 | 710 | 0.98 | 34,002,156 | 1 | 128118.00 |
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
92.26 | 23,819 | 1,998 |
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 | 2,994 | 1,257.54 | 0.00 | 0.00 | 0.00 | 0.00 | 429,260 |
E | 0 | 3,034 | 1,291.55 | 0.00 | 0.00 | 0.00 | 0.00 | 429,260 |
Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
---|---|---|---|---|---|
2K | 4K | 312,200 | 312,200 | 0 | 0 |
64K | 128K | 790 | 790 | 0 | 0 |
128K | 256K | 392 | 392 | 0 | 0 |
256K | 512K | 90 | 90 | 0 | 0 |
512K | 1024K | 3,513 | 3,513 | 0 | 0 |
1M | 2M | 1,264 | 1,264 | 0 | 0 |
2M | 4M | 56 | 56 | 0 | 0 |
4M | 8M | 32 | 32 | 0 | 0 |
8M | 16M | 134 | 134 | 0 | 0 |
16M | 32M | 22 | 22 | 0 | 0 |
32M | 64M | 128 | 128 | 0 | 0 |
64M | 128M | 110 | 110 | 0 | 0 |
128M | 256M | 8 | 0 | 8 | 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 | 1,808,413.06 | 1,180,167.95 | 61.00 | 6,417 | 273,794,308 |
1,048 | 0.25 | 1,808,413.06 | 344,359.09 | 84.00 | 1,710 | 197,222,949 |
2,096 | 0.50 | 1,808,413.06 | 89,672.91 | 95.00 | 76 | 173,890,262 |
3,144 | 0.75 | 1,808,413.06 | 88,013.74 | 95.00 | 11 | 173,738,260 |
4,192 | 1.00 | 1,808,413.06 | 87,072.83 | 95.00 | 3 | 173,652,059 |
5,030 | 1.20 | 1,808,413.06 | 816.67 | 100.00 | 0 | 165,749,833 |
5,869 | 1.40 | 1,808,413.06 | 816.67 | 100.00 | 0 | 165,749,833 |
6,707 | 1.60 | 1,808,413.06 | 816.67 | 100.00 | 0 | 165,749,833 |
7,546 | 1.80 | 1,808,413.06 | 816.67 | 100.00 | 0 | 165,749,833 |
8,384 | 2.00 | 1,808,413.06 | 816.67 | 100.00 | 0 | 165,749,833 |
12,576 | 3.00 | 1,808,413.06 | 816.67 | 100.00 | 0 | 165,749,833 |
16,768 | 4.00 | 1,808,413.06 | 816.67 | 100.00 | 0 | 165,749,833 |
25,152 | 6.00 | 1,808,413.06 | 816.67 | 100.00 | 0 | 165,749,833 |
33,536 | 8.00 | 1,808,413.06 | 816.67 | 100.00 | 0 | 165,749,833 |
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 | 266 | 27,384 | 2,072,392 | 0.38 | 3,928,532 | 6.81 | 783,331 |
3,200 | 0.69 | 745 | 48,130 | 2,957,756 | 0.55 | 3,043,168 | 5.28 | 976,881 |
3,680 | 0.79 | 1,222 | 67,319 | 3,805,173 | 0.70 | 2,195,751 | 3.81 | 1,153,521 |
4,160 | 0.90 | 1,702 | 87,984 | 4,651,777 | 0.86 | 1,349,147 | 2.34 | 1,330,112 |
4,320 | 0.93 | 1,861 | 93,314 | 4,933,421 | 0.91 | 1,067,503 | 1.85 | 1,388,973 |
4,352 | 0.94 | 1,893 | 94,307 | 4,989,710 | 0.92 | 1,011,214 | 1.75 | 1,400,743 |
4,384 | 0.94 | 1,925 | 95,426 | 5,046,044 | 0.93 | 954,880 | 1.66 | 1,412,512 |
4,416 | 0.95 | 1,957 | 96,138 | 5,102,297 | 0.94 | 898,627 | 1.56 | 1,424,281 |
4,448 | 0.96 | 1,989 | 96,962 | 5,159,028 | 0.95 | 841,896 | 1.46 | 1,436,207 |
4,480 | 0.97 | 2,020 | 97,802 | 5,215,753 | 0.96 | 785,171 | 1.36 | 1,448,051 |
4,512 | 0.97 | 2,052 | 98,723 | 5,277,717 | 0.97 | 723,207 | 1.25 | 1,460,837 |
4,544 | 0.98 | 2,084 | 99,462 | 5,320,846 | 0.98 | 680,078 | 1.18 | 1,469,690 |
4,576 | 0.99 | 2,116 | 100,409 | 5,354,182 | 0.99 | 646,742 | 1.12 | 1,476,364 |
4,608 | 0.99 | 2,148 | 101,298 | 5,387,238 | 0.99 | 613,686 | 1.06 | 1,482,997 |
4,640 | 1.00 | 2,180 | 102,173 | 5,424,313 | 1.00 | 576,611 | 1.00 | 1,490,187 |
4,672 | 1.01 | 2,212 | 103,123 | 5,425,350 | 1.00 | 575,574 | 1.00 | 1,490,353 |
4,704 | 1.01 | 2,244 | 104,062 | 5,425,408 | 1.00 | 575,516 | 1.00 | 1,490,358 |
4,736 | 1.02 | 2,276 | 105,200 | 5,425,466 | 1.00 | 575,458 | 1.00 | 1,490,364 |
4,768 | 1.03 | 2,308 | 105,960 | 5,425,530 | 1.00 | 575,394 | 1.00 | 1,490,370 |
4,800 | 1.03 | 2,339 | 106,665 | 5,425,589 | 1.00 | 575,335 | 1.00 | 1,490,375 |
4,832 | 1.04 | 2,371 | 107,528 | 5,425,646 | 1.00 | 575,278 | 1.00 | 1,490,379 |
4,864 | 1.05 | 2,403 | 108,478 | 5,425,694 | 1.00 | 575,230 | 1.00 | 1,490,383 |
4,896 | 1.06 | 2,434 | 109,241 | 5,425,745 | 1.00 | 575,179 | 1.00 | 1,490,386 |
4,928 | 1.06 | 2,466 | 109,937 | 5,425,787 | 1.00 | 575,137 | 1.00 | 1,490,389 |
5,120 | 1.10 | 2,658 | 114,610 | 5,426,073 | 1.00 | 574,851 | 1.00 | 1,490,411 |
5,600 | 1.21 | 3,138 | 126,964 | 5,426,670 | 1.00 | 574,254 | 1.00 | 1,490,464 |
6,080 | 1.31 | 3,618 | 143,943 | 5,427,204 | 1.00 | 573,720 | 1.00 | 1,490,509 |
6,560 | 1.41 | 4,098 | 169,803 | 5,427,658 | 1.00 | 573,266 | 0.99 | 1,490,547 |
7,040 | 1.52 | 4,578 | 204,125 | 5,428,154 | 1.00 | 572,770 | 0.99 | 1,490,584 |
7,520 | 1.62 | 5,058 | 241,650 | 5,428,644 | 1.00 | 572,280 | 0.99 | 1,490,620 |
8,000 | 1.72 | 5,538 | 277,605 | 5,429,239 | 1.00 | 571,685 | 0.99 | 1,490,660 |
8,480 | 1.83 | 6,018 | 307,137 | 5,429,938 | 1.00 | 570,986 | 0.99 | 1,490,700 |
8,960 | 1.93 | 6,498 | 338,966 | 5,430,621 | 1.00 | 570,303 | 0.99 | 1,490,739 |
9,440 | 2.03 | 6,977 | 367,269 | 5,431,284 | 1.00 | 569,640 | 0.99 | 1,490,775 |
SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
---|---|---|---|
3,904 | 0.50 | 5,957,804 | 35,187,758,729 |
4,880 | 0.63 | 3,733,381 | 39,012,666,708 |
5,856 | 0.75 | 3,485,371 | 34,894,876,076 |
6,832 | 0.88 | 3,484,326 | 34,866,982,490 |
7,808 | 1.00 | 3,483,281 | 34,866,982,490 |
8,784 | 1.13 | 3,482,236 | 34,866,982,490 |
9,760 | 1.25 | 3,480,843 | 34,866,982,490 |
10,736 | 1.38 | 3,477,708 | 34,002,281,324 |
11,712 | 1.50 | 3,476,663 | 34,002,281,324 |
12,688 | 1.63 | 3,475,618 | 34,002,281,324 |
13,664 | 1.75 | 3,474,573 | 34,002,281,324 |
14,640 | 1.88 | 3,473,179 | 34,002,281,324 |
15,616 | 2.00 | 3,472,483 | 34,002,281,324 |
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 | 432 | 0 | 0 |
segment header | 19 | 0 | 0 |
1st level bmb | 9 | 0 | 0 |
undo header | 5 | 0 | 0 |
2nd level bmb | 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) | 99 | 99 | 0 | 99 | 31 | 313.74 |
TX-Transaction (index contention) | 45 | 45 | 0 | 43 | 0 | 2.79 |
SQ-Sequence Cache | 1,553 | 1,553 | 0 | 48 | 0 | 0.63 |
TX-Transaction | 34,489 | 34,490 | 0 | 11 | 0 | 1.82 |
FB-Format Block | 42 | 42 | 0 | 1 | 0 | 10.00 |
HW-Segment High Water Mark | 4,257 | 4,257 | 0 | 3 | 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 | 1.21 | 35,036 | 1,376 | 31 | 16.5/38 | 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 |
---|---|---|---|---|---|---|---|
30-8月 10:59 | 112 | 2,323 | 1,376 | 10 | 38 | 0/0 | 0/0/0/0/0/0 |
30-8月 10:49 | 173 | 3,016 | 1,291 | 31 | 37 | 0/0 | 0/0/0/0/0/0 |
30-8月 10:39 | 220 | 4,109 | 689 | 4 | 27 | 0/0 | 0/0/0/0/0/0 |
30-8月 10:29 | 152 | 7,061 | 87 | 4 | 16 | 0/0 | 0/0/0/0/0/0 |
30-8月 10:19 | 192 | 8,629 | 689 | 4 | 27 | 0/0 | 0/0/0/0/0/0 |
30-8月 10:09 | 357 | 9,898 | 87 | 9 | 16 | 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 | 21 | 0.00 | 0 | 0 | ||
AQ dequeue txn counter latch | 4 | 0.00 | 0 | 0 | ||
AQ disk delete txn counter latch | 4 | 0.00 | 0 | 0 | ||
ASM db client latch | 2,409 | 0.00 | 0 | 0 | ||
ASM map operation hash table | 1 | 0.00 | 0 | 0 | ||
ASM network state latch | 63 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 54,880 | 0.00 | 0 | 0 | ||
Change Notification Hash table latch | 1,201 | 0.00 | 0 | 0 | ||
Consistent RBA | 34,246 | 0.00 | 0 | 0 | ||
DML lock allocation | 107,831 | 0.01 | 0.00 | 0 | 0 | |
Event Group Locks | 150,225 | 0.02 | 0.00 | 0 | 0 | |
FAL Queue | 98 | 0.00 | 0 | 0 | ||
FIB s.o chain latch | 6 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 1,352 | 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 | 174,192 | 0.01 | 0.96 | 0 | 47,392 | 0.05 |
JS Sh mem access | 7 | 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,134 | 0.00 | 0 | 0 | ||
JS slv state obj latch | 237 | 1.27 | 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,201 | 0.00 | 0 | 0 | ||
KTF sga latch | 19 | 0.00 | 0 | 1,168 | 0.00 | |
KWQMN job cache list latch | 11 | 0.00 | 0 | 0 | ||
KWQP Prop Status | 2 | 0.00 | 0 | 0 | ||
KWQS pqsubs latch | 4 | 0.00 | 0 | 0 | ||
KWQS pqueue ctx latch | 78 | 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 | 72 | 0.00 | ||
Memory Management Latch | 1 | 0.00 | 0 | 1,201 | 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 | 40 | 0.00 | 0 | 0 | ||
Mutex | 1 | 0.00 | 0 | 0 | ||
Mutex Stats | 1 | 0.00 | 0 | 0 | ||
OS process | 300,929 | 0.00 | 0 | 0 | ||
OS process allocation | 157,854 | 0.05 | 0.00 | 0 | 0 | |
OS process: request allocation | 150,132 | 0.05 | 0.00 | 0 | 0 | |
PL/SQL warning settings | 97,547 | 0.01 | 0.00 | 0 | 0 | |
PX hash array latch | 1 | 0.00 | 0 | 0 | ||
QMT | 1 | 0.00 | 0 | 0 | ||
Real-time plan statistics latch | 22,206 | 0.00 | 0 | 0 | ||
Reserved Space Latch | 4 | 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 | 121 | 0.00 | 0 | 1,200 | 0.00 | |
SQL memory manager workarea list latch | 249,032 | 0.00 | 0 | 0 | ||
Shared B-Tree | 348 | 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 | 909 | 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 | 11,116 | 0.14 | 0.00 | 0 | 0 | |
active service list | 458,206 | 0.08 | 0.04 | 0 | 2,677 | 0.04 |
alert log latch | 2 | 0.00 | 0 | 0 | ||
archive control | 63 | 0.00 | 0 | 0 | ||
archive process latch | 295 | 0.00 | 0 | 0 | ||
begin backup scn array | 22 | 0.00 | 0 | 0 | ||
buffer pool | 1 | 0.00 | 0 | 0 | ||
business card | 1 | 0.00 | 0 | 0 | ||
cache buffer handles | 574 | 0.00 | 0 | 0 | ||
cache buffers chains | 627,378,312 | 0.33 | 0.00 | 0 | 1,386,468 | 0.00 |
cache buffers lru chain | 22,488 | 0.01 | 0.00 | 0 | 216,430,223 | 0.03 |
cache table scan latch | 228 | 0.00 | 0 | 228 | 0.00 | |
call allocation | 226,107 | 0.53 | 0.63 | 3 | 0 | |
cas latch | 1 | 0.00 | 0 | 0 | ||
change notification client cache latch | 1 | 0.00 | 0 | 0 | ||
channel handle pool latch | 150,149 | 0.03 | 0.00 | 0 | 0 | |
channel operations parent latch | 242,434 | 0.01 | 0.00 | 0 | 0 | |
checkpoint queue latch | 756,400 | 0.00 | 0 | 9,598 | 0.00 | |
client/application info | 450,347 | 0.00 | 0.00 | 0 | 0 | |
compile environment latch | 75,147 | 0.03 | 0.00 | 0 | 0 | |
corrupted undo seg latch | 333 | 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 | 63 | 0.00 | 0 | 0 | ||
cvmap freelist lock | 1 | 0.00 | 0 | 0 | ||
deferred cleanup latch | 63 | 0.00 | 0 | 0 | ||
dml lock allocation | 63 | 0.00 | 0 | 0 | ||
done queue latch | 1 | 0.00 | 0 | 0 | ||
dummy allocation | 150,269 | 1.04 | 0.01 | 0 | 0 | |
enqueue freelist latch | 1 | 0.00 | 0 | 339,426 | 0.00 | |
enqueue hash chains | 670,801 | 0.06 | 0.01 | 0 | 14 | 0.00 |
enqueues | 3 | 0.00 | 0 | 0 | ||
fifth spare latch | 1 | 0.00 | 0 | 0 | ||
file cache latch | 235 | 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 | 74,941 | 0.00 | 0 | 0 | ||
global tx hash mapping | 1,140 | 0.00 | 0 | 0 | ||
granule operation | 1 | 0.00 | 0 | 0 | ||
hash table column usage latch | 348 | 0.00 | 0 | 5,566,253 | 0.01 | |
hash table modification latch | 98 | 0.00 | 0 | 0 | ||
heartbeat check | 1 | 0.00 | 0 | 0 | ||
intra txn parallel recovery | 1 | 0.00 | 0 | 0 | ||
io pool granule metadata list | 1 | 0.00 | 0 | 0 | ||
job workq parent latch | 69 | 0.00 | 0 | 69 | 0.00 | |
job_queue_processes free list latch | 140 | 0.00 | 0 | 0 | ||
job_queue_processes parameter latch | 851 | 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 | ||
kgnfs mount latch | 1 | 0.00 | 0 | 0 | ||
kokc descriptor allocation latch | 392 | 0.00 | 0 | 0 | ||
ksfv messages | 1 | 0.00 | 0 | 0 | ||
ksim group membership cache | 1 | 0.00 | 0 | 0 | ||
kss move lock | 41 | 0.00 | 0 | 0 | ||
ksuosstats global area | 363 | 0.00 | 0 | 0 | ||
ksv allocation latch | 143 | 0.00 | 0 | 0 | ||
ksv class latch | 81 | 0.00 | 0 | 0 | ||
ksv msg queue latch | 1 | 0.00 | 0 | 0 | ||
ksz_so allocation latch | 150,132 | 0.05 | 0.04 | 0 | 0 | |
ktm global data | 60 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 130 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 34,354 | 0.00 | 0 | 0 | ||
list of block allocation | 46,560 | 0.01 | 0.00 | 0 | 0 | |
loader state object freelist | 54 | 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 | 99 | 0.00 | 0 | 4 | 0.00 | |
managed standby latch | 97 | 0.00 | 0 | 0 | ||
mapped buffers lru chain | 1 | 0.00 | 0 | 0 | ||
message pool operations parent latch | 25 | 0.00 | 0 | 0 | ||
messages | 233,797 | 0.02 | 0.00 | 0 | 0 | |
mostly latch-free SCN | 34,638 | 0.14 | 0.00 | 0 | 0 | |
msg queue latch | 1 | 0.00 | 0 | 0 | ||
multiblock read objects | 36,778 | 0.00 | 0 | 0 | ||
name-service namespace bucket | 1 | 0.00 | 0 | 0 | ||
ncodef allocation latch | 63 | 0.00 | 0 | 0 | ||
object queue header heap | 89,048 | 0.00 | 0 | 141 | 0.00 | |
object queue header operation | 173,274 | 0.00 | 0.00 | 0 | 0 | |
object stats modification | 3 | 0.00 | 0 | 0 | ||
parallel query alloc buffer | 721 | 0.00 | 0 | 0 | ||
parallel query stats | 1 | 0.00 | 0 | 0 | ||
parameter list | 1,162 | 0.00 | 0 | 0 | ||
parameter table management | 301,992 | 0.08 | 0.15 | 0 | 0 | |
peshm | 1 | 0.00 | 0 | 0 | ||
pesom_free_list | 1 | 0.00 | 0 | 0 | ||
pesom_hash_node | 1 | 0.00 | 0 | 0 | ||
post/wait queue | 44,715 | 0.11 | 0.00 | 0 | 30,559 | 0.02 |
process allocation | 150,270 | 4.00 | 1.04 | 51 | 74,960 | 0.16 |
process group creation | 150,132 | 0.03 | 0.00 | 0 | 0 | |
process queue | 1 | 0.00 | 0 | 0 | ||
process queue reference | 1 | 0.00 | 0 | 0 | ||
qmn task queue latch | 521 | 0.00 | 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 | 198,773 | 0.01 | 0.00 | 0 | 61,524 | 0.11 |
redo copy | 1 | 0.00 | 0 | 61,550 | 0.21 | |
redo writing | 116,442 | 0.01 | 0.00 | 0 | 0 | |
reservation so alloc latch | 2 | 0.00 | 0 | 0 | ||
resmgr group change latch | 75,075 | 0.00 | 0.00 | 0 | 0 | |
resmgr:active threads | 150,269 | 0.00 | 0 | 0 | ||
resmgr:actses change group | 75,030 | 0.00 | 0 | 0 | ||
resmgr:actses change state | 1 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 150,268 | 1.22 | 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 | 26,759,785 | 0.21 | 0.00 | 0 | 107 | 0.00 |
rules engine rule set statistics | 100 | 0.00 | 0 | 0 | ||
second Audit Vault latch | 1 | 0.00 | 0 | 0 | ||
second spare latch | 1 | 0.00 | 0 | 0 | ||
sequence cache | 317,677 | 0.69 | 0.00 | 0 | 0 | |
session allocation | 452,885 | 0.02 | 0.00 | 0 | 302,682 | 0.01 |
session idle bit | 1,445,459 | 0.00 | 0.00 | 0 | 0 | |
session queue latch | 1 | 0.00 | 0 | 0 | ||
session state list latch | 150,198 | 1.67 | 0.00 | 0 | 0 | |
session switching | 75,117 | 0.02 | 0.00 | 0 | 0 | |
session timer | 1,208 | 0.00 | 0 | 0 | ||
shared pool | 6,942,751 | 1.03 | 0.07 | 4 | 0 | |
shared pool sim alloc | 1 | 0.00 | 0 | 0 | ||
shared pool simulator | 97,558 | 0.05 | 0.16 | 0 | 0 | |
sim partition latch | 1 | 0.00 | 0 | 0 | ||
simulator hash latch | 59,357,897 | 0.00 | 0.00 | 0 | 0 | |
simulator lru latch | 4,997 | 0.06 | 0.00 | 0 | 33,184,172 | 0.63 |
sort extent pool | 1,070 | 0.00 | 0 | 0 | ||
space background state object latch | 10 | 0.00 | 0 | 0 | ||
space background task latch | 5,233 | 1.18 | 0.00 | 0 | 2,407 | 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 | 174 | 0.00 | 0 | 0 | ||
transaction allocation | 61,333 | 0.00 | 0.00 | 0 | 0 | |
transaction branch allocation | 2,217 | 0.14 | 0.00 | 0 | 0 | |
undo global data | 180,320 | 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 |
---|---|---|---|---|
cache buffers chains | 627,378,312 | 2,099,331 | 55 | 2,099,284 |
shared pool | 6,942,751 | 71,384 | 4,782 | 67,136 |
row cache objects | 26,759,785 | 55,150 | 213 | 54,943 |
process allocation | 150,270 | 6,012 | 6,282 | 263 |
session state list latch | 150,198 | 2,501 | 5 | 2,496 |
resmgr:free threads list | 150,268 | 1,830 | 5 | 1,825 |
dummy allocation | 150,269 | 1,557 | 9 | 1,548 |
call allocation | 226,107 | 1,209 | 762 | 489 |
enqueue hash chains | 670,801 | 431 | 3 | 428 |
active service list | 458,206 | 388 | 16 | 372 |
parameter table management | 301,992 | 255 | 37 | 219 |
ksz_so allocation latch | 150,132 | 80 | 3 | 77 |
shared pool simulator | 97,558 | 44 | 7 | 37 |
In memory undo latch | 174,192 | 24 | 23 | 2 |
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
In memory undo latch | ktiFlush: child | 0 | 19 | 20 |
In memory undo latch | kticmt: child | 0 | 4 | 0 |
In memory undo latch | ktichg: child | 0 | 1 | 4 |
active service list | kswslogon: session logout | 0 | 27 | 16 |
active service list | kswsite: service iterator | 0 | 1 | 0 |
cache buffers chains | kcbgtcr: fast path (cr pin) | 0 | 16 | 10 |
cache buffers chains | kcbchg1: mod cr pin | 0 | 14 | 5 |
cache buffers chains | kcbgcur: fast path (shr) | 0 | 10 | 3 |
cache buffers chains | kcbgtcr: fast path | 0 | 6 | 1 |
cache buffers chains | kcbzwb | 0 | 6 | 3 |
cache buffers chains | kcbrls_2 | 0 | 5 | 13 |
cache buffers chains | kcbgtcr_2 | 0 | 4 | 5 |
cache buffers chains | kcbgcur_2 | 0 | 3 | 4 |
cache buffers chains | kcbrls: fast release | 0 | 1 | 5 |
call allocation | ksuxds | 0 | 612 | 399 |
call allocation | ksudlp: top call | 0 | 146 | 185 |
call allocation | ksucrp: top call | 0 | 3 | 175 |
call allocation | ksuprc | 0 | 1 | 1 |
dummy allocation | ktcscnfy | 0 | 9 | 9 |
enqueue hash chains | ksqrcl | 0 | 2 | 1 |
enqueue hash chains | ksqgtl3 | 0 | 1 | 1 |
ksz_so allocation latch | ksz_parent_so_del1 | 0 | 3 | 3 |
parameter table management | ksp_param_table_free | 0 | 44 | 2 |
parameter table management | kspcpy | 0 | 4 | 1 |
process allocation | ksucrp:1 | 0 | 4,039 | 0 |
process allocation | ksudlp | 0 | 1,767 | 2,268 |
process allocation | ksuapc | 0 | 475 | 4,013 |
resmgr:free threads list | kskthrcreate | 0 | 5 | 5 |
row cache objects | kqreqd: reget | 0 | 121 | 9 |
row cache objects | kqrpre: find obj | 0 | 59 | 98 |
row cache objects | kqreqd | 0 | 33 | 106 |
session state list latch | kpseqa | 0 | 3 | 4 |
session state list latch | kpseqd | 0 | 2 | 1 |
shared pool | kghalo | 0 | 4,406 | 4,055 |
shared pool | kghalp | 0 | 143 | 131 |
shared pool | kghupr1 | 0 | 142 | 373 |
shared pool | kghfre | 0 | 66 | 209 |
shared pool | kgh_heap_sizes | 0 | 16 | 10 |
shared pool | kghasp | 0 | 9 | 4 |
shared pool simulator | kglsim_upd_newhp | 0 | 7 | 7 |
Mutex Type | Location | Sleeps | Wait Time (ms) |
---|---|---|---|
Library Cache | kglget1 1 | 43,204 | 0 |
Library Cache | kglhdgn2 106 | 41,803 | 0 |
Library Cache | kgllkdl1 85 | 32,161 | 0 |
Library Cache | kglpndl1 95 | 3,497 | 0 |
Library Cache | kglpin1 4 | 2,913 | 0 |
Library Cache | kglhdgn1 62 | 1,890 | 0 |
Library Cache | kgldtin1 42 | 1,753 | 0 |
Library Cache | kglhdgh1 64 | 1,041 | 0 |
Library Cache | kglpnal1 90 | 950 | 0 |
Cursor Pin | kkslce [KKSCHLPIN2] | 445 | 0 |
Library Cache | kgllkc1 57 | 360 | 0 |
Library Cache | kglget2 2 | 20 | 0 |
Cursor Pin | kksfbc [KKSCHLFSP2] | 20 | 0 |
Library Cache | kglobpn1 71 | 16 | 0 |
Library Cache | kglrfcl1 79 | 11 | 0 |
Cursor Pin | kksfbc [KKSCHLPIN1] | 10 | 0 |
Library Cache | kglGetHandleReference 124 | 6 | 0 |
Cursor Pin | kksLockDelete [KKSCHLPIN6] | 5 | 0 |
Library Cache | kglhdgc1 102 | 1 | 0 |
Library Cache | kglini1 32 | 1 | 0 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | F_PAR | TABLE | 231,294,208 | 73.75 | |
USERCENTER | USERCENTER20120220_DATA | SMS_SEND_ENT | TABLE | 32,732,144 | 10.44 | |
USERCENTER | USERCENTER20120220_DATA | SMS_MASS | TABLE | 23,635,328 | 7.54 | |
USERCENTER | USERCENTER20120220_DATA | SMS_SEND_AH | TABLE | 11,015,856 | 3.51 | |
SYS | SYSTEM | I_SYSAUTH1 | INDEX | 3,612,912 | 1.15 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | F_PAR | TABLE | 18,666 | 14.03 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_JSHM_TJSJ | INDEX | 145 | 0.11 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_FFHM_TJSJ | INDEX | 89 | 0.07 | |
USERCENTER | USERCENTER20120220_DATA | SMS_SEND | TABLE | 45 | 0.03 | |
USERCENTER | USERCENTER20120220_DATA | T_LOCATION_INFO | TABLE | 34 | 0.03 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Read Requests | %Total |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | F_PAR | TABLE | 18,428 | 78.92 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_JSHM_TJSJ | INDEX | 145 | 0.62 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_FFHM_TJSJ | INDEX | 89 | 0.38 | |
USERCENTER | USERCENTER20120220_DATA | SMS_SEND | TABLE | 45 | 0.19 | |
USERCENTER | USERCENTER20120220_DATA | T_LOCATION_INFO | TABLE | 34 | 0.15 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | UnOptimized Reads | %Total |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | F_PAR | TABLE | 18,428 | 78.92 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_JSHM_TJSJ | INDEX | 145 | 0.62 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_FFHM_TJSJ | INDEX | 89 | 0.38 | |
USERCENTER | USERCENTER20120220_DATA | SMS_SEND | TABLE | 45 | 0.19 | |
USERCENTER | USERCENTER20120220_DATA | T_LOCATION_INFO | TABLE | 34 | 0.15 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Writes | %Total |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | T_LOCATION_INFO | TABLE | 2,140 | 0.90 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_JSHM_TJSJ | INDEX | 1,168 | 0.49 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_FFHM_TJSJ | INDEX | 1,042 | 0.44 | |
USERCENTER | USERCENTER20120220_DATA | SMS_SEND | TABLE | 342 | 0.14 | |
USERCENTER | USERCENTER20120220_DATA | T_USER | TABLE | 323 | 0.14 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Write Requests | %Total |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | T_LOCATION_INFO | TABLE | 1,452 | 8.29 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_JSHM_TJSJ | INDEX | 1,093 | 6.24 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_FFHM_TJSJ | INDEX | 989 | 5.64 | |
USERCENTER | USERCENTER20120220_DATA | SMS_SEND | TABLE | 304 | 1.73 | |
USERCENTER | USERCENTER20120220_DATA | T_USER | TABLE | 296 | 1.69 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Writes | %Total |
---|---|---|---|---|---|---|
SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_2877231475_4085 | TABLE PARTITION | 21 | 0.01 |
SYS | SYSAUX | SYS_LOB0000006339C00038$$ | LOB | 20 | 0.01 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Table Scans | %Total |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | F_PAR | TABLE | 3,028 | 98.99 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | DB Block Changes | % of Capture |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | T_LOCATION_INFO | TABLE | 27,472 | 39.35 | |
SYS | SYSTEM | SEQ$ | TABLE | 19,872 | 28.47 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_JSHM_TJSJ | INDEX | 4,672 | 6.69 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_FFHM_TJSJ | INDEX | 4,352 | 6.23 | |
USERCENTER | USERCENTER20120220_DATA | SMS_SEND_ENT | TABLE | 2,800 | 4.01 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | T_FEE | TABLE | 98 | 67.12 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_FFHM_TJSJ | INDEX | 44 | 30.14 | |
SYS | SYSAUX | WRH$_SERVICE_STAT_PK | WRH$_SERVIC_2877231475_4085 | INDEX PARTITION | 2 | 1.37 |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_JSHM_TJSJ | INDEX | 1 | 0.68 | |
USERCENTER | USERCENTER20120220_DATA | SMS_RECV | TABLE | 1 | 0.68 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | ITL Waits | % of Capture |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_FFHM_TJSJ | INDEX | 2 | 100.00 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
---|---|---|---|---|---|---|
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_FFHM_TJSJ | INDEX | 101 | 73.19 | |
USERCENTER | USERCENTER20120220_DATA | SMS_SEND_XW | TABLE | 27 | 19.57 | |
USERCENTER | USERCENTER20120220_DATA | F_PAR | TABLE | 2 | 1.45 | |
USERCENTER | USERCENTER20120220_DATA | SMS_SEND | TABLE | 2 | 1.45 | |
USERCENTER | USERCENTER20120220_DATA | PRI_SMS_SEND_JSHM_TJSJ | INDEX | 1 | 0.72 |
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
---|---|---|---|---|---|---|
dc_awr_control | 65 | 0.00 | 0 | 2 | 1 | |
dc_files | 10 | 0.00 | 0 | 0 | 10 | |
dc_global_oids | 420 | 0.00 | 0 | 0 | 52 | |
dc_histogram_data | 487,357 | 0.00 | 0 | 0 | 2,790 | |
dc_histogram_defs | 332,743 | 0.01 | 0 | 0 | 3,271 | |
dc_object_grants | 131 | 0.00 | 0 | 0 | 13 | |
dc_objects | 262,973 | 0.01 | 0 | 5 | 2,212 | |
dc_profiles | 75,009 | 0.00 | 0 | 0 | 1 | |
dc_rollback_segments | 31,350 | 0.00 | 0 | 0 | 704 | |
dc_segments | 161,727 | 0.01 | 0 | 13 | 1,110 | |
dc_sequences | 1,505 | 0.40 | 0 | 1,505 | 29 | |
dc_tablespaces | 2,275,474 | 0.00 | 0 | 0 | 11 | |
dc_users | 6,740,294 | 0.00 | 0 | 0 | 129 | |
global database name | 77,424 | 0.00 | 0 | 0 | 1 | |
outstanding_alerts | 42 | 0.00 | 0 | 0 | 7 | |
sch_lj_oids | 5 | 0.00 | 0 | 0 | 16 |
Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
---|---|---|---|---|---|---|
ACCOUNT_STATUS | 149,879 | 0.00 | 0 | 0 | 0 | |
BODY | 1,962 | 0.15 | 2,590 | 0.27 | 3 | 0 |
CLUSTER | 8 | 12.50 | 8 | 12.50 | 0 | 0 |
DBLINK | 150,124 | 0.00 | 0 | 0 | 0 | |
EDITION | 75,024 | 0.00 | 150,033 | 0.00 | 0 | 0 |
INDEX | 6 | 50.00 | 6 | 50.00 | 0 | 0 |
QUEUE | 77 | 0.00 | 235 | 0.00 | 0 | 0 |
SCHEMA | 75,034 | 0.00 | 0 | 0 | 0 | |
SQL AREA | 561,915 | 4.71 | 1,332,355 | 8.46 | 31,511 | 12 |
SQL AREA BUILD | 58,071 | 47.84 | 0 | 0 | 0 | |
SQL AREA STATS | 27,717 | 99.29 | 27,716 | 99.29 | 0 | 0 |
SUBSCRIPTION | 8 | 0.00 | 8 | 0.00 | 0 | 0 |
TABLE/PROCEDURE | 140,170 | 0.01 | 410,538 | 0.08 | 287 | 0 |
TRIGGER | 1,922 | 0.00 | 4,734 | 0.15 | 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 | 997.57 | 1.44 | 2.27 | 27 | 339 | 691 | 691 | |
B | Freeable | 256.38 | 0.00 | 1.04 | 0.68 | 9 | 247 | 247 | |
B | PL/SQL | 7.47 | 5.47 | 0.01 | 0.02 | 0 | 1 | 689 | 689 |
B | SQL | 5.00 | 2.24 | 0.01 | 0.01 | 0 | 3,097 | 671 | 450 |
E | Other | 1,012.58 | 1.43 | 2.25 | 27 | 339 | 706 | 706 | |
E | Freeable | 267.56 | 0.00 | 1.03 | 0.66 | 9 | 261 | 261 | |
E | PL/SQL | 7.27 | 5.28 | 0.01 | 0.02 | 0 | 1 | 704 | 704 |
E | SQL | 4.74 | 2.15 | 0.01 | 0.01 | 0 | 3,097 | 686 | 443 |
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 | 485.50 | 514.43 | 5.96 |
shared | KGLHD | 79.31 | 85.37 | 7.63 |
shared | SQLA | 2,028.81 | 2,029.58 | 0.04 |
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,247.66 | 1,209.07 | -3.09 |
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 Slaves | 0803 10:21:23 | 0.04 | 0.00 | 0.00 |
QMON Coordinator | 0803 10:21:13 | 0.00 | 0.00 | 0.00 |
Queue Name | Enq Msgs | Deq Msgs | %Exp Msgs | %Delay Msgs | Enq Time(s) | Deq Time(s) | %Transf Time | %Eval Time |
---|---|---|---|---|---|---|---|---|
SYS.ALERT_QUE(12733) | 0 | 0 | 0.00 | 0.00 | ||||
SYS.AQ$_ALERT_QT_E(12732) | 2 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
SYSMAN.MGMT_TASK_Q(68711) | 62 | 62 | 0.00 | 0.00 | 0.01 | 0.06 | 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 | ||
SYS.AQ$_ALERT_QT_E(12732) | 0.00 | 0.00 | 0.00 | |
SYSMAN.MGMT_TASK_Q(68711) | 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 |
---|---|---|---|---|---|---|
HAE_SUB(1)/SYS.ALERT_QUE | 0 | 0 | 0 | |||
LOCALHOST_LOC_3938_JQHX(41)/SYS.ALERT_QUE | 0 | 0 | 2 | 0.00 | 0.00 | 0.00 |
Avg Total Connections | Avg Active Connections | Avg Total Shared Srvrs | Avg Active Shared Srvrs | Avg Total Dispatchers | Avg Active Dispatchers |
---|---|---|---|---|---|
0 | 0 | 1 | 0 | 1 | 0 |
Common Queue Per Sec | Disp Queue Per Sec | Server Msgs/Sec | Server KB/Sec | Common Queue Total | Disp Queue Total | Server Total Msgs | Server Total(KB) |
---|---|---|---|---|---|---|---|
0 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 |
Total Server Time (s) | %Busy | %Idle | Incoming Net % | Outgoing Net % |
---|---|---|---|---|
3,604 | 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,604 | 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 |