Undo space error
From: Pap <oracle.developer35_at_gmail.com>
Date: Mon, 3 May 2021 00:47:43 +0530
Message-ID: <CAEjw_fgZtqBfw-yDsxoOvYZJSCfkrya0tSa-6p1D6kPWb-zzHA_at_mail.gmail.com>
Hi All, it's version 11.2.0.4 of oracle. We are suddenly seeing multiple queries failed with 'ora-30036: unable to extend segment by 8 in undo tablespace 'undotbs1' error even after rerun.
Date: Mon, 3 May 2021 00:47:43 +0530
Message-ID: <CAEjw_fgZtqBfw-yDsxoOvYZJSCfkrya0tSa-6p1D6kPWb-zzHA_at_mail.gmail.com>
Hi All, it's version 11.2.0.4 of oracle. We are suddenly seeing multiple queries failed with 'ora-30036: unable to extend segment by 8 in undo tablespace 'undotbs1' error even after rerun.
In past we have seen lot of ora -01555 for long running queries but so many ora-30036 is seen for the first time. So what must be the cause of this? Is there anyway I can debug the cause of this error from stored historical information in AWR views(dba_hist*)?
Regards
Pap
-- http://www.freelists.org/webpage/oracle-lReceived on Sun May 02 2021 - 21:17:43 CEST