Re: Tablespace storage parameters

From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/05/23
Message-ID: <oSkW4.205931$Tn4.1777851@news1.rdc2.pa.home.com>#1/1

If you are going to spread the load across several drives, which you might want to do to distribute the load, or because of drive limitations, then you just have to make sure that the initial and next extents aren't larger that the datafiles. Be aware of the pctincrease, you should use a value of 0.

Now if you want to use OS/striping (combine the disks at the os level, and make one big drive) that is fine too, but then the issues are mainly recovery related. It's much easier to restore one 10m file than one 500m file.

My databases are usually between 100G-200G, I use 2g as my datafile size.

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"James Chappell" <james_at_rees-chappell.demon.co.uk> wrote in message
news:GHruqPAaKbK5Ew93_at_rees-chappell.demon.co.uk...


> What is the consequence of choosing particular values for the initial

> and next extents when creating a datafile for a tablespace.

>

> If I want to create a tablespace of (say) 500M would it be better to

> have several smaller files, or one large one?

>

> I'm using Oracel8 on NT

> --

> James Chappell

Received on Tue May 23 2000 - 00:00:00 CDT