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
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@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?
Regards,
Edwin.K
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.'
