Re: determine Oracle account last access time

From: Howard J. Rogers <howardjr_at_www.com>
Date: Tue, 9 Oct 2001 17:30:57 +1000
Message-ID: <3bc2c2fa@news.iprimus.com.au>

I can't agree with that answer. Every User's Server Process has to check whether or not they are *supposed* to be audited, even if they are not. Every Server Process has to take time out from any operation to check the audit_options that may have been set, just to check. If they're not being audited, then they proceed to do what the User wanted them to do. If they are, then they have to take time out to add to the audit trail.

Net result, every User is affected by switching auditing on. They'll all notice it.

Regards
HJR "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:ts3nop2b51qo42_at_news.demon.nl...
>
> "Orna Berlinsky" <ornab_at_amdocs.com> wrote in message
> news:4e2fb3ee.0110072332.3bacabf9_at_posting.google.com...
> > thanks guys,
> >
> > I was concerned about the perfirmance impact of enabling auditing.
> > What should I expect in this case - will my users suffer ?
> >
> > Orna
>
>
> As you are not auditing any select, inserts, updates and deletes, and
audit
> will insert/update only 2 records, your users won't *notice* it.
>
> Regards,
>
> Sybrand Bakker,
> Senior Oracle DBA
>
>
>
Received on Tue Oct 09 2001 - 02:30:57 CDT