SQL Id | SQL Text |
04xtrk7uyhknh | select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null |
0dwr2vd6vbqzs |
SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff,
nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number
= :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
|
0h6b2sajwb74n | select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME') |
18naypzfmabd6 | INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256)) |
1b28hzmjun5t0 | MERGE INTO SYS.MON_MODS_ALL$ MM USING ( SELECT /*+ ordered */ DISTINCT TAB.OBJ# FROM (SELECT T.OBJ# OBJ#, T.OBJ# BO#, T.ANALYZETIME FROM SYS.TAB$ T WHERE BITAND(T.FLAGS, 16) = 16 UNION ALL SELECT T.OBJ# OBJ#, T.BO# BO#, T.ANALYZETIME FROM SYS.TABPART$ T WHERE BITAND(T.FLAGS, 2) = 2 UNION ALL SELECT T.OBJ# OBJ#, T.BO# BO#, T.ANALYZETIME FROM SYS.TABCOMPART$ T WHERE BITAND(T.FLAGS, 2) = 2 UNION ALL SELECT T.OBJ# OBJ#, TCP.BO# BO#, T.ANALYZETIME FROM SYS.TABSUBPART$ T, SYS.TABCOMPART$ TCP WHERE BITAND(T.FLAGS, 2) = 2 AND T.POBJ# = TCP.OBJ# ) TAB, OBJ$ O, SYS.COL$ C WHERE TAB.BO# = O.OBJ# AND TAB.ANALYZETIME < O.MTIME AND C.OBJ# = TAB.BO# AND C.TYPE# IN ( 1, 2, 12, 23, 69, 96, 100, 101, 178, 179, 180, 181, 182, 183, 231) AND BITAND(C.PROPERTY, 16384+32768) = 0 AND NOT (BITAND(C.PROPERTY, 32+65536+131072) = 32+65536 AND C.DEFAULT$ IS NULL ) AND NOT EXISTS (SELECT /*+ unnest */ NULL FROM HIST_HEAD$ HH WHERE HH.OBJ# = TAB.OBJ# AND HH.INTCOL# = C.INTCOL#) ) MCS ON (MM.OBJ# = MCS.OBJ#) WHEN MATCHED THEN UPDATE SET FLAGS = FLAGS + 4 WHERE BITAND(FLAGS, 4) = 0 WHEN NOT MATCHED THEN INSERT (OBJ#, INSERTS, UPDATES, DELETES, TIMESTAMP, FLAGS, DROP_SEGMENTS) VALUES(MCS.OBJ#, 0, 0, 0, :B1 , 4, 0) |
2ym6hhaq30r73 | select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3 |
3wmz23p8fsvvn |
SELECT DISTINCT D.NAME, TRIM(SUBSTR(C.DATA_VALUE_MIN, INSTR(C.DATA_VALUE_MIN, ')', 1)+1)) DATA_VALUE_MIN, TRIM(SUBSTR(C.DATA_VALUE_MAX, INSTR(C.DATA_VALUE_MAX, ')', 1)+1)) DATA_VALUE_MAX , C.NUM_TYPE, D.CODE FROM YTO_MID_ROAD B, YTO_MID_ROAD_NUM C, YTO_JINGANG_STATION D WHERE (B.NAME = 'Îâ½ÊÐ' /*OR B.ALIAS1='Îâ½ÊÐ' OR B.ALIAS2='Îâ½ÊÐ' OR B.ALIAS3='Îâ½ÊÐ'*/ OR B.NAME like'%½ËÕÊ¡%' /* OR B.ALIAS1='½ËÕÊ¡' OR B.ALIAS2='½ËÕÊ¡' OR B.ALIAS3='½ËÕÊ¡'*/ OR B.NAME ='Îâ' /* OR B.ALIAS1='Îâ' OR B.ALIAS2='Îâ' OR B.ALIAS3='Îâ'*/ OR B.NAME like'%½É½%' /* OR B.ALIAS1='½É½' OR B.ALIAS2='½É½' OR B.ALIAS3='½É½'*/ OR B.NAME ='ºþ' /*OR B.ALIAS1='ºþ' OR B.ALIAS2='ºþ' OR B.ALIAS3='ºþ'*/ OR B.NAME like'%»¨Ô°%' /* OR B.ALIAS1='»¨Ô°' OR B.ALIAS2='»¨Ô°' OR B.ALIAS3='»¨Ô°'*/ OR B.NAME like'%3Çø%' /* OR B.ALIAS1='3Çø' OR B.ALIAS2='3Çø' OR B.ALIAS3='3Çø'*/ OR B.NAME like'%60%' /* OR B.ALIAS1='60' OR B.ALIAS2='60' OR B.ALIAS3='60'*/ OR B.NAME like'%ºÅ%' /* OR B.ALIAS1='ºÅ' OR B.ALIAS2='ºÅ' OR B.ALIAS3='ºÅ'*/ ) AND B.ROAD_ID = C.ROAD_ID AND B.ISDELETE=0 AND C.ISDELETE=0 AND C.IS_REACH=1 AND D.USED='Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND C.OUTLET_ID = D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') UNION SELECT DISTINCT D.NAME, '0', '0', 3, D.CODE FROM YTO_MID_POI B, YTO_JINGANG_STATION D WHERE ( B.NAME='Îâ½ÊÐ' OR B.NAME like'%½ËÕÊ¡%' /* OR B.ALIAS1='½ËÕÊ¡' OR B.ALIAS2='½ËÕ
Ê¡' OR B.ALIAS3='½ËÕÊ¡'*/ OR B.NAME ='Îâ' /* OR B.ALIAS1='Îâ' OR B.ALIAS2=
'Îâ' OR B.ALIAS3='Îâ'*/ OR B.NAME like'%½É½%' /* OR B.ALIAS1='½É½' OR B.ALIAS2='½É½' OR B.ALIAS3='½É½'*/ OR B.NAME ='ºþ' /*OR B.ALIAS1='ºþ' OR B.ALIAS2='ºþ' OR B.ALIAS3='ºþ'*/ OR B.NAME like'%»¨Ô°%' /* OR B.ALIAS1='»¨Ô°' OR B.ALIAS2='»¨Ô°' OR B.ALIAS3='»¨Ô°'*/ OR B.NAME like'%3Çø%' /* OR B.ALIAS1='3Çø' OR B.ALIAS2='3Çø' OR B.ALIAS3='3Çø'*/ OR B.NAME like'%60%' /* OR B.ALIAS1='60' OR B.ALIAS2='60' OR B.ALIAS3='60'*/ OR B.NAME like'%ºÅ%' /* OR B.ALIAS1='ºÅ' OR B.ALIAS2='ºÅ' OR B.ALIAS3='ºÅ'*/ ) AND D.USED = 'Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND B.OUTLET_ID=D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') |
42pgj3syb4tcn |
select m1.device_id, m1.latitude, m1.longitude, m1.speed, m1.direction, m1.gpstime, m1.stop_car, m1.engine, m2.vehicle_id, m2.line_no, m2.next_org_code, m2.is_lazy, m2.EXPECTED_END_DATE, m2.task_id, m2.sdate, m2.edate, m1.fictitious_line_name from (select t1.device_id as device_id, t2.latitude as latitude, t2.longitude as longitude, t2.speed as speed, t2.direction as direction, to_char(t2.gpstime, 'yyyy-MM-dd HH24:mi:ss') as gpstime, t3.stop_car as stop_car, t3.flame_out as engine, t4.fictitious_line_name from t_terminal t1, t_last_locrecord t2, t_term_status_last_record t3, ( select b.tid, h.fictitious_line_name from ref_vehicle_terminal b, yto_vehicle_ref g, yto_fictitious_line h where b.vid = g.id(+) and g.fictitious_line_id = h.fictitious_line_id(+) ) t4 where t1.device_id = t2.device_id and t1.device_id = t3.device_id(+) and t1.device_id = t4.tid(+) and t1.device_id in ('13721878691')) m1, (select y1.termial_id as device_id , y1.vehicle_id as vehicle_id, y1.line_no as line_no, y1.next_org_code as next_org_code, y2.is_lazy as is_lazy, to_char(y2.EXPECTED_END_DATE, 'yyyy-MM-dd HH24:mi:ss') as EXPECTED_END_DATE, y1.task_id, to_char(y4.sdate, 'yyyy-MM-dd HH24:mi:ss') sdate, to_char(y4.edate, 'yyyy-MM-dd HH24:mi:ss') edate from yto_task y1, yto_task_dtl y2, ( select yy3.task_id, y3.real_start_date sdate, y32.real_end_date edate from yto_task yy3, yto_task_dtl y3, yto_task_dtl y32 where yy3.task_id = y3.task_id and yy3.task_id = y
32.task_id and yy3.start_org_code = y3.start_org_code and yy3.end_org_code = y32.end_org_code ) y4, t_last_locrecord y5 where y1.task_id = y2.task_id and y1.next_org_code = y2.end_org_code and y1.task_id = y4.task_id and y1.termial_id = y5.device_id and y1.create_date <= y5.gpstime+1 and y1.is_over = 0) m2 where m1.device_id = m2.device_id(+) |
43uvh6zzd4559 | SELECT vst.sql_id, vst.sql_fulltext FROM V$SQLSTATS vst WHERE vst.sql_id IN (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10) AND vst.plan_hash_value = :phv |
459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
4p7v0nxa2awyv |
select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), sum(sys_op_opnsize("ID")), substrb(dump(min(substrb("ID", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ID", 1, 32)), 16, 0, 32), 1, 120), count("DEVICE_ID"), sum(sys_op_opnsize("DEVICE_ID")), count("LATITUDE"), count(distinct "LATITUDE"), sum(sys_op_opnsize("LATITUDE")), substrb(dump(min("LATITUDE"), 16, 0, 32), 1, 120), substrb(dump(max("LATITUDE"), 16, 0, 32), 1, 120), count("LONGITUDE"), count(distinct "LONGITUDE"), sum(sys_op_opnsize("LONGITUDE")), substrb(dump(min("LONGITUDE"), 16, 0, 32), 1, 120), substrb(dump(max("LONGITUDE"), 16, 0, 32), 1, 120), count("JMX"), count(distinct "JMX"), sum(sys_op_opnsize("JMX")), substrb(dump(min("JMX"), 16, 0, 32), 1, 120), substrb(dump(max("JMX"), 16, 0, 32), 1, 120), count("JMY"), count(distinct "JMY"), sum(sys_op_opnsize("JMY")), substrb(dump(min("JMY"), 16, 0, 32), 1, 120), substrb(dump(max("JMY"), 16, 0, 32), 1, 120), count("SPEED"), count(distinct "SPEED"), sum(sys_op_opnsize("SPEED")), substrb(dump(min("SPEED"), 16, 0, 32), 1, 120), substrb(dump(max("SPEED"), 16, 0, 32), 1, 120), co
unt("DIRECTION"), count(distinct "DIRECTION"), sum(sys_op_opnsize("DIRECTION")), substrb(dump(min("DIRECTION"), 16, 0, 32), 1, 120), substrb(dump(max("DIRECTION"), 16, 0, 32), 1, 120), count("HEIGHT"), count(distinct "HEIGHT"), sum(sys_op_opnsize("HEIGHT")), substrb(dump(min("HEIGHT"), 16, 0, 32), 1, 120), substrb(dump(max("HEIGHT"), 16, 0, 32), 1, 120), count("DISTANCE"), count(distinct "DISTANCE"), sum(sys_op_opnsize("DISTANCE")), substrb(dump(min("DISTANCE"), 16, 0, 32), 1, 120), substrb(dump(max("DISTANCE"), 16, 0, 32), 1, 120), count("STATLLITE_NUM"), count(distinct "STATLLITE_NUM"), sum(sys_op_opnsize("STATLLITE_NUM")), substrb(dump(min("STATLLITE_NUM"), 16, 0, 32), 1, 120), substrb(dump(max("STATLLITE_NUM"), 16, 0, 32), 1, 120), count("GPSTIME"), count("INPUTDATE"), count(distinct "INPUTDATE"), substrb(dump(min("INPUTDATE"), 16, 0, 32), 1, 120), substrb(dump(max("INPUTDATE"), 16, 0, 32), 1, 120), count("LOCATE_TYPE"), count(distinct "LOCATE_TYPE"), sum(sys_op_opnsize("LOCATE_TYPE")), substrb(dump(min("LOCATE_TYPE"), 16, 0, 32), 1, 120), substrb(dump(max("LOCATE_TYPE"), 16, 0, 32), 1, 120), count("COORD_TYPE"), count(distinct "COORD_TYPE"), sum(sys_op_opns
ize("COORD_TYPE")), substrb(dump(min("COORD_TYPE"), 16, 0, 32), 1, 120), substrb(dump(max("COORD_TYPE"), 16, 0, 32), 1, 120), count("STATE"), count(distinct "STATE"), sum(sys_op_opnsize("STATE")), substrb(dump(min("STATE"), 16, 0, 32), 1, 120), substrb(dump(max("STATE"), 16, 0, 32), 1, 120), count("POS_DESC"), count(distinct "POS_DESC"), sum(sys_op_opnsize("POS_DESC")), substrb(dump(min(substrb("POS_DESC", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("POS_DESC", 1, 32)), 16, 0, 32), 1, 120), count("OBJ_ID"), count(distinct "OBJ_ID"), sum(sys_op_opnsize("OBJ_ID")), substrb(dump(min(substrb("OBJ_ID", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("OBJ_ID", 1, 32)), 16, 0, 32), 1, 120), count("OBJ_TYPE"), count(distinct "OBJ_TYPE"), sum(sys_op_opnsize("OBJ_TYPE")), substrb(dump(min("OBJ_TYPE"), 16, 0, 32), 1, 120), substrb(dump(max("OBJ_TYPE"), 16, 0, 32), 1, 120), count("SENDED"), count("DEVICE_MANTISSA"), sum(sys_op_opnsize("DEVICE_MANTISSA")) from "YTGPS"."GPS_LOCRECORD_SHOW" t |
53w19918z0xyv |
SELECT DISTINCT D.NAME, TRIM(SUBSTR(C.DATA_VALUE_MIN, INSTR(C.DATA_VALUE_MIN, ')', 1)+1)) DATA_VALUE_MIN, TRIM(SUBSTR(C.DATA_VALUE_MAX, INSTR(C.DATA_VALUE_MAX, ')', 1)+1)) DATA_VALUE_MAX , C.NUM_TYPE, D.CODE FROM YTO_MID_ROAD B, YTO_MID_ROAD_NUM C, YTO_JINGANG_STATION D WHERE (B.NAME = 'ÎâÖÐÇø' /*OR B.ALIAS1='ÎâÖÐÇø' OR B.ALIAS2='ÎâÖÐÇø' OR B.ALIAS3='ÎâÖÐÇø'*/ OR B.NAME like'%ËÕÖÝ%' /* OR B.ALIAS1='ËÕÖÝ' OR B.ALIAS2='ËÕÖÝ' OR B.ALIAS3='ËÕÖÝ'*/ OR B.NAME like'%¹¤ÒµÔ°Çø%' /* OR B.ALIAS1='¹¤ÒµÔ°Çø' OR B.ALIAS2='¹¤ÒµÔ°Çø' OR B.ALIAS3='¹¤ÒµÔ°Çø'*/ OR B.NAME like'%¸ß¶û·ò»¨Ô°%' /* OR B.ALIAS1='¸ß¶û·ò»¨Ô°' OR B.ALIAS2='¸ß¶û·ò»¨Ô°' OR B.ALIAS3='¸ß¶û·ò»¨Ô°'*/ OR B.NAME like'%28%' /* OR B.ALIAS1='28' OR B.ALIAS2='28' OR B.ALIAS3='28'*/ OR B.NAME ='´±' /*OR B.ALIAS1='´±' OR B.ALIAS2='´±' OR B.ALIAS3='´±'*/ OR B.NAME like'%1305%' /* OR B.ALIAS1='1305' OR B.ALIAS2='1305' OR B.ALIAS3='1305'*/ ) AND B.ROAD_ID = C.ROAD_ID AND B.ISDELETE=0 AND C.ISDELETE=0 AND C.IS_REACH=1 AND D.USED='Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND C.OUTLET_ID = D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') UNION SELECT DISTINCT D.NAME, '0', '0', 3, D.CODE FROM YTO_MID_POI B, YTO_JINGANG_STATION D WHERE ( B.NAME='ÎâÖÐÇø' OR B.NAME like'%ËÕÖÝ%' /* OR B.ALIAS1='ËÕÖÝ' OR B.ALIAS2='ËÕÖÝ' OR B.ALIAS3='ËÕÖÝ'*/ OR B.NAME like'%¹¤ÒµÔ°Çø%' /* OR B.ALIAS1='¹¤ÒµÔ°Çø' OR B.ALIAS2='¹¤ÒµÔ°Çø' OR B.ALIAS3='¹¤Òµ
Ô°Çø'*/ OR B.NAME like'%¸ß¶û·ò»¨Ô°%' /* OR B.ALIAS1='¸ß¶û·ò»¨Ô°' OR B.ALIAS2='¸ß¶û·ò»¨Ô°' OR B.ALIAS3='¸ß¶û
·ò»¨Ô°'*/ OR B.NAME like'%28%' /* OR B.ALIAS1='28' OR B.ALIAS2='28' OR B.ALIAS3='28'*/ OR B.NAME ='´±' /*OR B.ALIAS1='´±' OR B.ALIAS2='´±' OR B.ALIAS3='´±'*/ OR B.NAME like'%1305%' /* OR B.ALIAS1='1305' OR B.ALIAS2='1305' OR B.ALIAS3='1305'*/ ) AND D.USED = 'Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND B.OUTLET_ID=D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') |
5kyb5bvnu3s04 | SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1 |
5qkwd1quhpn9z | select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*) from "YTGPS"."GPS_LOCRECORD_SHOW" t |
5ur69atw3vfhj | select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1 |
68ddx7zxvxubr | select count(*) from (select distinct a.id, a.task_id, a.later_status, a.lazy_time, a.vehicle_no, a.line_name, to_char(a.gps_time, 'yyyy-MM-dd HH24:mi:ss'), a.is_disposal, b.name, c.device_id from t_later_info a, yto_org_node b, yto_in_out_area_s c, (select g.gid from t_privilage_group g start with g.gid = (select gid from ref_user_group where user_id = (select id from t_user where user_account = '00002578'))connect by prior g.gid = g.parent_id) d where a.task_id = c.task_id and b.org_id = ( case a.later_status when 1 then c.start_org_code else c.end_org_code end)and a.is_disposal = 0 and sysdate - a.gps_time < 5 and (c.start_org_code = d.gid or c.end_org_code = d.gid )) |
6xvp6nxs4a9n4 | select nvl(sum(space), 0) from recyclebin$ where ts# = :1 |
9qkxr4qhujs7s | SELECT DISTINCT D.NAME, TRIM(SUBSTR(C.DATA_VALUE_MIN, INSTR(C.DATA_VALUE_MIN, ')', 1)+1)) DATA_VALUE_MIN, TRIM(SUBSTR(C.DATA_VALUE_MAX, INSTR(C.DATA_VALUE_MAX, ')', 1)+1)) DATA_VALUE_MAX , C.NUM_TYPE, D.CODE FROM YTO_MID_ROAD B, YTO_MID_ROAD_NUM C, YTO_JINGANG_STATION D WHERE (B.NAME = '²×ÀËÇø' /*OR B.ALIAS1='²×ÀËÇø' OR B.ALIAS2='²×ÀËÇø' OR B.ALIAS3='²×ÀËÇø'*/ OR B.NAME like'%ËÕÖÝÊÐ%' /* OR B.ALIAS1='ËÕÖÝÊÐ' OR B.ALIAS2='ËÕÖÝÊÐ' OR B.ALIAS3='ËÕÖÝÊÐ'*/ ) AND B.ROAD_ID = C.ROAD_ID AND B.ISDELETE=0 AND C.ISDELETE=0 AND C.IS_REACH=1 AND D.USED='Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND C.OUTLET_ID = D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') UNION SELECT DISTINCT D.NAME, '0', '0', 3, D.CODE FROM YTO_MID_POI B, YTO_JINGANG_STATION D WHERE ( B.NAME='²×ÀËÇø' OR B.NAME like'%ËÕÖÝÊÐ%' /* OR B.ALIAS1='ËÕÖÝÊÐ' OR B.ALIAS2='ËÕÖÝÊÐ' OR B.ALIAS3='ËÕÖÝÊÐ'*/ ) AND D.USED = 'Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND B.OUTLET_ID=D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') |
a8u21vgds1tkf | select substrb(dump(val, 16, 0, 32), 1, 120) ep, cnt from (select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"GPSTIME" val, count(*) cnt from "YTGPS"."GPS_LOCRECORD_SHOW" t where "GPSTIME" is not null group by "GPSTIME") order by val |
az33m61ym46y4 | SELECT NULL AS table_cat,
o.owner AS table_schem,
o.object_name AS table_name,
o.object_type AS table_type,
NULL AS remarks
FROM all_objects o
WHERE o.owner LIKE :1 ESCAPE '/'
AND o.object_name LIKE :2 ESCAPE '/'
AND o.object_type IN ('xxx', 'TABLE')
ORDER BY table_type, table_schem, table_name
|
b6usrg82hwsa3 | call dbms_stats.gather_database_stats_job_proc ( ) |
bk575wxmq6nkc |
SELECT DISTINCT D.NAME, TRIM(SUBSTR(C.DATA_VALUE_MIN, INSTR(C.DATA_VALUE_MIN, ')', 1)+1)) DATA_VALUE_MIN, TRIM(SUBSTR(C.DATA_VALUE_MAX, INSTR(C.DATA_VALUE_MAX, ')', 1)+1)) DATA_VALUE_MAX , C.NUM_TYPE, D.CODE FROM YTO_MID_ROAD B, YTO_MID_ROAD_NUM C, YTO_JINGANG_STATION D WHERE (B.NAME = 'Îâ½ÊÐ' /*OR B.ALIAS1='Îâ½ÊÐ' OR B.ALIAS2='Îâ½ÊÐ' OR B.ALIAS3='Îâ½ÊÐ'*/ OR B.NAME ='ÍÍ' /* OR B.ALIAS1='ÍÍ' OR B.ALIAS2='ÍÍ' OR B.ALIAS3='ÍÍ'*/ OR B.NAME ='´å' /* OR B.ALIAS1='´å' OR B.ALIAS2='´å' OR B.ALIAS3='´å'*/ OR B.NAME like'%ÉçÇø%' /* OR B.ALIAS1='ÉçÇø' OR B.ALIAS2='ÉçÇø' OR B.ALIAS3='ÉçÇø'*/ OR B.NAME ='Çñ' /*OR B.ALIAS1='Çñ' OR B.ALIAS2='Çñ' OR B.ALIAS3='Çñ'*/ OR B.NAME ='Éá' /*OR B.ALIAS1='Éá' OR B.ALIAS2='Éá' OR B.ALIAS3='Éá'*/ OR B.NAME like'%¿ª·¢Çø%' /* OR B.ALIAS1='¿ª·¢Çø' OR B.ALIAS2='¿ª·¢Çø' OR B.ALIAS3='¿ª·¢Çø'*/ ) AND B.ROAD_ID = C.ROAD_ID AND B.ISDELETE=0 AND C.ISDELETE=0 AND C.IS_REACH=1 AND D.USED='Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND C.OUTLET_ID = D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') UNION SELECT DISTINCT D.NAME, '0', '0', 3, D.CODE FROM YTO_MID_POI B, YTO_JINGANG_STATION D WHERE ( B.NAME='Îâ½ÊÐ' OR B.NAME ='ÍÍ' /* OR B.ALIAS1='ÍÍ' OR B.ALIAS2='ÍÍ' OR B.ALIAS3='ÍÍ'*/ OR B.NAME ='´å' /* OR B.ALIAS1='´å' OR B.ALIAS2='´å' OR B.ALIAS3='´å'*/ OR B.NAME like'%ÉçÇø%' /* OR B.ALIAS1='ÉçÇø' OR B.ALIAS2='ÉçÇø' OR B.ALIAS3='ÉçÇø'*/ OR B.NAME ='Çñ'
/*OR B.ALIAS1='Çñ' OR B.ALIAS2='Çñ' OR B.ALIAS3='Çñ'*/ OR B.NAME ='Éá' /*O
R B.ALIAS1='Éá' OR B.ALIAS2='Éá' OR B.ALIAS3='Éá'*/ OR B.NAME like'%¿ª·¢Çø%' /* OR B.ALIAS1='¿ª·¢Çø' OR B.ALIAS2='¿ª·¢Çø' OR B.ALIAS3='¿ª·¢Çø'*/ ) AND D.USED = 'Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND B.OUTLET_ID=D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') |
bvkpprhsjx5j3 |
SELECT DISTINCT D.NAME, TRIM(SUBSTR(C.DATA_VALUE_MIN, INSTR(C.DATA_VALUE_MIN, ')', 1)+1)) DATA_VALUE_MIN, TRIM(SUBSTR(C.DATA_VALUE_MAX, INSTR(C.DATA_VALUE_MAX, ')', 1)+1)) DATA_VALUE_MAX , C.NUM_TYPE, D.CODE FROM YTO_MID_ROAD B, YTO_MID_ROAD_NUM C, YTO_JINGANG_STATION D WHERE (B.NAME = 'Ì«²ÖÊÐ' /*OR B.ALIAS1='Ì«²ÖÊÐ' OR B.ALIAS2='Ì«²ÖÊÐ' OR B.ALIAS3='Ì«²ÖÊÐ'*/ OR B.NAME like'%Ì«²ÖÊÐ%' /* OR B.ALIAS1='Ì«²ÖÊÐ' OR B.ALIAS2='Ì«²ÖÊÐ' OR B.ALIAS3='Ì«²ÖÊÐ'*/ OR B.NAME like'%ɳϪÕò%' /* OR B.ALIAS1='ɳϪÕò' OR B.ALIAS2='ɳϪÕò' OR B.ALIAS3='ɳϪÕò'*/ OR B.NAME ='Áõ' /*OR B.ALIAS1='Áõ' OR B.ALIAS2='Áõ' OR B.ALIAS3='Áõ'*/ OR B.NAME ='Ì©' /*OR B.ALIAS1='Ì©' OR B.ALIAS2='Ì©' OR B.ALIAS3='Ì©'*/ OR B.NAME like'%´ú¹º%' /* OR B.ALIAS1='´ú¹º' OR B.ALIAS2='´ú¹º' OR B.ALIAS3='´ú¹º'*/ OR B.NAME ='²¿' /*OR B.ALIAS1='²¿' OR B.ALIAS2='²¿' OR B.ALIAS3='²¿'*/ ) AND B.ROAD_ID = C.ROAD_ID AND B.ISDELETE=0 AND C.ISDELETE=0 AND C.IS_REACH=1 AND D.USED='Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND C.OUTLET_ID = D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') UNION SELECT DISTINCT D.NAME, '0', '0', 3, D.CODE FROM YTO_MID_POI B, YTO_JINGANG_STATION D WHERE ( B.NAME='Ì«²ÖÊÐ' OR B.NAME like'%Ì«²ÖÊÐ%' /* OR B.ALIAS1='Ì«²ÖÊÐ' OR B.ALIAS2='Ì«²ÖÊÐ' OR B.ALIAS3='Ì«²ÖÊÐ'*/ OR B.NAME like'%ɳϪÕò%' /* OR B.ALIAS1='ɳϪÕò' OR B.ALIAS2='ɳϪÕò' OR B.ALIAS3='ɳϪÕò'*/ OR B.NAME ='Áõ' /*OR B.ALIAS1='Áõ' OR
B.ALIAS2='Áõ' OR B.ALIAS3='Áõ'*/ OR B.NAME ='Ì©' /*OR B.ALIAS1='Ì©' OR B.ALIAS2='Ì©' OR B.ALI
AS3='Ì©'*/ OR B.NAME like'%´ú¹º%' /* OR B.ALIAS1='´ú¹º' OR B.ALIAS2='´ú¹º' OR B.ALIAS3='´ú¹º'*/ OR B.NAME ='²¿' /*OR B.ALIAS1='²¿' OR B.ALIAS2='²¿' OR B.ALIAS3='²¿'*/ ) AND D.USED = 'Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND B.OUTLET_ID=D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') |
c3hhngpbpvvmk | SELECT MARKER_TIMESTAMP FROM MGMT_AVAILABILITY_MARKER WHERE TARGET_GUID = :B1 |
c45crtmadjf65 | SELECT SEVERITY_CODE FROM (SELECT SEVERITY_CODE FROM MGMT_SEVERITY WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP <= :B1 ORDER BY COLLECTION_TIMESTAMP DESC) WHERE ROWNUM = 1 |
c4nhd1ntptxq7 | select message_level, sequence_id, time_suggested from WRI$_ALERT_OUTSTANDING where reason_id = :1 and object_id = :2 and subobject_id = :3 and internal_instance_number = :4 |
csnp95dz2r8ss | select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0 |
d2vhun1bqg4dg |
MERGE /*+ dynamic_sampling(ST 4) dynamic_sampling_est_cdn(ST) */ INTO STATS_TARGET$ ST USING (SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN STALENESS > .5 THEN 128 ELSE 0 END + AFLAGS AFLAGS, STATUS, SID, SERIAL#, PART#, BO# FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN T.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, NULL, NULL) WHEN S.TYPE# = 5 THEN DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) ELSE NULL END * NVL(TS.BLOCKSIZE, :B4 ) OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, NULL PART#, NULL BO# FROM SYS.SEG$ S, SYS.TS$ TS, SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T, SYS.MON_MODS_ALL$ M WHERE :B1 IS NOT NULL AND O.TYPE# = 2 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE#(+) AND T.BLOCK# = S.BLOCK#(+) AND T.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.PROPERTY, 64+512) = 0 AND BITAND(T.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(O
.FLAGS, 128) != 128 AND BITAND(T.PROPERTY, 2147483648) = 0 AND (BITAND(T.PROPERTY, 4194304) != 4194304 AND BITAND(T.PROPERTY, 8388608) != 8388608) AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND NOT (U.NAME = 'SYS' AND O.NAME = 'SUMDELTA$') AND (U.NAME, O.NAME) NOT IN (SELECT /*+ unnest */ * FROM (SELECT MOWNER, LOG FROM MLOG$ UNION ALL SELECT MOWNER, TEMP_LOG FROM MLOG$ WHERE TEMP_LOG IS NOT NULL)) AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, PART#, BO# FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO# FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABPART$ T, SYS.TAB$ TAB, SYS.
OBJ$ OT, SYS.MON_MODS_ALL$ M WHERE O.TYPE# = 19 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND BITAND(TAB.PROPERTY, 512) != 512 AND BITAND(TAB.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(T.FLAGS, 2) != 2)) UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, O.SUBNAME, NULL) * :B4 OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO# FROM SYS.OBJ$ O, SYS.USER$ U, SYS.TABCOMPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M WHERE O.TYPE# = 19 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AN
D BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(T.FLAGS, 2) != 2)) ) WHERE :B5 IS NOT NULL UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 64 ELSE 0 END + CASE WHEN ROW_NUMBER() OVER (PARTITION BY (SELECT TCP0.BO# FROM TABCOMPART$ TCP0 WHERE TCP0.OBJ#=ST0.BO#) ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, PART#, BO# FROM (SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.SUBPART# PART#, T.POBJ# BO# FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABSUBPART$ T, SYS.TABCOMPART$ TCP, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.PARTOBJ$ PO WHERE O.TYPE# = 3
4 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND TCP.OBJ# = T.POBJ# AND TCP.BO# = TAB.OBJ# AND PO.OBJ# = TAB.OBJ# AND ((:B7 IS NOT NULL AND BITAND(PO.SPARE2, 255) = 2) OR (:B6 IS NOT NULL AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND BITAND(TCP.FLAGS, 32) != 32 AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(T.FLAGS, 2) != 2))) ST0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(I.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(CM.TRUNC, 1, GREATEST(CM.ROWCNT, CM.INSERTS), CM.TOT_MODS/(CM.ROWCNT + 0.01))))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, NULL PART#, I.BO# BO# FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.IND$ I, (SELECT BOBJ#, SUM(BITAND(T.TRIGFLAG, 67108864)/67108864) LOCKED, SUM(BITAND(M.FLAGS, 1))/COUNT(M.FLAGS) TRUNC, SUM(M.INSERTS+M.DELETES) TOT_MODS, SUM(M.INSERTS) INSERTS, SUM(T
.ROWCNT) ROWCNT FROM MON_MODS_ALL$ M, TAB$ T WHERE M.OBJ#(+) = T.OBJ# AND T.CLUCOLS IS NOT NULL GROUP BY BOBJ#) CM WHERE (:B8 IS NOT NULL) AND O.TYPE# = 1 AND S.TYPE# = 6 AND I.TYPE# = 3 AND I.OBJ# = O.OBJ# AND I.BO# = CM.BOBJ#(+) AND I.FILE# = S.FILE# AND I.BLOCK# = S.BLOCK# AND I.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(O.FLAGS, 128) != 128 AND (BITAND(I.FLAGS, 2) = 0 OR (BITAND(I.FLAGS, 2) != 0 AND (CM.TRUNC > 0 OR CM.TOT_MODS > .1 * CM.ROWCNT))) AND CM.LOCKED = 0 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN I.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_INDEX_BLOCK_COUNT(U.NAME, OI.NAME, NULL, NULL) WHEN S.TYPE# = 6 THEN DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), I.DATAOBJ#, S.BLOCKS) ELSE NULL END * NVL(TS.BLOCKSIZE, :B4 ) OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, NULL PART#, NULL BO# FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OBJ$ OI WHERE :B1 IS NOT NULL AND I.TYPE# = 4 AND I.BO# = OT.OB
J# AND BITAND(OT.FLAGS, 128) != 128 AND OT.OWNER# = U.USER# AND M.OBJ#(+) = OT.OBJ# AND I.FILE# = S.FILE#(+) AND I.BLOCK# = S.BLOCK#(+) AND I.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND T.OBJ# = OT.OBJ# AND I.OBJ# = OI.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT)))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT /*+ leading(i t) no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, PART#, BO# FROM (SELECT DECODE(BITAND(TP.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(TP.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(TP.ROWCNT, (TP.ROWCNT + M.INSERTS - M.DELETES)))) / (TP.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(IP.TS#, IP.FILE#, IP.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), IP.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, TP.PART# PART#, TP.BO# BO# FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.INDPART$ IP, SYS.TABPART$ TP, SYS.SEG$ S, SYS.MON_MODS_ALL$ M,
SYS.TS$ TS, SYS.TAB$ T WHERE I.TYPE# = 4 AND S.TYPE# = 6 AND OT.OWNER# = U.USER# AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# AND TP.OBJ# = OT.OBJ# AND I.BO# = TP.BO# AND BITAND(OT.FLAGS, 128) != 128 AND M.OBJ#(+) = OT.OBJ# AND IP.FILE# = S.FILE# AND IP.BLOCK# = S.BLOCK# AND IP.TS# = S.TS# AND TS.TS# = S.TS# AND I.BO# = T.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(TP.FLAGS, 32) != 32 AND ((BITAND(TP.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * TP.ROWCNT)))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(TP.FLAGS, 2) != 2))) WHERE :B5 IS NOT NULL UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B4 OSIZE, I.OBJ# OBJ#, 1 TYPE#, 32 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, NULL PART#, I.BO# BO# FROM SYS.IND$ I, SYS.TAB$ T, SYS.OBJ$ O, USER$ U WHERE (:B8 IS NOT NULL) AND :B1 IS NOT NULL AND BITAND(I.PROPERTY, 32) != 32 AND BITAND(I.PROPERTY, 64) != 64 AND BITAND(I.FLAGS, 2) != 2 AND I.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 16) = 16 AND I.OBJ# = O.OBJ# AND I.TYPE# != 4 AND I.TYPE# != 8 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 AND BITAND(O.FLAGS, 128) != 128 AND O.OWNER# = U.USER# AND NOT (U.NAME = 'SYS' AND O.NAME = 'I_SUMDELTA$') UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B4 OSIZE, I.OBJ# OBJ#, 20 TYPE#, 64 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, I.PART# PART#, I
.BO# BO# FROM (SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDPART$ WHERE BITAND(FLAGS, 2) != 2 UNION ALL SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDCOMPART$ WHERE BITAND(FLAGS, 2) != 2 ) I, SYS.IND$ IND, SYS.TAB$ T, SYS.OBJ$ OI WHERE (:B8 IS NOT NULL) AND :B5 IS NOT NULL AND I.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B4 OSIZE, I.OBJ# OBJ#, 35 TYPE#, 0 AFLAGS, 0 STATUS, :B3 SID, :B2 SERIAL#, I.SUBPART# PART#, I.POBJ# BO# FROM SYS.INDSUBPART$ I, SYS.INDCOMPART$ ICP, SYS.IND$ IND, SYS.TAB$ T, SYS.PARTOBJ$ PO, SYS.OBJ$ OI WHERE (:B8 IS NOT NULL) AND BITAND(I.FLAGS, 2) != 2 AND I.POBJ# = ICP.OBJ# AND ICP.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = PO.OBJ# AND ((:B7 IS NOT NULL AND BITAND(PO.SPARE2, 255) = 2) OR (:B6 IS NOT NULL AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 ) WHERE OSIZE IS NOT NULL ) NEW ON (ST.OBJ# = NEW.OBJ#) WHEN MATCHED THEN UPDATE SET ST.STALENESS = CASE WHEN BITAND(ST.FLAGS, 7) > 1 THEN GREATEST(NEW.STALENESS, -0.5) + ROUND(BITAND(ST.FLAGS, 7)*0.15, 1) ELSE NEW.STALENESS END, ST.OSIZE = NEW.OSIZE * DECODE(BITAND(ST.FLA
GS, 7), 0, 1, 2), ST.FLAGS = ST.FLAGS - BITAND(ST.FLAGS, 32+64+128) + NEW.AFLAGS, ST.STATUS = 0, ST.TYPE# = NEW.TYPE#, ST.PART# = NEW.PART#, ST.BO# = NEW.BO#, ST.SID = NEW.SID, ST.SERIAL# = NEW.SERIAL# WHEN NOT MATCHED THEN INSERT (ST.STALENESS, ST.OSIZE, ST.OBJ#, ST.TYPE#, ST.FLAGS, ST.STATUS, ST.SID, ST.SERIAL#, ST.PART#, ST.BO#) VALUES (NEW.STALENESS, NEW.OSIZE, NEW.OBJ#, NEW.TYPE#, NEW.AFLAGS, NEW.STATUS, :B3 , :B2 , NEW.PART#, NEW.BO#) |
d92h3rjp0y217 | begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end; |
du5yw0cqjr4hj | SELECT DISTINCT D.NAME, TRIM(SUBSTR(C.DATA_VALUE_MIN, INSTR(C.DATA_VALUE_MIN, ')', 1)+1)) DATA_VALUE_MIN, TRIM(SUBSTR(C.DATA_VALUE_MAX, INSTR(C.DATA_VALUE_MAX, ')', 1)+1)) DATA_VALUE_MAX , C.NUM_TYPE, D.CODE FROM YTO_MID_ROAD B, YTO_MID_ROAD_NUM C, YTO_JINGANG_STATION D WHERE (B.NAME = '³£ÊìÊÐ' /*OR B.ALIAS1='³£ÊìÊÐ' OR B.ALIAS2='³£ÊìÊÐ' OR B.ALIAS3='³£ÊìÊÐ'*/ OR B.NAME like'%½ËÕÊ¡%' /* OR B.ALIAS1='½ËÕÊ¡' OR B.ALIAS2='½ËÕÊ¡' OR B.ALIAS3='½ËÕÊ¡'*/ ) AND B.ROAD_ID = C.ROAD_ID AND B.ISDELETE=0 AND C.ISDELETE=0 AND C.IS_REACH=1 AND D.USED='Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND C.OUTLET_ID = D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') UNION SELECT DISTINCT D.NAME, '0', '0', 3, D.CODE FROM YTO_MID_POI B, YTO_JINGANG_STATION D WHERE ( B.NAME='³£ÊìÊÐ' OR B.NAME like'%½ËÕÊ¡%' /* OR B.ALIAS1='½ËÕÊ¡' OR B.ALIAS2='½ËÕÊ¡' OR B.ALIAS3='½ËÕÊ¡'*/ ) AND D.USED = 'Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND B.OUTLET_ID=D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') |
frr9vmmcsadhb | select * from ( select distinct a.id, a.task_id, a.later_status, a.lazy_time, a.vehicle_no, a.line_name, to_char(a.gps_time, 'yyyy-MM-dd HH24:mi:ss'), a.is_disposal, b.name, c.device_id from t_later_info a, yto_org_node b, yto_in_out_area_s c, (select g.gid from t_privilage_group g start with g.gid = (select gid from ref_user_group where user_id = (select id from t_user where user_account = '00002578'))connect by prior g.gid = g.parent_id) d where a.task_id = c.task_id and b.org_id = ( case a.later_status when 1 then c.start_org_code else c.end_org_code end)and a.is_disposal = 0 and sysdate - a.gps_time < 5 and (c.start_org_code = d.gid or c.end_org_code = d.gid ) ) where rownum <= :1 |
fw268s02gfmpb |
SELECT DISTINCT D.NAME, TRIM(SUBSTR(C.DATA_VALUE_MIN, INSTR(C.DATA_VALUE_MIN, ')', 1)+1)) DATA_VALUE_MIN, TRIM(SUBSTR(C.DATA_VALUE_MAX, INSTR(C.DATA_VALUE_MAX, ')', 1)+1)) DATA_VALUE_MAX , C.NUM_TYPE, D.CODE FROM YTO_MID_ROAD B, YTO_MID_ROAD_NUM C, YTO_JINGANG_STATION D WHERE (B.NAME = 'ÎâÖÐÇø' /*OR B.ALIAS1='ÎâÖÐÇø' OR B.ALIAS2='ÎâÖÐÇø' OR B.ALIAS3='ÎâÖÐÇø'*/ OR B.NAME like'%ËÕÖÝÊÐ%' /* OR B.ALIAS1='ËÕÖÝÊÐ' OR B.ALIAS2='ËÕÖÝÊÐ' OR B.ALIAS3='ËÕÖÝÊÐ'*/ OR B.NAME like'%ÎâÖÐÇø%' /* OR B.ALIAS1='ÎâÖÐÇø' OR B.ALIAS2='ÎâÖÐÇø' OR B.ALIAS3='ÎâÖÐÇø'*/ OR B.NAME ='ËÕ' /*OR B.ALIAS1='ËÕ' OR B.ALIAS2='ËÕ' OR B.ALIAS3='ËÕ'*/ OR B.NAME ='ÒÍ' /*OR B.ALIAS1='ÒÍ' OR B.ALIAS2='ÒÍ' OR B.ALIAS3='ÒÍ'*/ OR B.NAME ='·' /*OR B.ALIAS1='·' OR B.ALIAS2='·' OR B.ALIAS3='·'*/ OR B.NAME ='5' /*OR B.ALIAS1='5' OR B.ALIAS2='5' OR B.ALIAS3='5'*/ OR B.NAME like'%1ºÅ%' /* OR B.ALIAS1='1ºÅ' OR B.ALIAS2='1ºÅ' OR B.ALIAS3='1ºÅ'*/ OR B.NAME like'%ÓÀ³Ç%' /* OR B.ALIAS1='ÓÀ³Ç' OR B.ALIAS2='ÓÀ³Ç' OR B.ALIAS3='ÓÀ³Ç'*/ ) AND B.ROAD_ID = C.ROAD_ID AND B.ISDELETE=0 AND C.ISDELETE=0 AND C.IS_REACH=1 AND D.USED='Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND C.OUTLET_ID = D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') UNION SELECT DISTINCT D.NAME, '0', '0', 3, D.CODE FROM YTO_MID_POI B, YTO_JINGANG_STATION D WHERE ( B.NAME='ÎâÖÐÇø' OR B.NAME like'%ËÕÖÝÊÐ%' /* OR B.ALIAS1='ËÕÖÝÊÐ' OR B.ALIAS2='ËÕÖÝÊÐ' OR B.AL
IAS3='ËÕÖÝÊÐ'*/ OR B.NAME like'%ÎâÖÐÇø%' /* OR B.ALIAS1='ÎâÖÐÇø' OR B.ALIAS2='ÎâÖÐÇø'
OR B.ALIAS3='ÎâÖÐÇø'*/ OR B.NAME ='ËÕ' /*OR B.ALIAS1='ËÕ' OR B.ALIAS2='ËÕ' OR B.ALIAS3='ËÕ'*/ OR B.NAME ='ÒÍ' /*OR B.ALIAS1='ÒÍ' OR B.ALIAS2='ÒÍ' OR B.ALIAS3='ÒÍ'*/ OR B.NAME ='·' /*OR B.ALIAS1='·' OR B.ALIAS2='·' OR B.ALIAS3='·'*/ OR B.NAME ='5' /*OR B.ALIAS1='5' OR B.ALIAS2='5' OR B.ALIAS3='5'*/ OR B.NAME like'%1ºÅ%' /* OR B.ALIAS1='1ºÅ' OR B.ALIAS2='1ºÅ' OR B.ALIAS3='1ºÅ'*/ OR B.NAME like'%ÓÀ³Ç%' /* OR B.ALIAS1='ÓÀ³Ç' OR B.ALIAS2='ÓÀ³Ç' OR B.ALIAS3='ÓÀ³Ç'*/ ) AND D.USED = 'Y' AND D.TYPE IN ('SUB_DEPARTMENT' , 'BRANCH') AND B.OUTLET_ID=D.CODE AND SUBSTR(B.DISTRICT_IDS, 0, INSTR(B.DISTRICT_IDS || ', ', ', ', 6)-1) =(SELECT T.DISTRICT_IDS FROM YTO_DISTRICT T WHERE T.NAME='ËÕÖÝÊÐ') |
Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
HIS_GPS_01_1 | +DATADG/gpsdb/dbf_01_01.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_1 | +DATADG/gpsdb/dbf_01_1.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_1 | +DATADG/gpsdb/dbf_01_11.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_1 | +DATADG/gpsdb/dbf_01_21.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_1 | +DATADG/gpsdb/dbf_01_31.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_2 | +DATADG/gpsdb/dbf_01_02.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_2 | +DATADG/gpsdb/dbf_01_12.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_2 | +DATADG/gpsdb/dbf_01_2.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_2 | +DATADG/gpsdb/dbf_01_22.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_2 | +DATADG/gpsdb/dbf_01_32.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_3 | +DATADG/gpsdb/dbf_01_03.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_3 | +DATADG/gpsdb/dbf_01_13.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_3 | +DATADG/gpsdb/dbf_01_3.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_1 | +DATADG/gpsdb/dbf_02_01.dbf |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_1 | +DATADG/gpsdb/dbf_02_1.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_1 | +DATADG/gpsdb/dbf_02_11.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_1 | +DATADG/gpsdb/dbf_02_21.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_1 | +DATADG/gpsdb/dbf_02_31.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_2 | +DATADG/gpsdb/dbf_02_02.dbf |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_2 | +DATADG/gpsdb/dbf_02_12.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_2 | +DATADG/gpsdb/dbf_02_2.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_2 | +DATADG/gpsdb/dbf_02_22.dbf |
11 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_2 | +DATADG/gpsdb/dbf_02_32.dbf |
11 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_3 | +DATADG/gpsdb/dbf_02_03.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_3 | +DATADG/gpsdb/dbf_02_13.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_3 | +DATADG/gpsdb/dbf_02_3.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_03_1 | +DATADG/gpsdb/dbf_03_1 |
11 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_03_1 | +DATADG/gpsdb/dbf__03_01.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_03_1 | +DATADG/gpsdb/dbf__03_11.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_03_2 | +DATADG/gpsdb/dbf_03_02.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_03_2 | +DATADG/gpsdb/dbf_03_12.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_03_2 | +DATADG/gpsdb/dbf_03_2 |
11 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_03_3 | +DATADG/gpsdb/dbf_03_03.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_03_3 | +DATADG/gpsdb/dbf_03_13.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_03_3 | +DATADG/gpsdb/dbf_03_3 |
11 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_04_1 | +DATADG/gpsdb/dbf_04_1 |
11 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_04_2 | +DATADG/gpsdb/dbf_04_2 |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_04_3 | +DATADG/gpsdb/dbf_04_3 |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_05_1 | +DATADG/gpsdb/dbf_05_1 |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_05_2 | +DATADG/gpsdb/dbf_05_2 |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_05_3 | +DATADG/gpsdb/dbf_05_3 |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_06_1 | +DATADG/gpsdb/dbf_06_1.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_06_1 | +DATADG/gpsdb/dbf_06_1b.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_06_2 | +DATADG/gpsdb/dbf_06_2.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_06_2 | +DATADG/gpsdb/dbf_06_2b.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_06_3 | +DATADG/gpsdb/dbf_06_3.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_06_3 | +DATADG/gpsdb/dbf_06_3b.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_07_1 | +DATADG/gpsdb/dbf_07_1.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_07_1 | +DATADG/gpsdb/dbf_07_1b.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_07_2 | +DATADG/gpsdb/dbf_07_2.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_07_2 | +DATADG/gpsdb/dbf_07_2b.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_07_3 | +DATADG/gpsdb/dbf_07_3.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_07_3 | +DATADG/gpsdb/dbf_07_3b.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_08_1 | +DATADG/gpsdb/dbf_08_1.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_08_1 | +DATADG/gpsdb/dbf_08_1b.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_08_1 | +FLASHAREA_DG/gpsdb/dbf_08_2.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_08_2 | +DATADG/gpsdb/dbf_08_2.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_08_2 | +DATADG/gpsdb/dbf_08_2b.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_08_3 | +DATADG/gpsdb/dbf_08_3.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_08_3 | +DATADG/gpsdb/dbf_08_3b.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_08_3 | +DATADG/gpsdb/dbf_08_3c.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_09_1 | +DATADG/gpsdb/dbf_09_1.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_09_1 | +DATADG/gpsdb/dbf_09_1_01.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_09_2 | +DATADG/gpsdb/dbf_09_2.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_09_2 | +DATADG/gpsdb/dbf_09_2b.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_09_2 | +DATADG/gpsdb/dbf_10_2_03.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_09_3 | +DATADG/gpsdb/dbf_09_3.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_09_3 | +DATADG/gpsdb/dbf_09_3b.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_10_1 | +DATADG/gpsdb/dbf_10_1.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_10_1 | +DATADG/gpsdb/dbf_10_1_02.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_10_2 | +DATADG/gpsdb/dbf_10_2.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_10_2 | +DATADG/gpsdb/dbf_10_2_02.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_10_2 | +DATADG/gpsdb/dbf_10_2_12.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_10_3 | +DATADG/gpsdb/dbf_10_3.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_10_3 | +DATADG/gpsdb/dbf_10_3_02.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_10_3 | +DATADG/gpsdb/dbf_10_3_03.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_10_3 | +DATADG/gpsdb/dbf_10_3_13.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_11_1 | +DATADG/gpsdb/dbf_11_1.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_11_1 | +DATADG/gpsdb/dbf_11_1_02.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_11_2 | +DATADG/gpsdb/dbf_11_2.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_11_2 | +DATADG/gpsdb/dbf_11_2_02.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_11_2 | +DATADG/gpsdb/dbf_11_2_12.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_11_3 | +DATADG/gpsdb/dbf_11_3.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_11_3 | +DATADG/gpsdb/dbf_11_3_02.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_11_3 | +DATADG/gpsdb/dbf_11_3_03.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_12_1 | +DATADG/gpsdb/dbf_12_01.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_12_1 | +DATADG/gpsdb/dbf_12_1.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_1 | +DATADG/gpsdb/dbf_12_11.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_12_2 | +DATADG/gpsdb/dbf_12_02.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_12_2 | +DATADG/gpsdb/dbf_12_12.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_12_2 | +DATADG/gpsdb/dbf_12_2.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_3 | +DATADG/gpsdb/dbf_12_03.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_12_3 | +DATADG/gpsdb/dbf_12_23.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_3 | +DATADG/gpsdb/dbf_12_3.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_3 | +DATADG/gpsdb/dbf_12_3_13.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_20130501 | +DATADG/gpsdb/dbf_130501.dbf |
2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_20130502 | +DATADG/gpsdb/dbf_130502.dbf |
2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_20130503 | +DATADG/gpsdb/dbf_130503.dbf |
2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
SPLEX_TSP | +DATADG/gpsdb/splex_tbs_01.dbf |
2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
SYSAUX | +DATADG/gpsdb/sysaux01.dbf |
55 | 0 | 4.36 | 1.51 | 608 | 0 | 0 | 0.00 |
SYSTEM | +DATADG/gpsdb/system01.dbf |
33 | 0 | 5.76 | 1.00 | 87 | 0 | 0 | 0.00 |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_01.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_02.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_03.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_04.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_05.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_06.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_07.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_08.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_09.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_10.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
UNDOTBS1 | +DATADG/gpsdb/undotbs01.dbf |
2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
UNDOTBS1 | +DATADG/gpsdb/undotbs03.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
UNDOTBS1 | +DATADG/gpsdb/undotbs05.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
UNDOTBS2 | +DATADG/gpsdb/undotbs02.dbf |
2 | 0 | 0.00 | 1.00 | 71 | 0 | 0 | 0.00 |
UNDOTBS2 | +DATADG/gpsdb/undotbs04.dbf |
6 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
UNDOTBS2 | +DATADG/gpsdb/undotbs06.dbf |
6 | 0 | 0.00 | 1.00 | 52 | 0 | 2 | 0.00 |
UNDOTBS2 | +DATADG/gpsdb/undotbs07.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
UNDOTBS2 | +DATADG/gpsdb/undotbs08.dbf |
6 | 0 | 0.00 | 1.00 | 8 | 0 | 0 | 0.00 |
USERS | +DATADG/gpsdb/users01.dbf |
2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_01.dbf |
52 | 0 | 2.12 | 1.10 | 4 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_02.dbf |
74 | 0 | 1.89 | 1.01 | 3 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_03.dbf |
62 | 0 | 4.03 | 1.08 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_04.dbf |
82 | 0 | 2.68 | 1.04 | 3 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_05.dbf |
76 | 0 | 2.11 | 1.13 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_06.dbf |
528 | 0 | 1.34 | 2.27 | 4 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_07.dbf |
8 | 0 | 1.25 | 1.00 | 5 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_08.dbf |
17 | 0 | 2.35 | 1.00 | 3 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_09.dbf |
156 | 0 | 1.73 | 2.87 | 3 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_10.dbf |
286 | 0 | 1.43 | 2.36 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_11.dbf |
167 | 0 | 1.38 | 2.26 | 3 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_12.dbf |
409 | 0 | 1.12 | 2.41 | 4 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_13.dbf |
325 | 0 | 1.85 | 3.22 | 3 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_14.dbf |
324 | 0 | 1.45 | 3.23 | 4 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_15.dbf |
322 | 0 | 1.83 | 3.24 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_16.dbf |
312 | 0 | 1.73 | 3.31 | 3 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_17.dbf |
315 | 0 | 1.30 | 3.29 | 3 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_18.dbf |
321 | 0 | 1.18 | 3.21 | 5 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_19.dbf |
325 | 0 | 1.63 | 3.21 | 3 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_20.dbf |
352 | 0 | 1.28 | 2.73 | 4 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_21.dbf |
242 | 0 | 1.94 | 3.10 | 3 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_22.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_23.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_24.dbf |
12 | 0 | 1.67 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_25.dbf |
50 | 0 | 2.60 | 1.02 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_26.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_27.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_28.dbf |
8 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_29.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_30.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_31.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_32.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_33.dbf |
10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_34.dbf |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_35.dbf |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_36.dbf |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_37.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_38.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_39.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +FLASHAREA_DG/gpsdb/wzt_tbs_26.dbf |
4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |