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@xxxxxxxxx> 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
