Re: ANOTHER KIND OF SNAPSHOT TOO OLD....

From: <thuge_at_steelcase-strafor.com>
Date: Tue, 02 Mar 1999 11:06:32 GMT
Message-ID: <7bggnk$gls$1@nnrp1.dejanews.com>

Do you have an optimal option set to this segment ? if yes, try to increase it or delete this option.

In article <7bf9a1$v96$1_at_news.sti.com.br>, "LUIS CARLOS LANNOCCA" <lannocca_at_sti.com.br> wrote:
> I have a large table with 4Gb and every query dealing with a great number of
> rows
> send me a ORA-01555 snapshot too old , rollback segment number 2 name roll_1
> too small ,
> but only a MyRoll rollback segment is present with 200M . I receive this
> message even using Set Transaction Use Rollback MyRoll. Only one user is
> connect to database when its occurs, always doing queries , not inserts or
> updates or deletes. My database runs in a NT 4.0 P3 , dual processor with
> 256Mb .
>
> I will appreciate every comments .Thanks
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 02 1999 - 05:06:32 CST