Re: Very Large Databases

Phillip,

1. Around 1022, might be greater in 8.x
2. No, although don't put all your eggs in one basket ! Best to spread load across mutiple files.
3. No, although consider backup.
4. http://www.jlcomp.demon.co.uk/ and http://www.ixora.com.au/

Chris

Phillip Adams wrote:
>
> Hello,
>
> I have a couple of what I hope are simple questions. I am currently
> working on the feasibility of migrating several Databases' into 1 large
> DB. I am also considering using RAW devices instead of formatted
> filesystems (We currently use Digital UNIX 40F).
>
> My questions are:
>
> 1. Is there a limit to the number of datafiles that Oracle can address.
> I intend to resize datafiles on the fly instead of adding additional
> datafiles but I still need to know if there are any limitations. I have
> checked the init<SID>.ora file and the only likely offender is db_files.
> Does this have any effect on the number of datafiles allowed? If so, can
> I change this parameter on the fly or will I have to recreate the
> control files?
>
> 2. Is there a limit to the size of individual datafiles. If this project
> goes ahead, we are likely to see datafiles as big 30GB - 100GB!
>
> 3. Are there any limitations to the size of raw disk that Oracle can
> address.
>
> 4. Are there any good Oracle web sites that you cyberspace people
> recommend?
>
> Any help would be very much appreciated.
>
> Thanks,
>
> Phil.
>
> --
> Phillip Adams
Received on Thu Jun 29 2000 - 00:00:00 CDT