WORKLOAD REPOSITORY report for

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

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:57207-3ÔÂ -13 10:54:501200 .3
End Snap:57407-3ÔÂ -13 15:23:551195 .4
Elapsed:  269.08 (mins)  
DB Time:  74.89 (mins)  

Report Summary

Cache Sizes

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

Load Profile

Per SecondPer Transaction
Redo size: 6,206.76 2,896.73
Logical reads: 3,707.35 1,730.24
Block changes: 23.07 10.77
Physical reads: 6.30 2.94
Physical writes: 2.32 1.08
User calls: 143.73 67.08
Parses: 57.40 26.79
Hard parses: 0.44 0.21
Sorts: 32.04 14.95
Logons: 3.48 1.63
Executes: 55.13 25.73
Transactions: 2.14 

% Blocks changed per Read: 0.62Recursive Call %: 58.77
Rollback per transaction %: 6.82Rows per Sort: 11.73

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 100.16In-memory Sort %: 100.00
Library Hit %: 98.84Soft Parse %: 99.23
Execute to Parse %: -4.13Latch Hit %: 99.89
Parse CPU to Parse Elapsd %: 87.70% Non-Parse CPU: 97.43

Shared Pool Statistics

BeginEnd
Memory Usage %: 80.92 82.86
% SQL with executions>1: 72.54 88.16
% Memory for SQL w/exec>1: 75.70 88.42

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  5,956  132.6 
reliable message 2,154 876 407 19.5Other
enq: WF - contention 1,277 577 452 12.8Other
latch free 4,687 89 19 2.0Other
control file sequential read 257,162 71 0 1.6System I/O

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 1.16 0.54
Global Cache blocks served: 3.37 1.57
GCS/GES messages received: 15.13 7.06
GCS/GES messages sent: 14.21 6.63
DBWR Fusion writes: 0.11 0.05
Estd Interconnect traffic (KB) 41.91 

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

Buffer access - local cache %: 100.13
Buffer access - remote cache %: 0.03
Buffer access - disk %: -0.16

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 2.5
Avg global cache cr block receive time (ms): 0.5
Avg global cache current block receive time (ms): 0.3
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 %: 5.2
Avg global cache cr block flush time (ms): 1.2
Avg global cache current block pin time (ms): 0.1
Avg global cache current block send time (ms): 0.2
Global cache log flushes for current blocks served %: 0.8
Avg global cache current block flush time (ms): 0.8

