Re: OCP question from Boson practice tests

Prem ,
OCP has nothing to do with knowledge and nothing to do with the real world. So if you want to give OCP, forget what you know and humbly, play by its rules.

Right now if your are serious about giving OCP exams then please enable "suspension of disbelief" , don't ask why and just mug up the following 3 (any one of them may come up in the ocp exam , though not together) :

1.
To optimize the performance of a sort in a temprary tablespace , set the UNIFORM SIZE to be a multiple of the parameter sort_area_size

2.
To optimize the performance of a sort in a temprary tablespace , set the UNIFORM SIZE to be a multiple of sort_area_size * db_block_size

3.
To optimize the performance of a sort in a temprary tablespace , set the UNIFORM SIZE to be n * sort_area_size + db_block_size.

OCP has nothing to do with knowledge and nothing to do with the real world. So if you want to give OCP, forget what you know and play by its rules. Best of luck .

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

> 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: <bulbultyagi_at_now-india.net.in
  INET: bulbultyagi_at_now-india.net.in

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