Oracle Resource Manager Primarily used to limit a user/group using too much resources but by doing that to all groups other than APPS it would achieve your goals ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of edwin devadanam Sent: 09 August 2007 13:35 To: oracle-l@xxxxxxxxxxxxx Subject: Functionality that allows us to prioritize traffic or system usage for different users 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/webhos ting/?p=PASSPORTPLUS>