This content has been marked as final. Show 3 replies
If you have Enterprise Edition licences, then this is what the Resource Manager is made for. You would need to map sessions to a comsumer group based on the client program rather than schema logon.
Oracle Certified Master DBA
Resource manager, I never try this but you create Profile and assign user to it .
you can limit user resources through profile and Database resource manager but profile are statics so DRM is the best solution. create cosumer group and resources planes and assign plane to consumer group.
consult below link