Re: failed to extend rollback for a simple select?????

From: <decompton_at_worldnet.att.net>
Date: Thu, 15 Jul 1999 18:47:04 GMT
Message-ID: <7mlab3$o1u$1@nnrp1.deja.com>

Scott,

I agree with you in that as written, your SQL statements would not need much rollback segment. I've had trouble like this in the past using a SELECT FOR UPDATE(make sure that the statement with the bind variable is using an index, not doing a table scan). Anything unusual in the explain plans?

dave

In article <378DF748.A69ACE51_at_erols.com>, Scott Mattes <smattes_at_erols.com> wrote:
> Oracle 8.05.?
> Merant (was MicroFocus) Toolbox 4.1
> IBM AIX
>
> I didn't know that you needed rollback segments for a select?
>
> select field1
> into :field1
> from table1
> where field2 = :field2
>
> causes about a 20-30 second delay and then a "failed to extend
rollback
> segment x" message.
> But doing the following
>
> select field1
> from table1
> where field2 = 'value'
>
> from SQLPlus runs just fine and returns the one record we thought we
> should get.
> ---------------------------------
> Scott Mattes
> Work: Scott.Mattes_at_Wang.com
> Home: SMattes_at_Erols.com
> Web: www.erols.com/smattes
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 15 1999 - 13:47:04 CDT