Re: Auditing question
From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Wed, 19 Jan 2011 10:27:26 +0530
Message-ID: <AANLkTimSo0jxhKY_TL-HF2Vzg8Op0HOH71fxdx-BEw9w_at_mail.gmail.com>
how dba audit is enabled, at statement, user or database level !
Date: Wed, 19 Jan 2011 10:27:26 +0530
Message-ID: <AANLkTimSo0jxhKY_TL-HF2Vzg8Op0HOH71fxdx-BEw9w_at_mail.gmail.com>
how dba audit is enabled, at statement, user or database level !
the purpose of each v$view is/are different...v$session will inform inly about current session where as dba_audit_session will have record only if audit trail is enabled
On 19 January 2011 01:19, Goulet, Richard <Richard.Goulet_at_parexel.com>wrote:
> This one is driving me crazy. If I count the number of sessions from
> v$session that a particular user has and then look in dba_audit_sessions for
> the corresponding audit records they do not match. I'm short about 40
> records.
>
> Dick Goulet
> Senior Oracle DBA
>
>
-- ============================== DO NOT FORGET TO SMILE TODAY ============================== -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 18 2011 - 22:57:26 CST