Re: Why ORA-1555 snapshot too old.

From: Richard Kuhler <noone_at_nowhere.com>
Date: Fri, 18 Oct 2002 22:50:54 GMT
Message-ID: <if0s9.6106$X9.1822977@twister.socal.rr.com>

I must admit I don't understand your answer. The poster stated that "I know the RBS is not wrapping back on itself in that short of a time and it is not shrinking either." However, you seem to be implying that committing records individually makes this a mute point (i.e. no matter how big the rollback was you couldn't stop ora-1555 in this situation?). Can you please expound on your answer a little more?

Richard Kuhler

Sybrand Bakker wrote:
>
> On Fri, 18 Oct 2002 16:25:35 -0400, "Chuck" <chuckh_at_softhome.net>
> wrote:
>
> >One of my developers is trying to query a 45g table that is constantly being
> >insert into.
>
> And every record is committed individually.
> There's your answer.
>
> Regards
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Fri Oct 18 2002 - 17:50:54 CDT