Re: Setting sort_area_size for another session

In article <vcwM7.81013$XJ4.43922236_at_news1.sttln1.wa.home.com>, "Jim Kennedy" <kennedy-family_at_home.com> wrote:

> Not that I know of. Maybe get them to buy the extra RAM or fix the bad
> sql. They should be willing to fix the problem; it is unlikely they
> actually know it is a problem and you would be doing them a massive favor
> to tell them where the problem is. If they act defensive then bump the
> problem up the chain. Although good customer service organizations will
> listen nicely and help to fix it.
> Jim
> "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.

The same trick that I've mentioned in connection with SQL_TRACE (db trigger) will also work here. Modification is trivial.

-- 
Mladen Gogala