Re: 9.0.2 64-bit on redhat 3.0r2 AMD64 (4-way) 17G RAM

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: 31 Aug 2004 10:40:23 -0700
Message-ID: <d4d6f278.0408310940.524aadb4@posting.google.com>

No actually the pga_aggregate_target is NOT per session it is for the whole database.

The oracle doc is somewhat confusing and not well written about this parm but there is some kind of limit that no session can use more than some percentage of the pga_aggregate_target.

There some tuning views that you can query to check "predictions" of how useable different sizes for the pga_aggregate_target is ... or of course the gui "tuning advice" through the oem. Received on Tue Aug 31 2004 - 12:40:23 CDT