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_06″ ) )

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

本文来源gaodai#ma#com搞*!代#%^码$网! 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_12″ ))

and A.FILE_NAME :”SYS_B_13″ and A.File_Class_Id = B.File_Class_Id and B.operati

喜欢 (0)赏

[搞代码]

分享 (0)