Re: Virtual Memory Size of Dedicated Server Process

Thanks a lot.

Sybrand Bakker wrote:

> "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 Wed Aug 01 2001 - 09:16:16 CDT