WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
DSQQCMS3957709990dsqqcms110.2.0.4.0NOSVCTAG-JFHP53X

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:4228-4ÔÂ -12 14:00:1541 3.7
End Snap:4328-4ÔÂ -12 14:30:3635 2.3
Elapsed:  30.35 (mins)  
DB Time:  329.25 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 6,800M 6,800MStd Block Size: 8K
Shared Pool Size: 1,344M 1,344MLog Buffer: 14,352K

Load Profile

Per SecondPer Transaction
Redo size: 3,108.61 1,670.86
Logical reads: 952,053.46 511,723.68
Block changes: 15.84 8.51
Physical reads: 0.29 0.16
Physical writes: 1.87 1.00
User calls: 119.65 64.31
Parses: 56.05 30.13
Hard parses: 6.71 3.61
Sorts: 32.62 17.53
Logons: 0.06 0.03
Executes: 49.19 26.44
Transactions: 1.86 

% Blocks changed per Read: 0.00Recursive Call %: 16.64
Rollback per transaction %: 0.00Rows per Sort: 7093.94

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 100.00In-memory Sort %: 100.00
Library Hit %: 82.64Soft Parse %: 88.02
Execute to Parse %: -13.95Latch Hit %: 82.43
Parse CPU to Parse Elapsd %: 104.19% Non-Parse CPU: 99.90

Shared Pool Statistics

