WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
ACSDB3302263338acsdb2210.2.0.5.0YESOMP-ACS-DB2

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:58114-3ÔÂ -13 15:00:371206 .5
End Snap:58314-3ÔÂ -13 17:27:591145 .5
Elapsed:  147.37 (mins)  
DB Time:  53.57 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 29,328M 29,328MStd Block Size: 8K
Shared Pool Size: 3,344M 3,344MLog Buffer: 14,272K

Load Profile

Per SecondPer Transaction
Redo size: 9,886.93 1,880.01
Logical reads: 8,794.59 1,672.31
Block changes: 67.52 12.84
Physical reads: 4.06 0.77
Physical writes: 1.89 0.36
User calls: 203.05 38.61
Parses: 73.04 13.89
Hard parses: 0.80 0.15
Sorts: 41.49 7.89
Logons: 3.42 0.65
Executes: 71.13 13.53
Transactions: 5.26 

% Blocks changed per Read: 0.77Recursive Call %: 52.91
Rollback per transaction %: 2.50Rows per Sort: 26.77

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 100.05In-memory Sort %: 100.00
Library Hit %: 98.32Soft Parse %: 98.90
Execute to Parse %: -2.69Latch Hit %: 99.85
Parse CPU to Parse Elapsd %: 80.39% Non-Parse CPU: 96.97

Shared Pool Statistics

BeginEnd
Memory Usage %: 82.63 85.12
% SQL with executions>1: 91.57 99.63
% Memory for SQL w/exec>1: 91.03 99.37

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
enq: WF - contention 10,930 5,319 487 165.5Other
CPU time  3,956  123.1 
log file sync 46,457 49 1 1.5Commit
latch free 3,506 48 14 1.5Other
latch: library cache lock 154 41 263 1.3Concurrency

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 1.39 0.27
Global Cache blocks served: 2.26 0.43
GCS/GES messages received: 15.64 2.97
GCS/GES messages sent: 16.20 3.08
DBWR Fusion writes: 0.18 0.03
Estd Interconnect traffic (KB) 35.42 

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

Buffer access - local cache %: 100.03
Buffer access - remote cache %: 0.02
Buffer access - disk %: -0.05

