DBMS_APPLICATION_INFO

• 각 세션별로 적절한 모듈명 (V$SESSION.MODULE) 또는 Client 정보 (V$SESSION.CLIENT_INFO)을 부여하여 테스트의 효율성을 높힐 때 사용한다.

SQL> exec dbms_application_info.set_module('module','action1');
SQL> select sid from v$session where module = 'module1';
SQL> exec dbms_application_info.set_client_info('client1');
SQL> select sid from v$session where client_info = 'client1';

• 테스트는 다음과 같다.

SQL >exec dbms_application_info.set_module('module1','action1');

PL/SQL procedure successfully completed.

SQL >select sid from v$session where module = 'module1';

       SID
----------
        10

SQL >exec dbms_application_info.set_client_info('client1');

PL/SQL procedure successfully completed.

SQL >select sid from v$session where client_info = 'client1';

       SID
----------
        10