I always recommend to our developers to make extensive use of
DBMS_APPLICATION_INFO. As far I know there are three main columns on
V$SESSION that are updated when using DBMS_APPLICATION_INFO:
SQL> exec dbms_application_info.set_client_info (CLIENT_INFO => 'MY
PROCESS');
SQL> exec dbms_application_info.set_module (MODULE_NAME => 'MY
MODULE', ACTION_NAME => 'ACTION_01');
SQL>
SQL> SELECT CLIENT_INFO, MODULE, ACTION FROM v$session WHERE audsid =
USERENV('SESSIONID');
CLIENT_INFO MODULE ACTION
-------------------- -------------------- --------------------
MY PROCESS MY MODULE ACTION_01
SQL>
SQL> exec dbms_application_info.set_action (ACTION_NAME => 'ACTION
02');
SQL>
SQL> SELECT CLIENT_INFO, MODULE, ACTION FROM v$session WHERE audsid =
USERENV('SESSIONID');
CLIENT_INFO MODULE ACTION
-------------------- -------------------- --------------------
MY PROCESS MY MODULE ACTION 02
SQL> SELECT CLIENT_INFO, CLIENT_IDENTIFIER, MODULE, ACTION FROM v$session
WHERE audsid = USERENV('SESSIONID');
CLIENT_INFO CLIENT_IDENTIFIER MODULE ACTION
-------------------- -------------------- --------------------
--------------------
MY PROCESS MY PROCESS AGAIN MY MODULE ACTION 02
v$active_session_history where rownum <=1;
SELECT CLIENT_INFO, CLIENT_IDENTIFIER, MODULE, ACTION FROM
v$active_session_history where rownum <=1
*
ERRO na linha 1:
ORA-00904: "CLIENT_IDENTIFIER": identificador inválido
SQL> SELECT CLIENT_INFO, CLIENT_ID , MODULE, ACTION FROM
v$active_session_history where rownum <=1;
SELECT CLIENT_INFO, CLIENT_ID , MODULE, ACTION FROM
v$active_session_history where rownum <=1
*
ERRO na linha 1:
ORA-00904: "CLIENT_INFO": identificador inválido
SQL> SELECT CLIENT_ID , MODULE, ACTION FROM v$active_session_history where
rownum <=1;
CLIENT_ID MODULE
ACTION
----------------------------------------------------------------
-------------------- --------------------
93316716
REGISTROSOLIC_TAP SOLICITACAO_TAP