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 |
089dbukv1aanh | SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL |
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 |
0suvf6uupkfv4 |
SELECT T.AUDIT_ID , M.ROAD_ID , N.ROAD_NUM_ID , M.NAME , TRIM('£¬' FROM M.ALIAS1||'£¬'||DECODE(M.ALIAS2, '', '', M.ALIAS2, M.ALIAS2||'£¬')||M.ALIAS3) ALIAS , DECODE(NVL(N.IS_REACH, M.IS_REACH), '1', 'ÅÉËÍ', '0', '²»ÅÉËÍ')IS_REACH , M.OWNER , (SELECT TT.NAME FROM YTO_JINGANG_STATION TT WHERE TT.CODE = M.OWNER AND TT.STATUS = 'VALID') OGNAME , M.DISTRICT_ID , Y.DISTRICT_NAMES DIS_NAME , T.AUDIT_VALUE_TYPE , DECODE(T.STATE, '10', '²Ý¸å', '20', '·Ö¹«Ë¾ÉóºËÖÐ', '30', 'Ê¡ÇøÉóºËÖÐ', '40', '¹ÜÀíÇøÉóºËÖÐ', '50', '×ܹ«Ë¾ÉóºËÖÐ', '60', 'ÉóºËͨ¹ý', '70', 'ÉóºË²»Í¨¹ý' ) STATE , T.STATE AUDIT_STATE_NUM , DECODE(N.NUM_TYPE, 1, 'µ¥ºÅ', 2, 'Ë«ºÅ', 3, 'È«²¿') AS NUM_TYPE , DECODE(T.AUDIT_TYPE, '1', 'ÐÂÔö', '2', 'ÐÞ¸Ä', '3', 'ɾ³ý') AUDIT_TYPE , TO_CHAR(CAST(T.CREATE_TIME AS DATE), 'YYYY-MM-DD HH24:MI:SS')CREATE_TIME , TO_CHAR(NVL(N.DATA_VALUE_MIN, 1)) || '-' ||TO_CHAR(NVL(SUBSTR(N.DATA_VALUE_MAX, INSTR(N.DATA_VALUE_MAX, ')')+1, length(N.DATA_VALUE_MAX)), 9999)) DATA_VALUE , N.DATA_VALUE_MAX , N.DATA_VALUE_MIN , G.CODE CGCODE , G.NAME CGNAME , M.CREATER CREATER_CODE , U.USER_NAME CREATER_NAME , T.COMMENTS , '' NEW_RELEASE , T.AUDIT_ORG_ID , T.AUDIT_ORG_NAME , T.AUDITOR_ID , T.AUDITOR_NAME , T.AUDIT_TIME , DECODE(
N.IS_SINGLE, '0', '·ñ' , '1' , 'ÊÇ') IS_SINGLE
, N.FLOOR_VALUE FROM YTO_MID_ROAD M , (SELECT A.*, B.DATA_VALUE_MIN||'-'||B.DATA_VALUE_MIN FLOOR_VALUE FROM YTO_MID_ROAD_NUM A LEFT JOIN YTO_MID_POI_DTL B ON A.ROAD_NUM_ID = B.ROAD_NUM_ID) N , ( SELECT A.* , B.COMMENTS , B.AUDIT_ORG_ID , S.NAME AUDIT_ORG_NAME , B.AUDITOR_ID , TO_CHAR(B.AUDIT_TIME, 'YYYY-MM-DD HH24:MI:SS') AUDIT_TIME , U.USER_NAME AUDITOR_NAME FROM (SELECT P.* FROM YTO_AUDIT_RECORD P WHERE P.OUTLET_ID = :1 AND P.STATE = :2 ) A LEFT JOIN (SELECT Q.*, ROW_NUMBER() OVER(PARTITION BY Q.AUDIT_ID ORDER BY Q.AUDIT_TIME DESC) RN FROM YTO_AUDIT_DETAIL Q) B ON A.AUDIT_ID = B.AUDIT_ID AND B.RN = 1 LEFT JOIN YTO_JINGANG_STATION S ON (S.CODE = B.AUDIT_ORG_ID AND S.STATUS = 'VALID') LEFT JOIN YTO_JINGANG_USER U ON U.USER_CODE = B.AUDITOR_ID ) T , YTO_JINGANG_STATION G , YTO_JINGANG_USER U , YTO_MID_DISTRICT Y WHERE N.ISDELETE = 0 AND M.ROAD_ID = N.ROAD_ID AND G.STATUS = 'VALID' AND N.ROAD_NUM_ID = T.AUDIT_VALUE AND T.OUTLET_ID = G.CODE AND U.USER_CODE = T.CREATOR_ID AND M.DISTRICT_ID = Y.DISTRICT_ID
|
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)) |
2h79jm9f76rau |
SELECT * FROM (SELECT A.*, ROWNUM RN FROM( SELECT T1.ROAD_ID , T1.NAME , CASE WHEN T2.DATA_VALUE_MIN IS NULL AND T2.DATA_VALUE_MAX IS NULL THEN '' WHEN T2.DATA_VALUE_MIN IS NOT NULL AND T2.DATA_VALUE_MAX IS NULL THEN T2.DATA_VALUE_MIN WHEN T2.DATA_VALUE_MIN IS NULL AND T2.DATA_VALUE_MAX IS NOT NULL THEN T2.DATA_VALUE_MAX WHEN T2.DATA_VALUE_MIN IS NOT NULL AND T2.DATA_VALUE_MAX IS NOT NULL THEN (TO_CHAR(T2.DATA_VALUE_MIN) ||'-'||(TO_CHAR(SUBSTR(T2.DATA_VALUE_MAX, INSTR(T2.DATA_VALUE_MAX, ')')+1, length(T2.DATA_VALUE_MAX))))) END AS DATA_VALUE , DECODE(T2.IS_REACH, 1, 'ÅÉËÍ', 0, '²»ÅÉËÍ') AS IS_REACH , TRIM(', ' FROM T1.ALIAS1||', '||DECODE(T1.ALIAS2, '', '', T1.ALIAS2, T1.ALIAS2||', ')||T1.ALIAS3) AS ALIAS1 , T2.OWNER , T2.CREATE_STATION_CODE , T2.CREATER , T2.ROAD_NUM_ID , T1.DISTRICT_ID , T6.DISTRICT_NAMES , T6.LEVELS , T2.DATA_VALUE_MIN , T2.DATA_VALUE_MAX , DECODE(T2.NUM_TYPE, 1, 'µ¥ºÅ', 2, 'Ë«ºÅ', 3, 'È«²¿') AS NUM_TYPE , DECODE(T5.AUDIT_TYPE, 1, 'ÐÂÔö', 2, 'ÐÞ¸Ä', 3, 'ɾ³ý') AS AUDIT_TYPE , DECODE(T2.IS_SINGLE, '0', '·ñ', '1', 'ÊÇ') IS_SINGLE , T3.NAME G_NAME , T7.NAME AS G_NAME2 , DECODE(T5.STATE, 10, '²Ý¸å', 20, '·Ö¹«Ë¾ÉóºËÖÐ', 30, 'Ê¡ÇøÉóºËÖÐ', 40, '¹ÜÀíÇøÉóºËÖÐ', 50, '×ܹ«Ë¾ÉóºËÖÐ', 60, 'ÉóºËͨ¹ý', 70, 'ÉóºË²»Í¨¹ý') AS STATE , T5.CREATE_TIME , T2.FLOOR_VALUE , '' NOPASSREASON FROM YTO_MID_ROAD T1
LEFT JOIN (SELECT A.*, B.DATA_VALUE_MIN||'-'||B
.DATA_VALUE_MIN FLOOR_VALUE FROM YTO_MID_ROAD_NUM A LEFT JOIN YTO_MID_POI_DTL B ON A.ROAD_NUM_ID = B.ROAD_NUM_ID) T2 ON T1.ROAD_ID = T2.ROAD_ID LEFT JOIN YTO_JINGANG_STATION T3 ON (T1.OWNER = T3.CODE AND T3.STATUS = 'VALID') LEFT JOIN YTO_JINGANG_USER T4 ON T1.CREATER = T4.USER_CODE LEFT JOIN YTO_AUDIT_RECORD T5 ON T2.ROAD_NUM_ID = T5.AUDIT_VALUE LEFT JOIN YTO_MID_DISTRICT T6 ON T1.DISTRICT_ID = T6.DISTRICT_ID LEFT JOIN YTO_JINGANG_STATION T7 ON (T1.CREATE_STATION_CODE = T7.CODE AND T7.STATUS = 'VALID') WHERE T2.ISDELETE = '0' AND T1.OWNER IN (SELECT CODE FROM YTO_JINGANG_STATION WHERE STATUS = 'VALID' START WITH CODE = :1 CONNECT BY PRIOR ID = PARENT_ID) AND T2.ROAD_NUM_ID IS NOT NULL AND T1.NAME LIKE '%'||:2||'%' ORDER BY T1.CREATE_TIME DESC) A WHERE ROWNUM <=:3) WHERE RN >= :4 |
350f5yrnnmshs | lock table sys.mon_mods$ in exclusive mode nowait |
396ga4w3na138 |
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 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 ='·' /*OR B.ALIAS1='·' OR B.ALIAS2='·' OR B.ALIAS3='·'*/ OR B.NAME like'%2ºÅ%' /* OR B.ALIAS1='2ºÅ' OR B.ALIAS2='2ºÅ' OR B.ALIAS3='2ºÅ'*/ 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 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 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'%2ºÅ%' /* OR B.ALIAS1='2ºÅ' OR B.ALIAS2='2ºÅ' OR B.ALIAS3='2ºÅ'*/ 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 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='ËÕÖÝÊÐ') |
459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
54g344fvq2153 | SELECT T6.DISTRICT_NAMES , T1.NAME , CASE WHEN T2.DATA_VALUE_MIN IS NULL AND T2.DATA_VALUE_MAX IS NULL THEN '' WHEN T2.DATA_VALUE_MIN IS NOT NULL AND T2.DATA_VALUE_MAX IS NULL THEN T2.DATA_VALUE_MIN WHEN T2.DATA_VALUE_MIN IS NULL AND T2.DATA_VALUE_MAX IS NOT NULL THEN T2.DATA_VALUE_MAX WHEN T2.DATA_VALUE_MIN IS NOT NULL AND T2.DATA_VALUE_MAX IS NOT NULL THEN (TO_CHAR(T2.DATA_VALUE_MIN) ||'-'||(TO_CHAR(SUBSTR(T2.DATA_VALUE_MAX, INSTR(T2.DATA_VALUE_MAX, ')')+1, length(T2.DATA_VALUE_MAX))))) END AS DATA_VALUE , DECODE(T2.NUM_TYPE, 1, 'µ¥ºÅ', 2, 'Ë«ºÅ', 3, 'È«²¿') AS NUM_TYPE , DECODE(T2.IS_REACH, 1, 'ÅÉËÍ', 0, '²»ÅÉËÍ') AS IS_REACH , T1.OWNER , T3.NAME G_NAME FROM YTO_MID_ROAD T1 INNER JOIN YTO_MID_ROAD_NUM T2 ON T1.ROAD_ID = T2.ROAD_ID INNER JOIN YTO_JINGANG_STATION T3 ON (T1.OWNER = T3.CODE AND T3.STATUS = 'VALID') INNER JOIN YTO_JINGANG_USER T4 ON T1.CREATER = T4.USER_CODE INNER JOIN YTO_AUDIT_RECORD T5 ON T2.ROAD_NUM_ID = T5.AUDIT_VALUE INNER JOIN YTO_MID_DISTRICT T6 ON T1.DISTRICT_ID = T6.DISTRICT_ID AND T1.NAME = :1 AND T1.DISTRICT_ID = :2 AND T1.ISDELETE = '0' |
5kyb5bvnu3s04 | SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1 |
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 |
6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
6wsph5c17t4kb |
SELECT COUNT(1) FROM ( SELECT P.STATION_CODE, P.STATION_NAME, NVL(SUM(CASE WHEN AUDIT_STATE = '10' THEN NVL(P.ROAD_NUM, 0) END), 0)D_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '10' THEN NVL(P.POI_NUM, 0) END), 0)D_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '10' THEN NVL(P.DIS_NUM, 0) END), 0)D_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '20' THEN NVL(P.ROAD_NUM, 0) END), 0)S_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '20' THEN NVL(P.POI_NUM, 0) END), 0)S_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '20' THEN NVL(P.DIS_NUM, 0) END), 0)S_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '30' THEN NVL(P.ROAD_NUM, 0) END), 0)P_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '30' THEN NVL(P.POI_NUM, 0) END), 0)P_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '30' THEN NVL(P.DIS_NUM, 0) END), 0)P_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '40' THEN NVL(P.ROAD_NUM, 0) END), 0)M_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '40' THEN NVL(P.POI_NUM, 0) END), 0)M_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '40' THEN NVL(P.DIS_NUM, 0) END), 0)M_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '50' THEN NVL(P.ROAD_NUM, 0) END), 0)H_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '50' THEN NVL(P.POI_NUM, 0) END), 0)H_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '50' THEN NVL(P.DIS_NUM, 0) END), 0)H_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '60' THEN NVL(P.ROAD_NUM, 0) END), 0)C_NUM_ROAD, NVL(SUM
(CASE WHEN AUDIT_STATE = '60' THEN NVL(P.POI_NUM, 0) END), 0)C_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '60' THEN NVL(P.DIS_NUM, 0) END), 0)C_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '70' THEN NVL(P.ROAD_NUM, 0) END), 0)N_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '70' THEN NVL(P.POI_NUM, 0) END), 0)N_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '70' THEN NVL(P.DIS_NUM, 0) END), 0)N_NUM_DISTRICT FROM YTO_AUDIT_STATISTICS P WHERE P.STATION_CODE IN( SELECT G.CODE FROM YTO_JINGANG_STATION G WHERE G.STATUS = 'VALID' START WITH G.CODE = (SELECT USER_ORG_CODE FROM YTO_JINGANG_USER WHERE USER_CODE = :1) CONNECT BY PRIOR G.ID = G.PARENT_ID ) GROUP BY P.STATION_CODE, P.STATION_NAME ) |
6xvp6nxs4a9n4 | select nvl(sum(space), 0) from recyclebin$ where ts# = :1 |
7bwxgqjqqwn1y | SELECT COUNT(1) FROM YTO_MID_ROAD T1 LEFT JOIN YTO_MID_ROAD_NUM T2 ON T1.ROAD_ID = T2.ROAD_ID LEFT JOIN YTO_JINGANG_STATION T3 ON (T1.CREATE_STATION_CODE = T3.CODE AND T3.STATUS = 'VALID') LEFT JOIN YTO_JINGANG_USER T4 ON T1.CREATER = T4.USER_CODE LEFT JOIN YTO_AUDIT_RECORD T5 ON T2.ROAD_NUM_ID = T5.AUDIT_VALUE LEFT JOIN YTO_MID_DISTRICT T6 ON T1.DISTRICT_ID = T6.DISTRICT_ID LEFT JOIN YTO_JINGANG_STATION T7 ON (T1.CREATE_STATION_CODE = T7.CODE AND T7.STATUS = 'VALID') WHERE T2.ISDELETE = '0' AND T1.OWNER IN (SELECT CODE FROM YTO_JINGANG_STATION WHERE STATUS = 'VALID' START WITH CODE = :1 CONNECT BY PRIOR ID = PARENT_ID) AND T2.ROAD_NUM_ID IS NOT NULL AND T1.NAME LIKE '%'||:2||'%' |
84qubbrsr0kfn | insert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash |
8f1sjvfxuup9w | select t.*, o.*, m.comments
from sys.all_tables t,
sys.all_tab_comments m,
sys.all_objects o
where t.owner = :object_owner
and t.table_name = :object_name
and m.owner (+) = :object_owner
and m.table_name (+) = :object_name
and o.owner (+) = :object_owner
and o.object_name (+) = :object_name
and :object_type is not null
and :sub_object is null
|
9g8rftjc929u0 |
SELECT * FROM (SELECT A.*, ROWNUM RN FROM( SELECT T1.ROAD_ID , T1.NAME , CASE WHEN T2.DATA_VALUE_MIN IS NULL AND T2.DATA_VALUE_MAX IS NULL THEN '' WHEN T2.DATA_VALUE_MIN IS NOT NULL AND T2.DATA_VALUE_MAX IS NULL THEN T2.DATA_VALUE_MIN WHEN T2.DATA_VALUE_MIN IS NULL AND T2.DATA_VALUE_MAX IS NOT NULL THEN T2.DATA_VALUE_MAX WHEN T2.DATA_VALUE_MIN IS NOT NULL AND T2.DATA_VALUE_MAX IS NOT NULL THEN (TO_CHAR(T2.DATA_VALUE_MIN) ||'-'||(TO_CHAR(SUBSTR(T2.DATA_VALUE_MAX, INSTR(T2.DATA_VALUE_MAX, ')')+1, length(T2.DATA_VALUE_MAX))))) END AS DATA_VALUE , DECODE(T2.IS_REACH, 1, 'ÅÉËÍ', 0, '²»ÅÉËÍ') AS IS_REACH , TRIM(', ' FROM T1.ALIAS1||', '||DECODE(T1.ALIAS2, '', '', T1.ALIAS2, T1.ALIAS2||', ')||T1.ALIAS3) AS ALIAS1 , T2.OWNER , T2.CREATE_STATION_CODE , T2.CREATER , T2.ROAD_NUM_ID , T1.DISTRICT_ID , T6.DISTRICT_NAMES , T6.LEVELS , T2.DATA_VALUE_MIN , T2.DATA_VALUE_MAX , DECODE(T2.NUM_TYPE, 1, 'µ¥ºÅ', 2, 'Ë«ºÅ', 3, 'È«²¿') AS NUM_TYPE , DECODE(T5.AUDIT_TYPE, 1, 'ÐÂÔö', 2, 'ÐÞ¸Ä', 3, 'ɾ³ý') AS AUDIT_TYPE , DECODE(T2.IS_SINGLE, '0', '·ñ', '1', 'ÊÇ') IS_SINGLE , T3.NAME G_NAME , T7.NAME AS G_NAME2 , DECODE(T5.STATE, 10, '²Ý¸å', 20, '·Ö¹«Ë¾ÉóºËÖÐ', 30, 'Ê¡ÇøÉóºËÖÐ', 40, '¹ÜÀíÇøÉóºËÖÐ', 50, '×ܹ«Ë¾ÉóºËÖÐ', 60, 'ÉóºËͨ¹ý', 70, 'ÉóºË²»Í¨¹ý') AS STATE , T5.CREATE_TIME , T2.FLOOR_VALUE , '' NOPASSREASON FROM YTO_MID_ROAD T1
LEFT JOIN (SELECT A.*, B.DATA_VALUE_MIN||'-'||B
.DATA_VALUE_MIN FLOOR_VALUE FROM YTO_MID_ROAD_NUM A LEFT JOIN YTO_MID_POI_DTL B ON A.ROAD_NUM_ID = B.ROAD_NUM_ID) T2 ON T1.ROAD_ID = T2.ROAD_ID LEFT JOIN YTO_JINGANG_STATION T3 ON (T1.OWNER = T3.CODE AND T3.STATUS = 'VALID') LEFT JOIN YTO_JINGANG_USER T4 ON T1.CREATER = T4.USER_CODE LEFT JOIN YTO_AUDIT_RECORD T5 ON T2.ROAD_NUM_ID = T5.AUDIT_VALUE LEFT JOIN YTO_MID_DISTRICT T6 ON T1.DISTRICT_ID = T6.DISTRICT_ID LEFT JOIN YTO_JINGANG_STATION T7 ON (T1.CREATE_STATION_CODE = T7.CODE AND T7.STATUS = 'VALID') WHERE T2.ISDELETE = '0' AND T1.OWNER IN (SELECT CODE FROM YTO_JINGANG_STATION WHERE STATUS = 'VALID' START WITH CODE = :1 CONNECT BY PRIOR ID = PARENT_ID) AND T2.ROAD_NUM_ID IS NOT NULL ORDER BY T1.CREATE_TIME DESC) A WHERE ROWNUM <=:2) WHERE RN >= :3 |
ajzh5n7z4wgxh |
SELECT * FROM (SELECT AUDIT_ALL_TEMP.*, ROWNUM RN FROM( SELECT P.STATION_CODE, P.STATION_NAME, NVL(SUM(CASE WHEN AUDIT_STATE = '10' THEN NVL(P.ROAD_NUM, 0) END), 0)D_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '10' THEN NVL(P.POI_NUM, 0) END), 0)D_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '10' THEN NVL(P.DIS_NUM, 0) END), 0)D_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '20' THEN NVL(P.ROAD_NUM, 0) END), 0)S_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '20' THEN NVL(P.POI_NUM, 0) END), 0)S_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '20' THEN NVL(P.DIS_NUM, 0) END), 0)S_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '30' THEN NVL(P.ROAD_NUM, 0) END), 0)P_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '30' THEN NVL(P.POI_NUM, 0) END), 0)P_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '30' THEN NVL(P.DIS_NUM, 0) END), 0)P_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '40' THEN NVL(P.ROAD_NUM, 0) END), 0)M_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '40' THEN NVL(P.POI_NUM, 0) END), 0)M_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '40' THEN NVL(P.DIS_NUM, 0) END), 0)M_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '50' THEN NVL(P.ROAD_NUM, 0) END), 0)H_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '50' THEN NVL(P.POI_NUM, 0) END), 0)H_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '50' THEN NVL(P.DIS_NUM, 0) END), 0)H_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '60' THEN NVL(P.ROAD_NUM, 0
) END), 0)C_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '60' THEN NVL(P.POI_NUM, 0) END), 0)C_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '60' THEN NVL(P.DIS_NUM, 0) END), 0)C_NUM_DISTRICT, NVL(SUM(CASE WHEN AUDIT_STATE = '70' THEN NVL(P.ROAD_NUM, 0) END), 0)N_NUM_ROAD, NVL(SUM(CASE WHEN AUDIT_STATE = '70' THEN NVL(P.POI_NUM, 0) END), 0)N_NUM_POI, NVL(SUM(CASE WHEN AUDIT_STATE = '70' THEN NVL(P.DIS_NUM, 0) END), 0)N_NUM_DISTRICT FROM YTO_AUDIT_STATISTICS P WHERE P.STATION_CODE IN( SELECT G.CODE FROM YTO_JINGANG_STATION G WHERE G.STATUS = 'VALID' START WITH G.CODE = (SELECT USER_ORG_CODE FROM YTO_JINGANG_USER WHERE USER_CODE = :1) CONNECT BY PRIOR G.ID = G.PARENT_ID ) GROUP BY P.STATION_CODE, P.STATION_NAME ) AUDIT_ALL_TEMP WHERE ROWNUM <=:2) WHERE RN >= :3 |
ak9um20829hhf | 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='ËÕÖÝÊÐ') |
an9ph1jq3g7fd | SELECT COUNT(1) FROM YTO_MID_ROAD T1 LEFT JOIN YTO_MID_ROAD_NUM T2 ON T1.ROAD_ID = T2.ROAD_ID LEFT JOIN YTO_JINGANG_STATION T3 ON (T1.CREATE_STATION_CODE = T3.CODE AND T3.STATUS = 'VALID') LEFT JOIN YTO_JINGANG_USER T4 ON T1.CREATER = T4.USER_CODE LEFT JOIN YTO_AUDIT_RECORD T5 ON T2.ROAD_NUM_ID = T5.AUDIT_VALUE LEFT JOIN YTO_MID_DISTRICT T6 ON T1.DISTRICT_ID = T6.DISTRICT_ID LEFT JOIN YTO_JINGANG_STATION T7 ON (T1.CREATE_STATION_CODE = T7.CODE AND T7.STATUS = 'VALID') WHERE T2.ISDELETE = '0' AND T1.OWNER IN (SELECT CODE FROM YTO_JINGANG_STATION WHERE STATUS = 'VALID' START WITH CODE = :1 CONNECT BY PRIOR ID = PARENT_ID) AND T2.ROAD_NUM_ID IS NOT NULL |
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
|
b0320g1xasbx7 | SELECT TIMEZONE_REGION FROM MGMT_TARGETS WHERE TARGET_GUID = :B1 |
bk5k8x08y0wfw |
SELECT COUNT(1) FROM ( SELECT T.AUDIT_ID , M.ROAD_ID , N.ROAD_NUM_ID , M.NAME , TRIM('£¬' FROM M.ALIAS1||'£¬'||DECODE(M.ALIAS2, '', '', M.ALIAS2, M.ALIAS2||'£¬')||M.ALIAS3) ALIAS , DECODE(NVL(N.IS_REACH, M.IS_REACH), '1', 'ÅÉËÍ', '0', '²»ÅÉËÍ')IS_REACH , M.OWNER , (SELECT TT.NAME FROM YTO_JINGANG_STATION TT WHERE TT.CODE = M.OWNER AND TT.STATUS = 'VALID') OGNAME , M.DISTRICT_ID , Y.DISTRICT_NAMES DIS_NAME , T.AUDIT_VALUE_TYPE , DECODE(T.STATE, '10', '²Ý¸å', '20', '·Ö¹«Ë¾ÉóºËÖÐ', '30', 'Ê¡ÇøÉóºËÖÐ', '40', '¹ÜÀíÇøÉóºËÖÐ', '50', '×ܹ«Ë¾ÉóºËÖÐ', '60', 'ÉóºËͨ¹ý', '70', 'ÉóºË²»Í¨¹ý' ) STATE , T.STATE AUDIT_STATE_NUM , DECODE(N.NUM_TYPE, 1, 'µ¥ºÅ', 2, 'Ë«ºÅ', 3, 'È«²¿') AS NUM_TYPE , DECODE(T.AUDIT_TYPE, '1', 'ÐÂÔö', '2', 'ÐÞ¸Ä', '3', 'ɾ³ý') AUDIT_TYPE , TO_CHAR(CAST(T.CREATE_TIME AS DATE), 'YYYY-MM-DD HH24:MI:SS')CREATE_TIME , TO_CHAR(NVL(N.DATA_VALUE_MIN, 1)) || '-' ||TO_CHAR(NVL(SUBSTR(N.DATA_VALUE_MAX, INSTR(N.DATA_VALUE_MAX, ')')+1, length(N.DATA_VALUE_MAX)), 9999)) DATA_VALUE , N.DATA_VALUE_MAX , N.DATA_VALUE_MIN , G.CODE CGCODE , G.NAME CGNAME , M.CREATER CREATER_CODE , U.USER_NAME CREATER_NAME , T.COMMENTS , '' NEW_RELEASE , T.AUDIT_ORG_ID , T.AUDIT_ORG_NAME , T.AUDITOR_ID , T.AUDITOR_NAME , T.AUD
IT_TIME , DECODE(N.IS_SINGLE, '0', '·ñ' , '
1' , 'ÊÇ') IS_SINGLE , N.FLOOR_VALUE FROM YTO_MID_ROAD M , (SELECT A.*, B.DATA_VALUE_MIN||'-'||B.DATA_VALUE_MIN FLOOR_VALUE FROM YTO_MID_ROAD_NUM A LEFT JOIN YTO_MID_POI_DTL B ON A.ROAD_NUM_ID = B.ROAD_NUM_ID) N , ( SELECT A.* , B.COMMENTS , B.AUDIT_ORG_ID , S.NAME AUDIT_ORG_NAME , B.AUDITOR_ID , TO_CHAR(B.AUDIT_TIME, 'YYYY-MM-DD HH24:MI:SS') AUDIT_TIME , U.USER_NAME AUDITOR_NAME FROM (SELECT P.* FROM YTO_AUDIT_RECORD P WHERE P.OUTLET_ID = :1 AND P.STATE = :2 ) A LEFT JOIN (SELECT Q.*, ROW_NUMBER() OVER(PARTITION BY Q.AUDIT_ID ORDER BY Q.AUDIT_TIME DESC) RN FROM YTO_AUDIT_DETAIL Q) B ON A.AUDIT_ID = B.AUDIT_ID AND B.RN = 1 LEFT JOIN YTO_JINGANG_STATION S ON (S.CODE = B.AUDIT_ORG_ID AND S.STATUS = 'VALID') LEFT JOIN YTO_JINGANG_USER U ON U.USER_CODE = B.AUDITOR_ID ) T , YTO_JINGANG_STATION G , YTO_JINGANG_USER U , YTO_MID_DISTRICT Y WHERE N.ISDELETE = 0 AND M.ROAD_ID = N.ROAD_ID AND G.STATUS = 'VALID' AND N.ROAD_NUM_ID = T.AUDIT_VALUE AND T.OUTLET_ID = G.CODE AND U.USER_CODE = T.CREATOR_ID AND M.DISTRICT_ID = Y.DISTRICT_ID )
|
bp4krvud9bjpn |
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 = 'null' /*OR B.ALIAS1='null' OR B.ALIAS2='null' OR B.ALIAS3='null'*/ 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'%³£ÖÝ%' /* 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='Ö°Òµ¼¼ÊõѧԺ'*/ ) 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='null' 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'%³£ÖÝ%' /* OR B.ALIAS1='³£ÖÝ' OR B.ALIAS2='³£ÖÝ' O
R 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='Ö°Òµ¼¼ÊõѧԺ'*/ ) 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='ËÕÖÝÊÐ') |
bpu82rmw6n4rc | SELECT COUNT(1) FROM ( SELECT T2.BASE_DATE_ID, T1.LEVEL_ID, T2.ORG_PROVINCES, T2.ORG_NAME, T2.ORG_CODE, T2.PRINCIPAL_NAME, T2.PRINCIPAL_CODE, T1.PRINCIPAL_PHONE, T1.ORG_ADDRESS, T1.DISPATCH_IN, T1.DISPATCH_OUT, T1.AUDIT_STATUS, T1.AUDIT_ADVICE, T1.MODIFY_TIME, T3.USER_NAME MODIFY_USER_NAME, T1.MODIFY_USER_CODE, T4.CODE, T4.NAME, T1.XY_LOCATION, T1.OUT_DISPLAY_NAME , T1.CSMANAGER_NAME, T1.CSMANAGER_PHONE , T1.DAILY_AFFAIRS_NAME , T1.DAILY_AFFAIRS_PHONE FROM YTO_ORG_BASE_DATE T2 LEFT JOIN YTO_ORG_LEVEL_AUDIT T1 ON T1.BASE_DATE_ID = T2.BASE_DATE_ID LEFT JOIN YTO_JINGANG_USER T3 ON T3.USER_CODE = T1.MODIFY_USER_CODE LEFT JOIN YTO_JINGANG_STATION T4 ON T4.CODE = T3.USER_ORG_CODE WHERE 1 = 1 AND T2.ORG_CODE IN (SELECT G.CODE FROM YTO_JINGANG_STATION G START WITH G.CODE = :1 CONNECT BY PRIOR G.ID = G.PARENT_ID) ) |
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 |
cg2fjydbr0u8m | UPDATE YTO_AUDIT_STATISTICS T SET ROAD_NUM = NVL((SELECT COUNT(1) FROM YTO_AUDIT_RECORD A, YTO_MID_ROAD_NUM B WHERE A.AUDIT_VALUE = B.ROAD_NUM_ID AND B.ISDELETE = 0 AND T.STATION_CODE = A.OUTLET_ID AND T.AUDIT_STATE = A.STATE GROUP BY A.AUDIT_VALUE_TYPE, A.OUTLET_ID, A.STATE), 0) WHERE T.AUDIT_STATE = :1 AND T.STATION_CODE = :2 |
csnp95dz2r8ss | select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0 |
d92h3rjp0y217 | begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end; |
dknnjdqsdhb73 |
SELECT * FROM (SELECT YTO_ROAD_AUDIT.*, ROWNUM RN FROM( SELECT T.AUDIT_ID , M.ROAD_ID , N.ROAD_NUM_ID , M.NAME , TRIM('£¬' FROM M.ALIAS1||'£¬'||DECODE(M.ALIAS2, '', '', M.ALIAS2, M.ALIAS2||'£¬')||M.ALIAS3) ALIAS , DECODE(NVL(N.IS_REACH, M.IS_REACH), '1', 'ÅÉËÍ', '0', '²»ÅÉËÍ')IS_REACH , M.OWNER , (SELECT TT.NAME FROM YTO_JINGANG_STATION TT WHERE TT.CODE = M.OWNER AND TT.STATUS = 'VALID') OGNAME , M.DISTRICT_ID , Y.DISTRICT_NAMES DIS_NAME , T.AUDIT_VALUE_TYPE , DECODE(T.STATE, '10', '²Ý¸å', '20', '·Ö¹«Ë¾ÉóºËÖÐ', '30', 'Ê¡ÇøÉóºËÖÐ', '40', '¹ÜÀíÇøÉóºËÖÐ', '50', '×ܹ«Ë¾ÉóºËÖÐ', '60', 'ÉóºËͨ¹ý', '70', 'ÉóºË²»Í¨¹ý' ) STATE , T.STATE AUDIT_STATE_NUM , DECODE(N.NUM_TYPE, 1, 'µ¥ºÅ', 2, 'Ë«ºÅ', 3, 'È«²¿') AS NUM_TYPE , DECODE(T.AUDIT_TYPE, '1', 'ÐÂÔö', '2', 'ÐÞ¸Ä', '3', 'ɾ³ý') AUDIT_TYPE , TO_CHAR(CAST(T.CREATE_TIME AS DATE), 'YYYY-MM-DD HH24:MI:SS')CREATE_TIME , TO_CHAR(NVL(N.DATA_VALUE_MIN, 1)) || '-' ||TO_CHAR(NVL(SUBSTR(N.DATA_VALUE_MAX, INSTR(N.DATA_VALUE_MAX, ')')+1, length(N.DATA_VALUE_MAX)), 9999)) DATA_VALUE , N.DATA_VALUE_MAX , N.DATA_VALUE_MIN , G.CODE CGCODE , G.NAME CGNAME , M.CREATER CREATER_CODE , U.USER_NAME CREATER_NAME , T.COMMENTS , '' NEW_RELEASE , T.AUDIT_ORG_ID , T.AUDIT_ORG_NAME , T.AUDITOR_ID ,
T.AUDITOR_NAME , T.AUDIT_TIME , D
ECODE(N.IS_SINGLE, '0', '·ñ' , '1' , 'ÊÇ') IS_SINGLE , N.FLOOR_VALUE FROM YTO_MID_ROAD M , (SELECT A.*, B.DATA_VALUE_MIN||'-'||B.DATA_VALUE_MIN FLOOR_VALUE FROM YTO_MID_ROAD_NUM A LEFT JOIN YTO_MID_POI_DTL B ON A.ROAD_NUM_ID = B.ROAD_NUM_ID) N , ( SELECT A.* , B.COMMENTS , B.AUDIT_ORG_ID , S.NAME AUDIT_ORG_NAME , B.AUDITOR_ID , TO_CHAR(B.AUDIT_TIME, 'YYYY-MM-DD HH24:MI:SS') AUDIT_TIME , U.USER_NAME AUDITOR_NAME FROM (SELECT P.* FROM YTO_AUDIT_RECORD P WHERE P.OUTLET_ID = :1 AND P.STATE = :2 ) A LEFT JOIN (SELECT Q.*, ROW_NUMBER() OVER(PARTITION BY Q.AUDIT_ID ORDER BY Q.AUDIT_TIME DESC) RN FROM YTO_AUDIT_DETAIL Q) B ON A.AUDIT_ID = B.AUDIT_ID AND B.RN = 1 LEFT JOIN YTO_JINGANG_STATION S ON (S.CODE = B.AUDIT_ORG_ID AND S.STATUS = 'VALID') LEFT JOIN YTO_JINGANG_USER U ON U.USER_CODE = B.AUDITOR_ID ) T , YTO_JINGANG_STATION G , YTO_JINGANG_USER U , YTO_MID_DISTRICT Y WHERE N.ISDELETE = 0 AND M.ROAD_ID = N.ROAD_ID AND G.STATUS = 'VALID' AND N.ROAD_NUM_ID = T.AUDIT_VALUE AND T.OUTLET_ID = G.CODE AND U.USER_CODE = T.CREATOR_ID AND M.DISTRICT_ID = Y.DISTRICT_ID )YTO_ROAD_AUDIT WHERE ROWNUM <=:3) WHERE RN >= :4
|
g00cj285jmgsw | update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn |
g6mrfm9yr0y4x |
SELECT COUNT(1) FROM ( SELECT T.AUDIT_ID , M.ROAD_ID , N.ROAD_NUM_ID , M.NAME , TRIM('£¬' FROM M.ALIAS1||'£¬'||DECODE(M.ALIAS2, '', '', M.ALIAS2, M.ALIAS2||'£¬')||M.ALIAS3) ALIAS , DECODE(NVL(N.IS_REACH, M.IS_REACH), '1', 'ÅÉËÍ', '0', '²»ÅÉËÍ')IS_REACH , M.OWNER , (SELECT TT.NAME FROM YTO_JINGANG_STATION TT WHERE TT.CODE = M.OWNER AND TT.STATUS = 'VALID') OGNAME , M.DISTRICT_ID , Y.DISTRICT_NAMES DIS_NAME , T.AUDIT_VALUE_TYPE , DECODE(T.STATE, '10', '²Ý¸å', '20', '·Ö¹«Ë¾ÉóºËÖÐ', '30', 'Ê¡ÇøÉóºËÖÐ', '40', '¹ÜÀíÇøÉóºËÖÐ', '50', '×ܹ«Ë¾ÉóºËÖÐ', '60', 'ÉóºËͨ¹ý', '70', 'ÉóºË²»Í¨¹ý' ) STATE , T.STATE AUDIT_STATE_NUM , DECODE(N.NUM_TYPE, 1, 'µ¥ºÅ', 2, 'Ë«ºÅ', 3, 'È«²¿') AS NUM_TYPE , DECODE(T.AUDIT_TYPE, '1', 'ÐÂÔö', '2', 'ÐÞ¸Ä', '3', 'ɾ³ý') AUDIT_TYPE , TO_CHAR(CAST(T.CREATE_TIME AS DATE), 'YYYY-MM-DD HH24:MI:SS')CREATE_TIME , TO_CHAR(NVL(N.DATA_VALUE_MIN, 1)) || '-' ||TO_CHAR(NVL(SUBSTR(N.DATA_VALUE_MAX, INSTR(N.DATA_VALUE_MAX, ')')+1, length(N.DATA_VALUE_MAX)), 9999)) DATA_VALUE , N.DATA_VALUE_MAX , N.DATA_VALUE_MIN , G.CODE CGCODE , G.NAME CGNAME , M.CREATER CREATER_CODE , U.USER_NAME CREATER_NAME , T.COMMENTS , '' NEW_RELEASE , T.AUDIT_ORG_ID , T.AUDIT_ORG_NAME , T.AUDITOR_ID , T.AUDITOR_NAME , T.AUD
IT_TIME , DECODE(N.IS_SINGLE, '0', '·ñ' , '
1' , 'ÊÇ') IS_SINGLE , N.FLOOR_VALUE FROM YTO_MID_ROAD M , (SELECT A.*, B.DATA_VALUE_MIN||'-'||B.DATA_VALUE_MIN FLOOR_VALUE FROM YTO_MID_ROAD_NUM A LEFT JOIN YTO_MID_POI_DTL B ON A.ROAD_NUM_ID = B.ROAD_NUM_ID) N , ( SELECT A.* , B.COMMENTS , B.AUDIT_ORG_ID , S.NAME AUDIT_ORG_NAME , B.AUDITOR_ID , TO_CHAR(B.AUDIT_TIME, 'YYYY-MM-DD HH24:MI:SS') AUDIT_TIME , U.USER_NAME AUDITOR_NAME FROM (SELECT P.* FROM YTO_AUDIT_RECORD P WHERE P.OUTLET_ID = :1 AND P.STATE = :2 ) A LEFT JOIN (SELECT Q.*, ROW_NUMBER() OVER(PARTITION BY Q.AUDIT_ID ORDER BY Q.AUDIT_TIME DESC) RN FROM YTO_AUDIT_DETAIL Q) B ON A.AUDIT_ID = B.AUDIT_ID AND B.RN = 1 LEFT JOIN YTO_JINGANG_STATION S ON (S.CODE = B.AUDIT_ORG_ID AND S.STATUS = 'VALID') LEFT JOIN YTO_JINGANG_USER U ON U.USER_CODE = B.AUDITOR_ID ) T , YTO_JINGANG_STATION G , YTO_JINGANG_USER U , YTO_MID_DISTRICT Y WHERE N.ISDELETE = 0 AND M.ROAD_ID = N.ROAD_ID AND G.STATUS = 'VALID' AND N.ROAD_NUM_ID = T.AUDIT_VALUE AND T.OUTLET_ID = G.CODE AND U.USER_CODE = T.CREATOR_ID AND M.DISTRICT_ID = Y.DISTRICT_ID AND M.NAME LIKE '%'||:3||'%' )
|
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 |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_1 | +DATADG/gpsdb/dbf_01_1.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_1 | +DATADG/gpsdb/dbf_01_11.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_1 | +DATADG/gpsdb/dbf_01_21.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_1 | +DATADG/gpsdb/dbf_01_31.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_2 | +DATADG/gpsdb/dbf_01_02.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_2 | +DATADG/gpsdb/dbf_01_12.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_2 | +DATADG/gpsdb/dbf_01_2.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_2 | +DATADG/gpsdb/dbf_01_22.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_2 | +DATADG/gpsdb/dbf_01_32.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_3 | +DATADG/gpsdb/dbf_01_03.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_3 | +DATADG/gpsdb/dbf_01_13.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_3 | +DATADG/gpsdb/dbf_01_3.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_1 | +DATADG/gpsdb/dbf_02_01.dbf |
12 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_1 | +DATADG/gpsdb/dbf_02_1.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_1 | +DATADG/gpsdb/dbf_02_11.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_1 | +DATADG/gpsdb/dbf_02_21.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_1 | +DATADG/gpsdb/dbf_02_31.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_2 | +DATADG/gpsdb/dbf_02_02.dbf |
12 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_2 | +DATADG/gpsdb/dbf_02_12.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_2 | +DATADG/gpsdb/dbf_02_2.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_2 | +DATADG/gpsdb/dbf_02_22.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_2 | +DATADG/gpsdb/dbf_02_32.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_3 | +DATADG/gpsdb/dbf_02_03.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_3 | +DATADG/gpsdb/dbf_02_13.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_3 | +DATADG/gpsdb/dbf_02_3.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_03_1 | +DATADG/gpsdb/dbf_03_1 |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_03_1 | +DATADG/gpsdb/dbf__03_01.dbf |
5 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_03_1 | +DATADG/gpsdb/dbf__03_11.dbf |
5 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_03_2 | +DATADG/gpsdb/dbf_03_02.dbf |
5 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_03_2 | +DATADG/gpsdb/dbf_03_12.dbf |
5 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_03_2 | +DATADG/gpsdb/dbf_03_2 |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_03_3 | +DATADG/gpsdb/dbf_03_03.dbf |
5 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_03_3 | +DATADG/gpsdb/dbf_03_13.dbf |
5 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_03_3 | +DATADG/gpsdb/dbf_03_3 |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_04_1 | +DATADG/gpsdb/dbf_04_1 |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_04_2 | +DATADG/gpsdb/dbf_04_2 |
5 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_04_3 | +DATADG/gpsdb/dbf_04_3 |
5 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_05_1 | +DATADG/gpsdb/dbf_05_1 |
5 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_05_2 | +DATADG/gpsdb/dbf_05_2 |
5 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_05_3 | +DATADG/gpsdb/dbf_05_3 |
5 | 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 |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_06_2 | +DATADG/gpsdb/dbf_06_2.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_06_2 | +DATADG/gpsdb/dbf_06_2b.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_06_3 | +DATADG/gpsdb/dbf_06_3.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_06_3 | +DATADG/gpsdb/dbf_06_3b.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_07_1 | +DATADG/gpsdb/dbf_07_1.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_07_1 | +DATADG/gpsdb/dbf_07_1b.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_07_2 | +DATADG/gpsdb/dbf_07_2.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_07_2 | +DATADG/gpsdb/dbf_07_2b.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_07_3 | +DATADG/gpsdb/dbf_07_3.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_07_3 | +DATADG/gpsdb/dbf_07_3b.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_08_1 | +DATADG/gpsdb/dbf_08_1.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_08_1 | +DATADG/gpsdb/dbf_08_1b.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_08_1 | +FLASHAREA_DG/gpsdb/dbf_08_2.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_08_2 | +DATADG/gpsdb/dbf_08_2.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_08_2 | +DATADG/gpsdb/dbf_08_2b.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_08_3 | +DATADG/gpsdb/dbf_08_3.dbf |
5 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_08_3 | +DATADG/gpsdb/dbf_08_3b.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 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 | 1 | 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 | 1 | 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 |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_09_3 | +DATADG/gpsdb/dbf_09_3.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 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 | 1 | 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 | 1 | 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 |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_10_3 | +DATADG/gpsdb/dbf_10_3.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 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 |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_11_1 | +DATADG/gpsdb/dbf_11_1.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 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 | 1 | 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 |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_11_3 | +DATADG/gpsdb/dbf_11_3.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 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 |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_1 | +DATADG/gpsdb/dbf_12_01.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 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 |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_2 | +DATADG/gpsdb/dbf_12_02.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_2 | +DATADG/gpsdb/dbf_12_12.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 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 |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_3 | +DATADG/gpsdb/dbf_12_23.dbf |
5 | 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 |
10 | 0 | 0.00 | 1.00 | 2 | 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 |
40 | 0 | 5.00 | 1.38 | 495 | 0 | 0 | 0.00 |
SYSTEM | +DATADG/gpsdb/system01.dbf |
2 | 0 | 0.00 | 1.00 | 79 | 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 | 1 | 0 | 0 | 0.00 |
UNDOTBS1 | +DATADG/gpsdb/undotbs05.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
UNDOTBS2 | +DATADG/gpsdb/undotbs02.dbf |
2 | 0 | 0.00 | 1.00 | 95 | 0 | 0 | 0.00 |
UNDOTBS2 | +DATADG/gpsdb/undotbs04.dbf |
6 | 0 | 0.00 | 1.00 | 8 | 0 | 0 | 0.00 |
UNDOTBS2 | +DATADG/gpsdb/undotbs06.dbf |
6 | 0 | 0.00 | 1.00 | 41 | 0 | 0 | 0.00 |
UNDOTBS2 | +DATADG/gpsdb/undotbs07.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
UNDOTBS2 | +DATADG/gpsdb/undotbs08.dbf |
6 | 0 | 0.00 | 1.00 | 1 | 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 |
19 | 0 | 1.58 | 1.11 | 13 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_02.dbf |
3 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_03.dbf |
8 | 0 | 2.50 | 1.63 | 7 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_04.dbf |
10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_05.dbf |
3 | 0 | 3.33 | 1.00 | 6 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_06.dbf |
15 | 0 | 5.33 | 1.33 | 26 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_07.dbf |
26 | 0 | 1.92 | 1.42 | 20 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_08.dbf |
7 | 0 | 8.57 | 2.00 | 12 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_09.dbf |
23 | 0 | 3.48 | 1.48 | 35 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_10.dbf |
5 | 0 | 4.00 | 2.40 | 9 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_11.dbf |
23 | 0 | 3.04 | 1.09 | 22 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_12.dbf |
30 | 0 | 3.33 | 1.23 | 40 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_13.dbf |
13 | 0 | 3.08 | 1.38 | 18 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_14.dbf |
22 | 0 | 3.18 | 2.00 | 25 | 0 | 1 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_15.dbf |
19 | 0 | 4.74 | 1.11 | 18 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_16.dbf |
7 | 0 | 8.57 | 1.86 | 15 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_17.dbf |
12 | 0 | 5.00 | 1.08 | 8 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_18.dbf |
19 | 0 | 2.63 | 1.47 | 10 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_19.dbf |
20 | 0 | 3.50 | 1.40 | 11 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_20.dbf |
19 | 0 | 5.26 | 1.68 | 16 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_21.dbf |
15 | 0 | 5.33 | 1.73 | 24 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_22.dbf |
6 | 0 | 1.67 | 1.00 | 3 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_23.dbf |
6 | 0 | 1.67 | 2.00 | 9 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_24.dbf |
8 | 0 | 0.00 | 1.00 | 7 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_25.dbf |
5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_26.dbf |
6 | 0 | 0.00 | 1.00 | 6 | 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 | 20 | 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 |
12 | 0 | 0.00 | 1.00 | 20 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_34.dbf |
14 | 0 | 0.71 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_35.dbf |
12 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_36.dbf |
12 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_37.dbf |
10 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_38.dbf |
5 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_39.dbf |
5 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +FLASHAREA_DG/gpsdb/wzt_tbs_26.dbf |
7 | 0 | 0.00 | 1.57 | 7 | 0 | 0 | 0.00 |