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 

                                   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