It's late at night maybe that's why I do not
understand your answer but I do not see the link
between LMT and the number/size of datafiles.
One reason of multiple datafiles id to spread IO but
since nowadays a majority of sites goes on huge disk
box using raid 5 (that's what we have, the unix guys
are the IT master here) multiple files is less
meaningful.
What I liked is a file politics where you restrained
the number of file size. Here we have from 15M up to
8.5G file size with all the possibility in between.
I'm trying to standardize all that.
Another factor to consider is backup and recovery.
Restoring a 10G file will take more time than a 2G
file.
In your case, if file placement is not possible than
go for a 800M file and use a second one for the future
growth.
- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> a écrit :
> Darren - My advice would be to read up on Locally
> Managed Tablespaces (LMT)
> and uniform extents. This is a new feature that will
> ease your management
> work.
>
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> Sent: Wednesday, September 25, 2002 6:43 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I am in the process of upgrading our databases from
> 8.0.5 to 8.1.7,
> possibly 9i depending on application
> certifications.
>
> I currently have a tablespace that is made up of 4 -
> 200mb datafiles, my
> first thought would be to
> create a 800mb datafile and move all the data into
> it,
>
> The growth of this tablespace is maybe 100 to 150Mb
> a year, and from
> what I understand all datafiles should
> be the same size. So at that point when I need
> another datafile, I will
> have to create another 800Mb datafile.
>
> Would that be a good practise, or should I stay with
> multiple
> 200/300/400/500 etc datafiles ?
>
> Thanks
>
> Darren
>
> --------------------------------------------------
> Darren Browett P.Eng This
> message was transmitted
> Data Administrator using
> 100% recycled electrons
> Information and Communication Technology
> City of Coquitlam
> P:(604)927 - 3614
> E:dbrowett_at_city.coquitlam.bc.ca
>
> ---------------------------------------------------
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Browett, Darren
> INET: dbrowett_at_city.coquitlam.bc.ca
>
> 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: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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).
>
>
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail :
http://fr.mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
INET: stephane_paquette_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 Wed Sep 25 2002 - 22:13:19 CDT