Re: RE: OCP Architecture question

yeah thats what i figured... but having these certifications are good for my career.

thanks. I figured it was a stupid question.
>
> From: "Cary Millsap" <cary.millsap_at_hotsos.com>
> Date: 2003/08/15 Fri AM 01:14:23 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: RE: OCP Architecture question
>
> With respect to evaluating answer number one, it's a bad question,
> because you have know way to know whether the context is supposed to be
>
>
>
> a) assume a fixed rollback segment size, but use fewer, larger
> extents; or
>
> b) make the rollback segment larger by using the same number of
> larger extents.
>
>
>
> In context (a), #1 is a bad answer. In context (b), it's a better
> answer, but it's still poor.
>
>
>
> The thing that really chaps me about stupid certification questions like
> this is that no answer among the choices listed is really the right
> thing for you to try to do, which is:
>
>
>
> <shout>FIX THE QUERY THAT'S TAKING SO LONG TO RUN.</shout>
>
>
>
> In other words, make queries run quickly enough that they don't require
> multiple-hour-old undo blocks to produce read-consistent results.
>
>
>
> Jacking around with rollback segments is just a kludge that will produce
> results far inferior to what you can achieve by attacking the query
> problem at its root.
>
>
>
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
>
> Upcoming events:
> - Hotsos Clinic <http://www.hotsos.com/training/clinic101> 101 in
> Sydney
> - Hotsos Symposium 2004 <http://www.hotsos.com/events/symposium/2004>
> March 7-10 Dallas
> - Visit www.hotsos.com for schedule details...
>
> -----Original Message-----
> Tim Gorman
> Sent: Thursday, August 14, 2003 10:54 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> 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: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

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).