WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

DSQQCMS 3957709990 dsqqcms 1 10.2.0.4.0 NO SVCTAG-JFHP53X

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
DSQQCMS	3957709990	dsqqcms	1	10.2.0.4.0	NO	SVCTAG-JFHP53X

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 45 28-4月 -12 15:33:39 32 2.4

End Snap: 46 28-4月 -12 16:00:52 33 2.5

Elapsed: 27.20 (mins)

DB Time: 71.69 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	45	28-4月 -12 15:33:39	32	2.4
End Snap:	46	28-4月 -12 16:00:52	33	2.5
Elapsed:		27.20 (mins)
DB Time:		71.69 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 6,544M 6,544M Std Block Size: 8K

Shared Pool Size: 1,344M 1,344M Log Buffer: 14,352K

	Begin	End
Buffer Cache:	6,544M	6,544M	Std Block Size:	8K
Shared Pool Size:	1,344M	1,344M	Log Buffer:	14,352K

Load Profile

Per Second Per Transaction

Redo size: 3,071.56 1,794.85

Logical reads: 783,222.66 457,672.92

Block changes: 15.02 8.78

Physical reads: 0.57 0.33

Physical writes: 1.66 0.97

User calls: 113.10 66.09

Parses: 46.90 27.40

Hard parses: 1.35 0.79

Sorts: 25.81 15.08

Logons: 0.04 0.02

Executes: 45.78 26.75

Transactions: 1.71

	Per Second	Per Transaction
Redo size:	3,071.56	1,794.85
Logical reads:	783,222.66	457,672.92
Block changes:	15.02	8.78
Physical reads:	0.57	0.33
Physical writes:	1.66	0.97
User calls:	113.10	66.09
Parses:	46.90	27.40
Hard parses:	1.35	0.79
Sorts:	25.81	15.08
Logons:	0.04	0.02
Executes:	45.78	26.75
Transactions:	1.71

% Blocks changed per Read: 0.00 Recursive Call %: 20.16

Rollback per transaction %: 0.00 Rows per Sort: 6809.58

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

Buffer Hit %: 100.00 In-memory Sort %: 100.00

Library Hit %: 94.14 Soft Parse %: 97.13

Execute to Parse %: -2.44 Latch Hit %: 94.27

Parse CPU to Parse Elapsd %: 79.28 % Non-Parse CPU: 99.87

Shared Pool Statistics

Begin End

Memory Usage %: 14.86 15.51

% SQL with executions>1: 58.11 82.78

% Memory for SQL w/exec>1: 61.78 83.17

	Begin	End
Memory Usage %:	14.86	15.51
% SQL with executions>1:	58.11	82.78
% Memory for SQL w/exec>1:	61.78	83.17

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class

CPU time 4,283 99.6

latch: cache buffers chains 940,019 4 0 .1 Concurrency

db file sequential read 734 2 3 .0 User I/O

SQL*Net break/reset to client 4,068 1 0 .0 Application

log file sync 2,834 1 0 .0 Commit

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		4,283		99.6
latch: cache buffers chains	940,019	4	0	.1	Concurrency
db file sequential read	734	2	3	.0	User I/O
SQL*Net break/reset to client	4,068	1	0	.0	Application
log file sync	2,834	1	0	.0	Commit

Main Report

Report Summary
Wait Events Statistics
SQL Statistics
Instance Activity Statistics
IO Stats
Buffer Pool Statistics
Advisory Statistics
Wait Statistics
Undo Statistics
Latch Statistics
Segment Statistics
Dictionary Cache Statistics
Library Cache Statistics
Memory Statistics
Streams Statistics
Resource Limit Statistics
init.ora Parameters

Time Model Statistics

Total time in database user-calls (DB Time): 4301.5s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	4,289.09	99.71
DB CPU	4,283.20	99.57
parse time elapsed	5.95	0.14
hard parse elapsed time	0.79	0.02
failed parse elapsed time	0.39	0.01
connection management call elapsed time	0.16	0.00
PL/SQL execution elapsed time	0.03	0.00
hard parse (sharing criteria) elapsed time	0.02	0.00
hard parse (bind mismatch) elapsed time	0.02	0.00
sequence load elapsed time	0.00	0.00
PL/SQL compilation elapsed time	0.00	0.00
repeated bind elapsed time	0.00	0.00
DB time	4,301.53
background elapsed time	7.05
background cpu time	5.12

Back to Wait Events Statistics
Back to Top

Wait Class

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
Concurrency	940,029	0.00	4	0	336.57
User I/O	1,047	0.00	2	2	0.37
System I/O	6,573	0.00	1	0	2.35
Application	4,068	0.00	1	0	1.46
Commit	2,834	0.00	1	0	1.01
Network	175,697	0.00	0	0	62.91
Other	22	4.55	0	12	0.01

Back to Wait Events Statistics
Back to Top

