Re: Virtual Memory Size of Dedicated Server Process

Suppose you're on UNIX. Try /usr/proc/bin/pmap -x [pid]. The shared memory portion (Permission: read/write/exec/shared; Mapped file: [shmid=0x2]) is from SGA. This is the most detailed picture you can get.

I don't know how to explain the Shared column shows a dash -.

Yong Huang
yong321_at_yahoo.com

dora <dora_at_hotpop3.com> wrote in message news:<3B66B089.E58264E7_at_hotpop3.com>...
> Hi,
>
> I have an instance running on one machine and another instance running
> on another machine. The only difference between the two are the value
> set to the parameter SHARED_POOL_SIZE. The virtual memory size of the
> dedicated server process (just simply a sqlplus session doing nothing)
> is 135MBytes on one machine and 260MBytes on another machine. Can
> someone tell me how Oracle allocate memory to dedicated server process?
> What are the components of the dedicated process?
>
> Thanks
> Ng
Received on Wed Aug 01 2001 - 23:45:54 CDT