Re: Urgent - Question on Auditing

"Dave Weeks" <dweeks_at_nospam.gnseurope.com> wrote in message news:9dgcne$m5i$1_at_reader-00.news.insnet.cw.net...
> Hi there,
>
> Things about auditing I've done on our 8.1.5. (Solaris 2.7) setup:
>
> 1) Moved sys.aud$ out of the SYSTEM tablespace and into TEMP.

And how, pray, did you manage to house a permanent table in a temporary tablespace?? Nice to move the aud$ table (it's practically obligatory if you've any sense, for exactly the reasons you go on to list), but I hope you have a proper temporary tablespace somewhere for sorts etc? This one definitely isn't, because otherwise the move would have failed.

Regards
HJR
>This will
> prevent SYSTEM from being fragmented by audit records being
> inserted/deleted.
> 2) Or, set the auditing to write to the OS instead of the database
 (this
> superceedes #1)
>
> 3) 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 Sat May 12 2001 - 02:00:43 CDT