Re: Question on tablespace/file allocation

> So would I be better off to just allocate one physical file for each
> tablespace?

Depends -- some operating systems & versions of Oracle limit file sizes (commonly, 2GB on UNIX.) I see no advantage to multiple files for a tablespace as long as you can stay under the file size limits of your OS & Oracle version. I would size them to what you think you need over the next few months & then either manually grow them as needed (via ALTER DATABASE DATAFILE...RESIZE...) or set them to autoextend -- if you choose the autoextend route, make you sure you specify a maxsize to avoid creating files that are not supported. When you reach the safe limits for a file, add a new file & grow as before. You will probably get a lot of different opinions on this issue since space management is one of the main things DBAs do & so there are lots of views on how "best" to do it. But getting back to your original question, I don't think tablespace file-striping is worth the effort it would take & is not likely to produce the result you are loooking for.

Good luck. Received on Tue Aug 21 2001 - 14:56:27 CDT