WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
JXDB	568676454	jxdb2	2	19-Dec-13 16:12	11.2.0.1.0	YES

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
JXDB2	AIX-Based Systems (64-bit)	64	32		64.00

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	10247	20-Dec-13 09:00:03	542	8.1
End Snap:	10248	20-Dec-13 10:00:27	554	9.5
Elapsed:		60.40 (mins)
DB Time:		379.64 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	11,392M	11,392M	Std Block Size:	8K
Shared Pool Size:	3,584M	3,584M	Log Buffer:	83,836K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	6.3	0.3	0.00	0.01
DB CPU(s):	2.4	0.1	0.00	0.00
Redo size:	300,454.2	15,413.5
Logical reads:	315,479.0	16,184.3
Block changes:	2,125.4	109.0
Physical reads:	1,409.9	72.3
Physical writes:	217.7	11.2
User calls:	489.5	25.1
Parses:	907.1	46.5
Hard parses:	56.0	2.9
W/A MB processed:	32.7	1.7
Logons:	0.9	0.1
Executes:	1,437.8	73.8
Rollbacks:	0.2	0.0
Transactions:	19.5

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.86	In-memory Sort %:	100.00
Library Hit %:	94.24	Soft Parse %:	93.83
Execute to Parse %:	36.91	Latch Hit %:	98.12
Parse CPU to Parse Elapsd %:	19.15	% Non-Parse CPU:	98.66

Shared Pool Statistics

	Begin	End
Memory Usage %:	69.59	67.08
% SQL with executions>1:	72.29	74.75
% Memory for SQL w/exec>1:	74.24	76.59

Top 5 Timed Foreground Events

Host CPU (CPUs: 64 Cores: 32 Sockets: )

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
4.46	4.38	5.7	0.5	1.0	93.8

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
3.8	60.5	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	65,536.0	65,536.0
SGA use (MB):	15,744.0	15,744.0
PGA use (MB):	2,054.9	2,394.8
% Host Mem used for SGA+PGA:	27.16	27.68

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	46.24	2.37
Global Cache blocks served:	56.16	2.88
GCS/GES messages received:	488.58	25.06
GCS/GES messages sent:	444.61	22.81
DBWR Fusion writes:	9.47	0.49
Estd Interconnect traffic (KB)	1,001.50

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

