Database instances

[jimaricat]

How many oracle database instances ,.a normal pc can have.

my machine is p3,1.2ghz,256Mb ram

[santoshym]

Hi

I have a similiar system as yours, Iam able to run two oracle database instances.These are just development & test instances.

Regards

Santosh

[Shestakov]

Originally posted by jimaricat
How many oracle database instances ,.a normal pc can have.
my machine is p3,1.2ghz,256Mb ram

It depend from:
-- version of oracle
-- OS on ur box
in case p3,1.2ghz,256Mb ram
If u going to use NT/W2K (this is most popular platform)
9i(9.2.0) 1 instance with a lot of problems
9i(9.0.1) 1 instance with a lot of problems
8i(8.1.7) 1 instance
8i(8.1.6) 1 instance (usual) 2 instance with some problems
...
If Linux then u can a little bit decrease requiement to the equipment.

Best way - read README for each version and each OS.

[Shestakov]

I descdibe situation with 265 M memory (i didn't describe situation with CPU)
If u going to use some small 9i db u have to have:
-- 36 MB shared memiry minimun (64 min recomended)
-- 4096x200 db cache min (16 MB)
-- no less then to 2 MB for each dedicated process
then Min SGA ~ 96-100 MB +
-- NT file cache up to 15 MB
-- NT itself 30-60MB
-- oracle (no less then 16 MB)

100x2 = 200 this is 2 sga onli
200+40+15+16 (where will live dedicated servers, listener, any other client software? where u going to place sqlplus?)
-------------------------------------------------
I don't describe java pool, large pool ... (only sga without any java and any others extentions)
-------------------------------------------------