kvamdb1$cat awrrpt_1_19654_19655.html AWR Report

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
VAM2306309266vam1110.2.0.4.0YESkvamdb1

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:1965409-Feb-12 00:00:14884 .8
End Snap:1965509-Feb-12 01:00:431214 .7
Elapsed:  60.49 (mins)  
DB Time:  1,667.27 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 5,248M 5,248MStd Block Size: 8K
Shared Pool Size: 1,664M 1,664MLog Buffer: 14,376K

Load Profile

Per SecondPer Transaction
Redo size: 836,605.78 10,014.94
Logical reads: 337,920.82 4,045.22
Block changes: 3,547.34 42.46
Physical reads: 3,425.33 41.00
Physical writes: 146.71 1.76
User calls: 2,428.29 29.07
Parses: 343.16 4.11
Hard parses: 7.34 0.09
Sorts: 40.88 0.49
Logons: 0.92 0.01
Executes: 397.16 4.75
Transactions: 83.54 

% Blocks changed per Read: 1.05Recursive Call %: 21.48
Rollback per transaction %: 0.03Rows per Sort: 12.39

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.14In-memory Sort %: 100.00
Library Hit %: 95.19Soft Parse %: 97.86
Execute to Parse %: 13.60Latch Hit %: 98.61
Parse CPU to Parse Elapsd %: 91.49% Non-Parse CPU: 99.86

Shared Pool Statistics

BeginEnd
Memory Usage %: 56.58 56.46
% SQL with executions>1: 79.25 83.56
% Memory for SQL w/exec>1: 78.71 82.13

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  84,712  84.7 
Backup: sbtwrite2 369,587 7,112 19 7.1Administrative
Backup: sbtbackup 6 2,284 380,749 2.3Administrative
db file sequential read 413,705 1,033 2 1.0User I/O
SQL*Net more data from client 489,091 589 1 .6Network

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 73.30 0.88
Global Cache blocks served: 248.87 2.98
GCS/GES messages received: 2,661.09 31.86
GCS/GES messages sent: 1,452.19 17.38
DBWR Fusion writes: 22.32 0.27
Estd Interconnect traffic (KB) 3,380.81 

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

