ORA-1691: unable to extend lobsegment
- From: Nik Tek <niktek2005@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>, niktek2005@xxxxxxxxx
- Date: Tue, 24 Jun 2014 12:52:38 -0700
Hi DB gurus,
I have been recently noticing "ora-1691" error very frequently
ORA-1691: unable to extend lobsegment XADMIN.SYS_LOB0000348670C00005$$ by
128 in tablespace USERS
SELECT FILE_NAME,(bytes/1024/1024) MB_SIZE, AUTOEXTENSIBL, MAXBYTES
FROM DBA_DATA_FILES
WHERE TABLESPACE_NAME = 'USERS';
FILE_NAME MB_SIZE AUTOEXTENSIBLE MAXBYTES
---
---------------------------------------------------------------------------
/data01/app/oracle/oradata/STDB/users01.dbf 32767.5 YES 32768
/data01/app/oracle/oradata/STDB/users02.dbf 15360 YES 0
I was wondering to set the init parameter RESUMABLE_TIMEOUT = 20
ALTER SYSTEM SET RESUMABLE_TIMEOUT = 20;
Is this a good approach to handle this error in production?
Something wrong in the data/application code of not able to handle a insert
statement.
--
Thank you
NikTeki
Other related posts:
