DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Sort Area Size Question

  1. #1
    Join Date
    Jan 2001
    Posts
    515
    Since the sort area size is allocated for every user, can you dynamically change one users sort area size? So if you had someone running a large query with a lot of sorting, is there a way to say something like alter session sort_area_size 10M;?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    yes, try it

  3. #3
    Join Date
    Jan 2001
    Posts
    515

    syntax??

    is my syntax correct?

  4. #4
    Join Date
    Oct 2000
    Posts
    467
    almost. its alter session set sort_area_size = n

    Pls note that by reducing this value for the session, your sorts will turn to disk in the temp segments. Also reducing this at session does not change the actual value of sort_area_size for other sessions.
    Vinit

  5. #5
    Join Date
    Jan 2001
    Posts
    515

    thanks

    thank you...

Posting Permissions

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


Click Here to Expand Forum to Full Width