BeginEnd
Memory Usage %: 82.13 77.53
% SQL with executions>1: 84.38 71.46
% Memory for SQL w/exec>1: 83.69 69.42

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  14,203  71.9 
latch: cache buffers chains 42,732,032 5,609 0 28.4Concurrency
SQL*Net break/reset to client 13,732 3 0 .0Application
wait list latch free 715 3 4 .0Other
log file sync 3,517 1 0 .0Commit

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 19,732.22 99.89
DB CPU 14,202.51 71.89
parse time elapsed 13.40 0.07
hard parse elapsed time 9.26 0.05
failed parse elapsed time 1.11 0.01
hard parse (sharing criteria) elapsed time 0.28 0.00
connection management call elapsed time 0.28 0.00
PL/SQL execution elapsed time 0.01 0.00
sequence load elapsed time 0.01 0.00
repeated bind elapsed time 0.00 0.00
DB time 19,754.86  
background elapsed time 7.69  
background cpu time 6.78  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Concurrency 42,732,048 0.00 5,609 0 12,612.77
Application 13,732 0.00 3 0 4.05
Other 727 0.00 3 4 0.21
System I/O 8,287 0.00 1 0 2.45
Commit 3,517 0.00 1 0 1.04
User I/O 632 0.00 1 1 0.19
Network 206,187 0.00 0 0 60.86

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
latch: cache buffers chains 42,732,032 0.00 5,609 0 12,612.76
SQL*Net break/reset to client 13,732 0.00 3 0 4.05
wait list latch free 715 0.00 3 4 0.21
log file sync 3,517 0.00 1 0 1.04
direct path read 447 0.00 0 1 0.13
log file parallel write 3,577 0.00 0 0 1.06
db file parallel write 2,712 0.00 0 0 0.80
SQL*Net message to client 201,799 0.00 0 0 59.56
db file sequential read 80 0.00 0 3 0.02
control file sequential read 1,388 0.00 0 0 0.41
control file parallel write 610 0.00 0 0 0.18
SQL*Net more data to client 3,744 0.00 0 0 1.11
os thread startup 4 0.00 0 12 0.00
SQL*Net more data from client 644 0.00 0 0 0.19
Data file init write 12 0.00 0 1 0.00
direct path write 92 0.00 0 0 0.03
latch free 10 0.00 0 1 0.00
latch: shared pool 5 0.00 0 1 0.00
rdbms ipc reply 1 0.00 0 1 0.00
buffer busy waits 2 0.00 0 0 0.00
latch: In memory undo latch 1 0.00 0 0 0.00
latch: library cache 1 0.00 0 0 0.00
db file single write 1 0.00 0 0 0.00
LGWR wait for redo copy 1 0.00 0 0 0.00
latch: row cache objects 3 0.00 0 0 0.00
SQL*Net message from client 201,810 0.00 33,301 165 59.57
Streams AQ: waiting for time management or cleanup tasks 1 100.00 2,978 2977677 0.00
virtual circuit status 61 100.00 1,826 29939 0.02
Streams AQ: qmn slave idle wait 65 0.00 1,814 27911 0.02
Streams AQ: qmn coordinator idle wait 132 50.76 1,814 13744 0.04
jobq slave wait 40 100.00 120 2999 0.01
class slave wait 2 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
log file parallel write 3,577 0.00 0 0 1.06
db file parallel write 2,712 0.00 0 0 0.80
control file parallel write 607 0.00 0 0 0.18
control file sequential read 691 0.00 0 0 0.20
os thread startup 4 0.00 0 12 0.00
events in waitclass Other 1 0.00 0 0 0.00
direct path write 1 0.00 0 0 0.00
rdbms ipc message 10,615 66.36 19,993 1883 3.13
Streams AQ: waiting for time management or cleanup tasks 1 100.00 2,978 2977677 0.00
smon timer 7 100.00 1,917 273830 0.00
pmon timer 13,090 4.62 1,817 139 3.86
Streams AQ: qmn slave idle wait 65 0.00 1,814 27911 0.02
Streams AQ: qmn coordinator idle wait 132 50.76 1,814 13744 0.04

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 59,408
AVG_IDLE_TIME 122,579
AVG_SYS_TIME ###############
AVG_USER_TIME 58,971
BUSY_TIME 1,427,196
IDLE_TIME 2,943,283
SYS_TIME 10,538
USER_TIME 1,416,658
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES ###############
VM_OUT_BYTES ###############
PHYSICAL_MEMORY_BYTES 34,345,619,456
NUM_CPUS 24
NUM_CPU_CORES 2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 19,754.90 14,202.50 517 1,733,712,580
DSQQCMS 0.00 0.00 0 0
DSQQCMSXDB 0.00 0.00 0 0
SYS$BACKGROUND 0.00 0.00 15 13,739

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 583 50 42731955 560928 0 0 205817 32
DSQQCMS 0 0 0 0 0 0 0 0
SYS$BACKGROUND 49 11 4 5 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
1,770 1,296 6 294.98 8.96 gmm6ktqrft6n1   select rowid, title, filep...
678 676 234 2.90 3.43 06r32459s5kzc   select rowid, ArticleID, S...
641 377 2 320.67 3.25 46g6przk5zzd6   select rowid, title, filep...
570 310 2 285.06 2.89 bxa7c0y5p6smg   select rowid, title, filep...
504 246 2 251.80 2.55 9m0df2u0hq0a3   select rowid, title, filep...
479 222 1 479.07 2.43 42p76ntbk36s7   select rowid, title, filep...
465 279 2 232.34 2.35 68pwkvkgs7taj   select rowid, title, filep...
436 209 1 435.81 2.21 asutk4a2q7bjr   select rowid, title, filep...
432 207 1 432.10 2.19 7jnmh71dpd33t   select rowid, title, filep...
392 234 2 195.96 1.98 f442cdh9hp6sk   select rowid, title, filep...
356 195 1 356.14 1.80 adjykgtx1c6f5   select rowid, title, filep...
350 199 1 350.35 1.77 3cmjhwmg4cr77   select rowid, title, filep...
348 187 1 347.66 1.76 chh3zytwqh5da   select rowid, title, filep...
346 187 1 346.47 1.75 0rtu86j0cruw6   select rowid, title, filep...
337 181 1 336.54 1.70 753tqna67s31z   select rowid, title, filep...
330 312 2 164.95 1.67 731rq4a5rd9by   select rowid, title, filep...
330 181 1 329.86 1.67 f2g5r0n3rzx8b   select rowid, title, filep...
323 181 1 323.49 1.64 4njfq9ukts180   select rowid, title, filep...
305 181 1 304.93 1.54 4yq9fnxa9chq0   select rowid, title, filep...
299 186 1 299.01 1.51 dgd8f0h5zsqtt   select rowid, title, filep...
292 182 1 291.71 1.48 2ppbrbmspht5w   select rowid, title, filep...
288 175 1 288.06 1.46 8f2nkcw9sh7kt   select rowid, title, filep...
263 171 1 263.34 1.33 dc11ra38d2cfr   select rowid, title, filep...
258 157 1 258.30 1.31 21avrksszdzpv   select rowid, title, filep...
246 155 1 245.71 1.24 8k57ucpzm2t88   select rowid, title, filep...
241 161 1 241.19 1.22 4jnmvaqva8jka   select rowid, title, filep...
237 154 1 236.53 1.20 gudw3y40c9r6f   select rowid, title, filep...
234 146 1 233.98 1.18 06b2hthmk8ckn   select rowid, title, filep...
228 142 1 227.86 1.15 c3v2dg0b4cwbb   select rowid, title, filep...
226 149 1 226.14 1.14 cwrq283s67xf1   select rowid, title, filep...
217 146 1 216.83 1.10 fzd3w5kxdbx20   select rowid, title, filep...

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
1,296 1,770 6 216.05 8.96 gmm6ktqrft6n1   select rowid, title, filep...
676 678 234 2.89 3.43 06r32459s5kzc   select rowid, ArticleID, S...
377 641 2 188.27 3.25 46g6przk5zzd6   select rowid, title, filep...
312 330 2 155.85 1.67 731rq4a5rd9by   select rowid, title, filep...
310 570 2 155.06 2.89 bxa7c0y5p6smg   select rowid, title, filep...
279 465 2 139.55 2.35 68pwkvkgs7taj   select rowid, title, filep...
246 504 2 122.88 2.55 9m0df2u0hq0a3   select rowid, title, filep...
234 392 2 117.22 1.98 f442cdh9hp6sk   select rowid, title, filep...
222 479 1 222.18 2.43 42p76ntbk36s7   select rowid, title, filep...
209 436 1 209.43 2.21 asutk4a2q7bjr   select rowid, title, filep...
207 432 1 207.08 2.19 7jnmh71dpd33t   select rowid, title, filep...
199 350 1 198.52 1.77 3cmjhwmg4cr77   select rowid, title, filep...
195 356 1 194.79 1.80 adjykgtx1c6f5   select rowid, title, filep...
187 346 1 187.19 1.75 0rtu86j0cruw6   select rowid, title, filep...
187 348 1 187.05 1.76 chh3zytwqh5da   select rowid, title, filep...
186 299 1 185.62 1.51 dgd8f0h5zsqtt   select rowid, title, filep...
182 292 1 181.54 1.48 2ppbrbmspht5w   select rowid, title, filep...
181 305 1 181.49 1.54 4yq9fnxa9chq0   select rowid, title, filep...
181 330 1 181.38 1.67 f2g5r0n3rzx8b   select rowid, title, filep...
181 337 1 181.11 1.70 753tqna67s31z   select rowid, title, filep...
181 323 1 180.88 1.64 4njfq9ukts180   select rowid, title, filep...
175 288 1 175.08 1.46 8f2nkcw9sh7kt   select rowid, title, filep...
171 263 1 170.79 1.33 dc11ra38d2cfr   select rowid, title, filep...
161 241 1 161.05 1.22 4jnmvaqva8jka   select rowid, title, filep...
157 258 1 157.33 1.31 21avrksszdzpv   select rowid, title, filep...
155 246 1 154.83 1.24 8k57ucpzm2t88   select rowid, title, filep...
154 237 1 153.99 1.20 gudw3y40c9r6f   select rowid, title, filep...
149 226 1 148.57 1.14 cwrq283s67xf1   select rowid, title, filep...
146 217 1 146.38 1.10 fzd3w5kxdbx20   select rowid, title, filep...
146 234 1 145.81 1.18 06b2hthmk8ckn   select rowid, title, filep...
142 228 1 142.26 1.15 c3v2dg0b4cwbb   select rowid, title, filep...

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
150,857,840 6 25,142,973.33 8.70 1296.33 1769.90 gmm6ktqrft6n1   select rowid, title, filep...
57,452,737 234 245,524.52 3.31 676.45 678.49 06r32459s5kzc   select rowid, ArticleID, S...
50,264,264 2 25,132,132.00 2.90 311.70 329.90 731rq4a5rd9by   select rowid, title, filep...
28,441,522 2 14,220,761.00 1.64 310.11 570.12 bxa7c0y5p6smg   select rowid, title, filep...
28,440,949 2 14,220,474.50 1.64 279.11 464.68 68pwkvkgs7taj   select rowid, title, filep...
28,433,242 2 14,216,621.00 1.64 234.45 391.91 f442cdh9hp6sk   select rowid, title, filep...
28,432,028 2 14,216,014.00 1.64 376.54 641.33 46g6przk5zzd6   select rowid, title, filep...
28,428,468 2 14,214,234.00 1.64 245.76 503.60 9m0df2u0hq0a3   select rowid, title, filep...
16,070,079 63 255,080.62 0.93 176.17 176.73 5jjk0pcxyhn50   select rowid, ArticleID, S...
14,221,600 1 14,221,600.00 0.82 157.33 258.30 21avrksszdzpv   select rowid, title, filep...

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
11 1 11.00 2.08 0.01 0.01 0dwr2vd6vbqzs   SELECT count(*) over () as tot...
0 4 0.00 0.00 0.00 0.00 04xtrk7uyhknh   select obj#, type#, ctime, mti...
0 1 0.00 0.00 145.81 233.98 06b2hthmk8ckn   select rowid, title, filep...
0 234 0.00 0.00 676.45 678.49 06r32459s5kzc   select rowid, ArticleID, S...
0 746 0.00 0.00 0.05 0.05 0b0pshdtu62uq   select rowid, ClassID, ClassN...
0 1 0.00 0.00 187.19 346.47 0rtu86j0cruw6   select rowid, title, filep...
0 884 0.00 0.00 0.07 0.07 0spyvxw3mjfq1   select rowid, ClassID, ClassN...
0 1 0.00 0.00 0.00 0.00 0vwa9n600yvgm   SELECT sum(delta_cpu_time) as ...
0 2 0.00 0.00 0.00 0.00 10xj8nynmpqtq   SELECT dbin.db_name, dbin.ins...
0 884 0.00 0.00 0.06 0.06 13vskq2q5jvhk   select rowid, ClassID, ClassN...

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
7,376 7,376 1.00 0.00 0.00 520mkxqpf15q8   select 1 from dual
1,885 1,885 1.00 0.00 0.00 bmu0axt874vhg   select rowid, LinkUrl, fil...
1,440 1,440 1.00 0.00 0.00 1yqap269f30av   select rowid, ClassName FROM ...
1,126 1,126 1.00 0.00 0.00 4vch3hvcrchc8   select rowid, ClassName FROM ...
1,070 0 0.00 0.00 0.00 6r9qfcm69dxdz   select rowid, ClassID, ClassN...
1,054 0 0.00 0.00 0.00 6qvrp6yyu2mdg   select rowid, ClassID, ClassN...
1,018 0 0.00 0.00 0.00 4ubhh0upvybwp   select rowid, ClassID, ClassN...
952 0 0.00 0.00 0.00 5j0q9a0bs6fhj   select rowid, ClassID, ClassN...
940 940 1.00 0.00 0.00 51m750uwchh0d   select rowid, ClassName FROM ...
894 0 0.00 0.00 0.00 9v19c6dp27m92   select rowid, ClassID, ClassN...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
7,376 7,376 7.23 520mkxqpf15q8   select 1 from dual
1,885 1,885 1.85 bmu0axt874vhg   select rowid, LinkUrl, fil...
1,440 1,440 1.41 1yqap269f30av   select rowid, ClassName FROM ...
1,126 1,126 1.10 4vch3hvcrchc8   select rowid, ClassName FROM ...
1,070 1,070 1.05 6r9qfcm69dxdz   select rowid, ClassID, ClassN...
1,054 1,054 1.03 6qvrp6yyu2mdg   select rowid, ClassID, ClassN...
1,018 1,018 1.00 4ubhh0upvybwp   select rowid, ClassID, ClassN...
952 952 0.93 5j0q9a0bs6fhj   select rowid, ClassID, ClassN...
940 940 0.92 51m750uwchh0d   select rowid, ClassName FROM ...
894 894 0.88 9v19c6dp27m92   select rowid, ClassID, ClassN...

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
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
06b2hthmk8cknselect rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220150 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '°Í»ù˹̹×ÜÀí' OR k.KeyWord = '²©ÑÅ' OR k.KeyWord = '¿ØÖÆ' OR k.KeyWord = 'Ï»÷±©Á÷' OR k.KeyWord = 'ÔËÓªÉÌ') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
06r32459s5kzcselect rowid, ArticleID, SpecialID, ClassID, Title, TitleFontColor, TitleFontType, TitleFontSize, filepath, filename, LayoutPath, InfoLink, PublishDate FROM (SELECT ArticleID, SpecialID, ClassID, Title, TitleFontColor, TitleFontType, TitleFontSize, filepath, filename, LayoutPath, InfoLink, PublishDate FROM Article WHERE Deleted = 0 AND ToHtml = 1 AND ClassID in ( 1 , 5 , 562 , 563 , 564 , 565 , 566 , 567 , 568 , 482 , 483 , 484 , 485 , 569 , 574 , 575 , 576 , 577 , 578 , 579 , 14 , 13 , 112 , 155 , 559 , 10 , 12 , 382 , 493 , 8 , 23 , 24 , 113 , 21 , 22 , 383 , 942 , 556 , 6 , 17 , 18 , 557 , 528 , 1050 ) AND CssType = 'none' AND Passed = 1 ORDER BY OnTop DESC, UpdateTime DESC )WHERE ROWNUM < 11
0b0pshdtu62uqselect rowid, ClassID, ClassName from ArticleClass where ParentID=12 order by orderid Asc
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
0rtu86j0cruw6select rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220193 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '²ð³ý' OR k.KeyWord = '³Öǹ' OR k.KeyWord = 'ºÓÅÏÑÅÊû' OR k.KeyWord = 'Çá΢ÉË' OR k.KeyWord = 'ͨ±¨') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
0spyvxw3mjfq1select rowid, ClassID, ClassName from ArticleClass where ParentID=483 order by orderid Asc
0vwa9n600yvgm SELECT sum(delta_cpu_time) as total_cpu, sum(case when session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' ) then delta_cpu_time else 0 end) as logmr_cpu, sum(case when session_type in ( 'STREAMS Capture' ) then delta_cpu_time else 0 end) as captr_cpu, sum(case when session_type in ( 'Propagation Sender' , 'Propagation Receiver' ) then delta_cpu_time else 0 end) as prpgt_cpu, sum(case when session_type in ( 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' ) then delta_cpu_time else 0 end) as apply_cpu, sum(case when session_type in ( 'QMON Slaves' , 'QMON Coordinator' ) then delta_cpu_time else 0 end) as qmon_cpu FROM ( SELECT b.session_type, (case when b.min_logon_time = e.min_logon_time then e.sum_cpu_time - b.sum_cpu_time else e.sum_cpu_time end) as delta_cpu_time FROM wrh$_sess_time_stats b, wrh$_sess_time_stats e WHERE b.dbid = :dbid AND b.instance_number = :instance_number AND b.snap_id = :startsn AND e.dbid = :dbid AND e.instance_number = :instance_number AND e.snap_id = :endsn AND e.se ssion_type = b.session_type AND e.session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' , 'STREAMS Capture' , 'Propagation Sender' , 'Propagation Receiver' , 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' , 'QMON Slaves' , 'QMON Coordinator' ) ) all_types
10xj8nynmpqtq SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time
13vskq2q5jvhkselect rowid, ClassID, ClassName from ArticleClass where ParentID=24 order by orderid Asc
1yqap269f30avselect rowid, ClassName FROM ArticleClass WHERE ClassID = 155 AND ROWNUM < 2
21avrksszdzpvselect rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220171 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '°®Ó빷ͬÐÐ' OR k.KeyWord = '°²¸ñ¶û' OR k.KeyWord = '³Â°²ç÷' OR k.KeyWord = 'ÍâÍâÍâ' OR k.KeyWord = 'Ò󺣹â') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
2ppbrbmspht5wselect rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220189 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = 'ºÉÀ¼' OR k.KeyWord = '»ÝÓþ' OR k.KeyWord = '½ôËõÕþ²ß' OR k.KeyWord = 'Å·ÔªÇø' OR k.KeyWord = '×ÔÓɵ³') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
3cmjhwmg4cr77select rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220194 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '°ÍÊïËÉ' OR k.KeyWord = 'ÀûÂÊ·çÏÕ' OR k.KeyWord = 'ÀûÂÊÊг¡»¯' OR k.KeyWord = '΢²©' OR k.KeyWord = 'Ï´ÅÆ') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
42p76ntbk36s7select rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220183 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '³Â½ð' OR k.KeyWord = 'ÁÖµ¤' OR k.KeyWord = 'Äе¥°ë¾öÈü' OR k.KeyWord = 'ÍËÈü' OR k.KeyWord = 'ÑǽõÈü') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
46g6przk5zzd6select rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220188 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '³¤½­½­ëà' OR k.KeyWord = '¶´Í¥ºþ' OR k.KeyWord = 'ËÀÍö' OR k.KeyWord = 'Û¶Ñôºþ' OR k.KeyWord = 'Û¶ÑôÏØ') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
4jnmvaqva8jkaselect rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220201 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '±£ÏÕÒµ·¢Õ¹' OR k.KeyWord = '±£ÏÕÒµ¸Ä¸ï' OR k.KeyWord = '¿Æѧ·¢Õ¹¹Û' OR k.KeyWord = 'ÍõáªÉ½' OR k.KeyWord = 'Îȶ¨·¢Õ¹') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
4njfq9ukts180select rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220198 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '¼Æ»®' OR k.KeyWord = '½Ìѧ' OR k.KeyWord = '¿ªÑ§' OR k.KeyWord = 'Åàѵ°à' OR k.KeyWord = '΢²©') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
4ubhh0upvybwpselect rowid, ClassID, ClassName from ArticleClass where ParentID=562 order by orderid Asc
4vch3hvcrchc8select rowid, ClassName FROM ArticleClass WHERE ClassID = 563 AND ROWNUM < 2
4yq9fnxa9chq0select rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220199 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '½ºÄÒ¼Á' OR k.KeyWord = 'ÎÊÌâ²úÆ·' OR k.KeyWord = 'Ò©Æ·Éú²úÆóÒµ' OR k.KeyWord = 'Ò©ÓÃÃ÷½º' OR k.KeyWord = 'Ò½ÁÆ»ú¹¹') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
51m750uwchh0dselect rowid, ClassName FROM ArticleClass WHERE ClassID = 566 AND ROWNUM < 2
520mkxqpf15q8select 1 from dual
5j0q9a0bs6fhjselect rowid, ClassID, ClassName from ArticleClass where ParentID=566 order by orderid Asc
5jjk0pcxyhn50select rowid, ArticleID, SpecialID, ClassID, Title, TitleFontColor, TitleFontType, TitleFontSize, filepath, filename, LayoutPath, InfoLink FROM (SELECT ArticleID, SpecialID, ClassID, Title, TitleFontColor, TitleFontType, TitleFontSize, filepath, filename, LayoutPath, InfoLink FROM Article WHERE Deleted = 0 AND ToHtml = 1 AND ClassID in ( 1 , 5 , 562 , 563 , 564 , 565 , 566 , 567 , 568 , 482 , 483 , 484 , 485 , 569 , 574 , 575 , 576 , 577 , 578 , 579 , 14 , 13 , 112 , 155 , 559 , 10 , 12 , 382 , 493 , 8 , 23 , 24 , 113 , 21 , 22 , 383 , 942 , 556 , 6 , 17 , 18 , 557 , 528 , 1050 ) AND CssType = 'none' AND Passed = 1 ORDER BY Hits DESC )WHERE ROWNUM < 11
68pwkvkgs7tajselect rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220192 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '´óѧÉú´å¹Ù' OR k.KeyWord = '·þÎñȺÖÚ' OR k.KeyWord = '¼¨Ð§¹¤×Ê' OR k.KeyWord = 'È«¶î²¦¿îÊÂÒµµ¥Î»' OR k.KeyWord = 'ÊÂÒµ±àÖÆ') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
6qvrp6yyu2mdgselect rowid, ClassID, ClassName from ArticleClass where ParentID=5 order by orderid Asc
6r9qfcm69dxdzselect rowid, ClassID, ClassName from ArticleClass where ParentID=155 order by orderid Asc
731rq4a5rd9byselect rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220089 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '°ÜѪÐÔÐÝ¿Ë' OR k.KeyWord = '¼¦Èâ¾í' OR k.KeyWord = '¿ÏµÂ»ù' OR k.KeyWord = 'ĪÄÝ¿¨' OR k.KeyWord = 'ÄÔËðÉË' OR k.KeyWord = 'Å®º¢' OR k.KeyWord = 'ÈøÂü' OR k.KeyWord = 'ËÄ̱֫»¾' OR k.KeyWord = 'ÑÔÓ﹦ÄÜÕÏ°­' OR k.KeyWord = 'Ö¢×´') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
753tqna67s31zselect rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220196 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '³¡Ãæ' OR k.KeyWord = '»ý·ÖÖÆ' OR k.KeyWord = 'ÈëÔ°' OR k.KeyWord = '΢²©' OR k.KeyWord = 'Ó׶ùÔ°') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
7jnmh71dpd33tselect rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220180 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '·´ÅɽÇÉ«' OR k.KeyWord = '¹ÛÖÚ¼ûÃæ' OR k.KeyWord = 'ɱÉú' OR k.KeyWord = 'ËÕÓÐÅó' OR k.KeyWord = 'ãë´¨') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
8f2nkcw9sh7ktselect rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220147 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = 'µÀǸ' OR k.KeyWord = 'Ãñµ÷' OR k.KeyWord = '˫ɱ' OR k.KeyWord = 'ÍÚ½Ç' OR k.KeyWord = '×îºó³å´Ì') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
8k57ucpzm2t88select rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220170 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '±ùµº' OR k.KeyWord = '¸ñÀïÄ·ËÉ' OR k.KeyWord = 'μұ¦' OR k.KeyWord = 'Öз½Ô¸' OR k.KeyWord = '×Üͳ') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
9m0df2u0hq0a3select rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220184 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '¹«ÎñÔ±¿¼ÊÔ' OR k.KeyWord = '¿¼Éú' OR k.KeyWord = 'Éí·Ý֤ʶ±ðÒÇ' OR k.KeyWord = 'ÎÞÏßµç¼à²â' OR k.KeyWord = '×÷±×') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
9v19c6dp27m92select rowid, ClassID, ClassName from ArticleClass where ParentID=564 order by orderid Asc
adjykgtx1c6f5select rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220190 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = 'µØÍõ' OR k.KeyWord = '·¿Ô´' OR k.KeyWord = '¾ù¼Û' OR k.KeyWord = '¿ªÅÌ' OR k.KeyWord = 'Â¥°å¼Û') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
asutk4a2q7bjrselect rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220181 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '³£¹æÈü' OR k.KeyWord = '¿Æ±È' OR k.KeyWord = '¿Í³¡ÌôÕ½' OR k.KeyWord = 'ÂåÉ¼í¶ºþÈË' OR k.KeyWord = 'Âí´Ì') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
bmu0axt874vhgselect rowid, LinkUrl, filepath, LayoutPath, ParentID, ClassName FROM ArticleClass WHERE ClassID = 1 AND ROWNUM < 2
bxa7c0y5p6smgselect rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220185 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '´óѧÉú´å¹Ù' OR k.KeyWord = 'Äê¶È¹¤×÷' OR k.KeyWord = 'Å©´å»·¾³' OR k.KeyWord = 'ÏçÕò' OR k.KeyWord = 'ѧʱ') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
c3v2dg0b4cwbbselect rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220169 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '¹âѧĤ' OR k.KeyWord = '¿­öÎ' OR k.KeyWord = 'ÃñÆó' OR k.KeyWord = 'ÌìÔÆ' OR k.KeyWord = 'Õ½ÂÔÐÔ') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
chh3zytwqh5daselect rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220195 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '¹º·¿' OR k.KeyWord = 'ÆÕͨÉÌÆ··¿' OR k.KeyWord = 'ÓÅ»ÝÕþ²ß' OR k.KeyWord = 'Õþ²ß»úÖÆ' OR k.KeyWord = 'ÖÐСÌ×ÐÍ') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
cwrq283s67xf1select rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220178 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '·²È˸è' OR k.KeyWord = '»ð¹øµê' OR k.KeyWord = '¼ÅįÄÑÄÍ' OR k.KeyWord = 'Àî×ÚÊ¢' OR k.KeyWord = 'ÏÖ³¡¸èÃÔ') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
dc11ra38d2cfrselect rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220187 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = 'KO' OR k.KeyWord = '»ì´î' OR k.KeyWord = 'ÄÂÀïÄá°Â' OR k.KeyWord = 'ÐÔ°®' OR k.KeyWord = 'ÕÕƬÆعâ') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
dgd8f0h5zsqttselect rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220200 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '±©×ß' OR k.KeyWord = '´´¿ÉÌù' OR k.KeyWord = 'бø' OR k.KeyWord = '×°±¸' OR k.KeyWord = 'áôáô') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
f2g5r0n3rzx8bselect rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220197 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '³ÂÔÆÓëÖйú¹²²úµ³' OR k.KeyWord = '¸ßУ' OR k.KeyWord = '΢²©' OR k.KeyWord = 'Öйú¹²²úµ³' OR k.KeyWord = 'רÌâ') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
f442cdh9hp6skselect rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220191 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '´òÕÛ' OR k.KeyWord = '·¿´ûÀûÂÊ' OR k.KeyWord = '·¿¼Ûµ÷¿Ø' OR k.KeyWord = '¹º·¿Õß' OR k.KeyWord = 'Ò×ÏÜÈÝ') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
fzd3w5kxdbx20select rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220179 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '´©Ë¯ÒÂ' OR k.KeyWord = 'Èø¶¥¶¥' OR k.KeyWord = '΢²©' OR k.KeyWord = 'Î̺ç' OR k.KeyWord = 'Õź¬ÔÏ') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
gmm6ktqrft6n1select rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220127 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '°ÜѪÐÔÐÝ¿Ë' OR k.KeyWord = '³ÉÄ꼦' OR k.KeyWord = '·úà­ÅµÍªÀ࿹¾úÒ©' OR k.KeyWord = '»·±û·úßßËá' OR k.KeyWord = '¼¦°×Á¡' OR k.KeyWord = '¼¦Èâ¾í' OR k.KeyWord = '½â¾·¼Á' OR k.KeyWord = '¿ÏµÂ»ù' OR k.KeyWord = 'ÑÔÓ﹦ÄÜÕÏ°­' OR k.KeyWord = 'Òæ±£ÊÀÁé') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6
gudw3y40c9r6fselect rowid, title, filepath, filename, layoutpath, publishdate, classid, infolink, defaultpicurl, hits FROM (SELECT t.Title as title, t.FilePath as filepath, t.FileName as filename, t.LayOutPath as layoutpath, t.PublishDate as publishdate, t.ClassID as classid, t.InfoLink as infolink, t.DefaultPicUrl as defaultpicurl, t.Hits as hits FROM Article t WHERE EXISTS ( SELECT a.ArticleID FROM Article a, ArticleKeyWord k WHERE a.Deleted = 0 AND a.Passed = 1 AND a.ToHtml = 1 AND a.ArticleID != 1220177 AND t.ArticleID = a.ArticleID AND a.InfoShareType = 0 AND a.ArticleID = k.INFOID AND (k.KeyWord = '·¶çâç÷' OR k.KeyWord = '¸èÃÔ' OR k.KeyWord = '¸èÓÑ»á' OR k.KeyWord = 'ÀϹ«' OR k.KeyWord = 'ÃÀ¸è') ) AND t.SiteID = 202 AND t.cssType = 'none' ORDER BY t.ArticleID DESC )WHERE ROWNUM < 6

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 1,400,184 768.90 413.28
CPU used when call started 1,400,163 768.88 413.27
CR blocks created 6,433 3.53 1.90
Cached Commit SCN referenced 324 0.18 0.10
Commit SCN cached 1 0.00 0.00
DB time 1,964,963 1,079.04 579.98
DBWR checkpoint buffers written 3,258 1.79 0.96
DBWR checkpoints 0 0.00 0.00
DBWR object drop buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 70 0.04 0.02
DBWR undo block writes 261 0.14 0.08
IMU CR rollbacks 0 0.00 0.00
IMU Flushes 112 0.06 0.03
IMU Redo allocation size 345,656 189.81 102.02
IMU commits 3,276 1.80 0.97
IMU contention 0 0.00 0.00
IMU ktichg flush 0 0.00 0.00
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 0 0.00 0.00
IMU undo allocation size 9,555,344 5,247.21 2,820.35
IMU- failed to get a private strand 0 0.00 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 0 0.00 0.00
PX local messages sent 0 0.00 0.00
SQL*Net roundtrips to/from client 201,423 110.61 59.45
active txn count during cleanout 54 0.03 0.02
application wait time 326 0.18 0.10
background checkpoints completed 0 0.00 0.00
background checkpoints started 0 0.00 0.00
background timeouts 7,048 3.87 2.08
branch node splits 0 0.00 0.00
buffer is not pinned count 649,906,225 356,888.96 191,825.92
buffer is pinned count 101,482,686 55,728.12 29,953.57
bytes received via SQL*Net from client 24,040,853 13,201.77 7,095.88
bytes sent via SQL*Net to client 55,839,800 30,663.82 16,481.64
calls to get snapshot scn: kcmgss 225,921 124.06 66.68
calls to kcmgas 10,264 5.64 3.03
calls to kcmgcs 91 0.05 0.03
change write time 23 0.01 0.01
cleanout - number of ktugct calls 73 0.04 0.02
cleanouts and rollbacks - consistent read gets 0 0.00 0.00
cleanouts only - consistent read gets 13 0.01 0.00
cluster key scan block gets 290 0.16 0.09
cluster key scans 160 0.09 0.05
commit batch/immediate performed 2 0.00 0.00
commit batch/immediate requested 2 0.00 0.00
commit cleanout failures: block lost 0 0.00 0.00
commit cleanout failures: callback failure 4 0.00 0.00
commit cleanout failures: cannot pin 0 0.00 0.00
commit cleanouts 6,241 3.43 1.84
commit cleanouts successfully completed 6,237 3.42 1.84
commit immediate performed 2 0.00 0.00
commit immediate requested 2 0.00 0.00
commit txn count during cleanout 41 0.02 0.01
concurrency wait time 560,984 308.06 165.58
consistent changes 17,129 9.41 5.06
consistent gets 1,733,690,787 952,037.52 511,715.11
consistent gets - examination 991,077,375 544,239.41 292,525.79
consistent gets direct 535 0.29 0.16
consistent gets from cache 1,733,690,255 952,037.23 511,714.95
cursor authentications 810 0.44 0.24
data blocks consistent reads - undo records applied 17,129 9.41 5.06
db block changes 28,842 15.84 8.51
db block gets 29,115 15.99 8.59
db block gets direct 142 0.08 0.04
db block gets from cache 28,973 15.91 8.55
deferred (CURRENT) block cleanout applications 4,636 2.55 1.37
doubling up with imu segment 0 0.00 0.00
enqueue conversions 368 0.20 0.11
enqueue deadlocks 0 0.00 0.00
enqueue releases 37,805 20.76 11.16
enqueue requests 37,805 20.76 11.16
enqueue timeouts 0 0.00 0.00
enqueue waits 0 0.00 0.00
execute count 89,575 49.19 26.44
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 0 0.00 0.00
free buffer requested 6,857 3.77 2.02
heap block compress 1,373 0.75 0.41
hot buffers moved to head of LRU 29 0.02 0.01
immediate (CR) block cleanout applications 13 0.01 0.00
immediate (CURRENT) block cleanout applications 470 0.26 0.14
index crx upgrade (positioned) 1,860 1.02 0.55
index fast full scans (full) 180 0.10 0.05
index fetch by key 464,797,589 255,238.56 137,189.37
index scans kdiixs1 61,482 33.76 18.15
leaf node 90-10 splits 16 0.01 0.00
leaf node splits 21 0.01 0.01
lob reads 285 0.16 0.08
lob writes 381 0.21 0.11
lob writes unaligned 353 0.19 0.10
logons cumulative 108 0.06 0.03
messages received 6,280 3.45 1.85
messages sent 6,280 3.45 1.85
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 731,850,126 401,887.57 216,012.43
opened cursors cumulative 18,754 10.30 5.54
parse count (failures) 6,866 3.77 2.03
parse count (hard) 12,223 6.71 3.61
parse count (total) 102,068 56.05 30.13
parse time cpu 1,369 0.75 0.40
parse time elapsed 1,314 0.72 0.39
physical read IO requests 506 0.28 0.15
physical read bytes 4,341,760 2,384.23 1,281.51
physical read total IO requests 1,913 1.05 0.56
physical read total bytes 27,238,400 14,957.67 8,039.67
physical read total multi block requests 12 0.01 0.00
physical reads 530 0.29 0.16
physical reads cache 13 0.01 0.00
physical reads cache prefetch 0 0.00 0.00
physical reads direct 517 0.28 0.15
physical reads direct (lob) 471 0.26 0.14
physical reads direct temporary tablespace 0 0.00 0.00
physical write IO requests 2,817 1.55 0.83
physical write bytes 27,852,800 15,295.06 8,221.02
physical write total IO requests 11,811 6.49 3.49
physical write total bytes 81,997,824 45,028.22 24,202.43
physical write total multi block requests 7,271 3.99 2.15
physical writes 3,400 1.87 1.00
physical writes direct 142 0.08 0.04
physical writes direct (lob) 101 0.06 0.03
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 3,258 1.79 0.96
physical writes non checkpoint 487 0.27 0.14
pinned buffers inspected 0 0.00 0.00
prefetch clients - default 6 0.00 0.00
process last non-idle time 1,822 1.00 0.54
recovery blocks read 0 0.00 0.00
recursive calls 43,499 23.89 12.84
recursive cpu usage 1,194 0.66 0.35
redo blocks read for recovery 0 0.00 0.00
redo blocks written 13,348 7.33 3.94
redo buffer allocation retries 0 0.00 0.00
redo entries 10,556 5.80 3.12
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 126 0.07 0.04
redo size 5,660,884 3,108.61 1,670.86
redo subscn max counts 499 0.27 0.15
redo synch time 82 0.05 0.02
redo synch writes 3,384 1.86 1.00
redo wastage 945,232 519.06 278.99
redo write time 57 0.03 0.02
redo writes 3,575 1.96 1.06
rollback changes - undo records applied 2 0.00 0.00
rollbacks only - consistent read gets 6,726 3.69 1.99
rows fetched via callback 61,399,473 33,716.86 18,122.63
session connect time 0 0.00 0.00
session cursor cache hits 22,869 12.56 6.75
session logical reads 1,733,719,818 952,053.46 511,723.68
session uga memory 8,590,534,064 4,717,398.74 2,535,576.76
session uga memory max 322,617,416 177,161.86 95,223.56
shared hash latch upgrades - no wait 10,659,848 5,853.74 3,146.35
shared hash latch upgrades - wait 186 0.10 0.05
sorts (memory) 59,396 32.62 17.53
sorts (rows) 421,351,711 231,380.73 124,365.91
sql area evicted 8,490 4.66 2.51
sql area purged 6,866 3.77 2.03
switch current to new buffer 57 0.03 0.02
table fetch by rowid 103,405,022 56,783.75 30,520.96
table fetch continued row 15,022,208 8,249.28 4,433.95
table scan blocks gotten 229,596,828 126,080.61 67,767.66
table scan rows gotten 881,085,857 483,838.76 260,060.76
table scans (long tables) 666 0.37 0.20
table scans (short tables) 5,713 3.14 1.69
total number of times SMON posted 0 0.00 0.00
transaction rollbacks 2 0.00 0.00
undo change vector size 1,409,432 773.97 416.01
user I/O wait time 62 0.03 0.02
user calls 217,881 119.65 64.31
user commits 3,388 1.86 1.00
user rollbacks 0 0.00 0.00
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 19,108 10.49 5.64
write clones created in background 0 0.00 0.00
write clones created in foreground 0 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
opened cursors current 152 81
logons current 41 35
session cursor cache count 67,807 69,874

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 0 0.00

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)
JSCMS 493 0 1.20 1.05 2,421 1 2 0.00
SYSAUX 15 0 6.67 1.00 213 0 0 0.00
UNDOTBS 0 0 0.00 0.00 147 0 0 0.00
SYSTEM 0 0 0.00 0.00 35 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)
JSCMS D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS01.DBF 198 0 1.46 1.07 112 0 0 0.00
JSCMS D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS02.DBF 164 0 0.67 1.00 264 0 0 0.00
JSCMS D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS03.DBF 2 0 0.00 1.00 421 0 0 0.00
JSCMS D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS04.DBF 32 0 0.31 1.00 153 0 0 0.00
JSCMS D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS05.DBF 14 0 2.14 1.71 239 0 2 0.00
JSCMS D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS06.DBF 16 0 2.50 1.00 109 0 0 0.00
JSCMS D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS07.DBF 6 0 1.67 1.00 322 0 0 0.00
JSCMS D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS08.DBF 7 0 1.43 1.00 255 0 0 0.00
JSCMS D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS09.DBF 7 0 2.86 1.00 168 0 0 0.00
JSCMS D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS10.DBF 5 0 2.00 1.20 208 0 0 0.00
JSCMS D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS11.DBF 8 0 1.25 1.00 75 0 0 0.00
JSCMS D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS12.DBF 34 0 1.47 1.00 95 0 0 0.00
SYSAUX D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\SYSAUX01.DB 15 0 6.67 1.00 213 0 0 0.00
SYSTEM D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\SYSTEM01.DB 0 0     35 0 0 0.00
UNDOTBS D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\UNDOTBS.DBF 0 0     147 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 841,075 100 1,726,666,732 15 3,258 0 0 2


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 7 570 2205 11491 353880 11491  
E 0 7 675 2382 11394 353880 11394  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 672 0.10 83,118 1055.34 94,955,223
D 1,344 0.20 166,236 725.13 65,244,396
D 2,016 0.30 249,354 176.31 15,863,531
D 2,688 0.40 332,472 3.77 339,647
D 3,360 0.49 415,590 1.00 90,031
D 4,032 0.59 498,708 1.00 90,025
D 4,704 0.69 581,826 1.00 90,024
D 5,376 0.79 664,944 1.00 89,993
D 6,048 0.89 748,062 1.00 89,978
D 6,720 0.99 831,180 1.00 89,976
D 6,800 1.00 841,075 1.00 89,976
D 7,392 1.09 914,298 1.00 89,976
D 8,064 1.19 997,416 1.00 89,976
D 8,736 1.28 1,080,534 1.00 89,976
D 9,408 1.38 1,163,652 1.00 89,976
D 10,080 1.48 1,246,770 1.00 89,976
D 10,752 1.58 1,329,888 1.00 89,976
D 11,424 1.68 1,413,006 1.00 89,976
D 12,096 1.78 1,496,124 1.00 89,976
D 12,768 1.88 1,579,242 1.00 89,976
D 13,440 1.98 1,662,360 0.14 12,259

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 888 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 2,048 1,819 76.67 0.00 0.00 0.00 0.00 209,710
E 2,048 1,823 61.59 0.00 0.00 0.00 0.00 209,710

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 17,611 17,611 0 0
64K 128K 473 473 0 0
128K 256K 758 758 0 0
256K 512K 64 64 0 0
512K 1024K 39 39 0 0
1M 2M 18 18 0 0
2M 4M 45 45 0 0
4M 8M 96 96 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
256 0.13 41,463.29 572.24 99.00 0
512 0.25 41,463.29 375.45 99.00 0
1,024 0.50 41,463.29 164.80 100.00 0
1,536 0.75 41,463.29 164.80 100.00 0
2,048 1.00 41,463.29 164.80 100.00 0
2,458 1.20 41,463.29 0.00 100.00 0
2,867 1.40 41,463.29 0.00 100.00 0
3,277 1.60 41,463.29 0.00 100.00 0
3,686 1.80 41,463.29 0.00 100.00 0
4,096 2.00 41,463.29 0.00 100.00 0
6,144 3.00 41,463.29 0.00 100.00 0
8,192 4.00 41,463.29 0.00 100.00 0
12,288 6.00 41,463.29 0.00 100.00 0
16,384 8.00 41,463.29 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
480 0.36 159 18,508 73,390 0.89 9,184 22.73 16,228,371
624 0.46 300 26,649 76,849 0.94 5,725 14.17 16,250,538
768 0.57 443 34,161 79,259 0.96 3,315 8.21 16,257,336
912 0.68 586 41,915 80,041 0.97 2,533 6.27 16,260,104
1,056 0.79 726 48,368 80,177 0.98 2,397 5.93 16,261,816
1,200 0.89 869 54,695 81,356 0.99 1,218 3.01 16,263,032
1,344 1.00 1,012 62,199 82,170 1.00 404 1.00 16,263,994
1,488 1.11 1,155 74,903 82,171 1.00 403 1.00 16,264,490
1,632 1.21 1,298 82,564 82,173 1.00 401 0.99 16,264,957
1,776 1.32 1,441 91,251 82,176 1.00 398 0.99 16,265,580
1,920 1.43 1,584 99,578 82,176 1.00 398 0.99 16,265,919
2,064 1.54 1,727 107,305 82,176 1.00 398 0.99 16,266,227
2,208 1.64 1,870 115,244 82,176 1.00 398 0.99 16,266,510
2,352 1.75 2,013 123,358 82,176 1.00 398 0.99 16,266,873
2,496 1.86 2,156 130,904 82,176 1.00 398 0.99 16,267,160
2,640 1.96 2,299 138,144 82,176 1.00 398 0.99 16,267,391
2,784 2.07 2,442 145,650 82,706 1.01 1 0.00 16,267,786

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
2,048 0.25 712,567 65,238,430
4,096 0.50 649,381 339,632
6,144 0.75 648,732 90,012
8,192 1.00 648,732 89,976
10,240 1.25 648,732 89,958
12,288 1.50 648,732 89,958
14,336 1.75 648,732 89,958
16,384 2.00 648,667 12,255

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

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