Buffer access - local cache %: 99.12
Buffer access - remote cache %: 0.02
Buffer access - disk %: 0.86

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1
Avg global cache cr block receive time (ms): 0.7
Avg global cache current block receive time (ms): 0.7
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 %: 1.3
Avg global cache cr block flush time (ms): 0.6
Avg global cache current block pin time (ms): 0.0
Avg global cache current block send time (ms): 0.1
Global cache log flushes for current blocks served %: 0.0
Avg global cache current block flush time (ms): 1.0

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.1
Avg message sent queue time on ksxp (ms): 0.4
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: 50.69
% of indirect sent messages: 47.11
% of flow controlled messages: 2.20


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 99,453.02 99.42
DB CPU 84,712.06 84.68
RMAN cpu time (backup/restore) 284.04 0.28
parse time elapsed 154.10 0.15
hard parse elapsed time 83.07 0.08
connection management call elapsed time 14.55 0.01
PL/SQL execution elapsed time 7.88 0.01
hard parse (sharing criteria) elapsed time 6.15 0.01
sequence load elapsed time 3.71 0.00
hard parse (bind mismatch) elapsed time 0.30 0.00
PL/SQL compilation elapsed time 0.15 0.00
repeated bind elapsed time 0.10 0.00
DB time 100,035.96  
background elapsed time 10,737.31  
background cpu time 1,025.42  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Administrative 369,609 0.00 9,529 26 1.22
User I/O 603,416 0.00 1,143 2 1.99
Network 19,153,176 0.00 922 0 63.18
System I/O 551,537 0.00 239 0 1.82
Cluster 347,137 0.00 206 1 1.15
Commit 303,688 0.00 203 1 1.00
Application 166,263 0.00 89 1 0.55
Other 584,477 92.64 69 0 1.93
Concurrency 62,586 0.20 37 1 0.21
Configuration 1,647 59.62 1 1 0.01

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Backup: sbtwrite2 369,587 0.00 7,112 19 1.22
Backup: sbtbackup 6 0.00 2,284 380749 0.00
db file sequential read 413,705 0.00 1,033 2 1.36
SQL*Net more data from client 489,091 0.00 589 1 1.61
SQL*Net more data to client 10,857,486 0.00 325 0 35.81
log file sync 303,688 0.00 203 1 1.00
log file parallel write 338,738 0.00 141 0 1.12
gc current block 2-way 235,217 0.00 137 1 0.78
Backup: sbtclose2 8 0.00 122 15303 0.00
db file scattered read 54,916 0.00 100 2 0.18
SQL*Net break/reset to client 164,988 0.00 85 1 0.54
reliable message 348 9.20 47 136 0.00
db file parallel write 166,493 0.00 41 0 0.55
log file sequential read 3,216 0.00 37 11 0.01
gc current grant 2-way 55,607 0.00 24 0 0.18
row cache lock 24,481 0.01 19 1 0.08
gc cr block 2-way 27,623 0.00 17 1 0.09
control file sequential read 36,170 0.00 15 0 0.12
gc current grant busy 16,075 0.00 12 1 0.05
library cache lock 24,425 0.00 11 0 0.08
direct path read 132,418 0.00 10 0 0.44
Backup: sbtinfo2 8 0.00 10 1218 0.00
SQL*Net message to client 7,806,599 0.00 9 0 25.75
gc buffer busy 836 0.84 7 8 0.00
gc current block busy 378 0.00 6 15 0.00
Streams AQ: qmn coordinator waiting for slave to start 1 100.00 5 4891 0.00
CGS wait for IPC msg 510,062 99.98 4 0 1.68
enq: FB - contention 4,407 0.00 3 1 0.01
enq: KO - fast object checkpoint 32 9.38 3 83 0.00
enq: TX - index contention 236 0.00 2 10 0.00
RMAN backup & recovery I/O 328 0.00 2 7 0.00
control file parallel write 3,426 0.00 2 1 0.01
cursor: pin S wait on X 152 80.26 2 13 0.00
gc cr block busy 1,657 0.00 2 1 0.01
enq: WF - contention 14 21.43 2 132 0.00
DFS lock handle 2,054 0.00 1 1 0.01
enq: TC - contention 4 50.00 1 297 0.00
gcs log flush sync 2,177 11.07 1 1 0.01
latch free 644 0.00 1 2 0.00
Log archive I/O 3,102 0.00 1 0 0.01
log file switch completion 48 0.00 1 15 0.00
gc current multi block request 6,640 0.00 1 0 0.02
gc cr disk read 1,118 0.00 1 1 0.00
ksxr poll remote instances 44,687 42.11 1 0 0.15
name-service call wait 11 0.00 1 58 0.00
os thread startup 7 0.00 1 85 0.00
enq: TM - contention 1,212 0.00 1 0 0.00
rdbms ipc reply 1,251 0.00 1 0 0.00
latch: cache buffers chains 11,572 0.00 0 0 0.04
enq: TT - contention 698 0.00 0 1 0.00
gc cr grant 2-way 870 0.00 0 0 0.00
gc cr multi block request 1,090 0.00 0 0 0.00
enq: HW - contention 587 0.00 0 1 0.00
library cache pin 770 0.00 0 0 0.00
gc current retry 4 0.00 0 58 0.00
enq: CF - contention 189 0.00 0 1 0.00
gc current split 21 0.00 0 8 0.00
PX Deq: reap credit 12,282 96.85 0 0 0.04
LGWR wait for redo copy 4,125 0.00 0 0 0.01
global enqueue expand wait 9 100.00 0 14 0.00
IPC send completion sync 289 98.62 0 0 0.00
local write wait 84 0.00 0 1 0.00
enq: PS - contention 184 0.00 0 1 0.00
db file parallel read 3 0.00 0 32 0.00
buffer busy waits 886 0.00 0 0 0.00
enq: RS - prevent file delete 103 0.00 0 1 0.00
read by other session 25 0.00 0 3 0.00
PX Deq Credit: send blkd 187 27.81 0 0 0.00
direct path write 2,255 0.00 0 0 0.01
kksfbc child completion 1 100.00 0 52 0.00
latch: shared pool 51 0.00 0 1 0.00
enq: RO - fast object reuse 26 0.00 0 1 0.00
enq: TA - contention 24 0.00 0 1 0.00
latch: session allocation 6 0.00 0 3 0.00
enq: SQ - contention 11 0.00 0 1 0.00
log file single write 64 0.00 0 0 0.00
enq: TX - row lock contention 5 0.00 0 3 0.00
KJC: Wait for msg sends to complete 253 0.00 0 0 0.00
PX Deq: Signal ACK 88 27.27 0 0 0.00
enq: TX - allocate ITL entry 16 0.00 0 1 0.00
library cache load lock 3 0.00 0 4 0.00
enq: US - contention 13 0.00 0 1 0.00
latch: KCL gc element parent latch 106 0.00 0 0 0.00
enq: TX - contention 3 0.00 0 2 0.00
db file single write 10 0.00 0 1 0.00
enq: WL - contention 8 0.00 0 1 0.00
undo segment extension 984 99.80 0 0 0.00
ges inquiry response 5 0.00 0 1 0.00
enq: BR - file shrink 5 0.00 0 1 0.00
buffer deadlock 148 92.57 0 0 0.00
latch: object queue header operation 39 0.00 0 0 0.00
enq: JQ - contention 4 0.00 0 1 0.00
latch: row cache objects 2 0.00 0 1 0.00
enq: CT - state 2 0.00 0 1 0.00
latch: gcs resource hash 7 0.00 0 0 0.00
enq: AF - task serialization 1 0.00 0 1 0.00
gc cr failure 1 0.00 0 1 0.00
latch: cache buffers lru chain 10 0.00 0 0 0.00
ges2 LMON to wake up LMD - mrcvr 5 0.00 0 0 0.00
latch: messages 1 0.00 0 0 0.00
latch: redo allocation 3 0.00 0 0 0.00
cursor: pin S 12 0.00 0 0 0.00
latch: redo writing 1 0.00 0 0 0.00
lock escalate retry 4 100.00 0 0 0.00
latch: enqueue hash chains 1 0.00 0 0 0.00
cursor: mutex X 1 0.00 0 0 0.00
cr request retry 1 100.00 0 0 0.00
latch: ges resource hash list 1 0.00 0 0 0.00
SQL*Net message from client 7,806,265 0.00 3,045,062 390 25.75
jobq slave wait 6,395 49.43 15,519 2427 0.02
gcs remote message 1,964,097 94.41 13,770 7 6.48
PX Idle Wait 2,124 94.11 5,094 2398 0.01
Streams AQ: qmn slave idle wait 135 0.74 3,635 26925 0.00
DIAG idle wait 17,257 0.00 3,550 206 0.06
ASM background timer 2,471 0.00 3,550 1437 0.01
ges remote message 140,376 84.12 3,540 25 0.46
Streams AQ: waiting for messages in the queue 375 96.80 3,540 9439 0.00
Streams AQ: qmn coordinator idle wait 261 50.19 3,535 13544 0.00
class slave wait 983 0.00 3,453 3513 0.00
Streams AQ: waiting for time management or cleanup tasks 12 0.00 3,391 282566 0.00
PX Deq: Execute Reply 5,295 44.85 406 77 0.02
PX Deq: Table Q Normal 95 65.26 152 1604 0.00
KSV master wait 996 0.00 12 12 0.00
PX Deq: Execution Msg 1,003 16.75 2 2 0.00
PX Deq: Parse Reply 77 40.26 1 10 0.00
PX Deq: Join ACK 101 43.56 0 1 0.00
PX Deq: Msg Fragment 225 44.89 0 0 0.00
PX Deq Credit: need buffer 24 58.33 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 261 100.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 338,750 0.00 141 0 1.12
events in waitclass Other 564,574 93.75 60 0 1.86
db file parallel write 166,493 0.00 41 0 0.55
log file sequential read 3,216 0.00 37 11 0.01
row cache lock 1,768 0.11 9 5 0.01
control file sequential read 11,833 0.00 5 0 0.04
control file parallel write 2,516 0.00 2 1 0.01
db file sequential read 287 0.00 1 4 0.00
Log archive I/O 3,102 0.00 1 0 0.01
enq: TM - contention 1,206 0.00 1 0 0.00
direct path read 9,698 0.00 0 0 0.03
gc cr block 2-way 443 0.00 0 1 0.00
os thread startup 3 0.00 0 60 0.00
gc current block 2-way 342 0.00 0 0 0.00
library cache lock 286 0.00 0 0 0.00
direct path write 2,253 0.00 0 0 0.01
gc current grant 2-way 124 0.00 0 0 0.00
gc cr grant 2-way 49 0.00 0 0 0.00
library cache pin 52 0.00 0 0 0.00
log file single write 64 0.00 0 0 0.00
gc current grant busy 21 0.00 0 1 0.00
latch: shared pool 1 0.00 0 8 0.00
enq: RO - fast object reuse 10 0.00 0 0 0.00
gc cr block busy 5 0.00 0 1 0.00
latch: cache buffers chains 68 0.00 0 0 0.00
latch: row cache objects 1 0.00 0 2 0.00
enq: KO - fast object checkpoint 4 0.00 0 0 0.00
buffer busy waits 12 0.00 0 0 0.00
gc cr multi block request 3 0.00 0 0 0.00
latch: redo writing 1 0.00 0 0 0.00
enq: HW - contention 1 0.00 -0 -0 0.00
rdbms ipc message 518,185 11.19 52,554 101 1.71
gcs remote message 1,964,057 94.41 13,770 7 6.48
DIAG idle wait 17,257 0.00 3,550 206 0.06
ASM background timer 2,471 0.00 3,550 1437 0.01
smon timer 781 0.00 3,545 4539 0.00
ges remote message 140,374 84.12 3,540 25 0.46
Streams AQ: qmn coordinator idle wait 261 50.19 3,535 13544 0.00
pmon timer 2,020 99.90 3,529 1747 0.01
class slave wait 980 0.00 3,453 3524 0.00
Streams AQ: waiting for time management or cleanup tasks 12 0.00 3,391 282566 0.00
KSV master wait 212 0.00 0 1 0.00
PX Deq: Parse Reply 30 40.00 0 2 0.00
PX Deq: Join ACK 30 40.00 0 1 0.00
PX Deq: Execute Reply 24 29.17 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 261 100.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 132,787
AVG_IDLE_TIME 230,822
AVG_IOWAIT_TIME 0
AVG_SYS_TIME 18,253
AVG_USER_TIME 114,423
BUSY_TIME 2,126,441
IDLE_TIME 3,695,034
IOWAIT_TIME 0
SYS_TIME 293,918
USER_TIME 1,832,523
LOAD 6
OS_CPU_WAIT_TIME 11,600
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 3,407,872
VM_OUT_BYTES 118,472,704
PHYSICAL_MEMORY_BYTES 16,863,617,024
NUM_CPUS 16

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 83,891.60 69,782.00 12,287,407 96,430,476
vam 16,143.70 14,928.50 133,396 1,129,758,206
SYS$BACKGROUND 0.00 0.00 10,427 213,673

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 457005 45451 8106 520 369623 952929 4868528 9611
vam 133486 68461 48385 2028 0 0 14271382 82608
SYS$BACKGROUND 12941 347 6101 1111 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
8,199 8,235 42 195.20 8.20 c4s83719x437j   select rc.Id as city_id, rn.p...
1,648 1,648 197 8.36 1.65 4a6cx9kqm5r5h   select Identifier, Node, NodeA...
1,509 1,290 97,457 0.02 1.51 anwkyts985z77   delete from fsti_alarm_trans w...
1,504 1,283 97,457 0.02 1.50 gdd5s7nqgssu9   select addition_id from fsti_a...
431 431 66 6.53 0.43 1dg7znt919y4p   Select c.Id As cityid, c.cname...
317 317 74 4.28 0.32 g269uhxq6ubty   Select c.Id As cityid, c.cname...
141 141 69 2.04 0.14 3rn43k5skpggf   SELECT * FROM ( SELE...
131 131 74 1.77 0.13 3vzt7yt9tja88   SELECT * FROM ( SELE...
119 119 74 1.60 0.12 5spcdusnvyta6   Select Count(1) From Res_Servi...
114 114 70 1.63 0.11 9u68cq2puf064   Select Count(1) From Res_Servi...

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
8,235 8,199 42 196.08 8.20 c4s83719x437j   select rc.Id as city_id, rn.p...
1,648 1,648 197 8.37 1.65 4a6cx9kqm5r5h   select Identifier, Node, NodeA...
1,290 1,509 97,457 0.01 1.51 anwkyts985z77   delete from fsti_alarm_trans w...
1,283 1,504 97,457 0.01 1.50 gdd5s7nqgssu9   select addition_id from fsti_a...
431 431 66 6.53 0.43 1dg7znt919y4p   Select c.Id As cityid, c.cname...
317 317 74 4.28 0.32 g269uhxq6ubty   Select c.Id As cityid, c.cname...
141 141 69 2.04 0.14 3rn43k5skpggf   SELECT * FROM ( SELE...
131 131 74 1.76 0.13 3vzt7yt9tja88   SELECT * FROM ( SELE...
119 119 74 1.60 0.12 5spcdusnvyta6   Select Count(1) From Res_Servi...
114 114 70 1.63 0.11 9u68cq2puf064   Select Count(1) From Res_Servi...

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
576,487,441 42 13,725,891.45 47.01 8235.22 8198.51 c4s83719x437j   select rc.Id as city_id, rn.p...
221,130,100 97,457 2,269.00 18.03 1290.20 1509.40 anwkyts985z77   delete from fsti_alarm_trans w...
221,130,071 97,457 2,269.00 18.03 1282.62 1503.58 gdd5s7nqgssu9   select addition_id from fsti_a...
27,066,563 197 137,393.72 2.21 1648.10 1647.79 4a6cx9kqm5r5h   select Identifier, Node, NodeA...
6,747,631 74 91,184.20 0.55 130.57 130.63 3vzt7yt9tja88   SELECT * FROM ( SELE...
6,737,924 74 91,053.03 0.55 118.75 118.75 5spcdusnvyta6   Select Count(1) From Res_Servi...
6,648,800 74 89,848.65 0.54 316.56 316.56 g269uhxq6ubty   Select c.Id As cityid, c.cname...
6,567,219 70 93,817.41 0.54 113.77 113.77 9u68cq2puf064   Select Count(1) From Res_Servi...
6,481,157 69 93,929.81 0.53 140.98 140.98 3rn43k5skpggf   SELECT * FROM ( SELE...
6,473,339 69 93,816.51 0.53 111.70 111.71 c9f8hcmhypvmq   Select severity, count(1) as a...

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
273 1,979 0.14 0.00 39.88 43.97 8cx33vubmug6b   insert into FSTI_ALARM_HISTORY...
118 1 118.00 0.00 0.67 1.65 6bbzx8bac652f JDBC Thin Client SELECT t.*, rownum from (SELEC...
76 307 0.25 0.00 8.42 9.69 5j90cjhgfvsj8   insert into FSTI_ALARM_HISTORY...
72 1,322 0.05 0.00 30.27 33.28 gt22pnh04wan8   UPDATE FSTI_ALARM_CURRENT SET ...
38 13,918 0.00 0.00 9.49 9.53 dxy8awsx01f1x   update PERF_HOST_STORAGE_DAY_M...
34 5,171 0.01 0.00 4.31 4.39 9yuu4zjfdunym   update PERF_INTERFACE_DAY_MIN ...
31 13,781 0.00 0.00 9.35 9.47 98vhmww9mb31y   update PERF_HOST_STORAGE_HOUR_...
30 13,924 0.00 0.00 10.12 10.14 f54tpujxcbnc7   update PERF_HOST_STORAGE_DAY_A...
29 5,117 0.01 0.00 4.01 4.14 43gjvgxaba0uf   update PERF_INTERFACE_HOUR_MIN...
29 9,472 0.00 0.00 4.47 4.48 9827cwgknbxj0   update PERF_ORACLE_ROLLBACK_DA...

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
190,969 354,359 1.86 0.00 0.00 2aadvhw5r7gfc   select name, ip from CONF_APP_...
187,088 186,649 1.00 0.00 0.00 3tjv3vcff9nj1   select net_area_id from CONF_A...
97,457 0 0.00 0.01 0.02 anwkyts985z77   delete from fsti_alarm_trans w...
97,457 1,586 0.02 0.01 0.02 gdd5s7nqgssu9   select addition_id from fsti_a...
45,332 44,908 0.99 0.00 0.00 2jfqzrxhrm93b   select /*+ rule */ c.name, u....
42,000 240 0.01 0.00 0.00 dn76n760vxs8b   Insert Into Prod_Fz_Qyzj_Rtp_S...
20,126 1,038 0.05 0.00 0.00 8r32rk7uxxkdb   select app_type from res_appli...
17,940 17,940 1.00 0.00 0.00 a0u5858g45m8n   select count(1) from dual wher...
14,647 14,643 1.00 0.00 0.00 d2qfc3zqhckw7   select PERF_HOST_STORAGE_SEQ.n...
13,957 13,832 0.99 0.00 0.00 gqrmhgpq33afw   update PERF_HOST_STORAGE_DAY_M...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
191,000 190,969 15.34 2aadvhw5r7gfc   select name, ip from CONF_APP_...
186,860 187,088 15.00 3tjv3vcff9nj1   select net_area_id from CONF_A...
97,457 97,457 7.83 anwkyts985z77   delete from fsti_alarm_trans w...
97,457 97,457 7.83 gdd5s7nqgssu9   select addition_id from fsti_a...
45,332 45,332 3.64 2jfqzrxhrm93b   select /*+ rule */ c.name, u....
42,000 42,000 3.37 dn76n760vxs8b   Insert Into Prod_Fz_Qyzj_Rtp_S...
20,126 20,126 1.62 8r32rk7uxxkdb   select app_type from res_appli...
14,646 14,647 1.18 d2qfc3zqhckw7   select PERF_HOST_STORAGE_SEQ.n...
13,953 13,957 1.12 gqrmhgpq33afw   update PERF_HOST_STORAGE_DAY_M...
13,923 13,924 1.12 f54tpujxcbnc7   update PERF_HOST_STORAGE_DAY_A...
13,915 13,918 1.12 dxy8awsx01f1x   update PERF_HOST_STORAGE_DAY_M...
13,779 13,781 1.11 98vhmww9mb31y   update PERF_HOST_STORAGE_HOUR_...
13,770 13,774 1.11 2uxqqt4t7jwn2   update PERF_HOST_STORAGE_HOUR_...
13,731 13,735 1.10 gaskb581vzwb1   update PERF_HOST_STORAGE_HOUR_...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
2,118,608   0.12 49s332uhbnsma   ** SQL Text Not Available **

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
731 375 1wp11bj429060   update RES_NE set ne_type=:1, ...
493   49s332uhbnsma   ** SQL Text Not Available **
467 5,078 c42pznb7vnkvg   update RES_HOST_PROCESS set ne...
79 48 0fr8zhn4ymu3v   select intcol#, type, flags, l...
76 26 cjk1ffy5kmm5s   select obj# from oid$ where us...
69 307 5j90cjhgfvsj8   insert into FSTI_ALARM_HISTORY...
63 19 g3wrkmxkxzhf2   select cols, audit$, textlengt...
61 1 d1m8g1r0jntpj   begin :vsn_min...
58 48 32bhha21dkv0v   select col#, intcol#, charseti...
56 1 a20djcagc6vp4   declare policy ...
48 6 5wc2915k44m38   select user#, type# from user$...
44 146 9g485acn2n30m   select col#, intcol#, reftyp, ...
44 146 9rfqm06xmuwu0   select intcol#, toid, versio...
44 146 f3g84j69n0tjh   select col#, intcol#, ntab# fr...
37 275 04xtrk7uyhknh   select obj#, type#, ctime, mti...
37 4 5t7dh3thzzrfh   begin dbms_rcvm...
32 1,320 2q93zsrvbdw48   select grantee#, privilege#, n...
32 1,320 6aq34nj2zb2n7   select col#, grantee#, privi...
31 2,118 6769wyy3yf66f   select pos#, intcol#, col#, sp...
29 1,979 8cx33vubmug6b   insert into FSTI_ALARM_HISTORY...
28 21 dpvv2ua0tfjcv   select cachedblk, cachehit, ...
28 1,322 gt22pnh04wan8   UPDATE FSTI_ALARM_CURRENT SET ...
22 180 7tc5u8t3mmzgf   select cachedblk, cachehit, ...

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
3.09 32.45 9.53 9.49 13,918 dxy8awsx01f1x   update PERF_HOST_STORAGE_DAY_M...
3.07 30.87 9.96 9.94 13,735 gaskb581vzwb1   update PERF_HOST_STORAGE_HOUR_...
3.04 29.97 10.14 10.12 13,924 f54tpujxcbnc7   update PERF_HOST_STORAGE_DAY_A...
3.04 31.85 9.54 9.49 13,957 gqrmhgpq33afw   update PERF_HOST_STORAGE_DAY_M...
2.98 31.27 9.53 9.45 13,774 2uxqqt4t7jwn2   update PERF_HOST_STORAGE_HOUR_...
2.98 31.42 9.47 9.35 13,781 98vhmww9mb31y   update PERF_HOST_STORAGE_HOUR_...
2.30 4.51 50.87 50.29 190,969 2aadvhw5r7gfc   select name, ip from CONF_APP_...
1.62 36.95 4.39 4.31 5,171 9yuu4zjfdunym   update PERF_INTERFACE_DAY_MIN ...
1.50 36.14 4.14 4.01 5,117 43gjvgxaba0uf   update PERF_INTERFACE_HOUR_MIN...
1.42 35.24 4.02 3.95 5,150 dg1u46j2f9u7x   update PERF_INTERFACE_DAY_MAX ...
1.41 32.74 4.32 4.31 5,186 ck8ffq53n5hra   update PERF_INTERFACE_DAY_AVG ...
1.40 17.60 7.95 7.25 5,078 c42pznb7vnkvg   update RES_HOST_PROCESS set ne...
1.36 33.18 4.09 4.03 5,127 6pk0ncqyb1pf2   update PERF_INTERFACE_HOUR_MAX...
1.22 2.77 43.97 39.88 1,979 8cx33vubmug6b   insert into FSTI_ALARM_HISTORY...
0.91 2.73 33.28 30.27 1,322 gt22pnh04wan8   UPDATE FSTI_ALARM_CURRENT SET ...
0.90 17.95 5.03 4.95 9,012 9hxy7mq2w4mxc   update PERF_ORACLE_ROLLBACK_HO...
0.89 19.84 4.48 4.47 9,472 9827cwgknbxj0   update PERF_ORACLE_ROLLBACK_DA...
0.88 16.02 5.52 5.16 9,501 gm0926zq11v76   update PERF_ORACLE_ROLLBACK_DA...
0.86 19.69 4.37 4.32 9,010 btsd8mnm607a5   update PERF_ORACLE_ROLLBACK_HO...
0.86 19.39 4.41 4.34 9,014 52rh4tudahskr   update PERF_ORACLE_ROLLBACK_HO...
0.83 18.20 4.54 4.52 9,473 a1wt2f5ha4z3x   update PERF_ORACLE_ROLLBACK_DA...
0.68 2.54 26.76 23.12 1,586 dtka5gpfn2pk3   update fsti_alarm_trans set la...
0.62 0.47 130.63 130.57 74 3vzt7yt9tja88   SELECT * FROM ( SELE...
0.59 0.01 8,198.51 8,235.22 42 c4s83719x437j   select rc.Id as city_id, rn.p...
0.58 2.19 26.69 26.66 187,088 3tjv3vcff9nj1   select net_area_id from CONF_A...
0.57 0.03 1,647.79 1,648.10 197 4a6cx9kqm5r5h   select Identifier, Node, NodeA...
0.53 0.44 118.75 118.75 74 5spcdusnvyta6   Select Count(1) From Res_Servi...
0.49 0.43 113.77 113.77 70 9u68cq2puf064   Select Count(1) From Res_Servi...
0.44 0.43 103.20 103.18 63 2ynctjsphswxs   Select severity, count(1) as a...
0.42 0.30 140.98 140.98 69 3rn43k5skpggf   SELECT * FROM ( SELE...
0.39 1.44 26.92 23.48 1,586 cv89mwmx833bg   select a.IDENTIFIER, a.SERIAL,...
0.34 1.29 26.49 22.98 1,586 grk0hgasghg0a   delete from fsti_alarm_trans w...
0.34 3.52 9.69 8.42 307 5j90cjhgfvsj8   insert into FSTI_ALARM_HISTORY...
0.32 0.45 71.42 71.24 42,000 dn76n760vxs8b   Insert Into Prod_Fz_Qyzj_Rtp_S...
0.28 0.25 111.71 111.70 69 c9f8hcmhypvmq   Select severity, count(1) as a...
0.24 3.43 7.12 7.11 45,332 2jfqzrxhrm93b   select /*+ rule */ c.name, u....
0.20 0.06 316.56 316.56 74 g269uhxq6ubty   Select c.Id As cityid, c.cname...
0.18 0.04 431.01 431.01 66 1dg7znt919y4p   Select c.Id As cityid, c.cname...
0.17 0.01 1,503.58 1,282.62 97,457 gdd5s7nqgssu9   select addition_id from fsti_a...
0.13 0.01 1,509.40 1,290.20 97,457 anwkyts985z77   delete from fsti_alarm_trans w...
0.11 14.04 0.77 0.75 6,396 2ym6hhaq30r73   select type#, blocks, extents,...
0.09 15.95 0.56 0.55 375 1wp11bj429060   update RES_NE set ne_type=:1, ...
0.07 4.46 1.65 0.67 1 6bbzx8bac652f JDBC Thin Client SELECT t.*, rownum from (SELEC...
0.05 7.35 0.73 0.48 108 bd13sdj0ty0q4 SQL Loader Conventional Path Load SELECT 'X' FROM SYS.ALL_OBJECT...
0.03 9.00 0.28 0.21 23 130dvvr5s8bgn   select obj#, dataobj#, part#...
0.01 0.04 23.74 23.69 2 43xtg2pbayp29   DECLARE job BINARY_INTEGER := ...
0.01 0.44 1.75 1.64 1,305 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
0.01 0.43 1.61 1.61 9,739 c0ffn9zgw6rk6   select PERF_ORACLE_ROLLBACK_SE...
0.01 0.24 2.49 2.49 14,647 d2qfc3zqhckw7   select PERF_HOST_STORAGE_SEQ.n...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
04xtrk7uyhknhselect obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0fr8zhn4ymu3vselect intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc
130dvvr5s8bgnselect obj#, dataobj#, part#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabpart$ where bo# = :1 order by part#
1dg7znt919y4pSelect c.Id As cityid, c.cname, p.Id As platformid, n.Id As neid, n.ne_name, p.remark, t.* From res_service_ne_v n, RES_PLATFORM p, FSTI_ALARM_CURRENT t, RES_CITY c, CONF_ALERT_GROUP cp, CONF_ALERT_KEY ck, res_ne_card card, Sec_User_Ne_View sv where n.platform_id=p.id and card.neid(+) = n.ID and n.loopback_ip=t.node and p.city_id=c.Id and t.acknowledged != 1 and Sv.User_Id =327 and n.Id = Sv.Ne_Id and t.clearedtime = to_date('4001-1-1', 'yyyy-mm-dd') and t.alertgroup = cp.id(+) and t.alertkey = ck.key_id(+) and t.sound LIKE '%fjlincm%' and ((remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ')and group_name not in('²É¼¯¸æ¾¯', 'ÐÔÄÜÊý¾ÝÍêÕûÐԸ澯', 'ÒµÎñÊý¾ÝÍêÕûÐԸ澯', 'ÍøÔªÁ¬Í¨ÐԸ澯', '´úÀí¶ËÍøÔªÁ¬Í¨ÐԸ澯') and severity > 4 and remark1 is null ) or (remark not in('ÔöÖµÍø¹Ü') and group_name in ('ÒµÎñÓ¦Óø澯') and severity > 4) or (remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ') and group_name in('É豸ÐÔÄܸ澯') and severity > 4 and Tally > 3) )
1wp11bj429060update RES_NE set ne_type=:1, ne_name=:2, loopback_ip=:3, oss_ip=:4, platform_id=:5, ne_desc=:6, ip_forwarding=:7, device_vendor=:8, device_vendor_model=:9, device_type_id=:10, check_time=:11, os_type=:12, cpu_info=:13, memory_size=:14, domain=:15, ro_community=:16, rw_community=:17, snmp_version=:18, snmp_port=:19, user_name=:20, user_pwd=:21, is_monitor=:22, gather_type=:23, update_time=:24, group_id=:25, integrater_id=:26, stat_time_point=:27, net_area_id=:28 where ID=:29
2aadvhw5r7gfcselect name, ip from CONF_APP_SERVER_CLUSTER where net_area_id=:1 and last_activate_time>sysdate-:2 order by id
2jfqzrxhrm93bselect /*+ rule */ c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
2q93zsrvbdw48select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
2uxqqt4t7jwn2update PERF_HOST_STORAGE_HOUR_MAX set resid=:1, used=:2, free=:3, used_percent=:4, update_time=:5 where ID=:6
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
2ynctjsphswxsSelect severity, count(1) as alcount From res_service_ne_v n, RES_PLATFORM p, FSTI_ALARM_CURRENT t, sec_user_ne_view sv, RES_CITY c, CONF_ALERT_GROUP cp, res_ne_card card where n.platform_id=p.id and card.neid(+) = n.ID and n.loopback_ip=t.node and p.city_id=c.Id and t.alertgroup = cp.id(+) and t.clearedtime = to_date('4001-1-1', 'yyyy-mm-dd') and n.id = sv.ne_id and sv.user_id =672 and ((remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ')and group_name not in('²É¼¯¸æ¾¯', 'ÐÔÄÜÊý¾ÝÍêÕûÐԸ澯', 'ÒµÎñÊý¾ÝÍêÕûÐԸ澯', 'ÍøÔªÁ¬Í¨ÐԸ澯', '´úÀí¶ËÍøÔªÁ¬Í¨ÐԸ澯') and severity > 4 and remark1 is null ) or (remark not in('ÔöÖµÍø¹Ü') and group_name in ('ÒµÎñÓ¦Óø澯') and severity > 4) or (remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ') and group_name in('É豸ÐÔÄܸ澯') and severity > 4 and Tally > 3) ) Group By t.severity Order By t.severity
32bhha21dkv0vselect col#, intcol#, charsetid, charsetform from col$ where obj#=:1 order by intcol# asc
3rn43k5skpggfSELECT * FROM ( SELECT A.*, rownum r FROM (Select cp.group_name, ck.key_name, ck.descs, c.Id As Cityid, c.Cname, p.Id As Platformid, n.Id As Neid, nvl(card.machine_name, n.Ne_Name) as ne_name, p.Platform, To_Char(t.Firstoccurrence, 'yyyy-mm-dd hh24:mi:ss') As First_Time, To_Char(t.Lastoccurrence, 'yyyy-mm-dd hh24:mi:ss') As Last_Time, t.* From Res_Service_Ne_v n, Res_Platform p, Fsti_Alarm_Current t, Res_City c, CONF_ALERT_GROUP cp, sec_user_ne_view sv, CONF_ALERT_KEY ck, res_ne_card card Where n.Platform_Id = p.Id and card.neid(+) = n.ID And n.Loopback_Ip = t.Node And p.City_Id = c.Id and n.id = sv.ne_id and sv.user_id =327 And t.Clearedtime = To_Date('4001-1-1', 'yyyy-mm-dd') and t.alertgroup = cp.id(+) and t.alertkey = ck.key_id(+) and ((remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ')and group_name not in('²É¼¯¸æ¾¯', 'ÐÔÄÜÊý¾ÝÍêÕûÐԸ澯', 'ÒµÎñÊý¾ÝÍêÕûÐԸ澯', 'ÍøÔªÁ¬Í¨ÐԸ澯', '´úÀí¶ËÍøÔªÁ¬Í¨ÐԸ澯') and severity > 4 and remark1 is null ) or (remark not in('ÔöÖµÍø¹Ü') and group_name in ('ÒµÎñÓ¦Óø澯') and severity > 4) or (remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ') and group_name in('É豸ÐÔÄܸ澯') and severity > 4 and Tally > 3) ) order by lastoccurrence desc ) A WHERE rownum <= 7 ) B WHERE r > 0
3tjv3vcff9nj1select net_area_id from CONF_APP_SERVER_CLUSTER where name=:1
3vzt7yt9tja88SELECT * FROM ( SELECT A.*, rownum r FROM (Select cp.group_name, ck.key_name, ck.descs, c.Id As Cityid, c.Cname, p.Id As Platformid, n.Id As Neid, nvl(card.machine_name, n.Ne_Name) as ne_name, p.Platform, To_Char(t.Firstoccurrence, 'yyyy-mm-dd hh24:mi:ss') As First_Time, To_Char(t.Lastoccurrence, 'yyyy-mm-dd hh24:mi:ss') As Last_Time, t.* From Res_Service_Ne_v n, Res_Platform p, Fsti_Alarm_Current t, Res_City c, CONF_ALERT_GROUP cp, sec_user_ne_view sv, CONF_ALERT_KEY ck, res_ne_card card Where n.Platform_Id = p.Id and card.neid(+) = n.ID And n.Loopback_Ip = t.Node And p.City_Id = c.Id and n.id = sv.ne_id and sv.user_id =672 And t.Clearedtime = To_Date('4001-1-1', 'yyyy-mm-dd') and t.alertgroup = cp.id(+) and t.alertkey = ck.key_id(+) and ((remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ')and group_name not in('²É¼¯¸æ¾¯', 'ÐÔÄÜÊý¾ÝÍêÕûÐԸ澯', 'ÒµÎñÊý¾ÝÍêÕûÐԸ澯', 'ÍøÔªÁ¬Í¨ÐԸ澯', '´úÀí¶ËÍøÔªÁ¬Í¨ÐԸ澯') and severity > 4 and remark1 is null ) or (remark not in('ÔöÖµÍø¹Ü') and group_name in ('ÒµÎñÓ¦Óø澯') and severity > 4) or (remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ') and group_name in('É豸ÐÔÄܸ澯') and severity > 4 and Tally > 3) ) order by lastoccurrence desc ) A WHERE rownum <= 7 ) B WHERE r > 0
43gjvgxaba0ufupdate PERF_INTERFACE_HOUR_MIN set resid=:1, in_octets_ratio=:2, in_discards_ratio=:3, in_errors_ratio=:4, out_octets_ratio=:5, out_discards_ratio=:6, out_errors_ratio=:7, admin_status_value=:8, oper_status_value=:9, update_time=:10 where ID=:11
43xtg2pbayp29DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN pack_sm_rep.prc_run_5_min; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
49s332uhbnsma** SQL Text Not Available **
4a6cx9kqm5r5hselect Identifier, Node, NodeAlias, AlertGroup, AlertKey, Severity, OriginalSeverity, Summary, Location, Detail, FirstOccurrence, LastOccurrence, LastModified, Tally, Acknowledged, AcknowledgeTime, ClearedTime, Annotated, SmNotified, Remark1, Remark2, Remark3, Remark4, Remark5 from FSTI_ALARM_CURRENT where Clearedtime=to_date('4001-01-01', 'yyyy-mm-dd')
52rh4tudahskrupdate PERF_ORACLE_ROLLBACK_HOUR_MAX set resid=:1, extents=:2, rs_size=:3, writes=:4, opt_size=:5, update_time=:6 where ID=:7
5j90cjhgfvsj8insert into FSTI_ALARM_HISTORY (ID, Identifier, Node, NodeAlias, AlertGroup, AlertKey, Severity, Summary, Detail, EventTime) values(FSTI_ALARM_HISTORY_ID_SEQ.NEXTVAL, :1, :2, :3, :4, :5, :6, :7, :8, :9)
5spcdusnvyta6Select Count(1) From Res_Service_Ne_v n, Res_Platform p, Fsti_Alarm_Current t, Res_City c, sec_user_ne_view sv, CONF_ALERT_GROUP cp, CONF_ALERT_KEY ck, res_ne_card card Where n.Platform_Id = p.Id and card.neid(+) = n.ID And n.Loopback_Ip = t.Node And p.City_Id = c.Id And t.Clearedtime = To_Date('4001-1-1', 'yyyy-mm-dd') and t.alertgroup = cp.id(+)and t.alertkey = ck.key_id(+) and n.id = sv.ne_id and sv.user_id =672 and ((remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ')and group_name not in('²É¼¯¸æ¾¯', 'ÐÔÄÜÊý¾ÝÍêÕûÐԸ澯', 'ÒµÎñÊý¾ÝÍêÕûÐԸ澯', 'ÍøÔªÁ¬Í¨ÐԸ澯', '´úÀí¶ËÍøÔªÁ¬Í¨ÐԸ澯') and severity > 4 and remark1 is null ) or (remark not in('ÔöÖµÍø¹Ü') and group_name in ('ÒµÎñÓ¦Óø澯') and severity > 4) or (remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ') and group_name in('É豸ÐÔÄܸ澯') and severity > 4 and Tally > 3) )
5t7dh3thzzrfh begin dbms_rcvman.setDatabase(upper(:dbname:dbname_i), :rlgscn, :rlgtime, :fhdbi:fhdbi_i); end;
5wc2915k44m38select user#, type# from user$ where name=:1
6769wyy3yf66fselect pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1
6aq34nj2zb2n7select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6bbzx8bac652f SELECT t.*, rownum from (SELECT nvl((f.bytes)/1024/1024, 0) "remain_size", nvl((f.max_block)/1024/1024, 0) "max_free_block", d.status "status", d.tablespace_name "tablespace_name", d.contents "contents", d.extent_management "extent_management", TO_CHAR(NVL(a.bytes / 1024 / 1024, 0), '99999990.900') "space_size", TO_CHAR(NVL(a.bytes - NVL(f.bytes, 0), 0)/1024/1024, '99999999.999') "used_size", TO_CHAR(NVL(NVL(f.bytes, 0) / a.bytes * 100, 0), '990.00') "free_rate", d.logging "logging", (NVL(d.initial_extent, 0) / 1024) "init_extent", (NVL(d.next_extent, 0) / 1024) "next_extent", NVL(d.min_extents, 0) "min_extents", NVL(d.max_extents, 0) "max_extents", NVL(d.pct_increase, 0) "pct_increase", (NVL(d.min_extlen, 0) / 1024) "min_extlen" FROM sys.dba_tablespaces d, (select tablespace_name, sum(bytes) bytes from sys.dba_data_files group by tablespace_name) a, (select tablespace_name, sum(bytes) bytes, max(bytes) max_block from sys.dba_free_space group by tablespace_name) f WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = f.tablespace_name(+) AND NOT (d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY') UNION ALL SELECT nvl((a.bytes - NVL(t.bytes, 0))/1024/1024, 0) "remain_size", nvl((t.max_block)/1024/1024, 0) "max_free_block", d.status "status", d.tablespace_name "tablespace_name", d.contents "contents", d.extent_management "extent_management", TO_CHAR(NVL(a.bytes / 1024 / 1024, 0), '99999990.900') "space_size(M)", TO_CHAR(NVL (t.bytes, 0)/1024/1024, '99999999.999') "used_size(M)", TO_CHAR(NVL((a.bytes - NVL(t.bytes, 0)) / a.bytes * 100, 0), '990.00') "free_rate", d.logging "logging", (d.initial_extent / 1024) "initial_extent", (d.next_extent / 1024) "next_extent", d.min_extents "min_extents", d.max_extents "max_extents", d.pct_increase "pct_increase", (d.min_extlen / 1024) "min_extlen" FROM sys.dba_tablespaces d, (select tablespace_name, sum(bytes) bytes from sys.dba_temp_files group by tablespace_name) a, (select tablespace_name, sum(bytes_used) bytes, max(bytes_cached) max_block from sys.v_$temp_extent_pool group by tablespace_name) t WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = t.tablespace_name(+) AND d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY') t
6pk0ncqyb1pf2update PERF_INTERFACE_HOUR_MAX set resid=:1, in_octets_ratio=:2, in_discards_ratio=:3, in_errors_ratio=:4, out_octets_ratio=:5, out_discards_ratio=:6, out_errors_ratio=:7, admin_status_value=:8, oper_status_value=:9, update_time=:10 where ID=:11
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7tc5u8t3mmzgfselect cachedblk, cachehit, logicalread from tab_stats$ where obj#=:1
8cx33vubmug6binsert into FSTI_ALARM_HISTORY (ID, Identifier, Node, NodeAlias, AlertGroup, AlertKey, Severity, Summary, Location, Detail, EventTime, object_id) values(FSTI_ALARM_HISTORY_ID_SEQ.NEXTVAL, :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11)
8r32rk7uxxkdbselect app_type from res_application where neid = :1 and ismonitor=1
9827cwgknbxj0update PERF_ORACLE_ROLLBACK_DAY_MIN set resid=:1, extents=:2, rs_size=:3, writes=:4, opt_size=:5, update_time=:6 where ID=:7
98vhmww9mb31yupdate PERF_HOST_STORAGE_HOUR_MIN set resid=:1, used=:2, free=:3, used_percent=:4, update_time=:5 where ID=:6
9g485acn2n30mselect col#, intcol#, reftyp, stabid, expctoid from refcon$ where obj#=:1 order by intcol# asc
9hxy7mq2w4mxcupdate PERF_ORACLE_ROLLBACK_HOUR_AVG set resid=:1, extents=:2, rs_size=:3, writes=:4, opt_size=:5, update_time=:6 where ID=:7
9rfqm06xmuwu0select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltype$ where obj#=:1 order by intcol# asc
9u68cq2puf064Select Count(1) From Res_Service_Ne_v n, Res_Platform p, Fsti_Alarm_Current t, Res_City c, sec_user_ne_view sv, CONF_ALERT_GROUP cp, CONF_ALERT_KEY ck, res_ne_card card Where n.Platform_Id = p.Id and card.neid(+) = n.ID And n.Loopback_Ip = t.Node And p.City_Id = c.Id And t.Clearedtime = To_Date('4001-1-1', 'yyyy-mm-dd') and t.alertgroup = cp.id(+)and t.alertkey = ck.key_id(+) and n.id = sv.ne_id and sv.user_id =327 and ((remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ')and group_name not in('²É¼¯¸æ¾¯', 'ÐÔÄÜÊý¾ÝÍêÕûÐԸ澯', 'ÒµÎñÊý¾ÝÍêÕûÐԸ澯', 'ÍøÔªÁ¬Í¨ÐԸ澯', '´úÀí¶ËÍøÔªÁ¬Í¨ÐԸ澯') and severity > 4 and remark1 is null ) or (remark not in('ÔöÖµÍø¹Ü') and group_name in ('ÒµÎñÓ¦Óø澯') and severity > 4) or (remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ') and group_name in('É豸ÐÔÄܸ澯') and severity > 4 and Tally > 3) )
9yuu4zjfdunymupdate PERF_INTERFACE_DAY_MIN set resid=:1, in_octets_ratio=:2, in_discards_ratio=:3, in_errors_ratio=:4, out_octets_ratio=:5, out_discards_ratio=:6, out_errors_ratio=:7, admin_status_value=:8, oper_status_value=:9, update_time=:10 where ID=:11
a0u5858g45m8nselect count(1) from dual where 1=1 AND 4 = 5
a1wt2f5ha4z3xupdate PERF_ORACLE_ROLLBACK_DAY_MAX set resid=:1, extents=:2, rs_size=:3, writes=:4, opt_size=:5, update_time=:6 where ID=:7
a20djcagc6vp4 declare policy varchar2(512); alldest number := dbms_rcvman.FALSE#; begin if (:alldest > 0) then alldest := dbms_rcvman.TRUE#; end if; dbms_rcvman.getRedoLogDeletionPolicy(policy => policy); dbms_rcvman.setRedoLogDeletionPolicy(policy => policy, alldest => alldest); if (policy like '%TO APPLIED ON STANDBY%') then dbms_rcvman.getSCNForAppliedPolicy( minSCN => :applied_scn); else :applied_scn := 0; end if; end;
anwkyts985z77delete from fsti_alarm_trans where FIRSTOCCURRENCE<sysdate-1/24 and last_send_time is not null
bd13sdj0ty0q4SELECT 'X' FROM SYS.ALL_OBJECTS WHERE OBJECT_NAME = :1 AND OWNER = :2 AND OBJECT_TYPE = 'TABLE'
btsd8mnm607a5update PERF_ORACLE_ROLLBACK_HOUR_MIN set resid=:1, extents=:2, rs_size=:3, writes=:4, opt_size=:5, update_time=:6 where ID=:7
c0ffn9zgw6rk6select PERF_ORACLE_ROLLBACK_SEQ.nextval from dual
c42pznb7vnkvgupdate RES_HOST_PROCESS set neid=:1, pid=:2, ppid=:3, process_name=:4, state=:5, priority=:6, memory_size=:7, threads=:8, handles=:9, percent_cpu=:10, kernel_time=:11, user_time=:12, start_time=:13, total_run_time=:14, total_cpu_time=:15, percent_cpu_time=:16, user_name=:17, command_line=:18, file_path=:19, update_time=:20 where ID=:21
c4s83719x437jselect rc.Id as city_id, rn.platform_id, rn.id as ne_id, osc.node, osc.severity, cic.id category_id, osc.detail from fsti_alarm_current osc, conf_indicator_category cic, conf_alert_key key, res_ne rn, res_platform rp, res_city rc where exists (select ne_id from sec_user_ne_view nv where nv.User_Id = 589 and nv.NE_ID = rn.id) and osc.clearedtime = to_date('4001-1-1', 'yyyy-mm-dd') and lower(key.key_name) = lower(cic.name) and osc.alertkey = key.key_id and rn.loopback_ip = osc.node and rn.platform_id = rp.id and rp.city_id = rc.Id
c9f8hcmhypvmqSelect severity, count(1) as alcount From res_service_ne_v n, RES_PLATFORM p, FSTI_ALARM_CURRENT t, sec_user_ne_view sv, RES_CITY c, CONF_ALERT_GROUP cp, res_ne_card card where n.platform_id=p.id and card.neid(+) = n.ID and n.loopback_ip=t.node and p.city_id=c.Id and t.alertgroup = cp.id(+) and t.clearedtime = to_date('4001-1-1', 'yyyy-mm-dd') and n.id = sv.ne_id and sv.user_id =327 and ((remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ')and group_name not in('²É¼¯¸æ¾¯', 'ÐÔÄÜÊý¾ÝÍêÕûÐԸ澯', 'ÒµÎñÊý¾ÝÍêÕûÐԸ澯', 'ÍøÔªÁ¬Í¨ÐԸ澯', '´úÀí¶ËÍøÔªÁ¬Í¨ÐԸ澯') and severity > 4 and remark1 is null ) or (remark not in('ÔöÖµÍø¹Ü') and group_name in ('ÒµÎñÓ¦Óø澯') and severity > 4) or (remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ') and group_name in('É豸ÐÔÄܸ澯') and severity > 4 and Tally > 3) ) Group By t.severity Order By t.severity
cjk1ffy5kmm5sselect obj# from oid$ where user#=:1 and oid$=:2
ck8ffq53n5hraupdate PERF_INTERFACE_DAY_AVG set resid=:1, in_octets_ratio=:2, in_discards_ratio=:3, in_errors_ratio=:4, out_octets_ratio=:5, out_discards_ratio=:6, out_errors_ratio=:7, admin_status_value=:8, oper_status_value=:9, update_time=:10 where ID=:11
cv89mwmx833bgselect a.IDENTIFIER, a.SERIAL, a.NODE, a.NODEALIAS, a.ALERTGROUP, decode(a.ALERTKEY, null, 'null', a.ALERTKEY) as ALERTKEY, b.ENAME, b.CNAME, a.SUMMARY, to_char(a.FIRSTOCCURRENCE, 'yyyy-mm-dd hh24:mi:ss') as mediation_time, decode(a.detail, null, 'null', a.detail) as detail, to_char(a.last_send_time, 'yyyy-mm-dd hh24:mi:ss') as last_send_time, a.addition_id from fsti_alarm_trans a, CONF_ALERT_LEVEL b where a.addition_id=:1 and a.SEVERITY=b.SEVERITY
d1m8g1r0jntpj begin :vsn_min := dbms_backup_restore.protocol_version_number_min; :rel_min := dbms_backup_restore.protocol_release_number_min; :upd_min := dbms_backup_restore.protocol_update_number_min; :cmp_min := 0; :vsn_max := dbms_backup_restore.protocol_version_number_max; :rel_max := dbms_backup_restore.protocol_release_number_max; :upd_max := dbms_backup_restore.protocol_update_number_max; :cmp_max := 0; :pkg_vsn := to_char(:vsn_max, 'fm00')||'.'|| to_char(:rel_max, 'fm00')||'.'|| to_char(:upd_max, 'fm00')||'.'|| to_char(:cmp_max, 'fm00'); end;
d2qfc3zqhckw7select PERF_HOST_STORAGE_SEQ.nextval from dual
dg1u46j2f9u7xupdate PERF_INTERFACE_DAY_MAX set resid=:1, in_octets_ratio=:2, in_discards_ratio=:3, in_errors_ratio=:4, out_octets_ratio=:5, out_discards_ratio=:6, out_errors_ratio=:7, admin_status_value=:8, oper_status_value=:9, update_time=:10 where ID=:11
dn76n760vxs8bInsert Into Prod_Fz_Qyzj_Rtp_Status(Id, Dsp_Id, Element_Id, Date_Type, Update_Time, Input_Enable, Output_Enable, Audio_Ip, Audio_Port, Audio_Tx_Mt, Audio_Tx_Pt, Audio_Rx_Mt, Input_Agc, Output_Agc, Input_Fixgain, Output_Fixgain, Fraction_Lost, Packet_Lost, Overflows)Values(Prod_Fz_Qyzj_Rtp_Status_Seq.Nextval, :1, :2, :3, to_date(:4, 'YYYY-MM-DD HH24:MI:SS'), :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18)
dpvv2ua0tfjcvselect cachedblk, cachehit, logicalread from ind_stats$ where obj#=:1
dtka5gpfn2pk3update fsti_alarm_trans set last_send_time=sysdate where addition_id=:1
dxy8awsx01f1xupdate PERF_HOST_STORAGE_DAY_MIN set resid=:1, used=:2, free=:3, used_percent=:4, update_time=:5 where ID=:6
f3g84j69n0tjhselect col#, intcol#, ntab# from ntab$ where obj#=:1 order by intcol# asc
f54tpujxcbnc7update PERF_HOST_STORAGE_DAY_AVG set resid=:1, used=:2, free=:3, used_percent=:4, update_time=:5 where ID=:6
g269uhxq6ubtySelect c.Id As cityid, c.cname, p.Id As platformid, n.Id As neid, n.ne_name, p.remark, t.* From res_service_ne_v n, RES_PLATFORM p, FSTI_ALARM_CURRENT t, RES_CITY c, CONF_ALERT_GROUP cp, CONF_ALERT_KEY ck, res_ne_card card, Sec_User_Ne_View sv where n.platform_id=p.id and card.neid(+) = n.ID and n.loopback_ip=t.node and p.city_id=c.Id and t.acknowledged != 1 and Sv.User_Id =672 and n.Id = Sv.Ne_Id and t.clearedtime = to_date('4001-1-1', 'yyyy-mm-dd') and t.alertgroup = cp.id(+) and t.alertkey = ck.key_id(+) and t.sound LIKE '%fjzhangxw%' and ((remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ')and group_name not in('²É¼¯¸æ¾¯', 'ÐÔÄÜÊý¾ÝÍêÕûÐԸ澯', 'ÒµÎñÊý¾ÝÍêÕûÐԸ澯', 'ÍøÔªÁ¬Í¨ÐԸ澯', '´úÀí¶ËÍøÔªÁ¬Í¨ÐԸ澯') and severity > 4 and remark1 is null ) or (remark not in('ÔöÖµÍø¹Ü') and group_name in ('ÒµÎñÓ¦Óø澯') and severity > 4) or (remark not in('ÔöÖµÍø¹Ü', 'CÍøºËÐÄÍø', 'ȪÖÝÒ»¿¨Í¨', 'ȪÖÝPHS¶ÌÐÅÖÐÐÄ') and group_name in('É豸ÐÔÄܸ澯') and severity > 4 and Tally > 3) )
g3wrkmxkxzhf2select cols, audit$, textlength, intcols, property, flags, rowid from view$ where obj#=:1
gaskb581vzwb1update PERF_HOST_STORAGE_HOUR_AVG set resid=:1, used=:2, free=:3, used_percent=:4, update_time=:5 where ID=:6
gdd5s7nqgssu9select addition_id from fsti_alarm_trans where last_send_time is null or (last_send_time<sysdate-1/1440) order by addition_id
gm0926zq11v76update PERF_ORACLE_ROLLBACK_DAY_AVG set resid=:1, extents=:2, rs_size=:3, writes=:4, opt_size=:5, update_time=:6 where ID=:7
gqrmhgpq33afwupdate PERF_HOST_STORAGE_DAY_MAX set resid=:1, used=:2, free=:3, used_percent=:4, update_time=:5 where ID=:6
grk0hgasghg0adelete from fsti_alarm_trans where addition_id=:1
gt22pnh04wan8UPDATE FSTI_ALARM_CURRENT SET NODE = :B9 , NODEALIAS = :B8 , ALERTGROUP = :B7 , ALERTKEY = :B6 , SEVERITY = :B5 , SUMMARY = :B4 , LOCATION = :B3 , DETAIL = :B2 , LASTOCCURRENCE = :B1 , LASTMODIFIED = :B1 , TALLY = TALLY + 1 , SOUND = :B12 , REMARK5 = :B11 WHERE IDENTIFIER = :B10 AND CLEAREDTIME = TO_DATE('4001-01-01', 'yyyy-mm-dd')

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 1,780,478 490.60 5.87
CPU used when call started 1,632,147 449.73 5.38
CR blocks created 3,158 0.87 0.01
Cached Commit SCN referenced 240,568 66.29 0.79
Commit SCN cached 5 0.00 0.00
DB time 11,099,506 3,058.43 36.61
DBWR checkpoint buffers written 440,039 121.25 1.45
DBWR checkpoints 43 0.01 0.00
DBWR fusion writes 80,995 22.32 0.27
DBWR object drop buffers written 1,442 0.40 0.00
DBWR parallel query checkpoint buffers written 14,044 3.87 0.05
DBWR revisited being-written buffer 9 0.00 0.00
DBWR tablespace checkpoint buffers written 999 0.28 0.00
DBWR thread checkpoint buffers written 29,137 8.03 0.10
DBWR transaction table writes 518 0.14 0.00
DBWR undo block writes 136,369 37.58 0.45
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 26 0.01 0.00
DML statements parallelized 0 0.00 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 968 0.27 0.00
PX local messages sent 968 0.27 0.00
PX remote messages recv'd 3,075 0.85 0.01
PX remote messages sent 3,099 0.85 0.01
Parallel operations downgraded to serial 1,152 0.32 0.00
Parallel operations not downgraded 26 0.01 0.00
RowCR - row contention 34 0.01 0.00
RowCR attempts 3,203 0.88 0.01
RowCR hits 3,164 0.87 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 28 0.01 0.00
SQL*Net roundtrips to/from client 7,797,973 2,148.70 25.72
SQL*Net roundtrips to/from dblink 0 0.00 0.00
active txn count during cleanout 138,914 38.28 0.46
application wait time 8,866 2.44 0.03
background checkpoints completed 16 0.00 0.00
background checkpoints started 16 0.00 0.00
background timeouts 15,237 4.20 0.05
branch node splits 67 0.02 0.00
buffer is not pinned count 77,265,003 21,290.10 254.86
buffer is pinned count 430,197,423 118,539.38 1,419.03
bytes received via SQL*Net from client 1,336,355,674 368,228.08 4,408.03
bytes received via SQL*Net from dblink 0 0.00 0.00
bytes sent via SQL*Net to client 29,807,037,441 8,213,223.76 98,319.84
bytes sent via SQL*Net to dblink 0 0.00 0.00
calls to get snapshot scn: kcmgss 2,763,513 761.48 9.12
calls to kcmgas 1,235,695 340.49 4.08
calls to kcmgcs 121,601 33.51 0.40
change write time 7,195 1.98 0.02
cleanout - number of ktugct calls 151,103 41.64 0.50
cleanouts and rollbacks - consistent read gets 434 0.12 0.00
cleanouts only - consistent read gets 1,291 0.36 0.00
cluster key scan block gets 86,475 23.83 0.29
cluster key scans 68,576 18.90 0.23
cluster wait time 20,642 5.69 0.07
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 44,369 12.23 0.15
commit batch/immediate requested 44,369 12.23 0.15
commit cleanout failures: block lost 265 0.07 0.00
commit cleanout failures: buffer being written 18 0.00 0.00
commit cleanout failures: callback failure 12,382 3.41 0.04
commit cleanout failures: cannot pin 142 0.04 0.00
commit cleanouts 1,325,259 365.17 4.37
commit cleanouts successfully completed 1,312,452 361.64 4.33
commit immediate performed 44,369 12.23 0.15
commit immediate requested 44,369 12.23 0.15
commit txn count during cleanout 78,684 21.68 0.26
concurrency wait time 3,658 1.01 0.01
consistent changes 13,508 3.72 0.04
consistent gets 1,210,275,633 333,487.17 3,992.15
consistent gets - examination 3,538,590 975.05 11.67
consistent gets direct 1,856,983 511.69 6.13
consistent gets from cache 1,198,244,174 330,171.94 3,952.46
current blocks converted for CR 0 0.00 0.00
cursor authentications 13,870 3.82 0.05
data blocks consistent reads - undo records applied 11,768 3.24 0.04
db block changes 12,873,827 3,547.34 42.46
db block gets 16,090,429 4,433.66 53.07
db block gets direct 74 0.02 0.00
db block gets from cache 16,088,162 4,433.04 53.07
deferred (CURRENT) block cleanout applications 762,829 210.19 2.52
dirty buffers inspected 1,050 0.29 0.00
drop segment calls in space pressure 0 0.00 0.00
enqueue conversions 1,826 0.50 0.01
enqueue deadlocks 0 0.00 0.00
enqueue releases 960,059 264.54 3.17
enqueue requests 960,096 264.55 3.17
enqueue timeouts 44 0.01 0.00
enqueue waits 7,615 2.10 0.03
exchange deadlocks 174 0.05 0.00
execute count 1,441,336 397.16 4.75
failed probes on index block reclamation 1 0.00 0.00
free buffer inspected 1,379,727 380.18 4.55
free buffer requested 1,077,192 296.82 3.55
gc CPU used by this session 79,186 21.82 0.26
gc blocks lost 0 0.00 0.00
gc cr block build time 154 0.04 0.00
gc cr block flush time 88 0.02 0.00
gc cr block receive time 2,073 0.57 0.01
gc cr block send time 1,036 0.29 0.00
gc cr blocks received 30,348 8.36 0.10
gc cr blocks served 107,131 29.52 0.35
gc current block flush time 31 0.01 0.00
gc current block pin time 1,636 0.45 0.01
gc current block receive time 16,607 4.58 0.05
gc current block send time 7,600 2.09 0.03
gc current blocks received 235,685 64.94 0.78
gc current blocks served 796,074 219.36 2.63
gc local grants 731,356 201.52 2.41
gc remote grants 75,446 20.79 0.25
gcs messages sent 5,143,883 1,417.38 16.97
ges messages sent 126,328 34.81 0.42
global enqueue get time 6,601 1.82 0.02
global enqueue gets async 25,656 7.07 0.08
global enqueue gets sync 629,825 173.55 2.08
global enqueue releases 647,612 178.45 2.14
global undo segment hints helped 0 0.00 0.00
heap block compress 3,031 0.84 0.01
hot buffers moved to head of LRU 289,056 79.65 0.95
immediate (CR) block cleanout applications 1,725 0.48 0.01
immediate (CURRENT) block cleanout applications 49,522 13.65 0.16
index crx upgrade (found) 2,342 0.65 0.01
index crx upgrade (positioned) 236,452 65.15 0.78
index fast full scans (full) 674 0.19 0.00
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 3,400,160 936.90 11.22
index scans kdiixs1 396,130 109.15 1.31
leaf node 90-10 splits 238 0.07 0.00
leaf node splits 15,907 4.38 0.05
lob reads 4,782 1.32 0.02
lob writes 281 0.08 0.00
lob writes unaligned 281 0.08 0.00
local undo segment hints helped 0 0.00 0.00
local undo segment hints were stale 0 0.00 0.00
logons cumulative 3,345 0.92 0.01
messages received 612,700 168.83 2.02
messages sent 612,508 168.77 2.02
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 1,195,394,799 329,386.81 3,943.06
opened cursors cumulative 1,168,626 322.01 3.85
parse count (failures) 4 0.00 0.00
parse count (hard) 26,655 7.34 0.09
parse count (total) 1,245,382 343.16 4.11
parse time cpu 11,999 3.31 0.04
parse time elapsed 13,115 3.61 0.04
physical read IO requests 591,388 162.95 1.95
physical read bytes 19,572,736,000 5,393,198.19 64,561.54
physical read total IO requests 1,476,661 406.89 4.87
physical read total bytes ############### 33,726,031.09 403,731.62
physical read total multi block requests 366,219 100.91 1.21
physical reads 12,431,049 3,425.33 41.00
physical reads cache 522,569 143.99 1.72
physical reads cache prefetch 63,611 17.53 0.21
physical reads direct 1,866,681 514.36 6.16
physical reads direct (lob) 3,216 0.89 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 271,531 74.82 0.90
physical write bytes 4,361,781,248 1,201,873.40 14,387.53
physical write total IO requests 1,003,652 276.55 3.31
physical write total bytes 14,231,140,864 3,921,340.54 46,942.05
physical write total multi block requests 744,113 205.04 2.45
physical writes 532,444 146.71 1.76
physical writes direct 2,327 0.64 0.01
physical writes direct (lob) 0 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 530,117 146.07 1.75
physical writes non checkpoint 472,347 130.15 1.56
pinned buffers inspected 30 0.01 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 108 0.03 0.00
process last non-idle time 3,617 1.00 0.01
queries parallelized 26 0.01 0.00
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 2,411,349 664.44 7.95
recursive cpu usage 6,833,537 1,882.96 22.54
redo blocks read for recovery 0 0.00 0.00
redo blocks written 6,375,836 1,756.84 21.03
redo buffer allocation retries 41 0.01 0.00
redo entries 6,977,064 1,922.51 23.01
redo log space requests 48 0.01 0.00
redo log space wait time 79 0.02 0.00
redo ordering marks 136,179 37.52 0.45
redo size 3,036,169,552 836,605.78 10,014.94
redo subscn max counts 7,857 2.16 0.03
redo synch time 19,437 5.36 0.06
redo synch writes 347,746 95.82 1.15
redo wastage 122,716,712 33,814.16 404.79
redo write time 19,026 5.24 0.06
redo writer latching time 13 0.00 0.00
redo writes 338,910 93.39 1.12
rollback changes - undo records applied 88,806 24.47 0.29
rollbacks only - consistent read gets 2,935 0.81 0.01
rows fetched via callback 536,822 147.92 1.77
session connect time 0 0.00 0.00
session cursor cache hits 1,165,994 321.29 3.85
session logical reads 1,226,366,036 337,920.82 4,045.22
session pga memory 871,192,208 240,053.93 2,873.67
session pga memory max 2,464,716,176 679,143.83 8,129.98
session uga memory 30,231,986,896 8,330,317.08 99,721.56
session uga memory max 2,409,945,968 664,052.09 7,949.31
shared hash latch upgrades - no wait 246,478 67.92 0.81
shared hash latch upgrades - wait 2,395 0.66 0.01
sorts (disk) 0 0.00 0.00
sorts (memory) 148,376 40.88 0.49
sorts (rows) 1,838,384 506.56 6.06
space was found by tune down 0 0.00 0.00
space was not found by tune down 0 0.00 0.00
sql area evicted 26,868 7.40 0.09
sql area purged 8 0.00 0.00
steps of tune down ret. in space pressure 0 0.00 0.00
summed dirty queue length 17,210 4.74 0.06
switch current to new buffer 5,214 1.44 0.02
table fetch by rowid 249,247,593 68,679.29 822.15
table fetch continued row 8,761 2.41 0.03
table scan blocks gotten 532,992,631 146,864.23 1,758.10
table scan rows gotten 12,350,020,793 3,403,004.56 40,737.10
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 411 0.11 0.00
table scans (long tables) 1,405 0.39 0.00
table scans (rowid ranges) 411 0.11 0.00
table scans (short tables) 223,300 61.53 0.74
total number of times SMON posted 781 0.22 0.00
transaction lock background get time 0 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 44,369 12.23 0.15
transaction tables consistent read rollbacks 20 0.01 0.00
transaction tables consistent reads - undo records applied 2,495 0.69 0.01
tune down retentions in space pressure 0 0.00 0.00
undo change vector size 662,325,972 182,501.58 2,184.71
user I/O wait time 114,242 31.48 0.38
user calls 8,812,630 2,428.29 29.07
user commits 303,073 83.51 1.00
user rollbacks 91 0.03 0.00
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 34,415 9.48 0.11
write clones created in background 84 0.02 0.00
write clones created in foreground 9 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 67,888,353 67,953,631
opened cursors current 686 842
workarea memory allocated 7,248 10,010
logons current 884 1,214

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 16 15.87

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)
OPER_DATA 200,092 55 1.83 9.67 154,988 43 724 3.72
REP_DATA 326,168 90 1.33 1.20 149 0 0 0.00
OPER_INDEX_DATA 49,832 14 5.32 1.00 76,950 21 255 10.90
PERF_DATA 2,941 1 5.89 1.00 11,348 3 36 0.28
UNDOTBS1 10 0 0.00 1.00 10,361 3 50 0.00
RES_CONF_DATA 4,380 1 1.16 1.00 5,405 1 432 1.06
PERF_INDEX_DATA 3,677 1 5.27 1.00 6,010 2 114 1.32
ITCOL_INDEX_DATA 1,518 0 5.89 1.00 1,685 0 12 4.17
ITCOL_DATA 707 0 7.23 1.00 1,968 1 0 0.00
ALM_DATA 212 0 4.48 1.00 1,157 0 41 0.49
ALM_INDEX_DATA 242 0 5.66 1.00 1,112 0 2 0.00
SYSAUX 493 0 4.40 1.00 348 0 0 0.00
FLOW_DATA 692 0 1.01 1.00 18 0 0 0.00
SYSTEM 420 0 4.52 1.00 197 0 5 2.00
RES_CONF_INDEX_DATA 114 0 5.44 1.00 362 0 5 0.00
REP_INDEX_DATA 18 0 0.00 1.00 9 0 0 0.00
UNDOTBS2 11 0 0.00 1.00 9 0 6 1.67
FLOW_INDEX_DATA 9 0 0.00 1.00 9 0 0 0.00
USERS 9 0 0.00 1.00 9 0 0 0.00
VAM_DATA 9 0 0.00 1.00 9 0 0 0.00
VAM_INDX_DATA 9 0 0.00 1.00 9 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)
ALM_DATA +DG/vam/datafile/alm_data01.dbf 42 0 5.71 1.00 410 0 20 0.50
ALM_DATA +DG/vam/datafile/alm_data02.dbf 170 0 4.18 1.00 747 0 21 0.48
ALM_INDEX_DATA +DG/vam/datafile/alm_index_data01.dbf 110 0 7.82 1.00 591 0 2 0.00
ALM_INDEX_DATA +DG/vam/datafile/alm_index_data02.dbf 132 0 3.86 1.00 521 0 0 0.00
FLOW_DATA +DG/vam/datafile/flow_data_01.dbf 117 0 0.94 1.00 9 0 0 0.00
FLOW_DATA +DG/vam/datafile/flow_data_02.dbf 575 0 1.03 1.00 9 0 0 0.00
FLOW_INDEX_DATA +DG/vam/datafile/flow_index_data_01.dbf 9 0 0.00 1.00 9 0 0 0.00
ITCOL_DATA +DG/vam/datafile/itcol_data_01.dbf 241 0 8.22 1.00 907 0 0 0.00
ITCOL_DATA +DG/vam/datafile/itcol_data_02.dbf 291 0 6.91 1.00 783 0 0 0.00
ITCOL_DATA +DG/vam/datafile/itcol_data_03.dbf 175 0 6.40 1.00 278 0 0 0.00
ITCOL_INDEX_DATA +DG/vam/datafile/itcol_index_data_01.dbf 208 0 5.67 1.00 244 0 1 0.00
ITCOL_INDEX_DATA +DG/vam/datafile/itcol_index_data_02.dbf 205 0 7.46 1.00 211 0 0 0.00
ITCOL_INDEX_DATA +DG/vam/datafile/itcol_index_data_03.dbf 150 0 6.53 1.00 188 0 1 0.00
ITCOL_INDEX_DATA +DG/vam/datafile/itcol_index_data_04.dbf 207 0 5.94 1.00 255 0 3 16.67
ITCOL_INDEX_DATA +DG/vam/datafile/itcol_index_data_06.dbf 164 0 4.21 1.00 163 0 0 0.00
ITCOL_INDEX_DATA +DG/vam/datafile/itcol_index_data_07.dbf 278 0 6.37 1.00 260 0 3 0.00
ITCOL_INDEX_DATA +DG/vam/datafile/itcol_index_data_08.dbf 168 0 5.18 1.00 221 0 3 0.00
ITCOL_INDEX_DATA +DG/vam/datafile/itcol_index_data_09.dbf 138 0 5.00 1.00 143 0 1 0.00
OPER_DATA +DG/vam/datafile/oper_data01.dbf 1,032 0 2.74 8.42 1,073 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data02.dbf 1,271 0 2.45 7.02 966 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data03.dbf 946 0 2.57 9.09 917 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data04.dbf 994 0 2.53 8.70 915 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data05.dbf 970 0 2.47 8.89 829 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data06.dbf 977 0 2.18 8.84 823 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data07.dbf 914 0 1.91 9.38 816 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data08.dbf 944 0 2.58 9.11 1,094 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data09.dbf 1,231 0 1.61 7.22 815 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data10.dbf 938 0 2.11 9.16 833 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data100.dbf 765 0 1.24 11.01 310 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data101.dbf 1,147 0 2.26 7.67 1,241 0 127 0.87
OPER_DATA +DG/vam/datafile/oper_data102.dbf 1,058 0 2.12 8.24 1,039 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data103.dbf 1,861 1 1.19 11.70 1,072 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data104.dbf 1,100 0 1.95 8.82 1,012 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data105.dbf 1,098 0 1.74 8.83 1,272 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data106.dbf 1,102 0 1.82 8.81 1,082 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data107.dbf 1,082 0 1.86 8.96 1,005 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data108.dbf 1,074 0 1.90 9.02 971 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data109.dbf 1,092 0 1.84 8.88 1,058 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data11.dbf 988 0 2.65 8.75 809 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data110.dbf 1,115 0 2.10 8.72 1,040 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data111.dbf 1,224 0 1.68 8.03 1,072 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data112.dbf 1,075 0 1.78 9.01 1,040 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data113.dbf 1,057 0 1.93 9.15 1,080 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data114.dbf 1,068 0 1.70 9.06 1,008 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data115.dbf 1,042 0 1.63 9.26 1,018 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data116.dbf 1,331 0 1.92 7.47 1,118 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data117.dbf 1,105 0 1.74 8.79 1,082 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data118.dbf 1,153 0 1.73 8.47 1,170 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data119.dbf 1,009 0 1.61 9.53 914 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data12.dbf 969 0 2.31 8.90 831 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data120.dbf 1,165 0 1.76 7.57 627 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data121.dbf 957 0 1.27 9.00 491 0 1 0.00
OPER_DATA +DG/vam/datafile/oper_data122.dbf 749 0 1.35 11.22 398 0 23 0.00
OPER_DATA +DG/vam/datafile/oper_data123.dbf 803 0 1.56 10.53 579 0 118 0.00
OPER_DATA +DG/vam/datafile/oper_data124.dbf 821 0 1.47 10.33 495 0 123 0.00
OPER_DATA +DG/vam/datafile/oper_data125.dbf 807 0 1.46 10.49 450 0 161 0.12
OPER_DATA +DG/vam/datafile/oper_data126.dbf 879 0 1.54 9.71 543 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data127.dbf 805 0 1.52 10.51 415 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data128.dbf 1,639 0 0.80 13.15 401 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data129.dbf 868 0 1.83 10.91 873 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data13.dbf 984 0 2.38 8.78 755 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data130.dbf 857 0 1.46 11.04 856 0 7 5.71
OPER_DATA +DG/vam/datafile/oper_data131.dbf 871 0 1.58 10.89 742 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data132.dbf 840 0 1.43 11.25 854 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data133.dbf 826 0 1.28 11.42 673 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data134.dbf 831 0 1.22 11.36 736 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data135.dbf 823 0 1.18 11.46 809 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data136.dbf 844 0 1.28 11.20 824 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data137.dbf 857 0 1.55 11.05 835 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data138.dbf 835 0 1.23 11.31 813 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data139.dbf 841 0 1.28 11.24 447 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data14.dbf 899 0 2.02 9.52 1,117 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data140.dbf 1,094 0 1.22 8.87 360 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data141.dbf 875 0 1.58 10.84 383 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data142.dbf 857 0 1.51 11.05 412 0 2 0.00
OPER_DATA +DG/vam/datafile/oper_data143.dbf 818 0 1.19 11.53 343 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data144.dbf 1,100 0 2.16 8.83 1,056 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data145.dbf 1,070 0 2.28 9.05 1,263 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data146.dbf 1,024 0 2.25 8.48 1,081 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data147.dbf 1,830 1 1.22 11.89 852 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data148.dbf 1,032 0 2.03 9.33 781 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data149.dbf 1,005 0 2.24 9.56 684 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data15.dbf 1,768 0 1.36 12.27 732 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data150.dbf 1,071 0 1.98 9.04 709 0 2 0.00
OPER_DATA +DG/vam/datafile/oper_data151.dbf 1,014 0 2.01 9.49 670 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data152.dbf 1,023 0 2.08 9.42 1,018 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data153.dbf 1,854 1 1.09 12.26 1,178 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data154.dbf 1,131 0 2.33 9.45 1,062 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data155.dbf 1,094 0 2.09 9.73 676 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data156.dbf 1,135 0 2.04 9.43 733 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data157.dbf 1,146 0 2.07 9.35 755 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data158.dbf 1,106 0 2.05 9.65 742 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data159.dbf 1,084 0 2.10 9.82 739 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data16.dbf 993 0 2.15 9.66 782 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data160.dbf 1,108 0 1.96 9.63 735 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data161.dbf 1,259 0 2.00 8.60 847 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data162.dbf 1,131 0 2.06 9.46 1,014 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data163.dbf 1,147 0 2.13 9.34 1,387 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data164.dbf 1,115 0 2.02 9.58 1,272 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data165.dbf 1,302 0 1.67 8.35 1,138 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data166.dbf 1,095 0 2.20 8.86 803 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data167.dbf 1,107 0 2.20 8.78 840 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data168.dbf 1,035 0 2.28 8.86 880 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data169.dbf 1,077 0 2.31 8.55 931 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data17.dbf 1,016 0 2.13 9.46 772 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data170.dbf 1,068 0 2.14 8.61 878 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data171.dbf 1,327 0 2.01 7.13 886 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data172.dbf 1,053 0 2.44 8.72 835 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data173.dbf 1,278 0 2.24 7.36 899 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data174.dbf 1,042 0 2.19 8.80 827 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data176.dbf 992 0 2.04 9.20 849 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data177.dbf 1,038 0 2.18 8.83 1,406 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data178.dbf 1,021 0 2.18 8.96 1,386 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data179.dbf 1,109 0 2.16 8.16 1,160 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data18.dbf 1,047 0 2.18 9.22 1,057 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data180.dbf 1,029 0 2.40 8.44 1,256 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data181.dbf 1,828 1 1.24 11.90 1,215 0 2 0.00
OPER_DATA +DG/vam/datafile/oper_data182.dbf 1,060 0 2.15 9.11 970 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data183.dbf 1,038 0 1.81 9.28 779 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data184.dbf 1,038 0 1.90 9.29 814 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data185.dbf 1,084 0 2.21 8.94 800 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data186.dbf 1,135 0 1.94 8.58 874 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data187.dbf 1,011 0 1.88 9.51 792 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data188.dbf 1,034 0 2.08 9.32 801 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data189.dbf 1,057 0 2.24 9.14 736 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data19.dbf 978 0 2.02 9.80 786 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data190.dbf 1,223 0 1.98 8.04 710 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data191.dbf 1,031 0 2.19 9.35 780 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data192.dbf 1,024 0 1.75 9.41 995 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data193.dbf 1,001 0 2.07 9.60 747 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data194.dbf 1,156 0 1.92 8.45 781 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data195.dbf 1,051 0 2.04 9.19 800 0 3 0.00
OPER_DATA +DG/vam/datafile/oper_data196.dbf 1,064 0 2.02 9.09 843 0 82 14.51
OPER_DATA +DG/vam/datafile/oper_data197.dbf 1,053 0 2.52 8.27 864 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data198.dbf 1,007 0 2.33 8.60 776 0 73 18.22
OPER_DATA +DG/vam/datafile/oper_data199.dbf 1,009 0 2.28 8.59 743 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data20.dbf 1,335 0 1.66 7.45 823 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data21.dbf 1,010 0 2.11 9.52 1,005 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data22.dbf 997 0 2.06 9.64 994 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data23.dbf 1,045 0 2.11 9.24 1,138 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data24.dbf 1,096 0 2.71 8.86 1,476 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data25.dbf 1,061 0 2.32 9.11 1,180 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data26.dbf 995 0 2.04 9.65 792 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data27.dbf 979 0 1.85 9.79 726 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data28.dbf 998 0 2.07 9.63 724 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data29.dbf 974 0 1.72 9.84 684 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data30.dbf 1,208 0 1.90 8.13 820 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data31.dbf 1,032 0 2.08 9.34 700 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data32.dbf 965 0 2.21 8.93 787 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data33.dbf 922 0 2.19 9.30 771 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data34.dbf 969 0 2.52 8.90 1,038 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data35.dbf 962 0 2.02 8.96 826 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data36.dbf 975 0 2.48 8.85 791 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data37.dbf 988 0 2.28 8.75 915 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data39.dbf 987 0 2.35 8.76 828 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data40.dbf 996 0 2.32 8.69 912 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data41.dbf 1,795 0 1.30 12.10 732 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data42.dbf 1,036 0 2.24 9.30 811 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data43.dbf 984 0 1.99 9.74 716 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data44.dbf 1,021 0 2.21 9.43 939 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data45.dbf 978 0 2.02 9.80 727 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data46.dbf 976 0 1.83 9.82 661 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data47.dbf 969 0 1.87 9.89 636 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data48.dbf 998 0 2.07 9.63 640 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data49.dbf 998 0 2.14 9.63 611 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data50.dbf 975 0 2.01 9.83 745 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data51.dbf 975 0 1.95 9.83 675 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data52.dbf 979 0 1.95 9.79 636 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data53.dbf 933 0 2.05 10.23 562 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data54.dbf 964 0 1.88 9.93 589 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data55.dbf 951 0 1.69 10.05 550 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data56.dbf 931 0 1.77 10.25 531 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data57.dbf 928 0 1.75 10.28 509 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data58.dbf 854 0 1.86 9.96 773 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data59.dbf 909 0 1.99 9.42 714 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data60.dbf 879 0 1.95 9.71 655 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data61.dbf 902 0 1.80 9.49 658 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data62.dbf 915 0 2.07 9.37 683 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data63.dbf 907 0 1.70 9.44 650 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data64.dbf 867 0 1.80 9.83 739 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data65.dbf 898 0 1.99 9.53 780 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data66.dbf 885 0 1.85 9.65 898 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data67.dbf 830 0 1.88 10.22 895 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data68.dbf 835 0 1.68 10.17 675 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data69.dbf 820 0 1.57 10.34 639 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data70.dbf 898 0 1.85 9.53 883 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data71.dbf 815 0 1.56 10.39 710 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data72.dbf 751 0 1.20 11.19 850 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data73.dbf 782 0 1.39 10.79 701 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data74.dbf 872 0 1.83 9.78 692 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data75.dbf 834 0 1.73 10.18 705 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data76.dbf 871 0 1.33 9.79 683 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data77.dbf 1,628 0 0.66 13.24 728 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data78.dbf 866 0 1.44 10.93 565 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data79.dbf 867 0 0.99 10.92 943 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data80.dbf 824 0 1.14 11.45 610 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data81.dbf 853 0 1.35 11.09 529 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data82.dbf 867 0 1.06 10.93 521 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data83.dbf 851 0 1.05 11.12 732 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data84.dbf 801 0 1.02 11.75 452 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data85.dbf 852 0 1.36 11.11 539 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data86.dbf 851 0 1.28 11.12 330 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data87.dbf 782 0 0.88 12.01 308 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data88.dbf 828 0 1.17 11.40 378 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data89.dbf 803 0 1.16 11.72 263 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data90.dbf 1,114 0 0.98 8.73 293 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data91.dbf 795 0 1.19 11.83 277 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data92.dbf 803 0 1.03 11.72 512 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data93.dbf 794 0 1.11 11.84 327 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data94.dbf 792 0 0.93 11.87 280 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data95.dbf 995 0 1.18 8.69 309 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data96.dbf 738 0 1.15 11.37 274 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data97.dbf 736 0 1.13 11.40 278 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data98.dbf 750 0 1.31 11.21 337 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data99.dbf 758 0 1.35 11.10 287 0 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data01.dbf 1,818 1 5.40 1.00 3,174 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data02.dbf 2,381 1 5.18 1.00 3,206 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data03.dbf 2,080 1 5.29 1.00 3,116 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data04.dbf 1,732 0 5.57 1.00 3,133 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data05.dbf 2,206 1 5.37 1.00 3,671 1 116 17.24
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data06.dbf 2,385 1 5.43 1.00 3,394 1 65 11.85
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data07.dbf 2,240 1 5.64 1.00 3,337 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data08.dbf 2,243 1 5.54 1.00 3,148 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data09.dbf 1,784 0 5.34 1.00 3,230 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data10.dbf 1,695 0 5.33 1.00 3,011 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data11.dbf 2,500 1 5.53 1.00 3,518 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data12.dbf 2,875 1 5.28 1.00 4,595 1 74 0.14
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data13.dbf 2,816 1 4.96 1.00 4,367 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data14.dbf 2,550 1 5.15 1.00 4,251 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data15.dbf 2,173 1 5.65 1.00 3,391 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data16.dbf 2,157 1 4.89 1.00 3,347 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data17.dbf 2,267 1 5.17 1.00 3,360 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data18.dbf 2,175 1 5.49 1.00 3,415 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data19.dbf 2,092 1 5.10 1.00 3,312 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data20.dbf 2,435 1 5.71 1.00 3,733 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data21.dbf 2,640 1 5.00 1.00 3,771 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data22.dbf 2,588 1 5.21 1.00 3,470 1 0 0.00
PERF_DATA +DG/vam/datafile/perf_data01.dbf 2,373 1 5.96 1.00 9,600 3 34 0.29
PERF_DATA +DG/vam/datafile/perf_data02.dbf 568 0 5.60 1.00 1,748 0 2 0.00
PERF_INDEX_DATA +DG/vam/datafile/perf_index_data01.dbf 519 0 5.16 1.00 1,030 0 10 8.00
PERF_INDEX_DATA +DG/vam/datafile/perf_index_data02.dbf 1,273 0 5.67 1.00 2,289 1 66 0.30
PERF_INDEX_DATA +DG/vam/datafile/perf_index_data03.dbf 1,034 0 5.27 1.00 1,590 0 34 0.88
PERF_INDEX_DATA +DG/vam/datafile/perf_index_data04.dbf 851 0 4.71 1.00 1,101 0 4 5.00
REP_DATA +DG/vam/datafile/rep_data01.dbf 82,379 23 1.35 1.20 125 0 0 0.00
REP_DATA +DG/vam/datafile/rep_data02.dbf 81,376 22 1.32 1.19 8 0 0 0.00
REP_DATA +DG/vam/datafile/rep_data03.dbf 81,276 22 1.37 1.20 8 0 0 0.00
REP_DATA +DG/vam/datafile/rep_data04.dbf 81,137 22 1.29 1.20 8 0 0 0.00
REP_INDEX_DATA +DG/vam/datafile/rep_index_data01.dbf 18 0 0.00 1.00 9 0 0 0.00
RES_CONF_DATA +DG/vam/datafile/res_conf_data01.dbf 4,380 1 1.16 1.00 5,405 1 432 1.06
RES_CONF_INDEX_DATA +DG/vam/datafile/res_conf_index_data01.dbf 114 0 5.44 1.00 362 0 5 0.00
SYSAUX +DG/vam/datafile/sysaux.262.702665593 493 0 4.40 1.00 348 0 0 0.00
SYSTEM +DG/vam/datafile/system.260.702665563 420 0 4.52 1.00 197 0 5 2.00
UNDOTBS1 +DG/vam/datafile/undotbs1.261.702665567 10 0 0.00 1.00 10,361 3 50 0.00
UNDOTBS2 +DG/vam/datafile/undotbs2.264.702665599 11 0 0.00 1.00 9 0 6 1.67
USERS +DG/vam/datafile/users.265.702665623 9 0 0.00 1.00 9 0 0 0.00
VAM_DATA +DG/vam/datafile/vam_data_01.dbf 9 0 0.00 1.00 9 0 0 0.00
VAM_INDX_DATA +DG/vam/datafile/vam_indx_data_01.dbf 9 0 0.00 1.00 9 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 628,349 100 1,205,011,881 522,567 530,117 0 0 1,686
K 120,897   0 0 0 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 11 44068 514394 737280 737280 2177705  
E 0 14 46681 699449 737280 737280 2284031  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 512 0.10 61,408 8.91 15,366,305,354
D 1,024 0.19 122,816 1.96 3,382,459,465
D 1,536 0.29 184,224 1.30 2,247,993,716
D 2,048 0.39 245,632 1.12 1,931,345,179
D 2,560 0.49 307,040 1.05 1,808,132,308
D 3,072 0.58 368,448 1.02 1,765,308,717
D 3,584 0.68 429,856 1.01 1,746,889,365
D 4,096 0.78 491,264 1.01 1,736,607,631
D 4,608 0.88 552,672 1.00 1,729,976,417
D 5,120 0.97 614,080 1.00 1,725,506,727
D 5,264 1.00 631,351 1.00 1,724,534,651
D 5,632 1.07 675,488 1.00 1,722,019,672
D 6,144 1.17 736,896 1.00 1,719,642,691
D 6,656 1.26 798,304 1.00 1,717,806,882
D 7,168 1.36 859,712 1.00 1,716,291,958
D 7,680 1.46 921,120 0.99 1,714,540,842
D 8,192 1.56 982,528 0.99 1,711,221,966
D 8,704 1.65 1,043,936 0.99 1,704,444,789
D 9,216 1.75 1,105,344 0.98 1,693,936,326
D 9,728 1.85 1,166,752 0.97 1,678,997,513
D 10,240 1.95 1,228,160 0.95 1,642,333,829

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 5,089 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 1,628 390 2,139.75 7.08 0.33 100.00 0.00 166,700
E 1,628 102 3,026.10 9.78 0.32 100.00 0.00 166,700

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 29,471 29,471 0 0
64K 128K 117 117 0 0
128K 256K 1 1 0 0
256K 512K 2 2 0 0
512K 1024K 3,035 3,035 0 0
1M 2M 1,777 1,777 0 0
64M 128M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
204 0.13 6,161,988.61 6,806,434.73 48.00 333,700
407 0.25 6,161,988.61 6,803,682.00 48.00 333,689
814 0.50 6,161,988.61 6,413,247.49 49.00 311,482
1,221 0.75 6,161,988.61 1,089,484.00 85.00 37,005
1,628 1.00 6,161,988.61 227,040.68 96.00 1,209
1,954 1.20 6,161,988.61 139,736.23 98.00 95
2,279 1.40 6,161,988.61 139,115.82 98.00 0
2,605 1.60 6,161,988.61 139,115.82 98.00 0
2,930 1.80 6,161,988.61 139,115.82 98.00 0
3,256 2.00 6,161,988.61 139,115.82 98.00 0
4,884 3.00 6,161,988.61 139,115.82 98.00 0
6,512 4.00 6,161,988.61 139,115.82 98.00 0
9,768 6.00 6,161,988.61 139,115.82 98.00 0
13,024 8.00 6,161,988.61 139,115.82 98.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
256 0.15 209 17,750 19,230,958 0.74 6,828,660 99.73 1,387,221,748
432 0.26 372 30,739 22,933,600 0.88 3,126,018 45.65 1,390,444,625
608 0.37 542 44,824 24,797,383 0.95 1,262,235 18.43 1,392,208,183
784 0.47 715 59,142 25,418,649 0.98 640,969 9.36 1,393,125,276
960 0.58 889 73,620 25,671,538 0.99 388,080 5.67 1,393,637,202
1,136 0.68 1,064 88,297 25,781,406 0.99 278,212 4.06 1,393,956,252
1,312 0.79 1,239 103,608 25,871,582 1.00 188,036 2.75 1,394,183,190
1,488 0.89 1,414 118,653 25,925,614 1.00 134,004 1.96 1,394,360,337
1,664 1.00 1,589 134,186 25,991,146 1.00 68,472 1.00 1,394,500,380
1,840 1.11 1,764 149,880 26,024,171 1.00 35,447 0.52 1,394,612,595
2,016 1.21 1,939 165,132 26,062,095 1.00 1 0.00 1,394,707,971
2,192 1.32 2,114 180,158 26,101,146 1.00 1 0.00 1,394,789,570
2,368 1.42 2,289 195,102 26,127,786 1.01 1 0.00 1,394,857,426
2,544 1.53 2,464 211,681 26,149,531 1.01 1 0.00 1,394,914,994
2,720 1.63 2,639 227,691 26,187,277 1.01 1 0.00 1,394,969,668
2,896 1.74 2,814 243,925 26,192,167 1.01 1 0.00 1,395,015,549
3,072 1.85 2,989 259,781 26,204,749 1.01 1 0.00 1,395,056,287
3,248 1.95 3,164 275,496 26,210,906 1.01 1 0.00 1,395,091,165
3,424 2.06 3,424 303,218 26,216,950 1.01 1 0.00 1,395,124,134

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
2,000 0.25 55,678,320 15,357,672,439
4,000 0.50 11,545,337 1,930,271,831
6,000 0.75 10,678,437 1,764,371,580
8,000 1.00 10,520,628 1,724,534,826
10,000 1.25 10,492,222 1,715,394,791
12,000 1.50 10,423,839 1,692,975,839
14,000 1.75 10,264,978 1,641,412,247
16,000 2.00 10,264,980 1,641,412,247

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

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

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 1,574 6 4
undo block 7 0 1
segment header 3 0 3
1st level bmb 51 0 0
undo header 49 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
FB-Format Block 8,515 8,515 0 4,270 3 0.77
KO-Multiple Object Checkpoint (fast object checkpoint) 116 116 0 28 3 97.07
TX-Transaction (index contention) 743 741 0 235 3 10.70
WF-AWR Flush 25 25 0 11 2 171.45
TC-Tablespace Checkpoint 6 6 0 2 1 609.00
TM-DML 479,975 480,543 0 1,208 1 0.52
TT-Tablespace 2,679 2,679 0 690 1 0.76
HW-Segment High Water Mark 3,889 3,889 0 575 0 0.73
CF-Controlfile Transaction 9,559 9,559 0 189 0 1.13
PS-PX Process Reservation 380 360 20 183 0 0.64
RS-Reclaimable Space (prevent file delete) 230 230 0 103 0 0.91
RO-Multiple Object Reuse (fast object reuse) 84 84 0 26 0 1.23
TA-Instance Undo 24 24 0 24 0 0.96
SQ-Sequence Cache 2,660 2,660 0 11 0 1.55
TX-Transaction (row lock contention) 9 9 0 5 0 2.80
US-Undo Segment 28 28 0 13 0 0.85
TX-Transaction (allocate ITL entry) 20 20 0 16 0 0.63
WL-Being Written Redo Log 17 16 1 8 0 0.88
TX-Transaction 367,662 368,863 0 3 0 2.33
BR-Backup/Restore (file shrink) 10 10 0 5 0 1.00
JQ-Job Queue 28 6 22 4 0 1.00
AF-Advisor Framework (task serialization) 7 7 0 1 0 1.00
CT-Block Change Tracking (state) 2 2 0 2 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Error encountered in Undo Segment Summary While executing SQL statement: Len = 834 select undotsn , sum(undoblks)/1000 undob , sum(txncount) txcnt , max(maxquerylen) maxq , max(maxconcurrency) maxc , min(tuned_undoretention)/60 ||'/'|| max(tuned_undor etention)/60 mintun , sum(ssolderrcnt) ||'/'|| sum(nospaceerrcnt) snolno , sum (unxpstealcnt) ||'/'|| sum(unxpblkrelcnt) ||'/'| | sum(unxpblkreucnt) ||'/'|| sum(expstealcnt) || '/'|| sum(expblkrelcnt) ||'/'|| sum(expblkreucnt) blkst from dba_hist_undostat where dbid = :dbid a nd instance_number = :inst_num and end_time > :b_eitvtim e and begin_time < :e_eitvtime group by undotsn Encountered error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small Continuing to Next Section...


Back to Undo Statistics
Back to Top

Undo Segment Stats

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
End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
09-Feb 01:08 22,690 53,583 2,307 10 456 0/0 0/0/0/0/0/0
09-Feb 00:58 20,895 71,526 1,700 9 459 0/0 0/0/0/0/0/0
09-Feb 00:48 22,654 35,951 1,093 9 463 0/0 0/0/0/0/0/0
09-Feb 00:38 19,787 53,432 4,657 11 466 0/0 0/0/0/0/0/0
09-Feb 00:28 29,611 86,613 4,353 9 466 0/0 0/0/0/0/0/0
09-Feb 00:18 22,715 71,507 3,747 12 469 0/0 0/0/0/0/0/0
09-Feb 00:08 20,729 56,231 3,140 13 470 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 allocation 5,002 0.00   0 0  
ASM db client latch 2,844 0.00   0 0  
ASM map headers 3,043 0.00   0 0  
ASM map load waiting list 893 0.00   0 0  
ASM map operation freelist 2,052 0.00   0 0  
ASM map operation hash table 5,041,691 0.01 0.00 0 0  
ASM network background latch 4,958 0.00   0 0  
AWR Alerted Metric Element list 84,756 0.00   0 0  
Consistent RBA 338,833 0.00 0.00 0 0  
FAL request queue 105 0.00   0 0  
FAL subheap alocation 105 0.00   0 0  
FIB s.o chain latch 833 0.00   0 0  
FOB s.o list latch 48,122 0.05 0.00 0 0  
JS broadcast add buf latch 829 0.00   0 0  
JS broadcast drop buf latch 829 0.00   0 0  
JS broadcast load blnc latch 726 0.00   0 0  
JS mem alloc latch 8 0.00   0 0  
JS queue access latch 8 0.00   0 0  
JS queue state obj latch 21,780 0.00   0 0  
KCL gc element parent latch 4,118,627 0.05 0.05 0 28,621 0.24
KFK SGA context latch 10,204 0.00   0 0  
KFMD SGA 4,135 0.10 0.00 0 0  
KJC message pool free list 147,190 0.53 0.00 0 6,963 0.33
KJCT flow control latch 1,953,031 0.04 0.00 0 0  
KMG MMAN ready and startup request latch 1,209 0.00   0 0  
KSXR large replies 244 0.00   0 0  
KTF sga latch 24 0.00   0 1,160 0.00
KWQMN job cache list latch 291 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 0     0 1,209 0.00
OS process 8,760 0.00   0 0  
OS process allocation 7,379 0.04 0.00 0 0  
OS process: request allocation 6,142 0.00   0 0  
PL/SQL warning settings 3,478 0.00   0 0  
SGA IO buffer pool latch 628 0.16 0.00 0 628 0.64
SQL memory manager latch 1 0.00   0 1,208 0.00
SQL memory manager workarea list latch 103,312 0.00 0.00 0 0  
Shared B-Tree 132 0.00   0 0  
X$KSFQP 59 0.00   0 0  
active checkpoint queue latch 245,181 3.26 0.00 0 0  
active service list 23,088 0.12 0.56 0 3,343 0.03
archive control 117 0.00   0 0  
archive process latch 1,450 0.00   0 0  
begin backup scn array 14 0.00   0 0  
business card 49 0.00   0 0  
cache buffer handles 187,269 0.00 0.00 0 0  
cache buffers chains 2,464,018,642 1.52 0.00 0 6,535,028 0.00
cache buffers lru chain 1,586,373 0.27 0.00 0 81,071,443 0.04
cache table scan latch 0     0 54,906 0.00
channel handle pool latch 6,160 0.03 0.00 0 0  
channel operations parent latch 1,228,871 0.00 0.00 0 0  
checkpoint queue latch 11,239,535 0.01 0.00 0 726,040 0.01
client/application info 19,616 0.00   0 0  
commit callback allocation 22 0.00   0 0  
compile environment latch 3,349 0.00   0 0  
dictionary lookup 8 0.00   0 0  
dml lock allocation 967,170 1.52 0.00 0 0  
dummy allocation 6,368 0.06 0.00 0 0  
enqueue hash chains 2,933,034 0.11 0.00 0 3,383 0.03
enqueues 663,213 0.33 0.00 0 0  
error message lists 199 0.50 0.00 0 0  
event group latch 3,236 0.00   0 0  
file cache latch 4,341 0.00   0 0  
gcs opaque info freelist 1,666,460 0.24 0.00 0 0  
gcs partitioned table hash 41,279,197 0.00   0 642,198 0.00
gcs remastering latch 6,658,825 0.00 64.89 0 0  
gcs resource freelist 4,881,633 0.00 0.00 0 4,615,513 0.00
gcs resource hash 13,988,376 0.04 0.00 0 74 0.00
gcs resource scan list 148 0.00   0 0  
gcs shadows freelist 5,285,264 0.00 0.00 0 5,230,985 0.00
ges caches resource lists 936,803 0.24 0.00 0 581,984 0.07
ges deadlock list 48,558 0.01 0.00 0 17 0.00
ges domain table 1,459,940 0.01 0.00 0 0  
ges enqueue table freelist 1,529,420 0.11 0.00 0 0  
ges group table 1,871,612 0.06 0.00 0 0  
ges process hash list 75,632 0.00   0 0  
ges process parent latch 2,904,591 0.00   0 0  
ges process table freelist 6,142 0.02 0.00 0 0  
ges resource hash list 1,956,919 0.04 0.00 0 132,387 0.04
ges resource scan list 413 0.24 0.00 0 0  
ges resource table freelist 210,738 0.01 0.00 0 0  
ges synchronous data 192 0.00   0 6,571 0.08
ges timeout list 22,876 0.00   0 24,539 0.00
global KZLD latch for mem in SGA 3,229 0.00   0 0  
hash table column usage latch 1,580 0.00   0 144,192 0.00
hash table modification latch 264 0.00   0 0  
job workq parent latch 0     0 12 0.00
job_queue_processes parameter latch 64 0.00   0 0  
kks stats 111,890 0.01 0.00 0 0  
kokc descriptor allocation latch 504 0.00   0 0  
krbmrosl 294 0.00   0 0  
ksuosstats global area 245 0.00   0 0  
ktm global data 837 0.00   0 0  
kwqbsn:qsga 131 0.00   0 0  
lgwr LWN SCN 340,510 0.08 0.00 0 0  
library cache 2,604,737 0.25 0.00 0 78,613 0.04
library cache load lock 14,536 0.01 0.00 0 0  
library cache lock 899,391 0.02 0.00 0 0  
library cache lock allocation 39,590 0.00   0 0  
library cache pin 869,409 0.04 0.00 0 1 0.00
library cache pin allocation 9,412 0.00   0 0  
list of block allocation 85,677 0.00   0 0  
loader state object freelist 8,624 2.27 0.00 0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 9,321 0.00   0 25 0.00
message pool operations parent latch 1,363 0.00   0 0  
messages 1,867,906 0.71 0.00 0 0  
mostly latch-free SCN 348,384 1.47 0.00 0 0  
msg queue 948 0.00   0 948 0.00
multiblock read objects 656,236 0.00 0.00 0 0  
name-service memory objects 29,652 0.00   0 0  
name-service namespace bucket 43,143 0.00   0 0  
name-service namespace objects 2 0.00   0 0  
name-service pending queue 15,018 0.00   0 0  
name-service request 24 8.33 0.00 0 0  
name-service request queue 50,838 0.00 0.00 0 0  
ncodef allocation latch 96 0.00   0 0  
object queue header heap 4,877 0.00   0 4,528 0.00
object queue header operation 4,134,528 0.06 0.02 0 0  
object stats modification 36 2.78 0.00 0 0  
parallel query alloc buffer 1,916 0.00   0 0  
parallel query stats 186 0.54 0.00 0 0  
parallel txn reco latch 19,104 0.00   0 0  
parameter list 20,776 0.00   0 0  
parameter table allocation management 6,368 0.00   0 0  
post/wait queue 451,180 0.01 0.00 0 304,831 0.46
process allocation 33,955 0.12 0.69 1 3,231 0.15
process group creation 6,142 0.00   0 0  
process queue 657 0.15 0.00 0 0  
process queue reference 98,545 0.00 0.00 0 4,945 0.00
qmn state object latch 2 0.00   0 0  
qmn task queue latch 526 0.00   0 0  
query server freelists 499 1.00 0.00 0 0  
query server process 4 0.00   0 4 0.00
queued dump request 17,257 0.00   0 0  
redo allocation 1,048,846 0.22 0.00 0 6,969,371 0.35
redo copy 0     0 6,977,533 0.07
redo writing 1,285,748 0.51 0.00 0 0  
resmgr group change latch 4,183 0.00   0 0  
resmgr:active threads 6,363 0.00   0 0  
resmgr:actses change group 3,341 0.00   0 0  
resmgr:free threads list 6,362 0.14 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 2,893,936 0.08 0.00 0 13,088 0.11
rules engine aggregate statistics 11 0.00   0 0  
rules engine rule set statistics 122 0.00   0 0  
segmented array pool 833 0.00   0 0  
sequence cache 396,489 0.36 0.00 0 0  
session allocation 1,482,180 0.79 0.00 0 0  
session idle bit 18,076,831 0.03 0.00 0 0  
session state list latch 6,920 0.16 0.00 0 0  
session switching 96 0.00   0 0  
session timer 2,019 0.00   0 0  
shared pool 1,113,454 0.06 0.07 0 0  
shared pool simulator 2,188,707 0.01 0.04 0 0  
simulator hash latch 87,480,034 0.01 0.00 0 0  
simulator lru latch 0     0 78,226,114 2.52
slave class 3,039 0.00   0 0  
slave class create 1,940 0.05 1.00 0 0  
sort extent pool 1,041 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 336 0.00   0 0  
temp lob duration state obj allocation 2 0.00   0 0  
temporary table state object allocation 1 0.00   0 0  
threshold alerts latch 611 0.00   0 0  
transaction allocation 698,475 0.00   0 0  
transaction branch allocation 2,020 0.00   0 0  
undo global data 1,447,577 0.04 0.00 0 0  
user lock 12,533 0.17 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 2,464,018,642 37,554,142 11,572 37,543,484 0 0 0
messages 1,867,906 13,288 1 13,287 0 0 0
session allocation 1,482,180 11,654 6 11,648 0 0 0
active checkpoint queue latch 245,181 7,998 1 7,997 0 0 0
redo writing 1,285,748 6,495 1 6,494 0 0 0
gcs resource hash 13,988,376 5,706 7 5,700 0 0 0
mostly latch-free SCN 348,384 5,138 2 5,136 0 0 0
session idle bit 18,076,831 4,895 5 4,890 0 0 0
cache buffers lru chain 1,586,373 4,246 10 4,236 0 0 0
enqueue hash chains 2,933,034 3,331 1 3,330 0 0 0
object queue header operation 4,134,528 2,547 39 2,508 0 0 0
row cache objects 2,893,936 2,454 2 2,452 0 0 0
redo allocation 1,048,846 2,279 3 2,276 0 0 0
KCL gc element parent latch 4,118,627 2,152 106 2,047 0 0 0
ges resource hash list 1,956,919 872 1 871 0 0 0
KJCT flow control latch 1,953,031 747 1 746 0 0 0
shared pool 1,113,454 690 51 641 0 0 0
shared pool simulator 2,188,707 145 6 140 0 0 0
process allocation 33,955 42 29 13 0 0 0
active service list 23,088 27 15 12 0 0 0
gcs remastering latch 6,658,825 9 584 3 0 0 0
slave class create 1,940 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 kclbla 0 98 6
KCL gc element parent latch kclnfndnewm 0 58 47
KCL gc element parent latch kclrwrite 0 52 77
KCL gc element parent latch kclfwrite1 0 38 49
KCL gc element parent latch kclwrt 0 32 19
KCL gc element parent latch kclzcl 0 4 7
KCL gc element parent latch kclplz 0 3 10
KCL gc element parent latch KCLUNLNK 0 2 34
KCL gc element parent latch kclfwrite2 0 2 2
KCL gc element parent latch kcllwr 0 2 2
KCL gc element parent latch kclpdc_3 0 2 5
KCL gc element parent latch kclgrantlk 0 1 8
KCL gc element parent latch kclnfnd 0 1 7
KCL gc element parent latch kclpto_1 0 1 0
KCL gc element parent latch kclrwrite_1 0 1 3
KCL gc element parent latch kclshrsplit 0 1 0
KCL gc element parent latch kclulb 0 1 19
KJCT flow control latch kjctcsnd: send normal message 0 1 1
active checkpoint queue latch kcbbacq: scan active checkpoints 0 1 1
active service list ksws_event: ksws event 0 18 17
active service list kswssyis: find service entry 1 0 1 0
cache buffers chains kcbgtcr: kslbegin excl 0 61,623 58,402
cache buffers chains kcbrls: kslbegin 0 2,413 7,308
cache buffers chains kcbgtcr: fast path 0 876 100
cache buffers chains kclexpand 0 674 1
cache buffers chains kclwrt 0 263 3
cache buffers chains kcbgcur: kslbegin 0 112 61
cache buffers chains kcbget: pin buffer 0 87 59
cache buffers chains kclcls_3 0 68 1
cache buffers chains kcbbxsv 0 62 318
cache buffers chains kcbzwb 0 56 29
cache buffers chains kclbla 0 35 0
cache buffers chains kcbzgb: scan from tail. nowait 0 34 0
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 27 40
cache buffers chains kcbnew: new latch again 0 26 0
cache buffers chains kcbnlc 0 26 25
cache buffers chains kcbbic1 0 8 0
cache buffers chains kcbzib: multi-block read: nowait 0 7 0
cache buffers chains kclebs_1 0 7 0
cache buffers chains kcbchg: kslbegin: call CR func 0 5 42
cache buffers chains kcbget: exchange 0 5 13
cache buffers chains kcbso1: set no access 0 5 3
cache buffers chains kclpred 0 5 0
cache buffers chains kcbget: exchange rls 0 3 9
cache buffers chains kcllwr 0 3 0
cache buffers chains kcbgcur: buf pinned 0 2 0
cache buffers chains kcbsod1 0 2 0
cache buffers chains kcbgkcbcr 0 1 20
cache buffers chains kcbo_write_process 0 1 1
cache buffers chains kcbzib: finish free bufs 0 1 6
cache buffers chains kclfbst_1 0 1 0
cache buffers chains kclpdc_1 0 1 0
cache buffers chains kclpdc_4 0 1 0
cache buffers chains kclwcrs 0 1 1
cache buffers chains kclwlr 0 1 0
cache buffers lru chain kcbzgws 0 8 0
cache buffers lru chain kcbbxsv: move to being written 0 1 4
cache buffers lru chain kclmvreqbg 0 1 0
channel operations parent latch ksrapublish() 0 1 0
enqueue hash chains ksqgtl3 0 1 0
gcs remastering latch 59 0 578 0
gcs remastering latch 69 0 4 0
gcs remastering latch 43 0 2 0
gcs resource hash kjblocalfile_nolock 0 3 1
gcs resource hash kjbmpclose 0 2 0
gcs resource hash kclzcl 0 1 0
gcs resource hash kjbrwrdone reget 0 1 0
ges resource hash list kjrmas1: lookup master node 0 1 0
lgwr LWN SCN kcs023 0 1 0
messages ksaamb: after wakeup 0 1 0
mostly latch-free SCN kcslcu3 0 1 2
object queue header operation kcbo_switch_mq_bg 0 46 62
object queue header operation kcbo_switch_q_bg 0 19 14
object queue header operation kcbw_unlink_q 0 12 6
object queue header operation kcbw_link_q 0 9 3
object queue header operation kcbo_switch_cq 0 4 10
object queue header operation kcbo_write_q 0 3 0
object queue header operation kcbw_unlink_q_bg 0 3 1
object queue header operation kcbo_service_ockpt 0 1 1
process allocation ksufap: active procs 0 12 7
process allocation ksudlp 0 10 10
process allocation ksucrp 0 7 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 3 0
redo writing kcrfw_cal_target_rba 0 1 0
row cache objects kqreqd: reget 0 1 0
row cache objects kqrigt 0 1 0
session allocation ksucri 0 2 0
session allocation ksudlp 0 2 0
session allocation ksuxds: KSUSFCLC not set 0 2 3
session idle bit ksupuc: set busy 0 10 3
session idle bit ksupuc: clear busy 0 3 10
shared pool kghalo 0 41 25
shared pool kghfrunp: alloc: wait 0 3 0
shared pool kghupr1 0 3 17
shared pool kghasp 0 2 1
shared pool kghalp 0 1 4
shared pool kghfre 0 1 4
shared pool simulator kglsim_unpin_simhp 0 6 0
slave class create ksvcreate 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
VAMT ALM_INDEX_DATA FSTI_ALARM_CURRENT_CLEAR_ID   INDEX 591,270,992 48.21
VAMT ALM_DATA FSTI_ALARM_TRANS   TABLE 451,919,168 36.85
VAMT REP_DATA REP_FZ_WAP_TERMINALACCESS   TABLE 75,238,176 6.14
VAMT ALM_DATA FSTI_ALARM_CURRENT   TABLE 60,207,424 4.91
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN P_20120208 INDEX PARTITION 3,624,240 0.30

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
VAMT OPER_DATA PROD_FZ_WAP_WAP20TRAFFIC P_20120208 TABLE PARTITION 1,853,502 14.91
VAMT REP_DATA REP_FZ_WAP_TERMINALACCESS   TABLE 389,662 3.13
VAMT OPER_DATA LOCAL_WAP20_MSISDN P_20120208 INDEX PARTITION 29,194 0.23
VAMT OPER_DATA LOCAL_WAP20_MSISDN P_20120205 INDEX PARTITION 18,561 0.15
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN P_20120208 INDEX PARTITION 18,403 0.15

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN P_20120205 INDEX PARTITION 123 21.24
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN P_20120208 INDEX PARTITION 94 16.23
VAMT OPER_DATA LOCAL_WAP20_MSISDN P_20120208 INDEX PARTITION 87 15.03
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN P_20120209 INDEX PARTITION 30 5.18
VAMT OPER_DATA LOCAL_WAP20_MSISDN P_20120205 INDEX PARTITION 29 5.01

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
VAMT OPER_DATA LOCAL_WAP20_MSISDN P_20120208 INDEX PARTITION 4 44.44
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN P_20120205 INDEX PARTITION 1 11.11
VAMT PERF_INDEX_DATA PK_PERF_HOST_SH_AVG_ID   INDEX 1 11.11
VAMT PERF_INDEX_DATA UK_PERF_HOST_SH_MIN_RES_UP   INDEX 1 11.11
VAMT PERF_INDEX_DATA UK_PERF_INTERFACE_H_MIN_RES_UP   INDEX 1 11.11

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
VAMT OPER_DATA PROD_FZ_WAP_WAP20TRAFFIC P_20120205 TABLE PARTITION 428 53.90
VAMT OPER_DATA PROD_FZ_ISMP_TRAFFIC IC20120210 TABLE PARTITION 91 11.46
VAMT OPER_DATA PK_PROD_RES_NE_DETECT_LOG   INDEX 68 8.56
VAMT OPER_INDEX_DATA UK_PROD_RES_NE_DETECT_LOG   INDEX 57 7.18
VAMT OPER_INDEX_DATA LC_INDEX_PROD_FZ_MMSC_LOG_SNDR OG20120210 INDEX PARTITION 25 3.15

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
VAMT RES_CONF_DATA CONF_APP_SERVER_CLUSTER   TABLE 306 47.81
VAMT OPER_INDEX_DATA UK_PROD_RES_NE_DETECT_LOG   INDEX 122 19.06
VAMT OPER_DATA PK_PROD_RES_NE_DETECT_LOG   INDEX 88 13.75
VAMT ALM_DATA FSTI_ALARM_CURRENT   TABLE 40 6.25
VAMT OPER_DATA PROD_FZ_ISMP_TRAFFIC IC20120210 TABLE PARTITION 21 3.28

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
VAMT ALM_DATA FSTI_ALARM_CURRENT   TABLE 4,108 13.54
VAMT RES_CONF_DATA CONF_APP_SERVER_CLUSTER   TABLE 3,532 11.64
VAMT RES_CONF_DATA RES_NE   TABLE 3,506 11.55
VAMT RES_CONF_DATA RES_ORACLE_SESSION   TABLE 1,279 4.21
VAMT RES_CONF_DATA RES_HOST_STORAGE   TABLE 1,219 4.02

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
VAMT OPER_DATA LOCAL_WAP20_MSISDN P_20120208 INDEX PARTITION 61,796 26.22
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN P_20120208 INDEX PARTITION 41,657 17.67
VAMT OPER_DATA LOCAL_WAP20_MSISDN P_20120204 INDEX PARTITION 7,781 3.30
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN P_20120209 INDEX PARTITION 5,409 2.30
VAMT OPER_DATA LOCAL_WAP20_MSISDN P_20120205 INDEX PARTITION 5,346 2.27

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 66 0.00 0   2 1
dc_database_links 6,460 0.00 0   0 1
dc_files 3,084 58.33 0   0 257
dc_global_oids 357 7.28 0   0 5
dc_histogram_data 143,119 3.89 0   0 1,246
dc_histogram_defs 108,589 9.04 0   0 1,588
dc_object_grants 4 50.00 0   0 2
dc_object_ids 143,766 2.35 0   0 701
dc_objects 40,282 2.01 0   8 816
dc_profiles 3,235 0.00 0   0 1
dc_rollback_segments 46,733 0.00 0   0 799
dc_segments 105,518 4.72 0   280 570
dc_sequences 2,767 13.73 0   2,767 68
dc_tablespace_quotas 270 28.52 0   270 1
dc_tablespaces 165,860 0.04 0   0 22
dc_usernames 18,120 0.08 0   0 6
dc_users 231,735 0.01 0   0 35
outstanding_alerts 277 94.58 0   11 0

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 4 0 0
dc_files 1,799 0 1,799
dc_global_oids 26 0 26
dc_histogram_defs 9,820 0 10,126
dc_object_ids 3,396 1 3,623
dc_objects 823 2 783
dc_segments 5,469 68 5,075
dc_sequences 5,534 222 164
dc_tablespace_quotas 540 75 2
dc_tablespaces 65 0 65
dc_usernames 15 0 14
dc_users 15 0 14
outstanding_alerts 545 0 256

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 602 1.00 5,666 0.21 6 0
CLUSTER 115 3.48 221 7.24 12 0
INDEX 87 34.48 181 29.28 23 0
SQL AREA 116,665 21.67 1,605,330 5.75 16,188 2,331
TABLE/PROCEDURE 38,916 1.84 453,658 1.57 2,667 0
TRIGGER 555 0.18 5,480 0.38 20 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
CLUSTER 221 4 4 4 0
INDEX 181 44 31 34 0
TABLE/PROCEDURE 118,298 684 577 492 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,886.13   2.13 4.24 52 63 885 885
  SQL 142.34 73.91 0.16 0.87 10 228 865 250
  Freeable 106.13 0.00 0.62 0.75 7   170 170
  PL/SQL 5.33 2.05 0.01 0.02 0 0 885 885
E Other 2,727.14   2.24 3.52 32 64 1,215 1,215
  SQL 148.41 78.34 0.12 0.76 10 228 1,195 430
  Freeable 144.00 0.00 0.64 0.78 6   226 226
  PL/SQL 6.80 2.62 0.01 0.01 0 0 1,215 1,215

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 6,559,891,456  
Fixed Size 2,053,928  
Redo Buffers 14,721,024  
Variable Size 1,811,941,592  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 16.00 16.00 0.00
large ASM map operations hashta 0.38 0.38 0.00
large PX msg pool 1.15 1.15 0.00
large free memory 30.47 30.47 0.00
shared ASH buffers 29.00 29.00 0.00
shared ASM extent pointer array 26.87 26.42 -1.66
shared CCursor 56.07 54.70 -2.45
shared Cursor Stats 24.43 24.43 0.00
shared KGH: NO ACCESS 87.54 87.54 0.00
shared PCursor 37.51 36.69 -2.20
shared db_block_hash_buckets 45.00 45.00 0.00
shared event statistics per sess 19.51 19.51 0.00
shared free memory 722.55 724.50 0.27
shared gcs resources 131.31 131.31 0.00
shared gcs shadows 78.06 78.06 0.00
shared ges enqueues 27.63 27.63 0.00
shared kglsim heap 32.82 32.82 0.00
shared kglsim object batch 61.13 61.13 0.00
shared library cache 73.92 73.76 -0.22
shared sql area 69.84 66.88 -4.23
shared trace buffer 23.50 23.50 0.00
streams free memory 16.00 16.00 0.00
  buffer_cache 6,256.00 6,256.00 0.00
  fixed_sga 1.96 1.96 0.00
  log_buffer 14.04 14.04 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 129,723 0 0
QMON Slaves -19,992 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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R 11 0 0 30 57

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 326,256 724,104 843599 843599
gcs_shadows 487,305 784,704 843599 843599


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_immediate_commit_propagation FALSE   
audit_file_dest /oracle/app/oracle/admin/vam/adump   
background_dump_dest /oracle/app/oracle/admin/vam/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.3.0   
control_files +DG/vam/controlfile/current.256.702665559, +RECOVERYDEST/vam/controlfile/current.256.702665559   
core_dump_dest /oracle/app/oracle/admin/vam/cdump   
db_block_size 8192   
db_create_file_dest +DG   
db_domain      
db_file_multiblock_read_count 16   
db_files 1000   
db_keep_cache_size 1056964608   
db_name vam   
db_recovery_file_dest +RECOVERYDEST   
db_recovery_file_dest_size 524288000000   
instance_number 1   
job_queue_processes 10   
local_listener VAM   
log_archive_dest_1 LOCATION=+RECOVERYDEST/   
log_archive_format %t_%s_%r.dbf   
open_cursors 1000   
open_links 30   
open_links_per_instance 10   
optimizer_index_caching 90   
optimizer_index_cost_adj 20   
pga_aggregate_target 1707081728   
processes 2000   
remote_listener      
remote_login_passwordfile EXCLUSIVE   
session_cached_cursors 1000   
sessions 2205   
sga_target 8388608000   
spfile +DG/vam/spfilevam.ora   
thread 1   
undo_management AUTO   
undo_retention 10800   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/app/oracle/admin/vam/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 0 0.00 0.00
acks for commit broadcast(logical) 0 0.00 0.00
broadcast msgs on commit(actual) 0 0.00 0.00
broadcast msgs on commit(logical) 0 0.00 0.00
broadcast msgs on commit(wasted) 0 0.00 0.00
broadcast on commit wait time(ms) 0 0.00 0.00
broadcast on commit waits 0 0.00 0.00
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 0 0.00 0.00
flow control messages sent 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 680,977 187.64 2.25
gcs ast xid 21 0.01 0.00
gcs blocked converts 333,300 91.84 1.10
gcs blocked cr converts 32,076 8.84 0.11
gcs compatible basts 347 0.10 0.00
gcs compatible cr basts (global) 3,528 0.97 0.01
gcs compatible cr basts (local) 504,226 138.94 1.66
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 79,470 21.90 0.26
gcs dbwr write request msgs 40,470 11.15 0.13
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 4,042 1.11 0.01
gcs immediate (null) converts 318,446 87.75 1.05
gcs immediate cr (compatible) converts 31 0.01 0.00
gcs immediate cr (null) converts 4,361,611 1,201.83 14.39
gcs indirect ast 283,651 78.16 0.94
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 37,762 10.41 0.12
gcs msgs process time(ms) 309,340 85.24 1.02
gcs msgs received 9,540,409 2,628.83 31.47
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 55 0.02 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 4 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 18 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 26,163 7.21 0.09
gcs side channel msgs logical 329,277 90.73 1.09
gcs stale cr 6,463 1.78 0.02
gcs undo cr 122,763 33.83 0.40
gcs write notification msgs 4,621 1.27 0.02
gcs writes refused 66 0.02 0.00
ges msgs process time(ms) 3,068 0.85 0.01
ges msgs received 117,095 32.27 0.39
global posts dropped 0 0.00 0.00
global posts queue time 47 0.01 0.00
global posts queued 11 0.00 0.00
global posts requested 11 0.00 0.00
global posts sent 11 0.00 0.00
implicit batch messages received 527,920 145.47 1.74
implicit batch messages sent 42,693 11.76 0.14
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 16,018 4.41 0.05
messages queue sent actual 329,103 90.68 1.09
messages queue sent logical 443,995 122.34 1.46
messages received actual 1,912,383 526.95 6.31
messages received logical 9,661,359 2,662.15 31.87
messages sent directly 369,264 101.75 1.22
messages sent indirectly 343,225 94.57 1.13
messages sent not implicit batched 286,770 79.02 0.95
messages sent pbatched 4,600,717 1,267.71 15.18
msgs causing lmd to send msgs 36,126 9.95 0.12
msgs causing lms(s) to send msgs 463,061 127.59 1.53
msgs received queue time (ms) 206,644 56.94 0.68
msgs received queued 9,661,396 2,662.16 31.87
msgs sent queue time (ms) 23,163 6.38 0.08
msgs sent queue time on ksxp (ms) 412,461 113.65 1.36
msgs sent queued 391,400 107.85 1.29
msgs sent queued on ksxp 1,081,451 297.99 3.57
process batch messages received 524,406 144.50 1.73
process batch messages sent 494,346 136.22 1.63


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 30,884
CURRENT Block Requests 125,627
Data Block Requests 30,884
Undo Block Requests 122,764
TX Block Requests 1,331
Current Results 106,821
Private results 1
Zero Results 304
Disk Read Results 49,383
Fail Results 0
Fairness Down Converts 5,617
Fairness Clears 0
Free GC Elements 0
Flushes 1,359
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 49,531
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 795,781 99.98 0.00 0.02 0.00 0.00
Flushes 298 71.81 28.19 0.00 0.00 0.00
Writes 80,943 50.49 47.21 2.02 0.13 0.15


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 data block 25,742 93.61 6.34 0.04 233,872 99.84 0.16 0.01
2 Others 1,065 97.84 0.56 1.60 1,554 99.10 0.77 0.13
2 undo block 1,885 99.73 0.27 0.00 0      
2 undo header 1,656 98.97 1.03 0.00 165 100.00 0.00 0.00


Back to Top

End of Report