OraFAQ Forum: Performance Tuning » Using Consumer groups

Home » RDBMS Server » Performance Tuning » Using Consumer groups

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Using Consumer groups [message #109121]

Tue, 22 February 2005 04:35

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Hi all,

I have set up a SQL-Plan for using consumer groups.
My szenario is :
1st Plan : ERP Users 90 % Overall Performance
2nd Plan : Named Users 10 % Overall Performance

within 2nd Plan :
read users 90 %
r/w users 10 %

We do need to grant also the r/w access with this performance.
Will it be better to place the consumer groups to the profiles instead of the users ?
I will attach my script for building the plan
Any hints and helps welcome

Attachment: Resource manager.sql
(Size: 2.53KB, Downloaded 1891 times)

Report message to a moderator

Previous Topic:	Re: materialized view
Next Topic:	Replace Outer Join with Unions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 15 20:27:11 CST 2026