Using the report name awrrpt_1_112314_112315.html AWR Report

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
APPDBC2699934982appdbc1110.2.0.4.0YESerpdb-m9k-d00

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:11231405-Dec-16 13:30:1165 7.2
End Snap:11231505-Dec-16 14:00:2055 7.4
Elapsed:  30.16 (mins)  
DB Time:  2.28 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 22,960M 22,960MStd Block Size: 8K
Shared Pool Size: 13,792M 13,792MLog Buffer: 14,320K

Load Profile

Per SecondPer Transaction
Redo size: 914.66 893.57
Logical reads: 1,398.47 1,366.23
Block changes: 1.66 1.62
Physical reads: 69.33 67.73
Physical writes: 0.59 0.58
User calls: 10.38 10.14
Parses: 83.52 81.59
Hard parses: 0.03 0.03
Sorts: 3.32 3.24
Logons: 0.93 0.90
Executes: 105.66 103.22
Transactions: 1.02 

% Blocks changed per Read: 0.12Recursive Call %: 99.46
Rollback per transaction %: 99.41Rows per Sort: 58.76

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 95.04In-memory Sort %: 100.00
Library Hit %: 99.96Soft Parse %: 99.96
Execute to Parse %: 20.96Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 234.90% Non-Parse CPU: 94.87

Shared Pool Statistics

