RE: Another datafile sizing question

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 25 Sep 2002 17:53:21 -0800
Message-ID: <F001.004D9858.20020925175321@fatcity.com>

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). Received on Wed Sep 25 2002 - 20:53:21 CDT