Global Cache and Enqueue Services - Messaging Statistics

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


Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU 5,956.47 132.56
sql execute elapsed time 2,039.35 45.38
connection management call elapsed time 386.75 8.61
parse time elapsed 174.81 3.89
hard parse elapsed time 35.24 0.78
sequence load elapsed time 11.83 0.26
PL/SQL execution elapsed time 4.92 0.11
failed parse elapsed time 0.24 0.01
hard parse (sharing criteria) elapsed time 0.06 0.00
hard parse (bind mismatch) elapsed time 0.05 0.00
repeated bind elapsed time 0.01 0.00
PL/SQL compilation elapsed time 0.01 0.00
DB time 4,493.57  
background elapsed time 1,996.65  
background cpu time 258.39  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%Total Call Time
CPU time     5,956   132.56
Other 378,023 54 1,578 4 35.12
Concurrency 13,069 0 127 10 2.82
System I/O 300,568   102 0 2.27
User I/O 99,970   51 1 1.14
Commit 31,670 0 41 1 0.90
Cluster 23,693 0 17 1 0.38
Network 2,224,329   15 0 0.33
Configuration 5,676 0 6 1 0.12
Application 1,907   3 2 0.07

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
reliable message 2,154 42 876 407 0.06
enq: WF - contention 1,277 87 577 452 0.04
latch free 4,687 0 89 19 0.14
control file sequential read 257,162   71 0 7.43
log file sync 31,670 0 41 1 0.92
os thread startup 440 1 35 81 0.01
latch: cache buffers chains 2,801   34 12 0.08
db file sequential read 17,608   26 1 0.51
latch: shared pool 204   25 122 0.01
direct path read 82,084   25 0 2.37
log file parallel write 37,583   21 1 1.09
DFS lock handle 22,226   18 1 0.64
latch: library cache lock 141   17 123 0.00
SQL*Net more data to client 343,599   10 0 9.93
control file parallel write 5,623   9 2 0.16
latch: library cache 82   7 86 0.00
gc current block 2-way 11,242   7 1 0.32
enq: HW - contention 5,650 0 5 1 0.16
name-service call wait 135   5 38 0.00
latch: session allocation 1,153   4 4 0.03
latch: row cache objects 28   4 131 0.00
gc cr block 2-way 6,484   4 1 0.19
row cache lock 9,151   3 0 0.26
SQL*Net message to client 1,865,589   3 0 53.93
SQL*Net break/reset to client 1,250   3 2 0.04
enq: TX - contention 14   2 170 0.00
CGS wait for IPC msg 155,833 100 2 0 4.50
gc buffer busy 158 1 2 11 0.00
gc cr block busy 481   2 3 0.01
gc current grant busy 2,325   1 1 0.07
gc current block busy 326   1 4 0.01
log file sequential read 104   1 13 0.00
SQL*Net message from dblink 1,006   1 1 0.03
gcs log flush sync 1,354 1 1 1 0.04
enq: TX - index contention 37 3 1 22 0.00
SQL*Net more data from client 13,162   1 0 0.38
enq: PS - contention 914   1 1 0.03
latch: gcs resource hash 4   1 134 0.00
ksxr poll remote instances 35,707 66 0 0 1.03
buffer busy waits 41   0 11 0.00
gc current grant 2-way 1,054   0 0 0.03
PX Deq: reap credit 21,264 96 0 0 0.61
enq: TM - contention 655   0 0 0.02
latch: cache buffers lru chain 2   0 123 0.00
cursor: pin S 126,329   0 0 3.65
enq: US - contention 682   0 0 0.02
gc current multi block request 1,241   0 0 0.04
undo segment extension 2 100 0 98 0.00
rdbms ipc reply 1,257   0 0 0.04
enq: CF - contention 233   0 1 0.01
PX Deq Credit: send blkd 1,040 66 0 0 0.03
PX Deq: Signal ACK 1,078 33 0 0 0.03
CSS operation: query 36   0 3 0.00
log file switch completion 4   0 28 0.00
Data file init write 92   0 1 0.00
cursor: pin S wait on X 10 90 0 10 0.00
enq: FB - contention 193   0 0 0.01
gc cr grant 2-way 206   0 0 0.01
gc cr multi block request 149   0 0 0.00
enq: SQ - contention 8   0 6 0.00
IPC send completion sync 159 100 0 0 0.00
library cache lock 82   0 0 0.00
Log archive I/O 88   0 0 0.00
enq: TA - contention 54   0 1 0.00
enq: TD - KTF dump entries 53   0 1 0.00
CSS initialization 12   0 2 0.00
library cache pin 52   0 0 0.00
enq: JQ - contention 25   0 0 0.00
read by other session 2   0 6 0.00
gc cr disk read 26   0 0 0.00
db file single write 21   0 0 0.00
CSS operation: action 24   0 0 0.00
local write wait 6   0 1 0.00
direct path write 157   0 0 0.00
enq: TX - allocate ITL entry 12   0 1 0.00
enq: DR - contention 9   0 1 0.00
enq: JS - job run lock - synchronize 9   0 0 0.00
enq: TT - contention 13   0 0 0.00
LGWR wait for redo copy 56   0 0 0.00
buffer deadlock 5 100 0 0 0.00
log file single write 8   0 0 0.00
SQL*Net message to dblink 970   0 0 0.03
latch: ges resource hash list 22   0 0 0.00
enq: TX - row lock contention 1   0 1 0.00
enq: AF - task serialization 1   0 1 0.00
enq: RS - prevent aging list update 1   0 1 0.00
gc current split 1   0 1 0.00
enq: WL - contention 1   0 0 0.00
enq: CT - state 1   0 0 0.00
enq: PW - flush prewarm buffers 1   0 0 0.00
latch: KCL gc element parent latch 6   0 0 0.00
SQL*Net more data from dblink 3   0 0 0.00
SQL*Net message from client 1,919,777   17,682,532 9211 55.50
gcs remote message 4,433,499 95 125,950 28 128.16
jobq slave wait 19,064 94 54,212 2844 0.55
PX Idle Wait 9,744 95 23,227 2384 0.28
Streams AQ: qmn slave idle wait 598   15,766 26365 0.02
Streams AQ: qmn coordinator idle wait 1,765 34 15,766 8933 0.05
Streams AQ: waiting for time management or cleanup tasks 1,839 69 15,762 8571 0.05
DIAG idle wait 80,642   15,761 195 2.33
ASM background timer 4,253   15,758 3705 0.12
ges remote message 282,633 70 15,754 56 8.17
virtual circuit status 538 100 15,701 29184 0.02
class slave wait 3,090 85 15,685 5076 0.09
i/o slave wait 38,658   86 2 1.12
KSV master wait 273   16 57 0.01
PX Deq: Execution Msg 1,861 6 2 1 0.05
single-task message 36   2 49 0.00
PX Deq: Join ACK 1,162 34 1 1 0.03
PX Deq: Parse Reply 1,132 34 0 0 0.03
PX Deq: Execute Reply 877 34 0 0 0.03
PX Deq: Msg Fragment 680 1 0 0 0.02
Streams AQ: RAC qmn coordinator idle wait 2,220 100 0 0 0.06

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
os thread startup 440 1 35 81 0.01
log file parallel write 37,584   21 1 1.09
control file sequential read 43,071   19 0 1.25
control file parallel write 5,560   8 1 0.16
enq: HW - contention 5,454   2 0 0.16
log file sequential read 104   1 13 0.00
gc cr block 2-way 1,116   1 0 0.03
gc current block 2-way 345   0 1 0.01
latch: library cache 1   0 137 0.00
Log archive I/O 88   0 0 0.00
latch: shared pool 18   0 1 0.00
log file single write 8   0 0 0.00
direct path write 111   0 0 0.00
direct path read 152   0 0 0.00
gc current multi block request 1   0 0 0.00
buffer busy waits 3   0 0 0.00
latch: cache buffers chains 8   0 0 0.00
latch: row cache objects 2   0 0 0.00
enq: TM - contention 624 -0 -0 -0 0.02
events in waitclass Other 111,222 79 -44,725 -402 3.22
rdbms ipc message 366,473 64 266,802 728 10.59
gcs remote message 4,433,497 95 125,949 28 128.16
Streams AQ: qmn slave idle wait 598   15,766 26365 0.02
Streams AQ: qmn coordinator idle wait 1,765 34 15,766 8933 0.05
Streams AQ: waiting for time management or cleanup tasks 1,839 69 15,762 8571 0.05
DIAG idle wait 80,641   15,761 195 2.33
ASM background timer 4,253   15,758 3705 0.12
ges remote message 282,643 70 15,754 56 8.17
smon timer 3,304   15,750 4767 0.10
pmon timer 14,794 100 15,707 1062 0.43
class slave wait 2,863 91 15,685 5478 0.08
KSV master wait 124   7 54 0.00
Streams AQ: RAC qmn coordinator idle wait 2,220 100 0 0 0.06

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 950,451
IDLE_TIME 50,700,026
IOWAIT_TIME 13,970
NICE_TIME 1,459
SYS_TIME 532,440
USER_TIME 397,313
LOAD 1
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 5,269,565,440
VM_OUT_BYTES 2,860,846,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 4,274.00 5,729.10 101,099 59,394,459
SYS$USERS 221.20 228.70 97 248,071
SYS$BACKGROUND 0.20 0.30 523 270,005
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 84254 45 10921 85 0 0 1992084 14
SYS$USERS 14937 6 160 3 0 0 15474 0
SYS$BACKGROUND 779 1 1984 37 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
324 293 113,049 0.00 7.22 az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
203 207 802 0.25 4.51 d3rgr1ugyfy4v   select * from ( select temp.* ...
175 179 7 25.04 3.90 gtct3f6rqmt7k   BEGIN proc_tb_server_kpi(:1, :...
175 179 7 25.04 3.90 aucbhp050unfp   INSERT INTO TB_SERVER_KPI (SER...
153 154 802 0.19 3.40 9j3v93dcqd1ng   select count(*) from (select c...
125 127 5 24.91 2.77 6p18ng82999p1 oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
116 118 5 23.13 2.57 36pd7s33q8t3d oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
68 29 263 0.26 1.50 0s07s16dca7m1 sqlplus@OMP-ACS-DB2 (TNS V1-V3) select STATUS from v$datafile
67 64 54,309 0.00 1.50 0k8522rmdzg4k   select privilege# from sysauth...
48 49 106 0.45 1.06 b6sts095f7490   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
293 324 113,049 0.00 4.93 7.22 az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
207 203 802 0.26 3.47 4.51 d3rgr1ugyfy4v   select * from ( select temp.* ...
179 175 7 25.61 3.01 3.90 gtct3f6rqmt7k   BEGIN proc_tb_server_kpi(:1, :...
179 175 7 25.61 3.01 3.90 aucbhp050unfp   INSERT INTO TB_SERVER_KPI (SER...
154 153 802 0.19 2.59 3.40 9j3v93dcqd1ng   select count(*) from (select c...
127 125 5 25.47 2.14 2.77 6p18ng82999p1 oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
118 116 5 23.66 1.99 2.57 36pd7s33q8t3d oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
64 67 54,309 0.00 1.08 1.50 0k8522rmdzg4k   select privilege# from sysauth...
49 48 106 0.46 0.82 1.06 b6sts095f7490   select * from ( select temp.* ...
44 44 108 0.41 0.74 0.98 8qk3ffrqfu5mj   select count(*) from (select a...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
8,811,909 802 10,987.42 14.72 206.81 202.71 d3rgr1ugyfy4v   select * from ( select temp.* ...
6,790,391 802 8,466.82 11.34 154.27 152.70 9j3v93dcqd1ng   select count(*) from (select c...
5,877,447 113,049 51.99 9.82 293.49 324.24 az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
2,609,587 7 372,798.14 4.36 179.29 175.29 gtct3f6rqmt7k   BEGIN proc_tb_server_kpi(:1, :...
2,609,580 7 372,797.14 4.36 179.27 175.28 aucbhp050unfp   INSERT INTO TB_SERVER_KPI (SER...
2,498,041 108 23,130.01 4.17 44.34 43.99 8qk3ffrqfu5mj   select count(*) from (select a...
2,195,048 106 20,708.00 3.67 48.58 47.72 b6sts095f7490   select * from ( select temp.* ...
1,863,940 5 372,788.00 3.11 127.34 124.54 6p18ng82999p1 oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
1,863,915 5 372,783.00 3.11 118.28 115.67 36pd7s33q8t3d oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
1,666,904 16,504 101.00 2.78 17.84 17.67 4bkajwhn01bf4   select m.* from (select t.adve...
817,494 8,094 101.00 1.37 8.26 8.20 chvsc0kcnaygf   select * from ( select t.adver...
758,112 7,152 106.00 1.27 7.77 7.38 gxa2gs64zaq6p   select * from ( select temp.* ...
722,453 7,153 101.00 1.21 6.53 6.44 fkwdf31hccvwp   select * from ( select t.adver...
720,433 7,133 101.00 1.20 6.61 6.50 10rj3nwvwud4n   select * from ( select t.adver...
707,070 1,295 546.00 1.18 16.86 16.54 55mrvd0ujdavz   select count(*) from( select c...
622,224 7,152 87.00 1.04 7.38 7.82 4aa2pajm13day   select count(*) from tb_articl...

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
830 12,624 0.07 0.82 25.91 34.45 f7wycxzwr231m JDBC Thin Client insert into TB_ACCOUNT_INTERFA...
730 13,057 0.06 0.72 29.82 39.36 8g02qq5sb8gkk JDBC Thin Client INSERT INTO TB_AUTH_LOG(LOG_ID...
292 2 146.00 0.29 0.30 0.35 0dwr2vd6vbqzs   SELECT count(*) over () as tot...
11 10,730 0.00 0.01 3.03 3.25 5kt6k7qwjz6fu JDBC Thin Client select * from (select t.*, row...
6 5 1.20 0.01 0.01 0.03 2yk6kghmsqydw JDBC Thin Client update TB_ARTICLE_CONTENT set ...
6 4 1.50 0.01 0.02 0.06 4mu05x7kzn7pw JDBC Thin Client insert into TB_API_REQUEST_LOG...
6 5 1.20 0.01 0.04 0.08 b00t2yvxh2vvm JDBC Thin Client insert into TB_ARTICLE_CONTENT...
2 1 2.00 0.00 0.03 0.04 663z4d9phs0up PL/SQL Developer select col.*, com.Comments fro...
1 189 0.01 0.00 6.58 6.64 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
0 58 0.00 0.00 0.04 0.04 04xtrk7uyhknh   select obj#, type#, ctime, mti...

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
113,049 0 0.00 0.00 0.00 az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
110,696 4,877 0.04 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
54,309 110,696 2.04 0.00 0.00 0k8522rmdzg4k   select privilege# from sysauth...
53,642 53,641 1.00 0.00 0.00 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
53,642 53,642 1.00 0.00 0.00 459f3z9u4fb3u   select value$ from props$ wher...
53,115 53,115 1.00 0.00 0.00 5ur69atw3vfhj   select decode(failover_method,...
51,839 0 0.00 0.00 0.00 a4m2hmf2qhtv7   select tbtestwhit0_.wl_id as w...
26,145 0 0.00 0.00 0.00 bw2rqq1s3bzrd   select tbtestwhit0_.wl_id as w...
16,504 16,491 1.00 0.00 0.00 4bkajwhn01bf4   select m.* from (select t.adve...
16,391 16,391 1.00 0.00 0.00 c68x2drb8jh6f   SELECT T.LABEL_ID, T.LABEL_NAM...
16,305 146,745 9.00 0.00 0.00 4mx8yjy0y5n5g   select tdict0_.ID as ID156_, t...
13,057 13,057 1.00 0.00 0.00 8g02qq5sb8gkk JDBC Thin Client INSERT INTO TB_AUTH_LOG(LOG_ID...
12,624 12,624 1.00 0.00 0.00 dtrjpdn3fw6as JDBC Thin Client select TB_ACCOUNT_INTERFACE_LO...
12,624 12,624 1.00 0.00 0.00 f7wycxzwr231m JDBC Thin Client insert into TB_ACCOUNT_INTERFA...
12,620 80,652 6.39 0.00 0.00 asycs9abcdt1k JDBC Thin Client SELECT TP.ID, TP.SP_ID, TP.SP_...
11,164 11,164 1.00 0.00 0.00 bh9d2wk667paf   select tdict0_.ID as ID112_, t...
10,730 10,287 0.96 0.00 0.00 5kt6k7qwjz6fu JDBC Thin Client select * from (select t.*, row...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
113,049 113,049 12.20 az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
110,696 110,696 11.94 0h6b2sajwb74n   select privilege#, level from ...
54,309 54,309 5.86 0k8522rmdzg4k   select privilege# from sysauth...
53,642 53,642 5.79 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
53,642 53,642 5.79 459f3z9u4fb3u   select value$ from props$ wher...
53,115 53,115 5.73 5ur69atw3vfhj   select decode(failover_method,...
51,839 51,839 5.59 a4m2hmf2qhtv7   select tbtestwhit0_.wl_id as w...
26,145 26,145 2.82 bw2rqq1s3bzrd   select tbtestwhit0_.wl_id as w...
16,504 16,504 1.78 4bkajwhn01bf4   select m.* from (select t.adve...
16,391 16,391 1.77 c68x2drb8jh6f   SELECT T.LABEL_ID, T.LABEL_NAM...
16,305 16,305 1.76 4mx8yjy0y5n5g   select tdict0_.ID as ID156_, t...
13,057 13,057 1.41 8g02qq5sb8gkk JDBC Thin Client INSERT INTO TB_AUTH_LOG(LOG_ID...
12,624 12,624 1.36 dtrjpdn3fw6as JDBC Thin Client select TB_ACCOUNT_INTERFACE_LO...
12,624 12,624 1.36 f7wycxzwr231m JDBC Thin Client insert into TB_ACCOUNT_INTERFA...
12,620 12,620 1.36 asycs9abcdt1k JDBC Thin Client SELECT TP.ID, TP.SP_ID, TP.SP_...
11,164 11,164 1.20 bh9d2wk667paf   select tdict0_.ID as ID112_, t...
10,730 10,730 1.16 5kt6k7qwjz6fu JDBC Thin Client select * from (select t.*, row...

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
35 10 3qsmy8ybvwt3n   insert into WRI$_ALERT_OUTSTAN...
26 443 bcz7kcb5nhjfv   insert into tb_user_oper_log (...
21 6,860 4m7m0t6fjcs5x   update seq$ set increment$=:2,...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)CWT % of Elapsd TimeElapsed Time(s)CPU Time(s)Executions SQL IdSQL ModuleSQL Text
4.14 10.51 39.36 29.82 13,057 8g02qq5sb8gkk JDBC Thin Client INSERT INTO TB_AUTH_LOG(LOG_ID...
3.62 10.51 34.45 25.91 12,624 f7wycxzwr231m JDBC Thin Client insert into TB_ACCOUNT_INTERFA...
2.46 7.05 34.82 12.11 443 bcz7kcb5nhjfv   insert into tb_user_oper_log (...
1.20 28.20 4.27 3.20 6,860 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
0.43 0.28 152.70 154.27 802 9j3v93dcqd1ng   select count(*) from (select c...
0.24 0.12 202.71 206.81 802 d3rgr1ugyfy4v   select * from ( select temp.* ...
0.21 5.77 3.68 3.15 12,624 dtrjpdn3fw6as JDBC Thin Client select TB_ACCOUNT_INTERFACE_LO...
0.21 0.06 324.24 293.49 113,049 az33m61ym46y4 JDBC Thin Client SELECT NULL AS table_cat, o.ow...
0.18 5.55 3.25 3.03 10,730 5kt6k7qwjz6fu JDBC Thin Client select * from (select t.*, row...
0.13 0.30 43.99 44.34 108 8qk3ffrqfu5mj   select count(*) from (select a...
0.09 1.37 6.64 6.58 189 6gvch1xu9ca3g   DECLARE job BINARY_INTEGER := ...
0.08 0.18 47.72 48.58 106 b6sts095f7490   select * from ( select temp.* ...
0.05 0.03 175.28 179.27 7 aucbhp050unfp   INSERT INTO TB_SERVER_KPI (SER...
0.05 0.03 175.29 179.29 7 gtct3f6rqmt7k   BEGIN proc_tb_server_kpi(:1, :...
0.04 44.08 0.10 0.06 20 2v2hwkp94jdny JDBC Thin Client insert into TB_SSO_APP_TICKET ...
0.04 0.03 124.54 127.34 5 6p18ng82999p1 oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
0.04 10.68 0.35 0.30 2 0dwr2vd6vbqzs   SELECT count(*) over () as tot...
0.02 0.02 115.67 118.28 5 36pd7s33q8t3d oracle@OMP_MS_DB1 (TNS V1-V3) SELECT "A1"."COLLECT_TYPE", NV...
0.01 40.48 0.03 0.02 3 6jmd41c7nuvf5 JDBC Thin Client insert into TB_SSO_USER_LOGIN_...
0.01 0.34 3.50 3.27 7,145 9w01ztmr4569k   select count(*) from tb_articl...
0.01 0.15 7.82 7.38 7,152 4aa2pajm13day   select count(*) from tb_articl...
0.01 39.38 0.02 0.01 10 3qsmy8ybvwt3n   insert into WRI$_ALERT_OUTSTAN...
0.01 0.08 7.38 7.77 7,152 gxa2gs64zaq6p   select * from ( select temp.* ...
0.01 24.08 0.02 0.02 2 31a13pnjps7j3   SELECT source, (case when time...
0.01 0.12 4.67 4.73 7,145 3r189y4actbt2   select * from ( select temp.* ...
0.01 0.31 1.78 1.82 1 gktbxssxarhdq   select count(*) from (select a...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
04xtrk7uyhknhselect obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0dwr2vd6vbqzs SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0s07s16dca7m1select STATUS from v$datafile
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
10rj3nwvwud4nselect * from ( select t.advert_id, t.ad_code, t.ad_name, t.ad_width, t.ad_height, t.ad_type, t.city_id, t.column_id, t.access_type, t.ad_enable, t.ad_status, t.remark, t.operator, t1.matter_id, t1.matter_name, t1.matter_type, t1.matter_width, t1.matter_height, t1.matter_desc, t1.matter_url, t1.matter_title, t1.status, t1.upload_time, t1.url from tb_advert t, tb_matter t1, tb_ad_publish t2 where t.advert_id=t2.advert_id and t2.matter_id=t1.matter_id and t.area_code = '591' and t.ad_code ='WEB_INDEX_1' and t.ad_enable=1 and t.access_type=1 and t1.status=2 and t2.status =1 and sysdate >= t2.start_time and sysdate < t2.end_time order by t1.update_time desc ) where rownum<2
2v2hwkp94jdnyinsert into TB_SSO_APP_TICKET (ACCOUNT, APP_ID, APP_TMP_TICKET, APP_URL, AUTH_IP, AUTH_TIME, EFFECT_TIME, GENERATE_TIME, GLOBAL_TICKET, REMARK, REQ_IP, STATUS, USESSIONID, VERSION, ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15)
2yk6kghmsqydwupdate TB_ARTICLE_CONTENT set CLIENT_CONTENT=:1, WAP_CONTENT=:2, WEB_CONTENT=:3 where CONTENT_ID=:4
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"
3qsmy8ybvwt3ninsert into WRI$_ALERT_OUTSTANDING (reason_id, object_id, subobject_id, internal_instance_number, owner, object_name, subobject_name, sequence_id, reason_argument_1, reason_argument_2, reason_argument_3, reason_argument_4, reason_argument_5, time_suggested, creation_time, action_argument_1, action_argument_2, action_argument_3, action_argument_4, action_argument_5, message_level, hosting_client_id, process_id, host_id, host_nw_addr, instance_name, instance_number, user_id, execution_context_id, error_instance_id, context, metric_value) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32)
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
4mu05x7kzn7pwinsert into TB_API_REQUEST_LOG (CLIENT_IP, CONTENT, REQUEST_SEQ, REQUEST_SOURCE, REQUEST_TIME, REQUEST_TYPE, RESPONSE_TIME, RETURN_CODE, RETURN_DESC, SERVICE_NAME, SYS_FUNC_ID, VERIFY_CODE, ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
4mx8yjy0y5n5gselect tdict0_.ID as ID156_, tdict0_.GROUP_ID as GROUP2_156_, tdict0_.DICT_NAME as DICT3_156_, tdict0_.DICT_VALUE as DICT4_156_, tdict0_.DICT_INDEX as DICT5_156_, tdict0_.REMARK as REMARK156_ from T_DICT tdict0_, T_DICT_GROUP tdictgroup1_ where tdict0_.GROUP_ID=tdictgroup1_.ID and tdictgroup1_.GROUP_NAME=:1 and tdict0_.DICT_VALUE<>'pingtan' order by tdict0_.DICT_INDEX
55mrvd0ujdavzselect count(*) from( select c.*, a.advertiser_name, bc.business_circle_id id, bc.business_circle_name name from tb_courtesy c, tb_advertiser a, tb_business_circle bc where c.advertiser_id = a.advertiser_id and a.business_circle_id = bc.business_circle_id and c.courtesy_source = 0 and c.status = 0 and a.status = 0 and bc.status = 0 and bc.blone_city = c.city_id union all select c.*, '' advertiser_name, bc.business_circle_id id, bc.business_circle_name name from tb_courtesy c, tb_business_circle bc, tb_courtesy_businesscircle cb where cb.businesscircle_id = bc.business_circle_id and c.courtesy_code = cb.courtesy_code and c.status = 0 and bc.status = 0 and c.courtesy_source = 1 and bc.blone_city = c.city_id ) d where d.city_id= 591 and d.begin_date <= sysdate and d.end_date > sysdate
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
663z4d9phs0upselect col.*, com.Comments from sys.all_tab_columns col, sys.all_col_comments com where col.owner = 'SYS' and col.table_name = 'DBA_JOBS' and com.Owner (+) = 'SYS' and com.Table_Name (+) = 'DBA_JOBS' and com.Column_Name (+) = col.Column_Name order by col.column_id
6gvch1xu9ca3gDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6jmd41c7nuvf5insert into TB_SSO_USER_LOGIN_LOG (ACCOUNT, COOKIE, LOGIN_BS, LOGIN_IP, LOGIN_OS, LOGIN_TIME, LOGOUT_TIME, REMARK, STATUS, TICKET, USERAGENT, USESSIONID, ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
6p18ng82999p1SELECT "A1"."COLLECT_TYPE", NVL(SUM("A1"."SUCC_REQ_NUM"), 0) FROM "TB_SERVER_LOG" "A1" WHERE TO_CHAR("A1"."COLLECT_TIME", 'yyyy-mm-dd hh24:mi')>:1 AND TO_CHAR("A1"."COLLECT_TIME", 'yyyy-mm-dd hh24:mi')<=:2 AND ("A1"."COLLECT_TYPE"=1 OR "A1"."COLLECT_TYPE"=2) GROUP BY "A1"."COLLECT_TYPE"
8g02qq5sb8gkkINSERT INTO TB_AUTH_LOG(LOG_ID, THIRD_ID, SP_ID, LOG_TYPE, IP_ADDRESS, TOKEN_VALUE, ACCOUNT, ACCOUNT_TYPE, RESULT_TYPE, REMARK, RESP_CONT, REQUEST_PARAM) VALUES(SEQ_AUTH_LOG.NEXTVAL, :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11)
8qk3ffrqfu5mjselect count(*) from (select a.content_id, a.views_count, a.ups_count, c.title, c.short_title, b.column_id from tb_article a, tb_article_desc c, tb_article_content_relation b where a.status = 2 and a.content_id = c.content_id and a.content_id = b.content_id and b.column_id in (select column_id from tb_page_content t where t.status = 2 and t.type = 1 and (t.parent_id = 10591007 or t.column_id = 10591007))) f where f.content_id not in (select content_id from (select a.content_id from tb_article a, tb_article_desc c, tb_article_content_relation b where a.status = 2 and a.content_id = c.content_id and a.content_id = b.content_id and b.column_id in (select column_id from tb_page_content t where t.status = 2 and t.type = 1 and (t.parent_id = 10591007 or t.column_id = 10591007))) group by content_id having count(*) > 1)
9j3v93dcqd1ngselect count(*) from (select content_id, column_id from tb_article_content_relation t where column_id in (select column_id from tb_page_content t where t.status = 2 and t.type = 2 and t.parent_id = :1)) b, ( select a.content_id, to_char(a.insert_date, 'yyyy-mm-dd hh24:mi:ss') insert_date, c.title, to_char(c.release_date, 'yyyy-mm-dd hh24:mi:ss') release_date, to_char(c.release_date, 'yyyy-mm-dd') release_date_ymd, c.content_type, c.top_content, c.show_image from tb_article a, tb_article_content b, tb_article_desc c where a.status = 2 and a.content_id = b.content_id and a.content_id = c.content_id ) q where b.content_id=q.content_id
9w01ztmr4569kselect count(*) from tb_article a, tb_article_desc c where a.status = 2 and a.content_id = c.content_id and exists (select content_id from tb_article_content_relation where column_id = 10591031 and content_id = a.content_id)
a4m2hmf2qhtv7select tbtestwhit0_.wl_id as wl1_114_, tbtestwhit0_.wl_ip as wl2_114_, tbtestwhit0_.wl_phone as wl3_114_, tbtestwhit0_.wl_email as wl4_114_, tbtestwhit0_.Wl_url as Wl5_114_, tbtestwhit0_.wl_type as wl6_114_, tbtestwhit0_.is_valid as is7_114_ from TB_TEST_WHITE_LIST tbtestwhit0_ where tbtestwhit0_.is_valid=1
asycs9abcdt1kSELECT TP.ID, TP.SP_ID, TP.SP_NAME, TP.PWD, TP.SECRET_KEY, TP.ENCRYT_TYPE, TP.DOMAIN_NAME, TP.ADD_USER_ID, TP.ADD_TIME, TP.STATUS, TP.BEGIN_TIME, TP.EXPIRE_TIME, TP.UPDATE_TIME, TP.REMARK, IL.IP_ADDRESS, IL.STATUS AS IP_STATUS, SC.AUTH_TYPE, S.S_NAME, S.S_URL, S.DIGIT_SIGNATURE, S.STATUS AS SERVICE_STATUS FROM TB_THIRD_PART TP, TB_IP_LIST IL, TB_IP_SERVICE_CONF SC, TB_SERVICE S WHERE TP.ID=IL.THIRD_ID AND IL.ID=SC.IP_LIST_ID AND SC.S_ID=S.S_ID AND TP.SP_ID = :1 AND TP.STATUS = :2 AND IL.STATUS = :3 AND S.STATUS = :4 AND S.S_ID = :5
aucbhp050unfpINSERT INTO TB_SERVER_KPI (SERVERKPI_ID, SUCC_REQ_NUM, FAIL_REQ_NUM, COLLECT_TYPE, COLLECT_TIME, IS_UP, CREATE_DATE ) SELECT TB_SERVER_KPI_SEQ.NEXTVAL, SUC, FAIL, COLLECT_TYPE, TO_DATE(:B1 , 'yyyy-mm-dd hh24:mi'), 0, :B3 FROM ( SELECT TUP.COLLECT_TYPE, SUM(TUP.SUCC_REQ_NUM) SUC, SUM(TUP.FAIL_REQ_NUM) FAIL FROM TB_SERVER_LOG TUP WHERE TO_CHAR(TUP.COLLECT_TIME, 'yyyy-mm-dd hh24:mi') > :B2 AND TO_CHAR(TUP.COLLECT_TIME, 'yyyy-mm-dd hh24:mi') <= :B1 AND TUP.COLLECT_TYPE IN(1, 2) GROUP BY TUP.COLLECT_TYPE)
az33m61ym46y4SELECT NULL AS table_cat, o.owner AS table_schem, o.object_name AS table_name, o.object_type AS table_type, NULL AS remarks FROM all_objects o WHERE o.owner LIKE :1 ESCAPE '/' AND o.object_name LIKE :2 ESCAPE '/' AND o.object_type IN ('xxx', 'TABLE') ORDER BY table_type, table_schem, table_name
b00t2yvxh2vvminsert into TB_ARTICLE_CONTENT (CLIENT_CONTENT, WAP_CONTENT, WEB_CONTENT, CONTENT_ID) values (:1, :2, :3, :4)
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)
bh9d2wk667pafselect 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_NAME=:2
bw2rqq1s3bzrdselect tbtestwhit0_.wl_id as wl1_121_, tbtestwhit0_.wl_ip as wl2_121_, tbtestwhit0_.wl_phone as wl3_121_, tbtestwhit0_.wl_email as wl4_121_, tbtestwhit0_.Wl_url as Wl5_121_, tbtestwhit0_.wl_type as wl6_121_, tbtestwhit0_.is_valid as is7_121_ from TB_TEST_WHITE_LIST tbtestwhit0_ where tbtestwhit0_.is_valid=1
c68x2drb8jh6fSELECT T.LABEL_ID, T.LABEL_NAME, T.LABEL_URL FROM TB_LABEL T WHERE T.IS_DISP = 0 AND T.STATUS = 0 AND T.LABEL_GROUP_CODE = 'LABEL_INDEX_JGG' AND T.CITY_ID = :1 AND rownum = 1
chvsc0kcnaygfselect * from ( select t.advert_id, t.ad_code, t.ad_name, t.ad_width, t.ad_height, t.ad_type, t.city_id, t.column_id, t.access_type, t.ad_enable, t.ad_status, t.remark, t.operator, t1.matter_id, t1.matter_name, t1.matter_type, t1.matter_width, t1.matter_height, t1.matter_desc, t1.matter_url, t1.matter_title, t1.status, t1.upload_time, t1.url from tb_advert t, tb_matter t1, tb_ad_publish t2 where t.advert_id=t2.advert_id and t2.matter_id=t1.matter_id and t.area_code = '591' and t.ad_code ='WEB_HEADTOP_1' and t.ad_enable=1 and t.access_type=1 and t1.status=2 and t2.status =1 and sysdate >= t2.start_time and sysdate < t2.end_time order by t1.update_time desc ) where rownum<2
d3rgr1ugyfy4vselect * from ( select temp.* , rownum num from ( select q.*, b.column_id from (select content_id, column_id from tb_article_content_relation t where column_id in (select column_id from tb_page_content t where t.status = 2 and t.type = 2 and t.parent_id = :1)) b, ( select a.content_id, to_char(a.insert_date, 'yyyy-mm-dd hh24:mi:ss') insert_date, c.title, to_char(c.release_date, 'yyyy-mm-dd hh24:mi:ss') release_date, to_char(c.release_date, 'yyyy-mm-dd') release_date_ymd, c.content_type, c.top_content, c.show_image from tb_article a, tb_article_content b, tb_article_desc c where a.status = 2 and a.content_id = b.content_id and a.content_id = c.content_id ) q where b.content_id=q.content_id order by q.release_date desc¡¡) temp where rownum <= :2 ) where¡¡num > :3
dtrjpdn3fw6asselect TB_ACCOUNT_INTERFACE_LOG_SEQ.nextval from dual
f7wycxzwr231minsert into TB_ACCOUNT_INTERFACE_LOG (CONTENT, IP, PORTAL_ACCOUNT, PORTAL_TYPE, REQUEST_TIME, RETURN_CODE, RETURN_INFO, RETURN_TIME, ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9)
fkwdf31hccvwpselect * from ( select t.advert_id, t.ad_code, t.ad_name, t.ad_width, t.ad_height, t.ad_type, t.city_id, t.column_id, t.access_type, t.ad_enable, t.ad_status, t.remark, t.operator, t1.matter_id, t1.matter_name, t1.matter_type, t1.matter_width, t1.matter_height, t1.matter_desc, t1.matter_url, t1.matter_title, t1.status, t1.upload_time, t1.url from tb_advert t, tb_matter t1, tb_ad_publish t2 where t.advert_id=t2.advert_id and t2.matter_id=t1.matter_id and t.area_code = '591' and t.ad_code ='WEB_INDEX_2' and t.ad_enable=1 and t.access_type=1 and t1.status=2 and t2.status =1 and sysdate >= t2.start_time and sysdate < t2.end_time order by t1.update_time desc ) where rownum<2
gktbxssxarhdqselect 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 = 10596031 or t.column_id = 10596031))) 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 = 10596031 or t.column_id = 10596031))) 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 249,546 15.46 7.21
CPU used when call started 242,246 15.00 7.00
CR blocks created 325 0.02 0.01
Cached Commit SCN referenced 1,643,609 101.80 47.51
Commit SCN cached 61 0.00 0.00
DB time 5,728,099 354.80 165.59
DBWR checkpoint buffers written 36,040 2.23 1.04
DBWR checkpoints 2 0.00 0.00
DBWR fusion writes 1,696 0.11 0.05
DBWR object drop buffers written 0 0.00 0.00
DBWR revisited being-written buffer 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 1,959 0.12 0.06
DBWR undo block writes 7,929 0.49 0.23
DFO trees parallelized 399 0.02 0.01
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 2,188 0.14 0.06
PX local messages sent 2,188 0.14 0.06
PX remote messages recv'd 1,012 0.06 0.03
PX remote messages sent 1,676 0.10 0.05
Parallel operations not downgraded 399 0.02 0.01
RowCR - row contention 0 0.00 0.00
RowCR attempts 377 0.02 0.01
RowCR hits 377 0.02 0.01
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 10 0.00 0.00
SQL*Net roundtrips to/from client 1,648,816 102.13 47.66
SQL*Net roundtrips to/from dblink 970 0.06 0.03
active txn count during cleanout 10,320 0.64 0.30
application wait time 326 0.02 0.01
background checkpoints completed 3 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 78,547 4.87 2.27
branch node splits 2 0.00 0.00
buffer is not pinned count 13,689,254 847.91 395.72
buffer is pinned count 24,704,117 1,530.16 714.14
bytes received via SQL*Net from client 309,931,995 19,197.06 8,959.38
bytes received via SQL*Net from dblink 326,961 20.25 9.45
bytes sent via SQL*Net to client 1,099,702,205 68,115.10 31,789.73
bytes sent via SQL*Net to dblink 295,365 18.29 8.54
calls to get snapshot scn: kcmgss 2,407,697 149.13 69.60
calls to kcmgas 98,819 6.12 2.86
calls to kcmgcs 4,318 0.27 0.12
change write time 790 0.05 0.02
cleanout - number of ktugct calls 5,157 0.32 0.15
cleanouts and rollbacks - consistent read gets 229 0.01 0.01
cleanouts only - consistent read gets 115 0.01 0.00
cluster key scan block gets 503,025 31.16 14.54
cluster key scans 463,295 28.70 13.39
cluster wait time 1,703 0.11 0.05
commit batch performed 3 0.00 0.00
commit batch requested 3 0.00 0.00
commit batch/immediate performed 66 0.00 0.00
commit batch/immediate requested 66 0.00 0.00
commit cleanout failures: block lost 25 0.00 0.00
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 49 0.00 0.00
commit cleanout failures: cannot pin 35 0.00 0.00
commit cleanouts 107,266 6.64 3.10
commit cleanouts successfully completed 107,157 6.64 3.10
commit immediate performed 63 0.00 0.00
commit immediate requested 63 0.00 0.00
commit txn count during cleanout 11,296 0.70 0.33
concurrency wait time 12,408 0.77 0.36
consistent changes 331 0.02 0.01
consistent gets 59,388,548 3,678.50 1,716.78
consistent gets - examination 21,632,583 1,339.91 625.35
consistent gets direct 98,987 6.13 2.86
consistent gets from cache 59,289,541 3,672.37 1,713.92
current blocks converted for CR 0 0.00 0.00
cursor authentications 4,351 0.27 0.13
data blocks consistent reads - undo records applied 308 0.02 0.01
db block changes 372,485 23.07 10.77
db block gets 465,127 28.81 13.45
db block gets direct 57 0.00 0.00
db block gets from cache 465,070 28.81 13.44
deferred (CURRENT) block cleanout applications 40,464 2.51 1.17
dirty buffers inspected 6 0.00 0.00
enqueue conversions 5,421 0.34 0.16
enqueue releases 366,524 22.70 10.60
enqueue requests 366,666 22.71 10.60
enqueue timeouts 145 0.01 0.00
enqueue waits 8,547 0.53 0.25
exchange deadlocks 6 0.00 0.00
execute count 889,991 55.13 25.73
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 8,054 0.50 0.23
free buffer requested 29,721 1.84 0.86
gc CPU used by this session 7,178 0.44 0.21
gc blocks lost 0 0.00 0.00
gc cr block build time 29 0.00 0.00
gc cr block flush time 58 0.00 0.00
gc cr block receive time 344 0.02 0.01
gc cr block send time 44 0.00 0.00
gc cr blocks received 7,108 0.44 0.21
gc cr blocks served 9,324 0.58 0.27
gc current block flush time 28 0.00 0.00
gc current block pin time 247 0.02 0.01
gc current block receive time 402 0.02 0.01
gc current block send time 700 0.04 0.02
gc current blocks received 11,578 0.72 0.33
gc current blocks served 45,007 2.79 1.30
gc local grants 5,616 0.35 0.16
gc remote grants 5,604 0.35 0.16
gcs messages sent 162,759 10.08 4.70
ges messages sent 66,678 4.13 1.93
global enqueue get time 55,600 3.44 1.61
global enqueue gets async 10,140 0.63 0.29
global enqueue gets sync 214,970 13.32 6.21
global enqueue releases 203,212 12.59 5.87
heap block compress 294 0.02 0.01
hot buffers moved to head of LRU 746 0.05 0.02
immediate (CR) block cleanout applications 344 0.02 0.01
immediate (CURRENT) block cleanout applications 2,934 0.18 0.08
index crx upgrade (found) 77 0.00 0.00
index crx upgrade (positioned) 18,097 1.12 0.52
index fast full scans (full) 37 0.00 0.00
index fetch by key 12,302,782 762.03 355.64
index scans kdiixs1 839,124 51.97 24.26
leaf node 90-10 splits 429 0.03 0.01
leaf node splits 728 0.05 0.02
lob reads 19,958 1.24 0.58
lob writes 13,669 0.85 0.40
lob writes unaligned 13,663 0.85 0.39
logons cumulative 56,253 3.48 1.63
messages received 104,968 6.50 3.03
messages sent 104,968 6.50 3.03
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 36,303,429 2,248.62 1,049.44
opened cursors cumulative 928,901 57.54 26.85
parse count (failures) 114 0.01 0.00
parse count (hard) 7,093 0.44 0.21
parse count (total) 926,716 57.40 26.79
parse time cpu 15,281 0.95 0.44
parse time elapsed 17,424 1.08 0.50
physical read IO requests 84,698 5.25 2.45
physical read bytes 833,282,048 51,613.15 24,088.17
physical read total IO requests 356,960 22.11 10.32
physical read total bytes 5,260,785,152 325,850.85 152,076.58
physical read total multi block requests 8,627 0.53 0.25
physical reads 101,719 6.30 2.94
physical reads cache 2,585 0.16 0.07
physical reads cache prefetch 0 0.00 0.00
physical reads direct 99,134 6.14 2.87
physical reads direct (lob) 98,953 6.13 2.86
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 18,286 1.13 0.53
physical write bytes 307,355,648 19,037.48 8,884.91
physical write total IO requests 104,981 6.50 3.03
physical write total bytes 853,828,096 52,885.76 24,682.11
physical write total multi block requests 76,481 4.74 2.21
physical writes 37,519 2.32 1.08
physical writes direct 169 0.01 0.00
physical writes direct (lob) 47 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 37,350 2.31 1.08
physical writes non checkpoint 13,290 0.82 0.38
pinned buffers inspected 2 0.00 0.00
pinned cursors current 2 0.00 0.00
prefetch clients - default 0 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 0 0.00 0.00
process last non-idle time 16,144 1.00 0.47
queries parallelized 399 0.02 0.01
recovery blocks read 0 0.00 0.00
recursive calls 3,307,455 204.86 95.61
recursive cpu usage 48,260 2.99 1.40
redo blocks read for recovery 0 0.00 0.00
redo blocks written 221,368 13.71 6.40
redo buffer allocation retries 4 0.00 0.00
redo entries 218,789 13.55 6.32
redo log space requests 4 0.00 0.00
redo log space wait time 11 0.00 0.00
redo ordering marks 3,480 0.22 0.10
redo size 100,206,748 6,206.76 2,896.73
redo subscn max counts 5,017 0.31 0.15
redo synch time 4,299 0.27 0.12
redo synch writes 30,716 1.90 0.89
redo wastage 9,531,568 590.38 275.53
redo write broadcast ack time 1,121 0.07 0.03
redo write time 3,035 0.19 0.09
redo writer latching time 0 0.00 0.00
redo writes 37,591 2.33 1.09
rollback changes - undo records applied 76 0.00 0.00
rollbacks only - consistent read gets 64 0.00 0.00
root node splits 0 0.00 0.00
rows fetched via callback 5,775,019 357.70 166.94
session connect time 0 0.00 0.00
session cursor cache hits 484,985 30.04 14.02
session logical reads 59,854,301 3,707.35 1,730.24
shared hash latch upgrades - no wait 40,614 2.52 1.17
shared hash latch upgrades - wait 77 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 517,256 32.04 14.95
sorts (rows) 6,068,317 375.87 175.42
sql area evicted 4,645 0.29 0.13
sql area purged 113 0.01 0.00
summed dirty queue length 6 0.00 0.00
switch current to new buffer 377 0.02 0.01
table fetch by rowid 9,335,306 578.22 269.86
table fetch continued row 24,252 1.50 0.70
table scan blocks gotten 28,479,637 1,764.02 823.28
table scan rows gotten 3,552,596,862 220,046.38 102,696.99
table scans (long tables) 0 0.00 0.00
table scans (short tables) 541,074 33.51 15.64
total number of times SMON posted 3,304 0.20 0.10
transaction lock background get time 0 0.00 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 66 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 20,668,252 1,280.18 597.47
user I/O wait time 5,126 0.32 0.15
user calls 2,320,514 143.73 67.08
user commits 32,233 2.00 0.93
user rollbacks 2,360 0.15 0.07
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 208,314 12.90 6.02
write clones created in background 6 0.00 0.00
write clones created in foreground 1 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.2E+12 1.2E+12
session cursor cache count 225,028,637 225,435,068
session uga memory 7.8E+14 7.8E+14
opened cursors current 401 471
workarea memory allocated 2,877 265
logons current 1,200 1,195
session uga memory max 1.8E+13 1.8E+13
session pga memory 7.1E+11 7.1E+11

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 2 0.45

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 79,956 5 0.00 1.21 2 0 0 0.00
WCITY2_DATA 3,938 0 4.39 1.00 9,301 1 23 0.43
UNDOTBS2 2 0 0.00 1.00 4,408 0 7 0.00
SYSAUX 374 0 1.60 1.00 2,523 0 0 0.00
WCITY2_INDEX 287 0 10.49 1.00 1,201 0 38 13.16
SYSTEM 17 0 3.53 1.00 582 0 72 2.78
WCITY_GNMS 13 0 3.85 1.00 148 0 3 16.67
WCITY 72 0 0.00 1.00 42 0 0 0.00
TS_APP_DATA 4 0 0.00 1.00 44 0 0 0.00
TBS_ITS 4 0 0.00 1.00 4 0 0 0.00
TS_APP_INDEX 4 0 0.00 1.00 2 0 0 0.00
WCITY_BC 4 0 0.00 1.00 2 0 0 0.00
HQDB_DATA 2 0 0.00 1.00 2 0 0 0.00
INMS01 2 0 0.00 1.00 2 0 0 0.00
ISS 2 0 0.00 1.00 2 0 0 0.00
NETM_DATA 2 0 0.00 1.00 2 0 0 0.00
OMAE_DATA 2 0 0.00 1.00 2 0 0 0.00
OMP01 2 0 0.00 1.00 2 0 0 0.00
OMS01 2 0 0.00 1.00 2 0 0 0.00
REPORT_DATA 2 0 0.00 1.00 2 0 0 0.00
SSB_DATA_JWF 2 0 0.00 1.00 2 0 0 0.00
UNDOTBS1 2 0 0.00 1.00 2 0 2 0.00
ZXDBM_DATA 2 0 0.00 1.00 2 0 0 0.00
ZXINJOS_DATA 2 0 0.00 1.00 2 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
HQDB_DATA +DATA/acsdb/datafile/hqdb_data.296.762368267 2 0 0.00 1.00 2 0 0 0.00
INMS01 +DATA/acsdb/datafile/inms01.279.762122141 2 0 0.00 1.00 2 0 0 0.00
ISS +DATA/acsdb/datafile/iss01.bdf 2 0 0.00 1.00 2 0 0 0.00
NETM_DATA +DATA/acsdb/datafile/netm_data.295.762368247 2 0 0.00 1.00 2 0 0 0.00
OMAE_DATA +DATA/acsdb/datafile/omae_data.297.762368277 2 0 0.00 1.00 2 0 0 0.00
OMP01 +DATA/acsdb/datafile/omp01.280.762122149 2 0 0.00 1.00 2 0 0 0.00
OMS01 +DATA/acsdb/datafile/oms01.281.762122175 2 0 0.00 1.00 2 0 0 0.00
REPORT_DATA +DATA/acsdb/datafile/report_data.291.762359943 2 0 0.00 1.00 2 0 0 0.00
SSB_DATA_JWF +DATA/acsdb/datafile/ssb_data_jwf.292.762359949 2 0 0.00 1.00 2 0 0 0.00
SYSAUX +DATA/acsdb/datafile/sysaux.257.762113905 374 0 1.60 1.00 2,523 0 0 0.00
SYSTEM +DATA/acsdb/datafile/system.1634.787070407 4 0 0.00 1.00 75 0 0 0.00
SYSTEM +DATA/acsdb/datafile/system.256.762113905 13 0 4.62 1.00 507 0 72 2.78
TBS_ITS +DATA/acsdb/datafile/tbs_its.305.762449727 2 0 0.00 1.00 2 0 0 0.00
TBS_ITS +DATA/acsdb/datafile/tbs_its01.dbf 2 0 0.00 1.00 2 0 0 0.00
TS_APP_DATA +DATA/acsdb/datafile/ts_app_data01.dbf 4 0 0.00 1.00 44 0 0 0.00
TS_APP_INDEX +DATA/acsdb/datafile/ts_app_index01.dbf 4 0 0.00 1.00 2 0 0 0.00
UNDOTBS1 +DATA/acsdb/datafile/undotbs1.258.762113905 2 0 0.00 1.00 2 0 2 0.00
UNDOTBS2 +DATA/acsdb/datafile/undotbs2.269.762113985 2 0 0.00 1.00 4,408 0 7 0.00
USERS +DATA/acsdb/datafile/users.259.762113905 79,956 5 0.00 1.21 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.1031.787073439 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.1146.787070545 4 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.1297.787074783 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.2249.787070711 4 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.287.762346721 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.2995.787070437 4 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.3189.787070649 4 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.3202.787070683 4 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.3261.787070351 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.370.787070423 4 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.4594.787070635 4 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.4822.787075205 2 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.5264.787070521 4 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.5495.787070583 4 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.5810.787070597 4 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity.6430.787070489 4 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity1.dbf 4 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity2.dbf 4 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity3.dbf 4 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity4.dbf 4 0 0.00 1.00 2 0 0 0.00
WCITY +DATA/acsdb/datafile/wcity5.dbf 2 0 0.00 1.00 2 0 0 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data01.dbf 229 0 1.09 1.00 183 0 1 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data02.dbf 137 0 1.53 1.00 201 0 0 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data03.dbf 137 0 1.17 1.00 341 0 2 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data04.dbf 903 0 0.17 1.00 37 0 0 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data05.dbf 610 0 0.51 1.00 234 0 0 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data06.dbf 133 0 5.94 1.02 1,028 0 15 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data07.dbf 218 0 6.97 1.00 1,634 0 4 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data08.dbf 644 0 8.82 1.00 2,679 0 0 0.00
WCITY2_DATA +DATA/acsdb/datafile/wcity2_data09.dbf 927 0 8.87 1.00 2,964 0 1 10.00
WCITY2_INDEX +DATA/acsdb/datafile/wcity2_index01.dbf 207 0 8.16 1.00 617 0 13 36.92
WCITY2_INDEX +DATA/acsdb/datafile/wcity2_index02.dbf 80 0 16.50 1.00 584 0 25 0.80
WCITY_BC +DATA/acsdb/datafile/wcity_bc01.dbf 4 0 0.00 1.00 2 0 0 0.00
WCITY_GNMS +DATA/acsdb/datafile/wcity_gnms01.dbf 9 0 4.44 1.00 123 0 3 16.67
WCITY_GNMS +DATA/acsdb/datafile/wcity_gnms02.dbf 4 0 2.50 1.00 25 0 0 0.00
ZXDBM_DATA +DATA/acsdb/datafile/zxdbm_data.290.762359941 2 0 0.00 1.00 2 0 0 0.00
ZXINJOS_DATA +DATA/acsdb/datafile/zxinjos_data.289.762359941 2 0 0.00 1.00 2 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 3,513,861 100 59,761,969 2,585 37,350 0 0 145


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 12 11377 92643 99888 184320 99888  
E 0 1 806 8686 28349 184320 28349  

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 37.15 1,075,494,610
D 5,856 0.20 701,622 1.50 43,467,262
D 8,784 0.30 1,052,433 1.18 34,287,459
D 11,712 0.40 1,403,244 1.11 32,207,291
D 14,640 0.50 1,754,055 1.06 30,687,546
D 17,568 0.60 2,104,866 1.04 30,113,723
D 20,496 0.70 2,455,677 1.03 29,953,831
D 23,424 0.80 2,806,488 1.03 29,684,050
D 26,352 0.90 3,157,299 1.01 29,337,400
D 29,280 1.00 3,508,110 1.00 28,962,029
D 29,328 1.00 3,513,861 1.00 28,948,186
D 32,208 1.10 3,858,921 0.97 28,086,777
D 35,136 1.20 4,209,732 0.96 27,860,824
D 38,064 1.30 4,560,543 0.95 27,637,895
D 40,992 1.40 4,911,354 0.95 27,540,672
D 43,920 1.50 5,262,165 0.94 27,274,843
D 46,848 1.60 5,612,976 0.93 26,963,502
D 49,776 1.70 5,963,787 0.92 26,648,576
D 52,704 1.80 6,314,598 0.84 24,193,350
D 55,632 1.90 6,665,409 0.82 23,729,199
D 58,560 2.00 7,016,220 0.81 23,392,429

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 9,984 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,644 939.28 4.93 0.53 100.00 0.00 823,700
E 8,044 6,616 943.51 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 198,967 198,967 0 0
64K 128K 274 274 0 0
128K 256K 346 346 0 0
256K 512K 136 136 0 0
512K 1024K 3,758 3,758 0 0
1M 2M 4,787 4,787 0 0
2M 4M 16 16 0 0
4M 8M 32 32 0 0
8M 16M 8 8 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
1,006 0.13 2,912,568.92 3,432.18 100.00 0
2,011 0.25 2,912,568.92 3,162.87 100.00 0
4,022 0.50 2,912,568.92 2,080.19 100.00 0
6,033 0.75 2,912,568.92 2,080.19 100.00 0
8,044 1.00 2,912,568.92 1,231.86 100.00 0
9,653 1.20 2,912,568.92 0.00 100.00 0
11,262 1.40 2,912,568.92 0.00 100.00 0
12,870 1.60 2,912,568.92 0.00 100.00 0
14,479 1.80 2,912,568.92 0.00 100.00 0
16,088 2.00 2,912,568.92 0.00 100.00 0
24,132 3.00 2,912,568.92 0.00 100.00 0
32,176 4.00 2,912,568.92 0.00 100.00 0
48,264 6.00 2,912,568.92 0.00 100.00 0
64,352 8.00 2,912,568.92 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 385 30,127 15,632,930 1.00 79,523 1.08 682,642
2,352 0.70 710 48,289 15,637,018 1.00 75,435 1.02 683,033
2,688 0.80 1,042 65,626 15,638,058 1.00 74,395 1.01 683,181
3,024 0.90 1,377 80,954 15,638,505 1.00 73,948 1.00 683,256
3,360 1.00 1,711 98,270 15,638,763 1.00 73,690 1.00 683,309
3,696 1.10 2,045 116,107 15,638,941 1.00 73,512 1.00 683,350
4,032 1.20 2,380 134,556 15,639,092 1.00 73,361 1.00 683,385
4,368 1.30 2,715 153,483 15,639,213 1.00 73,240 0.99 683,415
4,704 1.40 3,050 172,514 15,639,318 1.00 73,135 0.99 683,442
5,040 1.50 3,385 191,950 15,639,415 1.00 73,038 0.99 683,466
5,376 1.60 3,720 211,338 15,639,496 1.00 72,957 0.99 683,487
5,712 1.70 4,055 228,890 15,639,573 1.00 72,880 0.99 683,506
6,048 1.80 4,390 245,536 15,639,642 1.00 72,811 0.99 683,524
6,384 1.90 4,725 264,033 15,639,703 1.00 72,750 0.99 683,540
6,720 2.00 5,060 280,762 15,639,755 1.00 72,698 0.99 683,554

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
8,192 0.25 5,403,173 43,468,581
16,384 0.50 5,366,727 30,687,961
24,576 0.75 5,362,439 29,952,678
32,768 1.00 5,359,759 28,948,176
40,960 1.25 5,356,007 27,636,824
49,152 1.50 5,354,399 26,962,331
57,344 1.75 5,353,863 24,191,991
65,536 2.00 5,353,863 23,393,021

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
16 0.50 0 0 0 0
32 1.00 0 0 0 0
48 1.50 0 0 0 0
64 2.00 0 0 0 0
80 2.50 0 0 0 0
96 3.00 0 0 0 0
112 3.50 0 0 0 0
128 4.00 0 0 0 0
144 4.50 0 0 0 0
160 5.00 0 0 0 0
176 5.50 0 0 0 0
192 6.00 0 0 0 0
208 6.50 0 0 0 0
224 7.00 0 0 0 0
240 7.50 0 0 0 0
256 8.00 0 0 0 0
272 8.50 0 0 0 0
288 9.00 0 0 0 0
304 9.50 0 0 0 0
320 10.00 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 120 1 6
segment header 9 0 0
undo header 9 0 0
1st level bmb 6 0 0
2nd level bmb 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
WF-AWR Flush 193 50 143 166 533 3,211.39
HW-Segment High Water Mark 10,508 10,508 0 5,590 6 1.00
TX-Transaction 41,839 41,839 0 11 2 224.55
TX-Transaction (index contention) 53 53 0 33 1 25.76
PS-PX Process Reservation 2,819 2,818 1 895 1 0.74
TM-DML 46,923 46,923 0 644 0 0.54
US-Undo Segment 701 701 0 681 0 0.34
CF-Controlfile Transaction 37,953 37,953 0 177 0 1.02
FB-Format Block 351 351 0 166 0 0.54
SQ-Sequence Cache 6,870 6,870 0 7 0 8.57
TD-KTF map table enqueue (KTF dump entries) 53 53 0 53 0 0.75
TA-Instance Undo 106 106 0 54 0 0.37
JQ-Job Queue 633 633 0 24 0 0.83
TT-Tablespace 900 900 0 13 0 0.77
DR-Distributed Recovery 9 9 0 9 0 1.11
JS-Job Scheduler (job run lock - synchronize) 9 9 0 9 0 1.11
RS-Reclaimable Space (prevent aging list update) 18 18 0 1 0 10.00
TX-Transaction (allocate ITL entry) 12 12 0 11 0 0.00
AF-Advisor Framework (task serialization) 14 14 0 1 0 0.00
CT-Block Change Tracking (state) 21 21 0 1 0 0.00
PW-Buffer Cache PreWarm (flush prewarm buffers) 1 0 1 1 0 0.00
TX-Transaction (row lock contention) 1 1 0 1 0 0.00
WL-Being Written Redo Log 2 2 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
5 5.34 41,474 1,011 5 75/75 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
07-3ÔÂ 15:19 139 1,953 726 3 75 0/0 0/0/0/0/0/0
07-3ÔÂ 15:09 150 1,617 559 5 75 0/0 0/0/0/0/0/0
07-3ÔÂ 14:59 90 1,546 0 4 75 0/0 0/0/0/0/0/0
07-3ÔÂ 14:49 123 1,722 0 5 75 0/0 0/0/0/0/0/0
07-3ÔÂ 14:39 160 1,831 0 4 75 0/0 0/0/0/0/0/0
07-3ÔÂ 14:29 125 1,746 1,011 3 75 0/0 0/0/0/0/0/0
07-3ÔÂ 14:19 119 1,835 408 3 75 0/0 0/0/0/0/0/0
07-3ÔÂ 14:09 104 1,045 407 4 75 0/0 0/0/0/0/0/0
07-3ÔÂ 13:59 173 2,055 0 3 75 0/0 0/0/0/0/0/0
07-3ÔÂ 13:49 172 2,096 998 3 75 0/0 0/0/0/0/0/0
07-3ÔÂ 13:39 177 2,192 741 3 75 0/0 0/0/0/0/0/0
07-3ÔÂ 13:29 160 1,980 738 3 75 0/0 0/0/0/0/0/0
07-3ÔÂ 13:19 97 1,695 0 3 75 0/0 0/0/0/0/0/0
07-3ÔÂ 13:09 151 1,812 393 4 75 0/0 0/0/0/0/0/0
07-3ÔÂ 12:59 138 1,722 0 4 75 0/0 0/0/0/0/0/0
07-3ÔÂ 12:49 100 1,561 387 4 75 0/0 0/0/0/0/0/0
07-3ÔÂ 12:39 113 1,348 387 3 75 0/0 0/0/0/0/0/0
07-3ÔÂ 12:29 78 1,277 984 3 75 0/0 0/0/0/0/0/0
07-3ÔÂ 12:19 172 2,197 382 3 75 0/0 0/0/0/0/0/0
07-3ÔÂ 12:09 150 1,701 0 2 75 0/0 0/0/0/0/0/0
07-3ÔÂ 11:59 153 1,495 0 3 75 0/0 0/0/0/0/0/0
07-3ÔÂ 11:49 88 1,392 258 3 75 0/0 0/0/0/0/0/0
07-3ÔÂ 11:39 31 554 0 2 75 0/0 0/0/0/0/0/0
07-3ÔÂ 11:29 77 750 361 2 75 0/0 0/0/0/0/0/0
07-3ÔÂ 11:19 32 675 370 3 75 0/0 0/0/0/0/0/0
07-3ÔÂ 11:09 44 646 448 3 75 0/0 0/0/0/0/0/0
07-3ÔÂ 10:59 2,223 1,031 0 3 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 426 0.00   0 0  
ASM db client latch 11,357 0.00   0 0  
ASM map headers 1,622 0.00   0 0  
ASM map load waiting list 588 0.00   0 0  
ASM map operation freelist 11,792 0.00   0 0  
ASM map operation hash table 2,639,510 0.01 0.00 0 0  
ASM network background latch 8,532 0.00   0 0  
AWR Alerted Metric Element list 157,360 0.00   0 0  
Consistent RBA 37,586 0.00   0 0  
FAL request queue 327 0.00   0 0  
FAL subheap alocation 327 0.00   0 0  
FIB s.o chain latch 108 0.00   0 0  
FOB s.o list latch 58,863 0.03 0.00 0 0  
JS broadcast add buf latch 3,692 0.00   0 0  
JS broadcast drop buf latch 3,692 0.00   0 0  
JS broadcast load blnc latch 3,220 0.00   0 0  
JS mem alloc latch 24 0.00   0 0  
JS queue access latch 24 0.00   0 0  
JS queue state obj latch 116,470 0.00   0 0  
JS slv state obj latch 2,271,423 0.01 0.00 0 0  
KCL gc element parent latch 244,325 0.01 0.25 0 670 0.00
KFK SGA context latch 12,616 0.00   0 0  
KFMD SGA 8,562 0.00   0 0  
KJC message pool free list 86,416 0.10 0.00 0 3,785 0.16
KJCT flow control latch 406,010 0.06 0.01 0 0  
KMG MMAN ready and startup request latch 5,379 0.00   0 0  
KSXR large replies 1 0.00   0 0  
KTF sga latch 106 0.00   0 4,478 0.00
KWQMN job cache list latch 5,213 0.12 0.50 0 0  
KWQP Prop Status 4 0.00   0 0  
MQL Tracking Latch 0     0 322 0.00
Memory Management Latch 0     0 5,379 0.00
OS process 168,348 0.00   0 0  
OS process allocation 117,531 0.11 0.20 6 0  
OS process: request allocation 110,421 0.16 0.35 25 0  
PL/SQL warning settings 58,870 0.00   0 0  
SGA IO buffer pool latch 116 0.00   0 116 0.00
SQL memory manager latch 2 0.00   0 5,373 0.00
SQL memory manager workarea list latch 497,545 0.00   0 0  
Shared B-Tree 575 0.00   0 0  
active checkpoint queue latch 35,575 0.00   0 0  
active service list 315,339 0.58 0.09 3 16,871 0.01
alert log latch 4 0.00   0 0  
archive control 580 0.00   0 0  
archive process latch 6,031 0.00   0 0  
begin backup scn array 47 0.00   0 0  
business card 798 0.00   0 0  
cache buffer handles 7,556 0.05 0.00 0 0  
cache buffers chains 98,975,850 0.09 0.03 34 103,684 0.02
cache buffers lru chain 95,442 0.00 0.50 0 111,445 0.01
channel handle pool latch 110,517 0.02 0.00 0 0  
channel operations parent latch 1,278,784 0.02 0.03 0 0  
checkpoint queue latch 1,981,208 0.00 0.00 0 36,395 0.00
client/application info 290,733 0.00   0 0  
commit callback allocation 498 0.00   0 0  
compile environment latch 56,317 0.00   0 0  
dml lock allocation 94,563 0.00 0.00 0 0  
dummy allocation 112,639 0.08 0.00 0 0  
enqueue hash chains 868,522 0.00 0.00 0 1,297 0.00
enqueues 951,932 0.01 0.03 0 0  
error message lists 1,941 0.00   0 0  
event group latch 55,170 0.00   0 0  
file cache latch 4,993 0.00   0 0  
gcs opaque info freelist 56,022 0.00 0.00 0 0  
gcs partitioned table hash 356,857 0.00   0 2,160 0.00
gcs remastering latch 1,974 0.00   0 0  
gcs resource freelist 5,365 0.02 0.00 0 7,447 0.00
gcs resource hash 252,127 0.03 0.05 1 27 0.00
gcs resource scan list 54 0.00   0 0  
gcs shadows freelist 17,637 0.00   0 26,673 0.00
ges caches resource lists 72,735 0.02 0.00 0 190,786 0.00
ges deadlock list 242 0.00   0 0  
ges domain table 229,360 0.00   0 0  
ges enqueue table freelist 432,594 0.00   0 0  
ges group table 319,186 0.00 0.00 0 0  
ges process hash list 228,744 0.00   0 0  
ges process parent latch 870,151 0.00   0 0  
ges process table freelist 110,421 0.03 0.03 0 0  
ges resource hash list 668,684 0.11 0.03 0 23,448 0.43
ges resource scan list 3,132 0.00   0 0  
ges resource table freelist 15,364 0.00   0 2 0.00
ges timeout list 7,001 0.00   0 14,394 0.00
global KZLD latch for mem in SGA 54,212 0.00   0 0  
global hanganlyze operation 2 0.00   0 0  
global tx hash mapping 513 0.00   0 0  
hash table column usage latch 939 0.00   0 189,713 0.00
hash table modification latch 258 0.00   0 0  
interrupt manipulation 3,492 0.00   0 0  
job workq parent latch 0     0 1,284 0.08
job_queue_processes parameter latch 882 0.00   0 0  
kks stats 34,895 0.00   0 0  
kmcptab latch 1 0.00   0 0  
kmcpvec latch 0     0 1 0.00
kokc descriptor allocation latch 308 0.00   0 0  
ksuosstats global area 1,080 0.00   0 0  
ksv instance 2 0.00   0 0  
ktm global data 3,324 0.00   0 0  
kwqbsn:qsga 573 0.00   0 0  
lgwr LWN SCN 37,901 0.00   0 0  
library cache 3,393,578 0.16 0.01 7 18,369 0.01
library cache load lock 220 0.00   0 0  
library cache lock 5,555,487 0.50 0.01 17 0  
library cache lock allocation 157,182 0.01 0.18 0 0  
library cache pin 933,802 0.01 0.00 0 1 0.00
library cache pin allocation 1,460 0.00   0 0  
list of block allocation 10,002 0.00   0 0  
loader state object freelist 40,074 0.02 0.00 0 0  
logminer context allocation 2 0.00   0 0  
message pool operations parent latch 5,240 0.00   0 0  
messages 912,850 0.02 0.00 0 0  
mostly latch-free SCN 38,068 0.08 0.03 0 0  
msg queue 244 0.00   0 244 0.00
multiblock read objects 5,350 0.00   0 0  
name-service memory objects 54,614 0.01 0.00 0 0  
name-service namespace bucket 165,548 0.00   0 0  
name-service pending queue 32,542 0.00   0 0  
name-service request 256 1.95 0.00 0 0  
name-service request queue 198,942 0.00 0.00 0 0  
ncodef allocation latch 705 0.00   0 0  
object queue header heap 100,802 0.00   0 1,056 0.00
object queue header operation 274,744 0.00 0.00 0 0  
object stats modification 5 0.00   0 0  
parallel query alloc buffer 10,256 0.00   0 0  
parallel query stats 1,631 0.00   0 0  
parallel txn reco latch 72,030 0.00   0 0  
parameter list 489,952 0.02 0.00 0 0  
parameter table management 112,831 0.00   0 0  
post/wait queue 77,816 0.02 0.00 0 33,028 0.00
process allocation 245,764 1.02 1.73 47 55,026 0.26
process group creation 110,420 0.05 0.02 0 0  
process queue 4,423 0.00   0 0  
process queue reference 75,169 0.01 0.00 0 7,142 0.00
qmn task queue latch 3,517 15.81 0.00 0 0  
query server freelists 3,671 0.14 0.00 0 0  
query server process 0     0 64 0.00
queued dump request 80,633 0.00   0 0  
redo allocation 113,541 0.03 0.00 0 218,723 0.03
redo copy 0     0 218,745 0.05
redo writing 159,704 0.00 0.00 0 0  
resmgr group change latch 57,497 0.00   0 0  
resmgr:active threads 112,292 0.00   0 0  
resmgr:actses change group 55,815 0.00   0 0  
resmgr:free threads list 112,290 0.31 0.08 4 0  
resmgr:resource group CPU method 55,826 0.00 0.00 0 0  
resmgr:schema config 2 0.00   0 0  
row cache objects 6,008,028 0.10 0.00 4 4,296 7.17
rules engine aggregate statistics 21 0.00   0 0  
rules engine rule set statistics 242 0.00   0 0  
segmented array pool 104 0.00   0 0  
sequence cache 681,141 0.10 0.01 0 0  
session allocation 1,158,991 1.44 0.07 4 0  
session idle bit 5,107,141 0.00 0.00 0 0  
session state list latch 112,666 0.02 0.00 0 0  
session switching 276,955 0.06 0.04 0 0  
session timer 14,800 0.00   0 0  
shared pool 1,866,539 0.43 0.03 25 0  
shared pool simulator 40,059 0.00 0.00 0 0  
simulator hash latch 3,479,169 0.00 0.00 0 0  
simulator lru latch 0     0 3,478,218 0.20
slave class 932 0.00   0 0  
slave class create 6,329 0.05 1.00 0 0  
sort extent pool 4,177 0.00   0 0  
state object free list 4 0.00   0 0  
statistics aggregation 1,344 0.00   0 0  
temporary table state object allocation 1 0.00   0 0  
threshold alerts latch 2,932 0.00   0 0  
transaction allocation 11,090 0.00   0 0  
transaction branch allocation 15,166 0.00   0 0  
undo global data 283,561 0.00 0.00 0 0  
user lock 218,509 1.67 0.01 3 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 98,975,850 88,878 2,801 86,180 0 0 0
library cache lock 5,555,487 27,870 141 27,747 0 0 0
session allocation 1,158,991 16,672 1,153 15,595 0 0 0
shared pool 1,866,539 8,060 204 7,886 0 0 0
row cache objects 6,008,028 5,792 28 5,771 0 0 0
library cache 3,393,578 5,549 82 5,479 0 0 0
user lock 218,509 3,658 33 3,633 0 0 0
process allocation 245,764 2,511 4,353 246 0 0 0
active service list 315,339 1,834 161 1,681 0 0 0
ges resource hash list 668,684 768 22 746 0 0 0
sequence cache 681,141 656 5 651 0 0 0
qmn task queue latch 3,517 556 1 555 0 0 0
resmgr:free threads list 112,290 351 28 327 0 0 0
KJCT flow control latch 406,010 259 2 257 0 0 0
channel operations parent latch 1,278,784 249 8 243 0 0 0
OS process: request allocation 110,421 177 62 136 0 0 0
session switching 276,955 166 6 162 0 0 0
OS process allocation 117,531 134 27 111 0 0 0
enqueues 951,932 111 3 108 0 0 0
gcs resource hash 252,127 80 4 77 0 0 0
process group creation 110,420 52 1 51 0 0 0
ges process table freelist 110,421 34 1 33 0 0 0
mostly latch-free SCN 38,068 32 1 31 0 0 0
KCL gc element parent latch 244,325 24 6 19 0 0 0
library cache lock allocation 157,182 11 2 10 0 0 0
KWQMN job cache list latch 5,213 6 3 3 0 0 0
cache buffers lru chain 95,442 4 2 2 0 0 0
slave class create 6,329 3 3 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KCL gc element parent latch kclchkping 0 4 0
KCL gc element parent latch kclpto 0 1 4
KCL gc element parent latch kclpto_1 0 1 0
KJCT flow control latch kjcts_sqenq: queue a message 0 2 1
KWQMN job cache list latch kwqmnprsc: loop 0 3 0
OS process allocation kso_new_process:2 0 17 16
OS process allocation kso_delete_process:1 0 10 11
OS process: request allocation kso_new_process 0 34 19
OS process: request allocation ksoreqholder_delete 0 28 43
active service list kswslogon: session logout 0 979 968
active service list kswslogon: session login 0 20 7
active service list kswsgsnp: get service name ptr 0 7 26
active service list kswssyis: find service entry 1 0 3 3
active service list kswsclstabc: scan list to return rows 0 1 1
cache buffers chains kcbgtcr: kslbegin excl 0 13,033 4,905
cache buffers chains kcbrls: kslbegin 0 291 8,555
cache buffers chains kcbgtcr: fast path 0 145 8
cache buffers chains kcbzwb 0 21 10
cache buffers chains kclbla 0 15 0
cache buffers chains kcbgcur: kslbegin 0 12 7
cache buffers chains kcbget: pin buffer 0 7 5
cache buffers chains kclwrt 0 4 0
cache buffers chains kcbchg: kslbegin: call CR func 0 3 4
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1 2
cache buffers lru chain kcbzgb: posted for free bufs 0 1 1
cache buffers lru chain kcbzgws 0 1 0
channel handle pool latch ksrchdelete() 0 1 1
channel operations parent latch ksrchdelete() 0 24 23
cost function kzulrl 0 24 27
cost function kzulgt: find user res 0 9 6
enqueues ksqies 0 3 3
event range base latch No latch 0 7 8
gcs resource hash kjbassume 0 2 0
gcs resource hash kjblocalfile_nolock 0 2 0
ges process table freelist kjpfr: free process 0 1 1
ges resource hash list kjakcai: search for resp by resname 0 19 0
ges resource hash list kjrmas1: lookup master node 0 2 0
ges resource hash list kjlrlr: remove lock from resource queue 0 1 19
lgwr LWN SCN kcs023 0 1 0
library cache kglhdgn: child: 0 27 39
library cache kgldte: child 0 0 26 30
library cache kglLockCursor 0 13 3
library cache kglobpn: child: 0 5 7
library cache kglpndl: child: after processing 0 2 0
library cache kglpndl: child: before processing 0 2 0
library cache lock kgllkdl: child: cleanup 0 121 115
library cache lock kgllkal: child: multiinstance 0 14 19
library cache lock allocation kgllkget 0 2 2
object queue header operation kcbo_switch_mq_bg 0 2 0
process allocation ksuapc 0 2,085 1,614
process allocation ksucrp 0 1,708 0
process allocation ksudlp 0 463 1,301
process allocation ksufap: active procs 0 99 1,440
process group creation ksupgprem 0 1 1
resmgr:free threads list kgskthrsod 0 24 21
resmgr:free threads list kgskthrcreate 0 4 7
row cache objects kqrpre: find obj 0 15 23
row cache objects kqreqd: reget 0 7 0
row cache objects kqrbip 0 2 0
row cache objects kqreqd 0 2 3
row cache objects kqrso 0 2 0
sequence cache kdnnxt: cached seq 0 4 0
sequence cache kdnssd 0 1 0
session allocation ksuxds: KSUSFCLC not set 0 881 305
session allocation ksudlp 0 117 386
session allocation ksucri 0 96 300
session allocation ksuxds: not user session 0 43 155
session allocation ksufap: active sessions 0 13 0
session allocation ksucrp 0 3 7
session switching kskexeall 0 6 6
shared pool kghalo 0 95 78
shared pool kghfre 0 83 112
shared pool kghfrunp: alloc: session dur 0 17 0
shared pool kghfrunp: clatch: nowait 0 7 0
shared pool kghupr1 0 7 12
shared pool kghfrunp: alloc: cursor dur 0 2 0
slave class create ksvcreate 0 3 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
WCITY2 WCITY2_DATA TB_ARTICLE_CONTENT_RELATION   TABLE 8,490,720 14.19
WCITY2 WCITY2_INDEX PK_TB_ARTICLE_DESC   INDEX 8,358,736 13.97
WCITY2 WCITY2_DATA TB_ARTICLE_DESC   TABLE 6,426,080 10.74
SYS SYSTEM I_OBJ2   INDEX 5,515,856 9.22
WCITY2 WCITY2_INDEX PK_TB_ARTICLE_CONTENT   INDEX 4,927,504 8.23

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 740 0.73
WCITY2 WCITY2_DATA TB_AUTH_LOG   TABLE 594 0.58
WCITY2 WCITY2_DATA INDEX_LOGIN_LOG_CA   INDEX 150 0.15
WCITY2 WCITY2_DATA SYS_LOB0000126366C00002$$   LOB 110 0.11
WCITY2 WCITY2_INDEX PK_TB_AUTH_LOG2   INDEX 107 0.11

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
WCITY2 WCITY2_INDEX IDX_TB_ACCOUNT_INTERFACE_LOG_2   INDEX 18 33.33
WCITY2 WCITY2_INDEX IDX_TB_AUTH_LOG_3   INDEX 17 31.48
WCITY2 WCITY2_INDEX ACCOUNT_INTERFACE_LOG_ID   INDEX 8 14.81
WCITY2 WCITY2_INDEX PK_TB_AUTH_LOG2   INDEX 8 14.81
WCITY2 WCITY2_DATA TB_ACCESS_TOKEN   TABLE 2 3.70

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 6 50.00
WCITY2 WCITY2_INDEX IDX_TB_ACCOUNT_INTERFACE_LOG_2   INDEX 4 33.33
WCITY2 WCITY2_INDEX ACCOUNT_INTERFACE_LOG_ID   INDEX 1 8.33
WCITY2 WCITY2_INDEX PK_TB_ACCESS_TOKEN   INDEX 1 8.33

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SYS SYSTEM SEQ$   TABLE 16 47.06
WCITY2 WCITY2_DATA TB_USER_OPER_LOG P_20130307 TABLE PARTITION 7 20.59
WCITY2 WCITY2_INDEX PK_TB_AUTH_LOG2   INDEX 5 14.71
WCITY2 WCITY2_INDEX ACCOUNT_INTERFACE_LOG_ID   INDEX 1 2.94
WCITY2 WCITY2_INDEX IDX_TB_ACCOUNT_INTERFACE_LOG_2   INDEX 1 2.94

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
SYS SYSTEM USER$   TABLE 47 48.45
WCITY2 WCITY2_INDEX IDX_TB_AUTH_LOG_3   INDEX 12 12.37
WCITY2 WCITY2_INDEX PK_TB_AUTH_LOG2   INDEX 11 11.34
WCITY2 WCITY2_DATA TB_USER_OPER_LOG P_20130307 TABLE PARTITION 9 9.28
SYS SYSTEM SEQ$   TABLE 5 5.15

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 2,107 29.64
SYS SYSTEM JOB$   TABLE 930 13.08
SYS SYSTEM SEQ$   TABLE 899 12.65
WCITY2 WCITY2_DATA TB_PORTAL_USER   TABLE 259 3.64
WCITY2 WCITY2_INDEX INDEX_TB_P_U_MOBILE   INDEX 229 3.22

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
WCITY2 WCITY2_INDEX IDX_TB_AUTH_LOG_3   INDEX 1,901 16.42
WCITY2 WCITY2_INDEX PK_TB_AUTH_LOG2   INDEX 1,893 16.35
WCITY2 WCITY2_INDEX IDX_TB_ACCOUNT_INTERFACE_LOG_2   INDEX 1,717 14.83
WCITY2 WCITY2_INDEX ACCOUNT_INTERFACE_LOG_ID   INDEX 1,679 14.50
SYS SYSTEM SEQ$   TABLE 1,290 11.14

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 284 0.00 0   3 1
dc_database_links 109,643 0.00 0   0 4
dc_global_oids 5,096 0.00 0   0 97
dc_histogram_data 189,887 0.07 0   0 2,400
dc_histogram_defs 54,915 0.46 0   0 2,944
dc_object_ids 244,239 0.02 0   0 1,239
dc_objects 77,299 0.11 0   4 762
dc_profiles 54,853 0.00 0   0 1
dc_rollback_segments 110,552 0.00 0   0 688
dc_segments 78,581 0.76 0   24 4,364
dc_sequences 6,863 17.53 0   6,863 19
dc_tablespace_quotas 21 57.14 0   21 0
dc_tablespaces 84,292 0.00 0   0 25
dc_usernames 220,832 0.00 0   0 52
dc_users 1,149,364 0.00 0   0 73
outstanding_alerts 1,328 94.28 0   21 4

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 6 0 0
dc_histogram_defs 250 0 1,423
dc_object_ids 41 0 515
dc_objects 91 5 262
dc_segments 734 22 42
dc_sequences 13,714 1,198 0
dc_tablespace_quotas 42 13 1
dc_usernames 1 0 1
outstanding_alerts 2,623 1,243 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 4,413 0.00 9,273 0.00 0 0
CLUSTER 6 0.00 8 0.00 0 0
INDEX 23 26.09 83 7.23 0 0
JAVA DATA 4 75.00 4 75.00 0 0
JAVA RESOURCE 4 75.00 4 75.00 0 0
JAVA SOURCE 4 75.00 4 75.00 0 0
SQL AREA 442,926 2.90 1,420,605 1.45 629 1
TABLE/PROCEDURE 11,420 0.11 362,509 0.03 51 0
TRIGGER 252 1.19 777 0.39 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 8 0 1 0 0
INDEX 83 6 6 3 0
JAVA DATA 4 3 1 0 0
JAVA RESOURCE 4 3 1 0 0
JAVA SOURCE 4 3 0 0 0
TABLE/PROCEDURE 36,483 43 44 34 0
TRIGGER 4 3 2 0 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 859.42   0.68 1.37 21 21 1,267 1,267
  Freeable 71.75 0.00 1.49 2.96 21   48 48
  SQL 4.74 3.90 0.00 0.08 3 12 1,175 296
  PL/SQL 3.02 0.82 0.00 0.00 0 0 1,265 1,201
E Other 866.02   0.72 1.42 21 21 1,198 1,198
  Freeable 73.75 0.00 1.34 2.79 21   55 55
  PL/SQL 2.55 0.40 0.00 0.00 0 0 1,196 1,196
  SQL 2.28 1.36 0.00 0.01 0 5 1,162 377

Back to Memory Statistics
Back to Top

SGA Memory Summary

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

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 32.00 32.00 0.00
large ASM map operations hashta 0.38 0.38 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.60 14.60 0.00
shared ASH buffers 50.00 50.00 0.00
shared CCursor 131.69 141.09 7.13
shared PCursor 103.94 112.03 7.78
shared db_block_hash_buckets 180.00 180.00 0.00
shared free memory 638.01 573.10 -10.17
shared gcs resources 690.04 690.04 0.00
shared gcs shadows 370.55 370.55 0.00
shared kglsim object batch 50.77 50.77 0.00
shared library cache 88.90 90.81 2.15
shared sql area 664.90 713.41 7.30
streams free memory 32.00 32.00 0.00
  buffer_cache 29,328.00 29,328.00 0.00
  fixed_sga 2.06 2.06 0.00
  log_buffer 13.94 13.94 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Slaves 3,237,507 176,452 0
QMON Coordinator 60,991 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 21 0 0 1 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 1,347,973 3,979,876 4005095 4005095
ges_procs 1,198 1,657 2001 2001
processes 1,199 1,659 2000 2000
sessions 1,212 1,989 2205 2205


Back to Top

init.ora Parameters

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


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 33,114 2.05 0.96
acks for commit broadcast(logical) 33,298 2.06 0.96
broadcast msgs on commit(actual) 37,577 2.33 1.09
broadcast msgs on commit(logical) 37,591 2.33 1.09
broadcast msgs on commit(wasted) 871 0.05 0.03
broadcast on commit wait time(ms) 8,738 0.54 0.25
broadcast on commit waits 35,477 2.20 1.03
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 1 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 21,142 1.31 0.61
gcs ast xid 1 0.00 0.00
gcs blocked converts 14,068 0.87 0.41
gcs blocked cr converts 7,308 0.45 0.21
gcs compatible basts 5 0.00 0.00
gcs compatible cr basts (global) 555 0.03 0.02
gcs compatible cr basts (local) 14,213 0.88 0.41
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,364 0.08 0.04
gcs dbwr write request msgs 1,295 0.08 0.04
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 202 0.01 0.01
gcs immediate (null) converts 10,794 0.67 0.31
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 465 0.03 0.01
gcs indirect ast 9,975 0.62 0.29
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 406 0.03 0.01
gcs msgs process time(ms) 14,104 0.87 0.41
gcs msgs received 191,857 11.88 5.55
gcs out-of-order msgs 8 0.00 0.00
gcs pings refused 14 0.00 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 14 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 3 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 2,681 0.17 0.08
gcs side channel msgs actual 12,810 0.79 0.37
gcs side channel msgs logical 21,323 1.32 0.62
gcs stale cr 7,439 0.46 0.22
gcs undo cr 0 0.00 0.00
gcs write notification msgs 129 0.01 0.00
gcs writes refused 7 0.00 0.00
ges msgs process time(ms) 1,112 0.07 0.03
ges msgs received 52,472 3.25 1.52
global posts dropped 0 0.00 0.00
global posts queue time 823,172 50.99 23.80
global posts queued 248 0.02 0.01
global posts requested 248 0.02 0.01
global posts sent 249 0.02 0.01
implicit batch messages received 15,186 0.94 0.44
implicit batch messages sent 10,098 0.63 0.29
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 74,884 4.64 2.16
messages queue sent actual 136,334 8.44 3.94
messages queue sent logical 147,250 9.12 4.26
messages received actual 216,322 13.40 6.25
messages received logical 244,329 15.13 7.06
messages sent directly 34,610 2.14 1.00
messages sent indirectly 63,631 3.94 1.84
messages sent not implicit batched 126,236 7.82 3.65
messages sent pbatched 70,128 4.34 2.03
msgs causing lmd to send msgs 10,487 0.65 0.30
msgs causing lms(s) to send msgs 11,783 0.73 0.34
msgs received queue time (ms) 5,362 0.33 0.16
msgs received queued 244,329 15.13 7.06
msgs sent queue time (ms) 8,754 0.54 0.25
msgs sent queue time on ksxp (ms) 43,405 2.69 1.25
msgs sent queued 147,091 9.11 4.25
msgs sent queued on ksxp 204,837 12.69 5.92
number of ges deadlock detected 0 0.00 0.00
process batch messages received 73,629 4.56 2.13
process batch messages sent 56,288 3.49 1.63


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 8,136
CURRENT Block Requests 1,190
Data Block Requests 8,136
Undo Block Requests 0
TX Block Requests 822
Current Results 9,318
Private results 0
Zero Results 8
Disk Read Results 0
Fail Results 0
Fairness Down Converts 1,685
Fairness Clears 0
Free GC Elements 0
Flushes 481
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 0
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 45,011 99.92 0.00 0.07 0.00 0.00
Flushes 364 84.07 15.66 0.27 0.00 0.00
Writes 1,696 66.86 31.54 0.35 0.47 0.77


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 5,737 92.14 7.86 0.00 11,080 97.36 2.64 0.00
1 undo header 1,015 99.90 0.10 0.00 57 94.74 5.26 0.00
1 Others 355 93.24 6.76 0.00 432 93.98 6.02 0.00


Back to Top

End of Report