Re: Tablespace storage parameters

From: MyTwoBits <nighr_at_hotmail.com>
Date: 2000/05/25
Message-ID: <Ll3X4.88099$fF5.2871610@news1.rdc1.il.home.com>#1/1

Until your tablespaces are larger than 2GB, it's more a pain in the ass to keep track of small data files. There are known bugs for some versions of Oracle when datafiles approach or exceed 4GB. I have a standard on my systems that no data file is larger than 2000 MB. My Unix servers have 9GB as their smallest disks. My NT servers have 36 GB disks. On Unix I mainly use raw partitions and RAID 0 (no striping). I have individual tables that are several GB each. If your objects are in the 100k range I wouldn't spend the time with multiple data files. At 500M, you could create your SGA large enough to hold your whole tablespace in memory!

"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 Thu May 25 2000 - 00:00:00 CDT