ORA-30036故障处理思路

故障现象为某省结算库应用方在跑存储过程发现报错ORA-30036:unabletoextendsegmentby8inundotablespaceUNDOTBS1后进行了下面的一系列的排查分析：查看undo表空间

故障现象为某省结算库应用方在跑存储过程发现报错

ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

后进行了下面的一系列的排查分析：

Wed Jan 30 04:32:01 GMT+08:00 2013ORA-01555 caused by SQL statement below (SQL ID: 4ds6qq0mfac2t, Query Duration=5 sec, SCN: 0x0c00.d915c977):

Wed Jan 30 04:32:01 GMT+08:00 2013SELECT distinct FILE_NAME,to_char(file_name_time,:"SYS_B_00"),A.operation_type_grade FROM T_FILE_INFO_81 A,T_FILE_CLASS B ,T_FILE_STAT

E C WHERE ((A.RAT_FIRST_STARTTIME >=:"SYS_B_01" and A.RAT_FIRST_STARTTIME <=:"SYS_B_02" )

or (A.RAT_LAST_ENDTIME >=:"SYS_B_03" and A.RAT_LAST_ENDTIME <=:"SYS_B_04" )

or (A.RAT_FIRST_STARTTIME <=:"SYS_B_05" and A.RAT_LAST_ENDTIME >= :"SYS_B_06" ) )

and ((A.RAT_FIRST_CALLING_NBR >=:"SYS_B_07" and A.RAT_FIRST_CALLING_NBR <=:"SYS_B_08")

or (A.RAT_LAST_CALLING_NBR >= :"SYS_B_09" and A.RAT_LAST_CALLING_NBR <= :"SYS_B_10" )

or (A.RAT_FIRST_CALLING_NBR <=:"SYS_B_11" and A.RAT_LAST_CALLING_NBR >=:"SYS_B_12" ))

and A.FILE_NAME <>:"SYS_B_13" and A.File_Class_Id = B.File_Class_Id and B.operati