Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Multiple Instances on an Alpha

Re: Multiple Instances on an Alpha

From: <markp28665_at_aol.com>
Date: 1996/12/05
Message-ID: <19961205233600.SAA08640@ladder01.news.aol.com>#1/1

>>>Our 8400 Alpha may be required to run 4 instances of our DB at
different
location. The 8400 has 2 cpu's. Is this enough horse power given that we have 1.5GB of mem and RAID Disk of 16GB. <<<

I do not understand you completely since one box can only be at one location and therefore do you mean 1) you will be running 4 instances of Oracle off the one box, 2) four separate business sites will be supported by the database running on this machine, or 3) you are duplicating the database at four sites.

Total size of the database is less important to performance than the number of concurrent users and the type of activity they are performing. Is your system designed to be short on-line transaction driven, ad-hoc, or batch driven.

I/O is still the biggest bollteneck on the computer, but computation intensive applications will make I/O relatively unimportant. You have lots of memory and the alpha chip is pretty fast, but DEC I/O rates do not impress me based on experience. But what kind of disk do you have. Will you be using OS level disk file stripping.

What blocksize is your database? Last I knew Oracle on VMS defaulted to 2K.
4K or 8K Oracle blocks are generally better on most applications unless you are memory constrained.

Any answer you get will be worthless to you if you do not provide more information on the application and network environment. Networks can be a real killer for some applications.

Hope this helps you get your answer. Sizing is tough. You can almost count on being over or under-sized.

Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Thu Dec 05 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US