ORA-1693: max # extents 505 error Solution

This morning, the alert. log of erp db suddenly ran out of N multi-ORA-1693 error.

ARC1: Completed archiving log 1 thread 1 sequence 343118 Fri Sep 9 09:52:55 2011

ORA-1693: max # extents 505 reached in lobsegment APPLSYS. SYS_LOB0001182584C00040 $

ORA-1693: max # extents 505 reached in lobsegment APPLSYS. SYS_LOB0001182584C00040 $

ORA-1693: max # extents 505 reached in lobsegment APPLSYS. SYS_LOB0001182584C00040 $

ORA-1693: max # extents 505 reached in lobsegment APPLSYS. SYS_LOB0001182584C00040 $

ORA-1693: max # extents 505 reached in lobsegment APPLSYS. SYS_LOB0001182584C00040 $

ORA-1693: max # extents 505 reached in lobsegment APPLSYS. SYS_LOB0001182584C00040 $

ORA-1693: max # extents 505 reached in lobsegment APPLSYS. SYS_LOB0001182584C00040 $

ORA-1693: max # extents 505 reached in lobsegment APPLSYS. SYS_LOB0001182584C00040 $

ORA-1693: max # extents 505 reached in lobsegment APPLSYS. SYS_LOB0001182584C00040 $

ORA-1693: max # extents 505 reached in lobsegment APPLSYS. SYS_LOB0001182584C00040 $

ORA-1693: max # extents 505 reached in lobsegment APPLSYS. SYS_LOB0001182584C00040 $

ORA-1693: max # extents 505 reached in lobsegment APPLSYS. SYS_LOB0001182584C00040 $

ORA-1693: max # extents 505 reached in lobsegment APPLSYS. SYS_LOB0001182584C00040 $

ORA-1693: max # extents 505 reached in lobsegment APPLSYS. SYS_LOB0001182584C00040 $

ORA-1693: max # extents 505 reached in lobsegment APPLSYS. SYS_LOB0001182584C00040 $

 

After querying the information on the Internet, I have consulted the Development Department. It should be caused by a request submitted by the Development Department. The solution is as follows:

1. query the maxextents of the existing table

Bytes -------------------------------------------------------------------------------------

Select owner, segment_name, segment_type, tablespace_name, extents, max_extents

From dba_segments

Where segment_name = 'sys _ LOB0001182584C00040 $ ';

2. Check the tables and fields that cause the sequence partition.

Bytes --------------------------------------------------------------------------------------------

Select owner, table_name, column_name, segment_name

From dba_lobs

Where segment_name = 'sys _ LOB0001182584C00040 $ ';

3. Increase maxextents

Bytes ---------------------------------------------------------------------------------------

Alter table APPLSYS. wf_icationication_out modify lob (USER_DATA.TEXT_LOB) (storage (maxextents 2048 ));

Bytes ---------------------------------------------------------------------------------------------

OK after modification