Re: Database Structure

There is some major gaps in your knowledge of database construction. Oracle can use from 1 to some really large number of disks. The limitation in this area will most likely be in your operating system. There is a large number of design issues regarding performance that  are affected by this layout. If you are just doing this for learning purposes then initially keep it simple a disk to install Oracle, can have other stuff on it. A disk to hold all of your datafiles. That will get you started. We run it in a single disk on our laptops for training and testing. No performance but it works.

If this is to do other stuff, like install an application, you need to enlist the help of a decent DBA.

HTH Peter McLarty                   E-mail: Peter.Mclarty_at_Mincom.com Technical Consultant        WWW: http://www.Mincom.com APAC Technical Services     Phone: +61 (0)7 3303 3461 Brisbane,  Australia                Mobile: +61 (0)402 094 238          

----------------------                    Facsimile: +61 (0)7 3303 3048

"Kevin Bass" <kbass1_at_nc.rr.com>
Sent by: root_at_fatcity.com
11/05/01 09:30 AM
Please respond to ORACLE-L

       
        To:        Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc:        
        Fax to:        
        Subject:        Database Structure

I am attempting to construct a new database environment but I am not sure how many hard drives to use nor what size hard drive I should use.  After reviewing information from Oracle and various books,  I have come to the conclusion that Oracle can operate using 4 to 22 hard drives on a server but I cannot determine the size of the hard drives.

How many hard drives should I use for Oracle and what should be the recommended size requirements for each hard drive?

Thanks, Kevin

-- 





-- 
This transmission is for the intended addressee only and is confidential
information.  If you have received this transmission in error, please
delete it and notify the sender.  The contents of this e-mail are the
opinion of the writer only and are not endorsed by the Mincom Group
of companies unless expressly stated otherwise.