Re: Urgent - Question on Auditing

From: Dave Weeks <dweeks_at_nospam.gnseurope.com>
Date: Fri, 11 May 2001 10:38:11 +0100
Message-ID: <9dgcne$m5i$1@reader-00.news.insnet.cw.net>

Hi there,

Things about auditing I've done on our 8.1.5. (Solaris 2.7) setup:

Moved sys.aud$ out of the SYSTEM tablespace and into TEMP. This will prevent SYSTEM from being fragmented by audit records being inserted/deleted.
Or, set the auditing to write to the OS instead of the database (this superceedes #1)
Read http://w3.uqah.uquebec.ca/ORACLE/server.805/a58397/ch22.htm#1108 (take an hour to read it all)

Best regards,

Dave Weeks.

Balachandra Rao <bprao_at_worldnet.att.net> wrote in message news:BHBK6.15073$4f7.1182444_at_bgtnsc06-news.ops.worldnet.att.net...
> Hi ,
> We have oracle 8.1.6 running on NT. Our dba started the auditing on
> (connections) but we found the system slowing down. He stopped auditing
by
> changing the parameter in init.ora file to false. Our query in sys.aud$
> table shows no increase in records after changing the parameter. Is this
> the only step to be taken to stop auditing.
> If not what are the other steps required.
>
> Thanks in advance.
> BPR
>
>
Received on Fri May 11 2001 - 04:38:11 CDT