Database Reference
In-Depth Information
Next, module, action, and client identifier are set.
DBB> begin
dbms_application_info.set_module('taf_mod', 'taf_act');
dbms_session.set_identifier('taf_ident');
end;
/
1 Row(s) Processed.
Since
SELECT_CATALOG_ROLE
is not a default role of APP_USER, it must be enabled with a
SET
ROLE
statement before
V$SESSION
may be accessed. Furthermore, the NLS date format is changed.
DBB> SET ROLE select_catalog_role
/
0 Row(s) Processed.
DBB> ALTER SESSION SET nls_date_format='dd. Mon yy hh24:mi'
/
0 Row(s) Processed.
DBB> SELECT sid, serial#, audsid, logon_time, client_identifier, module, action
FROM v$session
WHERE username='APP_USER'
/
Row 1 fetched. Hit enter to continue fetching ...
SID SERIAL# AUDSID LOGON_TIME CLIENT_IDENTIFIER MODULE ACTION
--- ------- ------ ---------------- ----------------- ------- -------
116 23054 110007 05. Aug 07 14:40 taf_ident taf_mod taf_act
1 Row(s) processed.
Take note that the client was assigned session 116, session serial number 23054, and auditing
session identifier
4
110007. The auditing identifier is formed by selecting
NEXTVAL
from the sequence
SYS.AUDSES$
at session establishment. The auditing identifier uniquely identifies a session for
the lifetime of a database and is saved in
DBA_AUDIT_TRAIL.SESSIONID
if any auditing on behalf
of the session occurs. The date format of the session includes the month name. Client identi-
fier, module, and action were communicated to the DBMS. Querying failover-related columns
in
V$SESSION
confirms that TAF is switched on for the session.
DBB> SELECT failover_type, failover_method, failed_over
FROM v$session
WHERE username='APP_USER'
/
Row 1 fetched. Hit enter to continue fetching ...
FAILOVER_TYPE FAILOVER_METHOD FAILED_OVER
------------- --------------- -----------
SELECT BASIC NO
1 Row(s) processed.
The session auditing identifier
V$SESSION.AUDSID
may also be retrieved with the following statement:
SELECT userenv(sessionid)
FROM
dual
.
4.