Re: Failure to extend rollback segment N because of 1000 condition
From: Steve Howard <stevedhoward_at_gmail.com>
Date: Fri, 14 May 2010 16:07:01 -0700 (PDT)
Message-ID: <4345396b-c4a3-4778-86de-13c5d8a9c21d_at_s41g2000vba.googlegroups.com>
On May 14, 5:52 pm, ca111026 <ca111..._at_gmail.com> wrote:
> I got strange error message in alert.log for 9.2.0.7 database (64-bit)
> on AIX 5.3
>
> ARC0: Completed archiving log 4 thread 1 sequence 123305
> Fri May 14 21:05:55 2010
> Failure to extend rollback segment 15 because of 1000 conditionFULL
> status of rollback segment 15 set.
> Fri May 14 21:05:59 2010
>
> I am familiar with 30036 error, but not with 1000. In fact error 1000
> has nothing to do with rollback/undo
>
> oracle> oerr ora 30036
> 30036, 00000, "unable to extend segment by %s in undo tablespace '%s'"
> // *Cause: the specified undo tablespace has no more space
> available.
> // *Action: Add more space to the undo tablespace before retrying
> // the operation. An alternative is to wait until active
> // transactions to commit.
>
> oracle> oerr ora 1000
> 01000, 00000, "maximum open cursors exceeded"
> // *Cause:
> // *Action:
>
> The database is configured with automatic undo management. This is
> batch processing system, undo generation is stable at approximately
> 60,000 blocks per 10 min interval (as per V$UNDOSTAT), or 360,000
> blocks per hour. Undo retention is set to 28,000 seconds, or 8 hours.
> To keep 8 hours of undo we need approximately 3 million blocks
> (2,880,000), or 24 GB as database uses 8K blocks. Undo tablespace is
> 60 GB, approx 50% free.
> So everything seems to be configured correctly, why the error?
Date: Fri, 14 May 2010 16:07:01 -0700 (PDT)
Message-ID: <4345396b-c4a3-4778-86de-13c5d8a9c21d_at_s41g2000vba.googlegroups.com>
On May 14, 5:52 pm, ca111026 <ca111..._at_gmail.com> wrote:
> I got strange error message in alert.log for 9.2.0.7 database (64-bit)
> on AIX 5.3
>
> ARC0: Completed archiving log 4 thread 1 sequence 123305
> Fri May 14 21:05:55 2010
> Failure to extend rollback segment 15 because of 1000 conditionFULL
> status of rollback segment 15 set.
> Fri May 14 21:05:59 2010
>
> I am familiar with 30036 error, but not with 1000. In fact error 1000
> has nothing to do with rollback/undo
>
> oracle> oerr ora 30036
> 30036, 00000, "unable to extend segment by %s in undo tablespace '%s'"
> // *Cause: the specified undo tablespace has no more space
> available.
> // *Action: Add more space to the undo tablespace before retrying
> // the operation. An alternative is to wait until active
> // transactions to commit.
>
> oracle> oerr ora 1000
> 01000, 00000, "maximum open cursors exceeded"
> // *Cause:
> // *Action:
>
> The database is configured with automatic undo management. This is
> batch processing system, undo generation is stable at approximately
> 60,000 blocks per 10 min interval (as per V$UNDOSTAT), or 360,000
> blocks per hour. Undo retention is set to 28,000 seconds, or 8 hours.
> To keep 8 hours of undo we need approximately 3 million blocks
> (2,880,000), or 24 GB as database uses 8K blocks. Undo tablespace is
> 60 GB, approx 50% free.
> So everything seems to be configured correctly, why the error?
Perhaps this will help.
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1441804355350 Received on Fri May 14 2010 - 18:07:01 CDT