SQL Id | SQL Text |
0h6b2sajwb74n | select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME') |
18naypzfmabd6 | INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256)) |
350f5yrnnmshs | lock table sys.mon_mods$ in exclusive mode nowait |
459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
5fj2t8gc6yagr | 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') LEFT JOIN (SELECT T8.COMMENTS , T8.AUDIT_ID FROM YTO_AUDIT_DETAIL T8 , (SELECT T9.AUDIT_ID , MAX(T9.AUDIT_TIME)AUDIT_TIME FROM YTO_AUDIT_DETAIL T9 WHERE T9.STATE = 0 GROUP BY T9.AUDIT_ID) T10 WHERE T8.STATE = 0 AND T8.AUDIT_ID = T10.AUDIT_ID AND T8.AUDIT_TIME = T10.AUDIT_TIME )T11 ON T5.AUDIT_ID = T11.AUDIT_ID 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 T5.STATE = :2 |
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 |
68ddx7zxvxubr | select count(*) from (select distinct a.id, a.task_id, a.later_status, a.lazy_time, a.vehicle_no, a.line_name, to_char(a.gps_time, 'yyyy-MM-dd HH24:mi:ss'), a.is_disposal, b.name, c.device_id from t_later_info a, yto_org_node b, yto_in_out_area_s c, (select g.gid from t_privilage_group g start with g.gid = (select gid from ref_user_group where user_id = (select id from t_user where user_account = '00002578'))connect by prior g.gid = g.parent_id) d where a.task_id = c.task_id and b.org_id = ( case a.later_status when 1 then c.start_org_code else c.end_org_code end)and a.is_disposal = 0 and sysdate - a.gps_time < 5 and (c.start_org_code = d.gid or c.end_org_code = d.gid )) |
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 |
809zdnzb6nwwg |
SELECT COUNT(1) FROM ( SELECT T.AUDIT_ID , M.POI_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(T.AUDIT_TYPE, '1', 'ÐÂÔö', '2', 'ÐÞ¸Ä', '3', 'ɾ³ý') AUDIT_TYPE , TO_CHAR(CAST(T.CREATE_TIME AS DATE), 'YYYY-MM-DD HH24:MI:SS')CREATE_TIME , NVL(N.DATA_VALUE, '1-9999') DATA_VALUE , NVL(SUBSTR(N.DATA_VALUE, INSTR(N.DATA_VALUE, '-')+1), 9999)DATA_VALUE_MAX , NVL(SUBSTR(N.DATA_VALUE, 0, INSTR(N.DATA_VALUE, '-')-1), 1)DATA_VALUE_MIN , G.CODE CGCODE , G.NAME CGNAME , M.CREATER CREATER_CODE , U.USER_NAME CREATER_NAME , CASE WHEN T.COMMENTS IS NULL THEN DECODE(T.STATE, '10', '²Ý¸å', '20', '·Ö¹«Ë¾ÉóºËÖÐ', '30', '·Ö¹«Ë¾ÉóºËͨ¹ý', '40', 'Ê¡¹«Ë¾ÉóºËͨ¹ý', '50', '¹ÜÀíÇøÉóºËͨ¹ý', '60', '×ܹ«Ë¾ÉóºË
ͨ¹ý', '70', 'ÉÏ´ÎÉóºËδͨ¹ý') ELSE T.COMMENTS END COMMENTS , '' NEW_RELEASE
, T.AUDIT_ORG_ID , T.AUDIT_ORG_NAME , T.AUDITOR_ID , T.AUDITOR_NAME , T.AUDIT_TIME FROM YTO_MID_POI M LEFT JOIN YTO_MID_POI_DTL N ON M.POI_ID = N.POI_ID , ( 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 T.AUDIT_VALUE = N.POI_DTL_ID AND G.STATUS = 'VALID' AND T.OUTLET_ID = G.CODE AND U.USER_CODE = T.CREATOR_ID AND M.DISTRICT_ID = Y.DISTRICT_ID )
|
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 |
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 |
a49zwfctq8r84 |
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 , T11.COMMENTS NOPASSREASON FROM YTO_M
ID_ROAD T1 LEFT JOIN (SELECT A.*, B.DATA_VALUE_M
IN||'-'||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') LEFT JOIN (SELECT T8.COMMENTS , T8.AUDIT_ID FROM YTO_AUDIT_DETAIL T8 , (SELECT T9.AUDIT_ID , MAX(T9.AUDIT_TIME)AUDIT_TIME FROM YTO_AUDIT_DETAIL T9 WHERE T9.STATE = 0 GROUP BY T9.AUDIT_ID) T10 WHERE T8.STATE = 0 AND T8.AUDIT_ID = T10.AUDIT_ID AND T8.AUDIT_TIME = T10.AUDIT_TIME )T11 ON T5.AUDIT_ID = T11.AUDIT_ID 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 T5.STATE = :2 ORDER BY T1.CREATE_TIME DESC) A WHERE ROWNUM <=:3) WHERE RN >= :4
|
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 )
|
c30y4ycz6yt7v | SELECT "ZIP_NO_SEQ", "ADDR", "ADDR_DTL", "LRGN_NM", "MRGN_NM", "SRGN_NM", "IS_SERVICE" FROM "TB_AZ012_W0228_RESULT" "TB_AZ012_W0228_RESULT" |
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 |
casn5xxbk9tah |
SELECT nvl(v.first_val, 0), nvl(v.last_val, 0), nvl(v.delta_val, 0), decode(v.stat_id, NULL, 0, 1), decode(osmap.required, 'N', 0, 1), osmap.statistic_hash, osmap.keh_id FROM ( SELECT b.value as first_val, e.value as last_val, (e.value - b.value) as delta_val, b.stat_id FROM (SELECT t1.* FROM WRH$_OSSTAT 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$_OSSTAT_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) b , (SELECT t1.* FROM WRH$_OSSTAT 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$_OSSTAT_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) e WHERE b.dbid = :dbid and e.dbid = :dbid2 and b.instance_number = :instance_number and e.instance_number = :instance_number2 and b.snap_id = :begin_snap_id and e.snap_id = :end_snap_id and b.stat_id = e.stat_id ) v, X$KEHOSM
AP osmap WHERE osmap.statistic_hash = v.stat_id(+) ORDER BY osmap.keh_id ASC |
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 |
cnpy92sm9tavb | SELECT ROAD_ID FROM YTO_MID_ROAD WHERE NAME=:1 AND DISTRICT_ID=:2 AND OWNER=:3 UNION ALL SELECT T1.ROAD_ID FROM YTO_MID_ROAD_NUM T1 INNER JOIN YTO_MID_ROAD T2 ON T1.ROAD_ID=T2.ROAD_ID WHERE T2.NAME=:4 AND DISTRICT_ID=:5 AND T1.OWNER=:6 AND T1.DATA_VALUE_MIN=:7 AND T1.DATA_VALUE_MAX=:8 |
csnp95dz2r8ss | select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0 |
dbq0pds6kwqju | UPDATE YTO_AUDIT_STATISTICS T SET POI_NUM = NVL((SELECT COUNT(1) FROM YTO_AUDIT_RECORD A, YTO_MID_POI_DTL B WHERE A.AUDIT_VALUE = B.POI_DTL_ID AND T.STATION_CODE = A.OUTLET_ID AND T.AUDIT_STATE = A.STATE AND B.ISDELETE = 0 AND B.ROAD_NUM_ID IS NULL GROUP BY A.AUDIT_VALUE_TYPE, A.OUTLET_ID, A.STATE), 0) WHERE T.AUDIT_STATE = :1 AND T.STATION_CODE = :2 |
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
|
dxdwxhrp87q6z |
SELECT * FROM (SELECT YTO_POI_AUDIT.*, ROWNUM RN FROM( SELECT T.AUDIT_ID , M.POI_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(T.AUDIT_TYPE, '1', 'ÐÂÔö', '2', 'ÐÞ¸Ä', '3', 'ɾ³ý') AUDIT_TYPE , TO_CHAR(CAST(T.CREATE_TIME AS DATE), 'YYYY-MM-DD HH24:MI:SS')CREATE_TIME , NVL(N.DATA_VALUE, '1-9999') DATA_VALUE , NVL(SUBSTR(N.DATA_VALUE, INSTR(N.DATA_VALUE, '-')+1), 9999)DATA_VALUE_MAX , NVL(SUBSTR(N.DATA_VALUE, 0, INSTR(N.DATA_VALUE, '-')-1), 1)DATA_VALUE_MIN , G.CODE CGCODE , G.NAME CGNAME , M.CREATER CREATER_CODE , U.USER_NAME CREATER_NAME , CASE WHEN T.COMMENTS IS NULL THEN DECODE(T.STATE, '10', '²Ý¸å', '20', '·Ö¹«Ë¾ÉóºËÖÐ', '30', '·Ö¹«Ë¾ÉóºËͨ¹ý', '40', 'Ê¡¹«Ë¾ÉóºËͨ¹ý', '50', '¹Ü
ÀíÇøÉóºËͨ¹ý', '60', '×ܹ«Ë¾ÉóºËͨ¹ý', '70', 'ÉÏ´ÎÉóºËδͨ¹ý') ELSE T.COMMENTS END COMMENTS
, '' NEW_RELEASE , T.AUDIT_ORG_ID , T.AUDIT_ORG_NAME , T.AUDITOR_ID , T.AUDITOR_NAME , T.AUDIT_TIME FROM YTO_MID_POI M LEFT JOIN YTO_MID_POI_DTL N ON M.POI_ID = N.POI_ID , ( 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 T.AUDIT_VALUE = N.POI_DTL_ID AND G.STATUS = 'VALID' AND T.OUTLET_ID = G.CODE AND U.USER_CODE = T.CREATOR_ID AND M.DISTRICT_ID = Y.DISTRICT_ID )YTO_POI_AUDIT WHERE ROWNUM <=:3) WHERE RN >= :4
|
frr9vmmcsadhb | select * from ( select distinct a.id, a.task_id, a.later_status, a.lazy_time, a.vehicle_no, a.line_name, to_char(a.gps_time, 'yyyy-MM-dd HH24:mi:ss'), a.is_disposal, b.name, c.device_id from t_later_info a, yto_org_node b, yto_in_out_area_s c, (select g.gid from t_privilage_group g start with g.gid = (select gid from ref_user_group where user_id = (select id from t_user where user_account = '00002578'))connect by prior g.gid = g.parent_id) d where a.task_id = c.task_id and b.org_id = ( case a.later_status when 1 then c.start_org_code else c.end_org_code end)and a.is_disposal = 0 and sysdate - a.gps_time < 5 and (c.start_org_code = d.gid or c.end_org_code = d.gid ) ) where rownum <= :1 |
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 |
g1u8jnzfm96nx |
select m1.device_id, m1.latitude, m1.longitude, m1.speed, m1.direction, m1.gpstime, m1.stop_car, m1.engine, m2.vehicle_id, m2.line_no, m2.next_org_code, m2.is_lazy, m2.EXPECTED_END_DATE, m2.task_id, m2.sdate, m2.edate, m1.fictitious_line_name from (select t1.device_id as device_id, t2.latitude as latitude, t2.longitude as longitude, t2.speed as speed, t2.direction as direction, to_char(t2.gpstime, 'yyyy-MM-dd HH24:mi:ss') as gpstime, t3.stop_car as stop_car, t3.flame_out as engine, t4.fictitious_line_name from t_terminal t1, t_last_locrecord t2, t_term_status_last_record t3, ( select b.tid, h.fictitious_line_name from ref_vehicle_terminal b, yto_vehicle_ref g, yto_fictitious_line h where b.vid = g.id(+) and g.fictitious_line_id = h.fictitious_line_id(+) ) t4 where t1.device_id = t2.device_id and t1.device_id = t3.device_id(+) and t1.device_id = t4.tid(+) and t1.device_id in ('13721982074', '13721878525', '13721986854', '13721986940', '14782232230')) m1, (select y1.termial_id as device_id , y1.vehicle_id as vehicle_id, y1.line_no as line_no, y1.next_org_code as next_org_code, y2.is_lazy as is_lazy, to_char(y2.EXPECTED_END_DATE, 'yyyy-MM-dd HH24:mi:ss') as EXPECTED_END_DATE, y1.task_id, to_char(y4.sdate, 'yyyy-MM-dd HH24:mi:ss') sdate, to_char(y4.edate, 'yyyy-MM-dd HH24:mi:ss') edate from yto_task y1, yto_task_dtl y2, ( select yy3.task_id, y3.real_start_date sdate, y32.real_end_date edate from yto_task yy3, yto_task_dtl y3, yto_task
_dtl y32 where yy3.task_id = y3.task_id and yy3.task_id = y32.task_id and yy3.start_org_code = y3.start_org_code and yy3.end_org_code = y32.end_org_code ) y4, t_last_locrecord y5 where y1.task_id = y2.task_id and y1.next_org_code = y2.end_org_code and y1.task_id = y4.task_id and y1.termial_id = y5.device_id and y1.create_date <= y5.gpstime+1 and y1.is_over = 0) m2 where m1.device_id = m2.device_id(+) |
Statistic | Total | per Second | per Trans |
CPU used by this session | 46,479 | 12.95 | 44.35 |
CPU used when call started | 45,975 | 12.81 | 43.87 |
CR blocks created | 95 | 0.03 | 0.09 |
Cached Commit SCN referenced | 0 | 0.00 | 0.00 |
Commit SCN cached | 0 | 0.00 | 0.00 |
DB time | 410,626 | 114.38 | 391.82 |
DBWR checkpoint buffers written | 1,069 | 0.30 | 1.02 |
DBWR checkpoints | 5 | 0.00 | 0.00 |
DBWR fusion writes | 139 | 0.04 | 0.13 |
DBWR transaction table writes | 63 | 0.02 | 0.06 |
DBWR undo block writes | 189 | 0.05 | 0.18 |
DFO trees parallelized | 78 | 0.02 | 0.07 |
PX local messages recv'd | 420 | 0.12 | 0.40 |
PX local messages sent | 420 | 0.12 | 0.40 |
PX remote messages recv'd | 220 | 0.06 | 0.21 |
PX remote messages sent | 344 | 0.10 | 0.33 |
Parallel operations not downgraded | 78 | 0.02 | 0.07 |
RowCR - row contention | 4 | 0.00 | 0.00 |
RowCR attempts | 239 | 0.07 | 0.23 |
RowCR hits | 242 | 0.07 | 0.23 |
SMON posted for undo segment shrink | 0 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 15,209 | 4.24 | 14.51 |
active txn count during cleanout | 48 | 0.01 | 0.05 |
application wait time | 4 | 0.00 | 0.00 |
background checkpoints completed | 4 | 0.00 | 0.00 |
background checkpoints started | 5 | 0.00 | 0.00 |
background timeouts | 24,546 | 6.84 | 23.42 |
buffer is not pinned count | 1,405,506 | 391.50 | 1,341.13 |
buffer is pinned count | 3,518,236 | 980.01 | 3,357.10 |
bytes received via SQL*Net from client | 6,841,166 | 1,905.61 | 6,527.83 |
bytes sent via SQL*Net to client | 147,022,726 | 40,953.26 | 140,288.86 |
calls to get snapshot scn: kcmgss | 67,544 | 18.81 | 64.45 |
calls to kcmgas | 5,056 | 1.41 | 4.82 |
calls to kcmgcs | 98 | 0.03 | 0.09 |
change write time | 12 | 0.00 | 0.01 |
cleanout - number of ktugct calls | 277 | 0.08 | 0.26 |
cleanouts and rollbacks - consistent read gets | 0 | 0.00 | 0.00 |
cleanouts only - consistent read gets | 181 | 0.05 | 0.17 |
cluster key scan block gets | 23,813 | 6.63 | 22.72 |
cluster key scans | 389 | 0.11 | 0.37 |
cluster wait time | 406 | 0.11 | 0.39 |
commit batch/immediate performed | 2 | 0.00 | 0.00 |
commit batch/immediate requested | 2 | 0.00 | 0.00 |
commit cleanout failures: block lost | 16 | 0.00 | 0.02 |
commit cleanout failures: callback failure | 107 | 0.03 | 0.10 |
commit cleanout failures: cannot pin | 0 | 0.00 | 0.00 |
commit cleanouts | 2,344 | 0.65 | 2.24 |
commit cleanouts successfully completed | 2,221 | 0.62 | 2.12 |
commit immediate performed | 2 | 0.00 | 0.00 |
commit immediate requested | 2 | 0.00 | 0.00 |
commit txn count during cleanout | 286 | 0.08 | 0.27 |
concurrency wait time | 96 | 0.03 | 0.09 |
consistent changes | 106 | 0.03 | 0.10 |
consistent gets | 13,173,087 | 3,669.37 | 12,569.74 |
consistent gets - examination | 1,507,584 | 419.94 | 1,438.53 |
consistent gets direct | 4 | 0.00 | 0.00 |
consistent gets from cache | 13,173,083 | 3,669.37 | 12,569.74 |
current blocks converted for CR | 0 | 0.00 | 0.00 |
cursor authentications | 88 | 0.02 | 0.08 |
data blocks consistent reads - undo records applied | 3 | 0.00 | 0.00 |
db block changes | 11,666 | 3.25 | 11.13 |
db block gets | 12,018 | 3.35 | 11.47 |
db block gets direct | 3 | 0.00 | 0.00 |
db block gets from cache | 12,015 | 3.35 | 11.46 |
deferred (CURRENT) block cleanout applications | 1,230 | 0.34 | 1.17 |
dirty buffers inspected | 0 | 0.00 | 0.00 |
enqueue conversions | 3,367 | 0.94 | 3.21 |
enqueue releases | 128,743 | 35.86 | 122.85 |
enqueue requests | 128,745 | 35.86 | 122.85 |
enqueue timeouts | 2 | 0.00 | 0.00 |
enqueue waits | 890 | 0.25 | 0.85 |
exchange deadlocks | 0 | 0.00 | 0.00 |
execute count | 16,232 | 4.52 | 15.49 |
free buffer inspected | 10,990 | 3.06 | 10.49 |
free buffer requested | 33,821 | 9.42 | 32.27 |
gc CPU used by this session | 18,172 | 5.06 | 17.34 |
gc blocks lost | 0 | 0.00 | 0.00 |
gc cr block build time | 3 | 0.00 | 0.00 |
gc cr block flush time | 0 | 0.00 | 0.00 |
gc cr block receive time | 1,629 | 0.45 | 1.55 |
gc cr block send time | 4 | 0.00 | 0.00 |
gc cr blocks received | 23,882 | 6.65 | 22.79 |
gc cr blocks served | 1,436 | 0.40 | 1.37 |
gc current block flush time | 1 | 0.00 | 0.00 |
gc current block pin time | 1 | 0.00 | 0.00 |
gc current block receive time | 41 | 0.01 | 0.04 |
gc current block send time | 7 | 0.00 | 0.01 |
gc current blocks received | 1,015 | 0.28 | 0.97 |
gc current blocks served | 1,966 | 0.55 | 1.88 |
gc local grants | 152 | 0.04 | 0.15 |
gc remote grants | 642 | 0.18 | 0.61 |
gcs messages sent | 1,636,544 | 455.86 | 1,561.59 |
ges messages sent | 19,095 | 5.32 | 18.22 |
global enqueue get time | 310 | 0.09 | 0.30 |
global enqueue gets async | 7,308 | 2.04 | 6.97 |
global enqueue gets sync | 20,924 | 5.83 | 19.97 |
global enqueue releases | 23,100 | 6.43 | 22.04 |
heap block compress | 58 | 0.02 | 0.06 |
hot buffers moved to head of LRU | 40 | 0.01 | 0.04 |
immediate (CR) block cleanout applications | 181 | 0.05 | 0.17 |
immediate (CURRENT) block cleanout applications | 230 | 0.06 | 0.22 |
index crx upgrade (positioned) | 1,909 | 0.53 | 1.82 |
index fast full scans (full) | 196 | 0.05 | 0.19 |
index fetch by key | 529,924 | 147.61 | 505.65 |
index scans kdiixs1 | 412,728 | 114.97 | 393.82 |
leaf node 90-10 splits | 9 | 0.00 | 0.01 |
leaf node splits | 16 | 0.00 | 0.02 |
lob reads | 4 | 0.00 | 0.00 |
lob writes | 41 | 0.01 | 0.04 |
lob writes unaligned | 41 | 0.01 | 0.04 |
logons cumulative | 2,923 | 0.81 | 2.79 |
messages received | 8,332 | 2.32 | 7.95 |
messages sent | 8,332 | 2.32 | 7.95 |
no buffer to keep pinned count | 0 | 0.00 | 0.00 |
no work - consistent read gets | 11,612,988 | 3,234.80 | 11,081.10 |
opened cursors cumulative | 11,517 | 3.21 | 10.99 |
parse count (failures) | 1 | 0.00 | 0.00 |
parse count (hard) | 1,676 | 0.47 | 1.60 |
parse count (total) | 11,388 | 3.17 | 10.87 |
parse time cpu | 1,690 | 0.47 | 1.61 |
parse time elapsed | 1,748 | 0.49 | 1.67 |
physical read IO requests | 1,297 | 0.36 | 1.24 |
physical read bytes | 11,763,712 | 3,276.79 | 11,224.92 |
physical read total IO requests | 13,959 | 3.89 | 13.32 |
physical read total bytes | 221,107,200 | 61,589.53 | 210,980.15 |
physical read total multi block requests | 56 | 0.02 | 0.05 |
physical reads | 1,436 | 0.40 | 1.37 |
physical reads cache | 620 | 0.17 | 0.59 |
physical reads cache prefetch | 182 | 0.05 | 0.17 |
physical reads direct | 816 | 0.23 | 0.78 |
physical reads direct (lob) | 1 | 0.00 | 0.00 |
physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
physical reads prefetch warmup | 182 | 0.05 | 0.17 |
physical write IO requests | 1,189 | 0.33 | 1.13 |
physical write bytes | 11,354,112 | 3,162.69 | 10,834.08 |
physical write total IO requests | 6,826 | 1.90 | 6.51 |
physical write total bytes | 83,778,560 | 23,336.56 | 79,941.37 |
physical write total multi block requests | 1,007 | 0.28 | 0.96 |
physical writes | 1,386 | 0.39 | 1.32 |
physical writes direct | 203 | 0.06 | 0.19 |
physical writes direct (lob) | 3 | 0.00 | 0.00 |
physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
physical writes from cache | 1,183 | 0.33 | 1.13 |
physical writes non checkpoint | 525 | 0.15 | 0.50 |
pinned buffers inspected | 0 | 0.00 | 0.00 |
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 | 51 | 0.01 | 0.05 |
process last non-idle time | 3,635 | 1.01 | 3.47 |
queries parallelized | 78 | 0.02 | 0.07 |
recursive calls | 62,299 | 17.35 | 59.45 |
recursive cpu usage | 2,300 | 0.64 | 2.19 |
redo blocks written | 6,623 | 1.84 | 6.32 |
redo buffer allocation retries | 0 | 0.00 | 0.00 |
redo entries | 7,951 | 2.21 | 7.59 |
redo log space requests | 0 | 0.00 | 0.00 |
redo log space wait time | 0 | 0.00 | 0.00 |
redo ordering marks | 117 | 0.03 | 0.11 |
redo size | 2,768,276 | 771.10 | 2,641.48 |
redo subscn max counts | 361 | 0.10 | 0.34 |
redo synch time | 2 | 0.00 | 0.00 |
redo synch writes | 112 | 0.03 | 0.11 |
redo wastage | 459,144 | 127.89 | 438.11 |
redo write broadcast ack time | 0 | 0.00 | 0.00 |
redo write time | 74 | 0.02 | 0.07 |
redo writer latching time | 0 | 0.00 | 0.00 |
redo writes | 1,483 | 0.41 | 1.42 |
rollback changes - undo records applied | 6 | 0.00 | 0.01 |
rollbacks only - consistent read gets | 3 | 0.00 | 0.00 |
rows fetched via callback | 431,199 | 120.11 | 411.45 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 3,119 | 0.87 | 2.98 |
session logical reads | 13,185,105 | 3,672.72 | 12,581.21 |
shared hash latch upgrades - no wait | 2,543 | 0.71 | 2.43 |
shared hash latch upgrades - wait | 0 | 0.00 | 0.00 |
sorts (disk) | 0 | 0.00 | 0.00 |
sorts (memory) | 8,933 | 2.49 | 8.52 |
sorts (rows) | 19,958,812 | 5,559.54 | 19,044.67 |
sql area evicted | 1,139 | 0.32 | 1.09 |
sql area purged | 1 | 0.00 | 0.00 |
summed dirty queue length | 0 | 0.00 | 0.00 |
switch current to new buffer | 18 | 0.01 | 0.02 |
table fetch by rowid | 1,748,758 | 487.12 | 1,668.66 |
table fetch continued row | 182 | 0.05 | 0.17 |
table scan blocks gotten | 10,596,340 | 2,951.62 | 10,111.01 |
table scan rows gotten | 572,396,828 | 159,441.44 | 546,180.18 |
table scans (long tables) | 0 | 0.00 | 0.00 |
table scans (short tables) | 9,378 | 2.61 | 8.95 |
total number of times SMON posted | 21 | 0.01 | 0.02 |
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 | 2 | 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 | 900,848 | 250.93 | 859.59 |
user I/O wait time | 179 | 0.05 | 0.17 |
user calls | 26,063 | 7.26 | 24.87 |
user commits | 679 | 0.19 | 0.65 |
user rollbacks | 369 | 0.10 | 0.35 |
workarea executions - onepass | 0 | 0.00 | 0.00 |
workarea executions - optimal | 10,341 | 2.88 | 9.87 |
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 |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_1 | +DATADG/gpsdb/dbf_01_1.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_1 | +DATADG/gpsdb/dbf_01_11.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_1 | +DATADG/gpsdb/dbf_01_21.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_1 | +DATADG/gpsdb/dbf_01_31.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_2 | +DATADG/gpsdb/dbf_01_02.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_2 | +DATADG/gpsdb/dbf_01_12.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_2 | +DATADG/gpsdb/dbf_01_2.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_2 | +DATADG/gpsdb/dbf_01_22.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_2 | +DATADG/gpsdb/dbf_01_32.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_3 | +DATADG/gpsdb/dbf_01_03.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_01_3 | +DATADG/gpsdb/dbf_01_13.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_01_3 | +DATADG/gpsdb/dbf_01_3.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_1 | +DATADG/gpsdb/dbf_02_01.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_1 | +DATADG/gpsdb/dbf_02_1.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_1 | +DATADG/gpsdb/dbf_02_11.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_1 | +DATADG/gpsdb/dbf_02_21.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_1 | +DATADG/gpsdb/dbf_02_31.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_2 | +DATADG/gpsdb/dbf_02_02.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_2 | +DATADG/gpsdb/dbf_02_12.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_2 | +DATADG/gpsdb/dbf_02_2.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_02_2 | +DATADG/gpsdb/dbf_02_22.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_2 | +DATADG/gpsdb/dbf_02_32.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_3 | +DATADG/gpsdb/dbf_02_03.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_3 | +DATADG/gpsdb/dbf_02_13.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_02_3 | +DATADG/gpsdb/dbf_02_3.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_03_1 | +DATADG/gpsdb/dbf_03_1 |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_03_1 | +DATADG/gpsdb/dbf__03_01.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_03_1 | +DATADG/gpsdb/dbf__03_11.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_03_2 | +DATADG/gpsdb/dbf_03_02.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_03_2 | +DATADG/gpsdb/dbf_03_12.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_03_2 | +DATADG/gpsdb/dbf_03_2 |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_03_3 | +DATADG/gpsdb/dbf_03_03.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_03_3 | +DATADG/gpsdb/dbf_03_13.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_03_3 | +DATADG/gpsdb/dbf_03_3 |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_04_1 | +DATADG/gpsdb/dbf_04_1 |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_04_2 | +DATADG/gpsdb/dbf_04_2 |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_04_3 | +DATADG/gpsdb/dbf_04_3 |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_05_1 | +DATADG/gpsdb/dbf_05_1 |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_05_2 | +DATADG/gpsdb/dbf_05_2 |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_05_3 | +DATADG/gpsdb/dbf_05_3 |
8 | 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 |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_06_2 | +DATADG/gpsdb/dbf_06_2.dbf |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_06_2 | +DATADG/gpsdb/dbf_06_2b.dbf |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_06_3 | +DATADG/gpsdb/dbf_06_3.dbf |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_06_3 | +DATADG/gpsdb/dbf_06_3b.dbf |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_07_1 | +DATADG/gpsdb/dbf_07_1.dbf |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_07_1 | +DATADG/gpsdb/dbf_07_1b.dbf |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_07_2 | +DATADG/gpsdb/dbf_07_2.dbf |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_07_2 | +DATADG/gpsdb/dbf_07_2b.dbf |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_07_3 | +DATADG/gpsdb/dbf_07_3.dbf |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_07_3 | +DATADG/gpsdb/dbf_07_3b.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_08_1 | +DATADG/gpsdb/dbf_08_1.dbf |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_08_1 | +DATADG/gpsdb/dbf_08_1b.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_08_1 | +FLASHAREA_DG/gpsdb/dbf_08_2.dbf |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_08_2 | +DATADG/gpsdb/dbf_08_2.dbf |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_08_2 | +DATADG/gpsdb/dbf_08_2b.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_08_3 | +DATADG/gpsdb/dbf_08_3.dbf |
3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_08_3 | +DATADG/gpsdb/dbf_08_3b.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_08_3 | +DATADG/gpsdb/dbf_08_3c.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_09_1 | +DATADG/gpsdb/dbf_09_1.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_09_1 | +DATADG/gpsdb/dbf_09_1_01.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_09_2 | +DATADG/gpsdb/dbf_09_2.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_09_2 | +DATADG/gpsdb/dbf_09_2b.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_09_2 | +DATADG/gpsdb/dbf_10_2_03.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_09_3 | +DATADG/gpsdb/dbf_09_3.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_09_3 | +DATADG/gpsdb/dbf_09_3b.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_10_1 | +DATADG/gpsdb/dbf_10_1.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_10_1 | +DATADG/gpsdb/dbf_10_1_02.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_10_2 | +DATADG/gpsdb/dbf_10_2.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_10_2 | +DATADG/gpsdb/dbf_10_2_02.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_10_2 | +DATADG/gpsdb/dbf_10_2_12.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_10_3 | +DATADG/gpsdb/dbf_10_3.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_10_3 | +DATADG/gpsdb/dbf_10_3_02.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_10_3 | +DATADG/gpsdb/dbf_10_3_03.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_10_3 | +DATADG/gpsdb/dbf_10_3_13.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_11_1 | +DATADG/gpsdb/dbf_11_1.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_11_1 | +DATADG/gpsdb/dbf_11_1_02.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_11_2 | +DATADG/gpsdb/dbf_11_2.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_11_2 | +DATADG/gpsdb/dbf_11_2_02.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_11_2 | +DATADG/gpsdb/dbf_11_2_12.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_11_3 | +DATADG/gpsdb/dbf_11_3.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_11_3 | +DATADG/gpsdb/dbf_11_3_02.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_11_3 | +DATADG/gpsdb/dbf_11_3_03.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_1 | +DATADG/gpsdb/dbf_12_01.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_1 | +DATADG/gpsdb/dbf_12_1.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_1 | +DATADG/gpsdb/dbf_12_11.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_2 | +DATADG/gpsdb/dbf_12_02.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_2 | +DATADG/gpsdb/dbf_12_12.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_2 | +DATADG/gpsdb/dbf_12_2.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_3 | +DATADG/gpsdb/dbf_12_03.dbf |
8 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_3 | +DATADG/gpsdb/dbf_12_23.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
HIS_GPS_12_3 | +DATADG/gpsdb/dbf_12_3.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HIS_GPS_12_3 | +DATADG/gpsdb/dbf_12_3_13.dbf |
8 | 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 |
51 | 0 | 4.51 | 1.73 | 484 | 0 | 0 | 0.00 |
SYSTEM | +DATADG/gpsdb/system01.dbf |
1 | 0 | 0.00 | 1.00 | 98 | 0 | 0 | 0.00 |
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 |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
UNDOTBS1 | +DATADG/gpsdb/undotbs05.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
UNDOTBS2 | +DATADG/gpsdb/undotbs02.dbf |
1 | 0 | 0.00 | 1.00 | 74 | 0 | 0 | 0.00 |
UNDOTBS2 | +DATADG/gpsdb/undotbs04.dbf |
4 | 0 | 0.00 | 1.00 | 16 | 0 | 0 | 0.00 |
UNDOTBS2 | +DATADG/gpsdb/undotbs06.dbf |
4 | 0 | 0.00 | 1.00 | 39 | 0 | 0 | 0.00 |
UNDOTBS2 | +DATADG/gpsdb/undotbs07.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
UNDOTBS2 | +DATADG/gpsdb/undotbs08.dbf |
4 | 0 | 0.00 | 1.00 | 6 | 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 |
11 | 0 | 2.73 | 1.82 | 9 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_02.dbf |
3 | 0 | 6.67 | 1.00 | 4 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_03.dbf |
3 | 0 | 6.67 | 1.67 | 3 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_04.dbf |
2 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_05.dbf |
6 | 0 | 11.67 | 2.17 | 12 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_06.dbf |
8 | 0 | 7.50 | 1.13 | 16 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_07.dbf |
21 | 0 | 2.86 | 1.24 | 15 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_08.dbf |
10 | 0 | 1.00 | 1.00 | 7 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_09.dbf |
16 | 0 | 1.25 | 1.00 | 26 | 0 | 1 | 20.00 |
WZT | +DATADG/gpsdb/wzt_tbs_10.dbf |
3 | 0 | 3.33 | 1.00 | 7 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_11.dbf |
13 | 0 | 5.38 | 1.00 | 20 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_12.dbf |
12 | 0 | 6.67 | 1.58 | 32 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_13.dbf |
6 | 0 | 3.33 | 3.83 | 22 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_14.dbf |
277 | 0 | 0.29 | 1.00 | 10 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_15.dbf |
9 | 0 | 5.56 | 1.11 | 6 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_16.dbf |
8 | 0 | 10.00 | 1.75 | 9 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_17.dbf |
10 | 0 | 4.00 | 1.50 | 5 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_18.dbf |
9 | 0 | 3.33 | 1.44 | 13 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_19.dbf |
9 | 0 | 2.22 | 1.56 | 5 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_20.dbf |
7 | 0 | 7.14 | 2.00 | 4 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_21.dbf |
12 | 0 | 5.83 | 1.92 | 19 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_22.dbf |
3 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_23.dbf |
4 | 0 | 2.50 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_24.dbf |
7 | 0 | 4.29 | 2.29 | 8 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_25.dbf |
8 | 0 | 1.25 | 1.00 | 5 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_26.dbf |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_27.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_28.dbf |
6 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_29.dbf |
7 | 0 | 1.43 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_30.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_31.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_32.dbf |
6 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_33.dbf |
9 | 0 | 0.00 | 1.00 | 18 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_34.dbf |
12 | 0 | 0.83 | 1.00 | 1 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_35.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_36.dbf |
9 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_37.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_38.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
WZT | +DATADG/gpsdb/wzt_tbs_39.dbf |
8 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
WZT | +FLASHAREA_DG/gpsdb/wzt_tbs_26.dbf |
6 | 0 | 0.00 | 1.00 | 6 | 0 | 0 | 0.00 |