Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Functionality that allows us to prioritize traffic or system usage for different users
Add the use of services to this with the resource manager, you can then
tune usage by service, allowing a service to only have so much resource
between certain times.
Your SQL users then use a different service, you can create all sorts of
services and use them to control your BI access, other SQL access eg
Access, Excel if you have them in use.
Cheers
Peter
From: Andrew Kerber [mailto:andrew.kerber_at_gmail.com]
Sent: Thursday, 9 August 2007 10:44 PM
To: edwin_kodamala_at_yahoo.com
Cc: oracle-l_at_freelists.org
Subject: Re: Functionality that allows us to prioritize traffic or
system usage for different users
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_at_yahoo.com> 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<http://us.rd.yahoo.com/evt=48251/*http://smallbusiness.yahoo.com/webhos ting/?p=PASSPORTPLUS>
________________________________
Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online.
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 09 2007 - 17:26:15 CDT
![]() |
![]() |