Using the report name awrrpt_1_112315_112316.html AWR Report

WORKLOAD REPOSITORY report for

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

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:11231505-Dec-16 14:00:2055 7.4
End Snap:11231605-Dec-16 14:30:1356 7.1
Elapsed:  29.89 (mins)  
DB Time:  2.00 (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: 770.96 744.52
Logical reads: 1,202.79 1,161.53
Block changes: 1.54 1.48
Physical reads: 81.98 79.17
Physical writes: 0.25 0.25
User calls: 10.41 10.05
Parses: 96.94 93.61
Hard parses: 0.04 0.03
Sorts: 3.49 3.37
Logons: 0.93 0.90
Executes: 131.96 127.44
Transactions: 1.04 

% Blocks changed per Read: 0.13Recursive Call %: 99.54
Rollback per transaction %: 98.33Rows per Sort: 56.56

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 93.19In-memory Sort %: 100.00
Library Hit %: 99.97Soft Parse %: 99.96
Execute to Parse %: 26.54Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 236.36% Non-Parse CPU: 93.93

Shared Pool Statistics

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

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  68  57.0 
db file sequential read 147,129 35 0 28.8User I/O
reliable message 1,890 30 16 24.6Other
gc cr disk read 72,276 27 0 22.8Cluster
PX Deq: reap credit 17,834 12 1 10.2Other

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 4.48 4.32
Global Cache blocks served: 96.77 93.46
GCS/GES messages received: 205.75 198.69
GCS/GES messages sent: 74.33 71.78
DBWR Fusion writes: 0.01 0.01
Estd Interconnect traffic (KB) 864.72 

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

Buffer access - local cache %: 92.82
Buffer access - remote cache %: 0.37
Buffer access - disk %: 6.81

Global Cache and Enqueue Services - Workload Characteristics

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

Global Cache and Enqueue Services - Messaging Statistics

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


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 116.75 97.17
DB CPU 68.49 57.00
PL/SQL execution elapsed time 6.27 5.22
connection management call elapsed time 2.29 1.90
parse time elapsed 1.70 1.42
failed parse elapsed time 0.03 0.03
hard parse elapsed time 0.03 0.02
repeated bind elapsed time 0.01 0.00
hard parse (sharing criteria) elapsed time 0.00 0.00
DB time 120.16  
background elapsed time 123.02  
background cpu time 66.87  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Other 47,304 82.97 52 1 25.47
User I/O 147,276 0.00 35 0 79.31
Cluster 80,345 0.00 31 0 43.27
System I/O 21,618 0.00 6 0 11.64
Network 16,040 0.00 1 0 8.64
Concurrency 167 0.00 0 2 0.09
Application 482 0.00 0 0 0.26
Commit 15 0.00 0 1 0.01

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file sequential read 147,129 0.00 35 0 79.23
reliable message 1,890 1.16 30 16 1.02
gc cr disk read 72,276 0.00 27 0 38.92
PX Deq: reap credit 17,834 97.89 12 1 9.60
Streams AQ: qmn coordinator waiting for slave to start 1 100.00 5 5309 0.00
control file sequential read 20,257 0.00 5 0 10.91
gc cr block 2-way 7,756 0.00 3 0 4.18
PX Deq Credit: send blkd 2,892 39.90 3 1 1.56
enq: PS - contention 1,201 0.00 1 0 0.65
gcs log flush sync 598 2.68 1 1 0.32
SQL*Net more data from dblink 3 0.00 0 160 0.00
control file parallel write 623 0.00 0 1 0.34
wait for scn ack 359 0.00 0 1 0.19
os thread startup 3 0.00 0 69 0.00
enq: JQ - contention 363 0.00 0 1 0.20
CGS wait for IPC msg 17,404 100.00 0 0 9.37
SQL*Net break/reset to client 480 0.00 0 0 0.26
log file parallel write 395 0.00 0 0 0.21
latch free 63 0.00 0 2 0.03
gc current block 2-way 212 0.00 0 1 0.11
db file parallel write 314 0.00 0 0 0.17
enq: CF - contention 96 0.00 0 1 0.05
row cache lock 162 0.00 0 0 0.09
PX Deq: Signal ACK 1,153 50.04 0 0 0.62
DFS lock handle 198 0.00 0 0 0.11
log file sequential read 15 0.00 0 2 0.01
ksxr poll remote instances 3,045 82.73 0 0 1.64
IPC send completion sync 96 100.00 0 0 0.05
gc current grant busy 49 0.00 0 0 0.03
gc cr block congested 9 0.00 0 2 0.00
SQL*Net message to client 15,467 0.00 0 0 8.33
log file sync 15 0.00 0 1 0.01
rdbms ipc reply 62 0.00 0 0 0.03
gc cr block busy 10 0.00 0 1 0.01
gc current grant 2-way 18 0.00 0 0 0.01
SQL*Net more data from client 564 0.00 0 0 0.30
gc cr multi block request 10 0.00 0 0 0.01
enq: WF - contention 10 0.00 0 0 0.01
enq: TA - contention 6 0.00 0 0 0.00
gc current block busy 2 0.00 0 1 0.00
Log archive I/O 12 0.00 0 0 0.01
library cache pin 1 0.00 0 1 0.00
direct path write 21 0.00 0 0 0.01
LGWR wait for redo copy 26 0.00 0 0 0.01
enq: FB - contention 2 0.00 0 0 0.00
gc buffer busy 1 0.00 0 1 0.00
gc cr grant 2-way 2 0.00 0 0 0.00
enq: TM - contention 2 0.00 0 0 0.00
log file single write 2 0.00 0 0 0.00
enq: JS - job run lock - synchronize 1 0.00 0 0 0.00
enq: DR - contention 1 0.00 0 0 0.00
direct path read 126 0.00 0 0 0.07
library cache lock 1 0.00 0 0 0.00
enq: TQ - TM contention 1 0.00 0 0 0.00
SQL*Net more data to client 3 0.00 0 0 0.00
KJC: Wait for msg sends to complete 1 0.00 0 0 0.00
PX qref latch 1 100.00 0 0 0.00
SQL*Net message to dblink 3 0.00 0 0 0.00
gcs remote message 599,580 99.92 13,983 23 322.88
jobq slave wait 5,185 43.80 12,229 2359 2.79
Streams AQ: qmn slave idle wait 934 0.11 5,281 5654 0.50
SQL*Net message from client 15,465 0.00 5,267 341 8.33
wait for unread message on broadcast channel 3,862 83.14 3,387 877 2.08
PX Idle Wait 1,741 64.79 3,368 1935 0.94
virtual circuit status 60 100.00 1,756 29265 0.03
DIAG idle wait 8,953 0.00 1,751 196 4.82
ges remote message 27,407 95.00 1,750 64 14.76
Streams AQ: qmn coordinator idle wait 733 41.20 1,743 2378 0.39
Streams AQ: waiting for messages in the queue 185 96.76 1,741 9412 0.10
Streams AQ: waiting for time management or cleanup tasks 10 40.00 1,590 158984 0.01
PX Deq: Join ACK 1,735 33.72 89 51 0.93
PX Deq: Execution Msg 3,104 2.58 60 19 1.67
SQL*Net message from dblink 4 0.00 35 8635 0.00
PX Deq: Parse Reply 1,670 32.93 0 0 0.90
PX Deq: Execute Reply 1,090 11.10 0 0 0.59
PX Deq: Msg Fragment 156 40.38 0 0 0.08
Streams AQ: RAC qmn coordinator idle wait 735 98.23 0 0 0.40
class slave wait 3 0.00 0 1 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
events in waitclass Other 22,025 90.91 34 2 11.86
db file sequential read 58,631 0.00 14 0 31.57
gc cr disk read 28,413 0.00 11 0 15.30
control file sequential read 4,831 0.00 2 0 2.60
gc cr block 2-way 1,531 0.00 1 0 0.82
control file parallel write 623 0.00 0 1 0.34
os thread startup 3 0.00 0 69 0.00
log file parallel write 395 0.00 0 0 0.21
db file parallel write 314 0.00 0 0 0.17
row cache lock 158 0.00 0 0 0.09
gc current block 2-way 82 0.00 0 1 0.04
log file sequential read 15 0.00 0 2 0.01
gc current grant busy 22 0.00 0 0 0.01
gc cr multi block request 7 0.00 0 1 0.00
gc cr block congested 2 0.00 0 2 0.00
Log archive I/O 12 0.00 0 0 0.01
gc buffer busy 1 0.00 0 1 0.00
gc cr grant 2-way 2 0.00 0 0 0.00
log file single write 2 0.00 0 0 0.00
gc cr block busy 1 0.00 0 1 0.00
direct path read 126 0.00 0 0 0.07
enq: TM - contention 1 0.00 0 0 0.00
direct path write 19 0.00 0 0 0.01
gc current grant 2-way 3 0.00 -0 -0 0.00
rdbms ipc message 33,310 87.08 27,696 831 17.94
gcs remote message 599,583 99.92 13,983 23 322.88
pmon timer 610 100.00 1,752 2871 0.33
DIAG idle wait 8,954 0.00 1,751 196 4.82
ges remote message 27,408 95.00 1,750 64 14.76
Streams AQ: qmn coordinator idle wait 733 41.20 1,743 2378 0.39
smon timer 11 0.00 1,703 154860 0.01
Streams AQ: waiting for time management or cleanup tasks 10 40.00 1,590 158984 0.01
PX Deq: Join ACK 6 50.00 0 1 0.00
Streams AQ: RAC qmn coordinator idle wait 735 98.23 0 0 0.40
PX Deq: Parse Reply 6 50.00 0 1 0.00
PX Deq: Execute Reply 6 50.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 3,503
AVG_IDLE_TIME 175,718
AVG_IOWAIT_TIME 0
AVG_SYS_TIME 1,462
AVG_USER_TIME 1,987
BUSY_TIME 114,108
IDLE_TIME 5,625,012
IOWAIT_TIME 0
SYS_TIME 48,610
USER_TIME 65,498
LOAD 1
OS_CPU_WAIT_TIME 35,000
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 0
VM_OUT_BYTES 0
PHYSICAL_MEMORY_BYTES 67,462,922,240
NUM_CPUS 32

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 118.10 66.90 88,222 1,727,437
SYS$BACKGROUND 0.00 0.00 58,783 366,614
SYS.KUPC$C_1_20161115174523 0.00 0.00 0 0
SYS.KUPC$C_1_20161115182328 0.00 0.00 0 0
SYS.KUPC$C_1_20161124101927 0.00 0.00 0 0
SYS.KUPC$C_1_20161124103225 0.00 0.00 0 0
SYS.KUPC$S_1_20161115174523 0.00 0.00 0 0
SYS.KUPC$S_1_20161115182328 0.00 0.00 0 0
SYS.KUPC$S_1_20161124101927 0.00 0.00 0 0
SYS.KUPC$S_1_20161124103225 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 88222 2086 3 0 0 0 14187 50
SYS$BACKGROUND 59054 1371 164 27 0 0 0 0
appdbc 0 0 0 0 0 0 0 0
hrms 0 0 0 0 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
75 42 6 12.46 62.21 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
37 37 62,612 0.00 30.86 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
26 11 0   21.31 69atchvk0ukpy ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN SYS.DBMS_DATAPUMP.A...
25 11 580 0.04 21.21 afcz9s4uazbpk ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN :1 := sys.kupc$que_int.t...
19 5 580 0.03 15.81 gn74qsy7sv4z4 ude@erpdb-m9k-d00 (TNS V1-V3) SELECT COUNT(*) FROM gv$datapu...
5 5 165,909 0.00 4.13 2ym6hhaq30r73   select type#, blocks, extents,...
2 1 6 0.41 2.04 bnafqqprpz3u1 sqlplus@erpdb-m9k-d00 (TNS V1-V3) select tablespace_name, use_pr...
2 1 6 0.39 1.97 11ssd5xrck6sn JDBC Thin Client select sum("tablespace_size(M)...
2 2 636 0.00 1.89 3f751tsaf2j02 JDBC Thin Client SELECT VALUE FROM NLS_INSTANCE...
2 2 12 0.14 1.41 29nxqgu4mdrnu sqlplus@erpdb-m9k-d00 (TNS V1-V3) declare v_process number; v_...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
42 75 6 6.96 62.21 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
37 37 62,612 0.00 30.86 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
11 25 580 0.02 21.21 afcz9s4uazbpk ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN :1 := sys.kupc$que_int.t...
11 26 0   21.31 69atchvk0ukpy ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN SYS.DBMS_DATAPUMP.A...
5 5 165,909 0.00 4.13 2ym6hhaq30r73   select type#, blocks, extents,...
5 19 580 0.01 15.81 gn74qsy7sv4z4 ude@erpdb-m9k-d00 (TNS V1-V3) SELECT COUNT(*) FROM gv$datapu...
2 2 636 0.00 1.89 3f751tsaf2j02 JDBC Thin Client SELECT VALUE FROM NLS_INSTANCE...
2 2 12 0.14 1.41 29nxqgu4mdrnu sqlplus@erpdb-m9k-d00 (TNS V1-V3) declare v_process number; v_...
1 2 6 0.21 2.04 bnafqqprpz3u1 sqlplus@erpdb-m9k-d00 (TNS V1-V3) select tablespace_name, use_pr...
1 2 6 0.20 1.97 11ssd5xrck6sn JDBC Thin Client select sum("tablespace_size(M)...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
1,625,326 6 270,887.67 75.35 41.75 74.75 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
497,727 165,909 3.00 23.08 4.96 4.96 2ym6hhaq30r73   select type#, blocks, extents,...
271,304 62,612 4.33 12.58 36.71 37.09 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
96,586 6 16,097.67 4.48 1.28 2.45 bnafqqprpz3u1 sqlplus@erpdb-m9k-d00 (TNS V1-V3) select tablespace_name, use_pr...
68,156 11 6,196.00 3.16 0.36 0.36 25t0tfag0pz8v   select file#, block# from seg...
22,359 1 22,359.00 1.04 0.42 0.61 fbxacrra3ym8n JDBC Thin Client select sum(bytes/1024/1024/102...
21,864 6 3,644.00 1.01 1.22 2.37 11ssd5xrck6sn JDBC Thin Client select sum("tablespace_size(M)...
9,560 528 18.11 0.44 0.04 0.04 bsa0wjtftg3uw   select file# from file$ where ...
8,140 1 8,140.00 0.38 0.07 0.07 31a13pnjps7j3   SELECT source, (case w...
3,888 648 6.00 0.18 0.65 0.65 05uqdabhzncdc   select role# from defrole$ d, ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
88,221 6 14,703.50 60.01 41.75 74.75 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
58,628 62,612 0.94 39.88 36.71 37.09 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
7 1 7.00 0.00 0.83 0.84 bunssq950snhf   insert into wrh$_sga_target_ad...
6 1 6.00 0.00 0.01 0.03 76natvnhtqqhw   INSERT INTO SYS.WRI$_ADV_TASKS...
2 1 2.00 0.00 0.06 0.27 7vgmvmy8vvb9s   insert into wrh$_tempstatxs ...
2 1 2.00 0.00 1.17 1.17 84qubbrsr0kfn   insert into wrh$_latch (snap...
2 1 2.00 0.00 0.01 0.02 bqnn4c3gjtmgu   insert into wrh$_bg_event_summ...
2 1 2.00 0.00 0.00 0.01 g6wf9na8zs5hb   insert into wrh$_sysmetric_sum...
1 1 1.00 0.00 0.04 0.53 b8fznm1yy23x2   DECLARE job BINARY_INTEGER := ...
0 648 0.00 0.00 0.65 0.65 05uqdabhzncdc   select role# from defrole$ d, ...

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
165,909 165,909 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
62,612 0 0.00 0.00 0.00 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
1,302 72 0.06 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
648 1,296 2.00 0.00 0.00 05uqdabhzncdc   select role# from defrole$ d, ...
636 636 1.00 0.00 0.00 3f751tsaf2j02 JDBC Thin Client SELECT VALUE FROM NLS_INSTANCE...
580 0 0.00 0.02 0.04 afcz9s4uazbpk ude@erpdb-m9k-d00 (TNS V1-V3) BEGIN :1 := sys.kupc$que_int.t...
580 580 1.00 0.01 0.03 gn74qsy7sv4z4 ude@erpdb-m9k-d00 (TNS V1-V3) SELECT COUNT(*) FROM gv$datapu...
528 4,525 8.57 0.00 0.00 bsa0wjtftg3uw   select file# from file$ where ...
369 369 1.00 0.00 0.00 a1mbfp580hw3k   select u1.user#, u2.user#, u...
352 361 1.03 0.00 0.00 6ssrk2dqj7jbx   select job, nvl2(last_date, ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
165,909 165,909 95.44 2ym6hhaq30r73   select type#, blocks, extents,...
1,302 1,302 0.75 0h6b2sajwb74n   select privilege#, level from ...
648 648 0.37 05uqdabhzncdc   select role# from defrole$ d, ...
636 636 0.37 3f751tsaf2j02 JDBC Thin Client SELECT VALUE FROM NLS_INSTANCE...
580 580 0.33 gn74qsy7sv4z4 ude@erpdb-m9k-d00 (TNS V1-V3) SELECT COUNT(*) FROM gv$datapu...
528 528 0.30 bsa0wjtftg3uw   select file# from file$ where ...
369 11 0.21 aq8yqxyyb40nn   update sys.job$ set this_date=...
368 12 0.21 47a50dvdgnxc2   update sys.job$ set failures=0...
368 369 0.21 a1mbfp580hw3k   select u1.user#, u2.user#, u...
159 159 0.09 c4nhd1ntptxq7   select message_level, sequenc...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

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

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

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

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)CWT % of Elapsd TimeElapsed Time(s)CPU Time(s)Executions SQL IdSQL ModuleSQL Text
18.89 25.27 74.75 41.75 6 0yt1b8mbz63nk sqlplus@erpdb-m9k-d00 (TNS V1-V3) SELECT e.owner, e.segment_typ...
11.20 30.19 37.09 36.71 62,612 37k9g8mgfh7h8   select 1 from x$ktfbue where k...
0.24 39.99 0.61 0.42 1 fbxacrra3ym8n JDBC Thin Client select sum(bytes/1024/1024/102...
0.08 33.55 0.24 0.24 352 6ssrk2dqj7jbx   select job, nvl2(last_date, ...
0.02 54.41 0.05 0.03 4 c7sn076yz7030   select smontabv.cnt, smontab....
0.01 0.47 2.45 1.28 6 bnafqqprpz3u1 sqlplus@erpdb-m9k-d00 (TNS V1-V3) select tablespace_name, use_pr...
0.01 2.07 0.53 0.04 1 b8fznm1yy23x2   DECLARE job BINARY_INTEGER := ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
05uqdabhzncdcselect role# from defrole$ d, user$ u where d.user#=:1 and u.user#=d.user# and u.defrole=2 union select privilege# from sysauth$ s, user$ u where (grantee#=:1 or grantee#=1) and privilege#>0 and not exists (select null from defrole$ where user#=:1 and role#=s.privilege#) and u.user#=:1 and u.defrole=3
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0yt1b8mbz63nk SELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file# , greatest(e.block_id, c.block#) corr_start_block# , least(e.block_id+e.blocks-1, c.block#+c.blocks-1) corr_end_block# , least(e.block_id+e.blocks-1, c.block#+c.blocks-1) - greatest(e.block_id, c.block#) + 1 blocks_corrupted , corruption_type description FROM dba_extents e, v$database_block_corruption c WHERE e.file_id = c.file# AND e.block_id <= c.block# + c.blocks - 1 AND e.block_id + e.blocks - 1 >= c.block# UNION SELECT s.owner, s.segment_type, s.segment_name, s.partition_name, c.file# , header_block corr_start_block# , header_block corr_end_block# , 1 blocks_corrupted , corruption_type||' Segment Header' description FROM dba_segments s, v$database_block_corruption c WHERE s.header_file = c.file# AND s.header_block between c.block# and c.block# + c.blocks - 1 UNION SELECT null owner, null segment_type, null segment_name, null partition_name, c.file# , greatest(f.block_id, c.block#) corr_start_block# , least(f.block_id+f.blocks-1, c.block#+c.blocks-1) corr_end_block# , least(f.block_id+f.blocks-1, c.block#+c.blocks-1) - greatest(f.block_id, c.block#) + 1 blocks_corrupted , 'Free Block' description FROM dba_free_space f, v$database_block_corruption c WHERE f.file_id = c.file# AND f.block_id <= c.block# + c.blocks - 1 AND f.block_id + f.blocks - 1 >= c.block# order by file#, corr_start_block#
10xj8nynmpqtq SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time
11ssd5xrck6sn select sum("tablespace_size(M)") from ( select t2.tablespace_size "tablespace_size(M)", t2.tablespace_size - nvl(t1.free_size, 0) "used_size(M)", nvl(t1.free_size, 0) "free_size(M)", round((t2.tablespace_size - nvl(t1.free_size, 0))*100/t2.tablespace_size, 2) "used_percentage(%)" from dba_tablespaces t0, (select tablespace_name, round(sum(bytes)/1024/1024) free_size from dba_free_space group by tablespace_name) t1, (select tablespace_name, round(sum(bytes)/1024/1024) tablespace_size from dba_data_files group by tablespace_name) t2 where t0.tablespace_name = t1.tablespace_name(+) and t0.tablespace_name = t2.tablespace_name(+) and not (t0.extent_management like 'LOCAL' and t0.contents like 'TEMPORARY') union all select t2.tablespace_size "tablespace_size(M)", nvl(t1.used_size, 0) "used_size(M)", t2.tablespace_size - nvl(t1.used_size, 0) "free_size(M)", round(nvl(t1.used_size, 0)*100/t2.tablespace_size, 2) "used_percentage(%)" from dba_tablespaces t0, (select tablespace_name, round(sum(bytes_cached)/1024/1024) used_size from v$temp_extent_pool group by tablespace_name) t1, (select tablespace_name, round(sum(bytes)/1024/1024) tablespace_size from dba_temp_files group by tablespace_name) t2 where t0.tablespace_name = t1.tablespace_name(+) and t0.tablespace_name = t2.tablespace_name(+) and t0.extent_management like 'LOCAL' and t0.contents like 'TEMPORARY')
14566d856s6hsSELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1
25t0tfag0pz8vselect file#, block# from seg$ where ts# = :1
298ppdduqr7wmSELECT status FROM sys.wri$_adv_tasks WHERE id = :1
29nxqgu4mdrnu declare v_process number; v_sid number; v_serail number; v_status varchar2(30); v_count number; v_inst_num number; begin select INSTANCE_NUMBER into v_inst_num from v$instance; --parallel sql insert into ak_mon.High_parall_sql (collect_date, inst_num, username, sql_id, program, parall_cnt, sql_text) select sysdate collect_date, v_inst_num inst_num, username, a.sql_id, program, parall_cnt, sql_text from (select username, sql_id, program, count(*) parall_cnt from (select username, sql_id, program from v$session where status = 'ACTIVE' AND SQL_ID is not null union all select username, PREV_SQL_ID as sql_id, program from v$session where PREV_SQL_ID is not null and status = 'ACTIVE') group by username, sql_id, program having count(*) > 5) a, v$sqlarea sqlarea where a.sql_id = sqlarea.sql_id; insert into ak_mon.session_lock_longops select sysdate collect_date, v_inst_num inst_num, a.sid, b.serial#, a.type, a.id1, a.id2, a.LMODE, a.REQUEST, a.CTIME, a.BLOCK, b.username, b.program, b.machine, b.sql_id, (select sql_ text from v$sqlarea x where x.sql_id = b.sql_id) sql_text, b.PREV_SQL_ID, (select sql_text from v$sqlarea x where x.sql_id = b.PREV_SQL_ID) PREV_SQL_TEXT, b.status, p.spid, a.addr, --case when exists (select 1 from ak_mon.filter_program where (FILTER_TYPE='2' and filter_str=(upper(b.username))) or (FILTER_TYPE='1' and filter_str=upper(substr(b.program, 1, Instr(b.program, '@', 1)-1))) ) then 0 else 1 end kill_status, 1, b.event from v$lock a, v$session b, v$process p where a.TYPE in ('TX', 'TM') ----²éɱµÄËøÀàÐÍ and a.sid = b.sid and b.paddr = p.addr and a.ctime >= 300 --upper(b.program) like 'JDBC%') or --(upper(b.program) like 'SQLPLUS%' and a.ctime >= 0)) --ʱ¼äÏÞÖÆ --a.ctime >= 0) --ʱ¼äÏÞÖÆ and a.lmode > 0 and a.REQUEST = 0 and a.block = 1 and b.username is not null; commit; for x in (select distinct a.sid, b.serial# from v$lock a, v$session b where a.TYPE in ('TM', 'TX') and a.sid = b.sid and a.ctime >= 300 --upper(b.program) like 'JDBC%') or --(upper(b.program) like 'SQLPLUS%' and a.ctime >= 0)) --a.ctime >= 0) and b.username is not null --and not exists (select 1 from ak_mon.filter_program where (FILTER_TYPE='2' and filter _str=(upper(b.username))) or (FILTER_TYPE='1' and filter_str=upper(substr(b.program, 1, Instr(b.program, '@', 1)-1))) ) and a.lmode > 0 and a.block = 1 and a.REQUEST = 0) loop select b.spid into v_process from v$session a, v$process b where a.paddr = b.addr and a.status<>'KILLED' and a.serial#=x.serial# and a.sid = x.sid; dbms_output.put_line('ps -ef|grep '||to_char(v_process)||'|grep LOCAL=NO|awk ''{print -9 $2}''|xargs kill'); end loop; commit; insert into ak_mon.session_wait_longops select sysdate collect_date, v_inst_num inst_num, a.username, a.sid, a.serial#, a.program, a.machine, a.sql_id, a.event, a.SECONDS_IN_WAIT, (select sql_text from v$sqlarea x where x.sql_id=a.sql_id) sql_text, a.PREV_SQL_ID, (select sql_text from v$sqlarea x where x.sql_id=a.PREV_SQL_ID) PREV_SQL_TEXT from v$session a where WAIT_CLASS#<>6 and username is not null and WAIT_TIME =0 and status='ACTIVE' and SECONDS_IN_WAIT>0; commit; end;
2ym6hhaq30r73select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
31a13pnjps7j3 SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
37k9g8mgfh7h8select 1 from x$ktfbue where ktfbuesegtsn = :1 and ktfbuesegfno = :2 and ktfbuesegbno = :3 and ktfbuefno = :4 and ktfbuebno <= :5 and (ktfbuebno+ktfbueblks) > :5
3f751tsaf2j02SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'
47a50dvdgnxc2update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4
69atchvk0ukpyBEGIN SYS.DBMS_DATAPUMP.ADD_FILE( handle => :JOBHNDL, filename => :FILENAME, directory => :DIRECTORY, filesize => :FILESIZE, filetype => :FILETYPE); END;
6ssrk2dqj7jbxselect job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job
76natvnhtqqhwINSERT INTO SYS.WRI$_ADV_TASKS (ID, OWNER#, OWNER_NAME, NAME, DESCRIPTION, ADVISOR_ID, ADVISOR_NAME, CTIME, MTIME, PARENT_ID, PARENT_REC_ID, PROPERTY, EXEC_START, EXEC_END, STATUS, STATUS_MSG_ID, PCT_COMPLETION_TIME, PROGRESS_METRIC, METRIC_UNITS, ACTIVITY_COUNTER, REC_COUNT, ERROR_MSG#, SOURCE, HOW_CREATED ) VALUES (:B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , SYSDATE, SYSDATE, 0, 0, :B3 , NULL, NULL, :B2 , 0, 0, 0, '', 0, 0, 0, '', :B1 )
7vgmvmy8vvb9sinsert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.kcftiopyw, ts.kcftiosbr, ts.kcftioprt, ts.kcftiopwt, ts.kcftiosbt, ts.kcftiopbr, ts.kcftiopbw, fw.count, fw.time from x$kcftio ts, x$kcctf tf, x$kcbfwait fw where tf.tfdup != 0 and tf.tfnum = ts.kcftiofno and fw.indx+1 = (ts.kcftiofno + :db_files)
84qubbrsr0kfninsert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash
8vkjh60z1g287 select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
a1mbfp580hw3kselect u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1 from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name
afcz9s4uazbpkBEGIN :1 := sys.kupc$que_int.transceive_int(:2, :3, :4, :5, :6); END;
aq8yqxyyb40nnupdate sys.job$ set this_date=:1 where job=:2
b8fznm1yy23x2DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN --¸ù¾ÝÒøÆóÊÓͼ¸üÐÂ״̬±í£¬Ã¿ÌìÖ´ÐÐÒ»´Î£¬2015-06-30ÐÂÔö SYNCH_GDYQ_PAYED_BOE_STATUS; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
bnafqqprpz3u1select tablespace_name, use_precent from (select b.tablespace_name, round(sum(b.bytes)/1024/1024, 0) sum_MB, round(sum(nvl(a.bytes, 0))/1024/1024, 0) free_MB, round((sum(b.bytes)-sum(nvl(a.bytes, 0)))/sum(b.bytes), 2)*100 use_precent from (select tablespace_name, file_id, sum(bytes) bytes from dba_free_space group by tablespace_name, file_id ) a, dba_data_files b where a.file_id(+)=b.file_id and a.tablespace_name(+)=b.tablespace_name and b.tablespace_name like '%%' group by b.tablespace_name order by 4) where use_precent>95
bqnn4c3gjtmguinsert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select /*+ ordered use_nl(e) */ :snap_id, :dbid, :instance_number, e.event_id, sum(e.total_waits), sum(e.total_timeouts), sum(e.time_waited_micro) from v$session bgsids, v$session_event e where bgsids.type = 'BACKGROUND' and bgsids.sid = e.sid group by e.event_id
bsa0wjtftg3uwselect file# from file$ where ts#=:1
bunssq950snhfinsert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
c4nhd1ntptxq7select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING where reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instance_number = :4
c7sn076yz7030select smontabv.cnt, smontab.time_mp, smontab.scn, smontab.num_mappings, smontab.tim_scn_map, smontab.orig_thread from smon_scn_time smontab, (select max(scn) scnmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt from smon_scn_time where thread=0) smontabv where smontab.scn = smontabv.scnmax and thread=0
fbxacrra3ym8nselect sum(bytes/1024/1024/1024) as totaldata from dba_segments
g6wf9na8zs5hbinsert into wrh$_sysmetric_summary (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, num_interval, maxval, minval, average, standard_deviation) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, numintv, max, min, avg, std FROM x$kewmsmdv WHERE groupid = 2
gdn3ysuyssf82SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
gn74qsy7sv4z4SELECT COUNT(*) FROM gv$datapump_job WHERE job_id = :1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 9,707 5.41 5.23
CPU used when call started 5,961 3.32 3.21
CR blocks created 584 0.33 0.31
Cached Commit SCN referenced 0 0.00 0.00
Commit SCN cached 0 0.00 0.00
DB time 541,724 302.08 291.72
DBWR checkpoint buffers written 403 0.22 0.22
DBWR checkpoints 1 0.00 0.00
DBWR fusion writes 22 0.01 0.01
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 22 0.01 0.01
DBWR undo block writes 91 0.05 0.05
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 583 0.33 0.31
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 3,480 1.94 1.87
PX local messages sent 3,480 1.94 1.87
PX remote messages recv'd 1,309 0.73 0.70
PX remote messages sent 2,411 1.34 1.30
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 583 0.33 0.31
RowCR - row contention 0 0.00 0.00
RowCR attempts 0 0.00 0.00
RowCR hits 0 0.00 0.00
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 13,649 7.61 7.35
SQL*Net roundtrips to/from dblink 3 0.00 0.00
active txn count during cleanout 46 0.03 0.02
application wait time 15 0.01 0.01
background checkpoints completed 1 0.00 0.00
background checkpoints started 1 0.00 0.00
background timeouts 8,142 4.54 4.38
branch node splits 1 0.00 0.00
buffer is not pinned count 960,202 535.44 517.07
buffer is pinned count 692,631 386.23 372.98
bytes received via SQL*Net from client 1,917,704 1,069.37 1,032.69
bytes received via SQL*Net from dblink 7,122 3.97 3.84
bytes sent via SQL*Net to client 744,954 415.41 401.16
bytes sent via SQL*Net to dblink 121 0.07 0.07
calls to get snapshot scn: kcmgss 558,865 311.64 300.95
calls to kcmgas 149,656 83.45 80.59
calls to kcmgcs 47 0.03 0.03
change write time 3 0.00 0.00
cleanout - number of ktugct calls 658 0.37 0.35
cleanouts and rollbacks - consistent read gets 2 0.00 0.00
cleanouts only - consistent read gets 584 0.33 0.31
cluster key scan block gets 579,512 323.15 312.07
cluster key scans 377,406 210.45 203.23
cluster wait time 3,063 1.71 1.65
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 20 0.01 0.01
commit cleanout failures: callback failure 4 0.00 0.00
commit cleanout failures: cannot pin 0 0.00 0.00
commit cleanouts 406 0.23 0.22
commit cleanouts successfully completed 382 0.21 0.21
commit immediate performed 0 0.00 0.00
commit immediate requested 0 0.00 0.00
commit txn count during cleanout 646 0.36 0.35
concurrency wait time 27 0.02 0.01
consistent changes 1,224 0.68 0.66
consistent gets 2,116,710 1,180.34 1,139.85
consistent gets - examination 619,320 345.35 333.51
consistent gets direct 0 0.00 0.00
consistent gets from cache 2,116,710 1,180.34 1,139.85
current blocks converted for CR 0 0.00 0.00
cursor authentications 1 0.00 0.00
data blocks consistent reads - undo records applied 2 0.00 0.00
db block changes 2,754 1.54 1.48
db block gets 40,248 22.44 21.67
db block gets direct 19 0.01 0.01
db block gets from cache 40,229 22.43 21.66
deferred (CURRENT) block cleanout applications 221 0.12 0.12
dirty buffers inspected 0 0.00 0.00
enqueue conversions 2,698 1.50 1.45
enqueue releases 220,489 122.95 118.73
enqueue requests 220,541 122.98 118.76
enqueue timeouts 56 0.03 0.03
enqueue waits 1,680 0.94 0.90
exchange deadlocks 0 0.00 0.00
execute count 236,649 131.96 127.44
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 7,123 3.97 3.84
free buffer requested 155,636 86.79 83.81
gc CPU used by this session 4,652 2.59 2.51
gc blocks lost 0 0.00 0.00
gc cr block build time 10 0.01 0.01
gc cr block flush time 22 0.01 0.01
gc cr block receive time 332 0.19 0.18
gc cr block send time 11 0.01 0.01
gc cr blocks received 7,789 4.34 4.19
gc cr blocks served 1,040 0.58 0.56
gc current block flush time 0 0.00 0.00
gc current block pin time 96 0.05 0.05
gc current block receive time 8 0.00 0.00
gc current block send time 1,101 0.61 0.59
gc current blocks received 241 0.13 0.13
gc current blocks served 172,506 96.19 92.89
gc local grants 74,092 41.32 39.90
gc remote grants 72,937 40.67 39.28
gcs messages sent 127,658 71.19 68.74
ges messages sent 5,646 3.15 3.04
global enqueue get time 221 0.12 0.12
global enqueue gets async 166 0.09 0.09
global enqueue gets sync 185,893 103.66 100.10
global enqueue releases 183,312 102.22 98.71
heap block compress 13 0.01 0.01
hot buffers moved to head of LRU 74 0.04 0.04
immediate (CR) block cleanout applications 586 0.33 0.32
immediate (CURRENT) block cleanout applications 89 0.05 0.05
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 2,323 1.30 1.25
index fast full scans (full) 0 0.00 0.00
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 756,556 421.88 407.41
index scans kdiixs1 4,360 2.43 2.35
leaf node 90-10 splits 13 0.01 0.01
leaf node splits 21 0.01 0.01
lob reads 0 0.00 0.00
lob writes 0 0.00 0.00
lob writes unaligned 0 0.00 0.00
logons cumulative 1,676 0.93 0.90
messages received 1,401 0.78 0.75
messages sent 1,401 0.78 0.75
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 1,101,032 613.97 592.91
opened cursors cumulative 174,323 97.21 93.87
parse count (failures) 61 0.03 0.03
parse count (hard) 63 0.04 0.03
parse count (total) 173,838 96.94 93.61
parse time cpu 416 0.23 0.22
parse time elapsed 176 0.10 0.09
physical read IO requests 147,018 81.98 79.17
physical read bytes 1,204,371,456 671,595.08 648,557.60
physical read total IO requests 167,558 93.44 90.23
physical read total bytes 1,549,808,640 864,221.62 834,576.54
physical read total multi block requests 11 0.01 0.01
physical reads 147,018 81.98 79.17
physical reads cache 146,892 81.91 79.10
physical reads cache prefetch 0 0.00 0.00
physical reads direct 126 0.07 0.07
physical reads direct (lob) 0 0.00 0.00
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 336 0.19 0.18
physical write bytes 3,743,744 2,087.63 2,016.02
physical write total IO requests 2,613 1.46 1.41
physical write total bytes 47,132,672 26,282.65 25,381.08
physical write total multi block requests 150 0.08 0.08
physical writes 457 0.25 0.25
physical writes direct 39 0.02 0.02
physical writes direct (lob) 0 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 418 0.23 0.23
physical writes non checkpoint 196 0.11 0.11
pinned buffers inspected 0 0.00 0.00
prefetch clients - default 0 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 16 0.01 0.01
process last non-idle time 337 0.19 0.18
queries parallelized 583 0.33 0.31
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 4,061,752 2,264.96 2,187.27
recursive cpu usage 2,789 1.56 1.50
redo blocks written 3,056 1.70 1.65
redo buffer allocation retries 0 0.00 0.00
redo entries 2,227 1.24 1.20
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 71 0.04 0.04
redo size 1,382,568 770.96 744.52
redo subscn max counts 92 0.05 0.05
redo synch time 1 0.00 0.00
redo synch writes 15 0.01 0.01
redo wastage 131,708 73.44 70.93
redo write time 24 0.01 0.01
redo writer latching time 0 0.00 0.00
redo writes 395 0.22 0.21
rollback changes - undo records applied 0 0.00 0.00
rollbacks only - consistent read gets 0 0.00 0.00
rows fetched via callback 181,731 101.34 97.86
session connect time 0 0.00 0.00
session cursor cache hits 167,473 93.39 90.18
session logical reads 2,156,958 1,202.79 1,161.53
session pga memory 72,875,722,584 40,637,775.38 39,243,792.45
session pga memory max 78,039,172,952 43,517,076.31 42,024,325.77
session uga memory 51,588,665,768 28,767,448.71 27,780,649.31
session uga memory max 655,242,136 365,383.45 352,849.83
shared hash latch upgrades - no wait 2,369 1.32 1.28
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 6,253 3.49 3.37
sorts (rows) 353,653 197.21 190.44
sql area evicted 0 0.00 0.00
sql area purged 61 0.03 0.03
summed dirty queue length 0 0.00 0.00
switch current to new buffer 7 0.00 0.00
table fetch by rowid 188,329 105.02 101.42
table fetch continued row 2 0.00 0.00
table scan blocks gotten 504,609 281.39 271.73
table scan rows gotten 24,650,864 13,746.09 13,274.56
table scans (direct read) 0 0.00 0.00
table scans (long tables) 0 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 76,482 42.65 41.19
total number of times SMON posted 11 0.01 0.01
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 421,928 235.28 227.21
user I/O wait time 3,463 1.93 1.86
user calls 18,672 10.41 10.05
user commits 31 0.02 0.02
user rollbacks 1,826 1.02 0.98
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 4,062 2.27 2.19
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,152,670 6,158,092
opened cursors current 407 399
logons current 55 56

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 1 2.01

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 90,662 51 0.24 1.00 5 0 0 0.00
USERS 22,440 13 0.25 1.00 0 0 0 0.00
SYSAUX 11,479 6 0.22 1.00 244 0 0 0.00
DAT_EPM 7,665 4 0.22 1.00 2 0 0 0.00
SYSTEM 7,260 4 0.27 1.00 19 0 0 0.00
EPM_GD_DATA 2,658 1 0.18 1.00 0 0 0 0.00
AUDIT_DATA 1,099 1 0.28 1.00 0 0 0 0.00
DAT_PAMS 1,092 1 0.20 1.00 0 0 0 0.00
DAT_EVSAS 628 0 0.56 1.00 2 0 0 0.00
EAS_DATA_NEW 609 0 0.15 1.00 0 0 0 0.00
EIP_DATA 384 0 0.18 1.00 0 0 0 0.00
IDX_PAMS 342 0 0.23 1.00 0 0 0 0.00
EAS_IND 305 0 0.39 1.00 0 0 0 0.00
MOB_DATA 198 0 0.20 1.00 0 0 0 0.00
TDEIP_DATA 100 0 0.40 1.00 1 0 0 0.00
UNDOTBS1 1 0 10.00 1.00 50 0 0 0.00
DAT_HRMS 34 0 5.59 1.00 1 0 0 0.00
SIED 24 0 0.00 1.00 0 0 0 0.00
LISAPP_DAT 8 0 10.00 1.00 8 0 0 0.00
LISAPP_IDX 3 0 10.00 1.00 3 0 0 0.00
IDX_HRMS 4 0 7.50 1.00 0 0 0 0.00
UNDOTBS2 4 0 10.00 1.00 0 0 0 0.00
TDEIP_IND 3 0 10.00 1.00 0 0 0 0.00
IDX_EVSAS 1 0 10.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 1,099 1 0.28 1.00 0 0 0 0.00
DAT_EPM /dev/vx/rdsk/racdg/datafile304 109 0 0.55 1.00 0 0 0 0.00
DAT_EPM /dev/vx/rdsk/racdg/datafile52 3,799 2 0.25 1.00 1 0 0 0.00
DAT_EPM /dev/vx/rdsk/racdg/datafile53 3,757 2 0.19 1.00 1 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile103 7 0 1.43 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile109 24 0 1.25 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile333 40 0 0.75 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile36 274 0 0.26 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile37 63 0 0.79 1.00 1 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile373 10 0 0.00 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile374 22 0 1.36 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile38 20 0 2.00 1.00 1 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile388 20 0 1.00 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile72 35 0 0.57 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile81 96 0 0.42 1.00 0 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile82 17 0 0.59 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile101 1 0 10.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile102 1 0 10.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile107 1 0 10.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile112 1 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile118 1 0 0.00 1.00 0 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/datafile305 1 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile370 12 0 0.83 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile54 1 0 10.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile67 1 0 10.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile68 1 0 10.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile70 1 0 10.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile73 1 0 10.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile74 1 0 10.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile78 1 0 10.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile79 1 0 10.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile80 1 0 10.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile83 1 0 10.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile84 1 0 10.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile92 1 0 10.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile93 1 0 10.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile94 1 0 10.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile95 1 0 10.00 1.00 0 0 0 0.00
DAT_PAMS /dev/vx/rdsk/racdg/datafile29 1,092 1 0.20 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile01 2,789 2 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile05 1,868 1 0.22 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile07 2,183 1 0.27 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile08 8,353 5 0.28 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile09 2,157 1 0.25 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile10 6,166 3 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile100 1,055 1 0.15 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile104 3,486 2 0.26 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile108 902 1 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile11 3,553 2 0.20 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile113 324 0 0.25 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile116 137 0 0.15 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile119 103 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile120 35 0 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile121 69 0 0.14 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile122 35 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile123 18 0 1.11 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 103 0 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile126 18 0 0.56 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile127 613 0 0.20 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile128 52 0 0.58 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile129 154 0 0.26 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile130 69 0 0.58 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile132 69 0 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile133 35 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile134 52 0 0.38 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile135 18 0 0.00 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 35 0 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile300 52 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile301 52 0 0.19 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile302 86 0 0.47 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile303 86 0 0.12 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile306 49 0 0.20 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile307 1,769 1 0.13 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile308 630 0 0.27 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile309 288 0 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile310 494 0 0.16 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile311 324 0 0.28 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile312 137 0 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile313 783 0 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile314 409 0 0.20 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile315 545 0 0.28 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile316 994 1 0.11 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile317 647 0 0.26 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile318 494 0 0.20 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile319 2,517 1 0.23 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile320 2,744 2 0.23 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile321 1,717 1 0.23 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile334 3,723 2 0.22 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile335 1,989 1 0.19 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile336 1,768 1 0.25 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile340 748 0 0.32 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile343 680 0 0.26 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile344 799 0 0.25 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile345 272 0 0.22 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile346 2,667 1 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile347 1,054 1 0.34 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile348 850 0 0.24 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile349 460 0 0.30 1.00 3 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile350 527 0 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile351 272 0 0.26 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile352 136 0 0.15 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile353 51 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile354 17 0 0.59 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile355 7,327 4 0.27 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile356 68 0 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile357 136 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile358 170 0 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile377 255 0 0.35 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile383 2,397 1 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile384 1,071 1 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile385 799 0 0.16 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile386 340 0 0.18 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile390 323 0 0.12 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile391 34 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile55 2,075 1 0.21 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile75 1,514 1 0.23 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile76 1,378 1 0.21 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile87 3,066 2 0.20 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile88 1,620 1 0.29 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile99 2,806 2 0.25 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile409 12 0 0.83 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile410 36 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile411 6 0 1.67 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile412 21 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile413 27 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile414 18 0 0.56 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile415 18 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile416 77 0 0.13 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile417 54 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile418 39 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile419 30 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile420 30 0 0.33 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile421 63 0 0.16 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile422 51 0 0.20 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile423 21 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile424 24 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile425 22 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile426 24 0 0.83 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile427 12 0 0.00 1.00 0 0 0 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile428 24 0 0.00 1.00 0 0 0 0.00
EAS_IND /dev/vx/rdsk/racdg/datafile02 165 0 0.36 1.00 0 0 0 0.00
EAS_IND /dev/vx/rdsk/racdg/datafile06 140 0 0.43 1.00 0 0 0 0.00
EIP_DATA /dev/vx/rdsk/racdg/datafile03 384 0 0.18 1.00 0 0 0 0.00
EPM_GD_DATA /dev/vx/rdsk/racdg/datafile378 2,658 1 0.18 1.00 0 0 0 0.00
IDX_EVSAS /dev/vx/rdsk/racdg/datafile39 1 0 10.00 1.00 1 0 0 0.00
IDX_HRMS /dev/vx/rdsk/racdg/datafile110 1 0 0.00 1.00 0 0 0 0.00
IDX_HRMS /dev/vx/rdsk/racdg/datafile77 1 0 10.00 1.00 0 0 0 0.00
IDX_HRMS /dev/vx/rdsk/racdg/datafile85 1 0 10.00 1.00 0 0 0 0.00
IDX_HRMS /dev/vx/rdsk/racdg/datafile86 1 0 10.00 1.00 0 0 0 0.00
IDX_PAMS /dev/vx/rdsk/racdg/datafile26 342 0 0.23 1.00 0 0 0 0.00
LISAPP_DAT /dev/vx/rdsk/racdg/datafile44 1 0 10.00 1.00 1 0 0 0.00
LISAPP_DAT /dev/vx/rdsk/racdg/datafile45 1 0 10.00 1.00 1 0 0 0.00
LISAPP_DAT /dev/vx/rdsk/racdg/datafile46 1 0 10.00 1.00 1 0 0 0.00
LISAPP_DAT /dev/vx/rdsk/racdg/datafile47 1 0 10.00 1.00 1 0 0 0.00
LISAPP_DAT /dev/vx/rdsk/racdg/datafile48 1 0 10.00 1.00 1 0 0 0.00
LISAPP_DAT /dev/vx/rdsk/racdg/datafile49 1 0 10.00 1.00 1 0 0 0.00
LISAPP_DAT /dev/vx/rdsk/racdg/datafile50 1 0 10.00 1.00 1 0 0 0.00
LISAPP_DAT /dev/vx/rdsk/racdg/datafile51 1 0 10.00 1.00 1 0 0 0.00
LISAPP_IDX /dev/vx/rdsk/racdg/datafile40 1 0 10.00 1.00 1 0 0 0.00
LISAPP_IDX /dev/vx/rdsk/racdg/datafile42 1 0 10.00 1.00 1 0 0 0.00
LISAPP_IDX /dev/vx/rdsk/racdg/datafile43 1 0 10.00 1.00 1 0 0 0.00
MOB_DATA /dev/vx/rdsk/racdg/datafile31 198 0 0.20 1.00 0 0 0 0.00
SIED /dev/vx/rdsk/racdg/datafile25 24 0 0.00 1.00 0 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile105 31 0 0.32 1.00 3 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile111 68 0 0.29 1.00 3 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile131 7 0 0.00 1.00 4 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile22 58 0 0.52 1.00 53 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile331 0 0     2 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile56 12 0 3.33 1.00 34 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile71 4 0 5.00 1.00 8 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile89 4 0 5.00 1.00 29 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile90 133 0 0.45 1.00 2 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/sysaux01 11,162 6 0.21 1.00 106 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/appdbc_system03 61 0 0.33 1.00 0 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile328 390 0 0.13 1.00 0 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile341 126 0 0.40 1.00 0 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile97 49 0 0.20 1.00 0 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile98 1 0 10.00 1.00 0 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/system01 6,578 4 0.27 1.00 19 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/system02 55 0 0.55 1.00 0 0 0 0.00
TDEIP_DATA /dev/vx/rdsk/racdg/datafile57 1 0 10.00 1.00 1 0 0 0.00
TDEIP_DATA /dev/vx/rdsk/racdg/datafile58 97 0 0.10 1.00 0 0 0 0.00
TDEIP_DATA /dev/vx/rdsk/racdg/datafile59 1 0 10.00 1.00 0 0 0 0.00
TDEIP_DATA /dev/vx/rdsk/racdg/datafile60 1 0 10.00 1.00 0 0 0 0.00
TDEIP_IND /dev/vx/rdsk/racdg/datafile61 1 0 10.00 1.00 0 0 0 0.00
TDEIP_IND /dev/vx/rdsk/racdg/datafile62 1 0 10.00 1.00 0 0 0 0.00
TDEIP_IND /dev/vx/rdsk/racdg/datafile63 1 0 10.00 1.00 0 0 0 0.00
UNDOTBS1 /dev/vx/rdsk/racdg/datafile381 0 0     28 0 0 0.00
UNDOTBS1 /dev/vx/rdsk/racdg/undotbs01a 0 0     22 0 0 0.00
UNDOTBS1 /dev/vx/rdsk/racdg/undotbs01c 1 0 10.00 1.00 0 0 0 0.00
UNDOTBS2 /dev/vx/rdsk/racdg/datafile64 1 0 10.00 1.00 0 0 0 0.00
UNDOTBS2 /dev/vx/rdsk/racdg/datafile65 1 0 10.00 1.00 0 0 0 0.00
UNDOTBS2 /dev/vx/rdsk/racdg/datafile66 1 0 10.00 1.00 0 0 0 0.00
UNDOTBS2 /dev/vx/rdsk/racdg/undotbs02b 1 0 10.00 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile106 1,627 1 0.25 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile115 907 1 0.20 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile117 3,013 2 0.24 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile139 659 0 0.30 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile21 895 0 0.22 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile330 4,998 3 0.22 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile342 2,118 1 0.30 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile382 750 0 0.23 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile91 169 0 0.30 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile96 3,532 2 0.23 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/users01 3,772 2 0.29 1.00 0 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 2,753,762 93 2,156,878 146,882 418 0 0 0


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

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

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 2,288 0.10 274,417 5.25 1,089,927,714
D 4,576 0.20 548,834 3.05 634,513,632
D 6,864 0.30 823,251 1.63 338,933,206
D 9,152 0.40 1,097,668 1.30 271,026,102
D 11,440 0.50 1,372,085 1.21 250,818,999
D 13,728 0.60 1,646,502 1.14 237,799,238
D 16,016 0.70 1,920,919 1.10 228,896,446
D 18,304 0.80 2,195,336 1.06 219,520,867
D 20,592 0.90 2,469,753 1.03 213,395,896
D 22,880 1.00 2,744,170 1.00 207,839,237
D 22,960 1.00 2,753,765 1.00 207,711,531
D 25,168 1.10 3,018,587 0.98 202,989,500
D 27,456 1.20 3,293,004 0.96 200,284,793
D 29,744 1.30 3,567,421 0.95 198,291,312
D 32,032 1.40 3,841,838 0.95 196,934,925
D 34,320 1.49 4,116,255 0.94 196,152,586
D 36,608 1.59 4,390,672 0.94 195,518,779
D 38,896 1.69 4,665,089 0.94 194,566,096
D 41,184 1.79 4,939,506 0.93 193,065,630
D 43,472 1.89 5,213,923 0.90 187,901,738
D 45,760 1.99 5,488,340 0.82 169,527,274

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 401 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,440 2,779.74 0.00 0.00 0.00 0.00 419,430
E 4,096 1,412 2,780.18 0.00 0.00 0.00 0.00 419,430

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 3,576 3,576 0 0
64K 128K 39 39 0 0
256K 512K 2 2 0 0
512K 1024K 384 384 0 0
1M 2M 61 61 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,022,045.72 956,556.32 94.00 12,164
1,024 0.25 16,022,045.72 859,599.09 95.00 11,068
2,048 0.50 16,022,045.72 254,299.58 98.00 3,043
3,072 0.75 16,022,045.72 29,596.26 100.00 0
4,096 1.00 16,022,045.72 29,596.26 100.00 0
4,915 1.20 16,022,045.72 24,239.42 100.00 0
5,734 1.40 16,022,045.72 24,239.42 100.00 0
6,554 1.60 16,022,045.72 24,239.42 100.00 0
7,373 1.80 16,022,045.72 24,239.42 100.00 0
8,192 2.00 16,022,045.72 24,239.42 100.00 0
12,288 3.00 16,022,045.72 24,239.42 100.00 0
16,384 4.00 16,022,045.72 24,239.42 100.00 0
24,576 6.00 16,022,045.72 24,239.42 100.00 0
32,768 8.00 16,022,045.72 24,239.42 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
2,672 0.19 1,485 60,934 6,814,927 0.99 81,410 4.84 861,573,297
4,064 0.29 2,874 78,982 6,860,360 1.00 35,977 2.14 861,710,033
5,456 0.40 4,263 115,467 6,873,941 1.00 22,396 1.33 861,759,323
6,848 0.50 5,651 130,304 6,877,349 1.00 18,988 1.13 861,766,143
8,240 0.60 7,032 196,436 6,879,514 1.00 16,823 1.00 861,768,656
9,632 0.70 8,408 242,345 6,879,524 1.00 16,813 1.00 861,769,223
11,024 0.80 8,941 258,566 6,879,524 1.00 16,813 1.00 861,769,255
12,416 0.90 9,042 266,190 6,879,524 1.00 16,813 1.00 861,769,281
13,808 1.00 9,042 266,190 6,879,524 1.00 16,813 1.00 861,769,281
15,200 1.10 9,042 266,190 6,879,524 1.00 16,813 1.00 861,769,281
16,592 1.20 9,042 266,190 6,879,524 1.00 16,813 1.00 861,769,281
17,984 1.30 9,042 266,190 6,879,524 1.00 16,813 1.00 861,769,281
19,376 1.40 9,042 266,190 6,879,524 1.00 16,813 1.00 861,769,281
20,768 1.50 9,042 266,190 6,879,524 1.00 16,813 1.00 861,769,281
22,160 1.60 9,042 266,190 6,879,524 1.00 16,813 1.00 861,769,281
23,552 1.71 9,042 266,190 6,879,524 1.00 16,813 1.00 861,769,281
24,944 1.81 9,042 266,190 6,879,524 1.00 16,813 1.00 861,769,281
26,336 1.91 9,042 266,190 6,879,524 1.00 16,813 1.00 861,769,281
27,728 2.01 9,042 266,190 6,879,524 1.00 16,813 1.00 861,769,281

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
9,216 0.25 1,049,619 664,644,192
18,432 0.50 900,428 262,729,597
27,648 0.75 887,490 229,953,306
36,864 1.00 880,184 207,707,801
46,080 1.25 878,864 203,802,894
55,296 1.50 870,238 177,569,399
64,512 1.75 870,238 177,569,399
73,728 2.00 870,238 177,569,399

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,161 4,109 52 1,201 0 0.41
JQ-Job Queue 381 377 4 363 0 0.74
CF-Controlfile Transaction 4,255 4,255 0 96 0 0.89
WF-AWR Flush 20 20 0 10 0 0.50
TA-Instance Undo 7 7 0 6 0 0.33
FB-Format Block 2 2 0 2 0 1.00
TM-DML 1,733 1,733 0 2 0 1.00
JS-Job Scheduler (job run lock - synchronize) 1 1 0 1 0 1.00
TQ-Queue table enqueue (TM contention) 2 2 0 1 0 1.00
DR-Distributed Recovery 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.14 279 0 4 5760/5760 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
05-Dec 14:38 76 129 0 3 5,760 0/0 0/0/0/0/0/0
05-Dec 14:28 0 6 0 0 5,760 0/0 0/0/0/0/0/0
05-Dec 14:18 2 92 0 1 5,760 0/0 0/0/0/0/0/0
05-Dec 14:08 66 52 0 4 5,760 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch 1,201 0.00   0 0  
AWR Alerted Metric Element list 12,289 0.00   0 0  
Consistent RBA 396 0.00   0 0  
FAL request queue 38 0.00   0 0  
FAL subheap alocation 38 0.00   0 0  
FIB s.o chain latch 6 0.00   0 0  
FOB s.o list latch 2,484 0.00   0 0  
JS broadcast add buf latch 411 0.00   0 0  
JS broadcast drop buf latch 411 0.00   0 0  
JS broadcast load blnc latch 358 0.00   0 0  
JS mem alloc latch 3 0.00   0 0  
JS queue access latch 3 0.00   0 0  
JS queue state obj latch 36,758 0.00   0 0  
JS slv state obj latch 1 0.00   0 0  
KCL gc element parent latch 814,881 0.00 0.00 0 66 0.00
KJC message pool free list 1,881 0.00   0 85 0.00
KJCT flow control latch 204,179 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 598 0.00   0 0  
KSXR large replies 122 0.00   0 0  
KTF sga latch 8 0.00   0 386 0.00
KWQMN job cache list latch 751 0.00   0 0  
KWQP Prop Status 207 0.00   0 0  
MQL Tracking Latch 0     0 36 0.00
Memory Management Latch 0     0 598 0.00
Memory Queue 4,305 0.00   0 0  
Memory Queue Subscriber 580 0.00   0 0  
OS process 2,085 0.00   0 0  
OS process allocation 1,990 0.00   0 0  
OS process: request allocation 1,380 0.00   0 0  
PL/SQL warning settings 1,880 0.00   0 0  
SQL memory manager latch 1 0.00   0 597 0.00
SQL memory manager workarea list latch 42,860 0.00   0 0  
Shared B-Tree 10,865 0.00   0 0  
active checkpoint queue latch 2,768 0.04 0.00 0 0  
active service list 13,945 0.01 1.00 0 610 0.00
archive control 33 0.00   0 0  
archive process latch 675 0.00   0 0  
begin backup scn array 1 0.00   0 0  
bq:time manger info latch 520 0.00   0 0  
bufq statistics 1,678 0.00   0 0  
business card 1,166 0.00   0 0  
cache buffer handles 116 0.00   0 0  
cache buffers chains 4,226,136 0.00 0.00 0 318,861 0.00
cache buffers lru chain 103,268 0.00   0 326,818 0.00
channel handle pool latch 1,382 0.00   0 0  
channel operations parent latch 151,760 0.01 0.00 0 0  
checkpoint queue latch 193,366 0.00 0.00 0 529 0.00
client/application info 6,593 0.00   0 0  
commit callback allocation 4 0.00   0 0  
compile environment latch 1,676 0.00   0 0  
datapump attach fixed tables latch 1,675 0.00   0 0  
datapump job fixed tables latch 1,675 0.00   0 0  
dml lock allocation 3,496 0.00   0 0  
dummy allocation 3,351 0.00   0 0  
enqueue hash chains 793,935 0.00 0.00 0 163 0.00
enqueue sob latch 1 0.00   0 0  
enqueues 440,889 0.01 0.00 0 0  
error message lists 589 0.00   0 0  
event group latch 691 0.00   0 0  
file cache latch 1,882 0.00   0 0  
gcs opaque info freelist 166,380 0.15 0.00 0 0  
gcs partitioned table hash 1,129,144 0.00   0 0  
gcs remastering latch 1,389 0.00   0 0  
gcs resource freelist 35,797 0.00   0 12,604 0.00
gcs resource hash 574,258 0.00 0.00 0 0  
gcs shadows freelist 64,736 0.00   0 95,249 0.00
ges caches resource lists 95,452 0.04 0.00 0 25,194 0.00
ges deadlock list 4 0.00   0 0  
ges domain table 366,317 0.00   0 0  
ges enqueue table freelist 368,635 0.00   0 0  
ges group table 552,050 0.00 0.00 0 0  
ges process hash list 4,183 0.00   0 0  
ges process parent latch 741,395 0.00   0 0  
ges process table freelist 1,380 0.00   0 0  
ges resource hash list 560,090 0.15 0.00 0 5,596 0.00
ges resource scan list 16 0.00   0 0  
ges resource table freelist 8,187 0.00   0 0  
ges timeout list 1,580 0.00   0 1,293 0.00
global KZLD latch for mem in SGA 641 0.00   0 0  
global tx hash mapping 10 0.00   0 0  
hash table column usage latch 3 0.00   0 3 0.00
hash table modification latch 48 0.00   0 0  
job workq parent latch 0     0 742 0.00
job_queue_processes parameter latch 389 0.00   0 0  
kks stats 2 0.00   0 0  
kokc descriptor allocation latch 242 0.00   0 0  
ksuosstats global area 121 0.00   0 0  
ktm global data 11 0.00   0 0  
kwqbsn:qsga 4,846 0.00   0 0  
lgwr LWN SCN 956 0.00   0 0  
library cache 79,754 0.34 0.00 0 1 0.00
library cache load lock 2 0.00   0 0  
library cache lock 56,928 0.42 0.00 0 0  
library cache lock allocation 1,649 0.00   0 0  
library cache pin 30,140 0.36 0.00 0 0  
library cache pin allocation 4 0.00   0 0  
list of block allocation 43 0.00   0 0  
loader state object freelist 14 0.00   0 0  
logminer context allocation 1 0.00   0 0  
message pool operations parent latch 4,005 0.00   0 0  
messages 69,349 0.00 0.00 0 0  
mostly latch-free SCN 957 0.10 0.00 0 0  
multiblock read objects 298 0.00   0 0  
name-service memory objects 6,420 0.00   0 0  
name-service namespace bucket 24,535 0.00   0 0  
name-service pending queue 766 0.00   0 0  
name-service request queue 21,280 0.00   0 0  
ncodef allocation latch 29 0.00   0 0  
object queue header heap 112,777 0.00   0 109,596 0.00
object queue header operation 427,375 0.00 0.00 0 0  
object stats modification 1 0.00   0 0  
parallel query alloc buffer 10,948 0.00   0 0  
parallel query stats 1,781 0.00   0 0  
parallel txn reco latch 9,177 0.00   0 0  
parameter list 156 0.00   0 0  
parameter table allocation management 1,674 0.00   0 0  
post/wait queue 850 0.00   0 616 0.00
process allocation 21,384 0.03 0.86 0 690 0.14
process group creation 1,380 0.00   0 0  
process queue 6,485 0.00   0 0  
process queue reference 107,514 0.01 0.00 0 9,523 0.01
qmn state object latch 2 0.00   0 0  
qmn task queue latch 2,264 31.58 0.08 0 0  
query server freelists 5,299 0.00   0 0  
queue sender's info. latch 7,981 1.79 0.00 0 0  
queued dump request 8,954 0.00   0 0  
redo allocation 2,320 0.00   0 2,210 0.00
redo copy 0     0 2,210 1.18
redo writing 5,211 0.02 0.00 0 0  
resmgr group change latch 1,975 0.00   0 0  
resmgr:active threads 3,346 0.00   0 0  
resmgr:actses change group 1,312 0.00   0 0  
resmgr:free threads list 3,345 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 638,156 0.01 0.00 0 0  
rules engine rule set statistics 100 0.00   0 0  
sequence cache 1,962 0.00   0 0  
session allocation 21,541 0.06 0.00 0 0  
session idle bit 42,835 0.00   0 0  
session state list latch 3,360 0.00   0 0  
session switching 29 0.00   0 0  
session timer 609 0.00   0 0  
shared pool 60,014 0.01 0.00 0 0  
shared pool simulator 407,800 0.00   0 0  
simulator hash latch 83,123 0.00   0 0  
simulator lru latch 0     0 83,115 0.00
slave class 3 0.00   0 0  
slave class create 12 8.33 1.00 0 0  
sort extent pool 82 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 8,820 0.00   0 0  
threshold alerts latch 352 0.00   0 0  
transaction allocation 6,035,967 0.00   0 0  
transaction branch allocation 610 0.00   0 0  
undo global data 5,989 0.00   0 0  
user lock 2,585 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
qmn task queue latch 2,264 715 55 660 0 0 0
process allocation 21,384 7 6 1 0 0 0
active service list 13,945 1 1 0 0 0 0
slave class create 12 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KCL gc element parent latch kclhngcbk1 0 1 0
active service list kswssyis: find service entry 1 0 1 0
event range base latch No latch 0 55 55
object queue header operation kcbo_switch_mq_bg 0 2 0
process allocation ksucrp 0 4 0
process allocation ksufap: active procs 0 2 4
slave class create ksvcreate 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
SYS SYSTEM FILE$   TABLE 339,152 15.72
SYS SYSTEM I_FILE#_BLOCK#   INDEX 327,024 15.16
SYS SYSTEM SEG$   TABLE 256,176 11.88
SYS SYSTEM USER$   TABLE 210,576 9.76
SYS SYSTEM TS$   TABLE 205,232 9.51

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SYS SYSAUX WRH$_BUFFER_POOL_STATS_PK   INDEX 3 0.00
SYS SYSAUX WRH$_LATCH 982_112240 TABLE PARTITION 2 0.00
SYS SYSAUX WRH$_PARAMETER 982_112240 TABLE PARTITION 2 0.00
SYS SYSAUX WRH$_SYSMETRIC_SUMMARY   TABLE 2 0.00
SYS SYSAUX WRI$_ADV_PARAMETERS_PK   INDEX 2 0.00

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
SYS SYSTEM SMON_SCN_TIME   TABLE 116 1.49
SYS SYSTEM JOB$   TABLE 103 1.32
WFR EAS_DATA_NEW WFR_BILL_STATUS   TABLE 16 0.21
SYS SYSTEM TAB$   TABLE 14 0.18
SYS SYSTEM SEG$   TABLE 11 0.14

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
SYS SYSTEM JOB$   TABLE 25 10.37
SYS SYSTEM SMON_SCN_TIME_SCN_IDX   INDEX 8 3.32
SYS SYSTEM SMON_SCN_TIME_TIM_IDX   INDEX 7 2.90
SYS SYSTEM SMON_SCN_TIME   TABLE 6 2.49
SYS SYSTEM I_JOB_NEXT   INDEX 4 1.66

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 33 0.00 0   2 1
dc_database_links 1,331 0.00 0   0 26
dc_files 3,250 0.00 0   0 254
dc_global_oids 1,892 0.00 0   0 309
dc_histogram_data 3 0.00 0   0 36,294
dc_histogram_defs 2 0.00 0   0 11,502
dc_object_ids 1,916 0.00 0   0 6,657
dc_objects 875 0.11 0   0 8,757
dc_profiles 652 0.00 0   0 2
dc_rollback_segments 15,070 0.00 0   0 1,313
dc_segments 6 0.00 0   0 2,700
dc_tablespaces 170,207 0.00 0   0 43
dc_usernames 2,679 0.00 0   0 148
dc_users 20,968 0.00 0   0 196
outstanding_alerts 161 98.76 0   0 4

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 4 0 0
dc_objects 1 1 0
outstanding_alerts 318 159 0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 54 0.00 1,384 0.00 0 0
INDEX 1 0.00 11 0.00 0 0
SQL AREA 6,166 0.00 407,229 0.03 61 0
TABLE/PROCEDURE 807 0.00 5,691 0.04 1 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
INDEX 11 0 0 0 0
TABLE/PROCEDURE 2,281 2 1 2 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,506.32   25.53 142.80 1,102 1,102 59 59
  PL/SQL 1,147.54 123.91 20.13 151.19 1,142 1,142 57 57
  SQL 78.04 67.81 2.23 9.07 39 402 35 19
  Freeable 47.88 0.00 1.71 2.41 10   28 28
E Other 1,505.61   25.09 141.46 1,101 1,101 60 60
  PL/SQL 1,148.69 124.03 19.81 150.03 1,143 1,143 58 58
  SQL 78.17 67.92 2.23 9.09 39 402 35 18
  Freeable 47.75 0.00 1.71 2.40 10   28 28

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Coordinator 288,803 0 0
QMON Slaves -353,774 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 0 0 0 0 0
SYS.KUPC$C_1_20161115174523$6687 0 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$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,895,084 2,861,412 3096098 3096098
gcs_shadows 2,102,738 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) 34,115 19.02 18.37
acks for commit broadcast(logical) 35,267 19.67 18.99
broadcast msgs on commit(actual) 393 0.22 0.21
broadcast msgs on commit(logical) 395 0.22 0.21
broadcast msgs on commit(wasted) 17 0.01 0.01
broadcast on commit wait time(ms) 87 0.05 0.05
broadcast on commit waits 359 0.20 0.19
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 74 0.04 0.04
flow control messages sent 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 82,624 46.07 44.49
gcs ast xid 0 0.00 0.00
gcs blocked converts 722 0.40 0.39
gcs blocked cr converts 1,022 0.57 0.55
gcs compatible basts 31 0.02 0.02
gcs compatible cr basts (global) 7 0.00 0.00
gcs compatible cr basts (local) 86,076 48.00 46.35
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 16 0.01 0.01
gcs dbwr write request msgs 49 0.03 0.03
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 861 0.48 0.46
gcs immediate (null) converts 3,029 1.69 1.63
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 9,631 5.37 5.19
gcs indirect ast 13,918 7.76 7.49
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 40 0.02 0.02
gcs msgs process time(ms) 16,898 9.42 9.10
gcs msgs received 363,083 202.47 195.52
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 0 0.00 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 0 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 0 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 0 0.00 0.00
gcs side channel msgs actual 1,991 1.11 1.07
gcs side channel msgs logical 8,058 4.49 4.34
gcs stale cr 74,506 41.55 40.12
gcs undo cr 0 0.00 0.00
gcs write notification msgs 0 0.00 0.00
gcs writes refused 3 0.00 0.00
ges msgs process time(ms) 113 0.06 0.06
ges msgs received 5,880 3.28 3.17
global posts dropped 0 0.00 0.00
global posts queue time 0 0.00 0.00
global posts queued 2 0.00 0.00
global posts requested 2 0.00 0.00
global posts sent 2 0.00 0.00
implicit batch messages received 8,235 4.59 4.43
implicit batch messages sent 1,583 0.88 0.85
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,328 0.74 0.72
messages queue sent actual 16,281 9.08 8.77
messages queue sent logical 17,923 9.99 9.65
messages received actual 177,743 99.12 95.72
messages received logical 368,965 205.75 198.69
messages sent directly 82,264 45.87 44.30
messages sent indirectly 13,034 7.27 7.02
messages sent not implicit batched 14,698 8.20 7.91
messages sent pbatched 36,899 20.58 19.87
msgs causing lmd to send msgs 2,322 1.29 1.25
msgs causing lms(s) to send msgs 891 0.50 0.48
msgs received queue time (ms) 2,064 1.15 1.11
msgs received queued 368,967 205.75 198.69
msgs sent queue time (ms) 459 0.26 0.25
msgs sent queue time on ksxp (ms) 24,095 13.44 12.98
msgs sent queued 17,918 9.99 9.65
msgs sent queued on ksxp 131,412 73.28 70.77
process batch messages received 89,387 49.84 48.14
process batch messages sent 36,644 20.43 19.73


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 995
CURRENT Block Requests 45
Data Block Requests 995
Undo Block Requests 0
TX Block Requests 12
Current Results 1,040
Private results 0
Zero Results 0
Disk Read Results 0
Fail Results 0
Fairness Down Converts 130
Fairness Clears 0
Free GC Elements 0
Flushes 583
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 6
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 172,500 100.00 0.00 0.00 0.00 0.00
Flushes 2 50.00 50.00 0.00 0.00 0.00
Writes 22 86.36 9.09 0.00 0.00 4.55


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 undo header 4,741 99.89 0.04 0.06 78 97.44 2.56 0.00
2 Others 2,682 99.81 0.00 0.19 34 100.00 0.00 0.00
2 data block 374 97.59 2.14 0.27 143 100.00 0.00 0.00


Back to Top

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