RE: Functionality that allows us to prioritize traffic or system usage for different users
- From: "Peter McLarty" <p.mclarty@xxxxxxxxxx>
- To: <edwin_kodamala@xxxxxxxxx>
- Date: Fri, 10 Aug 2007 08:26:15 +1000
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@xxxxxxxxx]
Sent: Thursday, 9 August 2007 10:44 PM
To: edwin_kodamala@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@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/webhos
ting/?p=PASSPORTPLUS>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
