[oracle@oracle ~]$ cat orcl.html AWR Report

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
ORCL1321230414orcl110.2.0.4.0NOoracle

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:575506-May-13 10:00:5994 4.8
End Snap:575606-May-13 10:28:25108 4.9
Elapsed:  27.43 (mins)  
DB Time:  1,027.45 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 5,920M 5,920MStd Block Size: 8K
Shared Pool Size: 9,360M 9,360MLog Buffer: 14,320K

Load Profile

Per SecondPer Transaction
Redo size: 16,130.98 1,204.88
Logical reads: 140,221.98 10,473.67
Block changes: 89.95 6.72
Physical reads: 0.79 0.06
Physical writes: 751.52 56.13
User calls: 1,404.50 104.91
Parses: 279.37 20.87
Hard parses: 20.25 1.51
Sorts: 22.40 1.67
Logons: 0.36 0.03
Executes: 278.83 20.83
Transactions: 13.39 

% Blocks changed per Read: 0.06Recursive Call %: 13.78
Rollback per transaction %: 0.00Rows per Sort: 5898.09

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 99.13
Buffer Hit %: 100.00In-memory Sort %: 99.99
Library Hit %: 87.24Soft Parse %: 92.75
Execute to Parse %: -0.19Latch Hit %: 99.74
Parse CPU to Parse Elapsd %: 53.65% Non-Parse CPU: 97.09

Shared Pool Statistics

