Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: help !! ---snapshot too old

Re: help !! ---snapshot too old

From: Amir Kibar <amirk_at_softhome.net>
Date: Fri, 26 Feb 1999 19:43:36 +0200
Message-ID: <36D6DD47.F643F8B7@softhome.net>


christinezhao_at_hotmail.com wrote:

> 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

Try to enlarge yout rollback segments' tablespace.

Amir Kibar
Oracle DBA
IAF Received on Fri Feb 26 1999 - 11:43:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US