Re: Undo space error
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 2 May 2021 16:14:47 -0400
Message-ID: <250ae201-2dc9-6f61-3f1f-ae504768dbb2_at_gmail.com>
Date: Sun, 2 May 2021 16:14:47 -0400
Message-ID: <250ae201-2dc9-6f61-3f1f-ae504768dbb2_at_gmail.com>
Have you ever seen "Star Trek"? Have you ever noticed the words "space, the final frontier" at the very beginning of the show? Well, as the Universe expands, so should your UNDO tablespace. And Universe expansion is accelerating.
https://www.youtube.com/watch?v=hdjL8WXjlGI
You should expand your UNDO tablespace and boldly go where many a DBA has gone before.
On 5/2/21 3:17 PM, Pap 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.
>
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Sun May 02 2021 - 22:14:47 CEST