DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
---|---|---|---|---|---|---|
ORCL | 1306904245 | orcl | 1 | 22-Aug-12 12:08 | 11.2.0.3.0 | NO |
Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
---|---|---|---|---|---|
1AXDXPL14WV0L1 | Microsoft Windows IA (32-bit) | 2 | 2 | 1 | 3.45 |
Snap Id | Snap Time | Sessions | Cursors/Session | |
---|---|---|---|---|
Begin Snap: | 80 | 22-Aug-12 13:04:36 | 22 | 1.7 |
End Snap: | 81 | 22-Aug-12 13:07:19 | 24 | 1.4 |
Elapsed: | 2.72 (mins) | |||
DB Time: | 6.58 (mins) |
Begin | End | |||
---|---|---|---|---|
Buffer Cache: | 424M | 424M | Std Block Size: | 8K |
Shared Pool Size: | 264M | 264M | Log Buffer: | 5,124K |
Per Second | Per Transaction | Per Exec | Per Call | |
---|---|---|---|---|
DB Time(s): | 2.4 | 0.0 | 0.00 | 0.00 |
DB CPU(s): | 0.7 | 0.0 | 0.00 | 0.00 |
Redo size: | 980,863.8 | 500.8 | ||
Logical reads: | 14,047.0 | 7.2 | ||
Block changes: | 7,883.5 | 4.0 | ||
Physical reads: | 0.6 | 0.0 | ||
Physical writes: | 29.6 | 0.0 | ||
User calls: | 7,834.7 | 4.0 | ||
Parses: | 4.7 | 0.0 | ||
Hard parses: | 0.4 | 0.0 | ||
W/A MB processed: | 0.2 | 0.0 | ||
Logons: | 0.1 | 0.0 | ||
Executes: | 1,972.9 | 1.0 | ||
Rollbacks: | 0.0 | 0.0 | ||
Transactions: | 1,958.6 |
Buffer Nowait %: | 99.96 | Redo NoWait %: | 99.99 |
Buffer Hit %: | 100.00 | In-memory Sort %: | 100.00 |
Library Hit %: | 100.15 | Soft Parse %: | 92.50 |
Execute to Parse %: | 99.76 | Latch Hit %: | 99.61 |
Parse CPU to Parse Elapsd %: | 78.07 | % Non-Parse CPU: | 95.98 |
Begin | End | |
---|---|---|
Memory Usage %: | 51.73 | 52.58 |
% SQL with executions>1: | 76.24 | 83.24 |
% Memory for SQL w/exec>1: | 60.84 | 70.91 |
Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
---|---|---|---|---|---|
log file sync | 320,008 | 289 | 1 | 73.13 | Commit |
DB CPU | 109 | 27.56 | |||
SQL*Net message to client | 640,097 | 2 | 0 | 0.43 | Network |
log file switch completion | 12 | 1 | 70 | 0.21 | Configuration |
Disk file operations I/O | 25 | 0 | 17 | 0.11 | User I/O |
Load Average Begin | Load Average End | %User | %System | %WIO | %Idle |
---|---|---|---|---|---|
38.6 | 34.0 | 27.4 |
%Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) |
---|---|---|
42.8 | 59.0 | 0.0 |
Begin | End | |
---|---|---|
Host Mem (MB): | 3,535.8 | 3,535.8 |
SGA use (MB): | 736.0 | 736.0 |
PGA use (MB): | 32.6 | 32.3 |
% Host Mem used for SGA+PGA: | 21.74 | 21.73 |
Statistic Name | Time (s) | % of DB Time |
---|---|---|
DB CPU | 108.88 | 27.56 |
sql execute elapsed time | 32.76 | 8.29 |
parse time elapsed | 11.27 | 2.85 |
hard parse elapsed time | 0.13 | 0.03 |
hard parse (sharing criteria) elapsed time | 0.13 | 0.03 |
PL/SQL execution elapsed time | 0.12 | 0.03 |
connection management call elapsed time | 0.02 | 0.00 |
PL/SQL compilation elapsed time | 0.00 | 0.00 |
repeated bind elapsed time | 0.00 | 0.00 |
DB time | 395.09 | |
background elapsed time | 144.77 | |
background cpu time | 30.92 |
Statistic | Value | End Value |
---|---|---|
AVG_BUSY_TIME | 11,843 | |
AVG_IDLE_TIME | 4,467 | |
AVG_SYS_TIME | 5,545 | |
AVG_USER_TIME | 6,295 | |
BUSY_TIME | 23,699 | |
IDLE_TIME | 8,945 | |
SYS_TIME | 11,101 | |
USER_TIME | 12,598 | |
PHYSICAL_MEMORY_BYTES | 3,707,600,896 | |
NUM_CPUS | 2 | |
NUM_CPU_CORES | 2 | |
NUM_CPU_SOCKETS | 1 | |
TCP_RECEIVE_SIZE_MAX | 64,512 |
Snap Time | Load | %busy | %user | %sys | %idle | %iowait |
---|---|---|---|---|---|---|
22-Aug 13:04:36 | 0.00 | |||||
22-Aug 13:07:19 | 0.00 | 72.60 | 38.59 | 34.01 | 27.40 | 0.00 |
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %DB time |
---|---|---|---|---|---|
Commit | 320,008 | 0 | 289 | 1 | 73.13 |
DB CPU | 109 | 27.56 | |||
Network | 640,097 | 0 | 2 | 0 | 0.43 |
Configuration | 18 | 0 | 1 | 68 | 0.31 |
User I/O | 69 | 0 | 1 | 10 | 0.18 |
Concurrency | 2,421 | 0 | 0 | 0 | 0.10 |
System I/O | 134 | 0 | 0 | 2 | 0.06 |
Other | 204 | 0 | 0 | 0 | 0.01 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % DB time |
---|---|---|---|---|---|---|
log file sync | 320,008 | 0 | 289 | 1 | 1.00 | 73.13 |
SQL*Net message to client | 640,097 | 0 | 2 | 0 | 2.00 | 0.43 |
log file switch completion | 12 | 0 | 1 | 70 | 0.00 | 0.21 |
Disk file operations I/O | 25 | 0 | 0 | 17 | 0.00 | 0.11 |
log file switch (checkpoint incomplete) | 6 | 0 | 0 | 64 | 0.00 | 0.10 |
control file sequential read | 134 | 0 | 0 | 2 | 0.00 | 0.06 |
library cache lock | 3 | 0 | 0 | 74 | 0.00 | 0.06 |
db file sequential read | 29 | 0 | 0 | 6 | 0.00 | 0.04 |
db file scattered read | 15 | 0 | 0 | 8 | 0.00 | 0.03 |
latch: In memory undo latch | 1,433 | 0 | 0 | 0 | 0.00 | 0.01 |
buffer busy waits | 821 | 0 | 0 | 0 | 0.00 | 0.01 |
cursor: pin S wait on X | 2 | 0 | 0 | 14 | 0.00 | 0.01 |
cursor: pin S | 34 | 0 | 0 | 1 | 0.00 | 0.00 |
library cache: mutex X | 3 | 0 | 0 | 5 | 0.00 | 0.00 |
enq: TX - contention | 17 | 0 | 0 | 1 | 0.00 | 0.00 |
latch: enqueue hash chains | 47 | 0 | 0 | 0 | 0.00 | 0.00 |
latch free | 103 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: cache buffers chains | 125 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: undo global data | 14 | 0 | 0 | 0 | 0.00 | 0.00 |
jobq slave wait | 360 | 100 | 180 | 500 | 0.00 | |
SQL*Net message from client | 640,097 | 0 | 154 | 0 | 2.00 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
---|---|---|---|---|---|---|
log file parallel write | 189,075 | 0 | 104 | 1 | 0.59 | 72.18 |
db file parallel write | 559 | 0 | 3 | 5 | 0.00 | 2.02 |
control file sequential read | 217 | 0 | 1 | 7 | 0.00 | 0.98 |
control file parallel write | 139 | 0 | 1 | 5 | 0.00 | 0.52 |
db file async I/O submit | 310 | 0 | 1 | 2 | 0.00 | 0.35 |
os thread startup | 8 | 0 | 0 | 32 | 0.00 | 0.17 |
direct path read | 11 | 0 | 0 | 15 | 0.00 | 0.11 |
log file sequential read | 10 | 0 | 0 | 11 | 0.00 | 0.07 |
LGWR wait for redo copy | 2,689 | 0 | 0 | 0 | 0.01 | 0.04 |
direct path write | 5 | 0 | 0 | 6 | 0.00 | 0.02 |
db file sequential read | 2 | 0 | 0 | 9 | 0.00 | 0.01 |
log file single write | 10 | 0 | 0 | 1 | 0.00 | 0.01 |
reliable message | 50 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: redo allocation | 25 | 0 | 0 | 0 | 0.00 | 0.00 |
rdbms ipc message | 73,752 | 1 | 1,651 | 22 | 0.23 | |
Space Manager: slave idle wait | 71 | 87 | 328 | 4621 | 0.00 | |
DIAG idle wait | 327 | 100 | 327 | 1000 | 0.00 | |
smon timer | 10 | 0 | 323 | 32334 | 0.00 | |
shared server idle wait | 6 | 100 | 180 | 30010 | 0.00 | |
dispatcher timer | 3 | 100 | 180 | 60010 | 0.00 | |
pmon timer | 56 | 95 | 164 | 2927 | 0.00 | |
Streams AQ: qmn slave idle wait | 5 | 0 | 140 | 28009 | 0.00 | |
Streams AQ: qmn coordinator idle wait | 9 | 56 | 140 | 15561 | 0.00 | |
SQL*Net message from client | 20 | 0 | 0 | 1 | 0.00 |
% of Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Total Waits | <1ms | <2ms | <4ms | <8ms | <16ms | <32ms | <=1s | >1s |
Disk file operations I/O | 26 | 19.2 | 15.4 | 19.2 | 15.4 | 11.5 | 19.2 | ||
LGWR wait for redo copy | 2689 | 100.0 | .0 | ||||||
SQL*Net message to client | 640.1K | 100.0 | |||||||
asynch descriptor resize | 13 | 100.0 | |||||||
buffer busy waits | 822 | 100.0 | |||||||
control file parallel write | 139 | 33.8 | 39.6 | 12.9 | 5.0 | 7.2 | 1.4 | ||
control file sequential read | 351 | 42.2 | 24.2 | 12.0 | 6.3 | 11.4 | 3.4 | .6 | |
cursor: pin S | 34 | 94.1 | 2.9 | 2.9 | |||||
cursor: pin S wait on X | 2 | 100.0 | |||||||
db file async I/O submit | 310 | 84.8 | 5.8 | .3 | 1.0 | 6.5 | 1.3 | .3 | |
db file parallel write | 559 | 27.2 | 19.0 | 22.0 | 20.2 | 5.7 | 3.6 | 2.3 | |
db file scattered read | 12 | 8.3 | 8.3 | 16.7 | 16.7 | 41.7 | 8.3 | ||
db file sequential read | 28 | 21.4 | 14.3 | 7.1 | 17.9 | 28.6 | 10.7 | ||
direct path read | 11 | 9.1 | 27.3 | 18.2 | 45.5 | ||||
direct path write | 5 | 20.0 | 20.0 | 40.0 | 20.0 | ||||
enq: FB - contention | 5 | 100.0 | |||||||
enq: TX - contention | 17 | 82.4 | 17.6 | ||||||
latch free | 108 | 100.0 | |||||||
latch: In memory undo latch | 1433 | 100.0 | |||||||
latch: cache buffers chains | 125 | 100.0 | |||||||
latch: enqueue hash chains | 47 | 100.0 | |||||||
latch: messages | 19 | 100.0 | |||||||
latch: redo allocation | 25 | 100.0 | |||||||
latch: session allocation | 1 | 100.0 | |||||||
latch: undo global data | 14 | 100.0 | |||||||
library cache lock | 3 | 100.0 | |||||||
library cache: mutex X | 3 | 66.7 | 33.3 | ||||||
log file parallel write | 189.1K | 97.3 | 1.6 | .6 | .3 | .1 | .1 | .1 | |
log file sequential read | 10 | 10.0 | 10.0 | 20.0 | 20.0 | 20.0 | 20.0 | ||
log file single write | 10 | 70.0 | 20.0 | 10.0 | |||||
log file switch (checkpoint incomplete) | 6 | 33.3 | 66.7 | ||||||
log file switch completion | 12 | 100.0 | |||||||
log file sync | 320K | 92.1 | 5.5 | 1.1 | .6 | .4 | .2 | .1 | |
os thread startup | 8 | 62.5 | 37.5 | ||||||
reliable message | 50 | 98.0 | 2.0 | ||||||
DIAG idle wait | 326 | 100.0 | |||||||
SQL*Net message from client | 640.1K | 99.6 | .3 | .1 | .0 | .0 | .0 | ||
Space Manager: slave idle wait | 72 | 1.4 | 1.4 | 2.8 | 94.4 | ||||
Streams AQ: qmn coordinator idle wait | 9 | 44.4 | 55.6 | ||||||
Streams AQ: qmn slave idle wait | 5 | 100.0 | |||||||
class slave wait | 2 | 100.0 | |||||||
dispatcher timer | 3 | 100.0 | |||||||
jobq slave wait | 359 | 100.0 | |||||||
pmon timer | 56 | 100.0 | |||||||
rdbms ipc message | 73.8K | 98.7 | .2 | .0 | .0 | .0 | .0 | .5 | .6 |
shared server idle wait | 6 | 100.0 | |||||||
smon timer | 10 | 60.0 | 40.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 | 5 | 80.8 | 15.4 | 3.8 | |||||
control file parallel write | 2 | 98.6 | .7 | .7 | |||||
control file sequential read | 2 | 99.4 | .3 | .3 | |||||
db file async I/O submit | 1 | 99.7 | .3 | ||||||
db file parallel write | 13 | 97.7 | 1.6 | .5 | .2 | ||||
library cache lock | 3 | 33.3 | 66.7 | ||||||
log file parallel write | 106 | 99.9 | .0 | .0 | .0 | .0 | |||
log file switch (checkpoint incomplete) | 4 | 33.3 | 66.7 | ||||||
log file switch completion | 12 | 66.7 | 33.3 | ||||||
log file sync | 480 | 99.9 | .1 | .0 | .0 | .0 | .0 | ||
os thread startup | 3 | 62.5 | 37.5 |
Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) |
---|---|---|---|---|
SYS$USERS | 395 | 109 | 0 | 2,292 |
SYS$BACKGROUND | 0 | 0 | 0 | 3 |
orcl.usf.ad.usfood.local | 0 | 0 | 0 | 0 |
orclXDB | 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 | 69 | 1 | 2421 | 0 | 0 | 0 | 640097 | 2 |
SYS$BACKGROUND | 18 | 0 | 9 | 0 | 0 | 0 | 0 | 0 |
Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
0.39 | 1 | 0.39 | 0.10 | 51.67 | 45.93 | 1uk5m5qbzj1vt | SQL*Plus | BEGIN dbms_workload_repository... |
0.34 | 1 | 0.34 | 0.09 | 95.52 | 0.00 | dayq182sk41ks | insert into wrh$_memory_target... | |
0.34 | 1 | 0.34 | 0.09 | 95.66 | 0.00 | bm2pwrpcr8ru6 | select sga_size s, sga_size_fa... | |
0.34 | 1 | 0.34 | 0.09 | 101.95 | 0.00 | bunssq950snhf | insert into wrh$_sga_target_ad... | |
0.27 | 3 | 0.09 | 0.07 | 46.65 | 36.35 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
0.25 | 5 | 0.05 | 0.06 | 6.28 | 47.67 | 2ts960gft6nsd | SQL*Plus | select name n from v$database |
0.13 | 1 | 0.13 | 0.03 | 11.87 | 95.08 | 350myuyx0t1d6 | insert into wrh$_tablespace_st... | |
0.10 | 13 | 0.01 | 0.02 | 0.00 | 97.78 | 18naypzfmabd6 | EM_PING | INSERT INTO MGMT_SYSTEM_PERFOR... |
0.08 | 548 | 0.00 | 0.02 | 57.18 | 21.55 | 3c1kubcdjnppq | update sys.col_usage$ set equa... | |
0.07 | 1 | 0.07 | 0.02 | 66.82 | 45.58 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... |
CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
0.34 | 1 | 0.34 | 0.32 | 0.34 | 101.95 | 0.00 | bunssq950snhf | insert into wrh$_sga_target_ad... | |
0.33 | 1 | 0.33 | 0.30 | 0.34 | 95.66 | 0.00 | bm2pwrpcr8ru6 | select sga_size s, sga_size_fa... | |
0.33 | 1 | 0.33 | 0.30 | 0.34 | 95.52 | 0.00 | dayq182sk41ks | insert into wrh$_memory_target... | |
0.20 | 1 | 0.20 | 0.19 | 0.39 | 51.67 | 45.93 | 1uk5m5qbzj1vt | SQL*Plus | BEGIN dbms_workload_repository... |
0.13 | 3 | 0.04 | 0.11 | 0.27 | 46.65 | 36.35 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
0.05 | 548 | 0.00 | 0.04 | 0.08 | 57.18 | 21.55 | 3c1kubcdjnppq | update sys.col_usage$ set equa... | |
0.05 | 1 | 0.05 | 0.04 | 0.03 | 142.30 | 0.00 | 5dfmd823r8dsp | insert into wrh$_memory_resize... | |
0.05 | 1 | 0.05 | 0.04 | 0.07 | 66.82 | 45.58 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
0.02 | 12 | 0.00 | 0.01 | 0.00 | 1098.80 | 0.00 | 08bqjmf8490s2 | SEVERITY EVALUATION | SELECT PARAMETER_VALUE FROM MG... |
0.02 | 1 | 0.02 | 0.01 | 0.01 | 120.98 | 0.00 | 0bdpb49gvdzgg | insert into wrh$_tempstatxs (s... |
User I/O Time (s) | Executions | UIO per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
0.18 | 1 | 0.18 | 19.37 | 0.39 | 51.67 | 45.93 | 1uk5m5qbzj1vt | SQL*Plus | BEGIN dbms_workload_repository... |
0.13 | 1 | 0.13 | 13.43 | 0.13 | 11.87 | 95.08 | 350myuyx0t1d6 | insert into wrh$_tablespace_st... | |
0.12 | 5 | 0.02 | 12.73 | 0.25 | 6.28 | 47.67 | 2ts960gft6nsd | SQL*Plus | select name n from v$database |
0.10 | 3 | 0.03 | 10.45 | 0.27 | 46.65 | 36.35 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
0.09 | 13 | 0.01 | 10.07 | 0.10 | 0.00 | 97.78 | 18naypzfmabd6 | EM_PING | INSERT INTO MGMT_SYSTEM_PERFOR... |
0.06 | 1 | 0.06 | 6.38 | 0.06 | 0.00 | 97.63 | 0z1031991bd7w | insert into wrh$_sysmetric_sum... | |
0.03 | 1 | 0.03 | 3.43 | 0.07 | 66.82 | 45.58 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
0.03 | 1 | 0.03 | 3.21 | 0.03 | 0.00 | 96.41 | 4rcrxkvaqt37f | insert into wrh$_shared_pool_a... | |
0.03 | 66 | 0.00 | 3.21 | 0.03 | 0.00 | 90.39 | 5h7w8ykwtb2xt | INSERT INTO SYS.WRI$_ADV_PARAM... | |
0.03 | 1 | 0.03 | 2.92 | 0.03 | 0.00 | 96.31 | d87cd6s72f197 | insert into wrh$_seg_stat (sna... | |
0.02 | 548 | 0.00 | 1.90 | 0.08 | 57.18 | 21.55 | 3c1kubcdjnppq | update sys.col_usage$ set equa... |
Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
3,179 | 3 | 1,059.67 | 0.14 | 0.27 | 46.6 | 36.3 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
2,235 | 1 | 2,235.00 | 0.10 | 0.39 | 51.7 | 45.9 | 1uk5m5qbzj1vt | SQL*Plus | BEGIN dbms_workload_repository... |
1,854 | 548 | 3.38 | 0.08 | 0.08 | 57.2 | 21.5 | 3c1kubcdjnppq | update sys.col_usage$ set equa... | |
857 | 1 | 857.00 | 0.04 | 0.07 | 66.8 | 45.6 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
642 | 158 | 4.06 | 0.03 | 0.01 | 0 | 0 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
514 | 9 | 57.11 | 0.02 | 0.02 | 84.3 | 0 | 3am9cfkvx7gq1 | CALL MGMT_ADMIN_DATA.EVALUATE_... | |
378 | 39 | 9.69 | 0.02 | 0.01 | 0 | 34.9 | 8vwv6hx92ymmm | UPDATE MGMT_CURRENT_METRICS SE... | |
331 | 112 | 2.96 | 0.01 | 0.01 | 104.3 | 0 | g00cj285jmgsw | update sys.mon_mods$ set inser... | |
240 | 66 | 3.64 | 0.01 | 0.03 | 0 | 90.4 | 5h7w8ykwtb2xt | INSERT INTO SYS.WRI$_ADV_PARAM... | |
201 | 10 | 20.10 | 0.01 | 0.01 | 0 | 0 | 4jrfrtx4u6zcx | SELECT TASK_TGT.TARGET_GUID TA... |
Physical Reads | Executions | Reads per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
58 | 1 | 58.00 | 63.04 | 0.39 | 51.67 | 45.93 | 1uk5m5qbzj1vt | SQL*Plus | BEGIN dbms_workload_repository... |
6 | 1 | 6.00 | 6.52 | 0.03 | 0.00 | 96.31 | d87cd6s72f197 | insert into wrh$_seg_stat (sna... | |
5 | 1 | 5.00 | 5.43 | 0.06 | 0.00 | 97.63 | 0z1031991bd7w | insert into wrh$_sysmetric_sum... | |
3 | 1 | 3.00 | 3.26 | 0.03 | 0.00 | 96.41 | 4rcrxkvaqt37f | insert into wrh$_shared_pool_a... | |
3 | 66 | 0.05 | 3.26 | 0.03 | 0.00 | 90.39 | 5h7w8ykwtb2xt | INSERT INTO SYS.WRI$_ADV_PARAM... | |
3 | 1 | 3.00 | 3.26 | 0.07 | 66.82 | 45.58 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
2 | 548 | 0.00 | 2.17 | 0.08 | 57.18 | 21.55 | 3c1kubcdjnppq | update sys.col_usage$ set equa... | |
0 | 46 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 089dbukv1aanh | EM_PING | SELECT SYS_EXTRACT_UTC(SYSTIME... |
0 | 12 | 0.00 | 0.00 | 0.00 | 1098.80 | 0.00 | 08bqjmf8490s2 | SEVERITY EVALUATION | SELECT PARAMETER_VALUE FROM MG... |
0 | 1 | 0.00 | 0.00 | 0.01 | 120.98 | 0.00 | 0bdpb49gvdzgg | insert into wrh$_tempstatxs (s... |
UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
60 | 60 | 1 | 60.00 | 0.00 | 113.21 | 1uk5m5qbzj1vt | SQL*Plus | BEGIN dbms_workload_repository... |
35 | 35 | 5 | 7.00 | 0.00 | 66.04 | 2ts960gft6nsd | SQL*Plus | select name n from v$database |
32 | 32 | 1 | 32.00 | 0.00 | 60.38 | 1cq3qr774cu45 | insert into WRH$_IOSTAT_FILETY... | |
12 | 12 | 1 | 12.00 | 0.00 | 22.64 | 3jyk0fjp6yjyf | INSERT INTO wrh$_tempfile (sna... | |
7 | 7 | 1 | 7.00 | 0.00 | 13.21 | 35y2u24f4rxqm | insert into wrh$_seg_stat_obj ... | |
7 | 7 | 1 | 7.00 | 0.00 | 13.21 | 934ur8r7tqbjx | SELECT DBID FROM V$DATABASE | |
4 | 4 | 1 | 4.00 | 0.00 | 7.55 | 1tn90bbpyjshq | UPDATE wrh$_tempfile tfh SET (... | |
3 | 3 | 66 | 0.05 | 0.00 | 5.66 | 5h7w8ykwtb2xt | INSERT INTO SYS.WRI$_ADV_PARAM... | |
2 | 2 | 548 | 0.00 | 0.00 | 3.77 | 3c1kubcdjnppq | update sys.col_usage$ set equa... | |
0 | 0 | 46 | 0.00 | 0.00 | 089dbukv1aanh | EM_PING | SELECT SYS_EXTRACT_UTC(SYSTIME... |
Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
548 | 548 | 1.00 | 0.08 | 57.2 | 21.5 | 3c1kubcdjnppq | update sys.col_usage$ set equa... | |
204 | 0 | 0.00 | 0.01 | 0 | 0 | b2gnxm5z6r51n | lock table sys.col_usage$ in e... | |
158 | 421 | 2.66 | 0.01 | 0 | 0 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
112 | 0 | 0.00 | 0.00 | 0 | 0 | 350f5yrnnmshs | lock table sys.mon_mods$ in ex... | |
112 | 108 | 0.96 | 0.01 | 104.3 | 0 | g00cj285jmgsw | update sys.mon_mods$ set inser... | |
66 | 66 | 1.00 | 0.03 | 0 | 90.4 | 5h7w8ykwtb2xt | INSERT INTO SYS.WRI$_ADV_PARAM... | |
54 | 54 | 1.00 | 0.00 | 0 | 0 | bsa0wjtftg3uw | select file# from file$ where ... | |
46 | 46 | 1.00 | 0.00 | 0 | 0 | 089dbukv1aanh | EM_PING | SELECT SYS_EXTRACT_UTC(SYSTIME... |
39 | 39 | 1.00 | 0.01 | 0 | 0 | 5kyb5bvnu3s04 | SELECT DISTINCT METRIC_GUID FR... | |
39 | 39 | 1.00 | 0.01 | 0 | 34.9 | 8vwv6hx92ymmm | UPDATE MGMT_CURRENT_METRICS SE... |
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
204 | 204 | 26.84 | b2gnxm5z6r51n | lock table sys.col_usage$ in e... | |
112 | 112 | 14.74 | 350f5yrnnmshs | lock table sys.mon_mods$ in ex... | |
8 | 8 | 1.05 | 0k8522rmdzg4k | select privilege# from sysauth... | |
8 | 158 | 1.05 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
6 | 54 | 0.79 | bsa0wjtftg3uw | select file# from file$ where ... | |
5 | 5 | 0.66 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
5 | 5 | 0.66 | 2ts960gft6nsd | SQL*Plus | select name n from v$database |
5 | 5 | 0.66 | 459f3z9u4fb3u | select value$ from props$ wher... | |
5 | 5 | 0.66 | 4vs91dcv7u1p6 | sqlplus.exe | insert into sys.aud$( sessioni... |
5 | 5 | 0.66 | 5qgz1p0cut7mx | sqlplus.exe | BEGIN DBMS_OUTPUT.DISABLE; END... |
Statistic | Total | per Second | per Trans |
---|---|---|---|
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 | 1 | 0.01 | 0.00 |
CCursor + sql area evicted | 0 | 0.00 | 0.00 |
CPU used by this session | 8,611 | 52.70 | 0.03 |
CPU used when call started | 8,599 | 52.63 | 0.03 |
CR blocks created | 21 | 0.13 | 0.00 |
Cached Commit SCN referenced | 0 | 0.00 | 0.00 |
Commit SCN cached | 0 | 0.00 | 0.00 |
DB time | 55,918 | 342.22 | 0.17 |
DBWR checkpoint buffers written | 4,819 | 29.49 | 0.02 |
DBWR checkpoints | 5 | 0.03 | 0.00 |
DBWR object drop buffers written | 0 | 0.00 | 0.00 |
DBWR thread checkpoint buffers written | 4,308 | 26.36 | 0.01 |
DBWR transaction table writes | 64 | 0.39 | 0.00 |
DBWR undo block writes | 3,641 | 22.28 | 0.01 |
HSC Heap Segment Block Changes | 321,112 | 1,965.19 | 1.00 |
Heap Segment Array Inserts | 88 | 0.54 | 0.00 |
Heap Segment Array Updates | 20 | 0.12 | 0.00 |
IMU CR rollbacks | 20 | 0.12 | 0.00 |
IMU Flushes | 18,357 | 112.34 | 0.06 |
IMU Redo allocation size | 7,081,476 | 43,338.29 | 22.13 |
IMU commits | 298,613 | 1,827.50 | 0.93 |
IMU contention | 16,920 | 103.55 | 0.05 |
IMU ktichg flush | 0 | 0.00 | 0.00 |
IMU pool not allocated | 3,083 | 18.87 | 0.01 |
IMU recursive-transaction flush | 1 | 0.01 | 0.00 |
IMU undo allocation size | 125,513,152 | 768,134.35 | 392.18 |
IMU- failed to get a private strand | 3,083 | 18.87 | 0.01 |
Requests to/from client | 640,097 | 3,917.36 | 2.00 |
RowCR attempts | 6 | 0.04 | 0.00 |
RowCR hits | 6 | 0.04 | 0.00 |
SMON posted for undo segment shrink | 7 | 0.04 | 0.00 |
SQL*Net roundtrips to/from client | 640,097 | 3,917.36 | 2.00 |
active txn count during cleanout | 11,507 | 70.42 | 0.04 |
application wait time | 0 | 0.00 | 0.00 |
background checkpoints completed | 3 | 0.02 | 0.00 |
background checkpoints started | 5 | 0.03 | 0.00 |
background timeouts | 785 | 4.80 | 0.00 |
buffer is not pinned count | 4,626 | 28.31 | 0.01 |
buffer is pinned count | 1,618 | 9.90 | 0.01 |
bytes received via SQL*Net from client | 129,305,538 | 791,343.56 | 404.03 |
bytes sent via SQL*Net to client | 88,990,060 | 544,614.81 | 278.06 |
calls to get snapshot scn: kcmgss | 322,572 | 1,974.12 | 1.01 |
calls to kcmgas | 320,723 | 1,962.81 | 1.00 |
calls to kcmgcs | 321,070 | 1,964.93 | 1.00 |
cell physical IO interconnect bytes | 255,357,440 | 1,562,775.03 | 797.89 |
change write time | 548 | 3.35 | 0.00 |
cleanout - number of ktugct calls | 26,455 | 161.90 | 0.08 |
cleanouts only - consistent read gets | 1 | 0.01 | 0.00 |
cluster key scan block gets | 21 | 0.13 | 0.00 |
cluster key scans | 20 | 0.12 | 0.00 |
commit batch/immediate performed | 3 | 0.02 | 0.00 |
commit batch/immediate requested | 3 | 0.02 | 0.00 |
commit cleanout failures: block lost | 0 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 6 | 0.04 | 0.00 |
commit cleanout failures: cannot pin | 14,318 | 87.63 | 0.04 |
commit cleanouts | 320,877 | 1,963.75 | 1.00 |
commit cleanouts successfully completed | 306,553 | 1,876.09 | 0.96 |
commit immediate performed | 3 | 0.02 | 0.00 |
commit immediate requested | 3 | 0.02 | 0.00 |
commit txn count during cleanout | 28,239 | 172.82 | 0.09 |
concurrency wait time | 65 | 0.40 | 0.00 |
consistent changes | 42 | 0.26 | 0.00 |
consistent gets | 367,082 | 2,246.52 | 1.15 |
consistent gets - examination | 43,603 | 266.85 | 0.14 |
consistent gets direct | 0 | 0.00 | 0.00 |
consistent gets from cache | 367,082 | 2,246.52 | 1.15 |
consistent gets from cache (fastpath) | 323,152 | 1,977.67 | 1.01 |
cursor authentications | 107 | 0.65 | 0.00 |
data blocks consistent reads - undo records applied | 24 | 0.15 | 0.00 |
db block changes | 1,288,166 | 7,883.51 | 4.03 |
db block gets | 1,928,196 | 11,800.47 | 6.02 |
db block gets direct | 0 | 0.00 | 0.00 |
db block gets from cache | 1,928,196 | 11,800.47 | 6.02 |
db block gets from cache (fastpath) | 519,463 | 3,179.09 | 1.62 |
deferred (CURRENT) block cleanout applications | 308,993 | 1,891.02 | 0.97 |
enqueue conversions | 251 | 1.54 | 0.00 |
enqueue releases | 642,864 | 3,934.30 | 2.01 |
enqueue requests | 642,864 | 3,934.30 | 2.01 |
enqueue timeouts | 0 | 0.00 | 0.00 |
enqueue waits | 22 | 0.13 | 0.00 |
execute count | 322,379 | 1,972.94 | 1.01 |
file io service time | 0 | 0.00 | 0.00 |
file io wait time | 49,747,815 | 304,454.19 | 155.44 |
free buffer requested | 5,313 | 32.52 | 0.02 |
heap block compress | 5 | 0.03 | 0.00 |
immediate (CR) block cleanout applications | 1 | 0.01 | 0.00 |
immediate (CURRENT) block cleanout applications | 115 | 0.70 | 0.00 |
in call idle wait time | 325,832 | 1,994.08 | 1.02 |
index crx upgrade (positioned) | 0 | 0.00 | 0.00 |
index fast full scans (full) | 0 | 0.00 | 0.00 |
index fetch by key | 1,771 | 10.84 | 0.01 |
index scans kdiixs1 | 1,031 | 6.31 | 0.00 |
leaf node 90-10 splits | 11 | 0.07 | 0.00 |
leaf node splits | 16 | 0.10 | 0.00 |
lob writes | 18 | 0.11 | 0.00 |
lob writes unaligned | 18 | 0.11 | 0.00 |
logical read bytes from cache | 18,802,917,376 | 115,072,933.76 | 58,751.77 |
logons cumulative | 16 | 0.10 | 0.00 |
max cf enq hold time | 0 | 0.00 | 0.00 |
messages received | 189,754 | 1,161.29 | 0.59 |
messages sent | 189,754 | 1,161.29 | 0.59 |
min active SCN optimization applied on CR | 76 | 0.47 | 0.00 |
no work - consistent read gets | 2,296 | 14.05 | 0.01 |
non-idle wait count | 1,481,243 | 9,065.13 | 4.63 |
non-idle wait time | 40,393 | 247.20 | 0.13 |
opened cursors cumulative | 642,194 | 3,930.20 | 2.01 |
parse count (describe) | 0 | 0.00 | 0.00 |
parse count (hard) | 57 | 0.35 | 0.00 |
parse count (total) | 760 | 4.65 | 0.00 |
parse time cpu | 438 | 2.68 | 0.00 |
parse time elapsed | 561 | 3.43 | 0.00 |
physical read IO requests | 53 | 0.32 | 0.00 |
physical read bytes | 753,664 | 4,612.39 | 2.35 |
physical read total IO requests | 419 | 2.56 | 0.00 |
physical read total bytes | 6,550,528 | 40,088.91 | 20.47 |
physical read total multi block requests | 0 | 0.00 | 0.00 |
physical reads | 92 | 0.56 | 0.00 |
physical reads cache | 77 | 0.47 | 0.00 |
physical reads cache prefetch | 39 | 0.24 | 0.00 |
physical reads direct | 15 | 0.09 | 0.00 |
physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
physical reads prefetch warmup | 39 | 0.24 | 0.00 |
physical write IO requests | 759 | 4.65 | 0.00 |
physical write bytes | 39,600,128 | 242,350.84 | 123.73 |
physical write total IO requests | 194,175 | 1,188.34 | 0.61 |
physical write total bytes | 248,806,912 | 1,522,686.12 | 777.42 |
physical write total multi block requests | 232 | 1.42 | 0.00 |
physical writes | 4,834 | 29.58 | 0.02 |
physical writes direct | 15 | 0.09 | 0.00 |
physical writes direct (lob) | 0 | 0.00 | 0.00 |
physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
physical writes from cache | 4,819 | 29.49 | 0.02 |
physical writes non checkpoint | 3,756 | 22.99 | 0.01 |
process last non-idle time | 164 | 1.00 | 0.00 |
recursive calls | 328,756 | 2,011.97 | 1.03 |
recursive cpu usage | 1,316 | 8.05 | 0.00 |
redo blocks checksummed by FG (exclusive) | 1,445 | 8.84 | 0.00 |
redo blocks written | 399,701 | 2,446.15 | 1.25 |
redo buffer allocation retries | 18 | 0.11 | 0.00 |
redo entries | 347,146 | 2,124.52 | 1.08 |
redo log space requests | 23 | 0.14 | 0.00 |
redo log space wait time | 122 | 0.75 | 0.00 |
redo ordering marks | 206 | 1.26 | 0.00 |
redo size | 160,273,152 | 980,863.84 | 500.79 |
redo size for direct writes | 0 | 0.00 | 0.00 |
redo subscn max counts | 360 | 2.20 | 0.00 |
redo synch long waits | 118 | 0.72 | 0.00 |
redo synch poll writes | 0 | 0.00 | 0.00 |
redo synch polls | 0 | 0.00 | 0.00 |
redo synch time | 29,252 | 179.02 | 0.09 |
redo synch time (usec) | 292,535,138 | 1,790,300.72 | 914.06 |
redo synch writes | 320,034 | 1,958.59 | 1.00 |
redo wastage | 37,522,776 | 229,637.55 | 117.24 |
redo write time | 10,721 | 65.61 | 0.03 |
redo writes | 189,075 | 1,157.13 | 0.59 |
rollback changes - undo records applied | 3 | 0.02 | 0.00 |
rollbacks only - consistent read gets | 12 | 0.07 | 0.00 |
rows fetched via callback | 818 | 5.01 | 0.00 |
session connect time | 164 | 1.00 | 0.00 |
session cursor cache hits | 117,148 | 716.94 | 0.37 |
session logical reads | 2,295,278 | 14,046.99 | 7.17 |
shared hash latch upgrades - no wait | 616 | 3.77 | 0.00 |
shared hash latch upgrades - wait | 0 | 0.00 | 0.00 |
sorts (memory) | 613 | 3.75 | 0.00 |
sorts (rows) | 6,324 | 38.70 | 0.02 |
sql area evicted | 0 | 0.00 | 0.00 |
sql area purged | 0 | 0.00 | 0.00 |
switch current to new buffer | 28 | 0.17 | 0.00 |
table fetch by rowid | 1,762 | 10.78 | 0.01 |
table fetch continued row | 0 | 0.00 | 0.00 |
table scan blocks gotten | 428 | 2.62 | 0.00 |
table scan rows gotten | 44,463 | 272.11 | 0.14 |
table scans (long tables) | 0 | 0.00 | 0.00 |
table scans (short tables) | 110 | 0.67 | 0.00 |
total cf enq hold time | 1,078 | 6.60 | 0.00 |
total number of cf enq holders | 15 | 0.09 | 0.00 |
total number of times SMON posted | 10 | 0.06 | 0.00 |
transaction rollbacks | 3 | 0.02 | 0.00 |
undo change vector size | 42,644,828 | 260,984.26 | 133.25 |
user I/O wait time | 93 | 0.57 | 0.00 |
user calls | 1,280,182 | 7,834.65 | 4.00 |
user commits | 320,040 | 1,958.63 | 1.00 |
workarea executions - optimal | 360 | 2.20 | 0.00 |
write clones created in background | 0 | 0.00 | 0.00 |
write clones created in foreground | 17 | 0.10 | 0.00 |
Statistic | Begin Value | End Value |
---|---|---|
opened cursors current | 37 | 33 |
logons current | 22 | 24 |
session uga memory max | 198,178,696 | 211,750,356 |
session pga memory | 159,907,896 | 164,993,332 |
session pga memory max | 183,648,956 | 188,734,392 |
session cursor cache count | 6,197 | 6,509 |
session uga memory | 339,323,629,008 | 352,209,440,712 |
Statistic | Total | per Hour |
---|---|---|
log switches (derived) | 5 | 110.16 |
Function Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
---|---|---|---|---|---|---|---|---|
LGWR | 1M | 0.54 | .006119 | 196M | 1182.61 | 1.19951 | 189.2K | 0.56 |
DBWR | 0M | 0.00 | 0M | 38M | 4.55 | .232558 | 0 | |
Others | 4M | 1.70 | .024479 | 3M | 1.08 | .018359 | 365 | 5.32 |
Buffer Cache Reads | 0M | 0.21 | 0M | 0M | 0.00 | 0M | 35 | 7.49 |
Direct Reads | 0M | 0.09 | 0M | 0M | 0.00 | 0M | 0 | |
Direct Writes | 0M | 0.00 | 0M | 0M | 0.09 | 0M | 0 | |
TOTAL: | 5M | 2.55 | .030599 | 237M | 1188.33 | 1.45042 | 189.6K | 0.57 |
Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read |
---|---|---|---|---|---|---|---|---|
Log File | 0M | 0.06 | 0M | 194M | 1182.00 | 1.18727 | 10.50 | |
Data File | 1M | 0.34 | .006119 | 39M | 4.65 | .238678 | 15.53 | |
Control File | 6M | 2.15 | .036719 | 5M | 1.69 | .030599 | 4.67 | |
TOTAL: | 7M | 2.55 | .042839 | 238M | 1188.33 | 1.45654 | 6.25 |
Function/File Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
---|---|---|---|---|---|---|---|---|
LGWR | 1M | 0.54 | .006119 | 196M | 1182.61 | 1.19951 | 99 | 4.41 |
LGWR (Log File) | 0M | 0.06 | 0M | 194M | 1182.00 | 1.18727 | 20 | 5.85 |
LGWR (Control File) | 1M | 0.48 | .006119 | 2M | 0.61 | .012239 | 79 | 4.05 |
DBWR | 0M | 0.00 | 0M | 38M | 4.55 | .232558 | 0 | |
DBWR (Data File) | 0M | 0.00 | 0M | 38M | 4.55 | .232558 | 0 | |
Others | 4M | 1.70 | .024479 | 3M | 1.08 | .018359 | 277 | 4.87 |
Others (Control File) | 4M | 1.66 | .024479 | 3M | 1.08 | .018359 | 272 | 4.85 |
Others (Data File) | 0M | 0.03 | 0M | 0M | 0.00 | 0M | 5 | 6.00 |
Buffer Cache Reads | 0M | 0.21 | 0M | 0M | 0.00 | 0M | 35 | 7.49 |
Buffer Cache Reads (Data File) | 0M | 0.21 | 0M | 0M | 0.00 | 0M | 35 | 7.49 |
Direct Reads | 0M | 0.09 | 0M | 0M | 0.00 | 0M | 0 | |
Direct Reads (Data File) | 0M | 0.09 | 0M | 0M | 0.00 | 0M | 0 | |
Direct Writes | 0M | 0.00 | 0M | 0M | 0.09 | 0M | 0 | |
Direct Writes (Data File) | 0M | 0.00 | 0M | 0M | 0.09 | 0M | 0 | |
TOTAL: | 5M | 2.55 | .030599 | 237M | 1188.33 | 1.45042 | 411 | 4.98 |
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
SYSAUX | 42 | 0 | 6.67 | 2.07 | 345 | 2 | 0 | 0.00 |
UNDOTBS1 | 3 | 0 | 0.00 | 1.00 | 325 | 2 | 322 | 0.03 |
SYSTEM | 5 | 0 | 4.00 | 1.00 | 43 | 0 | 0 | 0.00 |
USERS | 3 | 0 | 0.00 | 1.00 | 43 | 0 | 524 | 0.06 |
EXAMPLE | 3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|---|
EXAMPLE | C:\ORACLE\ORADATA\ORCL\EXAMPLE01.DBF | 3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
SYSAUX | C:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF | 42 | 0 | 6.67 | 2.07 | 345 | 2 | 0 | 0.00 |
SYSTEM | C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF | 5 | 0 | 4.00 | 1.00 | 43 | 0 | 0 | 0.00 |
UNDOTBS1 | C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF | 3 | 0 | 0.00 | 1.00 | 325 | 2 | 322 | 0.03 |
USERS | C:\ORACLE\ORADATA\ORCL\USERS01.DBF | 3 | 0 | 0.00 | 1.00 | 43 | 0 | 524 | 0.06 |
P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits |
---|---|---|---|---|---|---|---|---|
D | 52,735 | 100 | 2,288,740 | 74 | 4,819 | 0 | 0 | 846 |
MTTR Writes | Log Size Writes | Log Ckpt Writes | Other Settings Writes | Autotune Ckpt Writes | Thread Ckpt Writes |
---|---|---|---|---|---|
0 | 4,101 | 0 | 0 | 511 | 207 |
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 | 45 | 573 | 3616 | 165888 | 165888 | 465625 | |||
E | 0 | 85 | 2227 | 165739 | 165888 | 165888 | 459700 |
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 | 40 | 0.09 | 5 | 1.14 | 15 | 1 | 84.00 |
D | 80 | 0.19 | 10 | 1.05 | 14 | 1 | 75.00 |
D | 120 | 0.28 | 15 | 1.04 | 14 | 1 | 74.00 |
D | 160 | 0.38 | 20 | 1.03 | 14 | 1 | 73.00 |
D | 200 | 0.47 | 25 | 1.02 | 14 | 1 | 72.00 |
D | 240 | 0.57 | 30 | 1.01 | 13 | 1 | 70.00 |
D | 280 | 0.66 | 35 | 1.00 | 13 | 1 | 70.00 |
D | 320 | 0.75 | 40 | 1.00 | 13 | 1 | 70.00 |
D | 360 | 0.85 | 45 | 1.00 | 13 | 1 | 70.00 |
D | 400 | 0.94 | 50 | 1.00 | 13 | 1 | 70.00 |
D | 424 | 1.00 | 53 | 1.00 | 13 | 1 | 70.00 |
D | 440 | 1.04 | 55 | 1.00 | 13 | 1 | 70.00 |
D | 480 | 1.13 | 60 | 1.00 | 13 | 1 | 70.00 |
D | 520 | 1.23 | 65 | 1.00 | 13 | 1 | 70.00 |
D | 560 | 1.32 | 70 | 1.00 | 13 | 1 | 70.00 |
D | 600 | 1.42 | 75 | 1.00 | 13 | 1 | 70.00 |
D | 640 | 1.51 | 80 | 1.00 | 13 | 1 | 70.00 |
D | 680 | 1.60 | 85 | 1.00 | 13 | 1 | 70.00 |
D | 720 | 1.70 | 90 | 1.00 | 13 | 1 | 70.00 |
D | 760 | 1.79 | 95 | 1.00 | 13 | 1 | 70.00 |
D | 800 | 1.89 | 100 | 1.00 | 13 | 1 | 70.00 |
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
100.00 | 27 | 0 |
Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
---|---|---|---|---|---|
2K | 4K | 332 | 332 | 0 | 0 |
64K | 128K | 2 | 2 | 0 | 0 |
512K | 1024K | 24 | 24 | 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 |
---|---|---|---|---|---|---|
62 | 0.13 | 124.86 | 0.00 | 100.00 | 0 | 56,373 |
124 | 0.25 | 124.86 | 0.00 | 100.00 | 0 | 56,373 |
248 | 0.50 | 124.86 | 0.00 | 100.00 | 0 | 56,373 |
372 | 0.75 | 124.86 | 0.00 | 100.00 | 0 | 56,373 |
496 | 1.00 | 124.86 | 0.00 | 100.00 | 0 | 56,373 |
595 | 1.20 | 124.86 | 0.00 | 100.00 | 0 | 56,373 |
694 | 1.40 | 124.86 | 0.00 | 100.00 | 0 | 56,373 |
794 | 1.60 | 124.86 | 0.00 | 100.00 | 0 | 56,373 |
893 | 1.80 | 124.86 | 0.00 | 100.00 | 0 | 56,373 |
992 | 2.00 | 124.86 | 0.00 | 100.00 | 0 | 56,373 |
1,488 | 3.00 | 124.86 | 0.00 | 100.00 | 0 | 56,373 |
1,984 | 4.00 | 124.86 | 0.00 | 100.00 | 0 | 56,373 |
2,976 | 6.00 | 124.86 | 0.00 | 100.00 | 0 | 56,373 |
3,968 | 8.00 | 124.86 | 0.00 | 100.00 | 0 | 56,373 |
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) |
---|---|---|---|---|---|---|---|---|
104 | 0.39 | 16 | 1,533 | 18,631 | 0.97 | 680 | 8.40 | 471 |
136 | 0.52 | 46 | 3,348 | 18,695 | 0.97 | 616 | 7.60 | 473 |
168 | 0.64 | 49 | 3,607 | 18,695 | 0.97 | 616 | 7.60 | 473 |
184 | 0.70 | 49 | 3,607 | 18,695 | 0.97 | 616 | 7.60 | 473 |
192 | 0.73 | 49 | 3,607 | 18,695 | 0.97 | 616 | 7.60 | 473 |
200 | 0.76 | 49 | 3,607 | 18,695 | 0.97 | 616 | 7.60 | 473 |
208 | 0.79 | 49 | 3,607 | 18,695 | 0.97 | 616 | 7.60 | 473 |
216 | 0.82 | 49 | 3,607 | 18,695 | 0.97 | 616 | 7.60 | 473 |
224 | 0.85 | 49 | 3,607 | 18,695 | 0.97 | 616 | 7.60 | 473 |
232 | 0.88 | 49 | 3,607 | 18,778 | 0.98 | 533 | 6.58 | 473 |
240 | 0.91 | 49 | 3,607 | 18,861 | 0.98 | 450 | 5.56 | 473 |
248 | 0.94 | 49 | 3,607 | 18,944 | 0.99 | 367 | 4.53 | 473 |
256 | 0.97 | 49 | 3,607 | 19,087 | 0.99 | 224 | 2.77 | 474 |
264 | 1.00 | 49 | 3,607 | 19,230 | 1.00 | 81 | 1.00 | 474 |
272 | 1.03 | 49 | 3,607 | 19,230 | 1.00 | 81 | 1.00 | 474 |
280 | 1.06 | 49 | 3,607 | 19,230 | 1.00 | 81 | 1.00 | 474 |
288 | 1.09 | 49 | 3,607 | 19,230 | 1.00 | 81 | 1.00 | 474 |
296 | 1.12 | 49 | 3,607 | 19,230 | 1.00 | 81 | 1.00 | 474 |
304 | 1.15 | 49 | 3,607 | 19,230 | 1.00 | 81 | 1.00 | 474 |
312 | 1.18 | 49 | 3,607 | 19,230 | 1.00 | 81 | 1.00 | 474 |
320 | 1.21 | 49 | 3,607 | 19,230 | 1.00 | 81 | 1.00 | 474 |
328 | 1.24 | 49 | 3,607 | 19,230 | 1.00 | 81 | 1.00 | 474 |
336 | 1.27 | 49 | 3,607 | 19,230 | 1.00 | 81 | 1.00 | 474 |
360 | 1.36 | 49 | 3,607 | 19,230 | 1.00 | 81 | 1.00 | 474 |
392 | 1.48 | 49 | 3,607 | 19,230 | 1.00 | 81 | 1.00 | 474 |
424 | 1.61 | 49 | 3,607 | 19,230 | 1.00 | 81 | 1.00 | 474 |
456 | 1.73 | 49 | 3,607 | 19,230 | 1.00 | 81 | 1.00 | 474 |
488 | 1.85 | 49 | 3,607 | 19,230 | 1.00 | 81 | 1.00 | 474 |
520 | 1.97 | 49 | 3,607 | 19,230 | 1.00 | 81 | 1.00 | 474 |
552 | 2.09 | 49 | 3,607 | 19,230 | 1.00 | 81 | 1.00 | 474 |
SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
---|---|---|---|
184 | 0.25 | 19,333 | 15,030 |
368 | 0.50 | 18,734 | 15,030 |
552 | 0.75 | 18,721 | 13,371 |
736 | 1.00 | 18,721 | 13,270 |
920 | 1.25 | 18,721 | 13,270 |
1,104 | 1.50 | 18,721 | 13,270 |
1,288 | 1.75 | 18,721 | 13,270 |
1,472 | 2.00 | 18,721 | 13,270 |
Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
---|---|---|---|---|---|
8 | 1.00 | 0 | 0 | 0 | 0 |
16 | 2.00 | 0 | 0 | 0 | 0 |
24 | 3.00 | 0 | 0 | 0 | 0 |
32 | 4.00 | 0 | 0 | 0 | 0 |
40 | 5.00 | 0 | 0 | 0 | 0 |
48 | 6.00 | 0 | 0 | 0 | 0 |
56 | 7.00 | 0 | 0 | 0 | 0 |
64 | 8.00 | 0 | 0 | 0 | 0 |
72 | 9.00 | 0 | 0 | 0 | 0 |
80 | 10.00 | 0 | 0 | 0 | 0 |
88 | 11.00 | 0 | 0 | 0 | 0 |
96 | 12.00 | 0 | 0 | 0 | 0 |
104 | 13.00 | 0 | 0 | 0 | 0 |
112 | 14.00 | 0 | 0 | 0 | 0 |
120 | 15.00 | 0 | 0 | 0 | 0 |
128 | 16.00 | 0 | 0 | 0 | 0 |
136 | 17.00 | 0 | 0 | 0 | 0 |
144 | 18.00 | 0 | 0 | 0 | 0 |
152 | 19.00 | 0 | 0 | 0 | 0 |
160 | 20.00 | 0 | 0 | 0 | 0 |
Class | Waits | Total Wait Time (s) | Avg Time (ms) |
---|---|---|---|
data block | 487 | 0 | 0 |
undo header | 322 | 0 | 0 |
segment header | 19 | 0 | 0 |
1st level bmb | 14 | 0 | 0 |
2nd level bmb | 4 | 0 | 0 |
Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
---|---|---|---|---|---|---|
TX-Transaction | 318,384 | 319,797 | 0 | 17 | 0 | 0.00 |
FB-Format Block | 48 | 48 | 0 | 5 | 0 | 0.00 |
Latch Name | Get Requests | Pct Get Miss | Avg Slps /Miss | Wait Time (s) | NoWait Requests | Pct NoWait Miss |
---|---|---|---|---|---|---|
AQ deq hash table latch | 1 | 0.00 | 0 | 0 | ||
ASM db client latch | 182 | 0.00 | 0 | 0 | ||
ASM map operation hash table | 1 | 0.00 | 0 | 0 | ||
ASM network state latch | 4 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 834 | 0.00 | 0 | 0 | ||
Change Notification Hash table latch | 54 | 0.00 | 0 | 0 | ||
Consistent RBA | 189,089 | 0.00 | 0 | 0 | ||
DML lock allocation | 641,214 | 0.15 | 0.00 | 0 | 0 | |
Event Group Locks | 30 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 51 | 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 | 1,287,792 | 0.23 | 0.49 | 0 | 320,089 | 0.00 |
JS Sh mem access | 1 | 0.00 | 0 | 0 | ||
JS broadcast autostart latch | 3 | 0.00 | 0 | 0 | ||
JS queue access latch | 1 | 0.00 | 0 | 0 | ||
JS queue state obj latch | 1,152 | 0.00 | 0 | 0 | ||
JS slv state obj latch | 13 | 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 | 55 | 0.00 | 0 | 0 | ||
KTF sga latch | 2 | 0.00 | 0 | 53 | 0.00 | |
KWQMN job cache list latch | 1 | 0.00 | 0 | 0 | ||
KWQP Prop Status | 2 | 0.00 | 0 | 0 | ||
KWQS pqsubs latch | 2 | 0.00 | 0 | 0 | ||
KWQS pqueue ctx latch | 22 | 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 | 3 | 0.00 | ||
Memory Management Latch | 1 | 0.00 | 0 | 55 | 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 | ||
Mutex | 1 | 0.00 | 0 | 0 | ||
Mutex Stats | 1 | 0.00 | 0 | 0 | ||
OS process | 87 | 0.00 | 0 | 0 | ||
OS process allocation | 362 | 0.28 | 0.00 | 0 | 0 | |
OS process: request allocation | 24 | 0.00 | 0 | 0 | ||
PL/SQL warning settings | 37 | 0.00 | 0 | 0 | ||
PX hash array latch | 1 | 0.00 | 0 | 0 | ||
QMT | 1 | 0.00 | 0 | 0 | ||
Real-time plan statistics latch | 2 | 0.00 | 0 | 0 | ||
SGA IO buffer pool latch | 18 | 0.00 | 0 | 18 | 0.00 | |
SGA blob parent | 1 | 0.00 | 0 | 0 | ||
SGA bucket locks | 1 | 0.00 | 0 | 0 | ||
SGA heap locks | 1 | 0.00 | 0 | 0 | ||
SGA pool locks | 1 | 0.00 | 0 | 0 | ||
SQL memory manager latch | 6 | 0.00 | 0 | 54 | 0.00 | |
SQL memory manager workarea list latch | 3,882 | 0.00 | 0 | 0 | ||
Shared B-Tree | 53 | 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 | 635 | 0.00 | 0 | 0 | ||
active service list | 471 | 0.00 | 0 | 662 | 0.00 | |
buffer pool | 1 | 0.00 | 0 | 0 | ||
business card | 1 | 0.00 | 0 | 0 | ||
cache buffer handles | 394 | 0.00 | 0 | 0 | ||
cache buffers chains | 9,024,207 | 0.52 | 0.00 | 0 | 5,358 | 0.00 |
cache buffers lru chain | 4,997 | 0.00 | 0 | 10,584 | 0.03 | |
call allocation | 239 | 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 | 28 | 0.00 | 0 | 0 | ||
channel operations parent latch | 1,517 | 0.00 | 0 | 0 | ||
checkpoint queue latch | 12,236 | 0.00 | 0 | 6,397 | 0.03 | |
client/application info | 70 | 0.00 | 0 | 0 | ||
compile environment latch | 16 | 0.00 | 0 | 0 | ||
corrupted undo seg latch | 12 | 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 | 4 | 0.00 | 0 | 0 | ||
cvmap freelist lock | 1 | 0.00 | 0 | 0 | ||
deferred cleanup latch | 4 | 0.00 | 0 | 0 | ||
dml lock allocation | 6 | 0.00 | 0 | 0 | ||
done queue latch | 1 | 0.00 | 0 | 0 | ||
dummy allocation | 31 | 0.00 | 0 | 0 | ||
enqueue freelist latch | 1 | 0.00 | 0 | 3,576 | 0.00 | |
enqueue hash chains | 1,286,017 | 1.05 | 0.00 | 0 | 0 | |
enqueues | 4 | 0.00 | 0 | 0 | ||
fifth spare latch | 1 | 0.00 | 0 | 0 | ||
file cache latch | 111 | 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 | 5 | 0.00 | 0 | 0 | ||
global tx hash mapping | 1 | 0.00 | 0 | 0 | ||
granule operation | 1 | 0.00 | 0 | 0 | ||
hash table column usage latch | 223 | 0.00 | 0 | 2,067 | 0.00 | |
hash table modification latch | 1 | 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 | 4 | 0.00 | 0 | 3 | 0.00 | |
job_queue_processes free list latch | 6 | 0.00 | 0 | 0 | ||
job_queue_processes parameter latch | 37 | 0.00 | 0 | 0 | ||
k2q lock allocation | 1 | 0.00 | 0 | 0 | ||
kcbtsemkid latch | 5 | 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 | 52 | 0.00 | 0 | 0 | ||
ksfv messages | 1 | 0.00 | 0 | 0 | ||
ksim group membership cache | 1 | 0.00 | 0 | 0 | ||
kss move lock | 5 | 0.00 | 0 | 0 | ||
ksuosstats global area | 19 | 0.00 | 0 | 0 | ||
ksv allocation latch | 10 | 0.00 | 0 | 0 | ||
ksv class latch | 5 | 0.00 | 0 | 0 | ||
ksv msg queue latch | 1 | 0.00 | 0 | 0 | ||
ksz_so allocation latch | 24 | 4.17 | 0.00 | 0 | 0 | |
ktm global data | 41 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 7 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 189,179 | 0.00 | 0 | 0 | ||
list of block allocation | 37 | 0.00 | 0 | 0 | ||
loader state object freelist | 36 | 0.00 | 0 | 0 | ||
lob segment dispenser latch | 1 | 0.00 | 0 | 0 | ||
lob segment hash table latch | 3 | 0.00 | 0 | 0 | ||
lob segment query latch | 1 | 0.00 | 0 | 0 | ||
lock DBA buffer during media recovery | 1 | 0.00 | 0 | 0 | ||
logical standby cache | 1 | 0.00 | 0 | 0 | ||
logminer context allocation | 2 | 0.00 | 0 | 0 | ||
logminer work area | 1 | 0.00 | 0 | 0 | ||
longop free list parent | 1 | 0.00 | 0 | 0 | ||
mapped buffers lru chain | 1 | 0.00 | 0 | 0 | ||
message pool operations parent latch | 157 | 0.00 | 0 | 0 | ||
messages | 493,181 | 1.09 | 0.00 | 0 | 0 | |
mostly latch-free SCN | 189,760 | 0.21 | 0.03 | 0 | 0 | |
msg queue latch | 1 | 0.00 | 0 | 0 | ||
multiblock read objects | 28 | 0.00 | 0 | 0 | ||
name-service namespace bucket | 1 | 0.00 | 0 | 0 | ||
ncodef allocation latch | 4 | 0.00 | 0 | 0 | ||
object queue header heap | 1,250 | 0.00 | 0 | 2 | 0.00 | |
object queue header operation | 23,090 | 0.02 | 0.00 | 0 | 0 | |
object stats modification | 157 | 0.00 | 0 | 0 | ||
parallel query alloc buffer | 25 | 0.00 | 0 | 0 | ||
parallel query stats | 1 | 0.00 | 0 | 0 | ||
parameter list | 24 | 0.00 | 0 | 0 | ||
parameter table management | 129 | 0.78 | 0.00 | 0 | 0 | |
peshm | 1 | 0.00 | 0 | 0 | ||
pesom_free_list | 1 | 0.00 | 0 | 0 | ||
pesom_hash_node | 1 | 0.00 | 0 | 0 | ||
post/wait queue | 348,576 | 0.03 | 0.00 | 0 | 319,829 | 0.43 |
process allocation | 32 | 0.00 | 0 | 13 | 0.00 | |
process group creation | 24 | 4.17 | 0.00 | 0 | 0 | |
process queue | 1 | 0.00 | 0 | 0 | ||
process queue reference | 1 | 0.00 | 0 | 0 | ||
qmn task queue latch | 20 | 15.00 | 0.67 | 0 | 0 | |
query server freelists | 1 | 0.00 | 0 | 0 | ||
queued dump request | 1 | 0.00 | 0 | 0 | ||
queuing load statistics | 1 | 0.00 | 0 | 0 | ||
recovery domain hash list | 1 | 0.00 | 0 | 0 | ||
redo allocation | 1,210,576 | 0.01 | 0.38 | 0 | 345,821 | 1.25 |
redo copy | 1 | 0.00 | 0 | 347,134 | 0.90 | |
redo writing | 572,034 | 0.00 | 0.00 | 0 | 0 | |
resmgr group change latch | 11 | 0.00 | 0 | 0 | ||
resmgr:active threads | 31 | 0.00 | 0 | 0 | ||
resmgr:actses change group | 11 | 0.00 | 0 | 0 | ||
resmgr:actses change state | 1 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 30 | 3.33 | 0.00 | 0 | 0 | |
resmgr:plan CPU method | 1 | 0.00 | 0 | 0 | ||
resmgr:resource group CPU method | 1 | 0.00 | 0 | 0 | ||
resmgr:schema config | 1 | 0.00 | 0 | 0 | ||
resmgr:session queuing | 1 | 0.00 | 0 | 0 | ||
rm cas latch | 1 | 0.00 | 0 | 0 | ||
row cache objects | 17,532 | 0.00 | 0 | 0 | ||
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 | 36 | 0.00 | 0 | 0 | ||
session allocation | 320,124 | 0.09 | 0.00 | 0 | 320,099 | 0.05 |
session idle bit | 2,880,444 | 0.01 | 0.25 | 0 | 0 | |
session queue latch | 1 | 0.00 | 0 | 0 | ||
session state list latch | 26 | 0.00 | 0 | 0 | ||
session switching | 16 | 0.00 | 0 | 0 | ||
session timer | 56 | 0.00 | 0 | 0 | ||
shared pool | 7,008 | 0.36 | 0.00 | 0 | 0 | |
shared pool sim alloc | 3 | 0.00 | 0 | 0 | ||
shared pool simulator | 92 | 0.00 | 0 | 0 | ||
sim partition latch | 1 | 0.00 | 0 | 0 | ||
simulator hash latch | 86,998 | 0.00 | 0 | 0 | ||
simulator lru latch | 4,361 | 0.00 | 0 | 82,003 | 0.08 | |
sort extent pool | 20 | 0.00 | 0 | 0 | ||
space background state object latch | 2 | 0.00 | 0 | 0 | ||
space background task latch | 268 | 1.12 | 1.00 | 0 | 111 | 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 | 3 | 0.00 | 0 | 0 | ||
transaction allocation | 195 | 0.00 | 0 | 0 | ||
undo global data | 1,640,016 | 0.60 | 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 | 9,024,207 | 46,825 | 126 | 46,700 |
enqueue hash chains | 1,286,017 | 13,484 | 47 | 13,437 |
undo global data | 1,640,016 | 9,787 | 14 | 9,773 |
messages | 493,181 | 5,358 | 19 | 5,339 |
In memory undo latch | 1,287,792 | 2,941 | 1,434 | 1,508 |
DML lock allocation | 641,214 | 979 | 4 | 975 |
mostly latch-free SCN | 189,760 | 393 | 12 | 381 |
session idle bit | 2,880,444 | 344 | 87 | 257 |
session allocation | 320,124 | 273 | 1 | 272 |
redo allocation | 1,210,576 | 66 | 25 | 41 |
qmn task queue latch | 20 | 3 | 2 | 1 |
space background task latch | 268 | 3 | 3 | 0 |
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
DML lock allocation | ktaiam | 0 | 2 | 1 |
DML lock allocation | ktaidm | 0 | 2 | 3 |
In memory undo latch | kticmt: child | 0 | 879 | 307 |
In memory undo latch | ktiFlush: child | 0 | 658 | 1,241 |
In memory undo latch | ktichg: child | 0 | 10 | 0 |
In memory undo latch | kticflush_2 | 0 | 1 | 0 |
PC and Classifier lists for WLM | No latch | 0 | 2 | 0 |
cache buffers chains | kcbgcur: fast path (shr) | 0 | 1,474 | 1,475 |
cache buffers chains | kcbgcur_2 | 0 | 7 | 9 |
cache buffers chains | kcbnlc | 0 | 6 | 0 |
cache buffers chains | kcbrls_2 | 0 | 4 | 2 |
cache buffers chains | kcbchg1: mod cr pin | 0 | 2 | 1 |
cache buffers chains | kcbgcur_4 | 0 | 2 | 3 |
cache buffers chains | kcbgtcr: fast path | 0 | 2 | 4 |
cache buffers chains | kcbchg1: mod cur pin | 0 | 1 | 0 |
cache buffers chains | kcbrls: fast release | 0 | 1 | 4 |
cache buffers chains | kcbzpbuf | 0 | 1 | 0 |
enqueue hash chains | ksqrcl | 0 | 28 | 27 |
enqueue hash chains | ksqgtl3 | 0 | 19 | 20 |
messages | ksaamb: after wakeup | 0 | 16 | 17 |
messages | ksarcv | 0 | 2 | 2 |
messages | ksarcv: after wait | 0 | 1 | 0 |
mostly latch-free SCN | kcs05 | 0 | 10 | 0 |
mostly latch-free SCN | kcs04 | 0 | 2 | 12 |
qmn task queue latch | kwqmnmvtsks: delay to ready list | 0 | 2 | 0 |
redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 25 | 0 |
session allocation | ksucri_int : SSO | 0 | 1 | 0 |
session idle bit | ksupuc: set busy | 0 | 63 | 17 |
session idle bit | ksupuc: clear busy | 0 | 22 | 42 |
session idle bit | ksuxds | 0 | 3 | 29 |
space background task latch | ktsj_grab_task | 0 | 1 | 3 |
undo global data | ktudnx:child | 0 | 8 | 4 |
undo global data | ktubnd_4 | 0 | 3 | 0 |
undo global data | ktudba: KSLBEGIN | 0 | 2 | 0 |
undo global data | ktufrbs_2 | 0 | 1 | 10 |
Mutex Type | Location | Sleeps | Wait Time (ms) |
---|---|---|---|
Cursor Pin | kksfbc [KKSCHLPIN1] | 40 | 0 |
Cursor Pin | kkslce [KKSCHLPIN2] | 6 | 0 |
Library Cache | kglati1 45 | 5 | 0 |
Cursor Pin | kksLockDelete [KKSCHLPIN6] | 4 | 0 |
Library Cache | kglget2 2 | 1 | 0 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
---|---|---|---|---|---|---|
TESTUSER | USERS | TESTTABLE | TABLE | 1,286,688 | 56.06 | |
SYS | SYSTEM | I_COL_USAGE$ | INDEX | 1,056 | 0.05 | |
SYS | SYSTEM | I_SYSAUTH1 | INDEX | 832 | 0.04 | |
SYS | SYSTEM | COL_USAGE$ | TABLE | 544 | 0.02 | |
SYS | SYSAUX | WRM$_SNAPSHOT_DETAILS | TABLE | 352 | 0.02 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
SYS | SYSAUX | WRH$_SQL_PLAN | TABLE | 31 | 33.70 | |
SYS | SYSAUX | WRH$_SQLTEXT | TABLE | 12 | 13.04 | |
SYS | SYSAUX | WRH$_MVPARAMETER_PK | WRH$_MVPARA_1306904245_58 | INDEX PARTITION | 5 | 5.43 |
SYS | SYSAUX | WRH$_SYSMETRIC_SUMMARY | TABLE | 5 | 5.43 | |
SYS | SYSAUX | WRM$_SNAPSHOT_DETAILS_INDEX | INDEX | 5 | 5.43 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Read Requests | %Total |
---|---|---|---|---|---|---|
SYS | SYSAUX | WRH$_SQL_PLAN | TABLE | 16 | 30.19 | |
SYS | SYSAUX | WRH$_MVPARAMETER_PK | WRH$_MVPARA_1306904245_58 | INDEX PARTITION | 4 | 7.55 |
SYS | SYSAUX | WRH$_OSSTAT_PK | WRH$_OSSTAT_1306904245_58 | INDEX PARTITION | 3 | 5.66 |
SYS | SYSAUX | WRI$_ADV_PARAMETERS_PK | INDEX | 3 | 5.66 | |
SYS | SYSTEM | COL_USAGE$ | TABLE | 2 | 3.77 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | UnOptimized Reads | %Total |
---|---|---|---|---|---|---|
SYS | SYSAUX | WRH$_SQL_PLAN | TABLE | 16 | 30.19 | |
SYS | SYSAUX | WRH$_MVPARAMETER_PK | WRH$_MVPARA_1306904245_58 | INDEX PARTITION | 4 | 7.55 |
SYS | SYSAUX | WRH$_OSSTAT_PK | WRH$_OSSTAT_1306904245_58 | INDEX PARTITION | 3 | 5.66 |
SYS | SYSAUX | WRI$_ADV_PARAMETERS_PK | INDEX | 3 | 5.66 | |
SYS | SYSTEM | COL_USAGE$ | TABLE | 2 | 3.77 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Writes | %Total |
---|---|---|---|---|---|---|
TESTUSER | USERS | TESTTABLE | TABLE | 515 | 10.65 | |
SYS | SYSAUX | WRH$_SQLSTAT_INDEX | WRH$_SQLSTA_1306904245_58 | INDEX PARTITION | 24 | 0.50 |
SYS | SYSTEM | COL_USAGE$ | TABLE | 19 | 0.39 | |
SYS | SYSAUX | WRH$_EVENT_HISTOGRAM | WRH$_EVENT__1306904245_58 | TABLE PARTITION | 15 | 0.31 |
SYS | SYSAUX | WRH$_LATCH | WRH$_LATCH_1306904245_58 | TABLE PARTITION | 15 | 0.31 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Write Requests | %Total |
---|---|---|---|---|---|---|
TESTUSER | USERS | TESTTABLE | TABLE | 36 | 4.74 | |
SYS | SYSAUX | WRH$_SQL_PLAN_PK | INDEX | 10 | 1.32 | |
SYS | SYSAUX | WRH$_SQL_PLAN | TABLE | 8 | 1.05 | |
SYSMAN | SYSAUX | MGMT_METRICS_RAW_PK | INDEX | 6 | 0.79 | |
SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_1306904245_58 | TABLE PARTITION | 6 | 0.79 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | DB Block Changes | % of Capture |
---|---|---|---|---|---|---|
TESTUSER | USERS | TESTTABLE | TABLE | 6,192 | 79.96 | |
SYS | SYSTEM | COL_USAGE$ | TABLE | 528 | 6.82 | |
SYS | SYSTEM | MON_MODS$ | TABLE | 128 | 1.65 | |
SYS | SYSAUX | WRH$_SQLSTAT_INDEX | WRH$_SQLSTA_1306904245_58 | INDEX PARTITION | 128 | 1.65 |
SYS | SYSAUX | WRM$_SNAPSHOT_DETAILS | TABLE | 96 | 1.24 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
---|---|---|---|---|---|---|
TESTUSER | USERS | TESTTABLE | TABLE | 524 | 100.00 |
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
---|---|---|---|---|---|---|
dc_awr_control | 6 | 0.00 | 0 | 2 | 1 | |
dc_global_oids | 43 | 0.00 | 0 | 0 | 52 | |
dc_histogram_data | 314 | 0.00 | 0 | 0 | 1,359 | |
dc_histogram_defs | 2,019 | 0.05 | 0 | 0 | 4,066 | |
dc_object_grants | 19 | 0.00 | 0 | 0 | 69 | |
dc_objects | 656 | 0.91 | 0 | 0 | 1,804 | |
dc_profiles | 8 | 0.00 | 0 | 0 | 1 | |
dc_rollback_segments | 73 | 0.00 | 0 | 0 | 34 | |
dc_segments | 385 | 0.26 | 0 | 8 | 677 | |
dc_tablespaces | 891 | 0.00 | 0 | 0 | 7 | |
dc_users | 1,355 | 0.07 | 0 | 0 | 103 | |
global database name | 119 | 0.00 | 0 | 0 | 1 |
Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
---|---|---|---|---|---|---|
ACCOUNT_STATUS | 10 | 0.00 | 0 | 0 | 0 | |
BODY | 91 | 0.00 | 134 | 0.00 | 0 | 0 |
CLUSTER | 1 | 0.00 | 1 | 0.00 | 0 | 0 |
DBLINK | 10 | 0.00 | 0 | 0 | 0 | |
EDITION | 8 | 0.00 | 16 | 0.00 | 0 | 0 |
INDEX | 12 | 0.00 | 12 | 0.00 | 0 | 0 |
QUEUE | 7 | 0.00 | 29 | 0.00 | 0 | 0 |
SCHEMA | 12 | 0.00 | 0 | 0 | 0 | |
SQL AREA | 616 | 0.32 | 322,701 | -0.17 | 1 | 1 |
SQL AREA BUILD | 65 | 3.08 | 0 | 0 | 0 | |
SQL AREA STATS | 65 | 98.46 | 65 | 98.46 | 0 | 0 |
SUBSCRIPTION | 1 | 0.00 | 1 | 0.00 | 0 | 0 |
TABLE/PROCEDURE | 343 | 1.17 | 1,166 | 0.60 | 0 | 0 |
TRIGGER | 10 | 0.00 | 19 | 0.00 | 0 | 0 |
Component | Begin Snap Size (Mb) | Current Size (Mb) | Min Size (Mb) | Max Size (Mb) | Oper Count | Last Op Typ/Mod |
---|---|---|---|---|---|---|
ASM Buffer Cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
DEFAULT 16K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
DEFAULT 2K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
DEFAULT 32K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
DEFAULT 4K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
DEFAULT 8K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
DEFAULT buffer cache | 424.00 | 424.00 | 424.00 | 424.00 | 0 | INI/ |
KEEP buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
PGA Target | 496.00 | 496.00 | 496.00 | 496.00 | 0 | STA/ |
RECYCLE buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
SGA Target | 736.00 | 736.00 | 736.00 | 736.00 | 0 | STA/ |
Shared IO Pool | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
java pool | 24.00 | 24.00 | 24.00 | 24.00 | 0 | STA/ |
large pool | 8.00 | 8.00 | 8.00 | 8.00 | 0 | STA/ |
shared pool | 264.00 | 264.00 | 264.00 | 264.00 | 0 | STA/ |
streams pool | 8.00 | 8.00 | 8.00 | 8.00 | 0 | STA/ |
Category | Alloc (MB) | Used (MB) | Avg Alloc (MB) | Std Dev Alloc (MB) | Max Alloc (MB) | Hist Max Alloc (MB) | Num Proc | Num Alloc | |
---|---|---|---|---|---|---|---|---|---|
B | Other | 32.04 | 1.33 | 1.24 | 5 | 5 | 24 | 24 | |
B | SQL | 0.51 | 0.42 | 0.05 | 0.14 | 0 | 4 | 11 | 7 |
B | PL/SQL | 0.34 | 0.28 | 0.02 | 0.03 | 0 | 0 | 22 | 22 |
E | Other | 31.74 | 1.22 | 1.14 | 5 | 5 | 26 | 26 | |
E | SQL | 0.45 | 0.38 | 0.04 | 0.11 | 0 | 4 | 12 | 8 |
E | PL/SQL | 0.34 | 0.28 | 0.01 | 0.03 | 0 | 0 | 24 | 24 |
SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
---|---|---|
Database Buffers | 444,596,224 | |
Fixed Size | 1,384,856 | |
Redo Buffers | 5,246,976 | |
Variable Size | 327,159,400 |
Pool | Name | Begin MB | End MB | % Diff |
---|---|---|---|---|
java | free memory | 24.00 | 24.00 | 0.00 |
large | PX msg pool | 0.47 | 0.47 | 0.00 |
large | free memory | 7.53 | 7.53 | 0.00 |
shared | ASH buffers | 4.00 | 4.00 | 0.00 |
shared | KCB Table Scan Buffer | 4.00 | 4.00 | 0.00 |
shared | KGLH0 | 20.35 | 21.01 | 3.23 |
shared | KGLHD | 3.97 | 4.00 | 0.79 |
shared | KGLS | 10.46 | 10.47 | 0.11 |
shared | KGLSG | 3.52 | 3.52 | 0.00 |
shared | KQR M PO | 2.87 | 2.88 | 0.12 |
shared | KSFD SGA I/O b | 4.00 | 4.00 | 0.00 |
shared | PLDIA | 2.71 | 2.71 | 0.00 |
shared | PLMCD | 5.44 | 5.44 | 0.00 |
shared | SQLA | 17.64 | 19.08 | 8.16 |
shared | dbwriter coalesce buffer | 4.00 | 4.00 | 0.00 |
shared | event statistics per sess | 3.10 | 3.10 | 0.00 |
shared | free memory | 127.42 | 125.18 | -1.76 |
shared | ksunfy : SSO free list | 2.69 | 2.69 | 0.00 |
shared | row cache | 3.62 | 3.62 | 0.00 |
streams | free memory | 8.00 | 8.00 | 0.00 |
buffer_cache | 424.00 | 424.00 | 0.00 | |
fixed_sga | 1.32 | 1.32 | 0.00 | |
log_buffer | 5.00 | 5.00 | 0.00 |
Session Type | First Logon | CPU time(s) | User IO Wait time(s) | SYS IO Wait time(s) |
---|---|---|---|---|
QMON Coordinator | 0822 12:01:20 | 0.00 | 0.00 | 0.00 |
QMON Slaves | 0822 12:01:30 | 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) | 0 | 0 | 0.00 | 0.00 | ||||
SYSMAN.MGMT_TASK_Q(68711) | 10 | 10 | 0.00 | 0.00 | 0.00 | 0.01 | 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 | ||
SYSMAN.MGMT_TASK_Q(68711) | 0.06 | 0.06 | 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_3938_ORCL(41)/SYS.ALERT_QUE | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
Avg Total Connections | Avg Active Connections | Avg Total Shared Srvrs | Avg Active Shared Srvrs | Avg Total Dispatchers | Avg Active Dispatchers |
---|---|---|---|---|---|
0 | 0 | 1 | 0 | 1 | 0 |
Common Queue Per Sec | Disp Queue Per Sec | Server Msgs/Sec | Server KB/Sec | Common Queue Total | Disp Queue Total | Server Total Msgs | Server Total(KB) |
---|---|---|---|---|---|---|---|
0 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 |
Total Server Time (s) | %Busy | %Idle | Incoming Net % | Outgoing Net % |
---|---|---|---|---|
163 | 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 | 163 | 0.00 | 100.00 | 0 | 0 |
Parameter Name | Begin value | End value (if different) |
---|---|---|
audit_file_dest | C:\ORACLE\ADMIN\ORCL\ADUMP | |
audit_trail | DB | |
compatible | 11.2.0.0.0 | |
control_files | C:\ORACLE\ORADATA\ORCL\CONTROL01.CTL, C:\ORACLE\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL | |
db_block_size | 8192 | |
db_domain | usf.ad.usfood.local | |
db_name | orcl | |
db_recovery_file_dest | C:\oracle\fast_recovery_area | |
db_recovery_file_dest_size | 4353687552 | |
diagnostic_dest | C:\ORACLE | |
dispatchers | (PROTOCOL=TCP) (SERVICE=orclXDB) | |
event | 10503 trace name context forever, level 4000 | |
local_listener | LISTENER_ORCL | |
memory_target | 1291845632 | |
open_cursors | 300 | |
processes | 150 | |
remote_login_passwordfile | EXCLUSIVE | |
undo_tablespace | UNDOTBS1 |
Parameter Name | Begin value | End value (if different) |
---|---|---|
control_files | C:\ORACLE\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL | |
control_files | C:\ORACLE\ORADATA\ORCL\CONTROL01.CTL |