Very Large databases
From: Phillip Adams <banjopa_at_banjopa.demon.co.uk>
Date: 2000/06/29
Message-ID: <FQrC7KAxS6W5EwMH_at_banjopa.demon.co.uk>#1/1
Date: 2000/06/29
Message-ID: <FQrC7KAxS6W5EwMH_at_banjopa.demon.co.uk>#1/1
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 formated filesystems (We currently use Digital UNIX 40F).
My questions are:
- 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?
- 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!
- Are there any limitations to the size of raw disk that Oracle can address.
- Are there any good Oracle web sites that you cyberspace people recommend?
Any help would be very much appreciated.
Thanks,
Phil.
-- Phillip AdamsReceived on Thu Jun 29 2000 - 00:00:00 CEST