Oracle-L: RE: PGA

From: Ganesh Raja <gans_r_at_rediffmail.com>
Date: Mon, 31 Mar 2003 03:08:37 -0800
Message-ID: <F001.00576163.20030331030837@fatcity.com>

Your PGA directly Affects the Amt memory the OS has to shell out for Oracle Server Process so Increasing the Sort_Area_Size does not have immd effect but if your users are going to do a sort then your PGA can grow to a Maximum of Sort_Area_Size before being pulled down to the Temp Segments.

Just make sure u size it appropriatley.

HTH Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474

-----Original Message-----
Kumar
Sent: Monday, March 31, 2003 6:04 PM
To: Multiple recipients of list ORACLE-L

hello all,

how does increasing the value of SORT_AREA_SIZE affect the unix system perfomance.

Thanks
Arvind
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Arvind Kumar
INET: arvindk_at_sqlstarintl.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Ganesh Raja
INET: gans_r_at_rediffmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------