RE: SGA/PGA question
- From: kathy duret <katpopins21@xxxxxxxxx>
- To: Ron.Reidy@xxxxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Sun, 3 Sep 2006 06:43:33 -0700 (PDT)
Check your semaphors and your solaris setting but it does sound like you need at least 3G of memory. I have 3G for this many connections on Windows. Also MTS creates performance issues. Try to go with connection pooling on the app end. IF .Net check for garbage collections ...Check to make sure the app is closing connections, no leaks In the meantime, see if you can lower large pool, java pool, open_cursors, session cached cursors for a quick fix in the mean time. Been there done that with windows... Having bad flash backs now. Kathy "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx> wrote: 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 -- http://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. -- http://www.freelists.org/webpage/oracle-l --------------------------------- Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail.