session monitoring 썸네일형 리스트형 [ODI 11g] ODI SESSION MONITORING VIEW -- it is sql for monitoring all ODI Sessions status for 5 days fromODI Repository tables based SNP_SESSION and SNP_PLAN_AGENT.-- if you need, get it.-- it contains the session info not loadplan-- it is based of ODI 11.1.1.7.0 repository-- written by cheon on 2015/06/12 CREATE OR REPLACE VIEW V_ETL_MNT AS WITH A AS (SELECT SCEN_NAME, SCEN_VERSION, MAX(SESS_BEG) SESS_BEG , MAX(DECODE(RN,1,SESS_STA.. 더보기 이전 1 다음