Buffer access - local cache %:	99.84
Buffer access - remote cache %:	0.01
Buffer access - disk %:	0.14

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	0.7
Avg global cache current block receive time (ms):	1.4
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.1
Avg global cache cr block flush time (ms):	2.9
Avg global cache current block pin time (ms):	0.4
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	7.2
Avg global cache current block flush time (ms):	2.9

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.5
Avg message received queue time (ms):	0.1
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	48.44
% of indirect sent messages:	50.87
% of flow controlled messages:	0.69

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): 22778.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 78.2% of Total DB time 22,778.51 (s)
• Total FG Wait Time: 9,270.01 (s) DB CPU time: 8,534.63 (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 42.3% of Total DB Time (s): 22,779
• Captured PL/SQL account for 31.5% of Total DB Time (s): 22,779

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

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 36.6% of Total User I/O Wait Time (s): 2,831
• Captured PL/SQL account for 31.6% of Total User I/O Wait Time (s): 2,831

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: 1,143,260,315
• Captured SQL account for 20.4% 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: 5,109,343
• Captured SQL account for 8.6% 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: 682,859
• Captured SQL account for 31.4% of Total
• Total UnOptimized Read Requests: 682,859
• Captured SQL account for 31.4% of Total
• Total Optimized Read Requests: 1
• Captured SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

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

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 3,287,357
• Captured SQL account for 65.3% 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): 482
• Captured SQL account for 62.5% of Total

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
07p7znr0jw2w9	SELECT MAX(LISHI_XU_HAO) + 1 FROM HIST.HIS_SHEBEI_DUIDUAN_XINXI WHERE ID = NVL(:B1 , :B2 )
08whqv15ywp65	select column_id from sys.user_tab_columns t where column_name ='ZHUANG_TAI' and table_name ='PEIXIAN_DUANZI'
0t8cx8qa1symp	INSERT INTO TAR_LOUYU_MINGXI_TONGBU (ID, LOUYU_LEIXING, LOUYU_BIANHAO, DANYUAN_HAO, LOUCENG_HAO, FANGJIAN_HAO, CAOZUO_LEIXING, INSERT_TIME, JIERU_FANGSHI) SELECT ID, LOUYU_LEIXING, LOUYU_BIANHAO, DANYUAN_HAO, LOUCENG_HAO, FANGJIAN_HAO, CAOZUO_LEIXING, INSERT_TIME, JIERU_FANGSHI FROM LOUYU_MINGXI_TONGBU WHERE TO_CHAR(INSERT_TIME, 'yy/MM/dd') = TO_CHAR(SYSDATE - 1, 'yy/MM/dd')
0y77mdumzwsgg	select t.id ID, t.qu_ju QU_JU, t.ju_suo JU_SUO from odn_shebei t where t.shebei_dalei_id=320 and t.shebei_bianhao=:1
10gqjk50jds9r	update shebei_duiduan_xinxi set lie=:a, kuai=:b where mokuai_leibie=:c and mokuai_id=:d
1b7wk4n59tm9j	SELECT "Tbl1005"."ÐòºÅ" "Col1072", "Tbl1005"."²Ù×÷·½Ê½" "Col1073", "Tbl1005"."²Ù×÷ʱ¼ä" "Col1074", "Tbl1005"."ONUÉ豸ID" "Col1075", "Tbl1005"."Çø¾Ö" "Col1076", "Tbl1005"."¶Ë¾Ö" "Col1077", "Tbl1005"."¾ÖËù" "Col1078", "Tbl1005"."ONU²Û·" "Col1079", "Tbl1005"."ONU°å¿¨ÀàÐÍ×Öµä" "Col1080", "Tbl1005"."ONU_MAC" "Col1081", "Tbl1005"."ONU¹ÜÀíIP" "Col1082", "Tbl1005"."ONU_IAD_IP" "Col1083", "Tbl1005"."IAD_IPÑÚÂë" "Col1084", "Tbl1005"."IAD_IPÍø¹Ø" "Col1085", "Tbl1005"."NGN_VLAN" "Col1086", "Tbl1005"."MGCÖ÷IP" "Col1087", "Tbl1005"."MGC±¸IP" "Col1088", "Tbl1005"."ONUÀàÐÍ×Öµä" "Col1089", "Tbl1005"."GEPON±êʶ" "Col1090", "Tbl1005"."ONUÎïÀíλÖÃ" "Col1091", "Tbl1005"."ONUСÇø" "Col1092", "Tbl1005"."ONUÊÚȨºÅ" "Col1093", "Tbl1005"."ONU´¦Àí״̬" "Col1094", "Tbl1005"."OLTÍøÔªID" "Col1095", "Tbl1005"."PON²Û·" "Col1096 ", "Tbl1005"."PON¶Ë¿ÚºÅ" "Col1097", "Tbl1005"."³§¼Ò×Öµä" "Col1098", "Tbl1005"."½ÓÈ뷽ʽ" "Col1070" FROM "GXKF"."GTS_ONU_ZENGLIANG" "Tbl1005" WHERE "Tbl1005"."ÐòºÅ">:1 ORDER BY "Col1072" ASC
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1qn3qrh8bm3yu	SELECT MAX(LISHI_XU_HAO) + 1 FROM HIST.HIS_SHEBEI_FUWU_FANWEI WHERE ID = NVL(:B1 , :B2 )
1t2v45vps529m	SELECT MAX(LISHI_XU_HAO) + 1 FROM HIST.HIS_YONGHU_LUYOU_XIANGQING WHERE ID = NVL(:B1 , :B2 )
1tb1g3tg7hcc2	INSERT INTO HIST.HIS_SHEBEI_DUIDUAN_XINXI VALUES (HIST.SEH_SHEBEI_DUIDUAN_XINXI.NEXTVAL, :B32 , 1, :B31 , SYSDATE, :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , :B11 , :B12 , :B13 , :B14 , :B15 , :B16 , :B17 , :B18 , :B19 , :B20 , :B21 , :B22 , :B23 , :B24 , :B25 , :B26 , :B27 , :B28 , :B29 , :B30 )
1vdp9m4rzj3jd	SELECT COUNT(ID) FROM DIAODU_LUYOU T WHERE T.ZHUANXIAN_HAO=:B1 OR SUBSTR(T.ZHUANXIAN_HAO, 1, INSTR(T.ZHUANXIAN_HAO, '@')-1)=:B1
26sxq1jnv95zc	DELETE XINJIU_HAOMA_GUANLIAN T WHERE (T.YUAN_HAOMA=:B2 OR T.XIN_HAOMA=:B2 OR T.YONGHU_ID=:B1 ) AND T.SHIFOU_YIJUNGONG=1
2a92pvxutd36s	select column_id from sys.user_tab_columns t where column_name ='JUSUO_MINGCHENG' and table_name ='JU_SUO'
2d08kbbqr88xb	SELECT NAME, 1 SHAPE, OBJECTID, ƽ·¿Çø.SHAPE.points, ƽ·¿Çø.SHAPE.numpts, ƽ·¿Çø.SHAPE.entity, ƽ·¿Çø.SHAPE.minx, ƽ·¿Çø.SHAPE.miny, ƽ·¿Çø.SHAPE.maxx, ƽ·¿Çø.SHAPE.maxy, ƽ·¿Çø.rowid FROM SDE.ƽ·¿Çø ƽ·¿Çø WHERE SDE.ST_EnvIntersects(ƽ·¿Çø.SHAPE, :1, :2, :3, :4) = 1
35jr1pzxchjqu	INSERT INTO HAOMA_SHIGONG_XIAOZU (ID, ORDER_ID, SI_EXTERNAL_TYPE_ID, NUMBER_SUB_TYPE, FUWU_HAOMA, HAOMA_BIAOSHI, CANCEL_FLAG, SHIGONG_XIAOZU, CAOZUO_SHIJIAN, APPLY_ID) SELECT A.ID, A.ORDER_ID, A.SI_EXTERNAL_TYPE_ID, A.NUMBER_SUB_TYPE, A.FUWU_HAOMA, A.HAOMA_BIAOSHI, A.CANCEL_FLAG, A.SHIGONG_XIAOZU, A.CAOZUO_SHIJIAN, A.APPLY_ID FROM HAOMA_SHIGONG_XIAOZU@JXGL2CSM A, HAOMA_SHIGONG_XIAOZU B WHERE B.ID(+) = A.ID AND B.ID IS NULL
3bkw7vfztv6rj	call all_route1.p_baojunEditLuyou(:1, :2, :3)
3bvrdy93md1hn	/* update com.surekam.yupanyuzhan.model.ShebeiFuwuFanwei */ update SHEBEI_FUWU_FANWEI set SHEBEI_DALEI_ID=:1, SHEBEI_ID=:2, XIAOQU_BIANMA=:3, LOUYU_MINGXI_ID=:4, CAOZUO_YUAN=:5, CAOZUO_SHIJIAN=:6, CHUANGJIANREN=:7, CHUANGJIAN_SHIJIAN=:8 where ID=:9
3d26r40vjx2y9	select zhuang_tai from peixian_duanzi where id=:a
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3nkd3g3ju5ph1	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
3z3049ntubzaa	/* insert com.surekam.yupanyuzhan.model.ShebeiFuwuFanwei */ insert into SHEBEI_FUWU_FANWEI (SHEBEI_DALEI_ID, SHEBEI_ID, XIAOQU_BIANMA, LOUYU_MINGXI_ID, CAOZUO_YUAN, CAOZUO_SHIJIAN, CHUANGJIANREN, CHUANGJIAN_SHIJIAN, ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9)
4ca3j1b5v8up0	BEGIN peixian_gejie.p_xiugai_luyou(:1, :2, :3); END;
4huxx3zrqx8ab	SELECT YH.ID, YH.FUWU_LEIXING_ID, PRMTOOLS.F_QUERYBYID('fuwu_leixing', YH.FUWU_LEIXING_ID, 'fuwu_leixing') FUWU_LEIXING_ID_NAME, KH.KEHU_MINGCHENG, YH.YONGHU_MINGCHENG, YH.YONGHU_DIZHI, YH.ZHUANGJI_REN, YH.ANZHUANG_RIQI, YHSX.HUAJI_XINGHAO, KH.KEHU_LEIXING, PRMTOOLS.F_QUERYBYID('t_ci_cust_type', KH.KEHU_LEIXING, 'cust_type_desc') KEHU_LEIXING_NAME, KH.KEHU_DENGJI, PRMTOOLS.F_QUERYBYID('t_ci_large_cust_lvl', KH.KEHU_DENGJI, 'large_cust_lvl_desc') KEHU_DENGJI_NAME, KH.ZHONGYAO_KEHU, PRMTOOLS.F_QUERYBYID('t_ci_cust_vip', KH.ZHONGYAO_KEHU, 'VIP_DESC') ZHONGYAO_KEHU_NAME, PRMTOOLS.F_QUERYBYID('yong_hu', MNZJ.YINSHIHAO, 'fuwu_haoma') YINSHIHAO, MNZJ.LIANXUAN_FANGSHI, PRMTOOLS.F_QUERYBYDICTID('moni_zhongji', MNZJ.LIANXUAN_FANGSHI, 'lianxuan_fangshi') LIANXUAN_FANGSHI_NAME, AD.DUANKOU_LEIBIE, PRMTOOLS.F_QUERYBYID('sebei_dalei', AD.DUANKOU_LEIBIE, 'sebei_dalei') DUANKOU_LEIBIE_NAME, AD.DUANKOU_SHULIANG, AD.ADSL_LEIXING, PRMTOOLS.F_QUERYBYDICTID('adsl_xinxi', AD.ADSL_LEIXING, 'adsl_leixing') ADSL_LEIXING_NAME, AD.SULU, PRMTOOLS.F_QUERYBYID('t_adsl_rate', AD.SULU, 'rate') SULU_NAME, AD.JIERU_FANGSHI, PRMTOOLS.F_QUERYBYID('t_adsl_enternet_mode', AD.JIERU_FANGSHI, 'enternet_mode_desc') JIERU_FANGSHI_NAME, AD.JIEKOU_LEIXING, PRMTOOLS.F_QUERYBYDICTID('adsl_xinxi', AD.JIEKOU_LEIXING, 'jiekou_leixing') JIEKOU_LEIXING_NAME, AD.SHICHANG, PRMTOOLS.F_QUERYBYID('t_adsl_time_limit', AD.SHICHANG, 'time_limit_desc') SHICHANG_NAME, AD.JIATING_WANGGUAN, YHSX.DSLAM_CHANGJIA, PRMTOOLS.F_QUERYBYDIC TID('YONGHU_SHUXING', YHSX.DSLAM_CHANGJIA, 'DSLAM_CHANGJIA') DSLAM_CHANGJIA_NAME, YHSX.SHIFOU_ZIWEI, YHSX.MODEM_XINGHAO, PRMTOOLS.F_QUERYBYDICTID('YONGHU_SHUXING', YHSX.MODEM_XINGHAO, 'MODEM_XINGHAO') MODEM_XINGHAO_NAME, YH.FUWU_HAOMA, YONGHUXINXI_CHAXUN.ISADSL(YH.ID) ISADSL, YHSX.YONGHU_MINGCHENG_97, YHSX.YONGHU_DIZHI_97, PRMTOOLS.F_QUERYBYID('celiangshi_weihuzu', YONGHUXINXI_CHAXUN.F_QUERYBYTABLECOL('yonghu_weihuzu', 'yonghu_id', YH.ID, 'id', 'weihuzu_id'), 'weihuzu') GONGZUO_ZU, ADYH.ZHUANGJI_REN ADZHUANGJI_REN, ADYH.ANZHUANG_RIQI ADANZHUANG_RIQI FROM YONG_HU YH LEFT JOIN KE_HU KH ON YH.KEHU_ID=KH.ID LEFT JOIN ADSL_XINXI AD ON YONGHUXINXI_CHAXUN.GETADSLYONGHUIDBYYONGHUID(YH.ID)=AD.ID LEFT JOIN YONG_HU ADYH ON AD.ID=ADYH.ID LEFT JOIN YONGHU_SHUXING YHSX ON YH.ID=YHSX.ID LEFT JOIN MONI_ZHONGJI MNZJ ON YH.ID=MNZJ.ID WHERE YH.ID=:B1
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
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)
53jhqd97fm61q	select shebei_dalei from shebei_dalei where id=:a
5jnxdy9z895zv	select o.object_id, o.owner, o.object_name, o.subobject_name, o.object_type, s.cnt from dba_objects o, ¡¡( select current_obj#, count(*) cnt from dba_hist_active_sess_history where event='DFS lock handle' group by current_obj#) s where object_id = s.current_obj# order by cnt desc
5jvj9nvwz4sdm	SELECT CLIENT_IDENTIFIER FROM V$SESSION T WHERE T.AUDSID = USERENV('sessionid')
5k5jvgf8xt0yk	SELECT CLIENT_IDENTIFIER FROM V$SESSION T WHERE T.AUDSID = USERENV('SESSIONID')
5kbdm8atnqfy4	select case when nvl(bddianhua, '-1') = nvl(ddduanhua, '-1') then ddduanhua when bddianhua <> ddduanhua then bddianhua|| ', ' || ddduanhua when nvl(bddianhua, '-1')='-1' then ddduanhua when nvl(ddduanhua, '-1')='-1' then bddianhua end dianhua, x.* from (select dx.id id, (select yh.fuwu_haoma from yonghu_luyou_xiangqing xq, yonghu_luyou ly, yong_hu yh where yh.id = ly.yonghu_id and ly.id = xq.luyou_id and xq.shebei_id = dx.shebei_id and xq.mokuai_id = dx.mokuai_id and xq.duankou_hao = dx.qishi_duanzi) bddianhua, prmtools.f_querybyid('shebei_dalei', dx.shebei_dalei, 'shebei_dalei') bdshebeileixing, prmtools.f_querybyid('peixian_jia', dx.shebei_id, 'bian_hao') bdshebeibianhao, prmtools.f_querybyid('shebei_dalei', dx.mokuai_leibie, 'shebei_dalei') bdmokuailiexing, dx.lie bdlie, dx.kuai bdkuai, dx.qishi_duanzi bdduaizihao, (select yh.fuwu_haoma from yonghu_luyou_xiangqing xq, yonghu_luyou ly, yong_hu yh where yh.id = ly.yonghu_id and ly.id = xq .luyou_id and xq.shebei_id = dx.duiduan_shebei_id and xq.mokuai_id = dx.duiduan_mokuai_id and xq.duankou_hao = dx.duiduan_qishi_duanzi) ddduanhua, prmtools.f_querybyid('shebei_dalei', dx.duiduan_shebei_dalei, 'shebei_dalei') ddshebeileixing, CASE WHEN dx.duiduan_shebei_dalei = 20 THEN prmtools.f_querybyid('fenxian_he', dx.duiduan_shebei_id, 'bian_hao') else prmtools.f_querybyid('peixian_jia', dx.duiduan_shebei_id, 'bian_hao') END AS ddshebeibianhao, prmtools.f_querybyid('shebei_dalei', dx.duiduan_mokuai_leibie, 'shebei_dalei') ddmokuailiexing, dx.duiduan_lie ddlie, dx.duiduan_kuai ddkuai, dx.duiduan_qishi_duanzi ddduaizihao, dx.shebei_dalei shebeidalei, dx.shebei_id shebeiid, dx.mokuai_id mokuaiid from shebei_duiduan_xinxi dx) x where x.shebeidalei = '0' and x.shebeiid = '3103438' and x.mokuaiid in(3230399) ORDER BY x.bdlie, x.bdkuai, x.bdduaizihao
5nw3vj24xbgzj	BEGIN SP_LOUYU_MINGXI_TONGBU; END;
5tdm0g6jw55pq	BEGIN SP_Tar_Solr_Job; END;
60uk6ax9fh223	BEGIN :1 := epon_pkg.onu_ruwang_process(:2, :3); END;
6byk7r7q74s7x	/* dynamic native SQL query */ select count(*) from peixian_jia a join peixian_mokuai b on a.id=b.peixian_jia_id join peixian_duanzi c on b.id=c.mokuai_id and c.peixian_jia_id=a.id left join shebeihao s on b.id=s.mokuai_id and c.id=s.id and a.id=s.peixian_jia_id where upper(a.bian_hao)=:1 and b.lie=:2 and b.kuai=:3 and b.shebei_dalei=:4 order by c.duanzi_hao
6cayrqff248cw	select column_id from sys.user_tab_columns t where column_name ='SHEBEI_DALEI' and table_name ='SHEBEI_DALEI'
6h4048bxwym98	SELECT id, shangwang_svlan FROM (SELECT aa.* FROM (SELECT d.id, d.duankou_hao, z.shangwang_svlan , count(*) vlan_count FROM (SELECT * FROM olt_duankou WHERE olt_id = :1 AND yewu_leixing = :2) d INNER JOIN vlan_ziyuan z ON d.id = z.shanglian_duankou_id AND z.zhuang_tai = :5 AND nvl(z.shiyong_yongtu, 0)= nvl(:4, 0) GROUP BY d.id, d.duankou_hao, z.shangwang_svlan) aa WHERE aa.vlan_count >= :3 ORDER BY TO_NUMBER(aa.duankou_hao), aa.shangwang_svlan) bb WHERE ROWNUM = 1
6jm1qr70q2h16	SELECT DISTINCT L.APPLY_ID FROM IOM_GONGDAN_XINXI L WHERE (L.PRODUCT_NUM=:B1 OR L.PRODUCT_NUM_ORDER=:B1 ) AND L.WORK_ID IS NULL
6pcx8c0tbznba	call all_route1.p_ChaiJiChuLi(:1)
74nahtt0jabdu	SELECT OBJECTID, NO, BUILDINGNO, BUILDINGCODE, BUILDINGNAME, BUILDINGOTHER, BELONGDISTRICT, ADDR, ADDRALIAS1, ADDRALIAS2, BELONGGRID, GRIDCODE, LONGITUDE, LATITUDE, BUILDINGTYPE, BUILDINGTYPEMARKET, FLOORSPACE, FLOORS, BUILDINGAREA, ADMINDIVISIONS, STREET, QUJU, DUANJU, CODE, FLDID, FLDTAG, DSL_500_OUTER, DSL_500_INNER, FTTB, FTTH, FAMILYNUM, LAN, LAN_INFO, LAN1, MONEY, SQ, FLDBUILDSTATUS, BUILDINGTYPENEW, BUILDINGTYPEMARKETNEW, BUILDTYPE1, BUILDTYPE2, ADSL, LYZX, FTTBC, FTTHC, LANC, T2G, T3G, WLAN, TS, RATE, HRATE, INCOME, DZS, PRJSTATE, RELATIVE, CORRECT, CORRECTADD, KDZY, ARREARAGE, FTTX, IPTV, 1 SHAPE, ½¨Öþ.SHAPE.area, ½¨Öþ.SHAPE.len, ½¨Öþ.SHAPE.points, ½¨Öþ.SHAPE.numpts, ½¨Öþ.SHAPE.entity, ½¨Öþ.SHAPE.minx, ½¨Öþ.SHAPE.miny, ½¨Öþ.SHAPE.maxx, ½¨Öþ.SHAPE.maxy, ½¨Öþ.rowid FROM SDE.½¨Öþ ½¨Öþ WHERE SDE.ST_EnvIntersects(½¨Öþ.SHAPE, :1, :2, :3, :4) = 1
7nj6596fjdpyc	delete biangeng_shixiang where yonghu_id=:a
7q8q7qt5q819b	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN proc_onu_chaoshi_chuli; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
7xwp1bkswsufd	UPDATE IOM_GONGDAN_XINXI T SET T.JUNGONG_ZHUANGTAI=1, T.ADUAN_ZIYUAN_ZHUANGTAI=4 WHERE (T.PRODUCT_NUM=:B1 OR T.PRODUCT_NUM_ORDER=:B1 ) AND (T.JUNGONG_ZHUANGTAI='0' OR T.ADUAN_ZIYUAN_ZHUANGTAI!=4) AND T.ACTION_TYPE!='0'
7yjvvu8684s8r	select a.congshu_fuwu from guanlian_fuwu a where a.fuwu_id=:a and a.guanxi_leixing='0'
7z2ttqdvc85kf	select shujuku_biao from shebei_dalei t where t.id=:a
813chjbtjw9bv	UPDATE IOM_GONGDAN_XINXI M SET M.WORK_ID='2' WHERE M.APPLY_ID=:B1
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
8cgpz272jq02b	INSERT INTO HIST.HIS_YONGHU_LUYOU_XIANGQING VALUES (HIST.SEH_YONGHU_LUYOU_XIANGQING.NEXTVAL, :B34 , 1, :B33 , SYSDATE, :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , :B11 , :B12 , :B13 , :B14 , :B15 , :B16 , :B17 , :B18 , :B19 , :B20 , :B21 , :B22 , :B23 , :B24 , :B25 , :B26 , :B27 , :B28 , :B29 , :B30 , :B31 , :B32 )
8f4n1j0huj4qa	SELECT P.ID, P.ORDERID, P.INTERFACENAME, P.PARAM, P.WORKSHEETID, P.SERVERNUMBER from IOM_INTERFACE_ASY P WHERE P.id IN ( SELECT ID FROM (SELECT A.SERVERNUMBER, MIN(A.ID) ID FROM IOM_INTERFACE_ASY A WHERE A.RESULT in (0, 3) GROUP BY A.SERVERNUMBER ORDER BY MIN(A.ID)) WHERE ROWNUM <= 50 ) ORDER BY ID
8ha2fwnsq3217	BEGIN lianjie_shebei_maint.add_col_modify(:1, :2, :3, :4, :5, :6, :7, :8); END;
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
91k4w10zgrg4m	select object_name, object_type from sys.all_objects o where o.owner = :schema and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
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
a2m8vg3xta7wz	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN insert into haoma_shigong_xiaozu (id, order_id, si_external_type_id, number_sub_type, fuwu_haoma, haoma_biaoshi, cancel_flag, shigong_xiaozu, caozuo_shijian, apply_id) select a.id, a.order_id, a.si_external_type_id, a.number_sub_type, a.fuwu_haoma, a.haoma_biaoshi, a.cancel_flag, a.shigong_xiaozu, a.caozuo_shijian, a.apply_id from haoma_shigong_xiaozu@jxgl2csm a, haoma_shigong_xiaozu b where b.id(+) = a.id and b.id is null; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
ah0nz3nxp0rgt	SELECT 1 SHAPE, СÇø·¶Î§.OBJECTID, СÇø·¶Î§.SHAPE.points, СÇø·¶Î§.SHAPE.numpts, СÇø·¶Î§.SHAPE.entity, СÇø·¶Î§.SHAPE.minx, СÇø·¶Î§.SHAPE.miny, СÇø·¶Î§.SHAPE.maxx, СÇø·¶Î§.SHAPE.maxy, СÇø·¶Î§.rowid FROM SDE.СÇø·¶Î§ СÇø·¶Î§ WHERE SDE.ST_EnvIntersects(СÇø·¶Î§.SHAPE, :1, :2, :3, :4) = 1
arpg17sc4vmnp	select jusuo_mingcheng from ju_suo where id=:a
b9bjp8q6kqkgu	SELECT BUILDINGCODE, BUILDINGNAME, 1 SHAPE, OBJECTID, FLDBUILDSTATUS, ½¨Öþ.SHAPE.points, ½¨Öþ.SHAPE.numpts, ½¨Öþ.SHAPE.entity, ½¨Öþ.SHAPE.minx, ½¨Öþ.SHAPE.miny, ½¨Öþ.SHAPE.maxx, ½¨Öþ.SHAPE.maxy, ½¨Öþ.rowid FROM SDE.½¨Öþ ½¨Öþ WHERE SDE.ST_EnvIntersects(½¨Öþ.SHAPE, :1, :2, :3, :4) = 1
bc9f3ysr641f5	UPDATE IOM_GONGDAN_XINXI G SET G.PRODUCT_NUM_ORDER = 'D' || G.ADSL_LHAO, G.PRODUCT_NUM = 'D' || G.ADSL_LHAO WHERE G.PRODUCT_NUM IS NULL
bd502nbh9abbs	select s.synonym_name 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')
c00vrrgvs4078	UPDATE PEIXIAN_MOKUAI SET LIE = TO_CHAR (TO_NUMBER (LIE) + :B6 ), CAOZUO_YUAN = :B5 , CAOZUO_SHIJIAN = :B4 WHERE PEIXIAN_JIA_ID = :B3 AND LIE_LEIXING = :B2 AND TO_NUMBER (LIE) >= :B1
c6awqs517jpj0	select /*+ index(idl_char$ i_idl_char1) +*/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
cdt65t01gscrv	/* insert com.surekam.nrm.peixianluyouweihu.model.IomGongdanXinxi */ insert into IOM_GONGDAN_XINXI (ORDER_KIND, ORDER_TYPE, EXCHANGE_ID, PROD_ID, PRODUCT_NUM, APPLY_ID, BUSI_ID, BUSI_NAME, JUNGONG_ZHUANGTAI, PRODUCT_NUM_ORDER, REMARK, ACTION_TYPE, ORDER_ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
d8fvwfn6qs713	call all_route1.p_danChaiAdslLuYou(:1, :2)
dau41buhm58d4	select ju_suo from yong_hu where id=:a
dc715hm8hsgm4	UPDATE PEIXIAN_JIA_KONGWEI SET LIE = TO_CHAR (TO_NUMBER (LIE) + :B6 ), CAOZUO_YUAN = :B5 , CAOZUO_SHIJIAN = :B4 WHERE PEIXIAN_JIA_ID = :B3 AND LIE_LEIXING = :B2 AND TO_NUMBER (LIE) >= :B1
dz8yffw3mbzdp	UPDATE IOM_GONGDAN_XINXI T SET T.JUNGONG_ZHUANGTAI=1, T.ADUAN_ZIYUAN_ZHUANGTAI=4 WHERE T.ADSL_ZHANGHAO=:B1 AND (T.JUNGONG_ZHUANGTAI=0 OR T.ADUAN_ZIYUAN_ZHUANGTAI!=4) AND T.ACTION_TYPE!='0'
f2qxy6qbdq6p8	select * from( select rw.*, rownum rn from ( select bb.APPLY_ID fldid, bb.ORDER_ID order_id, bb.xin_zhuangji_dizhi as addr, bb.biaozhun_dizhi_id, bb.apply_dept_name shouliting, bb.duan_ju fenju, bb.yuan_haoma telephoneold, bb.KUANDAI_ZHANGHAO zhanghao, '' shensureason, bb.QU_JU branch, nvl(bb.biaozhun_dizhi, '²éÎ޴˵ØÖ·') biaozhun_dizhi, xin_haoma telephone, to_char(bb.session_id, 'yyyy-MM-dd HH24:mi:ss') cztime , bb.xin_kehu_mingcheng as czuser, func_getworkdaynum(bb.session_id, sysdate) as days, 'δ´¦Àí' as state, 'ǰ̨δ´ø±ê×¼µØÖ·' as type from (select fldcareaname from (select fldcareaname from tar_area where fldareaid in (select column_value from table (func_getbranchbyuser('120660073116760032560'))) union (select fldcareaname||'¾Ö' from tar_area where fldareaid in (select column_value from table (func_getbranchbyuser('120660073116760032560'))))) t ) tp, iom_jungong_gongdan_heche bb where tp.fldcareaname = bb.qu_ju and (bb.BIAOZHUN_DIZHI_ID = '040202376904_11121333_0' and (bb.shigong_dongzuo='×°' or bb.shigong_dongzuo='ÒÆ')) and bb.order_id in (select order_id from iom_jungong_gongdan_heche bt where not exists(select 1 from tar_iom_orderaddress_dealed cc where bt.order_id=cc.order_id) ) and (qu_ju = '°ËÇø¾Ö') and (duan_ju = 'Ëļ¾Çà¾Ö') ) rw where rownum <=25 ) where rn>0
fk1vv7u264673	/* dynamic native SQL query */ select * from ( select c.id as ID91_0_, a.weihu_danwei as weihu2_91_0_, 201 as WEIZHI3_91_0_, a.WEIZHI_ID as WEIZHI4_91_0_, a.jusuo_id as JUSUO5_91_0_, a.jifang_id as JIFANG6_91_0_, a.shebei_dalei_id as SHEBEI7_91_0_, a.id as SHEBEI8_91_0_, a.bian_hao as SHEBEI9_91_0_, a.ji_lie as JI10_91_0_, a.JI_JIA as JI11_91_0_, null as JI12_91_0_, b.shebei_dalei as MOKUAI13_91_0_, b.id as MOKUAI14_91_0_, b.bian_hao as MOKUAI15_91_0_, b.lie as LIE91_0_, b.kuai as KUAI91_0_, c.shebei_dalei as DUANKOU18_91_0_, c.id as DUANKOU19_91_0_, c.duanzi_hao as DUANKOU20_91_0_, c.bian_hao as DUANKOU21_91_0_, c.CAOZUO_YUAN as CAOZUO22_91_0_, c.CAOZUO_SHIJIAN as CAOZUO23_91_0_, c.zhuang_tai as zhuang24_91_0_, s.shebei_hao as shebei25_91_0_, s.jiaoHuan_XiTong_Hao as jiaohuan26_91_0_ from peixian_jia a join peixian_mokuai b on a.id=b.peixian_jia_id join peixian_duanzi c on b.id=c.mokuai_id and c.peixian_jia_id=a.id left join shebeihao s on b.id=s.mokuai_id and c.id=s.id and a.id=s.peixian_jia_id where upper(a.bian_hao)=:1 and b.lie=:2 and b.kuai=:3 and b.shebei_dalei=:4 order by c.duanzi_hao ) where rownum <= :5
fkxbjt49cy1sm	SELECT prmtools.f_querybyid('yonghu_luyou', e.luyou_id, 'zhuanxian_hao') ·þÎñºÅÂë, e.shebeihao É豸ºÅ, prmtools.f_querybyid('fuwu_leixing', prmtools.f_querybyid('yong_hu', e.yonghu_id, 'fuwu_leixing_id'), 'fuwu_leixing')||YONGHUXINXI_CHAXUN.F_shifou_adsl(to_number(e.yonghu_id)) ·þÎñÀàÐÍ, (SELECT prmtools.f_querybyid('yong_hu', congshu_fuwu, 'fuwu_haoma') FROM guanlian_fuwu WHERE fuwu_id=e.yonghu_id AND guanxi_leixing='0' and rownum=1) ADSLÕʺÅ, e.duanzi_hao ¶Ë×ÓºÅ, prmtools.f_querybytype_id(e.duiduan_shebei_dalei, e.duiduan_shebei_id) É豸±àºÅ, prmtools.f_querybyid('shebei_dalei', e.duiduan_mokuai_leibie, 'shebei_dalei') Ä£¿éÀàÐÍ, e.duiduan_lie ÁÐ, e.duiduan_kuai ¿é, e.duiduan_qishi_duanzi ¶Ô¶Ë¶Ë×ÓºÅ, case when e.duiduan_shebei_dalei in (20, 22) then (select nvl2(di_zhi, di_zhi||' ', '')||nvl2(dan_yuan, rtrim(dan_yuan, 'µ¥Ôª')||'µ¥Ôª', ' ')||nvl2(ceng_hao, to_char(ceng_hao)||'²ã', ' ')||nvl2(fang_hao, fang_hao||'ºÅ', ' ') from fenxian_he where id=e.duiduan_shebei_id) end µØÖ·, e.״̬, case when ״̬='¹ÊÕÏ' then (select rtrim(prmtools.f_querybydictid('guzhang_yuanyin', f.guzhang_fenlei, 'guzhang_fenlei')||'--'||nvl(f.guzhang_xianxiang, '-'), '-') from guzhang_yuanyin f where f.shebei_dalei=e.duanzi_leibie and f.shebei_id=e.duanzi_id) when ״̬='δ֪ռÓÃ' then (select rtrim(prmtools.f_querybydictid('weizhi_zhanyong', zhangyong_leibie, 'zhangyong_leibie')||'--'||nvl(zhangyong_neirong, '-'), '-') from weizhi_zhanyong a where duanzi_leibie=e.duanzi_leibie and duanzi_id=e.duanzi_id ) else ('') end ״̬˵Ã÷, /*prmtools.f_querybydictid(' shebei_duiduan_xinxi', */ e.fujie_biaozhi /*, 'fujie_biaozhi')*/ ¸´½Ó±êÖ¾ FROM (SELECT c.duanzi_hao, d.luyou_id, d.shebeihao, d.duanzi_leibie, d.duanzi_id, d.qishi_duanzi, d.duiduan_shebei_dalei, d.duiduan_shebei_id, d.duiduan_mokuai_leibie, d.duiduan_mokuai_id, d.duiduan_lie, d.duiduan_kuai, d.duiduan_qishi_duanzi, prmtools.f_querybyid('yonghu_luyou', d.luyou_id, 'yonghu_id') yonghu_id, d.mokuai_leibie, d.fujie_biaozhi, (prmtools.f_querybydictid(prmtools.f_devtype(d.duanzi_leibie, '0'), prmtools.f_querybyid(prmtools.f_devtype(d.duanzi_leibie, '0'), d.duanzi_id, 'zhuang_tai'), 'zhuang_tai')) ״̬ FROM ((SELECT a.luyou_id, (select prmtools.f_querybyid('shebeihao', z.duankou_id, 'jiaohuan_xitong_hao||'':''||shebei_hao') from yonghu_luyou_xiangqing z where z.luyou_id=a.luyou_id and z.duankou_leibie in (4, 89) and rownum=1) shebeihao, b.duanzi_leibie, b.duanzi_id, b.qishi_duanzi, b.duiduan_shebei_dalei, b.duiduan_shebei_id, b.duiduan_mokuai_leibie, b.duiduan_mokuai_id, b.duiduan_lie, b.duiduan_kuai, b.duiduan_qishi_duanzi, b.mokuai_leibie, b.fujie_biaozhi FROM yonghu_luyou_xiangqing a, shebei_duiduan_xinxi b WHERE a.mokuai_leibie(+)=b.mokuai_leibie and a.mokuai_id(+)=b.mokuai_id and a.duankou_hao(+)=b.qishi_duanzi and b.mokuai_leibie=:a and b.mokuai_id=:b)) d, peixian_biao c where c.duanzi_hao=d.qishi_duanzi(+)) e order by ¶Ë×ÓºÅ, É豸±àºÅ
fmvrsnb2cmbwq	insert into lishi_biangeng_shixiang select * from biangeng_shixiang where yonghu_id=:a
g6suxtk4h9mgh	SELECT 1 SHAPE, FLDBUILDSTATUS, ½¨Öþ.OBJECTID, ½¨Öþ.SHAPE.points, ½¨Öþ.SHAPE.numpts, ½¨Öþ.SHAPE.entity, ½¨Öþ.SHAPE.minx, ½¨Öþ.SHAPE.miny, ½¨Öþ.SHAPE.maxx, ½¨Öþ.SHAPE.maxy, ½¨Öþ.rowid FROM SDE.½¨Öþ ½¨Öþ WHERE SDE.ST_EnvIntersects(½¨Öþ.SHAPE, :1, :2, :3, :4) = 1
gnc90kkh08j9a	/* insert com.surekam.nrm.peixianluyouweihu.model.IomGongdanXinxi */ insert into IOM_GONGDAN_XINXI (ORDER_KIND, ORDER_TYPE, EXCHANGE_ID, PROD_ID, PRODUCT_NUM, APPLY_ID, BUSI_ID, BUSI_NAME, JUNGONG_ZHUANGTAI, PRODUCT_NUM_ORDER, adsl_lhao, adsl_Zhanghao, ACTION_TYPE, ORDER_ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14)
gtbgmczdn13ms	SELECT 1 SHAPE, ÐÐÕþ´å.OBJECTID, ÐÐÕþ´å.SHAPE.points, ÐÐÕþ´å.SHAPE.numpts, ÐÐÕþ´å.SHAPE.entity, ÐÐÕþ´å.SHAPE.minx, ÐÐÕþ´å.SHAPE.miny, ÐÐÕþ´å.SHAPE.maxx, ÐÐÕþ´å.SHAPE.maxy, ÐÐÕþ´å.rowid FROM SDE.ÐÐÕþ´å ÐÐÕþ´å WHERE SDE.ST_EnvIntersects(ÐÐÕþ´å.SHAPE, :1, :2, :3, :4) = 1
gx3ujs70j1zva	SELECT T.YONGHU_ID, T.BIANGENG_SHIJIAN, T.BIANGENG_SHIXIANG, PRMTOOLS.F_QUERYBYID('gongcheng_shixiang', T.BIANGENG_SHIXIANG, 'gongcheng_shixiang') BIANGENG_SHIXIANG_NAME, T.YUAN_NEIRONG, T.JINGBAN_REN CELIANG, '´ý´¦Àí' WAIXIAN, '´ý´¦Àí' JIFANG FROM BIANGENG_SHIXIANG T WHERE T.YONGHU_ID=:B1

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