Re: OCP question from Boson practice tests

Hi again Prem,

OK, I've changed my opinion of dear Boson. At first I simply thought they had no idea, now I suspect it's all a big joke designed to make DBAs have a bit of a giggle on warm summer nights ...

Sizing the temp tablespace by the formula you've given is really quite witty. Perhaps a little on the silly side but I love Monty Python so I liked it.

The correct answer is actually none of the four listed (so I'm really struggling to find two of the buggers).

1. Users: Not really. I could show you a DW database with only a handful of users that requires a much larger temp tablespace than an OLTP database with 1000s of users. It not the number of users but what the users *do* that's important.
2. Sort Area Size. Not really. Although it can influence whether a sort is performed on temp or not, it's the size of the *sort*, not the size of the S_A_S that's important. And not just the size of one sort, but the size of the *max concurrent* sort activity. I guess a badly set S_A_S could result in needing a larger temp tablespace but I doubt that's the point of the question. And then there's hash joins, etc, ooops, the question has kinda forgotten about non sort activity in temp....
3. tablespace management. Not really although I guess those bitmaps do take up some space ...
4. db_block_size. What the #@&* ??.

Thinking about all this a bit more, if Boson's practice questions puts people off doing OCPs, it might not be such a bad thing after all ...

Cheers ;)

Richard

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, January 07, 2004 8:44 PM

> Hi List, this is the question .
>
> --------------------------------------------------------------------
> You are calculating the proper size for a temporary tablespace .
> Which of the following are two most important factors to consider ?
>
> A. users
> B. sort_area_size
> C. type of tablespace management
> D. db_block_size
> --------------------------------------------------------------------
>
> my choice is A & B .
>
> but boson's choice is B & D . the explanation given by boson is :
> when sizing a temporary tablespace , the formula is
> db_block_size * sort_area_size .
>
> is it so ? do we need not take no. of users into account ?
> kindly explain me .
>
> Regards,
> Prem.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Prem Khanna J
> INET: jprem_at_kssnet.co.jp
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Foote
  INET: richard.foote_at_bigpond.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).