max_estimated_exec_time

Hello,

I have a question relative to Oracle 9.2.0. The resource manager includes a directive MAX_ESTIMATED_EXEC_TIME which is valued in seconds.
According to me just specifying this directive is enough to prevent a query from running if the CBO estimates a duration greater then MAX_ESTIMATED_EXEC_TIME. I've heard that it is also necessary to set the directive SWITCH_ESTIMATE to true.
It is not clearly specified in the documentation. What are your opinions and experiences about it ?

Thanks in advance
David Coste
OCP 8i Received on Wed Dec 10 2003 - 07:28:40 CST