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_STATE C WHERE ((A.RAT_FIRST_STARTTIME >=:"SYS_B_01" and A.RAT_FIRST_STARTTIME or (A.RAT_LAST_ENDTIME >=:"SYS_B_03" and A.RAT_LAST_ENDTIME or (A.RAT_FIRST_STARTTIME = :"SYS_B_06" ) ) and ((A.RAT_FIRST_CALLING_NBR >=:"SYS_B_07" and A.RAT_FIRST_CALLING_NBR or (A.RAT_LAST_CALLING_NBR >= :"SYS_B_09" and A.RAT_LAST_CALLING_NBR or (A.RAT_FIRST_CALLING_NBR =:"SYS_B_12" )) and A.FILE_NAME :"SYS_B_13" and A.File_Class_Id = B.File_Class_Id and B.operati