Back to Wait Statistics
Back to Top

Enqueue Activity

No data exists for this section of the report.

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
9 0.18 3,429 494 3 3346.53333333333333333333333333333333333/3395.25 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
28-4ÔÂ 14:25 39 1,101 494 2 3,395 0/0 0/0/0/0/0/0
28-4ÔÂ 14:15 50 1,223 63 2 3,371 0/0 0/0/0/0/0/0
28-4ÔÂ 14:05 95 1,105 55 3 3,347 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 1,214 0.00   0 0  
AWR Alerted Metric Element list 7,290 0.00   0 0  
Consistent RBA 3,577 0.00   0 0  
FIB s.o chain latch 4 0.00   0 0  
FOB s.o list latch 353 1.42 0.00 0 0  
In memory undo latch 18,235 0.01 1.00 0 3,792 0.00
JS mem alloc latch 12 0.00   0 0  
JS queue access latch 12 0.00   0 0  
JS queue state obj latch 13,210 0.00   0 0  
JS slv state obj latch 16 0.00   0 0  
KMG MMAN ready and startup request latch 607 0.00   0 0  
KTF sga latch 4 0.00   0 556 0.00
KWQMN job cache list latch 1 0.00   0 0  
MQL Tracking Latch 0     0 36 0.00
Memory Management Latch 0     0 607 0.00
OS process 360 0.00   0 0  
OS process allocation 841 0.00   0 0  
OS process: request allocation 218 0.46 0.00 0 0  
PL/SQL warning settings 151 0.00   0 0  
SQL memory manager latch 1 0.00   0 607 0.00
SQL memory manager workarea list latch 42,864 0.00   0 0  
Shared B-Tree 65 0.00   0 0  
active checkpoint queue latch 4,533 0.00   0 0  
active service list 4,214 0.09 0.00 0 12,672 0.01
archive control 4 0.00   0 0  
begin backup scn array 104 0.00   0 0  
cache buffer handles 500 0.00   0 0  
cache buffers chains 2,476,532,599 20.68 0.08 5608 6,786 0.00
cache buffers lru chain 6,640 0.00   0 363,535 0.00
channel handle pool latch 218 0.00   0 0  
channel operations parent latch 8,854 0.00   0 0  
checkpoint queue latch 181,943 0.00   0 3,353 0.00
client/application info 530 0.00   0 0  
compile environment latch 108 0.00   0 0  
dml lock allocation 25,675 0.02 0.00 0 0  
dummy allocation 222 0.45 0.00 0 0  
enqueue hash chains 76,017 0.00 0.00 0 0  
enqueues 58,662 0.02 0.00 0 0  
event group latch 106 0.00   0 0  
file cache latch 67 0.00   0 0  
global KZLD latch for mem in SGA 102 0.00   0 0  
hash table column usage latch 54 0.00   0 47,220 0.00
hash table modification latch 23 0.00   0 0  
job workq parent latch 0     0 4 0.00
job_queue_processes parameter latch 32 0.00   0 0  
kks stats 39,494 0.00 0.00 0 0  
kokc descriptor allocation latch 2 0.00   0 0  
ksuosstats global area 123 0.00   0 0  
ktm global data 7 0.00   0 0  
kwqbsn:qsga 65 0.00   0 0  
lgwr LWN SCN 3,587 0.00   0 0  
library cache 701,212 0.02 0.01 0 20,735 0.02
library cache load lock 94 0.00   0 0  
library cache lock 473,819 0.01 0.00 0 0  
library cache lock allocation 5,795 0.02 0.00 0 0  
library cache pin 171,316 0.00 0.00 0 0  
library cache pin allocation 7,399 0.00   0 0  
list of block allocation 238 0.00   0 0  
loader state object freelist 840 0.00   0 0  
longop free list parent 5,825 0.00   0 262 0.00
messages 30,351 1.18 0.00 0 0  
mostly latch-free SCN 3,609 0.28 0.00 0 0  
ncodef allocation latch 12,491 0.00   0 0  
object queue header heap 18,154 0.00   0 0  
object queue header operation 28,562 0.00   0 0  
object stats modification 1 0.00   0 0  
parallel query alloc buffer 224 0.00   0 0  
parameter list 8 0.00   0 0  
parameter table allocation management 116 7.76 0.00 0 0  
post/wait queue 5,200 0.00   0 3,516 0.03
process allocation 218 0.00   0 106 0.00
process group creation 218 0.00   0 0  
qmn task queue latch 260 0.00   0 0  
redo allocation 18,328 0.01 0.00 0 10,591 0.02
redo copy 0     0 10,592 0.04
redo writing 16,538 0.00   0 0  
resmgr group change latch 108 0.00   0 0  
resmgr:active threads 219 0.00   0 0  
resmgr:actses change group 104 0.00   0 0  
resmgr:free threads list 218 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 3,060,974 0.13 0.00 0 74 0.00
sequence cache 1,195 0.00   0 0  
session allocation 26,584 0.07 0.00 0 0  
session idle bit 439,360 0.00   0 0  
session state list latch 228 0.00   0 0  
session switching 12,491 0.00   0 0  
session timer 12,673 0.00   0 0  
shared pool 397,634 0.02 0.08 0 0  
shared pool sim alloc 124 0.00   0 0  
shared pool simulator 347,912 0.00 0.00 0 0  
simulator hash latch 431,972,095 0.01 0.00 0 0  
simulator lru latch 3,258 2.09 0.00 0 431,967,999 9.45
slave class 2 0.00   0 0  
slave class create 8 12.50 1.00 0 0  
sort extent pool 12,507 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 560 0.00   0 0  
threshold alerts latch 77 0.00   0 0  
transaction allocation 249 0.00   0 0  
transaction branch allocation 12,673 0.00   0 0  
undo global data 28,389 0.04 0.00 0 0  
user lock 424 2.36 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 2,476,532,599 512,132,918 42,738,525 502,500,226 0 0 0
simulator hash latch 431,972,095 28,132 9 28,124 0 0 0
row cache objects 3,060,974 4,002 3 3,999 0 0 0
library cache 701,212 118 1 117 0 0 0
shared pool 397,634 64 5 59 0 0 0
In memory undo latch 18,235 1 1 0 0 0 0
slave class create 8 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 kticmt: child 0 1 0
cache buffers chains kcbgtcr: kslbegin excl 0 28,633,140 27,628,172
cache buffers chains kcbrls: kslbegin 0 27,162,431 28,455,820
cache buffers chains kcbgtcr: fast path 0 1,969 2,664
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 22 14
cache buffers chains kcbget: exchange rls 0 7 157
cache buffers chains kcbgcur: kslbegin 0 6 250
cache buffers chains kcbget: exchange 0 6 197
library cache kglobpn: child: 0 1 0
row cache objects kqrpre: find obj 0 2 1
row cache objects kqreqd 0 1 2
shared pool kghalo 0 2 3
shared pool kghfrunp: alloc: session dur 0 2 0
shared pool kghupr1 0 1 2
simulator hash latch kcbsacc: lookup dba 0 9 9
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
JSCMS JSCMS INFO_KEYWORD   INDEX 1,159,873,824 66.90
JSCMS JSCMS PKKEY_ARTICLE   INDEX 215,263,104 12.42
JSCMS JSCMS ARTICLE SYS_P76 TABLE PARTITION 198,657,088 11.46
JSCMS JSCMS ARTICLE SYS_P75 TABLE PARTITION 75,441,632 4.35
JSCMS JSCMS ARTICLE SYS_P73 TABLE PARTITION 45,384,880 2.62

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
JSCMS JSCMS SYS_LOB0000051993C00019$$ YS_LOB_P85 LOB PARTITION 283 53.40
JSCMS JSCMS SYS_LOB0000051993C00019$$ YS_LOB_P88 LOB PARTITION 117 22.08
JSCMS JSCMS SYS_LOB0000051993C00019$$ YS_LOB_P87 LOB PARTITION 24 4.53
SYS SYSAUX WRH$_ACTIVE_SESSION_HISTORY 57709990_0 TABLE PARTITION 11 2.08
JSCMS JSCMS SYS_LOB0000051993C00019$$ YS_LOB_P86 LOB PARTITION 7 1.32

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
SYS SYSTEM SMON_SCN_TIME   TABLE 3 100.00

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
JSCMS JSCMS ARTICLECLASS   TABLE 2 100.00

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 33 0.00 0   2 1
dc_database_links 205 0.00 0   0 1
dc_global_oids 6 0.00 0   0 23
dc_histogram_data 22,462 0.15 0   0 980
dc_histogram_defs 46,241 0.56 0   0 1,690
dc_object_ids 819,213 0.00 0   0 267
dc_objects 10,411 0.05 0   5 527
dc_profiles 106 0.00 0   0 1
dc_rollback_segments 1,130 0.00 0   0 102
dc_segments 61,525 0.01 0   8 451
dc_sequences 17 0.00 0   17 6
dc_tablespaces 2,709 0.00 0   0 8
dc_usernames 696 0.00 0   0 37
dc_users 71,206 0.00 0   0 78
outstanding_alerts 21 0.00 0   0 6


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 13 0.00 53 0.00 0 0
CLUSTER 9 0.00 17 5.88 1 0
INDEX 5 40.00 26,943 0.01 0 0
SQL AREA 77,977 13.43 119,348 25.05 6,780 0
TABLE/PROCEDURE 954 0.00 26,132 0.16 27 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 Other 48.26   1.12 1.35 9 10 43 43
  Freeable 27.56 0.00 1.02 0.72 4   27 27
  SQL 0.72 0.44 0.02 0.03 0 6 33 33
  PL/SQL 0.16 0.08 0.00 0.01 0 0 41 41
