RE: datafile sizing question

From: Robertson Lee - lerobe <lerobe_at_acxiom.co.uk>
Date: Wed, 25 Sep 2002 09:23:24 -0800
Message-ID: <F001.004D8EC5.20020925092324@fatcity.com>

Hi Rachel,

I know the guy who creates the warehouses here uses 4Gb datafiles (I believe he creates them at 4050Mb).
We are on Tru64 Unix

He is on his honeymoon at the moment so I cannot ask him his reasoning.

Regards

Lee

-----Original Message-----
Sent: 25 September 2002 17:33
To: Multiple recipients of list ORACLE-L

Okay, I'm about to create some locally managed tablespaces for some large partitioned tables. I plan on making each datafile 2GB, with an extent of 20M.

What I've done other times when I use LMTs is add 64K to the file size, for the bitmap header, so that I don't waste most of an extent. But in those cases, the datafile size has been less than 2GB.

We will be on Solaris 2.8, I know that the OS can handle files larger than 2GB but it makes me nervous to do this.

I hate to waste most of 20M just for the bitmap header.

Is my thinking way off? If you've been doing this sort of sizing (it's a data warehouse, yes), what have you done?

thanks!

Rachel

Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Rachel Carmichael
INET: wisernet100_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).

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited.
If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Robertson Lee - lerobe
INET: lerobe_at_acxiom.co.uk

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