Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2014

    Unanswered: sort_area_size limited to 2GB?

    I want to increase the size of sort_area_size to 8GB for some experimental reasons, but alter session command is giving integer value required error after 2GB,even for _smm_max_size, the scenario is same.
    pga_target,memory_target are set to more than 10GB.
    Can anybody give me valid reasons for this error...?

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >Can anybody give me valid reasons for this error...?
    ERROR? What Error? I don't see any error.

    Actual solution is version specific & you decided to not share your version with us.

    Tuning General Parameters for Parallel Execution
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Tags for this Thread

Posting Permissions

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