Home » RDBMS Server » Server Administration » Resource Manager: switch back to default group
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
Previous Topic: Calculating Free Buffer Wait
Next Topic: temp01.dbf'
Goto Forum:
  


Current Time: Fri Sep 20 10:37:21 CDT 2024