cancel
Showing results for 
Search instead for 
Did you mean: 

Check DB alert

Former Member
0 Kudos

Hi,

I recentl upgraded my database to 10.2.0.4. when i run the checkdb i get the following warnings messages.

BR0970W Database administration alert - level: WARNING, type: CRITICAL_SEGMENT, object: (index) SAPR3.CDCLS~0, value: 163840 KB * 2 / PSAPCLUI

BR0970W Database administration alert - level: WARNING, type: CRITICAL_SEGMENT, object: (table) SAPR3.RFBLG, value: 655360 KB * 2 / PSAPCLUD (

Please help

Regards,

siddhartha.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

1)Is there any way to find whether the tablespace is locally manged of dictionary managed?

2)Extending the tablespace is the only available solution to this problem?

Thanks

siddhartha

Former Member
0 Kudos

Hi,

Yes,Extending the tablespace is the only available solution to this problem.

It is more specific to disk free space if unix the volume free space.Add disk or increase the volume size.

Regards

Ashok

Edited by: Ashok Dalai on Aug 18, 2008 11:56 AM

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks for the quick response.

What am i to do here?

Do i need to extend the tablespace?

Also, in DB02 i get lots of space critical objects?

Please help.

cc.Stefan: That particular link is not getting displayed properly. The right side of the web page is getting cut.

If u don mind can u please explain it again for me here.

Thanks,

siddhartha.

Former Member
0 Kudos

Hi siddhartha,

You can extend the table space using BRTOOLS or at oracle level.

alter tablespace <tablespace name>

add datafile <path with datafile name> size <100m> autoextend off;

Give the complete path where you want to add the datafile with file name.

EX 'c:\xx\sth_04.dbf'

Give the size to your requirement.

To use BRTOOLS open a command prompt and execute brtools..

You will get the option altertablespace,then you can follow the next options.

Regards

Ashok

stefan_koehler
Active Contributor
0 Kudos

Hello,

just check this thread:

Regards

Stefan

Former Member
0 Kudos

Hi siddhartha,

I think you have critical objects in your database.Check this in t-code db02.

index SAPR3.CDCLS~0 will overflow in table space PSAPCLUI

table SAPR3.RFBLG will overflow in tablespace PSAPCLUD

check the available space in table spaces PSAPCLUI and PSAPCLUD and extend it adding data file to these.

Regards

Ashok