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;?
Printable View
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;?
yes, try it
is my syntax correct?
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.
thank you...