SQL Id | SQL Text |
04xtrk7uyhknh | select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null |
05mbgav5mj9wz | SELECT ORG_NO FROM C_CONS WHERE CONS_NO= :1 AND ORG_NO LIKE :2 |
0cb3kttntx36c | INSERT INTO TMP_TQ_YXCJS_MX SELECT A.ORG_NO, A.CONS_NO, :B2 , TG_NO, TG_NAME, B.TG_ID FROM C_MP A, G_TG B, C_METER_MP_RELA C, D_METER E WHERE MP_ATTR_CODE = '01' AND STATUS_CODE IN ('01', '02', '03') AND A.TG_ID = B.TG_ID AND B.PUB_PRIV_FLAG = '01' AND C.MP_ID = A.MP_ID AND B.TG_ID = :B1 AND EXISTS (SELECT 1 FROM TMP_TQ_YXCJS@LNJCJG S WHERE KH_AZS + DX_AZS + SX_AZS - KH_CJS - DX_CJS - SX_CJS < 10 AND DATA_DATE = :B2 AND B.TG_ID = S.TG_ID) AND C.METER_ID = E.METER_ID AND E.WIRING_MODE = '1' AND NOT EXISTS (SELECT 1 FROM (SELECT A.CONS_NO N FROM C_MP A, G_TG B, C_METER_MP_RELA C, D_METER E, R_COLL_OBJ D, R_TMNL_RUN F, R_CP_MP_RELA G WHERE MP_ATTR_CODE = '01' AND C.METER_ID = D.METER_ID AND F.CP_NO = G.CP_NO AND A.MP_ID = G.MP_ID AND A.STATUS_CODE IN ('01', '02', '03') AND A.TG_ID = B.TG_ID AND B.TG_ID = :B1 AND EXISTS (SELECT 1 FROM TMP_TQ_YXCJS@LNJCJG S WHERE KH_AZS + DX_AZS + SX_AZS - KH_CJS - DX_CJS - SX_CJS < 10 AND DATA_DATE = :B2 AND B.TG_ID = S.TG_ID) AND B.PUB_PRIV_FLAG = '01' AND C.MP_ID = A.MP_ID AND C.METER_ID = E.METER_ID AND E.WIRING_MODE = '1') M WHERE M.N = A.CONS_NO) |
0f4k35h47njhx | SELECT "A1"."BELONG_DEPT", "A1"."BELONG_DEPT", "A1"."PR_CODE", "A1"."METER_ID", "A1"."SORT_CODE", "A1"."TYPE_CODE", "A1"."CUR_STATUS_CODE", "A1"."METER_ID", "A1"."BELONG_DEPT", "A2"."INST_DATE", "A2"."METER_ID", "A2"."ORG_NO" FROM "EPM_LN"."D_METER" "A1", "EPM_LN"."C_METER" "A2" WHERE "A2"."ORG_NO" LIKE :1||'%' AND "A1"."METER_ID"="A2"."METER_ID" AND "A1"."BELONG_DEPT"=:2 AND "A1"."CUR_STATUS_CODE"='012' AND "A1"."BELONG_DEPT" LIKE :3||'%' AND ("A1"."SORT_CODE"='10' OR ("A1"."TYPE_CODE"='26' OR "A1"."TYPE_CODE"='27' OR "A1"."TYPE_CODE"='28' OR "A1"."TYPE_CODE"='29')) |
0h6b2sajwb74n | select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
0rjdhcgspcc7r | create global temporary table sys.ora_temp_1_ds_2478185 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVBL_ID", "ACCT_NO", "ACCT_ID", "AMT", "ACCOUNTANT_NO", "BOOK_TIME", "BOOK_DATE", "ACCT_YM", "ORG_NO", "CONS_NO", "RCVBL_AMT_ID", "RCVBL_YM", "AMT_TYPE", "AREA_NO", "DBCR_FLAG" from "EPM_LN"."A_RCVBL_ENTRY" sample ( .3372806246) t where 1 = 2 |
101qfsakr5t87 | create global temporary table sys.ora_temp_1_ds_2478179 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"MR_STATUS_CODE", "EXCP_TYPE_CODE", "LAST_MR_DATE", "THIS_YMD", "SRC_CODE", "RELA_APP_NO", "MR_FACTOR", "ACTUAL_MODE", "METER_DATE", "CHECK_TYPE", "PRC_CODE", "BIN_MT_POS", "ASSET_NO", "MADE_NO", "ADJUST_PQ", "ADJUST_MODE", "RECORD_ID", "CONS_MT_ID", "MODIFY_TIMES", "USAGE_TYPE_CODE", "CONTAINER_NO", "T_PRC", "REMARK", "BAR_CODE", "MR_ID", "MR_PLAN_NO", "APP_NO", "CALC_ID", "AMT_YM", "CONS_NO", "ORG_NO", "METER_ID", "MP_ID", "MR_SN", "AVG_PQ", "MR_DIGIT", "READ_TYPE_CODE", "T_FACTOR", "LAST_MR_NUM", "LAST_MR_PQ", "THIS_READ", "THIS_READ_PQ" from "EPM_LN"."ARC_R_DATA" sample ( .9047537812) t where 1 = 2 |
1b27y3nt6u9bw | select sa_user.USER_ID as "USER_ID", sa_user.DEPT_ID as "DEPT_ID", sa_user.USER_NAME as "USER_NAME", sa_user.PASSWORD as "PASSWORD", sa_user.REAL_NAME as "REAL_NAME", sa_user.IS_LOCK as "IS_LOCK", sa_user.IS_DELETE as "IS_DELETE", sa_user.TELEPHONE as "TELEPHONE", sa_user.PASSWORD_UPDATE_TIME as "PASSWORD_UPDATE_TIME", sa_user.LOCK_TIME as "LOCK_TIME", sa_user.ATTR1 as "ATTR1", sa_user.ATTR2 as "ATTR2", sa_user.ATTR3 as "ATTR3", sa_user.ATTR4 as "ATTR4", sa_user.MAIL as "MAIL", sa_user.GENDER as "GENDER", sa_user.USER_IP as "USER_IP", sa_user.IS_MANAGER as "IS_MANAGER", sa_user.USER_TYPE as "USER_TYPE", sa_user.HIS_PASSWORD1 as "HIS_PASSWORD1", sa_user.HIS_PASSWORD2 as "HIS_PASSWORD2", sa_user.HIS_PASSWORD3 as "HIS_PASSWORD3", sa_user.HIS_PASSWORD4 as "HIS_PASSWORD4", sa_user.HIS_PASSWORD5 as "HIS_PASSWORD5", sa_user.HIS_PASSWORD6 as "HIS_PASSWORD6", sa_user.CREATE_TIME as "CREATE_TIME" from sa_user where sa_user.USER_ID = :1 |
1g7ygustztgs2 | create global temporary table sys.ora_temp_1_ds_2478191 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RELA_APP_NO", "METER_DATE", "BIN_MT_POS", "ASSET_NO", "MADE_NO", "RECORD_ID", "CONS_MT_ID", "CONTAINER_NO", "REMARK", "BAR_CODE", "CALC_ID", "CONS_NO", "METER_ID", "MP_ID", rowid SYS_DS_ALIAS_0 from "EPM_LN"."ARC_R_DATA" sample ( 11.8768775488) t where 1 = 2 |
1gfb6p1k36dj6 | create global temporary table sys.ora_temp_1_ds_2478176 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVBL_AMT_ID", "CALC_ID", "AMT_TYPE", "RCVBL_YM", "CONS_NO", "ORG_NO", "PAY_MODE", "T_PQ", "RCVBL_AMT", "RCVED_AMT", "STATUS_CODE", "SETTLE_FLAG", "PENALTY_BGN_DATE", "RCVBL_INPRICE_AMT", "RCVBL_PL_AMT", "RCVED_IN_PRICE_AMT", "RCVED_PL_AMT", "RCVBL_PENALTY", "RCVED_PENALTY", "RISK_LEVEL_CODE", "RELEASE_DATE", "ACCT_NO", "OWE_AMT", "MP_ID", "TARIFF_ID", "APP_NO", "DISPOSE_AMT", "DISPOSE_INPRICE", "DISPOSE_PL", "DISPOSE_PENALTY", "RENDER_MAN", "RENDER_DATE", "RECE_RPT_NO", "CARD_PRINTED", "PRC_AMT_ID", "CARRYOVER_FLAG", "INVISIBLE_FLAG" from "EPM_LN"."A_RCVBL_FLOW" sample ( .8583477602) t where 1 = 2 |
1mjd9xp80vuqa | select node, owner, name from syn$ where obj#=:1 |
1pgp558xspvaa | SELECT PROPERTY FROM SYS.TAB$ WHERE OBJ# = :B1 |
1uqm3qvbus277 | create global temporary table sys.ora_temp_1_ds_2468483 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"PREPAY_DATE", "PREPAY_YM", "ACCT_NO", "NOTE_ID", "REMA_TYPE", "REMAIN", "PAY_MODE", "PART_CHG_YM", "FREEZE_AMT", "PREPAY_ID", "CHARGE_ID", "PREPAY_AMT", "CONS_NO", "ORG_NO" from "EPM_LN"."A_PREPAY_FLOW" sample ( .6392910113) t where 1 = 2 |
1x9b90huwf3nt | INSERT INTO TMP_TQ_YXCJS_MX SELECT A.ORG_NO, A.CONS_NO, :B2 , TG_NO, TG_NAME, B.TG_ID FROM C_MP A, G_TG B, C_METER_MP_RELA C WHERE MP_ATTR_CODE = '02' AND A.MP_ID = C.MP_ID AND A.STATUS_CODE IN ('01', '02', '03') AND A.TG_ID = B.TG_ID AND B.TG_ID = :B1 AND EXISTS (SELECT 1 FROM TMP_TQ_YXCJS@LNJCJG S WHERE KH_AZS + DX_AZS + SX_AZS - KH_CJS - DX_CJS - SX_CJS < 10 AND DATA_DATE = :B2 AND B.TG_ID = S.TG_ID) AND B.PUB_PRIV_FLAG = '01' AND NOT EXISTS (SELECT 1 FROM (SELECT A.CONS_NO N FROM C_MP A, G_TG B, C_METER_MP_RELA C, R_COLL_OBJ D, R_TMNL_RUN E, R_CP_MP_RELA F WHERE MP_ATTR_CODE = '02' AND A.MP_ID = C.MP_ID AND C.METER_ID = D.METER_ID AND A.MP_ID = F.MP_ID AND E.CP_NO = F.CP_NO AND B.TG_ID = :B1 AND EXISTS (SELECT 1 FROM TMP_TQ_YXCJS@LNJCJG S WHERE KH_AZS + DX_AZS + SX_AZS - KH_CJS - DX_CJS - SX_CJS < 10 AND DATA_DATE = :B2 AND B.TG_ID = S.TG_ID) AND A.STATUS_CODE IN ('01', '02', '03') AND A.TG_ID = B.TG_ID AND B.PUB_PRIV_FLAG = '01') M WHERE M.N = A.CONS_NO) |
1yhhj8t99mzpn | insert into A_PC_TRAN_CHK(FILE_ID, EXCHG_ID, PL_ORG_CODE, EXCHG_CHANNEL, CONS_NO, EXCHG_YM, EXCHG_AMT, LAST_CHG, THIS_CHG, EXCHG_DATE, ACCT_DATE, RCVBL_NO_DTL_ID, EXCHG_TYPE_CODE, ORG_NO, SERIAL_NO, CANCEL_FLAG, AGENCIES_NO, COUNTER_NO, BANK_NO, ORGN_CONS_NO, RETURN_CODE, REMARK) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22) |
228m3taq5qfd8 | create global temporary table sys.ora_temp_1_ds_2478192 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RELA_APP_NO", "METER_DATE", "BIN_MT_POS", "ASSET_NO", "MADE_NO", "RECORD_ID", "CONS_MT_ID", "CONTAINER_NO", "REMARK", "BAR_CODE", "CALC_ID", "CONS_NO", "METER_ID", "MP_ID", rowid SYS_DS_ALIAS_0 from "EPM_LN"."ARC_R_DATA" sample ( 11.6324341318) t where 1 = 2 |
2bgqts87amgg6 | BEGIN UG_ACCR_LFEE_CALC.UP_LATEFEE_CALC_BY_CONSNO(:1, :2); END; |
2hm549s5cgxqb | select cons_no from c_cons where (( card_no=:1 ) or ( orgn_cons_no = :2)) and org_no like :3 and status_code<>'9' |
2m8db5h8zy794 | select * from (select alia.*, rownum as rnum from (SELECT instance_id, state_change_time, prolong_time, overtime_count, when_overtime, current_state, objecttype, create_time, time_out_time, schedule_type, timer_type, warning_interval, group_id, version FROM rt_overtime_deal WHERE time_out_time IS NOT NULL AND time_out_time<=:1 AND current_state=1 AND (overtime_count<1 OR overtime_count is NULL) AND handlestate=0 AND version=0) alia where rownum <2) where rnum>=1 |
2q7quf6dfntys | create global temporary table sys.ora_temp_1_ds_2468487 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVBL_ID", "ACCT_NO", "ACCT_ID", "AMT", "ACCOUNTANT_NO", "BOOK_TIME", "BOOK_DATE", "ACCT_YM", "ORG_NO", "CONS_NO", "RCVBL_AMT_ID", "RCVBL_YM", "AMT_TYPE", "AREA_NO", "DBCR_FLAG" from "EPM_LN"."A_RCVBL_ENTRY" sample ( .4566128314) t where 1 = 2 |
2q93zsrvbdw48 | select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee# |
2ym6hhaq30r73 | select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3 |
30qgskkwhqvt6 | BEGIN PRC_O_CUST_VALUE_EVAL(:1); END; |
32bhha21dkv0v | select col#, intcol#, charsetid, charsetform from col$ where obj#=:1 order by intcol# asc |
35dw88vgy2zuc | create global temporary table sys.ora_temp_1_ds_2478186 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVBL_ID", "ACCT_NO", "ACCT_ID", "AMT", "ACCOUNTANT_NO", "BOOK_TIME", "BOOK_DATE", "ACCT_YM", "ORG_NO", "CONS_NO", "RCVBL_AMT_ID", "RCVBL_YM", "AMT_TYPE", "AREA_NO", "DBCR_FLAG" from "EPM_LN"."A_RCVBL_ENTRY" sample ( .2204509792) t where 1 = 2 |
3r0q2w331jup9 | SELECT /*+ USE_HASH ("A1") USE_HASH ("A2") */ "A1"."INS_NAME", "A1"."END_TIME", "A1"."APP_NO", "A1"."END_TIME", "A1"."END_TIME", "A1"."STATUS_CODE", "A1"."INS_NAME", "A2"."PS_ORG_NO", "A2"."APP_NO", "A2"."APP_MODE", "A2"."PS_ORG_NO", "A2"."PERMENANT_REDUCE_FLAG", "A2"."ELEC_TYPE_CODE", "A2"."APP_ID", "A2"."APP_NO", "A2"."PS_ORG_NO" FROM "P_PROC_INSTANCE" "A1", "ARC_S_APP" "A2" WHERE "A2"."PS_ORG_NO" LIKE :1 AND "A2"."APP_NO"="A1"."APP_NO" AND "A1"."END_TIME"<:2 AND "A1"."END_TIME">=:3 AND "A1"."STATUS_CODE"='02' |
4jc5ucwq7a0h2 | SELECT *
FROM (SELECT NV.*
FROM VIEW_WORKITEM_NFLOW NV
WHERE NV.USER_ENTITY_ID = :1
UNION ALL
SELECT NV.*
FROM VIEW_WORKITEM_NFLOW NV, SA_BROLE_USER BU
WHERE NV.USER_ENTITY_ID = BU.ROLE_ID
AND BU.USER_ID = :2) T
WHERE T.WT_WORKTASK_STATUS = '01'
AND (T.WT_DEPT_ID IS NULL OR T.WT_DEPT_ID = '' OR T.WT_DEPT_ID = :3)
|
4mdhzj69qgg43 | UPDATE sys_group_server SET lastupdate=:1 where id=:2 |
4rq1j4m31t2rm | SELECT SUBSTR("A3"."PS_ORG_NO", 1, 5)||"A3"."APP_NO", SUBSTR("A3"."PS_ORG_NO", 1, 5)||"A2"."CONS_NO", :1, "A2"."CONS_NO", "A2"."CONS_NAME", "A3"."PS_ORG_NO", "A2"."ELEC_ADDR", "A3"."VOLT_CODE", "A2"."TRADE_CODE", NVL("A3"."HEC_INDUSTRY_CODE", '000'), "A2"."ELEC_TYPE_CODE", "A2"."ELEC_TYPE_CODE", "A2"."ID", "A2"."CONTRACT_CAP", "A1"."INS_NAME" FROM "ARC_S_APP" "A3", "ARC_S_BATCH_CUST_APP" "A2", "P_PROC_INSTANCE" "A1" WHERE "A3"."APP_ID"="A2"."APP_ID" AND "A3"."APP_NO"="A1"."APP_NO" AND "A1"."BGN_TIME">=:2 AND "A1"."BGN_TIME"<:3 AND ("A1"."INS_NAME"='103' OR "A1"."INS_NAME"='112' OR "A1"."INS_NAME"='217') AND "A3"."PS_ORG_NO" LIKE :4 |
4v031pzgh9ab1 | call pro_tq_yxcjs_mx_auto ( ) |
5tbw0ux7xt6gu | select app_no, emp_no, org_no, reply_interval, reply_time from (
select a.app_no, a.emp_no, a.org_no,
(select b.value from s_wkst_ext_attr b where b.app_no = a.app_no and b.ATTR_INFO_ID = 30000000001600) reply_interval,
(select b.value from s_wkst_ext_attr b where b.app_no = a.app_no and b.ATTR_INFO_ID = 30000000000800) reply_time,
(select b.value from s_wkst_ext_attr b where b.app_no = a.app_no and b.ATTR_INFO_ID = 30000000001200) continue_flag
from s_95598_wkst a
where a.busi_type_code = '003'
and a.handle_status_code = '05'
)where continue_flag = '1' |
5xumgxq6gcqmp |
create global temporary table sys.ora_temp_1_ds_2468490 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"GC_TYPE_CODE", "ABSO_MODE", "USER_TYPE_CODE", "DIVISION_CODE", "RUN_CAP", "CONTRACT_CAP", "POWEROFF_CODE", "ARC_CALC_ID", "HANLE_REMARK", "REMIND_SECT_NO", "AMT_CALC_ID", "CALC_PERIOD", "CALC_ID", "APP_CODE", "YM", "CONS_ID", "ORG_NO", "VERI_RSLT", "VERI_REMARK", "CALC_DATE", "SEND_DATE", "CONS_NO", "CONS_NAME", "CONS_SORT_CODE", "ELEC_ADDR", "TRADE_TYPE_CODE", "ELEC_TYPE_CODE", "VOLT_CODE", "HEC_TRADE_CODE", "CREATE_DATE", "POWERON_DATE", "CANCEL_DATE", "STATUS_CODE", "BUSI_REGION_NO", "TRANSFER_FLAG", "MR_SECT_NO", "GP_CODE", "RENDER_STATUS", "CALC_TYPE", "CALC_TIMES", "PAY_MODE", "USE_MONTH", "DATA_SRC", "ORGN_CONS_NO", "APP_NO_REF", "SHIFT_NO" from "EPM_LN"."ARC_E_CONS_SNAP" sample ( 1.0248965618) t where 1 = 2
|
605pnt2r2v42y | BEGIN PRC_O_CR_PA_BAL(:1); END; |
60xbnxfw0y4xg | select lock_name from sa_task_locks where lock_name in (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20) for update nowait |
62bv5jwtxafkz | select a.acct_no
from tmp_a_pay_flow a
where not exists (select 1
from a_rcvbl_flow b
where b.cons_no = a.cons_no
and b.settle_flag in ('01', '02') and b.STATUS_CODE = '01') |
6f8zytx9xtz7a | create global temporary table sys.ora_temp_1_ds_2478180 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RELA_APP_NO", "METER_DATE", "BIN_MT_POS", "ASSET_NO", "MADE_NO", "RECORD_ID", "CONS_MT_ID", "CONTAINER_NO", "REMARK", "BAR_CODE", "CALC_ID", "CONS_NO", "METER_ID", "MP_ID", rowid SYS_DS_ALIAS_0 from "EPM_LN"."ARC_R_DATA" sample ( 25.0000000000) t where 1 = 2 |
6mxnqk9th80qf | BEGIN DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC; END;
|
6znnf8yzkhmyv | create global temporary table sys.ora_temp_1_ds_2468482 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"PREPAY_DATE", "PREPAY_YM", "ACCT_NO", "NOTE_ID", "REMA_TYPE", "REMAIN", "PAY_MODE", "PART_CHG_YM", "FREEZE_AMT", "PREPAY_ID", "CHARGE_ID", "PREPAY_AMT", "CONS_NO", "ORG_NO" from "EPM_LN"."A_PREPAY_FLOW" sample ( .5945832300) t where 1 = 2 |
740nbjv41w09a | create global temporary table sys.ora_temp_1_ds_2468464 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"PREPAY_DATE", "PREPAY_YM", "ACCT_NO", "NOTE_ID", "REMA_TYPE", "REMAIN", "PAY_MODE", "PART_CHG_YM", "FREEZE_AMT", "PREPAY_ID", "CHARGE_ID", "PREPAY_AMT", "CONS_NO", "ORG_NO" from "EPM_LN"."A_PREPAY_FLOW" sample ( .5982089667) t where 1 = 2 |
77ymahwdhzt7p | create global temporary table sys.ora_temp_1_ds_2468434 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVBL_AMT_ID", "CHARGE_ID", "CONS_NO", "ACCT_NO", "NOTE_ID", "MP_ID", rowid SYS_DS_ALIAS_0 from "EPM_LN"."A_RCVED_FLOW" sample ( 9.0744275307) t where 1 = 2 |
7879mzp3tvg43 | create global temporary table sys.ora_temp_1_ds_2468431 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVED_AMT_ID", "RCVBL_AMT_ID", "CHARGE_ID", "ORG_NO", "CONS_NO", "RCVED_YM", "RCVED_DATE", "THIS_RCVED_AMT", "THIS_IN_PRICE_AMT", "THIS_PL_AMT", "THIS_PENALTY", "ACCT_NO", "OWE_AMT", "NOTE_ID", "TARIFF_ID", "MP_ID", "RCVBL_YM", "PART_CHG_YM" from "EPM_LN"."A_RCVED_FLOW" sample ( .9074427531) t where 1 = 2 |
7ng34ruy5awxq | select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj# |
7sj50vy1ddv99 | INSERT INTO O_CONSBASE SELECT SEQ_O_CONSBASE.NEXTVAL, A.ORGNO, A.ORGNAME, A.VOLTCODE, A.TRADECODE, A.CONSSORTCODE, A.ELECTCODE, A.CONSNUM, A.RUNCAP, A.CONCAP FROM (SELECT CONS.ORG_NO ORGNO, LINE_CONS.LINEID ORGNAME, CONS.VOLT_CODE VOLTCODE, CONS.TRADE_CODE TRADECODE, CONS.CONS_SORT_CODE CONSSORTCODE, CONS.ELEC_TYPE_CODE ELECTCODE, COUNT(CONS.CONS_ID) CONSNUM, SUM(CONS.RUN_CAP) RUNCAP, SUM(CONS.CONTRACT_CAP) CONCAP FROM C_CONS CONS, (SELECT DISTINCT B.ORG_NO ORGNO, D.LINE_ID LINEID, B.CONS_ID CONSID FROM C_MP B, G_LINE D WHERE B.LINE_ID = D.LINE_ID AND B.ORG_NO = D.ORG_NO AND B.ORG_NO LIKE :B1 ||'%') LINE_CONS, SA_ORG ORG WHERE CONS.CONS_ID = LINE_CONS.CONSID AND CONS.ORG_NO = LINE_CONS.ORGNO AND CONS.ORG_NO = ORG.ORG_NO AND CONS.ORG_NO LIKE :B1 ||'%' GROUP BY CONS.ORG_NO, LINE_CONS.LINEID, CONS.VOLT_CODE, CONS.TRADE_CODE, CONS.CONS_SORT_CODE, CONS.ELEC_TYPE_CODE) A |
7tc5u8t3mmzgf | select cachedblk, cachehit, logicalread from tab_stats$ where obj#=:1 |
7urkvbjgcy30s | create global temporary table sys.ora_temp_1_ds_2468444 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"PREPAY_DATE", "PREPAY_YM", "ACCT_NO", "NOTE_ID", "REMA_TYPE", "REMAIN", "PAY_MODE", "PART_CHG_YM", "FREEZE_AMT", "PREPAY_ID", "CHARGE_ID", "PREPAY_AMT", "CONS_NO", "ORG_NO" from "EPM_LN"."A_PREPAY_FLOW" sample ( .6935411072) t where 1 = 2 |
83m5qm6bras0m |
SELECT *
FROM (SELECT LI.*,
CASE
WHEN LI.OVERDUED_NE = 1 OR LI.OVERDUED_NE = 3 THEN 1
WHEN LI.OVERDUED_NE = 0 OR LI.OVERDUED_NE = 2 THEN
CASE
WHEN E.SUSPEND_FLAG = 0 THEN
CASE
WHEN SYSTIMESTAMP >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
WHEN E.SUSPEND_FLAG = 1 THEN
CASE
WHEN E.SUSPEND_TIME >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
ELSE 0
END
ELSE 0
END OVERDUED,
CASE
WHEN E.TARGET_OVERDUE_MINTIME IS NULL THEN LI.TARGET_TIME_NE
WHEN LI.TARGET_TIME_NE IS NULL THEN E.TARGET_OVERDUE_MINTIME
WHEN E.TARGET_OVERDUE_MINTIME <= LI.TARGET_TIME_NE THEN E.TARGET_OVERDUE_MINTIME
ELSE LI.TARGET_TIME_NE
END TARGET_TIME,
FTM.WORKFORM_TYPE_KIND
FROM (SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_
STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME AS WI_INSTANCE_NAME,
F.WORKFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = :1
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :2
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE F.PROCINST_ID = WF.PROC_INSTANCE_ID
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.
ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:3 LIKE (WF.DEPART_ID || '%')) OR (:4 = WF.DEPART_ID) OR (:5 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :6))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:7 LIKE (F.DEPT_ID || '%')) OR (:8 = F.DEPT_ID) OR (:9 = F.DEPT_ID) OR (F.DEPT_ID LIKE :10))))))
UNION ALL
SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME AS WI_INSTANCE_NAME,
F.WORKFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = :11
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE
= 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :12
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
RT_PROCESSINSTANCE P,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE WF.PROC_INSTANCE_ID = P.PROC_INSTANCE_ID
AND P.PARENT_PROCINC_ID IS NOT NULL
AND F.PROCINST_ID = P.PARENT_PROCINC_ID
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:13 LIKE (WF.DEPART_ID || '%')) OR (:14 = WF.DEPART_ID) OR (:15 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :16))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:17 LIKE (F.DEPT_ID || '%')) OR (:18 = F.DEPT_ID) OR (:19 = F.DEPT_ID) OR (F.DEPT_ID LIKE :20))))))
AND NOT EXISTS
(SELECT 1
FROM SA_WORKFORM_INST RF
WHERE WF.PROC_INSTANC
E_ID = RF.PROCINST_ID)) LI,
SA_WF_WORKFORM_TYPE_MAP FTM,
(SELECT ACT_INST_ID,
SUSPEND_FLAG,
MIN(TARGET_OVERDUE_MINTIME) AS TARGET_OVERDUE_MINTIME,
MIN(SUSPEND_TIME) AS SUSPEND_TIME
FROM (SELECT A.ACT_INST_ID, B.*
FROM SA_WF_EXAM_ACT_INST A, SA_WF_EXAM_INST B
WHERE A.SUBJECT_INST_ID = B.SUBJECT_INST_ID
AND A.PROC_INST_ID = B.PROC_INST_ID
AND B.COMPLETE_FLAG = 0)
GROUP BY ACT_INST_ID, SUSPEND_FLAG) E
WHERE LI.WI_WORKFORM_TYPE = FTM.WORKFORM_TYPE(+)
AND LI.ACTIVITY_INS_ID = E.ACT_INST_ID(+)) T
WHERE NOT EXISTS (SELECT 1
FROM SA_WF_WORKITEM_EXCLUDED_USER US
WHERE T.WORKITEM_INS_ID = US.WORKITEM_ID
AND US.USER_ID = :21) |
8t7g4rzt1gzc7 | create global temporary table sys.ora_temp_1_ds_2468430 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVBL_AMT_ID", "CHARGE_ID", "CONS_NO", "ACCT_NO", "NOTE_ID", "MP_ID", rowid SYS_DS_ALIAS_0 from "EPM_LN"."A_RCVED_FLOW" sample ( 9.1179098594) t where 1 = 2 |
8ty34r3uz199j | create global temporary table sys.ora_temp_1_ds_2468486 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVBL_ID", "ACCT_NO", "ACCT_ID", "AMT", "ACCOUNTANT_NO", "BOOK_TIME", "BOOK_DATE", "ACCT_YM", "ORG_NO", "CONS_NO", "RCVBL_AMT_ID", "RCVBL_YM", "AMT_TYPE", "AREA_NO", "DBCR_FLAG" from "EPM_LN"."A_RCVBL_ENTRY" sample ( .5428394804) t where 1 = 2 |
8vbyw5hqumgkj |
create global temporary table sys.ora_temp_1_ds_2468453 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"USAGE_TYPE_CODE", "EQUIP_GROUP_NO", "TL_SHARE_FLAG", "LL_SHARE_FLAG", "TL_BILL_FLAG", "LL_BILL_FLAG", "LL_CALC_CODE", "AP_LL_VALUE", "RP_LL_VALUE", "MP_CAP", "LL_SHARE_VALUE", "TL_SHARE_VALUE", "PT_AP_LOSS", "PT_RP_LOSS", "MP_AP_T_PQ", "T_RPQ", "DATA_SRC", "APP_NO_REF", "CHG_DATE", "CALC_TYPE", "CALC_TIMES", "TACTIC_ID", "ELEC_KIND_CODE", "MP_NO", "MP_NAME", "RELA_APP_NO", "MP_ATTR_CODE", "MR_SHARE", "LAST_ACTUAL_DATE", "ACTUAL_DATE", "MP_PARA_SNAP_ID", "PRC_TACTIC_SNAP_ID", "MP_ID", "CALC_ID", "PRC_ID", "YM", "ORG_NO", "MEAS_MODE", "SP_ID", "PQ_CALC_MODE", "MP_LEVEL_NUM", "FQR_VALUE", "FR_DEDUCT_FLAG", "DEDUCT_ORDER", "LINE_ID", "TG_ID" from "EPM_LN"."ARC_E_MP_PARA_SNAP" sample ( 1.0410764552) t where 1 = 2
|
8xfbm11gv2rv0 | select sa_dept.DEPT_ID as "DEPT_ID", sa_dept.DEPT_NAME as "DEPT_NAME", sa_dept.PARENT_DEPT_ID as "PARENT_DEPT_ID", sa_dept.IS_DELETE as "IS_DELETE", sa_dept.IS_DATA_DEPT as "IS_DATA_DEPT", sa_dept.DEPT_TREE as "DEPT_TREE", sa_dept.DEPT_TYPE as "DEPT_TYPE", sa_dept.DEPT_SHORTNAME as "DEPT_SHORTNAME", sa_dept.ORDER_ID as "ORDER_ID", sa_dept.ATTR1 as "ATTR1", sa_dept.ATTR2 as "ATTR2", sa_dept.ATTR3 as "ATTR3", sa_dept.ATTR4 as "ATTR4", sa_dept.IS_ORGNIZATION as "IS_ORGNIZATION", sa_dept.IS_BILL as "IS_BILL", sa_dept.IS_DIRECT as "IS_DIRECT", sa_dept.IS_ACCOUNT as "IS_ACCOUNT", sa_dept.DBPAR_NO as "DBPAR_NO", sa_dept.ORG_NO as "ORG_NO" from sa_dept where sa_dept.DEPT_ID=:1 |
92gugtwhtkb4h | INSERT INTO O_CR_PA_BAL SELECT :B1 , NVL(A.ORG_NO, '99999'), NVL(D.EMP_NO, '999999'), SUM(CASE WHEN A.RCVBL_YM = :B1 THEN NVL(A.RCVBL_AMT, 0) ELSE 0 END) AS RCVBL_AMT, SUM(CASE WHEN A.RCVBL_YM = :B1 THEN NVL(A.RCVED_AMT, 0) ELSE 0 END) AS RCVED_AMT, SUM(CASE WHEN A.RCVBL_YM >= SUBSTR(:B1 , 1, 4) || '01' AND A.RCVBL_YM <= :B1 THEN NVL(A.RCVBL_AMT, 0) ELSE 0 END) AS ACCU_RCVBL_AMT, SUM(CASE WHEN A.RCVBL_YM >= SUBSTR(:B1 , 1, 4) || '01' AND A.RCVBL_YM <= :B1 THEN NVL(A.RCVED_AMT, 0) ELSE 0 END) AS ACCU_RCVED_AMT FROM A_RCVBL_FLOW A, A_CR_SECT D, A_CR_RELA F WHERE A.CONS_NO = F.CONS_NO(+) AND F.REMIND_SECT_NO = D.REMIND_SECT_NO(+) AND A.RCVBL_YM >= SUBSTR(:B1 , 1, 4) || '01' AND A.RCVBL_YM <= :B1 AND A.AMT_TYPE <> '04' GROUP BY NVL(A.ORG_NO, '99999'), NVL(D.EMP_NO, '999999') |
95wxg05nskq2q | create global temporary table sys.ora_temp_1_ds_2468450 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVED_AMT_ID", "RCVBL_AMT_ID", "CHARGE_ID", "ORG_NO", "CONS_NO", "RCVED_YM", "RCVED_DATE", "THIS_RCVED_AMT", "THIS_IN_PRICE_AMT", "THIS_PL_AMT", "THIS_PENALTY", "ACCT_NO", "OWE_AMT", "NOTE_ID", "TARIFF_ID", "MP_ID", "RCVBL_YM", "PART_CHG_YM" from "EPM_LN"."A_RCVED_FLOW" sample ( .7266833858) t where 1 = 2 |
982mf3h5wcs61 | create global temporary table sys.ora_temp_1_ds_2468473 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"RCVBL_ID", "ACCT_NO", "ACCT_ID", "AMT", "ACCOUNTANT_NO", "BOOK_TIME", "BOOK_DATE", "ACCT_YM", "ORG_NO", "CONS_NO", "RCVBL_AMT_ID", "RCVBL_YM", "AMT_TYPE", "AREA_NO", "DBCR_FLAG" from "EPM_LN"."A_RCVBL_ENTRY" sample ( .5494360643) t where 1 = 2 |
9fm623d6yqfc8 |
DECLARE
stmt VARCHAR2(31700);
currSeq NUMBER;
currUserId NUMBER;
errorMessage VARCHAR2(32767);
objstatus VARCHAR2(100);
errorVal VARCHAR2(10);
-- purpose of these is because ora_dict* is oracle implicit function and is not l-value (can't be modified)
-- we want to modify these because object being changed may not be the one we're interested in (for example
-- changing unique index affects table, and DDL on materialized view really affects the 'table' of it...)
-- so we have our own name, owner, type ('real' ones)
real_ora_dict_obj_name VARCHAR2(4000);
real_ora_dict_obj_owner VARCHAR2(100);
real_ora_dict_obj_type VARCHAR2(40);
otype VARCHAR2(100);
disallowDDL NUMBER;
indexUnique VARCHAR2(40);
moduleNameInfo VARCHAR2(400);
oldModuleNameInfo VARCHAR2(400);
oldActionInfo VARCHAR2(400);
binObject NUMBER;
dbRole VARCHAR2(40);
dbOpenMode VARCHAR2(40);
-- sequence information
seqCache NUMBER;
seqIncrementBy NUMBER;
pieceStmt VARCHAR2(31700);
outMessage VARCHAR2(32767);
toIgnore VARCHAR2(40);
journalId NUMBER;
journalIndexOwner VARCHAR2(100);
journalType VARCHAR2(40);
objectTemporary varchar2(40);
objectGenerated varchar2(40);
objectSecondary varchar2(40);
objectType varchar2(40);
userCancelSimulate EXCEPTION;
userCancelNestedSimulate EXCEPTION;
PRAGMA EXCEPTION_INIT (userCancelSimulate, -1013);
PRAGMA EXCEPTION_INIT (userCancelNestedSimulate, -1017);
isTypeTable varchar2(40);
ntype NUMBER;
BEGIN
-- IMPORTANT: this check must happen BEFORE ANY PROCESSING
-- perfor
m check for role of this database
-- if database is not PRIMARY/LOGICAL STANDBY, and if it's not READ WRITE
-- then this trigger cannot (and should not) operate
-- In case of not wanting trigger on LOGICAL STANDBY (or with READ WRITE),
-- ddl_disable script can be used on standby to disable the trigger
BEGIN
IF "GGS".DDLReplication.dbQueried IS NULL THEN
SELECT database_role, open_mode
INTO dbRole, dbOpenMode
FROM v$database;
"GGS".DDLReplication.dbQueried := TRUE;
END IF;
IF NOT (
(dbRole = 'PRIMARY' OR dbRole = 'LOGICAL STANDBY')
AND dbOpenMode = 'READ WRITE'
)
THEN
-- do not write any trace even though it should work as this is standby
"GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1);
RETURN; -- do not use trigger if not read/write and primary/logical_standby
END IF;
EXCEPTION
WHEN OTHERS THEN -- this should never happen
"GGS" .trace_put_line ('DDL', 'Error in obtaining dbrole, open mode, error ['
|| SQLERRM || ']');
raise_application_error (-20782,
"GGS" .DDLReplication.triggerErrorMessage || ':' || SQLERRM);
END;
-- END OF IMPORTANT CHECK
-- the following MUST happen after checking for role of the database
-- but BEFORE anything else. Here we check if DDL is recyclebin. Recyclebin
--
DDL can happen as 'interrupting' original DDL and shares the same
-- memory, thus entirely messing up RDBMS trigger processing and potentially
-- causing db to hang.
-- set tracing from setup table
"GGS" .DDLReplication.setTracing ();
-- retrieve first 4K of DDL statement.
-- we only use the DDL for history table that doesn't require whole DDL text.
IF "GGS" .DDLReplication.getDDLText (stmt) = 0 THEN
"GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1);
RETURN;
END IF;
IF "GGS" .DDLReplication.isRecycle(stmt) = 1 THEN
IF "GGS" .DDLReplication.trace_level >= 0 THEN
"GGS" .trace_put_line ('DDL', 'DDL ignored, it is recycle bin DDL, text [' || stmt || ']');
END IF;
IF "GGS" .DDLReplication.sql_trace = 1 THEN
dbms_session.set_sql_trace(false);
END IF;
-- just ignore recyclebin objects
"GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1);
RETURN;
END IF;
disallowDDL := 0; -- DDL is normally allowed
toIgnore := 'NO'; -- do not ignore DDL by default
-- used to delete marker entry in cancel error
"GGS" .DDLReplication.currentMarkerSeq := NULL;
-- support for exceptions testing
IF 'FALSE' = 'TRUE' THEN
SELECT VALUE
INTO errorVal
FROM "GGS" ."GGS_SETUP"
WHERE property = ',
?!%*$#';
END IF;
-- get DDL history sequence, initialize object Id
SELECT "GGS" ."GGS_DDL_SEQ" .NEXTVAL INTO "GGS" .DDLReplication.currentDDLSeq FROM dual;
"GGS" .DDLReplication.currentObjectId := NULL;
IF "GGS" .DDLReplication.trace_level >= 0 THEN
"GGS" .trace_put_line ('DDL', '************************* Start of log for DDL sequence ['
|| to_char ("GGS" .DDLReplication.currentDDLSeq) || '], v[ ' ||
"GGS" .DDLReplication.tversion || '] trace level [' ||
"GGS" .DDLReplication.trace_level || '], owner schema of DDL package [GGS], objtype ['
|| ora_dict_obj_type || '] name [' || ora_dict_obj_owner || '.' || ora_dict_obj_name || ']');
END IF;
IF "GGS" .filterDDL (
stmt,
ora_dict_obj_owner,
ora_dict_obj_name,
ora_dict_obj_type,
ora_sysevent) = 'EXCLUDE' THEN
IF "GGS" .DDLReplication.trace_level >= 0 THEN
"GGS" .trace_put_line ('DDL', 'DDL ignored because filterDDL returned EXCLUDE');
END IF;
"GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1);
RETURN;
END IF;
-- check if we want this statement at all before going any further
-- this way we avoid some large DDL that we wouldn't want anyway
-- per http://ww
w.idevelopment.info/data/Oracle/DBA_tips/Database_Administration/DBA_26.shtml
IF ora_dict_obj_type <> 'TABLESPACE'
AND
(ora_dict_obj_owner = 'SYS' OR
ora_dict_obj_owner = 'SYSTEM' OR
ora_dict_obj_owner = 'DBSNMP' OR
ora_dict_obj_owner = 'OUTLN' OR
ora_dict_obj_owner = 'MDSYS' OR
ora_dict_obj_owner = 'SYSMAN' OR
ora_dict_obj_owner = 'DMSYS' OR
(ora_dict_obj_owner = 'PUBLIC' AND ora_dict_obj_type <> 'SYNONYM') OR
ora_dict_obj_owner = 'ORDSYS' OR
ora_dict_obj_owner = 'ORDPLUGINS' OR
ora_dict_obj_owner = 'CTXSYS' OR
ora_dict_obj_owner = 'DSSYS' OR
ora_dict_obj_owner = 'PERFSTAT' OR
ora_dict_obj_owner = 'WKPROXY' OR
ora_dict_obj_owner = 'WKSYS' OR
ora_dict_obj_owner = 'WMSYS' OR
ora_dict_obj_owner = 'EXFSYS' OR
ora_dict_obj_owner = 'XDB' OR
ora_dict_obj_owner = 'ANONYMOUS' OR
ora_dict_obj_owner = 'ODM' OR
ora_dict_obj_owner = 'ODM_MTR' OR
ora_dict_obj_owner = 'OLAPSYS' OR
ora_dict_obj_owner = 'TRACESVR' OR
ora_dict_obj_owner = 'REPADMIN' OR
ora_dict_obj_owner = 'AURORA$ORB$UNAUTHENTICATED' OR
ora_dict_obj_owner = 'AURORA$JIS$UTILITY$' OR
ora_dict_obj_owner = 'OSE$HTTP$ADMIN')
THEN
IF "GGS" .DDLReplication.trace_level >= 0 THEN
"GGS" .trace_put_line ('DDL', 'Object [' || ora_dict_obj_owner |
| '.' ||
ora_dict_obj_name || '] is ignored because object name is Oracle-reserved system name');
END IF;
toIgnore := 'YES';
END IF;
IF upper(substr (ora_dict_obj_name, 1, 5)) = 'MLOG$' OR upper(substr (ora_dict_obj_name, 1, 5)) = 'RUPD$'
THEN
IF "GGS" .DDLReplication.trace_level >= 0 THEN
"GGS" .trace_put_line ('DDL', 'Ignoring MLOG$ Object [' || ora_dict_obj_owner || '.' ||
ora_dict_obj_name || ' as it is temporary');
END IF;
toIgnore := 'YES';
END IF;
IF upper(substr (ora_dict_obj_name, 1, 6)) = 'OGGQT$' OR upper(substr (ora_dict_obj_name, 1, 3)) = 'AQ$'
THEN
IF "GGS" .DDLReplication.trace_level >= 0 THEN
"GGS" .trace_put_line ('DDL', 'Ignoring Queue related Object [' || ora_dict_obj_owner || '.' ||
ora_dict_obj_name || ' as it is for internal use');
END IF;
toIgnore := 'YES';
END IF;
IF (upper(ora_dict_obj_name) = upper ('GGS_MARKER') OR
upper(ora_dict_obj_name) = upper ('GGS_MARKER_SEQ') OR
upper(ora_dict_obj_name) = upper ('GGS_DDL_TRIGGER_BEFORE') OR
upper(ora_dict_obj_name) = upper ('GGS_DDL_SEQ') OR
upper(ora_dict_obj_name) = upper ('GGS_DDL_HIST') OR
upper(ora_dict_obj_name) = upper ('GGS_DDL_HIST_ALT') OR
upper(ora_dict_obj_name) = upper ('GGS_
SETUP')) AND
upper(ora_dict_obj_owner) = upper ('GGS') AND
(upper(ora_sysevent) = upper ('DROP') OR
upper(ora_sysevent) = upper ('RENAME'))
THEN
disallowDDL := 1;
raise_application_error (-20782,
'Cannot DROP object used in Oracle GoldenGate replication while trigger is enabled. ' ||
'Consult Oracle GoldenGate documentation and/or call Oracle GoldenGate Technical Support if you wish to do so.');
END IF;
-- check if this is domain index DDL (related to it)
IF ( ora_dict_obj_type = 'TABLE' OR ora_dict_obj_type = 'INDEX') AND
(
(substr(ora_dict_obj_name, 1, 3) = 'DR$' AND
(
substr (ora_dict_obj_name, length (ora_dict_obj_name) - 1, 2) = '$I' OR
substr (ora_dict_obj_name, length (ora_dict_obj_name) - 1, 2) = '$K' OR
substr (ora_dict_obj_name, length (ora_dict_obj_name) - 1, 2) = '$N' OR
substr (ora_dict_obj_name, length (ora_dict_obj_name) - 1, 2) = '$R' OR
substr (ora_dict_obj_name, length (ora_dict_obj_name) - 1, 2) = '$X'
)
)
OR
(
-- ignore objects that start with SYS_C, much like we ignore DR$, BIN$ etc.
substr (ora_dict_obj_name, 1, 5) = 'SYS_C'
)
)
THEN
toIgnore := 'YES';
IF "GGS" .DDLReplication.trace_level >= 0 THE
N
"GGS" .trace_put_line ('DDLTRACE1', 'Object is secondary for INDEX DOMAIN creation, ignored, objtype [' || ora_dict_obj_type ||
'] name [' || ora_dict_obj_owner || '.' || ora_dict_obj_name || '], error [' || to_char( SQLCODE) || ']');
END IF;
END IF;
-- check for and ignore Spatial temporary tables used during Spatial index creation.
-- Table will look something like M2_12AB$$
IF length (ora_dict_obj_name) > 5 AND
substr (ora_dict_obj_name, length (ora_dict_obj_name) - 1, 2) = '$$' AND
instr (ora_dict_obj_name, '_') > 0 AND
substr (ora_dict_obj_name, 1, 1) = 'M'
THEN
toIgnore := 'YES';
IF "GGS" .DDLReplication.trace_level >= 0 THEN
"GGS" .trace_put_line ('DDLTRACE1',
'Ignoring temporary Spatial table used during Spatial index creation [' ||
ora_dict_obj_type || '] name [' || ora_dict_obj_owner || '.' ||
ora_dict_obj_name || '], error [' || to_char( SQLCODE) || ']');
END IF;
END IF;
IF ora_dict_obj_type = 'TABLE' AND
substr(ora_dict_obj_name, 1, 12) = 'SYS_JOURNAL_'
THEN
BEGIN
journalId := to_number (substr(ora_dict_obj_name, 13));
SELECT owner, object_type
INTO
journalIndexOwner, journalType
FROM sys.dba_objects
WHERE object_id = journalId;
IF journalIndexOwner = ora
_dict_obj_owner AND journalType = 'INDEX' THEN
-- if SYS_JOURNAL_xxxxx has xxxxx to be existing object of type INDEX, this is online rebuild index, which we ignore
toIgnore := 'YES';
END IF;
IF "GGS" .DDLReplication.trace_level >= 0 THEN
"GGS" .trace_put_line ('DDLTRACE1', 'Object is secondary for INDEX DOMAIN creation, ignored, objtype [' || ora_dict_obj_type ||
'] name [' || ora_dict_obj_owner || '.' || ora_dict_obj_name || '], error [' || to_char( SQLCODE) || ']');
END IF;
EXCEPTION
WHEN OTHERS THEN
NULL; -- never mind, this isn't oracle journal table for rebuilding online index
END;
END IF;
-- Ignore Oracle 9i internal 'create/drop summary' when the user creates or drops of meteriazied view that has a SUM column.
IF ora_dict_obj_type = 'SUMMARY'
THEN
toIgnore := 'YES';
IF "GGS" .DDLReplication.trace_level >= 0 THEN
"GGS" .trace_put_line ('DDLTRACE1', 'Object is Oracle internal create summary for materialized views, ignored, objtype [' || ora_dict_obj_type ||
'] name [' || ora_dict_obj_owner || '.' || ora_dict_obj_name || '], error [' || to_char( SQLCODE) || ']');
END IF;
END IF;
IF "GGS" .DDLReplication.trace_level >= 0 THEN
"GGS" .trace_put_line ('DDLTRACE1', 'Before Trigger: point in execution
= [1.0], objtype [' || ora_dict_obj_type ||
'] name [' || ora_dict_obj_owner || '.' || ora_dict_obj_name || ']');
END IF;
IF "GGS" .DDLReplication.trace_level >= 1 THEN
"GGS" .trace_put_line ('DDLTRACE1', 'Before Trigger: point in execution = [1], original operation = [' ||
stmt || '], DDL seqno = [' || to_char ("GGS" .DDLReplication.currentDDLSeq) || ']' );
END IF;
IF stmt = '' OR stmt IS NULL THEN
-- oracle sometimes creates a follow-up DDL without statement and session user
-- this statement is related to previous one and is not a user statement, so is ignored
"GGS" .trace_put_line ('DDLTRACE1', 'DDL appears empty, ignoring');
IF "GGS" .DDLReplication.sql_trace = 1 THEN
dbms_session.set_sql_trace(false);
END IF;
"GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1);
RETURN;
END IF;
"GGS" .DDLReplication.getVersion();
IF "GGS" .DDLReplication.trace_level >= 1 THEN
"GGS" .trace_put_line ('DDLTRACE1', 'Before Trigger: proceeding with processing');
END IF;
-- get user id and object id as of this DDL
-- we're looking at TABLE and SEQUENCE (or related! such as CREATE UNIQUE INDEX) for object versioning
-- otherwise there is none
-- object id is always that of TABLE or SEQUENCE
-- get user id of object owne
r
BEGIN
IF "GGS" .DDLReplication.ddlObjUserId = -1 THEN
SELECT user# INTO currUserId FROM sys.user$ WHERE name = ora_dict_obj_owner;
ELSE
currUserId := "GGS" .DDLReplication.ddlObjUserId ;
END IF;
EXCEPTION
WHEN NO_DATA_FOUND THEN
currUserId := - 1;
WHEN OTHERS THEN
currUserId := - 1;
END;
"GGS" .DDLReplication.currentMasterOwner := '';
"GGS" .DDLReplication.currentMasterName := '';
"GGS" .DDLReplication.currentRowid := '';
real_ora_dict_obj_name := ora_dict_obj_name;
real_ora_dict_obj_owner := ora_dict_obj_owner;
real_ora_dict_obj_type := ora_dict_obj_type;
-- Oracle puts 0 sometimes in these particular predefined variables, at the end, so REPLACE first
-- the extract history record query crashes as DDL data seems incomplete
real_ora_dict_obj_name := REPLACE (real_ora_dict_obj_name, chr(0), ' ');
real_ora_dict_obj_name := rtrim (real_ora_dict_obj_name, ' ');
real_ora_dict_obj_owner := REPLACE (real_ora_dict_obj_owner, chr(0), ' ');
real_ora_dict_obj_owner := rtrim (real_ora_dict_obj_owner, ' ');
real_ora_dict_obj_type := REPLACE (real_ora_dict_obj_type, chr(0), ' ');
real_ora_dict_obj_type := rtrim (real_ora_dict_obj_type, ' ');
/*
the purpose of following code is to obtain this information:
object id of table or sequence affected
if object i
s not a table, then we need to get the name and owner
of table affected (base table), this is currentMasterOwner/currentMasterName
If operation is CREATE, then no metadata is known here (b/c it's before trigger).
*/
-- MATERIALIZE VIEW: we're interested in table part of it!
-- note: this must happen before checking for TABLE!
IF real_ora_dict_obj_type = 'MATERIALIZED VIEW' OR
real_ora_dict_obj_type = 'SNAPSHOT' THEN
real_ora_dict_obj_type := 'TABLE';
END IF;
IF ora_sysevent <> 'CREATE' or ora_dict_obj_type <> 'TABLE'
THEN
"GGS" .DDLReplication.getDDLObjInfo(ora_dict_obj_type, ora_sysevent,
ora_dict_obj_owner, ora_dict_obj_name );
END IF;
-- Try to find base object name/owner
-- If this is CREATE, there is no need to do it, since it doesn't exist yet
-- In case of CREATE, extract will perform resolution of base object owner
-- first try easier case when it's not CREATE
IF NOT ora_sysevent = 'CREATE' THEN
IF real_ora_dict_obj_type = 'INDEX' THEN
BEGIN
SELECT i.bo#, u.name, o.name , o.owner#
INTO "GGS" .DDLReplication.ddlBaseObjNum,
"GGS" .DDLReplication.currentMasterOwner,
"GGS" .DDLReplication.currentMasterName,
"GGS" .DDLReplication.ddlBaseObjUserId
FROM sys.ind$ i,
sys.obj$ o, sys.user$ u
WHERE i.obj# = "GGS" .DDLReplication.ddlObjNum and
o.obj# = i.bo# and u.user# = o.owner#;
select o.type# into otype FROM sys.obj$ o
where o.obj# = "GGS" .DDLReplication.ddlBaseObjNum;
"GGS" .DDLReplication.getObjTypeName(otype, otype);
real_ora_dict_obj_owner := "GGS" .DDLReplication.currentMasterOwner;
real_ora_dict_obj_name := "GGS" .DDLReplication.currentMasterName;
IF "GGS" .DDLReplication.trace_level >= 1 THEN
"GGS" .trace_put_line ('DDLTRACE1', 'Non-CREATE INDEX, master object [' || real_ora_dict_obj_owner ||
'.' || real_ora_dict_obj_name || ']');
END IF;
"GGS" .DDLReplication.currentObjectId :=
"GGS" .DDLReplication.ddlBaseObjNum;
IF "GGS" .DDLReplication.trace_level >= 1 THEN
"GGS" .trace_put_line ('DDLTRACE1', 'Non-CREATE INDEX, parent object id: ' || "GGS" .DDLReplication.currentObjectId);
END IF;
EXCEPTION
WHEN NO_DATA_FOUND THEN
"GGS" .DDLReplication.currentMasterOwner := '';
"GGS" .DDLReplication.currentMasterName := '';
WHEN OTHERS THEN
"GGS&q
uot; .DDLReplication.currentMasterOwner := '';
"GGS" .DDLReplication.currentMasterName := '';
END;
END IF;
IF real_ora_dict_obj_type = 'TRIGGER' THEN
BEGIN
SELECT tr.baseobject, u.name, o.name
INTO "GGS" .DDLReplication.ddlBaseObjNum,
"GGS" .DDLReplication.currentMasterOwner,
"GGS" .DDLReplication.currentMasterName
FROM sys.trigger$ tr, sys.obj$ o, sys.user$ u
WHERE tr.obj# = "GGS" .DDLReplication.ddlObjNum and
o.obj# = tr.baseobject and u.user# = o.owner#;
-- do not set real_ora names b/c trigger changes don't affect GG object resolution
EXCEPTION
WHEN NO_DATA_FOUND THEN
"GGS" .DDLReplication.currentMasterOwner := '';
"GGS" .DDLReplication.currentMasterName := '';
WHEN OTHERS THEN
"GGS" .DDLReplication.currentMasterOwner := '';
"GGS" .DDLReplication.currentMasterName := '';
END;
END IF;
END IF;
IF real_ora_dict_obj_type = 'SEQUENCE' THEN
BEGIN
-- get sequence CACHE/INCREMENTBY information as well as objectid
-- which will be used in conjuction with ROWID to resolve sequence
seqIncrement
By := 0;
seqCache := 0;
SELECT o.obj#, s.increment$, s.cache
INTO "GGS" .DDLReplication.currentObjectId, seqIncrementBy, seqCache
FROM sys.obj$ o, sys.seq$ s
WHERE o.obj# = "GGS" .DDLReplication.ddlObjNum AND
s.obj# = o.obj#;
EXCEPTION
WHEN NO_DATA_FOUND THEN
"GGS" .DDLReplication.currentObjectId := NULL;
WHEN OTHERS THEN
"GGS" .DDLReplication.currentObjectId := NULL;
END;
-- now find rowid of this sequence
-- in SYS.SEQ$ table (which is what we get from redo log)
BEGIN
SELECT ROWID
INTO "GGS" .DDLReplication.currentRowid
FROM sys.seq$ s
WHERE s.obj# = "GGS" .DDLReplication.currentObjectId;
EXCEPTION
WHEN NO_DATA_FOUND THEN
"GGS" .DDLReplication.currentRowid := '';
WHEN OTHERS THEN
"GGS" .DDLReplication.currentRowid := '';
END;
END IF;
IF real_ora_dict_obj_type = 'TABLE' THEN
BEGIN
SELECT o.obj# INTO "GGS" .DDLReplication.currentObjectId
FROM sys.obj$ o, sys.tab$ t
WHERE ((o.obj# = "GGS" .DDLReplication.ddlObjNum
AND o.obj# = t.obj#) AND bitand(t.property, 1) IN (0, 1)); -- account for object table (value 1 f
or t.property bitand)
EXCEPTION
WHEN NO_DATA_FOUND THEN
"GGS" .DDLReplication.currentObjectId := NULL;
WHEN OTHERS THEN
"GGS" .DDLReplication.currentObjectId := NULL;
END;
END IF;
-- CREATE INDEX is special b/c we don't know it's object id, but we have to figure out table's object id!!!
IF real_ora_dict_obj_type = 'INDEX' AND ora_sysevent = 'CREATE' THEN
-- we need base object id when indexed, it affects tables with no keys (ddlrep_2)
BEGIN
IF "GGS" .DDLReplication.ddlBaseObjNum <> -1 THEN
"GGS" .DDLReplication.currentObjectId :=
"GGS" .DDLReplication.ddlBaseObjNum;
SELECT o.name, u.name into real_ora_dict_obj_name,
real_ora_dict_obj_owner
from sys.obj$ o , sys.user$ u where
o.obj# = "GGS" .DDLReplication.ddlBaseObjNum and
u.user# = o.owner# ;
ELSE
"GGS" .DDLReplication.getTableFromIndex (
stmt,
ora_dict_obj_owner,
ora_dict_obj_name,
real_ora_dict_obj_owner,
real_ora_dict_obj_name,
otype);
IF "GGS" .DDLReplication.trace_level >= 1 THEN
"GGS" .trace_put_line ('DDLTRACE1', 'CREATE INDEX, parent: [' || otype || '] [' ||
real_ora_dict_obj_owner || '.' || real_ora_dict_obj_name || ']');
END IF;
SELECT o.object_id
INTO "GGS" .DDLReplication.currentObjectId
FROM dba_objects o
WHERE o.object_type = otype
AND o.object_name = real_ora_dict_obj_name AND
o.owner = real_ora_dict_obj_owner;
"GGS" .DDLReplication.ddlBaseObjNum :=
"GGS" .DDLReplication.currentObjectId ;
END IF;
IF "GGS" .DDLReplication.trace_level >= 1 THEN
"GGS" .trace_put_line ('DDLTRACE1', 'CREATE INDEX, parent object id: ' || "GGS" .DDLReplication.currentObjectId);
END IF;
"GGS" .DDLReplication.currentMasterName := real_ora_dict_obj_name;
"GGS" .DDLReplication.currentMasterOwner := real_ora_dict_obj_owner;
EXCEPTION
WHEN NO_DATA_FOUND THEN
"GGS" .DDLReplication.currentObjectId := NULL;
WHEN OTHERS THEN
"GGS" .DDL
Replication.currentObjectId := NULL;
END;
END IF;
IF real_ora_dict_obj_type = 'INDEX' AND ora_sysevent = 'DROP' THEN
BEGIN
SELECT bitand(i.property, 1)
INTO indexUnique
FROM sys.ind$ i
WHERE i.obj# = "GGS" .DDLReplication.ddlObjNum;
IF indexUnique = 1 THEN
indexUnique := 'UNIQUE';
ELSE
indexUnique := 'NONUNIQUE';
END IF;
EXCEPTION
WHEN NO_DATA_FOUND THEN
indexUnique := 'NONUNIQUE';
WHEN OTHERS THEN
indexUnique := 'NONUNIQUE';
END;
ELSE
indexUnique := 'NONUNIQUE';
END IF;
-- for all synonyms, except for CREATE (where not available)
-- get table owner/name so it can be used in extract
IF real_ora_dict_obj_type = 'SYNONYM' AND ora_sysevent <> 'CREATE' THEN
BEGIN
SELECT s.owner, s.name
INTO
"GGS" .DDLReplication.currentMasterOwner,
"GGS" .DDLReplication.currentMasterName
FROM sys.syn$ s
WHERE
s.obj# = "GGS" .DDLReplication.ddlObjNum;
EXCEPTION
WHEN NO_DATA_FOUND THEN
IF "GGS" .DDLReplication.trace_level >= 1 THEN
"GGS" .trace_put_line ('DDLTRACE1', 'Could not find table for public synonym: ' || real_ora_dict_obj_name);
END IF;
-- do nothing, PUBLIC/synName is used
END;
END IF;
/*
At this point we have object id of table/sequence as well as base object owner/name
(if object is not table)
*/
IF "GGS" .DDLReplication.trace_level >= 1 THEN
"GGS" .trace_put_line ('DDLTRACE1', 'Before Trigger: point in execution = [2]' );
END IF;
-- check if object is valid.
-- For example, when compiling triggers, procedures, packages, object may not compile
-- in this case DDL is still considered successful and this DDL trigger will not rollback
-- however status of object will be INVALID
BEGIN
SELECT d.status, d.generated, d.temporary, d.secondary, d.object_type, decode(bitand(t.property, 8192), 8192, 'YES', 'NO')
INTO objstatus, objectGenerated, objectTemporary, objectSecondary, objectType, isTypeTable
FROM dba_objects d, sys.tab$ t
WHERE d.object_id = "GGS" .DDLReplication.currentObjectId and t.obj# = "GGS" .DDLReplication.currentObjectId;
IF (objstatus <> 'VALID') THEN
IF "GGS" .DDLReplication.trace_level >= 0 THEN
"GGS" .trace_put_line ('DDL', 'DDL operation yielded invalid status, extract will decide if ignored. DDL operation [' ||
stmt || '], object [' || real_ora_dict_obj_owner || '.' || real_ora_dict_obj_name || '], sta
tus [' ||
objstatus || ']');
END IF;
END IF;
IF "GGS" .DDLReplication.trace_level >= 1 THEN
"GGS" .trace_put_line ('DDLTRACE1', 'Object atts/type: [gen=' || objectGenerated ||
', temp=' || objectTemporary || ', sec=' || objectSecondary || ', type=[' || objectType || ']');
END IF;
IF (objectGenerated = 'Y' AND objectType <> 'TABLE PARTITION')
OR objectTemporary = 'Y' OR objectSecondary = 'Y' OR isTypeTable = 'YES' THEN
toIgnore := 'YES';
END IF;
EXCEPTION
WHEN OTHERS THEN -- do nothing because for new tables there is no entry
NULL;
END;
-- ignore secondary sequence objects
BEGIN
IF ora_dict_obj_type = 'SEQUENCE' THEN
SELECT d.generated, d.temporary, d.secondary
INTO objectGenerated, objectTemporary, objectSecondary
FROM dba_objects d
WHERE d.object_id = "GGS" .DDLReplication.currentObjectId;
IF "GGS" .DDLReplication.trace_level >= 1 THEN
"GGS" .trace_put_line ('DDLTRACE1', 'Sequence Object atts/type: [gen=' || objectGenerated ||
', temp=' || objectTemporary || ', sec=' || objectSecondary || ']');
END IF;
IF objectGenerated = 'Y' OR objectTemporary = 'Y' OR objectSecondary = 'Y' THEN
toIgnore := 'YES';
END IF;
END I
F;
EXCEPTION
WHEN OTHERS THEN -- do nothing because for new tables there is no entry
IF instr ("GGS" .DDLReplication.raisable_errors, to_char (SQLCODE, 'S00000')) > 0 THEN
RAISE;
END IF;
NULL;
END;
IF "GGS" .DDLReplication.trace_level >= 0 THEN
"GGS" .trace_put_line ('DDL',
'DDL operation [' || stmt || '], sequence [' || "GGS" .DDLReplication.currentDDLSeq || '], '
|| 'DDL type [' || ora_sysevent || '] ' || ora_dict_obj_type || ', real object type [' || real_ora_dict_obj_type ||
'], validity [' || objstatus || '], object ID [' || "GGS" .DDLReplication.currentObjectId
|| '], object [' || ora_dict_obj_owner || '.' || ora_dict_obj_name || '], '
|| ' real object [' || real_ora_dict_obj_owner || '.' || real_ora_dict_obj_name || '], '
|| ' base object schema [' || "GGS" .DDLReplication.currentMasterOwner || '], '
|| ' base object name [' || "GGS" .DDLReplication.currentMasterName || '], '
|| ' logged as [' || ora_login_user || ']');
END IF;
BEGIN
SELECT o.dataobj#
INTO "GGS" .DDLReplication.currentDataObjectId
FROM sys.obj$
o
WHERE o.obj# = "GGS" .DDLReplication.currentObjectId;
EXCEPTION
WHEN NO_DATA_FOUND THEN
"GGS" .DDLReplication.currentDataObjectId := 0;
WHEN OTHERS THEN
"GGS" .DDLReplication.currentDataObjectId := 0;
END;
IF ora_dict_obj_type = 'TABLE' and ora_sysevent <> 'CREATE'
THEN
"GGS".DDLReplication.ddlBaseObjNum :=
"GGS".DDLReplication.ddlObjNum;
END IF;
--dbms_output.put_line(ora_dict_obj_type);
"GGS".DDLReplication.getObjType(ora_dict_obj_type, ntype);
--dbms_output.put_line(ntype);
IF "GGS".DDLAux.SKIP_OBJECT(
null, "GGS".DDLReplication.ddlBaseObjNum ,
ora_dict_obj_name, ora_dict_obj_owner ,
ntype,
"GGS" .DDLReplication.currentMasterName ,
"GGS" .DDLReplication.currentMasterOwner ,
ora_sysevent)
THEN
"GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1);
RETURN;
END IF;
-- these are stored in columns of DDL history table
-- they are oracle's original just like for marker table
-- 'real' ones are used to actually derive metadata *only*
"GGS" .DDLReplication.currentObjectName := ora_dict_obj_name;
"GGS" .DDLReplication.currentDDLType := ora_sysevent;
"GGS" .
DDLReplication.currentObjectOwner := ora_dict_obj_owner;
"GGS" .DDLReplication.currentObjectType := ora_dict_obj_type;
IF "GGS" .DDLReplication.trace_level >= 1 THEN
"GGS" .trace_put_line ('DDLTRACE1', 'Before Trigger: point in execution = [3]' );
END IF;
IF real_ora_dict_obj_type = 'INDEX' AND ora_sysevent = 'CREATE' and otype = 'TABLE' THEN
"GGS" .trace_put_line ('DDLTRACE1', 'checking create index for parent type:' || otype ||
' owner:' || real_ora_dict_obj_owner || ' name:' || real_ora_dict_obj_name ||
' object id:' || to_char("GGS" .DDLReplication.currentObjectId));
BEGIN
-- test that base table object exists.
SELECT t.obj#
INTO "GGS" .DDLReplication.currentObjectId
FROM sys.tab$ t
WHERE t.obj# = "GGS" .DDLReplication.currentObjectId;
EXCEPTION
WHEN NO_DATA_FOUND THEN BEGIN
toIgnore := 'YES';
IF "GGS" .DDLReplication.trace_level >= 1 THEN
"GGS" .trace_put_line ('DDLTRACE1', 'Base table does not exists');
END IF;
END;
END;
END IF;
/*
insert DDL descriptor string to marker table
DDL STATEMENT and related info
construct DDL operation descriptor string
marker record contains original object name, whereas DDL record contains 'real' (adjusted for INDEX->TABLE)
*/
"GGS" .DDLReplication.saveM
arkerDDL (
to_char ("GGS" .DDLReplication.currentObjectId),
ora_dict_obj_owner,
ora_dict_obj_name,
ora_dict_obj_type,
ora_sysevent,
to_char ("GGS" .DDLReplication.currentDDLSeq),
'GGS' || '.' || 'GGS_DDL_HIST',
ora_login_user,
objstatus,
indexUnique,
"GGS" .DDLReplication.currentMasterOwner,
"GGS" .DDLReplication.currentMasterName,
stmt,
toIgnore);
/*
Get Start SCN
IMPORTANT: start SCN can be obtained *only* after marker record has been
written - this is Oracle limitation because transaction had no data so far
(even though this is DDL transaction by itself, however in BEFORE trigger
there is no start SCN until it's done because transaction hasn't officially
started yet!!)
*/
-- get current module info
dbms_application_info.read_module(oldModuleNa
meInfo, oldActionInfo);
-- 'stamp' current session with unique ddl sequence number
-- this works even when we have multiple DDLs happenning in several background processes (all with session id of 0)
moduleNameInfo := 'GGS_DDL_MODULE_' || to_char ("GGS" .DDLReplication.currentDDLSeq);
dbms_application_info.set_module(moduleNameInfo, null);
-- we let potential error here be handled by extract as it should never happen that we can't find SCN
SELECT t.start_scnb, t.start_scnw
INTO "GGS" .DDLReplication.SCNB, "GGS" .DDLReplication.SCNW
FROM v$transaction t, v$session s
WHERE
t.addr = s.taddr AND t.ses_addr = s.saddr AND s.audsid = USERENV('SESSIONID')
AND s.module = moduleNameInfo;
IF "GGS" .DDLReplication.trace_level >= 0 THEN
"GGS" .trace_put_line ('DDL',
'Start SCN found [' || to_char("GGS" .DDLReplication.SCNB + "GGS" .DDLReplication.SCNW * power (2, 32)) || ']');
END IF;
-- restore module info
dbms_application_info.set_module(oldModuleNameInfo, oldActionInfo);
-- do not calculate/record any metadata for objects other than table, index or trigger
-- because these are the objects we need to resolve base owner/name for
-- also do not calculate metadata for TRUNCATE TABLE
-- because customer may have hundreds of those - they don't change table structure!!!
IF (NOT real_ora_di
ct_obj_type = 'TABLE' AND
NOT real_ora_dict_obj_type = 'INDEX' AND
NOT real_ora_dict_obj_type = 'TRIGGER' AND
NOT real_ora_dict_obj_type = 'SEQUENCE') OR
(real_ora_dict_obj_type = 'TABLE' AND ora_sysevent = 'TRUNCATE')
OR "GGS" .DDLReplication.stay_metadata = 1 -- do not query db for metadata if STAYMETADATA is ON
THEN
IF "GGS" .DDLReplication.trace_level >= 0 THEN
"GGS" .trace_put_line ('DDL', '------------------------- End of log for DDL sequence [' ||
to_char ("GGS" .DDLReplication.currentDDLSeq) || '], no DDL history metadata recorded for this DDL operation');
END IF;
IF "GGS" .DDLReplication.sql_trace = 1 THEN
dbms_session.set_sql_trace(false);
END IF;
"GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1);
RETURN;
END IF;
IF "GGS" .DDLReplication.trace_level >= 1 THEN
"GGS" .trace_put_line ('DDL', 'Object ID is [' || to_char ("GGS" .DDLReplication.currentObjectId) ||
']');
"GGS" .trace_put_line ('DDLTRACE1', 'Before Trigger: point in execution = [4]' );
END IF;
-- For any CREATE DDL, do the same, because there can't be
-- any DML for an object prior to it being created. This also
-- eliminates the problem of objects that don't exis
t in the context
-- of ddl trigger, since this is before ddl trigger. Any CREATE DDL
-- suffers from that issue. This way that problem is eliminated.
-- For CREATE INDEX DDLs take history as the key sey may change as
-- a result of the DDL (bug 14032266).
IF (ora_sysevent <> 'CREATE' OR
(toIgnore = 'NO' AND real_ora_dict_obj_type = 'INDEX' AND otype = 'TABLE')) THEN
"GGS" .DDLReplication.beginHistory ();
IF real_ora_dict_obj_type = 'SEQUENCE' THEN
/*
For sequences, we need sequence object id, name and rowid for the most part in order to map rowid to objectid/name
As sequences don't have properties as tables, this is where we must stop gathering metadata as well
*/
IF "GGS" .DDLReplication.trace_level >= 1 THEN
"GGS" .trace_put_line ('DDLTRACE1', 'Before Trigger: point in execution = [4-seq], sequence cache [' ||
to_char (seqCache) || '], sequence incrementby [' || to_char (seqIncrementBy) || ']' );
END IF;
"GGS" .DDLReplication.saveSeqInfo (
real_ora_dict_obj_owner, real_ora_dict_obj_name,
ora_sysevent, to_char(currUserId),
seqCache, seqIncrementBy, toIgnore );
ELSE
/*
BEGIN HISTORY table inserts
begin inserting metadata to histo
ry
*/
-- metadata producing calls
-- IMPORTANT: here we use real_ora_ values b/c resolution depends on it, also object id is correlated
IF "GGS" .DDLReplication.trace_level >= 2 THEN
"GGS" .trace_put_line ('DDLTRACE2', 'Goint to call getTableInfo() ' || stmt);
END IF;
"GGS" .DDLReplication.getTableInfo (
"GGS" .DDLReplication.ddlBaseObjNum,
real_ora_dict_obj_name,
real_ora_dict_obj_owner,
real_ora_dict_obj_type,
ora_sysevent, to_char(currUserId),
"GGS" .DDLReplication.currentMasterOwner,
"GGS" .DDLReplication.currentMasterName,
substr (stmt, 1, 4000 - 10),
toIgnore );
"GGS" .DDLReplication.getColDefs (
"GGS".DDLReplication.ddlBaseObjNum,
real_ora_dict_obj_owner,
real_ora_dict_obj_name);
IF "GGS" .DDLReplication.useAllKeys = 1 THEN
"GGS" .DDLReplication.getKeyColsUseAllKeys (
"GGS" .DDLReplication.ddlBaseObjNum,
real_ora_dict_obj_owner,
real_ora_dict_obj_name);
ELSE
"GGS" .DDLReplication.getKeyCols (
"GGS" .DDLReplication.ddlBaseObjNum,
real_ora_dict_obj_owner,
real_ora_dict_obj_name);
END IF;
IF "GGS" .DDLReplication.trace_level >= 1 THEN
"GGS" .trace_put_line ('DDLTRACE1', 'Before Trigger: point in execution = [5]' );
END IF;
-- end inserting metadata to history
/*
END HISTORY table inserts
*/
END IF;
/* make sure endHistory record is placed for sequences too */
"GGS" .DDLReplication.endHistory ();
END IF;
BEGIN
IF 'FALSE' = 'TRUE' OR 'FALSE' = 'TRUE' THEN
"GGS" .trace_put_line ('DDLTRACE1', 'Trigger: Raising simulated 1013 error');
RAISE userCancelSimulate;
END IF;
EXCEPTION
WHEN OTHERS THEN
IF 'FALSE' = 'TRUE' THEN
"GGS" .trace_put_line ('DDLTRACE1', 'Trigger: Raising simulated nested 1013 error');
RAISE userCancelNestedSimulate;
ELSE
RAISE;
END IF;
END;
-- this is always after last executable statement
IF "GGS" .DDLReplication.trace_level >= 1 THEN
"GGS" .trace_put_line ('DDLTRACE1', 'Before Trigger: point in execution = [the end]' );
END IF;
-- EXCEPTION
S
-- handle exceptions (if so specified)
IF "GGS" .DDLReplication.trace_level >= 0 THEN
"GGS" .trace_put_line ('DDL', '------------------------- End of log for DDL sequence [' ||
to_char ("GGS" .DDLReplication.currentDDLSeq) || ']');
END IF;
IF "GGS" .DDLReplication.sql_trace = 1 THEN
dbms_session.set_sql_trace(false);
END IF;
"GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1);
RETURN;
EXCEPTION
WHEN OTHERS THEN
"GGS" .trace_put_line ('DDL', 'Trigger sys.' || 'GGS_DDL_TRIGGER_BEFORE' || ' :Error processing DDL operation [' || stmt || '], error '
|| SQLERRM || ', error stack: ' || "GGS" .ddlora_getErrorStack);
-- this code will delete any previous garbage from marker data so if trigger commits, nothing is there
-- unless we put it down here somewhere (in big trigger exception) or in size handling above
-- this way extract doesn't abend from interrupted garbage
-- note that this really shouldn't happen (it does when simulated) because oracle actually rollsback transaction
IF "GGS" .DDLReplication.currentMarkerSeq IS NOT NULL THEN -- only if marker seqno set
BEGIN
"GGS" .trace_put_line ('DDL', 'Cleaning up marker sequence [' || "GGS" .DDLReplication.currentMarkerSeq || ']');
DELETE FROM "GGS" ."GGS_MARKER" WHERE seqNo = "GGS" .DDLReplication.currentMarkerSeq;
"GGS" .trace_put_line ('DDL', 'Cleaned up [' || SQL%ROWCOUNT || '] rows from marker table');
EXCEPTION
WHEN OTHERS THEN
NULL; -- this is a curtesy delete, ignore if any error
END;
END IF;
-- we also delete DDL seqno, so it's not accidentally selected in extract if trigger had problems
-- and thus incomplete data
BEGIN
"GGS" .trace_put_line ('DDL', 'Cleaning up DDL sequence [' || "GGS" .DDLReplication.currentDDLSeq || ']');
DELETE FROM "GGS" ."GGS_DDL_HIST" WHERE seqNo = "GGS" .DDLReplication.currentDDLSeq;
"GGS" .trace_put_line ('DDL', 'Cleaned up [' || SQL%ROWCOUNT || '] rows from DDL table');
EXCEPTION
WHEN OTHERS THEN
NULL; -- this is a curtesy delete, ignore if any error
END;
IF toIgnore = 'YES' THEN
-- if we're somehow here, and DDL is ignored anyway, don't error out
"GGS" .trace_put_line ('DDL', 'DDL is ignored, error is ignored too.');
IF "GGS" .DDLReplication.sql_trace = 1 THEN
dbms_session.set_sql_trace(false);
END IF;
"GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1);
RETURN;
END IF;
IF SQLCODE = -1013 OR
"GGS" .ddlora_errorIsUserCancel THEN
-- this is user cancellation error, just exit, never mind all this
-- what happens is that Oracle rollsback previous INSERTs but we would have
-- started new one here. We just want to ignore everything, hence RETURN
"GGS" .trace_put_line ('DDL', 'User cancelled operation');
IF 'FALSE' = 'TRUE' OR 'FALSE' = 'TRUE' THEN
"GGS" .trace_put_line ('DDLTRACE1', 'forced user cancel test stack ' ||
DBMS_UTILITY.format_error_stack);
END IF;
IF "GGS" .DDLReplication.sql_trace = 1 THEN
dbms_session.set_sql_trace(false);
END IF;
"GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1);
RETURN;
END IF;
IF disallowDDL = 1 THEN
IF "GGS" .DDLReplication.sql_trace = 1 THEN
dbms_session.set_sql_trace(false);
END IF;
raise_application_error (-20782,
"GGS" .DDLReplication.triggerErrorMessage || ':' || SQLERRM ||
', error stack: ' || "GGS" .ddlora_getErrorStack);
ELSE
/*
if there is trouble in trigger
try to make sure extract knows about it
include min necessary information for end-user to
examine trace log
*/
IF SQLCODE = -6508 THEN
-- this is improper installation, alert extract to it so user knows
outMessage := 'INSTALLPROBLEM: Oracle could not find properly installed DDL replication package (ORA-6508). Please ' ||
' install or upgrade DDL replication package for Oracle (PLSQL code) before proceeding. Please make sure all ' ||
'processes that use DDL are shutdown during trigger installation. The actual DDL here may or may not succeed.';
INSERT INTO "GGS" ."GGS_MARKER" (
seqNo,
fragmentNo,
optime,
TYPE,
SUBTYPE,
marker_text
)
VALUES (
-1,
0,
TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'),
'DDL',
'DDLINFO',
outMessage -- text of marker
);
ELSE
IF "GGS" .DDLReplication.currentMarkerSeq IS NULL THEN -- only if marker seqno not set
SELECT "GGS" ."GGS_MARKER_SEQ" .NEXTVAL INTO "GGS" .DDLReplication.currentMarkerSeq FROM dual;
END IF;
outMessage := 'ERROR: DDL sequence [' || to_char ("GGS" .DDLReplication.currentDDLSeq)
||
'], marker sequence [' || to_char ("GGS" .DDLReplication.currentMarkerSeq) ||
'], DDL trace log file [' || "GGS" .DDLReplication.dumpDir || "GGS" .file_separator || 'ggs_ddl_trace.log], error code ' ||
to_char(SQLCODE) || ' error message ' || SQLERRM || ', error stack: ' || "GGS" .ddlora_getErrorStack;
INSERT INTO "GGS" ."GGS_MARKER" (
seqNo,
fragmentNo,
optime,
TYPE,
SUBTYPE,
marker_text
)
VALUES (
"GGS" .DDLReplication.currentMarkerSeq,
0,
TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'),
'DDL',
'DDLINFO',
outMessage -- text of marker
);
END IF;
IF 'FALSE' = 'TRUE' THEN
IF "GGS" .DDLReplication.sql_trace = 1 THEN
dbms_session.set_sql_trace(false);
END IF;
raise_application_error (-20782,
"GGS" .DDLReplication.triggerErrorMessage || ':' || SQLERRM);
END IF;
END IF;
IF "GGS" .DDLReplication.sql_trace = 1 THEN
dbms_session.set_sql_trace(false);
END IF;
"GGS" .DDLReplication.setCtxInfo(-1, -1, -1, -1, -1);
END; |
9r4j75mjryt6a |
create global temporary table sys.ora_temp_1_ds_2468448 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"GC_TYPE_CODE", "ABSO_MODE", "USER_TYPE_CODE", "DIVISION_CODE", "RUN_CAP", "CONTRACT_CAP", "POWEROFF_CODE", "ARC_CALC_ID", "HANLE_REMARK", "REMIND_SECT_NO", "AMT_CALC_ID", "CALC_PERIOD", "CALC_ID", "APP_CODE", "YM", "CONS_ID", "ORG_NO", "VERI_RSLT", "VERI_REMARK", "CALC_DATE", "SEND_DATE", "CONS_NO", "CONS_NAME", "CONS_SORT_CODE", "ELEC_ADDR", "TRADE_TYPE_CODE", "ELEC_TYPE_CODE", "VOLT_CODE", "HEC_TRADE_CODE", "CREATE_DATE", "POWERON_DATE", "CANCEL_DATE", "STATUS_CODE", "BUSI_REGION_NO", "TRANSFER_FLAG", "MR_SECT_NO", "GP_CODE", "RENDER_STATUS", "CALC_TYPE", "CALC_TIMES", "PAY_MODE", "USE_MONTH", "DATA_SRC", "ORGN_CONS_NO", "APP_NO_REF", "SHIFT_NO" from "EPM_LN"."ARC_E_CONS_SNAP" sample ( 2.7430978173) t where 1 = 2
|
9tatc9qjgq2qu |
SELECT "A1"."INS_NAME", "A1"."INS_NAME", "A1"."APP_NO", "A1"."END_TIME", "A1"."END_TIME", "A1"."STATUS_CODE", "A1"."INS_NAME", "A1"."INS_NAME", "A2"."PS_ORG_NO", "A2"."APP_NO", "A2"."PS_ORG_NO", "A2"."CONS_NO", "A2"."CONS_NO", "A2"."CONS_NAME", "A2"."PS_ORG_NO", "A2"."ELEC_ADDR", "A2"."VOLT_CODE", "A2"."TRADE_CODE", "A2"."HEC_INDUSTRY_CODE", "A2"."ELEC_TYPE_CODE", "A2"."ELEC_TYPE_CODE", "A2"."APP_ID", "A2"."T_RUN_CAP", "A2"."ORGN_RUN_CAP", "A2"."T_CONTRACT_CAP", "A2"."ORGN_CONTRACT_CAP", "A2"."CONS_ID", "A2"."CUST_ID", "A2"."APP_NO", "A2"."PS_ORG_NO" FROM "P_PROC_INSTANCE" "A1", "ARC_S_APP" "A2" WHERE "A2"."PS_ORG_NO" LIKE :1 AND "A2"."APP_NO"="A1"."APP_NO" AND "A1"."END_TIME">=:2 AND "A1"."END_TIME"<:3 AND "A1"."INS_NAME"&l
t;>'103' AND "A1"."INS_NAME"<>'112' AND "A1"."INS_NAME"<>'217' AND "A1"."STATUS_CODE"='02' |
a6vvt01r5w66v | select systimestamp from dual |
axajjyf55qb9p | SELECT id, ip, name, lastupdate FROM sys_group_server where name=:1 |
aymch91s5gkqs | SELECT /*+ OPAQUE_TRANSFORM */ "METER_ID", "BELONG_DEPT", "SORT_CODE", "TYPE_CODE", "PR_CODE", "CUR_STATUS_CODE" FROM "EPM_LN"."D_METER" "D" WHERE "CUR_STATUS_CODE"='012' AND "BELONG_DEPT" LIKE :1 AND ("SORT_CODE"='10' OR ("TYPE_CODE"='26' OR "TYPE_CODE"='27' OR "TYPE_CODE"='28' OR "TYPE_CODE"='29')) AND "METER_ID"=:2 |
ayvx78m6p3fju |
SELECT *
FROM (SELECT LI.*,
CASE
WHEN LI.OVERDUED_NE = 1 OR LI.OVERDUED_NE = 3 THEN 1
WHEN LI.OVERDUED_NE = 0 OR LI.OVERDUED_NE = 2 THEN
CASE
WHEN E.SUSPEND_FLAG = 0 THEN
CASE
WHEN SYSTIMESTAMP >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
WHEN E.SUSPEND_FLAG = 1 THEN
CASE
WHEN E.SUSPEND_TIME >= E.TARGET_OVERDUE_MINTIME THEN 1
ELSE 0
END
ELSE 0
END
ELSE 0
END OVERDUED,
CASE
WHEN E.TARGET_OVERDUE_MINTIME IS NULL THEN LI.TARGET_TIME_NE
WHEN LI.TARGET_TIME_NE IS NULL THEN E.TARGET_OVERDUE_MINTIME
WHEN E.TARGET_OVERDUE_MINTIME <= LI.TARGET_TIME_NE THEN E.TARGET_OVERDUE_MINTIME
ELSE LI.TARGET_TIME_NE
END TARGET_TIME,
FTM.WORKFORM_TYPE_KIND
FROM (SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_
STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME AS WI_INSTANCE_NAME,
F.WORKFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = :1
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :2
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE F.PROCINST_ID = WF.PROC_INSTANCE_ID
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.
ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:3 LIKE (WF.DEPART_ID || '%')) OR (:4 = WF.DEPART_ID) OR (:5 = WF.DEPART_ID) OR (:6 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :7))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:8 LIKE (F.DEPT_ID || '%')) OR (:9 = F.DEPT_ID) OR (:10 = F.DEPT_ID) OR (:11 = F.DEPT_ID) OR (F.DEPT_ID LIKE :12))))))
UNION ALL
SELECT /*+INDEX(F IDX_WORKFORM_PROCINST_ID)*/
WF.PROC_INSTANCE_ID,
WF.ACTIVITY_INS_ID,
WF.WORKITEM_INS_ID,
WF.NAME,
WF.CURRENT_STATE,
WF.COMPLETE_TIME,
WF.CREATE_TIME,
WF.LIMIT_TIME,
WF.APP_URL,
WF.USER_NAME,
WF.USER_ID,
WF.USER_ENTITY_TYPE,
WF.USER_ENTITY_NAME,
WF.USER_ENTITY_ID,
WF.PARTICIPANT_TYPE,
WF.SEND_TYPE,
WF.OVERDUED AS OVERDUED_NE,
WF.EXT_PROP,
WF.FLOW_DIRECTION,
WF.BUSINESSKEY,
WF.DEPART_ID,
F.INSTANCE_ID AS WI_INSTANCE_ID,
F.INSTANCE_NAME AS WI_INSTANCE_NAME,
F.WORKFORM_TYPE AS WI_WORKFORM_TYPE,
F.BUILDER AS WI_BUILDER,
F.START_TIME AS WI_CREATE_TIME,
F.INSTANCE_STATUS AS WI_INSTANCE_STATUS,
F.BUSINESS AS WI_BUSINESS,
F.KEYDATA_ID AS WI_KEYDATA_ID,
F.IS_FLOW AS WI_IS_FLOW,
F.ATTR1 AS WI_ATTR1,
F.DEPT_ID AS WI_DEPT_ID,
'' AS WT_DEPT_ID,
WF.CURRENT_STATE AS WT_WORKTASK_STATUS,
NULL AS WT_TARGET_TIME,
'' AS WT_LINK_URL,
'' AS WT_LINK_PARAM,
'' AS WT_IS_BATCH,
U.REAL_NAME AS WI_BUILDER_REALNAME,
NULL AS HOWLONG_WILL_OVERDUE,
NULL AS HOWLONG_OVERDUED,
'' AS ACTIVITY_TMP_ID,
O.TIME_OUT_TIME AS TARGET_TIME_NE,
B.APPROVAL_STATUS AS BE_APPROVAL_STATUS,
ORG.ORG_NO,
ORG.ORG_NAME,
'' AS VIEW_FLAGS
FROM SA_WORKFORM_INST F,
(SELECT W.*
FROM RT_WORKITEMINST W
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = :13
AND W.PARTICIPANT_TYPE = 0
UNION ALL
SELECT W.*
FROM RT_WORKITEMINST W, SA_BROLE_USER R
WHERE (W.CURRENT_STATE = 1 OR W.CURRENT_STATE = 2 OR
W.CURRENT_STATE = 3)
AND W.USER_ID = R.ROLE_ID
AND R.USER_ID = :14
AND W.PARTICIPANT_TYPE = 1) WF,
SA_USER U,
RT_PROCESSINSTANCE P,
(SELECT * FROM RT_OVERTIME_DEAL WHERE TIMER_TYPE = 1) O,
SA_WF_BUSINESS_EXT B,
SA_DEPT D,
SA_ORG ORG
WHERE WF.PROC_INSTANCE_ID = P.PROC_INSTANCE_ID
AND P.PARENT_PROCINC_ID IS NOT NULL
AND F.PROCINST_ID = P.PARENT_PROCINC_ID
AND F.BUILDER = U.USER_ID(+)
AND U.DEPT_ID = D.DEPT_ID(+)
AND D.ORG_NO = ORG.ORG_NO(+)
AND WF.WORKITEM_INS_ID = O.INSTANCE_ID(+)
AND WF.WORKITEM_INS_ID = B.WORKITEM_ID(+)
AND (WF.PARTICIPANT_TYPE = 0 OR (WF.PARTICIPANT_TYPE = 1 AND ((WF.DEPART_ID IS NOT NULL AND ((:15 LIKE (WF.DEPART_ID || '%')) OR (:16 = WF.DEPART_ID) OR (:17 = WF.DEPART_ID) OR (:18 = WF.DEPART_ID) OR (WF.DEPART_ID LIKE :19))) OR ((WF.DEPART_ID IS NULL OR Wf.DEPART_ID = '') AND ((:20 LIKE (F.DEPT_ID || '%')) OR (:21 = F.DEPT_ID) OR (:22 = F.DEPT_ID) OR (:23 = F.DEPT_ID) OR (F.DEPT_ID LIKE :24))))))
AND NOT EXISTS
(SELECT 1
FROM SA_WORKFORM_INST RF
WHERE WF.PROC_INSTANCE_ID = RF.PROCINST_ID)) LI,
SA_WF_WORKFORM_TYPE_MAP FTM,
(SELECT ACT_INST_ID,
SUSPEND_FLAG,
MIN(TARGET_OVERDUE_MINTIME) AS TARGET_OVERDUE_MINTIME,
MIN(SUSPEND_TIME) AS SUSPEND_TIME
FROM (SELECT A.ACT_INST_ID, B.*
FROM SA_WF_EXAM_ACT_INST A, SA_WF_EXAM_INST B
WHERE A.SUBJECT_INST_ID = B.SUBJECT_INST_ID
AND A.PROC_INST_ID = B.PROC_INST_ID
AND B.COMPLETE_FLAG = 0)
GROUP BY ACT_INST_ID, SUSPEND_FLAG) E
WHERE LI.WI_WORKFORM_TYPE = FTM.WORKFORM_TYPE(+)
AND LI.ACTIVITY_INS_ID = E.ACT_INST_ID(+)) T
WHERE NOT EXISTS (SELECT 1
FROM SA_WF_WORKITEM_EXCLUDED_USER US
WHERE T.WORKITEM_INS_ID = US.WORKITEM_ID
AND US.USER_ID = :25) |
b4zcs3an3cnmn | SELECT "METER_ID", "INST_DATE", "ORG_NO" FROM "EPM_LN"."C_METER" "C" WHERE "ORG_NO" LIKE :1 AND "METER_ID"=:2 |
b6usrg82hwsa3 | call dbms_stats.gather_database_stats_job_proc ( ) |
b820g52hhvtfm | SELECT SUBSTR("A3"."PS_ORG_NO", 1, 5)||"A3"."APP_NO", SUBSTR("A3"."PS_ORG_NO", 1, 5)||"A2"."CONS_NO", :1, "A2"."CONS_NO", "A2"."CONS_NAME", "A3"."PS_ORG_NO", "A2"."ELEC_ADDR", "A3"."VOLT_CODE", "A2"."TRADE_CODE", NVL("A3"."HEC_INDUSTRY_CODE", '000'), "A2"."ELEC_TYPE_CODE", "A2"."ELEC_TYPE_CODE", "A2"."ID", "A2"."CONTRACT_CAP", "A1"."INS_NAME" FROM "ARC_S_APP" "A3", "ARC_S_BATCH_CUST_APP" "A2", "P_PROC_INSTANCE" "A1" WHERE "A3"."APP_ID"="A2"."APP_ID" AND "A3"."APP_NO"="A1"."APP_NO" AND "A1"."END_TIME">=:2 AND "A1"."END_TIME"<:3 AND "A1"."STATUS_CODE"='02' AND ("A1"."INS_NAME"='103' OR "A1"."INS_NAME"='112' OR "A1"."INS_NAME"='217') AND "A3"."PS_ORG_NO" LIKE :4 |
bg1zdrp116hrm |
INSERT INTO O_BUSI_ACT SELECT :B1 , NVL(A.ORG_NO, '000') AS ORG_NO, NVL(A.DEPT_NO, '000') AS DEPT_NO, NVL(A.PROC_NO, '000') AS PROC_NO, NVL(A.ACT_SORT_CODE, '000') AS ACT_SORT_CODE, NVL(A.HANDLE_EMP_NO, '000') AS HANDLE_EMP_NO, NVL(A.STATUS_CODE, '000') AS STATUS_CODE, SUM(A.HANDLE_CC) AS HANDLE_CC, SUM(A.WKST_NUM) AS WKST_NUM, SUM(A.UNCMPL_NUM) AS UNCMPL_NUM, SUM(A.OT_UNCMPL_NUM) AS OT_UNCMPL_NUM, SUM(A.CMPL_NUM) AS CMPL_NUM, SUM(A.ONTIME_CMPL_NUM) AS ONTIME_CMPL_NUM, SUM(A.OT_CMPL_NUM) AS OT_CMPL_NUM FROM (SELECT NVL(T.ORG_NO, '777') AS ORG_NO, NVL(T.DEPT_ID, '777') AS DEPT_NO, NVL(T.APP_TYPE_CODE, '777') AS PROC_NO, MAX(NAME_1) ACT_SORT_CODE, T.BUILDER HANDLE_EMP_NO, '???' AS STATUS_CODE, CASE WHEN COUNT(S.CONS_NO) = 0 THEN COUNT(DISTINCT(T.APP_NO)) ELSE COUNT(S.CONS_NO) + COUNT(DISTINCT(T.APP_NO)) - COUNT(DISTINCT(S.APP_NO)) END AS HANDLE_CC, COUNT(DISTINCT(T.APP_NO)) AS WKST_NUM, COUNT(DISTINCT(T.APP_NO)) AS UNCMPL_NUM, NVL(CASE WHEN T.OVERDUED = 1 THEN COUNT(DISTINCT(T.APP_NO)) END, 0) AS OT_UNCMPL_NUM, 0 AS CMPL_NUM, 0 AS ONTIME_CMPL_NUM, 0 AS OT_CMPL_NUM FROM (SELECT A.ORG_NO ORG_NO, A.APP_ID APP_ID, A.APP_NO APP_NO, A.APP_TYPE_CODE APP_TYPE_CODE, B.KEYDATA_ID KEYDATA_ID, CASE WHEN D.NAME IS NULL THEN '???????' ELSE D.NAME END AS NAME_1, B.BUILDER BUILDER, C.DEPT_ID DEPT_ID, C.REAL_NAME REAL_NAME, B.IS_FLOW IS_FLOW, B.PROCINST_ID PROCINST_ID, D.PROC_INSTANCE_ID PROC_INSTANCE_ID, E.OVERDUED OVERDUED FROM S_APP A, SA_WORKF
ORM_INST B, SA_USER C, RT_ACTINST D, RT_PROCESSINSTANCE E WHERE TO_CHAR(HANDLE_TIME, 'YYYYMMDD') = :B1 AND B.KEYDATA_ID = A.APP_NO AND B.BUILDER = C.USER_ID AND D.PROC_INSTANCE_ID = B.PROCINST_ID AND A.APP_TYPE_CODE IN ('101', '102', '103', '104', '105', '106', '107', '108', '109', '110', '111', '112', '201', '202', '203', '204', '205', '206', '207', '208', '209', '210', '211', '212', '213', '214', '215', '216', '217', '218', '301', '302', '303', '304', '305', '306', '307', '311', '351', '715', '716') AND D.CURRENT_STATE = '1' AND E.PROC_INSTANCE_ID(+) = B.PROCINST_ID AND E.PARENT_PROCINC_ID IS NULL) T, S_BATCH_CUST_APP S WHERE S.APP_ID(+) = T.APP_ID GROUP BY T.ORG_NO, T.DEPT_ID, T.APP_TYPE_CODE, T.BUILDER, T.OVERDUED UNION SELECT NVL(A.ORG_NO, '888') AS ORG_NO, NVL(A.DEPT_ID, '888') AS DEPT_NO, NVL(A.APP_TYPE_CODE, '888') AS PROC_NO, '?' AS ACT_SORT_CODE, A.BUILDER AS HANDLE_EMP_NO, '???' AS STATUS_CODE, 0 AS HANDLE_CC, 0 AS WKST_NUM, 0 AS UNCMPL_NUM, 0 AS OT_UNCMPL_NUM, SUM(CMPL_NUM) AS CMPL_NUM, SUM(ONTIME_CMPL_NUM1) + SUM(ONTIME_CMPL_NUM3) AS OT_CMPL_NUM, SUM(ONTIME_CMPL_NUM24) + SUM(ONTIME_CMPL_NUM2) + SUM(ONTIME_CMPL_NUM4) AS ONTIME_CMPL_NUM FROM (SELECT B.ORG_NO, E.DEPT_ID, B.APP_TYPE_CODE, A.BUILDER, 0, 0, 0, 0, COUNT(DISTINCT(B.APP_NO)) + COUNT(DISTINCT(C.APP_NO)) AS CMPL_NUM, NVL(CASE WHEN D.OVERDUED IS NULL THEN (COUNT(DISTINCT(B.APP_NO)) + COUNT(DISTINCT(C.APP_NO))) END, 0) AS ONTIME_CMPL_NU
M24, NVL(CASE WHEN D.OVERDUED = 2 THEN (COUNT(DISTINCT(B.APP_NO)) + COUNT(DISTINCT(C.APP_NO))) END, 0) AS ONTIME_CMPL_NUM2, NVL(CASE WHEN D.OVERDUED = 4 THEN (COUNT(DISTINCT(B.APP_NO)) + COUNT(DISTINCT(C.APP_NO))) END, 0) AS ONTIME_CMPL_NUM4, NVL(CASE WHEN D.OVERDUED = 1 THEN (COUNT(DISTINCT(B.APP_NO)) + COUNT(DISTINCT(C.APP_NO))) END, 0) AS ONTIME_CMPL_NUM1, NVL(CASE WHEN D.OVERDUED = 3 THEN (COUNT(DISTINCT(B.APP_NO)) + COUNT(DISTINCT(C.APP_NO))) END, 0) AS ONTIME_CMPL_NUM3 FROM SA_WORKFORM_INST_HISTORY A, ARC_S_APP B, ARC_S_BATCH_CUST_APP C, RT_PROCESSINSTANCE D, SA_USER E WHERE TO_CHAR(A.COMPLETE_TIME, 'YYYYMMDD') = :B1 AND A.KEYDATA_ID = B.APP_NO AND C.APP_ID(+) = B.APP_ID AND D.PROC_INSTANCE_ID(+) = A.PROCINST_ID AND A.BUILDER = E.USER_ID AND D.PARENT_PROCINC_ID IS NULL AND B.APP_TYPE_CODE IN ('101', '102', '103', '104', '105', '106', '107', '108', '109', '110', '111', '112', '201', '202', '203', '204', '205', '206', '207', '208', '209', '210', '211', '212', '213', '214', '215', '216', '217', '218', '301', '302', '303', '304', '305', '306', '307', '311', '351', '715', '716') GROUP BY B.ORG_NO, E.DEPT_ID, B.APP_TYPE_CODE, A.BUILDER, D.OVERDUED) A GROUP BY A.ORG_NO, A.DEPT_ID, A.APP_TYPE_CODE, A.BUILDER UNION SELECT NVL(A.ORG_NO, '888') AS ORG_NO, NVL(A.DEPT_ID, '888') AS DEPT_NO, NVL(A.APP_TYPE_CODE, '888') AS PROC_NO, '?' AS ACT_SORT_CODE, A.BUILDER AS HANDLE_EMP_NO, '???' AS STATUS_CODE, SUM(HANDLE_CC)
AS HANDLE_CC, SUM(WKST_NUM) AS WKST_NUM, 0 AS UNCMPL_NUM, 0 AS OT_UNCMPL_NUM, 0 AS CMPL_NUM, 0 AS OT_CMPL_NUM, 0 AS ONTIME_CMPL_NUM FROM (SELECT B.ORG_NO, E.DEPT_ID, B.APP_TYPE_CODE, A.BUILDER, CASE WHEN COUNT(C.CONS_NO) = 0 THEN COUNT(DISTINCT(B.APP_NO)) ELSE COUNT(C.CONS_NO) + COUNT(DISTINCT(B.APP_NO)) - COUNT(DISTINCT(C.APP_NO)) END AS HANDLE_CC, COUNT(DISTINCT(B.APP_NO)) AS WKST_NUM FROM SA_WORKFORM_INST_HISTORY A, ARC_S_APP B, ARC_S_BATCH_CUST_APP C, RT_PROCESSINSTANCE D, SA_USER E WHERE TO_CHAR(B.HANDLE_TIME, 'YYYYMMDD') = :B1 AND A.KEYDATA_ID = B.APP_NO AND C.APP_ID(+) = B.APP_ID AND D.PROC_INSTANCE_ID(+) = A.PROCINST_ID AND A.BUILDER = E.USER_ID AND D.PARENT_PROCINC_ID IS NULL AND B.APP_TYPE_CODE IN ('101', '102', '103', '104', '105', '106', '107', '108', '109', '110', '111', '112', '201', '202', '203', '204', '205', '206', '207', '208', '209', '210', '211', '212', '213', '214', '215', '216', '217', '218', '301', '302', '303', '304', '305', '306', '307', '311', '351', '715', '716') GROUP BY B.ORG_NO, E.DEPT_ID, B.APP_TYPE_CODE, A.BUILDER, D.OVERDUED) A GROUP BY A.ORG_NO, A.DEPT_ID, A.APP_TYPE_CODE, A.BUILDER UNION SELECT NVL(T.ORG_NO, '999') AS ORG_NO, NVL(T.DEPT_ID, '999') AS DEPT_NO, NVL(T.APP_TYPE_CODE, '999') AS PROC_NO, MAX(NAME_1) AS ACT_SORT_CODE, T.BUILDER AS HANDLE_EMP_NO, '???' AS STATUS_CODE, CASE WHEN COUNT(S.CONS_NO) = 0 THEN COUNT(DISTINCT(T.APP_NO)) ELSE COUNT(S.CONS_NO) + COUNT(DI
STINCT(T.APP_NO)) - COUNT(DISTINCT(S.APP_NO)) END AS HANDLE_CC, COUNT(DISTINCT(T.APP_NO)) AS WKST_NUM, COUNT(DISTINCT(T.APP_NO)) AS UNCMPL_NUM, 0 AS OT_UNCMPL_NUM, 0 AS CMPL_NUM, 0 AS ONTIME_CMPL_NUM, 0 AS OT_CMPL_NUM FROM (SELECT A.ORG_NO ORG_NO, A.APP_ID APP_ID, A.APP_NO APP_NO, A.APP_TYPE_CODE APP_TYPE_CODE, B.KEYDATA_ID KEYDATA_ID, CASE WHEN C.WORKTASK_NAME IS NULL THEN '???????' ELSE C.WORKTASK_NAME END AS NAME_1, B.BUILDER BUILDER, C.DEPT DEPT_ID FROM S_APP A, SA_WORKFORM_INST B, SA_WORKTASK C WHERE TO_CHAR(HANDLE_TIME, 'YYYYMMDD') = :B1 AND B.KEYDATA_ID = A.APP_NO AND B.INSTANCE_ID = C.INSTANCE_ID AND B.PROCINST_ID IS NULL AND A.APP_TYPE_CODE IN ('101', '102', '103', '104', '105', '106', '107', '108', '109', '110', '111', '112', '201', '202', '203', '204', '205', '206', '207', '208', '209', '210', '211', '212', '213', '214', '215', '216', '217', '218', '301', '302', '303', '304', '305', '306', '307', '311', '351', '715', '716') ) T, S_BATCH_CUST_APP S WHERE S.APP_ID(+) = T.APP_ID GROUP BY T.ORG_NO, T.DEPT_ID, T.APP_TYPE_CODE, T.BUILDER ) A GROUP BY A.ORG_NO, A.DEPT_NO, A.PROC_NO, A.ACT_SORT_CODE, A.HANDLE_EMP_NO, A.STATUS_CODE |
c053y9dmm5xh1 | BEGIN PRC_O_CONSBASE(:1); END; |
c1599tjmzu1fc | /* OracleOEM */ BEGIN :message := dbms_server_alert.expand_message(:language, :message_id, :argument_1, :argument_2, :argument_3, :argument_4, :argument_5); END; |
ca4ukj0ujvz3x |
SELECT "A1"."INS_NAME", "A1"."APP_NO", "A1"."INS_NAME", "A1"."END_TIME", "A1"."END_TIME", "A1"."STATUS_CODE", "A1"."INS_NAME", "A2"."PS_ORG_NO", "A2"."APP_NO", "A2"."PS_ORG_NO", "A2"."CONS_NO", "A2"."CONS_NO", "A2"."CONS_NAME", "A2"."PS_ORG_NO", "A2"."ELEC_ADDR", "A2"."VOLT_CODE", "A2"."TRADE_CODE", "A2"."HEC_INDUSTRY_CODE", "A2"."ELEC_TYPE_CODE", "A2"."ELEC_TYPE_CODE", "A2"."CONS_ID", "A2"."CUST_ID", "A2"."APP_ID", "A2"."APP_NO", "A2"."PS_ORG_NO" FROM "P_PROC_INSTANCE" "A1", "ARC_S_APP" "A2" WHERE "A2"."PS_ORG_NO" LIKE :1 AND "A1"."APP_NO"="A2"."APP_NO" AND "A1"."INS_NAME"<>'103' AND "A1"."INS_NAME"<>'112' AND "A1"."INS_NAME"<>'217' AND "A1"."END_TIME">=:2 AND "A1"."END_TIME"<:3 AND "A1"."STATUS_CODE"='02'
|
cj8q5srj4prnd | BEGIN PRC_O_BUSI_ACT(:1); END; |
cjk1ffy5kmm5s | select obj# from oid$ where user#=:1 and oid$=:2 |
cqv52axncuvzv | SELECT signature, nhash, sqlarea_hash, last_used, inuse_features, flags, modified, incarnation FROM sql$ WHERE signature = :1 |
crar4jfwaf7m6 |
SELECT "A1"."INS_NAME", "A1"."INS_NAME", "A1"."APP_NO", "A1"."BGN_TIME", "A1"."BGN_TIME", "A1"."INS_NAME", "A1"."INS_NAME", "A2"."PS_ORG_NO", "A2"."APP_NO", "A2"."PS_ORG_NO", "A2"."CONS_NO", "A2"."CONS_NO", "A2"."CONS_NAME", "A2"."PS_ORG_NO", "A2"."ELEC_ADDR", "A2"."VOLT_CODE", "A2"."TRADE_CODE", "A2"."HEC_INDUSTRY_CODE", "A2"."ELEC_TYPE_CODE", "A2"."ELEC_TYPE_CODE", "A2"."APP_ID", "A2"."T_RUN_CAP", "A2"."ORGN_RUN_CAP", "A2"."T_CONTRACT_CAP", "A2"."ORGN_CONTRACT_CAP", "A2"."CONS_ID", "A2"."CUST_ID", "A2"."APP_NO", "A2"."PS_ORG_NO" FROM "P_PROC_INSTANCE" "A1", "S_APP" "A2" WHERE "A2"."PS_ORG_NO" LIKE :1 AND "A2"."APP_NO"="A1"."APP_NO" AND "A1"."BGN_TIME">=:2 AND "A1"."BGN_TIME"<:3 AND "A1"."INS_NAME"<>'103' AND "A1"."INS_NAM
E"<>'112' AND "A1"."INS_NAME"<>'217' |
csr9ggpd4zawc | BEGIN PRC_O_LLR_CMPL(:1); END; |
d9dkp2jmgfvr3 | select sa_resource.RES_ID as "RES_ID", sa_resource.MODULE_NAME as "MODULE_NAME", sa_resource.RES_NAME as "RES_NAME", sa_resource.RES_TYPE as "RES_TYPE", sa_resource.PERMISSION_ID as "PERMISSION_ID", sa_resource.ATTR1 as "ATTR1", sa_resource.ATTR2 as "ATTR2", sa_resource.ATTR3 as "ATTR3", sa_resource.ATTR4 as "ATTR4", sa_resource.FOLDER_ID as "FOLDER_ID", sa_resource.HEIGHT as "HEIGHT", sa_resource.PANEL_TITLE as "PANEL_TITLE", sa_resource.B_PANEL as "B_PANEL", sa_resource.VALID_FLAG as "VALID_FLAG", sa_resource.START_TIME as "START_TIME", sa_resource.END_TIME as "END_TIME" from sa_resource where sa_resource.RES_TYPE = 'component' and sa_resource.ATTR1 = :1 and sa_resource.ATTR2 = :2 |
f3v7cr8996tw6 | create global temporary table sys.ora_temp_1_ds_2478178 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"MR_STATUS_CODE", "EXCP_TYPE_CODE", "LAST_MR_DATE", "THIS_YMD", "SRC_CODE", "RELA_APP_NO", "MR_FACTOR", "ACTUAL_MODE", "METER_DATE", "CHECK_TYPE", "PRC_CODE", "BIN_MT_POS", "ASSET_NO", "MADE_NO", "ADJUST_PQ", "ADJUST_MODE", "RECORD_ID", "CONS_MT_ID", "MODIFY_TIMES", "USAGE_TYPE_CODE", "CONTAINER_NO", "T_PRC", "REMARK", "BAR_CODE", "MR_ID", "MR_PLAN_NO", "APP_NO", "CALC_ID", "AMT_YM", "CONS_NO", "ORG_NO", "METER_ID", "MP_ID", "MR_SN", "AVG_PQ", "MR_DIGIT", "READ_TYPE_CODE", "T_FACTOR", "LAST_MR_NUM", "LAST_MR_PQ", "THIS_READ", "THIS_READ_PQ" from "EPM_LN"."ARC_R_DATA" sample ( .9637362097) t where 1 = 2 |
faww0hfwysxpk |
create global temporary table sys.ora_temp_1_ds_2468491 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"GC_TYPE_CODE", "ABSO_MODE", "USER_TYPE_CODE", "DIVISION_CODE", "RUN_CAP", "CONTRACT_CAP", "POWEROFF_CODE", "ARC_CALC_ID", "HANLE_REMARK", "REMIND_SECT_NO", "AMT_CALC_ID", "CALC_PERIOD", "CALC_ID", "APP_CODE", "YM", "CONS_ID", "ORG_NO", "VERI_RSLT", "VERI_REMARK", "CALC_DATE", "SEND_DATE", "CONS_NO", "CONS_NAME", "CONS_SORT_CODE", "ELEC_ADDR", "TRADE_TYPE_CODE", "ELEC_TYPE_CODE", "VOLT_CODE", "HEC_TRADE_CODE", "CREATE_DATE", "POWERON_DATE", "CANCEL_DATE", "STATUS_CODE", "BUSI_REGION_NO", "TRANSFER_FLAG", "MR_SECT_NO", "GP_CODE", "RENDER_STATUS", "CALC_TYPE", "CALC_TIMES", "PAY_MODE", "USE_MONTH", "DATA_SRC", "ORGN_CONS_NO", "APP_NO_REF", "SHIFT_NO" from "EPM_LN"."ARC_E_CONS_SNAP" sample ( 1.1024463483) t where 1 = 2
|
fnfvv8wmh4gfp | create global temporary table sys.ora_temp_1_ds_2478190 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"MR_STATUS_CODE", "EXCP_TYPE_CODE", "LAST_MR_DATE", "THIS_YMD", "SRC_CODE", "RELA_APP_NO", "MR_FACTOR", "ACTUAL_MODE", "METER_DATE", "CHECK_TYPE", "PRC_CODE", "BIN_MT_POS", "ASSET_NO", "MADE_NO", "ADJUST_PQ", "ADJUST_MODE", "RECORD_ID", "CONS_MT_ID", "MODIFY_TIMES", "USAGE_TYPE_CODE", "CONTAINER_NO", "T_PRC", "REMARK", "BAR_CODE", "MR_ID", "MR_PLAN_NO", "APP_NO", "CALC_ID", "AMT_YM", "CONS_NO", "ORG_NO", "METER_ID", "MP_ID", "MR_SN", "AVG_PQ", "MR_DIGIT", "READ_TYPE_CODE", "T_FACTOR", "LAST_MR_NUM", "LAST_MR_PQ", "THIS_READ", "THIS_READ_PQ" from "EPM_LN"."ARC_R_DATA" sample ( .6104701432) t where 1 = 2 |
ft2b5tk5pcb8t | create global temporary table sys.ora_temp_1_ds_2478189 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"MR_STATUS_CODE", "EXCP_TYPE_CODE", "LAST_MR_DATE", "THIS_YMD", "SRC_CODE", "RELA_APP_NO", "MR_FACTOR", "ACTUAL_MODE", "METER_DATE", "CHECK_TYPE", "PRC_CODE", "BIN_MT_POS", "ASSET_NO", "MADE_NO", "ADJUST_PQ", "ADJUST_MODE", "RECORD_ID", "CONS_MT_ID", "MODIFY_TIMES", "USAGE_TYPE_CODE", "CONTAINER_NO", "T_PRC", "REMARK", "BAR_CODE", "MR_ID", "MR_PLAN_NO", "APP_NO", "CALC_ID", "AMT_YM", "CONS_NO", "ORG_NO", "METER_ID", "MP_ID", "MR_SN", "AVG_PQ", "MR_DIGIT", "READ_TYPE_CODE", "T_FACTOR", "LAST_MR_NUM", "LAST_MR_PQ", "THIS_READ", "THIS_READ_PQ" from "EPM_LN"."ARC_R_DATA" sample ( .5776913240) t where 1 = 2 |
g3wrkmxkxzhf2 | select cols, audit$, textlength, intcols, property, flags, rowid from view$ where obj#=:1 |
g8bjbfhv73d31 | SELECT NVL(SUM(NVL(RCVBL_PENALTY, 0)-NVL(RCVED_PENALTY, 0)), 0) PENALTY,
MIN(RCVBL_AMT_ID) RCVBL_AMT_ID
FROM A_RCVBL_FLOW
WHERE CONS_NO = :1
AND ORG_NO LIKE :2
AND SETTLE_FLAG in ('01', '02') |
g8k48mbcnrt9b | select * from (select alia.*, rownum as rnum from (SELECT DISTINCT group_id FROM rt_overtime_deal WHERE current_state=:1 AND (create_time is not null) AND (time_out_time is NULL) AND handlestate=0 AND version=0) alia where rownum <2) where rnum>=1 |
gfqm840qr17qq | SELECT SUBSTR("A3"."PS_ORG_NO", 1, 5)||"A3"."APP_NO", SUBSTR("A3"."PS_ORG_NO", 1, 5)||"A1"."CONS_NO", :1, "A1"."CONS_NO", "A1"."CONS_NAME", "A3"."PS_ORG_NO", "A1"."ELEC_ADDR", "A3"."VOLT_CODE", "A1"."TRADE_CODE", NVL("A3"."HEC_INDUSTRY_CODE", '000'), "A1"."ELEC_TYPE_CODE", "A1"."ELEC_TYPE_CODE", 0, "A2"."INS_NAME", "A3"."APP_ID" FROM "ARC_S_APP" "A3", "P_PROC_INSTANCE" "A2", "ARC_S_BATCH_CUST_APP" "A1" WHERE "A2"."APP_NO"="A3"."APP_NO" AND "A3"."APP_ID"="A1"."APP_ID" AND ("A2"."INS_NAME"='103' OR "A2"."INS_NAME"='112' OR "A2"."INS_NAME"='217') AND "A2"."END_TIME">=:2 AND "A2"."END_TIME"<:3 AND "A2"."STATUS_CODE"='02' AND "A3"."PS_ORG_NO" LIKE :4 |
gq29uz9g0tcb9 |
INSERT INTO SA_O_LLR_CMPL SELECT AA.ORG_NO, :B3 , AA.CHKUNIT_ID, AA.CHKUNIT_NAME, AA.PPQ, AA.SPQ, AA.LPQ, AA.LLR, AA.LL_IDX, AA.IDX_DIFF, AA.LPQ_DIFF, NVL(CC.LLR, 0), AA.LLR - NVL(CC.LLR, 0), NVL(CC.LPQ, 0), AA.LPQ - NVL(CC.LPQ, 0), NVL(BB.LLR, 0), AA.LLR - NVL(BB.LLR, 0), NVL(BB.LPQ, 0), AA.LPQ - NVL(BB.LPQ, 0) FROM (SELECT A.ORG_NO ORG_NO, A.CHKUNIT_ID, A.CHKUNIT_NAME, D.CHKUNIT_PPQ PPQ, D.CHKUNIT_SPQ SPQ, (D.CHKUNIT_PPQ - D.CHKUNIT_SPQ) LPQ, (CASE WHEN D.CHKUNIT_PPQ != 0 THEN (D.CHKUNIT_PPQ - D.CHKUNIT_SPQ) / D.CHKUNIT_PPQ ELSE 0 END) LLR, NVL(E.LL_IDX_VALUE, 0) LL_IDX, ((CASE WHEN D.CHKUNIT_PPQ != 0 THEN (D.CHKUNIT_PPQ - D.CHKUNIT_SPQ) / D.CHKUNIT_PPQ ELSE 0 END) - NVL(E.LL_IDX_VALUE, 0)) IDX_DIFF, (D.CHKUNIT_PPQ - D.CHKUNIT_SPQ - D.CHKUNIT_PPQ * NVL(E.LL_IDX_VALUE, 0)) LPQ_DIFF FROM G_CHKUNIT A, G_CHKUNIT_COMP B, G_LL_STAT C, G_CHKUNIT_PQ D, G_CHKUNIT_REF_IDX E WHERE A.CHKUNIT_ID = B.CHKUNIT_ID AND A.LINK_FLAG = '0' AND C.DATA_STATUS = '01' AND C.ORG_NO = A.ORG_NO AND C.STAT_ID = D.STAT_ID AND C.STAT_SORT_CODE = '03' AND A.CHKUNIT_ID = C.RANGE_ID AND A.CHKUNIT_ID = E.CHKUNIT_ID(+) AND E.CHK_MONTH(+) = :B3 AND TO_CHAR(C.END_DATE, 'YYYYMM') = :B3 ) AA, (SELECT A.CHKUNIT_ID, A.CHKUNIT_NAME, D.CHKUNIT_PPQ - D.CHKUNIT_SPQ LPQ, CASE WHEN D.CHKUNIT_PPQ != 0 THEN (D.CHKUNIT_PPQ - D.CHKUNIT_SPQ) / D.CHKUNIT_PPQ ELSE 0 END LLR FROM G_CHKUNIT A, G_CHKUNIT_COMP B, G_LL_STAT C, G_CHKUNIT_PQ D WHERE A.CHKUNIT_ID = B.CHKUNIT_ID AND A.LI
NK_FLAG = '0' AND A.CHKUNIT_TYPE_CODE = '01' AND B.OBJ_TYPE_CODE = '01' AND C.DATA_STATUS = '01' AND C.ORG_NO = A.ORG_NO AND C.STAT_ID = D.STAT_ID AND C.STAT_SORT_CODE = '03' AND A.CHKUNIT_ID = C.RANGE_ID AND TO_CHAR(C.END_DATE, 'YYYYMM') = :B2 ) BB, (SELECT A.CHKUNIT_ID, A.CHKUNIT_NAME, D.CHKUNIT_PPQ - D.CHKUNIT_SPQ LPQ, CASE WHEN D.CHKUNIT_PPQ != 0 THEN (D.CHKUNIT_PPQ - D.CHKUNIT_SPQ) / D.CHKUNIT_PPQ ELSE 0 END LLR FROM G_CHKUNIT A, G_CHKUNIT_COMP B, G_LL_STAT C, G_CHKUNIT_PQ D WHERE A.CHKUNIT_ID = B.CHKUNIT_ID AND A.LINK_FLAG = '0' AND A.CHKUNIT_TYPE_CODE = '01' AND C.ORG_NO = A.ORG_NO AND C.STAT_ID = D.STAT_ID AND C.STAT_SORT_CODE = '03' AND A.CHKUNIT_ID = C.RANGE_ID AND TO_CHAR(C.END_DATE, 'YYYYMM') = :B1 ) CC WHERE AA.CHKUNIT_ID = BB.CHKUNIT_ID(+) AND AA.CHKUNIT_ID = CC.CHKUNIT_ID(+) |
gvg46qmtsmdc6 | INSERT INTO O_CUST_VALUE_EVAL (SELECT C.ORG_NO AS ORG_NO, TO_CHAR(CV.EVAL_DATE, 'yyyymm') AS YM, NVL(CL.EXECUTOR_NO, '9999') AS EVAL_PERSON, COUNT(DISTINCT CV.CUST_ID) AS VALUE_EVAL_CC, S.CUST_CC - COUNT(DISTINCT CV.CUST_ID) AS VALUE_UNEVAL_CC, S.CUST_CC AS CC FROM S_CUST_VALUE CV, S_CR_EVAL_LOG CL, C_CONS C, (SELECT O.ORG_NO, COUNT(DISTINCT O.CUST_ID) CUST_CC FROM C_CONS O GROUP BY O.ORG_NO) S WHERE CV.CUST_ID = C.CUST_ID AND CV.ID3 = CL.ID(+) AND S.ORG_NO = C.ORG_NO AND TO_CHAR(CV.EVAL_DATE, 'yyyymm') = :B1 GROUP BY C.ORG_NO, TO_CHAR(CV.EVAL_DATE, 'yyyymm'), CL.EXECUTOR_NO, S.CUST_CC) |
gvwx5k6wyadar | create global temporary table sys.ora_temp_1_ds_2468463 on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"PREPAY_DATE", "PREPAY_YM", "ACCT_NO", "NOTE_ID", "REMA_TYPE", "REMAIN", "PAY_MODE", "PART_CHG_YM", "FREEZE_AMT", "PREPAY_ID", "CHARGE_ID", "PREPAY_AMT", "CONS_NO", "ORG_NO" from "EPM_LN"."A_PREPAY_FLOW" sample ( .6118683049) t where 1 = 2 |
gx4rhfz2g90tx | DELETE FROM QRTZ_FIRED_TRIGGERS WHERE ENTRY_ID = :1 |
Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
EPCDAT1 | /dev/vgepm1/rlvepc_data1 |
624 | 0 | 2.29 | 1.78 | 31 | 0 | 0 | 0.00 |
EPCDAT1 | /dev/vgepm1/rlvepc_data2 |
64 | 0 | 6.09 | 9.44 | 106 | 0 | 0 | 0.00 |
EPCDAT1 | /dev/vgepm1/rlvepc_data3 |
120 | 0 | 4.33 | 4.16 | 103 | 0 | 0 | 0.00 |
EPCDAT1 | /dev/vgepm1/rlvepc_data4 |
52 | 0 | 8.27 | 8.29 | 25 | 0 | 2 | 0.00 |
EPCDAT1 | /dev/vgepm1/rlvepc_data5 |
109 | 0 | 6.88 | 5.19 | 81 | 0 | 0 | 0.00 |
EPCDAT1 | /dev/vgepm1/rlvepc_data6 |
453 | 0 | 3.31 | 1.85 | 144 | 0 | 1 | 0.00 |
EPCDAT1 | /dev/vgepm1/rlvepc_data7 |
321 | 0 | 4.33 | 2.83 | 240 | 0 | 0 | 0.00 |
EPCDAT1 | /dev/vgepm1/rlvepc_data8 |
649 | 0 | 2.79 | 1.84 | 101 | 0 | 0 | 0.00 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_001 |
3,002 | 1 | 14.21 | 5.11 | 293 | 0 | 74 | 4.32 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_002 |
1,830 | 1 | 13.88 | 7.74 | 26 | 0 | 25 | 5.20 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_003 |
1,797 | 0 | 20.04 | 7.89 | 22 | 0 | 25 | 8.00 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_004 |
2,011 | 1 | 13.65 | 7.10 | 16 | 0 | 13 | 6.92 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_005 |
1,684 | 0 | 19.61 | 8.13 | 33 | 0 | 25 | 6.80 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_006 |
2,046 | 1 | 12.89 | 6.86 | 51 | 0 | 27 | 6.30 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_007 |
2,572 | 1 | 19.62 | 5.45 | 24 | 0 | 22 | 7.27 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_008 |
1,710 | 0 | 19.49 | 7.55 | 33 | 0 | 26 | 6.54 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_009 |
1,584 | 0 | 12.95 | 8.23 | 44 | 0 | 28 | 6.43 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_010 |
1,765 | 0 | 13.64 | 7.50 | 55 | 0 | 14 | 4.29 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_011 |
1,911 | 1 | 18.41 | 7.00 | 81 | 0 | 99 | 6.87 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_012 |
1,620 | 0 | 21.59 | 8.22 | 40 | 0 | 61 | 7.87 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_013 |
1,299 | 0 | 14.32 | 10.30 | 47 | 0 | 35 | 6.29 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_014 |
777 | 0 | 6.82 | 14.41 | 42 | 0 | 44 | 7.05 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_015 |
931 | 0 | 11.42 | 12.10 | 38 | 0 | 51 | 6.67 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_016 |
876 | 0 | 8.98 | 12.90 | 29 | 0 | 120 | 6.42 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_017 |
954 | 0 | 6.07 | 11.98 | 72 | 0 | 163 | 5.89 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_018 |
1,015 | 0 | 9.90 | 11.08 | 38 | 0 | 192 | 5.99 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_019 |
1,121 | 0 | 11.15 | 10.13 | 60 | 0 | 113 | 6.46 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_020 |
809 | 0 | 11.16 | 13.80 | 46 | 0 | 64 | 7.50 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_021 |
731 | 0 | 8.26 | 15.29 | 71 | 0 | 67 | 6.72 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_022 |
871 | 0 | 8.93 | 12.74 | 64 | 0 | 88 | 7.05 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_023 |
1,142 | 0 | 15.35 | 9.85 | 59 | 0 | 106 | 7.17 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_024 |
1,235 | 0 | 13.12 | 9.23 | 49 | 0 | 143 | 6.22 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_025 |
1,688 | 0 | 4.49 | 7.06 | 41 | 0 | 176 | 6.02 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_026 |
3,147 | 1 | 6.69 | 3.93 | 27 | 0 | 159 | 5.66 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_027 |
1,716 | 0 | 8.78 | 6.94 | 23 | 0 | 161 | 6.77 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_028 |
855 | 0 | 7.86 | 12.20 | 23 | 0 | 91 | 6.92 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_029 |
1,672 | 0 | 6.19 | 7.19 | 41 | 0 | 69 | 6.67 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_030 |
1,159 | 0 | 6.25 | 10.01 | 25 | 0 | 59 | 6.61 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_031 |
856 | 0 | 10.35 | 21.20 | 10 | 0 | 52 | 7.12 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_032 |
998 | 0 | 11.56 | 18.20 | 3 | 0 | 77 | 7.40 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_033 |
873 | 0 | 8.51 | 20.87 | 13 | 0 | 68 | 6.62 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_034 |
899 | 0 | 7.72 | 20.34 | 27 | 0 | 57 | 6.49 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_035 |
818 | 0 | 6.59 | 22.29 | 25 | 0 | 41 | 7.56 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_036 |
1,831 | 1 | 11.45 | 10.24 | 29 | 0 | 17 | 7.65 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_037 |
1,365 | 0 | 8.29 | 13.62 | 22 | 0 | 28 | 7.50 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_038 |
1,118 | 0 | 14.08 | 16.36 | 21 | 0 | 20 | 5.50 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_039 |
992 | 0 | 10.99 | 18.46 | 15 | 0 | 15 | 8.00 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_040 |
1,041 | 0 | 10.37 | 17.70 | 21 | 0 | 15 | 6.67 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_041 |
1,015 | 0 | 12.37 | 18.07 | 25 | 0 | 16 | 8.13 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_042 |
858 | 0 | 5.64 | 21.44 | 35 | 0 | 11 | 6.36 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_043 |
803 | 0 | 5.84 | 21.61 | 30 | 0 | 17 | 5.29 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_044 |
995 | 0 | 13.30 | 16.83 | 22 | 0 | 17 | 7.65 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_045 |
779 | 0 | 6.75 | 20.94 | 71 | 0 | 13 | 5.38 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_046 |
608 | 0 | 6.58 | 26.60 | 14 | 0 | 51 | 6.86 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_047 |
1,016 | 0 | 15.83 | 15.95 | 59 | 0 | 43 | 6.51 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_048 |
981 | 0 | 10.74 | 16.67 | 65 | 0 | 36 | 7.22 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_049 |
638 | 0 | 6.19 | 25.39 | 143 | 0 | 19 | 8.42 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_050 |
638 | 0 | 6.46 | 25.39 | 191 | 0 | 156 | 1.22 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_051 |
1,419 | 0 | 9.68 | 10.94 | 23 | 0 | 18 | 6.67 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_052 |
2,038 | 1 | 8.14 | 8.33 | 29 | 0 | 18 | 6.67 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_053 |
1,651 | 0 | 11.41 | 10.52 | 29 | 0 | 18 | 7.22 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_054 |
2,717 | 1 | 11.91 | 6.58 | 25 | 0 | 22 | 7.73 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_055 |
1,182 | 0 | 12.74 | 14.45 | 29 | 0 | 13 | 6.15 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_056 |
956 | 0 | 8.57 | 17.83 | 6 | 0 | 21 | 7.62 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_057 |
1,027 | 0 | 10.44 | 10.99 | 2 | 0 | 12 | 7.50 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_058 |
1,629 | 0 | 8.08 | 6.49 | 36 | 0 | 26 | 6.92 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_059 |
1,185 | 0 | 9.60 | 10.01 | 18 | 0 | 20 | 7.00 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_060 |
623 | 0 | 15.30 | 16.75 | 11 | 0 | 22 | 8.18 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_061 |
866 | 0 | 13.83 | 22.19 | 2 | 0 | 35 | 8.86 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_062 |
681 | 0 | 12.72 | 17.67 | 24 | 0 | 34 | 7.06 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_063 |
938 | 0 | 10.60 | 13.61 | 60 | 0 | 75 | 8.13 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_064 |
853 | 0 | 9.31 | 17.08 | 24 | 0 | 46 | 7.39 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_065 |
909 | 0 | 12.99 | 15.75 | 13 | 0 | 55 | 7.27 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_066 |
1,988 | 1 | 5.62 | 7.72 | 140 | 0 | 23 | 7.39 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_067 |
2,528 | 1 | 5.03 | 5.92 | 153 | 0 | 14 | 8.57 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_068 |
1,518 | 0 | 7.84 | 9.65 | 131 | 0 | 14 | 7.14 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_069 |
2,069 | 1 | 12.36 | 7.07 | 189 | 0 | 19 | 5.79 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_070 |
1,926 | 1 | 12.79 | 7.34 | 188 | 0 | 16 | 8.75 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_071 |
1,671 | 0 | 7.82 | 9.10 | 204 | 0 | 12 | 7.50 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_072 |
2,800 | 1 | 11.59 | 5.62 | 203 | 0 | 17 | 8.82 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_073 |
2,183 | 1 | 13.80 | 7.03 | 292 | 0 | 19 | 4.74 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_074 |
2,183 | 1 | 11.77 | 7.17 | 198 | 0 | 24 | 7.92 |
EPMDAT1 | /dev/vgepm1/rlvepm_data1_075 |
2,508 | 1 | 19.06 | 5.79 | 297 | 0 | 26 | 10.38 |
EPMIDX | /dev/vgepm2/rlvepm_data2_001 |
261 | 0 | 2.61 | 1.18 | 0 | 0 | 63 | 1.75 |
EPMIDX | /dev/vgepm2/rlvepm_data2_002 |
264 | 0 | 3.07 | 1.16 | 0 | 0 | 79 | 1.39 |
EPMIDX | /dev/vgepm2/rlvepm_data2_003 |
389 | 0 | 3.21 | 1.12 | 0 | 0 | 74 | 1.76 |
EPMIDX | /dev/vgepm2/rlvepm_data2_004 |
481 | 0 | 2.77 | 1.12 | 0 | 0 | 48 | 1.88 |
EPMIDX | /dev/vgepm2/rlvepm_data2_005 |
714 | 0 | 3.00 | 1.08 | 0 | 0 | 63 | 1.59 |
EPMIDX | /dev/vgepm2/rlvepm_data2_006 |
814 | 0 | 2.67 | 1.05 | 0 | 0 | 77 | 1.56 |
EPMIDX | /dev/vgepm2/rlvepm_data2_007 |
323 | 0 | 2.32 | 1.12 | 5 | 0 | 70 | 2.14 |
EPMIDX | /dev/vgepm2/rlvepm_data2_008 |
309 | 0 | 3.01 | 1.18 | 5 | 0 | 57 | 2.11 |
EPMIDX | /dev/vgepm2/rlvepm_data2_009 |
379 | 0 | 3.06 | 1.13 | 9 | 0 | 66 | 2.27 |
EPMIDX | /dev/vgepm2/rlvepm_data2_010 |
348 | 0 | 4.02 | 1.17 | 5 | 0 | 53 | 1.51 |
EPMIDX | /dev/vgepm2/rlvepm_data2_011 |
285 | 0 | 2.11 | 1.21 | 21 | 0 | 54 | 1.30 |
EPMIDX | /dev/vgepm2/rlvepm_data2_012 |
273 | 0 | 2.34 | 1.23 | 10 | 0 | 53 | 2.08 |
EPMIDX | /dev/vgepm2/rlvepm_data2_013 |
435 | 0 | 3.52 | 1.10 | 0 | 0 | 70 | 1.71 |
EPMIDX | /dev/vgepm2/rlvepm_data2_014 |
538 | 0 | 2.73 | 1.07 | 3 | 0 | 98 | 1.94 |
EPMIDX | /dev/vgepm2/rlvepm_data2_015 |
267 | 0 | 3.60 | 1.22 | 2 | 0 | 54 | 1.85 |
EPMIDX | /dev/vgepm2/rlvepm_data2_016 |
152 | 0 | 3.16 | 1.39 | 2 | 0 | 71 | 2.54 |
EPMIDX | /dev/vgepm2/rlvepm_data2_017 |
213 | 0 | 4.46 | 1.31 | 4 | 0 | 53 | 0.94 |
EPMIDX | /dev/vgepm2/rlvepm_data2_018 |
161 | 0 | 3.73 | 1.29 | 3 | 0 | 84 | 2.50 |
EPMIDX | /dev/vgepm2/rlvepm_data2_019 |
160 | 0 | 3.25 | 1.23 | 4 | 0 | 85 | 1.65 |
EPMIDX | /dev/vgepm2/rlvepm_data2_020 |
131 | 0 | 3.51 | 1.37 | 4 | 0 | 74 | 2.43 |
EPMIDX | /dev/vgepm2/rlvepm_data2_021 |
147 | 0 | 3.13 | 1.48 | 1 | 0 | 46 | 2.61 |
EPMIDX | /dev/vgepm2/rlvepm_data2_022 |
180 | 0 | 3.61 | 1.34 | 0 | 0 | 62 | 2.90 |
EPMIDX | /dev/vgepm2/rlvepm_data2_023 |
232 | 0 | 3.97 | 1.24 | 10 | 0 | 72 | 1.94 |
EPMIDX | /dev/vgepm2/rlvepm_data2_024 |
671 | 0 | 2.40 | 1.69 | 1 | 0 | 471 | 2.04 |
EPMIDX | /dev/vgepm2/rlvepm_data2_025 |
829 | 0 | 2.40 | 1.52 | 0 | 0 | 605 | 1.72 |
EPMIDX | /dev/vgepm2/rlvepm_data2_026 |
763 | 0 | 2.33 | 1.57 | 1 | 0 | 561 | 1.52 |
EPMIDX | /dev/vgepm2/rlvepm_data2_027 |
908 | 0 | 2.26 | 1.48 | 1 | 0 | 627 | 1.66 |
EPMIDX | /dev/vgepm2/rlvepm_data2_028 |
952 | 0 | 2.69 | 1.53 | 2 | 0 | 608 | 1.78 |
EPMIDX | /dev/vgepm2/rlvepm_data2_029 |
1,122 | 0 | 2.91 | 1.48 | 2 | 0 | 522 | 1.76 |
EPMIDX | /dev/vgepm2/rlvepm_data2_030 |
1,251 | 0 | 2.72 | 1.44 | 4 | 0 | 604 | 1.80 |
EPMIDX | /dev/vgepm2/rlvepm_data2_031 |
978 | 0 | 2.55 | 1.66 | 7 | 0 | 655 | 1.80 |
EPMIDX | /dev/vgepm2/rlvepm_data2_032 |
1,381 | 0 | 2.40 | 1.41 | 39 | 0 | 755 | 1.72 |
EPMIDX | /dev/vgepm2/rlvepm_data2_033 |
780 | 0 | 2.29 | 1.72 | 82 | 0 | 490 | 1.84 |
EPMIDX | /dev/vgepm2/rlvepm_data2_034 |
803 | 0 | 2.50 | 1.15 | 18 | 0 | 380 | 1.53 |
EPMIDX | /dev/vgepm2/rlvepm_data2_035 |
903 | 0 | 2.61 | 1.13 | 15 | 0 | 391 | 1.51 |
EPMIDX | /dev/vgepm2/rlvepm_data2_036 |
883 | 0 | 3.11 | 1.13 | 47 | 0 | 401 | 1.52 |
EPMIDX | /dev/vgepm2/rlvepm_data2_037 |
1,883 | 1 | 3.50 | 1.06 | 24 | 0 | 401 | 1.80 |
EPMIDX | /dev/vgepm2/rlvepm_data2_038 |
1,062 | 0 | 4.15 | 1.11 | 6 | 0 | 419 | 1.58 |
EPMIDX | /dev/vgepm2/rlvepm_data2_039 |
1,530 | 0 | 4.07 | 1.07 | 3 | 0 | 394 | 1.62 |
EPMIDX | /dev/vgepm2/rlvepm_data2_040 |
1,111 | 0 | 3.70 | 1.10 | 26 | 0 | 400 | 1.93 |
EPMIDX | /dev/vgepm2/rlvepm_data2_041 |
664 | 0 | 2.20 | 1.18 | 50 | 0 | 487 | 1.46 |
EPMIDX | /dev/vgepm2/rlvepm_data2_042 |
587 | 0 | 2.69 | 1.18 | 24 | 0 | 371 | 1.59 |
EPMIDX | /dev/vgepm2/rlvepm_data2_043 |
810 | 0 | 2.21 | 1.14 | 50 | 0 | 586 | 1.45 |
EPMIDX | /dev/vgepm2/rlvepm_data2_044 |
902 | 0 | 1.97 | 1.13 | 52 | 0 | 572 | 1.56 |
EPMIDX | /dev/vgepm2/rlvepm_data2_045 |
900 | 0 | 2.17 | 1.13 | 40 | 0 | 596 | 1.48 |
EPMIDX | /dev/vgepm2/rlvepm_data2_046 |
933 | 0 | 2.60 | 1.13 | 60 | 0 | 590 | 1.76 |
EPMIDX | /dev/vgepm2/rlvepm_data2_047 |
851 | 0 | 2.50 | 1.14 | 53 | 0 | 477 | 1.43 |
EPMIDX | /dev/vgepm2/rlvepm_data2_048 |
620 | 0 | 2.50 | 1.17 | 48 | 0 | 359 | 1.50 |
EPMIDX | /dev/vgepm2/rlvepm_data2_049 |
653 | 0 | 2.60 | 1.19 | 35 | 0 | 342 | 1.52 |
EPMIDX | /dev/vgepm2/rlvepm_data2_050 |
825 | 0 | 2.80 | 1.16 | 33 | 0 | 457 | 2.04 |
EPMIDX | /dev/vgepm2/rlvepm_data2_051 |
633 | 0 | 2.76 | 1.20 | 31 | 0 | 347 | 2.13 |
EPMIDX | /dev/vgepm2/rlvepm_data2_052 |
667 | 0 | 2.94 | 1.37 | 44 | 0 | 362 | 1.96 |
EPMIDX | /dev/vgepm2/rlvepm_data2_053 |
903 | 0 | 2.79 | 1.26 | 58 | 0 | 379 | 1.64 |
EPMIDX | /dev/vgepm2/rlvepm_data2_054 |
1,189 | 0 | 2.70 | 1.19 | 51 | 0 | 708 | 1.71 |
EPMIDX | /dev/vgepm2/rlvepm_data2_055 |
1,389 | 0 | 2.63 | 1.17 | 72 | 0 | 868 | 1.60 |
EPMIDX | /dev/vgepm2/rlvepm_data2_056 |
1,609 | 0 | 2.30 | 1.15 | 79 | 0 | 996 | 1.70 |
EPMIDX | /dev/vgepm2/rlvepm_data2_057 |
2,017 | 1 | 2.35 | 1.12 | 151 | 0 | 1,284 | 1.77 |
EPMIDX | /dev/vgepm2/rlvepm_data2_058 |
2,030 | 1 | 2.44 | 1.13 | 122 | 0 | 1,308 | 1.80 |
EPMIDX | /dev/vgepm2/rlvepm_data2_059 |
2,211 | 1 | 2.00 | 1.12 | 166 | 0 | 1,484 | 1.84 |
EPMIDX | /dev/vgepm2/rlvepm_data2_060 |
2,528 | 1 | 1.95 | 1.10 | 216 | 0 | 1,730 | 1.94 |
EPMIDX | /dev/vgepm2/rlvepm_data2_061 |
2,745 | 1 | 1.96 | 1.10 | 242 | 0 | 1,988 | 1.88 |
EPMIDX | /dev/vgepm2/rlvepm_data2_062 |
2,832 | 1 | 1.98 | 1.10 | 242 | 0 | 2,039 | 1.88 |
EPMIDX | /dev/vgepm2/rlvepm_data2_063 |
3,357 | 1 | 2.12 | 1.10 | 254 | 0 | 2,227 | 1.61 |
EPMIDX | /dev/vgepm2/rlvepm_data2_064 |
3,244 | 1 | 2.07 | 1.08 | 327 | 0 | 2,267 | 1.75 |
EPMIDX | /dev/vgepm2/rlvepm_data2_065 |
3,551 | 1 | 2.33 | 1.13 | 424 | 0 | 2,506 | 1.94 |
EPMIDX | /dev/vgepm2/rlvepm_data2_066 |
3,717 | 1 | 2.36 | 1.12 | 320 | 0 | 2,542 | 1.88 |
EPMIDX | /dev/vgepm2/rlvepm_data2_067 |
4,967 | 1 | 2.17 | 1.09 | 364 | 0 | 2,723 | 1.71 |
EPMIDX | /dev/vgepm2/rlvepm_data2_068 |
5,781 | 2 | 2.29 | 1.11 | 427 | 0 | 3,015 | 1.92 |
EPMIDX | /dev/vgepm2/rlvepm_data2_069 |
6,011 | 2 | 2.21 | 1.12 | 424 | 0 | 3,139 | 1.80 |
EPMIDX | /dev/vgepm2/rlvepm_data2_070 |
6,150 | 2 | 2.17 | 1.12 | 463 | 0 | 3,273 | 1.94 |
EPMIDX | /dev/vgepm2/rlvepm_data2_071 |
6,444 | 2 | 2.23 | 1.11 | 491 | 0 | 3,567 | 1.67 |
EPMIDX | /dev/vgepm2/rlvepm_data2_072 |
6,874 | 2 | 2.62 | 1.11 | 439 | 0 | 3,746 | 1.78 |
EPMIDX | /dev/vgepm2/rlvepm_data2_073 |
6,243 | 2 | 2.20 | 1.14 | 446 | 0 | 3,628 | 1.86 |
EPMIDX | /dev/vgepm2/rlvepm_data2_074 |
5,528 | 2 | 2.32 | 1.19 | 478 | 0 | 3,706 | 1.73 |
EPMIDX | /dev/vgepm2/rlvepm_data2_075 |
6,077 | 2 | 2.59 | 1.16 | 561 | 0 | 3,922 | 1.84 |
EPMIDX | /dev/vgepm2/rlvepm_data2_076 |
6,398 | 2 | 2.30 | 1.17 | 614 | 0 | 4,070 | 1.83 |
EPMIDX | /dev/vgepm2/rlvepm_data2_077 |
6,498 | 2 | 2.35 | 1.18 | 660 | 0 | 4,077 | 1.79 |
EPMIDX | /dev/vgepm2/rlvepm_data2_078 |
6,348 | 2 | 2.44 | 1.17 | 556 | 0 | 4,150 | 1.79 |
EPMIDX | /dev/vgepm2/rlvepm_data2_079 |
6,384 | 2 | 2.35 | 1.17 | 600 | 0 | 3,827 | 1.74 |
EPMIDX | /dev/vgepm2/rlvepm_data2_080 |
6,395 | 2 | 2.43 | 1.17 | 552 | 0 | 3,792 | 1.67 |
EPMIDX | /dev/vgepm2/rlvepm_data2_081 |
6,021 | 2 | 2.33 | 1.21 | 574 | 0 | 3,804 | 1.81 |
EPMIDX | /dev/vgepm2/rlvepm_data2_082 |
5,868 | 2 | 2.41 | 1.21 | 776 | 0 | 3,684 | 1.71 |
EPMIDX | /dev/vgepm2/rlvepm_data2_083 |
5,944 | 2 | 2.68 | 1.21 | 730 | 0 | 3,758 | 1.69 |
EPMIDX | /dev/vgepm2/rlvepm_data2_084 |
5,821 | 2 | 2.57 | 1.26 | 608 | 0 | 3,430 | 1.73 |
EPMIDX | /dev/vgepm2/rlvepm_data2_085 |
5,199 | 1 | 2.79 | 1.31 | 539 | 0 | 3,123 | 1.79 |
EPMIDX | /dev/vgepm2/rlvepm_data2_086 |
5,245 | 1 | 2.85 | 1.34 | 507 | 0 | 3,168 | 1.89 |
EPMIDX | /dev/vgepm2/rlvepm_data2_087 |
4,975 | 1 | 2.73 | 1.36 | 450 | 0 | 2,916 | 1.70 |
EPMIDX | /dev/vgepm2/rlvepm_data2_088 |
5,105 | 1 | 2.58 | 1.35 | 418 | 0 | 2,861 | 1.76 |
EPMIDX | /dev/vgepm2/rlvepm_data2_089 |
5,927 | 2 | 2.65 | 1.31 | 455 | 0 | 2,834 | 1.68 |
EPMIDX | /dev/vgepm2/rlvepm_data2_090 |
5,778 | 2 | 2.66 | 1.32 | 391 | 0 | 2,753 | 1.96 |
EPMIDX | /dev/vgepm2/rlvepm_data2_091 |
5,235 | 1 | 2.71 | 1.36 | 322 | 0 | 2,375 | 1.83 |
EPMIDX | /dev/vgepm2/rlvepm_data2_092 |
5,366 | 1 | 2.18 | 1.34 | 351 | 0 | 2,491 | 1.74 |
EPMIDX | /dev/vgepm2/rlvepm_data2_093 |
4,757 | 1 | 2.44 | 1.38 | 401 | 0 | 2,650 | 1.83 |
EPMIDX | /dev/vgepm2/rlvepm_data2_094 |
4,770 | 1 | 2.38 | 1.40 | 377 | 0 | 2,543 | 1.83 |
EPMIDX | /dev/vgepm2/rlvepm_data2_095 |
4,938 | 1 | 3.76 | 1.38 | 427 | 0 | 2,472 | 1.88 |
EPMIDX | /dev/vgepm2/rlvepm_data2_096 |
4,844 | 1 | 3.05 | 1.39 | 397 | 0 | 2,243 | 1.89 |
EPMIDX | /dev/vgepm2/rlvepm_data2_097 |
4,905 | 1 | 2.91 | 1.38 | 312 | 0 | 2,120 | 1.81 |
EPMIDX | /dev/vgepm2/rlvepm_data2_098 |
4,907 | 1 | 3.01 | 1.42 | 340 | 0 | 1,975 | 1.81 |
EPMIDX | /dev/vgepm2/rlvepm_data2_099 |
4,133 | 1 | 2.54 | 1.51 | 358 | 0 | 2,100 | 2.04 |
EPMIDX | /dev/vgepm2/rlvepm_data2_100 |
3,656 | 1 | 2.96 | 1.56 | 327 | 0 | 2,103 | 1.80 |
EPMIDX | /dev/vgepm2/rlvepm_data2_101 |
3,855 | 1 | 2.76 | 1.51 | 317 | 0 | 2,259 | 1.89 |
EPMIDX | /dev/vgepm2/rlvepm_data2_102 |
4,016 | 1 | 2.99 | 1.49 | 313 | 0 | 2,313 | 1.88 |
EPMIDX | /dev/vgepm2/rlvepm_data2_103 |
3,897 | 1 | 2.98 | 1.49 | 369 | 0 | 2,362 | 1.91 |
EPMIDX | /dev/vgepm2/rlvepm_data2_104 |
3,637 | 1 | 2.64 | 1.53 | 372 | 0 | 2,364 | 1.81 |
EPMIDX | /dev/vgepm2/rlvepm_data2_105 |
3,769 | 1 | 2.96 | 1.47 | 324 | 0 | 2,364 | 1.84 |
EPMIDX | /dev/vgepm2/rlvepm_data2_106 |
3,624 | 1 | 2.70 | 1.49 | 308 | 0 | 2,299 | 1.84 |
EPMIDX | /dev/vgepm2/rlvepm_data2_107 |
3,303 | 1 | 2.51 | 1.53 | 304 | 0 | 2,116 | 1.95 |
EPMIDX | /dev/vgepm2/rlvepm_data2_108 |
2,923 | 1 | 3.11 | 1.65 | 283 | 0 | 1,884 | 1.92 |
EPMIDX | /dev/vgepm2/rlvepm_data2_109 |
2,875 | 1 | 2.54 | 1.64 | 219 | 0 | 1,751 | 1.80 |
EPMIDX | /dev/vgepm2/rlvepm_data2_110 |
3,750 | 1 | 2.93 | 1.44 | 260 | 0 | 1,794 | 1.82 |
EPMIDX | /dev/vgepm2/rlvepm_data2_111 |
3,649 | 1 | 2.65 | 1.43 | 227 | 0 | 1,759 | 1.96 |
EPMIDX | /dev/vgepm2/rlvepm_data2_112 |
3,441 | 1 | 3.23 | 1.47 | 205 | 0 | 1,516 | 1.84 |
EPMIDX | /dev/vgepm2/rlvepm_data2_113 |
3,274 | 1 | 2.66 | 1.49 | 190 | 0 | 1,346 | 2.02 |
EPMIDX | /dev/vgepm2/rlvepm_data2_114 |
2,428 | 1 | 2.41 | 1.61 | 178 | 0 | 1,273 | 1.85 |
EPMIDX | /dev/vgepm2/rlvepm_data2_115 |
2,095 | 1 | 3.61 | 1.67 | 163 | 0 | 1,274 | 1.95 |
EPMIDX | /dev/vgepm2/rlvepm_data2_116 |
1,879 | 1 | 3.25 | 1.74 | 150 | 0 | 1,092 | 2.32 |
EPMIDX | /dev/vgepm2/rlvepm_data2_117 |
1,749 | 0 | 4.52 | 1.81 | 148 | 0 | 1,031 | 2.53 |
EPMIDX | /dev/vgepm2/rlvepm_data2_118 |
1,789 | 0 | 4.19 | 1.70 | 213 | 0 | 900 | 2.43 |
EPMIDX | /dev/vgepm2/rlvepm_data2_119 |
1,540 | 0 | 4.12 | 1.84 | 103 | 0 | 757 | 2.10 |
EPMIDX | /dev/vgepm2/rlvepm_data2_120 |
1,520 | 0 | 4.66 | 1.88 | 113 | 0 | 709 | 2.64 |
EPMIDX | /dev/vgepm2/rlvepm_data2_121 |
1,699 | 0 | 3.08 | 1.81 | 95 | 0 | 697 | 2.12 |
EPMIDX | /dev/vgepm2/rlvepm_data2_122 |
1,655 | 0 | 3.43 | 1.83 | 107 | 0 | 694 | 2.18 |
EPMIDX | /dev/vgepm2/rlvepm_data2_123 |
1,472 | 0 | 2.90 | 1.86 | 116 | 0 | 592 | 1.98 |
EPMIDX | /dev/vgepm2/rlvepm_data2_124 |
1,392 | 0 | 3.56 | 2.02 | 105 | 0 | 571 | 2.24 |
EPMIDX | /dev/vgepm2/rlvepm_data2_125 |
1,294 | 0 | 3.02 | 2.04 | 106 | 0 | 495 | 2.34 |
EPMIDX | /dev/vgepm2/rlvepm_data2_126 |
960 | 0 | 3.16 | 2.17 | 67 | 0 | 445 | 2.11 |
EPMIDX | /dev/vgepm2/rlvepm_data2_127 |
1,495 | 0 | 2.86 | 1.88 | 73 | 0 | 454 | 2.11 |
EPMIDX | /dev/vgepm2/rlvepm_data2_128 |
1,870 | 1 | 2.70 | 1.54 | 82 | 0 | 321 | 2.55 |
EPMIDX | /dev/vgepm2/rlvepm_data2_129 |
1,766 | 0 | 2.59 | 1.67 | 103 | 0 | 335 | 2.54 |
EPMIDX | /dev/vgepm2/rlvepm_data2_130 |
1,758 | 0 | 2.47 | 1.57 | 102 | 0 | 337 | 2.79 |
EPMIDX | /dev/vgepm2/rlvepm_data2_131 |
774 | 0 | 3.26 | 2.36 | 123 | 0 | 264 | 2.80 |
EPMIDX | /dev/vgepm2/rlvepm_data2_132 |
1,170 | 0 | 2.97 | 2.14 | 139 | 0 | 225 | 2.80 |
EPMIDX | /dev/vgepm2/rlvepm_data2_133 |
847 | 0 | 3.72 | 2.53 | 135 | 0 | 133 | 3.08 |
EPMIDX | /dev/vgepm2/rlvepm_data2_134 |
821 | 0 | 3.57 | 2.66 | 138 | 0 | 94 | 3.83 |
EPMIDX | /dev/vgepm2/rlvepm_data2_135 |
890 | 0 | 3.79 | 2.80 | 153 | 0 | 80 | 3.75 |
EPMIDX | /dev/vgepm2/rlvepm_data2_136 |
993 | 0 | 4.02 | 2.64 | 156 | 0 | 126 | 2.78 |
EPMIDX | /dev/vgepm2/rlvepm_data2_137 |
833 | 0 | 3.65 | 2.94 | 179 | 0 | 142 | 3.31 |
EPMIDX | /dev/vgepm2/rlvepm_data2_138 |
1,071 | 0 | 4.38 | 2.42 | 201 | 0 | 392 | 1.99 |
EPMIDX | /dev/vgepm2/rlvepm_data2_139 |
1,268 | 0 | 3.95 | 2.16 | 197 | 0 | 344 | 2.03 |
EPMIDX | /dev/vgepm2/rlvepm_data2_140 |
1,217 | 0 | 5.53 | 2.08 | 165 | 0 | 438 | 2.05 |
EPMIDX | /dev/vgepm2/rlvepm_data2_141 |
1,080 | 0 | 2.91 | 2.22 | 119 | 0 | 442 | 1.86 |
EPMIDX | /dev/vgepm2/rlvepm_data2_142 |
1,152 | 0 | 3.27 | 2.05 | 134 | 0 | 413 | 1.86 |
EPMIDX | /dev/vgepm2/rlvepm_data2_143 |
1,111 | 0 | 3.96 | 1.94 | 157 | 0 | 423 | 1.99 |
EPMIDX | /dev/vgepm2/rlvepm_data2_144 |
1,365 | 0 | 5.03 | 1.68 | 147 | 0 | 433 | 2.17 |
EPMIDX | /dev/vgepm2/rlvepm_data2_145 |
896 | 0 | 2.75 | 2.03 | 142 | 0 | 402 | 1.59 |
EPMIDX | /dev/vgepm2/rlvepm_data2_146 |
839 | 0 | 2.73 | 1.56 | 81 | 0 | 377 | 1.78 |
EPMIDX | /dev/vgepm2/rlvepm_data2_147 |
1,234 | 0 | 2.80 | 2.06 | 147 | 0 | 429 | 1.72 |
EPMIDX | /dev/vgepm2/rlvepm_data2_148 |
1,152 | 0 | 2.62 | 2.02 | 96 | 0 | 375 | 1.60 |
EPMIDX | /dev/vgepm2/rlvepm_data2_149 |
1,282 | 0 | 2.57 | 2.03 | 168 | 0 | 536 | 1.77 |
EPMIDX | /dev/vgepm2/rlvepm_data2_150 |
1,213 | 0 | 2.77 | 2.21 | 198 | 0 | 565 | 1.70 |
EPMIDX | /dev/vgepm2/rlvepm_data2_151 |
1,919 | 1 | 3.37 | 1.70 | 206 | 0 | 510 | 1.82 |
EPMIDX | /dev/vgepm2/rlvepm_data2_152 |
1,409 | 0 | 3.29 | 1.79 | 176 | 0 | 403 | 2.08 |
EPMIDX | /dev/vgepm2/rlvepm_data2_153 |
1,148 | 0 | 16.31 | 1.98 | 36 | 0 | 334 | 2.31 |
EPMIDX | /dev/vgepm2/rlvepm_data2_154 |
649 | 0 | 6.89 | 2.26 | 38 | 0 | 306 | 2.78 |
EPMIDX | /dev/vgepm2/rlvepm_data2_155 |
401 | 0 | 3.79 | 2.52 | 23 | 0 | 229 | 2.27 |
EPMIDX | /dev/vgepm2/rlvepm_data2_156 |
492 | 0 | 5.22 | 3.50 | 53 | 0 | 167 | 2.57 |
EPMIDX | /dev/vgepm2/rlvepm_data2_157 |
784 | 0 | 2.90 | 2.36 | 83 | 0 | 124 | 2.26 |
EPMIDX | /dev/vgepm2/rlvepm_data2_158 |
818 | 0 | 3.23 | 2.09 | 54 | 0 | 66 | 2.27 |
EPMIDX | /dev/vgepm2/rlvepm_data2_159 |
680 | 0 | 3.09 | 2.20 | 56 | 0 | 59 | 2.03 |
EPMIDX | /dev/vgepm2/rlvepm_data2_160 |
891 | 0 | 3.06 | 1.93 | 60 | 0 | 74 | 1.49 |
EPMIDX | /dev/vgepm2/rlvepm_data2_161 |
1,375 | 0 | 2.75 | 1.96 | 73 | 0 | 78 | 2.56 |
EPMIDX | /dev/vgepm2/rlvepm_data2_162 |
1,043 | 0 | 3.05 | 2.22 | 54 | 0 | 51 | 3.73 |
EPMIDX | /dev/vgepm2/rlvepm_data2_163 |
1,177 | 0 | 2.72 | 1.92 | 91 | 0 | 87 | 2.30 |
EPMIDX | /dev/vgepm2/rlvepm_data2_164 |
1,167 | 0 | 3.71 | 2.09 | 130 | 0 | 75 | 2.67 |
EPMIDX | /dev/vgepm2/rlvepm_data2_165 |
1,066 | 0 | 3.47 | 2.23 | 100 | 0 | 77 | 3.12 |
EPMIDX | /dev/vgepm2/rlvepm_data2_166 |
844 | 0 | 3.03 | 2.41 | 108 | 0 | 66 | 2.73 |
EPMIDX | /dev/vgepm2/rlvepm_data2_167 |
345 | 0 | 3.10 | 2.48 | 38 | 0 | 51 | 1.96 |
EPMIDX | /dev/vgepm2/rlvepm_data2_168 |
348 | 0 | 3.94 | 2.41 | 39 | 0 | 51 | 1.76 |
EPMIDX | /dev/vgepm2/rlvepm_data2_169 |
306 | 0 | 2.91 | 1.19 | 0 | 0 | 55 | 1.09 |
EPMIDX | /dev/vgepm2/rlvepm_data2_170 |
293 | 0 | 2.94 | 1.18 | 0 | 0 | 72 | 1.67 |
EPMIDX | /dev/vgepm2/rlvepm_data2_171 |
340 | 0 | 3.50 | 1.16 | 0 | 0 | 63 | 1.11 |
EPMIDX | /dev/vgepm2/rlvepm_data2_172 |
261 | 0 | 2.61 | 1.22 | 0 | 0 | 60 | 1.00 |
EPMIDX | /dev/vgepm2/rlvepm_data2_173 |
298 | 0 | 3.02 | 1.16 | 0 | 0 | 65 | 1.23 |
EPMIDX | /dev/vgepm2/rlvepm_data2_174 |
304 | 0 | 3.49 | 1.18 | 0 | 0 | 58 | 2.07 |
EPMIDX | /dev/vgepm2/rlvepm_data2_175 |
268 | 0 | 2.99 | 1.25 | 0 | 0 | 49 | 2.04 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_001 |
1,029 | 0 | 18.05 | 4.92 | 6 | 0 | 320 | 4.22 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_002 |
1,981 | 1 | 16.86 | 3.51 | 67 | 0 | 363 | 7.80 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_003 |
1,994 | 1 | 19.67 | 3.30 | 141 | 0 | 444 | 6.96 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_004 |
1,988 | 1 | 23.90 | 2.97 | 231 | 0 | 364 | 9.73 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_005 |
1,289 | 0 | 19.42 | 3.83 | 115 | 0 | 433 | 5.94 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_006 |
1,310 | 0 | 14.66 | 3.89 | 85 | 0 | 392 | 5.46 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_007 |
1,685 | 0 | 24.85 | 2.53 | 33 | 0 | 396 | 8.36 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_008 |
2,122 | 1 | 22.66 | 2.22 | 54 | 0 | 421 | 9.93 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_009 |
1,575 | 0 | 19.84 | 4.13 | 105 | 0 | 698 | 5.76 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_010 |
1,775 | 0 | 20.04 | 3.57 | 201 | 0 | 742 | 5.78 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_011 |
2,221 | 1 | 22.35 | 2.90 | 100 | 0 | 840 | 5.68 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_012 |
1,116 | 0 | 14.71 | 5.92 | 43 | 0 | 822 | 3.35 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_013 |
951 | 0 | 11.69 | 6.93 | 155 | 0 | 735 | 3.24 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_014 |
1,072 | 0 | 11.07 | 6.18 | 99 | 0 | 778 | 3.20 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_015 |
2,266 | 1 | 18.74 | 4.57 | 90 | 0 | 907 | 5.20 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_016 |
2,159 | 1 | 19.41 | 4.10 | 31 | 0 | 807 | 5.25 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_017 |
1,782 | 0 | 16.98 | 4.79 | 86 | 0 | 786 | 5.19 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_018 |
1,913 | 1 | 12.10 | 4.35 | 134 | 0 | 609 | 5.85 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_019 |
2,190 | 1 | 14.00 | 3.79 | 49 | 0 | 562 | 7.53 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_020 |
1,988 | 1 | 14.38 | 3.98 | 66 | 0 | 502 | 7.67 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_021 |
1,342 | 0 | 12.92 | 5.45 | 100 | 0 | 745 | 4.31 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_022 |
1,595 | 0 | 11.24 | 4.99 | 65 | 0 | 956 | 3.63 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_023 |
934 | 0 | 9.82 | 7.37 | 75 | 0 | 1,179 | 2.49 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_024 |
1,494 | 0 | 13.23 | 5.02 | 139 | 0 | 776 | 4.20 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_025 |
819 | 0 | 15.91 | 7.73 | 157 | 0 | 401 | 5.21 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_026 |
1,353 | 0 | 17.77 | 4.88 | 187 | 0 | 394 | 8.02 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_027 |
1,316 | 0 | 18.24 | 5.46 | 269 | 0 | 473 | 6.72 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_028 |
1,053 | 0 | 8.66 | 5.84 | 241 | 0 | 587 | 4.31 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_029 |
928 | 0 | 16.20 | 6.58 | 297 | 0 | 326 | 6.93 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_030 |
531 | 0 | 10.85 | 9.81 | 174 | 0 | 251 | 6.10 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_031 |
394 | 0 | 9.90 | 10.66 | 56 | 0 | 172 | 6.40 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_032 |
487 | 0 | 17.06 | 8.57 | 70 | 0 | 172 | 6.86 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_033 |
532 | 0 | 16.26 | 7.89 | 57 | 0 | 193 | 7.20 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_034 |
333 | 0 | 10.96 | 9.40 | 45 | 0 | 127 | 5.35 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_035 |
385 | 0 | 14.62 | 8.22 | 79 | 0 | 136 | 6.99 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_036 |
344 | 0 | 9.39 | 9.16 | 53 | 0 | 131 | 5.65 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_037 |
361 | 0 | 16.79 | 8.75 | 171 | 0 | 130 | 6.77 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_038 |
402 | 0 | 13.13 | 7.95 | 64 | 0 | 123 | 5.45 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_039 |
360 | 0 | 8.97 | 8.75 | 70 | 0 | 130 | 5.77 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_040 |
363 | 0 | 12.45 | 8.71 | 59 | 0 | 128 | 7.11 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_041 |
271 | 0 | 8.15 | 9.60 | 101 | 0 | 121 | 6.45 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_042 |
203 | 0 | 9.95 | 10.34 | 135 | 0 | 98 | 6.53 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_043 |
229 | 0 | 15.55 | 9.28 | 142 | 0 | 73 | 8.36 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_044 |
233 | 0 | 16.31 | 9.17 | 304 | 0 | 71 | 8.31 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_045 |
214 | 0 | 13.22 | 9.73 | 213 | 0 | 76 | 6.97 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_046 |
496 | 0 | 24.78 | 4.29 | 201 | 0 | 76 | 7.89 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_047 |
82 | 0 | 19.51 | 1.06 | 0 | 0 | 7 | 18.57 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_048 |
789 | 0 | 23.40 | 1.05 | 0 | 0 | 42 | 25.71 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_049 |
568 | 0 | 25.55 | 1.05 | 1 | 0 | 43 | 25.35 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_050 |
345 | 0 | 16.99 | 1.04 | 18 | 0 | 76 | 10.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_051 |
63 | 0 | 6.67 | 1.03 | 3 | 0 | 176 | 1.88 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_052 |
759 | 0 | 25.20 | 1.09 | 33 | 0 | 350 | 3.60 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_053 |
4 | 0 | 12.50 | 31.50 | 0 | 0 | 0 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_054 |
8 | 0 | 10.00 | 16.75 | 0 | 0 | 1 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_055 |
4 | 0 | 10.00 | 31.50 | 0 | 0 | 0 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_056 |
7 | 0 | 7.14 | 19.57 | 0 | 0 | 1 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_057 |
6 | 0 | 8.33 | 23.67 | 0 | 0 | 0 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_058 |
6 | 0 | 8.33 | 22.00 | 0 | 0 | 1 | 10.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_059 |
2 | 0 | 10.00 | 1.00 | 0 | 0 | 0 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_060 |
15 | 0 | 5.33 | 2.87 | 3 | 0 | 2 | 5.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_061 |
8 | 0 | 5.00 | 1.88 | 0 | 0 | 0 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_062 |
24 | 0 | 7.08 | 2.29 | 0 | 0 | 9 | 5.56 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_063 |
21,593 | 6 | 1.49 | 1.06 | 0 | 0 | 8 | 8.75 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_064 |
75 | 0 | 6.93 | 16.41 | 0 | 0 | 8 | 10.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_065 |
232 | 0 | 3.53 | 6.04 | 10 | 0 | 7 | 10.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_066 |
153 | 0 | 17.12 | 4.45 | 9 | 0 | 14 | 6.43 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_067 |
175 | 0 | 5.71 | 7.66 | 32 | 0 | 12 | 5.83 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_068 |
135 | 0 | 6.67 | 10.51 | 103 | 0 | 13 | 6.15 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_069 |
131 | 0 | 6.41 | 9.91 | 12 | 0 | 16 | 10.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_070 |
167 | 0 | 9.04 | 9.04 | 1 | 0 | 12 | 10.83 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_071 |
208 | 0 | 7.16 | 11.88 | 14 | 0 | 12 | 7.50 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_072 |
225 | 0 | 6.98 | 11.61 | 26 | 0 | 24 | 4.17 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_073 |
316 | 0 | 7.97 | 10.60 | 79 | 0 | 26 | 4.23 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_074 |
261 | 0 | 6.74 | 13.11 | 1 | 0 | 31 | 4.52 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_075 |
292 | 0 | 9.59 | 14.07 | 22 | 0 | 24 | 7.08 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_076 |
316 | 0 | 7.03 | 14.11 | 11 | 0 | 46 | 4.78 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_077 |
470 | 0 | 18.55 | 10.78 | 15 | 0 | 60 | 7.67 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_078 |
371 | 0 | 8.63 | 14.12 | 21 | 0 | 74 | 3.92 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_079 |
439 | 0 | 10.39 | 12.75 | 24 | 0 | 92 | 3.91 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_080 |
380 | 0 | 6.89 | 15.77 | 73 | 0 | 88 | 3.75 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_081 |
435 | 0 | 6.51 | 14.08 | 54 | 0 | 102 | 4.80 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_082 |
347 | 0 | 5.82 | 15.54 | 7 | 0 | 42 | 5.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_083 |
276 | 0 | 4.82 | 17.38 | 23 | 0 | 2 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_084 |
262 | 0 | 8.66 | 18.90 | 43 | 0 | 1 | 10.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_085 |
288 | 0 | 12.60 | 17.15 | 15 | 0 | 3 | 3.33 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_086 |
332 | 0 | 10.12 | 15.26 | 7 | 0 | 6 | 3.33 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_087 |
368 | 0 | 13.37 | 13.91 | 16 | 0 | 3 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_088 |
349 | 0 | 11.81 | 14.32 | 16 | 0 | 5 | 4.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_089 |
485 | 0 | 10.37 | 11.34 | 0 | 0 | 1 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_090 |
448 | 0 | 9.84 | 14.14 | 32 | 0 | 2 | 5.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_091 |
663 | 0 | 9.74 | 11.96 | 24 | 0 | 122 | 4.02 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_092 |
649 | 0 | 10.14 | 12.32 | 0 | 0 | 104 | 4.71 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_093 |
583 | 0 | 5.90 | 14.06 | 9 | 0 | 115 | 4.52 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_094 |
539 | 0 | 6.09 | 14.52 | 0 | 0 | 120 | 4.08 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_095 |
651 | 0 | 9.66 | 11.85 | 16 | 0 | 103 | 5.44 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_096 |
688 | 0 | 11.77 | 11.20 | 15 | 0 | 128 | 6.48 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_097 |
655 | 0 | 11.08 | 11.82 | 6 | 0 | 125 | 7.20 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_098 |
654 | 0 | 11.02 | 10.94 | 31 | 0 | 139 | 5.76 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_099 |
711 | 0 | 10.76 | 9.97 | 7 | 0 | 155 | 5.55 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_100 |
657 | 0 | 14.00 | 10.91 | 19 | 0 | 167 | 5.93 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_101 |
541 | 0 | 8.74 | 13.34 | 19 | 0 | 150 | 5.40 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_102 |
633 | 0 | 9.56 | 11.42 | 21 | 0 | 182 | 5.44 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_103 |
667 | 0 | 7.53 | 11.26 | 34 | 0 | 174 | 4.66 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_104 |
658 | 0 | 9.04 | 11.47 | 13 | 0 | 168 | 5.24 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_105 |
625 | 0 | 9.79 | 11.83 | 26 | 0 | 172 | 5.41 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_106 |
771 | 0 | 12.91 | 9.44 | 22 | 0 | 214 | 6.45 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_107 |
601 | 0 | 8.39 | 11.87 | 19 | 0 | 192 | 5.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_108 |
790 | 0 | 12.19 | 8.92 | 15 | 0 | 201 | 5.27 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_109 |
598 | 0 | 7.63 | 11.54 | 18 | 0 | 201 | 4.98 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_110 |
818 | 0 | 11.44 | 8.41 | 4 | 0 | 181 | 5.80 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_111 |
698 | 0 | 10.73 | 9.50 | 18 | 0 | 187 | 6.26 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_112 |
676 | 0 | 10.59 | 8.60 | 12 | 0 | 196 | 5.77 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_113 |
758 | 0 | 12.30 | 7.93 | 26 | 0 | 188 | 7.61 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_114 |
600 | 0 | 8.92 | 9.44 | 13 | 0 | 171 | 5.56 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_115 |
598 | 0 | 8.60 | 9.57 | 11 | 0 | 202 | 4.85 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_116 |
684 | 0 | 11.65 | 7.93 | 6 | 0 | 201 | 5.62 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_117 |
733 | 0 | 14.43 | 7.18 | 6 | 0 | 208 | 6.11 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_118 |
663 | 0 | 14.34 | 7.79 | 24 | 0 | 170 | 6.29 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_119 |
605 | 0 | 10.35 | 8.63 | 11 | 0 | 198 | 4.75 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_120 |
626 | 0 | 11.45 | 8.29 | 9 | 0 | 220 | 4.86 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_121 |
641 | 0 | 14.43 | 8.55 | 23 | 0 | 217 | 5.44 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_122 |
602 | 0 | 11.88 | 8.85 | 12 | 0 | 204 | 5.59 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_123 |
571 | 0 | 13.20 | 9.14 | 10 | 0 | 204 | 5.34 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_124 |
740 | 0 | 15.09 | 6.99 | 16 | 0 | 184 | 6.90 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_125 |
631 | 0 | 14.88 | 8.23 | 10 | 0 | 208 | 5.48 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_126 |
716 | 0 | 15.27 | 7.25 | 22 | 0 | 212 | 5.80 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_127 |
593 | 0 | 13.47 | 8.73 | 20 | 0 | 226 | 5.04 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_128 |
502 | 0 | 8.94 | 10.01 | 23 | 0 | 209 | 5.41 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_129 |
676 | 0 | 15.00 | 7.19 | 8 | 0 | 223 | 5.20 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_130 |
749 | 0 | 13.77 | 6.54 | 34 | 0 | 208 | 5.82 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_131 |
605 | 0 | 11.22 | 7.58 | 24 | 0 | 199 | 5.23 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_132 |
622 | 0 | 12.97 | 7.58 | 21 | 0 | 201 | 5.72 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_133 |
602 | 0 | 11.98 | 8.04 | 29 | 0 | 216 | 5.23 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_134 |
697 | 0 | 11.46 | 7.90 | 30 | 0 | 182 | 5.77 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_135 |
1,474 | 0 | 22.27 | 4.89 | 44 | 0 | 267 | 9.66 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_136 |
1,542 | 0 | 14.48 | 5.72 | 40 | 0 | 277 | 8.23 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_137 |
1,220 | 0 | 12.83 | 6.23 | 49 | 0 | 470 | 4.02 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_138 |
1,173 | 0 | 17.20 | 7.11 | 61 | 0 | 325 | 6.43 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_139 |
439 | 0 | 15.63 | 8.97 | 0 | 0 | 62 | 6.77 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_140 |
189 | 0 | 5.61 | 12.70 | 0 | 0 | 30 | 3.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_141 |
188 | 0 | 6.76 | 13.38 | 0 | 0 | 25 | 4.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_142 |
157 | 0 | 5.99 | 9.55 | 1 | 0 | 33 | 3.03 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_143 |
151 | 0 | 5.76 | 9.07 | 0 | 0 | 29 | 3.10 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_144 |
193 | 0 | 5.39 | 7.34 | 1 | 0 | 25 | 2.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_145 |
264 | 0 | 16.44 | 4.71 | 1 | 0 | 49 | 2.24 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_146 |
201 | 0 | 3.38 | 6.48 | 2 | 0 | 30 | 3.33 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_147 |
141 | 0 | 3.26 | 7.09 | 0 | 0 | 13 | 2.31 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_148 |
121 | 0 | 2.89 | 8.02 | 11 | 0 | 24 | 2.50 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_149 |
90 | 0 | 4.00 | 9.22 | 3 | 0 | 13 | 0.77 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_150 |
94 | 0 | 6.70 | 18.07 | 0 | 0 | 17 | 1.76 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_151 |
77 | 0 | 5.06 | 10.57 | 0 | 0 | 18 | 2.22 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_152 |
116 | 0 | 6.55 | 14.83 | 7 | 0 | 12 | 0.83 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_153 |
147 | 0 | 6.73 | 19.49 | 0 | 0 | 18 | 2.22 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_154 |
186 | 0 | 12.85 | 19.46 | 0 | 0 | 14 | 2.14 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_155 |
168 | 0 | 11.49 | 16.24 | 3 | 0 | 18 | 1.67 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_156 |
152 | 0 | 14.41 | 11.98 | 0 | 0 | 18 | 3.89 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_157 |
465 | 0 | 23.85 | 7.17 | 0 | 0 | 18 | 1.11 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_158 |
95 | 0 | 6.95 | 16.62 | 0 | 0 | 15 | 1.33 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_159 |
212 | 0 | 11.51 | 12.96 | 0 | 0 | 14 | 2.86 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_160 |
349 | 0 | 24.30 | 9.61 | 0 | 0 | 16 | 1.88 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_161 |
585 | 0 | 26.43 | 7.02 | 0 | 0 | 11 | 1.82 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_162 |
537 | 0 | 25.10 | 4.52 | 0 | 0 | 15 | 2.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_163 |
342 | 0 | 22.66 | 9.04 | 0 | 0 | 19 | 1.05 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_164 |
612 | 0 | 27.88 | 5.04 | 0 | 0 | 17 | 3.53 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_165 |
309 | 0 | 24.66 | 9.89 | 0 | 0 | 0 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_166 |
634 | 0 | 20.77 | 5.14 | 0 | 0 | 119 | 2.35 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_167 |
84 | 0 | 7.26 | 24.52 | 0 | 0 | 0 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_168 |
72 | 0 | 7.64 | 28.44 | 0 | 0 | 0 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_169 |
72 | 0 | 9.58 | 28.44 | 0 | 0 | 0 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_170 |
45 | 0 | 7.78 | 28.44 | 0 | 0 | 0 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_171 |
44 | 0 | 7.50 | 29.07 | 0 | 0 | 0 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_172 |
18 | 0 | 6.67 | 21.56 | 0 | 0 | 0 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_173 |
41 | 0 | 8.05 | 28.10 | 0 | 0 | 0 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_174 |
72 | 0 | 7.08 | 18.18 | 0 | 0 | 14 | 3.57 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_175 |
378 | 0 | 23.25 | 8.12 | 0 | 0 | 10 | 4.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_176 |
288 | 0 | 5.14 | 7.99 | 0 | 0 | 118 | 1.86 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_177 |
358 | 0 | 3.55 | 4.84 | 0 | 0 | 139 | 2.95 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_178 |
284 | 0 | 4.51 | 8.88 | 5 | 0 | 126 | 1.98 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_179 |
905 | 0 | 15.38 | 5.19 | 0 | 0 | 238 | 2.65 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_180 |
78 | 0 | 7.18 | 27.90 | 0 | 0 | 0 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_181 |
40 | 0 | 8.00 | 28.75 | 0 | 0 | 0 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_182 |
268 | 0 | 2.80 | 1.07 | 0 | 0 | 113 | 2.65 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_183 |
279 | 0 | 3.30 | 5.09 | 0 | 0 | 116 | 2.67 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_184 |
20 | 0 | 2.50 | 1.00 | 0 | 0 | 0 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_185 |
19 | 0 | 4.74 | 1.00 | 0 | 0 | 0 | 0.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_186 |
706 | 0 | 17.35 | 6.29 | 0 | 0 | 69 | 3.48 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_187 |
144 | 0 | 28.06 | 22.79 | 0 | 0 | 9 | 6.67 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_188 |
56 | 0 | 8.93 | 22.77 | 0 | 0 | 6 | 6.67 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_189 |
288 | 0 | 31.49 | 8.35 | 0 | 0 | 6 | 10.00 |
EPMRANGE1 | /dev/vgepm3/rlvepm_data3_190 |
106 | 0 | 6.70 | 21.72 | 0 | 0 | 6 | 6.67 |
EPMTMP | /dev/vgepm1/rlvepm_temp1 |
87,737 | 24 | 25.12 | 9.34 | 14,101 | 4 | 0 | |
EPMTMP | /dev/vgepm1/rlvepm_temp2 |
85,241 | 24 | 25.81 | 7.07 | 7,418 | 2 | 0 | |
EPSA | /dev/vgepm1/rlvepsa_data01 |
131,746 | 36 | 2.32 | 9.61 | 124 | 0 | 493,756 | 2.15 |
EPSA | /dev/vgepm1/rlvepsa_data02 |
137,442 | 38 | 2.35 | 9.11 | 143 | 0 | 507,366 | 2.18 |
EPSA | /dev/vgepm1/rlvepsa_data03 |
145,988 | 40 | 2.41 | 8.45 | 245 | 0 | 533,021 | 2.20 |
EPSA | /dev/vgepm1/rlvepsa_data04 |
133,631 | 37 | 2.38 | 9.13 | 42 | 0 | 497,354 | 2.23 |
EPSA | /dev/vgepm1/rlvepsa_data05 |
128,702 | 36 | 2.14 | 9.59 | 34 | 0 | 487,326 | 2.10 |
EPSA | /dev/vgepm1/rlvepsa_data06 |
138,792 | 38 | 2.31 | 8.88 | 38 | 0 | 514,478 | 2.16 |
EPSA | /dev/vgepm1/rlvepsa_data07 |
133,940 | 37 | 2.49 | 9.25 | 32 | 0 | 494,228 | 2.31 |
EPSA | /dev/vgepm1/rlvepsa_data08 |
132,671 | 37 | 2.42 | 9.28 | 70 | 0 | 491,922 | 2.26 |
EPSA | /dev/vgepm1/rlvepsa_data09 |
134,356 | 37 | 2.23 | 9.17 | 18 | 0 | 491,671 | 2.12 |
EPSA | /dev/vgepm1/rlvepsa_data10 |
135,091 | 37 | 2.35 | 9.14 | 37 | 0 | 499,208 | 2.18 |
SYSAUX | /dev/vgsys/rlvsys_sysaux_01 |
2,755 | 1 | 5.31 | 2.84 | 2,586 | 1 | 659 | 3.10 |
SYSTEM | /dev/vgsys/rlvsys_system_01 |
2,867 | 1 | 5.01 | 1.00 | 1,713 | 0 | 90 | 2.67 |
TEMP | /dev/vgepm1/rlvepc_temp5 |
28,805 | 8 | 0.67 | 4.64 | 4,778 | 1 | 0 | |
TEMP | /dev/vgsys/rlvsys_temp1 |
5,340 | 1 | 1.54 | 19.71 | 4,159 | 1 | 0 | |
UNDOTBS1 | /dev/vgsys/rlvsys_undotbs1_1 |
0 | 0 | | | 3,940 | 1 | 52 | 0.00 |
UNDOTBS1 | /dev/vgsys/rlvsys_undotbs1_2 |
0 | 0 | | | 1,602 | 0 | 23 | 0.43 |
UNDOTBS1 | /dev/vgsys/rlvsys_undotbs1_3 |
0 | 0 | | | 1,330 | 0 | 7 | 0.00 |
UNDOTBS1 | /dev/vgsys/rlvsys_undotbs1_4 |
0 | 0 | | | 2,061 | 1 | 21 | 0.00 |
UNDOTBS1 | /dev/vgsys/rlvsys_undotbs1_5 |
0 | 0 | | | 1,454 | 0 | 9 | 0.00 |