Re: OCP Architecture question

They all allow the RBS to be bigger. More space available for RBS roughly equals fewer ORA-01555, for most situations...

on 8/14/03 6:24 PM, Ryan at rgaffuri_at_cox.net wrote:

> Im using the self test software and here is a question... I dont like the
> answers. Please tell me if Im wrong.
>
> Which Three methods can be used to avoid snapshot too old errors. This is for
> the 8i test.
>
> 1. User larger extents
> 2. Increase MAXEXTENTS for existing rollback segments
> 3. Create rollback segments with higher optimal values
> 4. Create rollback segments iwth high minextents
> 5. Run long queries when transaction processing is high.
>
> Ruling out 5 is obvious. The test says its.
>
> 1,3,4
>
> How does using large extents help this? What about a higher minextents value?
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: tim_at_sagelogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).