Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: OCP question from Boson practice tests
Use the following guidelines to specify DEFAULT STORAGE: Set INITIAL=NEXT.Since a process always writes data equal to SORT_AREA_SIZE to a temporary segment, a good value for the extent size is (n*s + b)
where: n is a positive integer
s is the value of SORT_AREA_SIZE initialization parameter
b is the value of DB_BLOCK_SIZE initialization parameter
Using this value optimizes temporary segment usage by allowing sufficient space for a header block and multiple sort run data to be stored in each extent.
************
Is this not correct? Forget OCP. I was just want clarify this issue. Good luck for the exams Prem.
Further to that if I give my sort area size as a very odd number which is not a multiple of OS block size then what happens.
Thank You
bulbultyagi@now-india.net.in wrote:
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 .
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: A Joshi INET: ajoshi977_at_yahoo.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).Received on Fri Jan 09 2004 - 19:19:25 CST
![]() |
![]() |