Re: Virtual Memory Size of Dedicated Server Process

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 31 Jul 2001 18:54:05 +0200
Message-ID: <996598448.8842.0.pluto.d4ee154e@news.demon.nl>

"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
>

Program Global Area and User Global Area. Also because the process directly communicates with the SGA, it needs to map in the SGA in it's own workspace.
That is the explanation of your problem: the shared pool is in the SGA.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Tue Jul 31 2001 - 11:54:05 CDT