Re: assign a priority to a request

Fair enough. Bear in mind that 9i has a feature with Resource Manager whereby if a statement is estimated (by the Optimizer) to take longer than a certain amount of time, it can switch consumer group automatically. Normally, the idea would be to switch a long-running report into a lower-resourced group, but there's no reason why you shouldn't do it the other way round: switch a particularly-demanding job into a higher-resourced group so it gets it over and done with.

But yeah, that automated switching requires 9i.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Frederic Payant" <fpayant_at_club-internet.fr> wrote in message
news:pvkq7u06a5kmrks7mmk71l5o9ps10c6ag7_at_4ax.com...


> Thanks for your advice.

> We won't use it because it doesn't match our needs (our goal is more

> to rise priority of a peculiar procedure at a peculiar moment), but I

> keep it in mind as it could be useful for other purpoises.

>

> Regards

> F. P.

>