kvamdb1$cat awrrpt_1_19655_19656.html AWR Report

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
VAM2306309266vam1110.2.0.4.0YESkvamdb1

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:1965509-Feb-12 01:00:431214 .7
End Snap:1965609-Feb-12 02:00:041123 .7
Elapsed:  59.35 (mins)  
DB Time:  267.22 (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: 909,237.73 13,585.18
Logical reads: 318,581.86 4,760.02
Block changes: 3,806.42 56.87
Physical reads: 36.27 0.54
Physical writes: 165.64 2.47
User calls: 2,178.03 32.54
Parses: 286.16 4.28
Hard parses: 6.65 0.10
Sorts: 41.23 0.62
Logons: 0.91 0.01
Executes: 337.13 5.04
Transactions: 66.93 

% Blocks changed per Read: 1.19Recursive Call %: 21.21
Rollback per transaction %: 0.03Rows per Sort: 11.64

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 99.99
Buffer Hit %: 99.99In-memory Sort %: 100.00
Library Hit %: 94.69Soft Parse %: 97.68
Execute to Parse %: 15.12Latch Hit %: 98.49
Parse CPU to Parse Elapsd %: 87.65% Non-Parse CPU: 99.35

Shared Pool Statistics

BeginEnd
Memory Usage %: 56.46 56.70
% SQL with executions>1: 83.56 82.69
% Memory for SQL w/exec>1: 82.13 81.93

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  14,720  91.8 
Backup: sbtwrite2 349,815 6,651 19 41.5Administrative
Backup: sbtbackup 3 3,002 1,000,730 18.7Administrative
db file sequential read 121,626 682 6 4.3User I/O
SQL*Net more data to client 9,893,020 282 0 1.8Network

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 90.67 1.35
Global Cache blocks served: 317.36 4.74
GCS/GES messages received: 966.24 14.44
GCS/GES messages sent: 436.25 6.52
DBWR Fusion writes: 32.21 0.48
Estd Interconnect traffic (KB) 3,538.14 

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

Buffer access - local cache %: 99.96
Buffer access - remote cache %: 0.03
Buffer access - disk %: 0.01

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.0
Avg global cache cr block flush time (ms): 1.4
Avg global cache current block pin time (ms): 0.0
Avg global cache current block send time (ms): 0.1
Global cache log flushes for current blocks served %: 0.1
Avg global cache current block flush time (ms): 1.1

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
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.1
Avg GES message process time (ms): 0.0
% of direct sent messages: 32.50
% of indirect sent messages: 66.46
% of flow controlled messages: 1.05


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 15,549.22 96.98
DB CPU 14,719.88 91.81
RMAN cpu time (backup/restore) 260.92 1.63
parse time elapsed 120.19 0.75
hard parse elapsed time 64.59 0.40
connection management call elapsed time 13.78 0.09
PL/SQL execution elapsed time 5.24 0.03
sequence load elapsed time 2.44 0.02
hard parse (sharing criteria) elapsed time 1.84 0.01
PL/SQL compilation elapsed time 0.25 0.00
hard parse (bind mismatch) elapsed time 0.17 0.00
repeated bind elapsed time 0.09 0.00
DB time 16,033.01  
background elapsed time 11,986.34  
background cpu time 840.66  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Administrative 349,822 0.00 9,690 28 1.47
User I/O 139,902 0.00 684 5 0.59
Network 17,365,012 0.00 351 0 72.86
Cluster 397,595 0.00 236 1 1.67
System I/O 481,720 0.00 217 0 2.02
Commit 238,841 0.00 191 1 1.00
Other 543,034 93.32 77 0 2.28
Application 121,896 0.00 61 0 0.51
Concurrency 54,344 0.22 25 0 0.23
Configuration 814 9.95 1 1 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Backup: sbtwrite2 349,815 0.00 6,651 19 1.47
Backup: sbtbackup 3 0.00 3,002 1000730 0.00
db file sequential read 121,626 0.00 682 6 0.51
SQL*Net more data to client 9,893,020 0.00 282 0 41.51
log file sync 238,841 0.00 191 1 1.00
gc current block 2-way 296,045 0.00 170 1 1.24
log file parallel write 265,360 0.00 119 0 1.11
SQL*Net more data from client 525,991 0.00 63 0 2.21
SQL*Net break/reset to client 120,146 0.00 60 0 0.50
reliable message 304 10.86 52 170 0.00
db file parallel write 179,058 0.00 46 0 0.75
log file sequential read 3,426 0.00 38 11 0.01
Backup: sbtclose2 2 0.00 34 17133 0.00
gc current grant 2-way 47,975 0.00 20 0 0.20
gc cr block 2-way 23,576 0.00 14 1 0.10
gc current grant busy 17,003 0.00 13 1 0.07
control file sequential read 27,666 0.00 10 0 0.12
library cache lock 20,650 0.00 10 0 0.09
row cache lock 19,803 0.00 9 0 0.08
gc current block busy 629 0.00 7 12 0.00
SQL*Net message to client 6,946,001 0.00 7 0 29.15
gc buffer busy 829 0.97 7 9 0.00
Streams AQ: qmn coordinator waiting for slave to start 1 100.00 5 4890 0.00
CGS wait for IPC msg 486,307 99.99 4 0 2.04
enq: WF - contention 19 36.84 4 197 0.00
enq: FB - contention 4,666 0.00 3 1 0.02
enq: TC - contention 6 83.33 3 464 0.00
enq: TX - index contention 205 0.00 3 13 0.00
Backup: sbtinfo2 2 0.00 2 1242 0.00
gc cr block busy 1,734 0.00 2 1 0.01
cursor: pin S wait on X 137 86.86 2 15 0.00
control file parallel write 2,743 0.00 2 1 0.01
gcs log flush sync 1,919 10.11 2 1 0.01
name-service call wait 19 0.00 1 56 0.00
direct path read 15,603 0.00 1 0 0.07
latch free 488 0.00 1 2 0.00
Log archive I/O 3,307 0.00 1 0 0.01
DFS lock handle 1,754 0.00 1 0 0.01
gc current multi block request 7,752 0.00 1 0 0.03
os thread startup 15 0.00 1 50 0.00
log file switch completion 51 0.00 1 12 0.00
enq: TM - contention 1,166 0.00 1 1 0.00
RMAN backup & recovery I/O 92 0.00 1 6 0.00
ksxr poll remote instances 36,551 42.84 1 0 0.15
gc cr disk read 918 0.00 0 1 0.00
latch: cache buffers chains 12,271 0.00 0 0 0.05
rdbms ipc reply 950 0.00 0 0 0.00
enq: HW - contention 663 0.00 0 1 0.00
gc cr multi block request 823 0.00 0 0 0.00
enq: TT - contention 480 0.00 0 1 0.00
library cache pin 577 0.00 0 0 0.00
ges inquiry response 293 0.00 0 1 0.00
db file scattered read 57 0.00 0 3 0.00
enq: RO - fast object reuse 397 0.00 0 0 0.00
kksfbc child completion 3 100.00 0 56 0.00
enq: CF - contention 199 0.00 0 1 0.00
IPC send completion sync 282 98.58 0 0 0.00
latch: shared pool 60 0.00 0 2 0.00
gc cr grant 2-way 288 0.00 0 0 0.00
LGWR wait for redo copy 3,549 0.00 0 0 0.01
enq: KO - fast object checkpoint 186 0.00 0 0 0.00
enq: PS - contention 123 0.00 0 1 0.00
global enqueue expand wait 6 83.33 0 12 0.00
local write wait 42 0.00 0 1 0.00
PX Deq: reap credit 4,373 94.37 0 0 0.02
buffer busy waits 614 0.00 0 0 0.00
PX Deq Credit: send blkd 127 12.60 0 0 0.00
direct path write 2,559 0.00 0 0 0.01
read by other session 8 0.00 0 5 0.00
enq: JQ - contention 40 0.00 0 1 0.00
log file single write 68 0.00 0 0 0.00
enq: SQ - contention 9 0.00 0 2 0.00
KJC: Wait for msg sends to complete 176 0.00 0 0 0.00
enq: TA - contention 23 0.00 0 1 0.00
gc current split 21 0.00 0 1 0.00
library cache load lock 7 0.00 0 2 0.00
enq: RS - prevent file delete 17 0.00 0 1 0.00
enq: WL - contention 9 0.00 0 1 0.00
enq: US - contention 9 0.00 0 1 0.00
enq: TX - allocate ITL entry 10 0.00 0 1 0.00
latch: KCL gc element parent latch 108 0.00 0 0 0.00
enq: TX - contention 1 0.00 0 4 0.00
latch: object queue header operation 38 0.00 0 0 0.00
buffer deadlock 152 96.71 0 0 0.00
PX Deq: Signal ACK 21 28.57 0 0 0.00
enq: PI - contention 6 0.00 0 0 0.00
latch: session allocation 3 0.00 0 1 0.00
db file single write 5 0.00 0 0 0.00
enq: BR - file shrink 2 0.00 0 1 0.00
db file parallel read 2 0.00 0 0 0.00
latch: cache buffers lru chain 4 0.00 0 0 0.00
gc cr failure 1 0.00 0 1 0.00
enq: TX - row lock contention 1 0.00 0 1 0.00
latch: row cache objects 1 0.00 0 1 0.00
enq: AF - task serialization 1 0.00 0 0 0.00
undo segment extension 81 100.00 0 0 0.00
enq: CT - state 1 0.00 0 0 0.00
latch: library cache 1 0.00 0 0 0.00
latch: gcs resource hash 2 0.00 0 0 0.00
latch: enqueue hash chains 1 0.00 0 0 0.00
cursor: mutex X 3 0.00 0 0 0.00
gc object scan 1 100.00 0 0 0.00
cr request retry 1 100.00 0 0 0.00
SQL*Net message from client 6,946,093 0.00 3,274,957 471 29.15
jobq slave wait 7,122 49.42 17,299 2429 0.03
gcs remote message 1,776,929 90.40 13,566 8 7.46
PX Idle Wait 2,182 94.64 5,238 2401 0.01
Streams AQ: qmn slave idle wait 134 2.24 3,530 26342 0.00
Streams AQ: waiting for time management or cleanup tasks 11 0.00 3,490 317314 0.00
ASM background timer 1,404 0.00 3,472 2473 0.01
Streams AQ: waiting for messages in the queue 367 96.73 3,469 9451 0.00
DIAG idle wait 16,852 0.00 3,467 206 0.07
Streams AQ: qmn coordinator idle wait 258 50.00 3,464 13426 0.00
ges remote message 130,933 85.55 3,458 26 0.55
class slave wait 346 0.29 3,309 9563 0.00
KSV master wait 359 0.00 4 11 0.00
PX Deq: Execution Msg 625 33.44 1 2 0.00
PX Deq: Parse Reply 29 41.38 0 2 0.00
PX Deq: Msg Fragment 239 43.10 0 0 0.00
PX Deq: Join ACK 29 37.93 0 1 0.00
PX Deq: Execute Reply 26 30.77 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 258 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 265,349 0.00 119 0 1.11
events in waitclass Other 532,090 94.43 66 0 2.23
db file parallel write 179,058 0.00 46 0 0.75
log file sequential read 3,426 0.00 38 11 0.01
control file sequential read 11,446 0.00 4 0 0.05
control file parallel write 2,580 0.00 2 1 0.01
Log archive I/O 3,307 0.00 1 0 0.01
os thread startup 15 0.00 1 50 0.00
enq: TM - contention 1,163 0.00 1 1 0.00
gc current block 2-way 633 0.00 0 1 0.00
gc cr block 2-way 517 0.00 0 1 0.00
direct path read 12,194 0.00 0 0 0.05
gc current block busy 4 0.00 0 52 0.00
enq: RO - fast object reuse 389 0.00 0 0 0.00
latch: shared pool 6 0.00 0 16 0.00
library cache lock 169 0.00 0 1 0.00
enq: KO - fast object checkpoint 186 0.00 0 0 0.00
gc current grant busy 58 0.00 0 1 0.00
direct path write 2,553 0.00 0 0 0.01
log file single write 68 0.00 0 0 0.00
enq: HW - contention 34 0.00 0 1 0.00
library cache pin 16 0.00 0 0 0.00
gc cr multi block request 16 0.00 0 0 0.00
latch: cache buffers chains 102 0.00 0 0 0.00
gc current multi block request 7 0.00 0 0 0.00
buffer busy waits 5 0.00 0 0 0.00
latch: row cache objects 1 0.00 0 1 0.00
gc object scan 1 100.00 0 0 0.00
row cache lock 1,139 -0.18 -8 -7 0.00
rdbms ipc message 461,191 12.11 51,604 112 1.94
gcs remote message 1,776,916 90.40 13,566 8 7.46
Streams AQ: waiting for time management or cleanup tasks 11 0.00 3,490 317314 0.00
ASM background timer 1,404 0.00 3,472 2473 0.01
DIAG idle wait 16,852 0.00 3,467 206 0.07
Streams AQ: qmn coordinator idle wait 258 50.00 3,464 13426 0.00
smon timer 891 0.00 3,464 3887 0.00
ges remote message 130,979 85.55 3,458 26 0.55
pmon timer 1,959 99.90 3,447 1760 0.01
class slave wait 343 0.29 3,309 9647 0.00
KSV master wait 221 0.00 0 2 0.00
PX Deq: Parse Reply 29 41.38 0 2 0.00
PX Deq: Join ACK 29 37.93 0 1 0.00
PX Deq: Execute Reply 26 30.77 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 258 100.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 114,605
AVG_IDLE_TIME 240,423
AVG_IOWAIT_TIME 0
AVG_SYS_TIME 16,293
AVG_USER_TIME 98,201
BUSY_TIME 1,835,421
IDLE_TIME 3,848,493
IOWAIT_TIME 0
SYS_TIME 262,392
USER_TIME 1,573,029
LOAD 6
OS_CPU_WAIT_TIME 11,900
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 24,936,448
VM_OUT_BYTES 36,937,728
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
vam 15,326.80 14,031.40 114,911 1,125,049,007
SYS$USERS 705.90 688.00 1,684 9,275,440
SYS$BACKGROUND 0.00 0.00 12,728 156,056

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
vam 114923 67365 43097 1750 0 0 12417746 25904
SYS$USERS 9464 754 6116 434 349814 968987 4935124 9212
SYS$BACKGROUND 15530 255 5124 296 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
7,884 7,930 42 187.71 49.17 c4s83719x437j   select rc.Id as city_id, rn.p...
1,477 1,249 99,186 0.01 9.22 anwkyts985z77   delete from fsti_alarm_trans w...
1,472 1,247 99,186 0.01 9.18 gdd5s7nqgssu9   select addition_id from fsti_a...
1,426 1,426 178 8.01 8.89 4a6cx9kqm5r5h   select Identifier, Node, NodeA...
1,123 378 486 2.31 7.01 6acqpn0qjrctq SQL Loader Conventional Path Load INSERT INTO PROD_FZ_WAP_WAP20T...
425 425 66 6.44 2.65 1dg7znt919y4p   Select c.Id As cityid, c.cname...
310 309 73 4.24 1.93 g269uhxq6ubty   Select c.Id As cityid, c.cname...
139 139 68 2.04 0.87 3rn43k5skpggf   SELECT * FROM ( SELE...
110 110 65 1.70 0.69 3vzt7yt9tja88   SELECT * FROM ( SELE...
108 108 68 1.59 0.67 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
7,930 7,884 42 188.80 49.17 c4s83719x437j   select rc.Id as city_id, rn.p...
1,426 1,426 178 8.01 8.89 4a6cx9kqm5r5h   select Identifier, Node, NodeA...
1,249 1,477 99,186 0.01 9.22 anwkyts985z77   delete from fsti_alarm_trans w...
1,247 1,472 99,186 0.01 9.18 gdd5s7nqgssu9   select addition_id from fsti_a...
425 425 66 6.44 2.65 1dg7znt919y4p   Select c.Id As cityid, c.cname...
378 1,123 486 0.78 7.01 6acqpn0qjrctq SQL Loader Conventional Path Load INSERT INTO PROD_FZ_WAP_WAP20T...
309 310 73 4.24 1.93 g269uhxq6ubty   Select c.Id As cityid, c.cname...
139 139 68 2.04 0.87 3rn43k5skpggf   SELECT * FROM ( SELE...
110 110 65 1.70 0.69 3vzt7yt9tja88   SELECT * FROM ( SELE...
108 108 68 1.59 0.67 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
567,246,758 42 13,505,875.19 50.00 7929.70 7883.79 c4s83719x437j   select rc.Id as city_id, rn.p...
225,053,171 99,186 2,269.00 19.84 1248.99 1477.45 anwkyts985z77   delete from fsti_alarm_trans w...
225,050,908 99,186 2,268.98 19.84 1247.18 1471.63 gdd5s7nqgssu9   select addition_id from fsti_a...
24,442,903 178 137,319.68 2.15 1425.92 1425.85 4a6cx9kqm5r5h   select Identifier, Node, NodeA...
16,059,605 486 33,044.45 1.42 378.06 1123.48 6acqpn0qjrctq SQL Loader Conventional Path Load INSERT INTO PROD_FZ_WAP_WAP20T...
6,743,012 73 92,370.03 0.59 309.48 309.52 g269uhxq6ubty   Select c.Id As cityid, c.cname...
6,390,471 68 93,977.51 0.56 138.75 138.77 3rn43k5skpggf   SELECT * FROM ( SELE...
6,381,100 68 93,839.71 0.56 108.13 108.13 9u68cq2puf064   Select Count(1) From Res_Servi...
6,196,415 66 93,885.08 0.55 425.30 425.32 1dg7znt919y4p   Select c.Id As cityid, c.cname...
6,005,778 64 93,840.28 0.53 102.07 102.07 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
106,824 486 219.80 82.70 378.06 1123.48 6acqpn0qjrctq SQL Loader Conventional Path Load INSERT INTO PROD_FZ_WAP_WAP20T...
472 4 118.00 0.37 2.07 4.78 6bbzx8bac652f JDBC Thin Client SELECT t.*, rownum from (SELEC...
258 1,829 0.14 0.20 36.44 40.78 8cx33vubmug6b   insert into FSTI_ALARM_HISTORY...
67 296 0.23 0.05 7.02 8.12 5j90cjhgfvsj8   insert into FSTI_ALARM_HISTORY...
46 1,281 0.04 0.04 26.48 29.46 gt22pnh04wan8   UPDATE FSTI_ALARM_CURRENT SET ...
30 798 0.04 0.02 0.88 11.42 1qvjz6ud03wfm   insert into prod_res_ne_detect...
24 4 6.00 0.02 45.97 45.97 43xtg2pbayp29   DECLARE job BINARY_INTEGER := ...
8 11,452 0.00 0.01 6.91 6.95 dxy8awsx01f1x   update PERF_HOST_STORAGE_DAY_M...
7 10,075 0.00 0.01 6.77 6.81 gaskb581vzwb1   update PERF_HOST_STORAGE_HOUR_...
6 10,077 0.00 0.00 6.33 6.33 2uxqqt4t7jwn2   update PERF_HOST_STORAGE_HOUR_...

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
140,928 261,589 1.86 0.00 0.00 2aadvhw5r7gfc   select name, ip from CONF_APP_...
136,038 135,733 1.00 0.00 0.00 3tjv3vcff9nj1   select net_area_id from CONF_A...
99,186 0 0.00 0.01 0.01 anwkyts985z77   delete from fsti_alarm_trans w...
99,186 1,700 0.02 0.01 0.01 gdd5s7nqgssu9   select addition_id from fsti_a...
31,082 30,856 0.99 0.00 0.00 2jfqzrxhrm93b   select /*+ rule */ c.name, u....
21,660 1,111 0.05 0.00 0.00 8r32rk7uxxkdb   select app_type from res_appli...
17,020 17,020 1.00 0.00 0.00 a0u5858g45m8n   select count(1) from dual wher...
12,029 12,029 1.00 0.00 0.00 cgrsx2689bca4   select count(1) from dual wher...
12,000 40 0.00 0.00 0.00 dn76n760vxs8b   Insert Into Prod_Fz_Qyzj_Rtp_S...
11,452 11,333 0.99 0.00 0.00 dxy8awsx01f1x   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
140,925 140,928 13.83 2aadvhw5r7gfc   select name, ip from CONF_APP_...
135,836 136,038 13.33 3tjv3vcff9nj1   select net_area_id from CONF_A...
99,186 99,186 9.73 gdd5s7nqgssu9   select addition_id from fsti_a...
99,185 99,186 9.73 anwkyts985z77   delete from fsti_alarm_trans w...
31,082 31,082 3.05 2jfqzrxhrm93b   select /*+ rule */ c.name, u....
21,658 21,660 2.13 8r32rk7uxxkdb   select app_type from res_appli...
12,000 12,000 1.18 dn76n760vxs8b   Insert Into Prod_Fz_Qyzj_Rtp_S...
11,454 11,452 1.12 dxy8awsx01f1x   update PERF_HOST_STORAGE_DAY_M...
11,447 11,450 1.12 f54tpujxcbnc7   update PERF_HOST_STORAGE_DAY_A...
11,444 11,444 1.12 gqrmhgpq33afw   update PERF_HOST_STORAGE_DAY_M...
11,262 11,266 1.11 d2qfc3zqhckw7   select PERF_HOST_STORAGE_SEQ.n...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
2,110,080   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
491   49s332uhbnsma   ** SQL Text Not Available **
467 4,056 c42pznb7vnkvg   update RES_HOST_PROCESS set ne...
79 129 0fr8zhn4ymu3v   select intcol#, type, flags, l...
76 19 cjk1ffy5kmm5s   select obj# from oid$ where us...
69 296 5j90cjhgfvsj8   insert into FSTI_ALARM_HISTORY...
63 21 g3wrkmxkxzhf2   select cols, audit$, textlengt...
61 1 d1m8g1r0jntpj   begin :vsn_min...
58 129 32bhha21dkv0v   select col#, intcol#, charseti...
56 1 a20djcagc6vp4   declare policy ...
48 3 5wc2915k44m38   select user#, type# from user$...
44 38 9g485acn2n30m   select col#, intcol#, reftyp, ...
44 38 9rfqm06xmuwu0   select intcol#, toid, versio...
44 38 f3g84j69n0tjh   select col#, intcol#, ntab# fr...
37 345 04xtrk7uyhknh   select obj#, type#, ctime, mti...
37 4 5t7dh3thzzrfh   begin dbms_rcvm...
32 1,100 2q93zsrvbdw48   select grantee#, privilege#, n...
32 1,100 6aq34nj2zb2n7   select col#, grantee#, privi...
31 1,767 6769wyy3yf66f   select pos#, intcol#, col#, sp...
29 1,829 8cx33vubmug6b   insert into FSTI_ALARM_HISTORY...
28 21 dpvv2ua0tfjcv   select cachedblk, cachehit, ...
28 1,281 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
152.27 13.55 1,123.48 378.06 486 6acqpn0qjrctq SQL Loader Conventional Path Load INSERT INTO PROD_FZ_WAP_WAP20T...
8.58 75.12 11.42 0.88 798 1qvjz6ud03wfm   insert into prod_res_ne_detect...
2.51 6.73 37.27 36.72 140,928 2aadvhw5r7gfc   select name, ip from CONF_APP_...
2.27 29.79 7.62 7.56 11,450 f54tpujxcbnc7   update PERF_HOST_STORAGE_DAY_A...
2.23 32.13 6.95 6.91 11,452 dxy8awsx01f1x   update PERF_HOST_STORAGE_DAY_M...
2.12 33.06 6.42 6.42 10,057 98vhmww9mb31y   update PERF_HOST_STORAGE_HOUR_...
2.11 30.63 6.89 6.89 11,444 gqrmhgpq33afw   update PERF_HOST_STORAGE_DAY_M...
2.08 30.55 6.81 6.77 10,075 gaskb581vzwb1   update PERF_HOST_STORAGE_HOUR_...
2.01 31.70 6.33 6.33 10,077 2uxqqt4t7jwn2   update PERF_HOST_STORAGE_HOUR_...
1.54 33.43 4.60 4.42 7,674 btsd8mnm607a5   update PERF_ORACLE_ROLLBACK_HO...
1.39 30.98 4.47 4.36 7,682 52rh4tudahskr   update PERF_ORACLE_ROLLBACK_HO...
1.37 27.39 5.01 4.94 7,668 9hxy7mq2w4mxc   update PERF_ORACLE_ROLLBACK_HO...
1.32 24.36 5.40 5.40 8,910 gm0926zq11v76   update PERF_ORACLE_ROLLBACK_DA...
1.29 20.74 6.22 5.59 4,056 c42pznb7vnkvg   update RES_HOST_PROCESS set ne...
1.25 27.02 4.62 4.60 8,888 9827cwgknbxj0   update PERF_ORACLE_ROLLBACK_DA...
1.23 25.81 4.75 4.70 8,878 a1wt2f5ha4z3x   update PERF_ORACLE_ROLLBACK_DA...
1.01 36.72 2.76 2.75 3,883 9yuu4zjfdunym   update PERF_INTERFACE_DAY_MIN ...
1.01 2.48 40.78 36.44 1,829 8cx33vubmug6b   insert into FSTI_ALARM_HISTORY...
1.01 33.87 2.97 2.97 3,892 ck8ffq53n5hra   update PERF_INTERFACE_DAY_AVG ...
0.97 35.34 2.75 2.71 3,904 dg1u46j2f9u7x   update PERF_INTERFACE_DAY_MAX ...
0.78 2.83 27.60 23.32 1,700 dtka5gpfn2pk3   update fsti_alarm_trans set la...
0.77 2.63 29.46 26.48 1,281 gt22pnh04wan8   UPDATE FSTI_ALARM_CURRENT SET ...
0.65 13.58 4.78 2.07 4 6bbzx8bac652f JDBC Thin Client SELECT t.*, rownum from (SELEC...
0.63 3.41 18.43 18.41 136,038 3tjv3vcff9nj1   select net_area_id from CONF_A...
0.50 0.04 1,425.85 1,425.92 178 4a6cx9kqm5r5h   select Identifier, Node, NodeA...
0.48 0.44 110.38 110.38 65 3vzt7yt9tja88   SELECT * FROM ( SELE...
0.48 0.47 100.62 100.62 66 5spcdusnvyta6   Select Count(1) From Res_Servi...
0.47 0.43 108.13 108.13 68 9u68cq2puf064   Select Count(1) From Res_Servi...
0.46 0.33 138.77 138.75 68 3rn43k5skpggf   SELECT * FROM ( SELE...
0.41 1.49 27.28 23.32 1,700 grk0hgasghg0a   delete from fsti_alarm_trans w...
0.40 1.46 27.59 23.85 1,700 cv89mwmx833bg   select a.IDENTIFIER, a.SERIAL,...
0.40 0.01 7,883.79 7,929.70 42 c4s83719x437j   select rc.Id as city_id, rn.p...
0.38 0.37 102.07 102.07 64 c9f8hcmhypvmq   Select severity, count(1) as a...
0.37 0.37 100.45 100.45 65 2ynctjsphswxs   Select severity, count(1) as a...
0.29 3.59 8.12 7.02 296 5j90cjhgfvsj8   insert into FSTI_ALARM_HISTORY...
0.19 4.09 4.61 4.61 31,082 2jfqzrxhrm93b   select /*+ rule */ c.name, u....
0.15 0.01 1,471.63 1,247.18 99,186 gdd5s7nqgssu9   select addition_id from fsti_a...
0.14 0.03 425.32 425.30 66 1dg7znt919y4p   Select c.Id As cityid, c.cname...
0.14 0.04 309.52 309.48 73 g269uhxq6ubty   Select c.Id As cityid, c.cname...
0.12 0.65 18.65 18.65 12,000 dn76n760vxs8b   Insert Into Prod_Fz_Qyzj_Rtp_S...
0.12 20.81 0.57 0.57 4,784 2ym6hhaq30r73   select type#, blocks, extents,...
0.12 0.01 1,477.45 1,248.99 99,186 anwkyts985z77   delete from fsti_alarm_trans w...
0.04 11.25 0.35 0.35 112 bd13sdj0ty0q4 SQL Loader Conventional Path Load SELECT 'X' FROM SYS.ALL_OBJECT...
0.03 0.06 45.97 45.97 4 43xtg2pbayp29   DECLARE job BINARY_INTEGER := ...
0.02 6.68 0.23 0.18 22 130dvvr5s8bgn   select obj#, dataobj#, part#...
0.01 1.40 0.77 0.77 3 dr5yapf51hwkd JDBC Thin Client SELECT /*+ rule */ rownum, db....
0.01 0.59 1.82 1.81 11,266 d2qfc3zqhckw7   select PERF_HOST_STORAGE_SEQ.n...
0.01 3.94 0.26 0.25 28 c3zymn7x3k6wy   select obj#, dataobj#, part#...
0.01 33.98 0.02 0.01 3 5wc2915k44m38   select user#, type# from user$...
0.01 26.34 0.03 0.03 223 8swypbbr0m372   select order#, columns, types ...
0.01 0.42 1.51 1.51 9,020 c0ffn9zgw6rk6   select PERF_ORACLE_ROLLBACK_SE...

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) )
1qvjz6ud03wfminsert into prod_res_ne_detect_log(id, neid, dest_ip, is_succ) values(prod_res_ne_detect_log_seq.nextval, :1, :2, :3)
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
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
6acqpn0qjrctq INSERT INTO PROD_FZ_WAP_WAP20TRAFFIC (TIMESTAMP, CDRTYPE, WAPGWID, BEARERTYPE, MSISDN, SPID, SERVICEID, USERTYPE, DISCOUNT, SERVICEATTR, STARTTIME, STOPTIME, CONTENTLENGTH, REGIONCODE, ACCESSREGION, CHARGEMODE, INFOFEE, TRAFFICFEE, STATUSCODE, SPDOMAIN, URL, USERAGENT, CHARGEID, ACCTSESSIONID, APN, IMSIL, PDSNIP, QOS, USERNAME, MSIP, BEARPROTOCOLTYPE, TRANSACTIONID, UPLINKTRAFFIC, DOWNLINKTRAFFIC, DESCPORT, SERVICETYPENAME, NODCODE, HOSTIP, RPSTIME, TRANSMITREQUESTTIME, TRANSMITRESPONSETIME, WAPVISITED, NASIP, NASID, CONTENTTYPE, TERMINATEDREASON, DURATION, BILLTYPE, OPERTYPE, SENDRESULT, STATISTICCODE, SP_IP, SP_PORT, WAPGW_PORT, UPDATE_TIME) VALUES (CAST(TO_DATE(:TIMESTAMP, 'yyyymmddhh24miss') AS DATE), :CDRTYPE, :WAPGWID, :BEARERTYPE, :MSISDN, :SPID, :SERVICEID, :USERTYPE, :DISCOUNT, :SERVICEATTR, CAST(TO_DATE(:STARTTIME, 'yyyymmddhh24miss') AS DATE), CAST(TO_DATE(:STOPTIME, 'yyyymmddhh24miss') AS DATE), :CONTENTLENGTH, :REGIONCODE, :ACCESSREGION, :CHARGEMODE, :INFOFEE, :TRAFFICFEE, :STATUSCODE, :SPDOMAIN, :URL, :USERAGENT, :CHARGEID, :ACCTSESSIONID, :APN, :IMSIL, :PDSNIP, :QOS, :USERNAME, :MSIP, :BEARPROTOCOLTYPE, :TRANSACTIONID, :UPLINKTRAFFIC, :DOWNLINKTRAFFIC, :DESCPORT, :SERVICETYPENAME, :NODCODE, :HOSTIP, :RPSTIME, :TRANSMITREQUESTTIME, :TRANSMITRESPONSETIME, :WAPVISITED, :NASIP, :NASID, :CONTENTTYPE, :TERMINATEDREASON, :DURATION, :BILLTYPE, :OPERTYPE, :SENDRESULT, :STATISTICCODE, :SP_IP, :SP_PORT, :WAPGW_PORT, CAST(TO_DATE(:UPDATE_TIME, 'yyyymmddhh24miss') AS DATE))
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
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
8swypbbr0m372select order#, columns, types from access$ where d_obj#=: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
c3zymn7x3k6wyselect obj#, dataobj#, part#, hiboundlen, hiboundval, flags, ts#, file#, block#, pctfree$, initrans, maxtrans, analyzetime, samplesize, rowcnt, blevel, leafcnt, distkey, lblkkey, dblkkey, clufac, pctthres$, length(bhiboundval), bhiboundval from indpart$ where bo# = :1 order by part#
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
cgrsx2689bca4select count(1) from dual where 1=1 AND 5 = 5
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
dr5yapf51hwkdSELECT /*+ rule */ rownum, db.object_name, db.owner, db.object_type, vl.TYPE, vl.ID1, vl.ID2, vl.CTIME, decode(vl.lmode, 0, 'NONE', 1, 'NULL', 2, 'ROW SHARE', 3, 'ROW EXCLUSIVE', 4, 'SHARE', 5, 'SHARE ROW EXCLUSIVE', 6, 'EXCLUSIVE', '?') "lmode", decode(vl.request, 0, 'NONE', 1, 'NULL', 2, 'ROW SHARE', 3, 'ROW EXCLUSIVE', 4, 'SHARE', 5, 'SHARE ROW EXCLUSIVE', 6, 'EXCLUSIVE', '?') "request" FROM dba_objects db, v$lock vl where db.object_id = vl.id1
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,531,866 430.19 6.43
CPU used when call started 1,524,558 428.14 6.40
CR blocks created 2,210 0.62 0.01
Cached Commit SCN referenced 1,940 0.54 0.01
Commit SCN cached 1 0.00 0.00
DB time 2,860,688 803.37 12.00
DBWR checkpoint buffers written 466,910 131.12 1.96
DBWR checkpoints 310 0.09 0.00
DBWR fusion writes 114,686 32.21 0.48
DBWR object drop buffers written 40 0.01 0.00
DBWR parallel query checkpoint buffers written 2,646 0.74 0.01
DBWR revisited being-written buffer 0 0.00 0.00
DBWR tablespace checkpoint buffers written 177 0.05 0.00
DBWR thread checkpoint buffers written 73,167 20.55 0.31
DBWR transaction table writes 489 0.14 0.00
DBWR undo block writes 135,841 38.15 0.57
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 12 0.00 0.00
DML statements parallelized 0 0.00 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 30 0.01 0.00
PX local messages sent 30 0.01 0.00
PX remote messages recv'd 471 0.13 0.00
PX remote messages sent 502 0.14 0.00
Parallel operations downgraded to serial 1,082 0.30 0.00
Parallel operations not downgraded 12 0.00 0.00
RowCR - row contention 11 0.00 0.00
RowCR attempts 1,914 0.54 0.01
RowCR hits 1,864 0.52 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 21 0.01 0.00
SQL*Net roundtrips to/from client 6,932,692 1,946.91 29.09
SQL*Net roundtrips to/from dblink 0 0.00 0.00
active txn count during cleanout 142,276 39.96 0.60
application wait time 6,053 1.70 0.03
background checkpoints completed 17 0.00 0.00
background checkpoints started 17 0.00 0.00
background timeouts 14,871 4.18 0.06
branch node splits 90 0.03 0.00
buffer is not pinned count 72,041,359 20,231.40 302.28
buffer is pinned count 408,390,652 114,688.51 1,713.59
bytes received via SQL*Net from client 1,341,201,611 376,650.19 5,627.64
bytes received via SQL*Net from dblink 0 0.00 0.00
bytes sent via SQL*Net to client 27,121,028,698 7,616,409.45 113,798.98
bytes sent via SQL*Net to dblink 0 0.00 0.00
calls to get snapshot scn: kcmgss 2,372,291 666.21 9.95
calls to kcmgas 1,180,236 331.45 4.95
calls to kcmgcs 128,471 36.08 0.54
change write time 6,893 1.94 0.03
cleanout - number of ktugct calls 159,287 44.73 0.67
cleanouts and rollbacks - consistent read gets 217 0.06 0.00
cleanouts only - consistent read gets 354 0.10 0.00
cluster key scan block gets 69,191 19.43 0.29
cluster key scans 52,095 14.63 0.22
cluster wait time 23,632 6.64 0.10
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 32,071 9.01 0.13
commit batch/immediate requested 32,071 9.01 0.13
commit cleanout failures: block lost 1,002 0.28 0.00
commit cleanout failures: buffer being written 9 0.00 0.00
commit cleanout failures: callback failure 9,742 2.74 0.04
commit cleanout failures: cannot pin 130 0.04 0.00
commit cleanouts 1,362,296 382.57 5.72
commit cleanouts successfully completed 1,351,413 379.52 5.67
commit immediate performed 32,071 9.01 0.13
commit immediate requested 32,071 9.01 0.13
commit txn count during cleanout 62,280 17.49 0.26
concurrency wait time 2,483 0.70 0.01
consistent changes 8,879 2.49 0.04
consistent gets 1,116,598,034 313,574.68 4,685.21
consistent gets - examination 3,064,226 860.53 12.86
consistent gets direct 3,410 0.96 0.01
consistent gets from cache 1,116,596,194 313,574.16 4,685.20
current blocks converted for CR 1 0.00 0.00
cursor authentications 12,633 3.55 0.05
data blocks consistent reads - undo records applied 7,966 2.24 0.03
db block changes 13,554,154 3,806.42 56.87
db block gets 17,830,008 5,007.21 74.81
db block gets direct 158 0.04 0.00
db block gets from cache 17,829,850 5,007.16 74.81
deferred (CURRENT) block cleanout applications 848,891 238.39 3.56
dirty buffers inspected 549 0.15 0.00
drop segment calls in space pressure 0 0.00 0.00
enqueue conversions 1,684 0.47 0.01
enqueue deadlocks 0 0.00 0.00
enqueue releases 795,726 223.46 3.34
enqueue requests 795,761 223.47 3.34
enqueue timeouts 41 0.01 0.00
enqueue waits 8,071 2.27 0.03
exchange deadlocks 182 0.05 0.00
execute count 1,200,473 337.13 5.04
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 693,980 194.89 2.91
free buffer requested 727,841 204.40 3.05
gc CPU used by this session 62,134 17.45 0.26
gc blocks lost 0 0.00 0.00
gc cr block build time 100 0.03 0.00
gc cr block flush time 102 0.03 0.00
gc cr block receive time 1,785 0.50 0.01
gc cr block send time 663 0.19 0.00
gc cr blocks received 26,177 7.35 0.11
gc cr blocks served 68,952 19.36 0.29
gc current block flush time 58 0.02 0.00
gc current block pin time 1,731 0.49 0.01
gc current block receive time 20,268 5.69 0.09
gc current block send time 9,409 2.64 0.04
gc current blocks received 296,691 83.32 1.24
gc current blocks served 1,061,111 297.99 4.45
gc local grants 333,748 93.73 1.40
gc remote grants 68,586 19.26 0.29
gcs messages sent 1,439,169 404.16 6.04
ges messages sent 114,277 32.09 0.48
global enqueue get time 5,100 1.43 0.02
global enqueue gets async 20,662 5.80 0.09
global enqueue gets sync 532,998 149.68 2.24
global enqueue releases 545,955 153.32 2.29
global undo segment hints helped 0 0.00 0.00
heap block compress 2,551 0.72 0.01
hot buffers moved to head of LRU 283,813 79.70 1.19
immediate (CR) block cleanout applications 571 0.16 0.00
immediate (CURRENT) block cleanout applications 54,549 15.32 0.23
index crx upgrade (found) 1,469 0.41 0.01
index crx upgrade (positioned) 186,215 52.29 0.78
index fast full scans (full) 638 0.18 0.00
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 3,062,357 860.00 12.85
index scans kdiixs1 327,898 92.08 1.38
leaf node 90-10 splits 165 0.05 0.00
leaf node splits 18,538 5.21 0.08
lob reads 4,366 1.23 0.02
lob writes 191 0.05 0.00
lob writes unaligned 190 0.05 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,232 0.91 0.01
messages received 563,324 158.20 2.36
messages sent 563,260 158.18 2.36
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 1,112,537,015 312,434.22 4,668.17
opened cursors cumulative 944,849 265.34 3.96
parse count (failures) 5 0.00 0.00
parse count (hard) 23,673 6.65 0.10
parse count (total) 1,018,993 286.16 4.28
parse time cpu 9,531 2.68 0.04
parse time elapsed 10,874 3.05 0.05
physical read IO requests 129,181 36.28 0.54
physical read bytes 1,062,723,584 298,445.09 4,459.15
physical read total IO requests 344,717 96.81 1.45
physical read total bytes 97,554,984,448 27,396,405.72 409,337.64
physical read total multi block requests 179,845 50.51 0.75
physical reads 129,170 36.27 0.54
physical reads cache 114,123 32.05 0.48
physical reads cache prefetch 549 0.15 0.00
physical reads direct 15,604 4.38 0.07
physical reads direct (lob) 3,409 0.96 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 307,948 86.48 1.29
physical write bytes 4,831,813,632 1,356,920.18 20,274.14
physical write total IO requests 887,716 249.30 3.72
physical write total bytes 15,252,521,984 4,283,371.91 63,999.10
physical write total multi block requests 604,345 169.72 2.54
physical writes 589,821 165.64 2.47
physical writes direct 2,711 0.76 0.01
physical writes direct (lob) 92 0.03 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 587,110 164.88 2.46
physical writes non checkpoint 520,646 146.21 2.18
pinned buffers inspected 23 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 2 0.00 0.00
process last non-idle time 3,615 1.02 0.02
queries parallelized 12 0.00 0.00
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 2,088,279 586.45 8.76
recursive cpu usage 18,730 5.26 0.08
redo blocks read for recovery 0 0.00 0.00
redo blocks written 6,727,550 1,889.30 28.23
redo buffer allocation retries 656 0.18 0.00
redo entries 7,357,926 2,066.33 30.87
redo log space requests 663 0.19 0.00
redo log space wait time 72 0.02 0.00
redo ordering marks 130,890 36.76 0.55
redo size 3,237,675,532 909,237.73 13,585.18
redo subscn max counts 8,431 2.37 0.04
redo synch time 18,056 5.07 0.08
redo synch writes 270,536 75.97 1.14
redo wastage 95,431,668 26,800.11 400.43
redo write time 15,445 4.34 0.06
redo writer latching time 14 0.00 0.00
redo writes 265,192 74.47 1.11
rollback changes - undo records applied 64,198 18.03 0.27
rollbacks only - consistent read gets 2,525 0.71 0.00 0.00
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 32,303 9.07 0.14
write clones created in background 42 0.01 0.00
write clones created in foreground 12 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,953,631 68,013,645
opened cursors current 842 789
workarea memory allocated 10,010 7,179
logons current 1,214 1,123

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 17 17.19

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 68,758 19 5.15 1.00 180,841 51 597 4.17
OPER_INDEX_DATA 50,074 14 5.81 1.00 92,235 26 183 15.14
UNDOTBS1 10 0 5.00 1.00 10,632 3 28 0.36
PERF_DATA 883 0 5.90 1.00 9,717 3 35 7.43
RES_CONF_DATA 3,726 1 0.52 1.01 4,906 1 347 1.50
PERF_INDEX_DATA 1,873 1 5.22 1.00 3,497 1 76 0.66
ITCOL_INDEX_DATA 1,220 0 5.35 1.00 1,351 0 23 1.74
ITCOL_DATA 632 0 6.68 1.00 1,695 0 0 0.00
ALM_DATA 285 0 5.12 1.00 1,110 0 4 5.00
ALM_INDEX_DATA 157 0 4.46 1.00 918 0 1 0.00
SYSAUX 489 0 3.87 1.00 323 0 0 0.00
FLOW_DATA 594 0 1.11 1.00 18 0 0 0.00
RES_CONF_INDEX_DATA 73 0 4.66 1.00 323 0 0 0.00
SYSTEM 168 0 5.60 1.00 218 0 4 0.00
REP_DATA 117 0 0.00 1.00 38 0 0 0.00
TEMP 50 0 3.60 11.14 0 0 5 10.00
REP_INDEX_DATA 18 0 0.00 1.00 9 0 0 0.00
FLOW_INDEX_DATA 9 0 0.00 1.00 9 0 0 0.00
UNDOTBS2 9 0 0.00 1.00 9 0 10 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 17 0 4.12 1.00 364 0 1 0.00
ALM_DATA +DG/vam/datafile/alm_data02.dbf 268 0 5.19 1.00 746 0 3 6.67
ALM_INDEX_DATA +DG/vam/datafile/alm_index_data01.dbf 45 0 5.56 1.00 463 0 1 0.00
ALM_INDEX_DATA +DG/vam/datafile/alm_index_data02.dbf 112 0 4.02 1.00 455 0 0 0.00
FLOW_DATA +DG/vam/datafile/flow_data_01.dbf 99 0 1.01 1.00 9 0 0 0.00
FLOW_DATA +DG/vam/datafile/flow_data_02.dbf 495 0 1.13 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 179 0 7.88 1.00 708 0 0 0.00
ITCOL_DATA +DG/vam/datafile/itcol_data_02.dbf 284 0 6.80 1.00 716 0 0 0.00
ITCOL_DATA +DG/vam/datafile/itcol_data_03.dbf 169 0 5.21 1.00 271 0 0 0.00
ITCOL_INDEX_DATA +DG/vam/datafile/itcol_index_data_01.dbf 165 0 5.82 1.00 191 0 1 0.00
ITCOL_INDEX_DATA +DG/vam/datafile/itcol_index_data_02.dbf 143 0 7.55 1.00 169 0 1 0.00
ITCOL_INDEX_DATA +DG/vam/datafile/itcol_index_data_03.dbf 104 0 6.63 1.00 161 0 1 0.00
ITCOL_INDEX_DATA +DG/vam/datafile/itcol_index_data_04.dbf 136 0 4.71 1.00 159 0 6 3.33
ITCOL_INDEX_DATA +DG/vam/datafile/itcol_index_data_06.dbf 160 0 4.19 1.00 184 0 4 0.00
ITCOL_INDEX_DATA +DG/vam/datafile/itcol_index_data_07.dbf 237 0 5.82 1.00 206 0 4 5.00
ITCOL_INDEX_DATA +DG/vam/datafile/itcol_index_data_08.dbf 176 0 4.55 1.00 188 0 5 0.00
ITCOL_INDEX_DATA +DG/vam/datafile/itcol_index_data_09.dbf 99 0 3.13 1.00 93 0 1 0.00
OPER_DATA +DG/vam/datafile/oper_data01.dbf 321 0 6.23 1.00 872 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data02.dbf 436 0 5.48 1.00 967 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data03.dbf 345 0 5.51 1.00 888 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data04.dbf 308 0 5.36 1.00 810 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data05.dbf 330 0 6.18 1.00 817 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data06.dbf 333 0 5.74 1.00 832 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data07.dbf 296 0 5.14 1.00 1,113 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data08.dbf 342 0 5.44 1.00 930 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data09.dbf 307 0 5.77 1.00 920 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data10.dbf 317 0 5.87 1.00 1,609 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data100.dbf 246 0 4.72 1.00 692 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data101.dbf 403 0 4.69 1.00 789 0 70 1.00
OPER_DATA +DG/vam/datafile/oper_data102.dbf 302 0 5.46 1.00 597 0 1 0.00
OPER_DATA +DG/vam/datafile/oper_data103.dbf 317 0 4.92 1.00 914 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data104.dbf 288 0 4.69 1.00 462 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data105.dbf 286 0 5.31 1.00 443 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data106.dbf 284 0 4.26 1.00 629 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data107.dbf 284 0 3.49 1.00 480 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data108.dbf 279 0 4.80 1.00 457 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data109.dbf 267 0 4.34 1.00 511 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data11.dbf 307 0 5.34 1.00 927 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data110.dbf 276 0 5.33 1.00 865 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data111.dbf 277 0 3.86 1.00 397 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data112.dbf 297 0 4.95 1.00 427 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data113.dbf 294 0 5.27 1.00 753 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data114.dbf 311 0 4.69 1.00 577 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data115.dbf 287 0 4.49 1.00 508 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data116.dbf 306 0 4.41 1.00 491 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data117.dbf 300 0 4.50 1.00 423 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data118.dbf 297 0 4.24 1.00 445 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data119.dbf 313 0 4.79 1.00 475 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data12.dbf 299 0 5.65 1.00 900 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data120.dbf 293 0 4.54 1.00 401 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data121.dbf 270 0 4.78 1.00 385 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data122.dbf 269 0 5.09 1.00 760 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data123.dbf 277 0 4.73 1.00 436 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data124.dbf 257 0 4.94 1.00 438 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data125.dbf 261 0 4.41 1.00 420 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data126.dbf 447 0 5.32 1.00 1,163 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data127.dbf 384 0 5.76 1.00 1,130 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data128.dbf 451 0 5.21 1.00 1,246 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data129.dbf 480 0 5.10 1.00 1,376 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data13.dbf 280 0 5.36 1.00 830 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data130.dbf 472 0 5.40 1.00 1,428 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data131.dbf 492 0 5.22 1.00 1,431 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data132.dbf 473 0 5.33 1.00 1,159 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data133.dbf 443 0 5.35 1.00 1,201 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data134.dbf 441 0 5.12 1.00 1,466 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data135.dbf 452 0 5.86 1.00 1,138 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data136.dbf 463 0 5.16 1.00 1,156 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data137.dbf 545 0 4.90 1.00 1,185 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data138.dbf 465 0 4.71 1.00 1,080 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data139.dbf 482 0 5.33 1.00 1,318 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data14.dbf 297 0 5.15 1.00 851 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data140.dbf 440 0 5.52 1.00 1,512 0 33 0.00
OPER_DATA +DG/vam/datafile/oper_data141.dbf 309 0 4.56 1.00 1,094 0 174 0.00
OPER_DATA +DG/vam/datafile/oper_data142.dbf 355 0 4.65 1.00 1,321 0 110 0.09
OPER_DATA +DG/vam/datafile/oper_data143.dbf 340 0 4.18 1.00 1,084 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data144.dbf 448 0 6.03 1.00 1,558 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data145.dbf 421 0 5.01 1.00 1,410 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data146.dbf 404 0 5.17 1.00 1,346 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data147.dbf 439 0 4.69 1.00 1,372 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data148.dbf 411 0 5.38 1.00 928 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data149.dbf 410 0 5.07 1.00 861 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data15.dbf 309 0 5.34 1.00 986 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data150.dbf 419 0 5.23 1.00 1,021 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data151.dbf 401 0 4.69 1.00 1,070 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data152.dbf 448 0 5.00 1.00 946 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data153.dbf 409 0 4.77 1.00 823 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data154.dbf 387 0 5.14 1.00 920 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data155.dbf 427 0 4.92 1.00 1,489 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data156.dbf 453 0 5.08 1.00 1,456 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data157.dbf 412 0 4.73 1.00 1,177 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data158.dbf 403 0 5.86 1.00 826 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data159.dbf 392 0 5.10 1.00 863 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data16.dbf 313 0 5.65 1.00 923 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data160.dbf 414 0 5.87 1.00 1,042 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data161.dbf 450 0 5.67 1.00 947 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data162.dbf 431 0 4.78 1.00 1,107 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data163.dbf 415 0 5.06 1.00 1,190 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data164.dbf 415 0 5.06 1.00 993 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data165.dbf 429 0 5.76 1.00 1,073 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data166.dbf 434 0 5.07 1.00 947 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data167.dbf 445 0 5.53 1.00 940 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data168.dbf 454 0 4.80 1.00 961 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data169.dbf 395 0 4.51 1.00 870 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data17.dbf 321 0 5.48 1.00 1,299 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data170.dbf 401 0 5.36 1.00 842 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data171.dbf 416 0 4.95 1.00 996 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data172.dbf 408 0 5.00 1.00 973 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data173.dbf 382 0 4.74 1.00 917 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data174.dbf 393 0 4.81 1.00 936 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data176.dbf 388 0 4.66 1.00 765 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data177.dbf 378 0 5.42 1.00 1,103 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data178.dbf 377 0 4.85 1.00 874 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data179.dbf 334 0 4.37 1.00 808 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data18.dbf 322 0 5.96 1.00 948 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data180.dbf 374 0 4.92 1.00 898 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data181.dbf 439 0 4.53 1.00 953 0 3 0.00
OPER_DATA +DG/vam/datafile/oper_data182.dbf 467 0 4.90 1.00 1,069 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data183.dbf 396 0 5.76 1.00 1,077 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data184.dbf 351 0 4.67 1.00 938 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data185.dbf 343 0 5.04 1.00 985 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data186.dbf 405 0 4.74 1.00 1,185 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data187.dbf 405 0 5.36 1.00 899 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data188.dbf 410 0 4.76 1.00 1,073 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data189.dbf 421 0 5.68 1.00 934 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data19.dbf 324 0 5.80 1.00 1,080 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data190.dbf 348 0 4.74 1.00 1,096 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data191.dbf 393 0 5.29 1.00 1,224 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data192.dbf 348 0 5.80 1.00 979 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data193.dbf 379 0 5.59 1.00 921 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data194.dbf 361 0 4.99 1.00 876 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data195.dbf 341 0 4.66 1.00 851 0 38 3.42
OPER_DATA +DG/vam/datafile/oper_data196.dbf 376 0 4.68 1.00 971 0 59 17.63
OPER_DATA +DG/vam/datafile/oper_data197.dbf 362 0 5.72 1.00 976 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data198.dbf 350 0 5.31 1.00 1,079 0 109 11.38
OPER_DATA +DG/vam/datafile/oper_data199.dbf 364 0 5.60 1.00 886 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data20.dbf 317 0 6.50 1.00 1,095 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data21.dbf 294 0 5.34 1.00 868 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data22.dbf 328 0 5.85 1.00 918 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data23.dbf 332 0 5.87 1.00 901 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data24.dbf 312 0 5.26 1.00 880 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data25.dbf 328 0 6.01 1.00 1,336 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data26.dbf 333 0 6.16 1.00 963 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data27.dbf 319 0 4.95 1.00 868 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data28.dbf 309 0 5.11 1.00 804 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data29.dbf 332 0 5.60 1.00 795 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data30.dbf 476 0 3.82 1.00 767 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data31.dbf 319 0 5.64 1.00 840 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data32.dbf 320 0 5.75 1.00 916 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data33.dbf 307 0 6.61 1.00 846 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data34.dbf 338 0 6.07 1.00 1,042 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data35.dbf 339 0 5.60 1.00 960 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data36.dbf 314 0 5.38 1.00 950 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data37.dbf 327 0 5.99 1.00 942 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data39.dbf 347 0 5.42 1.00 977 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data40.dbf 353 0 5.75 1.00 990 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data41.dbf 341 0 6.07 1.00 893 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data42.dbf 334 0 5.60 1.00 918 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data43.dbf 337 0 5.55 1.00 780 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data44.dbf 339 0 5.55 1.00 1,186 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data45.dbf 358 0 5.59 1.00 1,215 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data46.dbf 353 0 5.30 1.00 940 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data47.dbf 308 0 5.16 1.00 772 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data48.dbf 313 0 5.02 1.00 869 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data49.dbf 298 0 4.87 1.00 831 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data50.dbf 304 0 5.33 1.00 826 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data51.dbf 345 0 5.39 1.00 797 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data52.dbf 318 0 5.94 1.00 781 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data53.dbf 338 0 5.74 1.00 733 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data54.dbf 310 0 5.03 1.00 776 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data55.dbf 268 0 4.81 1.00 618 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data56.dbf 285 0 5.65 1.00 641 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data57.dbf 287 0 4.77 1.00 966 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data58.dbf 287 0 5.40 1.00 748 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data59.dbf 333 0 4.86 1.00 842 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data60.dbf 329 0 5.02 1.00 712 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data61.dbf 325 0 5.48 1.00 772 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data62.dbf 336 0 5.09 1.00 829 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data63.dbf 346 0 5.09 1.00 1,057 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data64.dbf 328 0 5.30 1.00 936 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data65.dbf 296 0 5.41 1.00 952 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data66.dbf 314 0 5.13 1.00 784 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data67.dbf 329 0 5.17 1.00 721 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data68.dbf 315 0 4.79 1.00 767 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data69.dbf 307 0 5.37 1.00 715 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data70.dbf 298 0 3.96 1.00 710 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data71.dbf 333 0 4.86 1.00 781 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data72.dbf 339 0 4.90 1.00 785 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data73.dbf 307 0 5.21 1.00 691 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data74.dbf 416 0 4.90 1.00 955 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data75.dbf 425 0 4.99 1.00 895 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data76.dbf 435 0 5.10 1.00 916 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data77.dbf 380 0 4.87 1.00 934 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data78.dbf 335 0 4.99 1.00 922 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data79.dbf 368 0 5.22 1.00 882 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data80.dbf 338 0 5.15 1.00 856 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data81.dbf 371 0 5.61 1.00 814 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data82.dbf 315 0 4.57 1.00 946 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data83.dbf 302 0 4.90 1.00 988 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data84.dbf 268 0 4.70 1.00 1,011 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data85.dbf 278 0 4.82 1.00 951 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data86.dbf 404 0 5.69 1.00 1,068 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data87.dbf 297 0 4.58 1.00 1,126 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data88.dbf 296 0 4.86 1.00 995 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data89.dbf 241 0 4.19 1.00 1,096 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data90.dbf 247 0 4.25 1.00 1,104 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data91.dbf 254 0 4.69 1.00 927 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data92.dbf 250 0 4.40 1.00 941 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data93.dbf 246 0 4.63 1.00 833 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data94.dbf 229 0 4.41 1.00 760 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data95.dbf 227 0 4.63 1.00 694 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data96.dbf 238 0 4.37 1.00 873 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data97.dbf 247 0 4.21 1.00 810 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data98.dbf 261 0 4.21 1.00 521 0 0 0.00
OPER_DATA +DG/vam/datafile/oper_data99.dbf 230 0 4.22 1.00 636 0 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data01.dbf 2,424 1 6.00 1.00 3,976 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data02.dbf 2,396 1 5.65 1.00 4,119 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data03.dbf 2,251 1 6.01 1.00 4,130 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data04.dbf 2,197 1 6.05 1.00 3,975 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data05.dbf 2,205 1 6.04 1.00 3,819 1 140 16.50
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data06.dbf 2,425 1 5.64 1.00 4,027 1 28 15.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data07.dbf 2,148 1 5.81 1.00 3,943 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data08.dbf 1,902 1 5.99 1.00 3,966 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data09.dbf 2,245 1 5.59 1.00 4,233 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data10.dbf 2,219 1 5.70 1.00 4,001 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data11.dbf 2,177 1 5.93 1.00 4,567 1 1 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data12.dbf 2,492 1 6.15 1.00 5,281 1 12 3.33
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data13.dbf 2,446 1 5.75 1.00 4,656 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data14.dbf 2,296 1 5.57 1.00 4,353 1 1 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data15.dbf 2,317 1 5.87 1.00 4,369 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data16.dbf 2,235 1 5.83 1.00 4,092 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data17.dbf 2,407 1 5.86 1.00 4,395 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data18.dbf 2,230 1 5.53 1.00 4,215 1 1 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data19.dbf 2,256 1 5.59 1.00 4,090 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data20.dbf 2,627 1 5.83 1.00 4,378 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data21.dbf 1,984 1 5.83 1.00 3,743 1 0 0.00
OPER_INDEX_DATA +DG/vam/datafile/oper_index_data22.dbf 2,195 1 5.60 1.00 3,907 1 0 0.00
PERF_DATA +DG/vam/datafile/perf_data01.dbf 691 0 6.12 1.00 8,053 2 32 5.00
PERF_DATA +DG/vam/datafile/perf_data02.dbf 192 0 5.10 1.00 1,664 0 3 33.33
PERF_INDEX_DATA +DG/vam/datafile/perf_index_data01.dbf 333 0 5.26 1.00 600 0 18 1.11
PERF_INDEX_DATA +DG/vam/datafile/perf_index_data02.dbf 593 0 5.60 1.00 1,324 0 44 0.68
PERF_INDEX_DATA +DG/vam/datafile/perf_index_data03.dbf 396 0 5.18 1.00 794 0 8 0.00
PERF_INDEX_DATA +DG/vam/datafile/perf_index_data04.dbf 551 0 4.83 1.00 779 0 6 0.00
REP_DATA +DG/vam/datafile/rep_data01.dbf 18 0 0.00 1.00 9 0 0 0.00
REP_DATA +DG/vam/datafile/rep_data02.dbf 27 0 0.00 1.00 11 0 0 0.00
REP_DATA +DG/vam/datafile/rep_data03.dbf 36 0 0.00 1.00 9 0 0 0.00
REP_DATA +DG/vam/datafile/rep_data04.dbf 36 0 0.00 1.00 9 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 3,726 1 0.52 1.01 4,906 1 347 1.50
RES_CONF_INDEX_DATA +DG/vam/datafile/res_conf_index_data01.dbf 73 0 4.66 1.00 323 0 0 0.00
SYSAUX +DG/vam/datafile/sysaux.262.702665593 489 0 3.87 1.00 323 0 0 0.00
SYSTEM +DG/vam/datafile/system.260.702665563 168 0 5.60 1.00 218 0 4 0.00
TEMP +DG/vam/tempfile/temp06.dbf 50 0 3.60 11.14 0 0 5 10.00
UNDOTBS1 +DG/vam/datafile/undotbs1.261.702665567 10 0 5.00 1.00 10,632 3 28 0.36
UNDOTBS2 +DG/vam/datafile/undotbs2.264.702665599 9 0 0.00 1.00 9 0 10 0.00
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 -3,169,050,401 114,188 587,110 0 0 1,315
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 14 46681 699449 737280 737280 2284031  
E 0 13 51363 625279 737280 737280 2106505  

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.92 15,376,337,235
D 1,024 0.19 122,816 1.96 3,383,063,122
D 1,536 0.29 184,224 1.30 2,248,404,457
D 2,048 0.39 245,632 1.12 1,931,651,186
D 2,560 0.49 307,040 1.05 1,808,364,648
D 3,072 0.58 368,448 1.02 1,765,519,988
D 3,584 0.68 429,856 1.01 1,747,085,164
D 4,096 0.78 491,264 1.01 1,736,777,611
D 4,608 0.88 552,672 1.00 1,730,123,150
D 5,120 0.97 614,080 1.00 1,725,623,551
D 5,264 1.00 631,351 1.00 1,724,648,844
D 5,632 1.07 675,488 1.00 1,722,130,522
D 6,144 1.17 736,896 1.00 1,719,751,157
D 6,656 1.26 798,304 1.00 1,717,913,062
D 7,168 1.36 859,712 1.00 1,716,396,294
D 7,680 1.46 921,120 0.99 1,714,642,431
D 8,192 1.56 982,528 0.99 1,711,322,117
D 8,704 1.65 1,043,936 0.99 1,704,543,161
D 9,216 1.75 1,105,344 0.98 1,694,033,530
D 9,728 1.85 1,166,752 0.97 1,679,093,712
D 10,240 1.95 1,228,160 0.95 1,642,429,054

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,039 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 102 3,026.10 9.78 0.32 100.00 0.00 166,700
E 1,628 185 2,588.33 7.01 0.27 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 27,584 27,584 0 0
64K 128K 91 91 0 0
256K 512K 3 3 0 0
512K 1024K 2,875 2,875 0 0
1M 2M 1,737 1,737 0 0
64M 128M 4 4 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,167,028.35 6,812,398.04 48.00 334,098
407 0.25 6,167,028.35 6,809,645.32 48.00 334,087
814 0.50 6,167,028.35 6,419,210.80 49.00 311,880
1,221 0.75 6,167,028.35 1,095,447.32 85.00 37,403
1,628 1.00 6,167,028.35 227,040.68 96.00 1,209
1,954 1.20 6,167,028.35 139,736.23 98.00 95
2,279 1.40 6,167,028.35 139,115.82 98.00 0
2,605 1.60 6,167,028.35 139,115.82 98.00 0
2,930 1.80 6,167,028.35 139,115.82 98.00 0
3,256 2.00 6,167,028.35 139,115.82 98.00 0
4,884 3.00 6,167,028.35 139,115.82 98.00 0
6,512 4.00 6,167,028.35 139,115.82 98.00 0
9,768 6.00 6,167,028.35 139,115.82 98.00 0
13,024 8.00 6,167,028.35 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 192 16,451 19,257,367 0.74 6,844,609 99.79 1,388,031,010
432 0.26 361 30,405 22,968,221 0.88 3,133,755 45.69 1,391,260,793
608 0.37 533 44,624 24,835,338 0.95 1,266,638 18.47 1,393,027,868
784 0.47 707 59,211 25,460,882 0.98 641,094 9.35 1,393,946,594
960 0.58 882 73,691 25,713,773 0.99 388,203 5.66 1,394,459,281
1,136 0.68 1,057 88,319 25,823,642 0.99 278,334 4.06 1,394,778,882
1,312 0.79 1,232 103,621 25,913,818 1.00 188,158 2.74 1,395,006,236
1,488 0.89 1,407 119,176 25,967,851 1.00 134,125 1.96 1,395,183,684
1,664 1.00 1,582 134,110 26,033,384 1.00 68,592 1.00 1,395,323,971
1,840 1.11 1,757 149,484 26,066,409 1.00 35,567 0.52 1,395,436,381
2,016 1.21 1,932 165,336 26,104,333 1.00 1 0.00 1,395,531,927
2,192 1.32 2,107 179,847 26,143,384 1.00 1 0.00 1,395,613,654
2,368 1.42 2,282 195,163 26,170,024 1.01 1 0.00 1,395,681,590
2,544 1.53 2,457 210,890 26,191,769 1.01 1 0.00 1,395,739,220
2,720 1.63 2,632 227,350 26,229,515 1.01 1 0.00 1,395,793,927
2,896 1.74 2,807 243,826 26,234,405 1.01 1 0.00 1,395,839,852
3,072 1.85 2,984 259,968 26,246,987 1.01 1 0.00 1,395,880,623
3,248 1.95 3,159 275,278 26,253,145 1.01 1 0.00 1,395,915,561
3,424 2.06 3,424 303,270 26,259,189 1.01 1 0.00 1,395,948,563

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,757,897 15,367,654,483
4,000 0.50 11,561,877 1,930,571,727
6,000 0.75 10,695,764 1,764,488,059
8,000 1.00 10,536,660 1,724,648,675
10,000 1.25 10,508,211 1,715,508,037
12,000 1.50 10,439,724 1,693,087,604
14,000 1.75 10,280,620 1,641,520,609
16,000 2.00 10,280,620 1,641,520,609

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,215 6 5
segment header 8 0 6
1st level bmb 52 0 0
undo block 12 0 1
undo header 26 0 0
2nd level bmb 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
WF-AWR Flush 21 21 0 12 4 319.50
FB-Format Block 8,955 8,955 0 4,536 4 0.81
TC-Tablespace Checkpoint 3 3 0 1 3 2,852.00
TX-Transaction (index contention) 336 332 0 202 3 13.92
TM-DML 398,030 398,484 0 1,141 1 0.58
HW-Segment High Water Mark 3,672 3,672 0 647 0 0.74
TT-Tablespace 2,183 2,183 0 477 0 0.75
CF-Controlfile Transaction 8,727 8,725 2 196 0 0.99
RO-Multiple Object Reuse (fast object reuse) 820 820 0 396 0 0.47
KO-Multiple Object Checkpoint (fast object checkpoint) 368 368 0 183 0 0.52
PS-PX Process Reservation 160 160 0 121 0 0.78
JQ-Job Queue 46 8 38 40 0 0.93
TA-Instance Undo 23 23 0 23 0 1.00
SQ-Sequence Cache 1,915 1,915 0 9 0 2.33
RS-Reclaimable Space (prevent file delete) 32 32 0 17 0 1.00
US-Undo Segment 21 21 0 9 0 1.11
WL-Being Written Redo Log 17 17 0 9 0 1.11
PI-Remote PX Process Spawn Status 6 6 0 6 0 0.83
TX-Transaction (allocate ITL entry) 10 10 0 10 0 0.40
TX-Transaction 292,708 293,599 0 1 0 4.00
BR-Backup/Restore (file shrink) 5 5 0 2 0 0.50
AF-Advisor Framework (task serialization) 7 7 0 1 0 1.00
CT-Block Change Tracking (state) 1 1 0 1 0 1.00
TX-Transaction (row lock contention) 2 2 0 1 0 1.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 02:08 24,294 47,364 5,948 8 436 0/0 0/0/0/0/0/0
09-Feb 01:58 18,687 55,177 5,341 8 438 0/0 0/0/0/0/0/0
09-Feb 01:48 26,997 24,352 4,735 9 440 0/0 0/0/0/0/0/0
09-Feb 01:38 23,455 38,719 4,128 7 448 0/0 0/0/0/0/0/0
09-Feb 01:28 23,355 63,983 3,521 8 450 0/0 0/0/0/0/0/0
09-Feb 01:18 23,162 58,699 2,914 7 454 0/0 0/0/0/0/0/0
09-Feb 01:08 22,690 53,583 2,307 10 456 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 1,796 0.00   0 0  
ASM db client latch 3,252 0.00   0 0  
ASM map headers 1,161 0.00   0 0  
ASM map load waiting list 372 0.00   0 0  
ASM map operation freelist 2,072 0.14 0.00 0 0  
ASM map operation hash table 3,240,450 0.01 0.00 0 0  
ASM network background latch 2,824 0.00   0 0  
AWR Alerted Metric Element list 85,723 0.00   0 0  
Consistent RBA 265,363 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 289 0.00   0 0  
FOB s.o list latch 51,275 0.03 0.00 0 0  
JS broadcast add buf latch 811 0.00   0 0  
JS broadcast drop buf latch 811 0.00   0 0  
JS broadcast load blnc latch 709 0.00   0 0  
JS mem alloc latch 12 0.00   0 0  
JS queue access latch 12 0.00   0 0  
JS queue state obj latch 21,270 0.00   0 0  
KCL gc element parent latch 4,852,483 0.06 0.04 0 45,560 0.27
KFK SGA context latch 9,950 0.00   0 0  
KFMD SGA 3,472 0.06 0.00 0 0  
KJC message pool free list 209,974 0.64 0.00 0 9,165 0.50
KJCT flow control latch 2,263,893 0.04 0.00 0 0  
KMG MMAN ready and startup request latch 1,180 0.00   0 0  
KSXR large replies 238 0.00   0 0  
KTF sga latch 24 0.00   0 1,128 0.00
KWQMN job cache list latch 282 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
MQL Tracking Latch 0     0 71 0.00
Memory Management Latch 0     0 1,180 0.00
OS process 9,717 0.00   0 0  
OS process allocation 7,567 0.04 0.00 0 0  
OS process: request allocation 6,351 0.02 0.00 0 0  
PL/SQL warning settings 3,370 0.00   0 0  
SGA IO buffer pool latch 749 0.53 0.00 0 749 0.80
SQL memory manager latch 13 0.00   0 1,179 0.00
SQL memory manager workarea list latch 101,093 0.00 0.00 0 0  
Shared B-Tree 129 0.00   0 0  
X$KSFQP 16 0.00   0 0  
active checkpoint queue latch 277,664 3.96 0.00 0 0  
active service list 22,853 0.09 0.52 0 4,659 0.00
archive control 118 0.00   0 0  
archive process latch 1,423 0.00   0 0  
begin backup scn array 104 0.00   0 0  
business card 24 0.00   0 0  
cache buffer handles 196,799 0.00 0.00 0 0  
cache buffers chains 2,304,165,460 1.62 0.00 0 1,584,872 0.01
cache buffers lru chain 1,804,425 0.20 0.00 0 1,017,697 0.10
cache table scan latch 0     0 54 5.56
channel handle pool latch 6,359 0.05 0.00 0 0  
channel operations parent latch 1,030,315 0.00 0.00 0 0  
checkpoint queue latch 12,924,471 0.01 0.00 0 783,000 0.01
client/application info 17,379 0.00   0 0  
commit callback allocation 6 0.00   0 0  
compile environment latch 3,238 0.00   0 0  
dictionary lookup 6 0.00   0 0  
dml lock allocation 800,948 1.30 0.00 0 0  
dummy allocation 6,567 0.11 0.00 0 0  
enqueue hash chains 2,440,829 0.10 0.00 0 2,052 0.00
enqueues 576,111 0.26 0.00 0 0  
error message lists 48 0.00   0 0  
event group latch 3,130 0.00   0 0  
file cache latch 4,111 0.00   0 0  
gcs opaque info freelist 2,253,438 0.23 0.00 0 0  
gcs partitioned table hash 14,965,722 0.00   0 252,278 0.00
gcs remastering latch 1,543,948 0.00 48.44 0 0  
gcs resource freelist 621,598 0.01 0.00 0 284,910 0.00
gcs resource hash 7,123,829 0.04 0.00 0 90 0.00
gcs resource scan list 180 0.00   0 0  
gcs shadows freelist 1,331,275 0.01 0.00 0 1,156,525 0.00
ges caches resource lists 866,283 0.20 0.00 0 548,408 0.07
ges deadlock list 41,136 0.00   0 15 0.00
ges domain table 1,270,824 0.01 0.00 0 0  
ges enqueue table freelist 1,337,326 0.08 0.00 0 0  
ges group table 1,584,428 0.06 0.00 0 0  
ges process hash list 199,902 0.00   0 0  
ges process parent latch 2,499,804 0.00   0 0  
ges process table freelist 6,351 0.03 0.00 0 0  
ges resource hash list 1,727,163 0.04 0.00 0 113,728 0.03
ges resource scan list 246 0.00   0 0  
ges resource table freelist 183,777 0.00 0.00 0 0  
ges synchronous data 64 0.00   0 2,586 0.15
ges timeout list 18,416 0.01 0.00 0 19,944 0.00
global KZLD latch for mem in SGA 3,121 0.00   0 0  
hash table column usage latch 1,529 0.00   0 184,107 0.00
hash table modification latch 364 0.00   0 0  
internal temp table object number allocation latc 2 0.00   0 0  
job workq parent latch 0     0 16 0.00
job_queue_processes parameter latch 66 0.00   0 0  
kks stats 94,432 0.03 0.00 0 0  
kokc descriptor allocation latch 496 0.00   0 0  
krbmrosl 50 0.00   0 0  
ksuosstats global area 238 0.00   0 0  
ktm global data 933 0.00   0 0  
kwqbsn:qsga 128 0.00   0 0  
lgwr LWN SCN 266,386 0.09 0.00 0 0  
library cache 2,167,566 0.22 0.00 0 65,067 0.05
library cache load lock 11,658 0.01 0.00 0 0  
library cache lock 822,060 0.02 0.00 0 0  
library cache lock allocation 37,486 0.01 0.00 0 0  
library cache pin 692,009 0.03 0.00 0 2 0.00
library cache pin allocation 8,452 0.00   0 0  
list of block allocation 98,973 0.00 0.00 0 0  
loader state object freelist 8,374 2.01 0.00 0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 9,299 0.00   0 10 0.00
message pool operations parent latch 2,333 0.00   0 0  
messages 1,704,775 0.76 0.00 0 0  
mostly latch-free SCN 274,175 1.81 0.00 0 0  
msg queue 308 0.00   0 308 0.00
multiblock read objects 6,780 0.03 0.00 0 0  
name-service memory objects 25,246 0.00 0.00 0 0  
name-service namespace bucket 40,852 0.00   0 0  
name-service namespace objects 48 0.00   0 0  
name-service pending queue 13,098 0.00   0 0  
name-service request 36 5.56 0.00 0 0  
name-service request queue 48,081 0.01 0.00 0 0  
ncodef allocation latch 95 0.00   0 0  
object queue header heap 3,472 0.00   0 3,889 0.00
object queue header operation 3,526,846 0.07 0.02 0 0  
object stats modification 19 0.00   0 0  
parallel query alloc buffer 1,380 0.07 0.00 0 0  
parallel query stats 136 0.74 0.00 0 0  
parallel txn reco latch 18,308 0.00   0 0  
parameter list 19,607 0.00   0 0  
parameter table allocation management 6,567 0.00   0 0  
post/wait queue 354,804 0.01 0.00 0 239,945 0.43
process allocation 34,181 0.11 0.78 0 3,127 0.10
process group creation 6,351 0.03 0.00 0 0  
process queue 378 0.00   0 0  
process queue reference 9,292 0.00   0 996 0.00
qmn state object latch 2 0.00   0 0  
qmn task queue latch 522 0.00   0 0  
query server freelists 284 0.35 0.00 0 0  
query server process 6 0.00   0 6 0.00
queued dump request 16,852 0.00   0 0  
redo allocation 824,076 0.26 0.00 0 7,352,297 0.29
redo copy 0     0 7,358,721 0.06
redo writing 1,094,467 0.79 0.00 0 0  
resmgr group change latch 3,522 0.00   0 0  
resmgr:active threads 6,562 0.00   0 0  
resmgr:actses change group 3,229 0.00   0 0  
resmgr:free threads list 6,561 0.20 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 2,657,667 0.12 0.00 0 10,661 0.32
rules engine aggregate statistics 3 0.00   0 0  
rules engine rule set statistics 106 0.00   0 0  
segmented array pool 289 0.00   0 0  
sequence cache 291,066 0.29 0.00 0 0  
session allocation 1,218,913 0.70 0.00 0 0  
session idle bit 15,893,402 0.03 0.00 0 0  
session state list latch 6,704 0.07 0.00 0 0  
session switching 95 0.00   0 0  
session timer 1,959 0.00   0 0  
shared pool 967,886 0.08 0.08 0 0  
shared pool simulator 1,792,066 0.01 0.01 0 0  
simulator hash latch 68,847,214 0.01 0.00 0 0  
simulator lru latch 0     0 68,797,072 2.48
slave class 1,131 0.00   0 0  
slave class create 665 0.15 1.00 0 0  
sort extent pool 1,122 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 336 0.00   0 0  
temporary table state object allocation 12 33.33 0.00 0 0  
threshold alerts latch 601 0.00   0 0  
transaction allocation 582,322 0.00   0 0  
transaction branch allocation 1,959 0.00   0 0  
undo global data 1,177,900 0.04 0.00 0 0  
user lock 12,902 0.15 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 2,304,165,460 37,236,979 12,271 37,225,604 0 0 0
session allocation 1,218,913 8,544 3 8,541 0 0 0
library cache 2,167,566 4,808 1 4,807 0 0 0
session idle bit 15,893,402 4,162 8 4,154 0 0 0
simulator hash latch 68,847,214 4,091 2 4,089 0 0 0
cache buffers lru chain 1,804,425 3,537 4 3,533 0 0 0
row cache objects 2,657,667 3,237 1 3,236 0 0 0
gcs resource hash 7,123,829 2,970 2 2,968 0 0 0
KCL gc element parent latch 4,852,483 2,683 108 2,576 0 0 0
enqueue hash chains 2,440,829 2,510 1 2,509 0 0 0
object queue header operation 3,526,846 2,315 38 2,277 0 0 0
KJC message pool free list 209,974 1,346 1 1,345 0 0 0
shared pool 967,886 744 60 684 0 0 0
shared pool simulator 1,792,066 103 1 102 0 0 0
process allocation 34,181 36 28 8 0 0 0
active service list 22,853 21 11 12 0 0 0
gcs remastering latch 1,543,948 9 436 0 0 0 0
slave class create 665 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 kclrwrite 0 85 116
KCL gc element parent latch kclbla 0 76 2
KCL gc element parent latch kclnfndnewm 0 53 33
KCL gc element parent latch kclwrt 0 48 24
KCL gc element parent latch kclfwrite1 0 44 75
KCL gc element parent latch kclplz 0 12 9
KCL gc element parent latch kcllwr 0 6 7
KCL gc element parent latch kclfwrite2 0 5 1
KCL gc element parent latch KCLUNLNK 0 2 28
KCL gc element parent latch kclnfnd 0 2 9
KCL gc element parent latch kclpdc_3 0 2 3
KCL gc element parent latch kclebs 0 1 0
KCL gc element parent latch kclexpand 0 1 0
KCL gc element parent latch kclgcr 0 1 0
KCL gc element parent latch kclpto 0 1 0
KCL gc element parent latch kclzcl 0 1 5
KJC message pool free list kjcsmpav: allocate a msg buffer 0 1 1
active service list ksws_event: ksws event 0 12 12
cache buffers chains kcbgtcr: kslbegin excl 0 68,790 64,468
cache buffers chains kcbrls: kslbegin 0 2,676 7,682
cache buffers chains kcbgtcr: fast path 0 495 53
cache buffers chains kclwrt 0 413 1
cache buffers chains kcbgcur: kslbegin 0 93 64
cache buffers chains kcbbxsv 0 80 484
cache buffers chains kcbget: pin buffer 0 76 45
cache buffers chains kclexpand 0 63 1
cache buffers chains kclbla 0 49 1
cache buffers chains kcbzwb 0 41 26
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 28 28
cache buffers chains kcbzgb: scan from tail. nowait 0 23 0
cache buffers chains kcbnew: new latch again 0 20 0
cache buffers chains kcbnlc 0 19 21
cache buffers chains kclcls_3 0 13 1
cache buffers chains kclebs_1 0 11 0
cache buffers chains kcllwr 0 7 2
cache buffers chains kcbbic1 0 4 3
cache buffers chains kcbchg: kslbegin: call CR func 0 4 22
cache buffers chains kclpdc_1 0 4 0
cache buffers chains kcbbic2 0 3 2
cache buffers chains kcbesc: escalate 0 3 1
cache buffers chains kclpred 0 3 0
cache buffers chains kcbget: exchange 0 2 6
cache buffers chains kcbget: exchange rls 0 2 4
cache buffers chains kclpto 0 2 0
cache buffers chains kcbgkcbcr 0 1 11
cache buffers chains kcbgtcr: kslbegin shared 0 1 1
cache buffers chains kcbzib: finish free bufs 0 1 9
cache buffers chains kclrwrite_1 0 1 0
cache buffers lru chain kcbbxsv: move to being written 0 2 4
cache buffers lru chain kcbzgws 0 2 0
enqueue hash chains ksqgtl3 0 1 1
gcs remastering latch 59 0 428 0
gcs remastering latch 69 0 7 0
gcs remastering latch 43 0 1 0
gcs resource hash kclfwrite1 0 1 0
gcs resource hash kjblocalfile_nolock 0 1 0
object queue header operation kcbo_switch_mq_bg 0 46 69
object queue header operation kcbo_switch_q_bg 0 29 14
object queue header operation kcbw_link_q 0 11 2
object queue header operation kcbw_unlink_q 0 9 3
object queue header operation kcbo_switch_cq 0 1 8
object queue header operation kcbo_write_q 0 1 0
object queue header operation kcbw_unlink_q_bg 0 1 2
process allocation ksudlp 0 10 12
process allocation ksucrp 0 9 0
process allocation ksufap: active procs 0 9 9
session allocation ksufap: active sessions 0 2 0
session allocation ksuxds: KSUSFCLC not set 0 1 0
session idle bit ksupuc: set busy 0 5 2
session idle bit ksupuc: clear busy 0 2 5
session idle bit ksuxds 0 2 2
shared pool kghalo 0 49 25
shared pool kghfrunp: alloc: wait 0 5 0
shared pool kghupr1 0 5 25
shared pool kghasp 0 1 3
shared pool kghfrunp: clatch: nowait 0 1 0
shared pool kghfrunp: clatch: wait 0 1 0
shared pool simulator kglsim_unpin_simhp 0 1 0
simulator hash latch kcbsacc: lookup dba 0 2 2
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 582,243,280 51.32
VAMT ALM_DATA FSTI_ALARM_TRANS   TABLE 462,680,160 40.79
VAMT ALM_DATA FSTI_ALARM_CURRENT   TABLE 57,419,408 5.06
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN P_20120208 INDEX PARTITION 4,522,704 0.40
VAMT OPER_DATA PROD_FZ_PHONENEWSPAPER_STATUS   TABLE 3,744,480 0.33

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
VAMT OPER_DATA LOCAL_WAP20_MSISDN P_20120205 INDEX PARTITION 19,803 15.33
VAMT OPER_DATA LOCAL_WAP20_MSISDN P_20120204 INDEX PARTITION 19,265 14.91
VAMT OPER_DATA LOCAL_WAP20_MSISDN P_20120208 INDEX PARTITION 16,664 12.90
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN P_20120204 INDEX PARTITION 16,556 12.82
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN P_20120205 INDEX PARTITION 15,685 12.14

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 48 16.90
VAMT OPER_INDEX_DATA UK_PROD_RES_NE_DETECT_LOG   INDEX 25 8.80
VAMT OPER_INDEX_DATA IND_LC_WAP20_SPDOMAIN P_20120208 INDEX PARTITION 23 8.10
VAMT OPER_DATA LOCAL_WAP20_MSISDN P_20120205 INDEX PARTITION 23 8.10
VAMT OPER_DATA LOCAL_WAP20_MSISDN P_20120208 INDEX PARTITION 19 6.69

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 2 40.00
VAMT ALM_INDEX_DATA LOCAL_ALARM_STATUS_LASTNODE US20120301 INDEX PARTITION 1 20.00
VAMT ITCOL_INDEX_DATA PK_HOST_STORAGE_ID   INDEX 1 20.00
VAMT PERF_INDEX_DATA PK_PERF_INTERFACE_H_MAX_ID   INDEX 1 20.00

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_20120208 TABLE PARTITION 319 56.06