10001Mb?
the uniform extent sizes map to what I'll be using as well. good to
know I'm not way off track
- John.Hallas_at_vodafone.co.uk wrote:
> We tend to use multiples of 1Gb and add 1 Mb to the file so that we
> get
> 2001, 10001 Mb etc
> Solaris 2.8
> LMT uniform extents range from 64K to 20Mb
>
> John
>
> -----Original Message-----
> Sent: 25 September 2002 19:44
> To: Multiple recipients of list ORACLE-L
>
>
>
> We created two datafiles of 16GB+64K all LMT autoallocate ... never
> gave a
> problem. A basic testing concluded that fixed size allocation of 128M
> caused
> unnecessary delays whereas autoallocate was much faster. I don't know
> the
> full details yet, but I'll know soon.
>
> Of course this is undergoing lot of testing (the whole application,
> no
> problems with datafiles yet), but we will probably settle for about
> 4GB+64K.
> This is AIX5L 64 bit running Oracle 9iR2.
>
> Raj
> ______________________________________________________
> Rajendra Jamadagni MIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect that of
> ESPN Inc.
>
> QOTD: Any clod can have facts, but having an opinion is an art!
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: John.Hallas_at_vodafone.co.uk
>
> 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).
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).
Received on Thu Sep 26 2002 - 06:03:25 CDT