Re: help !! ---snapshot too old

From: David <dsivick_at_mindspring.com>
Date: Fri, 26 Feb 1999 16:50:37 -0500
Message-ID: <7b759h$t1h$1@samsara0.mindspring.com>

Reset your rollback segment to have a larger minimal set too..

A rollback segment will not allocate a new segment if a particular segment is marked stale. So if a second transaction is using the same rollback segment it might end up using a stale segment from a large select that you might call later.

David

<christinezhao_at_hotmail.com> wrote in message news:7b4fpt$kdq$1_at_nnrp1.dejanews.com...
>Hi All,
>
>I have 10 rollback seg. optimal 8M ( all rollbacks are same ). now I got
this
>snapshot too old messages. should I make optimal to 16M?
>
>if I plan to add more rollback segments. should I enlarge tablespace also?
I
>calculate my current rollback seg: max_extents * db_lock * 10 >
>rollback_seg_tablespace.
>
>
>
>
>Christine Zhao
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Feb 26 1999 - 15:50:37 CST