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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RE: OCP Architecture question

Re: RE: OCP Architecture question

From: <rgaffuri_at_cox.net>
Date: Fri, 15 Aug 2003 03:29:23 -0800
Message-ID: <F001.005CAE7D.20030815032923@fatcity.com>


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?
>
>
>
>
>









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 101 in
Sydney
- Hotsos Symposium 2004 March 7–10
Dallas
- Visit www.hotsos.com for schedule details...

-----Original Message-----
From: ml-errors@fatcity.com [mailto:ml-errors@fatcity.com] On Behalf Of Tim Gorman
Sent: Thursday, August 14, 2003 10:54 PM
To: Multiple recipients of list ORACLE-L
Subject: 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@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).
Received on Fri Aug 15 2003 - 06:29:23 CDT

Original text of this message

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