BR0970W Database Alert type: CRITICAL_TABLESPACE : MAX EXTENT

After DB13 – CHECKDB operation we could see the message like below ;

“BR0970W Database administration alert – level: WARNING, type: CRITICAL_FILE, object: N:\ORACLE\SID\SAPDATA3\ROLL_3\ROLL.DATA3, value: (max_extn) 146021 KB (> 111239 KB)”.

The reason of this warning ;

Size of the freespace on filesystem is lower than the maximum size of the DATAFILE defination

So we can do easly two things to eliminate this warning ;

1 – Increase the filesystem “FREESPACE” size.

2 – Reduce the size of “MAXIMUM Size Defination” for the releated DATAFILE.

We can eliminate the warning message via following SQL Syntax for our case ;

ALTER DATABASE  DATAFILE ‘N:\ORACLE\SID\SAPDATA3\ROLL_3\ROLL.DATA3′ AUTOEXTEND ON MAXSIZE 100000 K;

Now MAXSIZE : 100000K

Now CheckDB will be GREEN…..

 

Leave a Reply


− three = 3

Blogroll