Re: Setting sort_area_size for another session

What version are you using? If you are using 8i or above, an after logon trigger should work

"Jens Lundell" <lundellj_at_saic.com> wrote in message news:c4fbc557.0111261028.115bbf7f_at_posting.google.com...

> 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

-- 
Posted from d225s240.hotbank.com [63.83.225.240] 
via Mailgate.ORG Server - http://www.Mailgate.ORG