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" )                          

           或 (A.RAT_FIRST_CALLING_NBR =:"SYS_B_12 " ))                                 

   和 A.FILE_NAME :"SYS_B_13"                                          和 A.File_Class_Id = B.File_Class_Id                                            和 B.operati