on 08-18-2008 8:48 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.