Re: OCP question from Boson practice tests
Hi, This is from a metalink note 1039341.6. It is about 'DEFAULT STORAGE'. I do not know if the OCP question was regarding that. *** 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 extentsize 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 allowingsufficient space for a header block and multiple sort run data to bestored 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[EMAIL PROTECTED] 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 itsrules.Right now if your are serious about giving OCP exams then pleaseenable "suspension of disbelief" , don't ask why and just mug up thefollowing 3 (any one of them may come up in the ocp exam , though nottogether) :1.To optimize the performance of a sort in a temprary tablespace , set theUNIFORM SIZE to be a multiple of the parameter sort_area_size2.To optimize the performance of a sort in a temprary tablespace , set theUNIFORM SIZE to be a multiple of sort_area_size * db_block_size3.To optimize the performance of a sort in a temprary tablespace , set theUNIFORM 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 . Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
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). A. 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. B. 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 C. tablespace management. Not really although I guess those bitmaps do take up some space ... D. 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: OCP question from Boson practice tests
Well, you've certainly gotten a few decent replies. I've never used Boson so I can't comment on their exams, I prefer going to Oracle Press. Anyway, sizing temp is a combination of things many of which are black magic at best. Number of users is an interesting variable to add, but not of an extreme value since it's actually the number of CONNECTED users that will really affect the value arrived at. Sort_Area_size, Maybe. If it's large enough it may well negate the need for temp in a number of cases, but don't bet on it. Type of Tablespace management? OK, who's smoking what. That's a giveaway toss out. DB_Block_Size, again a giveaway, it has no real bearing since the temp tablespace will have the same size, unless you use 9i features, but even then a MB is a MB. The real answer is know what your database is suppose to be doing. If your setting up an OLTP database you may well get away with a very small temp space. On the other hand a data warehouse or decision support system is, by design, going to consume mountains of temp. Also do not forget things like index rebuilds that you will need to do, they do sorts and consequently consume temp in the process. Then there's always that wild user who lets loose the Cartesian product from haties that will blow all of your calculations off the map. Therefore the answer in this case is E: None of the above. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 07, 2004 5:44 AM To: Multiple recipients of list ORACLE-L 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Goulet, Dick INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 ben * 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
