Results 1 to 2 of 2

Thread: Pga

  1. #1
    Join Date
    Jun 2003
    Posts
    45

    Unanswered: Pga

    Hi all,
    What is the need of Both pga_aggregate_target and sort_area_size

    in Oracle 9i?.

    Both are same?

    Pls explain

    regards
    sudheer

  2. #2
    Join Date
    Feb 2004
    Posts
    20
    plz go through the oracle documentation. it is written there that SORT_AREA_SIZE is retained for backward compatibility.
    oracle recommends that use pga_aggregate_target now.

    hope it will solve ur query

Posting Permissions

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