WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
ADS	537315831	ads	1	11-May-14 14:05	11.2.0.1.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
s4000n06	Solaris[tm] OE (64-bit)	32	16	4	128.00

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	26862	20-Jun-14 01:00:52	191	4.8
End Snap:	26866	20-Jun-14 05:00:30	279	4.9
Elapsed:		239.64 (mins)
DB Time:		17,968.47 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	5,632M	5,632M	Std Block Size:	8K
Shared Pool Size:	9,984M	9,984M	Log Buffer:	130,040K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	75.0	6.6	0.19	0.71
DB CPU(s):	1.7	0.2	0.00	0.02
Redo size:	167,433.6	14,825.7
Logical reads:	34,234.9	3,031.4
Block changes:	835.1	74.0
Physical reads:	6,983.7	618.4
Physical writes:	25.0	2.2
User calls:	106.0	9.4
Parses:	358.7	31.8
Hard parses:	3.6	0.3
W/A MB processed:	1.7	0.2
Logons:	0.1	0.0
Executes:	387.1	34.3
Rollbacks:	1.3	0.1
Transactions:	11.3

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	97.32	Redo NoWait %:	100.00
Buffer Hit %:	79.70	In-memory Sort %:	100.00
Library Hit %:	98.09	Soft Parse %:	99.01
Execute to Parse %:	7.35	Latch Hit %:	98.17
Parse CPU to Parse Elapsd %:	89.46	% Non-Parse CPU:	98.36

Shared Pool Statistics

	Begin	End
Memory Usage %:	70.12	70.23
% SQL with executions>1:	90.30	99.63
% Memory for SQL w/exec>1:	89.43	98.80

Top 5 Timed Foreground Events

Host CPU (CPUs: 32 Cores: 16 Sockets: 4)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
3.70	4.06	11.7	1.4	0.0	86.9

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
12.3	93.9	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	131,072.0	131,072.0
SGA use (MB):	37,120.0	37,120.0
PGA use (MB):	3,545.0	3,836.7
% Host Mem used for SGA+PGA:	31.02	31.25

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
• Shared Server Statistics
• init.ora Parameters

Wait Events Statistics

• Time Model Statistics
• Operating System Statistics
• Operating System Statistics - Detail
• Foreground Wait Class
• Foreground Wait Events
• Background Wait Events
• Wait Event Histogram
• Wait Event Histogram Detail (64 msec to 2 sec)
• Wait Event Histogram Detail (4 sec to 2 min)
• Wait Event Histogram Detail (4 min to 1 hr)
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

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

Operating System Statistics

• *TIME statistic values are diffed. All others display actual values. End Value is displayed if different
• ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond - 1000th of a second
• ordered by wait time desc, waits desc
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
• Captured Time accounts for 100.1% of Total DB time 1,078,108.35 (s)
• Total FG Wait Time: 1,054,697.14 (s) DB CPU time: 24,148.32 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

• s - second, ms - millisecond - 1000th of a second
• Only events with Total Wait Time (s) >= .001 are shown
• 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)
• Only events with Total Wait Time (s) >= .001 are shown
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• % of Waits: value of .0 indicates value was <.05%; value of null is truly 0
• % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
• Ordered by Event (idle events last)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

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 User I/O Wait Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Physical Reads (UnOptimized)
• 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 - Elapsed Time as a percentage of Total DB time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 190.4% of Total DB Time (s): 1,078,108
• Captured PL/SQL account for 1.1% of Total DB Time (s): 1,078,108

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 - CPU Time as a percentage of Total DB CPU
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 140.8% of Total CPU Time (s): 24,148
• Captured PL/SQL account for 6.8% of Total CPU Time (s): 24,148

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - User I/O Time as a percentage of Total User I/O Wait time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 191.2% of Total User I/O Wait Time (s): 1,054,628
• Captured PL/SQL account for 1.0% of Total User I/O Wait Time (s): 1,054,628

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 as a percentage of Total Buffer Gets
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Buffer Gets: 492,237,088
• Captured SQL account for 157.5% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• %Total - Physical Reads as a percentage of Total Disk Reads
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Disk Reads: 100,413,630
• Captured SQL account for 148.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

• UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
• %Opt - Optimized Reads as percentage of SQL Read Requests
• %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
• Total Physical Read Requests: 62,041,340
• Captured SQL account for 141.8% of Total
• Total UnOptimized Read Requests: 62,041,340
• Captured SQL account for 141.8% of Total
• Total Optimized Read Requests: 1
• Captured SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Executions: 5,566,418
• Captured SQL account for 91.2% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 5,157,531
• Captured SQL account for 96.9% 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
0126cqufqzasp	SELECT t1.XZQQC, decode(to_char(t1.XQKSR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQKSR, 'YYYY-MM-DD')) XQKSR, decode(to_char(t1.XQJZR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQJZR, 'YYYY-MM-DD')) XQJZR, t2.pmll*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '1'), t1.XQHLL*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '2'), to_char(t1.SHRQ, 'YYYY-MM-DD'), DECODE(t1.XZQZLDM, '01', '·¢ÐÐÈËÑ¡ÔñȨ', '02', 'Ͷ×ÊÈËÑ¡ÔñȨ', NULL) XZQLX, DECODE(t1.XZQZLDM, '01', 'Callable', '02', 'Puttable', NULL) EXZQLX FROM ADB_DJ_ZQXZQ t1, ADB_DJ_ZQ t2 WHERE t1.zqdm = t2.zqdm and t1.ZQDM = '046001'order by t1.XZQQC
068c4au9p98wv	SELECT GTTGZH FROM ADB_KHZH_GTTGZH ORDER BY GTTGZH
0a5ctztds9fys	INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "ADS"."V_GKSC_ACCR_QZFSZ_ASST" SELECT RQ, --ÈÕÆÚ SUM(M1) M1, --·â±ÕʽÄæ»Ø¹ºÀûÏ¢ÊÕÈë SUM(M2) M2, --Âò¶ÏʽÄæ»Ø¹ºÀûÏ¢ÊÕÈë SUM(M3) M3, --×Ô¶¯ÖÊѺÈÚ×ÊÀûÏ¢ÊÕÈë SUM(M4) M4, --ÈÚȯÀûÏ¢ÊÕÈë SUM(M5) M5, --ÑëÐгÖÓÐծȯÀûÏ¢ÊÕÈë SUM(M6) M6, --·â±ÕʽÕý»Ø¹ºÀûÏ¢Ö§³ö SUM(M7) M7, --Âò¶ÏʽÕý»Ø¹ºÀûÏ¢Ö§³ö SUM(M8) M8, --ÑëÐÐƱ¾ÝÀûÏ¢Ö§³ö SUM(M9) M9, --SLOͶ·ÅÀûÏ¢ÊÕÈë SUM(M10) M10 --SLO»ØÁýÀûÏ¢Ö§³ö FROM ( --»Ø¹ºÐÅÏ¢´¦Àí SELECT D.RQ RQ, (CASE WHEN A.ZTBYWZLDM = 'H2' THEN SUM(A.SJLX) ELSE 0 END) M1, (CASE WHEN A.ZTBYWZLDM = 'H4' THEN SUM(A.SJLX) ELSE 0 END) M2, 0 M3, 0 M4, 0 M5, (CASE WHEN A.ZTBYWZLDM = 'H1' THEN SUM(A.SJLX) ELSE 0 END) M6, (CASE WHEN A.ZTBYWZLDM = 'H3' THEN SUM(A.SJLX) ELSE 0 END) M7, 0 M8, (CASE WHEN A.ZTBYWZLDM = 'H6' THEN SUM(A.SJLX) ELSE 0 END) M9, (CASE WHEN A.ZTBYWZLDM = 'H5' THEN SUM(A.SJLX) ELSE 0 END) M10 FROM ADB_FX_TBHZ A, ADB_GG_RQ D WHERE D.RQ > A.DQJSJGR and A.SJLX>0 GROUP BY D.RQ, A.ZTBYWZLDM UNION ALL --ÑëÐгÖÓÐȯ´¦Àí SELECT D.RQ, 0 M1, 0 M2, 0 M3, 0 M4, SUM(C.DFLX) M5, 0 M6, 0 M7, 0 M8, 0 M9, 0 M10 FROM (SELECT A.CZRQ RQ, A.DFLX FROM ADB_SJ_ZHDFFXHZ A, ADB_DJ_ZQ B --Õý³£ÀûÏ¢ WHERE A.ZQDM = B.ZQDM AND B.FXRTGZH<>'F0001000000' AND A.ZQDM NOT IN ('4018', '4019', '9001', '9002', '9003') and A.DFLX>0 and A.ZHBH='Z0001000000' AND A.DFYCBZ IN ('0', '1') /*UNION ALL SELECT * FROM ADB_SJ_ZHDFFXHZ WHERE CASHIN_ACCR>0 --Ô¤²â*/ UNION ALL SELECT X.BQJXR RQ, A.DFLX FROM ADB_SJ_ZHDFFXHZ A, ADB_DJ_Z Q B, ADB_DJ_ZQJXQCXX X --Õý³£ÀûÏ¢ WHERE A.ZQDM = B.ZQDM AND A.ZQDM = X.ZQDM AND A.CZRQ <= X.BQJXR+15 AND A.CZRQ > X.BQQXR AND B.FXRTGZH <> 'F0001000000' AND A.ZQDM IN ('4018', '4019', '9002', '9003') AND A.DFLX>0 and A.ZHBH = 'Z0001000000' AND A.DFYCBZ IN ('0', '1') UNION ALL --Õý³£ÀûÏ¢ SELECT X.BQJXR, A.DFLX FROM ADB_SJ_ZHDFFXHZ A, ADB_DJ_ZQ B, ADB_DJ_ZQJXQCXX X WHERE A.ZQDM = B.ZQDM AND A.ZQDM = X.ZQDM AND A.CZRQ <= X.BQJXR+15 AND A.CZRQ > X.BQQXR AND B.FXRTGZH <> 'F0001000000' AND A.DFLX>0 AND A.CZRQ <= TO_DATE('20041201', 'YYYYMMDD') AND A.ZQDM = '9001' and A.ZHBH = 'Z0001000000' AND A.DFYCBZ IN ('0', '1') UNION ALL --Õý³£ÀûÏ¢ SELECT TO_DATE('20051201', 'YYYYMMDD'), A.DFLX FROM ADB_SJ_ZHDFFXHZ A WHERE A.CZRQ > TO_DATE('20041201', 'YYYYMMDD') and A.ZQDM = '9001' AND A.DFYCBZ IN ('0', '1') ) C, ADB_GG_RQ D WHERE D.RQ > C.RQ AND D.RQ <= TO_DATE('20501231', 'YYYYMMDD') GROUP BY D.RQ UNION ALL --ÑëÐÐƱ¾Ý´¦Àí SELECT D.RQ, 0 M1, 0 M2, 0 M3, 0 M4, 0 M5, 0 M6, 0 M7, SUM(C.DFLX) M8, 0 M9, 0 M10 FROM (SELECT A.CZRQ RQ, A.DFLX FROM ADB_SJ_ZHDFFXHZ A, ADB_DJ_ZQ B WHERE A.ZQDM = B.ZQDM AND A.DFLX>0 AND A.ZHBH<>'Z0001000000' AND B.FXRTGZH='F0001000000' AND A.DFYCBZ IN ('0', '1') ) C, ADB_GG_RQ D WHERE D.RQ > C.RQ AND D.RQ <= TO_DATE('20501231', 'YYYYMMDD') GROUP BY D.RQ ) GROUP BY RQ
0xwvqt6sfk6g4	SELECT t1.XZQQC, decode(to_char(t1.XQKSR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQKSR, 'YYYY-MM-DD')) XQKSR, decode(to_char(t1.XQJZR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQJZR, 'YYYY-MM-DD')) XQJZR, t2.pmll*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '1'), t1.XQHLL*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '2'), to_char(t1.SHRQ, 'YYYY-MM-DD'), DECODE(t1.XZQZLDM, '01', '·¢ÐÐÈËÑ¡ÔñȨ', '02', 'Ͷ×ÊÈËÑ¡ÔñȨ', NULL) XZQLX, DECODE(t1.XZQZLDM, '01', 'Callable', '02', 'Puttable', NULL) EXZQLX FROM ADB_DJ_ZQXZQ t1, ADB_DJ_ZQ t2 WHERE t1.zqdm = t2.zqdm and t1.ZQDM = '040217'order by t1.XZQQC
127jctf32srap	SELECT METAEXT_NAME, VENDOR_ID, DOMAIN_ID, DATA_TYPE, PERMISSIONS, PM_VALUE, LINE_NO, OBJECT_TYPE, OBJECT_ID, MAX_LENGTH, METAEXT_DESC, BIT_OPTIONS, COMP_VERSION FROM OPB_METAEXT_VAL WHERE SUBJECT_ID = :1 AND OBJECT_ID = :2 AND OBJECT_TYPE = :3 AND VERSION_NUMBER = :4 ORDER BY OBJECT_TYPE, OBJECT_ID, VENDOR_ID, DOMAIN_ID, METAEXT_NAME, LINE_NO ASC
13vm906uuj5ch	select t.userloginid, t.userpassword, t.email, t.name, t1.xb, t.phone, t1.dhhm2, t.company from xt_sys_user t, sso_user_info t1 where t.userloginid=t1.yhm and trim(t.userloginid) ='leichengyao'
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1f5xvxu4y34gw	INSERT INTO MDSYWTZ_TBL (RQ, ZHGTGZH, NHGTGZH, ZQDM, ZQME) SELECT TO_DATE(:B1 , 'YYYY-MM-DD') RQ, B.RRFTGZH, B.RCFTGZH, B.ZQDM, SUM(B.ZQME) FROM ( SELECT A1.RCFTGZH, A1.RRFTGZH, A1.ZQDM, A1.ZQME, A1.FSRQ FROM ADB_SJ_YWTZ A1 WHERE A1.YWLBDM = '331' AND A1.YWTZLBDM = '04' AND A1.WCBZ = '1' AND NOT EXISTS (SELECT T2.HTBH FROM ADB_SJ_HGYWCL T2 WHERE T2.YWLBDM = '331' AND T2.DQYWZTDM = '4' AND T2.DQJGRQ < TO_DATE(:B1 , 'YYYY-MM-DD') AND A1.HTBH = T2.HTBH) UNION ALL SELECT A1.RCFTGZH, A1.RRFTGZH, A1.ZQDM, 0 - A1.ZQME ZQME, TO_DATE(TO_CHAR(A1.SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') FSRQ FROM ADB_SJ_YWTZ A1, (SELECT A1.HTBH FROM ADB_SJ_YWTZ A1 WHERE A1.YWLBDM = '331' AND A1.YWTZLBDM = '04' AND A1.WCBZ = '1') A2 WHERE A1.YWLBDM = '331' AND A1.YWTZLBDM = '04' AND A1.WCBZ = '2' AND A1.HTBH = A2.HTBH AND NOT EXISTS (SELECT T2.HTBH FROM ADB_SJ_HGYWCL T2 WHERE T2.YWLBDM = '331' AND T2.DQYWZTDM = '4' AND T2.DQJGRQ < TO_DATE(:B1 , 'YYYY-MM-DD') AND A1.HTBH = T2.HTBH ))B WHERE B.FSRQ <= TO_DATE(:B1 , 'YYYY-MM-DD') GROUP BY TO_DATE(:B1 , 'YYYY-MM-DD'), B.RRFTGZH, B.RCFTGZH, B.ZQDM HAVING SUM(B.ZQME) > 0
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1qanz6dv2cz51	UPDATE OPB_CLIENT_CONN SET LOGIN_TIME = :1 WHERE CNX_ID = :2
216nrjw4auhcp	update datagate.TB_CLIENT_LOG set LOGIN_DATE=:1 , LOGIN_TIME=:2 , DATA_STREAM=:3 , LAST_DATE=:4 , LAST_TIME=:5 where SESSION_ID=:6 and USER_CODE=:7
2ksmus56bbgtg	DELETE FROM OPB_CLIENT_CONN WHERE CNX_ID = :1
2q7x5da3h3z0u	select distinct fn_hermite_yield(t.x1, t.x2, t.y1, t.y2, t.di1, t.di2, 2) from curve_formula t, par_curve_type t1, yc_bd_info t2 where t.x1 <= 2 and t.x2 >= 2 and t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.qxfl = '0' and t1.yc_def_id = '2c9081e50a2f9606010a306abdde0003' and t1.fbzt = 1 and t.work_time = (select max(t.work_time)-1 from curve_formula t, par_curve_type t1, yc_bd_info t2 where t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.fbzt = 1 and t1.qxfl = 0)
2q93zsrvbdw48	select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
34m3wwz9ua48r	SELECT SUBJ_NAME, SUBJ_ID, SUBJ_DESC, IS_SHARED, OWNER_ID, CREATION_TIME, FOLDER_ATTR, SUBJ_GID, CREATE_INFO, OBJVERSION, VERSION_STATUS, OS_USER FROM OPB_SUBJECT WHERE SUBJ_ID = :1
3ggfhkzsdagsk	select to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss') from dual
3hv8ubqjzfghu	SELECT NAME_SPACE, NAME, ID, STATUS, PRIVILEGES1, PRIVILEGES2, PRIVILEGES3, PRIVILEGES4, PRIVILEGES5 from OPB_USER_GROUP WHERE TYPE = 1 AND STATUS < :1 AND NAME = :2 AND NAME_SPACE = :3
3mp0znhgacysm	SELECT P.USER_ID, P.COMMENTS, P.SAVED_FROM, P.LAST_SAVED, P.OBJECT_NAME, P.GROUP_NAME, P.OBJECT_SUBTYPE, P.IS_SHORTCUT, P.UTC_LAST_SAVED, P.PURGED_BY_USERID, P.UTC_CHECKOUT, P.UTC_CHECKIN, S.SUBJ_NAME, U.NAME FROM OPB_VERSION_PROPS P , OPB_SUBJECT S, OPB_USER_GROUP U WHERE P.SUBJECT_ID = S.SUBJ_ID AND P.USER_ID = U.ID AND U.TYPE = 1 AND P.OBJECT_ID = :1 AND P.OBJECT_TYPE = :2 AND P.VERSION_NUMBER = :3 AND P.SUBJECT_ID = :4
3px3rcn1xg0ft	BEGIN SP_GKSC_M_VIEWS_REFRESH ; END;
3syzbdxytjm51	SELECT DBTYPE_ID, DATATYPE_NAME, NATIVE_DATATYPE, PM_DATATYPE, DEFAULT_PRECISION, DEFAULT_SCALE, PROP_FLAGS, PRINT_FLAGS, ORDER_NUM, OPB_OBJECT_ID FROM OPB_MMD_DATATYPE WHERE DBTYPE_ID > :1 ORDER BY DBTYPE_ID
3w4qs0tbpmxr6	select con#, obj#, rcon#, enabled, nvl(defer, 0), spare2, spare3 from cdef$ where robj#=:1
40h8waqz94jr4	INSERT INTO ADB_TMP_ZW_QZQGZ SELECT :B1 , ZQJ.ZQDM, CASE WHEN SOU.ZQDM IS NULL THEN '10' ELSE SOU.LTCSDM END LTCSDM, CASE WHEN SOU.ZQDM IS NULL THEN FN_CAL_BJFJG(ZQJ.ZQDM, TO_CHAR(:B1 , 'yyyymmdd')) ELSE SOU.GJQJ END GJQJ, CASE WHEN SOU.ZQDM IS NULL THEN FN_CAL_BJFJG(ZQJ.ZQDM, TO_CHAR(:B1 , 'yyyymmdd')) - FN_CAL_YJLX(ZQJ.ZQDM, TO_CHAR(:B1 , 'yyyymmdd')) ELSE SOU.GJJJ END GJJJ, CASE WHEN SOU.ZQDM IS NULL THEN '1' ELSE '2' END SZJSFF, SYSDATE BIGXSJ, SOU.GJSYL FROM (SELECT GZRQ, ZQDM, LTCSDM, GJQJ, GJJJ, GJSYL FROM ADB_XXFW_GZLSSJ WHERE KXD = 'ÍƼö' AND GZRQ >= TO_DATE('20060301', 'yyyymmdd') AND GZRQ = :B1 ) SOU, (SELECT T1.ZQDM FROM ADB_DJ_ZQ T1, ADB_DJ_ZQFXZJZC T2 WHERE T1.DQR > :B1 AND T1.QXR <= :B1 AND T1.ZQDM=T2.ZQDM AND T2.ZJZCCS=0 ) ZQJ WHERE SOU.ZQDM(+) = ZQJ.ZQDM
43ps4zzvt0su3	select distinct fn_hermite_yield(t.x1, t.x2, t.y1, t.y2, t.di1, t.di2, 10) from curve_formula t, par_curve_type t1, yc_bd_info t2 where t.x1 <= 10 and t.x2 >= 10 and t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.qxfl = '0' and t1.yc_def_id = '2c9081e50a2f9606010a3068cae70001' and t1.fbzt = 1 and t.work_time = (select max(t.work_time)-1 from curve_formula t, par_curve_type t1, yc_bd_info t2 where t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.fbzt = 1 and t1.qxfl = 0)
457h2b1gj9h4p	select distinct fn_hermite_yield(t.x1, t.x2, t.y1, t.y2, t.di1, t.di2, 7) from curve_formula t, par_curve_type t1, yc_bd_info t2 where t.x1 <= 7 and t.x2 >= 7 and t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.qxfl = '0' and t1.yc_def_id = '2c9081e50a2f9606010a3068cae70001' and t1.fbzt = 1 and t.work_time = (select max(t.work_time)-1 from curve_formula t, par_curve_type t1, yc_bd_info t2 where t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.fbzt = 1 and t1.qxfl = 0)
45v41vkwxkktp	select distinct fn_hermite_yield(t.x1, t.x2, t.y1, t.y2, t.di1, t.di2, 3) from curve_formula t, par_curve_type t1, yc_bd_info t2 where t.x1 <= 3 and t.x2 >= 3 and t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.qxfl = '0' and t1.yc_def_id = '2c9081e50a2f9606010a306abdde0003' and t1.fbzt = 1 and t.work_time = (select max(t.work_time)-1 from curve_formula t, par_curve_type t1, yc_bd_info t2 where t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.fbzt = 1 and t1.qxfl = 0)
484ujrubyhfc8	BEGIN SP_ADB_GSXJK_SJTB (:1, :2) ; END;
485mrqzxtvv4y	select distinct fn_hermite_yield(t.x1, t.x2, t.y1, t.y2, t.di1, t.di2, 7) from curve_formula t, par_curve_type t1, yc_bd_info t2 where t.x1 <= 7 and t.x2 >= 7 and t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.qxfl = '0' and t1.yc_def_id = '2c9081e50a2f9606010a306abdde0003' and t1.fbzt = 1 and t.work_time = (select max(t.work_time)-1 from curve_formula t, par_curve_type t1, yc_bd_info t2 where t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.fbzt = 1 and t1.qxfl = 0)
4jzw21gb4w5yk	SELECT REPOSITORY_ID, REPOSITORY_TYPE, DOMAIN_NAME, REPOSITORY_NAME, DB_USER, DB_PASSWD2, DB_ODBC_CONNECT, DB_NATIVE_CONNECT, DB_TYPE, HOSTNAME, PORTNUM, OBJVERSION, PCSF_DOMAIN FROM OPB_REPOSIT_INFO ORDER BY REPOSITORY_TYPE ASC
4r07kscxz39m0	SELECT DBTYPE_ID, KEY_NAME, SRCTGT_FLAGS, KEY_FLAGS, ORDER_NUM, OPB_OBJECT_ID FROM OPB_MMD_KEYTYPE WHERE DBTYPE_ID > :1 ORDER BY DBTYPE_ID
57sdckjq1q99v	SELECT REPOSIT_NAME, REPOSIT_GID FROM OPB_REPOSIT WHERE RECID = 1
5d0jrbzdgjq3t	select t2.ZWBBMC ZWBBMC, t2.YWBBMC YWBBMC, t1.BBBH BBBH , t2.BBLB , BBNY, FBSJ, FBZT from ADF_BB_TJYBCC t1, ADF_BB_TJYBZL t2 where t1.BBBH=t2.BBBH and t1.FBZT='1' and BBNY = '201405' and t1.WJLX = 1 order by t2.bblb, t1.BBBH
5g5fxpz8vzrvg	SELECT t1.XZQQC, decode(to_char(t1.XQKSR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQKSR, 'YYYY-MM-DD')) XQKSR, decode(to_char(t1.XQJZR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQJZR, 'YYYY-MM-DD')) XQJZR, t2.pmll*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '1'), t1.XQHLL*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '2'), to_char(t1.SHRQ, 'YYYY-MM-DD'), DECODE(t1.XZQZLDM, '01', '·¢ÐÐÈËÑ¡ÔñȨ', '02', 'Ͷ×ÊÈËÑ¡ÔñȨ', NULL) XZQLX, DECODE(t1.XZQZLDM, '01', 'Callable', '02', 'Puttable', NULL) EXZQLX FROM ADB_DJ_ZQXZQ t1, ADB_DJ_ZQ t2 WHERE t1.zqdm = t2.zqdm and t1.ZQDM = '040801'order by t1.XZQQC
5nw290whn4gsh	SELECT T2.LXFBFSDM, T2.FXPL, CASE WHEN TO_CHAR(T2.QXR, 'mmdd')='0229' THEN TO_DATE(SUBSTR(:B2 , 1, 4)||'0301', 'yyyymmdd')-1 ELSE TO_DATE(SUBSTR(:B2 , 1, 4)||TO_CHAR(T2.QXR, 'mmdd'), 'yyyymmdd') END FROM ADB_DJ_ZQ T2 WHERE TRIM(T2.ZQDM) = :B1
5wcxvqkvd7x56	SELECT distinct TBL$OR$IDX$PART$NUM("PAR_INDEX_SAMPLE_BOND", 0, 1, 0, "SCRQ") FROM (SELECT "C"."GZR" "SCRQ" FROM "INDEX_BUILD_INFO" "C" WHERE "C"."GZR"=TO_DATE(:B1, 'yyyymmdd') AND "C"."GZR"=TO_DATE(:B2, 'yyyymmdd') AND "C"."FHZT"='3') ORDER BY 1
5wqmxrppkr6qr	BEGIN :1 := FN_BOND_ZQGZJG(:2 , :3 , :4 ); END;
5z24t4p6j5pq0	SELECT REPOSITORY_NAME FROM OPB_REPOSIT_INFO
6055cmz8wt0xv	SELECT DBTYPE_ID, DBSUBTYPE_ID, OBJECT_TYPE, ATTR_ID, ATTR_INDEX, OPB_OBJECT_ID FROM OPB_MMD_DBTY2WAVAL WHERE DBTYPE_ID > :1 ORDER BY DBTYPE_ID, DBSUBTYPE_ID, OBJECT_TYPE, ATTR_ID, ATTR_INDEX
62hgv87gbfdtk	SELECT MAX(T1.RQ) FROM ADB_ZW_ZHTGYE T1 WHERE T1.ZQDM = :B1 AND T1.KMDM LIKE '03%' AND T1.KMDM <> '0300'
65n74bvx3vs46	SELECT OBJECT_TYPE, OBJECT_SUBTYPE, OS_TYPE, LIBRARY_NAME, LIB_TYPE FROM OPB_MMD_LIBS WHERE COMPONENT_ID = :1 AND COMPONENT_TYPE = 1
6bw3cda23zchx	select distinct fn_hermite_yield(t.x1, t.x2, t.y1, t.y2, t.di1, t.di2, 5) from curve_formula t, par_curve_type t1, yc_bd_info t2 where t.x1 <= 5 and t.x2 >= 5 and t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.qxfl = '0' and t1.yc_def_id = '2c9081e50a2f9606010a306abdde0003' and t1.fbzt = 1 and t.work_time = (select max(t.work_time)-1 from curve_formula t, par_curve_type t1, yc_bd_info t2 where t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.fbzt = 1 and t1.qxfl = 0)
6f5ydprjfznt2	BEGIN UTI_MARKET_HISTORY.UTI_MARKET_BUILD_DAY (:1, :2) ; END;
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6h4gxtck7bqjj	SELECT t.ZQDM, nvl(t.QQQJ, -999), nvl(t.QCQJ, -999), nvl(t.ZGQJ, -999), nvl(t.ZDQJ, -999), nvl(t.QMQJ, -999), nvl((CASE WHEN t.QQQJ IS NULL OR t.QQQJ =0 THEN NULL ELSE (t.BQPJ -t.QQQJ)/t.QQQJ END), -999) ZDF, nvl(t.BQPJ, -999), nvl(t.YJLX, -999), nvl(t.JJ, -999), nvl(t.BJE, -999), nvl(t.ZQJGL, -999), nvl(t.ZJQSE, -999), nvl(t.SYQX, -999), nvl(t.NSYL, -999), nvl(t.JSBS, -999), nvl(T.PJJSE , -999), T6.JXMS FUXFS, T1.ZQJC ZQJC, NVL(T4.SORTDM, '90') ZQXZSD, NVL(T5.SORTDM, '09') ZQFXRSD , NVL(T3.SORTDM, '03') FUXFSSD, T.XZQLX, T.XZQXSR, nvl(T.JSTS , -999) JSTS, T6.EJXMS, T.EXZQ, T7.ISIN from ( SELECT A1.KSRQ, A1.JZRQ, A1.ZQDM, A5.QQQJ, A2.QCQJ, A1.ZGQJ, A1.ZDQJ, A3.QMQJ, (A1.BQPJ -A5.QQQJ)/A5.QQQJ ZDF, A1.BQPJ, A3.YJLX, A1.JJ , A1.ZQJGL, A1.ZJQSE, A3.SYQX, A1.NSYL, A1.JSBS, A1.PJJSE , A1.BJE, DECODE(A4.XZQZLDM, '01', '·¢ÐÐÈËÑ¡ÔñȨ', '02', 'Ͷ×ÊÈËÑ¡ÔñȨ', NULL) XZQLX, TO_CHAR(A4.SHRQ, 'YYYY-MM-DD') XZQXSR, A1.JSTS, DECODE(A4.XZQZLDM, '01', 'Callable', '02', 'Putable', NULL) EXZQ FROM ( SELECT TO_DATE('19970529', 'YYYYMMDD') KSRQ, TO_DATE('20140530', 'YYYYMMDD') JZRQ, T1.ZQDM ZQDM, SUM(T1.BJE) BJE, SUM(T1.ZQJGL) ZQJGL, SUM(T1.ZJQSE) ZJQSE, MAX(T1.ZGQJ) ZGQJ, MIN(T1.ZDQJ) ZDQJ, SUM(T1.BQPJ * T1.ZQJGL)/SUM(T1.ZQJGL) BQPJ, SUM(T1.JJ * T1.ZQJGL)/SUM(T1.ZQJGL) JJ, SUM(T1.ZQJGL* T1.NSYL) / SUM(ZQJGL) NSYL, sum(t1.JSBS) JSBS, SUM(T1.ZQJGL)/sum(t1.jsbs) PJJSE, COUNT(*) JSTS FROM XHQJ_DAY_TBL T1 WHERE T1.RQ >= TO_DATE('199 70529', 'YYY YMMDD') AND T1.RQ <= TO_DATE('20140530', 'YYYYMMDD') AND T1.ZQDM <>'S00000' GROUP BY T1.ZQDM )A1, ( SELECT T1.ZQDM ZQDM, T1.QCQJ FROM ( SELECT T1.ZQDM ZQDM, MIN(T1.RQ) RQ FROM XHQJ_DAY_TBL T1 WHERE T1.RQ >= TO_DATE('19970529', 'YYYYMMDD') AND T1.RQ <= TO_DATE('20140530', 'YYYYMMDD') GROUP BY T1.ZQDM )TT1, XHQJ_DAY_TBL T1 WHERE T1.RQ = TT1.RQ AND T1.ZQDM = TT1.ZQDM AND T1.ZQDM <>'S00000' )A2, ( SELECT T1.ZQDM ZQDM, T1.QMQJ, T1.YJLX, T1.SYQX FROM ( SELECT T1.ZQDM ZQDM, MAX(T1.RQ) RQ FROM XHQJ_DAY_TBL T1 WHERE T1.RQ >= TO_DATE('19970529', 'YYYYMMDD') AND T1.RQ <= TO_DATE('20140530', 'YYYYMMDD') GROUP BY T1.ZQDM )TT1, XHQJ_DAY_TBL T1 WHERE T1.RQ = TT1.RQ AND T1.ZQDM = TT1.ZQDM AND T1.ZQDM <>'S00000' )A3, (SELECT t1.zqdm, SHRQ, XZQZLDM FROM ADB_DJ_ZQXZQ t1, (SELECT t.zqdm, MAX(t.XZQQC) XZQQC FROM ADB_DJ_ZQXZQ t GROUP BY t.zqdm HAVING MAX(t.SHRQ) < trunc(SYSDATE) Union SELECT t.zqdm, MIN(t.XZQQC) XZQQC FROM ADB_DJ_ZQXZQ t WHERE t.SHRQ >= trunc(SYSDATE) GROUP BY t.zqdm) b WHERE t1.zqdm = b.zqdm AND t1.XZQQC = b.XZQQC) A4, ( SELECT T1.ZQDM ZQDM, SUM(T1.BQPJ * T1.ZQJGL)/SUM(T1.ZQJGL) QQQJ FROM ( SELECT T2.ZQDM, MAX(T2.RQ) RQ FROM XHQJ_DAY_TBL T2 WHERE T2.RQ < TO_DATE('19970529', 'YYYYMMDD') GROUP BY T2.ZQDM )TT1, XHQJ_DAY_TBL T1 WHERE T1.RQ = TT1.RQ AND T1.ZQDM = TT1.ZQDM AND T1.ZQDM <>'S00000' GROUP BY T1.ZQDM ) A5 WHERE A1.ZQDM(+) = A2.ZQDM and A3.ZQDM(+) = A2.ZQDM and A4.ZQDM(+) = A 2.ZQDM and A5.ZQDM(+) = A3.ZQDM ) t , (select G1.* from (select z1.ZQJC, z1.zqdm, z1.JXFSDM, z1.ZQXZDM, z2.ZQFXRDM from ADB_DJ_ZQ z1 , ADB_DJ_ZQFZXX z2 where z1.zqdm=z2.zqdm ) G1, (select ZQDM from BJ_PBZQ where HQBZ = 'Y' and GXSJ< to_Date('19970529', 'yyyymmdd')) G2 WHERE G1.ZQDM = G2.ZQDM(+) AND G2.ZQDM IS NULL) T1 , SORT_JXFS_TBL T3, SORT_ZQXZ_TBL T4, SORT_ZQFXR_TBL T5 , BJ_ZQJX T6, T_ISIN T7 WHERE T.ZQDM=T1.ZQDM AND T.ZQDM = T7.ZQDM(+) AND T1.JXFSDM = T3.DM(+) AND T1.ZQXZDM=T4.DM(+) AND T1.ZQFXRDM=trim(T5.DM(+)) AND T1.JXFSDM = T6.JXFSBH(+) and t1.JXFSDM='31' and t.zqdm in (select zqdm from ADB_DJ_ZQ where ZQXZDM in (select dm from sort_zqxz_tbl where sortdm='06') ) ORDER BY ZQXZSD, ZQFXRSD, FUXFSSD, T.SYQX , T.ZQDM
6ra87g4ufvgpj	select distinct fn_hermite_yield(t.x1, t.x2, t.y1, t.y2, t.di1, t.di2, 5) from curve_formula t, par_curve_type t1, yc_bd_info t2 where t.x1 <= 5 and t.x2 >= 5 and t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.qxfl = '0' and t1.yc_def_id = '2c9081e50a2f9606010a3068cae70001' and t1.fbzt = 1 and t.work_time = (select max(t.work_time)-1 from curve_formula t, par_curve_type t1, yc_bd_info t2 where t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.fbzt = 1 and t1.qxfl = 0)
6sqdp7673k5x3	UPDATE wri$_adv_addm_tasks SET actual_analysis = :aa, database_time = :dbt, active_sessions = round(:dbt / (1000000 * :sint), 2), perc_flush_time = round(:ft / :sint, 2), perc_mw_time = round(:mw / :sint, 2) WHERE task_id = :tid
6ss9jsrba6g2z	SELECT METAEXT_NAME, DATA_TYPE, MAX_LENGTH, OBJECT_TYPE, DBTYPE, SUBTYPE, PERMISSIONS, DEFAULT_VALUE, METAEXT_DESC, METAEXT_PROP, OPB_OBJECT_ID, OBJVERSION, LINE_NO FROM OPB_MMD_METAEXT WHERE VENDOR_ID = :1 AND DOMAIN_ID = :2 ORDER BY OBJECT_TYPE, DBTYPE, METAEXT_NAME, LINE_NO ASC
6xvp6nxs4a9n4	select nvl(sum(space), 0) from recyclebin$ where ts# = :1
6ywy9pp4ch683	select t.userloginid, t.userpassword, t.email, t.name, t1.xb, t.phone, t1.dhhm2, t.company from xt_sys_user t, sso_user_info t1 where t.userloginid=t1.yhm and trim(t.userloginid) ='efundshk'
755dttk22c9vc	update sso_user_info set DXBZ ='2' where trim(yhm)='guihaiyang'
7jfvtx5a4svff	UPDATE OPB_TASK_INST_RUN SET END_TIME=:1, RUN_STATUS_CODE=:2, RUN_ERR_CODE =:3, RUN_ERR_MSG = :4, SERVER_NODE_NAME = :5 WHERE WORKFLOW_ID = :6 AND WORKFLOW_RUN_ID = :7 AND WORKLET_RUN_ID = :8 AND INSTANCE_ID = :9 AND FRAGMENT_ID = -1
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
8kd7q720h6dhv	INSERT INTO OPB_CLIENT_CONN (CNX_ID, LOGIN_ID, CLIENT_TYPE, APP_NAME1, APP_NAME2, HOST_NAME, HOST_ADDR, HOST_PORT, PROCESS_ID, CNX_RESIL) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)
8kfsr67hxgrn2	select t.userloginid, t.userpassword, t.email, t.name, t1.xb, t.phone, t1.dhhm2, t.company from xt_sys_user t, sso_user_info t1 where t.userloginid=t1.yhm and trim(t.userloginid) ='yxssh01'
8ks2u43c1hg5s	SELECT DBTYPE_ID, IS_PLG, DBTYPE_NAME, BASE_ID, SRCTGT_FLAGS, H_FLAGS, E_FLAGS, I_FLAGS, DEFAULT_DBSUBTYPE, FIELD_SEPARATOR, NULL_STRING, NOTNULL_STRING, DSQ_TYPE, INVALID_CHARS, INVALID_FCHARS, OPB_OBJECT_ID FROM OPB_MMD_DBTYPE WHERE DBTYPE_ID > :1 ORDER BY DBTYPE_ID
8n14w3n9rtkuf	SELECT OBJECT_TYPE, OBJECT_SUBTYPE, OS_TYPE, LIBRARY_NAME, OPB_OBJECT_ID, LIB_TYPE, COMPONENT_ID FROM OPB_MMD_LIBS WHERE COMPONENT_TYPE = :1 AND COMPONENT_ID > :2 ORDER BY COMPONENT_ID
8q4b6fjut4rpx	select to_char(max(t.end_time), 'yyyy-MM-dd hh24:mi:ss') etime, to_char(min(t.end_time), 'yyyy-MM-dd hh24:mi:ss') btime from etl_log_detail_cdctj t, (select max(etl_date) etl_max_date from etl_log_detail_cdctj where RUN_S_DATE = to_date('2014-05-01', 'yyyy-mm-dd')) t2 where proc_name in ('sp_ywzl01', 'sp_ywzl02', 'sp_fxdf', 'sp_fscfx', 'sp_zqzqqx', 'sp_zyzqrg', 'sp_zqdf', 'sp_zqtg', 'sp_tgqx', 'sp_fsctg', 'sp_ksctg', 'sp_zyzqtg', 'sp_zqtgz', 'sp_tzzsl', 'sp_yhxqjy_qz', 'sp_yhxqjy_tzz', 'sp_gtxqjy_qz', 'sp_yhzyjy_qz', 'sp_yhzyjy_tzz', 'sp_yhzyhg', 'sp_yhmdjy_qz', 'sp_yhmdjy_tzz', 'sp_yhmdh') and RUN_S_DATE = to_date('2014-05-01', 'yyyy-mm-dd') and etl_date = t2.etl_max_date
8sfvn15qnchmw	SELECT t1.XZQQC, decode(to_char(t1.XQKSR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQKSR, 'YYYY-MM-DD')) XQKSR, decode(to_char(t1.XQJZR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQJZR, 'YYYY-MM-DD')) XQJZR, t2.pmll*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '1'), t1.XQHLL*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '2'), to_char(t1.SHRQ, 'YYYY-MM-DD'), DECODE(t1.XZQZLDM, '01', '·¢ÐÐÈËÑ¡ÔñȨ', '02', 'Ͷ×ÊÈËÑ¡ÔñȨ', NULL) XZQLX, DECODE(t1.XZQZLDM, '01', 'Callable', '02', 'Puttable', NULL) EXZQLX FROM ADB_DJ_ZQXZQ t1, ADB_DJ_ZQ t2 WHERE t1.zqdm = t2.zqdm and t1.ZQDM = '040701'order by t1.XZQQC
8szc9vuqfx5qp	BEGIN :rv := F_GETZZGZ (:1, :2) ; END;
8uqgz38ysbtrt	DELETE FROM OPB_SERVICED_REQ WHERE CNX_ID = :1
8zsjj8d0p5zhb	SELECT DBTYPE_ID, DBSUBTYPE_ID, DBSUBTYPE_NAME, SRCTGT_FLAGS, H_FLAGS, E_FLAGS, I_FLAGS, OPB_OBJECT_ID FROM OPB_MMD_DBSUBTYPE WHERE DBTYPE_ID > :1 ORDER BY DBTYPE_ID, DBSUBTYPE_ID
9029qv60w2f70	SELECT t1.XZQQC, decode(to_char(t1.XQKSR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQKSR, 'YYYY-MM-DD')) XQKSR, decode(to_char(t1.XQJZR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQJZR, 'YYYY-MM-DD')) XQJZR, t2.pmll*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '1'), t1.XQHLL*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '2'), to_char(t1.SHRQ, 'YYYY-MM-DD'), DECODE(t1.XZQZLDM, '01', '·¢ÐÐÈËÑ¡ÔñȨ', '02', 'Ͷ×ÊÈËÑ¡ÔñȨ', NULL) XZQLX, DECODE(t1.XZQZLDM, '01', 'Callable', '02', 'Puttable', NULL) EXZQLX FROM ADB_DJ_ZQXZQ t1, ADB_DJ_ZQ t2 WHERE t1.zqdm = t2.zqdm and t1.ZQDM = '040802'order by t1.XZQQC
90mcq66xcbj3k	DELETE FROM OPB_PROXYUSER_INFO WHERE CNX_ID = :1
9c7jpvndky794	DELETE FROM OPB_REQ_REPLY WHERE CNX_ID = :1
9cjwansqqr73b	select t.userloginid, t.userpassword, t.email, t.name, t1.xb, t.phone, t1.dhhm2, t.company from xt_sys_user t, sso_user_info t1 where t.userloginid=t1.yhm and trim(t.userloginid) ='zhaominhao'
9mx3suj8ks9q4	SELECT ATTR_ID, ATTR_VALUE, LINE_NO, SESS_WIDG_INST_ID, PROC_INSTANCE_ID, PARTITION_ID, OBJECT_TYPE, OBJECT_SUBTYPE, COMP_VERSION FROM OPB_EXTN_ATTR WHERE SESSION_ID = :1 AND SESSION_INST_ID = :2 AND WORKFLOW_ID = :3 AND VERSION_NUMBER = :4 ORDER BY SESS_WIDG_INST_ID, PROC_INSTANCE_ID, PARTITION_ID, ATTR_ID, LINE_NO ASC
9tgj4g8y4rwy8	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
9y69yzsh6rjuy	select distinct fn_hermite_yield(t.x1, t.x2, t.y1, t.y2, t.di1, t.di2, 10) from curve_formula t, par_curve_type t1, yc_bd_info t2 where t.x1 <= 10 and t.x2 >= 10 and t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.qxfl = '0' and t1.yc_def_id = '2c9081e50a2f9606010a306abdde0003' and t1.fbzt = 1 and t.work_time = (select max(t.work_time)-1 from curve_formula t, par_curve_type t1, yc_bd_info t2 where t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.fbzt = 1 and t1.qxfl = 0)
a4gyt79jqj1vn	SELECT DBTYPE_ID, DBSUBTYPE_ID, OBJECT_TYPE, ATTR_ID, BIT_FLAGS, OPB_OBJECT_ID FROM OPB_MMD_DBTY2WATTR WHERE DBTYPE_ID > :1 ORDER BY DBTYPE_ID, DBSUBTYPE_ID, OBJECT_TYPE, ATTR_ID
amkvwkda3kb4p	SELECT ZQXZDM FROM V_ADB_DJ_ZQ A WHERE TRIM(A.ZQDM) = TRIM(:B1 )
axc57yqzh7q30	SELECT t1.XZQQC, decode(to_char(t1.XQKSR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQKSR, 'YYYY-MM-DD')) XQKSR, decode(to_char(t1.XQJZR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQJZR, 'YYYY-MM-DD')) XQJZR, t2.pmll*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '1'), t1.XQHLL*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '2'), to_char(t1.SHRQ, 'YYYY-MM-DD'), DECODE(t1.XZQZLDM, '01', '·¢ÐÐÈËÑ¡ÔñȨ', '02', 'Ͷ×ÊÈËÑ¡ÔñȨ', NULL) XZQLX, DECODE(t1.XZQZLDM, '01', 'Callable', '02', 'Puttable', NULL) EXZQLX FROM ADB_DJ_ZQXZQ t1, ADB_DJ_ZQ t2 WHERE t1.zqdm = t2.zqdm and t1.ZQDM = '050801'order by t1.XZQQC
b8mqq573kv11j	SELECT t1.ZQJC, t.ZQDM, T5.JXMS, nvl(t.QQJJ, -999), nvl(t.YJLX, -999), nvl(t.QCJG, -999), nvl(t.ZGJG, -999), nvl(t.ZDJG, -999), nvl(t.QMJG, -999), nvl(t.BQJG, -999), nvl(t.ZQJGL/10000, -999), nvl(t.ZJQSE/10000, -999), nvl(t.SYQX, -999), nvl(t.NSYL*100, -999), nvl(t.JSBS, -999), nvl(T.MBJSE/10000 , -999), nvl(T.BJE/10000 , -999), nvl(T3.SORTDM, '90') ZQXZSD, NVL(T4.SORTDM, '09') ZQFXRSD , NVL(T2.SORTDM, '03') FUXFSSD, T5.EJXMS, t6.xzqlx, t6.xzqxsr, t6.exzq, T7.ISIN, nvl(t.jsbs - t8.jsbs, -999) jsbsbz, t14.KHJC FROM XHJSHQ_TBL T, (select z1.ZQJC, z1.zqdm, z1.JXFSDM, z1.ZQXZDM, z2.ZQFXRDM, z1.FXRTGZH from ADB_DJ_ZQ z1 , ADB_DJ_ZQFZXX z2 where z1.zqdm=z2.zqdm) T1 , SORT_JXFS_TBL T2, SORT_ZQXZ_TBL T3, SORT_ZQFXR_TBL T4 , BJ_ZQJX T5, ADB_KHZH_YJTGZH t13, ADB_KHZH_KH t14, (SELECT t1.zqdm, DECODE(t1.XZQZLDM, '01', '·¢ÐÐÈËÑ¡ÔñȨ', '02', 'Ͷ×ÊÈËÑ¡ÔñȨ', NULL) XZQLX, to_char(t1.SHRQ, 'yyyy-mm-dd') XZQXSR, DECODE(t1.XZQZLDM, '01', 'Callable', '02', 'Putable', NULL) EXZQ FROM ADB_DJ_ZQXZQ t1, (SELECT t.zqdm, MAX(t.XZQQC) XZQQC FROM ADB_DJ_ZQXZQ t GROUP BY t.zqdm HAVING MAX(t.SHRQ) < trunc(SYSDATE) Union SELECT t.zqdm, MIN(t.XZQQC) XZQQC FROM ADB_DJ_ZQXZQ t WHERE t.SHRQ >= trunc(SYSDATE) GROUP BY t.zqdm) b WHERE t1.zqdm = b.zqdm AND t1.XZQQC = b.XZQQC) T6, T_ISIN T7, XHJSHQ_tbl_TEMP T8 where T.ZQDM = T1.ZQDM(+) AND T.ZQDM = T7.ZQDM(+) AND T1.JXFSDM = T2.DM(+) AND T1.ZQXZDM=T3.DM(+) AND T1.ZQFXRDM=trim(T4.DM(+)) AND T1.JXFSDM = T5.JX FSBH(+) and t.zqdm=t6.zqdm(+) AND t.zqdm = t8.zqdm(+) and t13.ZHBH = t1.FXRTGZH and t14.khbh = t13.khbh ORDER by ZQXZSD, ZQFXRSD, FUXFSSD, t.zqdm desc , t.zqjc asc , t5.jxms asc , T.ZQJGL asc , T.ZJQSE asc , T.SYQX asc , T.JSBS asc , T.MBJSE asc
ba7ydy9w2qw6j	SELECT COMP_ID, COMP_TYPE, COMP_VERSION, IS_OWNER, VENDOR_ID, PLG_ID, OPB_OBJECT_ID FROM OPB_MMD_PLGCOMP WHERE IS_REGISTERED = 1 ORDER BY COMP_TYPE, COMP_ID
bfq0nfmk4srxm	select distinct fn_hermite_yield(t.x1, t.x2, t.y1, t.y2, t.di1, t.di2, 1) from curve_formula t, par_curve_type t1, yc_bd_info t2 where t.x1 <= 1 and t.x2 >= 1 and t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.qxfl = '0' and t1.yc_def_id = '2c9081e50a2f9606010a306abdde0003' and t1.fbzt = 1 and t.work_time = (select max(t.work_time)-1 from curve_formula t, par_curve_type t1, yc_bd_info t2 where t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.fbzt = 1 and t1.qxfl = 0)
bv2fvzga6s460	SELECT DISTINCT TRIM(ZQDM), JXFSDM FROM ADB_DJ_ZQ WHERE TRIM(ZQDM) = TRIM(:B1 )
c94jrw43xpabq	SELECT ROLE_NAME from OPB_ROLE WHERE ID = :1 AND TYPE = :2
cfnpcm9s12c51	select t.userloginid, t.userpassword, t.email, t.name, t1.xb, t.phone, t1.dhhm2, t.company from xt_sys_user t, sso_user_info t1 where t.userloginid=t1.yhm and trim(t.userloginid) ='yinhuijuan'
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
crxwzb62uga8d	SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, PRIORITY FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = :1 AND NEXT_FIRE_TIME < :2 AND (NEXT_FIRE_TIME >= :3 ) ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC
csnp95dz2r8ss	select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
ctuqztupykvch	SELECT t1.XZQQC, decode(to_char(t1.XQKSR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQKSR, 'YYYY-MM-DD')) XQKSR, decode(to_char(t1.XQJZR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQJZR, 'YYYY-MM-DD')) XQJZR, t2.pmll*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '1'), t1.XQHLL*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '2'), to_char(t1.SHRQ, 'YYYY-MM-DD'), DECODE(t1.XZQZLDM, '01', '·¢ÐÐÈËÑ¡ÔñȨ', '02', 'Ͷ×ÊÈËÑ¡ÔñȨ', NULL) XZQLX, DECODE(t1.XZQZLDM, '01', 'Callable', '02', 'Puttable', NULL) EXZQLX FROM ADB_DJ_ZQXZQ t1, ADB_DJ_ZQ t2 WHERE t1.zqdm = t2.zqdm and t1.ZQDM = '040702'order by t1.XZQQC
cw2xm0fdtnfsp	select t.tjny, 'ÒøÐмäÊг¡' as xmmc, sum(sl) as sl , 1 orderNum from rep_tzzsl t where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t.xmbh2 = '1450' and t.lbbh not in ('1002', '1003', '1024') and t.xmbh1 = '1401' and t.xmbh3 = '1481' group by tjny union all select t.tjny, '¹ñ̨' as xmmc, sum(sl) as sl , 2 orderNum from rep_tzzsl t where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t.xmbh2 = '1455' and t.lbbh not in ('1002', '1003', '1024') and t.xmbh1 = '1401' and t.xmbh3 = '1482' group by tjny union all select a.tjny, a.xmmc, a.sl / 100000000 as sl , 3 orderNum from (select t1.sl, t1.tjny, t2.xmmc from rep_ywzl01 t1, rep_dim_xmzl t2 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0151' and t1.xmbh3 = '0161' and t1.xmbh1 = t2.xmbh and t1.xmbh1 = '0107') a union all select a.tjny, 'ÏÖȯ½»¸îÁ¿' as xmmc, a.sl / 100000000 as sl , 4 orderNum from (select sum(t1.sl) as sl, t1.tjny from rep_ywzl01 t1 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0151' and t1.xmbh3 = '0161' and t1.xmbh1 in ('0109', '0110') group by xmbh2, tjny) a union all select a.tjny, a.xmmc, a.sl / 100000000 as sl , 5 orderNum from (select t1.sl, t1.tjny, t2.xmmc from rep_ywzl01 t1, rep_dim_xmzl t2 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0151' and t1.xmbh3 = '0161' and t1.xmbh1 = t2.xmbh and t1.xmbh1 = '0109') a union all select a.tjny, a.xmmc, a.sl / 100000000 as sl , 6 orderNum from (select t1.sl, t1.tjny, t2.xmmc from rep_ywzl01 t1, rep_dim_xmzl t2 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0151' and t1.xmbh3 = '0161' and t1.xmbh1 = t2.xmbh and t1.xmbh1 = '0110') a union all select a.tjny, '»Ø¹º½»¸îÁ¿' as xmmc, a.sl / 100000000 as sl , 7 orderNum from (select sum(t1.sl) as sl, t1.tjny from rep_ywzl01 t1 where tjny = (select max(BBNY) from ADF_BB_TJYBCC w here FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0151' and t1.xmbh3 = '0161' and t1.xmbh1 in ('0104', '0105') group by xmbh2, tjny) a union all select a.tjny, a.xmmc, a.sl / 100000000 as sl , 8 orderNum from (select t1.sl, t1.tjny, t2.xmmc from rep_ywzl01 t1, rep_dim_xmzl t2 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0151' and t1.xmbh3 = '0161' and t1.xmbh1 = t2.xmbh and t1.xmbh1 = '0104') a union all select a.tjny, a.xmmc, a.sl / 100000000 as sl , 9 orderNum from (select t1.sl, t1.tjny, t2.xmmc from rep_ywzl01 t1, rep_dim_xmzl t2 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0151' and t1.xmbh3 = '0161' and t1.xmbh1 = t2.xmbh and t1.xmbh1 = '0105') a union all select a.tjny, 'Ô¶Æڳɽ»Á¿' as xmmc, a.sl / 100000000 as sl , 10 orderNum from (select sum(t1.sl) as sl, t1.tjny from rep_ywzl01 t1 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0151' and t1.xmbh3 = '0161' and t1.xmbh1 = '0112' group by xmbh2, tjny) a union all select a.tjny, 'ծȯ¶Ò¸¶Á¿' as xmmc, a.sl / 100000000 as sl , 11 orderNum from (select sum(t1.sl) as sl, t1.tjny from rep_ywzl01 t1 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0151' and t1.xmbh3 = '0161' and t1.xmbh1 = '0106' group by xmbh2, tjny) a union all select a.tjny, 'ÍйÜÃæ¶î' as xmmc, a.sl / 100000000 as sl , 12 orderNum from (select sum(t1.sl) as sl, t1.tjny from rep_ywzl02 t1 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0251' and t1.xmbh1 = '0201' group by xmbh2, tjny) a union all select a.tjny, 'ÍйÜÊÐÖµ' as xmmc, a.sl / 100000000 as sl , 13 orderNum from (select sum(t1.sl) as sl, t1.tjny from rep_ywzl02 t1 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0251' and t1.xmbh1 = '0209' group by xmbh2, tjny) a union all select a.tjny, 'ÍйÜծȯ' as xmmc, a.sl / 100000000 as sl , 14 orderNum from (select sum(t1.sl) as sl, t1.tjny from rep_ywzl02 t1 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0251' and t1.xmbh1 = '0205' group by xmbh2, tjny) a order by orderNum
cz1a1tjq1zuhc	SELECT DBTYPE_ID, DBSUBTYPE_ID, ATTR_ID, ATTR_NAME, ATTR_DESC, SRCTGT_FLAGS, IS_INT, PROP_FLAGS, OPB_OBJECT_ID FROM OPB_MMD_FLDATTR WHERE DBTYPE_ID > :1 ORDER BY DBTYPE_ID, DBSUBTYPE_ID
d9wgry2fvys8r	SELECT t1.XZQQC, decode(to_char(t1.XQKSR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQKSR, 'YYYY-MM-DD')) XQKSR, decode(to_char(t1.XQJZR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQJZR, 'YYYY-MM-DD')) XQJZR, t2.pmll*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '1'), t1.XQHLL*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '2'), to_char(t1.SHRQ, 'YYYY-MM-DD'), DECODE(t1.XZQZLDM, '01', '·¢ÐÐÈËÑ¡ÔñȨ', '02', 'Ͷ×ÊÈËÑ¡ÔñȨ', NULL) XZQLX, DECODE(t1.XZQZLDM, '01', 'Callable', '02', 'Puttable', NULL) EXZQLX FROM ADB_DJ_ZQXZQ t1, ADB_DJ_ZQ t2 WHERE t1.zqdm = t2.zqdm and t1.ZQDM = '061401'order by t1.XZQQC
dgrzguc2y5sh9	select '1' as rep_id, WORKFLOW_RUN_ID, '002' as MOD_KIND_ID, task_id as SESSION_ID, task_name as SESSION_NAME, instance_id, start_time as starttime, null as endtime, null as costtime, RUN_STATUS_CODE as run_state, 0 as success_num, 0 as fail_num, 0 as throw_num, 0 as RUN_EFFICIENCY, run_err_msg as err_msg, '' as log_file from rep_task_inst_run where task_type = 68 and RUN_STATUS_CODE=6 union SELECT '1' as rep_id, a.WORKFLOW_RUN_ID, '002' as MOD_KIND_ID, a.SESSION_ID, a.SESSION_NAME, a.instance_id, a.ACTUAL_START starttime, a.SESSION_TIMESTAMP endtime, (a.SESSION_TIMESTAMP-a.ACTUAL_START)*24*60*60 as costtime , decode(a.RUN_STATUS_CODE, 1, decode(b.rejected_rows, 0, 1, 99), a.RUN_STATUS_CODE) run_state, a.SUCCESSFUL_ROWS as success_num, a.FAILED_ROWS as fail_num, nvl(b.rejected_rows, 0) as throw_num, case when ((a.SESSION_TIMESTAMP - a.ACTUAL_START) * 24 * 60 * 60) = 0 then a.SUCCESSFUL_ROWS / 1 when ((a.SESSION_TIMESTAMP - a.ACTUAL_START) * 24 * 60 * 60) <> 0 then a.SUCCESSFUL_ROWS /((a.SESSION_TIMESTAMP - a.ACTUAL_START) * 24 * 60 * 60) end as RUN_EFFICIENCY, a.FIRST_ERROR_MSG||a.LAST_ERROR as err_msg, a.SESSION_LOG_FILE as log_file FROM REP_SESS_LOG a, (select sum(rejected_rows) as rejected_rows, session_id, WORKFLOW_RUN_ID from opb_swidginst_log where widget_type in (2, 3) group by session_id, WORKFLOW_RUN_ID) b where a.session_id=b.session_id(+) and a.WORKFLOW_RUN_ID=b.WORKFLOW_RUN_ID(+) and a.SESSION_TIMESTAMP >= :1
dhkhyn9vhj06g	select max(t.work_time) from curve_formula t, par_curve_type t1, yc_bd_info t2 where t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.fbzt = 1 and t1.qxfl = 0
dm6ud96z24ryg	select distinct fn_hermite_yield(t.x1, t.x2, t.y1, t.y2, t.di1, t.di2, 3) from curve_formula t, par_curve_type t1, yc_bd_info t2 where t.x1 <= 3 and t.x2 >= 3 and t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.qxfl = '0' and t1.yc_def_id = '2c9081e50a2f9606010a3068cae70001' and t1.fbzt = 1 and t.work_time = (select max(t.work_time)-1 from curve_formula t, par_curve_type t1, yc_bd_info t2 where t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.fbzt = 1 and t1.qxfl = 0)
ds58k4hks1fbx	SELECT :B3 RQ, B.INDEX_DEF_ID YBZID, PAR.ZSMC YBZMC, G.BZDM DCQID, G.SJZDLXMS DCQMC, A.ZQDM LTCSZQDM, A.ZQMC LTCSZQJC, E.STDCODE CSBH, E.VALUEDESC CSJC, A.CYJJ + A.YJLX QJ, A.CYJJ JJ, A.YJLX, A.DQJGZDF ZDF, A.DCQ, A.GZSYL DQSYL, A.DCSYL DC, A.XZJQ, A.LLJQ, A.LCJQ, A.TX, A.LLTX, A.LCTX, A.JDJZ, A.TGL KLTCL, 0, ROUND(B.INDEX_SZQZ*100, 6) ZSSZQZ, A.SZQZ FROM ( SELECT * FROM (SELECT T.*, COUNT(*) OVER(PARTITION BY ZQDM, CSBH) CNT FROM (SELECT DISTINCT GZR, E.ZQDM, ZQMC, E.CSBH, CYJJ, YJLX, DQJGZDF, DCQ, GZSYL, DCSYL, XZJQ, LLJQ, LCJQ, TX, LLTX, LCTX, JDJZ, TGL, SZQZ, CYBS FROM INDEX_SAMPLEBOND_PRICE E WHERE GZR = TO_DATE(:B2 , 'yyyymmdd') ) T WHERE GZR = TO_DATE(:B2 , 'yyyymmdd')) WHERE CNT > 1 AND CYBS = '1' UNION ALL SELECT * FROM (SELECT T.* , COUNT(*) OVER(PARTITION BY ZQDM, CSBH) CNT FROM (SELECT DISTINCT GZR, E.ZQDM, ZQMC, E.CSBH, CYJJ, YJLX, DQJGZDF, DCQ, GZSYL, DCSYL, XZJQ, LLJQ, LCJQ, TX, LLTX, LCTX, JDJZ, TGL, SZQZ, CYBS FROM INDEX_SAMPLEBOND_PRICE E WHERE GZR = TO_DATE(:B2 , 'yyyymmdd') ) T WHERE GZR = TO_DATE(:B2 , 'yyyymmdd')) WHERE CNT = 1 ) A, (SELECT R.INDEX_DEF_ID, R.ZQDM, R.CSBH, R.SCRQ, R.DCQFDBS, R.INDEX_SZQZ FROM PAR_INDEX_SAMPLE_BOND R WHERE R.SCRQ = TO_DATE(:B2 , 'yyyymmdd') AND NOT EXISTS (SELECT T.INDEX_DEF_ID, T.GZR, T.ZQDM, T.CSBH FROM INDEX_BUILD_ERRBOND T WHERE T.GZR = R.SCRQ AND T.INDEX_DEF_ID = R.INDEX_DEF_ID AND T.ZQDM = R.ZQDM AND T.CSBH = R.CSBH) AND ( :B1 IS NUL L OR :B1 = '@' OR R.INDEX_DEF_ID =:B1 )) B, INDEX_BUILD_INFO C, (SELECT TRIM(E2.SJZDLXDM) ENTRYVALUE, TRIM(E2.BZDM) STDCODE, TRIM(E2.SJZDLXMS) VALUEDESC FROM ADB_GG_UPDICTTYPE E1, ADB_GG_UPDICTITEM E2 WHERE TRIM(E1.SJZDLXDM) = TRIM(E2.SJZDXMDM) AND E1.SYBZ = '1' AND E2.SYBZ = '1' AND TRIM(E1.SJZDLXDM) = 'XXXZ1023') E, PAR_INDEX_DEF PAR, ( SELECT BZDM, SJZDLXMS, SJZDLXDM FROM ADB_GG_UPDICTITEM_TMP WHERE SJZDLXDM='0' )G WHERE A.ZQDM = B.ZQDM AND B.INDEX_DEF_ID = PAR.INDEX_DEF_ID AND ( :B1 IS NULL OR :B1 = '@' OR B.INDEX_DEF_ID =:B1 ) AND B.SCRQ = TO_DATE(:B2 , 'yyyymmdd') AND PAR.ZSZT = '2' AND PAR.GZFHZT = '3' AND PAR.FHZT = '3' AND PAR.GKBZ = '1' AND SYSDATE >= PAR.GKRQ AND A.CSBH = B.CSBH AND B.SCRQ = C.GZR AND C.FHZT = '3' AND TRIM(A.CSBH) = E.ENTRYVALUE(+) AND B.DCQFDBS IS NOT NULL ORDER BY YBZMC, LTCSZQDM
f4d4ccx58ypxc	SELECT TO_CHAR(MAX(WORK_DATE), 'yyyymmdd') FROM BOND_EVL_PRICE WHERE CSBH = '10' AND FBBS = '1'
fqhxwwqs09xhf	select distinct fn_hermite_yield(t.x1, t.x2, t.y1, t.y2, t.di1, t.di2, 2) from curve_formula t, par_curve_type t1, yc_bd_info t2 where t.x1 <= 2 and t.x2 >= 2 and t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.qxfl = '0' and t1.yc_def_id = '2c9081e50a2f9606010a3068cae70001' and t1.fbzt = 1 and t.work_time = (select max(t.work_time)-1 from curve_formula t, par_curve_type t1, yc_bd_info t2 where t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.fbzt = 1 and t1.qxfl = 0)
fufvvqyp9a25s	SELECT SUM(FXJG) FROM V_ADB_DJ_ZQ A WHERE TRIM(A.ZQDM) = TRIM(:B1 )
fwkk2a4j6davc	DELETE FROM OPB_OBJECT_LOCKS WHERE CNX_ID = :1
g1uhxzx0ndqza	SELECT :B4 RQ, B.INDEX_DEF_ID YBZID, PAR.ZSMC YBZMC, G.BZDM DCQID, G.SJZDLXMS DCQMC, A.ZQDM LTCSZQDM, A.ZQMC LTCSZQJC, E.STDCODE CSBH, E.VALUEDESC CSJC, A.CYJJ + A.YJLX QJ, A.CYJJ JJ, A.YJLX, A.DQJGZDF ZDF, A.DCQ, A.GZSYL DQSYL, A.DCSYL DC, A.XZJQ, A.LLJQ, A.LCJQ, A.TX, A.LLTX, A.LCTX, A.JDJZ, A.TGL KLTCL, B.DCQFDBS, ROUND(B.DCQ_SZQZ*100, 6) ZSSZQZ, A.SZQZ FROM ( SELECT * FROM (SELECT T.*, COUNT(*) OVER(PARTITION BY ZQDM, CSBH) CNT FROM (SELECT DISTINCT GZR, E.ZQDM, ZQMC, E.CSBH, CYJJ, YJLX, DQJGZDF, DCQ, GZSYL, DCSYL, XZJQ, LLJQ, LCJQ, TX, LLTX, LCTX, JDJZ, TGL, SZQZ, CYBS FROM INDEX_SAMPLEBOND_PRICE E WHERE GZR = TO_DATE(:B2 , 'yyyymmdd') ) T WHERE GZR = TO_DATE(:B2 , 'yyyymmdd')) WHERE CNT > 1 AND CYBS = '1' UNION ALL SELECT * FROM (SELECT T.* , COUNT(*) OVER(PARTITION BY ZQDM, CSBH) CNT FROM (SELECT DISTINCT GZR, E.ZQDM, ZQMC, E.CSBH, CYJJ, YJLX, DQJGZDF, DCQ, GZSYL, DCSYL, XZJQ, LLJQ, LCJQ, TX, LLTX, LCTX, JDJZ, TGL, SZQZ, CYBS FROM INDEX_SAMPLEBOND_PRICE E WHERE GZR = TO_DATE(:B2 , 'yyyymmdd') ) T WHERE GZR = TO_DATE(:B2 , 'yyyymmdd')) WHERE CNT = 1 ) A, (SELECT R.INDEX_DEF_ID, R.ZQDM, R.CSBH, R.SCRQ, R.DCQFDBS, R.DCQ_SZQZ FROM PAR_INDEX_SAMPLE_BOND R WHERE R.SCRQ = TO_DATE(:B2 , 'yyyymmdd') AND NOT EXISTS (SELECT T.INDEX_DEF_ID, T.GZR, T.ZQDM, T.CSBH FROM INDEX_BUILD_ERRBOND T WHERE T.GZR = R.SCRQ AND T.INDEX_DEF_ID = R.INDEX_DEF_ID AND T.ZQDM = R.ZQDM AND T.CSBH = R.CSBH) AND (:B1 IS NULL OR :B1 = '@' OR R.INDEX_DEF_ID =:B1 )) B, INDEX_BUILD_INFO C, (SELECT TRIM(E2.SJZDLXDM) ENTRYVALUE, TRIM(E2.BZDM) STDCODE, TRIM(E2.SJZDLXMS) VALUEDESC FROM ADB_GG_UPDICTTYPE E1, ADB_GG_UPDICTITEM E2 WHERE TRIM(E1.SJZDLXDM) = TRIM(E2.SJZDXMDM) AND E1.SYBZ = '1' AND E2.SYBZ = '1' AND TRIM(E1.SJZDLXDM) = 'XXXZ1023') E, PAR_INDEX_DEF PAR, ( SELECT BZDM, SJZDLXMS, SJZDLXDM FROM ADB_GG_UPDICTITEM_TMP )G WHERE A.ZQDM = B.ZQDM AND B.INDEX_DEF_ID = PAR.INDEX_DEF_ID AND PAR.ZSZT = '2' AND PAR.GZFHZT = '3' AND PAR.FHZT = '3' AND PAR.GKBZ = '1' AND SYSDATE >= PAR.GKRQ AND ( :B1 IS NULL OR :B1 = '@' OR B.INDEX_DEF_ID =:B1 ) AND B.SCRQ = TO_DATE(:B2 , 'yyyymmdd') AND A.CSBH = B.CSBH AND B.SCRQ = C.GZR AND C.FHZT = '3' AND TRIM(A.CSBH) = E.ENTRYVALUE(+) AND G.SJZDLXDM=B.DCQFDBS AND B.DCQFDBS=:B3 AND B.DCQFDBS IS NOT NULL
g9r9mc97yphgh	SELECT BQQXR, NVL(BQZQNLL, 0) FROM ADB_DJ_ZQJXQCXX WHERE TRIM(ZQDM) = :B2 AND (BQQXR <= :B1 AND :B1 < BQJXR)
gs42wyktj2aj1	SELECT INV_UTC, INV_COMMENTS, INV_TYPE, LINE_NO, VERSION_NUMBER FROM OPB_VALIDATE WHERE SUBJECT_ID = :1 AND OBJECT_TYPE = :2 AND OBJECT_ID = :3 AND VERSION_NUMBER <= :4 ORDER BY VERSION_NUMBER DESC, LINE_NO
gtxp9rwhmfjav	select zjgjxx0_.ZJGJXX_ID as ZJGJXX1_51_, zjgjxx0_.YC_DEF_ID as YC2_51_, zjgjxx0_.ZJ_ID as ZJ3_51_, zjgjxx0_.DW_ID as DW4_51_, zjgjxx0_.BZQX as BZQX51_, zjgjxx0_.BZQXMS as BZQXMS51_, zjgjxx0_.GJ_VALUE as GJ7_51_, zjgjxx0_.WORK_TIME as WORK8_51_ from ZJGJXX zjgjxx0_ where zjgjxx0_.DW_ID='0001' order by zjgjxx0_.WORK_TIME desc

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

• Ordered by statistic name

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

• IOStat by Function summary
• IOStat by Filetype summary
• IOStat by Function/Filetype summary
• Tablespace IO Stats
• File IO Stats

IOStat by Function summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Small Read and Large Read are average service times, in milliseconds
• Ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Ordered by (Data Read + Write) desc for each function

Back to IO Stats
Back to Top

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc