It can be done using resource profiles, though they are only useful when resources at 100% usage. On 8/9/07, edwin devadanam <edwin_kodamala@xxxxxxxxx> wrote: > > Hi, > Is there any way..............!!!!!!! > > is there any way to be able to give priority to the application (which > runs under user APPS) as compared to normal users executing SQL statements > under their own database account? > > our db is 10.2.0.2 on HP-UX > and apps version 11.5.10.2 > Regards, > Edwin.K > > ------------------------------ > Building a website is a piece of cake. > Yahoo! Small Business gives you all the tools to get > online.<http://us.rd.yahoo.com/evt=48251/*http://smallbusiness.yahoo.com/webhosting/?p=PASSPORTPLUS> > > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'