WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
TMSDB	2526487472	tmsdb1	1	31-May-13 18:05	11.2.0.3.0	YES

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
db-waybill-test01	Linux x86 64-bit	128	64	8	504.14

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	1847	05-Jun-13 09:00:09	764	2.1
End Snap:	1848	05-Jun-13 10:00:28	770	1.4
Elapsed:		60.32 (mins)
DB Time:		27,320.69 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	166,912M	166,912M	Std Block Size:	8K
Shared Pool Size:	23,552M	23,552M	Log Buffer:	391,008K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	452.9	0.8	0.02	0.01
DB CPU(s):	31.9	0.1	0.00	0.00
Redo size:	21,285,415.2	35,232.2
Logical reads:	1,760,703.9	2,914.4
Block changes:	95,415.6	157.9
Physical reads:	9,694.9	16.1
Physical writes:	9,655.4	16.0
User calls:	56,660.4	93.8
Parses:	1,881.1	3.1
Hard parses:	6.4	0.0
W/A MB processed:	44.2	0.1
Logons:	0.4	0.0
Executes:	20,808.5	34.4
Rollbacks:	0.5	0.0
Transactions:	604.2

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	99.92
Buffer Hit %:	99.49	In-memory Sort %:	100.00
Library Hit %:	99.89	Soft Parse %:	99.66
Execute to Parse %:	90.96	Latch Hit %:	99.31
Parse CPU to Parse Elapsd %:	82.51	% Non-Parse CPU:	95.30

Shared Pool Statistics

	Begin	End
Memory Usage %:	69.68	69.87
% SQL with executions>1:	92.35	92.55
% Memory for SQL w/exec>1:	96.86	96.97

Top 5 Timed Foreground Events

Host CPU (CPUs: 128 Cores: 64 Sockets: 8)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
116.51	70.94	23.3	2.3	31.5	73.1

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
25.9	96.2	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	516,234.6	516,234.6
SGA use (MB):	193,536.0	193,536.0
PGA use (MB):	6,467.7	6,004.8
% Host Mem used for SGA+PGA:	38.74	38.65

RAC Statistics

	Begin	End
Number of Instances:	1	1

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	0.00	0.00
Global Cache blocks served:	0.00	0.00
GCS/GES messages received:	0.00	0.00
GCS/GES messages sent:	0.00	0.00
DBWR Fusion writes:	0.00	0.00
Estd Interconnect traffic (KB)	0.01

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

Buffer access - local cache %:	99.49
Buffer access - remote cache %:	0.00
Buffer access - disk %:	0.51

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	0.0
Avg global cache current block receive time (ms):	0.0
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 %:	0.0
Avg global cache cr block flush time (ms):
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):

Global Cache and Enqueue Services - Messaging Statistics

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

Cluster Interconnect

• if IP/Public/Source at End snap is different a '*' is displayed

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): 1639241.7s
• 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 99.1% of Total DB time 1,639,241.68 (s)
• Total FG Wait Time: 1,508,803.72 (s) DB CPU time: 115,599.64 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

