ORA-1693: max # extents 505 错误解决办法
ORA-1693: max # extents 505 错误解决办法
今天上午erp db的alert.log 突然跑出N多ORA-1693错误一开始有点蒙
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$$
网上查询了一下信息 有咨询了一下开发部门 应该是开发部门提交一个request 引起的，解决办法如下
1.查詢現在的表的 maxextents
-------------------------------------------------------------------------------------
select owner,segment_name,segment_type,tablespace_name,extents,max_extents
from dba_segments
where segment_name='SYS_LOB0001182584C00040$$';
2.查詢出引起錯誤的表和字段
--------------------------------------------------------------------------------------------
select owner,table_name,column_name,segment_name
from dba_lobs
where segment_name = 'SYS_LOB0001182584C00040$$';
3. 將maxextents 加大
---------------------------------------------------------------------------------------
alter table APPLSYS.WF_NOTIFICATION_OUT modify lob (USER_DATA.TEXT_LOB) (storage (maxextents 2048));
---------------------------------------------------------------------------------------------
修改之后 OK