BeginEnd
Memory Usage %: 63.36 70.23
% SQL with executions>1: 43.71 85.10
% Memory for SQL w/exec>1: 54.00 87.24

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  1,668  2.7 
control file parallel write 340 967 2,844 1.6System I/O
db file sequential read 1,551 473 305 .8User I/O
log file switch completion 361 342 947 .6Configuration
row cache lock 118 192 1,624 .3Concurrency

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 61,387.80 99.58
DB CPU 1,668.47 2.71
parse time elapsed 91.33 0.15
hard parse elapsed time 70.89 0.11
PL/SQL compilation elapsed time 21.55 0.03
sequence load elapsed time 5.94 0.01
PL/SQL execution elapsed time 4.88 0.01
connection management call elapsed time 1.39 0.00
hard parse (sharing criteria) elapsed time 0.51 0.00
failed parse elapsed time 0.20 0.00
repeated bind elapsed time 0.00 0.00
DB time 61,647.20  
background elapsed time 4,054.61  
background cpu time 5.94  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
System I/O 24,397 0.00 1,123 46 1.11
User I/O 1,737 0.40 542 312 0.08
Configuration 371 89.49 347 934 0.02
Concurrency 1,225 11.92 270 221 0.06
Commit 22,026 0.00 172 8 1.00
Other 353 6.80 64 182 0.02
Network 2,144,853 0.00 2 0 97.35
Application 1,106 0.00 0 0 0.05

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
control file parallel write 340 0.00 967 2844 0.02
db file sequential read 1,551 0.00 473 305 0.07
log file switch completion 361 91.97 342 947 0.02
row cache lock 118 49.15 192 1624 0.01
log file sync 22,026 0.00 172 8 1.00
log file parallel write 22,089 0.00 149 7 1.00
buffer busy waits 97 72.16 73 750 0.00
enq: CF - contention 23 65.22 53 2316 0.00
read by other session 119 5.88 47 395 0.01
db file scattered read 49 0.00 22 443 0.00
Streams AQ: qmn coordinator waiting for slave to start 2 100.00 10 4884 0.00
control file sequential read 1,780 0.00 6 3 0.08
enq: SQ - contention 10 0.00 5 471 0.00
enq: TX - index contention 9 0.00 4 470 0.00
SQL*Net message to client 2,077,832 0.00 1 0 94.31
log file sequential read 96 0.00 1 9 0.00
latch: library cache 259 0.00 1 3 0.01
SQL*Net more data to client 64,323 0.00 1 0 2.92
enq: US - contention 64 0.00 1 9 0.00
latch: shared pool 559 0.00 1 1 0.03
kksfbc child completion 5 100.00 0 50 0.00
SQL*Net more data from client 2,698 0.00 0 0 0.12
latch free 243 0.00 0 1 0.01
Log archive I/O 90 0.00 0 3 0.00
cursor: pin S wait on X 19 94.74 0 10 0.00
os thread startup 3 0.00 0 61 0.00
SQL*Net break/reset to client 1,102 0.00 0 0 0.05
latch: cache buffers chains 135 0.00 0 0 0.01
log file single write 2 0.00 0 20 0.00
latch: row cache objects 1 0.00 0 4 0.00
enq: TX - row lock contention 4 0.00 0 1 0.00
latch: In memory undo latch 10 0.00 0 0 0.00
LGWR wait for redo copy 10 0.00 0 0 0.00
latch: session allocation 4 0.00 0 0 0.00
direct path read 10 0.00 0 0 0.00
cursor: mutex S 14 0.00 0 0 0.00
buffer deadlock 2 100.00 0 0 0.00
direct path read temp 4 0.00 0 0 0.00
direct path write 4 0.00 0 0 0.00
cursor: mutex X 1 0.00 0 0 0.00
SQL*Net message from client 2,077,831 0.00 69,980 34 94.31
Streams AQ: qmn slave idle wait 1,013 0.10 4,575 4516 0.05
virtual circuit status 55 100.00 1,611 29289 0.00
Streams AQ: qmn coordinator idle wait 718 36.07 1,599 2227 0.03
jobq slave wait 5 100.00 15 2931 0.00
class slave wait 3 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
control file parallel write 340 0.00 967 2844 0.02
log file parallel write 22,063 0.00 149 7 1.00
events in waitclass Other 207 8.21 63 305 0.01
control file sequential read 457 0.00 5 12 0.02
log file sequential read 96 0.00 1 9 0.00
Log archive I/O 90 0.00 0 3 0.00
os thread startup 3 0.00 0 61 0.00
log file single write 2 0.00 0 20 0.00
rdbms ipc message 25,155 17.98 15,105 600 1.14
Streams AQ: qmn slave idle wait 918 0.00 4,200 4575 0.04
smon timer 7 71.43 1,616 230803 0.00
pmon timer 570 100.00 1,611 2827 0.03
Streams AQ: qmn coordinator idle wait 718 36.07 1,599 2227 0.03

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 177,948
IDLE_TIME 2,474,840
IOWAIT_TIME 457,119
NICE_TIME 112
SYS_TIME 10,526
USER_TIME 163,046
LOAD 54
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 33,747,128,320
NUM_CPUS 16
NUM_CPU_SOCKETS 2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 60,234.50 1,696.10 1,569 233,792,181
SYS$BACKGROUND 0.00 0.00 252 13,508
orcl 0.00 0.00 0 0
orclXDB 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
SYS$USERS 1551 47818 1216 27013 0 0 2136647 216
SYS$BACKGROUND 265 7250 3 18 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
4,162 6 0   6.75 3nxtbwxqpb4zg JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2,247 4 0   3.65 75xdftn1qt7r0 JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2,162 3 0   3.51 6agd8kjkjarh9 JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2,162 4 0   3.51 146h0rt0bjpwz JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2,054 3 0   3.33 2qy0cwdcjtxq4 JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2,042 3 0   3.31 967w80xun3gq6 JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2,038 3 0   3.31 1u4bj8k7uqgsu JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2,025 3 0   3.28 831bshr9dd8nz JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2,024 3 0   3.28 g9gtcg1gt02nm JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2,010 3 0   3.26 6h9r6243h2p4b JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1,998 3 0   3.24 1sp5h9949cwbs JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1,824 3 0   2.96 91pw7nknvwpf2 JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1,790 3 0   2.90 dbcqzz18cdhsc JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1,777 3 0   2.88 fjw36aq5bkkvv JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1,775 3 0   2.88 f22hfj54nag1q JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1,669 2 0   2.71 957m3sjzt3k7s JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1,658 2 0   2.69 ga5rnh3a3nc4t JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1,646 2 0   2.67 624r6nm8asy0x JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1,615 2 1 1615.31 2.62 66ua7hnky1fq8 JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1,596 2 0   2.59 3kpja2mtaq85a JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1,539 2 0   2.50 2zxth2x2183rk JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1,534 2 0   2.49 b5d56uxzz8tf3 JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1,527 2 0   2.48 gbs59s577k744 JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1,515 2 0   2.46 47fh5x45vpd0s JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1,370 2 1 1370.01 2.22 8jwymcg8kk36x JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1,327 1 1 1326.62 2.15 24cwj85k2hrpc JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1,274 1 0   2.07 3dqbrfsz37zws JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1,130 2 1 1130.23 1.83 7kqqynzbxcd4j JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
891 1 1 891.36 1.45 ba6q3htuhmtvj JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
890 1 1 890.24 1.44 gkvd6sw2wya0w JDBC Thin Client SELECT i_id, i_cataid, vc_cata...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
90 90 2,757 0.03 0.15 auxhsvkpbrf76   select * from common_publish_l...
15 15 28 0.55 0.03 32cx4sk48d4c5   SELECT * FROM ( SELECT ROW_.*,...
14 14 33 0.41 0.02 57pf7q3th7jk8   SELECT COUNT(*) FROM jcms_web2...
8 8 228,644 0.00 0.01 520mkxqpf15q8 JDBC Thin Client select 1 from dual
8 8 2,035 0.00 0.01 2ftyy4dawz1d6 JDBC Thin Client SELECT i_id FROM jcms_catalogi...
6 6 4 1.62 0.01 4ah1944x6rv3m   SELECT * FROM ( SELECT ROW_.*,...
6 4,162 0   6.75 3nxtbwxqpb4zg JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
5 5 3 1.81 0.01 7045kjtmx4vrs   SELECT COUNT(i_id) AS id FROM ...
5 5 459 0.01 0.01 691gpfxdk0pun   SELECT i_id, i_linkid, i_linkm...
5 5 23 0.21 0.01 av9apcv6vdy1b   SELECT * FROM ( SELECT ROW_.*,...
4 2,247 0   3.65 75xdftn1qt7r0 JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
4 2,162 0   3.51 146h0rt0bjpwz JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
3 2,162 0   3.51 6agd8kjkjarh9 JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
3 2,010 0   3.26 6h9r6243h2p4b JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
3 2,054 0   3.33 2qy0cwdcjtxq4 JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
3 1,790 0   2.90 dbcqzz18cdhsc JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
3 1,824 0   2.96 91pw7nknvwpf2 JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
3 2,025 0   3.28 831bshr9dd8nz JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
3 1,775 0   2.88 f22hfj54nag1q JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
3 2,038 0   3.31 1u4bj8k7uqgsu JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
3 1,777 0   2.88 fjw36aq5bkkvv JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
3 2,024 0   3.28 g9gtcg1gt02nm JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
3 2,042 0   3.31 967w80xun3gq6 JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
3 1,998 0   3.24 1sp5h9949cwbs JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2 1,646 0   2.67 624r6nm8asy0x JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2 1,615 1 1.92 2.62 66ua7hnky1fq8 JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2 1,596 0   2.59 3kpja2mtaq85a JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2 1,130 1 1.91 1.83 7kqqynzbxcd4j JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2 1,534 0   2.49 b5d56uxzz8tf3 JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2 1,658 0   2.69 ga5rnh3a3nc4t JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2 1,539 0   2.50 2zxth2x2183rk JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2 1,515 0   2.46 47fh5x45vpd0s JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2 1,669 0   2.71 957m3sjzt3k7s JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2 1,527 0   2.48 gbs59s577k744 JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
2 1,370 1 1.69 2.22 8jwymcg8kk36x JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1 1,327 1 1.50 2.15 24cwj85k2hrpc JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1 1,274 0   2.07 3dqbrfsz37zws JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1 890 1 0.96 1.44 gkvd6sw2wya0w JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1 891 1 0.94 1.45 ba6q3htuhmtvj JDBC Thin Client SELECT i_id, i_cataid, vc_cata...

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
33,492,245 2,757 12,148.08 14.51 89.82 89.87 auxhsvkpbrf76   select * from common_publish_l...
2,599,352 28 92,834.00 1.13 15.48 15.48 32cx4sk48d4c5   SELECT * FROM ( SELECT ROW_.*,...
2,557,995 2,035 1,257.00 1.11 7.62 7.62 2ftyy4dawz1d6 JDBC Thin Client SELECT i_id FROM jcms_catalogi...
1,329,264 459 2,896.00 0.58 5.15 5.17 691gpfxdk0pun   SELECT i_id, i_linkid, i_linkm...
784,002 21 37,333.43 0.34 3.80 3.80 dk4qs5fn00y2r   SELECT i_id, i_publishtype FRO...
625,429 7 89,347.00 0.27 3.35 3.35 0g52agtd9qzbt   SELECT i_id, i_publishtype FRO...
565,887 7 80,841.00 0.25 4.46 4.79 55vf3djd2qgym   SELECT i_id, i_publishtype FRO...
565,886 7 80,840.86 0.25 3.41 3.41 4f5nuw8vnnucz   SELECT i_id, i_publishtype FRO...
313,952 4 78,488.00 0.14 6.47 6.47 4ah1944x6rv3m   SELECT * FROM ( SELECT ROW_.*,...
252,998 3 84,332.67 0.11 5.44 5.44 7045kjtmx4vrs   SELECT COUNT(i_id) AS id FROM ...

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
80 1 80.00 6.13 0.02 0.02 0dwr2vd6vbqzs   SELECT count(*) over () as tot...
71 0   5.44 1.82 1668.73 957m3sjzt3k7s JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
14 0   1.07 4.48 2247.20 75xdftn1qt7r0 JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
7 23 0.30 0.54 0.01 11.07 04xtrk7uyhknh   select obj#, type#, ctime, mti...
1 1 1.00 0.08 1.50 1326.62 24cwj85k2hrpc JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1 0   0.08 1.91 1596.45 3kpja2mtaq85a JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1 0   0.08 5.86 4161.96 3nxtbwxqpb4zg JDBC Thin Client SELECT i_id, i_cataid, vc_cata...
1 5 0.20 0.08 0.00 1.52 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
1 2,186 0.00 0.08 0.14 1.29 fhg7a9dbw16q8   SELECT JCMSMARKRECORD_SEQ.NEXT...
0 2,778 0.00 0.00 0.17 0.17 01za7kybp89j7   SELECT COMMON_PUBLISH_LIST_SEQ...

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
228,644 228,636 1.00 0.00 0.00 520mkxqpf15q8 JDBC Thin Client select 1 from dual
45,170 45,170 1.00 0.00 0.00 2hjmcac6hw9wh JDBC Thin Client SELECT i_id, vc_webname, vc_do...
9,938 9,938 1.00 0.00 0.00 78m78282zfd3r JDBC Thin Client SELECT i_id, vc_code, vc_catan...
9,550 0 0.00 0.00 0.00 1m9vm4cq13fwm JDBC Thin Client SELECT i_id, i_cataid, vc_fiel...
6,732 6,732 1.00 0.00 0.00 gfyq65ptk8nwu JDBC Thin Client SELECT i_id, vc_code, vc_catan...
6,266 0 0.00 0.00 0.00 55v8w0n0bcwxx JDBC Thin Client SELECT i_id, i_cataid, vc_fiel...
3,591 3,591 1.00 0.00 0.00 20x7azz7av1kz   SELECT i_id, vc_code, vc_catan...
3,178 0 0.00 0.00 0.00 du50rcks2sn8q JDBC Thin Client SELECT i_id, i_cataid, vc_fiel...
2,983 0 0.00 0.00 0.00 2nj6f3bgx8jzk   SELECT i_id FROM jcms_virtualc...
2,778 2,778 1.00 0.00 0.00 01za7kybp89j7   SELECT COMMON_PUBLISH_LIST_SEQ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
228,625 228,644 49.73 520mkxqpf15q8 JDBC Thin Client select 1 from dual
45,169 45,170 9.82 2hjmcac6hw9wh JDBC Thin Client SELECT i_id, vc_webname, vc_do...
9,938 9,938 2.16 78m78282zfd3r JDBC Thin Client SELECT i_id, vc_code, vc_catan...
9,550 9,550 2.08 1m9vm4cq13fwm JDBC Thin Client SELECT i_id, i_cataid, vc_fiel...
6,732 6,732 1.46 gfyq65ptk8nwu JDBC Thin Client SELECT i_id, vc_code, vc_catan...
6,266 6,266 1.36 55v8w0n0bcwxx JDBC Thin Client SELECT i_id, i_cataid, vc_fiel...
3,591 3,591 0.78 20x7azz7av1kz   SELECT i_id, vc_code, vc_catan...
3,178 3,178 0.69 du50rcks2sn8q JDBC Thin Client SELECT i_id, i_cataid, vc_fiel...
2,983 2,983 0.65 2nj6f3bgx8jzk   SELECT i_id FROM jcms_virtualc...
2,778 2,778 0.60 01za7kybp89j7   SELECT COMMON_PUBLISH_LIST_SEQ...

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

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
01za7kybp89j7SELECT COMMON_PUBLISH_LIST_SEQ.NEXTVAL FROM DUAL
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
0g52agtd9qzbtSELECT i_id, i_publishtype FROM jcms_info WHERE ( b_published=3 OR b_published=1 ) AND (c_validend='0000-00-00' OR c_validend>='2013-05-06 09:55:41') AND b_delete=0 AND i_cataid=250 ORDER BY i_type DESC, i_orderid ASC, i_id DESC
146h0rt0bjpwzSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:47:53' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
1m9vm4cq13fwmSELECT i_id, i_cataid, vc_fieldname, i_fieldtype, vc_name, vc_userid, b_issys, vc_sourceinfo, vc_childlink, i_orderid, b_show, vc_order, b_ordersj, b_pk, vc_default, b_write, vc_note, vc_key, vc_value, i_styleid FROM jcms_fieldinfo WHERE i_cataid=247 ORDER BY i_orderid ASC, i_id ASC
1sp5h9949cwbsSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:48:04' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
1u4bj8k7uqgsuSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:47:46' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
20x7azz7av1kzSELECT i_id, vc_code, vc_cataname, i_parentid, i_level, i_orderid, i_style, vc_stylename, i_catatemplate, i_infotemplate, i_catatemplatedef, i_infotemplatedef, i_url, c_deploytime, b_enabled, b_audit, i_moduleid, i_type, vc_userid, i_webid, vc_url, vc_dir, vc_tablename, vc_domain2, vc_alllink, vc_colnowlocation, vc_artnowlocation, vc_refcol, b_refvalid, b_published, b_changed, c_invalidate, b_listen, i_publishcount, b_legislation, i_publishtype, c_meta, c_artmeta, b_copy, i_history, i_infonumber, b_contribute, b_rss, vc_class, i_score, i_updatedate, b_createindex, b_ispoliticscol, i_alltemplate, i_alltemplatedef, b_read, vc_readfield, vc_readfieldvalue, c_publishtime, b_readtype, b_synctype, b_secauditing, c_updatetime, vc_updateuser, vc_note, i_styleid, i_picscore, b_colcopy, b_artcopy, b_visit, b_sendvalid, vc_flowcode, i_flowsourcecol, b_flowsourcecol, b_flowinherit, b_readcol FROM jcms_cataloginfo WHERE i_id=189
24cwj85k2hrpcSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:44:42' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
2ftyy4dawz1d6SELECT i_id FROM jcms_cataloginfo WHERE b_readtype<>0 AND i_webid=2
2hjmcac6hw9whSELECT i_id, vc_webname, vc_domain, vc_modalpath, vc_modalobjectpath, vc_publishpath, vc_infopath, vc_serverip, i_serverport, vc_serverdir, vc_contentflag, vc_trade, vc_district, vc_assort, b_needwebimage, i_webimagetype, vc_webword, vc_webimage, i_publishtype, vc_serverip2, i_serverport2, i_publishtype2, vc_serverip3, i_serverport3, i_publishtype3, vc_serverdir2, vc_serverdir3, b_datasync, vc_db_serverip, vc_db_port, vc_db_filepath, vc_norm, vc_department, b_canread, vc_readlocation, b_read, b_visit, vc_visit, c_createtime, vc_flowcode, b_version, b_meta, b_commonjs FROM jcms_webinfomation WHERE i_id=2
2nj6f3bgx8jzkSELECT i_id FROM jcms_virtualcatalog WHERE i_id=0
2qy0cwdcjtxq4SELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:47:36' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
2zxth2x2183rkSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:48:27' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
32cx4sk48d4c5SELECT * FROM ( SELECT ROW_.*, ROWNUM rn_ FROM ( SELECT a.i_id, a.b_ref, a.vc_title, a.c_deploytime, a.vc_editor, a.b_published, a.i_cataid, a.b_needaudit AS bchkdisabled, a.vc_userid, a.vc_title AS title, a.b_ref AS bchklink, b_memo FROM jcms_info a WHERE a.b_delete=0 AND a.i_webid=2 AND a.i_cataid=189 ORDER BY a.i_type DESC, a.i_orderid ASC, a.c_deploytime DESC, a.i_id DESC ) ROW_ WHERE ROWNUM <= 30) WHERE rn_ > 0
3dqbrfsz37zwsSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:37:22' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
3kpja2mtaq85aSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:44:05' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
3nxtbwxqpb4zgSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:48:00' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
47fh5x45vpd0sSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:42:25' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
4ah1944x6rv3mSELECT * FROM ( SELECT ROW_.*, ROWNUM rn_ FROM ( SELECT a.i_id, a.b_ref, a.vc_title, a.vc_cataname, a.c_deploytime, a.vc_editor, a.b_needaudit, a.vc_auditor, a.c_audittime, a.b_publish, a.i_cataid, a.i_artid, a.i_type, a.vc_userid, a.vc_title AS title, a.vc_tablename, a.b_ref AS bchklink, b_memo FROM jcms_web1_searchinfo a WHERE a.b_delete=0 ORDER BY a.c_deploytime DESC, a.i_id DESC ) ROW_ WHERE ROWNUM <= 50) WHERE rn_ > 0
4f5nuw8vnnuczSELECT i_id, i_publishtype FROM jcms_info WHERE ( b_published=3 OR b_published=1 ) AND (c_validend='0000-00-00' OR c_validend>='2013-05-06 09:46:58') AND b_delete=0 AND i_cataid=247 ORDER BY i_type DESC, i_orderid ASC, i_id DESC
520mkxqpf15q8select 1 from dual
55v8w0n0bcwxxSELECT i_id, i_cataid, vc_fieldname, i_fieldtype, vc_name, vc_userid, b_issys, vc_sourceinfo, vc_childlink, i_orderid, b_show, vc_order, b_ordersj, b_pk, vc_default, b_write, vc_note, vc_key, vc_value, i_styleid FROM jcms_fieldinfo WHERE i_cataid=250 ORDER BY i_orderid ASC, i_id ASC
55vf3djd2qgymSELECT i_id, i_publishtype FROM jcms_info WHERE ( b_published=3 OR b_published=1 ) AND (c_validend='0000-00-00' OR c_validend>='2013-05-06 09:46:59') AND b_delete=0 AND i_cataid=247 ORDER BY i_type DESC, i_orderid ASC, i_id DESC
57pf7q3th7jk8SELECT COUNT(*) FROM jcms_web2_searchinfo a WHERE a.b_delete=0
624r6nm8asy0xSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:48:48' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
66ua7hnky1fq8SELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:44:39' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
691gpfxdk0punSELECT i_id, i_linkid, i_linkmagazineid, i_linkstyle, i_modalobjectid FROM jcms_modalobjectunit WHERE ( i_type=2 OR i_type=4 ) AND ( i_linkstyle=8 AND i_linkid=0)
6agd8kjkjarh9SELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:47:56' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
6h9r6243h2p4bSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:47:49' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
7045kjtmx4vrsSELECT COUNT(i_id) AS id FROM jcms_web2_searchinfo WHERE vc_keyword LIKE '%??%' AND b_ref=0 AND b_delete=0
75xdftn1qt7r0SELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:32:42' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
78m78282zfd3rSELECT i_id, vc_code, vc_cataname, i_parentid, i_level, i_orderid, i_style, vc_stylename, i_catatemplate, i_infotemplate, i_catatemplatedef, i_infotemplatedef, i_url, c_deploytime, b_enabled, b_audit, i_moduleid, i_type, vc_userid, i_webid, vc_url, vc_dir, vc_tablename, vc_domain2, vc_alllink, vc_colnowlocation, vc_artnowlocation, vc_refcol, b_refvalid, b_published, b_changed, c_invalidate, b_listen, i_publishcount, b_legislation, i_publishtype, c_meta, c_artmeta, b_copy, i_history, i_infonumber, b_contribute, b_rss, vc_class, i_score, i_updatedate, b_createindex, b_ispoliticscol, i_alltemplate, i_alltemplatedef, b_read, vc_readfield, vc_readfieldvalue, c_publishtime, b_readtype, b_synctype, b_secauditing, c_updatetime, vc_updateuser, vc_note, i_styleid, i_picscore, b_colcopy, b_artcopy, b_visit, b_sendvalid, vc_flowcode, i_flowsourcecol, b_flowsourcecol, b_flowinherit, b_readcol FROM jcms_cataloginfo WHERE i_id=247
7kqqynzbxcd4jSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:48:53' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
831bshr9dd8nzSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:48:12' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
8jwymcg8kk36xSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:58:45' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
91pw7nknvwpf2SELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:38:21' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
957m3sjzt3k7sSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:48:38' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
967w80xun3gq6SELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:48:22' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
auxhsvkpbrf76select * from common_publish_list where publishstate=0 or publishstate=3 order by i_id
av9apcv6vdy1bSELECT * FROM ( SELECT ROW_.*, ROWNUM rn_ FROM ( SELECT a.i_id, a.b_ref, a.vc_title, a.vc_cataname, a.c_deploytime, a.vc_editor, a.b_needaudit, a.vc_auditor, a.c_audittime, a.b_publish, a.i_cataid, a.i_artid, a.i_type, a.vc_userid, a.vc_title AS title, a.vc_tablename, a.b_ref AS bchklink, b_memo FROM jcms_web8_searchinfo a WHERE a.b_delete=0 ORDER BY a.c_deploytime DESC, a.i_id DESC ) ROW_ WHERE ROWNUM <= 50) WHERE rn_ > 0
b5d56uxzz8tf3SELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:48:35' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
ba6q3htuhmtvjSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:53:46' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
dbcqzz18cdhscSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:48:44' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
dk4qs5fn00y2rSELECT i_id, i_publishtype FROM jcms_info WHERE ( b_published=3 OR b_published=1 ) AND (c_validend='0000-00-00' OR c_validend>='2013-05-06 09:49:12') AND b_delete=0 AND i_cataid=986 ORDER BY i_type DESC, i_orderid ASC, i_id DESC
du50rcks2sn8qSELECT i_id, i_cataid, vc_fieldname, i_fieldtype, vc_name, vc_userid, b_issys, vc_sourceinfo, vc_childlink, i_orderid, b_show, vc_order, b_ordersj, b_pk, vc_default, b_write, vc_note, vc_key, vc_value, i_styleid FROM jcms_fieldinfo WHERE i_cataid=189 ORDER BY i_orderid ASC, i_id ASC
f22hfj54nag1qSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:48:18' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
fhg7a9dbw16q8SELECT JCMSMARKRECORD_SEQ.NEXTVAL FROM DUAL
fjw36aq5bkkvvSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:48:08' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
g9gtcg1gt02nmSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:48:15' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
ga5rnh3a3nc4tSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:48:52' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
gbs59s577k744SELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:48:31' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC
gfyq65ptk8nwuSELECT i_id, vc_code, vc_cataname, i_parentid, i_level, i_orderid, i_style, vc_stylename, i_catatemplate, i_infotemplate, i_catatemplatedef, i_infotemplatedef, i_url, c_deploytime, b_enabled, b_audit, i_moduleid, i_type, vc_userid, i_webid, vc_url, vc_dir, vc_tablename, vc_domain2, vc_alllink, vc_colnowlocation, vc_artnowlocation, vc_refcol, b_refvalid, b_published, b_changed, c_invalidate, b_listen, i_publishcount, b_legislation, i_publishtype, c_meta, c_artmeta, b_copy, i_history, i_infonumber, b_contribute, b_rss, vc_class, i_score, i_updatedate, b_createindex, b_ispoliticscol, i_alltemplate, i_alltemplatedef, b_read, vc_readfield, vc_readfieldvalue, c_publishtime, b_readtype, b_synctype, b_secauditing, c_updatetime, vc_updateuser, vc_note, i_styleid, i_picscore, b_colcopy, b_artcopy, b_visit, b_sendvalid, vc_flowcode, i_flowsourcecol, b_flowsourcecol, b_flowinherit, b_readcol FROM jcms_cataloginfo WHERE i_id=250
gkvd6sw2wya0wSELECT i_id, i_cataid, vc_cataname, i_artid, vc_tablename, vc_title, vc_keyword, vc_abs, b_publish, vc_author, vc_source, vc_webname, vc_domain, c_createdate, i_type, vc_url, vc_dir, i_webid, b_needaudit, vc_editor, vc_auditor, c_deploytime, c_validbegin, c_validend, b_delete, b_ref, vc_content, vc_userid, c_date, vc_href FROM jcms_web1_searchinfo WHERE ( c_validend='0000-00-00' OR c_validend>='2013-05-06 09:52:44' ) AND b_publish=1 AND b_delete=0 ORDER BY c_deploytime DESC, i_id DESC

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 155,746 94.64 7.07
CPU used when call started 155,701 94.61 7.07
CR blocks created 3,059 1.86 0.14
Cached Commit SCN referenced 112,960,567 68,642.04 5,127.11
Commit SCN cached 75 0.05 0.00
DB time 683,600 415.40 31.03
DBWR checkpoint buffers written 4,168 2.53 0.19
DBWR checkpoints 1 0.00 0.00
DBWR transaction table writes 35 0.02 0.00
DBWR undo block writes 1,215 0.74 0.06
IMU CR rollbacks 934 0.57 0.04
IMU Flushes 1,332 0.81 0.06
IMU Redo allocation size 2,229,828 1,354.99 101.21
IMU commits 15,030 9.13 0.68
IMU contention 63 0.04 0.00
IMU pool not allocated 5,762 3.50 0.26
IMU recursive-transaction flush 5 0.00 0.00
IMU undo allocation size 39,648,376 24,092.88 1,799.58
IMU- failed to get a private strand 5,762 3.50 0.26
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 2,091,478 1,270.92 94.93
active txn count during cleanout 3,145 1.91 0.14
application wait time 13 0.01 0.00
background checkpoints completed 0 0.00 0.00
background checkpoints started 1 0.00 0.00
background timeouts 4,871 2.96 0.22
branch node splits 0 0.00 0.00
buffer is not pinned count 176,170,491 107,052.42 7,996.12
buffer is pinned count 864,505,838 525,328.85 39,238.65
bytes received via SQL*Net from client 260,085,960 158,044.81 11,804.92
bytes sent via SQL*Net to client 573,113,404 348,260.23 26,012.77
calls to get snapshot scn: kcmgss 1,245,195 756.66 56.52
calls to kcmgas 29,578 17.97 1.34
calls to kcmgcs 324 0.20 0.01
change write time 126 0.08 0.01
cleanout - number of ktugct calls 2,593 1.58 0.12
cleanouts and rollbacks - consistent read gets 2,336 1.42 0.11
cleanouts only - consistent read gets 116 0.07 0.01
cluster key scan block gets 1,638 1.00 0.07
cluster key scans 88 0.05 0.00
commit batch/immediate performed 5 0.00 0.00
commit batch/immediate requested 5 0.00 0.00
commit cleanout failures: block lost 0 0.00 0.00
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 4 0.00 0.00
commit cleanout failures: cannot pin 57 0.03 0.00
commit cleanouts 44,431 27.00 2.02
commit cleanouts successfully completed 44,370 26.96 2.01
commit immediate performed 5 0.00 0.00
commit immediate requested 5 0.00 0.00
commit txn count during cleanout 453 0.28 0.02
concurrency wait time 27,032 16.43 1.23
consistent changes 5,247 3.19 0.24
consistent gets 230,595,095 140,124.28 10,466.37
consistent gets - examination 499,149 303.31 22.66
consistent gets direct 11 0.01 0.00
consistent gets from cache 230,595,084 140,124.27 10,466.37
cursor authentications 4,545 2.76 0.21
data blocks consistent reads - undo records applied 4,317 2.62 0.20
db block changes 148,019 89.95 6.72
db block gets 160,786 97.70 7.30
db block gets direct 188 0.11 0.01
db block gets from cache 160,598 97.59 7.29
deferred (CURRENT) block cleanout applications 25,670 15.60 1.17
dirty buffers inspected 55 0.03 0.00
enqueue conversions 336 0.20 0.02
enqueue releases 105,892 64.35 4.81
enqueue requests 105,902 64.35 4.81
enqueue timeouts 5 0.00 0.00
enqueue waits 93 0.06 0.00
exchange deadlocks 2 0.00 0.00
execute count 458,859 278.83 20.83
free buffer inspected 5,153 3.13 0.23
free buffer requested 8,102 4.92 0.37
heap block compress 1,625 0.99 0.07
hot buffers moved to head of LRU 257,746 156.62 11.70
immediate (CR) block cleanout applications 2,452 1.49 0.11
immediate (CURRENT) block cleanout applications 2,430 1.48 0.11
index crx upgrade (positioned) 1,817 1.10 0.08
index fetch by key 149,950 91.12 6.81
index scans kdiixs1 80,183 48.72 3.64
leaf node 90-10 splits 50 0.03 0.00
leaf node splits 83 0.05 0.00
lob reads 41,408 25.16 1.88
lob writes 213 0.13 0.01
lob writes unaligned 213 0.13 0.01
logons cumulative 595 0.36 0.03
messages received 25,254 15.35 1.15
messages sent 25,254 15.35 1.15
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 229,982,473 139,752.01 10,438.57
opened cursors cumulative 458,239 278.46 20.80
parse count (failures) 550 0.33 0.02
parse count (hard) 33,321 20.25 1.51
parse count (total) 459,749 279.37 20.87
parse time cpu 4,850 2.95 0.22
parse time elapsed 9,040 5.49 0.41
physical read IO requests 1,172 0.71 0.05
physical read bytes 10,698,752 6,501.24 485.60
physical read total IO requests 3,065 1.86 0.14
physical read total bytes 133,303,296 81,003.58 6,050.44
physical read total multi block requests 144 0.09 0.01
physical reads 1,306 0.79 0.06
physical reads cache 1,253 0.76 0.06
physical reads cache prefetch 98 0.06 0.00
physical reads direct 53 0.03 0.00
physical reads direct (lob) 10 0.01 0.00
physical reads direct temporary tablespace 42 0.03 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 50,740 30.83 2.30
physical write bytes 10,131,316,736 6,156,433.75 459,845.53
physical write total IO requests 74,029 44.98 3.36
physical write total bytes 10,276,070,400 6,244,395.30 466,415.69
physical write total multi block requests 70,612 42.91 3.20
physical writes 1,236,733 751.52 56.13
physical writes direct 1,232,348 748.85 55.93
physical writes direct (lob) 2 0.00 0.00
physical writes direct temporary tablespace 1,232,160 748.74 55.93
physical writes from cache 4,385 2.66 0.20
physical writes non checkpoint 1,234,074 749.90 56.01
pinned buffers inspected 1 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
process last non-idle time 1,652 1.00 0.07
recursive calls 369,550 224.56 16.77
recursive cpu usage 4,369 2.65 0.20
redo blocks written 67,841 41.22 3.08
redo buffer allocation retries 75 0.05 0.00
redo entries 48,130 29.25 2.18
redo log space requests 419 0.25 0.02
redo log space wait time 35,004 21.27 1.59
redo ordering marks 541 0.33 0.02
redo size 26,545,904 16,130.98 1,204.88
redo subscn max counts 1,159 0.70 0.05
redo synch time 17,858 10.85 0.81
redo synch writes 22,056 13.40 1.00
redo wastage 7,098,740 4,313.65 322.20
redo write time 15,348 9.33 0.70
redo writer latching time 1 0.00 0.00
redo writes 22,160 13.47 1.01
rollback changes - undo records applied 19 0.01 0.00
rollbacks only - consistent read gets 708 0.43 0.03
rows fetched via callback 174,204 105.86 7.91
session connect time 0 0.00 0.00
session cursor cache hits 362,717 220.41 16.46
session logical reads 230,755,881 140,221.98 10,473.67
session uga memory max 622,145,864 378,055.48 28,238.28
shared hash latch upgrades - no wait 2,214 1.35 0.10
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 3 0.00 0.00
sorts (memory) 36,862 22.40 1.67
sorts (rows) 217,433,227 132,126.29 9,868.97
sql area evicted 3,434 2.09 0.16
sql area purged 550 0.33 0.02
summed dirty queue length 105 0.06 0.00
switch current to new buffer 3,071 1.87 0.14
table fetch by rowid 519,273,546 315,543.70 23,569.06
table fetch continued row 443 0.27 0.02
table scan blocks gotten 54,443,194 33,083.15 2,471.10
table scan rows gotten 2,756,437,136 1,674,986.88 125,110.62
table scans (cache partitions) 14 0.01 0.00
table scans (long tables) 0 0.00 0.00
table scans (short tables) 21,061 12.80 0.96
total number of times SMON posted 3 0.00 0.00
transaction rollbacks 5 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 7,730,468 4,697.53 350.87
user I/O wait time 52,555 31.94 2.39
user calls 2,311,308 1,404.50 104.91
user commits 22,031 13.39 1.00
user rollbacks 1 0.00 0.00
workarea executions - onepass 3 0.00 0.00
workarea executions - optimal 10,648 6.47 0.48
write clones created in foreground 30 0.02 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 156,671 161,415
opened cursors current 452 529
workarea memory allocated 8,246,054 6,176,706
logons current 94 108

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 1 2.19

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
TEMP 5 0 0.00 3.40 47,966 29 0 0.00
JCMS20130309 1,058 1 261.82 1.09 2,025 1 213 574.79
SYSAUX 262 0 316.95 1.00 295 0 0 0.00
JCMS_INDEX 301 0 233.29 1.00 148 0 2 60.00
UNDOTBS1 15 0 533.33 1.00 122 0 1 0.00
SYSTEM 69 0 909.42 1.00 30 0 0 0.00
JCMS_INDEX2 4 0 1140.00 1.00 7 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)
JCMS20130309 /data/oracle/oradata/orcl/JCMS20130309.dbf 1,058 1 261.82 1.09 2,025 1 213 574.79
JCMS_INDEX /data/oracle/oradata/orcl/JCMS_INDEX.dbf 301 0 233.29 1.00 148 0 2 60.00
JCMS_INDEX2 /data/oracle/oradata/jcms_index2.dbf 4 0 1140.00 1.00 7 0 0 0.00
SYSAUX /data/oracle/oradata/orclsysaux01.dbf 262 0 316.95 1.00 295 0 0 0.00
SYSTEM /data/oracle/oradata/orclsystem01.dbf 69 0 909.42 1.00 30 0 0 0.00
TEMP /data/oracle/oradata/orcl/temp02.dbf 3 0 0.00 1.00 29,609 18 0  
TEMP /data/oracle/oradata/orcl/temp03.dbf 2 0 0.00 7.00 18,357 11 0  
UNDOTBS1 /data/oracle/oradata/orclundotbs01.dbf 15 0 533.33 1.00 122 0 1 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 732,230 100 230,092,157 1,356 4,371 0 0 199


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 11 1609 30382 123370 368640 123370  
E 0 12 1397 60773 151413 368640 151413  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 592 0.10 73,223 1460.53 1,596,876,080
D 1,184 0.20 146,446 484.72 529,973,040
D 1,776 0.30 219,669 212.94 232,820,165
D 2,368 0.40 292,892 109.16 119,347,439
D 2,960 0.50 366,115 53.83 58,860,242
D 3,552 0.60 439,338 30.71 33,579,776
D 4,144 0.70 512,561 15.38 16,811,124
D 4,736 0.80 585,784 6.39 6,985,043
D 5,328 0.90 659,007 2.08 2,273,389
D 5,920 1.00 732,230 1.01 1,099,690
D 5,936 1.00 734,209 1.00 1,093,356
D 6,512 1.10 805,453 0.79 860,865
D 7,104 1.20 878,676 0.76 827,225
D 7,696 1.30 951,899 0.76 827,225
D 8,288 1.40 1,025,122 0.76 827,225
D 8,880 1.50 1,098,345 0.76 827,225
D 9,472 1.60 1,171,568 0.76 827,225
D 10,064 1.70 1,244,791 0.76 827,225
D 10,656 1.80 1,318,014 0.76 827,225
D 11,248 1.89 1,391,237 0.76 827,225
D 11,840 1.99 1,464,460 0.76 827,196

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
98.10 13,374 259

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 5,120 2,689 8,519.87 8,118.69 95.29 100.00 0.00 83,207
E 5,120 3,000 7,650.26 6,543.98 85.54 100.00 0.00 93,026

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 6,883 6,883 0 0
64K 128K 537 537 0 0
128K 256K 1,155 1,155 0 0
256K 512K 69 69 0 0
512K 1024K 94 94 0 0
1M 2M 278 278 0 0
2M 4M 505 505 0 0
4M 8M 541 541 0 0
8M 16M 474 474 0 0
16M 32M 39 39 0 0
32M 64M 35 35 0 0
64M 128M 3 2 1 0
128M 256M 1 0 1 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
640 0.13 1,343,388.64 427,770.92 76.00 0
1,280 0.25 1,343,388.64 306,728.60 81.00 0
2,560 0.50 1,343,388.64 262,214.73 84.00 0
3,840 0.75 1,343,388.64 253,863.98 84.00 0
5,120 1.00 1,343,388.64 251,307.48 84.00 0
6,144 1.20 1,343,388.64 250,750.87 84.00 0
7,168 1.40 1,343,388.64 250,750.87 84.00 0
8,192 1.60 1,343,388.64 249,950.68 84.00 0
9,216 1.80 1,343,388.64 249,092.82 84.00 0
10,240 2.00 1,343,388.64 249,092.82 84.00 0
15,360 3.00 1,343,388.64 247,054.61 84.00 0
20,480 4.00 1,343,388.64 247,054.61 84.00 0
30,720 6.00 1,343,388.64 247,054.61 84.00 0
40,960 8.00 1,343,388.64 247,054.61 84.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
1,808 0.19 1,056 155,003 375,763 0.95 19,531 13.22 17,165,987
2,752 0.29 1,995 202,727 380,035 0.97 15,259 10.33 17,183,181
3,696 0.39 2,938 264,098 383,657 0.97 11,637 7.88 17,186,256
4,640 0.50 3,881 346,465 384,566 0.98 10,728 7.26 17,187,823
5,584 0.60 4,824 411,473 384,575 0.98 10,719 7.26 17,188,838
6,528 0.70 5,767 457,423 384,593 0.98 10,701 7.25 17,189,736
7,472 0.80 6,710 509,051 384,933 0.98 10,361 7.01 17,190,277
8,416 0.90 7,653 614,721 391,287 0.99 4,007 2.71 17,190,813
9,360 1.00 8,596 696,279 393,817 1.00 1,477 1.00 17,191,101
10,304 1.10 9,539 760,240 393,818 1.00 1,476 1.00 17,191,433
11,248 1.20 10,482 822,841 396,695 1.01 1 0.00 17,192,079
12,192 1.30 11,425 866,822 396,697 1.01 1 0.00 17,192,330
13,136 1.40 12,368 909,792 396,697 1.01 1 0.00 17,192,610
14,080 1.50 13,311 955,348 396,697 1.01 1 0.00 17,192,826
15,024 1.61 14,254 999,038 396,697 1.01 1 0.00 17,192,937
15,968 1.71 14,781 1,024,250 396,697 1.01 1 0.00 17,192,990
16,912 1.81 15,016 1,035,466 396,697 1.01 1 0.00 17,193,044
17,856 1.91 15,251 1,047,071 396,697 1.01 1 0.00 17,193,069
18,800 2.01 15,581 1,063,088 396,697 1.01 1 0.00 17,193,084

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
3,840 0.25 2,733,730 307,761,715
7,680 0.50 411,627 1,445,131
11,520 0.75 400,178 1,093,388
15,360 1.00 393,450 1,093,388
19,200 1.25 389,437 1,093,388
23,040 1.50 389,437 1,093,388
26,880 1.75 389,437 1,093,388
30,720 2.00 389,437 1,093,388

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 215 123 570
undo block 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)
CF-Controlfile Transaction 495 492 3 7 55 7,790.00
SQ-Sequence Cache 377 377 0 10 5 482.00
TX-Transaction (index contention) 13 13 0 9 4 481.11
US-Undo Segment 77 77 0 64 1 10.47
TX-Transaction (row lock contention) 3 3 0 3 0 3.33

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
1 1.09 24,366 1,847 11 23.75/43.7666666666666666666666666666666666667 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
06-May 10:25 190 4,179 1,847 5 44 0/0 0/0/0/0/0/0
06-May 10:15 558 15,522 1,246 11 34 0/0 0/0/0/0/0/0
06-May 10:05 340 4,665 645 10 24 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 db client latch 464 0.00   0 0  
AWR Alerted Metric Element list 9,138 0.00   0 0  
Consistent RBA 21,947 0.00   0 0  
FAL request queue 35 0.00   0 0  
FAL subheap alocation 35 0.00   0 0  
FIB s.o chain latch 12 0.00   0 0  
FOB s.o list latch 143 0.00   0 0  
In memory undo latch 86,292 0.02 0.71 0 22,941 0.00
JS mem alloc latch 1 0.00   0 0  
JS queue access latch 1 0.00   0 0  
JS queue state obj latch 11,844 0.00   0 0  
JS slv state obj latch 2 0.00   0 0  
KMG MMAN ready and startup request latch 551 0.00   0 0  
KTF sga latch 4 0.00   0 481 0.00
KWQP Prop Status 201 0.00   0 0  
MQL Tracking Latch 0     0 33 0.00
Memory Management Latch 0     0 551 0.00
Memory Queue 199 0.00   0 0  
OS process 1,764 0.00   0 0  
OS process allocation 1,733 0.06 0.00 0 0  
OS process: request allocation 1,174 0.17 0.00 0 0  
PL/SQL warning settings 637 0.00   0 0  
SQL memory manager latch 2 0.00   0 232 0.00
SQL memory manager workarea list latch 23,941 0.00   0 0  
Shared B-Tree 1,237 0.00   0 0  
active checkpoint queue latch 2,748 0.00   0 0  
active service list 5,162 0.02 0.00 0 568 0.00
archive control 34 0.00   0 0  
archive process latch 308 0.00   0 0  
begin backup scn array 10 0.00   0 0  
bq:time manger info latch 59 0.00   0 0  
buffer pool 1 0.00   0 0  
bufq statistics 201 0.00   0 0  
cache buffer handles 465 0.00   0 0  
cache buffers chains 461,110,770 0.27 0.00 0 8,799 0.00
cache buffers lru chain 15,052 0.00   0 12,077 0.01
cache table scan latch 0     0 49 0.00
channel handle pool latch 1,178 0.08 0.00 0 0  
channel operations parent latch 6,942 0.00   0 0  
checkpoint queue latch 73,400 0.00   0 4,048 0.00
client/application info 3,493 0.00   0 0  
compile environment latch 595 0.00   0 0  
dml lock allocation 49,017 0.01 0.00 0 0  
dummy allocation 1,177 0.08 1.00 0 0  
enqueue hash chains 210,308 0.01 0.00 0 228 0.00
enqueue sob latch 2 0.00   0 0  
enqueues 364,160 0.04 0.01 0 0  
event group latch 592 0.00   0 0  
file cache latch 86 0.00   0 0  
global KZLD latch for mem in SGA 590 0.00   0 0  
hash table column usage latch 161 0.00   0 167,463 0.00
hash table modification latch 66 0.00   0 0  
job_queue_processes parameter latch 27 0.00   0 0  
kks stats 73,671 0.12 0.45 0 0  
kokc descriptor allocation latch 2 0.00   0 0  
ksuosstats global area 112 0.00   0 0  
ktm global data 7 0.00   0 0  
kwqbsn:qsga 982 0.00   0 0  
lgwr LWN SCN 22,539 0.02 0.00 0 0  
library cache 1,350,178 0.07 0.29 1 27,520 1.03
library cache load lock 78 0.00   0 0  
library cache lock 479,049 0.02 0.00 0 0  
library cache lock allocation 2,401 0.00   0 0  
library cache pin 273,633 0.02 0.00 0 0  
library cache pin allocation 86 0.00   0 0  
list of block allocation 121 0.00   0 0  
loader state object freelist 47 0.00   0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 1 0.00   0 1 0.00
message pool operations parent latch 4 0.00   0 0  
messages 82,075 0.00 0.00 0 0  
mostly latch-free SCN 22,785 0.19 0.00 0 0  
multiblock read objects 254 0.00   0 0  
ncodef allocation latch 27 0.00   0 0  
object queue header heap 11,142 0.00   0 40 0.00
object queue header operation 38,230 0.00   0 0  
object stats modification 7 0.00   0 0  
parallel query alloc buffer 188 0.00   0 0  
parameter list 40 0.00   0 0  
parameter table allocation management 582 0.00   0 0  
post/wait queue 33,909 0.12 0.00 0 22,243 0.02
process allocation 1,174 0.85 0.90 0 591 0.17
process group creation 1,174 0.00   0 0  
qmn state object latch 3 0.00   0 0  
qmn task queue latch 2,293 16.53 0.48 0 0  
redo allocation 107,349 0.00 0.00 0 47,831 0.05
redo copy 0     0 47,840 0.06
redo writing 69,516 0.10 0.00 0 0  
resmgr group change latch 591 0.00   0 0  
resmgr:active threads 1,172 0.00   0 0  
resmgr:actses change group 592 0.00   0 0  
resmgr:free threads list 1,171 0.17 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 2,670,428 0.06 0.00 0 231 0.00
rules engine rule set statistics 100 0.00   0 0  
sequence cache 24,072 0.04 0.00 0 0  
session allocation 505,187 0.05 0.01 0 0  
session idle bit 4,814,997 0.00 0.00 0 0  
session state list latch 1,197 0.00   0 0  
session switching 27 0.00   0 0  
session timer 568 0.00   0 0  
shared pool 1,468,870 0.12 0.33 1 0  
shared pool sim alloc 2,279 0.00   0 0  
shared pool simulator 864,252 0.01 0.00 0 0  
simulator hash latch 15,605,637 0.00 0.01 0 0  
simulator lru latch 4,463 0.04 0.00 0 15,600,487 0.65
slave class 3 0.00   0 0  
slave class create 12 8.33 1.00 0 0  
sort extent pool 9,671 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 560 0.00   0 0  
threshold alerts latch 116 0.00   0 0  
trace latch 15 0.00   0 0  
transaction allocation 159 0.00   0 0  
transaction branch allocation 568 0.00   0 0  
undo global data 109,734 0.00 0.00 0 0  
user lock 2,336 0.13 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 461,110,770 1,259,982 135 1,259,852 0 0 0
shared pool 1,468,870 1,692 558 1,183 0 0 0
row cache objects 2,670,428 1,491 1 1,490 0 0 0
library cache 1,350,178 903 259 675 0 0 0
simulator hash latch 15,605,637 695 9 687 0 0 0
qmn task queue latch 2,293 379 182 197 0 0 0
session allocation 505,187 267 4 263 0 0 0
enqueues 364,160 134 1 133 0 0 0
kks stats 73,671 89 40 50 0 0 0
In memory undo latch 86,292 14 10 4 0 0 0
process allocation 1,174 10 9 1 0 0 0
dummy allocation 1,177 1 1 0 0 0 0
slave class create 12 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latch ktiFlush: child 0 10 7
In memory undo latch kticmt: child 0 2 1
cache buffers chains kcbgtcr: kslbegin excl 0 460 368
cache buffers chains kcbrls: kslbegin 0 95 189
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 13 11
cache buffers chains kcbget: pin buffer 0 3 2
cache buffers chains kcbgtcr: fast path 0 2 0
cache buffers chains kcbzwb 0 2 0
cache buffers chains kcbgcur: kslbegin 0 1 0
cache buffers chains kcbnew: new latch again 0 1 0
dummy allocation ktcscnfy 0 1 1
enqueues ksqgel: create enqueue 0 1 0
event range base latch No latch 0 182 182
kks stats kks stats alloc/free 0 40 40
library cache kglukp: child 0 38 57
library cache kglobpn: child: 0 7 3
library cache kglhdgn: child: 0 4 10
library cache kglpndl: child: after processing 0 3 1
library cache kgldti: 2child 0 2 0
library cache kglhdgc: child: 0 1 0
library cache lock kgllkdl: child: no lock handle 0 2 4
process allocation ksudlp 0 6 6
process allocation ksucrp 0 3 0
row cache objects kqrpre: find obj 0 1 1
session allocation ksuxds: KSUSFCLC not set 0 4 0
shared pool kghalo 0 274 157
shared pool kghfrunp: alloc: session dur 0 206 119
shared pool kghfrunp: clatch: wait 0 162 170
shared pool kghupr1 0 47 166
shared pool kghfrunp: clatch: nowait 0 40 0
shared pool kghfre 0 26 58
shared pool kghasp 0 3 11
shared pool kghalp 0 2 47
simulator hash latch kcbsacc: lookup dba 0 6 7
simulator hash latch kcbs_lookup_setid: lookup dba 0 3 2
slave class create ksvcreate 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
JCMS01 JCMS20130309 JCMS_INFO   TABLE 160,003,680 69.34
JCMS01 JCMS20130309 COMMON_PUBLISH_LIST   TABLE 29,730,864 12.88
JCMS01 JCMS20130309 JCMS_WEB2_SEARCHINFO   TABLE 14,960,240 6.48
JCMS01 JCMS20130309 JCMS_LINKINFO   TABLE 6,855,504 2.97
JCMS01 JCMS20130309 JCMS_INFOREF   TABLE 4,166,176 1.81

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
JCMS01 JCMS20130309 JCMS_WEB1_SEARCHINFO   TABLE 594 45.48
JCMS01 JCMS_INDEX C_INFO_INDEX   INDEX 231 17.69
JCMS01 JCMS20130309 JCMS_WEB17_SEARCHINFO   TABLE 191 14.62
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY 30414_5747 TABLE PARTITION 80 6.13
JCMS01 JCMS_INDEX B_INFO_INDEX   INDEX 70 5.36

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
JCMS01 JCMS20130309 SYS_C0015810   INDEX 5 26.32
JCMS01 JCMS20130309 PLUGIN_OSS_CONTRIBUTION   TABLE 4 21.05
SYS SYSAUX WRH$_SQLSTAT_PK 30414_5747 INDEX PARTITION 4 21.05
JCMS01 JCMS20130309 JCMS_INFO   TABLE 2 10.53
JCMS01 JCMS20130309 JCMS_INFO_M1   INDEX 2 10.53

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
JCMS01 JCMS20130309 MERP_PUB_USER   TABLE 71 73.96
JCMS01 JCMS20130309 SYS_C0015810   INDEX 6 6.25
JCMS01 JCMS20130309 JCMS_INFO   TABLE 5 5.21
JCMS01 JCMS20130309 JCMS_ART_VOTING_M1   INDEX 4 4.17
JCMS01 JCMS20130309 JCMS_ART_VOT_INDX1   INDEX 3 3.13

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 31 0.00 0   2 1
dc_database_links 1,183 0.00 0   0 1
dc_global_oids 10 0.00 0   0 4
dc_histogram_data 471,808 0.00 0   0 2,481
dc_histogram_defs 266,770 0.04 0   0 2,930
dc_object_ids 245,271 0.01 0   0 852
dc_objects 55,545 0.04 0   0 576
dc_profiles 590 0.00 0   0 1
dc_rollback_segments 975 0.00 0   26 62
dc_segments 113,691 0.02 0   9 914
dc_sequences 364 1.10 0   364 29
dc_tablespaces 1,897 0.00 0   0 13
dc_usernames 2,434 0.00 0   0 38
dc_users 47,469 0.00 0   0 51
outstanding_alerts 42 0.00 0   0 13


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 7 14.29 47 2.13 0 0
INDEX 1 0.00 10 0.00 0 0
SQL AREA 119,612 53.36 591,894 16.56 798 0
TABLE/PROCEDURE 3,503 0.43 162,929 0.02 14 0
TRIGGER 2,181 0.18 13,701 0.04 0 0


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 SQL 8,064.14 8,058.66 93.77 160.07 513 513 86 52
  Other 282.28   2.94 4.27 22 23 96 96
  Freeable 171.63 0.00 2.96 12.49 69   58 58
  PL/SQL 1.79 1.53 0.02 0.01 0 0 94 94
E SQL 6,026.95 6,022.64 60.88 132.46 513 513 99 79
  Freeable 811.88 0.00 31.23 56.44 211   26 26
  Other 284.73   2.59 3.84 22 23 110 110
  PL/SQL 2.18 1.85 0.02 0.01 0 0 108 108

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 6,207,569,920  
Fixed Size 2,112,088  
Redo Buffers 14,663,680  
Variable Size 9,881,781,672  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 16.00 16.00 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared CCursor 660.08 763.74 15.70
shared Cursor Stats 127.08 127.08 0.00
shared PCursor 849.62 896.81 5.55
shared free memory 3,429.90 2,786.69 -18.75
shared kglsim object batch 118.37 123.97 4.73
shared library cache 408.39 433.46 6.14
shared sql area 3,546.35 4,004.81 12.93
streams free memory 31.99 31.99 0.00
  buffer_cache 5,920.00 5,920.00 0.00
  fixed_sga 2.01 2.01 0.00
  log_buffer 13.98 13.98 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 81,318 0 0
QMON Coordinator 58,781 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

Queue Schema and NameIncoming per secondOutgoing per secondSpilled per secondDiff Pct Spilled
SYS.KUPC$S_1_20130412221201 0 0 0 0

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 0 0 0 0 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /u01/app/ora10g/admin/orcl/adump   
background_dump_dest /u01/app/ora10g/admin/orcl/bdump   
compatible 10.2.0.3.0   
control_files /data/oracle/oradata/orcl/control01.ctl, /data/oracle/oradata/orcl/control02.ctl, /data/oracle/oradata/orcl/control03.ctl   
core_dump_dest /u01/app/ora10g/admin/orcl/cdump   
cursor_sharing EXACT   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_name orcl   
db_recovery_file_dest /u01/app/ora10g/flash_recovery_area   
db_recovery_file_dest_size 2147483648   
dispatchers (PROTOCOL=TCP) (SERVICE=orclXDB)   
job_queue_processes 10   
log_archive_dest_1 location=/data/archive   
nls_territory AMERICA   
open_cursors 300   
optimizer_index_cost_adj 10   
pga_aggregate_target 5368709120   
processes 400   
remote_login_passwordfile EXCLUSIVE   
session_cached_cursors 100   
sessions 445   
sga_max_size 16106127360   
sga_target 16106127360   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest /u01/app/ora10g/admin/orcl/udump   


Back to Top

End of Report