Oracle Database Discussions

Hi all,

In my PROD so many times I found that the tatol size of a tablespace remains is fair enough but the largest chunks availabe is very less and becouse of that it happens that a transaction fails and gives error in alert log file like:

ORA-1654: unable to extend index APPS.RCV_RECEIVING_SUB_LED_N3 by 27310 in tablespace GLD

and as a workaround I need to resize it database / add datafile and issue resolved.

But before add/resize of datafile when I checked the datafile free space available and the largest chunk is found:

select TABLESPACE_NAME,
sum(BYTES/1024/1024) Total_free_space,
max(BYTES/1024/1024) largest_free_extent
from dba_free_space
where tablespace_name='GLD'
group by TABLESPACE_NAME;

TABLESPACE_NAME TOTAL_FREE_SPACE LARGEST_FREE_EXTENT

GLD 5516.0546875 9.765625

I thin 5516 MB of free space is fair enough for a tbs. but still I am getting error to this tbs.

can any body give any idea what wrong with this.

Thanks in ADV !