That kind of falls under the 'closing the door after the cow is out'
philosophy. AUD$ isn't the problem now and it wasn't until someone
went nuts turning it on to such a ridiculous level. The problem is it
extended and then other sys tables extented after it and now I have
several hundred meg free chunks of space in the middle of the file.
- Brian
- "Weaver, Walt" <wweaver_at_rightnowtech.com> wrote:
> Why don't you move the AUD$ table out of the system tablespace?
>
> --Walt Weaver
> Bozeman, Montana, USA
>
> -----Original Message-----
> Sent: Thursday, August 17, 2000 2:59 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Another "DBA" turned on select auditing for all tables in our
> production warehouse because he and a couple others thought it was
> the
> best way to capture some statistics. Within a matter of an hour or
> so
> the auditing table grew to several hundred meg, fragmented up our
> system tablespace and slowed down our loads considerably. AUD$ became
> quite the bottleneck. Now we have a system tablespace that is 487M
> with 403M free. Autoextend on, no maxsize - another philosophy that
> abounds here. I could go on but...
>
> - Brian
> --
> Author: Weaver, Walt
> INET: wweaver_at_rightnowtech.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
Received on Fri Aug 18 2000 - 09:35:36 CDT