E Other 42.49   1.15 1.44 9 10 37 37
  Freeable 18.00 0.00 1.20 0.91 4   15 15
  SQL 0.98 0.72 0.04 0.03 0 6 27 27
  PL/SQL 0.15 0.08 0.00 0.01 0 0 35 35

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 7,130,316,800  
Fixed Size 2,079,440  
Redo Buffers 14,696,448  
Variable Size 1,442,841,904  

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 ASH buffers 40.50 40.50 0.00
shared CCursor 147.18 141.50 -3.86
shared PCursor 95.62 94.41 -1.27
shared db_block_hash_buckets 45.00 45.00 0.00
shared free memory 240.20 301.96 25.71
shared kglsim object batch 22.36 22.67 1.38
shared library cache 71.99 70.17 -2.53
shared sql area 553.96 500.86 -9.59
  buffer_cache 6,800.00 6,800.00 0.00
  fixed_sga 1.98 1.98 0.00
  log_buffer 14.02 14.02 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

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

No data exists for this section of the report.

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 D:\ORACLE\PRODUCT\10.2.0\ADMIN\DSQQCMS\ADUMP   
background_dump_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\DSQQCMS\BDUMP   
compatible 10.2.0.3.0   
control_files D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\CONTROL03.CTL   
core_dump_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\DSQQCMS\CDUMP   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 32   
db_name DSQQCMS   
db_recovery_file_dest D:\oracle\product\10.2.0\flash_recovery_area   
db_recovery_file_dest_size 4294967296   
dispatchers (PROTOCOL=TCP) (SERVICE=DSQQCMSXDB)   
job_queue_processes 10   
nls_language SIMPLIFIED CHINESE   
nls_territory CHINA   
open_cursors 300   
parallel_max_servers 32   
pga_aggregate_target 2147483648   
processes 600   
remote_login_passwordfile EXCLUSIVE   
sessions 665   
sga_target 8589934592   
undo_management AUTO   
undo_tablespace UNDOTBS   
user_dump_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\DSQQCMS\UDUMP   


Back to Top

End of Report