Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    3

    Question Unanswered: sort_area_size in Oracle 9i/9.2

    Since 9i, Oracle does not recommend using the SORT_AREA_SIZE parameter unless the instance is configured with the shared server option. Oracle recommends that you enable automatic sizing of SQL working areas by setting PGA_AGGREGATE_TARGET instead. SORT_AREA_SIZE is retained for backward compatibility.

    My question is: for Dedicated server with both PGA_AGGREGATE_TARGET and SORT_AREA_SIZE specified in the pfile, does Oracle ever use the sort_area_size?

  2. #2
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    hi,

    sort area size will be ignored.
    see Note:223730.1 on metalink about this.

    Hope this helps.
    Edwin van Hattem
    OCP DBA / System analyst

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •