WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
BXRAC	972412335	bxrac3	3	24-Feb-14 09:02	11.2.0.1.0	YES

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
bxrac03	Linux x86 64-bit	16	16	4	29.46

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	16662	26-Feb-14 08:00:08	85	1.7
End Snap:	16665	26-Feb-14 11:00:06	202	2.0
Elapsed:		179.97 (mins)
DB Time:		1,131.39 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	3,372M	3,372M	Std Block Size:	8K
Shared Pool Size:	1,172M	1,172M	Log Buffer:	5,908K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	6.3	2.2	0.04	0.03
DB CPU(s):	0.8	0.3	0.01	0.00
Redo size:	47,047.7	16,403.1
Logical reads:	21,449.8	7,478.5
Block changes:	317.0	110.5
Physical reads:	6,573.6	2,291.9
Physical writes:	23.4	8.2
User calls:	250.8	87.4
Parses:	34.5	12.0
Hard parses:	2.8	1.0
W/A MB processed:	1.1	0.4
Logons:	0.1	0.0
Executes:	147.5	51.4
Rollbacks:	0.1	0.0
Transactions:	2.9

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.75	Redo NoWait %:	100.00
Buffer Hit %:	70.63	In-memory Sort %:	100.00
Library Hit %:	96.00	Soft Parse %:	91.91
Execute to Parse %:	76.60	Latch Hit %:	99.81
Parse CPU to Parse Elapsd %:	61.35	% Non-Parse CPU:	98.36

Shared Pool Statistics

	Begin	End
Memory Usage %:	83.43	81.08
% SQL with executions>1:	84.30	49.99
% Memory for SQL w/exec>1:	83.62	56.27

Top 5 Timed Foreground Events

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

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.22	3.10	5.0	0.6	11.6	94.2

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
5.4	92.7	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	30,170.0	30,170.0
SGA use (MB):	4,616.0	4,616.0
PGA use (MB):	439.1	854.7
% Host Mem used for SGA+PGA:	16.76	18.13

RAC Statistics

	Begin	End
Number of Instances:	4	4

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	10.22	3.56
Global Cache blocks served:	1.13	0.39
GCS/GES messages received:	912.14	318.02
GCS/GES messages sent:	1,441.77	502.67
DBWR Fusion writes:	0.27	0.10
Estd Interconnect traffic (KB)	550.57

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

Buffer access - local cache %:	70.58
Buffer access - remote cache %:	0.05
Buffer access - disk %:	29.37

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.3
Avg global cache cr block receive time (ms):	2.7
Avg global cache current block receive time (ms):	7.1
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 %:	7.6
Avg global cache cr block flush time (ms):	1.3
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 %:	2.7
Avg global cache current block flush time (ms):	1.5

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	1.5
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:	11.43
% of indirect sent messages:	88.55
% of flow controlled messages:	0.02

Cluster Interconnect

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

More RAC Statistics

• RAC Report Summary
• Global Messaging Statistics
• Global CR Served Stats
• Global CURRENT Served Stats
• Global Cache Transfer Stats
• Interconnect Stats
• Dynamic Remastering Statistics

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): 67883.5s
• Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
• Ordered by % or DB time desc, Statistic name

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.0% of Total DB time 67,883.55 (s)
• Total FG Wait Time: 59,234.06 (s) DB CPU time: 8,681.09 (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)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes) h is 4096*1024 milliseconds (approximately 70 minutes or 1.17 hours)
• % 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

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
• 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 - 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 79.3% of Total DB Time (s): 67,884
• Captured PL/SQL account for 6.1% of Total DB Time (s): 67,884

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 77.8% of Total CPU Time (s): 8,681
• Captured PL/SQL account for 10.1% of Total CPU Time (s): 8,681

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 79.4% of Total User I/O Wait Time (s): 55,188
• Captured PL/SQL account for 5.9% of Total User I/O Wait Time (s): 55,188

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: 231,615,386
• Captured SQL account for 80.6% 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: 70,981,550
• Captured SQL account for 81.9% 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: 6,667,583
• Captured SQL account for 80.9% of Total
• Total UnOptimized Read Requests: 6,667,583
• Captured SQL account for 80.9% 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: 1,592,792
• Captured SQL account for 29.9% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 372,765
• Captured SQL account for 43.4% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

