Re: Undo space error
Date: Mon, 3 May 2021 13:54:32 +1000
Message-ID: <CAFeFPA97TeGrQCjnEtczqn5hqoFPGudt3C1RrQJC8pRbsb8Byg_at_mail.gmail.com>
What Mladen said, but I seem to recall having seen some bugs where this
error can be seen when oracle gets a very high tuned_undoretention and lots
of unexpired undo blocks.
I believe they mostly are fixed in 12C not sure about 11
Jack van Zanen
This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation
On Mon, May 3, 2021 at 5:18 AM Pap <oracle.developer35_at_gmail.com> wrote:
> 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 Mon May 03 2021 - 05:54:32 CEST