Re: Audit command help

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 12 Mar 2004 23:19:18 +1100
Message-ID: <4051aacd$0$31901$afc38c87@news.optusnet.com.au>

"Teresa Redmond" <NJZLIRWUWYGI_at_spammotel.com> wrote in message news:fe7f277866575feec511d152e1727005_at_news.teranews.com...
> On 8 Mar 2004 23:01:05 -0800, in comp.databases.oracle.server,
> srivenu_at_hotmail.com (srivenu) scribbled:
>
> >If you use extensive auditing, you may want to use large extent sizes
> >for SYS.AUD$ table and may move it to a different tablespace.
>
> I'll look in to that, but I really am hoping for this to NOT be too
> big. But we'll see. Thanks!

Well, I wouldn't look into it too deeply. Extent sizes have nothing to do with anything. Since SYS.AUD$ is a data dictionary table, the extent sizes are already fixed at the time of database creation. You can always issue an 'alter table' of course, but then you can kiss goodbye to your support contract with Oracle.

Likewise, moving AUD$ out of the system tablespace is recommended by Oracle, but is not actually supported. (Go figure!).

Regards
HJR Received on Fri Mar 12 2004 - 06:19:18 CST