RE: Functionality that allows us to prioritize traffic or system usage for different users

From: Peter McLarty <p.mclarty_at_cqu.edu.au>
Date: Fri, 10 Aug 2007 08:26:15 +1000
Message-ID: <27AA2E9CA7A0C44283BC1E9B00086AA907970357@UNIMAIL.staff.ad.cqu.edu.au>

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
	



________________________________


	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.' 

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 09 2007 - 17:26:15 CDT