Oracle experts, I am getting the following message in the alert log:
ORA-1691: unable to extend lobsegment NAVIGATOR.SYS_LOB0000058142C00004$$ by 128 in tablespace RNJE_LOB ORA-1691: unable to extend lobsegment NAVIGATOR.SYS_LOB0000058142C00004$$ by 8192 in tablespace RNJE_LOB
I have checked the dba_tablespace_usage_metrics and the TS is 99% used, there are 4 datafiles associated with this TS. I have checked the web for a resolution as I am not an Oracle DBA, and did not find a way to determine exactly which file is under stress, also whether doing a coalesce, extending the file or creating a new datafile was the answer. any help or direction would be greatly appreciated. Regards
You can try something like
to find the detailed information. Based upon the MAXSIZE and AUTOEXTEND property you can sort out what to do. Locally Managed tablespaces generally do not need to coalesce free extents. And since you have already said that it is 99 percent full so most probably the Extension of the data file size is required.
Generally, people stay away from adding a new data file, as this could mean more administrative cost and if added, then as per best practice a backup should be done immediately. Hope it helps.
answered Jan 26, 2012 at 04:05 AM