Using the report name awrrpt_1_112313_112314.html AWR Report

WORKLOAD REPOSITORY report for

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

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:11231305-Dec-16 13:00:0563 8.2
End Snap:11231405-Dec-16 13:30:1165 7.2
Elapsed:  30.11 (mins)  
DB Time:  2.41 (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: 3,705.18 2,290.47
Logical reads: 1,536.27 949.69
Block changes: 17.57 10.86
Physical reads: 80.33 49.66
Physical writes: 0.54 0.33
User calls: 10.51 6.50
Parses: 96.14 59.43
Hard parses: 0.04 0.02
Sorts: 3.16 1.96
Logons: 0.93 0.58
Executes: 140.62 86.93
Transactions: 1.62 

% Blocks changed per Read: 1.14Recursive Call %: 99.54
Rollback per transaction %: 62.90Rows per Sort: 62.25

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 94.77In-memory Sort %: 100.00
Library Hit %: 99.97Soft Parse %: 99.96
Execute to Parse %: 31.63Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 174.83% Non-Parse CPU: 94.34

Shared Pool Statistics

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

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  90  62.0 
db file sequential read 146,202 36 0 25.1User I/O
reliable message 1,891 30 16 21.0Other
gc cr disk read 71,897 26 0 18.0Cluster
PX Deq: reap credit 17,826 9 0 5.9Other

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 5.03 3.11
Global Cache blocks served: 3.34 2.07
GCS/GES messages received: 92.43 57.14
GCS/GES messages sent: 74.53 46.08
DBWR Fusion writes: 0.08 0.05
Estd Interconnect traffic (KB) 99.55 

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

Buffer access - local cache %: 94.44
Buffer access - remote cache %: 0.33
Buffer access - disk %: 5.23

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.0
Avg global cache cr block receive time (ms): 0.4
Avg global cache current block receive time (ms): 0.3
Avg global cache cr block build time (ms): 0.1
Avg global cache cr block send time (ms): 0.1
Global cache log flushes for cr blocks served %: 27.7
Avg global cache cr block flush time (ms): 0.3
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): 

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: 88.24
% of indirect sent messages: 9.19
% of flow controlled messages: 2.57


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 142.81 98.81
DB CPU 89.55 61.96
PL/SQL execution elapsed time 6.49 4.49
parse time elapsed 2.80 1.94
connection management call elapsed time 2.34 1.62
hard parse elapsed time 0.97 0.67
sequence load elapsed time 0.06 0.04
failed parse elapsed time 0.04 0.02
repeated bind elapsed time 0.01 0.01
PL/SQL compilation elapsed time 0.01 0.01
DB time 144.54  
background elapsed time 110.54  
background cpu time 51.67  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Other 48,520 81.33 55 1 16.61
User I/O 146,204 0.00 36 0 50.04
Cluster 80,587 0.00 29 0 27.58
System I/O 22,486 0.00 6 0 7.70
Concurrency 240 0.00 0 1 0.08
Application 486 0.00 0 0 0.17
Network 17,362 0.00 0 0 5.94
Commit 16 0.00 0 1 0.01
Configuration 3 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
db file sequential read 146,202 0.00 36 0 50.03
reliable message 1,891 1.06 30 16 0.65
gc cr disk read 71,897 0.00 26 0 24.61
PX Deq: reap credit 17,826 98.03 9 0 6.10
Streams AQ: qmn coordinator waiting for slave to start 1 100.00 6 6424 0.00
PX Deq Credit: send blkd 2,892 39.94 6 2 0.99
control file sequential read 19,997 0.00 5 0 6.84
gc cr block 2-way 8,028 0.00 3 0 2.75
enq: WF - contention 15 13.33 2 113 0.01
enq: PS - contention 1,200 0.00 1 0 0.41
control file parallel write 601 0.00 0 1 0.21
wait for scn ack 832 0.00 0 1 0.28
log file parallel write 1,226 0.00 0 0 0.42
os thread startup 3 0.00 0 71 0.00
CGS wait for IPC msg 17,559 100.00 0 0 6.01
gc current block 2-way 367 0.00 0 1 0.13
enq: JQ - contention 363 0.00 0 1 0.12
latch free 32 0.00 0 6 0.01
db file parallel write 662 0.00 0 0 0.23
enq: US - contention 770 0.00 0 0 0.26
DFS lock handle 248 0.00 0 1 0.08
SQL*Net break/reset to client 484 0.00 0 0 0.17
gcs log flush sync 248 2.82 0 0 0.08
row cache lock 225 0.00 0 0 0.08
enq: TM - contention 2 0.00 0 35 0.00
PX Deq: Signal ACK 1,149 49.78 0 0 0.39
enq: CF - contention 93 0.00 0 1 0.03
gc current grant 2-way 113 0.00 0 0 0.04
ksxr poll remote instances 3,163 81.32 0 0 1.08
gc current grant busy 75 0.00 0 0 0.03
IPC send completion sync 96 100.00 0 0 0.03
gc cr grant 2-way 67 0.00 0 0 0.02
gc cr block congested 12 0.00 0 2 0.00
log file sync 16 0.00 0 1 0.01
SQL*Net message to client 15,741 0.00 0 0 5.39
rdbms ipc reply 61 0.00 0 0 0.02
gc cr block busy 6 0.00 0 1 0.00
library cache lock 12 0.00 0 0 0.00
gc current block busy 4 0.00 0 1 0.00
SQL*Net more data from client 573 0.00 0 0 0.20
gc current block congested 1 0.00 0 2 0.00
gc current multi block request 13 0.00 0 0 0.00
gc current grant congested 1 0.00 0 2 0.00
enq: TA - contention 6 0.00 0 0 0.00
enq: HW - contention 3 0.00 0 0 0.00
LGWR wait for redo copy 65 0.00 0 0 0.02
enq: FB - contention 3 0.00 0 0 0.00
gc cr multi block request 3 0.00 0 0 0.00
direct path write 2 0.00 0 0 0.00
SQL*Net message to dblink 1,041 0.00 0 0 0.36
SQL*Net more data to client 7 0.00 0 0 0.00
enq: TQ - TM contention 1 0.00 0 0 0.00
PX qref latch 4 50.00 0 0 0.00
KJC: Wait for msg sends to complete 2 0.00 0 0 0.00
gcs remote message 587,721 99.75 14,099 24 201.14
jobq slave wait 4,778 45.65 10,701 2240 1.64
SQL*Net message from client 15,740 0.00 5,829 370 5.39
Streams AQ: qmn slave idle wait 937 0.11 4,700 5016 0.32
wait for unread message on broadcast channel 3,893 82.69 3,411 876 1.33
PX Idle Wait 1,748 64.53 3,393 1941 0.60
virtual circuit status 61 100.00 1,773 29074 0.02
DIAG idle wait 9,015 0.00 1,763 196 3.09
ges remote message 29,841 94.53 1,763 59 10.21
Streams AQ: waiting for messages in the queue 186 96.77 1,758 9450 0.06
Streams AQ: qmn coordinator idle wait 734 42.92 1,754 2390 0.25
Streams AQ: waiting for time management or cleanup tasks 10 40.00 1,566 156631 0.00
SQL*Net message from dblink 1,042 0.00 1,257 1206 0.36
PX Deq: Join ACK 1,738 33.77 90 52 0.59
PX Deq: Execution Msg 3,104 2.67 64 21 1.06
PX Deq: Parse Reply 1,671 32.85 0 0 0.57
PX Deq: Execute Reply 1,085 10.05 0 0 0.37
PX Deq: Msg Fragment 145 43.45 0 0 0.05
Streams AQ: RAC qmn coordinator idle wait 736 98.78 0 0 0.25
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 23,243 87.00 37 2 7.95
db file sequential read 47,931 0.00 12 0 16.40
gc cr disk read 23,227 0.00 8 0 7.95
control file sequential read 4,854 0.00 2 0 1.66
gc cr block 2-way 1,226 0.00 1 0 0.42
control file parallel write 601 0.00 0 1 0.21
log file parallel write 1,226 0.00 0 0 0.42
os thread startup 3 0.00 0 71 0.00
db file parallel write 662 0.00 0 0 0.23
row cache lock 158 0.00 0 0 0.05
gc current block 2-way 40 0.00 0 1 0.01
gc current grant busy 4 0.00 0 1 0.00
enq: TM - contention 1 0.00 0 3 0.00
gc cr block congested 1 0.00 0 2 0.00
gc cr multi block request 3 0.00 0 0 0.00
rdbms ipc message 32,795 85.88 28,007 854 11.22
gcs remote message 587,737 99.75 14,099 24 201.14
DIAG idle wait 9,016 0.00 1,763 196 3.09
ges remote message 29,841 94.53 1,763 59 10.21
pmon timer 615 100.00 1,761 2864 0.21
Streams AQ: qmn coordinator idle wait 734 42.92 1,754 2390 0.25
smon timer 9 0.00 1,660 184438 0.00
Streams AQ: waiting for time management or cleanup tasks 10 40.00 1,566 156631 0.00
PX Deq: Join ACK 6 50.00 0 1 0.00
Streams AQ: RAC qmn coordinator idle wait 736 98.78 0 0 0.25
PX Deq: Parse Reply 6 50.00 0 1 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 3,511
AVG_IDLE_TIME 176,982
AVG_IOWAIT_TIME 0
AVG_SYS_TIME 1,431
AVG_USER_TIME 2,016
BUSY_TIME 114,329
IDLE_TIME 5,665,436
IOWAIT_TIME 0
SYS_TIME 47,857
USER_TIME 66,472
LOAD 1
OS_CPU_WAIT_TIME 75,200
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 180,224
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 141.70 87.10 97,890 2,405,891
hrms 1.00 1.00 13 2,339
SYS$BACKGROUND 0.00 0.00 48,023 306,118
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 97900 2399 68 1 0 0 15392 2
hrms 13 2 5 0 0 0 114 0
SYS$BACKGROUND 48275 1233 168 28 0 0 0 0
appdbc 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
83 47 6 13.89 57.68 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
30 30 51,228 0.00 21.04 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
25 11 0   17.18 69atchvk0ukpy ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN SYS.DBMS_DATAPUMP.A...
25 11 581 0.04 17.10 afcz9s4uazbpk ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN :1 := sys.kupc$que_int.t...
18 5 581 0.03 12.64 gn74qsy7sv4z4 ude@erpdb-m9k-d00 (TNS V1-V3) SELECT COUNT(*) FROM gv$datapu...
8 8 1 7.73 5.35 5nsbr19rcb6hr   DECLARE job BINARY_INTEGER := ...
5 5 161,006 0.00 3.35 2ym6hhaq30r73   select type#, blocks, extents,...
3 3 12,403 0.00 2.09 13p9up4v7xcuk   SELECT COUNT(*) FROM EVS_VOUCH...
3 1 6 0.45 1.87 bnafqqprpz3u1 sqlplus@erpdb-m9k-d00 (TNS V1-V3) select tablespace_name, use_pr...
3 3 13,436 0.00 1.78 21dwgb1hwgky3   SELECT COUNT(*) FROM EVS_VOUCH...
2 1 6 0.39 1.62 11ssd5xrck6sn JDBC Thin Client select sum("tablespace_size(M)...
2 2 642 0.00 1.58 3f751tsaf2j02 JDBC Thin Client SELECT VALUE FROM NLS_INSTANCE...
2 2 12 0.14 1.17 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
47 83 6 7.80 57.68 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
30 30 51,228 0.00 21.04 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
11 25 581 0.02 17.10 afcz9s4uazbpk ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN :1 := sys.kupc$que_int.t...
11 25 0   17.18 69atchvk0ukpy ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN SYS.DBMS_DATAPUMP.A...
8 8 1 7.52 5.35 5nsbr19rcb6hr   DECLARE job BINARY_INTEGER := ...
5 5 161,006 0.00 3.35 2ym6hhaq30r73   select type#, blocks, extents,...
5 18 581 0.01 12.64 gn74qsy7sv4z4 ude@erpdb-m9k-d00 (TNS V1-V3) SELECT COUNT(*) FROM gv$datapu...
3 3 12,403 0.00 2.09 13p9up4v7xcuk   SELECT COUNT(*) FROM EVS_VOUCH...
3 3 13,436 0.00 1.78 21dwgb1hwgky3   SELECT COUNT(*) FROM EVS_VOUCH...
2 2 642 0.00 1.58 3f751tsaf2j02 JDBC Thin Client SELECT VALUE FROM NLS_INSTANCE...
2 2 12 0.14 1.17 29nxqgu4mdrnu sqlplus@erpdb-m9k-d00 (TNS V1-V3) declare v_process number; v_...
1 3 6 0.23 1.87 bnafqqprpz3u1 sqlplus@erpdb-m9k-d00 (TNS V1-V3) select tablespace_name, use_pr...
1 2 6 0.21 1.62 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,839,420 6 306,570.00 66.29 46.78 83.36 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
497,921 1 497,921.00 17.94 7.52 7.73 5nsbr19rcb6hr   DECLARE job BINARY_INTEGER := ...
483,018 161,006 3.00 17.41 4.84 4.84 2ym6hhaq30r73   select type#, blocks, extents,...
221,976 51,228 4.33 8.00 30.12 30.42 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
205,252 13,436 15.28 7.40 2.53 2.57 21dwgb1hwgky3   SELECT COUNT(*) FROM EVS_VOUCH...
200,374 12,403 16.16 7.22 3.02 3.02 13p9up4v7xcuk   SELECT COUNT(*) FROM EVS_VOUCH...
96,739 6 16,123.17 3.49 1.35 2.70 bnafqqprpz3u1 sqlplus@erpdb-m9k-d00 (TNS V1-V3) select tablespace_name, use_pr...
55,764 9 6,196.00 2.01 0.30 0.30 25t0tfag0pz8v   select file#, block# from seg...
28,364 1,029 27.56 1.02 0.31 0.32 25fs4cnptqjff   INSERT INTO EVS_VOUCHER_LINE (...
22,362 1 22,362.00 0.81 0.42 0.61 fbxacrra3ym8n JDBC Thin Client select sum(bytes/1024/1024/102...

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
98,097 6 16,349.50 67.60 46.78 83.36 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
47,926 51,228 0.94 33.03 30.12 30.42 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
139 1 139.00 0.10 7.52 7.73 5nsbr19rcb6hr   DECLARE job BINARY_INTEGER := ...
68 1,029 0.07 0.05 0.21 0.30 4jcnmfh5v6338   INSERT INTO INF_PAYMENT_JOURNA...
25 13,436 0.00 0.02 2.53 2.57 21dwgb1hwgky3   SELECT COUNT(*) FROM EVS_VOUCH...
17 1,029 0.02 0.01 0.31 0.32 25fs4cnptqjff   INSERT INTO EVS_VOUCHER_LINE (...
7 1 7.00 0.00 0.00 0.04 g6wf9na8zs5hb   insert into wrh$_sysmetric_sum...
6 20 0.30 0.00 0.00 0.00 grwydz59pu6mc   select text from view$ where r...
5 0   0.00 0.43 0.44 05hda3yp664zd PL/SQL Developer select * from APPS.SIE_BOE_HEA...
4 1 4.00 0.00 0.01 0.03 bqnn4c3gjtmgu   insert into wrh$_bg_event_summ...

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
161,006 161,006 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
51,228 0 0.00 0.00 0.00 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
13,436 13,436 1.00 0.00 0.00 21dwgb1hwgky3   SELECT COUNT(*) FROM EVS_VOUCH...
12,403 12,403 1.00 0.00 0.00 13p9up4v7xcuk   SELECT COUNT(*) FROM EVS_VOUCH...
1,314 72 0.05 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
1,029 1,029 1.00 0.00 0.00 25fs4cnptqjff   INSERT INTO EVS_VOUCHER_LINE (...
1,029 1,029 1.00 0.00 0.00 4jcnmfh5v6338   INSERT INTO INF_PAYMENT_JOURNA...
654 1,308 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...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
161,006 161,006 92.72 2ym6hhaq30r73   select type#, blocks, extents,...
1,314 1,314 0.76 0h6b2sajwb74n   select privilege#, level from ...
654 654 0.38 05uqdabhzncdc   select role# from defrole$ d, ...
642 642 0.37 3f751tsaf2j02 JDBC Thin Client SELECT VALUE FROM NLS_INSTANCE...
581 581 0.33 gn74qsy7sv4z4 ude@erpdb-m9k-d00 (TNS V1-V3) SELECT COUNT(*) FROM gv$datapu...
562 562 0.32 bsa0wjtftg3uw   select file# from file$ where ...
372 12 0.21 47a50dvdgnxc2   update sys.job$ set failures=0...
372 372 0.21 a1mbfp580hw3k   select u1.user#, u2.user#, u...
372 11 0.21 aq8yqxyyb40nn   update sys.job$ set this_date=...
160 160 0.09 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 2 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
20.26 24.30 83.36 46.78 6 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
8.65 28.45 30.42 30.12 51,228 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
0.24 39.06 0.61 0.42 1 fbxacrra3ym8n JDBC Thin Client select sum(bytes/1024/1024/102...
0.10 1.26 7.73 7.52 1 5nsbr19rcb6hr   DECLARE job BINARY_INTEGER := ...
0.08 33.08 0.24 0.24 355 6ssrk2dqj7jbx   select job, nvl2(last_date, ...
0.04 12.81 0.32 0.31 1,029 25fs4cnptqjff   INSERT INTO EVS_VOUCHER_LINE (...
0.02 7.10 0.30 0.21 1,029 4jcnmfh5v6338   INSERT INTO INF_PAYMENT_JOURNA...
0.02 0.63 2.57 2.53 13,436 21dwgb1hwgky3   SELECT COUNT(*) FROM EVS_VOUCH...
0.01 0.49 2.35 1.24 6 11ssd5xrck6sn JDBC Thin Client select sum("tablespace_size(M)...
0.01 32.84 0.03 0.03 4 c7sn076yz7030   select smontabv.cnt, smontab....
0.01 0.31 2.70 1.35 6 bnafqqprpz3u1 sqlplus@erpdb-m9k-d00 (TNS V1-V3) select tablespace_name, use_pr...
0.01 0.59 1.15 1.15 1 84qubbrsr0kfn   insert into wrh$_latch (snap...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
05hda3yp664zdselect * from APPS.SIE_BOE_HEADERS_QRY_COMMON_V
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
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
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')
13p9up4v7xcukSELECT COUNT(*) FROM EVS_VOUCHER_LINE E WHERE HEADER_ID = :B3 AND E.LINE_NUM = :B2 AND E.LAST_UPDATE_DATE < :B1
14566d856s6hsSELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1
21dwgb1hwgky3SELECT COUNT(*) FROM EVS_VOUCHER_LINE E WHERE HEADER_ID = :B2 AND E.LINE_NUM = :B1
25fs4cnptqjffINSERT INTO EVS_VOUCHER_LINE (VOUCHER_ID, LINE_DESC, LINE_NUM, CODE_ID, ACCOUNT_DESC, CONVERT_RATE, ACC_DR, ACC_CR, LINE_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_BY, LAST_UPDATE_LOGIN, VOUCHER_TYPE, ORIGIN_LINE_ID, HEADER_ID) VALUES ((SELECT VOUCHER_ID FROM EVS_VOUCHER WHERE ORIGIN_VOUCHER_ID = :B1 AND ROWNUM = 1), :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , EVS_VOUCHER_LINE_S.NEXTVAL, SYSDATE, :B6 , :B5 , :B4 , :B3 , '¸¶¿î', :B2 , :B1 )
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
4jcnmfh5v6338INSERT INTO INF_PAYMENT_JOURNAL_LINE (HEADER_ID, LINE_DESC, LINE_NUM, CODE_ID, ACCOUNT_DESC, CONVER_RATE, ACC_DR, ACC_CR, LINE_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_BY, LAST_UPDATE_LOGIN) VALUES (:B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 , SYSDATE, -1, SYSDATE, -1, 0)
5nsbr19rcb6hrDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN begin EVS_DATA_SYNC_ALL_PKG.evs_sync; end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
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
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
fbxacrra3ym8nselect sum(bytes/1024/1024/1024) as totaldata from dba_segments
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
grwydz59pu6mcselect text from view$ where rowid=: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 10,730 5.94 3.67
CPU used when call started 6,066 3.36 2.08
CR blocks created 260 0.14 0.09
Cached Commit SCN referenced 0 0.00 0.00
Commit SCN cached 0 0.00 0.00
DB time 1,054,976 584.05 361.05
DBWR checkpoint buffers written 822 0.46 0.28
DBWR checkpoints 0 0.00 0.00
DBWR fusion writes 145 0.08 0.05
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 31 0.02 0.01
DBWR undo block writes 250 0.14 0.09
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 583 0.32 0.20
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 3,480 1.93 1.19
PX local messages sent 3,480 1.93 1.19
PX remote messages recv'd 1,313 0.73 0.45
PX remote messages sent 2,413 1.34 0.83
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 583 0.32 0.20
RowCR - row contention 0 0.00 0.00
RowCR attempts 0 0.00 0.00
RowCR hits 1,026 0.57 0.35
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,926 7.71 4.77
SQL*Net roundtrips to/from dblink 1,041 0.58 0.36
active txn count during cleanout 1,015 0.56 0.35
application wait time 21 0.01 0.01
background checkpoints completed 0 0.00 0.00
background checkpoints started 0 0.00 0.00
background timeouts 8,199 4.54 2.81
branch node splits 0 0.00 0.00
buffer is not pinned count 1,338,763 741.16 458.17
buffer is pinned count 25,325,907 14,020.74 8,667.32
bytes received via SQL*Net from client 1,953,168 1,081.30 668.44
bytes received via SQL*Net from dblink 392,846 217.48 134.44
bytes sent via SQL*Net to client 864,365 478.52 295.81
bytes sent via SQL*Net to dblink 12,800 7.09 4.38
calls to get snapshot scn: kcmgss 594,743 329.26 203.54
calls to kcmgas 148,537 82.23 50.83
calls to kcmgcs 130 0.07 0.04
change write time 6 0.00 0.00
cleanout - number of ktugct calls 631 0.35 0.22
cleanouts and rollbacks - consistent read gets 2 0.00 0.00
cleanouts only - consistent read gets 267 0.15 0.09
cluster key scan block gets 622,009 344.35 212.87
cluster key scans 398,930 220.85 136.53
cluster wait time 2,931 1.62 1.00
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 1 0.00 0.00
commit batch/immediate requested 1 0.00 0.00
commit cleanout failures: block lost 0 0.00 0.00
commit cleanout failures: callback failure 17 0.01 0.01
commit cleanout failures: cannot pin 0 0.00 0.00
commit cleanouts 7,815 4.33 2.67
commit cleanouts successfully completed 7,798 4.32 2.67
commit immediate performed 1 0.00 0.00
commit immediate requested 1 0.00 0.00
commit txn count during cleanout 3,646 2.02 1.25
concurrency wait time 30 0.02 0.01
consistent changes 1,185 0.66 0.41
consistent gets 2,693,406 1,491.10 921.77
consistent gets - examination 719,514 398.33 246.24
consistent gets direct 0 0.00 0.00
consistent gets from cache 2,693,408 1,491.10 921.77
current blocks converted for CR 0 0.00 0.00
cursor authentications 2 0.00 0.00
data blocks consistent reads - undo records applied 11 0.01 0.00
db block changes 31,734 17.57 10.86
db block gets 81,669 45.21 27.95
db block gets direct 20 0.01 0.01
db block gets from cache 81,649 45.20 27.94
deferred (CURRENT) block cleanout applications 903 0.50 0.31
dirty buffers inspected 2 0.00 0.00
enqueue conversions 2,712 1.50 0.93
enqueue releases 224,388 124.22 76.79
enqueue requests 224,447 124.26 76.81
enqueue timeouts 61 0.03 0.02
enqueue waits 2,457 1.36 0.84
exchange deadlocks 0 0.00 0.00
execute count 253,999 140.62 86.93
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 8,246 4.57 2.82
free buffer requested 154,937 85.78 53.02
gc CPU used by this session 3,074 1.70 1.05
gc blocks lost 0 0.00 0.00
gc cr block build time 5 0.00 0.00
gc cr block flush time 8 0.00 0.00
gc cr block receive time 351 0.19 0.12
gc cr block send time 8 0.00 0.00
gc cr blocks received 8,716 4.83 2.98
gc cr blocks served 896 0.50 0.31
gc current block flush time 0 0.00 0.00
gc current block pin time 3 0.00 0.00
gc current block receive time 11 0.01 0.00
gc current block send time 39 0.02 0.01
gc current blocks received 364 0.20 0.12
gc current blocks served 5,139 2.85 1.76
gc local grants 73,380 40.62 25.11
gc remote grants 72,275 40.01 24.73
gcs messages sent 126,534 70.05 43.30
ges messages sent 8,099 4.48 2.77
global enqueue get time 433 0.24 0.15
global enqueue gets async 530 0.29 0.18
global enqueue gets sync 188,210 104.20 64.41
global enqueue releases 185,711 102.81 63.56
heap block compress 12 0.01 0.00
hot buffers moved to head of LRU 115 0.06 0.04
immediate (CR) block cleanout applications 269 0.15 0.09
immediate (CURRENT) block cleanout applications 318 0.18 0.11
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 2,343 1.30 0.80
index fast full scans (full) 0 0.00 0.00
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 799,565 442.65 273.64
index scans kdiixs1 30,808 17.06 10.54
leaf node 90-10 splits 11 0.01 0.00
leaf node splits 95 0.05 0.03
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,685 0.93 0.58
messages received 2,785 1.54 0.95
messages sent 2,785 1.54 0.95
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 1,557,164 862.07 532.91
opened cursors cumulative 174,175 96.43 59.61
parse count (failures) 61 0.03 0.02
parse count (hard) 69 0.04 0.02
parse count (total) 173,651 96.14 59.43
parse time cpu 507 0.28 0.17
parse time elapsed 290 0.16 0.10
physical read IO requests 145,110 80.33 49.66
physical read bytes 1,188,741,120 658,101.80 406,824.48
physical read total IO requests 165,393 91.56 56.60
physical read total bytes 1,519,009,792 840,942.62 519,852.77
physical read total multi block requests 0 0.00 0.00
physical reads 145,110 80.33 49.66
physical reads cache 145,110 80.33 49.66
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 677 0.37 0.23
physical write bytes 7,921,664 4,385.53 2,711.04
physical write total IO requests 3,710 2.05 1.27
physical write total bytes 44,744,192 24,770.94 15,312.87
physical write total multi block requests 1,003 0.56 0.34
physical writes 967 0.54 0.33
physical writes direct 20 0.01 0.01
physical writes direct (lob) 0 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 947 0.52 0.32
physical writes non checkpoint 594 0.33 0.20
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 22 0.01 0.01
process last non-idle time 4,958 2.74 1.70
queries parallelized 583 0.32 0.20
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 4,115,070 2,278.15 1,408.31
recursive cpu usage 3,970 2.20 1.36
redo blocks written 14,127 7.82 4.83
redo buffer allocation retries 0 0.00 0.00
redo entries 17,389 9.63 5.95
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 342 0.19 0.12
redo size 6,692,740 3,705.18 2,290.47
redo subscn max counts 155 0.09 0.05
redo synch time 3 0.00 0.00
redo synch writes 16 0.01 0.01
redo wastage 327,188 181.14 111.97
redo write time 45 0.02 0.02
redo writer latching time 0 0.00 0.00
redo writes 1,226 0.68 0.42
rollback changes - undo records applied 2 0.00 0.00
rollbacks only - consistent read gets 9 0.00 0.00
rows fetched via callback 191,107 105.80 65.40
session connect time 0 0.00 0.00
session cursor cache hits 167,174 92.55 57.21
session logical reads 2,774,996 1,536.27 949.69
session pga memory 72,738,246,344 40,268,793.39 24,893,308.13
session pga memory max 76,420,648,648 42,307,416.88 26,153,541.63
session uga memory 51,584,285,048 28,557,698.62 17,653,759.43
session uga memory max 666,107,520 368,765.37 227,962.87
shared hash latch upgrades - no wait 3,466 1.92 1.19
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 5,716 3.16 1.96
sorts (rows) 355,799 196.97 121.77
sql area evicted 0 0.00 0.00
sql area purged 61 0.03 0.02
summed dirty queue length 0 0.00 0.00
switch current to new buffer 2 0.00 0.00
table fetch by rowid 12,640,676 6,998.03 4,326.04
table fetch continued row 0 0.00 0.00
table scan blocks gotten 562,427 311.37 192.48
table scan rows gotten 27,790,921 15,385.40 9,510.92
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) 85,764 47.48 29.35
total number of times SMON posted 9 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 1 0.00 0.00
transaction tables consistent read rollbacks 1 0.00 0.00
transaction tables consistent reads - undo records applied 201 0.11 0.07
undo change vector size 2,208,740 1,222.79 755.90
user I/O wait time 3,551 1.97 1.22
user calls 18,986 10.51 6.50
user commits 1,084 0.60 0.37
user rollbacks 1,838 1.02 0.63
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 3,525 1.95 1.21
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,141,869 6,147,349
opened cursors current 519 465
workarea memory allocated 4,778 1,850
logons current 63 65

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 82,888 46 0.25 1.00 0 0 0 0.00
USERS 25,481 14 0.28 1.00 0 0 0 0.00
SYSAUX 12,571 7 0.20 1.00 454 0 0 0.00
DAT_EPM 8,477 5 0.24 1.00 0 0 0 0.00
SYSTEM 7,968 4 0.20 1.00 63 0 0 0.00
EPM_GD_DATA 2,947 2 0.22 1.00 0 0 0 0.00
DAT_PAMS 1,198 1 0.26 1.00 0 0 0 0.00
AUDIT_DATA 1,118 1 0.13 1.00 0 0 0 0.00
DAT_EVSAS 729 0 0.62 1.00 77 0 0 0.00
EAS_DATA_NEW 682 0 0.31 1.00 0 0 0 0.00
EIP_DATA 417 0 0.10 1.00 0 0 0 0.00
IDX_PAMS 399 0 0.18 1.00 0 0 0 0.00
EAS_IND 357 0 0.20 1.00 0 0 0 0.00
MOB_DATA 212 0 0.33 1.00 0 0 0 0.00
TDEIP_DATA 104 0 0.00 1.00 0 0 0 0.00
UNDOTBS1 0 0 0.00 0.00 83 0 0 0.00
SIED 27 0 0.00 1.00 0 0 0 0.00
DAT_HRMS 12 0 0.83 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,118 1 0.13 1.00 0 0 0 0.00
DAT_EPM /dev/vx/rdsk/racdg/datafile304 123 0 0.33 1.00 0 0 0 0.00
DAT_EPM /dev/vx/rdsk/racdg/datafile52 4,172 2 0.25 1.00 0 0 0 0.00
DAT_EPM /dev/vx/rdsk/racdg/datafile53 4,182 2 0.22 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile103 7 0 0.00 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile109 21 0 0.48 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile333 27 0 0.00 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile36 295 0 0.24 1.00 4 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile37 57 0 0.53 1.00 1 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile373 43 0 1.63 1.00 19 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile374 46 0 2.39 1.00 20 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile38 13 0 0.77 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile388 75 0 1.33 1.00 33 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile72 33 0 0.61 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile81 98 0 0.20 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile82 14 0 0.71 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile370 12 0 0.83 1.00 0 0 0 0.00
DAT_PAMS /dev/vx/rdsk/racdg/datafile29 1,198 1 0.26 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile01 2,511 1 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile05 1,666 1 0.26 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile07 1,954 1 0.30 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile08 7,411 4 0.25 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile09 1,926 1 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile10 5,573 3 0.25 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile100 961 1 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile104 3,230 2 0.20 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile108 824 0 0.27 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile11 3,191 2 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile113 300 0 0.27 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile116 126 0 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile119 94 0 0.74 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile120 31 0 0.32 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile121 62 0 0.32 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile122 30 0 0.33 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile123 16 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile125 95 0 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile126 16 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile127 554 0 0.14 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile128 47 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile129 138 0 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile130 63 0 0.16 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile132 61 0 0.33 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile133 31 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile134 48 0 0.42 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile135 16 0 0.63 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile137 31 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile300 48 0 0.42 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile301 47 0 0.64 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile302 80 0 0.25 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile303 80 0 0.50 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile306 32 0 0.31 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile307 1,652 1 0.22 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile308 591 0 0.22 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile309 256 0 0.12 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile310 459 0 0.26 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile311 303 0 0.30 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile312 127 0 0.47 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile313 749 0 0.33 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile314 382 0 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile315 511 0 0.27 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile316 916 1 0.23 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile317 602 0 0.20 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile318 462 0 0.26 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile319 2,347 1 0.27 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile320 2,542 1 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile321 1,609 1 0.33 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile334 3,477 2 0.20 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile335 1,853 1 0.22 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile336 1,646 1 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile340 696 0 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile343 650 0 0.26 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile344 742 0 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile345 252 0 0.16 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile346 2,477 1 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile347 987 1 0.25 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile348 790 0 0.19 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile349 428 0 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile350 490 0 0.18 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile351 256 0 0.39 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile352 128 0 0.23 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile353 47 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile354 16 0 0.63 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile355 6,766 4 0.31 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile356 64 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile357 128 0 0.16 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile358 158 0 0.38 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile377 237 0 0.46 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile383 2,232 1 0.28 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile384 995 1 0.15 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile385 746 0 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile386 315 0 0.16 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile390 304 0 0.33 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile391 32 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile55 1,845 1 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile75 1,355 1 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile76 1,235 1 0.26 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile87 2,768 2 0.20 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile88 1,439 1 0.23 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile99 2,533 1 0.26 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile409 14 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile410 40 0 0.25 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile411 7 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile412 21 0 0.48 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile413 27 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile414 20 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile415 20 0 0.50 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile416 89 0 0.56 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile417 62 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile418 40 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile419 35 0 0.57 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile420 35 0 0.29 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile421 66 0 0.45 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile422 62 0 0.16 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile423 21 0 0.48 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile424 26 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile425 28 0 1.43 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile426 28 0 0.36 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile427 14 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile428 27 0 0.00 1.00 0 0 0 0.00
EAS_IND /dev/vx/rdsk/racdg/datafile02 189 0 0.11 1.00 0 0 0 0.00
EAS_IND /dev/vx/rdsk/racdg/datafile06 168 0 0.30 1.00 0 0 0 0.00
EIP_DATA /dev/vx/rdsk/racdg/datafile03 417 0 0.10 1.00 0 0 0 0.00
EPM_GD_DATA /dev/vx/rdsk/racdg/datafile378 2,947 2 0.22 1.00 0 0 0 0.00
IDX_PAMS /dev/vx/rdsk/racdg/datafile26 399 0 0.18 1.00 0 0 0 0.00
MOB_DATA /dev/vx/rdsk/racdg/datafile31 212 0 0.33 1.00 0 0 0 0.00
SIED /dev/vx/rdsk/racdg/datafile25 27 0 0.00 1.00 0 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile105 39 0 0.51 1.00 11 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile111 73 0 0.14 1.00 3 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile131 7 0 1.43 1.00 4 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile22 76 0 0.79 1.00 84 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile331 2 0 0.00 1.00 1 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile56 18 0 2.22 1.00 48 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile71 10 0 6.00 1.00 30 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile89 7 0 2.86 1.00 47 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile90 157 0 0.38 1.00 14 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/sysaux01 12,182 7 0.19 1.00 212 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/appdbc_system03 68 0 0.15 1.00 5 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile328 435 0 0.14 1.00 2 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile341 139 0 0.36 1.00 0 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile97 54 0 0.19 1.00 0 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/system01 7,210 4 0.21 1.00 56 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/system02 62 0 0.16 1.00 0 0 0 0.00
TDEIP_DATA /dev/vx/rdsk/racdg/datafile58 104 0 0.00 1.00 0 0 0 0.00
UNDOTBS1 /dev/vx/rdsk/racdg/datafile381 0 0     50 0 0 0.00
UNDOTBS1 /dev/vx/rdsk/racdg/undotbs01a 0 0     31 0 0 0.00
UNDOTBS1 /dev/vx/rdsk/racdg/undotbs01c 0 0     2 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile106 1,842 1 0.29 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile115 1,052 1 0.26 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile117 3,453 2 0.29 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile139 729 0 0.40 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile21 987 1 0.14 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile330 5,802 3 0.28 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile342 2,445 1 0.30 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile382 866 0 0.25 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile91 187 0 0.16 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile96 4,036 2 0.25 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/users01 4,082 2 0.31 1.00 0 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,769,674 145,192 947 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 378 2066 21152 2147310 21152  
E 0 0 694 8174 12485 2147310 12485  

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.24 1,087,863,478
D 4,576 0.20 548,834 3.05 633,421,253
D 6,864 0.30 823,251 1.63 338,487,821
D 9,152 0.40 1,097,668 1.30 270,669,880
D 11,440 0.50 1,372,085 1.21 250,490,214
D 13,728 0.60 1,646,502 1.14 237,487,497
D 16,016 0.70 1,920,919 1.10 228,596,358
D 18,304 0.80 2,195,336 1.06 219,233,053
D 20,592 0.90 2,469,753 1.03 213,116,130
D 22,880 1.00 2,744,170 1.00 207,566,744
D 22,960 1.00 2,753,765 1.00 207,439,206
D 25,168 1.10 3,018,587 0.98 202,723,356
D 27,456 1.20 3,293,004 0.96 200,022,190
D 29,744 1.30 3,567,421 0.95 198,031,319
D 32,032 1.40 3,841,838 0.95 196,676,708
D 34,320 1.49 4,116,255 0.94 195,895,393
D 36,608 1.59 4,390,672 0.94 195,262,475
D 38,896 1.69 4,665,089 0.94 194,311,039
D 41,184 1.79 4,939,506 0.93 192,812,537
D 43,472 1.89 5,213,923 0.90 187,655,405
D 45,760 1.99 5,488,340 0.82 169,304,994

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 422 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,437 2,792.71 4.67 0.17 100.00 0.00 419,430
E 4,096 1,412 2,796.49 1.81 0.06 100.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,010 3,010 0 0
64K 128K 43 43 0 0
512K 1024K 398 398 0 0
1M 2M 70 70 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,020,215.86 952,754.52 94.00 12,086
1,024 0.25 16,020,215.86 855,797.29 95.00 10,990
2,048 0.50 16,020,215.86 250,497.78 98.00 2,965
3,072 0.75 16,020,215.86 29,596.26 100.00 0
4,096 1.00 16,020,215.86 29,596.26 100.00 0
4,915 1.20 16,020,215.86 24,239.42 100.00 0
5,734 1.40 16,020,215.86 24,239.42 100.00 0
6,554 1.60 16,020,215.86 24,239.42 100.00 0
7,373 1.80 16,020,215.86 24,239.42 100.00 0
8,192 2.00 16,020,215.86 24,239.42 100.00 0
12,288 3.00 16,020,215.86 24,239.42 100.00 0
16,384 4.00 16,020,215.86 24,239.42 100.00 0
24,576 6.00 16,020,215.86 24,239.42 100.00 0
32,768 8.00 16,020,215.86 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,931 6,813,445 0.99 81,406 4.84 860,833,404
4,064 0.29 2,874 78,979 6,858,878 1.00 35,973 2.14 860,970,140
5,456 0.40 4,263 115,464 6,872,459 1.00 22,392 1.33 861,019,430
6,848 0.50 5,651 130,301 6,875,867 1.00 18,984 1.13 861,026,250
8,240 0.60 7,032 196,433 6,878,032 1.00 16,819 1.00 861,028,763
9,632 0.70 8,408 242,342 6,878,042 1.00 16,809 1.00 861,029,330
11,024 0.80 8,941 258,563 6,878,042 1.00 16,809 1.00 861,029,362
12,416 0.90 9,042 266,187 6,878,042 1.00 16,809 1.00 861,029,388
13,808 1.00 9,042 266,187 6,878,042 1.00 16,809 1.00 861,029,388
15,200 1.10 9,042 266,187 6,878,042 1.00 16,809 1.00 861,029,388
16,592 1.20 9,042 266,187 6,878,042 1.00 16,809 1.00 861,029,388
17,984 1.30 9,042 266,187 6,878,042 1.00 16,809 1.00 861,029,388
19,376 1.40 9,042 266,187 6,878,042 1.00 16,809 1.00 861,029,388
20,768 1.50 9,042 266,187 6,878,042 1.00 16,809 1.00 861,029,388
22,160 1.60 9,042 266,187 6,878,042 1.00 16,809 1.00 861,029,388
23,552 1.71 9,042 266,187 6,878,042 1.00 16,809 1.00 861,029,388
24,944 1.81 9,042 266,187 6,878,042 1.00 16,809 1.00 861,029,388
26,336 1.91 9,042 266,187 6,878,042 1.00 16,809 1.00 861,029,388
27,728 2.01 9,042 266,187 6,878,042 1.00 16,809 1.00 861,029,388

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,137 663,467,993
18,432 0.50 900,165 262,371,245
27,648 0.75 887,230 229,639,660
36,864 1.00 879,927 207,424,496
46,080 1.25 878,607 203,524,915
55,296 1.50 869,984 177,327,202
64,512 1.75 869,984 177,327,202
73,728 2.00 869,984 177,327,202

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 20 20 0 13 2 133.38
PS-PX Process Reservation 4,157 4,102 55 1,200 0 0.41
JQ-Job Queue 383 378 6 362 0 0.69
US-Undo Segment 1,314 1,314 0 770 0 0.23
CF-Controlfile Transaction 4,270 4,270 0 93 0 0.77
TM-DML 2,870 2,870 0 2 0 36.00
TA-Instance Undo 7 7 0 6 0 0.17
FB-Format Block 5 5 0 3 0 0.33
HW-Segment High Water Mark 1,834 1,834 0 3 0 0.33
TQ-Queue table enqueue (TM contention) 2 2 0 1 0 1.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.49 1,640 2,695 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 13:38 117 167 0 3 5,760 0/0 0/0/0/0/0/0
05-Dec 13:28 158 1,141 2,503 3 5,760 0/0 0/0/0/0/0/0
05-Dec 13:18 2 110 1,900 2 5,760 0/0 0/0/0/0/0/0
05-Dec 13:08 211 222 2,695 4 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,535 0.00   0 0  
AWR Alerted Metric Element list 12,775 0.00   0 0  
Consistent RBA 1,227 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,651 0.00   0 0  
JS broadcast add buf latch 413 0.00   0 0  
JS broadcast drop buf latch 413 0.00   0 0  
JS broadcast load blnc latch 361 0.00   0 0  
JS mem alloc latch 6 0.00   0 0  
JS queue access latch 6 0.00   0 0  
JS queue state obj latch 36,822 0.00   0 0  
KCL gc element parent latch 477,454 0.00 0.00 0 81 0.00
KJC message pool free list 3,125 0.06 0.00 0 141 0.00
KJCT flow control latch 195,350 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 602 0.00   0 0  
KSXR large replies 120 0.00   0 0  
KTF sga latch 8 0.00   0 491 0.00
KWQMN job cache list latch 752 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 602 0.00
Memory Queue 4,242 0.00   0 0  
Memory Queue Subscriber 580 0.00   0 0  
OS process 2,106 0.00   0 0  
OS process allocation 2,008 0.00   0 0  
OS process: request allocation 1,393 0.00   0 0  
PL/SQL warning settings 1,900 0.00   0 0  
SQL memory manager latch 1 0.00   0 602 0.00
SQL memory manager workarea list latch 43,257 0.00   0 0  
Shared B-Tree 10,759 0.00   0 0  
active checkpoint queue latch 3,163 0.00   0 0  
active service list 14,009 0.00   0 615 0.00
archive control 30 0.00   0 0  
archive process latch 674 0.00   0 0  
begin backup scn array 2 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,166 0.00   0 0  
cache buffer handles 171 0.00   0 0  
cache buffers chains 5,285,123 0.00 0.00 0 150,081 0.00
cache buffers lru chain 108,989 0.00 0.00 0 323,961 0.00
channel handle pool latch 1,393 0.00   0 0  
channel operations parent latch 156,473 0.01 0.00 0 0  
checkpoint queue latch 200,691 0.00 0.00 0 1,274 0.00
client/application info 6,622 0.00   0 0  
commit callback allocation 8 0.00   0 0  
compile environment latch 1,685 0.00   0 0  
datapump attach fixed tables latch 1,683 0.00   0 0  
datapump job fixed tables latch 1,683 0.00   0 0  
dml lock allocation 5,769 0.00   0 0  
dummy allocation 3,367 0.00   0 0  
enqueue hash chains 804,890 0.00 0.00 0 164 0.00
enqueue sob latch 1 0.00   0 0  
enqueues 443,498 0.01 0.00 0 0  
error message lists 589 0.00   0 0  
event group latch 697 0.00   0 0  
file cache latch 1,657 0.00   0 0  
gcs opaque info freelist 6,658 0.00   0 0  
gcs partitioned table hash 683,075 0.00   0 0  
gcs remastering latch 1,372 0.00   0 0  
gcs resource freelist 12,086 0.00   0 29,445 0.00
gcs resource hash 296,197 0.00 0.00 0 0  
gcs shadows freelist 17,897 0.00   0 32,434 0.00
ges caches resource lists 77,033 0.05 0.00 0 25,154 0.04
ges deadlock list 26 0.00   0 0  
ges domain table 370,013 0.00   0 0  
ges enqueue table freelist 373,299 0.00   0 0  
ges group table 557,540 0.00   0 0  
ges process hash list 4,620 0.00   0 0  
ges process parent latch 751,715 0.00   0 0  
ges process table freelist 1,393 0.00   0 0  
ges resource hash list 568,999 0.16 0.00 0 6,466 0.06
ges resource scan list 27 0.00   0 0  
ges resource table freelist 10,061 0.05 0.00 0 0  
ges timeout list 1,598 0.00   0 1,303 0.00
global KZLD latch for mem in SGA 644 0.00   0 0  
global tx hash mapping 422 0.00   0 0  
hash table column usage latch 95 0.00   0 35,285 0.00
hash table modification latch 48 0.00   0 0  
job workq parent latch 0     0 744 0.13
job_queue_processes parameter latch 391 0.00   0 0  
kks stats 16 0.00   0 0  
kokc descriptor allocation latch 242 0.00   0 0  
ksuosstats global area 122 0.00   0 0  
ktm global data 9 0.00   0 0  
kwqbsn:qsga 4,811 0.00   0 0  
lgwr LWN SCN 1,646 0.00   0 0  
library cache 81,380 0.37 0.00 0 0  
library cache load lock 10 0.00   0 0  
library cache lock 57,769 0.40 0.00 0 0  
library cache lock allocation 1,718 0.00   0 0  
library cache pin 32,510 0.27 0.00 0 0  
library cache pin allocation 43 0.00   0 0  
list of block allocation 62 0.00   0 0  
loader state object freelist 2 0.00   0 0  
logminer context allocation 1 0.00   0 0  
message pool operations parent latch 4,010 0.00   0 0  
messages 71,126 0.03 0.00 0 0  
mostly latch-free SCN 1,657 0.00   0 0  
multiblock read objects 338 0.00   0 0  
name-service memory objects 4,638 0.00   0 0  
name-service namespace bucket 22,931 0.00   0 0  
name-service pending queue 662 0.00   0 0  
name-service request queue 20,344 0.00   0 0  
ncodef allocation latch 29 0.00   0 0  
object queue header heap 118,238 0.00 0.00 0 102,554 0.00
object queue header operation 432,956 0.00 0.00 0 0  
object stats modification 1 0.00   0 0  
parallel query alloc buffer 10,956 0.00   0 0  
parallel query stats 1,782 0.00   0 0  
parallel txn reco latch 7,866 0.00   0 0  
parameter list 169 0.00   0 0  
parameter table allocation management 1,682 0.00   0 0  
post/wait queue 377 0.00   0 264 0.00
process allocation 20,685 0.06 0.92 0 697 0.00
process group creation 1,393 0.00   0 0  
process queue 6,488 0.00   0 0  
process queue reference 107,565 0.01 0.00 0 9,529 0.04
qmn state object latch 2 0.00   0 0  
qmn task queue latch 2,276 29.61 0.03 0 0  
query server freelists 5,301 0.00   0 0  
queue sender's info. latch 7,864 1.31 0.00 0 0  
queued dump request 9,016 0.00   0 0  
redo allocation 4,515 0.60 0.00 0 17,396 0.07
redo copy 0     0 17,405 0.37
redo writing 8,106 0.00   0 0  
resmgr group change latch 1,982 0.00   0 0  
resmgr:active threads 3,362 0.00   0 0  
resmgr:actses change group 1,319 0.00   0 0  
resmgr:free threads list 3,361 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 812,154 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 5,219 0.00   0 0  
session allocation 75,250 0.03 0.00 0 0  
session idle bit 43,479 0.00   0 0  
session state list latch 3,378 0.00   0 0  
session switching 29 0.00   0 0  
session timer 615 0.00   0 0  
shared pool 59,847 0.00 0.00 0 0  
shared pool sim alloc 1 0.00   0 0  
shared pool simulator 421,868 0.00   0 0  
simulator hash latch 112,984 0.00   0 0  
simulator lru latch 0     0 112,956 0.00
slave class 3 0.00   0 0  
slave class create 12 8.33 1.00 0 0  
sort extent pool 80 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 6,035,976 0.00   0 0  
transaction branch allocation 618 0.00   0 0  
undo global data 11,400 0.00   0 0  
user lock 2,597 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
qmn task queue latch 2,276 674 20 654 0 0 0
process allocation 20,685 12 11 1 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
cache buffers chains kcbzgb: scan from tail. nowait 0 1 0
channel operations parent latch ksrmfree() 0 1 0
event range base latch No latch 0 20 20
object queue header operation kcbw_unlink_q 0 2 0
object queue header operation kcbo_switch_mq_bg 0 1 0
process allocation ksufap: active procs 0 6 4
process allocation ksucrp 0 5 0
queue sender's info. latch kwqbcurit: read sender info 0 1 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 390,256 14.06
SYS SYSTEM I_FILE#_BLOCK#   INDEX 329,888 11.89
EVS DAT_EVSAS EVS_VOUCHER_LINE   TABLE 264,240 9.52
SYS SYSTEM SEG$   TABLE 242,672 8.74
SYS SYSTEM USER$   TABLE 231,472 8.34

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
EVS DAT_EVSAS INF_PAYMENT_JOURNAL_LINE   TABLE 38 0.03
EVS DAT_EVSAS EVS_VOUCHER_LINE   TABLE 27 0.02
EVS DAT_EVSAS FK_INF_PAYMENT_LINE_NUM   INDEX 17 0.01
EVS DAT_EVSAS FK_VOUCHER_LINE_DATE   INDEX 11 0.01
EVS DAT_EVSAS FK_INF_PAYMENT_LINE_DATE   INDEX 8 0.01

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
EVS DAT_EVSAS FK_VOUCHER_LINE_NUM   INDEX 8 34.78
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY_PK 982_112240 INDEX PARTITION 8 34.78
EVS DAT_EVSAS FK_INF_PAYMENT_HEADER   INDEX 4 17.39
EVS DAT_EVSAS FK_INF_PAYMENT_LINE_NUM   INDEX 2 8.70
EVS DAT_EVSAS FK_VOUCHER_LINE_DATE   INDEX 1 4.35

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

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
SYS SYSTEM JOB$   TABLE 102 1.17
EVS DAT_EVSAS EVS_VOUCHER   TABLE 64 0.73
SYS SYSTEM TAB$   TABLE 27 0.31
SYS SYSTEM SMON_SCN_TIME   TABLE 20 0.23
EVS DAT_EVSAS EVS_VOUCHER_LINE   TABLE 12 0.14

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
SYS SYSAUX WRH$_SQLSTAT_INDEX 982_112240 INDEX PARTITION 42 11.54
SYS SYSTEM JOB$   TABLE 24 6.59
EVS DAT_EVSAS EVS_VOUCHER   TABLE 16 4.40
EVS DAT_EVSAS EVS_VOUCHER_LINE   TABLE 13 3.57
SYS SYSTEM TAB$   TABLE 8 2.20

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 31 6.45 0   0 1
dc_database_links 1,350 0.00 0   0 26
dc_files 3,250 0.00 0   0 254
dc_global_oids 1,925 0.00 0   0 309
dc_histogram_data 3,792 0.00 0   0 36,294
dc_histogram_defs 842 0.48 0   0 11,502
dc_object_ids 8,369 0.01 0   0 6,657
dc_objects 1,015 0.00 0   0 8,757
dc_profiles 656 0.00 0   0 2
dc_rollback_segments 15,285 0.00 0   0 1,313
dc_segments 418 0.00 0   4 2,700
dc_sequences 52 1.92 0   52 12
dc_tablespace_quotas 2 50.00 0   2 12
dc_tablespaces 193,810 0.00 0   0 43
dc_usernames 2,741 0.00 0   0 148
dc_users 45,641 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 2 2 0
dc_histogram_defs 4 0 0
dc_object_ids 1 0 0
dc_segments 8 1 0
dc_sequences 104 0 0
dc_tablespace_quotas 4 0 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 57 0.00 1,398 0.00 0 0
CLUSTER 4 0.00 4 0.00 0 0
INDEX 1 0.00 11 0.00 0 0
SQL AREA 6,265 0.26 424,512 0.03 61 0
TABLE/PROCEDURE 885 0.00 7,017 0.07 3 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
CLUSTER 4 0 0 0 0
INDEX 11 0 0 0 0
TABLE/PROCEDURE 2,341 0 0 0 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,514.87   22.61 133.82 1,099 1,099 67 67
  PL/SQL 1,145.54 123.88 17.62 141.31 1,139 1,139 65 65
  SQL 82.65 72.37 1.92 8.17 38 402 43 27
  Freeable 49.69 0.00 1.60 2.31 10   31 31
E 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

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.52 639.56 0.01
shared PCursor 396.82 396.84 0.01
shared db_block_hash_buckets 180.00 180.00 0.00
shared free memory 3,876.23 3,874.84 -0.04
shared gcs resources 478.41 478.41 0.00
shared gcs shadows 286.48 286.48 0.00
shared library cache 273.93 273.95 0.01
shared sql area 7,058.03 7,059.28 0.02
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 Coordinator 312,071 0 0
QMON Slaves -249,753 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,869,664 2,861,412 3096098 3096098
gcs_shadows 2,133,466 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) 28,872 15.98 9.88
acks for commit broadcast(logical) 29,543 16.36 10.11
broadcast msgs on commit(actual) 1,223 0.68 0.42
broadcast msgs on commit(logical) 1,226 0.68 0.42
broadcast msgs on commit(wasted) 23 0.01 0.01
broadcast on commit wait time(ms) 120 0.07 0.04
broadcast on commit waits 831 0.46 0.28
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 73 0.04 0.02
flow control messages sent 15 0.01 0.01
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 3,010 1.67 1.03
gcs ast xid 0 0.00 0.00
gcs blocked converts 452 0.25 0.15
gcs blocked cr converts 594 0.33 0.20
gcs compatible basts 10 0.01 0.00
gcs compatible cr basts (global) 5 0.00 0.00
gcs compatible cr basts (local) 7,185 3.98 2.46
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 143 0.08 0.05
gcs dbwr write request msgs 43 0.02 0.01
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 637 0.35 0.22
gcs immediate (null) converts 2,949 1.63 1.01
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 26,668 14.76 9.13
gcs indirect ast 22,774 12.61 7.79
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 12 0.01 0.00
gcs msgs process time(ms) 3,531 1.95 1.21
gcs msgs received 158,950 88.00 54.40
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,032 1.12 0.70
gcs side channel msgs logical 9,079 5.03 3.11
gcs stale cr 73,405 40.64 25.12
gcs undo cr 0 0.00 0.00
gcs write notification msgs 0 0.00 0.00
gcs writes refused 1 0.00 0.00
ges msgs process time(ms) 126 0.07 0.04
ges msgs received 8,005 4.43 2.74
global posts dropped 0 0.00 0.00
global posts queue time 9 0.00 0.00
global posts queued 4 0.00 0.00
global posts requested 4 0.00 0.00
global posts sent 4 0.00 0.00
implicit batch messages received 3,298 1.83 1.13
implicit batch messages sent 900 0.50 0.31
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 2,434 1.35 0.83
messages queue sent actual 13,971 7.73 4.78
messages queue sent logical 15,012 8.31 5.14
messages received actual 154,097 85.31 52.74
messages received logical 166,955 92.43 57.14
messages sent directly 83,424 46.18 28.55
messages sent indirectly 8,686 4.81 2.97
messages sent not implicit batched 13,071 7.24 4.47
messages sent pbatched 40,645 22.50 13.91
msgs causing lmd to send msgs 3,346 1.85 1.15
msgs causing lms(s) to send msgs 2,208 1.22 0.76
msgs received queue time (ms) 1,843 1.02 0.63
msgs received queued 166,955 92.43 57.14
msgs sent queue time (ms) 395 0.22 0.14
msgs sent queue time on ksxp (ms) 21,753 12.04 7.44
msgs sent queued 14,900 8.25 5.10
msgs sent queued on ksxp 127,095 70.36 43.50
process batch messages received 76,899 42.57 26.32
process batch messages sent 34,051 18.85 11.65


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 886
CURRENT Block Requests 10
Data Block Requests 886
Undo Block Requests 0
TX Block Requests 1
Current Results 896
Private results 0
Zero Results 0
Disk Read Results 0
Fail Results 0
Fairness Down Converts 208
Fairness Clears 0
Free GC Elements 0
Flushes 248
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 17
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 5,140 100.00 0.00 0.00 0.00 0.00
Flushes 0 0.00 0.00 0.00 0.00 0.00
Writes 145 86.90 9.66 0.69 2.76 0.00


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 undo header 5,401 99.74 0.09 0.17 84 94.05 4.76 1.19
2 Others 2,971 99.87 0.00 0.13 44 100.00 0.00 0.00
2 data block 343 99.13 0.87 0.00 237 100.00 0.00 0.00


Back to Top

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