• s - second, ms - millisecond - 1000th of a second
• Only events with Total Wait Time (s) >= .001 are shown
• ordered by wait time desc, waits desc (idle events last)
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)
• Only events with Total Wait Time (s) >= .001 are shown
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

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

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

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

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by User I/O Wait Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Physical Reads (UnOptimized)
• SQL ordered by Executions
• SQL ordered by Parse Calls
• SQL ordered by Sharable Memory
• SQL ordered by Version Count
• 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 63.6% of Total DB Time (s): 1,639,242
• Captured PL/SQL account for 1.9% of Total DB Time (s): 1,639,242

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 46.8% of Total CPU Time (s): 115,600
• Captured PL/SQL account for 15.7% of Total CPU Time (s): 115,600

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 77.4% of Total User I/O Wait Time (s): 368,064
• Captured PL/SQL account for 3.5% of Total User I/O Wait Time (s): 368,064

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: 6,372,754,928
• Captured SQL account for 57.7% 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: 35,089,970
• Captured SQL account for 32.5% 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: 14,862,623
• Captured SQL account for 45.8% of Total
• Total UnOptimized Read Requests: 14,862,623
• Captured SQL account for 45.8% of Total
• Total Optimized Read Requests: 1
• Captured SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Executions: 75,315,070
• Captured SQL account for 34.2% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 6,808,639
• Captured SQL account for 33.8% 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

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
00zhaygsjgp1a	INSERT INTO TMP_MAIL_IN_MONITOR SELECT /*+ index(i I_IDX_MAIL_MON_ACT_AT1) index(d IDX_SYSDEPT_CODE01) use_nl(i, d) */ MAIL_NO, ACTION_TYPE, PLAN_AGENCY, PLAN_FREQUENCY, PLAN_ACTION_TIME, ACTUAL_AGENCY, ACTUAL_FREQUENCY, ACTUAL_ACTION_TIME, MAIL_BAG_NO, OUT_PROV, OUT_CITY, IN_PROV, IN_CITY, OUT_CUR_PROV, OUT_CUR_CITY, IN_CUR_PROV, IN_CUR_CITY, DLV_STS_CODE FROM TMS_MAIL_MONITOR_INFO I INNER JOIN TBL_SYS_DEPARTMENTS D ON D.DEPT_CODE = I.ACTUAL_AGENCY AND D.PROV_CODE = :B1 WHERE I.DIRECTION = '1' AND I.ACTUAL_ACTION_TIME >= :B3 AND I.ACTUAL_ACTION_TIME < :B2
035gd6psmwnhm	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin p_tms_monitor(sysdate, '35'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
0b8hsct9ntgn1	select p.*, w.road road_val, w.deal_center from tms_work_plan p, tms_work_plan_detail w where p.jid = w.rid and p.isvalid ='1' and p.start_valid_date <=to_date(:1, 'yyyymmddhh24miss') and p.end_valid_date > to_date(:2, 'yyyymmddhh24miss') and p.end_time is not null and substr(p.days, :3, 1) = '1' and w.kind = :4 and w.road in (:5, :6) and p.org_code in (:7, :8) order by w.type asc, n_subtractime(:9, p.end_time), n_subtractime(:10, p.leave_time)
0uyxwj8xs49ww	INSERT /*+ append */ INTO TMP_IN_DELAY_PROV SELECT MAIL_NO, ACTUAL_ACTION_TIME AS ACTION_TIME, '1' AS IN_DELAY_PROV FROM ( SELECT /*+index(i I_MAIL_MONITOR_IDX1)*/T1.MAIL_NO, T1.IN_INHAND_PROV, T1.ACTUAL_ACTION_TIME, CASE WHEN F.DELIVER_BACK_TIME IS NOT NULL AND I.PLAN_ACTION_TIME IS NOT NULL THEN TO_DATE(SUBSTR(I.PLAN_ACTION_TIME, 0, 10) || ' ' || SUBSTR(F.DELIVER_BACK_TIME, 0, 2) || ':' || SUBSTR(F.DELIVER_BACK_TIME, 3, 2), 'yyyy-mm-dd hh24:mi:ss') ELSE TO_DATE(I.PLAN_ACTION_TIME, 'yyyy-mm-dd hh24:mi:ss') END AS END_TIME, ROW_NUMBER() OVER(PARTITION BY I.MAIL_NO ORDER BY I.PLAN_ACTION_TIME DESC) RN FROM TMP_IN_INHAND_PROV T1 LEFT JOIN TMS_MAIL_MONITOR_INFO I ON I.MAIL_NO = T1.MAIL_NO AND I.ACTION_TYPE IN ('R', 'U', '2') LEFT JOIN TMS_DEPT_CODE D ON D.UNIT_CODE = I.PLAN_AGENCY LEFT JOIN TMS_WORK_FREQUENCY F ON F.FREQUENCY_ID = I.PLAN_FREQUENCY WHERE D.UNIT_PATTERN IN ('1', '7')) WHERE RN = 1 AND END_TIME + :B2 / 24 < :B1
1rbw4d2963z30	select * from ( select p.*, w.road road_val, w.deal_center from tms_work_plan p, tms_work_plan_detail w where p.jid = w.rid and p.isvalid ='1' and p.start_valid_date <=to_date(:1, 'yyyymmddhh24miss') and p.end_valid_date > to_date(:2, 'yyyymmddhh24miss') and p.end_time is not null and substr(p.days, :3, 1) = '1' and w.kind = :4 and w.road in (:5, :6, :7) and p.org_code in (:8, :9) order by w.type asc, n_subtractime(:10, p.end_time), n_subtractime(:11, p.leave_time) ) where rownum = 1
219sf1cjht0rf	insert into TMS_MAIL_MONITOR_DETAIL(org, MAIL_NO, PREVIOUS_ORG, NEXT_ORG, ACTION_TYPE, ORG_DATE, ROUTE_CODE, FLY_NO, CUR_PROV, CUR_CITY, PRE_PROV, PRE_CITY, NEXT_PROV, NEXT_CITY, POST_PROV, POST_CITY, DEL_PROV, DEL_CITY) values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18)
2mn1hhpgw9n6g	select * from ( select p.*, w.road road_val, w.deal_center from tms_work_plan p, tms_work_plan_detail w where p.jid = w.rid and p.isvalid ='1' and p.start_valid_date <=to_date(:1, 'yyyymmddhh24miss') and p.end_valid_date > to_date(:2, 'yyyymmddhh24miss') and p.end_time is not null and substr(p.days, :3, 1) = '1' and w.kind = :4 and w.road in (:5, :6) and p.org_code in (:7) order by w.type asc, n_subtractime(:8, p.end_time), n_subtractime(:9, p.leave_time) ) where rownum = 1
4a4kr636txhw4	insert into CP_TMS.TMS_MAIL_MONITOR_INFO (MAIL_NO, ACTION_TYPE, PLAN_AGENCY, PLAN_FREQUENCY, PLAN_ACTION_TIME, ACTUAL_AGENCY, ACTUAL_FREQUENCY, ACTUAL_ACTION_TIME, TRIP_FLIGHTS_CODE, ROUTE_CODE, ACTION_PRESON, ACTION_EXPL, UNUSUAL_RESON, UNUSUAL_STATUT, TIME_DIFF, NEXT_ACTION_TIME_DIFF, ACTION_MARK, MAIL_BAG_NO, MAIL_BAG_LABEL, NEXT_ACTION_CODE, NEXT_ORGCODE, NEXT_FRE, PLAN_FLNO, STD_STARTDATETIME, STD_ENDDATETIME, PLAN_POSTLINE, CURTONTIME_FLAG, ALL_STD_USETIME, ALL_REAL_USETIME, ALLONTIME_FLAG, create_time, NEXT_ORG_TIME, seq, ROUTE_NAME, DIRECTION, LINE_SEQ, ERROR_FLAG, TRIP_FLIGHTS_NAME, display, DLV_STS_CODE, UNDLV_NEXT_ACTN_CODE, PKG_BUSI_KIND_CODE, SEAL_BAG_DATE, SEAL_BAG_TIME, seal_org_code, rcv_org_code, route_seq_num, section_code, table_td_num, dual_freq, route_depart_time, equipmentno, posting_date, posting_prov, out_Prov, out_city, in_Prov, in_city, route_crt_org, route_rcv_org, out_Cur_Prov, out_Cur_city, in_Cur_Prov, in_Cur_city, plan_FreDate, acutal_FreDate, plan_stdfre, acutal_StdFre, update_time, plan_out_Prov, plan_out_city, plan_in_Prov, plan_in_city, ID) values (:1, :2, :3, :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, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74)
4t27szqd8su7p	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin tmp_p_tms_dc_inhand(sysdate, '23'); tmp_p_tms_mail_agency_resolved('23'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
4v7vucd75460f	select * from ( select p.*, w.road road_val, w.deal_center from tms_work_plan p, tms_work_plan_detail w where p.jid = w.rid and p.isvalid ='1' and p.start_valid_date <=to_date(:1, 'yyyymmddhh24miss') and p.end_valid_date > to_date(:2, 'yyyymmddhh24miss') and p.end_time is not null and substr(p.days, :3, 1) = '1' and w.kind = :4 and w.road in (:5, :6, :7) and p.org_code in (:8, :9) order by decode(substr(p.flno, 1, 2), '8Y', 1, 2) asc, w.type asc, n_subtractime(:10, p.end_time), n_subtractime(:11, p.leave_time) ) where rownum = 1
52d582zabvzbx	INSERT /*+ append */ INTO SE_TMP_OUT_MAILNO_BRANCH_SOLVE SELECT * FROM (SELECT MAIL_NO, ACTION_TYPE, ACTUAL_AGENCY, D.UNIT_PATTERN, ACTUAL_ACTION_TIME, MAIL_BAG_NO, ACTUAL_FREQUENCY , ROW_NUMBER() OVER(PARTITION BY MAIL_NO, ACTION_TYPE, ACTUAL_AGENCY, ACTUAL_FREQUENCY ORDER BY A.ACTUAL_ACTION_TIME) RN FROM TMS_MAIL_MONITOR_INFO A INNER JOIN TBL_SYS_DEPARTMENTS B ON A.ACTUAL_AGENCY = B.DEPT_CODE INNER JOIN TMS_DEPT_CODE D ON D.UNIT_CODE = A.ACTUAL_AGENCY WHERE B.PROV_CODE = :B3 AND A.ACTUAL_ACTION_TIME >=:B2 AND A.ACTUAL_ACTION_TIME <:B1 AND D.UNIT_PATTERN IN ('2', '3', '4', '5', '6') AND A.DIRECTION IN ('2') ) WHERE RN = 1
53u3thfh0xtwn	select * from ( select p.*, w.road road_val, w.deal_center from tms_work_plan p, tms_work_plan_detail w where p.jid = w.rid and p.isvalid ='1' and p.start_valid_date <=to_date(:1, 'yyyymmddhh24miss') and p.end_valid_date > to_date(:2, 'yyyymmddhh24miss') and p.end_time is not null and substr(p.days, :3, 1) = '1' and w.kind = :4 and w.road in (:5, :6) and p.org_code in (:7, :8) order by w.type asc, n_subtractime(:9, p.end_time), n_subtractime(:10, p.leave_time) ) where rownum = 1
5bdk3phcf2zdf	select p.*, w.road road_val, w.deal_center from tms_work_plan p, tms_work_plan_detail w where p.jid = w.rid and p.isvalid ='1' and p.start_valid_date <=to_date(:1, 'yyyymmddhh24miss') and p.end_valid_date > to_date(:2, 'yyyymmddhh24miss') and p.end_time is not null and substr(p.days, :3, 1) = '1' and w.kind = :4 and w.road in (:5, :6) and p.org_code in (:7, :8) order by decode(substr(p.flno, 1, 2), '8Y', 1, 2) asc, w.type asc, n_subtractime(:9, p.end_time), n_subtractime(:10, p.leave_time)
5c79nfbw1cuhr	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin tmp_p_tms_mail_agency_out_2(sysdate, '44'); p_tms_mail_agency_out_c(sysdate, '44'); tmp_p_tms_mail_agency_in_2(sysdate, '44'); p_tms_mail_agency_in_c(sysdate, '44'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
5h44yu1d0fbk8	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin tmp_p_tms_dc_inhand(sysdate, '12'); tmp_p_tms_mail_agency_resolved('12'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
5hv67r52zq7dj	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin tmp_p_tms_dc_inhand(sysdate, '32'); tmp_p_tms_mail_agency_resolved('32'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
5j38p9zpjz8ys	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin tmp_p_tms_dc_inhand(sysdate, '44'); tmp_p_tms_mail_agency_resolved('44'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
5xvsq4payjrkw	update tms_mail_monitor_info set RCV_ORG_CODE=:1 , MAIL_BAG_NO=:2 , ROUTE_CRT_ORG=:3 , PLAN_OUT_PROV=:4 , UNUSUAL_STATUT=:5 , POSTING_PROV=:6 , seal_org_code=:7 , SHARE_ORG_CODE=:8 , PKG_BUSI_KIND_CODE=:9 , ROUTE_CODE=:10 , PLAN_STDFRE=:11 , DLV_STS_CODE=:12 , ROUTE_DEPART_TIME=:13 , TRIP_FLIGHTS_NAME=:14 , NEXT_FRE=:15 , EQUIPMENTNO=:16 , POSTING_DATE=:17 , UPDATE_TIME=:18 , UNDLV_NEXT_ACTN_CODE=:19 , PLAN_AGENCY=:20 , PLAN_ACTION_TIME=:21 , ALL_STD_USETIME=:22 , NEXT_ORG_TIME=:23 , DISPLAY=:24 , ERROR_FLAG=:25 , ACTION_TYPE=:26 , OUT_CITY=:27 , NEXT_ACTION_TIME_DIFF=:28 , ACTION_EXPL=:29 , ACTUAL_ACTION_TIME=:30 , PLAN_IN_CITY=:31 , IN_CUR_CITY=:32 , TABLE_TD_NUM=:33 , ROUTE_RCV_ORG=:34 , action_preson=:35 , DUAL_FREQ=:36 , LINE_SEQ=:37 , PLAN_FREDATE=:38 , DIRECTION=:39 , WORK_PLAN_DETAIL=:40 , IN_CITY=:41 , OUT_PROV=:42 , STD_ENDDATETIME=:43 , ACTUAL_FREQUENCY=:44 , PLAN_FREQUENCY=:45 , SHARE_FLAG=:46 , UNUSUAL_RESON=:47 , MAIL_NO=:48 , ALL_REAL_USETIME=:49 , NEXT_ACTION_CODE=:50 , ACTION_MARK=:51 , SEAL_BAG_DATE=:52 , ACUTAL_STDFRE=:53 , MAIL_BAG_LABEL=:54 , ACTUAL_AGENCY=:55 , CURTONTIME_FLAG=:56 , PLAN_POSTLINE=:57 , IN_CUR_PROV=:58 , TRIP_FLIGHTS_CODE=:59 , OUT_CUR_PROV=:60 , TIME_DIFF=:61 , CUR_PROV=:62 , PLAN_FLNO=:63 , ROUTE_NAME=:64 , PLAN_OUT_CITY=:65 , ROUTE_SEQ_NUM=:66 , SEAL_BAG_TIME=:67 , ACUTAL_FREDATE=:68 , SECTION_CODE=:69 , NEXT_ORGCODE=:70 , ALLONTIME_FLAG=:71 , SEQ=:72 , STD_STARTDATETIME=:73 , PLAN_IN_PROV=:74 , OUT_CUR_CITY=:75 , IN_PROV=:76 , WORK_PLAN_ID=:77 where create_time= to_date(:78, 'yyyy-mm-dd hh24:mi:ss') and id=:79
5y4vp545vykxz	select * from tms_route_list t where t.rtid = :1 and t.CREATE_DATE=to_date(:2, 'yyyymmdd') order by t.seq
5y62kgwds4465	INSERT /*+ append */ INTO TMP_OUT_MAILNO_BRANCH_BASE_2 SELECT * FROM (SELECT /*+index(b IDX_SYSDEPT_CODE01) */MAIL_NO, ACTION_TYPE, ACTUAL_AGENCY, D.UNIT_PATTERN, ACTUAL_ACTION_TIME, MAIL_BAG_NO, NVL(ACTUAL_FREQUENCY, 'δ֪') AS ACTUAL_FREQUENCY, A.PLAN_FREDATE, A.ACUTAL_FREDATE , ROW_NUMBER() OVER(PARTITION BY MAIL_NO, ACTION_TYPE, ACTUAL_AGENCY, ACTUAL_FREQUENCY ORDER BY A.ACTUAL_ACTION_TIME) RN FROM TMS_MAIL_MONITOR_INFO A INNER JOIN TBL_SYS_DEPARTMENTS B ON A.ACTUAL_AGENCY = B.DEPT_CODE AND B.PROV_CODE = :B1 INNER JOIN TMS_DEPT_CODE D ON D.UNIT_CODE = B.DEPT_CODE WHERE A.ACUTAL_FREDATE = :B2 AND A.DIRECTION IN ('2') ) WHERE RN = 1
68bpms5rwk2tz	update tms_mail_monitor_info t set t.PLAN_ACTION_TIME=:1, t.PLAN_FREQUENCY=:2 where t.ACTUAL_AGENCY=:3 and t.DIRECTION=:4 and t.MAIL_NO=:5 and t.action_type not in ('R', 'M', 'S', 'U')
68nrvd2tc5g8w	select '23' from dual
6ftvbkhrtzgzv	select '21' from dual
6npvfbcc7b56u	select * from ( select t.*, t.begin_time plan_action_time from TMS_WORK_FREQUENCY t where t.valid_end_time >= :1 and t.VALID_BEGIN_TIME < :2 and t.branch_id = :3 and t.import_export = :4 and t.is_valid = '1' order by n_subtractime(:5, t.begin_time) ) where rownum = 1
6p5f70cs2wkvy	select * from tms_mail_monitor_info t where t.mail_no=:1 and (t.action_type in (:2, :3, :4, :5) or (t.action_type='3' and t.pkg_busi_kind_code='03'))
6wk7k4tqn3jna	select '12' from dual
7d51y2g53rt9t	INSERT INTO TMP_MAIL_OUT_MONITOR SELECT /*+ index(i I_IDX_MAIL_MON_ACT_AT1) index(d IDX_SYSDEPT_CODE01) use_nl(i, d) */ MAIL_NO, ACTION_TYPE, PLAN_AGENCY, PLAN_FREQUENCY, PLAN_ACTION_TIME, ACTUAL_AGENCY, ACTUAL_FREQUENCY, ACTUAL_ACTION_TIME, MAIL_BAG_NO, OUT_PROV, OUT_CITY, IN_PROV, IN_CITY, OUT_CUR_PROV, OUT_CUR_CITY, IN_CUR_PROV, IN_CUR_CITY FROM TMS_MAIL_MONITOR_INFO I INNER JOIN TBL_SYS_DEPARTMENTS D ON D.DEPT_CODE = I.ACTUAL_AGENCY AND D.PROV_CODE = :B1 WHERE I.DIRECTION = '2' AND I.ACTUAL_ACTION_TIME >= :B3 AND I.ACTUAL_ACTION_TIME < :B2
7d7zhvqatg42f	INSERT /*+ append */ INTO SE_TMP_DC_OUT_RESOLVED_PLAN SELECT * FROM (SELECT A.MAIL_NO, A.PLAN_AGENCY, A.PLAN_ACTION_TIME , ROW_NUMBER() OVER(PARTITION BY MAIL_NO, ACTION_TYPE, A.PLAN_AGENCY ORDER BY A.PLAN_ACTION_TIME) RN FROM TMS_MAIL_MONITOR_INFO A INNER JOIN TBL_SYS_DEPARTMENTS B ON A.PLAN_AGENCY = B.DEPT_CODE INNER JOIN TMS_DEPT_CODE D ON D.UNIT_CODE = A.PLAN_AGENCY WHERE B.PROV_CODE = :B3 AND D.UNIT_PATTERN IN ('2', '3', '4', '5', '6') AND A.PLAN_ACTION_TIME IS NOT NULL AND A.ACTION_TYPE IN ('R', 'U') AND A.PLAN_ACTION_TIME >=:B2 AND A.PLAN_ACTION_TIME <:B1 AND A.DIRECTION IN ('2') ) WHERE RN = 1
80j29j1148cyc	select '33' from dual
9has1qruybaqk	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin tmp_p_tms_dc_inhand(sysdate, '42'); tmp_p_tms_mail_agency_resolved('42'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
adfcd02jcf4xc	INSERT /*+append*/ INTO SE_TMP_AGENCY_OUT_BAG_DETAIL(ACTION_AGENCY, QDATE, ACTION_FREQ, BAG, DAY_FLAG, SEAL_BAG, SHIP_BAG) SELECT A.*, CASE WHEN B.SEAL_BAG IS NOT NULL THEN '1' END AS SEAL_BAG, CASE WHEN C.START_BAG IS NOT NULL THEN '1' END AS SHIP_BAG FROM ( SELECT DISTINCT T.ACTION_AGENCY, T.QDATE, T.ACTION_FREQ, T.SEAL_BAG AS BAG, T.SEAL_FLAG AS DAY_FLAG FROM STAT_MAIL_OUT_AGENCY T WHERE T.QDATE = TRUNC(:B2 , 'dd') AND LENGTH(T.SEAL_BAG) > 13 AND T.BELONG_PROV = :B1 UNION SELECT DISTINCT T.ACTION_AGENCY, T.QDATE, T.ACTION_FREQ, T.START_BAG AS BAG, T.START_FLAG AS DAY_FLAG FROM STAT_MAIL_OUT_AGENCY T WHERE T.QDATE = TRUNC(:B2 , 'dd') AND LENGTH(T.START_BAG) > 13 AND T.BELONG_PROV = :B1 ) A LEFT JOIN (SELECT DISTINCT T.ACTION_AGENCY, T.QDATE, T.ACTION_FREQ, T.SEAL_BAG, T.SEAL_FLAG FROM STAT_MAIL_OUT_AGENCY T WHERE T.QDATE = TRUNC(:B2 , 'dd') AND LENGTH(T.SEAL_BAG) > 13 AND T.BELONG_PROV = :B1 ) B ON B.ACTION_AGENCY = A.ACTION_AGENCY AND B.QDATE = A.QDATE AND NVL(B.ACTION_FREQ, 'δ֪') = NVL(A.ACTION_FREQ, 'δ֪') AND B.SEAL_BAG = A.BAG AND B.SEAL_FLAG = A.DAY_FLAG LEFT JOIN (SELECT DISTINCT T.ACTION_AGENCY, T.QDATE, T.ACTION_FREQ, T.START_BAG, T.START_FLAG FROM STAT_MAIL_OUT_AGENCY T WHERE T.QDATE = TRUNC(:B2 , 'dd') AND LENGTH(T.START_BAG) > 13 AND T.BELONG_PROV = :B1 ) C ON C.ACTION_AGENCY = A.ACTION_AGENCY AND C.QDATE = A.QDATE AND NVL(C.ACTION_FREQ, 'δ֪') = NVL(A.ACTION_FREQ, 'δ֪') AND C.START_BAG = A.BAG AND C.START_FLAG = A.DAY_FLAG
akhnbfhxhyvzc	select f.* from tms_work_frequency f, tms_mail_monitor_info a where a.mail_no=:1 and f.frequency_id = nvl(a.plan_frequency, a.actual_frequency) and ( (a.action_type in ('F', 'E') and a.actual_agency = :2 ) or (a.action_type in ('R', 'U') and a.plan_agency =:3 ) ) and a.direction=f.import_export and a.direction=:4 order by decode(a.action_type, 'F', 1, 'E', 2, 3) asc
apn32dxjjuz4f	select * from ( select p.*, w.road road_val, w.deal_center from tms_work_plan p, tms_work_plan_detail w where p.jid = w.rid and p.isvalid ='1' and p.start_valid_date <=to_date(:1, 'yyyymmddhh24miss') and p.end_valid_date > to_date(:2, 'yyyymmddhh24miss') and p.end_time is not null and substr(p.days, :3, 1) = '1' and w.kind = :4 and w.road in (:5, :6) and p.org_code in (:7) order by decode(substr(p.flno, 1, 2), '8Y', 1, 2) asc, w.type asc, n_subtractime(:8, p.end_time), n_subtractime(:9, p.leave_time) ) where rownum = 1
ayvfafpr53d34	insert into CP_TMS.TMS_MAIL_POSTING_INFO (MAIL_NO, POSTING_ORGCODE, OPERA_TYPE, POSTING_DATE, POSTING_TIME, POSTING_POSTCODE, DEST, ACTUAL_WEIGHT, VOLU_WEIGHT, CHARGB_WEIGHT, BASE_TARIFF, DUE_TARIFF, REAL_TARIFF, NODELIVERED_CODE, TRANSPORT_CODE, SENDER_NAME, SENDER_UNITNAME, SENDER_ADDR, SENDER_CONTACT_TEL, SENDER_LOCATION, SENDER_POSTCODE, RECIPIENT_NAME, RECIPIENT_ADDR, RECIPIENT_CONTACT_TEL, RECIPIENT_UNITNAME, RECIPIENT_LOCATION, RECIPIENT_POSTCODE, SENDER_CODE, PRODUCT_CODE, CATEGORY_CODE, NATURE_CODE, FEEDBACK_MODE_CODE, ARRIVE_TIMELIMIT_CODE, PAYSIDE_CODE, RESPB_CODE, ADTNSVR_CODE, MAILED_SCOPE_CODE, BUSE_CODE, PAYMENT_CODE, LLONG, WWIDE, HHIGH, TAKER_CODE, SALER_CODE, TAKER_NAME, SALER_NAME, RECEIPT_INVOICE_NUM, INSPECTION_SIGNS, AFB_SIGNS, FB_PARAM, INSP_NUM, SFDJ_NUM, YPDJ_NUM, DZZ_NUM, GJBZ, ZPDJBZ, REMARK_CODE, YJQTBZ, DATA_ACQ_CODE, DATA_FROM, PARENT_COMPANY, PAYING_CUSTOMERS_CODE, A_TICKET_PAID_PIECES, BUSINESS_CATEGORY_CODE, OBLIGATE_DIMENSION_CODE, DAILY_DATE, INS_PRE_INCOME_PROPORTION, CLE_FEE_INCOME_PROPORTION, SALE_MEMBER_CODE, CUSTOMER_MANAGER_CODE, DEPARTMENT_CODE, LANSHOU_CODE, LANSHOU_NAME, EFFECTS_ALL_STATE, SPECIAL_MARKETING_CATEGORY, REFUSE_MARK, WIRELESS_TERMINAL, UPLOAD_STAMP, ACCEPT_STAMP, INSERT_TIME, DELIVERY_ORGCODE, DELIVERY_TIME, RCV_ORG_CODE, COMPLETE_WORK_PLAN, FULL, POSTING_prov, mail_kind_code, posting_city, posting_county, rcv_city, rcv_prov, pro_action, cur_action, cur_org_code, cur_action_time, next_action, next_org_code, next_action_time, planRoad_id, start_clc_time, cur_direction, cur_freq, next_freq, next_direction, error_flag, error_action_time, status, ID) values (:1, :2, :3, :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, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108)
b0ht7pk2r9pbg	update tms_mail_monitor_info t set t.PLAN_ACTION_TIME=:1, t.PLAN_FREQUENCY=:2 where id=:3 and create_time= to_date(:4, 'yyyy-mm-dd hh24:mi:ss')
b49u6ur6rng5a	select mailpostin0_.ID as ID, mailpostin0_.MAIL_NO as MAIL_NO, mailpostin0_.POSTING_ORGCODE as POSTING_3_, mailpostin0_.OPERA_TYPE as OPERA_TYPE, mailpostin0_.POSTING_DATE as POSTING_5_, mailpostin0_.POSTING_TIME as POSTING_6_, mailpostin0_.POSTING_POSTCODE as POSTING_7_, mailpostin0_.DEST as DEST, mailpostin0_.ACTUAL_WEIGHT as ACTUAL_W9_, mailpostin0_.VOLU_WEIGHT as VOLU_WE10_, mailpostin0_.CHARGB_WEIGHT as CHARGB_11_, mailpostin0_.BASE_TARIFF as BASE_TA12_, mailpostin0_.DUE_TARIFF as DUE_TARIFF, mailpostin0_.REAL_TARIFF as REAL_TA14_, mailpostin0_.NODELIVERED_CODE as NODELIV15_, mailpostin0_.TRANSPORT_CODE as TRANSPO16_, mailpostin0_.SENDER_NAME as SENDER_17_, mailpostin0_.SENDER_UNITNAME as SENDER_18_, mailpostin0_.SENDER_ADDR as SENDER_19_, mailpostin0_.SENDER_CONTACT_TEL as SENDER_20_, mailpostin0_.SENDER_LOCATION as SENDER_21_, mailpostin0_.SENDER_POSTCODE as SENDER_22_, mailpostin0_.RECIPIENT_NAME as RECIPIE23_, mailpostin0_.RECIPIENT_ADDR as RECIPIE24_, mailpostin0_.RECIPIENT_CONTACT_TEL as RECIPIE25_, mailpostin0_.RECIPIENT_UNITNAME as RECIPIE26_, mailpostin0_.RECIPIENT_LOCATION as RECIPIE27_, mailpostin0_.RECIPIENT_POSTCODE as RECIPIE28_, mailpostin0_.SENDER_CODE as SENDER_29_, mailpostin0_.PRODUCT_CODE as PRODUCT30_, mailpostin0_.CATEGORY_CODE as CATEGOR31_, mailpostin0_.NATURE_CODE as NATURE_32_, mailpostin0_.FEEDBACK_MODE_CODE as FEEDBAC33_, mailpostin0_.ARRIVE_TIMELIMIT_CODE as ARRIVE_34_, mailpostin0_.PAYSIDE_CODE as PAYSIDE35_, mailpostin0_.RESPB_CODE as RESPB_CODE, mailpostin0_.ADTNSVR_CODE as ADTNSVR37_, mailpostin0_.MAILED_SCOPE_CODE as MAILED_38_, mailpostin0_.BUSE_CODE as BUSE_CODE, mailpostin0_.PAYMENT_CODE as PAYMENT40_, mailpostin0_.LLONG as LLONG, mailpostin0_.WWIDE as WWIDE, mailpostin0_.HHIGH as HHIGH, mailpostin0_.TAKER_CODE as TAKER_CODE, mailpostin0_.SALER_CODE as SALER_CODE, mailpostin0_.TAKER_NAME as TAKER_NAME, mailpostin0_.SALER_NAME as SALER_NAME, mailpostin0_.RECEIPT_INVOICE_NUM as RECEIPT48_, mailpostin0_.INSPECTION_SIGNS as INSPECT49_, mailpostin0_.AFB_SIGNS as AFB_SIGNS, mailpostin0_.FB_PARAM as FB_PARAM, mailpostin0_.INSP_NUM as INSP_NUM, mailpostin0_.SFDJ_NUM as SFDJ_NUM, mailpostin0_.YPDJ_NUM as YPDJ_NUM, mailpostin0_.DZZ_NUM as DZZ_NUM, mailpostin0_.GJBZ as GJBZ, mailpostin0_.ZPDJBZ as ZPDJBZ, mailpostin0_.REMARK_CODE as REMARK_58_, mailpostin0_.YJQTBZ as YJQTBZ, mailpostin0_.DATA_ACQ_CODE as DATA_AC60_, mailpostin0_.DATA_FROM as DATA_FROM, mailpostin0_.PARENT_COMPANY as PARENT_62_, mailpostin0_.PAYING_CUSTOMERS_CODE as PAYING_63_, mailpostin0_.A_TICKET_PAID_PIECES as A_TICKE64_, mailpostin0_.BUSINESS_CATEGORY_CODE as BUSINES65_, mailpostin0_.OBLIGATE_DIMENSION_CODE as OBLIGAT66_, mailpostin0_.DAILY_DATE as DAILY_DATE, mailpostin0_.INS_PRE_INCOME_PROPORTION as INS_PRE68_, mailpostin0_.CLE_FEE_INCOME_PROPORTION as CLE_FEE69_, mailpostin0_.SALE_MEMBER_CODE as SALE_ME70_, mailpostin0_.CUSTOMER_MANAGER_CODE as CUSTOME71_, mailpostin0_.DEPARTMENT_CODE as DEPARTM72_, mailpostin0_.LANSHOU_CODE as LANSHOU73_, mailpostin0_.LANSHOU_NAME as LANSHOU74_, mailpostin0_.EFFECTS_ALL_STATE as EFFECTS75_, mailpostin0_.SPECIAL_MARKETING_CATEGORY as SPECIAL76_, mailpostin0_.REFUSE_MARK as REFUSE_77_, mailpostin0_.WIRELESS_TERMINAL as WIRELES78_, mailpostin0_.UPLOAD_STAMP as UPLOAD_79_, mailpostin0_.ACCEPT_STAMP as ACCEPT_80_, mailpostin0_.INSERT_TIME as INSERT_81_, mailpostin0_.DELIVERY_ORGCODE as DELIVER82_, mailpostin0_.DELIVERY_TIME as DELIVER83_, mailpostin0_.RCV_ORG_CODE as RCV_ORG84_, mailpostin0_.COMPLETE_WORK_PLAN as COMPLET85_, mailpostin0_.FULL as FULL, mailpostin0_.POSTING_prov as POSTING87_, mailpostin0_.mail_kind_code as mail_ki88_, mailpostin0_.posting_city as posting89_, mailpostin0_.posting_county as posting90_, mailpostin0_.rcv_city as rcv_city, mailpostin0_.rcv_prov as rcv_prov, mailpostin0_.pro_action as pro_action, mailpostin0_.cur_action as cur_action, mailpostin0_.cur_org_code as cur_org95_, mailpostin0_.cur_action_time as cur_act96_, mailpostin0_.next_action as next_ac97_, mailpostin0_.next_org_code as next_or98_, mailpostin0_.next_action_time as next_ac99_, mailpostin0_.planRoad_id as planRo100_, mailpostin0_.start_clc_time as start_101_, mailpostin0_.cur_direction as cur_di102_, mailpostin0_.cur_freq as cur_freq, mailpostin0_.next_freq as next_freq, mailpostin0_.next_direction as next_d105_, mailpostin0_.error_flag as error_flag, mailpostin0_.error_action_time as error_107_, mailpostin0_.status as status from CP_TMS.TMS_MAIL_POSTING_INFO mailpostin0_ where (mailpostin0_.MAIL_NO=:1 )and(mailpostin0_.POSTING_ORGCODE=:2 )and(mailpostin0_.POSTING_DATE=:3 )
c2yfaf1wt6yfa	select '13' from dual
cxfspv17xb542	insert /*+ append */ into vw_evt_mail_clct(MAIL_PRPTY_CODE, BASIC_FEE, YPDJ_BILLING_MODE, VOL_WEIGHT, CLCT_STAFF_NAME, FEEDBACK_MODE_CODE, SENDER_DEPT_NAME, HEIGHT, ADDI_SERVICE_CODE, PAY_CUST_CODE, RCVER_HOME_AREA_NAME, DENY_FLAG, MAIL_KIND_CODE, ACTUAL_TOTAL_FEE, UP_CORP, APPLY_CHK_FLAG, RCV_ORG_CODE, PROD_CODE, WIDTH, SPECIAL_SALE_TYPE, TIME_LIMIT_CODE, INSURANCE_FEE_RVNU_RATIO, CUST_MANAGER_CODE, TRANS_MODE_CODE, MAIL_REMARK_CODE, SENDER_CONTACT_PHONE, INTER_FLAG, BUSI_TYPE_CODE, INITIATIVE_FEEDBACK_FLAG, RCVER_DEPT_NAME, LOAD_DATE, MAIL_NUM, DLV_AREA_CODE, PAY_SIDE_CODE, REC_AVAIL_FLAG, RESERV_CODE, SETLMT_MODE_CODE, CLCT_BUREAU_POST_CODE, RCVER_POST_CODE, DUTY_CODE, DZZ_NUM, DAILY_REP_DATE, ACTUAL_WEIGHT, MAIL_OTHER_REMARK, LENGTH, SALES_CODE, RCVER_ADDR, YPDJ_FLAG, CLCT_PSEG_NAME, SENDER_CUST_CODE, CLCT_STAFF_CODE, RCPT_INVOICE_NUM, OPERATOR_CODE, CANT_DLV_DEAL_MODE_CODE, DATA_SRC_SYS, APPLY_FEE_RVNU_RATIO, BUSI_KIND_CODE, SENDER_ADDR, CLCT_DATE, CLCT_PSEG_CODE, SENDER_NAME, RCV_AREA, BILLING_WEIGHT, OPERATOR_NAME, CLCT_TIME, RCVER_NAME, ATTACH_LIST_QUAN, SENDER_POST_CODE, PART_KIND_QUAN, SENDER_HOME_AREA_NAME, DEPT_CODE, FEEDBACK_PARA, SHOULD_PAY_TOTAL_FEE, CLCT_BUREAU_ORG_CODE, YPDJ_QUAN, RCVER_CONTACT_PHONE, FULL_NFLIGHT_STS) values (:1, :2, :3, :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, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77)
d1jd55yak2nth	insert into CP_TMS.TMS_MAIL_MONITOR_INFO (MAIL_NO, ACTION_TYPE, PLAN_AGENCY, PLAN_FREQUENCY, PLAN_ACTION_TIME, ACTUAL_AGENCY, ACTUAL_FREQUENCY, ACTUAL_ACTION_TIME, TRIP_FLIGHTS_CODE, ROUTE_CODE, ACTION_PRESON, ACTION_EXPL, UNUSUAL_RESON, UNUSUAL_STATUT, TIME_DIFF, NEXT_ACTION_TIME_DIFF, ACTION_MARK, MAIL_BAG_NO, MAIL_BAG_LABEL, NEXT_ACTION_CODE, NEXT_ORGCODE, NEXT_FRE, PLAN_FLNO, STD_STARTDATETIME, STD_ENDDATETIME, PLAN_POSTLINE, CURTONTIME_FLAG, ALL_STD_USETIME, ALL_REAL_USETIME, ALLONTIME_FLAG, create_time, NEXT_ORG_TIME, seq, ROUTE_NAME, DIRECTION, LINE_SEQ, ERROR_FLAG, TRIP_FLIGHTS_NAME, display, DLV_STS_CODE, UNDLV_NEXT_ACTN_CODE, PKG_BUSI_KIND_CODE, SEAL_BAG_DATE, SEAL_BAG_TIME, seal_org_code, rcv_org_code, route_seq_num, section_code, table_td_num, dual_freq, route_depart_time, equipmentno, posting_date, posting_prov, out_Prov, out_city, in_Prov, in_city, route_crt_org, route_rcv_org, out_Cur_Prov, out_Cur_city, in_Cur_Prov, in_Cur_city, plan_FreDate, acutal_FreDate, plan_stdfre, acutal_StdFre, update_time, plan_out_Prov, plan_out_city, plan_in_Prov, plan_in_city, share_org_code, share_flag, cur_prov, work_plan_id, work_plan_detail, ID) values (:1, :2, :3, :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, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79)
dmgr3nwj7r0tb	select '14' from dual
fdn8kmj35xdvv	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin p_tms_monitor(sysdate, '32'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
fkz6zq0952j45	update tms_mail_posting_info i set i.cur_action=:1, i.cur_org_code=:2, i.cur_action_time=:3, i.cur_direction=:4, i.cur_freq=:5, i.next_action=:6, i.next_org_code=:7, i.next_action_time=:8, i.next_direction=:9, i.next_freq=:10 where i.mail_no=:11 and i.posting_orgcode=:12 and i.posting_date=:13
fptwz34ua4asv	delete tms_mail_monitor_info t where t.id=:1 and t.create_time= to_date(:2, 'yyyy-mm-dd hh24:mi:ss')
fq6uakxwmjw04	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin p_tms_monitor(sysdate, '42'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
fxcng3rxsq3zm	select '15' from dual
fxk341mn57pv6	INSERT /*+ append */ INTO SE_TMP_DC_INHAND_MAIL SELECT * FROM ( SELECT /*+index(a I_IDX_MAIL_MON_ACT_AT1) index(b IDX_SYSDEPT_CODE01) */A.MAIL_NO, A.ACTUAL_AGENCY AS AGENCY, D.UNIT_PATTERN, A.DIRECTION, B.PROV_CODE, B.CITY_CODE, B.COUNTY_CODE, ACTION_TYPE, A.MAIL_BAG_NO, A.ACTUAL_ACTION_TIME AS ACTION_TIME, ROW_NUMBER() OVER(PARTITION BY A.MAIL_NO, A.ACTUAL_AGENCY, DIRECTION, ACTION_TYPE ORDER BY A.ACTUAL_ACTION_TIME) RN, A.SEAL_ORG_CODE, A.ACTION_EXPL, A.ACTION_PRESON FROM TMS_MAIL_MONITOR_INFO A INNER JOIN TBL_SYS_DEPARTMENTS B ON A.ACTUAL_AGENCY=B.DEPT_CODE AND B.PROV_CODE=:B1 INNER JOIN TMS_DEPT_CODE D ON D.UNIT_CODE = B.DEPT_CODE AND D.UNIT_PATTERN IN ('2', '3', '4', '5', '6') WHERE A.ACTUAL_ACTION_TIME>=:B3 AND A.ACTUAL_ACTION_TIME<:B2 AND A.ACTION_TYPE IN ('R', 'U', 'S', 'M')) WHERE RN = 1
g0cy2mrnpx5vz	INSERT /*+ append */ INTO SE_TMP_IN_RESOLVED_DC_ARR SELECT MAIL_NO, ACTUAL_AGENCY, ACTUAL_ACTION_TIME, ACTUAL_FREQUENCY, '1' AS IS_REACH, UNIT_PATTERN FROM ( SELECT B.MAIL_NO, B.ACTUAL_AGENCY, B.ACTUAL_ACTION_TIME, B.ACTUAL_FREQUENCY, A.UNIT_PATTERN, ROW_NUMBER() OVER(PARTITION BY B.MAIL_NO, B.ACTUAL_AGENCY, B.ACTUAL_FREQUENCY ORDER BY B.ACTUAL_ACTION_TIME DESC) RN FROM SE_TMP_IN_RESOLVED_MAIL A INNER JOIN TMS_MAIL_MONITOR_INFO B ON B.MAIL_NO = A.MAIL_NO AND B.ACTUAL_AGENCY = A.AGENCY AND NVL(B.ACTUAL_FREQUENCY, 'δ֪') = A.FREQUENCY WHERE B.ACTION_TYPE IN ('R', 'U') AND A.UNIT_PATTERN IN ('2', '3', '4', '5', '6') AND B.ACTUAL_ACTION_TIME >= :B2 AND B.ACTUAL_ACTION_TIME < :B1 ) WHERE RN = 1
g512jznnsmxad	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin p_tms_monitor(sysdate, '44'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
g61pdxvgp6wgt	update tms_mail_monitor_info set RCV_ORG_CODE=:1 , MAIL_BAG_NO=:2 , ROUTE_CRT_ORG=:3 , PLAN_OUT_PROV=:4 , UNUSUAL_STATUT=:5 , POSTING_PROV=:6 , seal_org_code=:7 , PKG_BUSI_KIND_CODE=:8 , ROUTE_CODE=:9 , PLAN_STDFRE=:10 , DLV_STS_CODE=:11 , ROUTE_DEPART_TIME=:12 , TRIP_FLIGHTS_NAME=:13 , NEXT_FRE=:14 , EQUIPMENTNO=:15 , POSTING_DATE=:16 , UPDATE_TIME=:17 , UNDLV_NEXT_ACTN_CODE=:18 , PLAN_AGENCY=:19 , PLAN_ACTION_TIME=:20 , DISPLAY=:21 , ALL_STD_USETIME=:22 , NEXT_ORG_TIME=:23 , ERROR_FLAG=:24 , ACTION_TYPE=:25 , OUT_CITY=:26 , NEXT_ACTION_TIME_DIFF=:27 , ACTION_EXPL=:28 , ACTUAL_ACTION_TIME=:29 , PLAN_IN_CITY=:30 , IN_CUR_CITY=:31 , TABLE_TD_NUM=:32 , ROUTE_RCV_ORG=:33 , action_preson=:34 , DUAL_FREQ=:35 , LINE_SEQ=:36 , PLAN_FREDATE=:37 , DIRECTION=:38 , IN_CITY=:39 , OUT_PROV=:40 , STD_ENDDATETIME=:41 , ACTUAL_FREQUENCY=:42 , PLAN_FREQUENCY=:43 , UNUSUAL_RESON=:44 , MAIL_NO=:45 , ALL_REAL_USETIME=:46 , NEXT_ACTION_CODE=:47 , ACTION_MARK=:48 , SEAL_BAG_DATE=:49 , ACUTAL_STDFRE=:50 , ACTUAL_AGENCY=:51 , MAIL_BAG_LABEL=:52 , CURTONTIME_FLAG=:53 , PLAN_POSTLINE=:54 , IN_CUR_PROV=:55 , TRIP_FLIGHTS_CODE=:56 , OUT_CUR_PROV=:57 , TIME_DIFF=:58 , PLAN_FLNO=:59 , ROUTE_NAME=:60 , PLAN_OUT_CITY=:61 , ROUTE_SEQ_NUM=:62 , SEAL_BAG_TIME=:63 , SECTION_CODE=:64 , ACUTAL_FREDATE=:65 , NEXT_ORGCODE=:66 , ALLONTIME_FLAG=:67 , SEQ=:68 , STD_STARTDATETIME=:69 , PLAN_IN_PROV=:70 , OUT_CUR_CITY=:71 , IN_PROV=:72 where create_time= to_date(:73, 'yyyy-mm-dd hh24:mi:ss') and id=:74
g7hpn91q7kxzj	select * from ( select p.*, w.road road_val, w.deal_center from tms_work_plan p, tms_work_plan_detail w where p.jid = w.rid and p.isvalid ='1' and p.start_valid_date <=to_date(:1, 'yyyymmddhh24miss') and p.end_valid_date > to_date(:2, 'yyyymmddhh24miss') and p.end_time is not null and substr(p.days, :3, 1) = '1' and w.kind = :4 and w.road in (:5, :6) and p.org_code in (:7, :8, :9, :10) order by w.type asc, n_subtractime(:11, p.end_time), n_subtractime(:12, p.leave_time) ) where rownum = 1
grj2uc6k01mdz	select '11' from dual
gs8ybdmv3r1y2	INSERT /*+append*/ INTO TMP_AGENCY_IN_MONITOR_2 SELECT A.MAIL_NO, A.ACTION_TYPE, A.PLAN_AGENCY, A.PLAN_FREQUENCY, A.PLAN_ACTION_TIME, A.ACTUAL_AGENCY, A.ACTUAL_FREQUENCY, A.ACTUAL_ACTION_TIME, A.MAIL_BAG_NO, A.DLV_STS_CODE, A.PLAN_FREDATE, A.ACUTAL_FREDATE, '1' AS PLAN_OR_ACTUAL FROM TMS_MAIL_MONITOR_INFO A INNER JOIN TBL_SYS_DEPARTMENTS B ON A.ACTUAL_AGENCY=B.DEPT_CODE WHERE B.PROV_CODE=:B2 AND A.ACUTAL_FREDATE=:B1 AND A.DIRECTION='1' UNION ALL SELECT A.MAIL_NO, A.ACTION_TYPE, A.PLAN_AGENCY, A.PLAN_FREQUENCY, A.PLAN_ACTION_TIME, A.ACTUAL_AGENCY, A.ACTUAL_FREQUENCY, A.ACTUAL_ACTION_TIME, A.MAIL_BAG_NO, A.DLV_STS_CODE, A.PLAN_FREDATE, A.ACUTAL_FREDATE, '0' AS PLAN_OR_ACTUAL FROM TMS_MAIL_MONITOR_INFO A INNER JOIN TMS_DEPARTMENTS_FJ B ON A.PLAN_AGENCY=B.DEPT_CODE LEFT JOIN TMS_WORK_FREQUENCY F ON F.BRANCH_ID = A.PLAN_AGENCY AND F.FREQUENCY_ID = A.PLAN_FREQUENCY WHERE B.PROV_CODE=:B2 AND (F.IMPORT_EXPORT IS NULL OR F.IMPORT_EXPORT = '1') AND A.PLAN_FREDATE=:B1 AND A.DIRECTION='1'
gt6uu5c3vwkt0	INSERT /*+ append */ INTO SE_TMP_AGENCY_IN_DC_PLAN_ARR SELECT LZ.MAIL_NO, LZ.PLAN_AGENCY, LZ.PLAN_ACTION_TIME, '1' AS IS_PLAN FROM TMS_MAIL_MONITOR_INFO LZ INNER JOIN TMS_DEPARTMENTS_FJ DP ON LZ.PLAN_AGENCY = DP.DEPT_CODE AND DP.PROV_CODE = :B1 INNER JOIN TMS_DEPT_CODE D ON LZ.PLAN_AGENCY = D.UNIT_CODE AND D.UNIT_PATTERN IN ('2', '3', '4', '5', '6') WHERE LZ.PLAN_FREDATE=:B2 AND LZ.ACTION_TYPE = 'R'
gtp7wyrtyjmsc	select * from ( select p.*, w.road road_val, w.deal_center from tms_work_plan p, tms_work_plan_detail w where p.jid = w.rid and p.isvalid ='1' and p.start_valid_date <=to_date(:1, 'yyyymmddhh24miss') and p.end_valid_date > to_date(:2, 'yyyymmddhh24miss') and p.end_time is not null and substr(p.days, :3, 1) = '1' and w.kind = :4 and w.road in (:5, :6, :7) and p.org_code in (:8) order by w.type asc, n_subtractime(:9, p.end_time), n_subtractime(:10, p.leave_time) ) where rownum = 1
gwna2b13qnqth	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin tmp_p_tms_dc_inhand(sysdate, '35'); tmp_p_tms_mail_agency_resolved('35'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

• Ordered by statistic name