Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: relation shared pool elements phys mem

RE: relation shared pool elements phys mem

From: Jeroen van Sluisdam <jeroen.van.sluisdam_at_vrijuit.nl>
Date: Fri, 6 Aug 2004 19:21:46 +0200
Message-ID: <727A513477946E4380C23DD63C36FCC0F0451E@pedro.vrijuit.nl>


I'm sorry I forgot to mention some detail: I have 1 Gb available, HP-UX 11.11,
Oracle 9.2.0.4 I already use mts as default because in Our production environment it is necessary and we want development to Be as close as possible. Already downsized sga including buffers. Large pool was set to 5 mb. Runnning 2 databases with Total sga around 120 Mb each.

Still top shows around 5 to 8 Mb free memory. Unix shells are acting weird Also, hanging for several seconds. The errors come with starting a new Sqlplus session now and then. Dedicated connections for example A oem session of my client I don't have sofar

 Didn't see anything strange in syslog. Have these problems for Months now but were not important up till now several new development projects are starting. The shmax parameter is set to 1 Gb. I would like to Understand what the possible relations are between sga and memory usage on OS level. I know SGA has to fit into 1 memory segment. But is there any default memory segment size such that my 1Gb is already up with 2 db'es running? I don't have glace available. Any other trics to measure how much Memory is used by which process?

Tnx,

Jeroen




Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

-----------------------------------------------------------------
Received on Fri Aug 06 2004 - 12:13:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US