Re: ORA-1691: unable to extend lobsegment
- From: De DBA <dedba@xxxxxxxxxx>
- To: niktek2005@xxxxxxxxx
- Date: Wed, 25 Jun 2014 10:42:47 +1000
I'm puzzled by the maxbytes = 0 on the second file. If you set maxsize to
unlimited, in my experience, this should be 32768MB as well... It seems to me
that effectively the second file is not further autoextensible.
Cheers,
Tony
On 25/06/14 05:52, Nik Tek wrote:
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:
