Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Storage guidelines in 9iR1 ??

RE: Storage guidelines in 9iR1 ??

From: Kevin Toepke <ktoepke_at_tuningoracle.com>
Date: Wed, 19 Mar 2003 06:42:22 -0500
Message-Id: <24715.322345@fatcity.com>


Funny this came up. I had just finished doing research on this for a potential 9iRAC implemenation.

What I came up with from reading the docs and from experimentation is to keep the number of extents of each table and each indexes to less than 1024. 1024 seemed to be a majic number. Performance dropped significanty once you got past that.

Keep the uniform size an exact multiple of the tablespace's (or database's) block size.

Finaly, when you create a LMT, figure out the size you want and add 64k for the bitmap.

My envionment was Sun Solaris 8, 9iR2; patchset 1.

HTH
Kevin

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Prem Khanna J Sent: Wednesday, March 19, 2003 5:34 AM
To: Multiple recipients of list ORACLE-L Subject: Re: Storage guidelines in 9iR1 ??

Thanks Mogens.
but any "thumb of rule" to fix the UNIFORM SIZE in LMTs. how do u go about fixing the size ?!

Regards,
Jp.

2003/03/19 18:15:52, Mogens N?rgaard <mln_at_miracleas.dk> wrote:

>Go to LMT asap. Whether you want to use uniform sized extents in LMTs or
>system managed (or whatever it's called) is a matter of dispute. My
>personal opinion is for uniformed sizing.
>
>Mogens

--
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).
Received on Wed Mar 19 2003 - 05:42:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US