Setting sort_area_size for another session

I know I can set sort_area_size (and sort_area_retained_size) at the instance level in init.ora and for "my" session using "alter session set sort_area_size = xxx". But is it possible to set sort_area_size for another session or for a specific user and/or user type? We have a third party application that (due to bad SQL) needs a BIG sort area but we can't afford to set that big sort area at the instance level.

Thanks,

-Jens Received on Mon Nov 26 2001 - 12:28:30 CST