on 10-11-2010 11:15 AM
BR0970W Database administration alert - level: WARNING, type: MANY_EXTENTS, object: (table) SYS.AUD$, value: 94.65% (> 80%)
Any idea How to resolve this alert in DB 13
R/3 Release 4.6C
ORACLE-10.2.0.2.0
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
your object is close to reaching it's max configured extents.
Mark
Is there any way to resolve it ..it is in SYSTEM tablespace
Hi,
Yes it's a SYSTEM table object........ As your on 4.6C Can you use sapdba from the operating system ? as this has some nic functionality to check.
>
> Is there any way to resolve it ..it is in SYSTEM tablespace
You are no longer on Oracle 7.
You can adjust max and next. To get rid of the warning, there are some _exclude parameters for initSID.sap.
And you can Bump Up Alert thresholds in DB17.
Since ORACLE 10 you can even recreate the SYSTEM TS with brtools, i.e. to do a LMTS migration
for the SYSTEM TS. It uses transportable tablespaces to re-attach the data - spaces after the recreation.
Concluding from the name, the table belongs to some auditing stuff. May be you'll find some
Information how to reorganize it on oracle level. May be some dbms_audit* stuff to handle this.
Volker
it is system audit table for database
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.