]] On Behalf Of Miller,
Jay
Sent: Saturday, November 23, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L
Subject: Do user processes apply against shmmax limit?
Hi everyone,
I was always under the impression that the only concern with shmmax
was
that
it be large enough for the SGA
quite a bit with paging/swapping.
Rich
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
On Behalf Of Miller,
Jay
Sent: Saturday, November 23, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L
Subject: Do user processes apply against shmmax
limit
user processes apply against shmmax limit?
Hi everyone,
I was always under the impression that the only concern with shmmax
was
that
it be large enough for the SGA to fit into it. One of my System
Administrators has just told me that the individual user processes
(i.e.,
the PGA
... and we butt headlong into another fine myth, that is that
the SGA must fit into one segment.
On Sunday 24 November 2002 15:53, Richard Ji wrote:
if that SGA + user processes shmmax the system will start swapping.
That's not true. If your SGA is bigger than shmmax, it just means
the
To: Multiple recipients of list ORACLE-L
Subject: Do user processes apply against shmmax limit?
Hi everyone,
I was always under the impression that the only concern with
shmmax was that
it be large enough for the SGA to fit into it. One of my System
Administrators has just told me that the individual
if that SGA + user processes shmmax the system will start swapping.
That's not true. If your SGA is bigger than shmmax, it just means
the SGA will be fit into multiple shared memory segments. Doesn't
necessary mean the system will start swapping. Is the scan rate
going up?
Richard
Hi everyone,
I was always under the impression that the only concern with shmmax was that
it be large enough for the SGA to fit into it. One of my System
Administrators has just told me that the individual user processes (i.e.,
the PGA since we're not using multi-threaded server) get added to the
Your Sys Admin is wrong. The SHMxxx OS parameters refer to shared memory,
not private process heap memory. On most UNIX variants, the ulimit
command is used to limit the consumption of memory for heap, stack, etc...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
most disturbing is the thought that this person IS the sysadmin with
this level of knowledge.
--- Tim Gorman [EMAIL PROTECTED] wrote:
Your Sys Admin is wrong. The SHMxxx OS parameters refer to shared
memory,
not private process heap memory. On most UNIX variants, the ulimit
command is
Tim,
Unless shared servers (MTS) are in use, in which case either the
UGA or PGA is in the SGA.
To be honest, I can't recall which, and I'm too lazy to go look it up
right now. But MTS will consume memory on a per user basis, though
the poster didn't mention it. And I'm quite sure you know
**
-Original Message-
From: Miller, Jay [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 23, 2002 10:49 AM
To: Multiple recipients of list ORACLE-L
Subject: Do user processes apply against shmmax limit?
Hi everyone,
I was always under the impression that the only concern with
shmmax
11 matches
Mail list logo
