oracle如何得到mos,【翻译自mos文章】如何获得Oracle Database 12c中的audit session id

【翻译自mos文章】怎么获得Oracle Database 12c中的audit session id

怎么获得Oracle Database 12c中的audit session id

来源于：

How to obtain audit session ID in Oracle Database 12c (文档 ID 2016845.1)

适用于：

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later

Information in this document applies to any platform.

解决方案：

在Oracle database 12c之前，audit session id 是基于AUDSES$这个序列的，在oracle  database 12c中，只要Unified Auditing被关闭，audit session id 依然是基于AUDSES$这个序列的

SQL> conn vlad/vlad

Connected.

SQL> select value from v$option where parameter='Unified Auditing';

VALUE

----------------------------------------------------------------

FALSE

SQL> select last_number from dba_sequences where sequence_name='AUDSES$';

LAST_NUMBER

-----------

290016

SQL> select audsid from v$session where username='VLAD';

AUDSID

----------

290016

SQL> select SYS_CONTEXT('USERENV', 'SESSIONID') from dual;

SYS_CONTEXT('USERENV','SESSIONID')

--------------------------------------------------------------------------------

290016

Unified Auditing被启用，the audit session ID不在是基于序列的了，the audit session ID是随机生成的。

SQL> select value from v$option where parameter='Unified Auditing';

VALUE

----------------------------------------------------------------

TRUE

SQL> conn vlad/vlad

Connected.

SQL> select sys_context('userenv','UNIFIED_AUDIT_SESSIONID') from dual;

SYS_CONTEXT('USERENV','UNIFIED_AUDIT_SESSIONID')

--------------------------------------------------------------------------------

137315960

SQL> conn vlad/vlad

Connected.

SQL> select sys_context('userenv','UNIFIED_AUDIT_SESSIONID') from dual;

SYS_CONTEXT('USERENV','UNIFIED_AUDIT_SESSIONID')

--------------------------------------------------------------------------------

2041291097

SQL> conn vlad/vlad

Connected.

SQL> select sys_context('userenv','UNIFIED_AUDIT_SESSIONID') from dual;

SYS_CONTEXT('USERENV','UNIFIED_AUDIT_SESSIONID')

--------------------------------------------------------------------------------

1706600580