hi....space critical objects in DB02

[Former Member]

hi all,

i am findind sapce critical object in DB02.

even it have 13% free space. (87 % full).

tablespace.name is : PSAPCLUD.

object RFBLG

Freespace /KB. maximun 164,880

total 665.488

next extent /kb 327.680.

how to solve this problem...

Regards,

swathi

[Former Member · Accepted solution]

Hi,

the error is clear:

The tablespace PSAPCLUD has 665.488Kb Free space.

But, you have to keep in mind that an extent requires not only free space, but it has to be contiguous ( oracle does not allocate an extent in "chunks" on diferent locations )

So, the biggest group of free contiguous space is 164,880

The table RFBLG has a next extent of 327.680 that is bigger than the maximum contiguous free space, therefore Oracle will not be able to allocate the extent.

Solution -> Increase the contiguous free space by adding a new datafile.

quick workaround -> reduce the NEXT EXTENT for the table RFBLG so it fits the available free space.

[Former Member]

Hi Swati,

Please check the tablespace properties by using BRTOOLS utility. Check for Autoextent, is it enables or not?

The option for this is to add a new datafile in this tablespace.

You can do this by doing following steps:

Try to add the datafile, as the autoextension is off.

You can do this by the help of SAPDBA/BRTOOLS.

You would get the stuff related to BRTOOLS in hep.sap.com portal.

Just go thorugh this link

, may be it would help you out a bit.

If you get error in starting the brtools, just check the environmental variables like ORACLE_SID, ORACLE_HOME etc.

The other option is to reorg the tablespace.

That can be achieved by using the Brtools utility also.

Thanks