Using the report name awrrpt_1_112311_112312.html AWR Report

WORKLOAD REPOSITORY report for

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

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:11231105-Dec-16 12:00:3480 7.3
End Snap:11231205-Dec-16 12:30:3670 8.2
Elapsed:  30.03 (mins)  
DB Time:  3.46 (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: 4,417.64 4,215.24
Logical reads: 2,131.42 2,033.77
Block changes: 22.89 21.84
Physical reads: 75.71 72.24
Physical writes: 0.48 0.46
User calls: 10.50 10.02
Parses: 90.54 86.39
Hard parses: 0.03 0.03
Sorts: 5.04 4.80
Logons: 0.93 0.89
Executes: 129.89 123.94
Transactions: 1.05 

% Blocks changed per Read: 1.07Recursive Call %: 99.50
Rollback per transaction %: 97.09Rows per Sort: 40.32

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 96.45In-memory Sort %: 100.00
Library Hit %: 99.97Soft Parse %: 99.96
Execute to Parse %: 30.29Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 157.29% Non-Parse CPU: 96.51

Shared Pool Statistics

BeginEnd
Memory Usage %: 71.83 71.83
% SQL with executions>1: 99.76 99.87
% Memory for SQL w/exec>1: 99.23 99.49

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  130  62.5 
db file sequential read 136,649 41 0 19.6User I/O
reliable message 1,889 33 18 16.1Other
gc cr disk read 67,043 28 0 13.3Cluster
PX Deq Credit: send blkd 2,885 14 5 6.9Other

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 11.73 11.19
Global Cache blocks served: 7.02 6.70
GCS/GES messages received: 94.51 90.18
GCS/GES messages sent: 79.76 76.10
DBWR Fusion writes: 0.02 0.02
Estd Interconnect traffic (KB) 184.01 

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

Buffer access - local cache %: 95.90
Buffer access - remote cache %: 0.55
Buffer access - disk %: 3.55

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): 1.9
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 %: 52.6
Avg global cache cr block flush time (ms): 3.9
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.1
Avg global cache current block flush time (ms): 0.8

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: 89.90
% of indirect sent messages: 8.47
% of flow controlled messages: 1.62


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 205.88 99.12
DB CPU 129.76 62.48
PL/SQL execution elapsed time 6.38 3.07
connection management call elapsed time 2.33 1.12
parse time elapsed 2.06 0.99
sequence load elapsed time 0.32 0.15
hard parse elapsed time 0.06 0.03
failed parse elapsed time 0.03 0.02
repeated bind elapsed time 0.01 0.00
PL/SQL compilation elapsed time 0.00 0.00
DB time 207.70  
background elapsed time 109.04  
background cpu time 50.29  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Other 49,136 81.43 64 1 26.03
User I/O 136,658 0.00 41 0 72.38
Cluster 91,800 0.00 40 0 48.62
System I/O 21,868 0.00 6 0 11.58
Concurrency 536 0.00 0 1 0.28
Application 484 0.00 0 0 0.26
Network 24,358 0.00 0 0 12.90
Commit 24 0.00 0 1 0.01

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 136,649 0.00 41 0 72.38
reliable message 1,889 1.11 33 18 1.00
gc cr disk read 67,043 0.00 28 0 35.51
PX Deq Credit: send blkd 2,885 40.55 14 5 1.53
PX Deq: reap credit 17,951 97.60 11 1 9.51
gc cr block 2-way 13,656 0.00 6 0 7.23
control file sequential read 20,006 0.00 5 0 10.60
gcs log flush sync 1,316 14.74 4 3 0.70
gc current block busy 22 0.00 3 115 0.01
gc current grant busy 3,700 0.00 1 0 1.96
gc cr multi block request 5,391 0.00 1 0 2.86
gc current block 2-way 1,636 0.00 1 0 0.87
enq: PS - contention 1,199 0.00 1 0 0.64
wait for scn ack 539 0.00 1 1 0.29
control file parallel write 604 0.00 0 1 0.32
gc buffer busy 3 100.00 0 98 0.00
log file parallel write 654 0.00 0 0 0.35
enq: JQ - contention 362 0.00 0 1 0.19
CGS wait for IPC msg 17,537 100.00 0 0 9.29
db file parallel write 604 0.00 0 0 0.32
SQL*Net break/reset to client 482 0.00 0 0 0.26
os thread startup 2 0.00 0 70 0.00
row cache lock 528 0.00 0 0 0.28
latch free 64 0.00 0 2 0.03
PX Deq: Signal ACK 1,153 49.96 0 0 0.61
gc cr block congested 37 0.00 0 2 0.02
gc current grant 2-way 189 0.00 0 0 0.10
enq: CF - contention 96 0.00 0 1 0.05
DFS lock handle 168 0.00 0 0 0.09
ksxr poll remote instances 3,774 76.60 0 0 2.00
gc cr grant 2-way 86 0.00 0 0 0.05
IPC send completion sync 96 100.00 0 0 0.05
log file sync 24 0.00 0 1 0.01
SQL*Net message to client 15,681 0.00 0 0 8.31
gc cr block busy 11 0.00 0 1 0.01
rdbms ipc reply 62 0.00 0 0 0.03
enq: WF - contention 11 0.00 0 1 0.01
gc current block congested 3 0.00 0 2 0.00
SQL*Net more data from client 568 0.00 0 0 0.30
SQL*Net message to dblink 8,103 0.00 0 0 4.29
gc current multi block request 23 0.00 0 0 0.01
enq: TA - contention 6 0.00 0 0 0.00
direct path write 9 0.00 0 0 0.00
enq: TQ - TM contention 4 0.00 0 0 0.00
enq: FB - contention 2 0.00 0 0 0.00
buffer busy waits 2 0.00 0 0 0.00
enq: TM - contention 2 0.00 0 0 0.00
LGWR wait for redo copy 14 0.00 0 0 0.01
library cache lock 1 0.00 0 0 0.00
SQL*Net more data from dblink 2 0.00 0 0 0.00
SQL*Net more data to client 4 0.00 0 0 0.00
PX qref latch 7 57.14 0 0 0.00
latch: cache buffers chains 3 0.00 0 0 0.00
KJC: Wait for msg sends to complete 1 0.00 0 0 0.00
SQL*Net message from client 15,691 0.00 16,823 1072 8.31
gcs remote message 580,348 99.86 14,057 24 307.39
jobq slave wait 4,607 42.74 10,878 2361 2.44
Streams AQ: qmn slave idle wait 885 0.00 5,283 5970 0.47
wait for unread message on broadcast channel 3,850 82.42 3,396 882 2.04
PX Idle Wait 1,703 63.77 3,390 1990 0.90
Streams AQ: qmn coordinator idle wait 667 44.83 1,761 2640 0.35
DIAG idle wait 8,991 0.00 1,759 196 4.76
ges remote message 27,361 94.97 1,758 64 14.49
Streams AQ: waiting for time management or cleanup tasks 14 57.14 1,758 125560 0.01
virtual circuit status 60 100.00 1,758 29297 0.03
Streams AQ: waiting for messages in the queue 186 96.77 1,758 9450 0.10
SQL*Net message from dblink 8,101 0.00 922 114 4.29
PX Deq: Join ACK 1,741 34.00 86 50 0.92
PX Deq: Execution Msg 3,098 2.61 57 18 1.64
PX Deq: Parse Reply 1,592 30.59 0 0 0.84
single-task message 5 0.00 0 61 0.00
PX Deq: Execute Reply 1,364 29.18 0 0 0.72
PX Deq: Msg Fragment 159 39.62 0 0 0.08
Streams AQ: RAC qmn coordinator idle wait 672 97.92 0 0 0.36
class slave wait 2 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,817 86.93 36 1 12.61
db file sequential read 47,948 0.00 13 0 25.40
gc cr disk read 23,229 0.00 9 0 12.30
control file sequential read 4,803 0.00 2 0 2.54
gc cr block 2-way 1,286 0.00 1 1 0.68
control file parallel write 604 0.00 0 1 0.32
log file parallel write 654 0.00 0 0 0.35
db file parallel write 604 0.00 0 0 0.32
os thread startup 2 0.00 0 70 0.00
row cache lock 160 0.00 0 0 0.08
gc current block 2-way 66 0.00 0 1 0.03
gc cr grant 2-way 18 0.00 0 0 0.01
gc cr block congested 2 0.00 0 2 0.00
gc current grant busy 10 0.00 0 0 0.01
library cache lock 1 0.00 0 0 0.00
enq: TM - contention 1 0.00 -0 -0 0.00
rdbms ipc message 34,058 83.16 28,102 825 18.04
gcs remote message 580,353 99.86 14,058 24 307.39
Streams AQ: qmn slave idle wait 885 0.00 5,283 5970 0.47
Streams AQ: qmn coordinator idle wait 667 44.83 1,761 2640 0.35
pmon timer 615 100.00 1,761 2863 0.33
DIAG idle wait 8,991 0.00 1,759 196 4.76
ges remote message 27,359 94.97 1,758 64 14.49
Streams AQ: waiting for time management or cleanup tasks 14 57.14 1,758 125560 0.01
smon timer 9 0.00 1,723 191456 0.00
PX Deq: Join ACK 6 50.00 0 1 0.00
Streams AQ: RAC qmn coordinator idle wait 672 97.92 0 0 0.36
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 3,622
AVG_IDLE_TIME 176,418
AVG_IOWAIT_TIME 0
AVG_SYS_TIME 1,430
AVG_USER_TIME 2,137
BUSY_TIME 118,020
IDLE_TIME 5,647,385
IOWAIT_TIME 0
SYS_TIME 47,577
USER_TIME 70,443
LOAD 1
OS_CPU_WAIT_TIME 45,000
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 77,733,888
VM_OUT_BYTES ###############
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 186.00 109.20 88,339 3,015,541
appdbc 21.80 20.60 0 513,942
hrms 0.00 0.00 0 0
SYS$BACKGROUND 0.00 0.00 48,058 308,541
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

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 88339 2751 368 6 0 0 22349 2
appdbc 0 0 0 0 0 0 70 0
hrms 0 0 0 0 0 0 63 0
SYS$BACKGROUND 48317 1320 166 21 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 42 6 13.76 39.74 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
36 11 0   17.21 69atchvk0ukpy ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN SYS.DBMS_DATAPUMP.A...
36 11 580 0.06 17.15 afcz9s4uazbpk ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN :1 := sys.kupc$que_int.t...
32 32 51,219 0.00 15.61 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
29 5 580 0.05 14.07 gn74qsy7sv4z4 ude@erpdb-m9k-d00 (TNS V1-V3) SELECT COUNT(*) FROM gv$datapu...
22 20 1 21.50 10.35 a4fzhgvu1ccqc oracle@SGS-ORA-05 (TNS V1-V3) SELECT "A1"."CONTRACT_NUMBER",...
20 20 2 9.96 9.59 ga6cqp2y1j80m   SELECT BOE_NUM FROM (SELECT BH...
13 11 0   6.22 3v9c56u115sq3   DECLARE job BINARY_INTEGER := ...
12 11 1 11.61 5.59 dn36qnp9aaahh   DECLARE job BINARY_INTEGER := ...
5 5 154,509 0.00 2.26 2ym6hhaq30r73   select type#, blocks, extents,...
4 1 1 3.92 1.89 7px115t0jrzy8   DECLARE job BINARY_INTEGER := ...
3 3 2 1.69 1.63 6n4u7whzvtqg4   SELECT BOE_NUM FROM (SELECT BH...
3 1 328 0.01 1.46 8j8ctkxzh0gfz   UPDATE WFR.WFR_BILL_STATUS WS ...
3 2 1 2.82 1.36 cftaxubdx55hq   DECLARE job BINARY_INTEGER := ...
3 1 6 0.42 1.21 bnafqqprpz3u1 sqlplus@erpdb-m9k-d00 (TNS V1-V3) select tablespace_name, use_pr...
2 1 6 0.39 1.13 11ssd5xrck6sn JDBC Thin Client select sum("tablespace_size(M)...
2 2 638 0.00 1.09 3f751tsaf2j02 JDBC Thin Client SELECT VALUE FROM NLS_INSTANCE...

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 83 6 7.01 39.74 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
32 32 51,219 0.00 15.61 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
20 22 1 20.30 10.35 a4fzhgvu1ccqc oracle@SGS-ORA-05 (TNS V1-V3) SELECT "A1"."CONTRACT_NUMBER",...
20 20 2 9.95 9.59 ga6cqp2y1j80m   SELECT BOE_NUM FROM (SELECT BH...
11 12 1 11.16 5.59 dn36qnp9aaahh   DECLARE job BINARY_INTEGER := ...
11 36 0   17.21 69atchvk0ukpy ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN SYS.DBMS_DATAPUMP.A...
11 36 580 0.02 17.15 afcz9s4uazbpk ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN :1 := sys.kupc$que_int.t...
11 13 0   6.22 3v9c56u115sq3   DECLARE job BINARY_INTEGER := ...
5 29 580 0.01 14.07 gn74qsy7sv4z4 ude@erpdb-m9k-d00 (TNS V1-V3) SELECT COUNT(*) FROM gv$datapu...
5 5 154,509 0.00 2.26 2ym6hhaq30r73   select type#, blocks, extents,...
3 3 2 1.35 1.63 6n4u7whzvtqg4   SELECT BOE_NUM FROM (SELECT BH...
2 3 1 2.40 1.36 cftaxubdx55hq   DECLARE job BINARY_INTEGER := ...
2 2 638 0.00 1.09 3f751tsaf2j02 JDBC Thin Client SELECT VALUE FROM NLS_INSTANCE...
1 4 1 1.32 1.89 7px115t0jrzy8   DECLARE job BINARY_INTEGER := ...
1 3 6 0.21 1.21 bnafqqprpz3u1 sqlplus@erpdb-m9k-d00 (TNS V1-V3) select tablespace_name, use_pr...
1 2 6 0.20 1.13 11ssd5xrck6sn JDBC Thin Client select sum("tablespace_size(M)...
1 3 328 0.00 1.46 8j8ctkxzh0gfz   UPDATE WFR.WFR_BILL_STATUS WS ...

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,624,828 6 270,804.67 42.32 42.05 82.54 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
513,925 1 513,925.00 13.38 20.30 21.50 a4fzhgvu1ccqc oracle@SGS-ORA-05 (TNS V1-V3) SELECT "A1"."CONTRACT_NUMBER",...
494,858 2 247,429.00 12.89 2.70 3.38 6n4u7whzvtqg4   SELECT BOE_NUM FROM (SELECT BH...
463,527 154,509 3.00 12.07 4.69 4.69 2ym6hhaq30r73   select type#, blocks, extents,...
440,478 2 220,239.00 11.47 19.91 19.92 ga6cqp2y1j80m   SELECT BOE_NUM FROM (SELECT BH...
438,709 1 438,709.00 11.43 2.40 2.82 cftaxubdx55hq   DECLARE job BINARY_INTEGER := ...
252,589 0   6.58 10.73 12.92 3v9c56u115sq3   DECLARE job BINARY_INTEGER := ...
239,093 1 239,093.00 6.23 11.16 11.61 dn36qnp9aaahh   DECLARE job BINARY_INTEGER := ...
221,931 51,219 4.33 5.78 32.18 32.43 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
96,478 6 16,079.67 2.51 1.26 2.52 bnafqqprpz3u1 sqlplus@erpdb-m9k-d00 (TNS V1-V3) select tablespace_name, use_pr...
78,989 1 78,989.00 2.06 1.32 3.92 7px115t0jrzy8   DECLARE job BINARY_INTEGER := ...
72,899 1 72,899.00 1.90 1.02 1.02 fqt50nnb57zqz   SELECT * FROM INF_AP_JOURNAL_H...
59,322 1 59,322.00 1.54 0.88 0.88 2mgs8qvwgrg8r   SELECT * FROM INF_PAYMENT_JOUR...

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,058 6 14,676.33 64.56 42.05 82.54 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
47,874 51,219 0.93 35.10 32.18 32.43 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
125 328 0.38 0.09 0.66 3.02 8j8ctkxzh0gfz   UPDATE WFR.WFR_BILL_STATUS WS ...
95 0   0.07 10.73 12.92 3v9c56u115sq3   DECLARE job BINARY_INTEGER := ...
79 1 79.00 0.06 1.32 3.92 7px115t0jrzy8   DECLARE job BINARY_INTEGER := ...
26 2 13.00 0.02 19.91 19.92 ga6cqp2y1j80m   SELECT BOE_NUM FROM (SELECT BH...
13 1 13.00 0.01 11.16 11.61 dn36qnp9aaahh   DECLARE job BINARY_INTEGER := ...
10 328 0.03 0.01 0.61 0.99 88qprfrfky6tv   INSERT INTO WFR.WFR_BILL_HISTO...
4 1 4.00 0.00 0.00 0.00 3m8smr0v7v1m6   INSERT INTO sys.wri$_adv_messa...
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
154,509 154,509 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
51,219 0 0.00 0.00 0.00 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
3,934 3,934 1.00 0.00 0.00 74888btg9dfq2   UPDATE SIE.SIE_BOE_HEADERS SH ...
1,320 72 0.05 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
657 1,313 2.00 0.00 0.00 05uqdabhzncdc   select role# from defrole$ d, ...
638 638 1.00 0.00 0.00 3f751tsaf2j02 JDBC Thin Client SELECT VALUE FROM NLS_INSTANCE...
580 0 0.00 0.02 0.06 afcz9s4uazbpk ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN :1 := sys.kupc$que_int.t...
580 580 1.00 0.01 0.05 gn74qsy7sv4z4 ude@erpdb-m9k-d00 (TNS V1-V3) SELECT COUNT(*) FROM gv$datapu...
527 4,515 8.57 0.00 0.00 bsa0wjtftg3uw   select file# from file$ where ...
375 376 1.00 0.00 0.00 a1mbfp580hw3k   select u1.user#, u2.user#, u...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
154,509 154,509 94.73 2ym6hhaq30r73   select type#, blocks, extents,...
1,320 1,320 0.81 0h6b2sajwb74n   select privilege#, level from ...
657 657 0.40 05uqdabhzncdc   select role# from defrole$ d, ...
638 638 0.39 3f751tsaf2j02 JDBC Thin Client SELECT VALUE FROM NLS_INSTANCE...
580 580 0.36 gn74qsy7sv4z4 ude@erpdb-m9k-d00 (TNS V1-V3) SELECT COUNT(*) FROM gv$datapu...
527 527 0.32 bsa0wjtftg3uw   select file# from file$ where ...
376 375 0.23 a1mbfp580hw3k   select u1.user#, u2.user#, u...
376 17 0.23 aq8yqxyyb40nn   update sys.job$ set this_date=...
375 15 0.23 47a50dvdgnxc2   update sys.job$ set failures=0...
367 367 0.22 4m7m0t6fjcs5x   update seq$ set increment$=:2,...

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
21.11 25.57 82.54 42.05 6 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
9.86 30.39 32.43 32.18 51,219 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
2.39 60.89 3.92 1.32 1 7px115t0jrzy8   DECLARE job BINARY_INTEGER := ...
2.37 78.28 3.02 0.66 328 8j8ctkxzh0gfz   UPDATE WFR.WFR_BILL_STATUS WS ...
2.19 16.97 12.92 10.73 0 3v9c56u115sq3   DECLARE job BINARY_INTEGER := ...
2.14 9.96 21.50 20.30 1 a4fzhgvu1ccqc oracle@SGS-ORA-05 (TNS V1-V3) SELECT "A1"."CONTRACT_NUMBER",...
1.16 69.28 1.67 1.64 3,934 74888btg9dfq2   UPDATE SIE.SIE_BOE_HEADERS SH ...
0.88 26.00 3.38 2.70 2 6n4u7whzvtqg4   SELECT BOE_NUM FROM (SELECT BH...
0.73 74.37 0.99 0.61 328 88qprfrfky6tv   INSERT INTO WFR.WFR_BILL_HISTO...
0.68 5.87 11.61 11.16 1 dn36qnp9aaahh   DECLARE job BINARY_INTEGER := ...
0.57 20.11 2.82 2.40 1 cftaxubdx55hq   DECLARE job BINARY_INTEGER := ...
0.32 46.86 0.69 0.43 1 fbxacrra3ym8n JDBC Thin Client select sum(bytes/1024/1024/102...
0.30 93.59 0.32 0.03 17 aq8yqxyyb40nn   update sys.job$ set this_date=...
0.19 0.95 19.92 19.91 2 ga6cqp2y1j80m   SELECT BOE_NUM FROM (SELECT BH...
0.01 44.90 0.03 0.03 3 c7sn076yz7030   select smontabv.cnt, smontab....
0.01 83.09 0.01 0.01 1 akh9zqqkx3wj7   select 1, max(id) from sys.wr...

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
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')
14566d856s6hsSELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1
298ppdduqr7wmSELECT status FROM sys.wri$_adv_tasks WHERE id = :1
2mgs8qvwgrg8rSELECT * FROM INF_PAYMENT_JOURNAL_HEADER T WHERE LAST_UPDATE_DATE > :B1
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'
3m8smr0v7v1m6INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
3v9c56u115sq3DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PROC_AUTO_BOESTATE_JOB.SYNCH_BOE_350STATE; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
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
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
69atchvk0ukpyBEGIN SYS.DBMS_DATAPUMP.ADD_FILE( handle => :JOBHNDL, filename => :FILENAME, directory => :DIRECTORY, filesize => :FILESIZE, filetype => :FILETYPE); END;
6n4u7whzvtqg4SELECT BOE_NUM FROM (SELECT BH.BOE_NUM FROM SIE_BOE_HEADERS BH, WFR.WFR_BILL_STATUS BS, SIE_INVOICES SI, SIE.SIE_BOE_TYPES ST WHERE BH.BOE_HEADER_ID = BS.BOE_HEADER_ID AND SI.BOE_HEADER_ID = BH.BOE_HEADER_ID AND BH.BOE_TYPE_ID = ST.BOE_TYPE_ID AND ST.BOE_TYPE_CODE NOT IN ('gd_finalAccounts', 'gd_glPayForAdjust') AND SI.SIE_INVOICE_TYPE = 'AP_INVOICE' AND BH.ENABLED_FLAG = 'Y' AND BH.CHECK_UNIT = 'SGS' AND BS.CURRENT_STATUS = :B1 AND BH.BOE_HEADER_ID > 2603856 ORDER BY BH.LAST_UPDATE_DATE) WHERE ROWNUM <= TO_NUMBER(:B2 )
74888btg9dfq2UPDATE SIE.SIE_BOE_HEADERS SH SET SH.LAST_UPDATE_DATE = SYSDATE WHERE SH.BOE_HEADER_ID = :B1
7px115t0jrzy8DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PROC_AUTO_BOESTATE_JOB.SYNCH_BOE_SGS_350STATE; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
88qprfrfky6tvINSERT INTO WFR.WFR_BILL_HISTORIES (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, ENABLED_FLAG, WF_HISTORIES_ID, BOE_HEADER_ID, WF_DEFINIENS_ID, PRE_WORKFLOW_STATUS, NEXT_WORKFLOW_STATUS) (SELECT SYSDATE, 1, SYSDATE, 1, 1, 'Y', :B2 , WH.BOE_HEADER_ID, WH.WF_DEFINIENS_ID, WH.NEXT_WORKFLOW_STATUS, :B1 FROM WFR_BILL_HISTORIES WH WHERE WH.WF_HISTORIES_ID = (SELECT MAX(HI.WF_HISTORIES_ID) FROM WFR_BILL_HISTORIES HI WHERE HI.BOE_HEADER_ID = :B3 ))
8j8ctkxzh0gfzUPDATE WFR.WFR_BILL_STATUS WS SET WS.LAST_UPDATE_DATE = SYSDATE, WS.CURRENT_STATUS = :B2 WHERE WS.BOE_HEADER_ID = :B1
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;
akh9zqqkx3wj7select 1, max(id) from sys.wri$_adv_objects where task_id = :1 union all select 2, max(id) from sys.wri$_adv_recommendations where task_id = :1 union all select 3, max(id) from sys.wri$_adv_actions where task_id = :1 union all select 4, max(id) from sys.wri$_adv_findings where task_id = :1 union all select 5, max(id) from sys.wri$_adv_rationale where task_id = :1
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
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
cftaxubdx55hqDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PROC_AUTO_BOESTATE_JOB.SYNCH_BOE_SGS_601STATE; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
dn36qnp9aaahhDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PROC_AUTO_BOESTATE_JOB.SYNCH_BOE_601STATE; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
fbxacrra3ym8nselect sum(bytes/1024/1024/1024) as totaldata from dba_segments
fqt50nnb57zqzSELECT * FROM INF_AP_JOURNAL_HEADER T WHERE LAST_UPDATE_DATE > :B1
ga6cqp2y1j80mSELECT BOE_NUM FROM (SELECT BH.BOE_NUM FROM SIE_BOE_HEADERS BH, WFR.WFR_BILL_STATUS BS, SIE_INVOICES SI, SIE.SIE_BOE_TYPES ST WHERE BH.BOE_HEADER_ID = BS.BOE_HEADER_ID AND SI.BOE_HEADER_ID = BH.BOE_HEADER_ID AND BH.BOE_TYPE_ID = ST.BOE_TYPE_ID AND ST.BOE_TYPE_CODE NOT IN ('gd_finalAccounts', 'gd_glPayForAdjust') AND SI.SIE_INVOICE_TYPE = 'AP_INVOICE' AND BH.ENABLED_FLAG = 'Y' AND BH.CHECK_UNIT != 'SGS' AND BS.CURRENT_STATUS = :B1 AND BH.BOE_HEADER_ID > 2603856 ORDER BY BH.LAST_UPDATE_DATE) WHERE ROWNUM <= TO_NUMBER(:B2 )
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 15,405 8.55 8.16
CPU used when call started 8,091 4.49 4.29
CR blocks created 1,571 0.87 0.83
Cached Commit SCN referenced 41,356 22.96 21.90
Commit SCN cached 6 0.00 0.00
DB time 20,489,329 11,373.47 10,852.40
DBWR checkpoint buffers written 814 0.45 0.43
DBWR checkpoints 0 0.00 0.00
DBWR fusion writes 42 0.02 0.02
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 29 0.02 0.02
DBWR undo block writes 259 0.14 0.14
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 582 0.32 0.31
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 3,474 1.93 1.84
PX local messages sent 3,474 1.93 1.84
PX remote messages recv'd 1,311 0.73 0.69
PX remote messages sent 2,409 1.34 1.28
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 582 0.32 0.31
RowCR - row contention 0 0.00 0.00
RowCR attempts 0 0.00 0.00
RowCR hits 158 0.09 0.08
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,822 7.67 7.32
SQL*Net roundtrips to/from dblink 8,239 4.57 4.36
active txn count during cleanout 933 0.52 0.49
application wait time 14 0.01 0.01
background checkpoints completed 0 0.00 0.00
background checkpoints started 0 0.00 0.00
background timeouts 8,179 4.54 4.33
branch node splits 0 0.00 0.00
buffer is not pinned count 1,309,276 726.77 693.47
buffer is pinned count 1,460,667 810.81 773.66
bytes received via SQL*Net from client 1,933,560 1,073.30 1,024.13
bytes received via SQL*Net from dblink 1,564,544 868.47 828.68
bytes sent via SQL*Net to client 765,975 425.19 405.71
bytes sent via SQL*Net to dblink 820,111 455.24 434.38
calls to get snapshot scn: kcmgss 546,640 303.44 289.53
calls to kcmgas 140,763 78.14 74.56
calls to kcmgcs 102 0.06 0.05
change write time 26 0.01 0.01
cleanout - number of ktugct calls 1,389 0.77 0.74
cleanouts and rollbacks - consistent read gets 745 0.41 0.39
cleanouts only - consistent read gets 444 0.25 0.24
cluster key scan block gets 567,477 315.00 300.57
cluster key scans 366,000 203.16 193.86
cluster wait time 4,001 2.22 2.12
commit batch performed 1 0.00 0.00
commit batch requested 1 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 15 0.01 0.01
commit cleanout failures: callback failure 28 0.02 0.01
commit cleanout failures: cannot pin 1 0.00 0.00
commit cleanouts 4,250 2.36 2.25
commit cleanouts successfully completed 4,206 2.33 2.23
commit immediate performed 0 0.00 0.00
commit immediate requested 0 0.00 0.00
commit txn count during cleanout 1,188 0.66 0.63
concurrency wait time 27 0.01 0.01
consistent changes 3,354 1.86 1.78
consistent gets 3,748,718 2,080.88 1,985.55
consistent gets - examination 1,090,245 605.19 577.46
consistent gets direct 0 0.00 0.00
consistent gets from cache 3,748,718 2,080.88 1,985.55
current blocks converted for CR 0 0.00 0.00
cursor authentications 0 0.00 0.00
data blocks consistent reads - undo records applied 1,665 0.92 0.88
db block changes 41,242 22.89 21.84
db block gets 91,039 50.54 48.22
db block gets direct 26 0.01 0.01
db block gets from cache 91,013 50.52 48.21
deferred (CURRENT) block cleanout applications 3,893 2.16 2.06
dirty buffers inspected 0 0.00 0.00
enqueue conversions 25,942 14.40 13.74
enqueue releases 227,248 126.14 120.36
enqueue requests 227,314 126.18 120.40
enqueue timeouts 56 0.03 0.03
enqueue waits 1,680 0.93 0.89
exchange deadlocks 0 0.00 0.00
execute count 233,991 129.89 123.94
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 17,289 9.60 9.16
free buffer requested 159,588 88.59 84.53
gc CPU used by this session 3,203 1.78 1.70
gc blocks lost 0 0.00 0.00
gc cr block build time 13 0.01 0.01
gc cr block flush time 487 0.27 0.26
gc cr block receive time 1,451 0.81 0.77
gc cr block send time 21 0.01 0.01
gc cr blocks received 19,322 10.73 10.23
gc cr blocks served 2,398 1.33 1.27
gc current block flush time 1 0.00 0.00
gc current block pin time 9 0.00 0.00
gc current block receive time 344 0.19 0.18
gc current block send time 79 0.04 0.04
gc current blocks received 1,804 1.00 0.96
gc current blocks served 10,249 5.69 5.43
gc local grants 69,011 38.31 36.55
gc remote grants 71,484 39.68 37.86
gcs messages sent 138,334 76.79 73.27
ges messages sent 5,348 2.97 2.83
global enqueue get time 225 0.12 0.12
global enqueue gets async 536 0.30 0.28
global enqueue gets sync 175,873 97.63 93.15
global enqueue releases 172,955 96.01 91.61
heap block compress 459 0.25 0.24
hot buffers moved to head of LRU 43 0.02 0.02
immediate (CR) block cleanout applications 1,189 0.66 0.63
immediate (CURRENT) block cleanout applications 310 0.17 0.16
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 3,000 1.67 1.59
index fast full scans (full) 9 0.00 0.00
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 903,720 501.65 478.67
index scans kdiixs1 16,179 8.98 8.57
leaf node 90-10 splits 28 0.02 0.01
leaf node splits 74 0.04 0.04
lob reads 0 0.00 0.00
lob writes 6 0.00 0.00
lob writes unaligned 6 0.00 0.00
logons cumulative 1,680 0.93 0.89
messages received 3,204 1.78 1.70
messages sent 3,204 1.78 1.70
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 2,274,522 1,262.57 1,204.73
opened cursors cumulative 163,595 90.81 86.65
parse count (failures) 61 0.03 0.03
parse count (hard) 62 0.03 0.03
parse count (total) 163,112 90.54 86.39
parse time cpu 453 0.25 0.24
parse time elapsed 288 0.16 0.15
physical read IO requests 136,396 75.71 72.24
physical read bytes 1,117,356,032 620,235.80 591,819.93
physical read total IO requests 156,650 86.96 82.97
physical read total bytes 1,447,149,568 803,301.67 766,498.71
physical read total multi block requests 0 0.00 0.00
physical reads 136,396 75.71 72.24
physical reads cache 136,396 75.71 72.24
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 616 0.34 0.33
physical write bytes 7,143,424 3,965.26 3,783.59
physical write total IO requests 3,084 1.71 1.63
physical write total bytes 44,941,824 24,946.86 23,803.93
physical write total multi block requests 349 0.19 0.18
physical writes 872 0.48 0.46
physical writes direct 26 0.01 0.01
physical writes direct (lob) 7 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 846 0.47 0.45
physical writes non checkpoint 464 0.26 0.25
pinned buffers inspected 5 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 0 0.00 0.00
process last non-idle time 2,360 1.31 1.25
queries parallelized 582 0.32 0.31
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 3,792,525 2,105.20 2,008.75
recursive cpu usage 4,319 2.40 2.29
redo blocks written 15,937 8.85 8.44
redo buffer allocation retries 0 0.00 0.00
redo entries 22,068 12.25 11.69
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 385 0.21 0.20
redo size 7,958,380 4,417.64 4,215.24
redo subscn max counts 158 0.09 0.08
redo synch time 1 0.00 0.00
redo synch writes 22 0.01 0.01
redo wastage 189,896 105.41 100.58
redo write time 23 0.01 0.01
redo writer latching time 0 0.00 0.00
redo writes 658 0.37 0.35
rollback changes - undo records applied 0 0.00 0.00
rollbacks only - consistent read gets 399 0.22 0.21
rows fetched via callback 332,924 184.80 176.34
session connect time 0 0.00 0.00
session cursor cache hits 156,515 86.88 82.90
session logical reads 3,839,757 2,131.42 2,033.77
session pga memory 74,948,169,040 41,603,156.17 39,697,123.43
session pga memory max 78,625,394,000 43,644,355.65 41,644,806.14
session uga memory 64,471,070,576 35,787,398.83 34,147,812.81
session uga memory max 1,371,749,016 761,447.40 726,561.98
shared hash latch upgrades - no wait 4,211 2.34 2.23
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 9,071 5.04 4.80
sorts (rows) 365,702 203.00 193.70
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 5 0.00 0.00
table fetch by rowid 675,382 374.90 357.72
table fetch continued row 546 0.30 0.29
table scan blocks gotten 1,589,084 882.09 841.68
table scan rows gotten 51,019,103 28,320.31 27,022.83
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) 76,422 42.42 40.48
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 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
undo change vector size 2,856,940 1,585.87 1,513.21
user I/O wait time 4,072 2.26 2.16
user calls 18,920 10.50 10.02
user commits 55 0.03 0.03
user rollbacks 1,833 1.02 0.97
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 6,877 3.82 3.64
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,131,002 6,136,505
opened cursors current 582 571
workarea memory allocated 1,786 1,595
logons current 80 70

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 79,808 44 0.28 1.00 0 0 0 0.00
USERS 22,423 12 0.33 1.00 0 0 0 0.00
SYSAUX 11,572 6 0.27 1.00 316 0 0 0.00
DAT_EPM 7,662 4 0.33 1.00 0 0 0 0.00
SYSTEM 7,325 4 0.28 1.00 25 0 2 0.00
EPM_GD_DATA 2,658 1 0.32 1.00 0 0 0 0.00
AUDIT_DATA 1,098 1 0.26 1.00 0 0 0 0.00
DAT_PAMS 1,092 1 0.29 1.00 0 0 0 0.00
DAT_EVSAS 643 0 0.96 1.00 195 0 0 0.00
EAS_DATA_NEW 617 0 0.78 1.00 1 0 0 0.00
EAS_IND 439 0 1.66 1.00 0 0 0 0.00
EIP_DATA 384 0 0.23 1.00 0 0 0 0.00
IDX_PAMS 342 0 0.06 1.00 0 0 0 0.00
MOB_DATA 198 0 0.15 1.00 0 0 0 0.00
TDEIP_DATA 96 0 0.10 1.00 0 0 0 0.00
UNDOTBS1 0 0 0.00 0.00 79 0 0 0.00
SIED 24 0 0.00 1.00 0 0 0 0.00
DAT_HRMS 12 0 0.00 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,098 1 0.26 1.00 0 0 0 0.00
DAT_EPM /dev/vx/rdsk/racdg/datafile304 108 0 0.00 1.00 0 0 0 0.00
DAT_EPM /dev/vx/rdsk/racdg/datafile52 3,798 2 0.31 1.00 0 0 0 0.00
DAT_EPM /dev/vx/rdsk/racdg/datafile53 3,756 2 0.36 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 22 0 0.91 1.00 4 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile333 26 0 0.77 1.00 2 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile36 273 0 0.37 1.00 3 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile37 55 0 0.91 1.00 1 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile373 36 0 3.33 1.00 77 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile374 46 0 2.83 1.00 53 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile38 16 0 2.50 1.00 3 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile388 29 0 2.76 1.00 49 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile72 31 0 0.32 1.00 2 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile81 91 0 0.55 1.00 1 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 12 0 0.00 1.00 0 0 0 0.00
DAT_PAMS /dev/vx/rdsk/racdg/datafile29 1,092 1 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile01 2,460 1 0.26 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile05 1,635 1 0.28 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile07 1,905 1 0.33 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile08 7,343 4 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile09 1,920 1 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile10 5,405 3 0.31 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile100 915 1 0.28 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile104 3,075 2 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile108 795 0 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile11 3,137 2 0.32 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile113 285 0 0.39 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile116 120 0 0.25 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile119 90 0 0.11 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile120 30 0 0.67 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile121 60 0 0.33 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 15 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile124 1 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile125 90 0 0.78 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile126 15 0 1.33 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile127 555 0 0.13 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile128 45 0 0.22 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile129 135 0 0.30 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile130 60 0 0.33 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile132 60 0 0.33 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile133 30 0 0.33 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile134 45 0 0.44 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile135 15 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile137 30 0 0.33 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile300 45 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile301 45 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile302 64 0 0.16 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile303 68 0 0.15 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile306 31 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile307 1,575 1 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile308 555 0 0.59 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile309 243 0 0.33 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile310 435 0 0.18 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile311 285 0 0.39 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile312 120 0 0.50 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile313 695 0 0.26 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile314 360 0 0.36 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile315 465 0 0.30 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile316 855 0 0.32 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile317 570 0 0.39 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile318 435 0 0.28 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile319 2,235 1 0.23 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile320 2,389 1 0.30 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile321 1,500 1 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile334 3,285 2 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile335 1,755 1 0.28 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile336 1,560 1 0.36 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile340 661 0 0.42 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile343 604 0 0.13 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile344 705 0 0.33 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile345 240 0 0.25 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile346 2,355 1 0.31 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile347 931 1 0.28 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile348 750 0 0.33 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile349 405 0 0.22 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile350 465 0 0.26 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile351 240 0 0.42 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile352 120 0 0.08 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile353 46 0 0.65 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile354 15 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile355 6,465 4 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile356 60 0 0.50 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile357 120 0 0.25 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile358 150 0 0.40 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile377 225 0 0.36 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile383 2,120 1 0.27 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile384 945 1 0.20 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile385 710 0 0.27 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile386 300 0 0.23 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile390 285 0 0.07 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile391 30 0 0.33 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile55 1,830 1 0.30 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile75 1,336 1 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile76 1,230 1 0.31 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile87 2,685 1 0.26 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile88 1,434 1 0.22 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile99 2,475 1 0.21 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile409 16 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile410 36 0 0.00 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 19 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile413 26 0 0.77 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile414 30 0 2.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile415 36 0 3.61 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile416 63 0 0.79 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile417 48 0 0.83 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile418 36 0 0.00 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 36 0 0.28 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile421 68 0 0.74 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile422 39 0 0.26 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile423 15 0 1.33 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile424 26 0 1.15 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile425 26 0 0.38 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile426 24 0 0.42 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile427 12 0 0.00 1.00 1 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile428 25 0 1.20 1.00 0 0 0 0.00
EAS_IND /dev/vx/rdsk/racdg/datafile02 191 0 0.89 1.00 0 0 0 0.00
EAS_IND /dev/vx/rdsk/racdg/datafile06 248 0 2.26 1.00 0 0 0 0.00
EIP_DATA /dev/vx/rdsk/racdg/datafile03 384 0 0.23 1.00 0 0 0 0.00
EPM_GD_DATA /dev/vx/rdsk/racdg/datafile378 2,658 1 0.32 1.00 0 0 0 0.00
IDX_PAMS /dev/vx/rdsk/racdg/datafile26 342 0 0.06 1.00 0 0 0 0.00
MOB_DATA /dev/vx/rdsk/racdg/datafile31 198 0 0.15 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 36 0 1.11 1.00 9 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile111 70 0 0.86 1.00 6 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile131 9 0 5.56 1.00 3 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile22 74 0 1.35 1.00 68 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile331 5 0 8.00 1.00 5 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile56 14 0 3.57 1.00 31 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile71 11 0 5.45 1.00 24 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile89 12 0 3.33 1.00 36 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile90 138 0 0.51 1.00 16 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/sysaux01 11,203 6 0.23 1.00 118 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/appdbc_system03 60 0 0.83 1.00 2 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile328 397 0 0.35 1.00 1 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile341 128 0 0.55 1.00 0 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile97 48 0 0.00 1.00 0 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/system01 6,638 4 0.27 1.00 22 0 2 0.00
SYSTEM /dev/vx/rdsk/racdg/system02 54 0 0.37 1.00 0 0 0 0.00
TDEIP_DATA /dev/vx/rdsk/racdg/datafile58 96 0 0.10 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     29 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile106 1,626 1 0.40 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile115 906 1 0.34 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile117 3,012 2 0.30 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile139 654 0 0.35 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile21 882 0 0.40 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile330 4,998 3 0.30 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile342 2,112 1 0.28 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile382 750 0 0.35 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile91 168 0 0.36 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile96 3,529 2 0.36 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/users01 3,786 2 0.34 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 96 3,839,236 136,402 846 0 0 2


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 249 1478 4730 2147310 4730  
E 0 1 5009 8977 16324 2147310 16324  

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,085,765,295
D 4,576 0.20 548,834 3.05 632,309,370
D 6,864 0.30 823,251 1.63 338,004,403
D 9,152 0.40 1,097,668 1.30 270,254,384
D 11,440 0.50 1,372,085 1.21 250,117,413
D 13,728 0.60 1,646,502 1.14 237,127,588
D 16,016 0.70 1,920,919 1.10 228,244,948
D 18,304 0.80 2,195,336 1.06 218,890,557
D 20,592 0.90 2,469,753 1.03 212,779,568
D 22,880 1.00 2,744,170 1.00 207,235,460
D 22,960 1.00 2,753,765 1.00 207,108,042
D 25,168 1.10 3,018,587 0.98 202,396,652
D 27,456 1.20 3,293,004 0.96 199,698,041
D 29,744 1.30 3,567,421 0.95 197,709,052
D 32,032 1.40 3,841,838 0.95 196,355,722
D 34,320 1.49 4,116,255 0.94 195,575,146
D 36,608 1.59 4,390,672 0.94 194,943,512
D 38,896 1.69 4,665,089 0.94 193,993,006
D 41,184 1.79 4,939,506 0.93 192,495,920
D 43,472 1.89 5,213,923 0.90 187,343,666
D 45,760 1.99 5,488,340 0.82 169,010,698

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 1,072 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,415 2,858.00 1.74 0.06 100.00 0.00 419,430
E 4,096 1,392 3,001.37 1.56 0.05 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 6,361 6,361 0 0
64K 128K 40 40 0 0
128K 256K 2 2 0 0
512K 1024K 394 394 0 0
1M 2M 68 68 0 0
2M 4M 1 1 0 0
4M 8M 3 3 0 0
8M 16M 2 2 0 0
16M 32M 1 1 0 0
64M 128M 3 3 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,019,369.63 952,754.52 94.00 12,086
1,024 0.25 16,019,369.63 855,797.29 95.00 10,990
2,048 0.50 16,019,369.63 250,497.78 98.00 2,965
3,072 0.75 16,019,369.63 29,596.26 100.00 0
4,096 1.00 16,019,369.63 29,596.26 100.00 0
4,915 1.20 16,019,369.63 24,239.42 100.00 0
5,734 1.40 16,019,369.63 24,239.42 100.00 0
6,554 1.60 16,019,369.63 24,239.42 100.00 0
7,373 1.80 16,019,369.63 24,239.42 100.00 0
8,192 2.00 16,019,369.63 24,239.42 100.00 0
12,288 3.00 16,019,369.63 24,239.42 100.00 0
16,384 4.00 16,019,369.63 24,239.42 100.00 0
24,576 6.00 16,019,369.63 24,239.42 100.00 0
32,768 8.00 16,019,369.63 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,475 60,585 6,810,989 0.99 81,400 4.84 860,078,438
4,064 0.29 2,864 78,633 6,856,422 1.00 35,967 2.14 860,215,174
5,456 0.40 4,253 115,122 6,870,003 1.00 22,386 1.33 860,264,460
6,848 0.50 5,641 129,961 6,873,411 1.00 18,978 1.13 860,271,278
8,240 0.60 7,022 196,110 6,875,576 1.00 16,813 1.00 860,273,774
9,632 0.70 8,398 242,031 6,875,586 1.00 16,803 1.00 860,274,329
11,024 0.80 8,931 258,273 6,875,586 1.00 16,803 1.00 860,274,340
12,416 0.90 9,032 265,921 6,875,586 1.00 16,803 1.00 860,274,342
13,808 1.00 9,032 265,921 6,875,586 1.00 16,803 1.00 860,274,342
15,200 1.10 9,032 265,921 6,875,586 1.00 16,803 1.00 860,274,342
16,592 1.20 9,032 265,921 6,875,586 1.00 16,803 1.00 860,274,342
17,984 1.30 9,032 265,921 6,875,586 1.00 16,803 1.00 860,274,342
19,376 1.40 9,032 265,921 6,875,586 1.00 16,803 1.00 860,274,342
20,768 1.50 9,032 265,921 6,875,586 1.00 16,803 1.00 860,274,342
22,160 1.60 9,032 265,921 6,875,586 1.00 16,803 1.00 860,274,342
23,552 1.71 9,032 265,921 6,875,586 1.00 16,803 1.00 860,274,342
24,944 1.81 9,032 265,921 6,875,586 1.00 16,803 1.00 860,274,342
26,336 1.91 9,032 265,921 6,875,586 1.00 16,803 1.00 860,274,342
27,728 2.01 9,032 265,921 6,875,586 1.00 16,803 1.00 860,274,342

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,048,541 662,351,426
18,432 0.50 899,730 262,003,874
27,648 0.75 886,801 229,281,866
36,864 1.00 879,501 207,101,315
46,080 1.25 878,182 203,207,810
55,296 1.50 869,563 177,030,204
64,512 1.75 869,563 176,900,599
73,728 2.00 869,563 177,056,675

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

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 2 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
PS-PX Process Reservation 4,154 4,102 52 1,199 1 0.49
JQ-Job Queue 387 382 4 362 0 0.70
CF-Controlfile Transaction 4,262 4,262 0 96 0 0.70
WF-AWR Flush 21 21 0 11 0 1.09
TA-Instance Undo 6 6 0 6 0 0.67
TQ-Queue table enqueue (TM contention) 4 4 0 4 0 1.00
FB-Format Block 3 3 0 2 0 1.00
TM-DML 2,175 2,175 0 2 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.22 301 1,213 3 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 12:28 140 151 855 2 5,760 0/0 0/0/0/0/0/0
05-Dec 12:18 2 23 580 2 5,760 0/0 0/0/0/0/0/0
05-Dec 12:08 82 127 1,213 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,215 0.00   0 0  
AWR Alerted Metric Element list 12,833 0.00   0 0  
Consistent RBA 660 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,779 0.00   0 0  
JS broadcast add buf latch 411 0.00   0 0  
JS broadcast drop buf latch 411 0.00   0 0  
JS broadcast load blnc latch 360 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 36,720 0.00   0 0  
KCL gc element parent latch 503,568 0.00 0.00 0 63 0.00
KJC message pool free list 2,651 0.00   0 530 0.00
KJCT flow control latch 206,292 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 601 0.00   0 0  
KSXR large replies 122 0.00   0 0  
KTF sga latch 6 0.00   0 425 0.00
KWQMN job cache list latch 696 0.00   0 0  
KWQP Prop Status 206 0.00   0 0  
MQL Tracking Latch 0     0 36 0.00
Memory Management Latch 0     0 601 0.00
Memory Queue 4,284 0.00   0 0  
Memory Queue Subscriber 579 0.00   0 0  
OS process 2,121 0.00   0 0  
OS process allocation 2,005 0.00   0 0  
OS process: request allocation 1,396 0.00   0 0  
PL/SQL warning settings 1,911 0.00   0 0  
SQL memory manager latch 1 0.00   0 600 0.00
SQL memory manager workarea list latch 43,139 0.00   0 0  
Shared B-Tree 10,829 0.00   0 0  
active checkpoint queue latch 3,117 0.00   0 0  
active service list 13,993 0.00   0 615 0.00
archive control 30 0.00   0 0  
archive process latch 672 0.00   0 0  
begin backup scn array 9 0.00   0 0  
bq:time manger info latch 528 0.00   0 0  
bufq statistics 1,670 0.00   0 0  
business card 1,164 0.00   0 0  
cache buffer handles 192 0.00   0 0  
cache buffers chains 7,036,244 0.00 0.03 0 213,109 0.00
cache buffers lru chain 91,294 0.01 0.00 0 378,240 0.00
channel handle pool latch 1,398 0.00   0 0  
channel operations parent latch 170,694 0.01 0.00 0 0  
checkpoint queue latch 199,716 0.00   0 5,690 0.00
client/application info 6,637 0.00   0 0  
commit callback allocation 12 0.00   0 0  
compile environment latch 1,680 0.00   0 0  
datapump attach fixed tables latch 1,690 0.00   0 0  
datapump job fixed tables latch 1,690 0.00   0 0  
dml lock allocation 4,378 0.02 0.00 0 0  
dummy allocation 3,370 0.00   0 0  
enqueue hash chains 808,079 0.00 0.00 0 175 0.00
enqueues 452,227 0.02 0.00 0 0  
error message lists 588 0.00   0 0  
event group latch 693 0.00   0 0  
file cache latch 1,882 0.00   0 0  
gcs opaque info freelist 7,566 0.01 0.00 0 0  
gcs partitioned table hash 674,435 0.00   0 0  
gcs remastering latch 9,231 0.00   0 0  
gcs resource freelist 29,769 0.00   0 6,874 0.00
gcs resource hash 321,410 0.01 0.00 0 90 0.00
gcs resource scan list 180 0.00   0 0  
gcs shadows freelist 33,833 0.00   0 9,752 0.00
ges caches resource lists 64,804 0.07 0.00 0 23,589 0.00
ges deadlock list 4 0.00   0 0  
ges domain table 345,733 0.00   0 0  
ges enqueue table freelist 346,924 0.00   0 0  
ges group table 521,135 0.00   0 0  
ges process hash list 3,812 0.00   0 0  
ges process parent latch 699,768 0.00   0 0  
ges process table freelist 1,396 0.00   0 0  
ges resource hash list 525,976 0.19 0.00 0 4,706 0.00
ges resource scan list 22 0.00   0 0  
ges resource table freelist 6,750 0.00   0 0  
ges timeout list 1,584 0.00   0 1,290 0.00
global KZLD latch for mem in SGA 643 0.00   0 0  
global tx hash mapping 17,210 0.00   0 0  
hash table column usage latch 66 0.00   0 820 0.00
hash table modification latch 58 0.00   0 0  
job workq parent latch 0     0 752 0.00
job_queue_processes parameter latch 390 0.00   0 0  
kks stats 2 0.00   0 0  
kokc descriptor allocation latch 242 0.00   0 0  
krbmrosl 15 0.00   0 0  
ksuosstats global area 122 0.00   0 0  
ktm global data 9 0.00   0 0  
kwqbsn:qsga 4,845 0.00   0 0  
lgwr LWN SCN 1,757 0.00   0 0  
library cache 84,229 0.47 0.00 0 4 0.00
library cache lock 60,641 0.60 0.00 0 0  
library cache lock allocation 1,726 0.00   0 0  
library cache pin 33,846 0.50 0.00 0 0  
library cache pin allocation 83 0.00   0 0  
list of block allocation 462 0.00   0 0  
loader state object freelist 18 0.00   0 0  
logminer context allocation 1 0.00   0 0  
message pool operations parent latch 4,011 0.00   0 0  
messages 72,978 0.00 0.00 0 0  
mostly latch-free SCN 1,778 0.39 0.00 0 0  
multiblock read objects 7,286 0.00   0 0  
name-service memory objects 4,950 0.00   0 0  
name-service namespace bucket 23,187 0.00   0 0  
name-service pending queue 712 0.00   0 0  
name-service request queue 20,541 0.00   0 0  
ncodef allocation latch 29 0.00   0 0  
object queue header heap 100,008 0.00   0 86,394 0.00
object queue header operation 430,969 0.01 0.00 0 0  
object stats modification 1 0.00   0 0  
parallel query alloc buffer 10,938 0.00   0 0  
parallel query stats 1,779 0.00   0 0  
parallel txn reco latch 7,866 0.00   0 0  
parameter list 194 0.00   0 0  
parameter table allocation management 1,693 0.00   0 0  
post/wait queue 1,757 0.06 0.00 0 1,386 0.00
process allocation 20,788 0.03 0.86 0 693 0.00
process group creation 1,396 0.00   0 0  
process queue 6,477 0.00   0 0  
process queue reference 108,505 0.01 0.00 0 9,511 0.07
qmn task queue latch 2,202 31.15 0.08 0 0  
query server freelists 5,292 0.00   0 0  
queue sender's info. latch 7,944 1.45 0.00 0 0  
queued dump request 8,992 0.00   0 0  
redo allocation 4,158 0.00   0 22,032 0.01
redo copy 0     0 22,032 0.06
redo writing 6,353 0.00   0 0  
resmgr group change latch 1,982 0.00   0 0  
resmgr:active threads 3,367 0.00   0 0  
resmgr:actses change group 1,320 0.00   0 0  
resmgr:free threads list 3,366 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 612,366 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,011 0.04 0.00 0 0  
session allocation 32,406 0.02 0.00 0 0  
session idle bit 43,417 0.00   0 0  
session state list latch 3,378 0.00   0 0  
session switching 29 0.00   0 0  
session timer 614 0.00   0 0  
shared pool 59,460 0.00 0.00 0 0  
shared pool simulator 382,543 0.00   0 0  
simulator hash latch 198,162 0.00 0.00 0 0  
simulator lru latch 0     0 198,088 0.09
slave class 2 0.00   0 0  
slave class create 8 12.50 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 354 0.00   0 0  
transaction allocation 6,035,985 0.00   0 0  
transaction branch allocation 636 0.00   0 0  
undo global data 20,188 0.01 0.00 0 0  
user lock 2,625 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
qmn task queue latch 2,202 686 58 628 0 0 0
cache buffers chains 7,036,244 120 3 115 0 0 0
process allocation 20,788 7 6 1 0 0 0
slave class create 8 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
cache buffers chains kcbgtcr: kslbegin excl 0 4 3
cache buffers chains kcbgtcr: fast path 0 1 0
cache buffers chains kcbzgb: scan from tail. nowait 0 1 0
event range base latch No latch 0 58 58
object queue header operation kcbo_switch_mq_bg 0 3 0
process allocation ksucrp 0 4 0
process allocation ksufap: active procs 0 2 4
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
SIE EAS_DATA SIE_BOE_HEADERS   TABLE 774,304 20.17
SYS SYSTEM FILE$   TABLE 389,296 10.14
SIE EAS_DATA SIE_BOE_HEADERS_PK   INDEX 312,032 8.13
SYS SYSTEM I_FILE#_BLOCK#   INDEX 309,072 8.05
SYS SYSTEM SEG$   TABLE 234,064 6.10

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
APPS EAS_IND WFR_BILL_STATUS_N4   INDEX 112 0.08
WFR EAS_DATA_NEW WFR_BILL_STATUS_N5   INDEX 25 0.02
EVS DAT_EVSAS FK_VOUCHER_JOURNAL_NUM   INDEX 22 0.02
SYS SYSAUX WRH$_SQL_PLAN_PK   INDEX 19 0.01
SIE EAS_DATA SIE_INVOICES_N8   INDEX 11 0.01

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

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

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SYS SYSTEM JOB$   TABLE 2 100.00

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,250 16.82
WFR EAS_DATA_NEW WFR_BILL_STATUS   TABLE 2,428 12.57
SIE EAS_DATA SIE_BOE_HEADERS   TABLE 1,599 8.28
FBP EAS_DATA_NEW FBP_CONTRACT_HEADERS   TABLE 1,165 6.03
FBP EAS_DATA FBP_DEPTS_TL   TABLE 888 4.60

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 519 28.77
SIE EAS_DATA SIE_BOE_HEADERS   TABLE 333 18.46
WFR EAS_IND WFR_BILL_HISTORIES_N1   INDEX 193 10.70
SIE EAS_DATA_NEW SIE_INVOICES   TABLE 182 10.09
APPS EAS_IND WFR_BILL_STATUS_N4   INDEX 61 3.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 0.00 0   2 1
dc_database_links 1,399 0.00 0   0 26
dc_files 3,250 0.00 0   0 254
dc_global_oids 1,894 0.00 0   0 309
dc_histogram_data 282 0.00 0   0 36,041
dc_histogram_defs 101 0.00 0   0 11,421
dc_object_ids 2,724 0.00 0   0 6,654
dc_objects 907 0.00 0   0 8,707
dc_profiles 660 0.00 0   0 2
dc_rollback_segments 13,971 0.00 0   0 1,313
dc_segments 131 0.00 0   0 2,699
dc_sequences 365 1.10 0   365 13
dc_tablespaces 158,909 0.00 0   0 43
dc_usernames 2,711 0.00 0   0 148
dc_users 21,730 0.00 0   0 196
outstanding_alerts 162 98.77 0   2 57

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 4 0 0
dc_sequences 730 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 61 0.00 1,429 0.00 0 0
INDEX 1 0.00 11 0.00 0 0
SQL AREA 6,288 0.03 393,655 0.03 61 0
TABLE/PROCEDURE 982 0.00 7,711 0.00 0 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,879 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,573.16   18.73 119.38 1,098 1,098 84 84
  PL/SQL 1,143.93 124.07 13.95 125.58 1,137 1,137 82 82
  SQL 79.66 69.31 1.35 6.98 38 402 59 43
  Freeable 61.31 0.00 1.39 1.96 10   44 44
E Other 1,571.06   21.23 126.96 1,096 1,096 74 74
  PL/SQL 1,144.73 123.93 15.90 134.14 1,138 1,138 72 72
  Freeable 206.13 0.00 5.57 24.72 151   37 37
  SQL 79.50 69.17 1.59 7.58 38 402 50 34

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 638.93 638.94 0.00
shared PCursor 396.45 396.45 0.00
shared db_block_hash_buckets 180.00 180.00 0.00
shared free memory 3,885.71 3,885.57 -0.00
shared gcs resources 478.41 478.41 0.00
shared gcs shadows 286.48 286.48 0.00
shared library cache 273.67 273.67 0.00
shared sql area 7,050.22 7,050.45 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 514,339 0 0
QMON Coordinator 284,642 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 1 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,936,871 2,861,412 3096098 3096098
gcs_shadows 2,146,952 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) 37,440 20.78 19.83
acks for commit broadcast(logical) 38,360 21.29 20.32
broadcast msgs on commit(actual) 656 0.36 0.35
broadcast msgs on commit(logical) 658 0.37 0.35
broadcast msgs on commit(wasted) 36 0.02 0.02
broadcast on commit wait time(ms) 120 0.07 0.06
broadcast on commit waits 542 0.30 0.29
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 71 0.04 0.04
flow control messages sent 2 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 2,884 1.60 1.53
gcs ast xid 0 0.00 0.00
gcs blocked converts 794 0.44 0.42
gcs blocked cr converts 6,289 3.49 3.33
gcs compatible basts 22 0.01 0.01
gcs compatible cr basts (global) 10 0.01 0.01
gcs compatible cr basts (local) 7,084 3.93 3.75
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 34 0.02 0.02
gcs dbwr write request msgs 95 0.05 0.05
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 555 0.31 0.29
gcs immediate (null) converts 1,447 0.80 0.77
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 5,692 3.16 3.01
gcs indirect ast 7,601 4.22 4.03
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 35 0.02 0.02
gcs msgs process time(ms) 3,428 1.90 1.82
gcs msgs received 165,249 91.73 87.53
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 15 0.01 0.01
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 3,751 2.08 1.99
gcs side channel msgs logical 24,945 13.85 13.21
gcs stale cr 68,877 38.23 36.48
gcs undo cr 0 0.00 0.00
gcs write notification msgs 1 0.00 0.00
gcs writes refused 0 0.00 0.00
ges msgs process time(ms) 101 0.06 0.05
ges msgs received 5,005 2.78 2.65
global posts dropped 0 0.00 0.00
global posts queue time 25 0.01 0.01
global posts queued 6 0.00 0.00
global posts requested 6 0.00 0.00
global posts sent 6 0.00 0.00
implicit batch messages received 8,189 4.55 4.34
implicit batch messages sent 904 0.50 0.48
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,595 0.89 0.84
messages queue sent actual 11,790 6.54 6.24
messages queue sent logical 12,716 7.06 6.74
messages received actual 151,713 84.21 80.36
messages received logical 170,254 94.51 90.18
messages sent directly 88,300 49.01 46.77
messages sent indirectly 8,323 4.62 4.41
messages sent not implicit batched 10,886 6.04 5.77
messages sent pbatched 45,653 25.34 24.18
msgs causing lmd to send msgs 2,065 1.15 1.09
msgs causing lms(s) to send msgs 653 0.36 0.35
msgs received queue time (ms) 2,026 1.12 1.07
msgs received queued 170,255 94.51 90.18
msgs sent queue time (ms) 369 0.20 0.20
msgs sent queue time on ksxp (ms) 28,405 15.77 15.05
msgs sent queued 12,716 7.06 6.74
msgs sent queued on ksxp 137,704 76.44 72.94
process batch messages received 70,527 39.15 37.36
process batch messages sent 40,599 22.54 21.50


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 2,378
CURRENT Block Requests 20
Data Block Requests 2,378
Undo Block Requests 0
TX Block Requests 10
Current Results 1,564
Private results 2
Zero Results 832
Disk Read Results 0
Fail Results 0
Fairness Down Converts 85
Fairness Clears 0
Free GC Elements 0
Flushes 1,262
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 0
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 10,252 100.00 0.00 0.00 0.00 0.00
Flushes 13 69.23 30.77 0.00 0.00 0.00
Writes 42 66.67 30.95 0.00 2.38 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 11,549 88.20 0.10 11.70 1,700 98.12 1.18 0.71
2 undo header 4,757 99.73 0.02 0.25 80 97.50 2.50 0.00
2 Others 3,016 99.64 0.00 0.36 23 100.00 0.00 0.00


Back to Top

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