| aud$table becomes large size [message #62050] |
Tue, 22 June 2004 03:52  |
ramya
Messages: 87
Registered: August 2002
|
Member |
|
|
i had an aud$ table
its size now around 1.3gb
db in oracle 7.3
i want to delete some records
to clear some space is there any problems
b cos of its on system tablespace
now the system tablespace have less space
how to clear some space
with regards
ramya
|
|
|
|
|
|
| Re: aud$table becomes large size [message #62054 is a reply to message #62051] |
Tue, 22 June 2004 13:57  |
ramya
Messages: 87
Registered: August 2002
|
Member |
|
|
what r the precautions i have to take
be cos its asys owned table
its around 1.3 gb can i delete
some records less than a certian date
then keep some records
without going to exp and truncate
with regards
ramya
|
|
|
|
| Re: aud$table becomes large size [message #62067 is a reply to message #62054] |
Wed, 23 June 2004 04:34 |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Deleting rows will not release space allocated to the AUD$ segment. You need to DROP/CREATE or TRNCATE this table. This is clearly documented in the Administrators guide.
Best regards.
Frank
|
|
|
|
| Re: aud$table becomes large size [message #62068 is a reply to message #62067] |
Wed, 23 June 2004 05:02 |
ramya
Messages: 87
Registered: August 2002
|
Member |
|
|
but when i checked
its become large wihting 2 days
how it will becoming like this
its in system
so its affecting the perofmance of the db
how to track down it why its became big within 2 to 3 days
with regards
ramya
|
|
|
|
| Re: aud$table becomes large size [message #62071 is a reply to message #62068] |
Wed, 23 June 2004 06:38 |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
You are auditing too much. Scale down on what you are auditing.
Again, please read the Oracle Administrators Guide (especially the section on "Keep Audited Information Manageable") as this is all very well documented.
Best regards.
Frank
|
|
|
|
| Re: aud$table becomes large size & redo log contention [message #62080 is a reply to message #62071] |
Wed, 23 June 2004 21:38 |
ramya
Messages: 87
Registered: August 2002
|
Member |
|
|
thnaks sir
i had one more dougght there is a redo log contention
in this db i incresed the log_buffer but not much improvements the system tablesapce freespace is now only 185 mb sthe size is 2 gb.is there any affect of this auditing and aud table becomes 1.3 gb.
my question is wheter this auding will give more redo contention how to eliminate the redo contention
anything ihave to do with auditing
with regards
ramya
|
|
|
|
| Re: aud$table becomes large size & redo log contention [message #62239 is a reply to message #62080] |
Tue, 06 July 2004 22:03 |
Satheesh Babu.S
Messages: 35
Registered: July 2004
|
Member |
|
|
it's better to move the auditing information to other tablespace. Please find the metalink note: 72460.1 for more on that. Redo log contention can happen for many reason. Your lgwr is slow or arch & lgwr is contending for each other. There could be many other.
Thanks and Regards,
Satheesh Babu.S
Bangalore.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
