Re: Urgent - Question on Auditing

Sybrand,

Where is this temp tablespace used for anyway? We got a development environment here, and this TS is only 10 MB, and doesn't seem to be used. Just curiosity!

Regards,
Patrick Sinke,
Cap Gemini Ernst & Young, sector Financial Services.

Sybrand Bakker <postbus_at_sybrandb.demon.nl> schreef in berichtnieuws tfnjchpf3cc86b_at_beta-news.demon.nl...
> Moving it in the TEMP tablespace is unfortunately a *very bad* idea.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> "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. 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 Fri May 11 2001 - 07:34:15 CDT