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