Re: Oracle vs SQl Server

On Sun, 31 Dec 2000 07:29:56 GMT, Some Body <somebody_at_someone.edu> wrote:

>What are the relative disk-space requirements for the program files and
>the data?

Dunno. ORACLE has grown in size quite a lot lately. If you do a basic engine install, it's not that much though. Around 100M.

>I'm guessing that Oracle needs at least twice the disk space
>for the data, because of the need to hold the redo logs, archive logs
>and also the need to preallocate space not yet needed for data.

Whoa! Redo logs and such don't need "twice the data space"! No way in the world. And you don't need to pre-allocate space for data.

>SQL
>Server, I believe, gets more disk space as needed from the OS. Is this
>correct?

So does ORACLE. You can set it to use pre-allocated space or dynamically get it as needed. Your choice.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Sun Dec 31 2000 - 05:39:53 CST