Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with rollback segment (ORA-01555)
Thank you for your help in this matter.
I wasn't aware of that rollback segments still might be needed (for
reading purposes) even though transactions are commited. I think I now
why that happens in my client application.
Once again thank you for your advise and good links with related articles.
-Carl
In article <93pvgj$m2g$1_at_nnrp1.deja.com>,
c_joh_at_my-deja.com wrote:
> I have a problem with rollback segments that I don't understand. I'm
> running Oracle EE Ver. 8.0.5.1.0 and I have written a client
> application that will insert/update some tables in the database. It
all
> works very well except that I now and then get the error message
> "ORA-01555: snapshot too old (rollback segment XX too small)". I have
> currently 5 rollback segments online. They all are quite big, more
than
> should be needed for the transactions that occur from the client
> program. The database is in a test environment where there is no other
> users connected.
>
> When I query V$ROLLSTAT I can see that none of the rollbacksegments
> uses more then 2 extents and as the maxextent is set to 1000 there
> should be plenty of room to allocate more extents. The datafile is set
> to autoextend = ON.
>
> If anyone could give me a hint on what to look for I would be most
> grateful.
>
> -Carl
>
> Sent via Deja.com
> http://www.deja.com/
>
Sent via Deja.com
http://www.deja.com/
Received on Mon Jan 15 2001 - 04:21:07 CST