| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: failed to extend rollback for a simple select?????
we will check if there is an index, and we could do explain plans, but,
since it works in sqlplus and fails in COBOL...
decompton_at_worldnet.att.net wrote:
>
> 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.
--
 |
 |