ORA-1691: unable to extend lobsegment
From: Nik Tek <niktek2005_at_gmail.com>
Date: Tue, 24 Jun 2014 12:52:38 -0700
Message-ID: <CAHySzWWq65hf3_RvodZmwCugqE0OYBthA3Bnm4-ovJSm+kAtdw_at_mail.gmail.com>
Hi DB gurus,
Date: Tue, 24 Jun 2014 12:52:38 -0700
Message-ID: <CAHySzWWq65hf3_RvodZmwCugqE0OYBthA3Bnm4-ovJSm+kAtdw_at_mail.gmail.com>
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
--- ---------------------------------------------------------------------------Received on Tue Jun 24 2014 - 21:52:38 CEST
/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 -- http://www.freelists.org/webpage/oracle-l