CREATE OR REPLACE TRIGGER ip_look AFTER LOGON ON DATABASE
DECLARE ipinfo VARCHAR2(30);
BEGIN
SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') INTO ipinfo FROM DUAL;
DBMS_APPLICATION_INFO.SET_CLIENT_INFO(ipinfo);
END;
/
'Oracle_Script' 카테고리의 다른 글
estd_interconnect_traffic check procedure (0) | 2013.06.27 |
---|---|
통계정보 수집할 대상 테이블 조회 (0) | 2013.01.07 |
Archive Redo Log File Size & Rman Backup File Size (0) | 2012.10.31 |
Lock_Session_Monitoring (0) | 2012.07.17 |
DB backup script (0) | 2011.07.31 |