Re: Maximum Oracle instances on a Server?

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Thu, 28 Feb 2002 11:50:58 +1100
Message-ID: <a5jutp$k8j$1@lust.ihug.co.nz>

Don't forget that the old myth about block size being dependent on the nature of the database is, er... a myth. 8K for Unix is appropriate whatever the database is being used for.

Check out articles on the subject at my site, or (for a more technical approach) www.ixora.com.au, and look for an article called 'why a large database block size'.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"James Williams" <willjamu_at_mindspring.com> wrote in message
news:3c7d6bef.79289943_at_nntp.mindspring.com...


> Don't forget that OLTP and DSS normally need different blocksizes

> becase of random vs. sequential access.. Unless you are 9i and using

> multiple blocksizes then you could have an issue there.

> :

>

> >You will be running two Databases on this Machine which is going to be a

> >overkill if u'r Memory Requirments are not met ...

> >

> >The better way to go baout doing this would be to use a Different PFILE

for


> >u'r OLAP Dbs and a Differnet One for your OLTP DBs...

> >

> >

Received on Wed Feb 27 2002 - 18:50:58 CST