Resource Manager: switch back to default group [message #183273] |
Thu, 20 July 2006 04:06 |
hellcat
Messages: 84 Registered: January 2006 Location: Zug, Switzerland
|
Member |
|
|
hi
I'm playing around with Resource Manager - scenario:
a session gets switched from a high-resource group (default for this user) to a low-resource group after 10 mins the query runs. it finishes after 20 mins in the low-resource group. for the next query ran by this session oracle still uses the low-resource group for this session.
but I'd like it to use the high-resource group for the next query in this session again.
can one set up an automatic mechanism to achieve this?
thanks &
regards
br
|
|
|