WORKLOAD REPOSITORY report for

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

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:55425-2ÔÂ -13 10:43:491265 .5
End Snap:55925-2ÔÂ -13 17:03:271210 .5
Elapsed:  379.64 (mins)  
DB Time:  7,821.99 (mins)  

Report Summary

Cache Sizes

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

Load Profile

Per SecondPer Transaction
Redo size: 8,131.10 2,276.59
Logical reads: 8,746.03 2,448.76
Block changes: 25.53 7.15
Physical reads: 7.91 2.21
Physical writes: 3.09 0.87
User calls: 209.57 58.68
Parses: 96.27 26.95
Hard parses: 0.58 0.16
Sorts: 54.43 15.24
Logons: 9.16 2.57
Executes: 89.67 25.11
Transactions: 3.57 

% Blocks changed per Read: 0.29Recursive Call %: 66.81
Rollback per transaction %: 22.24Rows per Sort: 25.75

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 99.99
Buffer Hit %: 99.99In-memory Sort %: 100.00
Library Hit %: 99.24Soft Parse %: 99.39
Execute to Parse %: -7.35Latch Hit %: 99.80
Parse CPU to Parse Elapsd %: 71.34% Non-Parse CPU: 97.65

Shared Pool Statistics

BeginEnd
Memory Usage %: 78.64 81.16
% SQL with executions>1: 75.35 99.21
% Memory for SQL w/exec>1: 75.32 98.89

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
enq: TM - contention 928,840 453,797 489 96.7Application
CPU time  17,115  3.6 
enq: WF - contention 14,830 7,178 484 1.5Other
reliable message 4,160 2,627 632 .6Other
enq: US - contention 55,485 2,576 46 .5Other

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 2.26 0.63
Global Cache blocks served: 3.73 1.05
GCS/GES messages received: 28.96 8.11
GCS/GES messages sent: 26.91 7.53
DBWR Fusion writes: 0.09 0.03
Estd Interconnect traffic (KB) 58.83 

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

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

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 330.9
Avg global cache cr block receive time (ms): 0.7
Avg global cache current block receive time (ms): 0.8
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 1.8
Avg global cache cr block flush time (ms): 7.9
Avg global cache current block pin time (ms): 0.3
Avg global cache current block send time (ms): 0.1
Global cache log flushes for current blocks served %: 0.9
Avg global cache current block flush time (ms): 11.3

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.2
Avg message sent queue time on ksxp (ms): 0.3
Avg message received queue time (ms): 0.2
Avg GCS message process time (ms): 0.1
Avg GES message process time (ms): 0.0
% of direct sent messages: 25.04
% of indirect sent messages: 47.33
% of flow controlled messages: 27.63


Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 462,187.89 98.48
DB CPU 17,114.65 3.65
connection management call elapsed time 1,564.40 0.33
parse time elapsed 564.19 0.12
hard parse elapsed time 53.21 0.01
sequence load elapsed time 50.97 0.01
failed parse elapsed time 13.00 0.00
PL/SQL execution elapsed time 4.01 0.00
hard parse (sharing criteria) elapsed time 0.45 0.00
PL/SQL compilation elapsed time 0.35 0.00
hard parse (bind mismatch) elapsed time 0.06 0.00
repeated bind elapsed time 0.02 0.00
DB time 469,319.24  
background elapsed time 10,727.83  
background cpu time 462.79  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%Total Call Time
Application 1,029,111 90 454,113 441 96.76
CPU time     17,115   3.65
Other 1,684,791 27 13,046 8 2.78
Concurrency 128,010 0 1,497 12 0.32
System I/O 394,177   148 0 0.03
Cluster 71,078 0 144 2 0.03
Commit 66,024 0 106 2 0.02
User I/O 93,246   60 1 0.01
Network 4,358,764   18 0 0.00
Configuration 388 1 17 45 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
enq: TM - contention 928,840 100 453,797 489 11.42
enq: WF - contention 14,830 98 7,178 484 0.18
reliable message 4,160 64 2,627 632 0.05
enq: US - contention 55,485 0 2,576 46 0.68
row cache lock 89,962   466 5 1.11
latch free 29,090 0 418 14 0.36
latch: row cache objects 25,937   319 12 0.32
SQL*Net break/reset to client 100,256   316 3 1.23
latch: shared pool 980   223 228 0.01
latch: cache buffers chains 7,593   162 21 0.09
latch: ges resource hash list 2,268   150 66 0.03
latch: library cache 664   132 198 0.01
latch: library cache lock 547   112 206 0.01
log file sync 66,024 0 106 2 0.81
control file sequential read 312,478   97 0 3.84
gc buffer busy 1,495 3 80 54 0.02
os thread startup 671 1 52 77 0.01
log file parallel write 72,324   36 0 0.89
latch: session allocation 2,625   32 12 0.03
buffer busy waits 858   27 32 0.01
db file scattered read 6,287   22 4 0.08
gc current block 2-way 29,262   22 1 0.36
direct path read 66,459   21 0 0.82
gc current block busy 667 0 19 29 0.01
DFS lock handle 35,831 0 18 0 0.44
db file sequential read 19,862   16 1 0.24
enq: SQ - contention 248   15 62 0.00
control file parallel write 8,875   11 1 0.11
SQL*Net more data to client 281,543   9 0 3.46
gc cr block 2-way 15,805   9 1 0.19
gcs log flush sync 1,809 13 8 5 0.02
gc cr multi block request 16,482   8 0 0.20
SQL*Net message to client 4,049,016   7 0 49.77
Streams AQ: qmn coordinator waiting for slave to start 1 100 6 6210 0.00
CGS wait for IPC msg 307,418 100 4 0 3.78
LGWR wait for redo copy 622 51 3 6 0.01
gc current grant busy 3,185   3 1 0.04
log file sequential read 260   3 12 0.00
enq: TX - contention 890 0 3 3 0.01
ges lmd/lmses to freeze in rcfg - mrcvr 377 51 2 6 0.00
enq: PR - contention 5   2 453 0.00
PX Deq Credit: send blkd 4,532 57 2 0 0.06
SQL*Net more data from client 27,438   2 0 0.34
latch: object queue header operation 14   2 139 0.00
enq: TX - index contention 124   2 15 0.00
gc cr block busy 492   2 4 0.01
latch: checkpoint queue latch 4   2 441 0.00
PX Deq: reap credit 38,745 89 2 0 0.48
cursor: pin S 1,020,253   1 0 12.54
ksxr poll remote instances 113,136 49 1 0 1.39
enq: HW - contention 78 3 1 16 0.00
name-service call wait 25   1 48 0.00
CSS operation: query 126   1 9 0.00
rdbms ipc reply 2,787   1 0 0.03
latch: redo allocation 1   1 966 0.00
Data file init write 121   1 7 0.00
enq: CF - contention 435 0 1 2 0.01
SQL*Net message from dblink 398   1 2 0.00
enq: PS - contention 1,238   1 1 0.02
db file parallel read 132   1 4 0.00
log file switch completion 20   0 23 0.00
gc cr grant 2-way 1,572   0 0 0.02
wait list latch free 35   0 11 0.00
gc current multi block request 1,701   0 0 0.02
cursor: pin S wait on X 26 96 0 10 0.00
IPC send completion sync 895 100 0 0 0.01
enq: FB - contention 343   0 1 0.00
gcs drm freeze in enter server mode 1   0 211 0.00
kksfbc child completion 4 100 0 50 0.00
undo segment extension 2 100 0 99 0.00
PX Deq: Signal ACK 1,218 32 0 0 0.01
gc current grant 2-way 399   0 0 0.00
library cache lock 300   0 0 0.00
library cache pin 337   0 0 0.00
Log archive I/O 220   0 0 0.00
CSS initialization 42   0 2 0.00
latch: enqueue hash chains 144   0 1 0.00
ksdxexeotherwait 44,557 100 0 0 0.55
gc current retry 4   0 15 0.00
gc current split 13   0 4 0.00
local write wait 19   0 3 0.00
buffer deadlock 382 96 0 0 0.00
enq: TA - contention 75   0 0 0.00
enq: TX - allocate ITL entry 40   0 1 0.00
CSS operation: action 86   0 0 0.00
enq: JQ - contention 45   0 1 0.00
global enqueue expand wait 2 100 0 10 0.00
direct path write 347   0 0 0.00
latch: gcs resource hash 96   0 0 0.00
enq: RO - fast object reuse 13   0 1 0.00
latch: library cache pin 9   0 1 0.00
ges inquiry response 12   0 1 0.00
enq: MW - contention 13   0 1 0.00
enq: DR - contention 13   0 0 0.00
enq: JS - job run lock - synchronize 12   0 0 0.00
log file single write 20   0 0 0.00
latch: KCL gc element parent latch 70   0 0 0.00
db file single write 12   0 0 0.00
latch: messages 10   0 0 0.00
enq: TT - contention 3   0 1 0.00
latch: undo global data 1   0 1 0.00
enq: AF - task serialization 2   0 1 0.00
KJC: Wait for msg sends to complete 10   0 0 0.00
enq: TX - row lock contention 1   0 1 0.00
enq: WL - contention 2   0 0 0.00
read by other session 7   0 0 0.00
SQL*Net message to dblink 369   0 0 0.00
enq: PI - contention 2   0 0 0.00
enq: IR - contention 1   0 0 0.00
enq: UL - contention 1   0 0 0.00
enq: SW - contention 1   0 0 0.00
gc cr failure 1   0 0 0.00
wait for scn ack 2   0 0 0.00
lock escalate retry 3 67 0 0 0.00
cursor: mutex X 2   0 0 0.00
cr request retry 1 100 0 0 0.00
lock deadlock retry 1 100 0 0 0.00
SQL*Net message from client 4,255,188   26,134,432 6142 52.30
gcs remote message 6,323,614 94 177,664 28 77.73
jobq slave wait 40,788 98 118,430 2904 0.50
PX Idle Wait 10,890 92 25,563 2347 0.13
Streams AQ: qmn slave idle wait 879 0 22,267 25332 0.01
DIAG idle wait 113,761   22,236 195 1.40
ASM background timer 5,099   22,223 4358 0.06
ges remote message 598,518 63 22,217 37 7.36
Streams AQ: qmn coordinator idle wait 1,646 50 22,202 13489 0.02
virtual circuit status 760 100 22,190 29198 0.01
class slave wait 2,473 86 21,912 8860 0.03
Streams AQ: waiting for time management or cleanup tasks 85   21,849 257051 0.00
PX Deq: Execution Msg 3,804 24 986 259 0.05
i/o slave wait 42,190   80 2 0.52
KSV master wait 187   7 39 0.00
PX Deq: Join ACK 1,347 35 1 1 0.02
single-task message 29   1 48 0.00
PX Deq: Parse Reply 1,271 35 0 0 0.02
PX Deq: Msg Fragment 1,353 21 0 0 0.02
PX Deq: Execute Reply 1,187 35 0 0 0.01
Streams AQ: RAC qmn coordinator idle wait 1,660 100 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
events in waitclass Other 494,656 82 88 0 6.08
os thread startup 669 1 52 77 0.01
log file parallel write 72,324   36 0 0.89
control file sequential read 59,736   27 0 0.73
control file parallel write 8,841   11 1 0.11
log file sequential read 260   3 12 0.00
latch: shared pool 4   1 307 0.00
gc cr block 2-way 2,380   1 0 0.03
latch: row cache objects 155   1 7 0.00
latch: cache buffers chains 104   1 9 0.00
latch: library cache lock 1   0 492 0.00
enq: TM - contention 966   0 0 0.01
gc current block 2-way 865   0 0 0.01
Log archive I/O 220   0 0 0.00
gc current grant busy 74   0 0 0.00
buffer busy waits 28   0 1 0.00
db file sequential read 2   0 5 0.00
log file single write 20   0 0 0.00
direct path write 278   0 0 0.00
direct path read 380   0 0 0.00
enq: RO - fast object reuse 5   0 0 0.00
rdbms ipc message 617,936 53 376,220 609 7.60
gcs remote message 6,323,636 94 177,664 28 77.73
DIAG idle wait 113,761   22,236 195 1.40
ASM background timer 5,099   22,223 4358 0.06
ges remote message 598,487 63 22,217 37 7.36
Streams AQ: qmn coordinator idle wait 1,646 50 22,202 13489 0.02
pmon timer 21,793 100 22,151 1016 0.27
class slave wait 2,285 93 21,912 9589 0.03
Streams AQ: waiting for time management or cleanup tasks 85   21,849 257051 0.00
smon timer 95   21,530 226634 0.00
KSV master wait 101   3 29 0.00
Streams AQ: RAC qmn coordinator idle wait 1,660 100 0 0 0.02

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 2,460,875
IDLE_TIME 70,411,270
IOWAIT_TIME 19,373
NICE_TIME 270
SYS_TIME 1,310,209
USER_TIME 1,106,287
LOAD 2
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 6,980,502,528
VM_OUT_BYTES 4,341,166,080
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 469,050.80 16,847.10 178,140 198,653,965
SYS$USERS 267.90 266.40 27 296,194
SYS$BACKGROUND 0.30 0.50 2,007 274,463
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 73129 47 122478 1382 0 0 3510400 17
SYS$USERS 17499 11 466 19 0 0 23605 0
SYS$BACKGROUND 2619 3 5008 59 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
457,627 178 24,529 18.66 97.51 f7wycxzwr231m JDBC Thin Client insert into TB_ACCOUNT_INTERFA...
491 439 178,818 0.00 0.10 az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
269 274 1,050 0.26 0.06 d3rgr1ugyfy4v   select * from ( select temp.* ...
243 194 171,543 0.00 0.05 0k8522rmdzg4k   select privilege# from sysauth...
225 140 23,962 0.01 0.05 8g02qq5sb8gkk JDBC Thin Client INSERT INTO TB_AUTH_LOG(LOG_ID...
189 192 1,050 0.18 0.04 9j3v93dcqd1ng   select count(*) from (select c...
173 177 7 24.78 0.04 6p18ng82999p1 oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
170 116 170,577 0.00 0.04 5ur69atw3vfhj   select decode(failover_method,...
161 164 7 22.93 0.03 36pd7s33q8t3d oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
156 160 458 0.34 0.03 04v68mrc0ndtt   select * from ( select temp.* ...

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
439 491 178,818 0.00 2.56 0.10 az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
274 269 1,050 0.26 1.60 0.06 d3rgr1ugyfy4v   select * from ( select temp.* ...
194 243 171,543 0.00 1.13 0.05 0k8522rmdzg4k   select privilege# from sysauth...
192 189 1,050 0.18 1.12 0.04 9j3v93dcqd1ng   select count(*) from (select c...
178 457,627 24,529 0.01 1.04 97.51 f7wycxzwr231m JDBC Thin Client insert into TB_ACCOUNT_INTERFA...
177 173 7 25.35 1.04 0.04 6p18ng82999p1 oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
164 161 7 23.45 0.96 0.03 36pd7s33q8t3d oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
160 156 458 0.35 0.93 0.03 04v68mrc0ndtt   select * from ( select temp.* ...
153 149 6 25.45 0.89 0.03 gtct3f6rqmt7k   BEGIN proc_tb_server_kpi(:1, :...
153 149 6 25.45 0.89 0.03 aucbhp050unfp   INSERT INTO TB_SERVER_KPI (SER...

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
13,403,828 458 29,266.00 6.73 159.76 156.38 04v68mrc0ndtt   select * from ( select temp.* ...
11,473,825 1,050 10,927.45 5.76 273.94 269.14 d3rgr1ugyfy4v   select * from ( select temp.* ...
8,765,364 178,818 49.02 4.40 438.86 491.21 az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
8,764,251 1,050 8,346.91 4.40 192.26 188.82 9j3v93dcqd1ng   select count(*) from (select c...
4,464,093 193 23,130.02 2.24 71.97 70.56 8qk3ffrqfu5mj   select count(*) from (select a...
4,134,973 11 375,906.64 2.08 11.13 10.91 abc0gp2snqgc6   select * from ( select temp.* ...
4,134,909 11 375,900.82 2.08 11.33 11.08 dvx2pht8zybj3   select count(*) from tb_articl...
3,748,148 181 20,708.00 1.88 78.07 76.57 b6sts095f7490   select * from ( select temp.* ...
2,615,294 25,894 101.00 1.31 26.77 26.57 chvsc0kcnaygf   select * from ( select t.adver...
2,607,206 7 372,458.00 1.31 177.43 173.47 6p18ng82999p1 oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
2,607,171 7 372,453.00 1.31 164.15 160.52 36pd7s33q8t3d oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
2,399,558 23,758 101.00 1.20 25.86 25.61 4bkajwhn01bf4   select m.* from (select t.adve...
2,234,835 6 372,472.50 1.12 152.70 149.39 gtct3f6rqmt7k   BEGIN proc_tb_server_kpi(:1, :...
2,234,829 6 372,471.50 1.12 152.69 149.38 aucbhp050unfp   INSERT INTO TB_SERVER_KPI (SER...

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
93,504 1 93,504.00 51.90 13.37 18.24 dkpzqaa4b8vav PL/SQL Developer select * from tb_account_inter...
4,167 1 4,167.00 2.31 1.73 2.24 11ww6q6bzqjtf PL/SQL Developer select count(1) from tb_portal...
1,424 5 284.80 0.79 1.25 2.62 0dwr2vd6vbqzs   SELECT count(*) over () as tot...
1,215 2 607.50 0.67 1.56 2.89 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
33 24,529 0.00 0.02 177.91 457627.24 f7wycxzwr231m JDBC Thin Client insert into TB_ACCOUNT_INTERFA...
7 23,962 0.00 0.00 140.05 224.66 8g02qq5sb8gkk JDBC Thin Client INSERT INTO TB_AUTH_LOG(LOG_ID...
1 1 1.00 0.00 0.04 0.05 0gkq5s6hqx8hy   insert into wrh$_sessmetric_hi...
1 1,697 0.00 0.00 1.57 1.65 5kt6k7qwjz6fu JDBC Thin Client select * from (select t.*, row...
1 17,140 0.00 0.00 14.53 18.37 awq9n3jt2dwrt JDBC Thin Client select portaluser0_.ID as ID3_...
1 1,162 0.00 0.00 0.47 0.48 g4hsmh25tmwfh   update TW_ALARM_INFO set ALARM...

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
348,852 2,903 0.01 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
178,818 0 0.00 0.00 0.00 az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
171,543 348,850 2.03 0.00 0.00 0k8522rmdzg4k   select privilege# from sysauth...
171,205 171,203 1.00 0.00 0.00 459f3z9u4fb3u   select value$ from props$ wher...
171,204 171,204 1.00 0.00 0.00 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
170,577 170,578 1.00 0.00 0.00 5ur69atw3vfhj   select decode(failover_method,...
112,784 0 0.00 0.00 0.00 bw2rqq1s3bzrd   select tbtestwhit0_.wl_id as w...
45,378 408,402 9.00 0.00 0.00 c77pa2g2u0rq9   select tdict0_.ID as ID112_, t...
25,894 0 0.00 0.00 0.00 chvsc0kcnaygf   select * from ( select t.adver...
24,529 24,529 1.00 0.00 0.00 dtrjpdn3fw6as JDBC Thin Client select TB_ACCOUNT_INTERFACE_LO...
24,529 24,529 1.00 0.01 18.66 f7wycxzwr231m JDBC Thin Client insert into TB_ACCOUNT_INTERFA...
23,962 23,962 1.00 0.01 0.01 8g02qq5sb8gkk JDBC Thin Client INSERT INTO TB_AUTH_LOG(LOG_ID...
23,758 23,751 1.00 0.00 0.00 4bkajwhn01bf4   select m.* from (select t.adve...
23,433 23,433 1.00 0.00 0.00 c68x2drb8jh6f   SELECT T.LABEL_ID, T.LABEL_NAM...
23,391 136,131 5.82 0.00 0.00 asycs9abcdt1k JDBC Thin Client SELECT TP.ID, TP.SP_ID, TP.SP_...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
348,852 348,852 15.91 0h6b2sajwb74n   select privilege#, level from ...
178,833 178,818 8.16 az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
171,543 171,543 7.82 0k8522rmdzg4k   select privilege# from sysauth...
171,205 171,204 7.81 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
171,205 171,205 7.81 459f3z9u4fb3u   select value$ from props$ wher...
170,579 170,577 7.78 5ur69atw3vfhj   select decode(failover_method,...
112,784 112,784 5.14 bw2rqq1s3bzrd   select tbtestwhit0_.wl_id as w...
45,378 45,378 2.07 c77pa2g2u0rq9   select tdict0_.ID as ID112_, t...
25,894 25,894 1.18 chvsc0kcnaygf   select * from ( select t.adver...
24,529 24,529 1.12 dtrjpdn3fw6as JDBC Thin Client select TB_ACCOUNT_INTERFACE_LO...
24,529 24,529 1.12 f7wycxzwr231m JDBC Thin Client insert into TB_ACCOUNT_INTERFA...
23,962 23,962 1.09 8g02qq5sb8gkk JDBC Thin Client INSERT INTO TB_AUTH_LOG(LOG_ID...
23,758 23,758 1.08 4bkajwhn01bf4   select m.* from (select t.adve...
23,433 23,433 1.07 c68x2drb8jh6f   SELECT T.LABEL_ID, T.LABEL_NAM...
23,391 23,391 1.07 asycs9abcdt1k JDBC Thin Client SELECT TP.ID, TP.SP_ID, TP.SP_...

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
22 1,162 g4hsmh25tmwfh   update TW_ALARM_INFO set ALARM...
21 9,535 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
21 408 aq8yqxyyb40nn   update sys.job$ set this_date=...

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
66.69 29.69 224.66 140.05 23,962 8g02qq5sb8gkk JDBC Thin Client INSERT INTO TB_AUTH_LOG(LOG_ID...
52.24 0.01 457,627.24 177.91 24,529 f7wycxzwr231m JDBC Thin Client insert into TB_ACCOUNT_INTERFA...
6.49 35.60 18.24 13.37 1 dkpzqaa4b8vav PL/SQL Developer select * from tb_account_inter...
3.33 22.87 14.55 11.93 2,283 axmdf8vq7k1rh   select increment$, minvalue, m...
2.80 6.72 41.71 22.81 320 bcz7kcb5nhjfv   insert into tb_user_oper_log (...
2.11 57.85 3.64 1.71 2,599 7bd391hat42zk   select /*+ rule */ name, file#...
2.08 0.42 491.21 438.86 178,818 az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
2.05 22.80 9.01 7.05 9,535 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
1.36 53.16 2.57 1.20 719 5ansr7r9htpq3   update undo$ set name=:2, file...
0.94 4.51 20.76 18.00 24,529 dtrjpdn3fw6as JDBC Thin Client select TB_ACCOUNT_INTERFACE_LO...
0.52 22.97 2.24 1.73 1 11ww6q6bzqjtf PL/SQL Developer select count(1) from tb_portal...
0.51 0.27 188.82 192.26 1,050 9j3v93dcqd1ng   select count(*) from (select c...
0.40 26.66 1.51 1.09 408 aq8yqxyyb40nn   update sys.job$ set this_date=...
0.40 15.27 2.62 1.25 5 0dwr2vd6vbqzs   SELECT count(*) over () as tot...
0.35 12.23 2.89 1.56 2 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
0.30 0.11 269.14 273.94 1,050 d3rgr1ugyfy4v   select * from ( select temp.* ...
0.20 1.09 18.37 14.53 17,140 awq9n3jt2dwrt JDBC Thin Client select portaluser0_.ID as ID3_...
0.18 8.25 2.24 2.17 3 51kmqtgr5z85s PL/SQL Developer select * from tb_access_token ...
0.13 0.19 70.56 71.97 193 8qk3ffrqfu5mj   select count(*) from (select a...
0.12 7.03 1.65 1.57 1,697 5kt6k7qwjz6fu JDBC Thin Client select * from (select t.*, row...
0.09 0.12 76.57 78.07 181 b6sts095f7490   select * from ( select temp.* ...
0.06 0.50 12.82 10.49 14,960 9w01ztmr4569k   select count(*) from tb_articl...
0.06 0.04 149.38 152.69 6 aucbhp050unfp   INSERT INTO TB_SERVER_KPI (SER...
0.06 0.04 149.39 152.70 6 gtct3f6rqmt7k   BEGIN proc_tb_server_kpi(:1, :...
0.06 0.04 173.47 177.43 7 6p18ng82999p1 oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
0.06 0.43 13.96 11.91 15,038 4aa2pajm13day   select count(*) from tb_articl...
0.05 29.78 0.18 0.14 22 7cq8d0jqxzum1   delete from smon_scn_time wher...
0.05 1.23 4.16 2.82 4,451 cbvwasd557av2   insert into tb_wap_visit_log (...
0.05 0.03 160.52 164.15 7 36pd7s33q8t3d oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
0.03 0.36 9.52 8.91 14,960 3r189y4actbt2   select * from ( select temp.* ...
0.03 15.42 0.21 0.17 263 18naypzfmabd6   INSERT INTO MGMT_SYSTEM_PERFOR...
0.03 0.18 17.20 17.50 15,036 gxa2gs64zaq6p   select * from ( select temp.* ...
0.02 11.61 0.21 0.17 638 g00cj285jmgsw   update sys.mon_mods$ set inser...
0.02 14.38 0.14 0.11 319 04xtrk7uyhknh   select obj#, type#, ctime, mti...
0.02 16.50 0.11 0.09 5 31a13pnjps7j3   SELECT source, (case when time...
0.01 0.13 10.91 11.13 11 abc0gp2snqgc6   select * from ( select temp.* ...
0.01 0.13 11.08 11.33 11 dvx2pht8zybj3   select count(*) from tb_articl...
0.01 12.61 0.10 0.08 273 91h2x42zqagcm   UPDATE MGMT_CURRENT_METRICS SE...
0.01 0.29 3.73 3.78 678 2ug5va58ks6nc   select count(*) from tb_articl...
0.01 0.37 2.62 2.67 2 8823uk5zfv6d8 JDBC Thin Client select t1.CONTENT_ID, t1.IS_PR...
0.01 12.69 0.07 0.07 12 0cfuq7q5cwvpb   select program_oid, schedule_e...
0.01 0.42 2.05 2.09 1 72pjn5ufnn75x JDBC Thin Client select t1.CONTENT_ID, t1.IS_PR...
0.01 0.15 5.39 5.51 11 gg14jykdjfk1v   select count(*) from (select a...
0.01 0.06 10.92 11.13 67 g7558pad7w8pk   select * from ( select temp.* ...
0.01 5.81 0.10 0.10 1 amrf492v0v82z   select * from (select t.orderi...
0.01 0.05 11.49 11.70 94 6x6f4n9yatry9   select * from ( select temp.* ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
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
04xtrk7uyhknhselect obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0cfuq7q5cwvpbselect program_oid, schedule_expr, next_run_date, class_oid, comments, flags, schedule_limit, end_date, run_count, failure_count, last_enabled_time, number_of_args, max_failures, max_runs, job_weight, schedule_id, program_action, start_date, max_run_duration, priority, retry_count, running_instance, running_slave, job_status, last_start_date, last_end_date, user_callback, user_callback_ctx, creator, client_id, guid, nls_env, env, char_env, source, destination, queue_owner, queue_name, queue_agent, event_rule, mxdur_msgid, owner_udn from sys.scheduler$_job where obj# = :1
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
0gkq5s6hqx8hyinsert into wrh$_sessmetric_history (snap_id, dbid, instance_number, begin_time, end_time, sessid, serial#, intsize, group_id, metric_id, value) select :snap_id, :dbid, :instance_number, begtime, endtime, eid, eidsq, intsize_csec, groupid, metricid, value from x$kewmdrmv where groupid = 4
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
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')
11ww6q6bzqjtfselect count(1) from tb_portal_user
18naypzfmabd6INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
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"
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
51kmqtgr5z85sselect * from tb_access_token a where a.account='13559923679' order by token_id desc
5ansr7r9htpq3update undo$ set name=:2, file#=:3, block#=:4, status$=:5, user#=:6, undosqn=:7, xactsqn=:8, scnbas=:9, scnwrp=:10, inst#=:11, ts#=:12, spare1=:13 where us#=:1
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
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"
6x6f4n9yatry9select * 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 = 10598023 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
72pjn5ufnn75x select t1.CONTENT_ID, t1.IS_PROVINCE, t1.TITLE, t1.ORIGIN_SOURCE, to_char(t1.CREATE_DATE, 'yyyy-mm-dd hh24:mi:ss') CREATE_DATE, to_char(t1.AUDIT_DATE, 'yyyy-mm-dd hh24:mi:ss') AUDIT_DATE, to_char(t1.RELEASE_DATE, 'yyyy-mm-dd hh24:mi:ss') RELEASE_DATE, t1.STATUS, t1.PLANT_CODE, t1.TOP_CONTENT, t1.IS_HIGHLIGHT, t2.*, (select count(DISTINCT w.CONTENT_ID) TOTLES from TB_ARTICLE_DESC w , TB_ARTICLE_CONTENT_RELATION w2, TB_PAGE_CONTENT w3 where w.CONTENT_ID=w2.CONTENT_ID and w2.COLUMN_ID=w3.COLUMN_ID and w.PLANT_CODE !=10001 and w.STATUS =2 and w.IS_PROVINCE = 1 and w3.CITY_ID='598' ) TOTLES from (select k1.CONTENT_ID, k1.IS_PROVINCE, k1.TITLE, k1.ORIGIN_SOURCE, k1.CREATE_DATE, k1.AUDIT_DATE, k1.RELEASE_DATE, k1.STATUS, k1.PLANT_CODE, k1.TOP_CONTENT, k1.IS_HIGHLIGHT from (select ROWNUM RNUM, t11.CONTENT_ID, t11.IS_PROVINCE, t11.TITLE, t11.ORIGIN_SOURCE, t11.CREATE_DATE, t11.AUDIT_DATE, t11.RELEASE_DATE, t11.STATUS, t11.PLANT_CODE, t11.TOP_CONTENT, t11.IS_HIGHLIGHT from (select DISTINCT t111.* from TB_ARTICLE_DESC t111, TB_ARTICLE_CONTENT_RELATION t112, TB_PAGE_CONTENT t113 where t111.CONTENT_ID=t112.CONTENT_ID and t112.COLUMN_ID=t113.COLUMN_ID and t111.PLANT_CODE !=10001 and t111.STATUS =2 and t111.IS_PROVINCE = 1 and t113.CITY_ID='598' order by t111.AUDIT_DATE desc) t11)k1 where k1.RNUM<= 15 and k1.RNUM > 0 ) t1, (select a.CONTENT_ID , wm_concat(a.COLUMN_ID) as COlIDS, wm_concat(b.CNNAME) as COlNAMES, wm_concat(b.CITY_ID) as CITYIDS, wm_concat(b.TYPE) as TYPES from TB_ARTICLE_CONTENT_RELATION a, TB_PAGE_CONTENT b where a.COLUMN_ID = b.COLUMN_ID and exists (select 1 from (select k2.CONTENT_ID from (select ROWNUM RNUM, c.CONTENT_ID from (select DISTINCT t22.* from TB_ARTICLE_DESC t22, TB_ARTICLE_CONTENT_RELATION t23, TB_PAGE_CONTENT t24 where t22.CONTENT_ID=t23.CONTENT_ID and t23.COLUMN_ID=t24.COLUMN_ID and t22.PLANT_CODE !=10001 and t22.STATUS =2 and t22.IS_PROVINCE = 1 and t24.CITY_ID='598' order by t22.AUDIT_DATE desc) c)k2 where k2.RNUM<= 15 and k2.RNUM > 0 ) d where a.CONTENT_ID = d.CONTENT_ID) group by a.CONTENT_ID) t2 where t1.CONTENT_ID = t2.CONTENT_ID(+) order by t1.AUDIT_DATE desc
7bd391hat42zkselect /*+ rule */ name, file#, block#, status$, user#, undosqn, xactsqn, scnbas, scnwrp, DECODE(inst#, 0, NULL, inst#), ts#, spare1 from undo$ where us#=:1
7cq8d0jqxzum1delete from smon_scn_time where thread=0 and scn = (select min(scn) from smon_scn_time where thread=0)
8823uk5zfv6d8 select t1.CONTENT_ID, t1.IS_PROVINCE, t1.TITLE, t1.ORIGIN_SOURCE, to_char(t1.CREATE_DATE, 'yyyy-mm-dd hh24:mi:ss') CREATE_DATE, to_char(t1.AUDIT_DATE, 'yyyy-mm-dd hh24:mi:ss') AUDIT_DATE, to_char(t1.RELEASE_DATE, 'yyyy-mm-dd hh24:mi:ss') RELEASE_DATE, t1.STATUS, t1.PLANT_CODE, t1.TOP_CONTENT, t1.IS_HIGHLIGHT, t2.*, (select count(DISTINCT w.CONTENT_ID) TOTLES from TB_ARTICLE_DESC w , TB_ARTICLE_CONTENT_RELATION w2, TB_PAGE_CONTENT w3 where w.CONTENT_ID=w2.CONTENT_ID and w2.COLUMN_ID=w3.COLUMN_ID and w.PLANT_CODE !=10001 and w.STATUS in (0, 3, 5) and w.IS_PROVINCE = 1 and w3.CITY_ID='598' ) TOTLES from (select k1.CONTENT_ID, k1.IS_PROVINCE, k1.TITLE, k1.ORIGIN_SOURCE, k1.CREATE_DATE, k1.AUDIT_DATE, k1.RELEASE_DATE, k1.STATUS, k1.PLANT_CODE, k1.TOP_CONTENT, k1.IS_HIGHLIGHT from (select ROWNUM RNUM, t11.CONTENT_ID, t11.IS_PROVINCE, t11.TITLE, t11.ORIGIN_SOURCE, t11.CREATE_DATE, t11.AUDIT_DATE, t11.RELEASE_DATE, t11.STATUS, t11.PLANT_CODE, t11.TOP_CONTENT, t11.IS_HIGHLIGHT from (select DISTINCT t111.* from TB_ARTICLE_DESC t111, TB_ARTICLE_CONTENT_RELATION t112, TB_PAGE_CONTENT t113 where t111.CONTENT_ID=t112.CONTENT_ID and t112.COLUMN_ID=t113.COLUMN_ID and t111.PLANT_CODE !=10001 and t111.STATUS in (0, 3, 5) and t111.IS_PROVINCE = 1 and t113.CITY_ID='598' order by t111.CREATE_DATE desc) t11)k1 where k1.RNUM<= 15 and k1.RNUM > 0 ) t1, ( select a.CONTENT_ID, wm_concat(a.COLUMN_ID) as COlIDS, wm_concat(b.CNNAME) as COlNAMES, wm_concat(b.CITY_ID) as CITYIDS, wm_concat(b.TYPE) as TYPES from TB_ARTICLE_CONTENT_RELATION a, TB_PAGE_CONTENT b where a.COLUMN_ID = b.COLUMN_ID and exists (select 1 from (select k2.CONTENT_ID from (select ROWNUM RNUM, c.CONTENT_ID from (select DISTINCT t22.* from TB_ARTICLE_DESC t22, TB_ARTICLE_CONTENT_RELATION t23, TB_PAGE_CONTENT t24 where t22.CONTENT_ID=t23.CONTENT_ID and t23.COLUMN_ID=t24.COLUMN_ID and t22.PLANT_CODE !=10001 and t22.STATUS in (0, 3, 5) and t22.IS_PROVINCE = 1 and t24.CITY_ID='598' order by t22.CREATE_DATE desc) c)k2 where k2.RNUM<= 15 and k2.RNUM > 0 ) d where a.CONTENT_ID = d.CONTENT_ID) group by a.CONTENT_ID) t2 where t1.CONTENT_ID = t2.CONTENT_ID(+) order by t1.CREATE_DATE desc
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)
91h2x42zqagcmUPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B3 , VALUE = :B2 , STRING_VALUE = :B1 WHERE TARGET_GUID = :B6 AND METRIC_GUID = :B5 AND KEY_VALUE = :B4 AND COLLECTION_TIMESTAMP < :B3
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)
abc0gp2snqgc6select * from ( select temp.* , rownum num from ( select a.content_id, p.column_id, p.city_id, p.cnname, 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.short_title, c.image_path, c.show_image, nvl(a.views_count, 0) views_count from tb_article a, tb_article_content b, tb_article_desc c, tb_article_content_relation acr, tb_page_content p where a.status = 2 and a.content_id = b.content_id and a.content_id = c.content_id and acr.column_id = p.column_id and acr.content_id = a.content_id and p.status = 2 and p.name = :1 and p.city_id = :2 and p.type = 2 order by c.top_content desc, c.release_date desc, a.content_id¡¡) temp where rownum <= :3 ) where¡¡num > :4
amrf492v0v82zselect * from (select t.orderid, t.payment_amout, to_char( t.transaction_time, 'yyyymmdd') time from TB_FEE_PAYMENT_LOG t where t.payment_type =:1 and t.req_type = 2 and t.result = 1 and t.pay_type = 3 and t.msisdn =:2 order by t.transaction_time desc) where rownum<13
aq8yqxyyb40nnupdate sys.job$ set this_date=:1 where job=: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)
awq9n3jt2dwrtselect portaluser0_.ID as ID3_, portaluser0_.IS_CHANGE_CITY as IS2_3_, portaluser0_.CITY_ID as CITY3_3_, portaluser0_.CNNAME as CNNAME3_, portaluser0_.DEFAULT_CITY_ID as DEFAULT5_3_, portaluser0_.EMAIL as EMAIL3_, portaluser0_.ID_CARD_NO as ID7_3_, portaluser0_.IMG as IMG3_, portaluser0_.INTEREST as INTEREST3_, portaluser0_.LOCK_USER as LOCK10_3_, portaluser0_.MEDICAL_INSU_NO as MEDICAL11_3_, portaluser0_.MOBILE as MOBILE3_, portaluser0_.PASSWORD as PASSWORD3_, portaluser0_.PUSH_TYPE as PUSH14_3_, portaluser0_.REG_CHANNEL as REG15_3_, portaluser0_.REG_TIME as REG16_3_, portaluser0_.SEX as SEX3_, portaluser0_.SOCIAL_INSU_NO as SOCIAL18_3_, portaluser0_.STATUS as STATUS3_, portaluser0_.USER_TYPE as USER20_3_, portaluser0_.XM_IMPORTTIME as XM21_3_, portaluser0_.XM_PWD as XM22_3_, portaluser0_.XM_PWD_RESETTIME as XM23_3_, portaluser0_.XM_RANDCODE as XM24_3_, portaluser0_.XM_USER_ID as XM25_3_, portaluser0_.XM_USERTYPE as XM26_3_ from TB_PORTAL_USER portaluser0_ where portaluser0_.MOBILE=:1
axmdf8vq7k1rhselect increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1
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
c77pa2g2u0rq9select tdict0_.ID as ID112_, tdict0_.GROUP_ID as GROUP2_112_, tdict0_.DICT_NAME as DICT3_112_, tdict0_.DICT_VALUE as DICT4_112_, tdict0_.DICT_INDEX as DICT5_112_, tdict0_.REMARK as REMARK112_ from T_DICT tdict0_, T_DICT_GROUP tdictgroup1_ where tdict0_.GROUP_ID=tdictgroup1_.ID and tdictgroup1_.GROUP_NAME=:1 and tdict0_.DICT_VALUE<>'pingtan' order by tdict0_.DICT_INDEX
cbvwasd557av2insert into tb_wap_visit_log (wap_visit_log_id, access_type, operate_time, phone_no, phone_model, os, resolution, wap_version, client_versioin, create_date) values (tb_wap_visit_log_seq.nextval, :1, TO_DATE(:2, 'YYYY-MM-dd HH24:mi:ss'), :3, :4, :5, :6, :7, :8, TO_DATE(:9, 'YYYY-MM-dd HH24:mi:ss'))
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
d92h3rjp0y217begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
dkpzqaa4b8vavselect * from tb_account_interface_log l where l.request_time>=to_date('2013-2-25', 'yyyy-mm-dd') order by id desc
dtrjpdn3fw6asselect TB_ACCOUNT_INTERFACE_LOG_SEQ.nextval from dual
dvx2pht8zybj3select count(*) from tb_article a, tb_article_content b, tb_article_desc c, tb_article_content_relation acr, tb_page_content p where a.status = 2 and a.content_id = b.content_id and a.content_id = c.content_id and acr.column_id = p.column_id and acr.content_id = a.content_id and p.status = 2 and p.name = :1 and p.city_id = :2 and p.type = 2
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)
g00cj285jmgswupdate sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g4hsmh25tmwfhupdate TW_ALARM_INFO set ALARMCODE=:1, ALARMTITLE=:2, ALARMSEVERITY=:3, ALARMFACILITY=:4, DIALSTATUS=:5, ALARMDETAIL=:6, ALARMCREATETIME=:7, OPERSTATUS=:8 where ORIID=:9
g7558pad7w8pkselect * 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 = 10599031 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
gg14jykdjfk1vselect 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 = 10599007 or t.column_id = 10599007))) 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 = 10599007 or t.column_id = 10599007))) group by content_id having count(*) > 1)
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 586,042 25.73 7.20
CPU used when call started 577,203 25.34 7.09
CR blocks created 1,155 0.05 0.01
Cached Commit SCN referenced 2,025,362 88.92 24.90
Commit SCN cached 73 0.00 0.00
DB time 59,627,162 2,617.73 732.93
DBWR checkpoint buffers written 67,190 2.95 0.83
DBWR checkpoints 9 0.00 0.00
DBWR fusion writes 2,103 0.09 0.03
DBWR object drop buffers written 13 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 17,576 0.77 0.22
DBWR undo block writes 21,986 0.97 0.27
DFO trees parallelized 466 0.02 0.01
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 2,519 0.11 0.03
PX local messages sent 2,519 0.11 0.03
PX remote messages recv'd 2,362 0.10 0.03
PX remote messages sent 6,696 0.29 0.08
Parallel operations not downgraded 466 0.02 0.01
RowCR - row contention 2 0.00 0.00
RowCR attempts 885 0.04 0.01
RowCR hits 880 0.04 0.01
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 11 0.00 0.00
SQL*Net roundtrips to/from client 3,224,232 141.55 39.63
SQL*Net roundtrips to/from dblink 369 0.02 0.00
active txn count during cleanout 22,360 0.98 0.27
application wait time 45,407,466 1,993.46 558.14
background checkpoints completed 5 0.00 0.00
background checkpoints started 5 0.00 0.00
background timeouts 110,819 4.87 1.36
branch node splits 5 0.00 0.00
buffer is not pinned count 51,389,391 2,256.08 631.67
buffer is pinned count 131,356,911 5,766.78 1,614.61
bytes received via SQL*Net from client 670,436,762 29,433.25 8,240.88
bytes received via SQL*Net from dblink 123,235 5.41 1.51
bytes sent via SQL*Net to client 1,400,297,924 61,475.34 17,212.19
bytes sent via SQL*Net to dblink 122,203 5.36 1.50
calls to get snapshot scn: kcmgss 6,617,244 290.51 81.34
calls to kcmgas 177,135 7.78 2.18
calls to kcmgcs 10,400 0.46 0.13
change write time 3,284 0.14 0.04
cleanout - number of ktugct calls 11,239 0.49 0.14
cleanouts and rollbacks - consistent read gets 409 0.02 0.01
cleanouts only - consistent read gets 260 0.01 0.00
cluster key scan block gets 227,639 9.99 2.80
cluster key scans 193,715 8.50 2.38
cluster wait time 14,377 0.63 0.18
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 82 0.00 0.00
commit batch/immediate requested 82 0.00 0.00
commit cleanout failures: block lost 75 0.00 0.00
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 446 0.02 0.01
commit cleanout failures: cannot pin 271 0.01 0.00
commit cleanouts 153,502 6.74 1.89
commit cleanouts successfully completed 152,710 6.70 1.88
commit immediate performed 82 0.00 0.00
commit immediate requested 82 0.00 0.00
commit txn count during cleanout 20,940 0.92 0.26
concurrency wait time 146,018 6.41 1.79
consistent changes 2,268 0.10 0.03
consistent gets 198,480,732 8,713.62 2,439.69
consistent gets - examination 79,494,969 3,489.96 977.14
consistent gets direct 79,795 3.50 0.98
consistent gets from cache 198,400,937 8,710.12 2,438.71
current blocks converted for CR 0 0.00 0.00
cursor authentications 2,326 0.10 0.03
data blocks consistent reads - undo records applied 1,079 0.05 0.01
db block changes 581,432 25.53 7.15
db block gets 738,141 32.41 9.07
db block gets direct 1,305 0.06 0.02
db block gets from cache 736,836 32.35 9.06
deferred (CURRENT) block cleanout applications 77,814 3.42 0.96
dirty buffers inspected 5 0.00 0.00
enqueue conversions 6,750 0.30 0.08
enqueue releases 758,979 33.32 9.33
enqueue requests 759,147 33.33 9.33
enqueue timeouts 167 0.01 0.00
enqueue waits 59,772 2.62 0.73
exchange deadlocks 431 0.02 0.01
execute count 2,042,580 89.67 25.11
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 151,714 6.66 1.86
free buffer requested 166,727 7.32 2.05
gc CPU used by this session 18,470 0.81 0.23
gc blocks lost 0 0.00 0.00
gc cr block build time 114 0.01 0.00
gc cr block flush time 397 0.02 0.00
gc cr block receive time 1,417 0.06 0.02
gc cr block send time 120 0.01 0.00
gc cr blocks received 20,563 0.90 0.25
gc cr blocks served 28,731 1.26 0.35
gc current block flush time 568 0.02 0.01
gc current block pin time 1,794 0.08 0.02
gc current block receive time 2,393 0.11 0.03
gc current block send time 749 0.03 0.01
gc current blocks received 30,824 1.35 0.38
gc current blocks served 56,313 2.47 0.69
gc local grants 11,089 0.49 0.14
gc remote grants 103,481 4.54 1.27
gcs messages sent 445,619 19.56 5.48
ges messages sent 167,268 7.34 2.06
global enqueue get time 17,563,633 771.07 215.89
global enqueue gets async 53,466 2.35 0.66
global enqueue gets sync 477,278 20.95 5.87
global enqueue releases 412,737 18.12 5.07
heap block compress 206 0.01 0.00
hot buffers moved to head of LRU 16,138 0.71 0.20
immediate (CR) block cleanout applications 673 0.03 0.01
immediate (CURRENT) block cleanout applications 3,063 0.13 0.04
index crx upgrade (found) 70 0.00 0.00
index crx upgrade (positioned) 20,812 0.91 0.26
index fast full scans (full) 121 0.01 0.00
index fetch by key 48,890,581 2,146.38 600.95
index scans kdiixs1 3,851,944 169.11 47.35
leaf node 90-10 splits 466 0.02 0.01
leaf node splits 796 0.03 0.01
lob reads 16,472 0.72 0.20
lob writes 27,164 1.19 0.33
lob writes unaligned 27,159 1.19 0.33
logons cumulative 208,714 9.16 2.57
messages received 280,228 12.30 3.44
messages sent 280,228 12.30 3.44
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 114,523,584 5,027.77 1,407.70
opened cursors cumulative 2,197,174 96.46 27.01
parse count (failures) 6,925 0.30 0.09
parse count (hard) 13,287 0.58 0.16
parse count (total) 2,192,804 96.27 26.95
parse time cpu 40,234 1.77 0.49
parse time elapsed 56,400 2.48 0.69
physical read IO requests 75,923 3.33 0.93
physical read bytes 1,475,960,832 64,797.06 18,142.23
physical read total IO requests 406,435 17.84 5.00
physical read total bytes 6,968,312,832 305,920.16 85,653.16
physical read total multi block requests 13,348 0.59 0.16
physical reads 180,171 7.91 2.21
physical reads cache 99,996 4.39 1.23
physical reads cache prefetch 91,531 4.02 1.13
physical reads direct 80,175 3.52 0.99
physical reads direct (lob) 79,757 3.50 0.98
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 53,173 2.33 0.65
physical write bytes 577,363,968 25,347.21 7,096.85
physical write total IO requests 216,366 9.50 2.66
physical write total bytes 1,602,214,912 70,339.82 19,694.12
physical write total multi block requests 145,232 6.38 1.79
physical writes 70,479 3.09 0.87
physical writes direct 1,585 0.07 0.02
physical writes direct (lob) 61 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 68,894 3.02 0.85
physical writes non checkpoint 21,711 0.95 0.27
pinned buffers inspected 21 0.00 0.00
pinned cursors current 8 0.00 0.00
prefetch clients - default 1 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 58 0.00 0.00
process last non-idle time 22,780 1.00 0.28
queries parallelized 466 0.02 0.01
recursive calls 9,608,339 421.82 118.10
recursive cpu usage 108,738 4.77 1.34
redo blocks written 410,816 18.04 5.05
redo buffer allocation retries 18 0.00 0.00
redo entries 377,387 16.57 4.64
redo log space requests 20 0.00 0.00
redo log space wait time 47 0.00 0.00
redo ordering marks 4,916 0.22 0.06
redo size 185,211,944 8,131.10 2,276.59
redo subscn max counts 7,299 0.32 0.09
redo synch time 11,240 0.49 0.14
redo synch writes 63,704 2.80 0.78
redo wastage 18,449,612 809.97 226.78
redo write broadcast ack time 2,279 0.10 0.03
redo write time 5,648 0.25 0.07
redo writer latching time 355 0.02 0.00
redo writes 72,324 3.18 0.89
rollback changes - undo records applied 158 0.01 0.00
rollbacks only - consistent read gets 623 0.03 0.01
root node splits 0 0.00 0.00
rows fetched via callback 19,582,599 859.71 240.71
session connect time 0 0.00 0.00
session cursor cache hits 876,051 38.46 10.77
session logical reads 199,218,873 8,746.03 2,448.76
shared hash latch upgrades - no wait 88,181 3.87 1.08
shared hash latch upgrades - wait 143 0.01 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 1,239,854 54.43 15.24
sorts (rows) 31,921,416 1,401.40 392.37
sql area evicted 4,561 0.20 0.06
sql area purged 6,909 0.30 0.08
summed dirty queue length 4 0.00 0.00
switch current to new buffer 118 0.01 0.00
table fetch by rowid 54,212,198 2,380.00 666.37
table fetch continued row 65,346 2.87 0.80
table scan blocks gotten 93,237,162 4,093.26 1,146.05
table scan rows gotten 12,839,946,762 563,694.36 157,826.15
table scans (long tables) 4 0.00 0.00
table scans (short tables) 1,736,572 76.24 21.35
total number of times SMON posted 95 0.00 0.00
transaction lock background get time 3 0.00 0.00
transaction lock background gets 716 0.03 0.01
transaction lock foreground requests 716 0.03 0.01
transaction lock foreground wait time 68 0.00 0.00
transaction rollbacks 82 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 29,311,808 1,286.84 360.30
user I/O wait time 6,004 0.26 0.07
user calls 4,773,651 209.57 58.68
user commits 63,260 2.78 0.78
user rollbacks 18,095 0.79 0.22
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 358,774 15.75 4.41
write clones created in background 19 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.0E+12 1.0E+12
session cursor cache count 202,583,990 203,825,876
session uga memory 6.6E+14 6.7E+14
opened cursors current 598 604
workarea memory allocated 265 265
logons current 1,265 1,210
session uga memory max 1.7E+13 1.7E+13
session pga memory 6.0E+11 6.1E+11

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 5 0.79

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 63,873 3 0.00 1.21 5 0 0 0.00
UNDOTBS2 35 0 9.71 1.00 35,625 2 13 0.77
WCITY2_DATA 8,676 0 2.73 11.12 11,681 1 448 55.74
SYSAUX 1,634 0 1.49 1.00 1,999 0 0 0.00
WCITY2_INDEX 1,346 0 1.22 3.12 1,527 0 994 73.00
WCITY_GNMS 64 0 5.47 1.00 1,477 0 5 0.00
SYSTEM 18 0 1.11 1.00 605 0 685 6.41
WCITY 180 0 0.00 1.00 105 0 0 0.00
TS_APP_DATA 10 0 0.00 1.00 73 0 0 0.00
TBS_ITS 10 0 0.00 1.00 10 0 0 0.00
TS_APP_INDEX 10 0 0.00 1.00 5 0 0 0.00
WCITY_BC 10 0 0.00 1.00 5 0 0 0.00
HQDB_DATA 5 0 0.00 1.00 5 0 0 0.00
INMS01 5 0 0.00 1.00 5 0 0 0.00
ISS 5 0 0.00 1.00 5 0 0 0.00
NETM_DATA 5 0 0.00 1.00 5 0 0 0.00
OMAE_DATA 5 0 0.00 1.00 5 0 0 0.00
OMP01 5 0 0.00 1.00 5 0 0 0.00
OMS01 5 0 0.00 1.00 5 0 0 0.00
REPORT_DATA 5 0 0.00 1.00 5 0 0 0.00
SSB_DATA_JWF 5 0 0.00 1.00 5 0 0 0.00
UNDOTBS1 5 0 0.00 1.00 5 0 3 0.00
ZXDBM_DATA 5 0 0.00 1.00 5 0 0 0.00
ZXINJOS_DATA 5 0 0.00 1.00 5 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 5 0 0.00 1.00 5 0 0 0.00
INMS01 +DATA/acsdb/datafile/inms01.279.762122141 5 0 0.00 1.00 5 0 0 0.00
ISS +DATA/acsdb/datafile/iss01.bdf 5 0 0.00 1.00 5 0 0 0.00
NETM_DATA +DATA/acsdb/datafile/netm_data.295.762368247 5 0 0.00 1.00 5 0 0 0.00
OMAE_DATA +DATA/acsdb/datafile/omae_data.297.762368277 5 0 0.00 1.00 5 0 0 0.00
OMP01 +DATA/acsdb/datafile/omp01.280.762122149 5 0 0.00 1.00 5 0 0 0.00
OMS01 +DATA/acsdb/datafile/oms01.281.762122175 5 0 0.00 1.00 5 0 0 0.00
REPORT_DATA +DATA/acsdb/datafile/report_data.291.762359943 5 0 0.00 1.00 5 0 0 0.00
SSB_DATA_JWF +DATA/acsdb/datafile/ssb_data_jwf.292.762359949 5 0 0.00 1.00 5 0 0 0.00
SYSAUX +DATA/acsdb/datafile/sysaux.257.762113905 1,634 0 1.49 1.00 1,999 0 0 0.00
SYSTEM +DATA/acsdb/datafile/system.1634.787070407 10 0 0.00 1.00 85 0 0 0.00
SYSTEM +DATA/acsdb/datafile/system.256.762113905 8 0 2.50 1.00 520 0 685 6.41
TBS_ITS +DATA/acsdb/datafile/tbs_its.305.762449727 5 0 0.00 1.00 5 0 0 0.00
TBS_ITS +DATA/acsdb/datafile/tbs_its01.dbf 5 0 0.00 1.00 5 0 0 0.00
TS_APP_DATA +DATA/acsdb/datafile/ts_app_data01.dbf 10 0 0.00 1.00 73 0 0 0.00
TS_APP_INDEX +DATA/acsdb/datafile/ts_app_index01.dbf 10 0 0.00 1.00 5 0 0 0.00
UNDOTBS1 +DATA/acsdb/datafile/undotbs1.258.762113905 5 0 0.00 1.00 5 0 3 0.00
UNDOTBS2 +DATA/acsdb/datafile/undotbs2.269.762113985 35 0 9.71 1.00 35,625 2 13 0.77
USERS +DATA/acsdb/datafile/users.259.762113905 63,873 3 0.00 1.21 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.1031.787073439 5 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.1146.787070545 10 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.1297.787074783 5 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.2249.787070711 10 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.287.762346721 5 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.2995.787070437 10 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.3189.787070649 10 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.3202.787070683 10 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.3261.787070351 5 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.370.787070423 10 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.4594.787070635 10 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.4822.787075205 5 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.5264.787070521 10 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.5495.787070583 10 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.5810.787070597 10 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.6430.787070489 10 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity1.dbf 10 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity2.dbf 10 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity3.dbf 10 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity4.dbf 10 0 0.00 1.00 5 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity5.dbf 5 0 0.00 1.00 5 0 0 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data01.dbf 279 0 0.82 2.41 246 0 4 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data02.dbf 206 0 0.97 2.33 207 0 5 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data03.dbf 235 0 0.89 2.11 346 0 11 0.91
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data04.dbf 5,391 0 3.41 14.60 53 0 0 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data05.dbf 1,722 0 2.26 8.79 2,508 0 381 65.46
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data06.dbf 377 0 0.77 1.10 835 0 3 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data07.dbf 144 0 1.39 1.49 2,621 0 21 0.95
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data08.dbf 218 0 0.73 1.12 4,088 0 18 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data09.dbf 104 0 0.77 1.03 777 0 5 0.00
WCITY2_INDEX +DATA/acsdb/datafile/wcity2_index01.dbf 712 0 1.22 2.94 632 0 151 27.95
WCITY2_INDEX +DATA/acsdb/datafile/wcity2_index02.dbf 634 0 1.21 3.31 895 0 843 81.07
WCITY_BC +DATA/acsdb/datafile/wcity_bc01.dbf 10 0 0.00 1.00 5 0 0 0.00
WCITY_GNMS +DATA/acsdb/datafile/wcity_gnms01.dbf 26 0 4.62 1.00 660 0 5 0.00
WCITY_GNMS +DATA/acsdb/datafile/wcity_gnms02.dbf 38 0 6.05 1.00 817 0 0 0.00
ZXDBM_DATA +DATA/acsdb/datafile/zxdbm_data.290.762359941 5 0 0.00 1.00 5 0 0 0.00
ZXINJOS_DATA +DATA/acsdb/datafile/zxinjos_data.289.762359941 5 0 0.00 1.00 5 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,515,778 100 199,135,146 99,996 68,894 0 0 2,148


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 0 626 8459 20522 184320 20522  
E 0 3 1852 12153 70282 184320 70282  

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 33.51 874,265,986
D 5,856 0.20 701,622 1.45 37,733,045
D 8,784 0.30 1,052,433 1.13 29,449,144
D 11,712 0.40 1,403,244 1.08 28,110,997
D 14,640 0.50 1,754,055 1.03 26,875,663
D 17,568 0.60 2,104,866 1.02 26,713,377
D 20,496 0.70 2,455,677 1.02 26,632,731
D 23,424 0.80 2,806,488 1.01 26,481,388
D 26,352 0.90 3,157,299 1.01 26,409,826
D 29,280 1.00 3,508,110 1.00 26,103,604
D 29,344 1.00 3,515,778 1.00 26,093,569
D 32,208 1.10 3,858,921 0.98 25,497,183
D 35,136 1.20 4,209,732 0.97 25,430,032
D 38,064 1.30 4,560,543 0.97 25,238,117
D 40,992 1.40 4,911,354 0.96 25,165,906
D 43,920 1.50 5,262,165 0.96 24,920,131
D 46,848 1.60 5,612,976 0.94 24,615,833
D 49,776 1.70 5,963,787 0.93 24,307,092
D 52,704 1.80 6,314,598 0.84 21,855,531
D 55,632 1.90 6,665,409 0.82 21,390,851
D 58,560 2.00 7,016,220 0.81 21,078,671

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 35,328 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,648 869.85 0.00 0.00 0.00 0.00 823,700
E 8,044 6,636 884.94 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 326,556 326,556 0 0
64K 128K 1,352 1,352 0 0
128K 256K 1,506 1,506 0 0
256K 512K 1,998 1,998 0 0
512K 1024K 6,196 6,196 0 0
1M 2M 21,066 21,066 0 0
2M 4M 26 26 0 0
4M 8M 82 82 0 0
8M 16M 16 16 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 2,301,297.68 2,377.98 100.00 0
2,011 0.25 2,301,297.68 2,108.66 100.00 0
4,022 0.50 2,301,297.68 1,025.99 100.00 0
6,033 0.75 2,301,297.68 1,025.99 100.00 0
8,044 1.00 2,301,297.68 1,025.99 100.00 0
9,653 1.20 2,301,297.68 0.00 100.00 0
11,262 1.40 2,301,297.68 0.00 100.00 0
12,870 1.60 2,301,297.68 0.00 100.00 0
14,479 1.80 2,301,297.68 0.00 100.00 0
16,088 2.00 2,301,297.68 0.00 100.00 0
24,132 3.00 2,301,297.68 0.00 100.00 0
32,176 4.00 2,301,297.68 0.00 100.00 0
48,264 6.00 2,301,297.68 0.00 100.00 0
64,352 8.00 2,301,297.68 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 378 27,418 14,021,193 1.00 68,952 1.07 610,500
2,352 0.70 700 46,291 14,024,460 1.00 65,685 1.02 610,822
2,688 0.80 1,034 65,080 14,025,331 1.00 64,814 1.01 610,945
3,024 0.90 1,369 83,115 14,025,698 1.00 64,447 1.00 611,009
3,360 1.00 1,703 99,852 14,025,910 1.00 64,235 1.00 611,052
3,696 1.10 2,038 118,886 14,026,057 1.00 64,088 1.00 611,085
4,032 1.20 2,373 136,856 14,026,183 1.00 63,962 1.00 611,113
4,368 1.30 2,708 153,940 14,026,281 1.00 63,864 0.99 611,138
4,704 1.40 3,043 170,560 14,026,369 1.00 63,776 0.99 611,160
5,040 1.50 3,378 187,663 14,026,445 1.00 63,700 0.99 611,179
5,376 1.60 3,713 202,248 14,026,509 1.00 63,636 0.99 611,195
5,712 1.70 4,048 220,092 14,026,568 1.00 63,577 0.99 611,211
6,048 1.80 4,383 238,782 14,026,618 1.00 63,527 0.99 611,224
6,384 1.90 4,718 258,081 14,026,663 1.00 63,482 0.99 611,236
6,720 2.00 5,053 276,617 14,026,700 1.00 63,445 0.99 611,246

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 3,628,607 37,733,907
16,384 0.50 3,605,197 26,876,374
24,576 0.75 3,602,675 26,714,594
32,768 1.00 3,601,594 26,093,567
40,960 1.25 3,599,794 25,430,790
49,152 1.50 3,598,714 24,616,671
57,344 1.75 3,598,354 21,855,972
65,536 2.00 3,598,354 21,078,383

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

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

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 1,875 99 53
1st level bmb 51 3 53
system undo header 177 0 1
system undo block 20 0 1
undo header 16 0 1
segment header 6 0 2
2nd level bmb 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)
TM-DML 89,690 89,690 0 1,393 464,703 333,598.51
WF-AWR Flush 244 120 124 186 7,350 39,515.91
US-Undo Segment 55,061 55,063 0 54,739 2,796 51.07
SQ-Sequence Cache 12,475 12,475 0 237 16 65.74
TX-Transaction 80,288 80,288 0 866 3 3.26
PR-Process Startup 653 653 0 5 2 466.00
TX-Transaction (index contention) 153 151 0 121 2 16.86
HW-Segment High Water Mark 14,014 14,014 0 65 1 19.69
CF-Controlfile Transaction 53,063 53,063 0 422 1 2.20
PS-PX Process Reservation 3,473 3,431 42 1,231 1 0.60
FB-Format Block 538 538 0 287 0 0.77
TA-Instance Undo 76 76 0 75 0 0.67
JQ-Job Queue 444 443 1 44 0 1.14
TX-Transaction (allocate ITL entry) 40 40 0 40 0 0.75
JS-Job Scheduler (job run lock - synchronize) 12 12 0 12 0 0.83
RO-Multiple Object Reuse (fast object reuse) 36 36 0 12 0 0.83
DR-Distributed Recovery 13 13 0 13 0 0.00
MW-MWIN Schedule 13 13 0 13 0 0.00
TT-Tablespace 2,251 2,251 0 3 0 0.00
AF-Advisor Framework (task serialization) 35 35 0 2 0 0.00
PI-Remote PX Process Spawn Status 10 10 0 2 0 0.00
WL-Being Written Redo Log 5 5 0 2 0 0.00
IR-Instance Recovery 60 60 0 1 0 0.00
SW-Suspend Writes 12 12 0 1 0 0.00
TX-Transaction (row lock contention) 1 1 0 1 0 0.00
UL-User-defined 6 6 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 4.79 77,608 1,474 18 75/197.9 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
25-2ÔÂ 16:59 272 5,721 0 3 75 0/0 0/0/0/0/0/0
25-2ÔÂ 16:49 300 6,594 0 14 75 0/0 0/0/0/0/0/0
25-2ÔÂ 16:39 239 5,388 0 2 75 0/0 0/0/0/0/0/0
25-2ÔÂ 16:29 271 6,353 933 3 75 0/0 0/0/0/0/0/0
25-2ÔÂ 16:19 161 3,894 930 18 75 0/0 0/0/0/0/0/0
25-2ÔÂ 16:09 90 1,872 326 2 75 0/0 0/0/0/0/0/0
25-2ÔÂ 15:59 114 2,566 326 3 75 0/0 0/0/0/0/0/0
25-2ÔÂ 15:49 75 1,581 1,266 2 75 0/0 0/0/0/0/0/0
25-2ÔÂ 15:39 46 1,412 664 2 75 0/0 0/0/0/0/0/0
25-2ÔÂ 15:29 83 1,408 319 3 75 0/0 0/0/0/0/0/0
25-2ÔÂ 15:19 56 1,336 918 2 75 0/0 0/0/0/0/0/0
25-2ÔÂ 15:09 95 2,158 915 4 75 0/0 0/0/0/0/0/0
25-2ÔÂ 14:59 110 1,111 0 3 75 0/0 0/0/0/0/0/0
25-2ÔÂ 14:49 39 925 0 3 75 0/0 0/0/0/0/0/0
25-2ÔÂ 14:39 149 2,005 910 4 75 0/0 0/0/0/0/0/0
25-2ÔÂ 14:29 158 3,076 1,057 6 75 0/0 0/0/0/0/0/0
25-2ÔÂ 14:19 234 5,609 455 8 75 0/0 0/0/0/0/0/0
25-2ÔÂ 14:09 339 6,501 0 6 75 0/0 0/0/0/0/0/0
25-2ÔÂ 13:59 170 735 898 3 198 0/0 0/0/0/0/0/0
25-2ÔÂ 13:49 35 781 555 3 188 0/0 0/0/0/0/0/0
25-2ÔÂ 13:39 12 516 835 3 178 0/0 0/0/0/0/0/0
25-2ÔÂ 13:29 18 649 0 4 168 0/0 0/0/0/0/0/0
25-2ÔÂ 13:19 39 1,451 892 4 158 0/0 0/0/0/0/0/0
25-2ÔÂ 13:09 70 1,849 886 4 148 0/0 0/0/0/0/0/0
25-2ÔÂ 12:59 81 707 285 5 138 0/0 0/0/0/0/0/0
25-2ÔÂ 12:49 31 677 0 4 128 0/0 0/0/0/0/0/0
25-2ÔÂ 12:39 8 585 0 3 118 0/0 0/0/0/0/0/0
25-2ÔÂ 12:29 15 612 0 3 108 0/0 0/0/0/0/0/0
25-2ÔÂ 12:19 12 602 0 3 97 0/0 0/0/0/0/0/0
25-2ÔÂ 12:09 99 912 1,474 3 87 0/0 0/0/0/0/0/0
25-2ÔÂ 11:59 23 750 870 2 77 0/0 0/0/0/0/0/0
25-2ÔÂ 11:49 17 914 0 3 75 0/0 0/0/0/0/0/0
25-2ÔÂ 11:39 549 1,238 77 4 75 0/0 0/0/0/0/0/0
25-2ÔÂ 11:29 210 524 864 2 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 430 0.00   0 0  
ASM db client latch 15,873 0.00   0 0  
ASM map headers 902 0.00   0 0  
ASM map load waiting list 300 0.00   0 0  
ASM map operation freelist 7,160 0.00   0 0  
ASM map operation hash table 2,027,564 0.00 0.02 0 0  
ASM network background latch 10,226 0.00   0 0  
AWR Alerted Metric Element list 345,157 0.00   0 0  
Consistent RBA 72,333 0.00   0 0  
FAL request queue 465 0.00   0 0  
FAL subheap alocation 465 0.00   0 0  
FIB s.o chain latch 98 0.00   0 0  
FOB s.o list latch 102,987 0.01 0.00 0 0  
JS broadcast add buf latch 5,205 0.00   0 0  
JS broadcast drop buf latch 5,205 0.00   0 0  
JS broadcast load blnc latch 4,543 0.00   0 0  
JS mem alloc latch 35 0.00   0 0  
JS queue access latch 35 0.00   0 0  
JS queue state obj latch 164,218 0.00   0 0  
JS slv state obj latch 10,469 0.00   0 0  
KCL gc element parent latch 831,541 0.10 0.08 0 955 0.00
KFK SGA context latch 13,756 0.00   0 0  
KFMD SGA 5,732 0.02 1.00 0 0  
KJC message pool free list 152,408 0.23 0.00 0 8,368 0.04
KJCT flow control latch 891,517 0.01 0.00 0 0  
KMG MMAN ready and startup request latch 7,590 0.00   0 0  
KSXR large replies 3 0.00   0 0  
KTF sga latch 27,731 0.00   0 6,391 0.00
KWQMN job cache list latch 1,830 0.00   0 0  
KWQP Prop Status 10 0.00   0 0  
MQL Tracking Latch 0     0 454 0.00
Memory Management Latch 0     0 7,590 0.00
OS process 626,502 0.00   0 0  
OS process allocation 425,253 0.08 0.04 3 0  
OS process: request allocation 415,052 0.13 0.21 38 0  
PL/SQL warning settings 210,728 0.00   0 0  
SGA IO buffer pool latch 648 0.00   0 648 0.00
SQL memory manager latch 5 0.00   0 7,577 0.00
SQL memory manager workarea list latch 720,880 0.00 0.00 0 0  
Shared B-Tree 817 0.00   0 0  
active checkpoint queue latch 85,004 0.00 0.00 0 0  
active service list 1,023,358 0.36 0.09 0 26,106 0.10
alert log latch 10 0.00   0 0  
archive control 773 0.00   0 0  
archive process latch 8,517 0.00   0 0  
begin backup scn array 106 0.00   0 0  
business card 932 0.00   0 0  
cache buffer handles 12,808 0.00   0 0  
cache buffers chains 320,499,801 0.09 0.03 162 767,305 0.01
cache buffers lru chain 264,337 0.00 0.00 0 380,053 0.01
cache table scan latch 0     0 6,287 0.00
channel handle pool latch 415,158 0.02 0.08 0 0  
channel operations parent latch 3,751,327 0.01 0.03 0 0  
checkpoint queue latch 3,113,914 0.00 0.57 2 89,463 0.00
client/application info 968,803 0.00 0.00 0 0  
commit callback allocation 492 0.00   0 0  
compile environment latch 208,717 0.00   0 0  
dictionary lookup 4 0.00   0 0  
dml lock allocation 180,822 0.02 0.00 0 0  
dummy allocation 417,435 0.08 0.08 0 0  
enqueue hash chains 1,871,315 0.32 0.02 0 481,035 0.01
enqueues 2,161,584 0.31 0.00 0 0  
error message lists 2,254 0.00   0 0  
event group latch 207,524 0.00 1.13 4 0  
file cache latch 7,588 0.00   0 0  
gcs opaque info freelist 58,336 0.00 0.00 0 0  
gcs partitioned table hash 5,652,638 0.00 0.00 0 4,688 0.00
gcs remastering latch 1,813,249 0.00 0.02 0 0  
gcs resource freelist 106,502 0.00   0 53,189 0.00
gcs resource hash 1,525,771 0.02 0.28 0 52 0.00
gcs resource scan list 104 0.00   0 0  
gcs shadows freelist 106,457 0.00   0 64,702 0.00
ges caches resource lists 108,468 0.03 0.00 0 286,874 0.01
ges deadlock list 1,636 0.00   0 18,319 0.00
ges domain table 458,107 0.00 0.00 0 0  
ges enqueue table freelist 931,067 0.01 0.02 0 0  
ges group table 600,899 0.03 0.00 0 0  
ges process hash list 879,535 0.00   0 0  
ges process parent latch 2,050,521 0.00 0.00 0 6 0.00
ges process table freelist 415,052 0.03 0.05 0 0  
ges resource hash list 1,699,527 1.17 0.11 150 122,393 0.71
ges resource scan list 127,252 0.73 0.00 0 0  
ges resource table freelist 44,846 0.02 0.00 0 0  
ges synchronous data 32 0.00   0 91,961 0.00
ges timeout list 18,610 0.03 0.00 0 28,988 0.00
global KZLD latch for mem in SGA 241,205 0.00   0 0  
global tx hash mapping 309 0.00   0 0  
hash table column usage latch 1,287 0.00   0 461,915 0.00
hash table modification latch 430 0.00   0 0  
interrupt manipulation 5,515 0.00   0 0  
job workq parent latch 0     0 917 0.22
job_queue_processes parameter latch 787 0.00   0 0  
kks stats 28,151 0.00   0 0  
kmcptab latch 2 0.00   0 0  
kmcpvec latch 0     0 2 0.00
kokc descriptor allocation latch 27,886 0.00   0 0  
ksuosstats global area 1,528 0.13 1.00 0 0  
ksv instance 18 0.00   0 0  
ktm global data 117 0.00   0 0  
kwqbsn:qsga 812 0.00   0 0  
lgwr LWN SCN 72,882 0.00   0 0  
library cache 9,395,720 0.19 0.04 132 17,278 0.02
library cache load lock 1,722 0.00   0 0  
library cache lock 15,101,522 0.27 0.01 112 0  
library cache lock allocation 502,075 0.01 0.04 0 0  
library cache pin 2,505,361 0.05 0.01 0 0  
library cache pin allocation 1,442 0.00   0 0  
list of block allocation 104,007 0.04 0.20 5 0  
loader state object freelist 32,604 0.01 0.00 0 0  
logminer context allocation 5 0.00   0 0  
longop free list parent 33 0.00   0 1 0.00
message pool operations parent latch 8,121 0.00   0 0  
messages 1,800,395 0.18 0.00 0 0  
mostly latch-free SCN 73,583 0.21 0.00 0 0  
msg queue 158 0.00   0 158 0.00
multiblock read objects 22,558 0.00   0 0  
name-service memory objects 103,450 0.00   0 0  
name-service namespace bucket 249,139 0.00   0 0  
name-service pending queue 47,654 0.00   0 0  
name-service request 48 0.00   0 0  
name-service request queue 289,467 0.00   0 0  
ncodef allocation latch 1,038 0.00   0 0  
object queue header heap 342,204 0.00   0 2,173 0.00
object queue header operation 916,010 0.00 0.45 2 0  
object stats modification 11 0.00   0 0  
parallel query alloc buffer 14,208 0.00   0 0  
parallel query stats 2,132 0.00   0 0  
parallel txn reco latch 48,420 0.00   0 0  
parameter list 1,652,349 0.04 0.03 11 0  
parameter table management 418,123 0.00 1.00 0 0  
post/wait queue 162,320 0.05 0.00 0 67,873 0.00
process allocation 608,407 3.15 1.48 308 206,592 0.45
process group creation 415,052 0.03 0.03 0 0  
process queue 5,756 0.00   0 0  
process queue reference 131,515 0.00 0.00 0 14,125 0.00
qmn state object latch 2 0.00   0 0  
qmn task queue latch 3,328 0.00   0 0  
query server freelists 4,670 0.00   0 0  
query server process 8 0.00   0 8 0.00
queued dump request 112,265 0.00   0 0  
redo allocation 218,478 0.04 0.01 1 377,288 0.07
redo copy 0     0 377,411 0.35
redo writing 318,130 0.00 0.00 0 0  
resmgr group change latch 174,818 0.00   0 0  
resmgr:active threads 417,101 0.00   0 0  
resmgr:actses change group 173,100 0.00   0 0  
resmgr:free threads list 417,096 0.21 0.08 25 0  
resmgr:resource group CPU method 173,100 0.01 0.28 0 0  
resmgr:schema config 5 0.00   0 0  
row cache objects 16,634,631 2.47 0.06 319 2,478 11.22
rules engine aggregate statistics 44 0.00   0 0  
rules engine rule set statistics 588 0.00   0 0  
segmented array pool 98 0.00   0 0  
sequence cache 1,638,538 0.12 0.01 1 0  
session allocation 3,271,713 1.05 0.08 32 0  
session idle bit 10,763,814 0.00 0.01 0 0  
session state list latch 417,553 0.04 0.02 0 0  
session switching 1,038,677 0.03 0.01 0 0  
session timer 21,791 0.00   0 0  
shared pool 5,740,224 0.35 0.05 223 0  
shared pool sim alloc 11 0.00   0 0  
shared pool simulator 43,438 0.00 0.00 0 0  
simulator hash latch 10,649,491 0.00 0.00 0 0  
simulator lru latch 0     0 10,635,093 0.12
slave class 713 0.00   0 0  
slave class create 4,998 0.18 1.00 1 0  
sort extent pool 1,381 0.00   0 0  
state object free list 10 0.00   0 0  
statistics aggregation 2,800 0.00   0 0  
temp lob duration state obj allocation 6 0.00   0 0  
threshold alerts latch 4,142 0.00   0 0  
transaction allocation 6,918,095 0.00 0.00 0 0  
transaction branch allocation 22,030 0.00   0 0  
undo global data 576,474 0.04 0.00 0 0  
user lock 686,305 0.96 0.03 22 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
row cache objects 16,634,631 411,523 25,937 386,363 0 0 0
cache buffers chains 320,499,801 301,880 7,593 294,705 0 0 0
library cache lock 15,101,522 40,197 547 39,734 0 0 0
session allocation 3,271,713 34,453 2,625 31,983 0 0 0
shared pool 5,740,224 19,975 980 19,090 0 0 0
ges resource hash list 1,699,527 19,896 2,268 17,827 0 0 0
process allocation 608,407 19,139 28,322 1,575 0 0 0
library cache 9,395,720 17,916 664 17,320 0 0 0
enqueues 2,161,584 6,743 18 6,727 0 0 0
user lock 686,305 6,562 179 6,401 0 0 0
enqueue hash chains 1,871,315 5,965 144 5,828 0 0 0
active service list 1,023,358 3,637 323 3,336 0 0 0
messages 1,800,395 3,251 10 3,242 0 0 0
sequence cache 1,638,538 2,037 15 2,024 0 0 0
library cache pin 2,505,361 1,292 9 1,283 0 0 0
ges resource scan list 127,252 924 2 922 0 0 0
resmgr:free threads list 417,096 871 71 808 0 0 0
KCL gc element parent latch 831,541 866 70 804 0 0 0
parameter list 1,652,349 671 19 654 0 0 0
OS process: request allocation 415,052 542 114 442 0 0 0
channel operations parent latch 3,751,327 513 14 499 0 0 0
OS process allocation 425,253 355 15 340 0 0 0
gcs resource hash 1,525,771 337 96 298 0 0 0
session switching 1,038,677 335 2 333 0 0 0
dummy allocation 417,435 332 26 308 0 0 0
undo global data 576,474 214 1 213 0 0 0
session idle bit 10,763,814 211 2 209 0 0 0
session state list latch 417,553 167 3 164 0 0 0
ges enqueue table freelist 931,067 113 2 111 0 0 0
process group creation 415,052 109 3 107 0 0 0
ges process table freelist 415,052 104 5 100 0 0 0
channel handle pool latch 415,158 100 8 93 0 0 0
redo allocation 218,478 79 1 78 0 0 0
gcs remastering latch 1,813,249 59 1 58 0 0 0
ASM map operation hash table 2,027,564 51 1 50 0 0 0
list of block allocation 104,007 40 8 33 0 0 0
object queue header operation 916,010 31 14 17 0 0 0
library cache lock allocation 502,075 27 1 26 0 0 0
resmgr:resource group CPU method 173,100 18 5 14 0 0 0
slave class create 4,998 9 9 0 0 0 0
event group latch 207,524 8 9 0 0 0 0
checkpoint queue latch 3,113,914 7 4 3 0 0 0
ksuosstats global area 1,528 2 2 0 0 0 0
KFMD SGA 5,732 1 1 0 0 0 0
parameter table management 418,123 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
ASM map operation hash table kffmTranslate 0 1 0
KCL gc element parent latch kclnfndnewm 0 43 1
KCL gc element parent latch kclchkping 0 41 0
KCL gc element parent latch kclplz 0 3 17
KCL gc element parent latch KCLUNLNK 0 2 3
KCL gc element parent latch kclbla 0 1 0
KCL gc element parent latch kclzcl 0 1 12
KFMD SGA kfmdSlvJoinFetch 0 1 0
OS process allocation kso_new_process:2 0 7 7
OS process allocation kso_delete_process:1 0 6 6
OS process allocation ksosp_scrub:1 0 2 2
OS process: request allocation kso_new_process 0 83 72
OS process: request allocation ksoreqholder_delete 0 31 42
active service list kswslogon: session logout 0 1,542 1,430
active service list kswslogon: session login 0 158 98
active service list kswsgsnp: get service name ptr 0 15 186
active service list kswssyis: find service entry 1 0 10 4
cache buffers chains kcbgtcr: kslbegin excl 0 21,571 9,432
cache buffers chains kcbrls: kslbegin 0 1,171 14,082
cache buffers chains kcbgcur: kslbegin 0 737 407
cache buffers chains kcbgtcr: fast path 0 624 66
cache buffers chains kcbzwb 0 261 219
cache buffers chains kcbget: pin buffer 0 127 98
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 78 84
cache buffers chains kcbchg: kslbegin: call CR func 0 50 64
cache buffers chains kcbsod1 0 32 68
cache buffers chains kcbso1: set no access 0 28 10
cache buffers chains kcbgtcr 0 26 27
cache buffers chains kclbla 0 24 3
cache buffers chains kcbgcur: buf pinned 0 19 18
cache buffers chains kcbesc: escalate 0 7 9
cache buffers chains kcbzgb: scan from tail. nowait 0 6 0
cache buffers chains kcbnlc 0 5 39
cache buffers chains kcbget: exchange 0 1 25
cache buffers chains kcbzib: finish free bufs 0 1 11
cache buffers chains kclebs_1 0 1 1
cache buffers chains kclpto 0 1 0
cache buffers chains kclwcrs 0 1 7
channel handle pool latch ksrchconnect() 0 9 2
channel handle pool latch ksrchdelete() 0 4 11
channel operations parent latch ksrchdelete() 0 40 37
channel operations parent latch ksrsubscribe() 0 1 2
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 2 0
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 1 2
checkpoint queue latch kcbkllrba: compute lowest lrba 0 1 2
cost function kzulrl 0 103 116
cost function kzulgt: find user res 0 76 63
dummy allocation ktcscnfy 0 16 13
dummy allocation ktcdod 0 10 13
enqueue hash chains ksqgtl3 0 137 138
enqueue hash chains ksqrcl 0 5 2
enqueue hash chains ksqcmi: if lk mode requested 0 2 3
enqueues ksqgel: create enqueue 0 10 1
enqueues ksqdel 0 5 6
enqueues ksqies 0 3 11
event group latch ksdegi 0 9 9
event range base latch No latch 0 99 38
gcs remastering latch 69 0 1 0
gcs resource hash kjbopen 0 77 29
gcs resource hash kjbcropen:affinity 0 12 0
gcs resource hash kjblocalfile_nolock 0 2 0
gcs resource hash kjbmpcreatepi 0 2 0
gcs resource hash kclzcl 0 1 58
gcs resource hash kjbassume 0 1 0
gcs resource hash kjbopen:affinity 0 1 0
ges enqueue table freelist kjlalc: lock allocation 0 2 2
ges process table freelist kjpfr: free process 0 4 5
ges process table freelist kjpalc: process allocation 0 1 0
ges resource hash list kjrmas1: lookup master node 0 1,568 487
ges resource hash list kjrref: find matched resource 0 440 1,523
ges resource hash list kjcvscn: remove from scan queue 0 179 0
ges resource hash list kjakcai: search for resp by resname 0 30 24
ges resource hash list kjlrlr: remove lock from resource queue 0 27 210
ges resource hash list kjucvl: lock convert request 0 16 24
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 8 0
ges resource scan list kjcvscn: traverse scan_q 0 2 1
ksuosstats global area ksugetosstat 0 2 2
library cache kglpndl: child: after processing 0 172 24
library cache kgldte: child 0 0 146 148
library cache kglLockCursor 0 102 15
library cache kglhdgn: child: 0 93 261
library cache kglobpn: child: 0 87 170
library cache kglpndl: child: before processing 0 49 43
library cache kgldti: 2child 0 6 0
library cache kglati 0 2 0
library cache lock kgllkdl: child: cleanup 0 356 318
library cache lock kgllkal: child: multiinstance 0 92 191
library cache lock kgllkdl: child: no lock handle 0 7 3
library cache lock allocation kgllkget 0 1 1
library cache pin kglpndl 0 6 5
library cache pin kglpnal: child: alloc space 0 3 4
list of block allocation ktlabl 0 8 8
messages ksaamb: after wakeup 0 6 7
messages ksarcv 0 3 2
messages ksaclr 0 1 0
object queue header operation kcbo_switch_cq 0 14 11
object queue header operation kcbw_link_q 0 2 1
object queue header operation kcbw_unlink_q 0 2 3
object queue header operation kcbo_switch_mq_bg 0 1 0
parameter list kmmsvcl 0 19 19
parameter table management kspcpy 0 1 0
process allocation ksucrp 0 11,762 0
process allocation ksuapc 0 10,700 11,417
process allocation ksudlp 0 5,032 12,481
process allocation ksufap: active procs 0 828 4,424
process group creation ksupgprem 0 3 3
redo allocation kcrfw_redo_gen: redo allocation 1 0 1 0
resmgr:free threads list kgskthrsod 0 41 31
resmgr:free threads list kgskthrcreate 0 30 40
resmgr:resource group CPU method kgkprrrem 0 5 5
row cache objects kqreqd: reget 0 8,113 1,251
row cache objects kqrigt 0 7,425 20,641
row cache objects kqrpre: find obj 0 6,808 1,760
row cache objects kqreqd 0 3,380 2,120
row cache objects kqrbgl 0 78 100
row cache objects kqrpre: init complete 0 43 4
row cache objects kqrbtm: pop parent 0 24 29
row cache objects kqrbip 0 21 0
row cache objects kqrso 0 13 0
row cache objects ksucallcbksafely: kqrhngc 0 13 0
row cache objects kqrbpr: got immediately 0 9 4
row cache objects kqrcmt: while loop 0 5 4
row cache objects kqrpup 0 4 0
row cache objects kqrbpr: KQRRSNRL 0 1 16
sequence cache kdnnxt: cached seq 0 10 0
sequence cache kdnssd 0 3 0
sequence cache kdnss 0 2 15
session allocation ksuxds: KSUSFCLC not set 0 1,947 605
session allocation ksucri 0 269 838
session allocation ksudlp 0 227 599
session allocation ksuxds: not user session 0 129 319
session allocation ksucrp 0 34 263
session allocation ksufap: active sessions 0 19 0
session idle bit ksupuc: clear busy 0 1 1
session idle bit ksupuc: set busy 0 1 1
session state list latch kpseqa 0 3 3
session switching kskexeall 0 2 2
shared pool kghalo 0 727 659
shared pool kghfre 0 207 282
shared pool kghupr1 0 38 32
shared pool kghalp 0 4 4
shared pool kghfrunp: alloc: cursor dur 0 3 0
shared pool kghfree_extents: scan 0 1 3
slave class create ksvcreate 0 8 0
slave class create ksvgetwork1 0 1 1
undo global data ktusmofu: KSLBEGIN 0 1 1

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 33,296,656 16.71
WCITY2 WCITY2_INDEX PK_TB_ARTICLE_DESC   INDEX 31,433,648 15.78
WCITY2 WCITY2_DATA TB_ARTICLE_DESC   TABLE 30,033,952 15.08
WCITY2 WCITY2_INDEX PK_TB_ARTICLE   INDEX 18,294,528 9.18
WCITY2 WCITY2_DATA TB_ARTICLE   TABLE 15,270,256 7.67

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
WCITY2 WCITY2_DATA TB_ACCOUNT_INTERFACE_LOG   TABLE 93,517 51.90
WCITY2 WCITY2_INDEX PK_TB_PORTAL_USER   INDEX 4,167 2.31
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY 263338_538 TABLE PARTITION 1,412 0.78
WCITY2 WCITY2_DATA TB_ACCESS_TOKEN   TABLE 553 0.31
SYS SYSAUX WRH$_SQL_PLAN   TABLE 76 0.04

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
WCITY2 WCITY2_INDEX PK_TB_AUTH_LOG2   INDEX 73 60.83
WCITY2 WCITY2_INDEX ACCOUNT_INTERFACE_LOG_ID   INDEX 41 34.17
WCITY2 WCITY2_INDEX INDEX_TB_A_C_R_COLUMN_ID   INDEX 2 1.67
WCITY2 WCITY2_INDEX PK_TB_ACCESS_TOKEN   INDEX 2 1.67
WCITY2 WCITY2_DATA TB_ARTICLE   TABLE 2 1.67

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
WCITY2 WCITY2_INDEX PK_TB_AUTH_LOG2   INDEX 21 52.50
WCITY2 WCITY2_INDEX ACCOUNT_INTERFACE_LOG_ID   INDEX 19 47.50

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
WCITY2 WCITY2_DATA TB_ACCOUNT_INTERFACE_LOG   TABLE 322 46.20
WCITY2 WCITY2_INDEX PK_TB_AUTH_LOG2   INDEX 146 20.95
WCITY2 WCITY2_INDEX ACCOUNT_INTERFACE_LOG_ID   INDEX 113 16.21
SYS SYSTEM SEG$   TABLE 34 4.88
WCITY2 WCITY2_DATA TB_AUTH_LOG   TABLE 17 2.44

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 PK_TB_AUTH_LOG2   INDEX 427 34.91
WCITY2 WCITY2_INDEX ACCOUNT_INTERFACE_LOG_ID   INDEX 302 24.69
SYS SYSTEM UNDO$   TABLE 196 16.03
SYS SYSTEM I_UNDO1   INDEX 159 13.00
WCITY2 WCITY2_DATA TB_ACCOUNT_INTERFACE_LOG   TABLE 60 4.91

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 3,656 17.78
WCITY2 WCITY2_DATA TB_ACCESS_TOKEN   TABLE 2,147 10.44
SYS SYSTEM JOB$   TABLE 1,987 9.66
WCITY2 WCITY2_INDEX PK_TB_PORTAL_USER   INDEX 1,914 9.31
SYS SYSTEM SEQ$   TABLE 1,618 7.87

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
WCITY2 WCITY2_INDEX ACCOUNT_INTERFACE_LOG_ID   INDEX 8,748 28.38
WCITY2 WCITY2_INDEX PK_TB_AUTH_LOG2   INDEX 8,177 26.53
WCITY2 WCITY2_DATA TB_ACCOUNT_INTERFACE_LOG   TABLE 1,997 6.48
SYS SYSTEM SEQ$   TABLE 1,994 6.47
WCITY2 WCITY2_DATA TB_ACCESS_TOKEN   TABLE 1,098 3.56

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 421 0.71 0   6 1
dc_database_links 413,307 0.00 0   0 4
dc_global_oids 20,006 0.05 0   0 123
dc_histogram_data 180,351 0.29 0   0 2,259
dc_histogram_defs 86,751 1.88 0   0 2,259
dc_object_grants 254 10.63 0   0 33
dc_object_ids 165,697 0.17 0   0 1,437
dc_objects 262,997 0.17 0   10 804
dc_profiles 171,746 0.00 0   0 1
dc_rollback_segments 562,662 0.46 0   921 688
dc_segments 69,299 0.79 0   661 3,635
dc_sequences 12,238 18.64 0   12,238 17
dc_tablespace_quotas 32 21.88 0   32 0
dc_tablespaces 180,283 0.00 0   0 25
dc_usernames 763,064 0.00 0   0 57
dc_users 3,496,814 0.00 0   0 74
outstanding_alerts 1,898 93.73 0   44 48

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 15 3 0
dc_global_oids 10 0 0
dc_histogram_defs 1,628 0 1,909
dc_object_ids 300 0 11
dc_objects 474 5 311
dc_rollback_segments 69,192 2,296 0
dc_segments 1,865 28 0
dc_sequences 24,466 2,277 0
dc_tablespace_quotas 64 8 0
dc_usernames 2 0 0
outstanding_alerts 3,724 1,761 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 3,315 0.15 5,378 0.13 2 0
CLUSTER 67 1.49 101 0.99 0 0
INDEX 44 40.91 119 15.97 1 0
JAVA DATA 3 100.00 3 100.00 0 0
JAVA RESOURCE 3 100.00 3 100.00 0 0
JAVA SOURCE 3 100.00 3 100.00 0 0
SQL AREA 1,322,284 0.84 3,539,484 0.92 7,662 9
TABLE/PROCEDURE 83,120 0.31 880,970 0.09 177 0
TRIGGER 381 1.57 627 0.96 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 101 1 0 1 0
INDEX 119 27 4 21 0
JAVA DATA 3 3 0 0 0
JAVA RESOURCE 3 3 0 0 0
JAVA SOURCE 3 3 0 0 0
TABLE/PROCEDURE 44,296 266 68 124 0
TRIGGER 3 6 1 3 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 824.40   0.65 1.14 13 13 1,270 1,270
  Freeable 41.06 0.00 0.95 0.81 5   43 43
  SQL 2.86 1.75 0.00 0.01 0 4 1,233 534
  PL/SQL 2.69 0.41 0.00 0.00 0 0 1,268 1,266
E Other 815.38   0.67 1.17 13 13 1,218 1,218
  Freeable 60.06 0.00 0.92 0.63 5   65 65
  PL/SQL 2.63 0.45 0.00 0.00 0 0 1,216 1,214
  SQL 2.45 1.44 0.00 0.01 0 5 1,181 536

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 30,769,414,144  
Fixed Size 2,159,376  
Redo Buffers 14,614,528  
Variable Size 3,573,550,320  

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 128.42 134.20 4.50
shared PCursor 105.52 106.67 1.09
shared db_block_hash_buckets 180.00 180.00 0.00
shared free memory 714.22 630.00 -11.79
shared gcs resources 690.04 690.04 0.00
shared gcs shadows 370.55 370.55 0.00
shared kglsim object batch 50.14 50.16 0.04
shared library cache 89.53 89.68 0.17
shared sql area 606.12 680.13 12.21
streams free memory 16.00 16.00 0.00
  buffer_cache 29,344.00 29,344.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 Coordinator 69,990 0 0
QMON Slaves 12,998 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 44 0 0 1 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
ges_procs 1,227 1,657 2001 2001
processes 1,228 1,659 2000 2000
sessions 1,236 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   
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) 62,749 2.75 0.77
acks for commit broadcast(logical) 63,948 2.81 0.79
broadcast msgs on commit(actual) 72,247 3.17 0.89
broadcast msgs on commit(logical) 72,322 3.18 0.89
broadcast msgs on commit(wasted) 2,463 0.11 0.03
broadcast on commit wait time(ms) 17,873 0.78 0.22
broadcast on commit waits 69,747 3.06 0.86
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 1 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 17,682 0.78 0.22
gcs ast xid 12 0.00 0.00
gcs blocked converts 19,982 0.88 0.25
gcs blocked cr converts 19,943 0.88 0.25
gcs compatible basts 9 0.00 0.00
gcs compatible cr basts (global) 1,312 0.06 0.02
gcs compatible cr basts (local) 9,460 0.42 0.12
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,610 0.07 0.02
gcs dbwr write request msgs 1,458 0.06 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 3,241 0.14 0.04
gcs immediate (null) converts 13,876 0.61 0.17
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 45,788 2.01 0.56
gcs indirect ast 61,686 2.71 0.76
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 522 0.02 0.01
gcs msgs process time(ms) 25,483 1.12 0.31
gcs msgs received 473,744 20.80 5.82
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 29 0.00 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 34 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 7 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 0 0.00 0.00
gcs side channel msgs actual 26,404 1.16 0.32
gcs side channel msgs logical 54,762 2.40 0.67
gcs stale cr 9,672 0.42 0.12
gcs undo cr 4,462 0.20 0.05
gcs write notification msgs 77 0.00 0.00
gcs writes refused 15 0.00 0.00
ges msgs process time(ms) 3,313 0.15 0.04
ges msgs received 185,827 8.16 2.28
global posts dropped 0 0.00 0.00
global posts queue time 57 0.00 0.00
global posts queued 44 0.00 0.00
global posts requested 44 0.00 0.00
global posts sent 44 0.00 0.00
implicit batch messages received 25,862 1.14 0.32
implicit batch messages sent 22,634 0.99 0.28
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 92,976 4.08 1.14
messages queue sent actual 278,711 12.24 3.43
messages queue sent logical 337,103 14.80 4.14
messages received actual 481,470 21.14 5.92
messages received logical 659,571 28.96 8.11
messages sent directly 84,253 3.70 1.04
messages sent indirectly 159,253 6.99 1.96
messages sent not implicit batched 256,076 11.24 3.15
messages sent pbatched 307,611 13.50 3.78
msgs causing lmd to send msgs 75,389 3.31 0.93
msgs causing lms(s) to send msgs 13,631 0.60 0.17
msgs received queue time (ms) 144,298 6.33 1.77
msgs received queued 659,571 28.96 8.11
msgs sent queue time (ms) 57,266 2.51 0.70
msgs sent queue time on ksxp (ms) 116,532 5.12 1.43
msgs sent queued 336,231 14.76 4.13
msgs sent queued on ksxp 432,816 19.00 5.32
number of ges deadlock detected 0 0.00 0.00
process batch messages received 136,837 6.01 1.68
process batch messages sent 185,161 8.13 2.28


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 22,357
CURRENT Block Requests 6,338
Data Block Requests 22,357
Undo Block Requests 22
TX Block Requests 5,600
Current Results 28,390
Private results 1
Zero Results 303
Disk Read Results 0
Fail Results 0
Fairness Down Converts 2,129
Fairness Clears 0
Free GC Elements 0
Flushes 505
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 32
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 56,288 99.25 0.14 0.60 0.01 0.00
Flushes 501 80.04 13.97 3.79 2.00 0.20
Writes 2,103 71.28 26.58 0.57 0.67 0.90


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 15,872 95.55 2.87 1.59 29,350 98.05 1.88 0.07
1 undo header 4,274 99.46 0.54 0.00 664 85.39 14.61 0.00
1 Others 385 97.14 2.86 0.00 354 97.18 2.82 0.00
1 undo block 29 100.00 0.00 0.00 459 100.00 0.00 0.00


Back to Top

End of Report