Datafile sizing affects the speed of backup and restore, since each datafile
can only be backed up or restored by one process at a time. As a result, I
try to keep datafiles at uniform sizes of 2-4 Gb max. How do such large and
variable-sized datafiles impact your backups and restores? Just curious...
- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Thursday, September 26, 2002 6:28 AM
> Yes, 10Gb datafiles.
> I think we have a 35Gb datafile somewhere but I have not looked at that
> database myself
>
> John
>
> -----Original Message-----
> Sent: 26 September 2002 12:03
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
> --
> 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: Tim_at_SageLogix.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 - 08:28:27 CDT
