Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SORT_AREA_SIZE and PGA_AGGREGATE_TARGET

I am using SAP R/3 kernel 4.6D with oracle 10g.

I found that in init.ora file SORT_AREA_SIZE is still defined even if the PGA_AGGREGATE_TARGET is defined and since the datbase is 10G WORK_AREA_SIZE_POLICY is by default auto.

I would like to know is the SORT_AREA_SIZE is required specifically (I mean to say whether SAP uses anywhere in its application "alter session set workarea_size_policy = manual;" kinda statement?) for SAP otherwise automatic PGA management is supposed to manage the scenario...

Shall I remove SORT_AREA_SIZE from the init.ora?

Regards,

replied

SORT_AREA_SIZE is no longer required in SAP environments as soon as you set WORKAREA_SIZE_POLICY = AUTO.

Kind regards

Martin

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question