[Oracle] Set module 정리

https://oracle-base.com/articles/8i/dbms_application_info#set_action 참고

블로그에 있는 오라클 프로시저 샘플을 만든 뒤

DECLARE
   o_username DBUSER.USERNAME%TYPE;
   o_createdby DBUSER.CREATED_BY%TYPE;
   o_date DBUSER.CREATED_DATE%TYPE;
BEGIN
   DBMS_APPLICATION_INFO.set_module(module_name => 'add_order',
                                   action_name => 'insert into orders');
   DBMS_APPLICATION_INFO.set_action(action_name => 'insert into order_lines');
   getDBUSERByUserId(1001,o_username,o_createdby,o_date);

   DBMS_OUTPUT.PUT_LINE('username :  ' || o_username);
   DBMS_OUTPUT.PUT_LINE('createdby :  ' || o_createdby);
   DBMS_OUTPUT.PUT_LINE('createddate :  ' || o_date);

END;
/

set module , set action 을 추가한 후 v$session view 를 검색해보면 위 프로시저가 등록되있음.