Using the report name awrrpt_1_112312_112313.html AWR Report

WORKLOAD REPOSITORY report for

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

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:11231205-Dec-16 12:30:3670 8.2
End Snap:11231305-Dec-16 13:00:0563 8.2
Elapsed:  29.48 (mins)  
DB Time:  4.70 (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,757.81 3,645.74
Logical reads: 1,936.82 1,879.06
Block changes: 28.06 27.22
Physical reads: 105.44 102.30
Physical writes: 3.71 3.60
User calls: 10.79 10.47
Parses: 83.05 80.57
Hard parses: 0.14 0.14
Sorts: 3.73 3.62
Logons: 0.93 0.90
Executes: 111.60 108.27
Transactions: 1.03 

% Blocks changed per Read: 1.45Recursive Call %: 99.44
Rollback per transaction %: 98.85Rows per Sort: 193.14

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 94.57In-memory Sort %: 100.00
Library Hit %: 99.81Soft Parse %: 99.83
Execute to Parse %: 25.58Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 210.66% Non-Parse CPU: 97.91

Shared Pool Statistics

BeginEnd
Memory Usage %: 71.83 71.90
% SQL with executions>1: 99.87 99.78
% Memory for SQL w/exec>1: 99.49 99.30

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  199  70.4 
reliable message 1,855 34 19 12.2Other
db file sequential read 123,793 32 0 11.4User I/O
gc cr disk read 59,558 23 0 8.0Cluster
PX Deq: reap credit 17,528 8 0 2.8Other

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 13.34 12.94
Global Cache blocks served: 37.50 36.38
GCS/GES messages received: 153.77 149.19
GCS/GES messages sent: 113.93 110.53
DBWR Fusion writes: 0.71 0.68
Estd Interconnect traffic (KB) 459.00 

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

Buffer access - local cache %: 93.88
Buffer access - remote cache %: 0.69
Buffer access - disk %: 5.43

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.0
Avg global cache cr block receive time (ms): 0.5
Avg global cache current block receive time (ms): 1.0
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.1
Global cache log flushes for cr blocks served %: 3.3
Avg global cache cr block flush time (ms): 3.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): 20.0

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
Avg message sent queue time on ksxp (ms): 0.2
Avg message received queue time (ms): 0.5
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 79.80
% of indirect sent messages: 18.61
% of flow controlled messages: 1.58


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 283.61 100.50
DB CPU 198.76 70.44
PL/SQL execution elapsed time 6.84 2.42
parse time elapsed 3.60 1.28
connection management call elapsed time 2.30 0.81
hard parse elapsed time 1.95 0.69
sequence load elapsed time 0.16 0.06
PL/SQL compilation elapsed time 0.05 0.02
failed parse elapsed time 0.04 0.01
repeated bind elapsed time 0.01 0.00
hard parse (sharing criteria) elapsed time 0.01 0.00
hard parse (bind mismatch) elapsed time 0.00 0.00
DB time 282.18  
background elapsed time 118.97  
background cpu time 63.07  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Other 47,936 82.76 52 1 26.30
User I/O 129,231 0.00 43 0 70.89
Cluster 92,240 0.00 36 0 50.60
System I/O 25,225 0.00 6 0 13.84
Concurrency 459 0.00 0 1 0.25
Application 487 0.00 0 0 0.27
Network 19,680 0.00 0 0 10.80
Commit 8 0.00 0 1 0.00
Configuration 6 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
reliable message 1,855 1.29 34 19 1.02
db file sequential read 123,793 0.00 32 0 67.91
gc cr disk read 59,558 0.00 23 0 32.67
PX Deq: reap credit 17,528 97.85 8 0 9.61
gc cr multi block request 17,527 0.00 6 0 9.61
db file parallel read 2,576 0.00 6 2 1.41
PX Deq Credit: send blkd 2,825 40.07 6 2 1.55
gc cr block 2-way 11,013 0.00 5 0 6.04
control file sequential read 19,096 0.00 5 0 10.48
db file scattered read 2,312 0.00 5 2 1.27
gcs log flush sync 684 15.94 2 3 0.38
db file parallel write 4,854 0.00 1 0 2.66
gc current block 2-way 2,058 0.00 1 0 1.13
enq: PS - contention 1,174 0.00 0 0 0.64
control file parallel write 679 0.00 0 1 0.37
wait for scn ack 484 0.00 0 1 0.27
gc cr grant 2-way 1,306 0.00 0 0 0.72
enq: WF - contention 12 0.00 0 25 0.01
gc current grant busy 659 0.00 0 0 0.36
latch free 55 0.00 0 4 0.03
enq: JQ - contention 354 0.00 0 1 0.19
CGS wait for IPC msg 18,009 99.84 0 0 9.88
log file parallel write 559 0.00 0 0 0.31
gc current block busy 2 0.00 0 80 0.00
SQL*Net break/reset to client 484 0.00 0 0 0.27
os thread startup 2 0.00 0 70 0.00
row cache lock 311 0.00 0 0 0.17
PX Deq: Signal ACK 1,124 49.82 0 0 0.62
enq: TM - contention 3 0.00 0 23 0.00
DFS lock handle 187 0.00 0 0 0.10
log file sequential read 19 0.00 0 2 0.01
enq: CF - contention 92 0.00 0 0 0.05
SQL*Net more data to client 1,605 0.00 0 0 0.88
ksxr poll remote instances 3,311 79.10 0 0 1.82
SQL*Net more data from client 558 0.00 0 0 0.31
library cache lock 107 0.00 0 0 0.06
IPC send completion sync 93 100.00 0 0 0.05
direct path read 438 0.00 0 0 0.24
gc cr block busy 23 0.00 0 1 0.01
gc cr block congested 12 0.00 0 2 0.01
gc current grant 2-way 59 0.00 0 0 0.03
rdbms ipc reply 99 0.00 0 0 0.05
SQL*Net message to client 15,903 0.00 0 0 8.72
log file sync 8 0.00 0 1 0.00
library cache pin 39 0.00 0 0 0.02
gc current block congested 2 0.00 0 2 0.00
gc current multi block request 20 0.00 0 0 0.01
direct path write 112 0.00 0 0 0.06
enq: HW - contention 6 0.00 0 0 0.00
enq: TA - contention 6 0.00 0 0 0.00
gc cr grant congested 1 0.00 0 1 0.00
Log archive I/O 16 0.00 0 0 0.01
enq: SR - contention 4 0.00 0 0 0.00
enq: JS - job run lock - synchronize 2 0.00 0 1 0.00
SQL*Net message to dblink 1,614 0.00 0 0 0.89
log file single write 2 0.00 0 0 0.00
enq: FB - contention 2 0.00 0 0 0.00
enq: AF - task serialization 1 0.00 0 1 0.00
LGWR wait for redo copy 23 0.00 0 0 0.01
enq: WL - contention 1 0.00 0 0 0.00
enq: TQ - TM contention 2 0.00 0 0 0.00
enq: DR - contention 1 0.00 0 0 0.00
ges2 LMON to wake up LMD - mrcvr 2 0.00 0 0 0.00
PX qref latch 4 75.00 0 0 0.00
KJC: Wait for msg sends to complete 2 0.00 0 0 0.00
SQL*Net message from client 15,909 0.00 15,869 998 8.73
gcs remote message 589,219 99.51 13,797 23 323.21
jobq slave wait 4,557 45.25 10,313 2263 2.50
Streams AQ: qmn slave idle wait 962 0.00 5,178 5382 0.53
wait for unread message on broadcast channel 3,803 82.54 3,323 874 2.09
PX Idle Wait 1,678 63.83 3,314 1975 0.92
Streams AQ: waiting for time management or cleanup tasks 11 45.45 1,758 159805 0.01
Streams AQ: waiting for messages in the queue 183 96.72 1,729 9446 0.10
virtual circuit status 59 100.00 1,729 29297 0.03
DIAG idle wait 8,833 0.00 1,727 196 4.85
ges remote message 28,184 94.64 1,726 61 15.46
Streams AQ: qmn coordinator idle wait 742 41.11 1,726 2326 0.41
SQL*Net message from dblink 1,615 0.00 1,378 853 0.89
PX Deq: Join ACK 1,711 34.02 108 63 0.94
PX Deq: Execution Msg 3,039 2.83 69 23 1.67
PX Deq: Parse Reply 1,623 32.96 0 0 0.89
PX Deq: Execute Reply 1,200 22.75 0 0 0.66
PX Deq: Msg Fragment 148 41.22 0 0 0.08
Streams AQ: RAC qmn coordinator idle wait 744 98.52 0 0 0.41
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,120 89.84 35 2 12.68
db file sequential read 44,355 0.00 11 0 24.33
gc cr disk read 20,670 0.00 8 0 11.34
control file sequential read 4,924 0.00 2 0 2.70
db file parallel write 4,854 0.00 1 0 2.66
gc cr block 2-way 1,162 0.00 1 0 0.64
control file parallel write 675 0.00 0 1 0.37
log file parallel write 559 0.00 0 0 0.31
gc cr grant 2-way 750 0.00 0 0 0.41
os thread startup 2 0.00 0 70 0.00
enq: TM - contention 2 0.00 0 34 0.00
gc current block 2-way 114 0.00 0 1 0.06
row cache lock 112 0.00 0 0 0.06
log file sequential read 19 0.00 0 2 0.01
gc current grant busy 14 0.00 0 0 0.01
gc current grant 2-way 13 0.00 0 0 0.01
enq: HW - contention 6 0.00 0 0 0.00
gc cr block congested 1 0.00 0 2 0.00
library cache lock 7 0.00 0 0 0.00
direct path write 110 0.00 0 0 0.06
Log archive I/O 16 0.00 0 0 0.01
gc current multi block request 7 0.00 0 0 0.00
direct path read 412 0.00 0 0 0.23
log file single write 2 0.00 0 0 0.00
rdbms ipc message 33,225 82.79 27,616 831 18.23
gcs remote message 589,232 99.51 13,797 23 323.22
Streams AQ: qmn slave idle wait 962 0.00 5,178 5382 0.53
Streams AQ: waiting for time management or cleanup tasks 11 45.45 1,758 159805 0.01
smon timer 8 0.00 1,728 215986 0.00
DIAG idle wait 8,833 0.00 1,727 196 4.85
ges remote message 28,184 94.64 1,726 61 15.46
Streams AQ: qmn coordinator idle wait 742 41.11 1,726 2326 0.41
pmon timer 603 100.00 1,726 2862 0.33
Streams AQ: RAC qmn coordinator idle wait 744 98.52 0 0 0.41
PX Deq: Join ACK 4 50.00 0 1 0.00
PX Deq: Parse Reply 4 50.00 0 1 0.00
PX Deq: Execute Reply 4 50.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 3,754
AVG_IDLE_TIME 173,049
AVG_IOWAIT_TIME 0
AVG_SYS_TIME 1,411
AVG_USER_TIME 2,279
BUSY_TIME 121,987
IDLE_TIME 5,539,317
IOWAIT_TIME 0
SYS_TIME 47,200
USER_TIME 74,787
LOAD 1
OS_CPU_WAIT_TIME 39,500
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 13,205,504
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 274.50 191.60 140,632 2,708,490
appdbc 5.90 5.30 1 293,414
hrms 1.80 1.80 0 120,160
SYS$BACKGROUND 0.00 0.00 44,812 293,204
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 84046 3154 338 8 0 0 16172 2
appdbc 1 0 0 0 0 0 1435 3
hrms 0 0 0 0 0 0 243 0
SYS$BACKGROUND 45174 1094 122 20 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
77 77 1 77.02 27.29 23gzmzdtbb8w5 sqlplus@erpdb-m9k-d00 (TNS V1-V3) select sql_text, sql_id from ...
67 37 6 11.14 23.70 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
27 27 45,529 0.00 9.63 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
26 11 1 25.79 9.14 0n1r5m24q9dvv   DECLARE job BINARY_INTEGER := ...
24 11 0   8.50 69atchvk0ukpy ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN SYS.DBMS_DATAPUMP.A...
24 11 566 0.04 8.46 afcz9s4uazbpk ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN :1 := sys.kupc$que_int.t...
23 8 1 22.51 7.98 4ct5wkrsqmsd3   INSERT INTO GDPLANET.TMP_NOCON...
18 5 566 0.03 6.20 gn74qsy7sv4z4 ude@erpdb-m9k-d00 (TNS V1-V3) SELECT COUNT(*) FROM gv$datapu...
10 8 1 9.73 3.45 3u9c9mju3f3rp   DECLARE job BINARY_INTEGER := ...
6 5 1 5.85 2.07 9rx424vd77t3k oracle@m8000-1 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */...
6 4 1 5.79 2.05 48xp06cu8zahx   INSERT INTO GDPLANET.TMP_HASCO...
4 4 142,287 0.00 1.53 2ym6hhaq30r73   select type#, blocks, extents,...
4 3 1 3.75 1.33 fbspbft2c3gds   INSERT INTO GDPLANET.TMP_NOCON...
4 3 1 3.75 1.33 572fbaj0fdw2b sqlplus@erpdb-m9k-d00 (TNS V1-V3) select output from table(dbms_...
3 3 1 3.20 1.13 3y7a5dzq7ttvu   INSERT INTO GDPLANET.TMP_HASCO...
3 3 0   1.10 5nsbr19rcb6hr   DECLARE job BINARY_INTEGER := ...

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
77 77 1 77.02 27.29 23gzmzdtbb8w5 sqlplus@erpdb-m9k-d00 (TNS V1-V3) select sql_text, sql_id from ...
37 67 6 6.11 23.70 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
27 27 45,529 0.00 9.63 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
11 26 1 11.33 9.14 0n1r5m24q9dvv   DECLARE job BINARY_INTEGER := ...
11 24 566 0.02 8.46 afcz9s4uazbpk ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN :1 := sys.kupc$que_int.t...
11 24 0   8.50 69atchvk0ukpy ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN SYS.DBMS_DATAPUMP.A...
8 23 1 8.25 7.98 4ct5wkrsqmsd3   INSERT INTO GDPLANET.TMP_NOCON...
8 10 1 7.59 3.45 3u9c9mju3f3rp   DECLARE job BINARY_INTEGER := ...
5 6 1 5.31 2.07 9rx424vd77t3k oracle@m8000-1 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */...
5 18 566 0.01 6.20 gn74qsy7sv4z4 ude@erpdb-m9k-d00 (TNS V1-V3) SELECT COUNT(*) FROM gv$datapu...
4 4 142,287 0.00 1.53 2ym6hhaq30r73   select type#, blocks, extents,...
4 6 1 4.10 2.05 48xp06cu8zahx   INSERT INTO GDPLANET.TMP_HASCO...
3 4 1 3.40 1.33 fbspbft2c3gds   INSERT INTO GDPLANET.TMP_NOCON...
3 3 1 3.07 1.13 3y7a5dzq7ttvu   INSERT INTO GDPLANET.TMP_HASCO...
3 3 0   1.10 5nsbr19rcb6hr   DECLARE job BINARY_INTEGER := ...
3 4 1 2.77 1.33 572fbaj0fdw2b sqlplus@erpdb-m9k-d00 (TNS V1-V3) select output from table(dbms_...

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,411,296 6 235,216.00 41.20 36.66 66.87 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
502,419 1 502,419.00 14.67 11.33 25.79 0n1r5m24q9dvv   DECLARE job BINARY_INTEGER := ...
497,425 1 497,425.00 14.52 7.59 9.73 3u9c9mju3f3rp   DECLARE job BINARY_INTEGER := ...
426,861 142,287 3.00 12.46 4.30 4.30 2ym6hhaq30r73   select type#, blocks, extents,...
293,397 1 293,397.00 8.57 5.31 5.85 9rx424vd77t3k oracle@m8000-1 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */...
284,528 1 284,528.00 8.31 8.25 22.51 4ct5wkrsqmsd3   INSERT INTO GDPLANET.TMP_NOCON...
277,105 1 277,105.00 8.09 4.10 5.79 48xp06cu8zahx   INSERT INTO GDPLANET.TMP_HASCO...
216,913 1 216,913.00 6.33 3.07 3.20 3y7a5dzq7ttvu   INSERT INTO GDPLANET.TMP_HASCO...
213,105 1 213,105.00 6.22 3.40 3.75 fbspbft2c3gds   INSERT INTO GDPLANET.TMP_NOCON...
198,952 0   5.81 2.82 3.10 5nsbr19rcb6hr   DECLARE job BINARY_INTEGER := ...
197,277 45,529 4.33 5.76 27.02 27.16 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
134,113 1 134,113.00 3.92 2.77 3.75 572fbaj0fdw2b sqlplus@erpdb-m9k-d00 (TNS V1-V3) select output from table(dbms_...
112,348 1 112,348.00 3.28 1.14 1.14 bd502nbh9abbs plsqldev.exe select s.synonym_name object_n...
96,476 6 16,079.33 2.82 1.32 2.42 bnafqqprpz3u1 sqlplus@erpdb-m9k-d00 (TNS V1-V3) select tablespace_name, use_pr...

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
78,107 6 13,017.83 41.88 36.66 66.87 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
61,215 1 61,215.00 32.82 11.33 25.79 0n1r5m24q9dvv   DECLARE job BINARY_INTEGER := ...
61,185 1 61,185.00 32.81 8.25 22.51 4ct5wkrsqmsd3   INSERT INTO GDPLANET.TMP_NOCON...
42,616 45,529 0.94 22.85 27.02 27.16 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
1,745 1 1,745.00 0.94 0.20 0.98 b7jn4mf49n569   select o.name, u.name from ob...
586 1 586.00 0.31 7.59 9.73 3u9c9mju3f3rp   DECLARE job BINARY_INTEGER := ...
574 1 574.00 0.31 2.77 3.75 572fbaj0fdw2b sqlplus@erpdb-m9k-d00 (TNS V1-V3) select output from table(dbms_...
336 1 336.00 0.18 4.10 5.79 48xp06cu8zahx   INSERT INTO GDPLANET.TMP_HASCO...
121 536 0.23 0.06 0.06 0.06 grwydz59pu6mc   select text from view$ where r...
82 0   0.04 2.82 3.10 5nsbr19rcb6hr   DECLARE job BINARY_INTEGER := ...

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
142,287 142,287 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
45,529 0 0.00 0.00 0.00 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
1,313 39 0.03 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
635 1,270 2.00 0.00 0.00 05uqdabhzncdc   select role# from defrole$ d, ...
631 631 1.00 0.00 0.00 3f751tsaf2j02 JDBC Thin Client SELECT VALUE FROM NLS_INSTANCE...
566 0 0.00 0.02 0.04 afcz9s4uazbpk ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN :1 := sys.kupc$que_int.t...
566 566 1.00 0.01 0.03 gn74qsy7sv4z4 ude@erpdb-m9k-d00 (TNS V1-V3) SELECT COUNT(*) FROM gv$datapu...
536 536 1.00 0.00 0.00 grwydz59pu6mc   select text from view$ where r...
500 4,285 8.57 0.00 0.00 bsa0wjtftg3uw   select file# from file$ where ...
378 371 0.98 0.00 0.00 3c1kubcdjnppq   update sys.col_usage$ set eq...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
142,287 142,287 96.87 2ym6hhaq30r73   select type#, blocks, extents,...
1,313 1,313 0.89 0h6b2sajwb74n   select privilege#, level from ...
635 635 0.43 05uqdabhzncdc   select role# from defrole$ d, ...
631 631 0.43 3f751tsaf2j02 JDBC Thin Client SELECT VALUE FROM NLS_INSTANCE...
566 566 0.39 gn74qsy7sv4z4 ude@erpdb-m9k-d00 (TNS V1-V3) SELECT COUNT(*) FROM gv$datapu...
536 536 0.36 grwydz59pu6mc   select text from view$ where r...
500 500 0.34 bsa0wjtftg3uw   select file# from file$ where ...
356 3 0.24 47a50dvdgnxc2   update sys.job$ set failures=0...
356 356 0.24 a1mbfp580hw3k   select u1.user#, u2.user#, u...
356 2 0.24 aq8yqxyyb40nn   update sys.job$ set this_date=...

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,582,054 1 0.02 bd502nbh9abbs plsqldev.exe select s.synonym_name object_n...
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...
1,610,967 1 0.01 8f1sjvfxuup9w PL/SQL Developer select t.*, o.*, m.comments ...
1,550,054 1 0.01 bd502nbh9abbs plsqldev.exe select s.synonym_name object_n...
1,545,581 1 0.01 42b67jvy5ux34 PL/SQL Developer select col.*, com.Comments fr...
1,295,798 1 0.01 91k4w10zgrg4m plsqldev.exe select object_name, object_ty...
1,262,390 1 0.01 91k4w10zgrg4m plsqldev.exe select object_name, object_ty...
1,109,167 1 0.01 8f1sjvfxuup9w PL/SQL Developer select t.*, o.*, m.comments ...

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
17.12 25.60 66.87 36.66 6 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
8.22 30.25 27.16 27.02 45,529 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
6.72 26.05 25.79 11.33 1 0n1r5m24q9dvv   DECLARE job BINARY_INTEGER := ...
6.47 28.74 22.51 8.25 1 4ct5wkrsqmsd3   INSERT INTO GDPLANET.TMP_NOCON...
1.48 15.17 9.73 7.59 1 3u9c9mju3f3rp   DECLARE job BINARY_INTEGER := ...
1.07 18.41 5.79 4.10 1 48xp06cu8zahx   INSERT INTO GDPLANET.TMP_HASCO...
0.72 12.36 5.85 5.31 1 9rx424vd77t3k oracle@m8000-1 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */...
0.66 45.29 1.45 0.77 1 3v9c56u115sq3   DECLARE job BINARY_INTEGER := ...
0.39 10.46 3.75 3.40 1 fbspbft2c3gds   INSERT INTO GDPLANET.TMP_NOCON...
0.25 7.69 3.20 3.07 1 3y7a5dzq7ttvu   INSERT INTO GDPLANET.TMP_HASCO...
0.18 18.56 0.98 0.20 1 b7jn4mf49n569   select o.name, u.name from ob...
0.14 3.87 3.75 2.77 1 572fbaj0fdw2b sqlplus@erpdb-m9k-d00 (TNS V1-V3) select output from table(dbms_...
0.04 7.71 0.54 0.52 2 5fjy338yh5p6p PL/SQL Developer select * from FBP_VENDORS w ...
0.03 1.07 3.10 2.82 0 5nsbr19rcb6hr   DECLARE job BINARY_INTEGER := ...
0.03 1.11 2.42 1.32 6 bnafqqprpz3u1 sqlplus@erpdb-m9k-d00 (TNS V1-V3) select tablespace_name, use_pr...
0.01 26.32 0.05 0.05 378 3c1kubcdjnppq   update sys.col_usage$ set eq...
0.01 40.03 0.02 0.02 3 c7sn076yz7030   select smontabv.cnt, smontab....
0.01 10.43 0.05 0.01 1 g6wf9na8zs5hb   insert into wrh$_sysmetric_sum...
0.01 0.47 1.14 1.14 1 84qubbrsr0kfn   insert into wrh$_latch (snap...
0.01 0.77 0.66 0.66 635 05uqdabhzncdc   select role# from defrole$ d, ...

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
0n1r5m24q9dvvDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN begin export_eas_data_100m; end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
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
14566d856s6hsSELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1
23gzmzdtbb8w5select sql_text, sql_id from v$sqlarea where (address, hash_value) in (select sql_address, sql_hash_value from v$session where username like 'SYS')
298ppdduqr7wmSELECT status FROM sys.wri$_adv_tasks WHERE id = :1
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
3c1kubcdjnppqupdate sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3f751tsaf2j02SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'
3u9c9mju3f3rpDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN begin export_eas_data_all; end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
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;
3y7a5dzq7ttvuINSERT INTO GDPLANET.TMP_HASCONTRACT_100M SELECT SYSDATE, '', FT.ORG_ID, 'baozhang', 0, BH.BOE_NUM, NVL(BL.DOCUMENT_LINE_AMOUNT, BL.EXPENSE_AMOUNT), BH.BOE_NUM || BL.PROJECT_CODE, 'Freeze', FPA.PROJECT_ID, BH.BOE_DATE, BL.PROJECT_CODE, '', BH.APPLY_AMOUNT, 0, (SELECT MAX(WBH.CREATION_DATE) FROM WFR_BILL_HISTORIES WBH WHERE WBH.BOE_HEADER_ID = BH.BOE_HEADER_ID) FROM SIE_BOE_HEADERS BH, SIE_BOE_LINES BL, WFR_BILL_STATUS S, FBP_PROJECTS_ALL FPA, FBP_TASKS FT WHERE BH.BOE_HEADER_ID = BL.BOE_HEADER_ID AND BH.BOE_HEADER_ID = S.BOE_HEADER_ID AND BL.PROJECT_CODE = FPA.PROJECT_NUMBER AND BL.TASK_ID = FT.TASK_ID AND S.CURRENT_STATUS >= '200' AND S.CURRENT_STATUS < '300' AND BH.CONTRACT_HEADER_ID IS NOT NULL AND BH.BOE_TYPE_ID IN (10021, 10010) AND BH.APPLY_AMOUNT > 1000000
42b67jvy5ux34select col.*, com.Comments from sys.all_tab_columns col, sys.all_col_comments com where col.owner = 'FBP' and col.table_name = 'FBP_VENDORS' and com.Owner (+) = 'FBP' and com.Table_Name (+) = 'FBP_VENDORS' and com.Column_Name (+) = col.Column_Name order by col.column_id
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
48xp06cu8zahxINSERT INTO GDPLANET.TMP_HASCONTRACT_ALL SELECT SYSDATE, '', FT.ORG_ID, 'baozhang', 0, BH.BOE_NUM, NVL(BL.DOCUMENT_LINE_AMOUNT, BL.EXPENSE_AMOUNT), BH.BOE_NUM || BL.PROJECT_CODE, 'Freeze', FPA.PROJECT_ID, BH.BOE_DATE, BL.PROJECT_CODE, '', BH.APPLY_AMOUNT, 0, (SELECT MAX(WBH.CREATION_DATE) FROM WFR_BILL_HISTORIES WBH WHERE WBH.BOE_HEADER_ID = BH.BOE_HEADER_ID) FROM SIE_BOE_HEADERS BH, SIE_BOE_LINES BL, WFR_BILL_STATUS S, FBP_PROJECTS_ALL FPA, FBP_TASKS FT WHERE BH.BOE_HEADER_ID = BL.BOE_HEADER_ID AND BH.BOE_HEADER_ID = S.BOE_HEADER_ID AND BL.PROJECT_CODE = FPA.PROJECT_NUMBER AND BL.TASK_ID = FT.TASK_ID AND BH.CONTRACT_HEADER_ID IS NOT NULL AND S.CURRENT_STATUS >= '200' AND S.CURRENT_STATUS < '300' AND BH.BOE_TYPE_ID IN (10021, 10010)
4ct5wkrsqmsd3INSERT INTO GDPLANET.TMP_NOCONTRACT_100M SELECT SYSDATE, '', FT.ORG_ID, 'baozhang', 0, BH.BOE_NUM, NVL(BL.DOCUMENT_LINE_AMOUNT, BL.EXPENSE_AMOUNT), BH.BOE_NUM || BL.PROJECT_CODE, 'Freeze', FPA.PROJECT_ID, BH.BOE_DATE, BL.PROJECT_CODE, '', BH.APPLY_AMOUNT, 0, (SELECT MAX(WBH.CREATION_DATE) FROM WFR_BILL_HISTORIES WBH WHERE WBH.BOE_HEADER_ID = BH.BOE_HEADER_ID) FROM SIE_BOE_HEADERS BH, SIE_BOE_LINES BL, WFR_BILL_STATUS S, FBP_PROJECTS_ALL FPA, FBP_TASKS FT WHERE BH.BOE_HEADER_ID = BL.BOE_HEADER_ID AND BH.BOE_HEADER_ID = S.BOE_HEADER_ID AND BL.PROJECT_CODE = FPA.PROJECT_NUMBER AND BL.TASK_ID = FT.TASK_ID AND S.CURRENT_STATUS >= '200' AND S.CURRENT_STATUS < '300' AND BH.BOE_TYPE_ID IN (10021, 10010) AND BH.CONTRACT_HEADER_ID IS NULL AND BH.APPLY_AMOUNT > 1000000
572fbaj0fdw2bselect output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))
5fjy338yh5p6pselect * from FBP_VENDORS w where w.vendor_name like '%ÕÅÖæ%'
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;
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
8f1sjvfxuup9wselect t.*, o.*, m.comments from sys.all_tables t, sys.all_tab_comments m, sys.all_objects o where t.owner = :object_owner and t.table_name = :object_name and m.owner (+) = :object_owner and m.table_name (+) = :object_name and o.owner (+) = :object_owner and o.object_name (+) = :object_name and :object_type is not null and :sub_object is null
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
91k4w10zgrg4mselect object_name, object_type from sys.all_objects o where o.owner = :schema and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
9rx424vd77t3kSELECT /*+ OPAQUE_TRANSFORM */ "BOE_NUM", "DEBIT_NOTE_NUM", "PAYMENT_STATUS", "PAYMENT_DATE", "LAST_UPDATE_DATE" FROM "APPS"."EPSP_INF_BOE_PAYMENTS_V" "EPSP_INF_BOE_PAYMENTS_V"
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
b7jn4mf49n569select o.name, u.name from obj$ o, type$ t, user$ u where o.oid$ = t.tvoid and u.user#=o.owner# and bitand(t.properties, 8388608) = 8388608 and (sysdate-o.ctime) > 0.0007
bd502nbh9abbsselect s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
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
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
fbspbft2c3gdsINSERT INTO GDPLANET.TMP_NOCONTRACT_ALL SELECT SYSDATE, '', FT.ORG_ID, 'baozhang', 0, BH.BOE_NUM, NVL(BL.DOCUMENT_LINE_AMOUNT, BL.EXPENSE_AMOUNT), BH.BOE_NUM || BL.PROJECT_CODE, 'Freeze', FPA.PROJECT_ID, BH.BOE_DATE, BL.PROJECT_CODE, '', BH.APPLY_AMOUNT, 0, (SELECT MAX(WBH.CREATION_DATE) FROM WFR_BILL_HISTORIES WBH WHERE WBH.BOE_HEADER_ID = BH.BOE_HEADER_ID) FROM SIE_BOE_HEADERS BH, SIE_BOE_LINES BL, WFR_BILL_STATUS S, FBP_PROJECTS_ALL FPA, FBP_TASKS FT WHERE BH.BOE_HEADER_ID = BL.BOE_HEADER_ID AND BH.BOE_HEADER_ID = S.BOE_HEADER_ID AND BL.PROJECT_CODE = FPA.PROJECT_NUMBER AND BL.TASK_ID = FT.TASK_ID AND S.CURRENT_STATUS >= '200' AND S.CURRENT_STATUS < '300' AND BH.BOE_TYPE_ID IN (10021, 10010) AND BH.CONTRACT_HEADER_ID IS NULL
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 19,567 11.06 10.73
CPU used when call started 14,131 7.99 7.75
CR blocks created 621 0.35 0.34
Cached Commit SCN referenced 75,964 42.95 41.67
Commit SCN cached 7 0.00 0.00
DB time 1,279,143 723.24 701.67
DBWR checkpoint buffers written 5,203 2.94 2.85
DBWR checkpoints 1 0.00 0.00
DBWR fusion writes 1,248 0.71 0.68
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 26 0.01 0.01
DBWR undo block writes 576 0.33 0.32
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 570 0.32 0.31
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 3,408 1.93 1.87
PX local messages sent 3,408 1.93 1.87
PX remote messages recv'd 1,277 0.72 0.70
PX remote messages sent 2,360 1.33 1.29
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 570 0.32 0.31
RowCR - row contention 0 0.00 0.00
RowCR attempts 4 0.00 0.00
RowCR hits 11 0.01 0.01
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 14,068 7.95 7.72
SQL*Net roundtrips to/from dblink 1,478 0.84 0.81
active txn count during cleanout 417 0.24 0.23
application wait time 23 0.01 0.01
background checkpoints completed 1 0.00 0.00
background checkpoints started 1 0.00 0.00
background timeouts 8,031 4.54 4.41
branch node splits 1 0.00 0.00
buffer is not pinned count 1,096,243 619.83 601.34
buffer is pinned count 1,039,961 588.00 570.47
bytes received via SQL*Net from client 1,941,860 1,097.95 1,065.20
bytes received via SQL*Net from dblink 324,363 183.40 177.93
bytes sent via SQL*Net to client 4,290,343 2,425.80 2,353.45
bytes sent via SQL*Net to dblink 152,091 85.99 83.43
calls to get snapshot scn: kcmgss 493,356 278.95 270.63
calls to kcmgas 144,053 81.45 79.02
calls to kcmgcs 308 0.17 0.17
change write time 13 0.01 0.01
cleanout - number of ktugct calls 898 0.51 0.49
cleanouts and rollbacks - consistent read gets 200 0.11 0.11
cleanouts only - consistent read gets 463 0.26 0.25
cluster key scan block gets 508,808 287.68 279.10
cluster key scans 327,527 185.19 179.66
cluster wait time 3,578 2.02 1.96
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 0 0.00 0.00
commit batch/immediate requested 0 0.00 0.00
commit cleanout failures: block lost 21 0.01 0.01
commit cleanout failures: callback failure 5 0.00 0.00
commit cleanout failures: cannot pin 0 0.00 0.00
commit cleanouts 3,513 1.99 1.93
commit cleanouts successfully completed 3,487 1.97 1.91
commit immediate performed 0 0.00 0.00
commit immediate requested 0 0.00 0.00
commit txn count during cleanout 1,145 0.65 0.63
concurrency wait time 27 0.02 0.01
consistent changes 27,568 15.59 15.12
consistent gets 3,295,422 1,863.26 1,807.69
consistent gets - examination 677,488 383.06 371.63
consistent gets direct 26 0.01 0.01
consistent gets from cache 3,295,396 1,863.25 1,807.68
current blocks converted for CR 0 0.00 0.00
cursor authentications 7 0.00 0.00
data blocks consistent reads - undo records applied 716 0.40 0.39
db block changes 49,623 28.06 27.22
db block gets 130,111 73.57 71.37
db block gets direct 20 0.01 0.01
db block gets from cache 130,091 73.55 71.36
deferred (CURRENT) block cleanout applications 1,159 0.66 0.64
dirty buffers inspected 1 0.00 0.00
enqueue conversions 7,049 3.99 3.87
enqueue releases 195,836 110.73 107.43
enqueue requests 195,905 110.77 107.46
enqueue timeouts 76 0.04 0.04
enqueue waits 1,659 0.94 0.91
exchange deadlocks 0 0.00 0.00
execute count 197,378 111.60 108.27
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 87,489 49.47 47.99
free buffer requested 217,121 122.76 119.10
gc CPU used by this session 4,293 2.43 2.35
gc blocks lost 0 0.00 0.00
gc cr block build time 26 0.01 0.01
gc cr block flush time 205 0.12 0.11
gc cr block receive time 558 0.32 0.31
gc cr block send time 142 0.08 0.08
gc cr blocks received 11,480 6.49 6.30
gc cr blocks served 18,887 10.68 10.36
gc current block flush time 2 0.00 0.00
gc current block pin time 42 0.02 0.02
gc current block receive time 1,216 0.69 0.67
gc current block send time 327 0.18 0.18
gc current blocks received 12,117 6.85 6.65
gc current blocks served 47,432 26.82 26.02
gc local grants 63,126 35.69 34.63
gc remote grants 123,831 70.02 67.93
gcs messages sent 194,741 110.11 106.82
ges messages sent 6,753 3.82 3.70
global enqueue get time 244 0.14 0.13
global enqueue gets async 354 0.20 0.19
global enqueue gets sync 158,557 89.65 86.98
global enqueue releases 155,982 88.19 85.56
heap block compress 218 0.12 0.12
hot buffers moved to head of LRU 277 0.16 0.15
immediate (CR) block cleanout applications 663 0.37 0.36
immediate (CURRENT) block cleanout applications 160 0.09 0.09
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 2,270 1.28 1.25
index fast full scans (full) 1 0.00 0.00
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 711,660 402.38 390.38
index scans kdiixs1 45,990 26.00 25.23
leaf node 90-10 splits 6 0.00 0.00
leaf node splits 37 0.02 0.02
lob reads 4,157 2.35 2.28
lob writes 6,886 3.89 3.78
lob writes unaligned 6,886 3.89 3.78
logons cumulative 1,648 0.93 0.90
messages received 7,241 4.09 3.97
messages sent 7,209 4.08 3.95
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 2,280,524 1,289.43 1,250.97
opened cursors cumulative 147,770 83.55 81.06
parse count (failures) 61 0.03 0.03
parse count (hard) 253 0.14 0.14
parse count (total) 146,882 83.05 80.57
parse time cpu 415 0.23 0.23
parse time elapsed 197 0.11 0.11
physical read IO requests 157,214 88.89 86.24
physical read bytes 1,527,742,464 863,799.93 838,037.56
physical read total IO requests 176,579 99.84 96.86
physical read total bytes 1,857,969,664 1,050,513.48 1,019,182.48
physical read total multi block requests 2,327 1.32 1.28
physical reads 186,492 105.44 102.30
physical reads cache 186,054 105.20 102.06
physical reads cache prefetch 56,590 32.00 31.04
physical reads direct 438 0.25 0.24
physical reads direct (lob) 26 0.01 0.01
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 5,097 2.88 2.80
physical write bytes 53,714,944 30,370.93 29,465.14
physical write total IO requests 7,708 4.36 4.23
physical write total bytes 109,344,256 61,824.27 59,980.39
physical write total multi block requests 893 0.50 0.49
physical writes 6,557 3.71 3.60
physical writes direct 130 0.07 0.07
physical writes direct (lob) 0 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 6,427 3.63 3.53
physical writes non checkpoint 4,810 2.72 2.64
pinned buffers inspected 4 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 3 0.00 0.00
queries parallelized 569 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,384,209 1,913.46 1,856.40
recursive cpu usage 5,875 3.32 3.22
redo blocks written 13,566 7.67 7.44
redo buffer allocation retries 0 0.00 0.00
redo entries 17,680 10.00 9.70
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 376 0.21 0.21
redo size 6,646,180 3,757.81 3,645.74
redo subscn max counts 155 0.09 0.09
redo synch time 1 0.00 0.00
redo synch writes 10 0.01 0.01
redo wastage 165,368 93.50 90.71
redo write time 25 0.01 0.01
redo writer latching time 0 0.00 0.00
redo writes 554 0.31 0.30
rollback changes - undo records applied 0 0.00 0.00
rollbacks only - consistent read gets 61 0.03 0.03
rows fetched via callback 206,282 116.63 113.16
session connect time 0 0.00 0.00
session cursor cache hits 140,759 79.59 77.21
session logical reads 3,425,522 1,936.82 1,879.06
session pga memory 77,317,986,440 43,716,315.14 42,412,499.42
session pga memory max 78,188,746,216 44,208,650.89 42,890,151.52
session uga memory 17,229,560,752 9,741,755.34 9,451,212.70
session uga memory max 690,572,240 390,456.03 378,810.88
shared hash latch upgrades - no wait 2,779 1.57 1.52
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 6,603 3.73 3.62
sorts (rows) 1,275,301 721.07 699.56
sql area evicted 0 0.00 0.00
sql area purged 61 0.03 0.03
summed dirty queue length 1 0.00 0.00
switch current to new buffer 119 0.07 0.07
table fetch by rowid 435,304 246.12 238.78
table fetch continued row 902 0.51 0.49
table scan blocks gotten 1,545,014 873.57 847.51
table scan rows gotten 48,157,093 27,228.47 26,416.40
table scans (direct read) 0 0.00 0.00
table scans (long tables) 1 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 63,787 36.07 34.99
total number of times SMON posted 8 0.00 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 0 0.00 0.00
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
undo change vector size 2,786,716 1,575.64 1,528.64
user I/O wait time 4,336 2.45 2.38
user calls 19,084 10.79 10.47
user commits 21 0.01 0.01
user rollbacks 1,802 1.02 0.99
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 4,323 2.44 2.37
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,136,505 6,141,869
opened cursors current 571 519
workarea memory allocated 1,595 4,778
logons current 70 63

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 1 2.04

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 71,318 40 0.23 1.00 3,449 2 0 0.00
EAS_DATA_NEW 33,127 19 1.15 1.87 726 0 0 0.00
USERS 19,300 11 0.29 1.00 3 0 0 0.00
SYSAUX 10,218 6 0.30 1.02 331 0 0 0.00
SYSTEM 8,405 5 0.29 1.00 19 0 0 0.00
DAT_EPM 6,848 4 0.24 1.03 44 0 0 0.00
EPM_GD_DATA 2,224 1 0.22 1.00 1 0 0 0.00
DAT_PAMS 992 1 0.21 1.00 3 0 0 0.00
AUDIT_DATA 917 1 0.24 1.00 0 0 0 0.00
EAS_IND 350 0 0.77 1.00 369 0 0 0.00
DAT_EVSAS 536 0 0.28 1.00 18 0 0 0.00
EIP_DATA 348 0 0.20 1.00 1 0 0 0.00
IDX_PAMS 287 0 0.24 1.00 1 0 0 0.00
MOB_DATA 186 0 0.27 1.00 1 0 0 0.00
DAT_HRMS 90 0 0.00 1.00 20 0 0 0.00
UNDOTBS1 5 0 0.00 1.00 95 0 0 0.00
TDEIP_DATA 96 0 0.10 1.00 0 0 0 0.00
SIED 23 0 0.00 1.00 2 0 0 0.00
IDX_HRMS 19 0 0.00 1.00 5 0 0 0.00
LISAPP_DAT 16 0 0.00 1.00 0 0 0 0.00
UNDOTBS2 11 0 0.00 1.00 2 0 0 0.00
SALARY_DATA 6 0 0.00 1.00 3 0 0 0.00
LISAPP_IDX 6 0 0.00 1.00 0 0 0 0.00
TDEIP_IND 6 0 0.00 1.00 0 0 0 0.00
MOB_IDX 2 0 0.00 1.00 1 0 0 0.00
SALARY_IDX 2 0 0.00 1.00 1 0 0 0.00
EIP_IND 1 0 0.00 1.00 1 0 0 0.00
IDX_EVSAS 2 0 0.00 1.00 0 0 0 0.00
SIEX 1 0 0.00 1.00 1 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 917 1 0.24 1.00 0 0 0 0.00
DAT_EPM /dev/vx/rdsk/racdg/datafile304 127 0 0.79 1.98 27 0 0 0.00
DAT_EPM /dev/vx/rdsk/racdg/datafile52 3,399 2 0.20 1.00 2 0 0 0.00
DAT_EPM /dev/vx/rdsk/racdg/datafile53 3,322 2 0.26 1.02 15 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 17 0 0.00 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile333 21 0 0.00 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile36 254 0 0.35 1.00 2 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile37 55 0 0.36 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile373 10 0 1.00 1.00 9 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile374 19 0 0.00 1.00 5 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile38 13 0 0.00 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile388 15 0 0.67 1.00 2 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile72 29 0 0.34 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile81 84 0 0.12 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile82 12 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile101 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile102 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile107 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile112 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile118 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile12 1 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile13 2 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile138 1 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile14 2 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile15 2 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile16 2 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile17 2 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile359 2 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile360 2 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile361 2 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile362 2 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile363 2 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile364 2 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile365 2 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile366 2 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile367 2 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile368 2 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile369 2 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile370 12 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile371 2 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile372 2 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile54 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile67 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile68 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile70 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile73 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile74 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile78 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile79 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile80 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile83 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile84 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile92 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile93 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile94 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile95 2 0 0.00 1.00 0 0 0 0.00
DAT_PAMS /dev/vx/rdsk/racdg/datafile27 2 0 0.00 1.00 1 0 0 0.00
DAT_PAMS /dev/vx/rdsk/racdg/datafile28 2 0 0.00 1.00 1 0 0 0.00
DAT_PAMS /dev/vx/rdsk/racdg/datafile29 988 1 0.21 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile01 2,254 1 0.22 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile05 1,502 1 0.19 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile07 1,757 1 0.28 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile08 6,805 4 0.19 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile09 1,770 1 0.19 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile10 4,894 3 0.24 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile100 823 0 0.19 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile104 2,714 2 0.18 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile108 711 0 0.23 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile11 2,892 2 0.23 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile113 253 0 0.12 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile116 108 0 0.28 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile119 82 0 0.61 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile120 28 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile121 55 0 0.55 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile122 29 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile123 14 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 80 0 0.13 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile126 14 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile127 496 0 0.14 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile128 41 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile129 124 0 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile130 54 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile132 56 0 0.18 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile133 28 0 0.36 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile134 40 0 0.50 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile135 14 0 0.71 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile136 1 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile137 28 0 1.07 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile300 39 0 0.51 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile301 40 0 0.25 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile302 65 0 0.15 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile303 65 0 0.92 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile306 26 0 0.38 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile307 1,397 1 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile308 482 0 0.27 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile309 208 0 0.34 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile310 382 0 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile311 248 0 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile312 105 0 0.38 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile313 621 0 0.34 1.00 4 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile314 313 0 0.13 1.00 3 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile315 414 0 0.22 1.00 3 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile316 747 0 0.21 1.00 5 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile317 500 0 0.20 1.00 10 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile318 379 0 0.42 1.00 7 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile319 1,941 1 0.24 1.00 3 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile320 2,083 1 0.22 1.00 12 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile321 1,316 1 0.31 1.00 3 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile334 2,863 2 0.29 1.00 7 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile335 1,523 1 0.27 1.00 3 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile336 1,354 1 0.24 1.00 9 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile340 573 0 0.21 1.00 3 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile343 536 0 0.22 1.00 16 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile344 617 0 0.31 1.00 46 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile345 210 0 0.19 1.00 31 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile346 2,054 1 0.27 1.00 19 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile347 808 0 0.25 1.00 12 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile348 656 0 0.20 1.00 50 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile349 353 0 0.31 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile350 404 0 0.25 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile351 209 0 0.10 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile352 105 0 0.29 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile353 40 0 0.25 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile354 14 0 0.00 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile355 5,611 3 0.20 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile356 53 0 0.75 1.00 523 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile357 105 0 0.29 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile358 131 0 0.46 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile377 196 0 0.10 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile383 1,847 1 0.24 1.00 729 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile384 831 0 0.16 1.00 600 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile385 620 0 0.27 1.00 767 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile386 263 0 0.19 1.00 563 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile390 250 0 0.16 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile391 29 0 0.00 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile392 3 0 0.00 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile55 1,692 1 0.23 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile75 1,225 1 0.20 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile76 1,127 1 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile87 2,441 1 0.20 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile88 1,291 1 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile99 2,245 1 0.23 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile409 1,635 1 0.62 1.88 2 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile410 1,435 1 0.93 2.21 9 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile411 1,374 1 0.74 2.27 16 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile412 1,634 1 0.78 1.91 16 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile413 1,595 1 0.72 1.96 18 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile414 1,684 1 1.19 1.89 43 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile415 1,777 1 1.22 1.75 60 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile416 1,620 1 1.25 1.93 7 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile417 1,566 1 1.63 1.88 6 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile418 1,518 1 1.37 1.82 159 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile419 1,628 1 0.68 1.62 20 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile420 1,804 1 1.23 1.75 37 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile421 2,001 1 1.27 1.61 25 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile422 1,885 1 1.25 1.67 220 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile423 1,927 1 1.42 1.74 24 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile424 1,698 1 1.27 1.86 4 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile425 1,651 1 1.25 1.94 35 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile426 1,724 1 1.60 1.81 15 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile427 1,436 1 1.23 2.18 8 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile428 1,535 1 1.24 2.06 2 0 0 0.00
EAS_IND /dev/vx/rdsk/racdg/datafile02 162 0 0.62 1.00 82 0 0 0.00
EAS_IND /dev/vx/rdsk/racdg/datafile06 188 0 0.90 1.00 287 0 0 0.00
EIP_DATA /dev/vx/rdsk/racdg/datafile03 348 0 0.20 1.00 1 0 0 0.00
EIP_IND /dev/vx/rdsk/racdg/datafile04 1 0 0.00 1.00 1 0 0 0.00
EPM_GD_DATA /dev/vx/rdsk/racdg/datafile378 2,224 1 0.22 1.00 1 0 0 0.00
IDX_EVSAS /dev/vx/rdsk/racdg/datafile39 2 0 0.00 1.00 0 0 0 0.00
IDX_HRMS /dev/vx/rdsk/racdg/datafile110 2 0 0.00 1.00 0 0 0 0.00
IDX_HRMS /dev/vx/rdsk/racdg/datafile18 2 0 0.00 1.00 1 0 0 0.00
IDX_HRMS /dev/vx/rdsk/racdg/datafile19 2 0 0.00 1.00 1 0 0 0.00
IDX_HRMS /dev/vx/rdsk/racdg/datafile20 2 0 0.00 1.00 1 0 0 0.00
IDX_HRMS /dev/vx/rdsk/racdg/datafile375 2 0 0.00 1.00 1 0 0 0.00
IDX_HRMS /dev/vx/rdsk/racdg/datafile387 3 0 0.00 1.00 1 0 0 0.00
IDX_HRMS /dev/vx/rdsk/racdg/datafile77 2 0 0.00 1.00 0 0 0 0.00
IDX_HRMS /dev/vx/rdsk/racdg/datafile85 2 0 0.00 1.00 0 0 0 0.00
IDX_HRMS /dev/vx/rdsk/racdg/datafile86 2 0 0.00 1.00 0 0 0 0.00
IDX_PAMS /dev/vx/rdsk/racdg/datafile26 287 0 0.24 1.00 1 0 0 0.00
LISAPP_DAT /dev/vx/rdsk/racdg/datafile44 2 0 0.00 1.00 0 0 0 0.00
LISAPP_DAT /dev/vx/rdsk/racdg/datafile45 2 0 0.00 1.00 0 0 0 0.00
LISAPP_DAT /dev/vx/rdsk/racdg/datafile46 2 0 0.00 1.00 0 0 0 0.00
LISAPP_DAT /dev/vx/rdsk/racdg/datafile47 2 0 0.00 1.00 0 0 0 0.00
LISAPP_DAT /dev/vx/rdsk/racdg/datafile48 2 0 0.00 1.00 0 0 0 0.00
LISAPP_DAT /dev/vx/rdsk/racdg/datafile49 2 0 0.00 1.00 0 0 0 0.00
LISAPP_DAT /dev/vx/rdsk/racdg/datafile50 2 0 0.00 1.00 0 0 0 0.00
LISAPP_DAT /dev/vx/rdsk/racdg/datafile51 2 0 0.00 1.00 0 0 0 0.00
LISAPP_IDX /dev/vx/rdsk/racdg/datafile40 2 0 0.00 1.00 0 0 0 0.00
LISAPP_IDX /dev/vx/rdsk/racdg/datafile42 2 0 0.00 1.00 0 0 0 0.00
LISAPP_IDX /dev/vx/rdsk/racdg/datafile43 2 0 0.00 1.00 0 0 0 0.00
MOB_DATA /dev/vx/rdsk/racdg/datafile31 186 0 0.27 1.00 1 0 0 0.00
MOB_IDX /dev/vx/rdsk/racdg/datafile30 2 0 0.00 1.00 1 0 0 0.00
SALARY_DATA /dev/vx/rdsk/racdg/datafile33 2 0 0.00 1.00 1 0 0 0.00
SALARY_DATA /dev/vx/rdsk/racdg/datafile34 2 0 0.00 1.00 1 0 0 0.00
SALARY_DATA /dev/vx/rdsk/racdg/datafile35 2 0 0.00 1.00 1 0 0 0.00
SALARY_IDX /dev/vx/rdsk/racdg/datafile32 2 0 0.00 1.00 1 0 0 0.00
SIED /dev/vx/rdsk/racdg/datafile23 1 0 0.00 1.00 1 0 0 0.00
SIED /dev/vx/rdsk/racdg/datafile25 22 0 0.00 1.00 1 0 0 0.00
SIEX /dev/vx/rdsk/racdg/datafile24 1 0 0.00 1.00 1 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile105 28 0 0.00 1.00 3 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile111 63 0 0.00 1.00 2 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile131 6 0 0.00 1.00 0 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile22 80 0 2.13 1.30 77 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile331 0 0     2 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile56 27 0 2.96 1.00 41 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile71 12 0 2.50 1.00 13 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile89 14 0 2.86 1.00 35 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile90 112 0 0.09 1.00 5 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/sysaux01 9,876 6 0.28 1.01 153 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/appdbc_system03 53 0 0.19 1.00 0 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile328 330 0 0.27 1.00 0 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile341 114 0 0.61 1.00 1 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile97 47 0 0.21 1.00 0 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile98 3 0 3.33 1.00 0 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/system01 7,808 4 0.29 1.00 18 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/system02 50 0 0.40 1.00 0 0 0 0.00
TDEIP_DATA /dev/vx/rdsk/racdg/datafile57 2 0 0.00 1.00 0 0 0 0.00
TDEIP_DATA /dev/vx/rdsk/racdg/datafile58 90 0 0.11 1.00 0 0 0 0.00
TDEIP_DATA /dev/vx/rdsk/racdg/datafile59 2 0 0.00 1.00 0 0 0 0.00
TDEIP_DATA /dev/vx/rdsk/racdg/datafile60 2 0 0.00 1.00 0 0 0 0.00
TDEIP_IND /dev/vx/rdsk/racdg/datafile61 2 0 0.00 1.00 0 0 0 0.00
TDEIP_IND /dev/vx/rdsk/racdg/datafile62 2 0 0.00 1.00 0 0 0 0.00
TDEIP_IND /dev/vx/rdsk/racdg/datafile63 2 0 0.00 1.00 0 0 0 0.00
UNDOTBS1 /dev/vx/rdsk/racdg/datafile381 2 0 0.00 1.00 68 0 0 0.00
UNDOTBS1 /dev/vx/rdsk/racdg/undotbs01a 1 0 0.00 1.00 27 0 0 0.00
UNDOTBS1 /dev/vx/rdsk/racdg/undotbs01c 2 0 0.00 1.00 0 0 0 0.00
UNDOTBS2 /dev/vx/rdsk/racdg/datafile380 2 0 0.00 1.00 1 0 0 0.00
UNDOTBS2 /dev/vx/rdsk/racdg/datafile64 2 0 0.00 1.00 0 0 0 0.00
UNDOTBS2 /dev/vx/rdsk/racdg/datafile65 2 0 0.00 1.00 0 0 0 0.00
UNDOTBS2 /dev/vx/rdsk/racdg/datafile66 2 0 0.00 1.00 0 0 0 0.00
UNDOTBS2 /dev/vx/rdsk/racdg/undotbs02a 1 0 0.00 1.00 1 0 0 0.00
UNDOTBS2 /dev/vx/rdsk/racdg/undotbs02b 2 0 0.00 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile106 1,403 1 0.33 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile115 757 0 0.18 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile117 2,548 1 0.26 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile139 580 0 0.29 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile21 770 0 0.31 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile330 4,186 2 0.27 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile342 1,782 1 0.39 1.00 1 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile382 636 0 0.52 1.00 1 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile91 150 0 0.27 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile96 3,021 2 0.30 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/users01 3,467 2 0.24 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 2,753,762 95 3,424,557 185,968 6,427 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 1 5009 8977 16324 2147310 16324  
E 0 0 378 2066 21152 2147310 21152  

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,091,722
D 4,576 0.20 548,834 3.05 632,974,955
D 6,864 0.30 823,251 1.63 338,249,821
D 9,152 0.40 1,097,668 1.30 270,480,178
D 11,440 0.50 1,372,085 1.21 250,314,830
D 13,728 0.60 1,646,502 1.14 237,321,184
D 16,016 0.70 1,920,919 1.10 228,436,249
D 18,304 0.80 2,195,336 1.06 219,079,506
D 20,592 0.90 2,469,753 1.03 212,966,940
D 22,880 1.00 2,744,170 1.00 207,421,455
D 22,960 1.00 2,753,765 1.00 207,294,006
D 25,168 1.10 3,018,587 0.98 202,581,446
D 27,456 1.20 3,293,004 0.96 199,882,165
D 29,744 1.30 3,567,421 0.95 197,892,683
D 32,032 1.40 3,841,838 0.95 196,539,016
D 34,320 1.49 4,116,255 0.94 195,758,246
D 36,608 1.59 4,390,672 0.94 195,125,830
D 38,896 1.69 4,665,089 0.94 194,175,058
D 41,184 1.79 4,939,506 0.93 192,677,601
D 43,472 1.89 5,213,923 0.90 187,524,067
D 45,760 1.99 5,488,340 0.82 169,186,459

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 515 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,392 3,001.37 1.56 0.05 100.00 0.00 419,430
E 4,096 1,437 2,792.71 4.67 0.17 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,756 3,756 0 0
64K 128K 40 40 0 0
128K 256K 10 10 0 0
256K 512K 2 2 0 0
512K 1024K 434 434 0 0
1M 2M 62 62 0 0
2M 4M 10 10 0 0
4M 8M 9 9 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,824.34 952,754.52 94.00 12,086
1,024 0.25 16,019,824.34 855,797.29 95.00 10,990
2,048 0.50 16,019,824.34 250,497.78 98.00 2,965
3,072 0.75 16,019,824.34 29,596.26 100.00 0
4,096 1.00 16,019,824.34 29,596.26 100.00 0
4,915 1.20 16,019,824.34 24,239.42 100.00 0
5,734 1.40 16,019,824.34 24,239.42 100.00 0
6,554 1.60 16,019,824.34 24,239.42 100.00 0
7,373 1.80 16,019,824.34 24,239.42 100.00 0
8,192 2.00 16,019,824.34 24,239.42 100.00 0
12,288 3.00 16,019,824.34 24,239.42 100.00 0
16,384 4.00 16,019,824.34 24,239.42 100.00 0
24,576 6.00 16,019,824.34 24,239.42 100.00 0
32,768 8.00 16,019,824.34 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,484 60,912 6,811,842 0.99 81,404 4.84 860,414,311
4,064 0.29 2,873 78,960 6,857,275 1.00 35,971 2.14 860,551,047
5,456 0.40 4,262 115,445 6,870,856 1.00 22,390 1.33 860,600,337
6,848 0.50 5,650 130,282 6,874,264 1.00 18,982 1.13 860,607,157
8,240 0.60 7,031 196,419 6,876,429 1.00 16,817 1.00 860,609,665
9,632 0.70 8,407 242,333 6,876,439 1.00 16,807 1.00 860,610,227
11,024 0.80 8,940 258,554 6,876,439 1.00 16,807 1.00 860,610,259
12,416 0.90 9,041 266,178 6,876,439 1.00 16,807 1.00 860,610,285
13,808 1.00 9,041 266,178 6,876,439 1.00 16,807 1.00 860,610,285
15,200 1.10 9,041 266,178 6,876,439 1.00 16,807 1.00 860,610,285
16,592 1.20 9,041 266,178 6,876,439 1.00 16,807 1.00 860,610,285
17,984 1.30 9,041 266,178 6,876,439 1.00 16,807 1.00 860,610,285
19,376 1.40 9,041 266,178 6,876,439 1.00 16,807 1.00 860,610,285
20,768 1.50 9,041 266,178 6,876,439 1.00 16,807 1.00 860,610,285
22,160 1.60 9,041 266,178 6,876,439 1.00 16,807 1.00 860,610,285
23,552 1.71 9,041 266,178 6,876,439 1.00 16,807 1.00 860,610,285
24,944 1.81 9,041 266,178 6,876,439 1.00 16,807 1.00 860,610,285
26,336 1.91 9,041 266,178 6,876,439 1.00 16,807 1.00 860,610,285
27,728 2.01 9,041 266,178 6,876,439 1.00 16,807 1.00 860,610,285

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,965 663,032,161
18,432 0.50 900,018 262,198,894
27,648 0.75 887,085 229,488,809
36,864 1.00 879,783 207,288,239
46,080 1.25 878,463 203,391,220
55,296 1.50 869,841 177,210,716
64,512 1.75 869,841 177,210,716
73,728 2.00 869,841 177,210,716

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)
PS-PX Process Reservation 4,084 4,014 70 1,173 0 0.39
WF-AWR Flush 20 20 0 12 0 25.75
JQ-Job Queue 367 361 6 354 0 0.73
TM-DML 1,904 1,904 0 3 0 23.00
CF-Controlfile Transaction 4,227 4,227 0 92 0 0.62
HW-Segment High Water Mark 1,275 1,275 0 6 0 0.50
TA-Instance Undo 6 6 0 6 0 0.50
TQ-Queue table enqueue (TM contention) 2 2 0 2 0 1.00
SR-Synchronized Replication 1,592 1,592 0 4 0 0.25
FB-Format Block 3 3 0 2 0 0.50
JS-Job Scheduler (job run lock - synchronize) 2 2 0 2 0 0.50
AF-Advisor Framework (task serialization) 7 7 0 1 0 0.00
DR-Distributed Recovery 1 1 0 1 0 0.00
WL-Being Written Redo Log 1 1 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1 0.75 818 2,695 5 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:08 211 222 2,695 4 5,760 0/0 0/0/0/0/0/0
05-Dec 12:58 0 3 2,094 1 5,760 0/0 0/0/0/0/0/0
05-Dec 12:48 244 102 1,491 4 5,760 0/0 0/0/0/0/0/0
05-Dec 12:38 298 491 1,458 5 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,185 0.00   0 0  
AWR Alerted Metric Element list 12,407 0.00   0 0  
Consistent RBA 554 0.00   0 0  
FAL request queue 37 0.00   0 0  
FAL subheap alocation 37 0.00   0 0  
FIB s.o chain latch 6 0.00   0 0  
FOB s.o list latch 3,101 0.00   0 0  
JS broadcast add buf latch 405 0.00   0 0  
JS broadcast drop buf latch 405 0.00   0 0  
JS broadcast load blnc latch 353 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,286 0.00   0 0  
JS slv state obj latch 6 0.00   0 0  
KCL gc element parent latch 1,354,786 0.00 0.00 0 225 0.00
KJC message pool free list 6,742 0.06 0.00 0 2,662 0.00
KJCT flow control latch 213,184 0.00   0 0  
KMG MMAN ready and startup request latch 589 0.00   0 0  
KSXR large replies 120 0.00   0 0  
KTF sga latch 6 0.00   0 466 0.00
KWQMN job cache list latch 761 0.00   0 0  
KWQP Prop Status 201 0.00   0 0  
MQL Tracking Latch 0     0 35 0.00
Memory Management Latch 0     0 589 0.00
Memory Queue 4,179 0.00   0 0  
Memory Queue Subscriber 566 0.00   0 0  
OS process 2,106 0.00   0 0  
OS process allocation 1,986 0.00   0 0  
OS process: request allocation 1,389 0.00   0 0  
PL/SQL warning settings 1,894 0.00   0 0  
SGA IO buffer pool latch 2,312 0.04 0.00 0 2,312 0.00
SQL memory manager latch 1 0.00   0 589 0.00
SQL memory manager workarea list latch 42,476 0.00   0 0  
Shared B-Tree 10,602 0.00   0 0  
active checkpoint queue latch 8,082 0.01 0.00 0 0  
active service list 13,773 0.02 0.00 0 603 0.00
archive control 34 0.00   0 0  
archive process latch 665 0.00   0 0  
begin backup scn array 2 0.00   0 0  
bq:time manger info latch 520 0.00   0 0  
bufq statistics 1,630 0.00   0 0  
business card 1,140 0.00   0 0  
cache buffer handles 4,045 0.00   0 0  
cache buffers chains 6,875,638 0.00 0.00 0 968,388 0.00
cache buffers lru chain 109,824 0.00 0.00 0 482,974 0.01
cache table scan latch 0     0 2,312 0.00
channel handle pool latch 1,393 0.00   0 0  
channel operations parent latch 157,080 0.01 0.00 0 0  
checkpoint queue latch 260,389 0.00   0 1,966 0.00
client/application info 6,510 0.00   0 0  
commit callback allocation 8 0.00   0 0  
compile environment latch 1,648 0.00   0 0  
datapump attach fixed tables latch 1,655 0.00   0 0  
datapump job fixed tables latch 1,655 0.00   0 0  
dml lock allocation 3,838 0.00   0 0  
dummy allocation 3,303 0.00   0 0  
enqueue hash chains 689,402 0.00 0.00 0 166 0.00
enqueues 389,834 0.01 0.00 0 0  
error message lists 581 0.00   0 0  
event group latch 691 0.00   0 0  
file cache latch 1,598 0.00   0 0  
gcs opaque info freelist 41,906 0.05 0.00 0 0  
gcs partitioned table hash 4,296,542 0.00   0 0  
gcs remaster request queue 3 0.00   0 0  
gcs remastering latch 1,473,858 0.00   0 0  
gcs resource freelist 91,445 0.02 0.00 0 13,732 0.23
gcs resource hash 1,358,004 0.01 0.00 0 6 0.00
gcs resource scan list 12 0.00   0 0  
gcs shadows freelist 35,263 0.00   0 34,188 0.00
ges caches resource lists 85,775 0.06 0.00 0 24,168 0.02
ges deadlock list 216 0.00   0 1 0.00
ges domain table 310,053 0.00   0 0  
ges enqueue table freelist 313,250 0.00   0 0  
ges group table 467,238 0.00   0 0  
ges process hash list 10,521 0.00   0 0  
ges process parent latch 629,880 0.00   0 0  
ges process table freelist 1,389 0.00   0 0  
ges resource hash list 479,883 0.16 0.00 0 5,868 0.00
ges resource scan list 26 0.00   0 0  
ges resource table freelist 9,347 0.00   0 0  
ges synchronous data 32 0.00   0 773 0.39
ges timeout list 1,592 0.00   0 1,218 0.00
global KZLD latch for mem in SGA 636 0.00   0 0  
global tx hash mapping 4,081 0.00   0 0  
hash table column usage latch 110 0.00   0 27,172 0.00
hash table modification latch 30 0.00   0 0  
job workq parent latch 0     0 714 0.00
job_queue_processes parameter latch 383 0.00   0 0  
kks stats 240 0.00   0 0  
kokc descriptor allocation latch 244 0.00   0 0  
krbmrosl 15 0.00   0 0  
ksuosstats global area 120 0.00   0 0  
ktm global data 8 0.00   0 0  
kwqbsn:qsga 4,750 0.00   0 0  
lgwr LWN SCN 1,238 0.00   0 0  
library cache 111,983 0.19 0.00 0 3 0.00
library cache load lock 180 0.00   0 0  
library cache lock 62,357 0.31 0.00 0 0  
library cache lock allocation 1,668 0.00   0 0  
library cache pin 34,001 0.17 0.00 0 0  
library cache pin allocation 168 0.00   0 0  
list of block allocation 219 0.00   0 0  
loader state object freelist 126 0.00   0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 1 0.00   0 1 0.00
message pool operations parent latch 3,923 0.00   0 0  
messages 79,749 0.01 0.00 0 0  
mostly latch-free SCN 1,244 0.08 0.00 0 0  
multiblock read objects 16,354 0.01 0.00 0 0  
name-service memory objects 4,528 0.00   0 0  
name-service namespace bucket 22,286 0.00   0 0  
name-service pending queue 736 0.00   0 0  
name-service request queue 19,906 0.00   0 0  
ncodef allocation latch 29 0.00   0 0  
object queue header heap 118,689 0.00   0 85,288 0.00
object queue header operation 590,205 0.00 0.00 0 0  
object stats modification 4 0.00   0 0  
parallel query alloc buffer 10,726 0.00   0 0  
parallel query stats 1,743 0.00   0 0  
parallel txn reco latch 7,866 0.00   0 0  
parameter list 223 0.00   0 0  
parameter table allocation management 1,666 0.00   0 0  
post/wait queue 936 0.00   0 695 0.00
process allocation 20,117 0.07 0.93 0 691 0.00
process group creation 1,389 0.00   0 0  
process queue 6,350 0.00   0 0  
process queue reference 105,973 0.01 0.00 0 9,320 0.04
qmn task queue latch 2,274 31.40 0.06 0 0  
query server freelists 5,186 0.00   0 0  
queue sender's info. latch 7,752 1.10 0.00 0 0  
queued dump request 8,832 0.00   0 0  
redo allocation 3,039 0.00   0 17,550 0.01
redo copy 0     0 17,550 0.13
redo writing 10,982 0.00   0 0  
resmgr group change latch 1,944 0.00   0 0  
resmgr:active threads 3,300 0.00   0 0  
resmgr:actses change group 1,291 0.00   0 0  
resmgr:free threads list 3,299 0.03 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 656,260 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 2,245 0.00   0 0  
session allocation 45,760 0.03 0.00 0 0  
session idle bit 43,652 0.00   0 0  
session state list latch 3,326 0.06 0.00 0 0  
session switching 29 0.00   0 0  
session timer 603 0.00   0 0  
shared pool 80,318 0.00 0.00 0 0  
shared pool sim alloc 14 0.00   0 0  
shared pool simulator 338,540 0.00 0.00 0 0  
simulator hash latch 200,296 0.00   0 0  
simulator lru latch 0     0 191,324 0.01
slave class 2 0.00   0 0  
slave class create 8 12.50 1.00 0 0  
sort extent pool 87 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 8,820 0.00   0 0  
temp lob duration state obj allocation 2 0.00   0 0  
threshold alerts latch 247 0.00   0 0  
transaction allocation 5,532,970 0.00   0 0  
transaction branch allocation 626 0.00   0 0  
undo global data 62,414 0.00   0 0  
user lock 2,556 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
qmn task queue latch 2,274 714 40 674 0 0 0
process allocation 20,117 15 14 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 kcbzgb: scan from tail. nowait 0 1 0
cache buffers chains kclwrt 0 1 0
event range base latch No latch 0 40 40
process allocation ksucrp 0 9 0
process allocation ksufap: active procs 0 5 7
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 890,624 26.00
SYS SYSTEM FILE$   TABLE 337,328 9.85
SYS SYSTEM I_FILE#_BLOCK#   INDEX 269,776 7.88
SYS SYSTEM SEG$   TABLE 204,496 5.97
SYS SYSTEM USER$   TABLE 185,984 5.43

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
FBP EAS_DATA_NEW FBP_TASKS   TABLE 61,356 32.90
GDPLANET DAT_EPM TMP_HASCONTRACT_ALL   TABLE 232 0.12
APPS EAS_IND WFR_BILL_STATUS_N4   INDEX 90 0.05
SIE EAS_DATA_NEW SIE_BOE_LINES   TABLE 75 0.04
SIE EAS_DATA_NEW SIE_BOE_LINES_N1   INDEX 16 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

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
SIE EAS_DATA SIE_BOE_HEADERS   TABLE 1,053 9.17
WFR EAS_DATA_NEW WFR_BILL_STATUS   TABLE 969 8.44
WFR EAS_DATA_NEW WFR_BILL_HISTORIES   TABLE 771 6.72
APPS EAS_IND WFR_BILL_STATUS_N4   INDEX 645 5.62
WFR EAS_IND WFR_BILL_HISTORIES_N1   INDEX 579 5.04

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
FBP EAS_DATA_NEW FBP_TASKS   TABLE 9,958 82.18
WFR EAS_DATA_NEW WFR_BILL_STATUS   TABLE 687 5.67
SIE EAS_DATA SIE_BOE_HEADERS   TABLE 579 4.78
SIE EAS_DATA_NEW SIE_BOE_LINES   TABLE 191 1.58
SIE EAS_DATA SIE_BOE_PAYMENTS   TABLE 75 0.62

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 3.23 0   1 1
dc_database_links 1,333 0.00 0   0 26
dc_files 3,000 0.00 0   0 254
dc_global_oids 1,969 0.00 0   0 309
dc_histogram_data 23,252 1.09 0   0 36,294
dc_histogram_defs 13,115 0.59 0   0 11,498
dc_object_ids 7,101 0.03 0   0 6,656
dc_objects 2,787 1.83 0   2 8,757
dc_profiles 643 0.00 0   0 2
dc_rollback_segments 13,312 0.00 0   0 1,313
dc_segments 2,435 0.08 0   2 2,701
dc_sequences 65 1.54 0   65 11
dc_tablespaces 144,938 0.00 0   0 43
dc_usernames 2,720 0.00 0   0 148
dc_users 22,939 0.00 0   0 196
outstanding_alerts 109 98.17 0   2 4

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 3 1 0
dc_histogram_defs 77 0 0
dc_object_ids 2 0 0
dc_objects 55 1 0
dc_segments 4 0 0
dc_sequences 130 3 0
outstanding_alerts 215 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 70 0.00 1,630 0.00 0 0
INDEX 37 0.00 130 0.00 0 0
SQL AREA 6,455 2.80 341,468 0.16 61 0
TABLE/PROCEDURE 1,100 2.09 7,754 1.19 4 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 130 0 0 0 0
TABLE/PROCEDURE 3,240 43 2 39 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,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
E 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

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.94 639.52 0.09
shared PCursor 396.45 396.82 0.09
shared db_block_hash_buckets 180.00 180.00 0.00
shared free memory 3,885.57 3,876.23 -0.24
shared gcs resources 478.41 478.41 0.00
shared gcs shadows 286.48 286.48 0.00
shared library cache 273.67 273.93 0.10
shared sql area 7,050.45 7,058.03 0.11
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 504,038 0 0
QMON Coordinator 300,686 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,887,391 2,861,412 3096098 3096098
gcs_shadows 2,148,004 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) 29,782 16.84 16.34
acks for commit broadcast(logical) 30,647 17.33 16.81
broadcast msgs on commit(actual) 550 0.31 0.30
broadcast msgs on commit(logical) 554 0.31 0.30
broadcast msgs on commit(wasted) 27 0.02 0.01
broadcast on commit wait time(ms) 96 0.05 0.05
broadcast on commit waits 478 0.27 0.26
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 63 0.04 0.03
flow control messages sent 6 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 19,932 11.27 10.93
gcs ast xid 0 0.00 0.00
gcs blocked converts 671 0.38 0.37
gcs blocked cr converts 3,410 1.93 1.87
gcs compatible basts 7 0.00 0.00
gcs compatible cr basts (global) 191 0.11 0.10
gcs compatible cr basts (local) 23,190 13.11 12.72
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 1,058 0.60 0.58
gcs dbwr write request msgs 1,059 0.60 0.58
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 528 0.30 0.29
gcs immediate (null) converts 1,052 0.59 0.58
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 4,678 2.64 2.57
gcs indirect ast 5,079 2.87 2.79
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 64 0.04 0.04
gcs msgs process time(ms) 8,593 4.86 4.71
gcs msgs received 264,839 149.74 145.28
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 1 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 3,226 1.82 1.77
gcs side channel msgs logical 25,515 14.43 14.00
gcs stale cr 61,763 34.92 33.88
gcs undo cr 0 0.00 0.00
gcs write notification msgs 2 0.00 0.00
gcs writes refused 0 0.00 0.00
ges msgs process time(ms) 136 0.08 0.07
ges msgs received 7,130 4.03 3.91
global posts dropped 0 0.00 0.00
global posts queue time 21 0.01 0.01
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 6,879 3.89 3.77
implicit batch messages sent 1,581 0.89 0.87
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,532 0.87 0.84
messages queue sent actual 21,902 12.38 12.01
messages queue sent logical 23,549 13.31 12.92
messages received actual 170,518 96.41 93.54
messages received logical 271,971 153.77 149.19
messages sent directly 77,257 43.68 42.38
messages sent indirectly 18,019 10.19 9.88
messages sent not implicit batched 20,320 11.49 11.15
messages sent pbatched 109,424 61.87 60.02
msgs causing lmd to send msgs 3,112 1.76 1.71
msgs causing lms(s) to send msgs 4,863 2.75 2.67
msgs received queue time (ms) 147,946 83.65 81.16
msgs received queued 271,979 153.78 149.19
msgs sent queue time (ms) 661 0.37 0.36
msgs sent queue time on ksxp (ms) 26,779 15.14 14.69
msgs sent queued 23,549 13.31 12.92
msgs sent queued on ksxp 135,218 76.45 74.17
process batch messages received 75,322 42.59 41.32
process batch messages sent 44,753 25.30 24.55


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 18,858
CURRENT Block Requests 29
Data Block Requests 18,858
Undo Block Requests 0
TX Block Requests 7
Current Results 18,630
Private results 0
Zero Results 257
Disk Read Results 0
Fail Results 0
Fairness Down Converts 4,630
Fairness Clears 0
Free GC Elements 0
Flushes 617
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 1
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 47,429 100.00 0.00 0.00 0.00 0.00
Flushes 1 100.00 0.00 0.00 0.00 0.00
Writes 1,248 64.26 33.97 0.48 0.32 0.96


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 data block 5,497 99.16 0.38 0.45 11,987 91.92 0.01 8.08
2 undo header 3,394 99.71 0.18 0.12 67 98.51 1.49 0.00
2 Others 2,598 99.85 0.00 0.15 67 100.00 0.00 0.00


Back to Top

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