RE: OCP question from Boson practice tests

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Wed, 07 Jan 2004 06:44:24 -0800
Message-ID: <F001.005DBFBF.20040107064424@fatcity.com>

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 ?

users
sort_area_size
type of tablespace management
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: Goulet, Dick
INET: DGoulet_at_vicr.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------