i generally will not permit a file to exceed 2 gig for reasons of managability.
eg since a file is the smallest recovery unit, i want something small enough so that i can easily recover it without incurring too much downtime.
if i need to move some files around, 2 gig is small enough so that i can do it in parallel if need be
it may be difficult to find space for a very large file in the event that you need to clone it for some reason.
thanks,
steve
| Rachel Carmichael <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 02/12/2003 02:04 PM
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: database file sizes....more of smaller size or less of larger size? |
the ever popular answer "it depends"
how large are the tables you are storing in these datafiles? Is this a
data warehouse where you will be storing massive amounts of data? (1000
2GB datafiles to store one table's worth of data is somewhat obscene)
Is it a large database? Heavily used? OLTP?
I'm not making fun, it's just that a blanket statement "what are the
pros and cons" just doesn't make sense
--- [EMAIL PROTECTED] wrote:
> Hi DBAs,
>
> Oracle 8.1.7 WinNT
>
> I would like pros/cons on datafile sizes. It is better to have more
> of less
> size or less with larger sizes and why?
>
> Thanks
> Rick
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> 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).
>
__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
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).
