Home » Infrastructure » Unix » Running multiple Oracle database instance on single machine (Oracle Database Solaris 10)
Running multiple Oracle database instance on single machine [message #283454] Tue, 27 November 2007 03:46 Go to next message
Messages: 20
Registered: December 2005
Junior Member

I am trying to start 2 instance on a single machine of Oracle Database
My H/w and o/s is Solaris 10 with 4GB RAM and 10GB swap.

Can I give 1GB of SGA and 500MB of PGA for both instance leaving 1GB free.I am trying to give sga_max_target=1GB and sga_target=800MB and pga_aggregate_target=500MB.
But by giving this SGA/PGA, and starting the second instance, I get "Out of Memory" message.

The machine is ment only for oracle database and none other process is running on this machin.

How much maximum SGA and PGA can I give for both the instance so that there is
not much of pagging while working.


[Updated on: Tue, 27 November 2007 04:06]

Report message to a moderator

Re: Running multiple Oracle database instance on single machine [message #283564 is a reply to message #283454] Tue, 27 November 2007 08:32 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

It is depends on your database type and size.
You should start with lower limit example: 1gb for each database.
after check your workload on database if nesseccary to increase sga size then increase.
Previous Topic: Adding Data_file
Next Topic: Unable to capture pl/sql dbms_output using shell script while running it through browser
Goto Forum:

Current Time: Fri Feb 23 13:43:37 CST 2024