• %Total - Cluster Time as a percentage of Total Cluster Wait Time
• %Clu - Cluster Time as a percentage of Elapsed Time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Only SQL with Cluster Wait Time > .005 seconds is reported
• Total Cluster Wait Time (s): 3,629
• Captured SQL account for 85.2% of Total

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
05hmpf2p8565g	BEGIN pkg_k_dyjs.PRC_K_HOSBALANCE( '4043' , '4' , '201402' , 1 , 1 , 1 , '???' , PRM_APPCODE=>:PRM_APPCODE, PRM_ERRORMSG=>:PRM_ERRORMSG); END;
0aj1zdq290512	SELECT /*+rule */AC02.AAC001, AC02.AAE140, AC02.AAC036 FROM AC02, AC01 WHERE AC02.AAC001 = AC01.AAC001 AND AC01.AAB001 = :B1 AND AC02.AAC031 = '1' ORDER BY AC02.AAC001, AC02.AAE140
1wm6mmh7ja8fq	BEGIN pkg_k_dyjs.PRC_K_HOSBALANCE( '4048' , '4' , '201402' , 1 , 1 , 1 , '??' , PRM_APPCODE=>:PRM_APPCODE, PRM_ERRORMSG=>:PRM_ERRORMSG); END;
23s41uw7uh684	BEGIN pkg_a_FeeAssign.prc_a_FeeAssign( '1' , '10000114' , '201401' , '41' , 201402181420458285 , '???' , PRM_ASSIGNSEQ=>:PRM_ASSIGNSEQ, PRM_APPCODE=>:PRM_APPCODE, PRM_ERRORMSG=>:PRM_ERRORMSG); END;
29f0sdqrra9w3	SELECT KC24.ROWID I, KC24.AAC001 AAC001 FROM KC24 WHERE AKB020 = :B2 AND TO_CHAR(AAE036, 'yyyymm')>= :B1 AND NVL(BAA084, '0')='0'
2fdwm9h1sh4vc	UPDATE KC24 SET AKC267 = '1', AKC266 = SYSDATE WHERE AKB020 = :B4 AND AKC190 = :B3 AND CKC130 = :B2 AND AAE072 = :B1
2pu6rjcc5a70a	SELECT /*+rule */ ROWID R_ID, AC13.* FROM AC13 WHERE AAB001 = :B1 AND AAE114 = '1' AND ( BAC202 = '0' OR BAC202 IS NULL ) ORDER BY AAC001, AAA060
2t18c25c8q5yb	Select aia001 From aa03 Where aae001 =:1
2zhx5djchhvzw	BEGIN pkg_k_dyjs.PRC_K_HOSBALANCE( '3005' , '2' , '201402' , 1 , 1 , 1 , '??' , PRM_APPCODE=>:PRM_APPCODE, PRM_ERRORMSG=>:PRM_ERRORMSG); END;
31mrrcu76uw5g	BEGIN pkg_k_dyjs.PRC_K_HOSBALANCE( '3004' , '2' , '201402' , 1 , 1 , 1 , '???' , PRM_APPCODE=>:PRM_APPCODE, PRM_ERRORMSG=>:PRM_ERRORMSG); END;
32pwpwqjhyrvm	BEGIN pkg_a_FeeAssign.prc_a_FeeAssign( '1' , '10000123' , '201401' , '41' , 201402171423475953 , '???' , PRM_ASSIGNSEQ=>:PRM_ASSIGNSEQ, PRM_APPCODE=>:PRM_APPCODE, PRM_ERRORMSG=>:PRM_ERRORMSG); END;
34czy00uz791b	UPDATE KC24 SET AAE117 = '1', CKC305 = :B5 WHERE AKB020 = :B4 AND AKC190 = :B3 AND AAC001 = :B2 AND AAE072 = :B1 AND CKC125 =1
3972rvxu3knn3	delete from sdo_geor_ddl__table$$
45nssrx9ckbks	BEGIN pkg_a_FeeAssign.prc_a_FeeAssign( '1' , '10000113' , '201401' , '41' , 201402181420458283 , '???' , PRM_ASSIGNSEQ=>:PRM_ASSIGNSEQ, PRM_APPCODE=>:PRM_APPCODE, PRM_ERRORMSG=>:PRM_ERRORMSG); END;
481s6fpjnkc9k	SELECT A.AAB001, B.AAB004, A.AAE002, A.AAB210, A.AAE036, A.AAE140 FROM AB15 A, AB01 B WHERE A.AAB001 = B.AAB001 and a.aae002 = '201401' and a.aae140 = '41' and b.aab301 = '0103' and to_date(a.aae036) >= to_date('2014-02-26', 'yyyy-mm-dd') and to_date(a.aae036) <= to_date('2014-02-26', 'yyyy-mm-dd')
48kn5md9dhxzu	UPDATE KC24 SET AAE117 = '1', CKC305 = :B6 WHERE AKB020 = :B5 AND AKC190 = :B4 AND AAC001 = :B3 AND AAE072 = :B2 AND CKC130 = :B1
4dbw1kk1g56pt	BEGIN pkg_k_dyjs.PRC_K_HOSBALANCE( '4040' , '4' , '201402' , 1 , 1 , 1 , '??' , PRM_APPCODE=>:PRM_APPCODE, PRM_ERRORMSG=>:PRM_ERRORMSG); END;
4q3tcah7322w9	SELECT clientid, serverid, filename, direction, filepath, TASKNAME, fmd5, exptime, filecontent, lastexptime, NULL, rowsnum, dealtimes, dealtime, NULL, bzinfo from translog where SERVERID='001' and clientid='001' and DIRECTION<>'0' and EXPTIME>to_date('20140225200206', 'yyyymmddhh24miss') and (taskname<'Task1200' or taskname in('Task1204', 'Task1208')) order by exptime
4vs91dcv7u1p6	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)
4wc51apxahfyx	DELETE AC13 WHERE BAB221 = :B2 AND AAB001 = :B1 AND NOT EXISTS (SELECT 1 FROM AC10 WHERE AC13.AAC001 = AC10.AAC001 AND AC10.AAE002 = AC13.AAE002 AND AC13.AAE061 = AC10.BAB221 AND AC10.AAB001 = :B1 ) AND NOT EXISTS (SELECT 1 FROM AB20 WHERE AC13.AAB001 = AB20.AAB001 AND AC13.AAE002 = AB20.AAE002 AND AC13.AAE061 = AB20.BAB221 AND AB20.AAB001 = :B1 )
4z15nvru7h8sd	SELECT A.AAB001, A.AAA060, A.AAE002, A.AAE003, A.BAB221, A.AAE143, A.BAA082, A.AAE063, A.AAE140, A.AAB156, SUM(A.AAB201) AAB201 FROM AB14 A, AB13 B WHERE A.AAE064 = B.AAE064 AND A.AAB001 = :B3 AND A.AAE002 = :B2 AND B.BAB210 = '1' AND B.BAB211 <> '3' AND (A.AAE063 = :B1 OR :B1 = 0) GROUP BY A.AAB001, A.AAA060, A.AAE002, A.AAE003, A.BAB221, A.AAE143, A.BAA082, A.AAE063, A.AAE140, A.AAB156
540pxb8qp4v40	BEGIN pkg_k_dyjs.PRC_K_HOSBALANCE( '3004' , '2' , '201402' , 3 , 1 , 1 , '???' , PRM_APPCODE=>:PRM_APPCODE, PRM_ERRORMSG=>:PRM_ERRORMSG); END;
5h4a28dvrprps	SELECT "AB01"."AAB004", "AC01"."AAC002", "AC01"."AAC003", "AC13"."AAC008", NVL("AC01"."AAC021", '0'), "AC01"."AKC020", "AC13"."AAC001", "AC13"."AAB001", MAX("AC13"."BAC121") AJC020, MAX("AC13"."BAC121") AAC040, "AC13"."AAE143", NVL(SUM(DECODE("AC13"."BAA082", '11', DECODE(substr("AC13"."BAA063", 1, 2), '21', NVL("AC13"."AAC123", 0), 0), '21', DECODE(substr("AC13"."BAA063", 1, 2), '21', NVL("AC13"."AAC123", 0), 0), 0)), 0) GRYJ, NVL(SUM(DECODE("AC13"."BAA082", '12', DECODE(substr("AC13"."BAA063", 1, 2), '21', NVL("AC13"."AAC123", 0), 0), '22', DECODE(substr("AC13"."BAA063", 1, 2), '21', NVL("AC13"."AAC123", 0), 0), 0)), 0) DWYJ, NVL(SUM(DECODE("AC13"."BAA082", '11', NVL("AC13"."AAC123", 0), '12', NVL("AC13"."AAC123", 0), '21', NVL("AC13"."AAC123", 0), '22', NVL("AC13"."AAC123", 0), 0)), 0) YJHJ FROM "AB01 ", "AC01", "AC13" WHERE ( "AC13"."AAB001" = "AB01"."AAB001" ) AND ( "AC13"."AAC001" = "AC01"."AAC001" ) AND "AC13"."AAE002" = :v_aae002 AND "AC13"."AAB001" = :v_aab001 AND SUBSTR("AC13"."AAE140", 1, 1) = '2' AND "AC13"."BAB221" <> "AC13"."AAE061" and exists (select 1 from t_Person_Deptgroup tpd, t_Deptgroup_Privilege tdp where ( tpd.deptgroup_id = tdp.deptgroup_id ) and ( tdp.aab001 = ab01.aab001 ) and ( tpd.operator_id = 619) ) GROUP BY "AB01"."AAB004", "AC01"."AAC002", "AC01"."AAC003", "AC13"."AAC008", "AC13"."AAE143", "AC01"."AAC021", "AC01"."AKC020", "AC13"."AAC001", "AC13"."AAB001", "AC01"."AKC021" ORDER BY "AC13"."AAE143", "AC01"."AKC021", "AC13"."AAC001"
5hnnuvh73uvsx	SELECT clientid, serverid, filename, direction, filepath, TASKNAME, fmd5, exptime, filecontent, lastexptime, NULL, rowsnum, dealtimes, dealtime, NULL, bzinfo from translog where SERVERID='001' and clientid='001' and DIRECTION<>'0' and EXPTIME>to_date('20140223200212', 'yyyymmddhh24miss') and (taskname<'Task1200' or taskname in('Task1205', 'Task1209')) order by exptime
5hx2a7b985m4g	BEGIN pkg_k_dyjs_JMTC.PRC_K_HOSBALANCE( '3004' , '2' , '201402' , 1 , 1 , 1 , '???' , PRM_APPCODE=>:PRM_APPCODE, PRM_ERRORMSG=>:PRM_ERRORMSG); END;
5nmvnvw22bqpz	SELECT "AB10"."AAB001", "AB10"."AAE002", "AB10"."AAE063", "AB01"."AAB353", (select aab340 FROM ab52 WHERE aae008 ="AB10"."AAB024") AAB024, "AB10"."AAB025", "AB10"."AAB026", "AB10"."AAB180", '1' zzz001, '' zzz002, sysdate zzz003, to_date('') dzrq, to_number('') sjfje, '' zzz006, "AB10"."AAE142", to_number('') zzz007, to_number('') zzz008, '' zzz009, to_number('') zzz010, to_number('') zzz011, '' flag, '' zzz013, "AB01"."AAB004", "AB01"."AAE006", "AB01"."AAB020", "AB01"."AAB018", "AB01"."AAB016", "AB01"."AAB013", "AB01"."AAB022", to_date('') aab050 FROM "AB10", "AB01" where ab01.aab001 = ab10.aab001 and nvl(aae111, '0') <> '1' and nvl(bab203, '0') <> '1' AND NOT EXISTS( SELECT * FROM ab08 WHERE ab08.aae063 = ab10.aae063 AND EX ISTS (SELECT * FROM ac13 WHERE ac13.bab221 = ab08.bab221 AND EXISTS(SELECT * FROM ac10 WHERE ac10.bab221 = ac13.aae061 AND ac10.aae108 = '0' AND ROWNUM = 1 ) AND ROWNUM = 1) AND ROWNUM = 1) AND ( ( ab10.aae142 = '23' ) ) AND ( ( ab10.aae002 = '201403' ) ) ORDER BY "AB10"."AAB001"
5qpsf6dtrg9m9	SELECT "AB01"."AAB004", "AC01"."AAC002", "AC01"."AAC003", "AC13"."AAC008", NVL("AC01"."AAC021", '0'), "AC01"."AKC020", "AC13"."AAC001", "AC13"."AAB001", MAX("AC13"."BAC121") AJC020, MAX("AC13"."BAC121") AAC040, "AC13"."AAE143", NVL(SUM(DECODE("AC13"."BAA082", '11', DECODE(SUBSTR("AC13"."BAA063", 1, 2), '21', NVL("AC13"."AAC123", 0), 0), '21', DECODE(SUBSTR("AC13"."BAA063", 1, 2), '21', NVL("AC13"."AAC123", 0), 0), 0)), 0) GRYJ, NVL(SUM(DECODE("AC13"."BAA082", '12', DECODE(SUBSTR("AC13"."BAA063", 1, 2), '21', NVL("AC13"."AAC123", 0), 0), '22', DECODE(SUBSTR("AC13"."BAA063", 1, 2), '21', NVL("AC13"."AAC123", 0), 0), 0)), 0) DWYJ, NVL(SUM(DECODE("AC13"."BAA082", '11', NVL("AC13"."AAC123", 0), '12', NVL("AC13"."AAC123", 0), '21', NVL("AC13"."AAC123", 0), '22', NVL("AC13"."AAC123", 0), 0)), 0) YJHJ FROM dqsi."AB01", dqsi."AC01", dqsi."AC13" WHERE ("AC13"."AAB001" = "AB01"."AAB001") AND ("AC13"."AAC001" = "AC01"."AAC001") AND "AC13"."AAE002" = '201403' AND "AC13"."AAB001" IN (SELECT aab001 FROM dqsi.ab01 WHERE aab301='0102') AND SUBSTR("AC13"."AAE140", 1, 1) = '2' AND "AC13"."BAB221" <> "AC13"."AAE061" GROUP BY "AB01"."AAB004", "AC01"."AAC002", "AC01"."AAC003", "AC13". "AAC008", "AC13"."AAE143", "AC01"."AAC021", "AC01"."AKC020", "AC13"."AAC001", "AC13"."AAB001", "AC01"."AKC021" ORDER BY "AC13"."AAE143", "AC01"."AKC021", "AC13"."AAC001"
5ycu8j4w1b76r	BEGIN pkg_k_dyjs.PRC_K_HOSBALANCE( '3003' , '1' , '201402' , 1 , 1 , 1 , '??' , PRM_APPCODE=>:PRM_APPCODE, PRM_ERRORMSG=>:PRM_ERRORMSG); END;
62t5gutrnq44d	SELECT /*+INDEX(KC24 INDEX_KC24_PAY)*/KC24.AKB020, KC24.AAC001, KC24.AAB001, KC24.AKC190, KC24.AAE072, KC24.CKC130, KC24.AKA130, KC24.AKC021, NVL(KC24.CKC039, 0) CKC039, NVL(KC24.AKC260, 0) + NVL(ZKC025, 0)+ NVL(KC24.ZKC028, 0) TCZC, DECODE(NVL(AKC260, 0), 0, 0, DECODE(NVL(KC24.ZKC024, 0), 0, NVL(KC24.AKC260, 0)-NVL(KC24.ZKC025, 0)-NVL(KC24.ZKC028, 0), DECODE(NVL(KC24.ZKC025, 0)+NVL(KC24.ZKC028, 0), 0, NVL(KC24.AKC260, 0), NVL(KC24.AKC260, 0)-(NVL(KC24.AKC260, 0)+NVL(KC24.AKC257, 0))*0.05))) AKC260, NVL(KC24.AKC261, 0) AKC261, NVL(KC24.AKC265, 0) AKC265, NVL(KC24.ZKC025, 0) ZKC025, NVL(KC24.ZKC028, 0) ZKC028, DECODE(NVL(KC24.ZKC024, 0), 0, 0, DECODE(NVL(AKC260, 0), 0, NVL(KC24.ZKC024, 0)-NVL(KC24.ZKC025, 0)-NVL(KC24.ZKC028, 0), NVL(KC24.ZKC024, 0) + NVL(KC24.AKC260, 0) -NVL(KC24.ZKC025, 0)-NVL(KC24.ZKC028, 0)-DECODE(NVL(KC24.ZKC025, 0)+NVL(KC24.ZKC028, 0), 0, NVL(KC24.AKC260, 0), NVL(KC24.AKC260, 0)-(NVL(KC24.AKC260, 0)+NVL(KC24.AKC257, 0))*0.05))) ZKC024, NVL(KC24.AKC258, 0) JZJZF1, NVL(KC24.AKC264, 0) AKC264, NVL(KC24.AKC255, 0) ZHLJZF, NVL(KC24.AKC253, 0) AKC253, NVL(KC24.ZKC033, 0) + NVL(KC24.ZKC032, 0) + NVL(KC24.CKC066, 0) ZLZL, NVL(KC21.AKA151, 0) QFBZ, KC21.AKC196, TRUNC(KC21.AKC192, 'DD') RYRQ, TRUNC(KC24.AAE040, 'DD') CYRQ, (CASE WHEN INSTR(BAA084, '32') > 0 THEN ROUND(NVL(CKC039, 0)* 0.15, 2) ELSE 0 END) CKC039_GWY, (CASE WHEN INSTR(BAA084, '34') > 0 THEN ROUND(NVL(CKC039, 0)* 0.15, 2) ELSE 0 END) CKC039_QYBC FROM KC24, KC21 WHERE KC 24.AKB020 = KC21.AKB020(+) AND KC24.AKC190 = KC21.AKC190(+) AND KC24.AAC001 = KC21.AAC001(+) AND (KC24.AKC197 <> '0' OR KC24.AKC197 IS NULL ) AND (TO_CHAR(KC24.AAE040, 'yyyymm') = :B2 ) AND NVL(KC21.CKC125, '1') = '1' AND (KC24.CKC125 = 1 OR KC24.CKC125 IS NULL ) AND KC24.CKC130 = '1' AND NVL(KC24.AKC264, 0) <> 0 AND KC24.AKA130 <> '13' AND NVL(KC24.BAA084, 'X') <> '38' AND NVL(KC24.BAA084, 'X') <> '3A' AND KC24.AKB020 = :B1 AND NOT EXISTS(SELECT 1 FROM KC_HMD WHERE AKB020=KC24.AKB020 AND AAC001=KC24.AAC001 AND AKC190=KC24.AKC190 AND NVL(AAE120, '0')='0')
68wbxm6m6k5nw	SELECT "AB01"."AAB004", "AC01"."AAC002", "AC01"."AAC003", "AC13"."AAC008", NVL("AC01"."AAC021", '0'), "AC01"."AKC020", "AC13"."AAC001", "AC13"."AAB001", MAX("AC13"."BAC121") AJC020, MAX("AC13"."BAC121") AAC040, "AC13"."AAE143", NVL(SUM(DECODE("AC13"."BAA082", '11', DECODE(substr("AC13"."BAA063", 1, 2), '21', NVL("AC13"."AAC123", 0), 0), '21', DECODE(substr("AC13"."BAA063", 1, 2), '21', NVL("AC13"."AAC123", 0), 0), 0)), 0) GRYJ, NVL(SUM(DECODE("AC13"."BAA082", '12', DECODE(substr("AC13"."BAA063", 1, 2), '21', NVL("AC13"."AAC123", 0), 0), '22', DECODE(substr("AC13"."BAA063", 1, 2), '21', NVL("AC13"."AAC123", 0), 0), 0)), 0) DWYJ, NVL(SUM(DECODE("AC13"."BAA082", '11', NVL("AC13"."AAC123", 0), '12', NVL("AC13"."AAC123", 0), '21', NVL("AC13"."AAC123", 0), '22', NVL("AC13"."AAC123", 0), 0)), 0) YJHJ FROM "AB01 ", "AC01", "AC13" WHERE ( "AC13"."AAB001" = "AB01"."AAB001" ) AND ( "AC13"."AAC001" = "AC01"."AAC001" ) AND "AC13"."AAE002" = :v_aae002 AND "AC13"."AAB001" = :v_aab001 AND SUBSTR("AC13"."AAE140", 1, 1) = '2' AND "AC13"."BAB221" <> "AC13"."AAE061" and exists (select 1 from t_Person_Deptgroup tpd, t_Deptgroup_Privilege tdp where ( tpd.deptgroup_id = tdp.deptgroup_id ) and ( tdp.aab001 = ab01.aab001 ) and ( tpd.operator_id = 260) ) GROUP BY "AB01"."AAB004", "AC01"."AAC002", "AC01"."AAC003", "AC13"."AAC008", "AC13"."AAE143", "AC01"."AAC021", "AC01"."AKC020", "AC13"."AAC001", "AC13"."AAB001", "AC01"."AKC021" ORDER BY "AC13"."AAE143", "AC01"."AKC021", "AC13"."AAC001"
6cdu979a9uujk	SELECT "AB01"."AAB001", "AB01"."AAB004", "AB15"."AAE002", NVL(SUM(DECODE("AA07"."AAA062", '1', DECODE(SUBSTR("AB15"."AAA060", 1, 2), '35', 0, '37', 0, '32', 0, '34', 0, "AB15"."AAB210"), '2', DECODE(SUBSTR("AB15"."AAA060", 1, 2), '35', 0, '37', 0, '32', 0, '34', 0, "AB15"."AAB210"), 0)), 0) HZH , NVL(SUM(DECODE("AA07"."AAA062", '1', DECODE(SUBSTR("AB15"."AAA060", 1, 2), '32', "AB15"."AAB210", 0), '2', DECODE(SUBSTR("AB15"."AAA060", 1, 2), '32', "AB15"."AAB210", 0), 0)), 0) HZH_GWY , NVL(SUM(DECODE("AA07"."AAA062", '1', DECODE(SUBSTR("AB15"."AAA060", 1, 2), '34', "AB15"."AAB210", 0), '2', DECODE(SUBSTR("AB15"."AAA060", 1, 2), '34', "AB15"."AAB210", 0), 0)), 0) HZH_QYBC , NVL(SUM(DECODE("AA07"."AAA062", '0', DECODE(SUBSTR("AB15"."AAA060", 1, 2), '35', 0, '37', 0, '32', 0, '34', 0, "AB15"."AAB210"), 0) ), 0) HTC , NVL(SUM(DECODE("AA07"."AAA062", '0', DECODE(SUBSTR("AB15"."AAA060", 1, 2), '34', "AB15"."AAB210", 0), 0)), 0) HTC_BC , NVL(SUM(DECODE("AA07"."AAA062", '0', DECODE(SUBSTR("AB15"."AAA060", 1, 2), '32', "AB15"."AAB210", 0), 0)), 0) HTC_GWY , NVL(SUM(DECODE(SUBSTR("AB15"."AAA060", 1, 2), '35', "AB15"."AAB210", 0) ), 0) DBJZ, NVL(SUM(DECODE(SUBSTR("AB15"."AAA060", 1, 2), '37', "AB15"."AAB210", 0) ), 0) LXCYR, MAX(TO_CHAR("AB15"."AAE036", 'YYYYMMDD')) JBRQ FROM "AB01", "AB15", "AA07" WHERE "AB15"."AAA060" = "AA07"."AAA060" AND "AB15"."AAB001" = "AB01"."AAB001" AND SUBSTR("AB15"."AAA060", 1, 1) = '3' AND "AB01"."AAB019" <> '71' AND ( ( TO_CHAR(AB15.AAE036, 'YYYYMMDD') >= '20140224' ) ) AND ( ( TO_CHAR(AB15.AAE036, 'YYYYMMDD') <= '20140226' ) ) AND ( ( AB15.AAE011 = '???' ) ) and exists (select 1 from t_Person_Deptgroup tpd, t_Deptgroup_Privilege tdp where ( tpd.deptgroup_id = tdp.deptgroup_id ) and ( tdp.aab001 = ab01. aab001 ) and ( tpd.operator_id = 86) ) GROUP BY "AB01"."AAB001", "AB01"."AAB004", "AB15"."AAE002", "AB15"."AAB001"
7bd0q7y3xasu8	UPDATE KC04 SET CKC043 = NVL(CKC043, 0) + :B37 , AKC086 = NVL(AKC086, 0) + :B38 , AKC087 = NVL(AKC087, 0) - :B37 , AKC088 = NVL(AKC088, 0) + :B36 , ZKC022 = NVL(ZKC022, 0) + :B35 , ZKC026 = NVL(ZKC026, 0) + :B34 , ZKC029 = NVL(ZKC029, 0) + :B33 , BKC090 = NVL(BKC090, 0) + :B32 , AKC089 = NVL(AKC089, 0) + :B31 , AKC090 = NVL(AKC090, 0) + :B30 , BKC098 = NVL(BKC098, 0) + :B29 , BKC100 = NVL(BKC100, 0) + :B28 , AKC091 = NVL(AKC091, 0) + :B27 , BKC079 = NVL(BKC079, 0) + :B26 , AKC092 = NVL(AKC092, 0) + :B25 , BKC092 = NVL(BKC092, 0) + :B24 , BKC078 = NVL(BKC078, 0) + :B23 , BKC093 = NVL(BKC093, 0) + :B22 , BKC094 = NVL(BKC094, 0) + :B21 , BKC077 = NVL(BKC077, 0) + :B20 , BKC095 = NVL(BKC095, 0) + :B19 , BKC071 = NVL(BKC071, 0) + :B18 , BKC072 = NVL(BKC072, 0) + :B17 , BKC073 = NVL(BKC073, 0) + :B16 , ZKC023 = NVL(ZKC023, 0) + :B15 , BKC097 = NVL(BKC097, 0) + :B14 , BKC076 = NVL(BKC076, 0) + :B13 , AKC094 = NVL(:B12 , 0), AKC093 = NVL(AKC093, 0) + :B11 , AKC253 = NVL(AKC253, 0) + :B10 , AKC228 = NVL(AKC228, 0) + :B9 , BKC091 = NVL(BKC091, 0) + :B8 , BKC096 = NVL(BKC096, 0) + :B7 , AKC259 = NVL(AKC259, 0) + :B6 , AKC095 = SYSDATE, CKC193 = NVL(CKC193, 0) + :B5 , CKC194 = NVL(CKC194, 0) + :B4 , BKC193 = NVL(BKC193, 0) + :B3 WHERE AAC001 = :B2 AND AAE001 = :B1
7g1cm9yftvsgh	BEGIN pkg_a_FeeAssign.prc_a_FeeAssign( '1' , '10000008' , '201401' , '41' , 201402171120449734 , '???' , PRM_ASSIGNSEQ=>:PRM_ASSIGNSEQ, PRM_APPCODE=>:PRM_APPCODE, PRM_ERRORMSG=>:PRM_ERRORMSG); END;
7htvftwf56092	SELECT "AA10"."AAA102", "AA10"."AAA103" FROM "AA10" WHERE "AA10"."AAA100" = 'AAC008' ORDER BY TO_NUMBER ( "AA10"."AAA102" )
7pthacyk8fpx8	Select to_char ( sysdate , :1 ) From dual
7qn1bq3t291p5	SELECT clientid, serverid, filename, direction, filepath, TASKNAME, fmd5, exptime, filecontent, lastexptime, NULL, rowsnum, dealtimes, dealtime, NULL, bzinfo from translog where SERVERID='001' and clientid='001' and DIRECTION<>'0' and EXPTIME>to_date('20140225200206', 'yyyymmddhh24miss') and (taskname<'Task1200' or taskname in('Task1205', 'Task1209')) order by exptime
7zq8vpcypuvt2	SELECT "AB01"."AAB004", "AC01"."AAC002", "AC01"."AAC003", "AC13"."AAC008", NVL("AC01"."AAC021", '0'), "AC01"."AKC020", "AC13"."AAC001", "AC13"."AAB001", MAX("AC13"."BAC121") AJC020, MAX("AC13"."BAC121") AAC040, "AC13"."AAE143", NVL(SUM(DECODE("AC13"."BAA082", '11', DECODE(substr("AC13"."BAA063", 1, 2), '21', NVL("AC13"."AAC123", 0), 0), '21', DECODE(substr("AC13"."BAA063", 1, 2), '21', NVL("AC13"."AAC123", 0), 0), 0)), 0) GRYJ, NVL(SUM(DECODE("AC13"."BAA082", '12', DECODE(substr("AC13"."BAA063", 1, 2), '21', NVL("AC13"."AAC123", 0), 0), '22', DECODE(substr("AC13"."BAA063", 1, 2), '21', NVL("AC13"."AAC123", 0), 0), 0)), 0) DWYJ, NVL(SUM(DECODE("AC13"."BAA082", '11', NVL("AC13"."AAC123", 0), '12', NVL("AC13"."AAC123", 0), '21', NVL("AC13"."AAC123", 0), '22', NVL("AC13"."AAC123", 0), 0)), 0) YJHJ FROM "AB01 ", "AC01", "AC13" WHERE ( "AC13"."AAB001" = "AB01"."AAB001" ) AND ( "AC13"."AAC001" = "AC01"."AAC001" ) AND "AC13"."AAE002" = :v_aae002 AND "AC13"."AAB001" = :v_aab001 AND SUBSTR("AC13"."AAE140", 1, 1) = '2' AND "AC13"."BAB221" <> "AC13"."AAE061" and exists (select 1 from t_Person_Deptgroup tpd, t_Deptgroup_Privilege tdp where ( tpd.deptgroup_id = tdp.deptgroup_id ) and ( tdp.aab001 = ab01.aab001 ) and ( tpd.operator_id = 576) ) GROUP BY "AB01"."AAB004", "AC01"."AAC002", "AC01"."AAC003", "AC13"."AAC008", "AC13"."AAE143", "AC01"."AAC021", "AC01"."AKC020", "AC13"."AAC001", "AC13"."AAB001", "AC01"."AKC021" ORDER BY "AC13"."AAE143", "AC01"."AKC021", "AC13"."AAC001"
844r42vb5jnvv	SELECT "AB01"."AAB001", "AB01"."AAB004", "AB15"."AAE002", NVL(SUM(DECODE("AA07"."AAA062", '1', DECODE(SUBSTR("AB15"."AAA060", 1, 2), '35', 0, '37', 0, '32', 0, '34', 0, "AB15"."AAB210"), '2', DECODE(SUBSTR("AB15"."AAA060", 1, 2), '35', 0, '37', 0, '32', 0, '34', 0, "AB15"."AAB210"), 0)), 0) HZH , NVL(SUM(DECODE("AA07"."AAA062", '1', DECODE(SUBSTR("AB15"."AAA060", 1, 2), '32', "AB15"."AAB210", 0), '2', DECODE(SUBSTR("AB15"."AAA060", 1, 2), '32', "AB15"."AAB210", 0), 0)), 0) HZH_GWY , NVL(SUM(DECODE("AA07"."AAA062", '1', DECODE(SUBSTR("AB15"."AAA060", 1, 2), '34', "AB15"."AAB210", 0), '2', DECODE(SUBSTR("AB15"."AAA060", 1, 2), '34', "AB15"."AAB210", 0), 0)), 0) HZH_QYBC , NVL(SUM(DECODE("AA07"."AAA062", '0', DECODE(SUBSTR("AB15"."AAA060", 1, 2), '35', 0, '37', 0, '32', 0, '34', 0, "AB15"."AAB210"), 0) ), 0) HTC , NVL(SUM(DECODE("AA07"."AAA062", '0', DECODE(SUBSTR("AB15"."AAA060", 1, 2), '34', "AB15"."AAB210", 0), 0)), 0) HTC_BC , NVL(SUM(DECODE("AA07"."AAA062", '0', DECODE(SUBSTR("AB15"."AAA060", 1, 2), '32', "AB15"."AAB210", 0), 0)), 0) HTC_GWY , NVL(SUM(DECODE(SUBSTR("AB15"."AAA060", 1, 2), '35', "AB15"."AAB210", 0) ), 0) DBJZ, NVL(SUM(DECODE(SUBSTR("AB15"."AAA060", 1, 2), '37', "AB15"."AAB210", 0) ), 0) LXCYR, MAX(TO_CHAR("AB15"."AAE036", 'YYYYMMDD')) JBRQ FROM "AB01", "AB15", "AA07" WHERE "AB15"."AAA060" = "AA07"."AAA060" AND "AB15"."AAB001" = "AB01"."AAB001" AND SUBSTR("AB15"."AAA060", 1, 1) = '3' AND "AB01"."AAB019" <> '71' AND ( ( TO_CHAR(AB15.AAE036, 'YYYYMMDD') >= '20140217' ) ) AND ( ( TO_CHAR(AB15.AAE036, 'YYYYMMDD') <= '20140226' ) ) AND ( ( AB15.AAE011 = '???' ) ) and exists (select 1 from t_Person_Deptgroup tpd, t_Deptgroup_Privilege tdp where ( tpd.deptgroup_id = tdp.deptgroup_id ) and ( tdp.aab001 = ab01. aab001 ) and ( tpd.operator_id = 209) ) GROUP BY "AB01"."AAB001", "AB01"."AAB004", "AB15"."AAE002", "AB15"."AAB001"
8dx7yx5fzm2au	BEGIN pkg_k_dyjs.PRC_K_HOSBALANCE( '4194' , '4' , '201402' , 1 , 1 , 1 , '??' , PRM_APPCODE=>:PRM_APPCODE, PRM_ERRORMSG=>:PRM_ERRORMSG); END;
8fd0fagwvgtnx	SELECT "AB01"."AAB004", "AC01"."AAC002", "AC01"."AAC003", "AC13"."AAC008", NVL("AC01"."AAC021", '0'), "AC01"."AKC020", "AC13"."AAC001", "AC13"."AAB001", MAX("AC13"."BAC121") ALC001, MAX("AC13"."BAC121") AAC040, "AC13"."AAE143", NVL(SUM(DECODE("AC13"."BAA082", '12', DECODE(substr("AC13"."BAA063", 1, 2), '41', NVL("AC13"."AAC123", 0), 0), '22', DECODE(substr("AC13"."BAA063", 1, 2), '41', NVL("AC13"."AAC123", 0), 0), 0)), 0) DWYJ, NVL(SUM(DECODE("AC13"."BAA082", '11', NVL("AC13"."AAC123", 0), '12', NVL("AC13"."AAC123", 0), '21', NVL("AC13"."AAC123", 0), '22', NVL("AC13"."AAC123", 0), 0)), 0) YJHJ, NVL("AA13"."AAA034", 0) CBFL, NVL("AA14"."AAA035", 0) FDFL FROM "AB01", "AC01", "AC13", "AA13", (SELECT * FROM AA14 WHERE AAB001= :v_aab001 AND "AA14"."AAE041" <= :v_aae002 AND ("AA14 "."AAE042" >= :v_aae002 OR "AA14"."AAE042" IS NULL )) AA14 WHERE ( "AC13"."AAB001" = "AB01"."AAB001" ) AND ( "AC13"."AAC001" = "AC01"."AAC001" ) AND ( "AA13"."AAB044"(+) = NVL("AB01"."AAB321", '1')) AND ( "AA14"."AAB001"(+) = "AB01"."AAB001" ) AND ( "AA14"."AAB044"(+) = NVL("AB01"."AAB321", '1')) AND "AC13"."AAE002" = :v_aae002 AND "AC13"."AAB001" = :v_aab001 AND SUBSTR("AC13"."AAE140", 1, 1) = '4' AND "AC13"."BAB221" <> "AC13"."AAE061" and exists (select 1 from t_Person_Deptgroup tpd, t_Deptgroup_Privilege tdp where ( tpd.deptgroup_id = tdp.deptgroup_id ) and ( tdp.aab001 = ab01.aab001 ) and ( tpd.operator_id = 700) ) GROUP BY "AB01"."AAB004", "AC01"."AAC002", "AC01"."AAC003", "AC13"."AAE143", "AC13"."AAC008", "AC01"."AAC021", "AC01"."AKC020", "AC13"."AAC001", "AC13"."AAB001", "AC01"."AKC021", "AA13"."AAA034", "AA14"."AAA035" ORDER BY "AC13". "AAE143", "AC01"."AKC021", "AC13"."AAC001"
8ut57rx9kdyw1	SELECT * FROM translog WHERE clientid<>'001' and SERVERID='001' and DIRECTION='1' and (flag is null or flag in('-6', '-9')) order by taskname, exptime, clientid
9gwfdkfxzdwa9	SELECT "KC21"."AKB020", "KC21"."AKC190" , "KC21"."AAC001", "KC21"."AKA101", "KC21"."AAB001", "KC21"."AKC021", "KC21"."AKA130", "KC21"."AKC192", "KC21"."AKC199", "KC21"."AKC194", "KC21"."AKC200", "KC21"."AKC256", "KC21"."AAE073", "KC21"."CKC119", "KC21"."AAC003", "KC24"."AKC264", "KC24"."AAE036", "KC21"."AAB001" FROM "KC21", "KC24" WHERE ( "KC24"."AKB020" = "KC21"."AKB020" ) AND ( "KC24"."AKC190" = "KC21"."AKC190" ) AND NVL("KC24"."CKC125", '1') = '1' and to_char(kc24.aae036, 'YYYYMMDD') >= '20130101' and to_char(kc24.aae036, 'YYYYMMDD') <= '20131231'
9mj4974tvhbuy	BEGIN pkg_a_FeeAssign.prc_a_FeeAssign( '1' , '10000107' , '201401' , '41' , 201402171423475947 , '???' , PRM_ASSIGNSEQ=>:PRM_ASSIGNSEQ, PRM_APPCODE=>:PRM_APPCODE, PRM_ERRORMSG=>:PRM_ERRORMSG); END;
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
9xvag2qgd0aky	SELECT "AC13"."AAC001", "AC01"."AAC002", "AC01"."AAC003", "AC13"."AAC008", NVL("AC01"."AAC021", '0'), "AC01"."AKC021", "AC01"."AKC020", "AC13"."AAB001", "AB01"."AAB004", MAX("AC13"."BAC121") AAC040, "AC13"."AAE143", NVL(SUM(DECODE("AC13"."BAA082", '11', DECODE(substr("AC13"."BAA063", 1, 2), '31', NVL("AC13"."AAC123", 0), 0), '21', DECODE(substr("AC13"."BAA063", 1, 2), '31', NVL("AC13"."AAC123", 0), 0), 0)), 0) GRYJ, NVL(SUM(DECODE("AC13"."BAA082", '12', DECODE(substr("AC13"."BAA063", 1, 2), '31', NVL("AC13"."AAC123", 0), 0), '22', DECODE(substr("AC13"."BAA063", 1, 2), '31', NVL("AC13"."AAC123", 0), 0), 0)), 0) DWYJ, NVL(SUM(DECODE(substr("AC13"."BAA063", 1, 2), '35', NVL("AC13"."AAC123", 0))), 0) DABING, NVL(SUM(DECODE(substr("AC13"."BAA063", 1, 2), '32', NVL("AC13"."AAC123", 0))), 0) GONGWU, NVL(SUM(DECODE(substr( "AC13"."BAA063", 1, 2), '34', NVL("AC13"."AAC123", 0))), 0) DIYE, NVL(SUM(DECODE(substr("AC13"."BAA063", 1, 2), '36', NVL("AC13"."AAC123", 0))), 0) ZHUYUAN, NVL(SUM(DECODE("AC13"."BAA082", '11', NVL("AC13"."AAC123", 0), '12', NVL("AC13"."AAC123", 0), '21', NVL("AC13"."AAC123", 0), '22', NVL("AC13"."AAC123", 0), 0)), 0) YJHJ FROM "AB01", "AC01", "AC13" WHERE ( "AC13"."AAB001" = "AB01"."AAB001" ) AND ( "AC13"."AAC001" = "AC01"."AAC001" ) AND "AC13"."AAE002" = :v_aae002 AND "AC13"."AAB001" = :v_aab001 AND SUBSTR("AC13"."AAE140", 1, 1) = '3' AND "AC13"."BAB221" <> "AC13"."AAE061" GROUP BY "AB01"."AAB004", "AC01"."AAC002", "AC01"."AAC003", "AC13"."AAC008", "AC13"."AAE143", "AC01"."AAC021", "AC01"."AKC020", "AC13"."AAC001", "AC13"."AAB001", "AC01"."AKC021" ORDER BY "AC13"."AAE143", "AC01"."AKC021", "AC13"."AAC001"
9zpp7hr5grhqc	SELECT * from dqsi.k_card
9zqwh97gbx3vq	SELECT model_id , model_name , toolbar , tool_space , menu_level FROM t_model_list WHERE subsys_id =:1 And menu_level =Substr ( :2 , 1 , Instr ( :3 , ', ' , - 1 , 1 ) - 1 )
a1729qdwkdwzx	SELECT "T_MODEL_LIST"."MODEL_ID", "T_MODEL_LIST"."SUBSYS_ID", "T_MODEL_LIST"."MENU_LEVEL", "T_MODEL_LIST"."MODEL_NAME", "T_MODEL_LIST"."WIN_NAME", "T_MODEL_LIST"."WIN_TYPE", "T_MODEL_LIST"."TOOLBAR", "T_MODEL_LIST"."TOOL_SPACE", "T_MODEL_LIST"."PARAMETER", TO_CHAR("SUBSYS_ID") || ', ' || "T_MODEL_LIST"."MENU_LEVEL" LV1 FROM "T_MODEL_LIST" WHERE ( INSTR("T_MODEL_LIST"."MENU_LEVEL", ', ', 1, 1) = 0 ) AND ( "T_MODEL_LIST"."MODEL_NAME" <> '-' ) AND ( "MENU_LEVEL", "SUBSYS_ID") IN ( SELECT DECODE(INSTR("MENU_LEVEL", ', ', 1, 1), 0, "MENU_LEVEL", SUBSTR("MENU_LEVEL", 1, INSTR("MENU_LEVEL", ', ', 1, 1) - 1) ), "SUBSYS_ID" FROM "T_MODEL_LIST" WHERE "MODEL_ID" IN ( SELECT "T_MODEL_LIST"."MODEL_ID" FROM "T_MODEL_LIST", "T_OPERATORINFO" WHERE "T_OPERATORINFO"."OPERATOR_ID" = :ai_operator_id AND "T_OPERATORINFO"."SYS_FLAT" <= 0 UNION SELECT "T_PERSON_PRIVILEGE". "MODEL_ID" FROM "T_PERSON_PRIVILEGE" WHERE "T_PERSON_PRIVILEGE"."OPERATOR_ID" = :ai_operator_id ) )
a6u3yjca29nqc	declare m_stmt varchar2(512); begin m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; EXCEPTION WHEN OTHERS THEN NULL; end;
a9q37fwb0615r	SELECT COUNT(AKC190) FROM KC24 WHERE KC24.AKB020 = :B2 AND (TO_CHAR(KC24.AAE036, 'yyyymm') = :B1 ) AND AKA130 IN ('11', '12', '14', '15', '16') AND (KC24.AKC197 = '1' OR KC24.AKC197 = '2' OR KC24.AKC197 IS NULL) AND (KC24.CKC125 = 1 OR KC24.CKC125 IS NULL) AND KC24.BAA084 = '3A'
abd2n9vw82yca	SELECT AAC001, AAE140, SUM(FEESTATE) MONTHS FROM ( SELECT /*+rule*/ AAC001, AAE140, DECODE(AAE114, '0', 1, 0) FEESTATE FROM AC13 WHERE AAB001 = :B1 AND AAE143 = '14' ) GROUP BY AAC001, AAE140
abyd6k2498443	SELECT "AC01"."AAC001" , "AC01"."AAC003" , "AC01"."AAC002" FROM "AC01"
assyzvpgbhw4j	SELECT * FROM KC04 WHERE AAC001 = :B1 AND AAE001 = (SELECT MAX(AAE001) FROM KC04 WHERE AAC001 = :B1 )
b5jta3mfr3u8h	SELECT clientid, serverid, filename, direction, filepath, TASKNAME, fmd5, exptime, filecontent, lastexptime, NULL, rowsnum, dealtimes, dealtime, NULL, bzinfo from translog where SERVERID='001' and clientid='001' and DIRECTION<>'0' and EXPTIME>to_date('20140224200202', 'yyyymmddhh24miss') and (taskname<'Task1200' or taskname in('Task1205', 'Task1209')) order by exptime
b660fz21rwb6k	BEGIN pkg_K_ZHGL.prc_K_AccountPlRush( PRM_APPCODE=>:PRM_APPCODE, PRM_ERRORMSG=>:PRM_ERRORMSG); END;
cdfwh3rmvbsx0	BEGIN pkg_a_FeeAssign.prc_a_FeeAssign( '1' , '10000110' , '201401' , '41' , 201402171423475951 , '???' , PRM_ASSIGNSEQ=>:PRM_ASSIGNSEQ, PRM_APPCODE=>:PRM_APPCODE, PRM_ERRORMSG=>:PRM_ERRORMSG); END;
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
crjzgsf55ww78	SELECT SUM(COUNT(DISTINCT AAC001)) FROM KC24 WHERE KC24.AKB020 = :B2 AND (TO_CHAR(KC24.AAE036, 'yyyymm') = :B1 ) AND AKA130 IN ('11', '12', '14', '15', '16') AND (KC24.AKC197 = '1' OR KC24.AKC197 = '2' OR KC24.AKC197 IS NULL) AND (KC24.CKC125 = 1 OR KC24.CKC125 IS NULL) AND KC24.BAA084 <> '38' AND KC24.BAA084 <> '3A' GROUP BY TO_CHAR(KC24.AAE036, 'yyyymmdd')
crp7fnx8698qm	UPDATE KC24 SET AKC267 = '0' WHERE AKC267 IS NULL
cvn54b7yz0s8u	select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
cvxtu92gsgfpg	SELECT COUNT(AKC190) FROM KC24 WHERE KC24.AKB020 = :B2 AND (TO_CHAR(KC24.AAE036, 'yyyymm') = :B1 ) AND AKA130 IN ('11', '12', '14', '15', '16') AND (KC24.AKC197 = '1' OR KC24.AKC197 = '2' OR KC24.AKC197 IS NULL) AND (KC24.CKC125 = 1 OR KC24.CKC125 IS NULL) AND KC24.BAA084 <> '38' AND KC24.BAA084 <> '3A'
cxqf9x0kj2a09	UPDATE AC13 SET AAE114 = :B9 , ZAC005 = '1', AAE067 = :B8 , AAB191 = NVL(:B7 , SYSDATE) WHERE AAB001 = :B6 AND AAE002 = :B5 AND AAA060 = :B4 AND BAB221 = :B3 AND AAE143 = :B2 AND BAA082 = :B1 AND (AAE114 = '0' OR AAE114 = '2' OR AAE114 = '5')
cyzy0avs72fyg	SELECT COUNT(1) FROM AB08 WHERE AAB001 = :B1 AND NVL(AAB166, '0') = '0' AND NVL(BAB205, '0') = '0' AND NVL(BAA093, '0') = '1'
d09qz97n1t67c	SELECT COUNT(AKC190) FROM KC24 WHERE KC24.AKB020 = :B2 AND (TO_CHAR(KC24.AAE036, 'yyyymm') = :B1 ) AND AKA130 = '13' AND (KC24.AKC197 = '1' OR KC24.AKC197 = '2' OR KC24.AKC197 IS NULL) AND (KC24.CKC125 = 1 OR KC24.CKC125 IS NULL) AND KC24.BAA084 <> '38' AND KC24.BAA084 <> '3A'
d139ntmzymmjn	SELECT "AB01"."AAB004", "AC01"."AAC003", "AC01"."AAC001", nvl("IC02"."AIC040", 0.00) ic02_aic040, nvl("IC02"."AIC041", 0.00) ic02_aic041, nvl("IC02"."AIC043", 0.00) ic02_aic043, nvl("IC02"."AIC044", 0.00) ic02_aic044, nvl("IC02"."AIC058", 0.00) ic02_aic058, nvl("IC02"."AIC059", 0.00) ic02_aic059, nvl("IC02"."AIC072", 0.00) ic02_aic072, nvl("IC02"."AIC073", 0.00) ic02_aic073, nvl("IC02"."AIC074", 0.00) ic02_aic074, nvl("IC02"."AIC075", 0.00) ic02_aic075, nvl("IC02"."AIC076", 0.00) ic02_aic076, nvl("IC02"."AIC077", 0.00) ic02_aic077, nvl("IC02"."ZIC041", 0.00) ic02_zic041, nvl("IC02"."ZIC042", 0.00) ic02_zic042, nvl("IC02"."ZIC043", 0.00) ic02_zic043, nvl("IC02"."ZIC044", 0.00) ic02_zic044, nvl("IC02"."ZIC047", 0.00) ic02_zic047, nvl("IC02"."ZIC048", 0.00) ic02_zic048, nvl( "IC02"."ZIC049", 0.00) ic02_zic049, nvl("IC02"."ZIC050", 0.00) ic02_zic050, nvl("IC02"."ZIC045", 0.00) ic02_zic045, nvl("IC02"."ZIC046", 0.00) ic02_zic046, nvl("IC02"."ZIC051", 0.00) ic02_zic051, nvl("IC02"."ZIC052", 0.00) ic02_zic052, "IC02"."AIC080", "AB01"."AAB001", nvl((select nvl(aac100, 0.00) + nvl(aac128, 0.00) + nvl(aac129, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '01') ), 0.00) g_1, nvl((select nvl(bab137, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '01') ), 0.00) d_1, nvl((select nvl(aac100, 0.00) + nvl(aac128, 0.00) + nvl(aac129, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '02') ), 0.00) g_2, nvl((select nvl(bab137, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '02') ), 0.00) d_2, nvl((select nvl(aac100, 0.00) + nvl(aac128, 0.00) + nvl(aac129, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '03') ), 0.00) g_3, nvl((select nvl(bab137, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '03') ), 0.00) d_3, nvl((select nvl(aac100, 0.00) + nvl(aac128, 0.00) + nvl(aac129, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '04') ), 0.00) g_4, nvl((select nvl(bab137, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '04') ), 0.00) d_4, nvl((select nvl(aac100, 0.00) + nvl(aac128, 0.00) + nvl(aac129, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '05') ), 0.00) g_5, nvl((select nvl(bab137, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '05') ), 0.00) d_5, nvl((select nvl(aac100, 0.00) + nvl(aac128, 0.00) + nvl(aac129, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '06') ), 0.00) g_6, nvl((select nvl(bab137, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '06') ), 0.00) d_6, nvl((select nvl(aac100, 0.00) + nvl(aac128, 0.00) + nvl(aac129, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '07') ), 0.00) g_7, nvl((select nvl(bab137, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '07') ), 0.00) d_7, nvl((select nvl(aac100, 0.00) + nvl(aac128, 0.00) + nvl(aac129, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '08') ), 0.00) g_8 , nvl((select nvl(bab137, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '08') ), 0.00) d_8, nvl((select nvl(aac100, 0.00) + nvl(aac128, 0.00) + nvl(aac129, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '09') ), 0.00) g_9, nvl((select nvl(bab137, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '09') ), 0.00) d_9, nvl((select nvl(aac100, 0.00) + nvl(aac128, 0.00) + nvl(aac129, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '10') ), 0.00) g_10, nvl((select nvl(bab137, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '10') ), 0.00) d_10, nvl((select nvl(aac100, 0.00) + nvl(aac128, 0.00) + nvl(aac129, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '11') ), 0.00) g_11, nvl((select nvl(bab137, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '11') ), 0.00) d_11, nvl((select nvl(aac100, 0.00) + nvl(aac128, 0.00) + nvl(aac129, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '12') ), 0.00) g_12, nvl((select nvl(bab137, 0.00) from ic01 where aac001 = "IC02"."AAC001" and aae003 = (:as_aae001 || '12') ), 0.00) d_12, nvl((select sum(nvl(b.aic044, 0 .00)) + sum(nvl(b.aic072, 0.00)) + sum(nvl(b.zic043, 0.00)) + sum(nvl(b.zic044, 0.00)) + sum(nvl(b.zic047, 0.00)) + sum(nvl(b.zic048, 0.00)) from ic02 b where b.aac001 = "IC02"."AAC001" and b.aae001 > 1995 and b.aae001 <= :as_aae001 ), 0.00) grjf_1, nvl((select sum(nvl(c.aic043, 0.00)) + sum(nvl(c.aic058, 0.00)) from ic02 c where c.aac001 = "IC02"."AAC001" and c.aae001 > 1995 and c.aae001 <= :as_aae001 ), 0.00) dwjf_1 FROM "AB01", "AC01", "AC02", "IC02" WHERE ( "AB01"."AAB001" = "AC01"."AAB001" ) and ( "IC02"."AAC001" = "AC01"."AAC001" ) and ( "AC01"."AAC001" = "AC02"."AAC001" ) and ( "AC02"."AAE140" = '14' ) and ( "AC02"."AAC031" = '1' ) and ( "IC02"."AAE001" = :as_aae001 ) and ( "AB01"."AAB001" like :as_aab001 ) and ( "AC01"."AAC001" like :as_aac001 ) and ( "AC01"."AAC008" = '1')
dcfzn5vttzc8p	SELECT A.* FROM AB13 A, (SELECT AB13.AAE063, AB13.AAB191 FROM AB13 WHERE AB13.AAE064 = :B1 ) B WHERE A.AAB191 < B.AAB191 AND A.AAE063 = B.AAE063
dm7d7f77d9khj	SELECT "T_MODEL_LIST"."MODEL_ID", "T_MODEL_LIST"."SUBSYS_ID", "T_MODEL_LIST"."MENU_LEVEL", "T_MODEL_LIST"."MODEL_NAME", "T_MODEL_LIST"."WIN_NAME", "T_MODEL_LIST"."WIN_TYPE", "T_MODEL_LIST"."TOOLBAR", "T_MODEL_LIST"."TOOL_SPACE", "T_MODEL_LIST"."PARAMETER", TO_CHAR("SUBSYS_ID") || ', ' || SUBSTR("MENU_LEVEL", 1, INSTR("MENU_LEVEL", ', ', 1, 1) - 1) LV1, TO_CHAR("SUBSYS_ID") || ', ' || "T_MODEL_LIST"."MENU_LEVEL" LV2 FROM "T_MODEL_LIST" WHERE ( INSTR("T_MODEL_LIST"."MENU_LEVEL", ', ', 1, 1) > 0 ) AND ( INSTR("T_MODEL_LIST"."MENU_LEVEL", ', ', 1, 2) = 0 ) AND ( "T_MODEL_LIST"."MODEL_NAME" <> '-' ) AND ( "MENU_LEVEL", "SUBSYS_ID") IN ( SELECT DECODE(INSTR("MENU_LEVEL", ', ', 1, 2), 0, "MENU_LEVEL", SUBSTR("MENU_LEVEL", 1, INSTR("MENU_LEVEL", ', ', 1, 2) - 1) ), "SUBSYS_ID" FROM "T_MODEL_LIST" WHERE "MODEL_ID" IN ( SELECT "T_MODEL_LIST"."MODEL_ID" FROM "T_MODEL_LIST", "T_OPERATORINFO" WHERE "T_OPERATORINFO"."OPERATOR_ID" = :ai_operator_id AND "T_OPERATORINFO"."SYS_FLAT" <= 0 UNION SELECT "T_PERSON_PRIVILEGE"."MODEL_ID" FROM "T_PERSON_PRIVILEGE" WHERE "T_PERSON_PRIVILEGE"."OPERATOR_ID" = :ai_operator_id ) )
f5yun5dynkskv	select s.synonym_name as object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
fjznwxgpyzkn3	BEGIN PKG_L_NEW.PRC_L_LC13( PRM_APPCODE=>:PRM_APPCODE, PRM_ERRORMSG=>:PRM_ERRORMSG); END;
fqmpmkfr6pqyk	select s.synonym_name object_name, o.object_type from sys.all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
fr807n73y5jjc	SELECT "AB10"."AAB001", "AB10"."AAE002", "AB10"."AAE063", "AB01"."AAB353", (select aab340 FROM ab52 WHERE aae008 ="AB10"."AAB024") AAB024, "AB10"."AAB025", "AB10"."AAB026", "AB10"."AAB180", '1' zzz001, '' zzz002, sysdate zzz003, to_date('') dzrq, to_number('') sjfje, '' zzz006, "AB10"."AAE142", to_number('') zzz007, to_number('') zzz008, '' zzz009, to_number('') zzz010, to_number('') zzz011, '' flag, '' zzz013 FROM "AB10", "AB01" where ab01.aab001 = ab10.aab001 AND nvl(aae111, '0') <> '1' AND NOT EXISTS( SELECT * FROM ab08 WHERE ab08.aae063 = ab10.aae063 AND EXISTS (SELECT * FROM ac13 WHERE ac13.bab221 = ab08.bab221 AND EXISTS(SELECT * FROM ac10 WHERE ac10.bab221 = ac13.aae061 AND ac10.aae108 = '0' AND ROWNUM = 1 ) AND ROWNUM = 1) AND ROWNUM = 1) AND ( ( ab10.aae142 = '13' ) ) AND ( ( ab10.aae002 = '201403' ) ) ORDER BY "AB10"."AAB00 1"
frdgtrkqnu95h	UPDATE AC13 SET BAC202 = '1', AAB191 = SYSDATE WHERE ROWID = :B1
ft5vj8tp220n5	SELECT DISTINCT A.ALA041, B.AAA103 FROM V_LC04LC05LC06 A, AA10 B WHERE B.AAA102 = A.ALA041 AND B.AAA100='ALA041' AND A.AAC001 = :B1
g07j34ttg68xh	SELECT clientid, serverid, filename, direction, filepath, TASKNAME, fmd5, exptime, filecontent, lastexptime, NULL, rowsnum, dealtimes, dealtime, NULL, bzinfo from translog where SERVERID='001' and clientid='001' and DIRECTION<>'0' and EXPTIME>to_date('20140224200202', 'yyyymmddhh24miss') and (taskname<'Task1200' or taskname in('Task1204', 'Task1208')) order by exptime
g54dcjmyqky4t	SELECT "T_MODEL_LIST"."MODEL_ID", "T_MODEL_LIST"."SUBSYS_ID", "T_MODEL_LIST"."MENU_LEVEL", "T_MODEL_LIST"."MODEL_NAME", "T_MODEL_LIST"."WIN_NAME", "T_MODEL_LIST"."WIN_TYPE", "T_MODEL_LIST"."TOOLBAR", "T_MODEL_LIST"."TOOL_SPACE", "T_MODEL_LIST"."PARAMETER", TO_CHAR("SUBSYS_ID") || ', ' || SUBSTR("MENU_LEVEL", 1, INSTR("MENU_LEVEL", ', ', 1, 1) - 1) LV1, TO_CHAR("SUBSYS_ID") || ', ' || SUBSTR("MENU_LEVEL", 1, INSTR("MENU_LEVEL", ', ', 1, 2) - 1) LV2, TO_CHAR("SUBSYS_ID") || ', ' || "T_MODEL_LIST"."MENU_LEVEL" LV3 FROM "T_MODEL_LIST" WHERE ( INSTR("T_MODEL_LIST"."MENU_LEVEL", ', ', 1, 2) > 0 ) AND ( INSTR("T_MODEL_LIST"."MENU_LEVEL", ', ', 1, 3) = 0 ) AND ( "T_MODEL_LIST"."MODEL_NAME" <> '-' ) AND ( "MENU_LEVEL", "SUBSYS_ID") IN ( SELECT DECODE(INSTR("MENU_LEVEL", ', ', 1, 3), 0, "MENU_LEVEL", SUBSTR("MENU_LEVEL", 1, INSTR("MENU_LEVEL", ', ', 1, 3) - 1) ), "SUBSYS_ID" FROM "T_MODEL_ LIST" WHERE "MODEL_ID" IN ( SELECT "T_MODEL_LIST"."MODEL_ID" FROM "T_MODEL_LIST", "T_OPERATORINFO" WHERE "T_OPERATORINFO"."OPERATOR_ID" = :ai_operator_id AND "T_OPERATORINFO"."SYS_FLAT" <= 0 UNION SELECT "T_PERSON_PRIVILEGE"."MODEL_ID" FROM "T_PERSON_PRIVILEGE" WHERE "T_PERSON_PRIVILEGE"."OPERATOR_ID" = :ai_operator_id ) )
g5y97cx7ut6a5	SELECT "AB10"."AAB001", "AB10"."AAE002", "AB10"."AAE063", "AB01"."AAB353", (select aab340 FROM ab52 WHERE aae008 ="AB10"."AAB024") AAB024, "AB10"."AAB025", "AB10"."AAB026", "AB10"."AAB180", '1' zzz001, '' zzz002, sysdate zzz003, to_date('') dzrq, to_number('') sjfje, '' zzz006, "AB10"."AAE142", to_number('') zzz007, to_number('') zzz008, '' zzz009, to_number('') zzz010, to_number('') zzz011, '' flag, '' zzz013 FROM "AB10", "AB01" where ab01.aab001 = ab10.aab001 AND nvl(aae111, '0') <> '1' AND NOT EXISTS( SELECT * FROM ab08 WHERE ab08.aae063 = ab10.aae063 AND EXISTS (SELECT * FROM ac13 WHERE ac13.bab221 = ab08.bab221 AND EXISTS(SELECT * FROM ac10 WHERE ac10.bab221 = ac13.aae061 AND ac10.aae108 = '0' AND ROWNUM = 1 ) AND ROWNUM = 1) AND ROWNUM = 1) AND ( ( ab10.aae142 = '14' ) ) AND ( ( ab10.aae002 = '201403' ) ) ORDER BY "AB10"."AAB00 1"
gaf80unug6524	Select aab004 From ab01 Where aab001 =:1
gnq6t7z8jaby8	SELECT /*+INDEX(KC24 INDEX_KC24_PAY)*/KC24.AKB020, KC24.AAC001, KC24.AAB001, KC24.AKC190, KC24.AAE072, KC24.CKC130, KC24.AKA130, KC24.AKC021, NVL(KC24.CKC039, 0) CKC039, DECODE(NVL(AKC260, 0), 0, 0, DECODE(NVL(KC24.ZKC024, 0), 0, NVL(KC24.AKC260, 0)-NVL(KC24.ZKC025, 0)-NVL(KC24.ZKC028, 0), DECODE(NVL(KC24.ZKC025, 0)+NVL(KC24.ZKC028, 0), 0, NVL(KC24.AKC260, 0), NVL(KC24.AKC260, 0)-(NVL(KC24.AKC260, 0)+NVL(KC24.AKC257, 0))*0.05))) AKC260, NVL(KC24.AKC261, 0) AKC261, NVL(KC24.AKC265, 0) AKC265, NVL(KC24.ZKC025, 0) ZKC025, NVL(KC24.ZKC028, 0) ZKC028, DECODE(NVL(KC24.ZKC024, 0), 0, 0, DECODE(NVL(AKC260, 0), 0, NVL(KC24.ZKC024, 0)-NVL(KC24.ZKC025, 0)-NVL(KC24.ZKC028, 0), NVL(KC24.ZKC024, 0) + NVL(KC24.AKC260, 0) -NVL(KC24.ZKC025, 0)-NVL(KC24.ZKC028, 0)-DECODE(NVL(KC24.ZKC025, 0)+NVL(KC24.ZKC028, 0), 0, NVL(KC24.AKC260, 0), NVL(KC24.AKC260, 0)-(NVL(KC24.AKC260, 0)+NVL(KC24.AKC257, 0))*0.05))) ZKC024, NVL(KC24.AKC258, 0) AKC258, NVL(KC24.AKC264, 0) AKC264, NVL(KC24.AKC255, 0) AKC255, NVL(KC24.AKC253, 0) AKC253, NVL(KC24.ZKC033, 0)+NVL(KC24.ZKC032, 0) + NVL(KC24.CKC066, 0) ZLZL, NVL(KC24.AKC256, 0) AKC256, KC21.AKC196, TRUNC(KC21.AKC192, 'DD') RYRQ, TRUNC(KC24.AAE040, 'DD') CYRQ, NVL((CASE WHEN INSTR(BAA084, '32') > 0 THEN ROUND(NVL(CKC039, 0)* 0.15, 2) ELSE 0 END), 0) CKC039_GWY, NVL((CASE WHEN INSTR(BAA084, '34') > 0 THEN ROUND(NVL(CKC039, 0)* 0.15, 2) ELSE 0 END), 0) CKC039_QYBC FROM KC24, KC21 WHERE KC24.AKB020 = KC21.AKB020(+) AND KC24.AKC190 = KC21 .AKC190(+) AND KC24.AAC001 = KC21.AAC001(+) AND (KC24.AKC197 <> '0' OR KC24.AKC197 IS NULL ) AND (TO_CHAR(KC24.AAE036, 'yyyymm') = :B2 ) AND NVL(KC21.CKC125, '1') = '1' AND (KC24.CKC125 = 1 OR KC24.CKC125 IS NULL ) AND KC24.CKC130 = '1' AND KC24.AKA130 IN ('11', '14', '15', '16') AND NVL(KC24.AKC264, 0) <> 0 AND NVL(KC24.BAA084, 'X') <> '38' AND NVL(KC24.BAA084, 'X') <> '3A' AND KC24.AKB020 = :B1 AND NOT EXISTS(SELECT 1 FROM KC_HMD WHERE AKB020=KC24.AKB020 AND AAC001=KC24.AAC001 AND AKC190=KC24.AKC190 AND NVL(AAE120, '0')='0')
grwydz59pu6mc	select text from view$ where rowid=:1
gscnsah2jhpj2	BEGIN pkg_a_FeeAssign.prc_a_FeeAssign( '1' , '10000146' , '201401' , '41' , 201402171423485955 , '???' , PRM_ASSIGNSEQ=>:PRM_ASSIGNSEQ, PRM_APPCODE=>:PRM_APPCODE, PRM_ERRORMSG=>:PRM_ERRORMSG); END;

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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