21 lines
707 B
SQL
21 lines
707 B
SQL
col ii_service_name head SERVICE_NAME for a20
|
|
col ii_module head MODULE for a32
|
|
col ii_action head ACTION for a32
|
|
col ii_client_identifier head CLIENT_IDENTIFIER for a32
|
|
col ii_client_info head CLIENT_INFO for a32
|
|
|
|
select
|
|
userenv('SID') sid ,
|
|
userenv('SESSIONID') audsid,
|
|
'0x'||trim(to_char(userenv('SID'), 'XXXX')) "0xSID",
|
|
'0x'||trim(to_char(userenv('SESSIONID'), 'XXXXXXXX')) "0xAUDSID",
|
|
service_name ii_service_name,
|
|
client_identifier ii_client_identifier,
|
|
module ii_module,
|
|
action ii_action,
|
|
client_info ii_client_info
|
|
from
|
|
-- v$session where audsid = sys_context('USERENV', 'SESSIONID')
|
|
v$session where sid = sys_context('USERENV', 'SID')
|
|
/
|