BeginEnd
Memory Usage %: 71.91 71.90
% SQL with executions>1: 99.89 99.89
% Memory for SQL w/exec>1: 99.59 99.58

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  88  64.4 
reliable message 1,894 38 20 28.0Other
db file sequential read 125,887 28 0 20.2User I/O
gc cr disk read 61,984 22 0 16.2Cluster
PX Deq Credit: send blkd 2,905 8 3 5.7Other

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 7.82 7.64
Global Cache blocks served: 6.88 6.73
GCS/GES messages received: 65.35 63.85
GCS/GES messages sent: 61.11 59.71
DBWR Fusion writes: 0.07 0.07
Estd Interconnect traffic (KB) 142.34 

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %: 94.48
Buffer access - remote cache %: 0.56
Buffer access - disk %: 4.96

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.0
Avg global cache cr block receive time (ms): 0.8
Avg global cache current block receive time (ms): 0.6
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.1
Global cache log flushes for cr blocks served %: 44.0
Avg global cache cr block flush time (ms): 0.6
Avg global cache current block pin time (ms): 0.0
Avg global cache current block send time (ms): 0.1
Global cache log flushes for current blocks served %: 0.0
Avg global cache current block flush time (ms): 0.0

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
Avg message sent queue time on ksxp (ms): 0.2
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 93.95
% of indirect sent messages: 4.34
% of flow controlled messages: 1.71


Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 132.30 96.89
DB CPU 87.93 64.40
PL/SQL execution elapsed time 5.92 4.34
connection management call elapsed time 2.29 1.68
parse time elapsed 1.70 1.24
failed parse elapsed time 0.03 0.03
hard parse elapsed time 0.02 0.02
repeated bind elapsed time 0.01 0.00
DB time 136.54  
background elapsed time 109.36  
background cpu time 47.64  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Other 47,093 83.81 61 1 25.43
User I/O 125,895 0.00 28 0 67.98
Cluster 76,559 0.00 27 0 41.34
System I/O 20,904 0.00 5 0 11.29
Concurrency 177 0.00 0 2 0.10
Application 487 0.00 0 0 0.26
Network 16,221 0.00 0 0 8.76
Commit 2 0.00 0 3 0.00
Configuration 7 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
reliable message 1,894 1.43 38 20 1.02
db file sequential read 125,887 0.00 28 0 67.97
gc cr disk read 61,984 0.00 22 0 33.47
PX Deq Credit: send blkd 2,905 40.10 8 3 1.57
PX Deq: reap credit 17,879 97.98 7 0 9.65
Streams AQ: qmn coordinator waiting for slave to start 1 100.00 5 5312 0.00
control file sequential read 19,315 0.00 5 0 10.43
gc cr block 2-way 9,041 0.00 3 0 4.88
enq: WF - contention 15 13.33 1 77 0.01
gc cr multi block request 4,723 0.00 1 0 2.55
enq: PS - contention 1,202 0.00 1 0 0.65
control file parallel write 603 0.00 0 1 0.33
wait for scn ack 337 0.00 0 1 0.18
gc current block 2-way 663 0.00 0 0 0.36
os thread startup 3 0.00 0 68 0.00
CGS wait for IPC msg 17,514 100.00 0 0 9.46
enq: JQ - contention 361 0.00 0 1 0.19
db file parallel write 610 0.00 0 0 0.33
latch free 84 0.00 0 2 0.05
SQL*Net break/reset to client 484 0.00 0 0 0.26
log file parallel write 376 0.00 0 0 0.20
gcs log flush sync 178 2.25 0 0 0.10
row cache lock 169 0.00 0 0 0.09
PX Deq: Signal ACK 1,164 49.91 0 0 0.63
enq: CF - contention 97 0.00 0 1 0.05
DFS lock handle 175 0.00 0 0 0.09
ksxr poll remote instances 3,090 82.85 0 0 1.67
IPC send completion sync 96 100.00 0 0 0.05
gc cr block congested 14 0.00 0 2 0.01
gc current grant busy 37 0.00 0 0 0.02
SQL*Net message to client 15,643 0.00 0 0 8.45
gc current grant 2-way 49 0.00 0 0 0.03
rdbms ipc reply 65 0.00 0 0 0.04
gc cr block busy 10 0.00 0 1 0.01
library cache pin 3 0.00 0 3 0.00
log file sync 2 0.00 0 3 0.00
gc cr grant 2-way 17 0.00 0 0 0.01
SQL*Net more data from client 566 0.00 0 0 0.31
gc current multi block request 19 0.00 0 0 0.01
enq: TA - contention 6 0.00 0 0 0.00
enq: HW - contention 7 0.00 0 0 0.00
gc current block busy 2 0.00 0 1 0.00
direct path write 8 0.00 0 0 0.00
enq: TM - contention 3 0.00 0 0 0.00
enq: JS - job run lock - synchronize 2 0.00 0 0 0.00
enq: FB - contention 2 0.00 0 0 0.00
enq: DR - contention 1 0.00 0 1 0.00
LGWR wait for redo copy 21 0.00 0 0 0.01
enq: AF - task serialization 1 0.00 0 1 0.00
enq: TQ - TM contention 1 0.00 0 0 0.00
library cache lock 1 0.00 0 0 0.00
SQL*Net more data from dblink 1 0.00 0 0 0.00
SQL*Net more data to client 1 0.00 0 0 0.00
SQL*Net more data to dblink 1 0.00 0 0 0.00
KJC: Wait for msg sends to complete 1 0.00 0 0 0.00
latch: cache buffers chains 1 0.00 0 0 0.00
SQL*Net message to dblink 9 0.00 0 0 0.00
PX qref latch 1 100.00 0 0 0.00
SQL*Net message from client 15,652 0.00 23,687 1513 8.45
gcs remote message 561,730 99.89 14,120 25 303.31
jobq slave wait 5,439 46.15 12,346 2270 2.94
Streams AQ: qmn slave idle wait 957 0.00 5,517 5765 0.52
wait for unread message on broadcast channel 3,938 82.50 3,419 868 2.13
PX Idle Wait 1,731 64.01 3,403 1966 0.93
Streams AQ: waiting for messages in the queue 187 96.79 1,768 9452 0.10
DIAG idle wait 9,029 0.00 1,766 196 4.88
ges remote message 27,179 94.93 1,765 65 14.68
Streams AQ: qmn coordinator idle wait 731 42.27 1,762 2410 0.39
Streams AQ: waiting for time management or cleanup tasks 8 25.00 1,758 219733 0.00
virtual circuit status 60 100.00 1,758 29297 0.03
PX Deq: Join ACK 1,750 33.94 87 50 0.94
PX Deq: Execution Msg 3,110 2.80 62 20 1.68
PX Deq: Parse Reply 1,677 33.21 0 0 0.91
SQL*Net message from dblink 8 0.00 0 19 0.00
PX Deq: Execute Reply 1,081 9.90 0 0 0.58
single-task message 1 0.00 0 63 0.00
PX Deq: Msg Fragment 147 40.82 0 0 0.08
Streams AQ: RAC qmn coordinator idle wait 734 97.82 0 0 0.40
class slave wait 3 0.00 0 1 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
events in waitclass Other 21,782 92.59 44 2 11.76
db file sequential read 37,275 0.00 8 0 20.13
gc cr disk read 18,061 0.00 6 0 9.75
control file sequential read 5,168 0.00 2 0 2.79
gc cr block 2-way 1,004 0.00 0 0 0.54
control file parallel write 603 0.00 0 1 0.33
os thread startup 3 0.00 0 68 0.00
db file parallel write 610 0.00 0 0 0.33
log file parallel write 376 0.00 0 0 0.20
row cache lock 163 0.00 0 0 0.09
gc current block 2-way 48 0.00 0 1 0.03
gc cr multi block request 8 0.00 0 0 0.00
gc cr block congested 1 0.00 0 2 0.00
gc current multi block request 1 0.00 0 1 0.00
enq: HW - contention 1 0.00 0 0 0.00
latch: cache buffers chains 1 0.00 0 0 0.00
enq: TM - contention 2 0.00 -0 -34 0.00
rdbms ipc message 32,072 87.78 28,182 879 17.32
gcs remote message 561,695 99.89 14,120 25 303.29
Streams AQ: qmn slave idle wait 594 0.00 3,700 6229 0.32
DIAG idle wait 9,028 0.00 1,766 196 4.87
ges remote message 27,180 94.93 1,765 65 14.68
pmon timer 617 100.00 1,764 2859 0.33
Streams AQ: qmn coordinator idle wait 731 42.27 1,762 2410 0.39
Streams AQ: waiting for time management or cleanup tasks 8 25.00 1,758 219733 0.00
smon timer 7 0.00 1,734 247677 0.00
PX Deq: Join ACK 6 50.00 0 1 0.00
Streams AQ: RAC qmn coordinator idle wait 734 97.82 0 0 0.40
PX Deq: Parse Reply 6 50.00 0 0 0.00
PX Deq: Execute Reply 6 50.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 4,541
AVG_IDLE_TIME 176,205
AVG_IOWAIT_TIME 0
AVG_SYS_TIME 1,406
AVG_USER_TIME 3,070
BUSY_TIME 147,261
IDLE_TIME 5,640,368
IOWAIT_TIME 0
SYS_TIME 47,024
USER_TIME 100,237
LOAD 1
OS_CPU_WAIT_TIME 50,900
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 0
VM_OUT_BYTES 0
PHYSICAL_MEMORY_BYTES 67,462,922,240
NUM_CPUS 32

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 117.40 69.10 88,322 1,849,516
appdbc 20.90 20.30 0 513,792
SYS$BACKGROUND 0.00 0.00 37,359 239,478
SYS.KUPC$C_1_20161115174523 0.00 0.00 0 0
SYS.KUPC$C_1_20161115182328 0.00 0.00 0 0
SYS.KUPC$C_1_20161124101927 0.00 0.00 0 0
SYS.KUPC$C_1_20161124103225 0.00 0.00 0 0
SYS.KUPC$S_1_20161115174523 0.00 0.00 0 0
SYS.KUPC$S_1_20161115182328 0.00 0.00 0 0
SYS.KUPC$S_1_20161124101927 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
SYS$USERS 88308 1892 6 1 0 0 14344 2
appdbc 0 0 0 0 0 0 18 0
SYS$BACKGROUND 37617 864 171 27 0 0 0 0
hrms 0 0 0 0 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
72 42 6 11.97 52.58 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
26 11 0   18.81 69atchvk0ukpy ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN SYS.DBMS_DATAPUMP.A...
26 11 581 0.04 18.71 afcz9s4uazbpk ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN :1 := sys.kupc$que_int.t...
23 23 39,844 0.00 16.57 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
21 20 1 20.65 15.12 a4fzhgvu1ccqc oracle@SGS-ORA-05 (TNS V1-V3) SELECT "A1"."CONTRACT_NUMBER",...
19 5 581 0.03 13.99 gn74qsy7sv4z4 ude@erpdb-m9k-d00 (TNS V1-V3) SELECT COUNT(*) FROM gv$datapu...
4 4 143,140 0.00 3.15 2ym6hhaq30r73   select type#, blocks, extents,...
2 1 6 0.41 1.81 bnafqqprpz3u1 sqlplus@erpdb-m9k-d00 (TNS V1-V3) select tablespace_name, use_pr...
2 2 642 0.00 1.66 3f751tsaf2j02 JDBC Thin Client SELECT VALUE FROM NLS_INSTANCE...
2 1 6 0.38 1.66 11ssd5xrck6sn JDBC Thin Client select sum("tablespace_size(M)...
2 2 11 0.14 1.14 29nxqgu4mdrnu sqlplus@erpdb-m9k-d00 (TNS V1-V3) declare v_process number; v_...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
42 72 6 6.94 52.58 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
23 23 39,844 0.00 16.57 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
20 21 1 20.03 15.12 a4fzhgvu1ccqc oracle@SGS-ORA-05 (TNS V1-V3) SELECT "A1"."CONTRACT_NUMBER",...
11 26 0   18.81 69atchvk0ukpy ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN SYS.DBMS_DATAPUMP.A...
11 26 581 0.02 18.71 afcz9s4uazbpk ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN :1 := sys.kupc$que_int.t...
5 19 581 0.01 13.99 gn74qsy7sv4z4 ude@erpdb-m9k-d00 (TNS V1-V3) SELECT COUNT(*) FROM gv$datapu...
4 4 143,140 0.00 3.15 2ym6hhaq30r73   select type#, blocks, extents,...
2 2 642 0.00 1.66 3f751tsaf2j02 JDBC Thin Client SELECT VALUE FROM NLS_INSTANCE...
2 2 11 0.14 1.14 29nxqgu4mdrnu sqlplus@erpdb-m9k-d00 (TNS V1-V3) declare v_process number; v_...
1 2 6 0.22 1.81 bnafqqprpz3u1 sqlplus@erpdb-m9k-d00 (TNS V1-V3) select tablespace_name, use_pr...
1 2 6 0.20 1.66 11ssd5xrck6sn JDBC Thin Client select sum("tablespace_size(M)...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
1,625,521 6 270,920.17 64.24 41.62 71.80 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
513,775 1 513,775.00 20.31 20.03 20.65 a4fzhgvu1ccqc oracle@SGS-ORA-05 (TNS V1-V3) SELECT "A1"."CONTRACT_NUMBER",...
429,420 143,140 3.00 16.97 4.31 4.31 2ym6hhaq30r73   select type#, blocks, extents,...
172,648 39,844 4.33 6.82 22.54 22.62 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
96,643 6 16,107.17 3.82 1.30 2.48 bnafqqprpz3u1 sqlplus@erpdb-m9k-d00 (TNS V1-V3) select tablespace_name, use_pr...
43,372 7 6,196.00 1.71 0.23 0.23 25t0tfag0pz8v   select file#, block# from seg...
21,864 6 3,644.00 0.86 1.21 2.27 11ssd5xrck6sn JDBC Thin Client select sum("tablespace_size(M)...
9,560 528 18.11 0.38 0.04 0.04 bsa0wjtftg3uw   select file# from file$ where ...
8,140 1 8,140.00 0.32 0.06 0.07 31a13pnjps7j3   SELECT source, (case w...
3,870 645 6.00 0.15 0.65 0.65 05uqdabhzncdc   select role# from defrole$ d, ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
88,091 6 14,681.83 70.23 41.62 71.80 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
37,286 39,844 0.94 29.72 22.54 22.62 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
2 1 2.00 0.00 1.15 1.15 84qubbrsr0kfn   insert into wrh$_latch (snap...
1 1 1.00 0.00 0.01 0.01 bqnn4c3gjtmgu   insert into wrh$_bg_event_summ...
1 1 1.00 0.00 0.01 0.01 g6wf9na8zs5hb   insert into wrh$_sysmetric_sum...
0 645 0.00 0.00 0.65 0.65 05uqdabhzncdc   select role# from defrole$ d, ...
0 60 0.00 0.00 0.09 0.09 08acsb3tvu4v8 JDBC Thin Client select TRUNC(sysdate - (startu...
0 1 0.00 0.00 0.00 0.00 0cn2wm9d7zq8d   SELECT decode(value, 'FATAL', ...
0 1,333 0.00 0.00 0.15 0.15 0h6b2sajwb74n   select privilege#, level from ...
0 11 0.00 0.00 0.23 0.23 0nj0ck3xqjhrg sqlplus@erpdb-m9k-d00 (TNS V1-V3) INSERT INTO AK_MON.XJ_LONG_SES...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
143,140 143,140 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
39,844 0 0.00 0.00 0.00 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
1,333 39 0.03 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
645 1,290 2.00 0.00 0.00 05uqdabhzncdc   select role# from defrole$ d, ...
642 642 1.00 0.00 0.00 3f751tsaf2j02 JDBC Thin Client SELECT VALUE FROM NLS_INSTANCE...
581 0 0.00 0.02 0.04 afcz9s4uazbpk ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN :1 := sys.kupc$que_int.t...
581 581 1.00 0.01 0.03 gn74qsy7sv4z4 ude@erpdb-m9k-d00 (TNS V1-V3) SELECT COUNT(*) FROM gv$datapu...
528 4,525 8.57 0.00 0.00 bsa0wjtftg3uw   select file# from file$ where ...
362 362 1.00 0.00 0.00 a1mbfp580hw3k   select u1.user#, u2.user#, u...
355 356 1.00 0.00 0.00 6ssrk2dqj7jbx   select job, nvl2(last_date, ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
143,140 143,140 94.73 2ym6hhaq30r73   select type#, blocks, extents,...
1,333 1,333 0.88 0h6b2sajwb74n   select privilege#, level from ...
645 645 0.43 05uqdabhzncdc   select role# from defrole$ d, ...
642 642 0.42 3f751tsaf2j02 JDBC Thin Client SELECT VALUE FROM NLS_INSTANCE...
581 581 0.38 gn74qsy7sv4z4 ude@erpdb-m9k-d00 (TNS V1-V3) SELECT COUNT(*) FROM gv$datapu...
528 528 0.35 bsa0wjtftg3uw   select file# from file$ where ...
362 0 0.24 47a50dvdgnxc2   update sys.job$ set failures=0...
362 362 0.24 a1mbfp580hw3k   select u1.user#, u2.user#, u...
362 1 0.24 aq8yqxyyb40nn   update sys.job$ set this_date=...
160 160 0.11 c4nhd1ntptxq7   select message_level, sequenc...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
6,671,607 6 0.05 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
2,564,673 1 0.02 31a13pnjps7j3   SELECT source, (case w...
2,226,039 6 0.02 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
1,706,102 1 0.01 8vkjh60z1g287   select OBJOID, CLSOID, RUNT...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
25 1 14566d856s6hs   SELECT owner# FROM sys.wri$_ad...
23 1 298ppdduqr7wm   SELECT status FROM sys.wri$_ad...
23 1 gdn3ysuyssf82   SELECT advisor_id FROM sys.wri...
21 2 10xj8nynmpqtq   SELECT dbin.db_name, dbin.ins...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)CWT % of Elapsd TimeElapsed Time(s)CPU Time(s)Executions SQL IdSQL ModuleSQL Text
18.07 25.17 71.80 41.62 6 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
6.55 28.97 22.62 22.54 39,844 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
1.38 6.67 20.65 20.03 1 a4fzhgvu1ccqc oracle@SGS-ORA-05 (TNS V1-V3) SELECT "A1"."CONTRACT_NUMBER",...
0.12 39.90 0.29 0.29 355 6ssrk2dqj7jbx   select job, nvl2(last_date, ...
0.01 0.41 2.48 1.30 6 bnafqqprpz3u1 sqlplus@erpdb-m9k-d00 (TNS V1-V3) select tablespace_name, use_pr...
0.01 30.40 0.02 0.02 3 c7sn076yz7030   select smontabv.cnt, smontab....

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
05uqdabhzncdcselect role# from defrole$ d, user$ u where d.user#=:1 and u.user#=d.user# and u.defrole=2 union select privilege# from sysauth$ s, user$ u where (grantee#=:1 or grantee#=1) and privilege#>0 and not exists (select null from defrole$ where user#=:1 and role#=s.privilege#) and u.user#=:1 and u.defrole=3
08acsb3tvu4v8select TRUNC(sysdate - (startup_time))||'day(s), '||TRUNC(24*((sysdate-startup_time) -TRUNC(sysdate-startup_time))) ||'hour(s), '||MOD(TRUNC(1440*((SYSDATE-startup_time)- TRUNC(sysdate-startup_time))), 60) ||'minutes(s), '||MOD(TRUNC(86400*((SYSDATE-STARTUP_TIME)- TRUNC(SYSDATE-startup_time))), 60) ||'seconds' uptime from v$instance
0cn2wm9d7zq8dSELECT decode(value, 'FATAL', 1, 'ERROR', 2, 'WARNING', 3, 'INFORMATION', 4, 'INFORMATION2', 5, 'INFORMATION3', 6, 'INFORMATION4', 7, 'INFORMATION5', 8, 'INFORMATION6', 9, 0) FROM sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0nj0ck3xqjhrgINSERT INTO AK_MON.XJ_LONG_SES_MONI(INSTANCE_NAME, COLLECT_DATE, ADDR, XID, START_SCN, USERNAME, PROGRAM, SQL_ID, LONG_OPS, STATUS, SQL_TEXT, PREV_SQL_TEXT, KILL_STATUS) SELECT :B1 INSTANCE_NAME, SYSDATE, T.ADDR, T.XID, T.START_SCN, S.USERNAME, S.PROGRAM, S.SQL_ID, (SYSDATE-T.START_DATE)*24 LONG_OPS, T.STATUS, (SELECT SQL_TEXT FROM V$SQLAREA X WHERE X.SQL_ID = S.SQL_ID) SQL_TEXT, (SELECT SQL_TEXT FROM V$SQLAREA X WHERE X.SQL_ID = S.PREV_SQL_ID) PREV_SQL_TEXT, 1 KILL_STATUS FROM V$SESSION S, V$TRANSACTION T WHERE T.ADDR=S.TADDR AND S.USERNAME IS NOT NULL AND SYSDATE-T.START_DATE>1/18
0yt1b8mbz63nk SELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file# , greatest(e.block_id, c.block#) corr_start_block# , least(e.block_id+e.blocks-1, c.block#+c.blocks-1) corr_end_block# , least(e.block_id+e.blocks-1, c.block#+c.blocks-1) - greatest(e.block_id, c.block#) + 1 blocks_corrupted , corruption_type description FROM dba_extents e, v$database_block_corruption c WHERE e.file_id = c.file# AND e.block_id <= c.block# + c.blocks - 1 AND e.block_id + e.blocks - 1 >= c.block# UNION SELECT s.owner, s.segment_type, s.segment_name, s.partition_name, c.file# , header_block corr_start_block# , header_block corr_end_block# , 1 blocks_corrupted , corruption_type||' Segment Header' description FROM dba_segments s, v$database_block_corruption c WHERE s.header_file = c.file# AND s.header_block between c.block# and c.block# + c.blocks - 1 UNION SELECT null owner, null segment_type, null segment_name, null partition_name, c.file# , greatest(f.block_id, c.block#) corr_start_block# , least(f.block_id+f.blocks-1, c.block#+c.blocks-1) corr_end_block# , least(f.block_id+f.blocks-1, c.block#+c.blocks-1) - greatest(f.block_id, c.block#) + 1 blocks_corrupted , 'Free Block' description FROM dba_free_space f, v$database_block_corruption c WHERE f.file_id = c.file# AND f.block_id <= c.block# + c.blocks - 1 AND f.block_id + f.blocks - 1 >= c.block# order by file#, corr_start_block#
10xj8nynmpqtq SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time
11ssd5xrck6sn select sum("tablespace_size(M)") from ( select t2.tablespace_size "tablespace_size(M)", t2.tablespace_size - nvl(t1.free_size, 0) "used_size(M)", nvl(t1.free_size, 0) "free_size(M)", round((t2.tablespace_size - nvl(t1.free_size, 0))*100/t2.tablespace_size, 2) "used_percentage(%)" from dba_tablespaces t0, (select tablespace_name, round(sum(bytes)/1024/1024) free_size from dba_free_space group by tablespace_name) t1, (select tablespace_name, round(sum(bytes)/1024/1024) tablespace_size from dba_data_files group by tablespace_name) t2 where t0.tablespace_name = t1.tablespace_name(+) and t0.tablespace_name = t2.tablespace_name(+) and not (t0.extent_management like 'LOCAL' and t0.contents like 'TEMPORARY') union all select t2.tablespace_size "tablespace_size(M)", nvl(t1.used_size, 0) "used_size(M)", t2.tablespace_size - nvl(t1.used_size, 0) "free_size(M)", round(nvl(t1.used_size, 0)*100/t2.tablespace_size, 2) "used_percentage(%)" from dba_tablespaces t0, (select tablespace_name, round(sum(bytes_cached)/1024/1024) used_size from v$temp_extent_pool group by tablespace_name) t1, (select tablespace_name, round(sum(bytes)/1024/1024) tablespace_size from dba_temp_files group by tablespace_name) t2 where t0.tablespace_name = t1.tablespace_name(+) and t0.tablespace_name = t2.tablespace_name(+) and t0.extent_management like 'LOCAL' and t0.contents like 'TEMPORARY')
14566d856s6hsSELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1
25t0tfag0pz8vselect file#, block# from seg$ where ts# = :1
298ppdduqr7wmSELECT status FROM sys.wri$_adv_tasks WHERE id = :1
29nxqgu4mdrnu declare v_process number; v_sid number; v_serail number; v_status varchar2(30); v_count number; v_inst_num number; begin select INSTANCE_NUMBER into v_inst_num from v$instance; --parallel sql insert into ak_mon.High_parall_sql (collect_date, inst_num, username, sql_id, program, parall_cnt, sql_text) select sysdate collect_date, v_inst_num inst_num, username, a.sql_id, program, parall_cnt, sql_text from (select username, sql_id, program, count(*) parall_cnt from (select username, sql_id, program from v$session where status = 'ACTIVE' AND SQL_ID is not null union all select username, PREV_SQL_ID as sql_id, program from v$session where PREV_SQL_ID is not null and status = 'ACTIVE') group by username, sql_id, program having count(*) > 5) a, v$sqlarea sqlarea where a.sql_id = sqlarea.sql_id; insert into ak_mon.session_lock_longops select sysdate collect_date, v_inst_num inst_num, a.sid, b.serial#, a.type, a.id1, a.id2, a.LMODE, a.REQUEST, a.CTIME, a.BLOCK, b.username, b.program, b.machine, b.sql_id, (select sql_ text from v$sqlarea x where x.sql_id = b.sql_id) sql_text, b.PREV_SQL_ID, (select sql_text from v$sqlarea x where x.sql_id = b.PREV_SQL_ID) PREV_SQL_TEXT, b.status, p.spid, a.addr, --case when exists (select 1 from ak_mon.filter_program where (FILTER_TYPE='2' and filter_str=(upper(b.username))) or (FILTER_TYPE='1' and filter_str=upper(substr(b.program, 1, Instr(b.program, '@', 1)-1))) ) then 0 else 1 end kill_status, 1, b.event from v$lock a, v$session b, v$process p where a.TYPE in ('TX', 'TM') ----²éɱµÄËøÀàÐÍ and a.sid = b.sid and b.paddr = p.addr and a.ctime >= 300 --upper(b.program) like 'JDBC%') or --(upper(b.program) like 'SQLPLUS%' and a.ctime >= 0)) --ʱ¼äÏÞÖÆ --a.ctime >= 0) --ʱ¼äÏÞÖÆ and a.lmode > 0 and a.REQUEST = 0 and a.block = 1 and b.username is not null; commit; for x in (select distinct a.sid, b.serial# from v$lock a, v$session b where a.TYPE in ('TM', 'TX') and a.sid = b.sid and a.ctime >= 300 --upper(b.program) like 'JDBC%') or --(upper(b.program) like 'SQLPLUS%' and a.ctime >= 0)) --a.ctime >= 0) and b.username is not null --and not exists (select 1 from ak_mon.filter_program where (FILTER_TYPE='2' and filter _str=(upper(b.username))) or (FILTER_TYPE='1' and filter_str=upper(substr(b.program, 1, Instr(b.program, '@', 1)-1))) ) and a.lmode > 0 and a.block = 1 and a.REQUEST = 0) loop select b.spid into v_process from v$session a, v$process b where a.paddr = b.addr and a.status<>'KILLED' and a.serial#=x.serial# and a.sid = x.sid; dbms_output.put_line('ps -ef|grep '||to_char(v_process)||'|grep LOCAL=NO|awk ''{print -9 $2}''|xargs kill'); end loop; commit; insert into ak_mon.session_wait_longops select sysdate collect_date, v_inst_num inst_num, a.username, a.sid, a.serial#, a.program, a.machine, a.sql_id, a.event, a.SECONDS_IN_WAIT, (select sql_text from v$sqlarea x where x.sql_id=a.sql_id) sql_text, a.PREV_SQL_ID, (select sql_text from v$sqlarea x where x.sql_id=a.PREV_SQL_ID) PREV_SQL_TEXT from v$session a where WAIT_CLASS#<>6 and username is not null and WAIT_TIME =0 and status='ACTIVE' and SECONDS_IN_WAIT>0; commit; end;
2ym6hhaq30r73select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
31a13pnjps7j3 SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
37k9g8mgfh7h8select 1 from x$ktfbue where ktfbuesegtsn = :1 and ktfbuesegfno = :2 and ktfbuesegbno = :3 and ktfbuefno = :4 and ktfbuebno <= :5 and (ktfbuebno+ktfbueblks) > :5
3f751tsaf2j02SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'
47a50dvdgnxc2update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4
69atchvk0ukpyBEGIN SYS.DBMS_DATAPUMP.ADD_FILE( handle => :JOBHNDL, filename => :FILENAME, directory => :DIRECTORY, filesize => :FILESIZE, filetype => :FILETYPE); END;
6ssrk2dqj7jbxselect job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job
84qubbrsr0kfninsert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash
8vkjh60z1g287 select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
a1mbfp580hw3kselect u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1 from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name
a4fzhgvu1ccqcSELECT "A1"."CONTRACT_NUMBER", "A1"."BOE_ID", "A1"."BOE_NUM", "A1"."BOE_TYPE", "A1"."BOE_DATE", "A1"."USERID", "A1"."EMPLOYEE_NAME", "A1"."DEPT_NAME", "A1"."CURRENT_STATUS", "A1"."BOE_STATUS", "A1"."APPLY_AMOUNT", "A1"."PAY_AMOUNT", "A1"."PAY_DATE", "A1"."LAST_MODIFY_DATE", "A1"."RECEIVE_PAY_FLAG" FROM "APPS"."CMS_INF_BOE_CONTRACTS_V" "A1" WHERE "A1"."LAST_MODIFY_DATE">SYSDATE@!-33/24/60
afcz9s4uazbpkBEGIN :1 := sys.kupc$que_int.transceive_int(:2, :3, :4, :5, :6); END;
aq8yqxyyb40nnupdate sys.job$ set this_date=:1 where job=:2
bnafqqprpz3u1select tablespace_name, use_precent from (select b.tablespace_name, round(sum(b.bytes)/1024/1024, 0) sum_MB, round(sum(nvl(a.bytes, 0))/1024/1024, 0) free_MB, round((sum(b.bytes)-sum(nvl(a.bytes, 0)))/sum(b.bytes), 2)*100 use_precent from (select tablespace_name, file_id, sum(bytes) bytes from dba_free_space group by tablespace_name, file_id ) a, dba_data_files b where a.file_id(+)=b.file_id and a.tablespace_name(+)=b.tablespace_name and b.tablespace_name like '%%' group by b.tablespace_name order by 4) where use_precent>95
bqnn4c3gjtmguinsert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select /*+ ordered use_nl(e) */ :snap_id, :dbid, :instance_number, e.event_id, sum(e.total_waits), sum(e.total_timeouts), sum(e.time_waited_micro) from v$session bgsids, v$session_event e where bgsids.type = 'BACKGROUND' and bgsids.sid = e.sid group by e.event_id
bsa0wjtftg3uwselect file# from file$ where ts#=:1
c4nhd1ntptxq7select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING where reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instance_number = :4
c7sn076yz7030select smontabv.cnt, smontab.time_mp, smontab.scn, smontab.num_mappings, smontab.tim_scn_map, smontab.orig_thread from smon_scn_time smontab, (select max(scn) scnmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt from smon_scn_time where thread=0) smontabv where smontab.scn = smontabv.scnmax and thread=0
g6wf9na8zs5hbinsert into wrh$_sysmetric_summary (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, num_interval, maxval, minval, average, standard_deviation) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, numintv, max, min, avg, std FROM x$kewmsmdv WHERE groupid = 2
gdn3ysuyssf82SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
gn74qsy7sv4z4SELECT COUNT(*) FROM gv$datapump_job WHERE job_id = :1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 11,095 6.13 5.99
CPU used when call started 8,682 4.80 4.69
CR blocks created 181 0.10 0.10
Cached Commit SCN referenced 38,312 21.18 20.69
Commit SCN cached 2 0.00 0.00
DB time 566,740 313.24 306.02
DBWR checkpoint buffers written 950 0.53 0.51
DBWR checkpoints 0 0.00 0.00
DBWR fusion writes 125 0.07 0.07
DBWR object drop buffers written 0 0.00 0.00
DBWR parallel query checkpoint buffers written 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 23 0.01 0.01
DBWR undo block writes 311 0.17 0.17
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 586 0.32 0.32
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 3,498 1.93 1.89
PX local messages sent 3,498 1.93 1.89
PX remote messages recv'd 1,323 0.73 0.71
PX remote messages sent 2,427 1.34 1.31
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 586 0.32 0.32
RowCR - row contention 0 0.00 0.00
RowCR attempts 0 0.00 0.00
RowCR hits 0 0.00 0.00
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 13,751 7.60 7.42
SQL*Net roundtrips to/from dblink 9 0.00 0.00
active txn count during cleanout 80 0.04 0.04
application wait time 15 0.01 0.01
background checkpoints completed 0 0.00 0.00
background checkpoints started 0 0.00 0.00
background timeouts 8,213 4.54 4.43
branch node splits 1 0.00 0.00
buffer is not pinned count 935,109 516.83 504.92
buffer is pinned count 657,172 363.22 354.84
bytes received via SQL*Net from client 1,925,931 1,064.46 1,039.92
bytes received via SQL*Net from dblink 4,628 2.56 2.50
bytes sent via SQL*Net to client 743,546 410.96 401.48
bytes sent via SQL*Net to dblink 4,626 2.56 2.50
calls to get snapshot scn: kcmgss 496,696 274.52 268.19
calls to kcmgas 126,708 70.03 68.42
calls to kcmgcs 44 0.02 0.02
change write time 2 0.00 0.00
cleanout - number of ktugct calls 290 0.16 0.16
cleanouts and rollbacks - consistent read gets 1 0.00 0.00
cleanouts only - consistent read gets 181 0.10 0.10
cluster key scan block gets 556,192 307.41 300.32
cluster key scans 354,385 195.87 191.35
cluster wait time 2,627 1.45 1.42
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 0 0.00 0.00
commit batch/immediate requested 0 0.00 0.00
commit cleanout failures: block lost 0 0.00 0.00
commit cleanout failures: callback failure 13 0.01 0.01
commit cleanout failures: cannot pin 0 0.00 0.00
commit cleanouts 475 0.26 0.26
commit cleanouts successfully completed 462 0.26 0.25
commit immediate performed 0 0.00 0.00
commit immediate requested 0 0.00 0.00
commit txn count during cleanout 243 0.13 0.13
concurrency wait time 28 0.02 0.02
consistent changes 802 0.44 0.43
consistent gets 2,488,697 1,375.50 1,343.79
consistent gets - examination 571,927 316.10 308.82
consistent gets direct 0 0.00 0.00
consistent gets from cache 2,488,695 1,375.50 1,343.79
current blocks converted for CR 0 0.00 0.00
cursor authentications 0 0.00 0.00
data blocks consistent reads - undo records applied 3 0.00 0.00
db block changes 2,998 1.66 1.62
db block gets 41,472 22.92 22.39
db block gets direct 26 0.01 0.01
db block gets from cache 41,446 22.91 22.38
deferred (CURRENT) block cleanout applications 210 0.12 0.11
dirty buffers inspected 0 0.00 0.00
enqueue conversions 2,712 1.50 1.46
enqueue releases 198,231 109.56 107.04
enqueue requests 198,281 109.59 107.06
enqueue timeouts 47 0.03 0.03
enqueue waits 1,695 0.94 0.92
exchange deadlocks 0 0.00 0.00
execute count 191,172 105.66 103.22
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 13,027 7.20 7.03
free buffer requested 139,900 77.32 75.54
gc CPU used by this session 2,739 1.51 1.48
gc blocks lost 0 0.00 0.00
gc cr block build time 1 0.00 0.00
gc cr block flush time 10 0.01 0.01
gc cr block receive time 1,005 0.56 0.54
gc cr block send time 3 0.00 0.00
gc cr blocks received 13,327 7.37 7.20
gc cr blocks served 407 0.22 0.22
gc current block flush time 0 0.00 0.00
gc current block pin time 10 0.01 0.01
gc current block receive time 46 0.03 0.02
gc current block send time 84 0.05 0.05
gc current blocks received 821 0.45 0.44
gc current blocks served 12,050 6.66 6.51
gc local grants 63,107 34.88 34.08
gc remote grants 62,487 34.54 33.74
gcs messages sent 105,419 58.27 56.92
ges messages sent 5,155 2.85 2.78
global enqueue get time 325 0.18 0.18
global enqueue gets async 174 0.10 0.09
global enqueue gets sync 163,128 90.16 88.08
global enqueue releases 160,562 88.74 86.70
heap block compress 7 0.00 0.00
hot buffers moved to head of LRU 329 0.18 0.18
immediate (CR) block cleanout applications 182 0.10 0.10
immediate (CURRENT) block cleanout applications 97 0.05 0.05
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 2,354 1.30 1.27
index fast full scans (full) 1 0.00 0.00
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 715,657 395.54 386.42
index scans kdiixs1 3,813 2.11 2.06
leaf node 90-10 splits 10 0.01 0.01
leaf node splits 26 0.01 0.01
lob reads 0 0.00 0.00
lob writes 4 0.00 0.00
lob writes unaligned 4 0.00 0.00
logons cumulative 1,674 0.93 0.90
messages received 1,295 0.72 0.70
messages sent 1,295 0.72 0.70
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 1,544,872 853.85 834.16
opened cursors cumulative 151,576 83.78 81.84
parse count (failures) 61 0.03 0.03
parse count (hard) 61 0.03 0.03
parse count (total) 151,111 83.52 81.59
parse time cpu 451 0.25 0.24
parse time elapsed 192 0.11 0.10
physical read IO requests 125,440 69.33 67.73
physical read bytes 1,027,604,480 567,956.62 554,862.03
physical read total IO requests 144,969 80.12 78.28
physical read total bytes 1,345,519,616 743,668.20 726,522.47
physical read total multi block requests 0 0.00 0.00
physical reads 125,440 69.33 67.73
physical reads cache 125,440 69.33 67.73
physical reads cache prefetch 0 0.00 0.00
physical reads direct 0 0.00 0.00
physical reads direct (lob) 0 0.00 0.00
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 643 0.36 0.35
physical write bytes 8,765,440 4,844.66 4,732.96
physical write total IO requests 2,825 1.56 1.53
physical write total bytes 40,356,352 22,304.94 21,790.69
physical write total multi block requests 161 0.09 0.09
physical writes 1,070 0.59 0.58
physical writes direct 26 0.01 0.01
physical writes direct (lob) 6 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 1,044 0.58 0.56
physical writes non checkpoint 665 0.37 0.36
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
prefetched blocks aged out before use 24 0.01 0.01
process last non-idle time 1,791 0.99 0.97
queries parallelized 586 0.32 0.32
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 3,470,055 1,917.90 1,873.68
recursive cpu usage 2,758 1.52 1.49
redo blocks written 3,909 2.16 2.11
redo buffer allocation retries 0 0.00 0.00
redo entries 2,705 1.50 1.46
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 89 0.05 0.05
redo size 1,654,892 914.66 893.57
redo subscn max counts 97 0.05 0.05
redo synch time 0 0.00 0.00
redo synch writes 3 0.00 0.00
redo wastage 129,512 71.58 69.93
redo write time 19 0.01 0.01
redo writer latching time 0 0.00 0.00
redo writes 376 0.21 0.20
rollback changes - undo records applied 0 0.00 0.00
rollbacks only - consistent read gets 2 0.00 0.00
rows fetched via callback 181,054 100.07 97.76
session connect time 0 0.00 0.00
session cursor cache hits 144,798 80.03 78.18
session logical reads 2,530,259 1,398.47 1,366.23
session pga memory 77,475,708,152 42,820,795.52 41,833,535.72
session pga memory max 77,885,963,512 43,047,543.51 42,055,055.89
session uga memory 4,338,278,424 2,397,764.90 2,342,482.95
session uga memory max 1,012,370,736 559,536.93 546,636.47
shared hash latch upgrades - no wait 2,404 1.33 1.30
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 6,002 3.32 3.24
sorts (rows) 352,685 194.93 190.43
sql area evicted 0 0.00 0.00
sql area purged 61 0.03 0.03
summed dirty queue length 0 0.00 0.00
switch current to new buffer 2 0.00 0.00
table fetch by rowid 187,135 103.43 101.04
table fetch continued row 0 0.00 0.00
table scan blocks gotten 974,170 538.42 526.01
table scan rows gotten 37,517,636 20,735.98 20,257.90
table scans (direct read) 0 0.00 0.00
table scans (long tables) 0 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 80,018 44.23 43.21
total number of times SMON posted 7 0.00 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 0 0.00 0.00
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
undo change vector size 469,212 259.33 253.35
user I/O wait time 2,747 1.52 1.48
user calls 18,783 10.38 10.14
user commits 11 0.01 0.01
user rollbacks 1,841 1.02 0.99
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 3,763 2.08 2.03
write clones created in background 0 0.00 0.00
write clones created in foreground 0 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 6,147,349 6,152,670
opened cursors current 465 407
logons current 65 55

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 0 0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
EAS_DATA 69,591 38 0.22 1.00 0 0 0 0.00
USERS 22,510 12 0.22 1.00 15 0 0 0.00
SYSAUX 11,975 7 0.24 1.00 415 0 0 0.00
DAT_EPM 7,726 4 0.21 1.00 0 0 0 0.00
SYSTEM 7,379 4 0.19 1.00 27 0 0 0.00
EPM_GD_DATA 2,805 2 0.19 1.00 0 0 0 0.00
AUDIT_DATA 1,261 1 0.25 1.00 0 0 0 0.00
DAT_PAMS 1,092 1 0.22 1.00 0 0 0 0.00
DAT_EVSAS 552 0 0.20 1.00 109 0 0 0.00
EAS_DATA_NEW 591 0 0.29 1.00 1 0 0 0.00
EIP_DATA 388 0 0.13 1.00 0 0 0 0.00
IDX_PAMS 342 0 0.18 1.00 0 0 0 0.00
EAS_IND 306 0 0.23 1.00 0 0 0 0.00
MOB_DATA 198 0 0.10 1.00 0 0 0 0.00
TDEIP_DATA 96 0 0.21 1.00 0 0 0 0.00
UNDOTBS1 0 0 0.00 0.00 76 0 0 0.00
SIED 24 0 0.00 1.00 0 0 0 0.00
DAT_HRMS 14 0 0.71 1.00 0 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
AUDIT_DATA /dev/vx/rdsk/racdg/datafile69 1,261 1 0.25 1.00 0 0 0 0.00
DAT_EPM /dev/vx/rdsk/racdg/datafile304 110 0 0.18 1.00 0 0 0 0.00
DAT_EPM /dev/vx/rdsk/racdg/datafile52 3,829 2 0.22 1.00 0 0 0 0.00
DAT_EPM /dev/vx/rdsk/racdg/datafile53 3,787 2 0.20 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile103 6 0 0.00 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile109 18 0 0.56 1.00 1 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile333 24 0 0.42 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile36 270 0 0.15 1.00 7 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile37 54 0 0.37 1.00 1 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile373 6 0 1.67 1.00 41 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile374 18 0 0.00 1.00 23 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile38 12 0 0.83 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile388 12 0 0.00 1.00 36 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile72 30 0 0.00 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile81 90 0 0.11 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile82 12 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile370 14 0 0.71 1.00 0 0 0 0.00
DAT_PAMS /dev/vx/rdsk/racdg/datafile29 1,092 1 0.22 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile01 2,148 1 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile05 1,431 1 0.18 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile07 1,665 1 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile08 6,389 4 0.22 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile09 1,649 1 0.28 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile10 4,712 3 0.22 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile100 811 0 0.22 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile104 2,668 1 0.23 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile108 693 0 0.20 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile11 2,724 2 0.27 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile113 247 0 0.08 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile116 104 0 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile119 78 0 0.51 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile120 26 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile121 52 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile122 26 0 0.38 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile123 13 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile125 78 0 0.38 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile126 13 0 0.77 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile127 468 0 0.19 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile128 39 0 0.26 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile129 117 0 0.26 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile130 52 0 0.19 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile132 52 0 0.38 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile133 26 0 0.38 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile134 39 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile135 13 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile137 26 0 0.77 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile300 39 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile301 39 0 0.51 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile302 65 0 0.15 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile303 65 0 0.15 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile306 26 0 0.38 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile307 1,352 1 0.28 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile308 481 0 0.15 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile309 212 0 0.09 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile310 377 0 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile311 247 0 0.20 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile312 104 0 0.19 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile313 601 0 0.42 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile314 313 0 0.35 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile315 416 0 0.12 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile316 755 0 0.19 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile317 494 0 0.20 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile318 377 0 0.19 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile319 1,936 1 0.27 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile320 2,104 1 0.19 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile321 1,316 1 0.27 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile334 2,858 2 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile335 1,538 1 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile336 1,368 1 0.19 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile340 580 0 0.26 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile343 527 0 0.17 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile344 616 0 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile345 211 0 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile346 2,051 1 0.23 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile347 810 0 0.17 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile348 655 0 0.20 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile349 354 0 0.14 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile350 409 0 0.17 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile351 208 0 0.14 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile352 104 0 0.10 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile353 40 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile354 13 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile355 5,726 3 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile356 52 0 0.38 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile357 104 0 0.19 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile358 132 0 0.23 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile377 198 0 0.30 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile383 1,846 1 0.25 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile384 824 0 0.27 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile385 612 0 0.18 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile386 265 0 0.11 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile390 247 0 0.36 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile391 26 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile55 1,589 1 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile75 1,160 1 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile76 1,054 1 0.19 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile87 2,350 1 0.19 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile88 1,232 1 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile99 2,154 1 0.21 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile409 12 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile410 36 0 0.56 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile411 6 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile412 18 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile413 24 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile414 18 0 0.56 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile415 18 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile416 73 0 0.27 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile417 54 0 0.37 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile418 36 0 0.56 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile419 30 0 0.33 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile420 30 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile421 56 0 0.36 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile422 54 0 0.56 1.00 1 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile423 18 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile424 24 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile425 24 0 0.83 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile426 24 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile427 12 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile428 24 0 0.00 1.00 0 0 0 0.00
EAS_IND /dev/vx/rdsk/racdg/datafile02 162 0 0.31 1.00 0 0 0 0.00
EAS_IND /dev/vx/rdsk/racdg/datafile06 144 0 0.14 1.00 0 0 0 0.00
EIP_DATA /dev/vx/rdsk/racdg/datafile03 388 0 0.13 1.00 0 0 0 0.00
EPM_GD_DATA /dev/vx/rdsk/racdg/datafile378 2,805 2 0.19 1.00 0 0 0 0.00
IDX_PAMS /dev/vx/rdsk/racdg/datafile26 342 0 0.18 1.00 0 0 0 0.00
MOB_DATA /dev/vx/rdsk/racdg/datafile31 198 0 0.10 1.00 0 0 0 0.00
SIED /dev/vx/rdsk/racdg/datafile25 24 0 0.00 1.00 0 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile105 34 0 0.29 1.00 6 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile111 66 0 0.30 1.00 2 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile131 9 0 3.33 1.00 6 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile22 84 0 1.90 1.00 98 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile331 1 0 10.00 1.00 5 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile56 16 0 1.25 1.00 51 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile71 13 0 4.62 1.00 33 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile89 5 0 6.00 1.00 40 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile90 142 0 0.42 1.00 15 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/sysaux01 11,605 6 0.21 1.00 159 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/appdbc_system03 62 0 0.32 1.00 1 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile328 410 0 0.12 1.00 2 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile341 134 0 0.37 1.00 0 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile97 48 0 0.21 1.00 0 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/system01 6,670 4 0.19 1.00 24 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/system02 55 0 0.00 1.00 0 0 0 0.00
TDEIP_DATA /dev/vx/rdsk/racdg/datafile58 96 0 0.21 1.00 0 0 0 0.00
UNDOTBS1 /dev/vx/rdsk/racdg/datafile381 0 0     51 0 0 0.00
UNDOTBS1 /dev/vx/rdsk/racdg/undotbs01a 0 0     24 0 0 0.00
UNDOTBS1 /dev/vx/rdsk/racdg/undotbs01c 0 0     1 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile106 1,635 1 0.27 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile115 911 1 0.14 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile117 3,037 2 0.22 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile139 654 0 0.23 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile21 913 1 0.24 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile330 5,006 3 0.20 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile342 2,120 1 0.22 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile382 754 0 0.20 1.00 14 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile91 169 0 0.18 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile96 3,540 2 0.22 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/users01 3,771 2 0.22 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 2,753,762 95 2,536,461 125,443 1,044 0 0 0


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 0 694 8174 12485 2147310 12485  
E 0 0 229 1215 1689 2147310 1689  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 2,288 0.10 274,417 5.25 1,089,146,177
D 4,576 0.20 548,834 3.05 634,059,484
D 6,864 0.30 823,251 1.63 338,692,700
D 9,152 0.40 1,097,668 1.30 270,833,747
D 11,440 0.50 1,372,085 1.21 250,641,665
D 13,728 0.60 1,646,502 1.14 237,631,102
D 16,016 0.70 1,920,919 1.10 228,734,598
D 18,304 0.80 2,195,336 1.06 219,365,643
D 20,592 0.90 2,469,753 1.03 213,244,999
D 22,880 1.00 2,744,170 1.00 207,692,264
D 22,960 1.00 2,753,765 1.00 207,564,649
D 25,168 1.10 3,018,587 0.98 202,845,953
D 27,456 1.20 3,293,004 0.96 200,143,158
D 29,744 1.30 3,567,421 0.95 198,151,085
D 32,032 1.40 3,841,838 0.95 196,795,656
D 34,320 1.49 4,116,255 0.94 196,013,870
D 36,608 1.59 4,390,672 0.94 195,380,510
D 38,896 1.69 4,665,089 0.94 194,428,500
D 41,184 1.79 4,939,506 0.93 192,929,094
D 43,472 1.89 5,213,923 0.90 187,768,850
D 45,760 1.99 5,488,340 0.82 169,407,366

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 793 0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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 MemGlobal Mem Bound(K)
B 4,096 1,412 2,796.49 1.81 0.06 100.00 0.00 419,430
E 4,096 1,440 2,779.74 0.00 0.00 0.00 0.00 419,430

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 3,271 3,271 0 0
64K 128K 44 44 0 0
512K 1024K 389 389 0 0
1M 2M 56 56 0 0
2M 4M 1 1 0 0
4M 8M 2 2 0 0
8M 16M 1 1 0 0
64M 128M 1 1 0 0
128M 256M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
512 0.13 16,021,649.07 956,467.51 94.00 12,153
1,024 0.25 16,021,649.07 859,510.28 95.00 11,057
2,048 0.50 16,021,649.07 254,210.77 98.00 3,032
3,072 0.75 16,021,649.07 29,596.26 100.00 0
4,096 1.00 16,021,649.07 29,596.26 100.00 0
4,915 1.20 16,021,649.07 24,239.42 100.00 0
5,734 1.40 16,021,649.07 24,239.42 100.00 0
6,554 1.60 16,021,649.07 24,239.42 100.00 0
7,373 1.80 16,021,649.07 24,239.42 100.00 0
8,192 2.00 16,021,649.07 24,239.42 100.00 0
12,288 3.00 16,021,649.07 24,239.42 100.00 0
16,384 4.00 16,021,649.07 24,239.42 100.00 0
24,576 6.00 16,021,649.07 24,239.42 100.00 0
32,768 8.00 16,021,649.07 24,239.42 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
2,672 0.19 1,485 60,932 6,814,138 0.99 81,408 4.84 861,169,234
4,064 0.29 2,874 78,980 6,859,571 1.00 35,975 2.14 861,305,970
5,456 0.40 4,263 115,465 6,873,152 1.00 22,394 1.33 861,355,260
6,848 0.50 5,651 130,302 6,876,560 1.00 18,986 1.13 861,362,080
8,240 0.60 7,032 196,434 6,878,725 1.00 16,821 1.00 861,364,593
9,632 0.70 8,408 242,343 6,878,735 1.00 16,811 1.00 861,365,160
11,024 0.80 8,941 258,564 6,878,735 1.00 16,811 1.00 861,365,192
12,416 0.90 9,042 266,188 6,878,735 1.00 16,811 1.00 861,365,218
13,808 1.00 9,042 266,188 6,878,735 1.00 16,811 1.00 861,365,218
15,200 1.10 9,042 266,188 6,878,735 1.00 16,811 1.00 861,365,218
16,592 1.20 9,042 266,188 6,878,735 1.00 16,811 1.00 861,365,218
17,984 1.30 9,042 266,188 6,878,735 1.00 16,811 1.00 861,365,218
19,376 1.40 9,042 266,188 6,878,735 1.00 16,811 1.00 861,365,218
20,768 1.50 9,042 266,188 6,878,735 1.00 16,811 1.00 861,365,218
22,160 1.60 9,042 266,188 6,878,735 1.00 16,811 1.00 861,365,218
23,552 1.71 9,042 266,188 6,878,735 1.00 16,811 1.00 861,365,218
24,944 1.81 9,042 266,188 6,878,735 1.00 16,811 1.00 861,365,218
26,336 1.91 9,042 266,188 6,878,735 1.00 16,811 1.00 861,365,218
27,728 2.01 9,042 266,188 6,878,735 1.00 16,811 1.00 861,365,218

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
9,216 0.25 1,049,388 664,141,613
18,432 0.50 900,305 262,530,931
27,648 0.75 887,369 229,779,424
36,864 1.00 880,064 207,550,740
46,080 1.25 878,744 203,648,786
55,296 1.50 870,119 177,435,128
64,512 1.75 870,119 177,435,128
73,728 2.00 870,119 177,435,128

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
16 1.00 0 0 0 0
32 2.00 0 0 0 0
48 3.00 0 0 0 0
64 4.00 0 0 0 0
80 5.00 0 0 0 0
96 6.00 0 0 0 0
112 7.00 0 0 0 0
128 8.00 0 0 0 0
144 9.00 0 0 0 0
160 10.00 0 0 0 0
176 11.00 0 0 0 0
192 12.00 0 0 0 0
208 13.00 0 0 0 0
224 14.00 0 0 0 0
240 15.00 0 0 0 0
256 16.00 0 0 0 0
272 17.00 0 0 0 0
288 18.00 0 0 0 0
304 19.00 0 0 0 0
320 20.00 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
WF-AWR Flush 21 21 0 12 1 98.33
PS-PX Process Reservation 4,163 4,116 47 1,202 0 0.41
JQ-Job Queue 368 368 0 361 0 0.70
CF-Controlfile Transaction 4,284 4,284 0 97 0 0.76
TA-Instance Undo 6 6 0 6 0 0.67
HW-Segment High Water Mark 1,807 1,807 0 7 0 0.43
TM-DML 1,754 1,754 0 3 0 0.33
FB-Format Block 4 4 0 2 0 0.50
DR-Distributed Recovery 1 1 0 1 0 1.00
TQ-Queue table enqueue (TM contention) 1 1 0 1 0 1.00
JS-Job Scheduler (job run lock - synchronize) 2 2 0 2 0 0.00
AF-Advisor Framework (task serialization) 7 7 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1 0.19 231 0 4 5760/5760 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
05-Dec 14:08 66 52 0 4 5,760 0/0 0/0/0/0/0/0
05-Dec 13:58 1 9 0 1 5,760 0/0 0/0/0/0/0/0
05-Dec 13:48 2 3 0 1 5,760 0/0 0/0/0/0/0/0
05-Dec 13:38 117 167 0 3 5,760 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch 1,210 0.00   0 0  
AWR Alerted Metric Element list 12,401 0.00   0 0  
Consistent RBA 375 0.00   0 0  
FAL request queue 36 0.00   0 0  
FAL subheap alocation 36 0.00   0 0  
FOB s.o list latch 2,922 0.00   0 0  
JS broadcast add buf latch 416 0.00   0 0  
JS broadcast drop buf latch 416 0.00   0 0  
JS broadcast load blnc latch 361 0.00   0 0  
JS mem alloc latch 2 0.00   0 0  
JS queue access latch 2 0.00   0 0  
JS queue state obj latch 37,204 0.00   0 0  
JS slv state obj latch 6 0.00   0 0  
KCL gc element parent latch 446,501 0.00 0.00 0 86 0.00
KJC message pool free list 2,257 0.04 0.00 0 371 0.00
KJCT flow control latch 159,450 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 603 0.00   0 0  
KSXR large replies 120 0.00   0 0  
KTF sga latch 6 0.00   0 549 0.00
KWQMN job cache list latch 746 0.00   0 0  
KWQP Prop Status 204 0.00   0 0  
MQL Tracking Latch 0     0 36 0.00
Memory Management Latch 0     0 603 0.00
Memory Queue 4,242 0.00   0 0  
Memory Queue Subscriber 583 0.00   0 0  
OS process 2,133 0.00   0 0  
OS process allocation 2,015 0.00   0 0  
OS process: request allocation 1,401 0.00   0 0  
PL/SQL warning settings 1,863 0.00   0 0  
SQL memory manager latch 1 0.00   0 602 0.00
SQL memory manager workarea list latch 43,210 0.00   0 0  
Shared B-Tree 10,776 0.00   0 0  
active checkpoint queue latch 3,090 0.00   0 0  
active service list 14,061 0.00   0 617 0.00
archive control 30 0.00   0 0  
archive process latch 674 0.00   0 0  
begin backup scn array 8 0.00   0 0  
bq:time manger info latch 528 0.00   0 0  
bufq statistics 1,654 0.00   0 0  
business card 1,172 0.00   0 0  
cache buffer handles 136 0.00   0 0  
cache buffers chains 4,903,277 0.00 0.06 0 181,742 0.00
cache buffers lru chain 96,672 0.00 0.00 0 322,624 0.00
channel handle pool latch 1,402 0.00   0 0  
channel operations parent latch 153,186 0.01 0.00 0 0  
checkpoint queue latch 200,084 0.00   0 626 0.00
client/application info 6,590 0.00   0 0  
commit callback allocation 6 0.00   0 0  
compile environment latch 1,674 0.00   0 0  
datapump attach fixed tables latch 1,684 0.00   0 0  
datapump job fixed tables latch 1,684 0.00   0 0  
dml lock allocation 3,536 0.00   0 0  
dummy allocation 3,359 0.00   0 0  
enqueue hash chains 709,678 0.00 0.00 0 153 0.00
enqueue sob latch 1 0.00   0 0  
enqueues 399,294 0.01 0.00 0 0  
error message lists 592 0.00   0 0  
event group latch 696 0.00   0 0  
file cache latch 1,629 0.00   0 0  
gcs opaque info freelist 13,002 0.01 0.00 0 0  
gcs partitioned table hash 544,005 0.00   0 0  
gcs remastering latch 3,593 0.00   0 0  
gcs resource freelist 4,368 0.00   0 1,946 0.00
gcs resource hash 254,485 0.00 0.00 0 0  
gcs shadows freelist 7,716 0.00   0 7,966 0.00
ges caches resource lists 48,377 0.06 0.00 0 23,228 0.00
ges deadlock list 4 0.00   0 0  
ges domain table 323,529 0.00   0 0  
ges enqueue table freelist 324,641 0.00   0 0  
ges group table 487,826 0.00 0.00 0 0  
ges process hash list 3,772 0.00   0 0  
ges process parent latch 654,682 0.00   0 0  
ges process table freelist 1,401 0.00   0 0  
ges resource hash list 491,841 0.18 0.00 0 4,561 0.00
ges resource scan list 20 0.00   0 0  
ges resource table freelist 6,482 0.00   0 0  
ges timeout list 1,596 0.00   0 1,292 0.00
global KZLD latch for mem in SGA 645 0.00   0 0  
global tx hash mapping 12 0.00   0 0  
hash table column usage latch 49 0.00   0 0  
hash table modification latch 24 0.00   0 0  
job workq parent latch 0     0 728 0.00
job_queue_processes parameter latch 392 0.00   0 0  
kokc descriptor allocation latch 242 0.00   0 0  
ksuosstats global area 123 0.00   0 0  
ktm global data 7 0.00   0 0  
kwqbsn:qsga 4,821 0.00   0 0  
lgwr LWN SCN 785 0.00   0 0  
library cache 78,539 0.36 0.00 0 0  
library cache lock 57,184 0.43 0.00 0 0  
library cache lock allocation 1,672 0.00   0 0  
library cache pin 30,178 0.37 0.00 0 0  
library cache pin allocation 9 0.00   0 0  
list of block allocation 23 0.00   0 0  
loader state object freelist 14 0.00   0 0  
logminer context allocation 1 0.00   0 0  
message pool operations parent latch 4,012 0.00   0 0  
messages 67,093 0.00 0.00 0 0  
mostly latch-free SCN 787 0.00   0 0  
multiblock read objects 5,092 0.00   0 0  
name-service memory objects 4,700 0.00   0 0  
name-service namespace bucket 22,969 0.00   0 0  
name-service pending queue 640 0.00   0 0  
name-service request queue 20,292 0.00   0 0  
ncodef allocation latch 29 0.00   0 0  
object queue header heap 105,262 0.00   0 87,075 0.00
object queue header operation 384,726 0.00 0.00 0 0  
object stats modification 1 0.00   0 0  
parallel query alloc buffer 11,018 0.00   0 0  
parallel query stats 1,792 0.00   0 0  
parallel txn reco latch 7,866 0.00   0 0  
parameter list 213 0.00   0 0  
parameter table allocation management 1,686 0.00   0 0  
post/wait queue 266 0.38 0.00 0 180 0.00
process allocation 20,696 0.06 0.85 0 695 0.14
process group creation 1,401 0.00   0 0  
process queue 6,524 0.00   0 0  
process queue reference 108,213 0.00 0.00 0 9,577 0.01
qmn state object latch 2 0.00   0 0  
qmn task queue latch 2,269 30.72 0.10 0 0  
query server freelists 5,330 0.00   0 0  
queue sender's info. latch 7,864 1.40 0.00 0 0  
queued dump request 9,028 0.00   0 0  
redo allocation 1,948 0.05 0.00 0 2,816 0.04
redo copy 0     0 2,816 0.75
redo writing 5,483 0.04 0.00 0 0  
resmgr group change latch 1,971 0.00   0 0  
resmgr:active threads 3,354 0.00   0 0  
resmgr:actses change group 1,311 0.00   0 0  
resmgr:free threads list 3,353 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 565,749 0.01 0.00 0 0  
rules engine aggregate statistics 2 0.00   0 0  
rules engine rule set statistics 104 0.00   0 0  
sequence cache 1,958 0.00   0 0  
session allocation 21,962 0.04 0.00 0 0  
session idle bit 43,176 0.00   0 0  
session state list latch 3,368 0.00   0 0  
session switching 29 0.00   0 0  
session timer 618 0.00   0 0  
shared pool 59,436 0.00 0.00 0 0  
shared pool simulator 338,992 0.00   0 0  
simulator hash latch 105,945 0.00   0 0  
simulator lru latch 0     0 105,929 0.00
slave class 3 0.00   0 0  
slave class create 12 8.33 1.00 0 0  
sort extent pool 78 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 8,820 0.00   0 0  
threshold alerts latch 355 0.00   0 0  
transaction allocation 5,532,955 0.00   0 0  
transaction branch allocation 627 0.00   0 0  
undo global data 59,260 0.00   0 0  
user lock 2,601 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
qmn task queue latch 2,269 697 72 625 0 0 0
cache buffers chains 4,903,277 18 1 17 0 0 0
process allocation 20,696 13 11 2 0 0 0
slave class create 12 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KCL gc element parent latch kclhngcbk1 0 1 0
cache buffers chains kclwrt 0 1 0
event range base latch No latch 0 72 72
object queue header operation kcbo_switch_mq_bg 0 1 0
process allocation ksufap: active procs 0 6 5
process allocation ksucrp 0 5 0
slave class create ksvcreate 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
SYS SYSTEM FILE$   TABLE 439,904 17.39
SYS SYSTEM I_FILE#_BLOCK#   INDEX 290,864 11.50
SYS SYSTEM SEG$   TABLE 218,064 8.62
SYS SYSTEM USER$   TABLE 214,352 8.47
SYS SYSTEM TS$   TABLE 209,712 8.29

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SYS SYSAUX WRH$_SQL_PLAN_PK   INDEX 13 0.01
SYS SYSAUX WRH$_SYSSTAT_PK 982_112240 INDEX PARTITION 5 0.00
SYS SYSAUX WRH$_SQL_PLAN   TABLE 4 0.00
SYS SYSAUX WRH$_STREAMS_POOL_ADVICE_PK   INDEX 4 0.00
SYS SYSAUX WRH$_BG_EVENT_SUMMARY_PK   INDEX 3 0.00

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
SYS SYSAUX WRH$_FILESTATXS_PK 982_112240 INDEX PARTITION 2 100.00

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
SYS SYSAUX WRH$_FILESTATXS_PK 982_112240 INDEX PARTITION 1 100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
FBP EAS_DATA FBP_EMPLOYEES   TABLE 3,193 23.96
FBP EAS_DATA_NEW FBP_CONTRACT_HEADERS   TABLE 1,251 9.39
FBP EAS_DATA FBP_DEPTS_TL   TABLE 856 6.42
WFR EAS_DATA_NEW WFR_BILL_STATUS   TABLE 522 3.92
SIE EAS_DATA SIE_BOE_HEADERS   TABLE 309 2.32

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
WFR EAS_DATA_NEW WFR_BILL_STATUS   TABLE 231 28.14
FBP EAS_DATA_NEW FBP_CONTRACT_HEADERS   TABLE 148 18.03
SIE EAS_DATA SIE_BOE_PAYMENTS   TABLE 131 15.96
FBP EAS_DATA FBP_EMPLOYEES   TABLE 57 6.94
SYS SYSTEM JOB$   TABLE 36 4.38

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 33 3.03 0   1 1
dc_database_links 1,342 0.00 0   0 26
dc_files 3,000 0.00 0   0 254
dc_global_oids 1,890 0.00 0   0 309
dc_object_ids 1,943 0.00 0   0 6,657
dc_objects 863 0.12 0   1 8,757
dc_profiles 647 0.00 0   0 2
dc_rollback_segments 15,087 0.00 0   0 1,313
dc_segments 3 33.33 0   2 2,701
dc_sequences 1 100.00 0   1 12
dc_tablespaces 146,198 0.00 0   0 43
dc_usernames 2,718 0.00 0   0 148
dc_users 20,938 0.00 0   0 196
outstanding_alerts 163 98.16 0   2 4

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 3 1 0
dc_objects 3 1 0
dc_segments 4 0 0
dc_sequences 2 1 0
outstanding_alerts 321 159 0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 54 0.00 1,386 0.00 0 0
INDEX 1 0.00 11 0.00 0 0
SQL AREA 6,151 0.00 339,031 0.04 61 0
TABLE/PROCEDURE 801 0.00 5,666 0.04 2 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
INDEX 11 0 0 0 0
TABLE/PROCEDURE 2,278 6 2 5 0

Back to Library Cache Statistics
Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 1,512.60   22.24 132.73 1,098 1,098 68 68
  PL/SQL 1,146.68 123.99 17.37 140.37 1,140 1,140 66 66
  SQL 80.00 69.69 1.86 8.19 39 402 43 26
  Freeable 56.69 0.00 1.72 2.39 10   33 33
E Other 1,506.32   25.53 142.80 1,102 1,102 59 59
  PL/SQL 1,147.54 123.91 20.13 151.19 1,142 1,142 57 57
  SQL 78.04 67.81 2.23 9.07 39 402 35 19
  Freeable 47.88 0.00 1.71 2.41 10   28 28

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 24,075,304,960  
Fixed Size 2,111,920  
Redo Buffers 14,663,680  
Variable Size 14,562,625,104  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 32.00 32.00 0.00
large PX msg pool 1.09 1.09 0.00
large free memory 46.91 46.91 0.00
shared CCursor 639.56 639.56 0.00
shared PCursor 396.84 396.84 0.00
shared db_block_hash_buckets 180.00 180.00 0.00
shared free memory 3,874.84 3,874.96 0.00
shared gcs resources 478.41 478.41 0.00
shared gcs shadows 286.48 286.48 0.00
shared library cache 273.95 273.95 0.00
shared sql area 7,059.28 7,059.28 0.00
streams KGH: NO ACCESS 15.98 15.98 0.00
streams free memory 15.89 15.89 0.00
  buffer_cache 22,960.00 22,960.00 0.00
  fixed_sga 2.01 2.01 0.00
  log_buffer 13.98 13.98 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Slaves 338,459 0 0
QMON Coordinator 279,455 0 0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

Queue Schema and NameIncoming per secondOutgoing per secondSpilled per secondDiff Pct Spilled
SYS.KUPC$C_1_20161115174523 0 0 0 0
SYS.KUPC$C_1_20161115182328 0 0 0 0
SYS.KUPC$C_1_20161124101927 0 0 0 0
SYS.KUPC$C_1_20161124103225 0 0 0 0
SYS.KUPC$S_1_20161115174523 0 0 0 0
SYS.KUPC$S_1_20161115182328 0 0 0 0
SYS.KUPC$S_1_20161124101927 0 0 0 0
SYS.KUPC$S_1_20161124103225 0 0 0 0

Back to Streams Statistics
Back to Top

Buffered Subscribers

Subscriber NameIncoming per secondOutgoing per secondSpilled per second
KUPC$A_1_20161115174523 0 0 0
KUPC$A_1_20161115174523 0 0 0
KUPC$A_1_20161115180955 0 0 0
KUPC$A_1_20161115180955 0 0 0
KUPC$A_1_20161115181437 0 0 0
KUPC$A_1_20161115181437 0 0 0
KUPC$A_1_20161115181602 0 0 0
KUPC$A_1_20161115181602 0 0 0
KUPC$A_1_20161115182328 0 0 0
KUPC$A_1_20161115182328 0 0 0
KUPC$A_1_20161115182636 0 0 0
KUPC$A_1_20161115182636 0 0 0
KUPC$A_1_20161115182709 0 0 0
KUPC$A_1_20161115182709 0 0 0
KUPC$A_1_20161124101928 0 0 0
KUPC$A_1_20161124101928 0 0 0
KUPC$A_1_20161124103226 0 0 0
KUPC$A_1_20161124103226 0 0 0
MCP 0 0 0
MCP 0 0 0
MCP 0 0 0
MCP 0 0 0

Back to Streams Statistics
Back to Top

Rule Set

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R 2 0 0 0 0
SYS.KUPC$C_1_20161115174523$6691 0 0 0 0 0
SYS.KUPC$C_1_20161115174523$6692 0 0 0 0 0
SYS.KUPC$C_1_20161115174523$6694 0 0 0 0 0
SYS.KUPC$C_1_20161115174523$6696 0 0 0 0 0
SYS.KUPC$C_1_20161124103225$6723 0 0 0 0 0
SYS.KUPC$C_1_20161115182328$6698 0 0 0 0 0
SYS.KUPC$C_1_20161115182328$6702 0 0 0 0 0
SYS.KUPC$C_1_20161115182328$6710 0 0 0 0 0
SYS.KUPC$C_1_20161124101927$6714 0 0 0 0 0
SYS.KUPC$C_1_20161124101927$6718 0 0 0 0 0
SYS.KUPC$C_1_20161124103225$6719 0 0 0 0 0
SYS.KUPC$C_1_20161115174523$6687 0 0 0 0 0
SYS.KUPC$C_1_20161115174523$6708 0 0 0 0 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 1,872,003 2,861,412 3096098 3096098
gcs_shadows 2,133,227 3,095,936 3096098 3096098


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_optimizer_cost_based_transformation LINEAR   
audit_file_dest /oracle/admin/appdbc/adump   
audit_sys_operations TRUE   
audit_trail DB_EXTENDED   
background_dump_dest /oracle/admin/appdbc/bdump   
cluster_database TRUE   
cluster_database_instances 2   
cluster_interconnects 192.168.9.1   
compatible 10.2.0.3.0   
control_files /dev/vx/rdsk/racdg/control01, /dev/vx/rdsk/racdg/control02, /dev/vx/rdsk/racdg/control03   
core_dump_dest /oracle/admin/appdbc/cdump   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_files 400   
db_name appdbc   
db_recovery_file_dest      
db_recovery_file_dest_size 53687091200   
dispatchers (PROTOCOL=TCP) (SERVICE=appdbcXDB)   
instance_number 1   
job_queue_processes 20   
log_archive_dest_1 LOCATION=/arch_0   
max_dump_file_size 1024m   
open_cursors 600   
pga_aggregate_target 4294967296   
processes 2500   
remote_login_passwordfile EXCLUSIVE   
resource_limit TRUE   
service_names SYS$SYS.KUPC$C_1_20161124103225.APPDBC.GMCC.NET, SYS$SYS.KUPC$S_1_20161124101927.APPDBC.GMCC.NET, SYS$SYS.KUPC$C_1_20161124101927.APPDBC.GMCC.NET, SYS$SYS.KUPC$S_1_20161115182328.APPDBC.GMCC.NET, SYS$SYS.KUPC$C_1_20161115182328.APPDBC.GMCC.NET, SYS$SYS.KUPC$S_1_20161115174523.APPDBC.GMCC.NET, SYS$SYS.KUPC$C_1_20161115174523.APPDBC.GMCC.NET, lis, mdbc1, hrms, appdbc, SYS$SYS.KUPC$S_1_20161124103225.APPDBC.GMCC.NET   
sessions 2755   
sga_max_size 38654705664   
sga_target 38654705664   
spfile /dev/vx/rdsk/racdg/spfile   
thread 1   
undo_management AUTO   
undo_retention 1800   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/admin/appdbc/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 25,999 14.37 14.04
acks for commit broadcast(logical) 26,454 14.62 14.28
broadcast msgs on commit(actual) 376 0.21 0.20
broadcast msgs on commit(logical) 376 0.21 0.20
broadcast msgs on commit(wasted) 18 0.01 0.01
broadcast on commit wait time(ms) 85 0.05 0.05
broadcast on commit waits 337 0.19 0.18
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 57 0.03 0.03
flow control messages sent 10 0.01 0.01
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 6,024 3.33 3.25
gcs ast xid 0 0.00 0.00
gcs blocked converts 252 0.14 0.14
gcs blocked cr converts 3,860 2.13 2.08
gcs compatible basts 1 0.00 0.00
gcs compatible cr basts (global) 3 0.00 0.00
gcs compatible cr basts (local) 9,671 5.35 5.22
gcs cr basts to PIs 0 0.00 0.00
gcs cr serve without current lock 0 0.00 0.00
gcs dbwr flush pi msgs 121 0.07 0.07
gcs dbwr write request msgs 48 0.03 0.03
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 107 0.06 0.06
gcs immediate (null) converts 571 0.32 0.31
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 1,391 0.77 0.75
gcs indirect ast 2,142 1.18 1.16
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 8 0.00 0.00
gcs msgs process time(ms) 2,436 1.35 1.32
gcs msgs received 113,586 62.78 61.33
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 0 0.00 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 0 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 0 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 0 0.00 0.00
gcs side channel msgs actual 2,003 1.11 1.08
gcs side channel msgs logical 14,483 8.00 7.82
gcs stale cr 63,483 35.09 34.28
gcs undo cr 0 0.00 0.00
gcs write notification msgs 0 0.00 0.00
gcs writes refused 0 0.00 0.00
ges msgs process time(ms) 99 0.05 0.05
ges msgs received 4,658 2.57 2.52
global posts dropped 0 0.00 0.00
global posts queue time 74 0.04 0.04
global posts queued 3 0.00 0.00
global posts requested 3 0.00 0.00
global posts sent 3 0.00 0.00
implicit batch messages received 2,161 1.19 1.17
implicit batch messages sent 287 0.16 0.15
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 1,322 0.73 0.71
messages queue sent actual 6,375 3.52 3.44
messages queue sent logical 6,681 3.69 3.61
messages received actual 113,164 62.55 61.10
messages received logical 118,245 65.35 63.85
messages sent directly 72,834 40.26 39.33
messages sent indirectly 3,367 1.86 1.82
messages sent not implicit batched 6,088 3.36 3.29
messages sent pbatched 33,149 18.32 17.90
msgs causing lmd to send msgs 1,846 1.02 1.00
msgs causing lms(s) to send msgs 276 0.15 0.15
msgs received queue time (ms) 1,520 0.84 0.82
msgs received queued 118,245 65.35 63.85
msgs sent queue time (ms) 225 0.12 0.12
msgs sent queue time on ksxp (ms) 17,920 9.90 9.68
msgs sent queued 6,681 3.69 3.61
msgs sent queued on ksxp 105,685 58.41 57.07
process batch messages received 64,268 35.52 34.70
process batch messages sent 28,567 15.79 15.42


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 393
CURRENT Block Requests 14
Data Block Requests 393
Undo Block Requests 0
TX Block Requests 4
Current Results 407
Private results 0
Zero Results 0
Disk Read Results 0
Fail Results 0
Fairness Down Converts 29
Fairness Clears 0
Free GC Elements 0
Flushes 179
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 22
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 12,049 100.00 0.00 0.00 0.00 0.00
Flushes 1 100.00 0.00 0.00 0.00 0.00
Writes 124 74.19 17.74 0.81 7.26 0.00


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 data block 6,663 79.95 0.08 19.98 714 95.10 0.00 4.90
2 undo header 4,056 99.70 0.05 0.25 66 96.97 3.03 0.00
2 Others 2,600 99.96 0.00 0.04 26 100.00 0.00 0.00


Back to Top

End of Report Report written to awrrpt_1_112314_112315.html Prod:user=sys,db=appdbc SQL>