SQL Id | SQL Text |
04pdbfp2t31j3 |
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'%20%' /* OR B.ALIAS1='20' OR B.ALIAS2='20' OR B.ALIAS3='20'*/ 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='Ò»²ã'*/ OR B.NAME like'%±±Çø%' /* OR B.ALIAS1='±±Çø' OR B.ALIAS2='±±Çø' OR B.ALIAS3='±±Çø'*/ OR B.NAME like'%30%' /* OR B.ALIAS1='30' OR B.ALIAS2='30' OR B.ALIAS3='30'*/ 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.ALIA
S1='ËÕÖÝÊÐ' OR B.ALIAS2='ËÕÖÝÊÐ' OR B.ALIAS3='ËÕÖÝÊÐ'*/ OR B.NAME like'%ʮȫ½Ö%'
/* OR B.ALIAS1='ʮȫ½Ö' OR B.ALIAS2='ʮȫ½Ö' OR B.ALIAS3='ʮȫ½Ö'*/ OR B.NAME like'%20%' /* OR B.ALIAS1='20' OR B.ALIAS2='20' OR B.ALIAS3='20'*/ 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='Ò»²ã'*/ OR B.NAME like'%±±Çø%' /* OR B.ALIAS1='±±Çø' OR B.ALIAS2='±±Çø' OR B.ALIAS3='±±Çø'*/ OR B.NAME like'%30%' /* OR B.ALIAS1='30' OR B.ALIAS2='30' OR B.ALIAS3='30'*/ 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='ËÕÖÝÊÐ') |
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') |
122cz41jvv0f2 | INSERT INTO YTO_ROAD SELECT M.ROAD_ID , M.DISTRICT_ID , M.PROVINCE_ID , M.DISTRICT_IDS , M.NAME , M.TYPE , M.ALIAS1 , M.ALIAS3 , M.ALIAS2 , M.OWNER , M.CREATER , '' OUTLET_ID , M.IS_REACH , '' NEW_RELEASE FROM YTO_MID_ROAD M WHERE M.ROAD_ID IN ( :1 , :2 ) AND M.ROAD_ID NOT IN (SELECT ROAD_ID FROM YTO_ROAD) |
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)) |
26ggbs707cx1q | SELECT COUNT(1) FROM YTO_AUDIT_STATISTICS T1 WHERE T1.STATION_CODE=:1 AND T1.AUDIT_STATE=:2 |
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 |
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' |
5b39qfau94tzj | SELECT COUNT(1) FROM YTO_DIFFERENT_MATCHDATA A1 WHERE A1.STATUS = 1 AND A1.ORG_CODE = :1 |
5kyb5bvnu3s04 | SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1 |
5qg0cz6q69b6r | SELECT * FROM (SELECT YTO_AUDIT_STATISTICS.*, ROWNUM RN FROM( SELECT P.STATION_CODE GID , P.STATION_NAME G_NAME , P.ROAD_NUM V_NUM_ROAD , P.POI_NUM V_NUM_POI , P.DIS_NUM V_NUM_DISTRICT FROM YTO_AUDIT_STATISTICS P WHERE P.AUDIT_STATE = :1 AND NVL(ROAD_NUM, 0)+NVL(POI_NUM, 0)+NVL(DIS_NUM, 0)>0 AND 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 = :2) CONNECT BY PRIOR G.ID = G.PARENT_ID ) ) YTO_AUDIT_STATISTICS WHERE ROWNUM <=:3) WHERE RN >= :4 |
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||'%' |
80buw7h8q9ugu |
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'%ÂÌÉ«%' /* 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='ͼƬ'*/ ) 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'%ÂÌÉ«%' /* 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.ALIA
S1='²é¿´' 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='ËÕÖÝÊÐ') |
82ryj14n802dq |
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 T2.OWNER = :2 ORDER BY T1.CREATE_TIME DESC) A WHERE ROWNUM <=:3) WHERE RN >= :4 |
832bswus1k5s4 | SELECT COUNT(1) FROM ( SELECT P.STATION_CODE GID , P.STATION_NAME G_NAME , P.ROAD_NUM V_NUM_ROAD , P.POI_NUM V_NUM_POI , P.DIS_NUM V_NUM_DISTRICT FROM YTO_AUDIT_STATISTICS P WHERE P.AUDIT_STATE = :1 AND NVL(ROAD_NUM, 0)+NVL(POI_NUM, 0)+NVL(DIS_NUM, 0)>0 AND 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 = :2) CONNECT BY PRIOR G.ID = G.PARENT_ID ) ) |
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 |
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 |
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
|
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 )
|
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 |
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 |
Statistic | Total | per Second | per Trans |
CPU used by this session | 65,721 | 18.28 | 82.46 |
CPU used when call started | 64,528 | 17.94 | 80.96 |
CR blocks created | 165 | 0.05 | 0.21 |
Cached Commit SCN referenced | 0 | 0.00 | 0.00 |
Commit SCN cached | 0 | 0.00 | 0.00 |
DB time | 422,753 | 117.56 | 530.43 |
DBWR checkpoint buffers written | 1,621 | 0.45 | 2.03 |
DBWR checkpoints | 5 | 0.00 | 0.01 |
DBWR fusion writes | 264 | 0.07 | 0.33 |
DBWR transaction table writes | 68 | 0.02 | 0.09 |
DBWR undo block writes | 215 | 0.06 | 0.27 |
DFO trees parallelized | 78 | 0.02 | 0.10 |
PX local messages recv'd | 420 | 0.12 | 0.53 |
PX local messages sent | 420 | 0.12 | 0.53 |
PX remote messages recv'd | 196 | 0.05 | 0.25 |
PX remote messages sent | 320 | 0.09 | 0.40 |
Parallel operations not downgraded | 78 | 0.02 | 0.10 |
RowCR - row contention | 28 | 0.01 | 0.04 |
RowCR attempts | 424 | 0.12 | 0.53 |
RowCR hits | 433 | 0.12 | 0.54 |
SMON posted for undo segment shrink | 0 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 11,983 | 3.33 | 15.04 |
active txn count during cleanout | 87 | 0.02 | 0.11 |
application wait time | 5 | 0.00 | 0.01 |
background checkpoints completed | 4 | 0.00 | 0.01 |
background checkpoints started | 5 | 0.00 | 0.01 |
background timeouts | 24,462 | 6.80 | 30.69 |
branch node splits | 0 | 0.00 | 0.00 |
buffer is not pinned count | 648,672 | 180.39 | 813.89 |
buffer is pinned count | 1,304,057 | 362.64 | 1,636.21 |
bytes received via SQL*Net from client | 6,301,334 | 1,752.33 | 7,906.32 |
bytes sent via SQL*Net to client | 4,532,784 | 1,260.52 | 5,687.31 |
calls to get snapshot scn: kcmgss | 71,697 | 19.94 | 89.96 |
calls to kcmgas | 6,704 | 1.86 | 8.41 |
calls to kcmgcs | 96 | 0.03 | 0.12 |
change write time | 19 | 0.01 | 0.02 |
cleanout - number of ktugct calls | 526 | 0.15 | 0.66 |
cleanouts and rollbacks - consistent read gets | 35 | 0.01 | 0.04 |
cleanouts only - consistent read gets | 299 | 0.08 | 0.38 |
cluster key scan block gets | 9,347 | 2.60 | 11.73 |
cluster key scans | 264 | 0.07 | 0.33 |
cluster wait time | 94 | 0.03 | 0.12 |
commit batch/immediate performed | 0 | 0.00 | 0.00 |
commit batch/immediate requested | 0 | 0.00 | 0.00 |
commit cleanout failures: block lost | 19 | 0.01 | 0.02 |
commit cleanout failures: callback failure | 286 | 0.08 | 0.36 |
commit cleanout failures: cannot pin | 0 | 0.00 | 0.00 |
commit cleanouts | 2,891 | 0.80 | 3.63 |
commit cleanouts successfully completed | 2,586 | 0.72 | 3.24 |
commit immediate performed | 0 | 0.00 | 0.00 |
commit immediate requested | 0 | 0.00 | 0.00 |
commit txn count during cleanout | 532 | 0.15 | 0.67 |
concurrency wait time | 100 | 0.03 | 0.13 |
consistent changes | 216 | 0.06 | 0.27 |
consistent gets | 12,239,012 | 3,403.54 | 15,356.35 |
consistent gets - examination | 805,980 | 224.13 | 1,011.27 |
consistent gets direct | 12 | 0.00 | 0.02 |
consistent gets from cache | 12,239,000 | 3,403.53 | 15,356.34 |
current blocks converted for CR | 0 | 0.00 | 0.00 |
cursor authentications | 90 | 0.03 | 0.11 |
data blocks consistent reads - undo records applied | 71 | 0.02 | 0.09 |
db block changes | 14,120 | 3.93 | 17.72 |
db block gets | 14,857 | 4.13 | 18.64 |
db block gets direct | 10 | 0.00 | 0.01 |
db block gets from cache | 14,847 | 4.13 | 18.63 |
deferred (CURRENT) block cleanout applications | 1,687 | 0.47 | 2.12 |
dirty buffers inspected | 0 | 0.00 | 0.00 |
enqueue conversions | 3,246 | 0.90 | 4.07 |
enqueue releases | 125,415 | 34.88 | 157.36 |
enqueue requests | 125,415 | 34.88 | 157.36 |
enqueue timeouts | 0 | 0.00 | 0.00 |
enqueue waits | 850 | 0.24 | 1.07 |
exchange deadlocks | 0 | 0.00 | 0.00 |
execute count | 15,996 | 4.45 | 20.07 |
free buffer inspected | 2,658 | 0.74 | 3.34 |
free buffer requested | 4,952 | 1.38 | 6.21 |
gc CPU used by this session | 17,522 | 4.87 | 21.98 |
gc blocks lost | 0 | 0.00 | 0.00 |
gc cr block build time | 4 | 0.00 | 0.01 |
gc cr block flush time | 2 | 0.00 | 0.00 |
gc cr block receive time | 71 | 0.02 | 0.09 |
gc cr block send time | 8 | 0.00 | 0.01 |
gc cr blocks received | 1,996 | 0.56 | 2.50 |
gc cr blocks served | 2,288 | 0.64 | 2.87 |
gc current block flush time | 0 | 0.00 | 0.00 |
gc current block pin time | 6 | 0.00 | 0.01 |
gc current block receive time | 22 | 0.01 | 0.03 |
gc current block send time | 11 | 0.00 | 0.01 |
gc current blocks received | 761 | 0.21 | 0.95 |
gc current blocks served | 2,776 | 0.77 | 3.48 |
gc local grants | 525 | 0.15 | 0.66 |
gc remote grants | 836 | 0.23 | 1.05 |
gcs messages sent | 1,605,011 | 446.34 | 2,013.82 |
ges messages sent | 14,977 | 4.16 | 18.79 |
global enqueue get time | 176 | 0.05 | 0.22 |
global enqueue gets async | 3,812 | 1.06 | 4.78 |
global enqueue gets sync | 18,038 | 5.02 | 22.63 |
global enqueue releases | 18,722 | 5.21 | 23.49 |
heap block compress | 42 | 0.01 | 0.05 |
hot buffers moved to head of LRU | 136 | 0.04 | 0.17 |
immediate (CR) block cleanout applications | 334 | 0.09 | 0.42 |
immediate (CURRENT) block cleanout applications | 357 | 0.10 | 0.45 |
index crx upgrade (positioned) | 1,886 | 0.52 | 2.37 |
index fast full scans (full) | 368 | 0.10 | 0.46 |
index fetch by key | 395,262 | 109.92 | 495.94 |
index scans kdiixs1 | 77,206 | 21.47 | 96.87 |
leaf node 90-10 splits | 10 | 0.00 | 0.01 |
leaf node splits | 19 | 0.01 | 0.02 |
lob reads | 3 | 0.00 | 0.00 |
lob writes | 26 | 0.01 | 0.03 |
lob writes unaligned | 26 | 0.01 | 0.03 |
logons cumulative | 2,566 | 0.71 | 3.22 |
messages received | 8,284 | 2.30 | 10.39 |
messages sent | 8,284 | 2.30 | 10.39 |
no buffer to keep pinned count | 0 | 0.00 | 0.00 |
no work - consistent read gets | 11,376,255 | 3,163.61 | 14,273.85 |
opened cursors cumulative | 11,567 | 3.22 | 14.51 |
parse count (failures) | 0 | 0.00 | 0.00 |
parse count (hard) | 1,203 | 0.33 | 1.51 |
parse count (total) | 11,467 | 3.19 | 14.39 |
parse time cpu | 1,240 | 0.34 | 1.56 |
parse time elapsed | 1,250 | 0.35 | 1.57 |
physical read IO requests | 1,530 | 0.43 | 1.92 |
physical read bytes | 17,809,408 | 4,952.60 | 22,345.56 |
physical read total IO requests | 13,941 | 3.88 | 17.49 |
physical read total bytes | 223,560,192 | 62,169.68 | 280,502.12 |
physical read total multi block requests | 184 | 0.05 | 0.23 |
physical reads | 2,174 | 0.60 | 2.73 |
physical reads cache | 1,006 | 0.28 | 1.26 |
physical reads cache prefetch | 519 | 0.14 | 0.65 |
physical reads direct | 1,168 | 0.32 | 1.47 |
physical reads direct (lob) | 3 | 0.00 | 0.00 |
physical reads direct temporary tablespace | 150 | 0.04 | 0.19 |
physical reads prefetch warmup | 519 | 0.14 | 0.65 |
physical write IO requests | 1,840 | 0.51 | 2.31 |
physical write bytes | 18,128,896 | 5,041.45 | 22,746.42 |
physical write total IO requests | 7,395 | 2.06 | 9.28 |
physical write total bytes | 89,799,680 | 24,972.32 | 112,672.12 |
physical write total multi block requests | 1,074 | 0.30 | 1.35 |
physical writes | 2,213 | 0.62 | 2.78 |
physical writes direct | 400 | 0.11 | 0.50 |
physical writes direct (lob) | 10 | 0.00 | 0.01 |
physical writes direct temporary tablespace | 150 | 0.04 | 0.19 |
physical writes from cache | 1,813 | 0.50 | 2.27 |
physical writes non checkpoint | 1,101 | 0.31 | 1.38 |
pinned buffers inspected | 0 | 0.00 | 0.00 |
pinned cursors current | 4 | 0.00 | 0.01 |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
prefetch warmup blocks flushed out before use | 0 | 0.00 | 0.00 |
prefetched blocks aged out before use | 392 | 0.11 | 0.49 |
process last non-idle time | 3,608 | 1.00 | 4.53 |
queries parallelized | 78 | 0.02 | 0.10 |
recursive calls | 60,808 | 16.91 | 76.30 |
recursive cpu usage | 1,943 | 0.54 | 2.44 |
redo blocks written | 7,512 | 2.09 | 9.43 |
redo buffer allocation retries | 0 | 0.00 | 0.00 |
redo entries | 9,954 | 2.77 | 12.49 |
redo log space requests | 0 | 0.00 | 0.00 |
redo log space wait time | 0 | 0.00 | 0.00 |
redo ordering marks | 135 | 0.04 | 0.17 |
redo size | 3,257,216 | 905.80 | 4,086.85 |
redo subscn max counts | 495 | 0.14 | 0.62 |
redo synch time | 6 | 0.00 | 0.01 |
redo synch writes | 160 | 0.04 | 0.20 |
redo wastage | 449,508 | 125.00 | 564.00 |
redo write broadcast ack time | 0 | 0.00 | 0.00 |
redo write time | 80 | 0.02 | 0.10 |
redo writer latching time | 0 | 0.00 | 0.00 |
redo writes | 1,488 | 0.41 | 1.87 |
rollback changes - undo records applied | 0 | 0.00 | 0.00 |
rollbacks only - consistent read gets | 16 | 0.00 | 0.02 |
rows fetched via callback | 194,337 | 54.04 | 243.84 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 3,459 | 0.96 | 4.34 |
session logical reads | 12,253,861 | 3,407.67 | 15,374.98 |
shared hash latch upgrades - no wait | 2,991 | 0.83 | 3.75 |
shared hash latch upgrades - wait | 0 | 0.00 | 0.00 |
sorts (disk) | 0 | 0.00 | 0.00 |
sorts (memory) | 8,885 | 2.47 | 11.15 |
sorts (rows) | 85,078,046 | 23,659.29 | 106,747.86 |
sql area evicted | 35 | 0.01 | 0.04 |
sql area purged | 0 | 0.00 | 0.00 |
summed dirty queue length | 0 | 0.00 | 0.00 |
switch current to new buffer | 96 | 0.03 | 0.12 |
table fetch by rowid | 642,648 | 178.71 | 806.33 |
table fetch continued row | 101 | 0.03 | 0.13 |
table scan blocks gotten | 10,895,747 | 3,029.99 | 13,670.95 |
table scan rows gotten | 594,615,801 | 165,356.25 | 746,067.50 |
table scans (long tables) | 0 | 0.00 | 0.00 |
table scans (short tables) | 9,347 | 2.60 | 11.73 |
total number of times SMON posted | 21 | 0.01 | 0.03 |
transaction lock background gets | 0 | 0.00 | 0.00 |
transaction lock foreground requests | 0 | 0.00 | 0.00 |
transaction lock foreground wait time | 0 | 0.00 | 0.00 |
transaction rollbacks | 0 | 0.00 | 0.00 |
transaction tables consistent read rollbacks | 0 | 0.00 | 0.00 |
transaction tables consistent reads - undo records applied | 0 | 0.00 | 0.00 |
undo change vector size | 1,047,280 | 291.24 | 1,314.03 |
user I/O wait time | 486 | 0.14 | 0.61 |
user calls | 22,178 | 6.17 | 27.83 |
user commits | 731 | 0.20 | 0.92 |
user rollbacks | 66 | 0.02 | 0.08 |
workarea executions - onepass | 2 | 0.00 | 0.00 |
workarea executions - optimal | 11,158 | 3.10 | 14.00 |
write clones created in background | 0 | 0.00 | 0.00 |
write clones created in foreground | 0 | 0.00 | 0.00 |
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 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_1 | +DATADG/gpsdb/dbf_01_1.dbf |
9 | 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 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_1 | +DATADG/gpsdb/dbf_01_21.dbf |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_1 | +DATADG/gpsdb/dbf_01_31.dbf |
10 | 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 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_2 | +DATADG/gpsdb/dbf_01_12.dbf |
10 | 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 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_2 | +DATADG/gpsdb/dbf_01_22.dbf |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_2 | +DATADG/gpsdb/dbf_01_32.dbf |
10 | 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 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_3 | +DATADG/gpsdb/dbf_01_13.dbf |
10 | 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 | 2 | 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 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_1 | +DATADG/gpsdb/dbf_02_11.dbf |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_1 | +DATADG/gpsdb/dbf_02_21.dbf |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_1 | +DATADG/gpsdb/dbf_02_31.dbf |
10 | 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 |
10 | 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 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_2 | +DATADG/gpsdb/dbf_02_22.dbf |
11 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_2 | +DATADG/gpsdb/dbf_02_32.dbf |
11 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_3 | +DATADG/gpsdb/dbf_02_03.dbf |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_3 | +DATADG/gpsdb/dbf_02_13.dbf |
10 | 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 | 2 | 0 | 0 | 0.00 |
HIS_GPS_03_1 | +DATADG/gpsdb/dbf_03_1 |
11 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_03_1 | +DATADG/gpsdb/dbf__03_01.dbf |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_03_1 | +DATADG/gpsdb/dbf__03_11.dbf |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_03_2 | +DATADG/gpsdb/dbf_03_02.dbf |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_03_2 | +DATADG/gpsdb/dbf_03_12.dbf |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_03_2 | +DATADG/gpsdb/dbf_03_2 |
11 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_03_3 | +DATADG/gpsdb/dbf_03_03.dbf |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_03_3 | +DATADG/gpsdb/dbf_03_13.dbf |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_03_3 | +DATADG/gpsdb/dbf_03_3 |
11 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_04_1 | +DATADG/gpsdb/dbf_04_1 |
11 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_04_2 | +DATADG/gpsdb/dbf_04_2 |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_04_3 | +DATADG/gpsdb/dbf_04_3 |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_05_1 | +DATADG/gpsdb/dbf_05_1 |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_05_2 | +DATADG/gpsdb/dbf_05_2 |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_05_3 | +DATADG/gpsdb/dbf_05_3 |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_06_1 | +DATADG/gpsdb/dbf_06_1.dbf |
2 | 0 | 0.00 | 1.00 | 1 | 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 | 2 | 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 | 2 | 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 | 2 | 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 | 2 | 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 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_1 | +DATADG/gpsdb/dbf_12_01.dbf |
9 | 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 |
9 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_2 | +DATADG/gpsdb/dbf_12_02.dbf |
9 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_2 | +DATADG/gpsdb/dbf_12_12.dbf |
9 | 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 |
9 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_3 | +DATADG/gpsdb/dbf_12_23.dbf |
10 | 0 | 0.00 | 1.00 | 1 | 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 | 2 | 0 | 0 | 0.00 |
HIS_GPS_20130501 | +DATADG/gpsdb/dbf_130501.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_20130502 | +DATADG/gpsdb/dbf_130502.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_20130503 | +DATADG/gpsdb/dbf_130503.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
SPLEX_TSP | +DATADG/gpsdb/splex_tbs_01.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
SYSAUX | +DATADG/gpsdb/sysaux01.dbf |
34 | 0 | 5.29 | 1.38 | 541 | 0 | 0 | 0.00 |
SYSTEM | +DATADG/gpsdb/system01.dbf |
2 | 0 | 5.00 | 1.00 | 93 | 0 | 0 | 0.00 |
TEMP | +DATADG/gpsdb/temp01.dbf |
10 | 0 | 0.00 | 15.00 | 10 | 0 | 0 | |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_01.dbf |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_02.dbf |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_03.dbf |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_04.dbf |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_05.dbf |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_06.dbf |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_07.dbf |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_08.dbf |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_09.dbf |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
TS_IDX_YTMOT | +DATADG/gpsdb/idx_ytmot_10.dbf |
2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
UNDOTBS1 | +DATADG/gpsdb/undotbs01.dbf |
1 | 0 | 0.00 | 1.00 | 1 | 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 |
1 | 0 | 0.00 | 1.00 | 70 | 0 | 0 | 0.00 |
UNDOTBS2 | +DATADG/gpsdb/undotbs04.dbf |
6 | 0 | 0.00 | 1.00 | 22 | 0 | 0 | 0.00 |
UNDOTBS2 | +DATADG/gpsdb/undotbs06.dbf |
6 | 0 | 0.00 | 1.00 | 51 | 0 | 1 | 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 |
1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_01.dbf |
22 | 0 | 11.82 | 2.00 | 33 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_02.dbf |
21 | 0 | 4.29 | 1.71 | 27 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_03.dbf |
9 | 0 | 4.44 | 1.00 | 10 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_04.dbf |
8 | 0 | 10.00 | 1.50 | 12 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_05.dbf |
7 | 0 | 10.00 | 2.14 | 12 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_06.dbf |
36 | 0 | 8.33 | 2.06 | 29 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_07.dbf |
52 | 0 | 6.73 | 1.73 | 47 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_08.dbf |
25 | 0 | 5.60 | 1.84 | 31 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_09.dbf |
14 | 0 | 9.29 | 1.50 | 59 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_10.dbf |
4 | 0 | 7.50 | 3.50 | 27 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_11.dbf |
53 | 0 | 5.28 | 1.98 | 62 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_12.dbf |
48 | 0 | 6.46 | 1.65 | 82 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_13.dbf |
51 | 0 | 6.27 | 2.24 | 67 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_14.dbf |
19 | 0 | 23.68 | 1.68 | 37 | 0 | 1 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_15.dbf |
14 | 0 | 7.86 | 2.21 | 16 | 0 | 1 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_16.dbf |
9 | 0 | 7.78 | 2.33 | 26 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_17.dbf |
17 | 0 | 5.88 | 1.94 | 29 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_18.dbf |
16 | 0 | 11.25 | 2.19 | 33 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_19.dbf |
30 | 0 | 6.67 | 2.57 | 46 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_20.dbf |
22 | 0 | 6.82 | 1.32 | 30 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_21.dbf |
19 | 0 | 4.21 | 1.95 | 35 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_22.dbf |
11 | 0 | 10.00 | 2.00 | 11 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_23.dbf |
8 | 0 | 3.75 | 2.75 | 12 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_24.dbf |
6 | 0 | 1.67 | 1.17 | 7 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_25.dbf |
5 | 0 | 4.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_26.dbf |
6 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_27.dbf |
8 | 0 | 0.00 | 1.00 | 7 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_28.dbf |
8 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_29.dbf |
8 | 0 | 0.00 | 1.00 | 3 | 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 | 26 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_34.dbf |
11 | 0 | 0.91 | 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 |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_38.dbf |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_39.dbf |
10 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
WZT | +FLASHAREA_DG/gpsdb/wzt_tbs_26.dbf |
8 | 0 | 16.25 | 1.75 | 17 | 0 | 0 | 0.00 |