WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
ORCL	1298563979	orcl	1	10.2.0.5.0	NO	wdfcmp

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	10235	24-Feb-13 00:00:17	40	7.1
End Snap:	10299	26-Feb-13 16:00:33	122	18.7
Elapsed:		3,840.27 (mins)
DB Time:		11,739.73 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	17,600M	17,696M	Std Block Size:	8K
Shared Pool Size:	2,672M	2,576M	Log Buffer:	14,296K

Load Profile

	Per Second	Per Transaction
Redo size:	421,031.54	136,230.13
Logical reads:	88,220.99	28,545.03
Block changes:	2,782.54	900.33
Physical reads:	1,169.22	378.32
Physical writes:	101.52	32.85
User calls:	231.52	74.91
Parses:	162.31	52.52
Hard parses:	46.39	15.01
Sorts:	857.50	277.46
Logons:	0.07	0.02
Executes:	563.06	182.19
Transactions:	3.09

% Blocks changed per Read:	3.15	Recursive Call %:	83.22
Rollback per transaction %:	2.08	Rows per Sort:	10.14

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	99.99
Buffer Hit %:	99.13	In-memory Sort %:	100.00
Library Hit %:	88.24	Soft Parse %:	71.42
Execute to Parse %:	71.17	Latch Hit %:	99.89
Parse CPU to Parse Elapsd %:	65.74	% Non-Parse CPU:	96.28

Shared Pool Statistics

	Begin	End
Memory Usage %:	38.96	36.20
% SQL with executions>1:	94.33	39.81
% Memory for SQL w/exec>1:	93.91	52.60

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		294,995		41.9
db file sequential read	21,037,493	157,375	7	22.3	User I/O
buffer busy waits	47,735	43,317	907	6.1	Concurrency
log file sync	775,106	17,764	23	2.5	Commit
log file switch (checkpoint incomplete)	29,437	17,699	601	2.5	Configuration

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

Wait Events Statistics

• Time Model Statistics
• Wait Class
• Wait Events
• Background Wait Events
• Operating System Statistics
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

• Total time in database user-calls (DB Time): 704383.6s
• 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

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
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

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)
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

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 seconds

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
• Total DB Time (s): 704,384
• Captured SQL account for 49.8% of Total

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 is the CPU Time divided into the Total CPU Time times 100
• Total CPU Time (s): 294,995
• Captured SQL account for 43.7% of Total

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: 20,327,572,132
• Captured SQL account for 44.6% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 269,408,657
• Captured SQL account for 10.1% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 129,738,601
• Captured SQL account for 62.2% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 37,398,631
• Captured SQL account for 26.5% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
02nhdra9z7b2d	select DataSetName , tSysClassDict."ROWID" from tSysClassDict where ClassId=:"SYS_B_0"
091rmkuc80y8u	UPDATE TCVSTHBODY SET TAG=:"SYS_B_0" WHERE TAG<>:"SYS_B_1" AND DATASTATE=:"SYS_B_2" AND ORGCODE=:"SYS_B_3"
0fv9wbfyra9q0	Select * from tWebComField where FaceCode=:"SYS_B_0"
13b4q2qjm1k2z	SELECT count(*) FROM tSalPayHead WHERE :"SYS_B_0" = :"SYS_B_1" And OrgCode = :"SYS_B_2" And to_char ( JkDate, :"SYS_B_3" ) Between :"SYS_B_4" And :"SYS_B_5" and ((( tSalPayHead.OrgCode in ( select OrgCode from ( select OrgCode from tOrgManage start with OrgCode = :"SYS_B_6" connect by Prior OrgCode = PreOrgCode ) ) or tSalPayHead.OrgCode = :"SYS_B_7" ) ))
13x01bd986fqn	SELECT BGNDATE , BGNTIME , BILLNO , ENDDATE , ENDTIME , GENTYPE , GROUPNO , ORGCODE , PLUCODE , PLUID , PLUTYPE , POSCOMUPTYPE , PRI , PRICE , REMARK , UPD1 , UPD2 , UPD3 , UPD4 , UPD5 , UPTDATE , TPROCXZHZXORGGROUP."ROWID" FROM TPROCXZHZXORGGROUP WHERE ORGCODE=:"SYS_B_0" AND UPTDATE >=TO_DATE(:"SYS_B_1", :"SYS_B_2")
14nxsybunua07	Select * from tWebComTable where FaceCode=:"SYS_B_0" and ComItemCode=:"SYS_B_1" Order by IsMaster Desc, SerialNo
1506ft6gwszrd	Update tWebComLogin Set LastDate=sysdate where OrgCode=:"SYS_B_0"
1fv9rn6um5f8h	Select * FROM (SELECT SerialNo, OrgCode, OrgName, RptDate, XsDate, SaleNo, PageNo, LnNo, PcGuid, PcNo, PluID, PluCode, ExPluCode, PluName, BarCode, Unit, Spec, DepID, DepCode, DepName, Season, ClsID, ClsCode, ClsName, BrandCode, BrandName, EtpCode, EtpName, CntID, HtCode, JyMode, JsCode, JhEtpCode, JhEtpName, JhCntID, JhHtCode, JhJyMode, JhJsCode, XsCount, HJPrice, WJPrice, Price, FsPrice, HJCost, WJCost, HXTotal, WXTotal, HyTotal, CxTotal, HMTotal, WMTotal, JTaxRate, XTaxRate, IsKc, IsJz, IsCl, DataType, CxBillNo, KcBillNo, PluType, KcSerialNo, CxDataType, TcRate FROM (SELECT * FROM TSALPLUDETAIL201302 where (RptDate >= :"SYS_B_0" And RptDate <= :"SYS_B_1") ) tSalPluDetailYYYYMM) tSalPluDetailYYYYMM where ( PluCode = :"SYS_B_2" ) and ( RptDate >= :"SYS_B_3" And RptDate <= :"SYS_B_4" ) and ((( tSalPluDetailYYYYMM.OrgCode in ( select OrgCode from ( select OrgCode from tOrgManage start with OrgCode = :"SYS_B_5" connect by Prior OrgCode = PreOrgCode ) ) or tSalPluDetailYYYYMM.OrgCode = :"SYS_B_6" ) )) and ((exists( select * from tUsrRightOrg where UserId = :"SYS_B_7" and (OrgCode=tSalPluDetailYYYYMM.OrgCode and tSalPluDetailYYYYMM.DepCode like DepCode || :"SYS_B_8"))) or (tSalPluDetailYYYYMM.DepCode is null))
22352n4z8tv3v	UPDATE TSYSLSKCLOCKDATA SET KYCOUNT=KYCOUNT-:B2 WHERE ROWID=:B1
24c6vrzw1ug5g	select B.* from tWebComItem B
25af3drxuaqgb	SELECT BGNTIME , BILLNO , CARDLXCODE , ENDTIME , ISENABLED , LMTCOUNT , LMTTYPE , ORGCODE , PLUCODE , PLUID , POSCOMUPTYPE , PRI , UPTDATE , YHPRICE , YHRATE , YHTYPE , VPROCXHYPLU."ROWID" FROM VPROCXHYPLU WHERE UPTDATE >= TO_DATE(:"SYS_B_0", :"SYS_B_1") AND ORGCODE=:"SYS_B_2"
26twhcjg0m4rd	Select ComType from twebcomlogin where OrgCode=:"SYS_B_0"
2dfnbtdvjyq1u	SELECT BillNo , SerialNo , ToSerialNo , CkCode , CkName , LAreaCode , (SELECT a.LAreaName FROM tStoLArea a WHERE a.LAreaCode=tStoCkBody.LAreaCode AND ORGCODE=:"SYS_B_0" AND CKCODE=TSTOCKBODY.CKCODE) AS LAreaCode$ , CwCode , CwBarCode , WlAreaCode , (SELECT a.WlAreaName FROM tStoArea a WHERE a.WlAreaCode=tStoCkBody.WlAreaCode AND ORGCODE=:"SYS_B_1") AS WlAreaCode$ , CkrId , CkrCode , CkrName , PluID , PluCode , PluName , BarCode , ExPluCode , ExPluName , Spec , Unit , PluType , PlanCount , PackUnit , PackQty , PackCount , SglCount , CkCount , PrnTimes , PrnDate , Remark FROM tStoCkBody Where BillNo = :"SYS_B_2"
2gw4dt8v4gyjn	SELECT BGNDATE, BGNTIME, BILLNO, CXTYPE, DATATYPE, ENDDATE, ENDTIME, ISENABLED, ISHYZSZ, LMTCOUNT, ORGCODE, PLUCODE, PLUID, POSCOMUPTYPE, PRI, UPTDATE, YHPRICE, YHRATE, YHTYPE FROM VPROCXPTPLU WHERE UPTDATE >= TO_DATE(:"SYS_B_0", :"SYS_B_1") AND ORGCODE=:"SYS_B_2"
2q9d3yh417u9h	UPDATE TCVSZDPSBODY SET TAG=:"SYS_B_0" WHERE TAG<>:"SYS_B_1" AND DATASTATE=:"SYS_B_2" AND ORGCODE=:"SYS_B_3"
2uwmmnqdwxw57	Select tWebComTable.*, tWebComTable."ROWID" from tWebComTable where FaceCode=:"SYS_B_0" and ComItemCode=:"SYS_B_1" Order by IsMaster Desc, SerialNo
37k5gfkz283ay	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN sSys_HsCmp_DailyForJob; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
3dfma4831cp2s	SELECT RptID , ClmName , ClmType , ClmCaption , ClmDefField , ClmDefCaption , TitleFont , ClmDataType , DispWdith , DispFmt , AnlignType , ForeColor , ClmFont , FootType , FootCaption , LnkObject , LnkFldCode , LnkFldName , IsLocal , IsRight , IsCanSort , IsCanFlt , IsSelect , IsCalculate , Formula , IsDisplay , IsLevel , IsSum , IsAdd , IsGroup , GrpExp , IsGrpSum , IsFigure , IsDefFigure , IsFigLable , IsDefFigLable , IsQryRelation , SerialNo FROM tRptRptColumn Where (RptID = :"SYS_B_0") and rownum <= :"SYS_B_1"
3m7n4vk1f8c43	UPDATE TSTKLSKC SET KCCOUNT=KCCOUNT-:B7 , HCOST=HCOST-:B6 , WCOST=WCOST-:B5 WHERE ORGCODE=:B4 AND DEPID=:B3 AND CKCODE=:B2 AND WLAREACODE='*' AND PCNO=:B1
3scwabj9qsmkj	select B.*, B."ROWID" from tWebComItem B where B.FaceCode=:"SYS_B_0" and B.ComItemCode=:"SYS_B_1"
3tu9cczxngqxn	select a.orgcode, a.etpname, a.xsdate, a.hsxsje, a.wsxsje, a.hsml, a.hsmllv, a.wsml, nvl(b.hsxsje, :"SYS_B_00") as fw_hsxsje, nvl(b.wsxsje, :"SYS_B_01") as fw_wsxsje, nvl(b.hsml, :"SYS_B_02") as fw_hsml, nvl(b.hsmllv, :"SYS_B_03") as fw_hsmllv, nvl(b.wsml, :"SYS_B_04") as fw_wsml, a.hsxsje+nvl(b.hsxsje, :"SYS_B_05") as hz_hsxsje, a.wsxsje+nvl(b.wsxsje, :"SYS_B_06") as hz_wsxsje, a.hsml+nvl(b.hsml, :"SYS_B_07") as hz_hsml, a.wsml+nvl(b.wsml, :"SYS_B_08") as hz_wsml from ( select t.orgcode, g.etpname, to_char(t.xsdate, :"SYS_B_09") as xsdate, sum(t.hxtotal) as hsxsje, sum(t.wxtotal) as wsxsje, sum(t.hmtotal) as hsml, round( sum(t.hmtotal)/(sum(t.hxtotal)+:"SYS_B_10") , :"SYS_B_11")*:"SYS_B_12" as hsmllv, sum(t.wmtotal) as wsml from ( select orgcode, barcode, hxtotal, wxtotal, hmtotal, wmtotal, xsdate from tSalPluDetail201301 where DataType in (:"SYS_B_13", :"SYS_B_14", :"SYS_B_15", :"SYS_B_16", :"SYS_B_17") union all SELECT orgcode, barcode, hxtotal, wxtotal, hmtotal, wmtotal, xsdate from tSalPluDetail201302 where DataType in (:"SYS_B_18", :"SYS_B_19", :"SYS_B_20", :"SYS_B_21", :"SYS_B_22") union all select orgcode, barcode, sstotal as hxtotal, sstotal as wxtotal , :"SYS_B_23" as hmtotal, :"SYS_B_2 4" as wmtotal, xsdate from tSalSaleplu where TranType<>:"SYS_B_25" and NOT SALENO LIKE :"SYS_B_26" ) t , tOrgExInfo f , tEtpEnterprise g where t.orgcode=f.orgcode and t.orgcode=g.etpcode and not t.barcode in (:"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") and t.xsdate >= to_date(:"SYS_B_43", :"SYS_B_44" ) and t.xsdate <= to_date(:"SYS_B_45", :"SYS_B_46") group by t.orgcode, to_char(t.xsdate, :"SYS_B_47"), g.etpname ) a, --·þÎñÐÔÏîÄ¿ (select t.orgcode, to_char(t.xsdate, :"SYS_B_48") as xsdate, sum(t.hxtotal) as hsxsje, sum(t.wxtotal) as wsxsje, sum(t.hmtotal) as hsml, round( sum(t.hmtotal)/(sum(t.hxtotal)+:"SYS_B_49") , :"SYS_B_50")*:"SYS_B_51" as hsmllv, sum(t.wmtotal) as wsml from ( select orgcode, barcode, hxtotal, wxtotal, hmtotal, wmtotal, xsdate from tSalPluDetail201301 where DataType in (:"SYS_B_52", :"SYS_B_53", :"SYS_B_54", :"SYS_B_55", :"SYS_B_56") union all SELECT orgcode, barcode, hxtotal, wxtotal, hmtotal, wmtotal, xsdate from tSalPluDetail201302 where DataType in (:"SYS_B_57", :"SYS_B_58", :"SYS_B_59", :"SYS_B_60", :"SYS_B_61") union all select orgcode, barcode, sstotal as hxtotal, sstotal as wxtotal , :"SYS_B_62" as hmtotal, :"SYS_B_63" as wmtotal, xsdate from tSalSaleplu where TranType<>:"SYS_B_64" and NOT SALENO LIKE :"SYS_B_65") t where t.barcode in (:"SYS_B_66", :"SYS_B_67", :"SYS_B_68", :"SYS_B_69", :"SYS_B_70", :"SYS_B_71", :"SYS_B_72", :"SYS_B_73", :"SYS_B_74", :"SYS_B_75", :"SYS_B_76", :"SYS_B_77", :"SYS_B_78", :"SYS_B_79", :"SYS_B_80", :"SYS_B_81") and t.xsdate >= to_date(:"SYS_B_82", :"SYS_B_83" ) and t.xsdate <= to_date(:"SYS_B_84", :"SYS_B_85") group by t.orgcode, to_char(t.xsdate, :"SYS_B_86") ) b where a.xsdate=b.xsdate(+) and a.orgcode= b.orgcode(+)
3x5mvt73katgg	SELECT COUNT(1) FROM TSKUPLUEX WHERE ORGCODE=:B2 AND PLUID=:B1
42n46ckrhbpb2	SELECT Billno , Serialno , PluID , PluCode , PluName , BarCode , ExPluCode , ExPluName , Spec , Unit , PriceType , JdRate , PsPrice , PsTotal , PackUnit , PackQty , PackCount , SglCount , PsCount , PluType , DepID , DepCode , (SELECT a.DepName FROM tOrgDept a WHERE a.DepID=tDstPsBody.DepID ) AS DepName , (SELECT a.DotDecimal FROM tSkuPlu a WHERE a.PluID=tDstPsBody.PluID ) AS R_DotDecimal , Remark , DataSource , Tag , WPsPrice , WPsTotal , XTaxRate , XTaxTotal , PlnCount , SdCount , KwCode , Price , STotal , CargoNo , MaterialCode , CxYhTotal , CxMsg , YhBillNo , YhSerialno , RefSerialno , StlCurrPsPrice , StlCurrPsTotal , ChgType , (SELECT a.LxName FROM tBasFlContent a WHERE a.LxCode=tDstPsBody.ChgType AND FLCODE=:"SYS_B_0" AND LXCODE<:"SYS_B_1") AS ChgType$ , LsPrice , ZkRate , PsPlnBillNo , PsPlnSerialNo , ClsID , ClsCode , ClsName , ScDate , PzCode FROM tDstPsBody Where BillNo = :"SYS_B_2" ORDER BY KwCode, ClsCode, Pluname, Unit, PluCode
43yqd5khtcuth	Select * from tWebComField where FaceCode=:"SYS_B_0" And ComItemCode=:"SYS_B_1" And upper(SendTable)=:"SYS_B_2"
4a0sdb2w6tmv1	begin sSys_SaleParam_RJ_Original(:ms_OrgCode, :ms_Date, :mi_UserId, :ms_UserCode, :ms_UserName, :mi_I, :ms_M); end;
4h6w2hs9n3wnz	SELECT ORGCODE, DEPID, CKCODE, PCNO, SALENO, PAGENO, LNNO, JZDATE, PLUID, XSCOUNT, CKCOUNT, ROUND(SSTOTAL*CKCOUNT/XSCOUNT, 2) AS SSTOTAL, ROUND(CXTOTAL*CKCOUNT/XSCOUNT, 2) AS CXTOTAL, ROUND(HYTOTAL*CKCOUNT/XSCOUNT, 2) AS HYTOTAL, ROUND(YSTOTAL*CKCOUNT/XSCOUNT, 2) AS YSTOTAL FROM (SELECT X.SALENO, X.PAGENO, X.LNNO, X.JZDATE, X.XSCOUNT, Y.ORGCODE, Y.DEPID, Y.CKCODE, Y.PCNO, Y.PLUID, Y.KCCOUNT, CASE WHEN (Y.KCCOUNT-X.SUMCOUNT)>=0 THEN X.XSCOUNT ELSE (Y.KCCOUNT-X.SUMCOUNT)+X.XSCOUNT END AS CKCOUNT, X.SSTOTAL, X.CXTOTAL, X.HYTOTAL, X.YSTOTAL FROM (SELECT ORGCODE, SALENO, PAGENO, LNNO, JZDATE, DEPID, PLUID, PLUTYPEF, XSCOUNT, SUM(XSCOUNT) OVER(PARTITION BY ORGCODE, DEPID, PLUID, PLUTYPEF ORDER BY ORGCODE, SALENO, PAGENO, LNNO ASC) AS SUMCOUNT, SSTOTAL, CXTOTAL, HYTOTAL, YSTOTAL FROM TSYS_DECA01_TEMP) X, (SELECT ORGCODE, DEPID, CKCODE, PCNO, PLUID, PLUTYPE, PLUTYPEF, KCCOUNT, JHDATE, ROW_NUMBER() OVER(PARTITION BY ORGCODE, DEPID, PLUID, PLUTYPEF ORDER BY JHDATE ASC) AS NUMCOUNT FROM TSYS_DECB01_TEMP) Y WHERE X.ORGCODE=Y.ORGCODE AND X.DEPID=Y.DEPID AND X.PLUID=Y.PLUID AND X.PLUTYPEF=Y.PLUTYPEF AND Y.NUMCOUNT=1) WHERE CKCOUNT>0
4q97ufg5vu2uq	SELECT ISTH, TO_CHAR(MAXINCOUNT), MAXINCOUNTLIMIT FROM TSKUPLUEX WHERE ORGCODE=:B2 AND PLUID=:B1
4wzc12hz2tx0m	select B.* from tWebComItem B where B.FaceCode=:"SYS_B_0" and B.ComItemCode=:"SYS_B_1"
5216pwt38ckhp	UPDATE TSTKLSKC SET KCCOUNT=KCCOUNT-:B7 , HCOST=HCOST-:B9 , WCOST=WCOST-:B8 , TEMPDATE=CASE KCCOUNT WHEN :B7 THEN :B6 ELSE NULL END WHERE ORGCODE=:B5 AND DEPID=:B4 AND CKCODE=:B3 AND WLAREACODE=:B2 AND PCNO=:B1
56azgmqnubry9	SELECT BillNo , Serialno , PluID , PluCode , PluName , BarCode , ExPluCode , ExPluName , Spec , Unit , ThPrice , PackUnit , PackQty , PackCount , SglCount , ThCount , ThTotal , Remark , DepID , (SELECT a.DepCode FROM tOrgDept a WHERE a.DepID=tDstRtnBody.DepID ) AS DepCode , (SELECT a.DepName FROM tOrgDept a WHERE a.DepID=tDstRtnBody.DepID ) AS DepName , PluType , ScDate , BzDays , (SELECT a.DotDecimal FROM tSkuPlu a WHERE a.PluID=tDstRtnBody.PluID ) AS R_DotDecimal , (SELECT a.UDP9 FROM tSkuPlu a WHERE a.PluID=tDstRtnBody.PluID ) AS UDP9 , ThReason , (SELECT a.LxName FROM tBasFlContent a WHERE a.LxCode=tDstRtnBody.ThReason AND FLCODE IN (:"SYS_B_0", :"SYS_B_1")) AS ThReason$ , WThPrice , WThTotal , XTaxRate , XTaxTotal , PlnCount , IsTh , KwCode , Price , STotal , StlCurrThPrice , StlCurrThTotal , CargoNo , MaterialCode , PieceCount , ChgType , (SELECT a.LxName FROM tBasFlContent a WHERE a.LxCode=tDstRtnBody.ChgType AND FLCODE=:"SYS_B_2" AND LXCODE>=:"SYS_B_3") AS ChgType$ , OriThCount , (SELECT a.UDP1 FROM tSkuPlu a WHERE a.PluID=tDstRtnBody.PluID ) AS Udp1 FROM tDstRtnBody Where BillNo = :"SYS_B_4"
59ybxu7r1g03f	UPDATE TCVSZDPSBODY SET TAG=:"SYS_B_0" WHERE TAG=:"SYS_B_1" AND TAG<>:"SYS_B_2" AND DATASTATE=:"SYS_B_3" AND ORGCODE=:"SYS_B_4"
5cf7hmzgu3uvn	select a.orgcode, a.etpname, a.udp1, a.udp2, a.hsxsje, a.wsxsje, a.hsml, a.hsmllv, a.wsml, nvl(b.hsxsje, :"SYS_B_00") as fw_hsxsje, nvl(b.wsxsje, :"SYS_B_01") as fw_wsxsje, nvl(b.hsml, :"SYS_B_02") as fw_hsml, nvl(b.hsmllv, :"SYS_B_03") as fw_hsmllv, nvl(b.wsml, :"SYS_B_04") as fw_wsml, a.hsxsje+nvl(b.hsxsje, :"SYS_B_05") as hz_hsxsje, a.wsxsje+nvl(b.wsxsje, :"SYS_B_06") as hz_wsxsje, a.hsml+nvl(b.hsml, :"SYS_B_07") as hz_hsml, a.wsml+nvl(b.wsml, :"SYS_B_08") as hz_wsml from ( select t.orgcode, g.etpname, f.udp1, f.udp2, sum(t.hxtotal) as hsxsje, sum(t.wxtotal) as wsxsje, sum(t.hmtotal) as hsml, round( sum(t.hmtotal)/(sum(t.hxtotal)+:"SYS_B_09") , :"SYS_B_10")*:"SYS_B_11" as hsmllv, sum(t.wmtotal) as wsml from ( select orgcode, barcode, hxtotal, wxtotal, hmtotal, wmtotal, xsdate from tSalPluDetail201301 where DataType in (:"SYS_B_12", :"SYS_B_13", :"SYS_B_14", :"SYS_B_15", :"SYS_B_16") union all SELECT orgcode, barcode, hxtotal, wxtotal, hmtotal, wmtotal, xsdate from tSalPluDetail201302 where DataType in (:"SYS_B_17", :"SYS_B_18", :"SYS_B_19", :"SYS_B_20", :"SYS_B_21") union all select orgcode, barcode, sstotal as hxtotal, sstotal as wxtotal , :"SYS_B_22" as hmtotal, :"SYS_B_23" as wmtotal, xsdate fro m tSalSaleplu where TranType<>:"SYS_B_24" and NOT SALENO LIKE :"SYS_B_25" ) t , tOrgExInfo f , tEtpEnterprise g where t.orgcode=f.orgcode and t.orgcode=g.etpcode and not t.barcode in (:"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") and t.xsdate >= to_date(:"SYS_B_43", :"SYS_B_44" ) and t.xsdate <= to_date(:"SYS_B_45", :"SYS_B_46") group by t.orgcode, g.etpname, f.udp1, f.udp2 ) a, --·þÎñÐÔÏîÄ¿ (select t.orgcode, sum(t.hxtotal) as hsxsje, sum(t.wxtotal) as wsxsje, sum(t.hmtotal) as hsml, round( sum(t.hmtotal)/(sum(t.hxtotal)+:"SYS_B_47") , :"SYS_B_48")*:"SYS_B_49" as hsmllv, sum(t.wmtotal) as wsml from ( select orgcode, barcode, hxtotal, wxtotal, hmtotal, wmtotal, xsdate from tSalPluDetail201301 where DataType in (:"SYS_B_50", :"SYS_B_51", :"SYS_B_52", :"SYS_B_53", :"SYS_B_54") union all SELECT orgcode, barcode, hxtotal, wxtotal, hmtotal, wmtotal, xsdate from tSalPluDetail201302 where DataType in (:"SYS_B _55", :"SYS_B_56", :"SYS_B_57", :"SYS_B_58", :"SYS_B_59") union all select orgcode, barcode, sstotal as hxtotal, sstotal as wxtotal , :"SYS_B_60" as hmtotal, :"SYS_B_61" as wmtotal, xsdate from tSalSaleplu where TranType<>:"SYS_B_62" and NOT SALENO LIKE :"SYS_B_63") t where t.barcode in (:"SYS_B_64", :"SYS_B_65", :"SYS_B_66", :"SYS_B_67", :"SYS_B_68", :"SYS_B_69", :"SYS_B_70", :"SYS_B_71", :"SYS_B_72", :"SYS_B_73", :"SYS_B_74", :"SYS_B_75", :"SYS_B_76", :"SYS_B_77", :"SYS_B_78", :"SYS_B_79", :"SYS_B_80") and t.xsdate >= to_date(:"SYS_B_81", :"SYS_B_82" ) and t.xsdate <= to_date(:"SYS_B_83", :"SYS_B_84") group by t.orgcode ) b where a.orgcode=b.orgcode(+)
5d4w6b4g8gu47	select a.orgcode, a.etpname, a.udp1, a.udp2, a.hsxsje, a.wsxsje, a.hsml, a.hsmllv, a.wsml, nvl(b.hsxsje, :"SYS_B_00") as fw_hsxsje, nvl(b.wsxsje, :"SYS_B_01") as fw_wsxsje, nvl(b.hsml, :"SYS_B_02") as fw_hsml, nvl(b.hsmllv, :"SYS_B_03") as fw_hsmllv, nvl(b.wsml, :"SYS_B_04") as fw_wsml, a.hsxsje+nvl(b.hsxsje, :"SYS_B_05") as hz_hsxsje, a.wsxsje+nvl(b.wsxsje, :"SYS_B_06") as hz_wsxsje, a.hsml+nvl(b.hsml, :"SYS_B_07") as hz_hsml, a.wsml+nvl(b.wsml, :"SYS_B_08") as hz_wsml from ( select t.orgcode, g.etpname, f.udp1, f.udp2, sum(t.hxtotal) as hsxsje, sum(t.wxtotal) as wsxsje, sum(t.hmtotal) as hsml, round( sum(t.hmtotal)/(sum(t.hxtotal)+:"SYS_B_09") , :"SYS_B_10")*:"SYS_B_11" as hsmllv, sum(t.wmtotal) as wsml from ( select orgcode, barcode, hxtotal, wxtotal, hmtotal, wmtotal, xsdate from tSalPluDetail201302 where DataType in (:"SYS_B_12", :"SYS_B_13", :"SYS_B_14", :"SYS_B_15", :"SYS_B_16") union all select orgcode, barcode, sstotal as hxtotal, sstotal as wxtotal , :"SYS_B_17" as hmtotal, :"SYS_B_18" as wmtotal, xsdate from tSalSaleplu where TranType<>:"SYS_B_19" and NOT SALENO LIKE :"SYS_B_20" ) t , tOrgExInfo f , tEtpEnterprise g where t.orgcode=f.orgcode and t.orgcode=g.etpcode and not t.barcode in (:"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") and t.xsdate >= to_date(:"SYS_B_38", :"SYS_B_39" ) and t.xsdate <= to_date(:"SYS_B_40", :"SYS_B_41") group by t.orgcode, g.etpname, f.udp1, f.udp2 ) a, --·þÎñÐÔÏîÄ¿ (select t.orgcode, sum(t.hxtotal) as hsxsje, sum(t.wxtotal) as wsxsje, sum(t.hmtotal) as hsml, round( sum(t.hmtotal)/(sum(t.hxtotal)+:"SYS_B_42") , :"SYS_B_43")*:"SYS_B_44" as hsmllv, sum(t.wmtotal) as wsml from ( select orgcode, barcode, hxtotal, wxtotal, hmtotal, wmtotal, xsdate from tSalPluDetail201302 where DataType in (:"SYS_B_45", :"SYS_B_46", :"SYS_B_47", :"SYS_B_48", :"SYS_B_49") union all select orgcode, barcode, sstotal as hxtotal, sstotal as wxtotal , :"SYS_B_50" as hmtotal, :"SYS_B_51" as wmtotal, xsdate from tSalSaleplu where TranType<>:"SYS_B_52" and NOT SALENO LIKE :"SYS_B_53") t where t.barcode in (:"SYS_B_54", :"SYS_B_55", :"SYS_B_56" , :"SYS_B_57", :"SYS_B_58", :"SYS_B_59", :"SYS_B_60", :"SYS_B_61", :"SYS_B_62", :"SYS_B_63", :"SYS_B_64", :"SYS_B_65", :"SYS_B_66", :"SYS_B_67", :"SYS_B_68", :"SYS_B_69", :"SYS_B_70") and t.xsdate >= to_date(:"SYS_B_71", :"SYS_B_72" ) and t.xsdate <= to_date(:"SYS_B_73", :"SYS_B_74") group by t.orgcode ) b where a.orgcode=b.orgcode(+)
5t2jkzcphbn4g	UPDATE TCVSJHBODY SET TAG=:"SYS_B_0" WHERE TAG=:"SYS_B_1" AND TAG<>:"SYS_B_2" AND YWTYPE=:"SYS_B_3" AND ORGCODE=:"SYS_B_4"
5uwbg8gd4b0qq	SELECT tSkuPlu.*, tSkuPlu."ROWID" FROM tSkuPlu WHERE (PluCode=:"SYS_B_0" Or CargoNo=:"SYS_B_1" Or BarCode=:"SYS_B_2" or MaterialCode=:"SYS_B_3") and IsActive=:"SYS_B_4" AND (IsActive = :"SYS_B_5" and YwStatus in ( :"SYS_B_6" , :"SYS_B_7" ) and IsKc = :"SYS_B_8" and Exists ( select PluID from tSkuPluEx where OrgCode = :"SYS_B_9" and PLuID = tSkuPlu.PLuID ))
6fzqkjh00c8q0	BEGIN sStk_FollowMeRece(:1, :2, :3, :4, :5, :6); END;
6r3kuttm5vax4	select distinct BillNo, OrgCode from tCvsPayBody where BillNo=:"SYS_B_0"
6zg7trkgzg3yf	SELECT QID_TSTKKCMONTH_SERIALNO.NEXTVAL FROM DUAL
7384gbr4tdmnt	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN --¡¾ÈÎÎñ±àÂë¡¿£º£¨0103£© SJOB_GATHERSALES('*'); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
7rcsysu9557sv	Select ComType , twebcomlogin."ROWID" from twebcomlogin where OrgCode=:"SYS_B_0"
849gk14t5hav7	SELECT CARDCODE , CARDID , CARDPWD , CKRCODE , CKRID , CKRNAME , DATASTATUS , ENDDATE , FIELD1 , FIELD2 , FIELD3 , INITDATE , INVALIDDATE , ISALLCLEAR , ISPRESENT , ISRECEDE , ISREPRINT , ISVIEWREPORT , ISVOID , LRDATE , MAXRATE , MAXTOTAL , ORGCODE , ORGNAME , REMARK , USERCODE , USERID , USERNAME , YWSTATUS , TSALRIGHTCARD."ROWID" FROM TSALRIGHTCARD WHERE ORGCODE=:"SYS_B_0"
8dsuf8bb6hk60	BEGIN PSSY_DB.SSTK_LETSGO_ORA( :1, :2, :3, :4, :5, :6, :7, :8 ); END;
8nrjwtfs2s8fh	SELECT B.SERIALNO, B.BILLNO, B.YWTYPE, A.ROWID AS KCROWID, A.ORGCODE, A.DEPID, A.PREDEPID, A.CKCODE, A.WLAREACODE, A.PLUID, A.PACKQTY, A.EXPLUCODE, A.PLUTYPE, A.PCGUID, A.PCNO, A.KCCOUNT, A.KCCOUNT-NVL((SELECT SUM(LOCKCOUNT) FROM TSTKLSKCLOCK WHERE ORGCODE=A.ORGCODE AND DEPID=A.DEPID AND CKCODE=A.CKCODE AND WLAREACODE=A.WLAREACODE AND PCNO=A.PCNO), 0) AS KYCOUNT, A.HCOST, A.WCOST, A.JHDATE, (SELECT SCDATE FROM TSTKPC WHERE PCNO=A.PCNO) AS SCDATE FROM TSTKLSKC A, TSYSLSKCBILLDATA B WHERE A.ORGCODE=B.ORGCODE AND A.DEPID=B.DEPID AND A.CKCODE=B.CKCODE AND A.PLUID=B.PLUID AND B.BILLNO=:B2 AND B.YWTYPE=:B1 AND A.KCCOUNT>0 FOR UPDATE OF A.KCCOUNT
986qr50vpxmwc	BEGIN SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_03', 'HSCMP'); END;
9as33rwqkzsxp	SELECT BARCODE , BILLNO , CARGONO , CGBILLNO , CKCODE , DATASTATE , DEPCODE , DEPID , DEPNAME , DHDATE , EXPLUCODE , EXPLUNAME , JHCOUNT , LRDATE , ORGCODE , PLUCODE , PLUID , PLUNAME , REALCOUNT , REMARK , SCDATE , SERIALNO , SPEC , SUPCODE , UNIT , USERCODE , USERID , YWTYPE , TCVSJHBODY."ROWID" FROM TCVSJHBODY WHERE TAG<>:"SYS_B_0" AND YWTYPE=:"SYS_B_1" AND ORGCODE=:"SYS_B_2"
9cxcma3jb80dh	BEGIN SEXECORAPROCEDURE( :1, :2, :3, :4, :5, :6 ); END;
9j7tuj8mt5pmf	SELECT BARCODE , BILLNO , DATASTATE , EXPLUCODE , EXPLUNAME , FHBGNDATE , FHENDDATE , FHTYPE , FHTYPE , FHTYPENAME , FHTYPENAME , JZDATE , LRDATE , MODIFYTYPE , MODIFYTYPENAME , ORGCODE , PLUCODE , PLUID , PLUNAME , PSCOUNT , REMARK , SERIALNO , SPEC , TAG , UDP1 , UDP2 , UDP3 , UDP4 , UDP5 , UNIT , USERCODE , USERID , USERNAME , TCVSZDPSBODY."ROWID" FROM TCVSZDPSBODY WHERE TAG<>:"SYS_B_0" AND DATASTATE=:"SYS_B_1" AND ORGCODE=:"SYS_B_2"
9k6468cky4q55	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN --¡¾ÈÎÎñ±àÂë¡¿£º£¨0104£© SJOB_GATHERRPT('*', '', '', '', 0); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
9y4jnhcws3jgc	SELECT IsSelect , BillNo , LrDate , UserID , UserCode , UserName , JzrID , JzrCode , JzrName , RptDate , PrnTimes , PrnDate , TimeMark , YwType , (SELECT a.YwTypeName FROM tSysYwType a WHERE a.YwType=tSalPayHead.YwType) AS YwType$ , OrgCode , OrgName , JkDate , JkType , DataStatus , JzDate , YsTotal , SsTotal , ChkTotal , ChkCount , ChkUserId , ChkUserCode , ChkUserName , ChkDate , IsZf , OriBillNo , ChKZTotal , MdCyTotal , ChKCYTotal FROM tSalPayHead Where (:"SYS_B_0" = :"SYS_B_1" And OrgCode = :"SYS_B_2" And to_char ( JkDate, :"SYS_B_3" ) Between :"SYS_B_4" And :"SYS_B_5" and ((( tSalPayHead.OrgCode in ( select OrgCode from ( select OrgCode from tOrgManage start with OrgCode = :"SYS_B_6" connect by Prior OrgCode = PreOrgCode ) ) or tSalPayHead.OrgCode = :"SYS_B_7" ) ))) and rownum <= :"SYS_B_8"
absdr89pb19cy	UPDATE TCVSJHBODY SET TAG=:"SYS_B_0" WHERE TAG<>:"SYS_B_1" AND YWTYPE=:"SYS_B_2" AND ORGCODE=:"SYS_B_3"
aj42bn2u07xxc	UPDATE TCVSDBBODY SET TAG=:"SYS_B_0" WHERE TAG=:"SYS_B_1" AND TAG<>:"SYS_B_2" AND YWTYPE=:"SYS_B_3" AND DATASTATE=:"SYS_B_4" AND ORGCODE=:"SYS_B_5"
aqj8ptv38nntc	UPDATE TSKUPLUPARAS SET AVGKCCOUNT=AVGKCCOUNT+:B6 *:B5 , AVGKCTOTAL=AVGKCTOTAL+:B4 *:B5 , KCPERCENT=CASE WHEN :B3 =0 THEN 0 ELSE CASE WHEN ROUND(:B4 *100.00/:B3 , 2)>100.00 THEN 100.00 WHEN ROUND(:B4 *100.00/:B3 , 2)<-100.00 THEN -100.00 ELSE ROUND(:B4 *100.00/:B3 , 2) END END WHERE ORGCODE=:B2 AND PLUID=:B1
ax8tdc572zcny	SELECT count(*) FROM tDstPsBody WHERE BillNo = :"SYS_B_0"
bbqp1ywqmvhv2	SELECT '['||TO_CHAR(D1.CLSCODE)||']'||D1.CLSNAME AS BM , '['||TO_CHAR(D2.CLSCODE)||']'||D2.CLSNAME AS DL , '['||TO_CHAR(D3.CLSCODE)||']'||D3.CLSNAME AS ZL , '['||TO_CHAR(D.CLSCODE)||']'||D.CLSNAME AS XFL, S.PLUCODE, S.PLUNAME, S.BARCODE, S.SPEC, S.UNIT, CASE UDP10 WHEN '1' THEN 'Õý³£' WHEN '2' THEN '²»Òª¿É·¢' WHEN '3' THEN '²»Òª²»·¢' WHEN '4' THEN 'Ô¤ÌÔÌ­' WHEN '5' THEN 'Í£ÊÛÇåÍË' WHEN '6' THEN 'ÌÔÌ­' ELSE '䶨Òå' END AS YWSTATUS , NVL(H.HJPRICE, S.HJPRICE) AS HJPRICE, NVL(HX.MINHJPRICE, H.HJPRICE) AS MINHJPRICE , NVL(H.WJPRICE, S.WJPRICE) AS WJPRICE, NVL(F.PRICE, S.PRICE) AS PRICE, NVL(F.HYPRICE, S.HYPRICE) AS HYPRICE, CASE S.UDP1 WHEN '1' THEN '²»ÄÜÍË' WHEN '2'THEN '¹ýÆÚÍË' WHEN '3' THEN 'ÁÙ½ü±£ÖÊÆÚ1/6ÍË' WHEN '4' THEN '³§¼Ò»»»õ' ELSE '䶨Òå' END AS UDP1 , S.UDP2, S.UDP3, S.UDP4, HT.HTNAME AS ETPNAME, S.UDP5, S.UDP6, S.UDP7, S.UDP8, H.JTAXRATE, H.JTAXCALTYPE, S.LRDATE, S.LRUSERCODE, S.LRUSERNAME, F.ISJH, F.ISTH, F.ISPS, F.ISJS, F.ISSALE, F.ISSALETH, F.ISCANPRESENT, H.ISTH, S.PLUMN, S.PLUWEIGHT, S.PLUWIDTH, S.PLUHEIGHT, S.PLUHEIGHT, S.PLULONG, S.CGYNAME, S.PRODUCE, S.PLUID, NVL(SPCZ.PACKQTY, 0) AS ZJXS , NVL(SPFD.PACKQTY, 0) AS ZXFHL , CASE HT.JYMODE WHEN '0' THEN '¾­Ïú' WHEN '1' THEN '´úÏú' WHEN '2' THEN 'ÁªÏú' WHEN '3' THEN '×âÁÞ' ELSE 'ÎÞ' END AS JYMODE , CASE HT.JSCODE WHEN '0' THEN '¾­Ïú½áËã' WHEN '1' THEN '´úÏú½áËã' WHEN '2' THEN 'ÁªÏú½áËã' WHEN '3' THEN '×â½ð½áËã' ELSE 'ÎÞ' END JSCODE, HT.YQDAYS, HT.ZQDAYS, NVL(FXDS.FXJS, 0) AS FXJS, NVL(YHDS.YHJ S, 0) AS YHJS, NVL(S.BRANDCODE, 'ÎÞ') AS BRANDCODE, NVL(P.BRANDNAME, 'ÎÞ') AS BRANDNAME, F.AQDAYS FROM (SELECT PLUID, PLUCODE, PLUNAME, PLUENAME, PLUABBRNAME, PLUMN, BARCODE, UNIT, SPEC, PLUWEIGHT, PLUHEIGHT, PLULONG, PLUWIDTH, ISMULPACKET, ORGCODE, ORGNAME, CGYID, CGYCODE, CGYNAME, CARGONO, PRODUCE, GRADE, QUALITY, ISSEASON, SALESEASON, BZDAYS, CASE LENGTH(CLSID) WHEN 11 THEN '8'||SUBSTR(PLUCODE, 0, 4)||'01' +0 ELSE CLSID END CLSID, BRANDCODE, JTAXCALTYPE, WJPRICE, HJPRICE, JTAXRATE, PRICE, XTAXRATE, PROMDECIMAL, PROMFORMULA, DOTDECIMAL, ISWEIGHT, ISCOUTQTY, ISSELFBRAND, ISKC, ISFRESH, ISEXPLUCODE, ISCURRDAY, JHBFBZDAYS, PSBFBZDAYS, ISNEWPLU, ISACTIVE, CXINFO, YWSTATUS, LRDATE, LRUSERID, LRUSERCODE, LRUSERNAME, ZXDATE, ZXUSERID, ZXUSERCODE, ZXUSERNAME, UDP1, UDP2, UDP3, UDP4, UDP5, UDP6, UDP7, UDP8, UDP9, DATASTATUS, HYPRICE, PLUCLS, PLUMODEL, UDP10, UDP11, UDP12, UDP13, UDP14, MATERIALCODE, LRORGCODE, LRORGNAME, DATASRC FROM TSKUPLU ) S, TBASBRAND P, (SELECT * FROM TSKUPLUEX WHERE ORGCODE='WDF00')F, (SELECT X.HTCODE, H.* FROM TCNTCONTRACT X, TCNTPLU H WHERE X.CNTID=H.CNTID ) H, ( SELECT CASE LENGTH(D.CLSID) WHEN 11 THEN '8'||D.CLSCODE+0 ELSE D.CLSID END CLSID , D.CLSCODE, D.CLSNAME FROM TCATCATEGORY D) D, ( SELECT CASE LENGTH(D.CLSID) WHEN 11 THEN '8'||D.CLSCODE+0 ELSE D.CLSID END CLSID , D.CLSCODE, D.CLSNAME FROM TCATCATEGORY D ) D1, ( SELECT CASE LENGTH(D.CLSID) WHEN 11 THEN '8'||D.CLSCODE+0 ELSE D.CLSID END CLSID , D.CLSCODE, D.CLSNAME FROM TCATCATEGORY D) D2, ( SE L ECT CASE LENGTH(D.CLSID) WHEN 11 THEN '8'||D.CLSCODE+0 ELSE D.CLSID END CLSID , D.CLSCODE, D.CLSNAME FROM TCATCATEGORY D ) D3 , (SELECT * FROM TSKUPLUPACKET WHERE ISPUR='1' )SPCZ, ( SELECT * FROM TSKUPLUPACKET WHERE ISDIST='1') SPFD , (SELECT M.PLUID, MIN(M.HJPRICE) AS MINHJPRICE FROM TORDJHHEAD P, TORDJHBODY M WHERE P.BILLNO=M.BILLNO AND P.YWTYPE='0904' GROUP BY M.PLUID) HX, TCNTCONTRACT HT , ( SELECT F.PLUID, COUNT(F.ORGCODE) AS FXJS FROM TSKUPLUEX F WHERE LENGTH(F.ORGCODE)=4 AND F.ISJH='1' GROUP BY F.PLUID ) FXDS, (SELECT PLUID, COUNT(ORGCODE) AS YHJS FROM ( SELECT A.ORGCODE , A.PLUID, SUM(A.KCCOUNT) AS KCSL FROM TSTKLSKC A WHERE LENGTH(A.ORGCODE)= 4 GROUP BY A.ORGCODE , A.PLUID HAVING SUM(A.KCCOUNT)>0 ) N1 GROUP BY PLUID ) YHDS WHERE SUBSTR(S.CLSID, 2, 2)=D1.CLSCODE(+) AND SUBSTR(S.CLSID, 2, 3)=D2.CLSCODE(+) AND SUBSTR(S.CLSID, 2, 4)=D3.CLSCODE(+) AND S.CLSID=D.CLSID(+) AND S.UDP4=HT.HTCODE(+) AND S.PLUID=H.PLUID(+) AND S.UDP4=H.HTCODE(+) AND S.PLUID= F.PLUID(+) AND S.PLUID=HX.PLUID(+) AND S.PLUID=SPCZ.PLUID(+) AND S.PLUID= SPFD.PLUID(+) AND S.PLUID=FXDS.PLUID(+) AND S.PLUID=YHDS.PLUID(+) AND S.BRANDCODE=P.BRANDCODE(+) AND EXISTS (SELECT 1 FROM TUSRRIGHTORG A, ( SELECT CASE LENGTH(D.CLSID) WHEN 11 THEN '8'||D.CLSCODE+0 ELSE D.CLSID END CLSID , D.CLSCODE, D.CLSNAME FROM TCATCATEGORY D) C WHERE A.USERID=:B1 AND C.CLSID = S.CLSID AND C.CLSCODE LIKE A.DEPCODE||'%')
bf412rgaw4uyn	begin sSku_DaySettleOfParas_Original(:ms_OrgCode, :ms_Date, :mi_UserId, :ms_UserCode, :ms_UserName, :mi_I, :ms_M); end;
bmxbbahrn8ubt	Insert into tSalPosLog201302(OrgCode, SaleNo, OprDate, PosNo, UserID, UserCode, UserName, OperatType, OperatTotal, Operat, JzDate)Select OrgCode, SaleNo, OprDate, PosNo, UserID, UserCode, UserName, OperatType, OperatTotal, Operat, :JzDate as JzDate From tSalPosLog PosLog Where Exists(Select 1 From tSalSale Where OrgCode=PosLog.OrgCode and SaleNo=PosLog.SaleNo and SalGUID=:SalGUID and JzDate=:JzDate02 and TranType<>'5')
bna29bcgu3pbr	SELECT count(*) FROM tDstRtnBody WHERE BillNo = :"SYS_B_0"
cjq91hg7qh6xd	SELECT ORGCODE , DEPID , ISHYDSC , ISPLDSC , ISXLDSC , ISPTDSC , ISPACKDSC , SPEC , UNIT , BARCODE , PLUMN , UPTDATE , POSCOMUPTYPE , POSCOMCURNO , BRANDCODE , CLSCODE , CLSID , UPTFLAG , ISMINPRICE , ISPRESENT , ISCANPRESENT , ISCANSALETH , ISCANSALE , MAXPRICE , MINPRICE , ISCOUTQTY , ISWEIGHT , PLUTYPE , PROMFORMULA , PROMDECIMAL , XTAXRATE , DOTDECIMAL , PRICE , HYPRICE , ISZEROSALE , ISKCNOW , ISKC , ISCERTIDSC , PLUENAME , DEPCODE , PLUID , PLUCODE , PLUNAME , DEPNAME , PLUABBRNAME , VSKUGTPLU."ROWID" FROM VSKUGTPLU WHERE ORGCODE=:"SYS_B_0" AND UPTDATE >=TO_DATE(:"SYS_B_1", :"SYS_B_2")
cjw47bnmu0z2f	UPDATE TSKUPLUPARAS SET KCABC=:B6 , XSABC=:B5 , MLABC=:B4 , ZHABC=:B3 WHERE ORGCODE=:B2 AND PLUID=:B1
cpa7wp2th7tx2	SELECT BARCODE , BILLNO , CARGONO , CKCODE , DATASTATE , DEPCODE , DEPID , DEPNAME , EXPLUCODE , EXPLUNAME , JZDATE , LRDATE , ORGCODE , PLUCODE , PLUID , PLUNAME , REASON , REMARK , SERIALNO , SPEC , SUPCODE , THCOUNT , TJDATE , UNIT , USERCODE , USERID , YWTYPE , TCVSTHBODY."ROWID" FROM TCVSTHBODY WHERE TAG<>:"SYS_B_0" AND DATASTATE=:"SYS_B_1" AND ORGCODE=:"SYS_B_2"
d4nfqkahsmn05	UPDATE TSKUPLUPARAS SET AVGKCCOUNT=:B9 , AVGKCTOTAL=:B8 , AVGPSCOUNT=:B7 , AVGPSTOTAL=:B6 , AVG1STCOUNT=:B5 , AVGXSTOTAL=:B4 , AVGMLTOTAL=:B3 WHERE ORGCODE=:B2 AND PLUID=:B1
dv7t3p1w4pn0f	Select * from tWebComField where FaceCode=:"SYS_B_0" And ComItemCode=:"SYS_B_1"
fcgwk3qgp2zsr	UPDATE TCVSTHBODY SET TAG=:"SYS_B_0" WHERE TAG=:"SYS_B_1" AND TAG<>:"SYS_B_2" AND DATASTATE=:"SYS_B_3" AND ORGCODE=:"SYS_B_4"
fcsw30vk481ab	Select tWebComField.*, tWebComField."ROWID" from tWebComField where FaceCode=:"SYS_B_0" And ComItemCode=:"SYS_B_1" And upper(SendTable)=:"SYS_B_2"
fkrs7tk295qhk	SELECT COUNT(1) FROM TCVSGTPLUUDP WHERE ORGCODE=:B2 AND PLUID=:B1
fm5cfb4kpy0mz	UPDATE TCVSGTPLUUDP SET ISTH=:B3 , UDP1=:B2 , UDP2=:B1 , UPTDATE=SYSDATE, POSCOMUPTYPE='0' WHERE ORGCODE=:B5 AND PLUID=:B4 AND (ISTH<>:B3 OR NVL(UDP1, '0')<>:B2 OR NVL(UDP2, '0')<>:B1 )
fr4uqtgmvgwa0	INSERT INTO TTMPSKUGTPLU (ORGCODE, DEPID, PLUID, ISKC, ISKCNOW, ISPACKDSC, ISPTDSC, ISXLDSC, ISPLDSC, ISHYDSC, ISCERTIDSC, UPTFLAG, POSCOMUPTYPE, DEPFLAG) SELECT X.ORGCODE, X.DEPID, X.PLUID , '1', '1', '0', '0', '0', '0', '0', '0', '1', '0' , '0' FROM (SELECT A.ORGCODE, A.DEPID, A.PLUID FROM TSKUPLUEX A, TORGMANAGE B, TSTKSTORE E, TPLUINCREASE_TMP C WHERE EXISTS(SELECT D.ORGCODE FROM TSTKLSKC D WHERE A.ORGCODE=D.ORGCODE AND A.DEPID=D.DEPID AND E.CKCODE=D.CKCODE AND A.PLUID=D.PLUID) AND A.ORGCODE=C.ORGCODE AND A.PLUID=C.PLUID AND A.DEPID=C.DEPID AND A.DEPID<>0 AND A.ORGCODE=B.ORGCODE AND B.ISENABLE='1' AND A.ORGCODE=E.ORGCODE AND E.CKTYPE='0' ) X, TSKUPLU Z WHERE X.PLUID=Z.PLUID AND Z.ISACTIVE='1' AND Z.ISKC='1' AND NOT EXISTS(SELECT 1 FROM TTMPSKUGTPLU B WHERE X.PLUID = B.PLUID AND X.DEPID = B.DEPID AND X.ORGCODE = B.ORGCODE)
ftkpvbpb4yjny	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN sSys_HsCmp_GtPluForJob; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
fxvnj5uac3rgv	Update tCvsGtPlu set IsPs=:"SYS_B_0" where OrgCode=:"SYS_B_1" and PluId=:"SYS_B_2"
g789f1k0q1156	insert into tStkJxcRptSouce201302(RptDate, OrgCode, FOrgCode, DepId, CkCode, PluId, ClsId, YwType, DataType, JhEtpCode, JhCntId, JhJyMode, JhJsCode, EtpCode, CntId, JyMode, JsCode, JTaxRate, RecCount, HCost, WCost) select :mm_Rpt_01, :mm_Org_01, :mm_FOrgCode, DepId, CkCode, PluId, nvl((select B.ClsId from tSkuPlu B where B.PluId=X.PluId), 0) As ClsId, '0000', '2', JhEtpCode, JhCntId, JhJyMode, JhJsCode, EtpCode, CntId, JyMode, JsCode, JTaxRate, sum(case when JsCode in ('3') then 0 else KcCount*DataFlag end), sum(case when JsCode in ('3') then 0 else HCost*DataFlag end), sum(case when JsCode in ('3') then 0 else WCost*DataFlag end) from (select A.CkCode, A.DepId, A.PluId, 1 As DataFlag, B.CntId As JhCntId, B.EtpCode As JhEtpCode, B.JyMode As JhJyMode, B.JsCode As JhJsCode, C.CntId, C.EtpCode, C.JyMode, C.JsCode, B.JTaxRate, A.KcCount, A.HCost, A.WCost from tStkLsKc A, tStkPcGUID B, tStkPc C where A.OrgCode=:mm_Org_02 and A.PcGUID=B.PcGUID and A.PcNo=C.PcNo and A.KcCount>0 union all select A.CkCode, B.DepId, B.PluId, decode(A.BillType, '0', -1, 1) As DataFlag, C.CntId As JhCntId, C.EtpCode As JhEtpCode, C.JyMode As JhJyMode, C.JsCode As JhJsCode, B.CntId, B.EtpCode, B.JyMode, B.JsCode, C.JTaxRate, B.RecCount As KcCount, B.Hcost, B.WCost from tStkKcJzHead A, tStkKcJzBody B, tStkPcGUID C where A.BillNo=B.BillNo and A.InOrgCode=:mm_Org_03 and A.RptDate>:mm_Rpt_02 and A.YwType<>'1105' and B.PcGUID=C.PcGUID) X group by DepId, CkCode, PluId, JhEtpCode, JhCntId, JhJyMode, JhJsCode, EtpCode, CntId, JyMode, JsCode, JTaxRate
gfsdw44n7x0wj	SELECT ROWID AS MYROWID, KYCOUNT, (SELECT ORDERNUM FROM TSTOAREAYWCTRL WHERE ORGCODE=:B13 AND WLAREACODE=A.WLAREACODE AND WLYWTYPE=:B12 AND ISCLYW='1') AS ORDERNUM FROM TSYSLSKCLOCKDATA A WHERE BILLNO=:B11 AND YWTYPE=:B10 AND ORGCODE=:B9 AND DEPID=:B8 AND CKCODE=:B7 AND PLUID=:B6 AND ((:B1 ='2002' AND PACKQTY=:B5 ) OR (:B1 <>'2002')) AND PLUTYPE=:B4 AND EXPLUCODE=:B3 AND KYCOUNT>0 AND ((:B2 <>'*' AND WLAREACODE=:B2 ) OR :B2 ='*') AND ((:B1 ='2002' AND EXISTS (SELECT 1 FROM TSTOAREAYWCTRL WHERE ORGCODE=:B13 AND WLYWTYPE=:B12 AND WLAREACODE=A.WLAREACODE AND ISCLYW='1')) OR (:B1 <>'2002')) ORDER BY ORDERNUM ASC, JHDATE ASC
gjbjrmkrw4424	select sysdate , dual."ROWID" from dual
gw91dr7wkpnt9	SELECT count(*) FROM tRptPara WHERE RptID = :"SYS_B_0"
gwck0qa3zvft8	SELECT BGNDATE , BGNTIME , BILLNO , ENDDATE , ENDTIME , ORGCODE , PLUCODE , PLUCOUNT , PLUID , POSCOMUPTYPE , PRI , UPTDATE , YHPRICE , VPROCXZHZXPLU."ROWID" FROM VPROCXZHZXPLU WHERE UPTDATE >= TO_DATE(:"SYS_B_0", :"SYS_B_1") AND ORGCODE=:"SYS_B_2"

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

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

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

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File

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

Back to Top

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

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

• Only rows with estimated physical reads >0 are displayed
• ordered by Block Size, Buffers For Estimate

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

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

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

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

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

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.

Back to Advisory Statistics
Back to Top

SGA Target Advisory

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

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

• ordered by wait time desc, waits desc

Back to Wait Statistics
Back to Top

Enqueue Activity

• only enqueues with waits are shown
• Enqueue stats gathered prior to 10g should not be compared with 10g data
• ordered by Wait Time desc, Waits desc

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

Back to Undo Statistics
Back to Top

Undo Segment Stats

• Most recent 35 Undostat rows, ordered by Time desc

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

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

• ordered by misses desc