Moving aud$ or fga_log$ to a different tablespace

If you are doing auditing (traditional or fine grained auditing), then the internal audit tables aud$ or fga_log$, which are by default in the system tablespace, are getting bigger and bigger over time. So you may want to move them into another tablespace – but that was unsupported in the past. No longer so, as Joel Goodman explains in this recent article:

About these ads
  1. #1 by Joel Goodman on May 15, 2009 - 09:58

    Uwe – thanks for pointing DBAs to this.

    Joel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 2,429 other followers

%d bloggers like this: