Re: ORA-01555 on a long select after many small txs from the same connection ?

A copy of this was sent to "Nick Rumble" <rumbln_at_tetraworld.com> (if that email address didn't require changing) On Thu, 1 Jul 1999 15:10:48 +0100, you wrote:

>Strangly enough - I've taken rollback segment R01 offline and performed a
>"SELECT COUNT(*) FROM NLTRANM" and the has now run through to the end ....
>
>Any ideas as to what's going on ?
>

You confirmed your suspicions that is was the delayed block cleanout. In most cases, the select count(*) will touch every block in the table, clean them out and leave them clean.

Your program then didn't 1555 itself.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jul 01 1999 - 11:53:34 CDT