RE: SGA/PGA question
- From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- To: <Harvinder.Singh@xxxxxxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 25 Aug 2006 14:30:36 -0600
You appear to be memory starved. Go with the IBM solution - Install
Bigger Memory.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Harvinder Singh
Sent: Friday, August 25, 2006 2:24 PM
To: ORACLE-L
Subject: SGA/PGA question
Hi,
We have 10.1.0.3 installed on sun solaris 10 having 2GB RAM and 2GB swap
file. In our system 4-5 application starts at same time and each
requires about 180 connections to the database. So about 900~ processes
can be connected at the same time and we have set the following
parameters:
Processes = 1000
Pga_target = 200MB
SGA_TARGET = 600MB
We are using the dedicated server model and getting following error
frequently and also notice that physical RAM drops to 0 MB free:
Ora-12500 (unable to start the dedicated process)
Since this is just a development box, so to fix this issue we are
planning to move to MTS model.
Is there any other way to solve this issue, if we have to go to the MTS
model what should be the value of PGA and SGA to be set?
Thanks
--Harvinder
--
//www.freelists.org/webpage/oracle-l
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is
intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
