Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent - Question on Auditing
Hi Howard,
The powers that be wanted Oracle on an A1000 with bags of memory for their piss-poor application that will be doing 1 sort every blue moon. Therefore, our TEMP tablespace is not of the 'temporary' variety at all but just a dumping ground for storing DBA-temporary objects (like sys.aud$ and dba.random_experiments).
Yes, you are correct that it's the norm to have a proper temporary tablespace for sorts (where else would Oracle do large sorts?) and sys.aud$ should be moved to a new tablespace (e.g. audit_tab).
Incidentally, the article I linked to says:
"You cannot move SYS.AUD$ to another tablespace as a means of controlling the growth and size of the audit trail."
Hmmm.....
Dave Weeks.
Howard J. Rogers <howardjr_at_www.com> wrote in message
news:3afcdfa2_at_news.iprimus.com.au...
>
> "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 Mon May 14 2001 - 06:10:54 CDT