PGA size and server process

From: Woody Ling <woodyling_at_gmail.com>
Date: Tue, 3 Jun 2008 19:08:43 -0700 (PDT)
Message-ID: <bc22d936-d6e2-4741-99c4-6dbf0550dfc1@u36g2000prf.googlegroups.com>


Hi,

I am now using dedicated server connection and I set pga_aggregate_target=1G. I find that there are total 5 server processes running by "ps -ef | grep oracle$SID"

Does it mean that each server process can consume up to 1G so that the total PGA size is 5G?
or
1G PGA are shared by all server processes?

If it is shared by all server processes, why does it call "dedicated"?

How to check the current size of PGA?

Thanks.
Woody Ling
Hong Kong Received on Tue Jun 03 2008 - 21:08:43 CDT

Original text of this message