Wait Events

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
latch: cache buffers chains	940,019	0.00	4	0	336.56
db file sequential read	734	0.00	2	3	0.26
SQL*Net break/reset to client	4,068	0.00	1	0	1.46
log file sync	2,834	0.00	1	0	1.01
log file parallel write	3,114	0.00	0	0	1.11
db file parallel write	1,616	0.00	0	0	0.58
SQL*Net message to client	171,679	0.00	0	0	61.47
wait list latch free	18	0.00	0	12	0.01
control file sequential read	1,299	0.00	0	0	0.47
direct path read	209	0.00	0	1	0.07
control file parallel write	544	0.00	0	0	0.19
db file scattered read	23	0.00	0	5	0.01
SQL*Net more data to client	3,612	0.00	0	0	1.29
kksfbc child completion	1	100.00	0	49	0.00
os thread startup	3	0.00	0	7	0.00
latch free	1	0.00	0	7	0.00
direct path write	81	0.00	0	0	0.03
SQL*Net more data from client	406	0.00	0	0	0.15
rdbms ipc reply	1	0.00	0	0	0.00
latch: messages	1	0.00	0	0	0.00
cursor: mutex S	6	0.00	0	0	0.00
cursor: mutex X	1	0.00	0	0	0.00
SQL*Net message from client	171,679	0.00	11,129	65	61.47
virtual circuit status	55	100.00	1,642	29847	0.02
Streams AQ: qmn slave idle wait	58	0.00	1,607	27715	0.02
Streams AQ: qmn coordinator idle wait	117	50.43	1,607	13739	0.04
jobq slave wait	17	100.00	51	2999	0.01
class slave wait	2	0.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	3,114	0.00	0	0	1.11
db file parallel write	1,616	0.00	0	0	0.58
control file parallel write	544	0.00	0	0	0.19
control file sequential read	632	0.00	0	0	0.23
os thread startup	3	0.00	0	7	0.00
events in waitclass Other	2	0.00	0	0	0.00
direct path write	1	0.00	0	0	0.00
rdbms ipc message	9,991	68.62	18,797	1881	3.58
pmon timer	645	84.34	1,629	2526	0.23
Streams AQ: qmn slave idle wait	58	0.00	1,607	27715	0.02
Streams AQ: qmn coordinator idle wait	117	50.43	1,607	13739	0.04
smon timer	5	100.00	1,407	281300	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
AVG_BUSY_TIME	17,983
AVG_IDLE_TIME	145,032
AVG_SYS_TIME	46
AVG_USER_TIME	17,879
BUSY_TIME	432,790
IDLE_TIME	3,481,987
SYS_TIME	2,281
USER_TIME	430,509
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

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
SYS$USERS	4,301.80	4,283.50	499	1,278,412,387
DSQQCMS	0.00	0.00	0	0
DSQQCMSXDB	0.00	0.00	0	0
SYS$BACKGROUND	0.00	0.00	583	17,447

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Wait Class info for services in the Service Statistics section.
Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
Time Waited (Wt Time) in centisecond (100th of a second)

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	452	72	940026	353	0	0	175450	28
SYS$BACKGROUND	613	144	3	3	0	0	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Text
890	888	29	30.68	20.68	bqgf3uprrjppd	select rowid, title, filep...
487	483	965	0.50	11.32	3jqzd3pj1b3vu	select rowid, ArticleID, ...
459	459	16	28.69	10.67	3ffas7zjhs66d	select rowid, title, f...
403	403	6	67.23	9.38	31qpsv5jkzfj4	select rowid, title, f...
375	375	15	24.99	8.72	0xk2wzb4xdy2h	select rowid, title, fil...
263	263	95	2.77	6.12	c3swh9wb88y1y	select rowid, ArticleID, S...
209	209	73	2.87	4.87	ffuhc1f252b47	select rowid, ArticleID, ...
159	154	1,262	0.13	3.69	1qj4qyhr4xtaj	select rowid, ArticleID, S...
133	132	46	2.88	3.08	2az7ba9n68ju7	select rowid, ArticleID, ...
83	83	33	2.52	1.93	659dy2c35jcst	select rowid, ArticleID, S...
61	60	23	2.63	1.41	2qh83ynazd9j8	select rowid, ArticleID, ...
55	54	571	0.10	1.27	fm670am8k1uj3	select rowid, ArticleID, ...
47	46	66	0.71	1.08	5n8sy4a1rvy1u	select rowid, ArticleID, S...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Text
888	890	29	30.63	20.68	bqgf3uprrjppd	select rowid, title, filep...
483	487	965	0.50	11.32	3jqzd3pj1b3vu	select rowid, ArticleID, ...
459	459	16	28.68	10.67	3ffas7zjhs66d	select rowid, title, f...
403	403	6	67.13	9.38	31qpsv5jkzfj4	select rowid, title, f...
375	375	15	24.97	8.72	0xk2wzb4xdy2h	select rowid, title, fil...
263	263	95	2.77	6.12	c3swh9wb88y1y	select rowid, ArticleID, S...
209	209	73	2.87	4.87	ffuhc1f252b47	select rowid, ArticleID, ...
154	159	1,262	0.12	3.69	1qj4qyhr4xtaj	select rowid, ArticleID, S...
132	133	46	2.88	3.08	2az7ba9n68ju7	select rowid, ArticleID, ...
83	83	33	2.51	1.93	659dy2c35jcst	select rowid, ArticleID, S...
60	61	23	2.63	1.41	2qh83ynazd9j8	select rowid, ArticleID, ...
54	55	571	0.09	1.27	fm670am8k1uj3	select rowid, ArticleID, ...
46	47	66	0.70	1.08	5n8sy4a1rvy1u	select rowid, ArticleID, S...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
Total Buffer Gets: 1,278,280,475
Captured SQL account for 97.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
411,420,929	29	14,186,928.59	32.19	888.21	889.58	bqgf3uprrjppd	select rowid, title, filep...
227,462,693	16	14,216,418.31	17.79	458.82	459.11	3ffas7zjhs66d	select rowid, title, f...
213,328,231	15	14,221,882.07	16.69	374.60	374.89	0xk2wzb4xdy2h	select rowid, title, fil...
150,638,627	6	25,106,437.83	11.78	402.77	403.37	31qpsv5jkzfj4	select rowid, title, f...
70,630,276	965	73,192.00	5.53	482.88	486.80	3jqzd3pj1b3vu	select rowid, ArticleID, ...
23,251,158	95	244,749.03	1.82	262.89	263.20	c3swh9wb88y1y	select rowid, ArticleID, S...
21,923,891	1,262	17,372.34	1.72	154.38	158.75	1qj4qyhr4xtaj	select rowid, ArticleID, S...
18,056,125	73	247,344.18	1.41	209.15	209.46	ffuhc1f252b47	select rowid, ArticleID, ...
11,377,429	46	247,335.41	0.89	132.38	132.53	2az7ba9n68ju7	select rowid, ArticleID, ...
8,162,623	33	247,352.21	0.64	82.80	83.04	659dy2c35jcst	select rowid, ArticleID, S...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 930
Captured SQL account for 23.9% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
61	1,262	0.05	6.56	154.38	158.75	1qj4qyhr4xtaj	select rowid, ArticleID, S...
27	15	1.80	2.90	0.04	0.10	5cm75a0wm0aa8	INSERT INTO Article ( Art...
26	29	0.90	2.80	0.08	0.12	2253g99zpd0h7	INSERT INTO Article ( Arti...
20	4	5.00	2.15	0.01	0.05	56tp5773huw57	INSERT INTO Article ( Ar...
19	515	0.04	2.04	0.07	0.08	3c1kubcdjnppq	update sys.col_usage$ set eq...
19	17	1.12	2.04	0.04	0.06	6qcpwayauctk9	INSERT INTO Article ( Ar...
10	8	1.25	1.08	0.02	0.04	39m4sx9k63ba2	select /*+ index(idl_ub2$ i_id...
10	13	0.77	1.08	0.01	0.06	cqgv56fmuj63x	select owner#, name, namespace...
9	13	0.69	0.97	0.02	0.04	8swypbbr0m372	select order#, columns, types ...
7	94	0.07	0.75	0.03	0.03	32hbap2vtmf53	select position#, sequence#, l...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 74,718
Captured SQL account for 90.9% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Text
30,620	27,146	0.89	0.00	0.00	9jdgmzjw0nhfx	select rowid, ClassID, ClassN...
10,259	10,259	1.00	0.00	0.00	fmpv8b6hwtqan	select rowid, ClassName FROM ...
6,050	6,050	1.00	0.00	0.00	g3176qdxahvv9	select :"SYS_B_0" from dual
2,332	2,332	1.00	0.00	0.00	45z2uq1mcrqgn	select rowid, LinkUrl, fil...
2,227	2,227	1.00	0.00	0.00	9na8jjkucqmvc	select rowid, Hits, Cl...
2,169	2,169	1.00	0.00	0.00	0k85d2bpkbudu	UPDATE Article SET Hits = ...
1,897	1,897	1.00	0.00	0.00	dwcw9ywxj60cp	select rowid, LinkUrl, ...
1,412	1,160	0.82	0.00	0.00	8abctqm6zaa63	select * from ArticleClass whe...
1,279	1,279	1.00	0.00	0.00	0v9qf7t4rr2np	select rowid, LinkUrl, f...
1,262	2,099	1.66	0.12	0.13	1qj4qyhr4xtaj	select rowid, ArticleID, S...
1,017	1,007	0.99	0.00	0.00	5cstqu8bbs2gh	select rowid, ClassID, Cla...
965	1,659	1.72	0.50	0.50	3jqzd3pj1b3vu	select rowid, ArticleID, ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 76,540
Captured SQL account for 88.2% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
30,615	30,620	40.00	9jdgmzjw0nhfx	select rowid, ClassID, ClassN...
10,259	10,259	13.40	fmpv8b6hwtqan	select rowid, ClassName FROM ...
6,050	6,050	7.90	g3176qdxahvv9	select :"SYS_B_0" from dual
2,332	2,332	3.05	45z2uq1mcrqgn	select rowid, LinkUrl, fil...
2,227	2,227	2.91	9na8jjkucqmvc	select rowid, Hits, Cl...
2,169	2,169	2.83	0k85d2bpkbudu	UPDATE Article SET Hits = ...
1,897	1,897	2.48	dwcw9ywxj60cp	select rowid, LinkUrl, ...
1,412	1,412	1.84	8abctqm6zaa63	select * from ArticleClass whe...
1,279	1,279	1.67	0v9qf7t4rr2np	select rowid, LinkUrl, f...
1,262	1,262	1.65	1qj4qyhr4xtaj	select rowid, ArticleID, S...
1,017	1,017	1.33	5cstqu8bbs2gh	select rowid, ClassID, Cla...
965	965	1.26	3jqzd3pj1b3vu	select rowid, ArticleID, ...

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 Id SQL Text

0k85d2bpkbudu UPDATE Article SET Hits = :"SYS_B_0", hitdate = :"SYS_B_1" WHERE ArticleID = :"SYS_B_2"

0v9qf7t4rr2np select rowid, LinkUrl, filepath, LayoutPath, ParentID, ClassName FROM ArticleClass WHERE ClassID = :"SYS_B_0" AND ROWNUM < :"SYS_B_1"

0xk2wzb4xdy2h select 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 = :"SYS_B_00" AND a.Passed = :"SYS_B_01" AND a.ToHtml = :"SYS_B_02" AND a.ArticleID != :"SYS_B_03" AND t.ArticleID = a.ArticleID AND a.InfoShareType = :"SYS_B_04" AND a.ArticleID = k.INFOID AND (k.KeyWord = :"SYS_B_05" OR k.KeyWord = :"SYS_B_06" OR k.KeyWord = :"SYS_B_07" OR k.KeyWord = :"SYS_B_08" OR k.KeyWord = :"SYS_B_09") ) AND t.SiteID = :"SYS_B_10" AND t.cssType = :"SYS_B_11" ORDER BY t.ArticleID DESC )WHERE ROWNUM < :"SYS_B_12"

1qj4qyhr4xtaj select rowid, ArticleID, SpecialID, ClassID FROM (SELECT ArticleID, SpecialID, ClassID FROM Article WHERE Deleted = :"SYS_B_0" AND ToHtml = :"SYS_B_1" AND ClassID = :"SYS_B_2" AND CssType = :"SYS_B_3" AND Passed = :"SYS_B_4" ORDER BY OnTop DESC, OrderID DESC )WHERE ROWNUM < :"SYS_B_5"

2253g99zpd0h7 INSERT INTO Article ( ArticleID , InfoType , SpecialID , Title , SubTitle , Author , CopyFrom , Editor , KeySIF , Hits , UpdateTime , Hot , OnTop , Elite , Passed , Tohtml , IsLink , Summary , Content , IncludePic , DefaultPicUrl , InfoPicUrl , UploadFiles , InfoLevel , PaginationType , ClassID , Deleted , LayoutID , Stars , TitleFontColor , TitleFontType , MaxCharPerPage , filepath , filename , OrderID , NeedPoint , NeedLevel , CssType , CssName , InfoLink , PublishDate , ComeURL , LayoutPath , Label , AssociateSplitTime , SplitKeyWord , SplitTime , isSplit , Language , IndexMark , IsOpen1 , IsOpen2 , SiteID ) VALUES ( ArticleID.Nextval , :"SYS_B_00" , :"SYS_B_01" , :"SYS_B_02" , :"SYS_B_03" , :"SYS_B_04" , :"SYS_B_05" , :"SYS_B_06" , :"SYS_B_07" , :"SYS_B_08" , to_date(:"SYS_B_09", :"SYS_B_10") , :"SYS_B_11" , :"SYS_B_12" , :"SYS_B_13" , :"SYS_B_14" , :"SYS_B_15" , :"SYS_B_16" , :1 , :2 , :"SYS_B_17" , :"SYS_B_18" , :"SYS_B_19" , :"SYS_B_20" , :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" , :"SYS_B_25" , :"SYS_B_26" , :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" , :"SYS_B_30" , :"SYS_B_31" , :"SYS_B_32" , :3 , :4 , :"SYS_B_33" , :"SYS_B_34" , :"SYS_B_35" , to_date(:"SYS_B_36", :"SYS_B_37") , :"SYS_B_38" , :"SYS_B_39" , :"SYS_B_40" , null , :"SYS_B_41" , null , :"SYS_B _42" , :"SYS_B_43" , :"SYS_B_44" , :"SYS_B_45" , :"SYS_B_46" , :"SYS_B_47" )

2az7ba9n68ju7 select 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 = :"SYS_B_00" AND ToHtml = :"SYS_B_01" AND ClassID in ( :"SYS_B_02" , :"SYS_B_03" , :"SYS_B_04" , :"SYS_B_05" , :"SYS_B_06" , :"SYS_B_07" , :"SYS_B_08" , :"SYS_B_09" , :"SYS_B_10" , :"SYS_B_11" , :"SYS_B_12" , :"SYS_B_13" , :"SYS_B_14" , :"SYS_B_15" , :"SYS_B_16" , :"SYS_B_17" , :"SYS_B_18" , :"SYS_B_19" , :"SYS_B_20" , :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" , :"SYS_B_25" , :"SYS_B_26" , :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" , :"SYS_B_30" , :"SYS_B_31" , :"SYS_B_32" , :"SYS_B_33" , :"SYS_B_34" , :"SYS_B_35" , :"SYS_B_36" , :"SYS_B_37" , :"SYS_B_38" , :"SYS_B_39" , :"SYS_B_40" , :"SYS_B_41" , :"SYS_B_42" , :"SYS_B_43" , :"SYS_B_44" , :"SYS_B_45" ) AND CssType = :"SYS_B_46" AND Passed = :"SYS_B_47" ORDER BY OnTop DESC, UpdateTime DESC )WHERE ROWNUM < :"SYS_B_48"

2qh83ynazd9j8 select 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 = :"SYS_B_00" AND ToHtml = :"SYS_B_01" AND ClassID in ( :"SYS_B_02" , :"SYS_B_03" , :"SYS_B_04" , :"SYS_B_05" , :"SYS_B_06" , :"SYS_B_07" , :"SYS_B_08" , :"SYS_B_09" , :"SYS_B_10" , :"SYS_B_11" , :"SYS_B_12" , :"SYS_B_13" , :"SYS_B_14" , :"SYS_B_15" , :"SYS_B_16" , :"SYS_B_17" , :"SYS_B_18" , :"SYS_B_19" , :"SYS_B_20" , :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" , :"SYS_B_25" , :"SYS_B_26" , :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" , :"SYS_B_30" , :"SYS_B_31" , :"SYS_B_32" , :"SYS_B_33" , :"SYS_B_34" , :"SYS_B_35" , :"SYS_B_36" , :"SYS_B_37" , :"SYS_B_38" , :"SYS_B_39" , :"SYS_B_40" , :"SYS_B_41" , :"SYS_B_42" , :"SYS_B_43" , :"SYS_B_44" , :"SYS_B_45" ) AND CssType = :"SYS_B_46" AND Passed = :"SYS_B_47" ORDER BY Hits DESC )WHERE ROWNUM < :"SYS_B_48"

31qpsv5jkzfj4 select 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 = :"SYS_B_00" AND a.Passed = :"SYS_B_01" AND a.ToHtml = :"SYS_B_02" AND a.ArticleID != :"SYS_B_03" AND t.ArticleID = a.ArticleID AND a.InfoShareType = :"SYS_B_04" AND a.ArticleID = k.INFOID AND (k.KeyWord = :"SYS_B_05" OR k.KeyWord = :"SYS_B_06" OR k.KeyWord = :"SYS_B_07" OR k.KeyWord = :"SYS_B_08" OR k.KeyWord = :"SYS_B_09" OR k.KeyWord = :"SYS_B_10" OR k.KeyWord = :"SYS_B_11" OR k.KeyWord = :"SYS_B_12" OR k.KeyWord = :"SYS_B_13" OR k.KeyWord = :"SYS_B_14") ) AND t.SiteID = :"SYS_B_15" AND t.cssType = :"SYS_B_16" ORDER BY t.ArticleID DESC )WHERE ROWNUM < :"SYS_B_17"

32hbap2vtmf53 select position#, sequence#, level#, argument, type#, charsetid, charsetform, properties, nvl(length, 0), nvl(precision#, 0), nvl(scale, 0), nvl(radix, 0), type_owner, type_name, type_subname, type_linkname, pls_type from argument$ where obj#=:1 and procedure#=:2 order by sequence# desc

39m4sx9k63ba2 select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#

3c1kubcdjnppq update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln

3ffas7zjhs66d select 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 = :"SYS_B_00" AND a.Passed = :"SYS_B_01" AND a.ToHtml = :"SYS_B_02" AND a.ArticleID != :"SYS_B_03" AND t.ArticleID = a.ArticleID AND a.InfoShareType = :"SYS_B_04" AND a.ArticleID = k.INFOID AND (k.KeyWord = :"SYS_B_05" OR k.KeyWord = :"SYS_B_06" OR k.KeyWord = :"SYS_B_07" OR k.KeyWord = :"SYS_B_08" OR k.KeyWord = :"SYS_B_09") ) AND t.SiteID = :"SYS_B_10" AND t.cssType = :"SYS_B_11" ORDER BY t.ArticleID DESC )WHERE ROWNUM < :"SYS_B_12"

3jqzd3pj1b3vu select rowid, ArticleID, SpecialID, ClassID FROM (SELECT ArticleID, SpecialID, ClassID FROM Article WHERE Deleted = :"SYS_B_0" AND ToHtml = :"SYS_B_1" AND ClassID = :"SYS_B_2" AND CssType = :"SYS_B_3" AND Passed = :"SYS_B_4" ORDER BY OnTop DESC, OrderID DESC )WHERE ROWNUM < :"SYS_B_5"

45z2uq1mcrqgn select rowid, LinkUrl, filepath, LayoutPath, ParentID, ClassName FROM ArticleClass WHERE ClassID = :"SYS_B_0" AND ROWNUM < :"SYS_B_1"

56tp5773huw57 INSERT INTO Article ( ArticleID , InfoType , SpecialID , Title , SubTitle , Author , CopyFrom , Editor , KeySIF , Hits , UpdateTime , Hot , OnTop , Elite , Passed , Tohtml , IsLink , Summary , Content , IncludePic , DefaultPicUrl , InfoPicUrl , UploadFiles , InfoLevel , PaginationType , ClassID , Deleted , LayoutID , Stars , TitleFontColor , TitleFontType , MaxCharPerPage , filepath , filename , OrderID , NeedPoint , NeedLevel , CssType , CssName , InfoLink , PublishDate , ComeURL , LayoutPath , Label , AssociateSplitTime , SplitKeyWord , SplitTime , isSplit , Language , IndexMark , IsOpen1 , IsOpen2 , SiteID ) VALUES ( ArticleID.Nextval , :"SYS_B_00" , :"SYS_B_01" , :"SYS_B_02" , :"SYS_B_03" , :"SYS_B_04" , :"SYS_B_05" , :"SYS_B_06" , :"SYS_B_07" , :"SYS_B_08" , to_date(:"SYS_B_09", :"SYS_B_10") , :"SYS_B_11" , :"SYS_B_12" , :"SYS_B_13" , :"SYS_B_14" , :"SYS_B_15" , :"SYS_B_16" , empty_clob() , empty_clob() , :"SYS_B_17" , :"SYS_B_18" , :"SYS_B_19" , empty_clob() , :"SYS_B_20" , :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" , :"SYS_B_25" , :"SYS_B_26" , :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" , :"SYS_B_30" , :"SYS_B_3 1" , :"SYS_B_32" , :"SYS_B_33" , :"SYS_B_34" , :"SYS_B_35" , :"SYS_B_36" , to_date(:"SYS_B_37", :"SYS_B_38") , :"SYS_B_39" , :"SYS_B_40" , :"SYS_B_41" , null , :"SYS_B_42" , null , :"SYS_B_43" , :"SYS_B_44" , :"SYS_B_45" , :"SYS_B_46" , :"SYS_B_47" , :"SYS_B_48" )

5cm75a0wm0aa8 INSERT INTO Article ( ArticleID , InfoType , SpecialID , Title , SubTitle , Author , CopyFrom , Editor , KeySIF , Hits , UpdateTime , Hot , OnTop , Elite , Passed , Tohtml , IsLink , Summary , Content , IncludePic , DefaultPicUrl , InfoPicUrl , UploadFiles , InfoLevel , PaginationType , ClassID , Deleted , LayoutID , Stars , TitleFontColor , TitleFontType , MaxCharPerPage , filepath , filename , OrderID , NeedPoint , NeedLevel , CssType , CssName , InfoLink , PublishDate , ComeURL , LayoutPath , Label , AssociateSplitTime , SplitKeyWord , SplitTime , isSplit , Language , IndexMark , IsOpen1 , IsOpen2 , SiteID ) VALUES ( ArticleID.Nextval , :"SYS_B_00" , :"SYS_B_01" , :"SYS_B_02" , :"SYS_B_03" , :"SYS_B_04" , :"SYS_B_05" , :"SYS_B_06" , :"SYS_B_07" , :"SYS_B_08" , to_date(:"SYS_B_09", :"SYS_B_10") , :"SYS_B_11" , :"SYS_B_12" , :"SYS_B_13" , :"SYS_B_14" , :"SYS_B_15" , :"SYS_B_16" , :1 , :2 , :"SYS_B_17" , :"SYS_B_18" , :"SYS_B_19" , :"SYS_B_20" , :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" , :"SYS_B_25" , :"SYS_B_26" , :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" , :"SYS_B_30" , :"SYS_B_31" , :"SYS_B_32" , :3 , :4 , :"SYS_B_33" , :"SYS_B_34" , :"SYS_B_35" , to_date(:"SYS_B_36", :"SYS_B_37") , :"SYS_B_38" , :"SYS_B_39" , :"SYS_B_40" , null , :"SYS_B_41" , null , :"SYS_B_42" , :"SYS_B_43" , :"SYS_B_44" , :"SYS_B_45" , :"SYS_B_46" , :"SYS_B_47" )

5cstqu8bbs2gh select rowid, ClassID, ClassName, ParentID, OrderID FROM ArticleClass WHERE ParentID = :"SYS_B_0" AND rootid = :"SYS_B_1" ORDER BY OrderID ASC, ClassID DESC

5n8sy4a1rvy1u select 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 = :"SYS_B_0" AND ToHtml = :"SYS_B_1" AND ClassID in ( :"SYS_B_2" ) AND CssType = :"SYS_B_3" AND Passed = :"SYS_B_4" ORDER BY OnTop DESC, UpdateTime DESC )WHERE ROWNUM < :"SYS_B_5"

659dy2c35jcst select 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 = :"SYS_B_00" AND ToHtml = :"SYS_B_01" AND ClassID in ( :"SYS_B_02" , :"SYS_B_03" , :"SYS_B_04" , :"SYS_B_05" , :"SYS_B_06" , :"SYS_B_07" , :"SYS_B_08" , :"SYS_B_09" , :"SYS_B_10" , :"SYS_B_11" , :"SYS_B_12" , :"SYS_B_13" , :"SYS_B_14" , :"SYS_B_15" , :"SYS_B_16" , :"SYS_B_17" , :"SYS_B_18" , :"SYS_B_19" , :"SYS_B_20" , :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" , :"SYS_B_25" , :"SYS_B_26" , :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" , :"SYS_B_30" , :"SYS_B_31" , :"SYS_B_32" , :"SYS_B_33" , :"SYS_B_34" , :"SYS_B_35" , :"SYS_B_36" , :"SYS_B_37" , :"SYS_B_38" , :"SYS_B_39" , :"SYS_B_40" , :"SYS_B_41" , :"SYS_B_42" , :"SYS_B_43" , :"SYS_B_44" , :"SYS_B_45" ) AND CssType = :"SYS_B_46" AND Passed = :"SYS_B_47" ORDER BY Hits DESC )WHERE ROWNUM < :"SYS_B_48"

6qcpwayauctk9 INSERT INTO Article ( ArticleID , InfoType , SpecialID , Title , SubTitle , Author , CopyFrom , Editor , KeySIF , Hits , UpdateTime , Hot , OnTop , Elite , Passed , Tohtml , IsLink , Summary , Content , IncludePic , DefaultPicUrl , InfoPicUrl , UploadFiles , InfoLevel , PaginationType , ClassID , Deleted , LayoutID , Stars , TitleFontColor , TitleFontType , MaxCharPerPage , filepath , filename , OrderID , NeedPoint , NeedLevel , CssType , CssName , InfoLink , PublishDate , ComeURL , LayoutPath , Label , AssociateSplitTime , SplitKeyWord , SplitTime , isSplit , Language , IndexMark , IsOpen1 , IsOpen2 , SiteID ) VALUES ( ArticleID.Nextval , :"SYS_B_00" , :"SYS_B_01" , :"SYS_B_02" , :"SYS_B_03" , :"SYS_B_04" , :"SYS_B_05" , :"SYS_B_06" , :"SYS_B_07" , :"SYS_B_08" , to_date(:"SYS_B_09", :"SYS_B_10") , :"SYS_B_11" , :"SYS_B_12" , :"SYS_B_13" , :"SYS_B_14" , :"SYS_B_15" , :"SYS_B_16" , :1 , :2 , :"SYS_B_17" , :"SYS_B_18" , :"SYS_B_19" , :"SYS_B_20" , :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" , :"SYS_B_25" , :"SYS_B_26" , :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" , :"SYS_B_30" , :"SYS_B_31" , :"SYS_B_32" , :3 , :4 , :"SYS_B_33" , :"SYS_B_34" , :"SYS_B_35" , to_date(:"SYS_B_36", :"SYS_B_37") , :"SYS_B_38" , :"SYS_B_39" , :"SYS_B_40" , null , :"SYS_B_41" , null , :"SYS_B_42" , :"SYS_B_43" , :"SYS_B_44" , :"SYS_B_45" , :"SYS_B_46" , :"SYS_B_47" )

8abctqm6zaa63 select * from ArticleClass where ParentID=:"SYS_B_0" order by OrderID Asc

8swypbbr0m372 select order#, columns, types from access$ where d_obj#=:1

9jdgmzjw0nhfx select rowid, ClassID, ClassName from ArticleClass where ParentID=:"SYS_B_0" order by orderid Asc

9na8jjkucqmvc select rowid, Hits, ClassID FROM Article WHERE ArticleID = :"SYS_B_0"

bqgf3uprrjppd select 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 = :"SYS_B_00" AND a.Passed = :"SYS_B_01" AND a.ToHtml = :"SYS_B_02" AND a.ArticleID != :"SYS_B_03" AND t.ArticleID = a.ArticleID AND a.InfoShareType = :"SYS_B_04" AND a.ArticleID = k.INFOID AND (k.KeyWord = :"SYS_B_05" OR k.KeyWord = :"SYS_B_06" OR k.KeyWord = :"SYS_B_07" OR k.KeyWord = :"SYS_B_08" OR k.KeyWord = :"SYS_B_09") ) AND t.SiteID = :"SYS_B_10" AND t.cssType = :"SYS_B_11" ORDER BY t.ArticleID DESC )WHERE ROWNUM < :"SYS_B_12"

c3swh9wb88y1y select 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 = :"SYS_B_00" AND ToHtml = :"SYS_B_01" AND ClassID in ( :"SYS_B_02" , :"SYS_B_03" , :"SYS_B_04" , :"SYS_B_05" , :"SYS_B_06" , :"SYS_B_07" , :"SYS_B_08" , :"SYS_B_09" , :"SYS_B_10" , :"SYS_B_11" , :"SYS_B_12" , :"SYS_B_13" , :"SYS_B_14" , :"SYS_B_15" , :"SYS_B_16" , :"SYS_B_17" , :"SYS_B_18" , :"SYS_B_19" , :"SYS_B_20" , :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" , :"SYS_B_25" , :"SYS_B_26" , :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" , :"SYS_B_30" , :"SYS_B_31" , :"SYS_B_32" , :"SYS_B_33" , :"SYS_B_34" , :"SYS_B_35" , :"SYS_B_36" , :"SYS_B_37" , :"SYS_B_38" , :"SYS_B_39" , :"SYS_B_40" , :"SYS_B_41" , :"SYS_B_42" , :"SYS_B_43" , :"SYS_B_44" , :"SYS_B_45" ) AND CssType = :"SYS_B_46" AND Passed = :"SYS_B_47" ORDER BY OnTop DESC, UpdateTime DESC )WHERE ROWNUM < :"SYS_B_48"

cqgv56fmuj63x select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

dwcw9ywxj60cp select rowid, LinkUrl, filepath, LayoutPath, ParentID, ClassName FROM ArticleClass WHERE ClassID = :"SYS_B_0" AND ROWNUM < :"SYS_B_1"

ffuhc1f252b47 select 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 = :"SYS_B_00" AND ToHtml = :"SYS_B_01" AND ClassID in ( :"SYS_B_02" , :"SYS_B_03" , :"SYS_B_04" , :"SYS_B_05" , :"SYS_B_06" , :"SYS_B_07" , :"SYS_B_08" , :"SYS_B_09" , :"SYS_B_10" , :"SYS_B_11" , :"SYS_B_12" , :"SYS_B_13" , :"SYS_B_14" , :"SYS_B_15" , :"SYS_B_16" , :"SYS_B_17" , :"SYS_B_18" , :"SYS_B_19" , :"SYS_B_20" , :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" , :"SYS_B_25" , :"SYS_B_26" , :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" , :"SYS_B_30" , :"SYS_B_31" , :"SYS_B_32" , :"SYS_B_33" , :"SYS_B_34" , :"SYS_B_35" , :"SYS_B_36" , :"SYS_B_37" , :"SYS_B_38" , :"SYS_B_39" , :"SYS_B_40" , :"SYS_B_41" , :"SYS_B_42" , :"SYS_B_43" , :"SYS_B_44" , :"SYS_B_45" ) AND CssType = :"SYS_B_46" AND Passed = :"SYS_B_47" ORDER BY OnTop DESC, UpdateTime DESC )WHERE ROWNUM < :"SYS_B_48"

fm670am8k1uj3 select rowid, ArticleID, SpecialID, ClassID FROM (SELECT ArticleID, SpecialID, ClassID FROM Article WHERE Deleted = :"SYS_B_0" AND ToHtml = :"SYS_B_1" AND ClassID = :"SYS_B_2" AND CssType = :"SYS_B_3" AND Passed = :"SYS_B_4" ORDER BY OnTop DESC, OrderID DESC )WHERE ROWNUM < :"SYS_B_5"

fmpv8b6hwtqan select rowid, ClassName FROM ArticleClass WHERE ClassID = :"SYS_B_0" AND ROWNUM < :"SYS_B_1"

g3176qdxahvv9 select :"SYS_B_0" from dual

SQL Id	SQL Text
0k85d2bpkbudu	UPDATE Article SET Hits = :"SYS_B_0", hitdate = :"SYS_B_1" WHERE ArticleID = :"SYS_B_2"
0v9qf7t4rr2np	select rowid, LinkUrl, filepath, LayoutPath, ParentID, ClassName FROM ArticleClass WHERE ClassID = :"SYS_B_0" AND ROWNUM < :"SYS_B_1"
0xk2wzb4xdy2h	select 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 = :"SYS_B_00" AND a.Passed = :"SYS_B_01" AND a.ToHtml = :"SYS_B_02" AND a.ArticleID != :"SYS_B_03" AND t.ArticleID = a.ArticleID AND a.InfoShareType = :"SYS_B_04" AND a.ArticleID = k.INFOID AND (k.KeyWord = :"SYS_B_05" OR k.KeyWord = :"SYS_B_06" OR k.KeyWord = :"SYS_B_07" OR k.KeyWord = :"SYS_B_08" OR k.KeyWord = :"SYS_B_09") ) AND t.SiteID = :"SYS_B_10" AND t.cssType = :"SYS_B_11" ORDER BY t.ArticleID DESC )WHERE ROWNUM < :"SYS_B_12"
1qj4qyhr4xtaj	select rowid, ArticleID, SpecialID, ClassID FROM (SELECT ArticleID, SpecialID, ClassID FROM Article WHERE Deleted = :"SYS_B_0" AND ToHtml = :"SYS_B_1" AND ClassID = :"SYS_B_2" AND CssType = :"SYS_B_3" AND Passed = :"SYS_B_4" ORDER BY OnTop DESC, OrderID DESC )WHERE ROWNUM < :"SYS_B_5"
2253g99zpd0h7	INSERT INTO Article ( ArticleID , InfoType , SpecialID , Title , SubTitle , Author , CopyFrom , Editor , KeySIF , Hits , UpdateTime , Hot , OnTop , Elite , Passed , Tohtml , IsLink , Summary , Content , IncludePic , DefaultPicUrl , InfoPicUrl , UploadFiles , InfoLevel , PaginationType , ClassID , Deleted , LayoutID , Stars , TitleFontColor , TitleFontType , MaxCharPerPage , filepath , filename , OrderID , NeedPoint , NeedLevel , CssType , CssName , InfoLink , PublishDate , ComeURL , LayoutPath , Label , AssociateSplitTime , SplitKeyWord , SplitTime , isSplit , Language , IndexMark , IsOpen1 , IsOpen2 , SiteID ) VALUES ( ArticleID.Nextval , :"SYS_B_00" , :"SYS_B_01" , :"SYS_B_02" , :"SYS_B_03" , :"SYS_B_04" , :"SYS_B_05" , :"SYS_B_06" , :"SYS_B_07" , :"SYS_B_08" , to_date(:"SYS_B_09", :"SYS_B_10") , :"SYS_B_11" , :"SYS_B_12" , :"SYS_B_13" , :"SYS_B_14" , :"SYS_B_15" , :"SYS_B_16" , :1 , :2 , :"SYS_B_17" , :"SYS_B_18" , :"SYS_B_19" , :"SYS_B_20" , :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" , :"SYS_B_25" , :"SYS_B_26" , :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" , :"SYS_B_30" , :"SYS_B_31" , :"SYS_B_32" , :3 , :4 , :"SYS_B_33" , :"SYS_B_34" , :"SYS_B_35" , to_date(:"SYS_B_36", :"SYS_B_37") , :"SYS_B_38" , :"SYS_B_39" , :"SYS_B_40" , null , :"SYS_B_41" , null , :"SYS_B _42" , :"SYS_B_43" , :"SYS_B_44" , :"SYS_B_45" , :"SYS_B_46" , :"SYS_B_47" )
2az7ba9n68ju7	select 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 = :"SYS_B_00" AND ToHtml = :"SYS_B_01" AND ClassID in ( :"SYS_B_02" , :"SYS_B_03" , :"SYS_B_04" , :"SYS_B_05" , :"SYS_B_06" , :"SYS_B_07" , :"SYS_B_08" , :"SYS_B_09" , :"SYS_B_10" , :"SYS_B_11" , :"SYS_B_12" , :"SYS_B_13" , :"SYS_B_14" , :"SYS_B_15" , :"SYS_B_16" , :"SYS_B_17" , :"SYS_B_18" , :"SYS_B_19" , :"SYS_B_20" , :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" , :"SYS_B_25" , :"SYS_B_26" , :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" , :"SYS_B_30" , :"SYS_B_31" , :"SYS_B_32" , :"SYS_B_33" , :"SYS_B_34" , :"SYS_B_35" , :"SYS_B_36" , :"SYS_B_37" , :"SYS_B_38" , :"SYS_B_39" , :"SYS_B_40" , :"SYS_B_41" , :"SYS_B_42" , :"SYS_B_43" , :"SYS_B_44" , :"SYS_B_45" ) AND CssType = :"SYS_B_46" AND Passed = :"SYS_B_47" ORDER BY OnTop DESC, UpdateTime DESC )WHERE ROWNUM < :"SYS_B_48"
2qh83ynazd9j8	select 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 = :"SYS_B_00" AND ToHtml = :"SYS_B_01" AND ClassID in ( :"SYS_B_02" , :"SYS_B_03" , :"SYS_B_04" , :"SYS_B_05" , :"SYS_B_06" , :"SYS_B_07" , :"SYS_B_08" , :"SYS_B_09" , :"SYS_B_10" , :"SYS_B_11" , :"SYS_B_12" , :"SYS_B_13" , :"SYS_B_14" , :"SYS_B_15" , :"SYS_B_16" , :"SYS_B_17" , :"SYS_B_18" , :"SYS_B_19" , :"SYS_B_20" , :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" , :"SYS_B_25" , :"SYS_B_26" , :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" , :"SYS_B_30" , :"SYS_B_31" , :"SYS_B_32" , :"SYS_B_33" , :"SYS_B_34" , :"SYS_B_35" , :"SYS_B_36" , :"SYS_B_37" , :"SYS_B_38" , :"SYS_B_39" , :"SYS_B_40" , :"SYS_B_41" , :"SYS_B_42" , :"SYS_B_43" , :"SYS_B_44" , :"SYS_B_45" ) AND CssType = :"SYS_B_46" AND Passed = :"SYS_B_47" ORDER BY Hits DESC )WHERE ROWNUM < :"SYS_B_48"
31qpsv5jkzfj4	select 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 = :"SYS_B_00" AND a.Passed = :"SYS_B_01" AND a.ToHtml = :"SYS_B_02" AND a.ArticleID != :"SYS_B_03" AND t.ArticleID = a.ArticleID AND a.InfoShareType = :"SYS_B_04" AND a.ArticleID = k.INFOID AND (k.KeyWord = :"SYS_B_05" OR k.KeyWord = :"SYS_B_06" OR k.KeyWord = :"SYS_B_07" OR k.KeyWord = :"SYS_B_08" OR k.KeyWord = :"SYS_B_09" OR k.KeyWord = :"SYS_B_10" OR k.KeyWord = :"SYS_B_11" OR k.KeyWord = :"SYS_B_12" OR k.KeyWord = :"SYS_B_13" OR k.KeyWord = :"SYS_B_14") ) AND t.SiteID = :"SYS_B_15" AND t.cssType = :"SYS_B_16" ORDER BY t.ArticleID DESC )WHERE ROWNUM < :"SYS_B_17"
32hbap2vtmf53	select position#, sequence#, level#, argument, type#, charsetid, charsetform, properties, nvl(length, 0), nvl(precision#, 0), nvl(scale, 0), nvl(radix, 0), type_owner, type_name, type_subname, type_linkname, pls_type from argument$ where obj#=:1 and procedure#=:2 order by sequence# desc
39m4sx9k63ba2	select /+ index(idl_ub2$ i_idl_ub21) +/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3ffas7zjhs66d	select 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 = :"SYS_B_00" AND a.Passed = :"SYS_B_01" AND a.ToHtml = :"SYS_B_02" AND a.ArticleID != :"SYS_B_03" AND t.ArticleID = a.ArticleID AND a.InfoShareType = :"SYS_B_04" AND a.ArticleID = k.INFOID AND (k.KeyWord = :"SYS_B_05" OR k.KeyWord = :"SYS_B_06" OR k.KeyWord = :"SYS_B_07" OR k.KeyWord = :"SYS_B_08" OR k.KeyWord = :"SYS_B_09") ) AND t.SiteID = :"SYS_B_10" AND t.cssType = :"SYS_B_11" ORDER BY t.ArticleID DESC )WHERE ROWNUM < :"SYS_B_12"
3jqzd3pj1b3vu	select rowid, ArticleID, SpecialID, ClassID FROM (SELECT ArticleID, SpecialID, ClassID FROM Article WHERE Deleted = :"SYS_B_0" AND ToHtml = :"SYS_B_1" AND ClassID = :"SYS_B_2" AND CssType = :"SYS_B_3" AND Passed = :"SYS_B_4" ORDER BY OnTop DESC, OrderID DESC )WHERE ROWNUM < :"SYS_B_5"
45z2uq1mcrqgn	select rowid, LinkUrl, filepath, LayoutPath, ParentID, ClassName FROM ArticleClass WHERE ClassID = :"SYS_B_0" AND ROWNUM < :"SYS_B_1"
56tp5773huw57	INSERT INTO Article ( ArticleID , InfoType , SpecialID , Title , SubTitle , Author , CopyFrom , Editor , KeySIF , Hits , UpdateTime , Hot , OnTop , Elite , Passed , Tohtml , IsLink , Summary , Content , IncludePic , DefaultPicUrl , InfoPicUrl , UploadFiles , InfoLevel , PaginationType , ClassID , Deleted , LayoutID , Stars , TitleFontColor , TitleFontType , MaxCharPerPage , filepath , filename , OrderID , NeedPoint , NeedLevel , CssType , CssName , InfoLink , PublishDate , ComeURL , LayoutPath , Label , AssociateSplitTime , SplitKeyWord , SplitTime , isSplit , Language , IndexMark , IsOpen1 , IsOpen2 , SiteID ) VALUES ( ArticleID.Nextval , :"SYS_B_00" , :"SYS_B_01" , :"SYS_B_02" , :"SYS_B_03" , :"SYS_B_04" , :"SYS_B_05" , :"SYS_B_06" , :"SYS_B_07" , :"SYS_B_08" , to_date(:"SYS_B_09", :"SYS_B_10") , :"SYS_B_11" , :"SYS_B_12" , :"SYS_B_13" , :"SYS_B_14" , :"SYS_B_15" , :"SYS_B_16" , empty_clob() , empty_clob() , :"SYS_B_17" , :"SYS_B_18" , :"SYS_B_19" , empty_clob() , :"SYS_B_20" , :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" , :"SYS_B_25" , :"SYS_B_26" , :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" , :"SYS_B_30" , :"SYS_B_3 1" , :"SYS_B_32" , :"SYS_B_33" , :"SYS_B_34" , :"SYS_B_35" , :"SYS_B_36" , to_date(:"SYS_B_37", :"SYS_B_38") , :"SYS_B_39" , :"SYS_B_40" , :"SYS_B_41" , null , :"SYS_B_42" , null , :"SYS_B_43" , :"SYS_B_44" , :"SYS_B_45" , :"SYS_B_46" , :"SYS_B_47" , :"SYS_B_48" )
5cm75a0wm0aa8	INSERT INTO Article ( ArticleID , InfoType , SpecialID , Title , SubTitle , Author , CopyFrom , Editor , KeySIF , Hits , UpdateTime , Hot , OnTop , Elite , Passed , Tohtml , IsLink , Summary , Content , IncludePic , DefaultPicUrl , InfoPicUrl , UploadFiles , InfoLevel , PaginationType , ClassID , Deleted , LayoutID , Stars , TitleFontColor , TitleFontType , MaxCharPerPage , filepath , filename , OrderID , NeedPoint , NeedLevel , CssType , CssName , InfoLink , PublishDate , ComeURL , LayoutPath , Label , AssociateSplitTime , SplitKeyWord , SplitTime , isSplit , Language , IndexMark , IsOpen1 , IsOpen2 , SiteID ) VALUES ( ArticleID.Nextval , :"SYS_B_00" , :"SYS_B_01" , :"SYS_B_02" , :"SYS_B_03" , :"SYS_B_04" , :"SYS_B_05" , :"SYS_B_06" , :"SYS_B_07" , :"SYS_B_08" , to_date(:"SYS_B_09", :"SYS_B_10") , :"SYS_B_11" , :"SYS_B_12" , :"SYS_B_13" , :"SYS_B_14" , :"SYS_B_15" , :"SYS_B_16" , :1 , :2 , :"SYS_B_17" , :"SYS_B_18" , :"SYS_B_19" , :"SYS_B_20" , :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" , :"SYS_B_25" , :"SYS_B_26" , :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" , :"SYS_B_30" , :"SYS_B_31" , :"SYS_B_32" , :3 , :4 , :"SYS_B_33" , :"SYS_B_34" , :"SYS_B_35" , to_date(:"SYS_B_36", :"SYS_B_37") , :"SYS_B_38" , :"SYS_B_39" , :"SYS_B_40" , null , :"SYS_B_41" , null , :"SYS_B_42" , :"SYS_B_43" , :"SYS_B_44" , :"SYS_B_45" , :"SYS_B_46" , :"SYS_B_47" )
5cstqu8bbs2gh	select rowid, ClassID, ClassName, ParentID, OrderID FROM ArticleClass WHERE ParentID = :"SYS_B_0" AND rootid = :"SYS_B_1" ORDER BY OrderID ASC, ClassID DESC
5n8sy4a1rvy1u	select 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 = :"SYS_B_0" AND ToHtml = :"SYS_B_1" AND ClassID in ( :"SYS_B_2" ) AND CssType = :"SYS_B_3" AND Passed = :"SYS_B_4" ORDER BY OnTop DESC, UpdateTime DESC )WHERE ROWNUM < :"SYS_B_5"
659dy2c35jcst	select 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 = :"SYS_B_00" AND ToHtml = :"SYS_B_01" AND ClassID in ( :"SYS_B_02" , :"SYS_B_03" , :"SYS_B_04" , :"SYS_B_05" , :"SYS_B_06" , :"SYS_B_07" , :"SYS_B_08" , :"SYS_B_09" , :"SYS_B_10" , :"SYS_B_11" , :"SYS_B_12" , :"SYS_B_13" , :"SYS_B_14" , :"SYS_B_15" , :"SYS_B_16" , :"SYS_B_17" , :"SYS_B_18" , :"SYS_B_19" , :"SYS_B_20" , :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" , :"SYS_B_25" , :"SYS_B_26" , :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" , :"SYS_B_30" , :"SYS_B_31" , :"SYS_B_32" , :"SYS_B_33" , :"SYS_B_34" , :"SYS_B_35" , :"SYS_B_36" , :"SYS_B_37" , :"SYS_B_38" , :"SYS_B_39" , :"SYS_B_40" , :"SYS_B_41" , :"SYS_B_42" , :"SYS_B_43" , :"SYS_B_44" , :"SYS_B_45" ) AND CssType = :"SYS_B_46" AND Passed = :"SYS_B_47" ORDER BY Hits DESC )WHERE ROWNUM < :"SYS_B_48"
6qcpwayauctk9	INSERT INTO Article ( ArticleID , InfoType , SpecialID , Title , SubTitle , Author , CopyFrom , Editor , KeySIF , Hits , UpdateTime , Hot , OnTop , Elite , Passed , Tohtml , IsLink , Summary , Content , IncludePic , DefaultPicUrl , InfoPicUrl , UploadFiles , InfoLevel , PaginationType , ClassID , Deleted , LayoutID , Stars , TitleFontColor , TitleFontType , MaxCharPerPage , filepath , filename , OrderID , NeedPoint , NeedLevel , CssType , CssName , InfoLink , PublishDate , ComeURL , LayoutPath , Label , AssociateSplitTime , SplitKeyWord , SplitTime , isSplit , Language , IndexMark , IsOpen1 , IsOpen2 , SiteID ) VALUES ( ArticleID.Nextval , :"SYS_B_00" , :"SYS_B_01" , :"SYS_B_02" , :"SYS_B_03" , :"SYS_B_04" , :"SYS_B_05" , :"SYS_B_06" , :"SYS_B_07" , :"SYS_B_08" , to_date(:"SYS_B_09", :"SYS_B_10") , :"SYS_B_11" , :"SYS_B_12" , :"SYS_B_13" , :"SYS_B_14" , :"SYS_B_15" , :"SYS_B_16" , :1 , :2 , :"SYS_B_17" , :"SYS_B_18" , :"SYS_B_19" , :"SYS_B_20" , :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" , :"SYS_B_25" , :"SYS_B_26" , :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" , :"SYS_B_30" , :"SYS_B_31" , :"SYS_B_32" , :3 , :4 , :"SYS_B_33" , :"SYS_B_34" , :"SYS_B_35" , to_date(:"SYS_B_36", :"SYS_B_37") , :"SYS_B_38" , :"SYS_B_39" , :"SYS_B_40" , null , :"SYS_B_41" , null , :"SYS_B_42" , :"SYS_B_43" , :"SYS_B_44" , :"SYS_B_45" , :"SYS_B_46" , :"SYS_B_47" )
8abctqm6zaa63	select * from ArticleClass where ParentID=:"SYS_B_0" order by OrderID Asc
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
9jdgmzjw0nhfx	select rowid, ClassID, ClassName from ArticleClass where ParentID=:"SYS_B_0" order by orderid Asc
9na8jjkucqmvc	select rowid, Hits, ClassID FROM Article WHERE ArticleID = :"SYS_B_0"
bqgf3uprrjppd	select 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 = :"SYS_B_00" AND a.Passed = :"SYS_B_01" AND a.ToHtml = :"SYS_B_02" AND a.ArticleID != :"SYS_B_03" AND t.ArticleID = a.ArticleID AND a.InfoShareType = :"SYS_B_04" AND a.ArticleID = k.INFOID AND (k.KeyWord = :"SYS_B_05" OR k.KeyWord = :"SYS_B_06" OR k.KeyWord = :"SYS_B_07" OR k.KeyWord = :"SYS_B_08" OR k.KeyWord = :"SYS_B_09") ) AND t.SiteID = :"SYS_B_10" AND t.cssType = :"SYS_B_11" ORDER BY t.ArticleID DESC )WHERE ROWNUM < :"SYS_B_12"
c3swh9wb88y1y	select 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 = :"SYS_B_00" AND ToHtml = :"SYS_B_01" AND ClassID in ( :"SYS_B_02" , :"SYS_B_03" , :"SYS_B_04" , :"SYS_B_05" , :"SYS_B_06" , :"SYS_B_07" , :"SYS_B_08" , :"SYS_B_09" , :"SYS_B_10" , :"SYS_B_11" , :"SYS_B_12" , :"SYS_B_13" , :"SYS_B_14" , :"SYS_B_15" , :"SYS_B_16" , :"SYS_B_17" , :"SYS_B_18" , :"SYS_B_19" , :"SYS_B_20" , :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" , :"SYS_B_25" , :"SYS_B_26" , :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" , :"SYS_B_30" , :"SYS_B_31" , :"SYS_B_32" , :"SYS_B_33" , :"SYS_B_34" , :"SYS_B_35" , :"SYS_B_36" , :"SYS_B_37" , :"SYS_B_38" , :"SYS_B_39" , :"SYS_B_40" , :"SYS_B_41" , :"SYS_B_42" , :"SYS_B_43" , :"SYS_B_44" , :"SYS_B_45" ) AND CssType = :"SYS_B_46" AND Passed = :"SYS_B_47" ORDER BY OnTop DESC, UpdateTime DESC )WHERE ROWNUM < :"SYS_B_48"
cqgv56fmuj63x	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
dwcw9ywxj60cp	select rowid, LinkUrl, filepath, LayoutPath, ParentID, ClassName FROM ArticleClass WHERE ClassID = :"SYS_B_0" AND ROWNUM < :"SYS_B_1"
ffuhc1f252b47	select 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 = :"SYS_B_00" AND ToHtml = :"SYS_B_01" AND ClassID in ( :"SYS_B_02" , :"SYS_B_03" , :"SYS_B_04" , :"SYS_B_05" , :"SYS_B_06" , :"SYS_B_07" , :"SYS_B_08" , :"SYS_B_09" , :"SYS_B_10" , :"SYS_B_11" , :"SYS_B_12" , :"SYS_B_13" , :"SYS_B_14" , :"SYS_B_15" , :"SYS_B_16" , :"SYS_B_17" , :"SYS_B_18" , :"SYS_B_19" , :"SYS_B_20" , :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" , :"SYS_B_25" , :"SYS_B_26" , :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" , :"SYS_B_30" , :"SYS_B_31" , :"SYS_B_32" , :"SYS_B_33" , :"SYS_B_34" , :"SYS_B_35" , :"SYS_B_36" , :"SYS_B_37" , :"SYS_B_38" , :"SYS_B_39" , :"SYS_B_40" , :"SYS_B_41" , :"SYS_B_42" , :"SYS_B_43" , :"SYS_B_44" , :"SYS_B_45" ) AND CssType = :"SYS_B_46" AND Passed = :"SYS_B_47" ORDER BY OnTop DESC, UpdateTime DESC )WHERE ROWNUM < :"SYS_B_48"
fm670am8k1uj3	select rowid, ArticleID, SpecialID, ClassID FROM (SELECT ArticleID, SpecialID, ClassID FROM Article WHERE Deleted = :"SYS_B_0" AND ToHtml = :"SYS_B_1" AND ClassID = :"SYS_B_2" AND CssType = :"SYS_B_3" AND Passed = :"SYS_B_4" ORDER BY OnTop DESC, OrderID DESC )WHERE ROWNUM < :"SYS_B_5"
fmpv8b6hwtqan	select rowid, ClassName FROM ArticleClass WHERE ClassID = :"SYS_B_0" AND ROWNUM < :"SYS_B_1"
g3176qdxahvv9	select :"SYS_B_0" from dual

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	430,025	263.48	153.97
CPU used when call started	430,153	263.56	154.01
CR blocks created	1,590	0.97	0.57
DB time	430,526	263.79	154.14
DBWR checkpoint buffers written	2,614	1.60	0.94
DBWR checkpoints	0	0.00	0.00
DBWR transaction table writes	61	0.04	0.02
DBWR undo block writes	225	0.14	0.08
IMU CR rollbacks	2	0.00	0.00
IMU Flushes	77	0.05	0.03
IMU Redo allocation size	231,436	141.80	82.86
IMU commits	2,716	1.66	0.97
IMU recursive-transaction flush	1	0.00	0.00
IMU undo allocation size	7,743,944	4,744.84	2,772.63
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	171,427	105.04	61.38
active txn count during cleanout	71	0.04	0.03
application wait time	88	0.05	0.03
background timeouts	6,855	4.20	2.45
buffer is not pinned count	456,438,494	279,667.08	163,422.30
buffer is pinned count	113,071,108	69,280.46	40,483.75
bytes received via SQL*Net from client	23,052,631	14,124.71	8,253.72
bytes sent via SQL*Net to client	46,985,532	28,788.78	16,822.60
calls to get snapshot scn: kcmgss	315,838	193.52	113.08
calls to kcmgas	4,885	2.99	1.75
calls to kcmgcs	78	0.05	0.03
change write time	17	0.01	0.01
cleanout - number of ktugct calls	92	0.06	0.03
cleanouts only - consistent read gets	9	0.01	0.00
cluster key scan block gets	392	0.24	0.14
cluster key scans	314	0.19	0.11
commit batch/immediate performed	1	0.00	0.00
commit batch/immediate requested	1	0.00	0.00
commit cleanout failures: callback failure	4	0.00	0.00
commit cleanouts	5,090	3.12	1.82
commit cleanouts successfully completed	5,086	3.12	1.82
commit immediate performed	1	0.00	0.00
commit immediate requested	1	0.00	0.00
commit txn count during cleanout	42	0.03	0.02
concurrency wait time	355	0.22	0.13
consistent changes	3,100	1.90	1.11
consistent gets	1,278,256,953	783,208.25	457,664.50
consistent gets - examination	662,629,523	406,003.59	237,246.52
consistent gets direct	247	0.15	0.09
consistent gets from cache	1,278,256,705	783,208.10	457,664.41
cursor authentications	151	0.09	0.05
data blocks consistent reads - undo records applied	3,100	1.90	1.11
db block changes	24,510	15.02	8.78
db block gets	23,535	14.42	8.43
db block gets direct	100	0.06	0.04
db block gets from cache	23,435	14.36	8.39
deferred (CURRENT) block cleanout applications	3,835	2.35	1.37
enqueue conversions	327	0.20	0.12
enqueue releases	24,552	15.04	8.79
enqueue requests	24,553	15.04	8.79
enqueue timeouts	1	0.00	0.00
enqueue waits	0	0.00	0.00
execute count	74,718	45.78	26.75
free buffer requested	2,589	1.59	0.93
heap block compress	383	0.23	0.14
hot buffers moved to head of LRU	10	0.01	0.00
immediate (CR) block cleanout applications	9	0.01	0.00
immediate (CURRENT) block cleanout applications	241	0.15	0.09
index crx upgrade (positioned)	1,402	0.86	0.50
index fast full scans (full)	126	0.08	0.05
index fetch by key	310,605,791	190,313.08	111,208.66
index scans kdiixs1	9,667	5.92	3.46
leaf node 90-10 splits	8	0.00	0.00
leaf node splits	23	0.01	0.01
lob reads	146	0.09	0.05
lob writes	284	0.17	0.10
lob writes unaligned	263	0.16	0.09
logons cumulative	66	0.04	0.02
messages received	4,753	2.91	1.70
messages sent	4,753	2.91	1.70
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	608,244,843	372,681.23	217,774.74
opened cursors cumulative	16,287	9.98	5.83
parse count (failures)	2,034	1.25	0.73
parse count (hard)	2,200	1.35	0.79
parse count (total)	76,540	46.90	27.40
parse time cpu	551	0.34	0.20
parse time elapsed	695	0.43	0.25
physical read IO requests	823	0.50	0.29
physical read bytes	7,634,944	4,678.05	2,733.60
physical read total IO requests	2,141	1.31	0.77
physical read total bytes	29,077,504	17,816.25	10,410.85
physical read total multi block requests	27	0.02	0.01
physical reads	930	0.57	0.33
physical reads cache	692	0.42	0.25
physical reads cache prefetch	101	0.06	0.04
physical reads direct	238	0.15	0.09
physical reads direct (lob)	215	0.13	0.08
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	89	0.05	0.03
physical write IO requests	2,265	1.39	0.81
physical write bytes	22,200,320	13,602.49	7,948.56
physical write total IO requests	10,253	6.28	3.67
physical write total bytes	61,181,952	37,487.15	21,905.46
physical write total multi block requests	6,338	3.88	2.27
physical writes	2,714	1.66	0.97
physical writes direct	100	0.06	0.04
physical writes direct (lob)	89	0.05	0.03
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	2,614	1.60	0.94
physical writes non checkpoint	1,828	1.12	0.65
prefetch clients - default	1	0.00	0.00
process last non-idle time	1,617	0.99	0.58
recovery blocks read	0	0.00	0.00
recursive calls	46,612	28.56	16.69
recursive cpu usage	261	0.16	0.09
redo blocks read for recovery	0	0.00	0.00
redo blocks written	11,956	7.33	4.28
redo entries	8,591	5.26	3.08
redo ordering marks	111	0.07	0.04
redo size	5,013,020	3,071.56	1,794.85
redo subscn max counts	300	0.18	0.11
redo synch time	89	0.05	0.03
redo synch writes	2,795	1.71	1.00
redo wastage	830,716	508.99	297.43
redo write time	60	0.04	0.02
redo writes	3,116	1.91	1.12
rollback changes - undo records applied	1	0.00	0.00
rollbacks only - consistent read gets	1,617	0.99	0.58
rows fetched via callback	41,400,594	25,366.80	14,822.98
session connect time	0	0.00	0.00
session cursor cache hits	69,081	42.33	24.73
session logical reads	1,278,280,475	783,222.66	457,672.92
session pga memory	865,488	530.30	309.88
session uga memory	4,296,589,496	2,632,588.33	1,538,342.10
session uga memory max	340,078,568	208,371.52	121,761.03
shared hash latch upgrades - no wait	7,196,405	4,409.35	2,576.59
shared hash latch upgrades - wait	27	0.02	0.01
sorts (disk)	0	0.00	0.00
sorts (memory)	42,116	25.81	15.08
sorts (rows)	286,792,413	175,722.25	102,682.57
sql area evicted	0	0.00	0.00
sql area purged	2,034	1.25	0.73
switch current to new buffer	15	0.01	0.01
table fetch by rowid	96,819,540	59,322.86	34,665.07
table fetch continued row	14,014,749	8,587.06	5,017.81
table scan blocks gotten	258,907,911	158,636.97	92,698.86
table scan rows gotten	1,015,402,044	622,152.89	363,552.47
table scans (long tables)	1,002	0.61	0.36
table scans (short tables)	36,965	22.65	13.23
total number of times SMON posted	0	0.00	0.00
transaction rollbacks	1	0.00	0.00
undo change vector size	1,240,720	760.21	444.22
user I/O wait time	187	0.11	0.07
user calls	184,584	113.10	66.09
user commits	2,793	1.71	1.00
workarea executions - optimal	14,252	8.73	5.10

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
opened cursors current	76	82
logons current	32	33
session cursor cache count	815	2,133

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s
JSCMS	281	1.99	1.34	1,864	1
SYSAUX	492	2.62	1.02	238	0
SYSTEM	215	2.84	1.00	18	0
UNDOTBS	0	0.00	0.00	129	0
JSCMS_IND_4K	4	0.00	1.00	9	0
JSCMS_IND_16K	4	0.00	1.00	6	0

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes
JSCMS	D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS01.DBF	97	3.09	1.29	85
JSCMS	D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS02.DBF	138	0.58	1.12	209
JSCMS	D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS03.DBF	5	6.00	4.40	345
JSCMS	D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS04.DBF	4	10.00	3.50	99
JSCMS	D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS05.DBF	6	1.67	2.00	168
JSCMS	D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS06.DBF	16	0.00	1.00	93
JSCMS	D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS07.DBF	0			255
JSCMS	D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS08.DBF	0			243
JSCMS	D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS09.DBF	4	2.50	1.50	123
JSCMS	D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS10.DBF	1	10.00	3.00	147
JSCMS	D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS11.DBF	8	7.50	1.75	47
JSCMS	D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS12.DBF	2	10.00	4.50	50
JSCMS_IND_16K	D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS_IND_1	4	0.00	1.00	6
JSCMS_IND_4K	D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\JSCMS_IND_4	4	0.00	1.00	9
SYSAUX	D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\SYSAUX01.DB	492	2.62	1.02	238
SYSTEM	D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\SYSTEM01.DB	215	2.84	1.00	18
UNDOTBS	D:\ORACLE\PRODUCT\10.2.0\ORADATA\DSQQCMS\UNDOTBS.DBF	0			129

Back to IO Stats
Back to Top

Buffer Pool Statistics

Standard block size Pools D: default, K: keep, R: recycle
Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes
D	809,411	100	346,194,774	754	2,579
16k	8,040	100	785,306,569	4	9
4k	30,656	100	145,706,335	4	26

Advisory Statistics

Instance Recovery Stats
Buffer Pool Advisory
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
SGA Target Advisory
Streams Pool Advisory
Java Pool Advisory

Instance Recovery Stats

B: Begin snapshot, E: End snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	8	531	1713	353880	353880
E	0	8	546	1929	12352	353880	12352

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	1,005	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto)
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
%Man W/A Mem - percentage of workarea memory under manual control

	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 Mem	Global Mem Bound(K)
B	2,048	1,825	55.68	0.20	0.36	100.00	0.00	209,710
E	2,048	1,824	59.47	0.00	0.00	0.00	0.00	209,710

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	12,551	12,551
64K	128K	603	603
128K	256K	869	869
256K	512K	62	62
512K	1024K	29	29
1M	2M	16	16
2M	4M	44	44
4M	8M	68	68
8M	16M	22	22

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd PGA Cache Hit %
256	0.13	1,538.84	100.00
512	0.25	1,538.84	100.00
1,024	0.50	1,538.84	100.00
1,536	0.75	1,538.84	100.00
2,048	1.00	1,538.84	100.00
2,458	1.20	1,538.84	100.00
2,867	1.40	1,538.84	100.00
3,277	1.60	1,538.84	100.00
3,686	1.80	1,538.84	100.00
4,096	2.00	1,538.84	100.00
6,144	3.00	1,538.84	100.00
8,192	4.00	1,538.84	100.00
12,288	6.00	1,538.84	100.00
16,384	8.00	1,538.84	100.00

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
192	0.14	31	2,690	4,258	1.00	12	1.00	34,037
336	0.25	31	2,690	4,258	1.00	12	1.00	34,037
480	0.36	31	2,690	4,258	1.00	12	1.00	34,037
624	0.46	31	2,690	4,258	1.00	12	1.00	34,037
768	0.57	31	2,690	4,258	1.00	12	1.00	34,037
912	0.68	31	2,690	4,258	1.00	12	1.00	34,037
1,056	0.79	31	2,690	4,258	1.00	12	1.00	34,037
1,200	0.89	31	2,690	4,258	1.00	12	1.00	34,037
1,344	1.00	31	2,690	4,258	1.00	12	1.00	34,037
1,488	1.11	31	2,690	4,258	1.00	12	1.00	34,037
1,632	1.21	31	2,690	4,258	1.00	12	1.00	34,037
1,776	1.32	31	2,690	4,258	1.00	12	1.00	34,037
1,920	1.43	31	2,690	4,258	1.00	12	1.00	34,037
2,064	1.54	31	2,690	4,258	1.00	12	1.00	34,037
2,208	1.64	31	2,690	4,258	1.00	12	1.00	34,037
2,352	1.75	31	2,690	4,258	1.00	12	1.00	34,037
2,496	1.86	31	2,690	4,258	1.00	12	1.00	34,037
2,640	1.96	31	2,690	4,258	1.00	12	1.00	34,037
2,784	2.07	31	2,690	4,258	1.00	12	1.00	34,037

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)
2,048	0.25	5,976
4,096	0.50	5,976
6,144	0.75	5,976
8,192	1.00	5,976
10,240	1.25	5,976
12,288	1.50	5,976
14,336	1.75	5,976
16,384	2.00	5,976

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

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

No data exists for this section of the report.

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

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
9	0.14	2,328	136	3	5760/5760	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
28-4月 15:53	38	1,021	136	3	5,760	0/0	0/0/0/0/0/0
28-4月 15:43	102	1,307	0	2	5,760	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Parent Latch Statistics
Child Latch Statistics

Latch Activity

"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
"Pct Misses" for both should be very close to 0.0

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM db client latch	1,089	0.00		0	0
AWR Alerted Metric Element list	6,125	0.00		0	0
Consistent RBA	3,115	0.00		0	0
FOB s.o list latch	221	0.00		0	0
In memory undo latch	14,838	0.00		0	3,140	0.00
JS mem alloc latch	8	0.00		0	0
JS queue access latch	8	0.00		0	0
JS queue state obj latch	11,788	0.00		0	0
JS slv state obj latch	6	0.00		0	0
KMG MMAN ready and startup request latch	544	0.00		0	0
KTF sga latch	3	0.00		0	504	0.00
MQL Tracking Latch	0			0	33	0.00
Memory Management Latch	0			0	544	0.00
OS process	210	0.00		0	0
OS process allocation	685	0.00		0	0
OS process: request allocation	129	0.00		0	0
PL/SQL warning settings	107	0.00		0	0
SGA IO buffer pool latch	23	0.00		0	23	0.00
SQL memory manager latch	1	0.00		0	544	0.00
SQL memory manager workarea list latch	38,594	0.00		0	0
Shared B-Tree	58	0.00		0	0
active checkpoint queue latch	3,792	2.74	0.00	0	0
active service list	3,603	0.00		0	633	0.00
archive control	4	0.00		0	0
begin backup scn array	90	0.00		0	0
cache buffer handles	196	0.00		0	0
cache buffers chains	1,894,179,255	5.74	0.01	4	2,778	0.00
cache buffers lru chain	5,757	0.45	0.00	0	170,514,950	0.48
cache table scan latch	0			0	3	0.00
channel handle pool latch	130	0.00		0	0
channel operations parent latch	7,844	0.00		0	0
checkpoint queue latch	187,365	0.01	0.00	0	2,602	0.00
client/application info	321	0.00		0	0
compile environment latch	66	0.00		0	0
dml lock allocation	11,458	0.00		0	0
dummy allocation	131	0.00		0	0
enqueue hash chains	49,496	0.00		0	0
enqueues	34,547	0.03	0.00	0	0
event group latch	65	0.00		0	0
file cache latch	55	0.00		0	0
global KZLD latch for mem in SGA	62	0.00		0	0
hash table column usage latch	395	0.00		0	4,634	0.00
hash table modification latch	58	0.00		0	0
job workq parent latch	0			0	2	0.00
job_queue_processes free list latch	2	0.00		0	0
job_queue_processes parameter latch	29	0.00		0	0
kks stats	378	0.53	0.00	0	0
ksuosstats global area	111	0.00		0	0
ktm global data	5	0.00		0	0
kwqbsn:qsga	58	0.00		0	0
lgwr LWN SCN	3,136	0.00		0	0
library cache	131,392	0.13	0.00	0	0
library cache load lock	756	0.00		0	0
library cache lock	38,418	0.14	0.00	0	0
library cache lock allocation	866	0.00		0	0
library cache pin	12,581	0.16	0.00	0	0
library cache pin allocation	204	0.00		0	0
list of block allocation	150	0.00		0	0
loader state object freelist	452	0.00		0	0
longop free list parent	82	0.00		0	82	0.00
messages	26,442	1.26	0.00	0	0
mostly latch-free SCN	3,157	0.16	0.00	0	0
multiblock read objects	46	0.00		0	0
ncodef allocation latch	124	0.00		0	0
object queue header heap	34,480	0.00		0	1	0.00
object queue header operation	43,455	0.00	0.00	0	0
object stats modification	83	0.00		0	0
parallel query alloc buffer	196	0.00		0	0
parameter list	4	0.00		0	0
parameter table allocation management	66	0.00		0	0
post/wait queue	4,197	0.00		0	2,835	0.00
process allocation	129	0.00		0	65	0.00
process group creation	129	0.00		0	0
qmn task queue latch	232	0.00		0	0
redo allocation	15,771	0.01	0.00	0	8,533	1.20
redo copy	0			0	8,576	0.02
redo writing	14,342	0.73	0.00	0	0
resmgr group change latch	65	0.00		0	0
resmgr:active threads	128	0.00		0	0
resmgr:actses change group	63	0.00		0	0
resmgr:free threads list	127	0.00		0	0
resmgr:schema config	1	0.00		0	0
row cache objects	94,304	4.44	0.00	0	0
sequence cache	589	0.00		0	0
session allocation	75,650	0.00	0.00	0	0
session idle bit	372,116	0.00	0.00	0	0
session state list latch	137	0.00		0	0
session switching	124	0.00		0	0
session timer	633	0.00		0	0
shared pool	45,992	0.22	0.00	0	0
shared pool sim alloc	16	0.00		0	0
shared pool simulator	25,905	0.01	0.00	0	0
slave class	2	0.00		0	0
slave class create	8	12.50	1.00	0	0
sort extent pool	135	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
threshold alerts latch	68	0.00		0	0
transaction allocation	153	0.00		0	0
transaction branch allocation	633	0.00		0	0
undo global data	18,262	0.03	0.00	0	0
user lock	248	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	1,894,179,255	108,651,568	940,019	107,998,312
messages	26,442	332	1	331
slave class create	8	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

only latches with sleeps are shown
ordered by name, sleeps desc

Latch Name	Where	Sleeps	Waiter Sleeps
cache buffers chains	kcbgtcr: kslbegin excl	1,417,678	1,442,292
cache buffers chains	kcbrls: kslbegin	1,416,346	1,402,578
cache buffers chains	kcbgtcr: fast path	35	6
cache buffers chains	kcbchg: kslbegin: bufs not pinned	13	9
cache buffers chains	kcbget: exchange rls	2	0
cache buffers chains	kcbgcur: kslbegin	1	0
messages	ksarcv: after wait	1	0
slave class create	ksvcreate	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

Segments by Logical Reads
Segments by Physical Reads
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 1,278,280,475
Captured Segments account for 99.1% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
JSCMS	JSCMS_IND_16K	INFO_KEYWORD		INDEX	777,179,552	60.80
JSCMS	JSCMS	ARTICLE	SYS_P76	TABLE PARTITION	229,413,008	17.95
JSCMS	JSCMS_IND_4K	PKKEY_ARTICLE		INDEX	144,973,792	11.34
JSCMS	JSCMS	ARTICLE	SYS_P75	TABLE PARTITION	65,301,616	5.11
JSCMS	JSCMS	ARTICLE	SYS_P73	TABLE PARTITION	35,981,088	2.81

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 930
Captured Segments account for 70.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
JSCMS	JSCMS	SYS_LOB0000051993C00019$$	YS_LOB_P85	LOB PARTITION	97	10.43
SYS	SYSAUX	WRH$_SQL_PLAN_PK		INDEX	70	7.53
JSCMS	JSCMS	LH_ARTICLE_INDX		INDEX	65	6.99
JSCMS	JSCMS	SYS_LOB0000051993C00019$$	YS_LOB_P88	LOB PARTITION	57	6.13
JSCMS	JSCMS	SYS_LOB0000051993C00019$$	YS_LOB_P87	LOB PARTITION	55	5.91

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

"Pct Misses" should be very low (< 2% in most cases)
"Final Usage" is the number of cache entries being used

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	30	0.00	2	1
dc_database_links	125	0.00	0	1
dc_global_oids	22	0.00	0	12
dc_histogram_data	3,891	2.60	0	780
dc_histogram_defs	3,641	18.70	0	2,654
dc_object_ids	17,232	0.60	0	615
dc_objects	1,056	10.42	1	507
dc_profiles	64	0.00	0	1
dc_rollback_segments	787	0.00	0	102
dc_segments	1,763	5.22	4	481
dc_sequences	8	12.50	8	6
dc_tablespace_quotas	1	100.00	1	1
dc_tablespaces	470	0.00	0	10
dc_usernames	498	5.82	0	42
dc_users	4,274	0.51	0	53
outstanding_alerts	18	0.00	0	9

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	5	60.00	45	6.67	0
CLUSTER	3	0.00	7	0.00	0
INDEX	114	8.77	699	1.43	0
SQL AREA	79,387	91.41	81,481	5.67	2,032
TABLE/PROCEDURE	502	32.07	2,343	13.70	1

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Process Memory Summary

B: Begin snap E: End snap
All rows below contain absolute values (i.e. not diffed over the interval)
Max Alloc is Maximum PGA Allocation size at snapshot time
Hist Max Alloc is the Historical Max Allocation for still-connected processes
ordered by Begin/End snapshot, Alloc (MB) desc

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	38.48		1.13	1.55	9	42	34	34
	Freeable	15.88	0.00	0.93	0.90	4		17	17
	SQL	1.25	0.83	0.05	0.06	0	43	23	23
	PL/SQL	0.10	0.04	0.00	0.00	0	0	32	32
E	Other	37.76		1.08	1.49	9	11	35	35
	Freeable	20.88	0.00	0.99	0.79	4		21	21
	SQL	0.76	0.47	0.03	0.03	0	43	24	23
	PL/SQL	0.10	0.04	0.00	0.00	0	0	33	33

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin 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

ordered by Pool, Name
N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot

Pool	Name	Begin MB	End 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	db_block_hash_buckets	45.00	45.00	0.00
shared	free memory	1,144.26	1,135.50	-0.77
shared	sql area		17.68
	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

Streams CPU/IO Usage
Streams Capture
Streams Apply
Buffered Queues
Buffered Subscribers
Rule Set

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.

init.ora Parameters

Parameter Name	Begin value	End 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
cursor_sharing	FORCE
db_16k_cache_size	134217728
db_4k_cache_size	134217728
db_block_size	8192
db_cache_advice	OFF
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
db_writer_processes	4
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

End of Report

% Blocks changed per Read:	0.00	Recursive Call %:	20.16
Rollback per transaction %:	0.00	Rows per Sort:	6809.58

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	94.14	Soft Parse %:	97.13
Execute to Parse %:	-2.44	Latch Hit %:	94.27
Parse CPU to Parse Elapsd %:	79.28	% Non-Parse CPU:	99.87