Global Cache and Enqueue Services - Workload Characteristics

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.1
Avg message sent queue time on ksxp (ms): 0.2
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.1
Avg GES message process time (ms): 0.0
% of direct sent messages: 16.38
% of indirect sent messages: 23.32
% of flow controlled messages: 60.30


Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU 3,955.72 123.07
sql execute elapsed time 1,822.24 56.69
connection management call elapsed time 215.60 6.71
parse time elapsed 148.33 4.61
hard parse elapsed time 43.99 1.37
sequence load elapsed time 9.09 0.28
PL/SQL execution elapsed time 8.65 0.27
failed parse elapsed time 0.21 0.01
PL/SQL compilation elapsed time 0.14 0.00
hard parse (sharing criteria) elapsed time 0.11 0.00
repeated bind elapsed time 0.01 0.00
hard parse (bind mismatch) elapsed time 0.01 0.00
DB time 3,214.13  
background elapsed time 5,621.52  
background cpu time 163.96  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%Total Call Time
Other 613,661 20 5,400 9 168.00
CPU time     3,956   123.07
Concurrency 10,803 0 98 9 3.04
System I/O 193,089   61 0 1.89
Commit 46,457 0 49 1 1.52
User I/O 38,266   15 0 0.46
Cluster 15,201 0 10 1 0.33
Network 1,546,222   8 0 0.26
Application 3,447   3 1 0.09
Configuration 3,082 0 2 1 0.06

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
enq: WF - contention 10,930 99 5,319 487 0.24
log file sync 46,457 0 49 1 1.00
latch free 3,506   48 14 0.08
latch: library cache lock 154   41 263 0.00
control file sequential read 140,664   40 0 3.03
latch: cache buffers chains 3,216   34 11 0.07
log file parallel write 49,150   16 0 1.06
latch: session allocation 714   13 19 0.02
DFS lock handle 10,456   11 1 0.22
os thread startup 199   10 49 0.00
direct path read 29,547   9 0 0.64
db file sequential read 8,545   5 1 0.18
latch: library cache 44   5 122 0.00
gc current block 2-way 7,193   4 1 0.15
control file parallel write 3,075   4 1 0.07
SQL*Net more data to client 125,569   4 0 2.70
latch: shared pool 83   3 35 0.00
SQL*Net break/reset to client 2,998   3 1 0.06
enq: TX - index contention 49 8 3 52 0.00
gc cr block 2-way 4,550   2 1 0.10
row cache lock 6,656   2 0 0.14
SQL*Net message to client 1,410,371   2 0 30.33
enq: TX - contention 10 10 2 197 0.00
enq: HW - contention 3,066 0 2 1 0.07
SQL*Net message from dblink 942   1 1 0.02
gc current grant busy 2,042   1 1 0.04
CGS wait for IPC msg 85,029 100 1 0 1.83
gc current block busy 136   1 9 0.00
log file sequential read 104   1 10 0.00
enq: PS - contention 456 0 1 2 0.01
SQL*Net more data from client 8,440   1 0 0.18
name-service call wait 10   1 59 0.00
gcs log flush sync 603 1 1 1 0.01
cursor: pin S 462,826   1 0 9.95
gc buffer busy 102 1 0 5 0.00
gc cr block busy 307   0 2 0.01
PX Deq Credit: send blkd 1,114 61 0 0 0.02
ksxr poll remote instances 23,293 63 0 0 0.50
enq: TM - contention 445   0 1 0.01
reliable message 570   0 0 0.01
PX Deq: reap credit 12,327 92 0 0 0.27
rdbms ipc reply 668   0 0 0.01
undo segment extension 1 100 0 99 0.00
gc current multi block request 499   0 0 0.01
log file switch completion 4   0 22 0.00
gc current grant 2-way 218   0 0 0.00
PX Deq: Signal ACK 498 32 0 0 0.01
IPC send completion sync 207 100 0 0 0.00
CSS operation: query 18   0 3 0.00
gc cr multi block request 123   0 0 0.00
library cache lock 110   0 0 0.00
buffer busy waits 168   0 0 0.00
library cache pin 101   0 0 0.00
enq: FB - contention 81   0 0 0.00
Log archive I/O 88   0 0 0.00
Data file init write 42   0 1 0.00
enq: TA - contention 58   0 1 0.00
enq: SQ - contention 5   0 6 0.00
cursor: pin S wait on X 2 100 0 11 0.00
enq: CF - contention 43   0 0 0.00
gc cr grant 2-way 22   0 1 0.00
enq: TD - KTF dump entries 29   0 1 0.00
latch: row cache objects 20   0 1 0.00
direct path write 126   0 0 0.00
global enqueue expand wait 1 100 0 12 0.00
CSS initialization 6   0 2 0.00
wait list latch free 1   0 10 0.00
enq: JQ - contention 13   0 0 0.00
gc current split 9   0 0 0.00
LGWR wait for redo copy 124   0 0 0.00
enq: TX - allocate ITL entry 6   0 1 0.00
CSS operation: action 12   0 0 0.00
read by other session 2   0 1 0.00
enq: DR - contention 4   0 1 0.00
latch: ges resource hash list 27   0 0 0.00
enq: JS - job run lock - synchronize 5   0 0 0.00
log file single write 8   0 0 0.00
enq: TX - row lock contention 2   0 1 0.00
SQL*Net message to dblink 900   0 0 0.02
db file single write 4   0 0 0.00
enq: TT - contention 2   0 1 0.00
enq: PI - contention 2   0 0 0.00
enq: PW - flush prewarm buffers 2   0 0 0.00
enq: AF - task serialization 1   0 0 0.00
enq: WL - contention 1   0 0 0.00
buffer deadlock 9 100 0 0 0.00
latch: enqueue hash chains 1   0 0 0.00
latch: KCL gc element parent latch 3   0 0 0.00
latch: object queue header operation 1   0 0 0.00
cursor: mutex S 1   0 0 0.00
latch: messages 1   0 0 0.00
PX qref latch 1 100 0 0 0.00
SQL*Net message from client 1,439,633   9,252,925 6427 30.96
gcs remote message 2,455,814 94 68,978 28 52.81
jobq slave wait 13,769 96 39,512 2870 0.30
Streams AQ: qmn slave idle wait 940   17,191 18288 0.02
PX Idle Wait 4,323 93 10,165 2351 0.09
DIAG idle wait 44,170   8,632 195 0.95
ASM background timer 1,949   8,628 4427 0.04
Streams AQ: waiting for time management or cleanup tasks 832 68 8,628 10370 0.02
ges remote message 152,919 70 8,628 56 3.29
Streams AQ: qmn coordinator idle wait 802 40 8,623 10752 0.02
virtual circuit status 295 100 8,608 29180 0.01
class slave wait 879 86 8,530 9705 0.02
i/o slave wait 15,879   27 2 0.34
PX Deq: Execution Msg 1,098 12 6 6 0.02
single-task message 42   2 48 0.00
KSV master wait 67   2 30 0.00
PX Deq: Join ACK 541 34 1 2 0.01
PX Deq: Parse Reply 512 34 0 0 0.01
PX Deq: Execute Reply 457 33 0 0 0.01
PX Deq: Msg Fragment 414 10 0 0 0.01
Streams AQ: RAC qmn coordinator idle wait 802 95 0 0 0.02

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 49,150   16 0 1.06
events in waitclass Other 112,055 89 13 0 2.41
control file sequential read 23,518   10 0 0.51
os thread startup 199   10 49 0.00
control file parallel write 3,063   4 1 0.07
log file sequential read 104   1 10 0.00
enq: HW - contention 3,030   1 0 0.07
latch: cache buffers chains 7   1 73 0.00
gc cr block 2-way 740   0 0 0.02
gc current block 2-way 373   0 1 0.01
enq: TM - contention 443   0 0 0.01
db file sequential read 8   0 7 0.00
Log archive I/O 88   0 0 0.00
direct path write 112   0 0 0.00
gc current grant busy 20   0 0 0.00
log file single write 8   0 0 0.00
library cache lock 3   0 0 0.00
direct path read 144   0 0 0.00
gc cr grant 2-way 1   0 0 0.00
gc current grant 2-way 1   0 0 0.00
buffer busy waits 2   0 0 0.00
rdbms ipc message 262,340 49 145,836 556 5.64
gcs remote message 2,455,834 94 68,978 28 52.81
Streams AQ: qmn slave idle wait 940   17,191 18288 0.02
DIAG idle wait 44,171   8,632 195 0.95
ASM background timer 1,949   8,628 4427 0.04
Streams AQ: waiting for time management or cleanup tasks 832 68 8,628 10370 0.02
ges remote message 152,925 70 8,628 56 3.29
smon timer 1,806   8,625 4776 0.04
Streams AQ: qmn coordinator idle wait 802 40 8,623 10752 0.02
pmon timer 7,988 100 8,605 1077 0.17
class slave wait 819 92 8,530 10415 0.02
KSV master wait 39   1 21 0.00
Streams AQ: RAC qmn coordinator idle wait 802 95 0 0 0.02

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 622,643
IDLE_TIME 27,667,135
IOWAIT_TIME 6,301
NICE_TIME 779
SYS_TIME 315,649
USER_TIME 293,596
LOAD 0
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 2,761,657,344
VM_OUT_BYTES 1,642,057,728
PHYSICAL_MEMORY_BYTES 67,561,590,784
NUM_CPUS 32
NUM_CPU_SOCKETS 4

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
acsdb 3,115.50 3,856.20 35,681 77,479,175
SYS$USERS 97.70 99.10 54 124,352
SYS$BACKGROUND 0.80 0.20 180 159,518
acsdbXDB 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
acsdb 29674 11 9661 81 0 0 1420737 8
SYS$USERS 8174 3 153 6 0 0 8746 0
SYS$BACKGROUND 418 0 986 11 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
203 171 62,299 0.00 6.31 az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
130 133 513 0.25 4.05 d3rgr1ugyfy4v   select * from ( select temp.* ...
87 89 513 0.17 2.72 9j3v93dcqd1ng   select count(*) from (select c...
74 75 3 24.61 2.30 6p18ng82999p1 oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
71 72 3 23.51 2.19 36pd7s33q8t3d oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
70 71 201 0.35 2.17 04v68mrc0ndtt   select * from ( select temp.* ...
49 50 2 24.38 1.52 gtct3f6rqmt7k   BEGIN proc_tb_server_kpi(:1, :...
49 50 2 24.38 1.52 aucbhp050unfp   INSERT INTO TB_SERVER_KPI (SER...
37 14 142 0.26 1.14 0s07s16dca7m1 sqlplus@OMP-ACS-DB2 (TNS V1-V3) select STATUS from v$datafile
35 36 81 0.44 1.10 b6sts095f7490   select * from ( select temp.* ...
33 30 29,054 0.00 1.01 0k8522rmdzg4k   select privilege# from sysauth...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total% Total DB Time SQL IdSQL ModuleSQL Text
171 203 62,299 0.00 4.31 6.31 az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
133 130 513 0.26 3.36 4.05 d3rgr1ugyfy4v   select * from ( select temp.* ...
89 87 513 0.17 2.24 2.72 9j3v93dcqd1ng   select count(*) from (select c...
75 74 3 25.02 1.90 2.30 6p18ng82999p1 oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
72 71 3 24.01 1.82 2.19 36pd7s33q8t3d oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
71 70 201 0.35 1.80 2.17 04v68mrc0ndtt   select * from ( select temp.* ...
50 49 2 24.93 1.26 1.52 gtct3f6rqmt7k   BEGIN proc_tb_server_kpi(:1, :...
50 49 2 24.93 1.26 1.52 aucbhp050unfp   INSERT INTO TB_SERVER_KPI (SER...
36 35 81 0.45 0.91 1.10 b6sts095f7490   select * from ( select temp.* ...
33 32 84 0.39 0.83 1.00 8qk3ffrqfu5mj   select count(*) from (select a...

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
5,882,466 201 29,266.00 7.56 71.33 69.84 04v68mrc0ndtt   select * from ( select temp.* ...
5,562,376 513 10,842.84 7.15 132.73 130.22 d3rgr1ugyfy4v   select * from ( select temp.* ...
4,195,133 513 8,177.65 5.39 88.64 87.35 9j3v93dcqd1ng   select count(*) from (select c...
3,398,736 62,299 54.56 4.37 170.56 202.65 az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
1,989,183 84 23,680.75 2.56 32.67 32.05 8qk3ffrqfu5mj   select count(*) from (select a...
1,677,348 81 20,708.00 2.16 36.10 35.44 b6sts095f7490   select * from ( select temp.* ...
1,293,709 12,809 101.00 1.66 13.84 13.68 chvsc0kcnaygf   select * from ( select t.adver...
1,144,800 10,800 106.00 1.47 11.25 10.79 gxa2gs64zaq6p   select * from ( select temp.* ...
1,119,016 3 373,005.33 1.44 72.02 70.52 36pd7s33q8t3d oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
1,119,015 3 373,005.00 1.44 75.05 73.84 6p18ng82999p1 oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
1,088,881 10,781 101.00 1.40 9.60 9.62 fkwdf31hccvwp   select * from ( select t.adver...
1,087,871 10,771 101.00 1.40 9.83 9.72 10rj3nwvwud4n   select * from ( select t.adver...
945,158 9,358 101.00 1.22 9.84 9.72 4bkajwhn01bf4   select m.* from (select t.adve...
939,600 10,800 87.00 1.21 8.96 10.33 4aa2pajm13day   select count(*) from tb_articl...
842,951 627 1,344.42 1.08 2.96 2.91 d5vargfkqu6jk   select * from ( select temp.* ...

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
71 18,112 0.00 0.20 7.41 8.73 1dm5vg7s11jyj   insert into TB_MAP_SERVICE_REC...
63 10,833 0.01 0.18 13.88 18.63 f7wycxzwr231m JDBC Thin Client insert into TB_ACCOUNT_INTERFA...
9 2 4.50 0.03 0.11 0.12 0dwr2vd6vbqzs   SELECT count(*) over () as tot...
9 1 9.00 0.03 0.27 0.32 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
4 1 4.00 0.01 9.19 9.18 572fbaj0fdw2b sqlplus.exe select output from table(dbms_...
2 13 0.15 0.01 0.00 0.02 1yyh2fdqqguz8   INSERT INTO sys.wri$_adv_findi...
2 86 0.02 0.01 0.02 0.05 3m8smr0v7v1m6   INSERT INTO sys.wri$_adv_messa...
1 53 0.02 0.00 0.01 0.01 5h7w8ykwtb2xt   INSERT INTO SYS.WRI$_ADV_PARAM...
0 10 0.00 0.00 0.00 0.00 04p9rnacfgfsn   INSERT INTO sys.wri$_adv_objec...
0 201 0.00 0.00 71.33 69.84 04v68mrc0ndtt   select * from ( select temp.* ...

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
62,299 0 0.00 0.00 0.00 az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
59,391 2,176 0.04 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
29,054 59,391 2.04 0.00 0.00 0k8522rmdzg4k   select privilege# from sysauth...
28,653 28,653 1.00 0.00 0.00 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
28,653 28,653 1.00 0.00 0.00 459f3z9u4fb3u   select value$ from props$ wher...
28,366 28,366 1.00 0.00 0.00 5ur69atw3vfhj   select decode(failover_method,...
20,293 0 0.00 0.00 0.00 a4m2hmf2qhtv7   select tbtestwhit0_.wl_id as w...
18,112 18,112 1.00 0.00 0.00 1dm5vg7s11jyj   insert into TB_MAP_SERVICE_REC...
18,112 18,112 1.00 0.00 0.00 d5y11r44hs4cv   select TB_MAP_SERVICE_RECORD_S...
12,809 0 0.00 0.00 0.00 chvsc0kcnaygf   select * from ( select t.adver...
11,131 11,131 1.00 0.00 0.00 8g02qq5sb8gkk JDBC Thin Client INSERT INTO TB_AUTH_LOG(LOG_ID...
10,833 10,833 1.00 0.00 0.00 dtrjpdn3fw6as JDBC Thin Client select TB_ACCOUNT_INTERFACE_LO...
10,833 10,833 1.00 0.00 0.00 f7wycxzwr231m JDBC Thin Client insert into TB_ACCOUNT_INTERFA...
10,800 10,800 1.00 0.00 0.00 4aa2pajm13day   select count(*) from tb_articl...
10,800 75,600 7.00 0.00 0.00 gxa2gs64zaq6p   select * from ( select temp.* ...
10,793 68,763 6.37 0.00 0.00 asycs9abcdt1k JDBC Thin Client SELECT TP.ID, TP.SP_ID, TP.SP_...
10,781 0 0.00 0.00 0.00 fkwdf31hccvwp   select * from ( select t.adver...
10,780 10,780 1.00 0.00 0.00 9w01ztmr4569k   select count(*) from tb_articl...
10,779 32,337 3.00 0.00 0.00 3r189y4actbt2   select * from ( select temp.* ...
10,772 10,772 1.00 0.00 0.00 6n4k1dy5nbu1y   select decode(t.content_flag, ...
10,771 0 0.00 0.00 0.00 10rj3nwvwud4n   select * from ( select t.adver...
9,794 287 0.03 0.00 0.00 3ccv18hhd0w69   select this_.COLUMN_ID as COLU...
9,358 9,349 1.00 0.00 0.00 4bkajwhn01bf4   select m.* from (select t.adve...
9,349 9,349 1.00 0.00 0.00 c68x2drb8jh6f   SELECT T.LABEL_ID, T.LABEL_NAM...
9,103 8,446 0.93 0.00 0.00 5kt6k7qwjz6fu JDBC Thin Client select * from (select t.*, row...
8,129 8,129 1.00 0.00 0.00 apxtnc1vs9dqu   select tdict0_.ID as ID156_, t...
6,489 0 0.00 0.00 0.00 bw2rqq1s3bzrd   select tbtestwhit0_.wl_id as w...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
62,300 62,299 9.65 az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
59,391 59,391 9.20 0h6b2sajwb74n   select privilege#, level from ...
29,054 29,054 4.50 0k8522rmdzg4k   select privilege# from sysauth...
28,653 28,653 4.44 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
28,653 28,653 4.44 459f3z9u4fb3u   select value$ from props$ wher...
28,366 28,366 4.39 5ur69atw3vfhj   select decode(failover_method,...
20,293 20,293 3.14 a4m2hmf2qhtv7   select tbtestwhit0_.wl_id as w...
18,112 18,112 2.80 1dm5vg7s11jyj   insert into TB_MAP_SERVICE_REC...
18,112 18,112 2.80 d5y11r44hs4cv   select TB_MAP_SERVICE_RECORD_S...
12,809 12,809 1.98 chvsc0kcnaygf   select * from ( select t.adver...
11,131 11,131 1.72 8g02qq5sb8gkk JDBC Thin Client INSERT INTO TB_AUTH_LOG(LOG_ID...
10,833 10,833 1.68 dtrjpdn3fw6as JDBC Thin Client select TB_ACCOUNT_INTERFACE_LO...
10,833 10,833 1.68 f7wycxzwr231m JDBC Thin Client insert into TB_ACCOUNT_INTERFA...
10,800 10,800 1.67 4aa2pajm13day   select count(*) from tb_articl...
10,800 10,800 1.67 gxa2gs64zaq6p   select * from ( select temp.* ...
10,793 10,793 1.67 asycs9abcdt1k JDBC Thin Client SELECT TP.ID, TP.SP_ID, TP.SP_...
10,781 10,781 1.67 fkwdf31hccvwp   select * from ( select t.adver...
10,780 10,780 1.67 9w01ztmr4569k   select count(*) from tb_articl...
10,779 10,779 1.67 3r189y4actbt2   select * from ( select temp.* ...
10,772 10,772 1.67 6n4k1dy5nbu1y   select decode(t.content_flag, ...
10,771 10,771 1.67 10rj3nwvwud4n   select * from ( select t.adver...
9,794 9,794 1.52 3ccv18hhd0w69   select this_.COLUMN_ID as COLU...
9,358 9,358 1.45 4bkajwhn01bf4   select m.* from (select t.adve...
9,349 9,349 1.45 c68x2drb8jh6f   SELECT T.LABEL_ID, T.LABEL_NAM...
9,103 9,103 1.41 5kt6k7qwjz6fu JDBC Thin Client select * from (select t.*, row...
8,129 8,129 1.26 apxtnc1vs9dqu   select tdict0_.ID as ID156_, t...
6,489 6,489 1.00 bw2rqq1s3bzrd   select tbtestwhit0_.wl_id as w...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
21 5,198 4m7m0t6fjcs5x   update seq$ set increment$=:2,...

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
2.05 10.98 18.63 13.88 10,833 f7wycxzwr231m JDBC Thin Client insert into TB_ACCOUNT_INTERFA...
1.57 7.98 19.73 17.90 11,131 8g02qq5sb8gkk JDBC Thin Client INSERT INTO TB_AUTH_LOG(LOG_ID...
1.17 5.34 21.95 8.35 247 bcz7kcb5nhjfv   insert into tb_user_oper_log (...
0.69 19.62 3.51 2.95 5,198 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
0.42 4.84 8.73 7.41 18,112 1dm5vg7s11jyj   insert into TB_MAP_SERVICE_REC...
0.23 6.91 3.39 3.25 9,103 5kt6k7qwjz6fu JDBC Thin Client select * from (select t.*, row...
0.16 0.18 87.35 88.64 513 9j3v93dcqd1ng   select count(*) from (select c...
0.13 0.86 14.93 15.15 627 2ug5va58ks6nc   select count(*) from tb_articl...
0.11 4.31 2.59 2.33 10,833 dtrjpdn3fw6as JDBC Thin Client select TB_ACCOUNT_INTERFACE_LO...
0.10 0.08 130.22 132.73 513 d3rgr1ugyfy4v   select * from ( select temp.* ...
0.04 0.13 32.05 32.67 84 8qk3ffrqfu5mj   select count(*) from (select a...
0.04 0.41 9.18 9.19 1 572fbaj0fdw2b sqlplus.exe select output from table(dbms_...
0.03 0.02 202.65 170.56 62,299 az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
0.03 0.74 4.63 4.44 18,112 d5y11r44hs4cv   select TB_MAP_SERVICE_RECORD_S...
0.03 0.32 10.33 8.96 10,800 4aa2pajm13day   select count(*) from tb_articl...
0.03 0.08 35.44 36.10 81 b6sts095f7490   select * from ( select temp.* ...
0.02 0.03 73.84 75.05 3 6p18ng82999p1 oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
0.02 0.18 10.79 11.25 10,800 gxa2gs64zaq6p   select * from ( select temp.* ...
0.02 0.37 4.92 4.91 10,780 9w01ztmr4569k   select count(*) from tb_articl...
0.02 5.07 0.32 0.27 1 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
0.02 0.03 48.76 49.86 2 aucbhp050unfp   INSERT INTO TB_SERVER_KPI (SER...
0.02 0.03 48.76 49.86 2 gtct3f6rqmt7k   BEGIN proc_tb_server_kpi(:1, :...
0.01 0.02 70.52 72.02 3 36pd7s33q8t3d oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
0.01 0.15 6.85 5.63 10,779 3r189y4actbt2   select * from ( select temp.* ...
0.01 2.63 0.36 0.35 3 5f4v2996x0tqf PL/SQL Developer select /*+rule*/ * from sys.al...
0.01 26.15 0.03 0.03 2 31a13pnjps7j3   SELECT source, (case when time...
0.01 4.15 0.12 0.11 2 0dwr2vd6vbqzs   SELECT count(*) over () as tot...
0.01 0.17 2.91 2.96 627 d5vargfkqu6jk   select * from ( select temp.* ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
04p9rnacfgfsnINSERT INTO sys.wri$_adv_objects (task_id, id, type, attr1, attr2, attr3, attr4, attr5)VALUES(:1, :2, :3, :4, :5, :6, ' ', :7) RETURNING rowid into :8
04v68mrc0ndttselect * from ( select temp.* , rownum num from ( select t.eillegal_loc_id, t.illegal_loc, t.longitude, t.latitude, t.illegal_num, t.sort_no, t.update_time, (select tr.reason_desc from tb_eillegal_reason_info tr where tr.illegal_reason_id =(select max(t1.illegal_reason_id) from tb_eillegal_reason_info t1 where t1.eillegal_loc_id = t.eillegal_loc_id and t1.vote_num = (select max(t2.vote_num) from tb_eillegal_reason_info t2 where t2.eillegal_loc_id = t.eillegal_loc_id))) reason from tb_eillegal_loc_info t where t.city_id=591 order by t.illegal_num desc¡¡) temp where rownum <= 10 ) where¡¡num > 0
0dwr2vd6vbqzs SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0s07s16dca7m1select STATUS from v$datafile
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
10rj3nwvwud4nselect * from ( select t.advert_id, t.ad_code, t.ad_name, t.ad_width, t.ad_height, t.ad_type, t.city_id, t.column_id, t.access_type, t.ad_enable, t.ad_status, t.remark, t.operator, t1.matter_id, t1.matter_name, t1.matter_type, t1.matter_width, t1.matter_height, t1.matter_desc, t1.matter_url, t1.matter_title, t1.status, t1.upload_time, t1.url from tb_advert t, tb_matter t1, tb_ad_publish t2 where t.advert_id=t2.advert_id and t2.matter_id=t1.matter_id and t.area_code = '591' and t.ad_code ='WEB_INDEX_1' and t.ad_enable=1 and t.access_type=1 and t1.status=2 and t2.status =1 and sysdate >= t2.start_time and sysdate < t2.end_time order by t1.update_time desc ) where rownum<2
1dm5vg7s11jyjinsert into TB_MAP_SERVICE_RECORD (APP_DOMAIN, CALL_TIME, CALL_INTF, RECORD_ID) values (:1, :2, :3, :4)
1yyh2fdqqguz8INSERT INTO sys.wri$_adv_findings (id, task_id, type, parent, obj_id, impact_msg_id, impact_val, msg_id, more_info_id) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9)
2ug5va58ks6ncselect count(*) from tb_article a, tb_article_content b, tb_article_desc c where a.status = 2 and a.content_id = b.content_id and a.content_id = c.content_id and exists (select content_id from tb_article_content_relation where column_id = :1 and content_id = a.content_id)
31a13pnjps7j3 SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
36pd7s33q8t3dSELECT "A1"."COLLECT_TYPE", NVL(SUM("A1"."FAIL_REQ_NUM"), 0) FROM "TB_SERVER_LOG" "A1" WHERE TO_CHAR("A1"."COLLECT_TIME", 'yyyy-mm-dd hh24:mi')>:1 AND TO_CHAR("A1"."COLLECT_TIME", 'yyyy-mm-dd hh24:mi')<=:2 AND ("A1"."COLLECT_TYPE"=1 OR "A1"."COLLECT_TYPE"=2) GROUP BY "A1"."COLLECT_TYPE"
3ccv18hhd0w69select this_.COLUMN_ID as COLUMN1_130_0_, this_.TEMP_ID as TEMP2_130_0_, this_.NAME as NAME130_0_, this_.CNNAME as CNNAME130_0_, this_.FILENAME as FILENAME130_0_, this_.CONTENT as CONTENT130_0_, this_.URL as URL130_0_, this_.STATUS as STATUS130_0_, this_.TYPE as TYPE130_0_, this_.REMARK as REMARK130_0_, this_.CITY_ID as CITY11_130_0_, this_.UPDATE_TIME as UPDATE12_130_0_, this_.HIDE_COLUMN as HIDE13_130_0_, this_.HAS_PAGE as HAS14_130_0_, this_.HAS_INFO as HAS15_130_0_, this_.PARENT_ID as PARENT16_130_0_ from TB_PAGE_CONTENT this_ where (this_.COLUMN_ID=:1 and this_.TYPE=:2)
3m8smr0v7v1m6INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
3r189y4actbt2select * from ( select temp.* , rownum num from ( select a.content_id, to_char(c.release_date, 'yyyy-mm-dd hh24:mi:ss') insert_date_yymmdd, c.title, c.short_title, to_char(c.release_date, 'yyyy-mm-dd hh24:mi:ss') release_date, nvl(c.image_path, '/images/common/noimg.gif') image_path, c.top_content from tb_article a, tb_article_desc c where a.status = 2 and a.content_id = c.content_id and exists (select content_id from tb_article_content_relation where column_id = 10591031 and content_id = a.content_id) order by c.top_content desc, c.release_date desc, c.content_id desc¡¡) temp where rownum <= 3 ) where¡¡num > 0
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
4aa2pajm13dayselect count(*) from tb_article a, tb_article_desc c where a.status = 2 and a.content_id = c.content_id and exists (select content_id from tb_article_content_relation where column_id = 10591023 and content_id = a.content_id)
4bkajwhn01bf4select m.* from (select t.advert_id, t.ad_code, t.ad_name, t.ad_width, t.ad_height, t.ad_type, t.city_id, t.column_id, t.access_type, t.ad_enable, t.ad_status, t.remark, t.operator, t1.matter_id, t1.matter_name, t1.matter_type, t1.matter_width, t1.matter_height, t1.matter_desc, t1.matter_url, t1.matter_title, t1.status, t1.upload_time, t1.url from tb_advert t, tb_matter t1, tb_ad_publish t2 where t.advert_id=t2.advert_id and t2.matter_id=t1.matter_id and t.area_code=:1 and t.ad_code =:2 and t.ad_enable=1 and t.access_type=2 and t1.status=2 and t2.status =1 and sysdate >= t2.start_time and sysdate <end_time order by t1.UPDATE_TIME desc)m where rownum=1
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
572fbaj0fdw2bselect output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))
5f4v2996x0tqfselect /*+rule*/ * from sys.all_tab_partitions where table_name = :object_name and table_owner = :object_owner and trim(composite) in ('NO', 'N0') order by partition_position
5h7w8ykwtb2xtINSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID, NAME, DATATYPE, VALUE, FLAGS, DESCRIPTION) VALUES (:B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
5kt6k7qwjz6fuselect * from (select t.*, rownum rn from tb_portal_user t where 1=1 and t.mobile = :1 and rownum<= 10) where rn>= 1
5ur69atw3vfhjselect decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6n4k1dy5nbu1yselect decode(t.content_flag, 0, (select content_edit from tb_weibo_template where id=t.template_id), 1, t.content_edit, '') content_edit, decode(t.content_flag, 0, (select content_notedit from tb_weibo_template where id=t.template_id), 1, t.content_notedit, '') content_notedit, t.id, t.type, t.type_value, t.url, t.city_id, t.login_flag, t.login_reason, t.pic_url, t.access_type from tb_weibo_setting t where t.city_id=591 and t.access_type=1 and t.type=3
6p18ng82999p1SELECT "A1"."COLLECT_TYPE", NVL(SUM("A1"."SUCC_REQ_NUM"), 0) FROM "TB_SERVER_LOG" "A1" WHERE TO_CHAR("A1"."COLLECT_TIME", 'yyyy-mm-dd hh24:mi')>:1 AND TO_CHAR("A1"."COLLECT_TIME", 'yyyy-mm-dd hh24:mi')<=:2 AND ("A1"."COLLECT_TYPE"=1 OR "A1"."COLLECT_TYPE"=2) GROUP BY "A1"."COLLECT_TYPE"
8g02qq5sb8gkkINSERT INTO TB_AUTH_LOG(LOG_ID, THIRD_ID, SP_ID, LOG_TYPE, IP_ADDRESS, TOKEN_VALUE, ACCOUNT, ACCOUNT_TYPE, RESULT_TYPE, REMARK, RESP_CONT, REQUEST_PARAM) VALUES(SEQ_AUTH_LOG.NEXTVAL, :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11)
8qk3ffrqfu5mjselect count(*) from (select a.content_id, a.views_count, a.ups_count, c.title, c.short_title, b.column_id from tb_article a, tb_article_desc c, tb_article_content_relation b where a.status = 2 and a.content_id = c.content_id and a.content_id = b.content_id and b.column_id in (select column_id from tb_page_content t where t.status = 2 and t.type = 1 and (t.parent_id = 10591007 or t.column_id = 10591007))) f where f.content_id not in (select content_id from (select a.content_id from tb_article a, tb_article_desc c, tb_article_content_relation b where a.status = 2 and a.content_id = c.content_id and a.content_id = b.content_id and b.column_id in (select column_id from tb_page_content t where t.status = 2 and t.type = 1 and (t.parent_id = 10591007 or t.column_id = 10591007))) group by content_id having count(*) > 1)
9j3v93dcqd1ngselect count(*) from (select content_id, column_id from tb_article_content_relation t where column_id in (select column_id from tb_page_content t where t.status = 2 and t.type = 2 and t.parent_id = :1)) b, ( select a.content_id, to_char(a.insert_date, 'yyyy-mm-dd hh24:mi:ss') insert_date, c.title, to_char(c.release_date, 'yyyy-mm-dd hh24:mi:ss') release_date, to_char(c.release_date, 'yyyy-mm-dd') release_date_ymd, c.content_type, c.top_content, c.show_image from tb_article a, tb_article_content b, tb_article_desc c where a.status = 2 and a.content_id = b.content_id and a.content_id = c.content_id ) q where b.content_id=q.content_id
9w01ztmr4569kselect count(*) from tb_article a, tb_article_desc c where a.status = 2 and a.content_id = c.content_id and exists (select content_id from tb_article_content_relation where column_id = 10591031 and content_id = a.content_id)
a4m2hmf2qhtv7select tbtestwhit0_.wl_id as wl1_114_, tbtestwhit0_.wl_ip as wl2_114_, tbtestwhit0_.wl_phone as wl3_114_, tbtestwhit0_.wl_email as wl4_114_, tbtestwhit0_.Wl_url as Wl5_114_, tbtestwhit0_.wl_type as wl6_114_, tbtestwhit0_.is_valid as is7_114_ from TB_TEST_WHITE_LIST tbtestwhit0_ where tbtestwhit0_.is_valid=1
apxtnc1vs9dquselect tdict0_.ID as ID156_, tdict0_.GROUP_ID as GROUP2_156_, tdict0_.DICT_NAME as DICT3_156_, tdict0_.DICT_VALUE as DICT4_156_, tdict0_.DICT_INDEX as DICT5_156_, tdict0_.REMARK as REMARK156_ from T_DICT tdict0_, T_DICT_GROUP tdictgroup1_ where tdict0_.GROUP_ID=tdictgroup1_.ID and tdictgroup1_.GROUP_NAME=:1 and tdict0_.DICT_NAME=:2
asycs9abcdt1kSELECT TP.ID, TP.SP_ID, TP.SP_NAME, TP.PWD, TP.SECRET_KEY, TP.ENCRYT_TYPE, TP.DOMAIN_NAME, TP.ADD_USER_ID, TP.ADD_TIME, TP.STATUS, TP.BEGIN_TIME, TP.EXPIRE_TIME, TP.UPDATE_TIME, TP.REMARK, IL.IP_ADDRESS, IL.STATUS AS IP_STATUS, SC.AUTH_TYPE, S.S_NAME, S.S_URL, S.DIGIT_SIGNATURE, S.STATUS AS SERVICE_STATUS FROM TB_THIRD_PART TP, TB_IP_LIST IL, TB_IP_SERVICE_CONF SC, TB_SERVICE S WHERE TP.ID=IL.THIRD_ID AND IL.ID=SC.IP_LIST_ID AND SC.S_ID=S.S_ID AND TP.SP_ID = :1 AND TP.STATUS = :2 AND IL.STATUS = :3 AND S.STATUS = :4 AND S.S_ID = :5
aucbhp050unfpINSERT INTO TB_SERVER_KPI (SERVERKPI_ID, SUCC_REQ_NUM, FAIL_REQ_NUM, COLLECT_TYPE, COLLECT_TIME, IS_UP, CREATE_DATE ) SELECT TB_SERVER_KPI_SEQ.NEXTVAL, SUC, FAIL, COLLECT_TYPE, TO_DATE(:B1 , 'yyyy-mm-dd hh24:mi'), 0, :B3 FROM ( SELECT TUP.COLLECT_TYPE, SUM(TUP.SUCC_REQ_NUM) SUC, SUM(TUP.FAIL_REQ_NUM) FAIL FROM TB_SERVER_LOG TUP WHERE TO_CHAR(TUP.COLLECT_TIME, 'yyyy-mm-dd hh24:mi') > :B2 AND TO_CHAR(TUP.COLLECT_TIME, 'yyyy-mm-dd hh24:mi') <= :B1 AND TUP.COLLECT_TYPE IN(1, 2) GROUP BY TUP.COLLECT_TYPE)
az33m61ym46y4SELECT NULL AS table_cat, o.owner AS table_schem, o.object_name AS table_name, o.object_type AS table_type, NULL AS remarks FROM all_objects o WHERE o.owner LIKE :1 ESCAPE '/' AND o.object_name LIKE :2 ESCAPE '/' AND o.object_type IN ('xxx', 'TABLE') ORDER BY table_type, table_schem, table_name
b6sts095f7490select * from ( select temp.* , rownum num from ( select f.content_id, f.views_count, f.ups_count, f.title, f.short_title, f.column_id from (select a.content_id, a.views_count, a.ups_count, c.title, c.short_title, b.column_id from tb_article a, tb_article_desc c, tb_article_content_relation b where a.status = 2 and a.content_id = c.content_id and a.content_id = b.content_id and b.column_id in (select column_id from tb_page_content t where t.status = 2 and t.type = 1 and (t.parent_id = 10591007 or t.column_id = 10591007))) f where f.content_id not in (select content_id from (select a.content_id from tb_article a, tb_article_desc c, tb_article_content_relation b where a.status = 2 and a.content_id = c.content_id and a.content_id = b.content_id and b.column_id in (select column_id from tb_page_content t where t.status = 2 and t.type = 1 and (t.parent_id = 10591007 or t.column_id = 10591007))) group by content_id having count(*) > 1) order by nvl(f.views_count, 0) desc¡¡) temp where rownum <= 10 ) where¡¡num > 0
bcz7kcb5nhjfvinsert into tb_user_oper_log (user_oper_log_id, access_type, user_id, session_id, city_id, column_id, column_level, visit_type, ip, mac, entity_id, visit_url, visit_source_url, search_key, browser, operate_time, mobile, remark) values (tb_user_oper_log_seq.nextval, :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, TO_DATE(:15, 'YYYY-MM-dd HH24:mi:ss'), :16, :17)
bw2rqq1s3bzrdselect tbtestwhit0_.wl_id as wl1_121_, tbtestwhit0_.wl_ip as wl2_121_, tbtestwhit0_.wl_phone as wl3_121_, tbtestwhit0_.wl_email as wl4_121_, tbtestwhit0_.Wl_url as Wl5_121_, tbtestwhit0_.wl_type as wl6_121_, tbtestwhit0_.is_valid as is7_121_ from TB_TEST_WHITE_LIST tbtestwhit0_ where tbtestwhit0_.is_valid=1
c68x2drb8jh6fSELECT T.LABEL_ID, T.LABEL_NAME, T.LABEL_URL FROM TB_LABEL T WHERE T.IS_DISP = 0 AND T.STATUS = 0 AND T.LABEL_GROUP_CODE = 'LABEL_INDEX_JGG' AND T.CITY_ID = :1 AND rownum = 1
chvsc0kcnaygfselect * from ( select t.advert_id, t.ad_code, t.ad_name, t.ad_width, t.ad_height, t.ad_type, t.city_id, t.column_id, t.access_type, t.ad_enable, t.ad_status, t.remark, t.operator, t1.matter_id, t1.matter_name, t1.matter_type, t1.matter_width, t1.matter_height, t1.matter_desc, t1.matter_url, t1.matter_title, t1.status, t1.upload_time, t1.url from tb_advert t, tb_matter t1, tb_ad_publish t2 where t.advert_id=t2.advert_id and t2.matter_id=t1.matter_id and t.area_code = '591' and t.ad_code ='WEB_HEADTOP_1' and t.ad_enable=1 and t.access_type=1 and t1.status=2 and t2.status =1 and sysdate >= t2.start_time and sysdate < t2.end_time order by t1.update_time desc ) where rownum<2
d3rgr1ugyfy4vselect * from ( select temp.* , rownum num from ( select q.*, b.column_id from (select content_id, column_id from tb_article_content_relation t where column_id in (select column_id from tb_page_content t where t.status = 2 and t.type = 2 and t.parent_id = :1)) b, ( select a.content_id, to_char(a.insert_date, 'yyyy-mm-dd hh24:mi:ss') insert_date, c.title, to_char(c.release_date, 'yyyy-mm-dd hh24:mi:ss') release_date, to_char(c.release_date, 'yyyy-mm-dd') release_date_ymd, c.content_type, c.top_content, c.show_image from tb_article a, tb_article_content b, tb_article_desc c where a.status = 2 and a.content_id = b.content_id and a.content_id = c.content_id ) q where b.content_id=q.content_id order by q.release_date desc¡¡) temp where rownum <= :2 ) where¡¡num > :3
d5vargfkqu6jkselect * from ( select temp.* , rownum num from ( select a.content_id, to_char(a.insert_date, 'yyyy-mm-dd hh24:mi:ss') insert_date, c.title, to_char(c.release_date, 'yyyy-mm-dd hh24:mi:ss') release_date, to_char(c.release_date, 'yyyy-mm-dd') release_date_ymd, c.content_type, c.top_content, c.show_image from tb_article a, tb_article_content b, tb_article_desc c where a.status = 2 and a.content_id = b.content_id and a.content_id = c.content_id and exists (select content_id from tb_article_content_relation where column_id = :1 and content_id = a.content_id) order by c.top_content desc, c.release_date desc, a.content_id¡¡) temp where rownum <= :2 ) where¡¡num > :3
d5y11r44hs4cvselect TB_MAP_SERVICE_RECORD_SEQ.nextval from dual
d92h3rjp0y217begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
dtrjpdn3fw6asselect TB_ACCOUNT_INTERFACE_LOG_SEQ.nextval from dual
f7wycxzwr231minsert into TB_ACCOUNT_INTERFACE_LOG (CONTENT, IP, PORTAL_ACCOUNT, PORTAL_TYPE, REQUEST_TIME, RETURN_CODE, RETURN_INFO, RETURN_TIME, ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9)
fkwdf31hccvwpselect * from ( select t.advert_id, t.ad_code, t.ad_name, t.ad_width, t.ad_height, t.ad_type, t.city_id, t.column_id, t.access_type, t.ad_enable, t.ad_status, t.remark, t.operator, t1.matter_id, t1.matter_name, t1.matter_type, t1.matter_width, t1.matter_height, t1.matter_desc, t1.matter_url, t1.matter_title, t1.status, t1.upload_time, t1.url from tb_advert t, tb_matter t1, tb_ad_publish t2 where t.advert_id=t2.advert_id and t2.matter_id=t1.matter_id and t.area_code = '591' and t.ad_code ='WEB_INDEX_2' and t.ad_enable=1 and t.access_type=1 and t1.status=2 and t2.status =1 and sysdate >= t2.start_time and sysdate < t2.end_time order by t1.update_time desc ) where rownum<2
gtct3f6rqmt7kBEGIN proc_tb_server_kpi(:1, :2, :3); END;
gxa2gs64zaq6pselect * from ( select temp.* , rownum num from ( select a.content_id, to_char(c.release_date, 'yyyy-mm-dd hh24:mi:ss') insert_date_yymmdd, c.title, c.short_title, to_char(c.release_date, 'yyyy-mm-dd hh24:mi:ss') release_date, nvl(c.image_path, '/images/common/noimg.gif') image_path, c.top_content from tb_article a, tb_article_desc c where a.status = 2 and a.content_id = c.content_id and exists (select content_id from tb_article_content_relation where column_id = 10591023 and content_id = a.content_id) order by c.top_content desc, c.release_date desc, c.content_id desc¡¡) temp where rownum <= 7 ) where¡¡num > 0

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 213,206 24.11 4.59
CPU used when call started 209,684 23.71 4.51
CR blocks created 240 0.03 0.01
Cached Commit SCN referenced 740,318 83.73 15.92
Commit SCN cached 27 0.00 0.00
DB time 4,398,724 497.48 94.60
DBWR checkpoint buffers written 15,409 1.74 0.33
DBWR checkpoints 2 0.00 0.00
DBWR fusion writes 1,617 0.18 0.03
DBWR object drop buffers written 0 0.00 0.00
DBWR revisited being-written buffer 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 989 0.11 0.02
DBWR undo block writes 3,799 0.43 0.08
DFO trees parallelized 186 0.02 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 1,003 0.11 0.02
PX local messages sent 1,003 0.11 0.02
PX remote messages recv'd 687 0.08 0.01
PX remote messages sent 1,670 0.19 0.04
Parallel operations not downgraded 186 0.02 0.00
RowCR - row contention 0 0.00 0.00
RowCR attempts 557 0.06 0.01
RowCR hits 557 0.06 0.01
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 4 0.00 0.00
SQL*Net roundtrips to/from client 1,293,603 146.30 27.82
SQL*Net roundtrips to/from dblink 900 0.10 0.02
active txn count during cleanout 6,403 0.72 0.14
application wait time 294 0.03 0.01
background checkpoints completed 2 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 43,076 4.87 0.93
branch node splits 0 0.00 0.00
buffer is not pinned count 17,304,158 1,957.03 372.13
buffer is pinned count 39,656,808 4,485.02 852.83
bytes received via SQL*Net from client 240,822,072 27,236.00 5,178.97
bytes received via SQL*Net from dblink 310,206 35.08 6.67
bytes sent via SQL*Net to client 556,843,829 62,976.78 11,975.14
bytes sent via SQL*Net to dblink 275,803 31.19 5.93
calls to get snapshot scn: kcmgss 2,712,013 306.72 58.32
calls to kcmgas 83,317 9.42 1.79
calls to kcmgcs 2,893 0.33 0.06
change write time 737 0.08 0.02
cleanout - number of ktugct calls 3,681 0.42 0.08
cleanouts and rollbacks - consistent read gets 123 0.01 0.00
cleanouts only - consistent read gets 82 0.01 0.00
cluster key scan block gets 108,641 12.29 2.34
cluster key scans 87,492 9.89 1.88
cluster wait time 1,047 0.12 0.02
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 31 0.00 0.00
commit batch/immediate requested 31 0.00 0.00
commit cleanout failures: block lost 9 0.00 0.00
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 22 0.00 0.00
commit cleanout failures: cannot pin 123 0.01 0.00
commit cleanouts 123,814 14.00 2.66
commit cleanouts successfully completed 123,660 13.99 2.66
commit immediate performed 31 0.00 0.00
commit immediate requested 31 0.00 0.00
commit txn count during cleanout 16,077 1.82 0.35
concurrency wait time 9,780 1.11 0.21
consistent changes 198,070 22.40 4.26
consistent gets 76,674,960 8,671.63 1,648.92
consistent gets - examination 29,184,614 3,300.66 627.63
consistent gets direct 35,476 4.01 0.76
consistent gets from cache 76,639,484 8,667.61 1,648.16
current blocks converted for CR 0 0.00 0.00
cursor authentications 3,118 0.35 0.07
data blocks consistent reads - undo records applied 251 0.03 0.01
db block changes 597,002 67.52 12.84
db block gets 1,087,228 122.96 23.38
db block gets direct 37 0.00 0.00
db block gets from cache 1,087,191 122.96 23.38
deferred (CURRENT) block cleanout applications 51,179 5.79 1.10
dirty buffers inspected 0 0.00 0.00
enqueue conversions 2,913 0.33 0.06
enqueue releases 262,035 29.64 5.64
enqueue requests 262,067 29.64 5.64
enqueue timeouts 32 0.00 0.00
enqueue waits 4,293 0.49 0.09
exchange deadlocks 16 0.00 0.00
execute count 628,927 71.13 13.53
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 14,955 1.69 0.32
free buffer requested 63,498 7.18 1.37
gc CPU used by this session 4,737 0.54 0.10
gc blocks lost 0 0.00 0.00
gc cr block build time 71 0.01 0.00
gc cr block flush time 28 0.00 0.00
gc cr block receive time 185 0.02 0.00
gc cr block send time 34 0.00 0.00
gc cr blocks received 5,019 0.57 0.11
gc cr blocks served 7,026 0.79 0.15
gc current block flush time 32 0.00 0.00
gc current block pin time 140 0.02 0.00
gc current block receive time 306 0.03 0.01
gc current block send time 680 0.08 0.01
gc current blocks received 7,305 0.83 0.16
gc current blocks served 12,925 1.46 0.28
gc local grants 2,957 0.33 0.06
gc remote grants 2,292 0.26 0.05
gcs messages sent 111,749 12.64 2.40
ges messages sent 31,512 3.56 0.68
global enqueue get time 104,785 11.85 2.25
global enqueue gets async 7,130 0.81 0.15
global enqueue gets sync 185,885 21.02 4.00
global enqueue releases 179,528 20.30 3.86
heap block compress 141 0.02 0.00
hot buffers moved to head of LRU 6,628 0.75 0.14
immediate (CR) block cleanout applications 205 0.02 0.00
immediate (CURRENT) block cleanout applications 1,763 0.20 0.04
index crx upgrade (found) 60 0.01 0.00
index crx upgrade (positioned) 12,939 1.46 0.28
index fast full scans (full) 104 0.01 0.00
index fetch by key 18,115,455 2,048.78 389.58
index scans kdiixs1 527,663 59.68 11.35
leaf node 90-10 splits 353 0.04 0.01
leaf node splits 448 0.05 0.01
lob reads 84,582 9.57 1.82
lob writes 72,072 8.15 1.55
lob writes unaligned 72,072 8.15 1.55
logons cumulative 30,230 3.42 0.65
messages received 121,257 13.71 2.61
messages sent 121,257 13.71 2.61
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 45,604,116 5,157.64 980.73
opened cursors cumulative 647,826 73.27 13.93
parse count (failures) 115 0.01 0.00
parse count (hard) 7,097 0.80 0.15
parse count (total) 645,828 73.04 13.89
parse time cpu 11,990 1.36 0.26
parse time elapsed 14,915 1.69 0.32
physical read IO requests 29,852 3.38 0.64
physical read bytes 294,215,680 33,274.60 6,327.22
physical read total IO requests 178,861 20.23 3.85
physical read total bytes 2,757,059,584 311,812.26 59,291.60
physical read total multi block requests 3,132 0.35 0.07
physical reads 35,915 4.06 0.77
physical reads cache 295 0.03 0.01
physical reads cache prefetch 0 0.00 0.00
physical reads direct 35,620 4.03 0.77
physical reads direct (lob) 35,466 4.01 0.76
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 10,067 1.14 0.22
physical write bytes 136,650,752 15,454.65 2,938.73
physical write total IO requests 114,880 12.99 2.47
physical write total bytes 557,284,352 63,026.60 11,984.61
physical write total multi block requests 98,664 11.16 2.12
physical writes 16,681 1.89 0.36
physical writes direct 149 0.02 0.00
physical writes direct (lob) 15 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 16,532 1.87 0.36
physical writes non checkpoint 7,384 0.84 0.16
pinned buffers inspected 2 0.00 0.00
prefetch clients - default 0 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 0 0.00 0.00
process last non-idle time 8,842 1.00 0.19
queries parallelized 186 0.02 0.00
recovery blocks read 0 0.00 0.00
recursive calls 2,017,457 228.17 43.39
recursive cpu usage 24,795 2.80 0.53
redo blocks read for recovery 0 0.00 0.00
redo blocks written 198,187 22.41 4.26
redo buffer allocation retries 4 0.00 0.00
redo entries 222,651 25.18 4.79
redo log space requests 4 0.00 0.00
redo log space wait time 9 0.00 0.00
redo ordering marks 2,839 0.32 0.06
redo size 87,420,688 9,886.93 1,880.01
redo subscn max counts 2,647 0.30 0.06
redo synch time 5,116 0.58 0.11
redo synch writes 45,909 5.19 0.99
redo wastage 10,615,408 1,200.56 228.29
redo write broadcast ack time 1,448 0.16 0.03
redo write time 2,761 0.31 0.06
redo writer latching time 0 0.00 0.00
redo writes 49,152 5.56 1.06
rollback changes - undo records applied 70 0.01 0.00
rollbacks only - consistent read gets 107 0.01 0.00
root node splits 0 0.00 0.00
rows fetched via callback 7,573,436 856.52 162.87
session connect time 0 0.00 0.00
session cursor cache hits 384,022 43.43 8.26
session logical reads 77,762,188 8,794.59 1,672.31
shared hash latch upgrades - no wait 43,477 4.92 0.93
shared hash latch upgrades - wait 60 0.01 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 366,836 41.49 7.89
sorts (rows) 9,820,132 1,110.62 211.19
sql area evicted 4,816 0.54 0.10
sql area purged 115 0.01 0.00
summed dirty queue length 0 0.00 0.00
switch current to new buffer 188 0.02 0.00
table fetch by rowid 14,461,592 1,635.55 311.00
table fetch continued row 32,039 3.62 0.69
table scan blocks gotten 40,180,317 4,544.23 864.09
table scan rows gotten 6,040,806,951 683,190.77 129,909.83
table scans (long tables) 0 0.00 0.00
table scans (short tables) 659,814 74.62 14.19
total number of times SMON posted 1,806 0.20 0.04
transaction lock background get time 0 0.00 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 31 0.00 0.00
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
undo change vector size 18,723,692 2,117.57 402.66
user I/O wait time 1,465 0.17 0.03
user calls 1,795,412 203.05 38.61
user commits 45,337 5.13 0.97
user rollbacks 1,163 0.13 0.03
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 170,842 19.32 3.67
write clones created in background 0 0.00 0.00
write clones created in foreground 0 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max 1.3E+12 1.3E+12
session cursor cache count 240,337,894 240,559,541
session uga memory 8.6E+14 8.7E+14
opened cursors current 658 558
workarea memory allocated 265 265
logons current 1,206 1,145
session uga memory max 1.8E+13 1.8E+13
session pga memory 7.9E+11 7.9E+11

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 2 0.81

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)
USERS 28,415 3 0.00 1.21 2 0 0 0.00
WCITY2_DATA 1,141 0 0.72 1.00 5,307 1 30 2.33
UNDOTBS2 2 0 0.00 1.00 2,201 0 10 1.00
SYSAUX 41 0 4.63 1.00 998 0 0 0.00
WCITY2_INDEX 86 0 15.47 1.00 895 0 40 2.25
TS_APP_DATA 73 0 5.48 1.00 232 0 138 0.51
SYSTEM 5 0 2.00 1.00 293 0 22 4.09
WCITY 50 0 0.00 1.00 42 0 0 0.00
WCITY_GNMS 6 0 0.00 1.00 67 0 8 11.25
TBS_ITS 4 0 0.00 1.00 4 0 0 0.00
HQDB_DATA 2 0 0.00 1.00 2 0 0 0.00
INMS01 2 0 0.00 1.00 2 0 0 0.00
ISS 2 0 0.00 1.00 2 0 0 0.00
NETM_DATA 2 0 0.00 1.00 2 0 0 0.00
OMAE_DATA 2 0 0.00 1.00 2 0 0 0.00
OMP01 2 0 0.00 1.00 2 0 0 0.00
OMS01 2 0 0.00 1.00 2 0 0 0.00
REPORT_DATA 2 0 0.00 1.00 2 0 0 0.00
SSB_DATA_JWF 2 0 0.00 1.00 2 0 0 0.00
TS_APP_INDEX 2 0 0.00 1.00 2 0 0 0.00
UNDOTBS1 2 0 0.00 1.00 2 0 1 10.00
WCITY_BC 2 0 0.00 1.00 2 0 0 0.00
ZXDBM_DATA 2 0 0.00 1.00 2 0 0 0.00
ZXINJOS_DATA 2 0 0.00 1.00 2 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)
HQDB_DATA +DATA/acsdb/datafile/hqdb_data.296.762368267 2 0 0.00 1.00 2 0 0 0.00
INMS01 +DATA/acsdb/datafile/inms01.279.762122141 2 0 0.00 1.00 2 0 0 0.00
ISS +DATA/acsdb/datafile/iss01.bdf 2 0 0.00 1.00 2 0 0 0.00
NETM_DATA +DATA/acsdb/datafile/netm_data.295.762368247 2 0 0.00 1.00 2 0 0 0.00
OMAE_DATA +DATA/acsdb/datafile/omae_data.297.762368277 2 0 0.00 1.00 2 0 0 0.00
OMP01 +DATA/acsdb/datafile/omp01.280.762122149 2 0 0.00 1.00 2 0 0 0.00
OMS01 +DATA/acsdb/datafile/oms01.281.762122175 2 0 0.00 1.00 2 0 0 0.00
REPORT_DATA +DATA/acsdb/datafile/report_data.291.762359943 2 0 0.00 1.00 2 0 0 0.00
SSB_DATA_JWF +DATA/acsdb/datafile/ssb_data_jwf.292.762359949 2 0 0.00 1.00 2 0 0 0.00
SYSAUX +DATA/acsdb/datafile/sysaux.257.762113905 41 0 4.63 1.00 998 0 0 0.00
SYSTEM +DATA/acsdb/datafile/system.1634.787070407 2 0 0.00 1.00 60 0 0 0.00
SYSTEM +DATA/acsdb/datafile/system.256.762113905 3 0 3.33 1.00 233 0 22 4.09
TBS_ITS +DATA/acsdb/datafile/tbs_its.305.762449727 2 0 0.00 1.00 2 0 0 0.00
TBS_ITS +DATA/acsdb/datafile/tbs_its01.dbf 2 0 0.00 1.00 2 0 0 0.00
TS_APP_DATA +DATA/acsdb/datafile/ts_app_data01.dbf 73 0 5.48 1.00 232 0 138 0.51
TS_APP_INDEX +DATA/acsdb/datafile/ts_app_index01.dbf 2 0 0.00 1.00 2 0 0 0.00
UNDOTBS1 +DATA/acsdb/datafile/undotbs1.258.762113905 2 0 0.00 1.00 2 0 1 10.00
UNDOTBS2 +DATA/acsdb/datafile/undotbs2.269.762113985 2 0 0.00 1.00 2,201 0 10 1.00
USERS +DATA/acsdb/datafile/users.259.762113905 28,415 3 0.00 1.21 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.1031.787073439 4 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.1146.787070545 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.1297.787074783 4 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.2249.787070711 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.287.762346721 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.2995.787070437 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.3189.787070649 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.3202.787070683 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.3261.787070351 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.370.787070423 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.4594.787070635 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.4822.787075205 4 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.5264.787070521 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.5495.787070583 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.5810.787070597 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.6430.787070489 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity1.dbf 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity2.dbf 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity3.dbf 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity4.dbf 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity5.dbf 4 0 0.00 1.00 2 0 0 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data01.dbf 174 0 0.06 1.00 207 0 0 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data02.dbf 152 0 0.39 1.00 198 0 4 17.50
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data03.dbf 187 0 0.16 1.00 398 0 5 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data04.dbf 362 0 0.33 1.00 24 0 1 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data05.dbf 85 0 0.35 1.00 74 0 0 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data06.dbf 95 0 2.11 1.00 1,234 0 0 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data07.dbf 25 0 0.80 1.00 2,355 0 10 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data08.dbf 18 0 3.33 1.00 371 0 4 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data09.dbf 43 0 6.74 1.00 446 0 6 0.00
WCITY2_INDEX +DATA/acsdb/datafile/wcity2_index01.dbf 42 0 23.81 1.00 439 0 17 1.18
WCITY2_INDEX +DATA/acsdb/datafile/wcity2_index02.dbf 44 0 7.50 1.00 456 0 23 3.04
WCITY_BC +DATA/acsdb/datafile/wcity_bc01.dbf 2 0 0.00 1.00 2 0 0 0.00
WCITY_GNMS +DATA/acsdb/datafile/wcity_gnms01.dbf 2 0 0.00 1.00 58 0 8 11.25
WCITY_GNMS +DATA/acsdb/datafile/wcity_gnms02.dbf 4 0 0.00 1.00 9 0 0 0.00
ZXDBM_DATA +DATA/acsdb/datafile/zxdbm_data.290.762359941 2 0 0.00 1.00 2 0 0 0.00
ZXINJOS_DATA +DATA/acsdb/datafile/zxinjos_data.289.762359941 2 0 0.00 1.00 2 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 3,513,861 100 77,726,105 295 16,532 0 0 249


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 1 610 6349 29590 184320 29590  
E 0 1 818 10055 45958 184320 45958  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 2,928 0.10 350,811 41.41 1,223,599,611
D 5,856 0.20 701,622 1.52 44,789,582
D 8,784 0.30 1,052,433 1.19 35,259,648
D 11,712 0.40 1,403,244 1.12 33,111,152
D 14,640 0.50 1,754,055 1.07 31,531,023
D 17,568 0.60 2,104,866 1.05 30,952,244
D 20,496 0.70 2,455,677 1.04 30,791,945
D 23,424 0.80 2,806,488 1.03 30,522,686
D 26,352 0.90 3,157,299 1.02 30,148,504
D 29,280 1.00 3,508,110 1.00 29,564,100
D 29,328 1.00 3,513,861 1.00 29,547,463
D 32,208 1.10 3,858,921 0.97 28,625,673
D 35,136 1.20 4,209,732 0.96 28,380,587
D 38,064 1.30 4,560,543 0.95 28,138,056
D 40,992 1.40 4,911,354 0.95 28,039,315
D 43,920 1.50 5,262,165 0.94 27,773,352
D 46,848 1.60 5,612,976 0.93 27,461,094
D 49,776 1.70 5,963,787 0.92 27,144,027
D 52,704 1.80 6,314,598 0.84 24,699,352
D 55,632 1.90 6,665,409 0.82 24,237,185
D 58,560 2.00 7,016,220 0.81 23,885,104

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 15,055 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 8,044 6,602 961.54 0.00 0.00 0.00 0.00 823,700
E 8,044 6,628 928.74 0.00 0.00 0.00 0.00 823,700

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 157,384 157,384 0 0
64K 128K 530 530 0 0
128K 256K 312 312 0 0
256K 512K 166 166 0 0
512K 1024K 3,175 3,175 0 0
1M 2M 9,123 9,123 0 0
2M 4M 120 120 0 0
4M 8M 22 22 0 0
8M 16M 8 8 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
1,006 0.13 3,659,101.40 3,545.07 100.00 0
2,011 0.25 3,659,101.40 3,275.75 100.00 0
4,022 0.50 3,659,101.40 2,193.08 100.00 0
6,033 0.75 3,659,101.40 2,193.08 100.00 0
8,044 1.00 3,659,101.40 1,344.74 100.00 0
9,653 1.20 3,659,101.40 0.00 100.00 0
11,262 1.40 3,659,101.40 0.00 100.00 0
12,870 1.60 3,659,101.40 0.00 100.00 0
14,479 1.80 3,659,101.40 0.00 100.00 0
16,088 2.00 3,659,101.40 0.00 100.00 0
24,132 3.00 3,659,101.40 0.00 100.00 0
32,176 4.00 3,659,101.40 0.00 100.00 0
48,264 6.00 3,659,101.40 0.00 100.00 0
64,352 8.00 3,659,101.40 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits (K)
2,016 0.60 396 30,604 16,480,985 1.00 86,875 1.08 738,814
2,352 0.70 721 48,142 16,485,647 1.00 82,213 1.02 739,255
2,688 0.80 1,054 63,883 16,486,822 1.00 81,038 1.01 739,422
3,024 0.90 1,388 81,413 16,487,315 1.00 80,545 1.00 739,507
3,360 1.00 1,723 99,873 16,487,604 1.00 80,256 1.00 739,566
3,696 1.10 2,058 119,383 16,487,807 1.00 80,053 1.00 739,613
4,032 1.20 2,392 136,688 16,487,980 1.00 79,880 1.00 739,652
4,368 1.30 2,727 154,278 16,488,119 1.00 79,741 0.99 739,686
4,704 1.40 3,062 170,974 16,488,239 1.00 79,621 0.99 739,717
5,040 1.50 3,397 186,216 16,488,351 1.00 79,509 0.99 739,745
5,376 1.60 3,732 203,005 16,488,445 1.00 79,415 0.99 739,769
5,712 1.70 4,067 220,846 16,488,538 1.00 79,322 0.99 739,792
6,048 1.80 4,402 238,199 16,488,618 1.00 79,242 0.99 739,812
6,384 1.90 4,737 256,279 16,488,687 1.00 79,173 0.99 739,830
6,720 2.00 5,072 273,425 16,488,749 1.00 79,111 0.99 739,847

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
8,192 0.25 5,591,136 44,790,981
16,384 0.50 5,552,879 31,530,085
24,576 0.75 5,547,889 30,950,955
32,768 1.00 5,544,562 29,547,451
40,960 1.25 5,540,681 28,138,038
49,152 1.50 5,539,017 27,461,401
57,344 1.75 5,537,909 24,698,714
65,536 2.00 5,537,909 23,886,159

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 0.50 0 0 0 0
32 1.00 0 0 0 0
48 1.50 0 0 0 0
64 2.00 0 0 0 0
80 2.50 0 0 0 0
96 3.00 0 0 0 0
112 3.50 0 0 0 0
128 4.00 0 0 0 0
144 4.50 0 0 0 0
160 5.00 0 0 0 0
176 5.50 0 0 0 0
192 6.00 0 0 0 0
208 6.50 0 0 0 0
224 7.00 0 0 0 0
240 7.50 0 0 0 0
256 8.00 0 0 0 0
272 8.50 0 0 0 0
288 9.00 0 0 0 0
304 9.50 0 0 0 0
320 10.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 219 0 2
undo header 11 0 2
1st level bmb 12 0 0
2nd level bmb 4 0 0
segment header 3 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 72 42 30 51 5,447 106,797.06
TX-Transaction (index contention) 58 57 0 44 3 58.86
TX-Transaction 52,204 52,204 0 6 2 335.00
HW-Segment High Water Mark 5,851 5,851 0 3,057 2 0.57
PS-PX Process Reservation 1,320 1,320 0 449 1 2.25
TM-DML 54,536 54,536 0 444 0 0.97
FB-Format Block 158 158 0 75 0 0.80
CF-Controlfile Transaction 20,678 20,678 0 38 0 1.58
TD-KTF map table enqueue (KTF dump entries) 29 29 0 29 0 1.03
SQ-Sequence Cache 5,229 5,229 0 5 0 6.00
TA-Instance Undo 58 58 0 58 0 0.34
JQ-Job Queue 283 283 0 13 0 0.00
JS-Job Scheduler (job run lock - synchronize) 5 5 0 5 0 0.00
TX-Transaction (allocate ITL entry) 5 5 0 5 0 0.00
DR-Distributed Recovery 4 4 0 4 0 0.00
PI-Remote PX Process Spawn Status 2 2 0 2 0 0.00
PW-Buffer Cache PreWarm (flush prewarm buffers) 2 0 2 2 0 0.00
TT-Tablespace 478 478 0 2 0 0.00
TX-Transaction (row lock contention) 2 2 0 2 0 0.00
AF-Advisor Framework (task serialization) 14 14 0 1 0 0.00
WL-Being Written Redo Log 2 2 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
5 2.69 49,410 1,849 4 75/75 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
14-3ÔÂ 17:19 88 1,934 108 2 75 0/0 0/0/0/0/0/0
14-3ÔÂ 17:09 270 6,232 0 3 75 0/0 0/0/0/0/0/0
14-3ÔÂ 16:59 89 1,699 694 3 75 0/0 0/0/0/0/0/0
14-3ÔÂ 16:49 124 1,702 405 3 75 0/0 0/0/0/0/0/0
14-3ÔÂ 16:39 155 2,451 1,058 3 75 0/0 0/0/0/0/0/0
14-3ÔÂ 16:29 231 3,885 774 4 75 0/0 0/0/0/0/0/0
14-3ÔÂ 16:19 310 6,460 642 3 75 0/0 0/0/0/0/0/0
14-3ÔÂ 16:09 238 3,685 774 3 75 0/0 0/0/0/0/0/0
14-3ÔÂ 15:59 381 8,654 1,849 3 75 0/0 0/0/0/0/0/0
14-3ÔÂ 15:49 105 1,896 1,246 2 75 0/0 0/0/0/0/0/0
14-3ÔÂ 15:39 128 2,428 644 3 75 0/0 0/0/0/0/0/0
14-3ÔÂ 15:29 150 2,598 990 3 75 0/0 0/0/0/0/0/0
14-3ÔÂ 15:19 142 2,373 389 4 75 0/0 0/0/0/0/0/0
14-3ÔÂ 15:09 275 3,413 265 4 75 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 154 0.00   0 0  
ASM db client latch 6,167 0.00   0 0  
ASM map headers 311 0.00   0 0  
ASM map load waiting list 93 0.00   0 0  
ASM map operation freelist 4,382 0.00   0 0  
ASM map operation hash table 862,172 0.00 0.00 0 0  
ASM network background latch 3,907 0.00   0 0  
AWR Alerted Metric Element list 145,023 0.00   0 0  
Consistent RBA 49,151 0.00   0 0  
FAL request queue 180 0.00   0 0  
FAL subheap alocation 180 0.00   0 0  
FIB s.o chain latch 40 0.00   0 0  
FOB s.o list latch 30,914 0.02 0.00 0 0  
JS broadcast add buf latch 2,023 0.00   0 0  
JS broadcast drop buf latch 2,023 0.00   0 0  
JS broadcast load blnc latch 1,765 0.00   0 0  
JS mem alloc latch 14 0.00   0 0  
JS queue access latch 14 0.00   0 0  
JS queue state obj latch 63,842 0.00   0 0  
KCL gc element parent latch 124,678 0.02 0.12 0 769 0.00
KFK SGA context latch 5,987 0.00   0 0  
KFMD SGA 3,318 0.00   0 0  
KJC message pool free list 75,002 0.06 0.00 0 3,330 0.06
KJCT flow control latch 265,814 0.05 0.03 0 0  
KMG MMAN ready and startup request latch 2,946 0.00   0 0  
KTF sga latch 9,274 0.00   0 2,644 0.00
KWQMN job cache list latch 2,179 0.18 0.50 0 0  
KWQP Prop Status 4 0.00   0 0  
MQL Tracking Latch 0     0 176 0.00
Memory Management Latch 0     0 2,946 0.00
OS process 90,465 0.00   0 0  
OS process allocation 63,188 0.09 0.04 1 0  
OS process: request allocation 59,459 0.15 0.12 4 0  
PL/SQL warning settings 31,474 0.00   0 0  
SGA IO buffer pool latch 233 0.00   0 233 0.00
SQL memory manager latch 2 0.00   0 2,943 0.00
SQL memory manager workarea list latch 280,291 0.00 0.00 0 0  
Shared B-Tree 318 0.00   0 0  
active checkpoint queue latch 22,750 0.00 0.00 0 0  
active service list 169,792 0.65 0.11 0 9,581 0.01
alert log latch 4 0.00   0 0  
archive control 323 0.00   0 0  
archive process latch 3,307 0.00   0 0  
begin backup scn array 16 0.00   0 0  
business card 372 0.00   0 0  
cache buffer handles 3,840 0.03 0.00 0 0  
cache buffers chains 127,631,643 0.15 0.02 34 72,594 0.01
cache buffers lru chain 95,637 0.00   0 107,954 0.00
channel handle pool latch 59,506 0.01 0.00 0 0  
channel operations parent latch 791,955 0.02 0.03 0 0  
checkpoint queue latch 1,096,202 0.00 0.00 0 21,256 0.00
client/application info 156,892 0.00   0 0  
commit callback allocation 254 0.00   0 0  
compile environment latch 30,234 0.00   0 0  
dml lock allocation 109,456 0.02 0.00 0 0  
dummy allocation 60,529 0.08 0.18 2 0  
enqueue hash chains 657,049 0.02 0.01 0 5,980 0.00
enqueues 704,876 0.01 0.04 0 0  
error message lists 900 0.00   0 0  
event group latch 29,696 0.00   0 0  
file cache latch 2,724 0.00   0 0  
gcs opaque info freelist 19,454 0.00   0 0  
gcs partitioned table hash 145,272 0.00   0 1,710 0.00
gcs remastering latch 1,461 0.00   0 0  
gcs resource freelist 3,772 0.00   0 2,046 0.00
gcs resource hash 110,249 0.07 0.00 0 14 0.00
gcs resource scan list 28 0.00   0 0  
gcs shadows freelist 2,765 0.00   0 3,947 0.00
ges caches resource lists 71,516 0.00 0.00 0 105,186 0.00
ges deadlock list 308 0.00   0 1 0.00
ges domain table 205,824 0.00   0 0  
ges enqueue table freelist 371,657 0.00 0.50 0 0  
ges group table 294,553 0.00 0.00 0 0  
ges process hash list 123,665 0.00   0 0  
ges process parent latch 718,310 0.00   0 1 0.00
ges process table freelist 59,459 0.04 0.00 0 0  
ges resource hash list 541,943 0.11 0.04 0 9,525 0.41
ges resource scan list 2,970 0.00   0 0  
ges resource table freelist 7,516 0.00   0 0  
ges timeout list 4,046 0.00   0 5,140 0.00
global KZLD latch for mem in SGA 29,212 0.00   0 0  
global tx hash mapping 366 0.00   0 0  
hash table column usage latch 647 0.00   0 457,120 0.00
hash table modification latch 188 0.00   0 0  
internal temp table object number allocation latc 20 0.00   0 0  
interrupt manipulation 1,864 0.00   0 0  
job workq parent latch 0     0 576 0.00
job_queue_processes parameter latch 426 0.00   0 0  
kks stats 34,425 0.00   0 0  
kmcptab latch 1 0.00   0 0  
kmcpvec latch 0     0 1 0.00
kokc descriptor allocation latch 9,360 0.00   0 0  
ksuosstats global area 594 0.00   0 0  
ksv instance 2 0.00   0 0  
ktm global data 1,814 0.00   0 0  
kwqbsn:qsga 316 0.00   0 0  
lgwr LWN SCN 49,311 0.00 0.00 0 0  
library cache 2,412,429 0.15 0.01 5 16,264 0.02
library cache load lock 568 0.00   0 0  
library cache lock 3,449,003 0.49 0.01 41 0  
library cache lock allocation 85,298 0.01 0.00 0 0  
library cache pin 664,338 0.02 0.00 0 0  
library cache pin allocation 872 0.00   0 0  
list of block allocation 5,566 0.00   0 0  
loader state object freelist 14,838 0.00   0 0  
logminer context allocation 2 0.00   0 0  
message pool operations parent latch 2,914 0.00   0 0  
messages 691,717 0.03 0.01 0 0  
mostly latch-free SCN 49,677 0.16 0.00 0 0  
msg queue 57 0.00   0 57 0.00
multiblock read objects 4,280 0.00   0 0  
name-service memory objects 33,364 0.00   0 0  
name-service namespace bucket 90,974 0.00   0 0  
name-service pending queue 19,560 0.00   0 0  
name-service request 20 0.00   0 0  
name-service request queue 111,263 0.00   0 0  
ncodef allocation latch 380 0.00   0 0  
object queue header heap 66,084 0.00   0 600 0.00
object queue header operation 250,387 0.00 0.25 0 0  
object stats modification 2 0.00   0 0  
parallel query alloc buffer 5,254 0.00   0 0  
parallel query stats 803 0.00   0 0  
parallel txn reco latch 39,102 0.00   0 0  
parameter list 263,648 0.04 0.00 0 0  
parameter table management 60,652 0.00   0 0  
post/wait queue 116,252 0.06 0.00 0 47,064 0.00
process allocation 132,182 1.03 2.43 36 29,621 0.25
process group creation 59,458 0.04 0.00 0 0  
process queue 2,154 0.00   0 0  
process queue reference 42,981 0.01 0.00 0 4,381 0.02
qmn task queue latch 2,533 20.69 0.01 0 0  
query server freelists 1,768 0.00   0 0  
query server process 2 0.00   0 4 0.00
queued dump request 44,171 0.00   0 0  
redo allocation 147,978 0.04 0.00 0 222,614 0.08
redo copy 0     0 222,697 0.09
redo writing 176,506 0.00 0.00 0 0  
resmgr group change latch 30,872 0.00   0 0  
resmgr:active threads 60,439 0.00   0 0  
resmgr:actses change group 30,033 0.00   0 0  
resmgr:free threads list 60,437 0.35 0.05 6 0  
resmgr:resource group CPU method 30,085 0.01 0.00 0 0  
resmgr:schema config 2 0.00   0 0  
row cache objects 4,365,350 0.08 0.01 0 500 0.00
rules engine aggregate statistics 5 0.00   0 0  
rules engine rule set statistics 210 0.00   0 0  
segmented array pool 36 0.00   0 0  
sequence cache 493,801 0.09 0.00 0 0  
session allocation 991,863 1.00 0.07 13 0  
session idle bit 4,025,806 0.00 0.03 0 0  
session state list latch 60,501 0.03 0.00 0 0  
session switching 149,190 0.06 0.05 0 0  
session timer 7,985 0.00   0 0  
shared pool 1,191,039 0.41 0.02 3 0  
shared pool simulator 43,596 0.00   0 0  
simulator hash latch 4,383,584 0.00 0.00 0 0  
simulator lru latch 0     0 4,382,972 0.13
slave class 242 0.00   0 0  
slave class create 1,717 0.12 1.00 0 0  
sort extent pool 2,284 0.00   0 0  
state object free list 4 0.00   0 0  
statistics aggregation 1,344 0.00   0 0  
temp lob duration state obj allocation 2 0.00   0 0  
threshold alerts latch 1,622 0.00   0 0  
transaction allocation 1,327,656 0.00   0 0  
transaction branch allocation 8,240 0.00   0 0  
undo global data 247,474 0.00 0.00 0 0  
user lock 117,694 1.90 0.01 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 127,631,643 194,716 3,217 191,664 0 0 0
library cache lock 3,449,003 16,845 154 16,721 0 0 0
session allocation 991,863 9,886 714 9,217 0 0 0
shared pool 1,191,039 4,931 83 4,862 0 0 0
library cache 2,412,429 3,591 44 3,553 0 0 0
row cache objects 4,365,350 3,456 20 3,440 0 0 0
user lock 117,694 2,236 20 2,218 0 0 0
process allocation 132,182 1,368 3,320 143 0 0 0
active service list 169,792 1,112 118 999 0 0 0
ges resource hash list 541,943 622 27 595 0 0 0
qmn task queue latch 2,533 524 3 521 0 0 0
sequence cache 493,801 445 2 443 0 0 0
resmgr:free threads list 60,437 212 10 203 0 0 0
messages 691,717 186 1 185 0 0 0
enqueue hash chains 657,049 162 1 161 0 0 0
channel operations parent latch 791,955 154 4 151 0 0 0
KJCT flow control latch 265,814 120 3 117 0 0 0
session switching 149,190 92 5 88 0 0 0
OS process: request allocation 59,459 91 11 84 0 0 0
enqueues 704,876 68 3 66 0 0 0
session idle bit 4,025,806 58 2 56 0 0 0
OS process allocation 63,188 55 2 53 0 0 0
dummy allocation 60,529 50 9 43 0 0 0
KCL gc element parent latch 124,678 25 3 22 0 0 0
KWQMN job cache list latch 2,179 4 2 2 0 0 0
object queue header operation 250,387 4 1 3 0 0 0
ges enqueue table freelist 371,657 2 1 1 0 0 0
slave class create 1,717 2 2 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KCL gc element parent latch kclchkping 0 2 0
KCL gc element parent latch kclnfndnewm 0 1 1
KCL gc element parent latch kclpto_1 0 1 0
KJCT flow control latch kjcts_sqenq: queue a message 0 3 2
KWQMN job cache list latch kwqmnprsc: loop 0 2 0
OS process allocation kso_new_process:2 0 2 2
OS process: request allocation kso_new_process 0 9 6
OS process: request allocation ksoreqholder_delete 0 2 5
active service list kswslogon: session logout 0 609 608
active service list kswslogon: session login 0 30 13
active service list kswsgsnp: get service name ptr 0 3 21
cache buffers chains kcbgtcr: kslbegin excl 0 9,398 4,384
cache buffers chains kcbrls: kslbegin 0 923 6,027
cache buffers chains kcbgtcr: fast path 0 107 14
cache buffers chains kcbget: pin buffer 0 12 6
cache buffers chains kcbgcur: kslbegin 0 10 4
cache buffers chains kclbla 0 3 0
cache buffers chains kcbchg: kslbegin: call CR func 0 2 7
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1 6
cache buffers chains kcbzwb 0 1 0
cache buffers chains kclebs_1 0 1 0
cache buffers chains kclpto 0 1 0
channel operations parent latch ksrchdelete() 0 10 10
cost function kzulrl 0 14 15
cost function kzulgt: find user res 0 6 5
dummy allocation ktcscnfy 0 5 5
dummy allocation ktcdod 0 4 4
enqueue hash chains ksqcmi: if lk mode not requested 0 1 0
enqueues ksqies 0 2 2
enqueues ksqgel: create enqueue 0 1 0
event range base latch No latch 0 29 22
ges enqueue table freelist kjlalc: lock allocation 0 1 0
ges resource hash list kjakcai: search for resp by resname 0 17 2
ges resource hash list kjrmas1: lookup master node 0 7 0
ges resource hash list kjlrlr: remove lock from resource queue 0 2 20
ges resource hash list kjcvscn: remove from scan queue 0 1 0
library cache kglLockCursor 0 11 3
library cache kglhdgn: child: 0 11 19
library cache kgldte: child 0 0 10 12
library cache kglobpn: child: 0 6 10
library cache kglpndl: child: before processing 0 3 0
library cache kgldti: 2child 0 1 0
library cache kglpndl: child: after processing 0 1 0
library cache lock kgllkdl: child: cleanup 0 111 103
library cache lock kgllkal: child: multiinstance 0 17 32
messages ksarcv 0 1 0
object queue header operation kcbo_switch_mq_bg 0 1 0
object queue header operation kcbw_link_q 0 1 0
process allocation ksuapc 0 2,097 1,759
process allocation ksucrp 0 954 0
process allocation ksudlp 0 220 646
process allocation ksufap: active procs 0 49 915
resmgr:free threads list kgskthrcreate 0 5 5
resmgr:free threads list kgskthrsod 0 5 5
row cache objects kqrpre: find obj 0 9 20
row cache objects kqreqd: reget 0 6 0
row cache objects kqrso 0 5 0
sequence cache kdnnxt: cached seq 0 2 0
session allocation ksuxds: KSUSFCLC not set 0 521 228
session allocation ksudlp 0 77 215
session allocation ksucri 0 55 167
session allocation ksuxds: not user session 0 36 86
session allocation ksucrp 0 15 18
session allocation ksufap: active sessions 0 10 0
session idle bit ksupuc: clear busy 0 2 2
session idle bit ksupuc: set busy 0 1 1
session switching kskexeall 0 5 5
shared pool kghalo 0 47 32
shared pool kghfre 0 27 43
shared pool kghupr1 0 6 7
shared pool kghalp 0 2 1
shared pool kghfrunp: alloc: cursor dur 0 1 0
shared pool kghfrunp: clatch: nowait 0 1 0
slave class create ksvcreate 0 2 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
WCITY2 WCITY2_DATA TB_ARTICLE_CONTENT_RELATION   TABLE 13,508,032 17.37
WCITY2 WCITY2_INDEX PK_TB_ARTICLE_DESC   INDEX 13,283,664 17.08
WCITY2 WCITY2_DATA TB_ARTICLE_DESC   TABLE 10,438,832 13.42
WCITY2 WCITY2_DATA TB_EILLEGAL_REASON_INFO   TABLE 5,854,784 7.53
WCITY2 WCITY2_DATA TB_ARTICLE   TABLE 5,526,848 7.11

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
WCITYAPP TS_APP_DATA PK_TB_MAP_SERVICE_RECORD   INDEX 71 0.20
WCITY2 WCITY2_INDEX ACCOUNT_INTERFACE_LOG_ID   INDEX 64 0.18
WCITY2 WCITY2_DATA TB_API_REQUEST_LOG   TABLE 54 0.15
WCITY2 WCITY2_DATA TB_ARTICLE_CONTENT   TABLE 33 0.09
WCITY2 WCITY2_DATA TB_USER_PHONE_INFO   TABLE 13 0.04

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
WCITYAPP TS_APP_DATA PK_TB_MAP_SERVICE_RECORD   INDEX 20 37.74
WCITY2 WCITY2_INDEX ACCOUNT_INTERFACE_LOG_ID   INDEX 9 16.98
WCITY2 WCITY2_INDEX IDX_TB_AUTH_LOG_3   INDEX 8 15.09
WCITY2 WCITY2_INDEX IDX_TB_ACCOUNT_INTERFACE_LOG_2   INDEX 6 11.32
WCITY2 WCITY2_INDEX PK_TB_AUTH_LOG2   INDEX 4 7.55

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
WCITY2 WCITY2_INDEX IDX_TB_ACCOUNT_INTERFACE_LOG_2   INDEX 2 40.00
WCITY2 WCITY2_INDEX PK_TB_AUTH_LOG2   INDEX 2 40.00
WCITY2 WCITY2_INDEX ACCOUNT_INTERFACE_LOG_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
WCITYAPP TS_APP_DATA PK_TB_MAP_SERVICE_RECORD   INDEX 121 76.58
WCITYAPP TS_APP_DATA TB_MAP_SERVICE_RECORD   TABLE 14 8.86
WCITY2 WCITY2_INDEX PK_TB_AUTH_LOG2   INDEX 5 3.16
SYS SYSTEM SEQ$   TABLE 4 2.53
WCITY2 WCITY2_INDEX ACCOUNT_INTERFACE_LOG_ID   INDEX 3 1.90

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
WCITY2 WCITY2_INDEX IDX_TB_AUTH_LOG_3   INDEX 9 14.29
WCITY2 WCITY2_INDEX PK_TB_AUTH_LOG2   INDEX 7 11.11
WCITY2 WCITY2_INDEX IDX_TB_ACCOUNT_INTERFACE_LOG_2   INDEX 6 9.52
WCITY2 WCITY2_DATA TB_ACCESS_TOKEN   TABLE 5 7.94
WCITY2 WCITY2_DATA TB_ARTICLE   TABLE 5 7.94

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
WCITY2 WCITY2_DATA TB_ARTICLE   TABLE 1,914 38.14
SYS SYSTEM SEQ$   TABLE 560 11.16
SYS SYSTEM JOB$   TABLE 522 10.40
WCITY2 WCITY2_INDEX INDEX_TB_P_U_MOBILE   INDEX 347 6.91
WCITY2 WCITY2_DATA TB_PORTAL_USER   TABLE 162 3.23

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
WCITY2 WCITY2_DATA TB_ACCOUNT_INTERFACE_LOG   TABLE 988 13.52
WCITY2 WCITY2_INDEX PK_TB_AUTH_LOG2   INDEX 774 10.60
WCITY2 WCITY2_INDEX IDX_TB_AUTH_LOG_3   INDEX 760 10.40
WCITY2 WCITY2_INDEX IDX_TB_ACCOUNT_INTERFACE_LOG_2   INDEX 745 10.20
WCITY2 WCITY2_INDEX ACCOUNT_INTERFACE_LOG_ID   INDEX 711 9.73

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 159 0.63 0   1 1
dc_database_links 59,314 0.00 0   0 2
dc_global_oids 7,364 0.03 0   0 85
dc_histogram_data 189,705 0.21 0   0 2,332
dc_histogram_defs 81,946 0.72 0   0 2,829
dc_object_grants 52 3.85 0   0 17
dc_object_ids 207,558 0.02 0   0 1,237
dc_objects 53,975 0.27 0   2 750
dc_profiles 29,499 0.00 0   0 1
dc_rollback_segments 59,077 0.00 0   0 688
dc_segments 70,999 0.04 0   15 2,818
dc_sequences 5,224 14.53 0   5,224 15
dc_tablespace_quotas 6 83.33 0   6 2
dc_tablespaces 123,153 0.00 0   0 25
dc_usernames 119,068 0.00 0   0 46
dc_users 706,638 0.00 0   0 72
outstanding_alerts 733 94.82 0   5 5

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 3 1 0
dc_global_oids 2 0 7
dc_histogram_defs 594 0 4
dc_object_ids 37 0 205
dc_objects 149 3 1
dc_segments 76 5 206
dc_sequences 10,427 762 0
dc_tablespace_quotas 12 3 1
dc_usernames 1 0 2
dc_users 1 0 1
outstanding_alerts 1,450 690 0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 2,068 0.19 4,790 0.13 2 0
CLUSTER 32 0.00 59 0.00 0 0
INDEX 42 9.52 135 5.19 3 0
SQL AREA 266,819 4.60 926,300 2.18 887 1
TABLE/PROCEDURE 7,679 1.30 287,350 0.09 77 0
TRIGGER 257 0.00 582 0.00 0 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
CLUSTER 59 0 0 0 0
INDEX 135 4 0 4 0
TABLE/PROCEDURE 31,475 97 17 95 0

Back to Library Cache Statistics
Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 880.51   0.73 1.40 21 21 1,211 1,211
  Freeable 76.69 0.00 1.42 2.80 21   54 54
  SQL 2.89 1.74 0.00 0.01 0 5 1,172 566
  PL/SQL 2.54 0.38 0.00 0.00 0 0 1,209 1,207
E Other 848.23   0.74 1.43 21 21 1,148 1,148
  Freeable 76.38 0.00 1.34 2.75 21   57 57
  SQL 2.62 1.55 0.00 0.01 0 6 1,119 467
  PL/SQL 2.55 0.47 0.00 0.00 0 0 1,146 1,146

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 30,752,636,928  
Fixed Size 2,159,376  
Redo Buffers 14,614,528  
Variable Size 3,590,327,536  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 32.00 32.00 0.00
large ASM map operations hashta 0.38 0.38 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.60 14.60 0.00
shared ASH buffers 50.00 50.00 0.00
shared CCursor 142.06 148.38 4.45
shared PCursor 116.58 121.68 4.37
shared db_block_hash_buckets 180.00 180.00 0.00
shared free memory 580.97 497.60 -14.35
shared gcs resources 690.04 690.04 0.00
shared gcs shadows 370.55 370.55 0.00
shared kglsim object batch 50.77 50.77 0.00
shared library cache 92.20 94.75 2.77
shared sql area 703.28 773.10 9.93
streams free memory 32.00 32.00 0.00
  buffer_cache 29,328.00 29,328.00 0.00
  fixed_sga 2.06 2.06 0.00
  log_buffer 13.94 13.94 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Slaves 1,857,716 53,213 0
QMON Coordinator 108,984 0 0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R 5 0 0 0 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 1,503,369 3,979,876 4005095 4005095
ges_procs 1,148 1,657 2001 2001
processes 1,149 1,659 2000 2000
sessions 1,163 1,989 2205 2205


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /oracle/app/oracle/admin/acsdb/adump   
background_dump_dest /oracle/app/oracle/admin/acsdb/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.5.0   
control_files +DATA/acsdb/controlfile/current.261.762113963, +DATA/acsdb/controlfile/current.260.762113963   
core_dump_dest /oracle/app/oracle/admin/acsdb/cdump   
db_block_size 8192   
db_create_file_dest +DATA   
db_domain      
db_file_multiblock_read_count 16   
db_name acsdb   
db_recovery_file_dest +DATA   
db_recovery_file_dest_size 209715200000   
dispatchers (PROTOCOL=TCP) (SERVICE=acsdbXDB)   
instance_number 2   
job_queue_processes 10   
local_listener (ADDRESS = (PROTOCOL = TCP)(HOST = 10.46.51.198)(PORT = 1521))   
log_archive_dest_1 LOCATION=+DATA/   
log_archive_format %t_%s_%r.dbf   
open_cursors 300   
pga_aggregate_target 8434745344   
processes 2000   
remote_listener LISTENERS_ACSDB   
remote_login_passwordfile EXCLUSIVE   
service_names acsdb   
sessions 2205   
sga_max_size 34359738368   
sga_target 34359738368   
spfile +DATA/acsdb/spfileacsdb.ora   
statistics_level TYPICAL   
thread 2   
undo_management AUTO   
undo_retention 4500   
undo_tablespace UNDOTBS2   
user_dump_dest /oracle/app/oracle/admin/acsdb/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 20,599 2.33 0.44
acks for commit broadcast(logical) 20,726 2.34 0.45
broadcast msgs on commit(actual) 49,129 5.56 1.06
broadcast msgs on commit(logical) 49,152 5.56 1.06
broadcast msgs on commit(wasted) 649 0.07 0.01
broadcast on commit wait time(ms) 12,000 1.36 0.26
broadcast on commit waits 47,820 5.41 1.03
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 4,329 0.49 0.09
gcs ast xid 8 0.00 0.00
gcs blocked converts 9,567 1.08 0.21
gcs blocked cr converts 6,363 0.72 0.14
gcs compatible basts 2 0.00 0.00
gcs compatible cr basts (global) 846 0.10 0.02
gcs compatible cr basts (local) 436 0.05 0.01
gcs cr basts to PIs 0 0.00 0.00
gcs cr serve without current lock 0 0.00 0.00
gcs dbwr flush pi msgs 1,176 0.13 0.03
gcs dbwr write request msgs 881 0.10 0.02
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 98 0.01 0.00
gcs immediate (null) converts 3,259 0.37 0.07
gcs immediate cr (compatible) converts 2 0.00 0.00
gcs immediate cr (null) converts 55 0.01 0.00
gcs indirect ast 3,927 0.44 0.08
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 313 0.04 0.01
gcs msgs process time(ms) 10,428 1.18 0.22
gcs msgs received 110,777 12.53 2.38
gcs out-of-order msgs 8 0.00 0.00
gcs pings refused 13 0.00 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 9 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 4 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 0 0.00 0.00
gcs side channel msgs actual 8,250 0.93 0.18
gcs side channel msgs logical 13,383 1.51 0.29
gcs stale cr 4,088 0.46 0.09
gcs undo cr 0 0.00 0.00
gcs write notification msgs 104 0.01 0.00
gcs writes refused 10 0.00 0.00
ges msgs process time(ms) 617 0.07 0.01
ges msgs received 27,539 3.11 0.59
global posts dropped 0 0.00 0.00
global posts queue time 2,933 0.33 0.06
global posts queued 126 0.01 0.00
global posts requested 127 0.01 0.00
global posts sent 126 0.01 0.00
implicit batch messages received 1,503 0.17 0.03
implicit batch messages sent 5,010 0.57 0.11
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 68,026 7.69 1.46
messages queue sent actual 95,194 10.77 2.05
messages queue sent logical 100,724 11.39 2.17
messages received actual 132,768 15.02 2.86
messages received logical 138,316 15.64 2.97
messages sent directly 18,484 2.09 0.40
messages sent indirectly 26,309 2.98 0.57
messages sent not implicit batched 90,184 10.20 1.94
messages sent pbatched 36,659 4.15 0.79
msgs causing lmd to send msgs 6,270 0.71 0.13
msgs causing lms(s) to send msgs 5,847 0.66 0.13
msgs received queue time (ms) 4,847 0.55 0.10
msgs received queued 138,316 15.64 2.97
msgs sent queue time (ms) 10,290 1.16 0.22
msgs sent queue time on ksxp (ms) 29,124 3.29 0.63
msgs sent queued 100,683 11.39 2.17
msgs sent queued on ksxp 134,052 15.16 2.88
number of ges deadlock detected 0 0.00 0.00
process batch messages received 65,807 7.44 1.42
process batch messages sent 32,953 3.73 0.71


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 6,475
CURRENT Block Requests 550
Data Block Requests 6,475
Undo Block Requests 0
TX Block Requests 341
Current Results 7,006
Private results 0
Zero Results 19
Disk Read Results 0
Fail Results 0
Fairness Down Converts 1,419
Fairness Clears 0
Free GC Elements 0
Flushes 267
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 0
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 12,923 99.72 0.01 0.27 0.00 0.00
Flushes 132 81.82 15.15 2.27 0.76 0.00
Writes 1,617 69.39 27.52 0.12 1.05 1.92


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 4,503 93.67 6.33 0.00 7,130 98.19 1.81 0.00
1 undo header 320 97.81 2.19 0.00 23 100.00 0.00 0.00
1 Others 194 95.88 4.12 0.00 137 96.35 3.65 0.00
1 undo block 1 100.00 0.00 0.00 0      


Back to Top

End of Report