Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SYS.AUD$ table

591075May 9 2008 — edited May 9 2008
Hi,

I started audit on a production system with the command "audit session" and at a moment in the morning all the users could not enter in the system. I stop the audit with the command "noaudit session" and the users coud enter into the system.

In this momement the SYSTEM tablespace is occupied in proportion of 87%.

THe parameters of SYS.AUD$ table are in this moment:

BYTES: 44261376
BLOCKS:10806
EXTENTS:19
INITIAL_EXTENT:12288
NEXT_EXTENT:22093824
MAX_EXTENTS:249

SYS.AUD$ table has 210000 lines in this moment.

Now I want to start again the audit by session. What I have to do not to block the users?

Thank you,

Mihaela
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2008
Added on May 9 2008
13 comments
2,665 views