WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
JXSOH	2190265532	jxsoh1	1	10.2.0.5.0	YES	sohrac1

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	39241	20-Jul-12 14:56:52	262	15.2
End Snap:	39242	20-Jul-12 15:57:11	263	15.3
Elapsed:		60.32 (mins)
DB Time:		582.45 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	2,032M	2,032M	Std Block Size:	8K
Shared Pool Size:	3,504M	3,504M	Log Buffer:	14,324K

Load Profile

	Per Second	Per Transaction
Redo size:	8,138.55	4,505.61
Logical reads:	84,911.42	47,008.09
Block changes:	40.35	22.34
Physical reads:	7,584.60	4,198.93
Physical writes:	6.49	3.59
User calls:	1,168.81	647.07
Parses:	69.54	38.50
Hard parses:	2.13	1.18
Sorts:	91.99	50.92
Logons:	0.09	0.05
Executes:	1,098.61	608.20
Transactions:	1.81

% Blocks changed per Read:	0.05	Recursive Call %:	45.63
Rollback per transaction %:	14.30	Rows per Sort:	14.44

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	95.84	Redo NoWait %:	100.00
Buffer Hit %:	91.07	In-memory Sort %:	100.00
Library Hit %:	99.55	Soft Parse %:	96.94
Execute to Parse %:	93.67	Latch Hit %:	94.67
Parse CPU to Parse Elapsd %:	44.31	% Non-Parse CPU:	99.56

Shared Pool Statistics

	Begin	End
Memory Usage %:	70.01	69.86
% SQL with executions>1:	87.46	82.70
% Memory for SQL w/exec>1:	86.76	80.45

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
gc buffer busy	12,815,419	22,761	2	65.1	Cluster
CPU time		7,283		20.8
gc cr multi block request	14,317,933	2,828	0	8.1	Cluster
db file scattered read	1,530,336	1,697	1	4.9	User I/O
db file parallel read	304,600	440	1	1.3	User I/O

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	4,913.28	2,720.06
Global Cache blocks served:	4,838.19	2,678.48
GCS/GES messages received:	24,780.92	13,719.05
GCS/GES messages sent:	21,811.11	12,074.92
DBWR Fusion writes:	0.72	0.40
Estd Interconnect traffic (KB)	87,111.76

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %:	85.28
Buffer access - remote cache %:	5.79
Buffer access - disk %:	8.93

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.7
Avg global cache cr block receive time (ms):	1.0
Avg global cache current block receive time (ms):	1.2
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	3.3
Avg global cache cr block flush time (ms):	2.6
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.0
Avg global cache current block flush time (ms):	2.9

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.6
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	0.71
% of indirect sent messages:	93.08
% of flow controlled messages:	6.21

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

More RAC Statistics

• RAC Report Summary
• Global Enqueue Statistics
• Global CR Served Stats
• Global CURRENT Served Stats
• Global Cache Transfer Stats

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): 34947s
• 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
• SQL ordered by Cluster Wait Time
• 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): 34,947
• Captured SQL account for 92.7% 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): 7,283
• Captured SQL account for 80.0% 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: 307,291,899
• Captured SQL account for 87.3% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 27,448,434
• Captured SQL account for 92.7% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 3,975,827
• Captured SQL account for 95.6% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 251,662
• Captured SQL account for 59.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

SQL ordered by Cluster Wait Time

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
03x5tn7vnvfan	SELECT MAX(LOGIN_TIME) LOGIN_TIME FROM PUB_ONLINE WHERE USER_ID=:1
04xtrk7uyhknh	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
067bwrajpzxq6	select * from ( select lawvcontra0_.ID as ID110_, lawvcontra0_.CONTRACT_CODE as CONTRACT2_110_, lawvcontra0_.CONTRACT_NAME as CONTRACT3_110_, lawvcontra0_.CONTRACT_MARK as CONTRACT4_110_, lawvcontra0_.CONTRACT_TYPE as CONTRACT5_110_, lawvcontra0_.CONTRACT_MONEY as CONTRACT6_110_, lawvcontra0_.MONTY_TYPE_ID as MONTY7_110_, lawvcontra0_.UNDERTAKE_DEP_NAME as UNDERTAKE8_110_, lawvcontra0_.UNDERTAKE_DEP_ID as UNDERTAKE9_110_, lawvcontra0_.UNDERTAKE_ORG_NAME as UNDERTAKE10_110_, lawvcontra0_.UNDERTAKER_NAME as UNDERTAKER11_110_, lawvcontra0_.ORGAN_CODE as ORGAN12_110_, lawvcontra0_.CONTRACT_STATE as CONTRACT13_110_, lawvcontra0_.HAS_SIGNED as HAS14_110_, lawvcontra0_.IS_GRANT as IS15_110_, lawvcontra0_.GRANT_ID as GRANT16_110_, lawvcontra0_.PARTY_NAME as PARTY17_110_, lawvcontra0_.CREATE_DATE as CREATE18_110_, lawvcontra0_.OWNER_ORG_ID as OWNER19_110_, lawvcontra0_.IS_SAND as IS20_110_, lawvcontra0_.IS_CITY_SEND as IS21_110_, lawvcontra0_.SOURCE_ID as SOURCE22_110_, lawvcontra0_.TARGET_ID as TARGET23_110_, lawvcontra0_.PERFORM_END_TIME as PERFORM24_110_, lawvcontra0_.PERFORM_BEGIN_TIME as PERFORM25_110_, lawvcontra0_.UNDERTAKER_ID as UNDERTAKER26_110_ from LAW_V_CONTRACT_INFO lawvcontra0_ where 1=1 and lawvcontra0_.OWNER_ORG_ID=:1 order by lawvcontra0_.CREATE_DATE desc ) where rownum <= :2
0bk8gjqzh75sb	SELECT P.QUESTION_ID, P.PAPER_ID, O.OPTIONVALUE, O.DISVALUE, O.CONTENT, O.FILE_ID, O.FILE_NAME FROM DA_PAPEROPTION O, DA_EXAMRESULT R, DA_EXAMRECORD D, DA_PAPERQUESTION P WHERE R.PAPER_ID=P.PAPER_ID AND D.RESULT_ID=R.RESULT_ID AND O.PAPERQUES_ID=P.PAPERQUES_ID AND D.QUESTION_ID=P.QUESTION_ID AND P.PAPERQUES_ID=O.PAPERQUES_ID AND R.PLAN_ID='8a6a8ea53790d0300137c677dbe85b4d' AND R.USER_ID='360423197210191715' ORDER BY P.PAPERQUES_ID, O.DISVALUE
0c0q49akn498g	SELECT "REPORT_RECEIVE"."SORT_NO" , "REPORT_RECEIVE"."DEPT_NAME" , "REPORT_RECEIVE"."DEPT_IP" , "REPORT_RECEIVE"."REPORT_WAY" FROM "REPORT_RECEIVE"
0c0zudydqsnt3	UPDATE WF_ACTIVITY_VARIABLE SET VAR_VALUE=:1, IS_MODIFIED=:2 WHERE ACTIVITY_ID=:3 AND DEFINITION_ID=:4
0dwr2vd6vbqzs	SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
0nrj0qs1bw44m	SELECT SESSION_ID, USER_ID, USER_NAME, CORPORATION_ID, CORPORATION_NAME, LOGIN_TIME, LOGOFF_TIME, REMOTEADDR, REMOTEHOST, REMOTEPORT FROM PUB_ONLINE WHERE USER_ID=:1
0t6p1us4q64x8	select count ( *) from report_list where report_id =170
0tsnkyya7d0db	DELETE FROM JMS_DWQQSENDDATA a where a.sendtime <= to_char(sysdate-7, 'yyyy-mm-dd')||' 00:00:00'
122smaa2z46p2	select count ( *) from soft_version
17g3g4gggr874	SELECT QUESTION_ID, score FROM DA_EXAMRECORD Where RESULT_ID = '8a6a8ea5385bf9bc01387e55e64b2a08' and score >=0
17urv4cpp85dy	SELECT TO_CHAR(CPSTA)||' '||TO_CHAR(CPDRT)||' '||TO_CHAR(CPLRBA_SEQ)||' '||TO_CHAR(CPLRBA_BNO)||' '||TO_CHAR(CPLRBA_BOF)||' '||TO_CHAR(CPODR_SEQ)||' '||TO_CHAR(CPODR_BNO)||' '||TO_CHAR(CPODR_BOF)||' '||TO_CHAR(CPODS)||' '||TO_CHAR(CPODT_I)||' '||TO_CHAR(CPHBT) FROM SYS.DBPS_XKCCCP WHERE CPTNO=2 AND CPHBT!=0 AND ROWNUM<2
1bv8dh1f5vp48	SELECT SEQUENCE# FROM V$LOG WHERE THREAD#=1 AND STATUS='CURRENT' AND ROWNUM<2
1cyw778s1pq5z	SELECT SIGN_ID, RECORD_ID, USER_ID, USER_NAME, ORG_ID, SIGN_DEPT, ORG_NAME, SIGN_NOTES, SIGN_DATE, IS_SIGNED, SIGN_USER_ID, SIGN_USER_NAME, REFER_USER_NAME, REFER_DATE FROM AJ_T_XW_SIGN s , pub_stru ps, pub_organ po WHERE RECORD_ID=:1 and ORG_ID=:2 and po.organ_id =ps.organ_id and po.organ_code =org_id order by s.is_signed desc , s.sign_date desc, po.organ_type, ps.stru_order
1f16gg6m3fcdy	SELECT "SOFT_PARM"."PARM_CODE" , "SOFT_PARM"."PARM_VALUE" , "SOFT_PARM"."PARM_REMAK" , "SOFT_PARM"."SORT_NO" FROM "SOFT_PARM" ORDER BY "SOFT_PARM"."SORT_NO" ASC
1pttsqqvj8c9t	select * from (select row_.* , rownum rownum_ from (select articleid, title from article where type='521' and companyid =181 order by createdate desc) row_ where rownum<=6 )where rownum>=0
1t6gp1jsqvxt7	SELECT T.TYPE_NAME, T.ORDER_ID, T.CLASS_ID FROM AJ_T_BASE_TYPE T WHERE INSTR(:B1 , T.TYPE_ID) != 0 ORDER BY T.ORDER_ID, T.CLASS_ID
1tmcb45gw59s3	select count ( *) from pp_schedule where monsum > 0
1u6a4uy9j80p1	select * from (select row_.* , rownum rownum_ from (select articleid, title, articlepath, createdate, author from article where type in(select articletypeid from articletype where articletypeid=521 or suptypeid=521) and companyid=181order by createdate desc ) row_ where rownum<=6 )where rownum>=0
1ugxww5vga3h6	SELECT Q.PAPER_ID, Q.QUESTION_ID, Q.CONTENT, Q.TYPE_ID, Q.DIFF_ID, Q.DATA_ID, Q.MARK, Q.CNT_ATTACH_ID , Q.CNT_ATTACH_NAME , Q.MUST_STATUS , Q.ANSWER FROM (SELECT P.PAPER_ID, P.QUESTION_ID, P.CONTENT, P.TYPE_ID, P.DIFF_ID, P.DATA_ID, D.MARK, P.CNT_ATTACH_ID, P.MUST_STATUS, D.SORT, P.CNT_ATTACH_NAME, P.ANSWER FROM DA_PAPERQUESTION P, DA_EXAMRESULT R, DA_EXAMRECORD D WHERE R.RESULT_ID=D.RESULT_ID AND R.PLAN_ID='8a6a8ea5385c14cc01387a3c18a95401' AND R.USER_ID='360423197210191715' AND D.QUESTION_ID=P.QUESTION_ID AND R.PAPER_ID = P.PAPER_ID) Q inner join DA_QUESTIONTYPE T ON Q.TYPE_ID=T.TYPE_ID ORDER BY T.SORT, Q.SORT
1xpg9q1yh7aud	INSERT INTO TJ_ZY(TJ_ID, QSSJ, ZZSJ, KHBM, T1, T2, L34, L341, L402, L403, TJFL, TJSM, DWXZM, DWXZ, DYDJM, DYDJ, XLXZM, XLXZ, DQTZM, DQTZ, FXBM, FXMC, L31, L321, L322, L32, L33, L37, L38, L39, L40, LL0, LL1, LL2, L30, L301, L342, L35, L36, L41, L42, L43, L44, LGYYH, LGYBT, LGY, L45, L46, L47, G1, G2, G3, G4, G10, G5, Y1, Y2, Y3, Y4, Y10, Y5, LB5, QB5, G7, Y7, LB1, LB2, LB3, LB4, LB10, G6, Y6, L401, LB6, LB5050, QB6, G8, Y8, LB8, QB8, Y9, G9, LB9, LB11, LB12, L241, L242, L243, L343, L314, L315, L316, L317, L318, L319, L14, L15, L16, L22, L21, L141, L313, L215, L216, L217, L218, L219, L415, L416, L417, L418, L419, L17, L18, L19, L19_2, L110, L111, L112, L171, L1121, L24, L23, L25, L27, L26, L311, L28, L210, L29, L310, L11, L12, L13, L211, L212, L213, L214, L2141, L119, L115, L116, L117, L118, L120, L113, L114, L312, LB7, L88, L221, L2401) SELECT :B1 , :B7 , :B6 , :B5 , :B2 , :B4 , L34, L341, L402, L403, TJFL, TJSM, DWXZM, DWXZ, DYDJM, DYDJ, XLXZM, XLXZ, DQTZM, DQTZ, FXBM, FXMC, NVL(L31, 0), NVL(L321, 0), NVL(L322, 0), NVL(L32, 0), NVL(L33, 0), NVL(L37, 0), NVL(L38, 0), NVL(L39, 0), NVL(L40, 0), NVL(LL0, 0), NVL(LL1, 0), NVL(LL2, 0), NVL(L30, 0), NVL(L301, 0), NVL(L342, 0), NVL(L35, 0), NVL(L36, 0), NVL(L41, 0), NVL(L42, 0), NVL(L43, 0), NVL(L44, 0), NVL(LGYYH, 0), NVL(LGYBT, 0), NVL(LGY, 0), NVL(L45, 0), NVL(L46, 0), NVL(L47, 0), NVL(G1, 0), NVL(G2, 0), NVL(G3, 0), NVL(G4, 0), NVL(G10, 0), NVL(G5, 0), NVL(Y1, 0), NVL(Y2, 0), NVL(Y3, 0), NVL(Y4, 0), NVL(Y10, 0), NVL(Y5, 0), NVL(L B5, 0), NVL(QB5, 0), NVL(G7, 0), NVL(Y7, 0), NVL(LB1, 0), NVL(LB2, 0), NVL(LB3, 0), NVL(LB4, 0), NVL(LB10, 0), NVL(G6, 0), NVL(Y6, 0), NVL(G6+Y6, 0), NVL(LB6, 0), NVL(LB5050, 0), NVL(QB6, 0), NVL(G8, 0), NVL(Y8, 0), NVL(LB8, 0), NVL(QB8, 0), NVL(Y9, 0), NVL(G9, 0), NVL(LB9, 0), NVL(LB11, 0), NVL(LB12, 0), NVL(CASE WHEN L31=0 THEN 0 ELSE 100*(L322+L33)/L31 END, 0) AS L241, NVL(CASE WHEN L32=0 THEN 0 ELSE 100*L322/L32 END, 0) AS L242, NVL(CASE WHEN L31=0 THEN 0 ELSE 100*L33/L31 END, 0) AS L243, NVL(CASE WHEN L30*100=0 THEN 0 ELSE L301/L30*100 END, 0) AS L343, NVL(CASE WHEN LL0=0 THEN 0 ELSE L31/LL0 END, 0) AS L314, NVL(CASE WHEN LL1=0 THEN 0 ELSE L31/LL1 END, 0) AS L315, NVL(CASE WHEN LL0=0 THEN 0 ELSE L30/LL0 END, 0) AS L316, NVL(CASE WHEN LL1=0 THEN 0 ELSE L30/LL1 END, 0) AS L317, NVL(CASE WHEN LL2=0 THEN 0 ELSE LGY/LL2 END, 0) AS L318, NVL(CASE WHEN LL0=0 THEN 0 ELSE L35/LL0 END, 0) AS L319, NVL(CASE WHEN L34=0 THEN 0 ELSE (G8+Y8)/L34 END, 0) AS L14, NVL(CASE WHEN L34=0 THEN 0 ELSE QB8/L34 END, 0) AS L15, NVL(CASE WHEN L34=0 THEN 0 ELSE (G8+Y8-LB8)/L34 END, 0) AS L16, NVL(CASE WHEN L34=0 THEN 0 ELSE Y8/L34 END, 0) AS L22, NVL(CASE WHEN L34=0 THEN 0 ELSE G8/L34 END, 0) AS L21, NVL(CASE WHEN L341=0 THEN 0 ELSE (G8+Y8)/L341 END, 0) AS L141, NVL(CASE WHEN L35=0 THEN 0 ELSE (G7+Y7)*LB11/L35 END, 0) AS L313, NVL(CASE WHEN (Y1+G1)=0 THEN 0 ELSE LB1/(Y1+G1) END, 0) AS L215, NVL(CASE WHEN (Y2+G2)=0 THEN 0 ELSE LB2/(Y2+G2) END, 0) AS L216, NVL(CASE WHEN (Y3+G3)=0 T HEN 0 ELSE LB3/(Y3+G3) END, 0) AS L217, NVL(CASE WHEN (Y4+G4)=0 THEN 0 ELSE LB4/(Y4+G4) END, 0) AS L218, NVL(CASE WHEN (Y10+G10)=0 THEN 0 ELSE LB10/(Y10+G10) END, 0) AS L219, NVL(CASE WHEN G1=0 THEN 0 ELSE LB91/G1 END, 0) AS L415, NVL(CASE WHEN G2=0 THEN 0 ELSE LB92/G2 END, 0) AS L416, NVL(CASE WHEN G3=0 THEN 0 ELSE LB93/G3 END, 0) AS L417, NVL(CASE WHEN G4=0 THEN 0 ELSE LB94/G4 END, 0) AS L418, NVL(CASE WHEN G10=0 THEN 0 ELSE LB95/G10 END, 0) AS L419, NVL(CASE WHEN L34=0 THEN 0 ELSE (G6+Y6)/L34 END, 0) AS L17, NVL(CASE WHEN L34=0 THEN 0 ELSE QB6/L34 END, 0) AS L18, NVL(CASE WHEN L34=0 THEN 0 ELSE (G6+Y6-LB6)/L34 END, 0) AS L19, NVL(CASE WHEN L34=0 THEN 0 ELSE (G6+Y6-LB6-LB5050)/L34 END, 0) AS L19_2, NVL(CASE WHEN L34=0 THEN 0 ELSE G6/L34 END, 0) AS L110, NVL(CASE WHEN L34=0 THEN 0 ELSE Y6/L34 END, 0) AS L111, NVL(CASE WHEN L34=0 THEN 0 ELSE (Y6-LB6)/L34 END, 0) AS L112, NVL(CASE WHEN L341=0 THEN 0 ELSE (G6+Y6) / L341 END, 0) AS L171, NVL(CASE WHEN L35=0 THEN 0 ELSE LB12/L35 END, 0) AS L1121, NVL(CASE WHEN Y5=0 THEN 0 ELSE Y7/Y5 END, 0) AS L24, NVL(CASE WHEN G5=0 THEN 0 ELSE G7/G5 END, 0) AS L23, NVL(CASE WHEN (G5+Y5)=0 THEN 0 ELSE (G6+Y6)/(G5+Y5) END, 0) AS L25, NVL(CASE WHEN Y5=0 THEN 0 ELSE Y6/Y5 END, 0) AS L27, NVL(CASE WHEN G5=0 THEN 0 ELSE G6/G5 END, 0) AS L26, NVL(CASE WHEN LB5=0 THEN 0 ELSE LB6/LB5 END, 0) AS L311, NVL(CASE WHEN L34=0 THEN 0 ELSE (G9+Y9)/L34 END, 0) AS L28, NVL(CASE WHEN Y5=0 THEN 0 ELSE Y9/Y5 END, 0) AS L210, NVL(CASE WHEN G5 =0 THEN 0 ELSE G9/G5 END, 0) AS L29, NVL(CASE WHEN LB5=0 THEN 0 ELSE LB9/LB5 END, 0) AS L310, NVL(CASE WHEN (L34*:B2 )=0 THEN 0 ELSE 100 - 100*(G8+Y8)/(L34*:B2 ) END, 0) AS L11, NVL(CASE WHEN (L34*:B2 )=0 THEN 0 ELSE 100 - 100*QB8/(L34*:B2 ) END, 0) AS L12, NVL(CASE WHEN (L34*:B2 )=0 THEN 0 ELSE 100 - 100*(G8+Y8-LB8)/(L34*:B2 ) END, 0) AS L13, NVL(CASE WHEN (L32*:B4 )=0 THEN 0 ELSE 36500*(G1+Y1)/(L32*:B4 ) END, 0) AS L211, NVL(CASE WHEN (L33*:B4 )=0 THEN 0 ELSE 36500*(G2+Y2)/(L33*:B4 ) END, 0) AS L212, NVL(CASE WHEN (L36*:B4 )=0 THEN 0 ELSE 36500*(G3+Y3)/(L36*:B4 ) END, 0) AS L213, NVL(CASE WHEN (L37*:B4 )=0 THEN 0 ELSE 36500*(G4+Y4)/(L37*:B4 ) END, 0) AS L214, NVL(CASE WHEN (L40*:B4 )=0 THEN 0 ELSE 36500*(G10+Y10)/(L40*:B4 ) END, 0) AS L2141, NVL(CASE WHEN ((L32+L33)*:B4 )=0 THEN 0 ELSE 36500*(G1+G2)/((L32+L33)*:B4 ) END, 0) AS L119, NVL(CASE WHEN (L32*:B4 )=0 THEN 0 ELSE 36500*G1/(L32*:B4 ) END, 0) AS L115, NVL(CASE WHEN (L33*:B4 )=0 THEN 0 ELSE 36500*G2/(L33*:B4 ) END, 0) AS L116, NVL(CASE WHEN (L36*:B4 )=0 THEN 0 ELSE 36500*G3/(L36*:B4 ) END, 0) AS L117, NVL(CASE WHEN (L37*:B4 )=0 THEN 0 ELSE 36500*G4/(L37*:B4 ) END, 0) AS L118, NVL(CASE WHEN (L40*:B4 )=0 THEN 0 ELSE 36500*G10/(L40*:B4 ) END, 0) AS L120, NVL(CASE WHEN (G8+Y8)=0 THEN 0 ELSE 100*(G8+Y8-QB8)/(G8+Y8) END, 0) AS L113, NVL(CASE WHEN (G8+Y8)=0 THEN 0 ELSE 100*(G8+Y8-LB8-QB8)/(G8+Y8) END, 0) AS L114, NVL(CASE WHEN L35=0 THEN 0 ELSE LB11/L35 END, 0) AS L312, LB7, NVL(G8+Y8, 0) AS L88, NVL(CASE WHEN L34=0 THEN 0 ELSE (Y8-LB8)/L34 END, 0) AS L221, NVL(CASE WHEN (Y5-LB5)=0 THEN 0 ELSE (Y7-LB7)/(Y5-LB5) END, 0) AS L2401 FROM (SELECT NVL(SUM(XLHJ), 0) AS L31, NVL(SUM(LDXCD), 0) AS L321, NVL(SUM(JYXCD), 0) AS L322, NVL(SUM(LDXCD+JYXCD), 0) AS L32, NVL(SUM(DLCD), 0) AS L33, NVL(SUM(DLQTS), 0) AS L37, NVL(SUM(DRQTS), 0) AS L38, NVL(SUM(KZSS), 0) AS L39, NVL(SUM(KGTS), 0) AS L40, NVL(SUM(CASE WHEN CXKG='1' THEN 1 ELSE 0 END), 0) AS LL0, NVL(COUNT(*), 0) AS LL1, NVL(SUM(CASE WHEN CXKG='1' AND XLXZM='1' THEN 1 ELSE 0 END), 0) AS LL2 FROM VIEW_ZYXDSJ WHERE ZXRQ>=(:B3 -1) OR ZXRQ IS NULL) T1 LEFT JOIN (SELECT NVL(COUNT(*), 0) AS L30, NVL(SUM(CASE WHEN ISSDY='1' THEN 1 ELSE 0 END), 0) AS L301, NVL(SUM(DYYHS), 0) AS L342, NVL(SUM(ZRL), 0) AS L35, NVL(SUM(BTS), 0) AS L36, NVL(SUM(BRL), 0) AS L41, NVL(SUM(ZYSBS), 0) AS L42, NVL(SUM(ZYSBR), 0) AS L43, NVL(SUM(BTS+ZYSBS), 0) AS L44, NVL(SUM(CASE WHEN YHXZM='1' THEN 1 ELSE 0 END), 0) AS LGYYH, NVL(SUM(CASE WHEN YHXZM='1' THEN BTS ELSE 0 END), 0) AS LGYBT, NVL(SUM(CASE WHEN YHXZM='1' THEN BRL ELSE 0 END), 0) AS LGY, NVL(SUM(CASE WHEN YHXZM='2' THEN 1 ELSE 0 END), 0) AS L45, NVL(SUM(CASE WHEN YHXZM='2' THEN BRL+ZYSBR ELSE 0 END), 0) AS L46, NVL(SUM(CASE WHEN YHXZM='2' THEN BTS ELSE 0 END), 0) AS L47 FROM VIEW_ZYYHSJ WHERE ZXRQ>=(:B3 -1) OR ZXRQ IS NULL) T2 ON 1=1 LEFT JOIN (SELECT NVL(SUM(CXSJ)/:B2 , 0) AS L34 FROM VIEW_ZYYHSJ) T3 ON 1=1 LEFT JOIN (SELECT NVL(SUM(CASE WHEN TJBZM LIKE '%1%' AND TDZRM LIKE '51%' THEN BL ELSE 0 END), 0) AS G1, NVL(SUM(CASE WHEN TJBZM LIKE '%2%' AND TDZRM LIKE '51%' THEN BL ELSE 0 END), 0) AS G2, NVL(SUM(CASE WHEN TJBZM LIKE '%3%' AND TDZRM LIKE '51%' THEN BL ELSE 0 END), 0) AS G3, NVL(SUM(CASE WHEN TJBZM LIKE '%4%' AND TDZRM LIKE '51%' THEN BL ELSE 0 END), 0) AS G4, NVL(SUM(CASE WHEN TJBZM LIKE '%5%' AND TDZRM LIKE '51%' THEN BL ELSE 0 END), 0) AS G10, NVL(SUM(CASE WHEN TDZRM LIKE '51%' THEN BL ELSE 0 END), 0) AS G5, NVL(SUM(CASE WHEN TJBZM LIKE '%1%' AND TDZRM LIKE '50%' THEN BL ELSE 0 END), 0) AS Y1, NVL(SUM(CASE WHEN TJBZM LIKE '%2%' AND TDZRM LIKE '50%' THEN BL ELSE 0 END), 0) AS Y2, NVL(SUM(CASE WHEN TJBZM LIKE '%3%' AND TDZRM LIKE '50%' THEN BL ELSE 0 END), 0) AS Y3, NVL(SUM(CASE WHEN TJBZM LIKE '%4%' AND TDZRM LIKE '50%' THEN BL ELSE 0 END), 0) AS Y4, NVL(SUM(CASE WHEN TJBZM LIKE '%5%' AND TDZRM LIKE '50%' THEN BL ELSE 0 END), 0) AS Y10, NVL(SUM(CASE WHEN TDZRM LIKE '50%' THEN BL ELSE 0 END), 0) AS Y5, NVL(SUM(CASE WHEN TDZRM='5041' THEN BL ELSE 0 END), 0) AS LB5, NVL(SUM(CASE WHEN TDZRM NOT IN ('5130', '5132', '5134', '5139', '5140', '5176', '5190', '5007', '5013', '5027', '5041') THEN BL ELSE 0 END), 0) AS QB5, NVL(SUM(CASE WHEN TDZRM LIKE '51%' THEN BL*CXSJ ELSE 0 END), 0) AS G7, NVL(SUM(CASE WHEN TDZRM LIKE '50%' THEN BL*CXSJ ELSE 0 END), 0) AS Y7, NVL(SUM(CASE WHEN TJBZM LIKE '%1%' THEN BL*CXSJ ELSE 0 END), 0) AS LB1, NVL(SUM(CASE WHEN TJBZM LIKE '%2%' THEN BL*CXSJ ELSE 0 END), 0) AS LB2, NVL(SUM(CASE WHEN TJBZM LI KE '%3%' THEN BL*CXSJ ELSE 0 END), 0) AS LB3, NVL(SUM(CASE WHEN TJBZM LIKE '%4%' THEN BL*CXSJ ELSE 0 END), 0) AS LB4, NVL(SUM(CASE WHEN TJBZM LIKE '%5%' THEN BL*CXSJ ELSE 0 END), 0) AS LB10, NVL(SUM(CASE WHEN TJBZM LIKE '%1%' AND TDZRM LIKE '51%' THEN BL*CXSJ ELSE 0 END), 0) AS LB91, NVL(SUM(CASE WHEN TJBZM LIKE '%2%' AND TDZRM LIKE '51%' THEN BL*CXSJ ELSE 0 END), 0) AS LB92, NVL(SUM(CASE WHEN TJBZM LIKE '%3%' AND TDZRM LIKE '51%' THEN BL*CXSJ ELSE 0 END), 0) AS LB93, NVL(SUM(CASE WHEN TJBZM LIKE '%4%' AND TDZRM LIKE '51%' THEN BL*CXSJ ELSE 0 END), 0) AS LB94, NVL(SUM(CASE WHEN TJBZM LIKE '%5%' AND TDZRM LIKE '51%' THEN BL*CXSJ ELSE 0 END), 0) AS LB95, NVL(SUM(CASE WHEN TDZRM='5041'THEN BL*CXSJ ELSE 0 END), 0) AS LB7 FROM VIEW_ZYTDSJ) T4 ON 1=1 LEFT JOIN (SELECT NVL(SUM(CASE WHEN TDZRM LIKE '51%' THEN BL ELSE 0 END), 0) AS G6, NVL(SUM(CASE WHEN TDZRM LIKE '50%' THEN BL ELSE 0 END), 0) AS Y6, NVL(SUM(CASE WHEN TDZRM='5041' THEN BL ELSE 0 END), 0) AS LB6, NVL(SUM(CASE WHEN TDZRM='5050' THEN BL ELSE 0 END), 0) AS LB5050, NVL(SUM(CASE WHEN TDZRM NOT IN ('5130', '5132', '5134', '5139', '5140', '5176', '5190', '5007', '5013', '5027', '5041') THEN BL ELSE 0 END), 0) AS QB6, NVL(SUM(CASE WHEN TDZRM LIKE '51%' THEN BL*CXSJ ELSE 0 END), 0) AS G8, NVL(SUM(CASE WHEN TDZRM LIKE '50%' THEN BL*CXSJ ELSE 0 END), 0) AS Y8, NVL(SUM(CASE WHEN TDZRM='5041' THEN BL*CXSJ ELSE 0 END), 0) AS LB8, NVL(SUM(CASE WHEN TDZRM NOT IN ('5130', '5132', '5134', '5139', '5140', '5176', '5190', '5007', '5013', '5027', '5041') THEN BL*CXSJ ELSE 0 END), 0) AS QB8, NVL(SUM(CASE WHEN TDZRM LIKE '50%' THEN BL*TDRL*ZRB*CXSJ ELSE 0 END), 0) AS Y9, NVL(SUM(CASE WHEN TDZRM LIKE '51%' THEN BL*TDRL*ZRB*CXSJ ELSE 0 END), 0) AS G9, NVL(SUM(CASE WHEN TDZRM='5041' THEN BL*TDRL*ZRB*CXSJ ELSE 0 END), 0) AS LB9, NVL(SUM(BL*TDRL), 0) AS LB11, NVL(SUM(BL*TDRL*CXSJ), 0) AS LB12 FROM VIEW_ZYTDYH) T5 ON 1=1 LEFT JOIN (SELECT COUNT(*) AS L341 FROM (SELECT DISTINCT XDDWBM, XDBM, YHBM FROM VIEW_ZYTDYH) T) T6 ON 1=1 LEFT JOIN (SELECT NVL(SUM(CASE WHEN TDZRM='51' THEN 1 ELSE 0 END), 0) AS L402, NVL(SUM(CASE WHEN TDZRM='50' THEN 1 ELSE 0 END), 0) AS L403 FROM (SELECT DISTINCT XDDWBM, XDBM, YHBM, SUBSTRB(TDZRM, 1, 2) TDZRM FROM VIEW_ZYTDYH) T) T8 ON 1=1 LEFT JOIN (SELECT TJFL, TJSM, DWXZM, DWXZ, DYDJM, DYDJ, XLXZM, XLXZ, DQTZM, DQTZ, FXBM, FXMC FROM TJ_ZYTASK WHERE ID=:B1 ) T7 ON 1=1
20q1u1pwn7s40	select distinct code from hyydfl_level_define
29jxz0fwpnjw8	select count ( *) from pp_detail where capability_water =0
2mxyaw5772zgn	SELECT SIGN_ID, RECORD_ID, USER_ID, USER_NAME, ORG_ID, SIGN_DEPT, ORG_NAME, SIGN_NOTES, SIGN_DATE, IS_SIGNED, SIGN_USER_ID, SIGN_USER_NAME, REFER_USER_NAME, REFER_DATE FROM AJ_T_XW_SIGN s , pub_stru ps, pub_organ po WHERE RECORD_ID=:1 and po.organ_id =ps.organ_id and po.organ_code =org_id order by s.is_signed desc , s.sign_date desc, po.organ_type, ps.stru_order
2vm077863rmw5	select count ( *) from buysell_power where buy_finance > 0
2ym6hhaq30r73	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
31a13pnjps7j3	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
32wf751ns51vy	SELECT sum(nvl(score, 0)) FROM DA_EXAMRECORD Where RESULT_ID = '8a6a8ea5385bf9bc01387e55e64b2a08' and score >=0
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
4k1fyrn4rf32z	SELECT QUESTION_ID, ANSWER FROM DA_EXAMRESULT R, DA_EXAMRECORD D WHERE R.RESULT_ID=D.RESULT_ID AND R.PLAN_ID='8a6a8ea5385c14cc01388f0d48336ef8' AND R.USER_ID='362423197207140011'
4kdn5tzc1dp1z	select count(1) from da_exam_user where plan_id = '8a6a8ea5389913ec01389d0c0a1c09c1'
4trp4uqybsths	select * from (select row_.* , rownum rownum_ from (select article.articleid, article.author, article.title, article.createdate, article.articlepath from article where article.articlepath is not null order by article.articleid desc) row_ where rownum<=5 )where rownum>=0
4xn3kcyrfz476	SELECT PARTY_NAME FROM LAW_T_CONTRACT_PARTY_INST WHERE CONTRACT_ID = TO_CHAR(:B1 )
5hktt0z8wq0w4	SELECT * FROM PUB_STRU_TYPE
5q65r47cqxd2a	DELETE FROM DA_EXAMRECORD WHERE RESULT_ID=:1 AND QUESTION_ID=:2
5st6jfpjah21k	select current_version from soft_version
5trhk03v534mm	begin :rc := sys . dbms_backup_restore . validateArchivedLog ( recid => :recid , stamp => :stamp , fname => :fname , thread => :thread , sequence => :seq , resetlogs_change => :rstscn , first_change => :lowscn , blksize => :blksize , signal => :sigerr , terminal => :terminal ) ; end ;
5wbraag0mtrr3	select value from init_para where name='ReportServer_Path'
5y3dwdnmnhsz4	select count(*) from (select distinct (t.user_id) from pub_online_hist t where t.login_time like '20120720%' )
60s9vgs0assrq	SELECT QUESTION_ID, ANSWER FROM DA_EXAMRESULT R, DA_EXAMRECORD D WHERE R.RESULT_ID=D.RESULT_ID AND R.PLAN_ID='8a6a8ea5385c14cc01387a3c18a95401' AND R.USER_ID='360423197210191715'
6jkx7kqx9ksut	select count ( *) from pp_getdata_sell
73w05knkwyh12	select ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL, pub_organ po, pub_stru ps where POL.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '99994045%' and po.organ_type like '1%' union all SELECT count( POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '99994045%' and po.organ_type like '1%' ) ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL, pub_organ po, pub_stru ps where POL.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '99994045' and po.organ_type like '1%' union all SELECT count( POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '99994045' and po.organ_type like '1%' ) ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL, pub_organ po, pub_stru ps where POL.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404551' and po.organ_type like '1%' union all SELECT count( POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404551' and po.organ_type like '1%' ) ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL, pub_organ po, pub_stru ps where POL.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404552' and po.organ_type like '1%' union all SELECT count( POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404552' and po.organ_type like '1%' ) ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL, pub_organ po, pub_stru ps where POL.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404553' and po.organ_type like '1%' union all SELECT count( POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404553' and po.organ_type like '1%' ) ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL, pub_organ po, pub_stru ps where POL.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404554' and po.organ_type like '1%' union all SELECT count( POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404554' and po.organ_type like '1%' ) ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL, pub_organ po, pub_stru ps where POL.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404555' and po.organ_type like '1%' union all SELECT count( POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404555' and po.organ_type like '1%' ) ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL, pub_organ po, pub_stru ps where POL.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like ' 9999404556' and po.organ_type like '1%' union all SELECT count( POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404556' and po.organ_type like '1%' ) ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL, pub_organ po, pub_stru ps where POL.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404557' and po.organ_type like '1%' union all SELECT count( POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404557' and po.organ_type like '1%' ) ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL, pub_organ po, pub_stru ps where POL.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404558' and po.organ_type like '1%' union all SELECT count( POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.org an_code like '9999404558' and po.organ_type like '1%' ) ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL, pub_organ po, pub_stru ps where POL.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404559' and po.organ_type like '1%' union all SELECT count( POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404559' and po.organ_type like '1%' ) ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL, pub_organ po, pub_stru ps where POL.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404560' and po.organ_type like '1%' union all SELECT count( POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404560' and po.organ_type like '1%' ) ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL, pub_organ po, pub_stru ps where POL.corporation_id = ps.stru_id and ps.organ_id = po.orga n_id and po.organ_code like '9999404561' and po.organ_type like '1%' union all SELECT count( POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404561' and po.organ_type like '1%' ) ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL, pub_organ po, pub_stru ps where POL.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404562' and po.organ_type like '1%' union all SELECT count( POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404562' and po.organ_type like '1%' ) ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL, pub_organ po, pub_stru ps where POL.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404511' and po.organ_type like '1%' union all SELECT count( POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id and ps.orga n_id = po.organ_id and po.organ_code like '9999404511' and po.organ_type like '1%' ) ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL, pub_organ po, pub_stru ps where POL.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404565' and po.organ_type like '1%' union all SELECT count( POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404565' and po.organ_type like '1%' ) ), ( select sum(num) from (SELECT count(POL.SESSION_ID) num FROM PUB_ONLINE POL, pub_organ po, pub_stru ps where POL.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404589' and po.organ_type like '1%' union all SELECT count( POH.SESSION_ID) num FROM PUB_ONLINE_HIST POH, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404589' and po.organ_type like '1%' ) ) from dual
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#
7zn98jm91qnwn	select * from (select row_.* , rownum rownum_ from (select articleid, title, articlepath, createdate, author from article where type in(select articletypeid from articletype where articletypeid=321 or suptypeid=321) and companyid=181order by createdate desc ) row_ where rownum<=6 )where rownum>=0
82d3cfudv18cr	select INIT_PARA.VALUE , INIT_PARA.NAME from INIT_PARA where (INIT_PARA.NAME = 'AutoSendMonthTime')
82y43v9jyyjyj	select count ( *) from distribute_unit
83qjh7ajnrytr	select value from init_para where name=:1
84mxnmsj0dtgs	SELECT TO_CHAR(CPSTA)||' '||TO_CHAR(CPDRT)||' '||TO_CHAR(CPLRBA_SEQ)||' '||TO_CHAR(CPLRBA_BNO)||' '||TO_CHAR(CPLRBA_BOF)||' '||TO_CHAR(CPODR_SEQ)||' '||TO_CHAR(CPODR_BNO)||' '||TO_CHAR(CPODR_BOF)||' '||TO_CHAR(CPODS)||' '||TO_CHAR(CPODT_I)||' '||TO_CHAR(CPHBT) FROM SYS.DBPS_XKCCCP WHERE CPTNO=1 AND CPHBT!=0 AND ROWNUM<2
87akpfahu6v3j	Select record_id, subtitle, title, create_date, create_org_id, class_name, class_id from aj_v_t_xw_new_for_zxxx where is_over_view in ('0', '1') and create_org_id = '9999404555' and rownum<=5
8dncffttyb71s	select count ( *) from gen_buy_sell_use where sellpower_mon > 0
8hstswatkrmvj	select count ( *) from report_import_parm
8w33ckvvux0fv	select count(*) from (select to_char(logintime, 'yyyy.mm.dd'), userid, count(userid) from LOG where to_char(sysdate, 'yyyy.mm.dd')=to_char(logintime, 'yyyy.mm.dd') group by to_char(logintime, 'yyyy.mm.dd'), userid order by userid desc)
8w9udmaddscwc	update sys.sumdelta$ s set s.timestamp = :1, s.scn = :2 where rowid in (select rowid from sys.sumdelta$ AS OF SNAPSHOT (:3) s1 where s1.tableobj# = :4 and s1.timestamp >= to_date('4000-01-01:00:00:00', 'YYYY-MM-DD:HH24:MI:SS'))
9gxkpawadq9f4	select * from (select row_.* , rownum rownum_ from (select articleid, title from article where type='1' and companyid =181 order by createdate desc) row_ where rownum<=9)where rownum>=0
9jhkxmdsh9bax	select value from init_para where name='XmlBakPath'
a2r0a7tzwb1d5	select count ( *) from pp_detail where qtdl =0
ag49vk2j7jfu6	SELECT SEQUENCE# FROM V$LOG WHERE THREAD#=2 AND STATUS='CURRENT' AND ROWNUM<2
ah6z9t7k3b3ax	SELECT A.STRU_ID, A.STRU_TYPE, A.PARENT_ID, B.ORGAN_ID, B.ORGAN_CODE, B.ORGAN_NAME, B.SHORT_NAME, B.ORGAN_TYPE FROM PUB_STRU A, PUB_ORGAN B WHERE A.ORGAN_ID=B.ORGAN_ID AND A.IN_USE = '1' AND B.IN_USE = '1' AND B.ORGAN_CODE=:1
ap7h8cxnat98k	INSERT INTO PUB_CMD_LOG (LOG_ID, BEAN_ID, BEAN_CLASS, METHOD, STARTTIME, ENDTIME, SECURITY_LOG_ID, Conn_Number)values(:1, :2, :3, :4, :5, :6, :7, :8)
aqv19mzwmqqak	SELECT * FROM ( SELECT ROW_.*, ROWNUM ROWNUM_ FROM ( select p.user_id, p.user_name, decode(do.organ_type, '203', (select organ_id from pub_organ where organ_id = ds.parent_id), do.organ_name) as dept_id, decode(do.organ_type, '203', (select organ_name from pub_organ where organ_id = ds.parent_id), do.organ_name) as dept_name, decode(do.organ_type, '203', do.organ_id, '' ) as bz_id, decode(do.organ_type, '203', do.organ_name, '' ) as bz_name, p.organ_id, p.organ_name, e.examno, to_char(NVL((Select t.start_date from da_examresult t where t.user_id = p.user_id and t.plan_id = e.plan_id), ''), 'yyyy-MM-dd HH24:MI:SS') as STARTDATE, to_char(NVL((Select t.end_date from da_examresult t where t.user_id = p.user_id and t.plan_id = e.plan_id), ''), 'yyyy-MM-dd HH24:MI:SS') as ENDDATE from da_v_users p, da_exam_user e, pub_stru os, pub_stru ds, pub_organ do WHERE P.USER_ID=E.USER_ID and e.org_id = os.organ_id and ds.organ_id = e.dept_id and do.organ_id = ds.organ_id AND E.PLAN_ID = '8a6a8ea5389913ec01389d0c0a1c09c1' ) ROW_ WHERE ROWNUM <= :1) WHERE ROWNUM_ > :2
at6kbvkxjbf98	select count(*) as onhist from pub_online_hist
ax2fmsz6tw0mh	select ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon , pub_organ po, pub_stru ps WHERE pon.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '99994045%' and po.organ_type like '1%' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%' and ps.organ_id = po.organ_id and po.organ_code like '99994045%' and po.organ_type like '1%' ) ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon , pub_organ po, pub_stru ps WHERE pon.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '99994045' and po.organ_type like '1%' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%' and ps.organ_id = po.organ_id and po.organ_code like '99994045' and po.organ_type like '1%' ) ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon , pub_organ po, pub_stru ps WHERE pon.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404551' and po.organ_type like '1%' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh, p ub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%' and ps.organ_id = po.organ_id and po.organ_code like '9999404551' and po.organ_type like '1%' ) ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon , pub_organ po, pub_stru ps WHERE pon.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404552' and po.organ_type like '1%' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%' and ps.organ_id = po.organ_id and po.organ_code like '9999404552' and po.organ_type like '1%' ) ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon , pub_organ po, pub_stru ps WHERE pon.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404553' and po.organ_type like '1%' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%' and ps.organ_id = po.organ_id and po.organ_code like '9999404553' and po.organ_type like '1%' ) ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon , pub_organ po, pub_stru ps WHERE pon.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404554' and po.organ_type like '1%' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%' and ps.organ_id = po.organ_id and po.organ_code like '9999404554' and po.organ_type like '1%' ) ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon , pub_organ po, pub_stru ps WHERE pon.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404555' and po.organ_type like '1%' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%' and ps.organ_id = po.organ_id and po.organ_code like '9999404555' and po.organ_type like '1%' ) ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon , pub_organ po, pub_stru ps WHERE pon.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404556' and po.organ_type like '1%' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id AND poh.LOGIN_T IME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%' and ps.organ_id = po.organ_id and po.organ_code like '9999404556' and po.organ_type like '1%' ) ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon , pub_organ po, pub_stru ps WHERE pon.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404557' and po.organ_type like '1%' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%' and ps.organ_id = po.organ_id and po.organ_code like '9999404557' and po.organ_type like '1%' ) ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon , pub_organ po, pub_stru ps WHERE pon.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404558' and po.organ_type like '1%' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%' and ps.organ_id = po.organ_id and po.organ_code like '9999404558' and po.organ_type like '1%' ) ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon , pub_organ po, pub_stru ps WHERE pon.corporation_id = ps.stru_id and ps.organ_i d = po.organ_id and po.organ_code like '9999404559' and po.organ_type like '1%' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%' and ps.organ_id = po.organ_id and po.organ_code like '9999404559' and po.organ_type like '1%' ) ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon , pub_organ po, pub_stru ps WHERE pon.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404560' and po.organ_type like '1%' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%' and ps.organ_id = po.organ_id and po.organ_code like '9999404560' and po.organ_type like '1%' ) ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon , pub_organ po, pub_stru ps WHERE pon.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404561' and po.organ_type like '1%' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%' and ps.organ_id = po.organ_id and po.o rgan_code like '9999404561' and po.organ_type like '1%' ) ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon , pub_organ po, pub_stru ps WHERE pon.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404562' and po.organ_type like '1%' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%' and ps.organ_id = po.organ_id and po.organ_code like '9999404562' and po.organ_type like '1%' ) ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon , pub_organ po, pub_stru ps WHERE pon.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404511' and po.organ_type like '1%' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%' and ps.organ_id = po.organ_id and po.organ_code like '9999404511' and po.organ_type like '1%' ) ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon , pub_organ po, pub_stru ps WHERE pon.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404565' and po.organ_type like '1%' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%' and ps.organ_id = po.organ_id and po.organ_code like '9999404565' and po.organ_type like '1%' ) ), ( SELECT COUNT(UNIQUE USER_ID) FROM (SELECT USER_ID FROM PUB_ONLINE pon , pub_organ po, pub_stru ps WHERE pon.corporation_id = ps.stru_id and ps.organ_id = po.organ_id and po.organ_code like '9999404589' and po.organ_type like '1%' UNION ALL SELECT USER_ID FROM PUB_ONLINE_HIST poh, pub_organ po, pub_stru ps WHERE poh.corporation_id = ps.stru_id AND poh.LOGIN_TIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%' and ps.organ_id = po.organ_id and po.organ_code like '9999404589' and po.organ_type like '1%' ) ) from dual
b2zxy6rsaczg0	SELECT COUNT(1) FROM (SELECT RECORD_ID, TITLE, CLASS_ID, CREATE_ORG, CREATE_ORG_ID, CREATE_USER, CREATE_USER_ID, PUBLISH_ORG, CREATE_DEPT, CREATE_DEPT_ID, CLASSES_ID, CREATE_DATE FROM AJ_V_ZH_SEARCH WHERE ( AJ_V_ZH_SEARCH.TITLE like '%¼¼¸Ä%' OR AJ_V_ZH_SEARCH.PUBLISH_ORG like '%¼¼¸Ä%' OR AJ_V_ZH_SEARCH.CREATE_USER like '%¼¼¸Ä%' OR AJ_V_ZH_SEARCH.CLASSES_ID like '%¼¼¸Ä%' OR instr('¼¼¸Ä', AJ_V_ZH_SEARCH.CLASSES_ID)>0 ) AND ( AJ_V_ZH_SEARCH.CREATE_ORG_ID = '9999404553' OR ( AJ_V_ZH_SEARCH.ClASS_ID in('sgjs', 'jyjl', 'zxhd', 'tgx', 'xwdt')AND instr('9999404553', AJ_V_ZH_SEARCH.CREATE_ORG_ID )>0 ) ) ORDER BY CREATE_DATE DESC, RECORD_ID DESC) T
bc2v9ccacsk20	select ( SELECT COUNT(*) FROM (SELECT UNIQUE SESSION_ID FROM PUB_ONLINE pu , pub_organ po , pub_stru ps where ps.organ_id =po.organ_id and pu.corporation_id =ps.stru_id and po.organ_code like '99994045%' and po.organ_type like '1%') ), ( SELECT COUNT(*) FROM (SELECT UNIQUE SESSION_ID FROM PUB_ONLINE pu , pub_organ po , pub_stru ps where ps.organ_id =po.organ_id and pu.corporation_id =ps.stru_id and po.organ_code like '99994045' and po.organ_type like '1%') ), ( SELECT COUNT(*) FROM (SELECT UNIQUE SESSION_ID FROM PUB_ONLINE pu , pub_organ po , pub_stru ps where ps.organ_id =po.organ_id and pu.corporation_id =ps.stru_id and po.organ_code like '9999404551' and po.organ_type like '1%') ), ( SELECT COUNT(*) FROM (SELECT UNIQUE SESSION_ID FROM PUB_ONLINE pu , pub_organ po , pub_stru ps where ps.organ_id =po.organ_id and pu.corporation_id =ps.stru_id and po.organ_code like '9999404552' and po.organ_type like '1%') ), ( SELECT COUNT(*) FROM (SELECT UNIQUE SESSION_ID FROM PUB_ONLINE pu , pub_organ po , pub_stru ps where ps.organ_id =po.organ_id and pu.corporation_id =ps.stru_id and po.organ_code like '9999404553' and po.organ_type like '1%') ), ( SELECT COUNT(*) FROM (SELECT UNIQUE SESSION_ID FROM PUB_ONLINE pu , pub_organ po , pub_stru ps where ps.organ_id =po.organ_id and pu.corporation_id =ps.stru_id and po.organ_code like '9999404554' and po.organ_type like '1%') ), ( SELECT COUNT(*) FROM (SELECT UNIQUE SESSION_ID FROM PUB_ONLINE pu , pub_organ po , pub_stru ps where ps.org an_id =po.organ_id and pu.corporation_id =ps.stru_id and po.organ_code like '9999404555' and po.organ_type like '1%') ), ( SELECT COUNT(*) FROM (SELECT UNIQUE SESSION_ID FROM PUB_ONLINE pu , pub_organ po , pub_stru ps where ps.organ_id =po.organ_id and pu.corporation_id =ps.stru_id and po.organ_code like '9999404556' and po.organ_type like '1%') ), ( SELECT COUNT(*) FROM (SELECT UNIQUE SESSION_ID FROM PUB_ONLINE pu , pub_organ po , pub_stru ps where ps.organ_id =po.organ_id and pu.corporation_id =ps.stru_id and po.organ_code like '9999404557' and po.organ_type like '1%') ), ( SELECT COUNT(*) FROM (SELECT UNIQUE SESSION_ID FROM PUB_ONLINE pu , pub_organ po , pub_stru ps where ps.organ_id =po.organ_id and pu.corporation_id =ps.stru_id and po.organ_code like '9999404558' and po.organ_type like '1%') ), ( SELECT COUNT(*) FROM (SELECT UNIQUE SESSION_ID FROM PUB_ONLINE pu , pub_organ po , pub_stru ps where ps.organ_id =po.organ_id and pu.corporation_id =ps.stru_id and po.organ_code like '9999404559' and po.organ_type like '1%') ), ( SELECT COUNT(*) FROM (SELECT UNIQUE SESSION_ID FROM PUB_ONLINE pu , pub_organ po , pub_stru ps where ps.organ_id =po.organ_id and pu.corporation_id =ps.stru_id and po.organ_code like '9999404560' and po.organ_type like '1%') ), ( SELECT COUNT(*) FROM (SELECT UNIQUE SESSION_ID FROM PUB_ONLINE pu , pub_organ po , pub_stru ps where ps.organ_id =po.organ_id and pu.corporation_id =ps.stru_id and po.organ_code like '9999404561' and po.organ_type like '1 %') ), ( SELECT COUNT(*) FROM (SELECT UNIQUE SESSION_ID FROM PUB_ONLINE pu , pub_organ po , pub_stru ps where ps.organ_id =po.organ_id and pu.corporation_id =ps.stru_id and po.organ_code like '9999404562' and po.organ_type like '1%') ), ( SELECT COUNT(*) FROM (SELECT UNIQUE SESSION_ID FROM PUB_ONLINE pu , pub_organ po , pub_stru ps where ps.organ_id =po.organ_id and pu.corporation_id =ps.stru_id and po.organ_code like '9999404511' and po.organ_type like '1%') ), ( SELECT COUNT(*) FROM (SELECT UNIQUE SESSION_ID FROM PUB_ONLINE pu , pub_organ po , pub_stru ps where ps.organ_id =po.organ_id and pu.corporation_id =ps.stru_id and po.organ_code like '9999404565' and po.organ_type like '1%') ), ( SELECT COUNT(*) FROM (SELECT UNIQUE SESSION_ID FROM PUB_ONLINE pu , pub_organ po , pub_stru ps where ps.organ_id =po.organ_id and pu.corporation_id =ps.stru_id and po.organ_code like '9999404589' and po.organ_type like '1%') ) from dual
bsa0wjtftg3uw	select file# from file$ where ts#=:1
c09vjrzqh3a20	update AJ_T_PUB_TASK set ACTION_STATUS = '2' where 'S36000000002386, S36000000011230, S36000000011329, S36000000011688, S36000000011690, S36000000011694, S36000000014702, S36000000014791, S36000000014792, S36000000014793, S36000000014830, S36000000014831, S36000000014835, S36000000002389, S36000000002418, S36000000002524, S36000000008109, S36000000008112, S36000000008734, S36000000014661, S3628282000000000368242, S36000000002532, S36000000008892, S36000000007325, S36000000014229, S36000000002393, S36000000002435, S36000000002443, S36000000002444, S36000000007328, S36000000007330, S36000000007331, S36000000007332, S36000000007333, S36000000008111, S36000000008123, S36000000011228, S36000000011797, S36000000011817, S36000000011843, S36000000011851, S36000000011872, S36000000011878, S36000000011880, S36000000011882, S36000000011894, S36000000011906, S36000000011931, S36000000014415, S36000000014420, S36000000002397, S36000000009210, S36000000002394, S36000000002417, S36000000011231, S36000000011735, S36000000011738, S36000000011740, S36000000011742, S36000000011744, S36000000011746, S36000000011748, S36000000011750, S36000000011752, S36000000011754, S36000000011757, S36000000011773, S36000000007324, S36000000009214, S36000000009216, S36000000009217, S36000000009218, S36000000011277, S36000000011709, S36000000014798, S36000000011280, S36000000011733, S36000000014833, S36000000008114, S36000000011283, S36000000011418, S36000000014414, S36000000008124, S36000000011285, S3600000001 1469, S36000000011639, S36000000011692, S36000000011696, S36000000011698, S36000000011700, S36000000011701, S36000000011705, S36000000011710, S36000000011712, S36000000011714, S36000000011716, S36000000011718, S36000000011719, S36000000011723, S36000000011725, S36000000011727, S36000000011729, S36000000011731, S36000000014506, S36000000014832' like '%'||ROLE_ID||'%' and TABLE_NAME = 'AJ_T_BS_TYPE' and TABLE_ID = '8a6a8ea535eade880135eb4a304e04da'
chbgkk6tmzmmj	update sys.sumpartlog$ s set s.timestamp = :1, s.scn = :2 where rowid in (select rowid from sumpartlog$ AS OF SNAPSHOT(:3) s1 where s1.bo# = :4 and s1.timestamp >= to_date('4000-01-01:00:00:00', 'YYYY-MM-DD:HH24:MI:SS'))
cm2889s9k390f	SELECT P.QUESTION_ID, P.PAPER_ID, O.OPTIONVALUE, O.DISVALUE, O.CONTENT, O.FILE_ID, O.FILE_NAME FROM DA_PAPEROPTION O, DA_EXAMRESULT R, DA_EXAMRECORD D, DA_PAPERQUESTION P WHERE R.PAPER_ID=P.PAPER_ID AND D.RESULT_ID=R.RESULT_ID AND O.PAPERQUES_ID=P.PAPERQUES_ID AND D.QUESTION_ID=P.QUESTION_ID AND P.PAPERQUES_ID=O.PAPERQUES_ID AND R.PLAN_ID='8a6a8ea5385c14cc01387a3c18a95401' AND R.USER_ID='360423197210191715' ORDER BY P.PAPERQUES_ID, O.DISVALUE
cp44w3a4w0u0b	SELECT TYPE_ID, TYPENAME, TYPE_DESC, MARK , IS_OBJECTIVE FROM DA_QUESTIONTYPE T WHERE EXISTS(SELECT 1 FROM (SELECT P.QUESTION_ID, P.TYPE_ID FROM DA_EXAMRESULT R, DA_EXAMRECORD D, DA_PAPERQUESTION P WHERE R.RESULT_ID=D.RESULT_ID AND R.PLAN_ID='8a6a8ea5385c14cc01387a3c18a95401' AND R.USER_ID='360423197210191715' AND D.QUESTION_ID=P.QUESTION_ID AND R.PAPER_ID = P.PAPER_ID) Q WHERE Q.TYPE_ID=T.TYPE_ID) ORDER BY T.SORT
d7mb3hcnsc09a	SELECT "REPORT_LIST"."SORT_NO" , "REPORT_LIST"."REPORT_NAME" , "REPORT_LIST"."REPORT_ID" , "REPORT_LIST"."ISYEARREPORT" , "REPORT_LIST"."IS_SHOW" , "REPORT_LIST"."TABLE_DATABASE" , "REPORT_LIST"."DATE_SELECTED" , "REPORT_LIST"."DATE_DELETED" FROM "REPORT_LIST"
df7c2wqn4pqf7	select l.webservices_log_id, l.webservices_type, l.call_data, l.keyword_id from sm_t_webservices_log l where l.need_try_again between 1 and 5 and (l.result_flag is null or l.result_flag <> 0) and l.webservices_type in (2, 4, 5)
dfvvudyy20p7b	SELECT A.STRU_ID, A.STRU_TYPE, A.PARENT_ID, B.ORGAN_ID, B.ORGAN_CODE, B.ORGAN_NAME, B.SHORT_NAME, B.ORGAN_TYPE FROM PUB_STRU A, PUB_ORGAN B WHERE A.ORGAN_ID=B.ORGAN_ID AND B.ORGAN_ID=:1 AND A.IN_USE = '1' AND B.IN_USE = '1'
dhzkt1vz6fzk8	SELECT COUNT(VISITOR) FROM VISITOR WHERE IMS_IP=:1
djm3xjf15avgh	SELECT TYPE_ID, TYPENAME, TYPE_DESC, MARK , IS_OBJECTIVE FROM DA_QUESTIONTYPE T WHERE EXISTS(SELECT 1 FROM (SELECT P.QUESTION_ID, P.TYPE_ID FROM DA_EXAMRESULT R, DA_EXAMRECORD D, DA_PAPERQUESTION P WHERE R.RESULT_ID=D.RESULT_ID AND R.PLAN_ID='8a6a8ea5385c14cc0138886ac37761cc' AND R.USER_ID='362325196610092534' AND D.QUESTION_ID=P.QUESTION_ID AND R.PAPER_ID = P.PAPER_ID) Q WHERE Q.TYPE_ID=T.TYPE_ID) ORDER BY T.SORT
dv3cafm3rrfhw	SELECT Q.PAPER_ID, Q.QUESTION_ID, Q.CONTENT, Q.TYPE_ID, Q.DIFF_ID, Q.DATA_ID, Q.MARK, Q.CNT_ATTACH_ID , Q.CNT_ATTACH_NAME , Q.MUST_STATUS , Q.ANSWER FROM (SELECT P.PAPER_ID, P.QUESTION_ID, P.CONTENT, P.TYPE_ID, P.DIFF_ID, P.DATA_ID, D.MARK, P.CNT_ATTACH_ID, P.MUST_STATUS, D.SORT, P.CNT_ATTACH_NAME, P.ANSWER FROM DA_PAPERQUESTION P, DA_EXAMRESULT R, DA_EXAMRECORD D WHERE R.RESULT_ID=D.RESULT_ID AND R.PLAN_ID='8a6a8ea53790d0300137c677dbe85b4d' AND R.USER_ID='360423197210191715' AND D.QUESTION_ID=P.QUESTION_ID AND R.PAPER_ID = P.PAPER_ID) Q inner join DA_QUESTIONTYPE T ON Q.TYPE_ID=T.TYPE_ID ORDER BY T.SORT, Q.SORT
f1nvw38k84g4x	select count ( *) from report_list where report_id =70
f3uw4zq22umt6	SELECT tsname, bsize total, used, bsize - used tsleft, useratio used_per, 100 - useratio free_per FROM (SELECT d.tablespace_name tsname, round(nvl(a.bytes / 1024 / 1024, 0), 2) bsize, round(nvl(a.bytes - nvl(f.bytes, 0), 0) / 1024 / 1024, 2) used, round(nvl((a.bytes - nvl(f.bytes, 0)) / a.bytes * 100, 0), 2) useratio FROM sys.dba_tablespaces d, (SELECT tablespace_name, SUM(bytes) bytes FROM dba_data_files GROUP BY tablespace_name) a, (SELECT tablespace_name, SUM(bytes) bytes FROM dba_free_space GROUP BY tablespace_name) f WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = f.tablespace_name(+) AND NOT (d.extent_management LIKE 'LOCAL' AND d.contents LIKE 'TEMPORARY') UNION ALL SELECT d.tablespace_name tsname, round(nvl(a.bytes / 1024 / 1024, 0), 2) bsize, round(nvl(t.bytes, 0) / 1024 / 1024, 2) used, round(nvl(t.bytes / a.bytes * 100, 0), 2) useratio FROM sys.dba_tablespaces d, (SELECT tablespace_name, SUM(bytes) bytes FROM dba_temp_files GROUP BY tablespace_name) a, (SELECT tablespace_name, SUM(bytes_cached) bytes FROM v$temp_extent_pool GROUP BY tablespace_name) t WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = t.tablespace_name(+) AND d.extent_management LIKE 'LOCAL' AND d.contents LIKE 'TEMPORARY') x order by tsname
fc47q236ryhbf	update dxp_monitor_heart_log a set a.heart_time = sysdate where upper(a.monitor_name) = 'SCHEDULE'
fy0cr07pnqm4d	select tablespace_name, trunc(Sqrt(max(blocks)/ sum(blocks)) * (100/Sqrt(Sqrt(count(blocks)))), 2) FSFI, count(blocks) blcn , sum(blocks) sumbl , max(blocks) mxbl from sys.dba_free_space group by tablespace_name
g8j9dbvwu8umw	SELECT USER_ID , EXAMNO FROM DA_EXAM_USER WHERE PLAN_ID='8a6a8ea538a1df360138a2493f1c08a4'
gpmhpd484pgkm	select count ( *) from soft_parm where parm_code ='power_six'
grwydz59pu6mc	select text from view$ where rowid=:1
gygmckv3731w9	INSERT INTO PUB_ONLINE (SESSION_ID, USER_ID, USER_NAME, CORPORATION_ID, CORPORATION_NAME, LOGIN_TIME, LOGOFF_TIME, REMOTEADDR, REMOTEHOST, REMOTEPORT) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)

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

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