My turn for the cold shower.
I'd missed that feature completely.
Thanks.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminars
UK Sept
Australia August
Malaysia September
USA x 2 November
http://www.jlcomp.demon.co.uk/seminar.html
Richard Foote wrote in message ...
>Yes you can set up Resource Manager to "switch" this expensive code into
>another consumer group which may have lower priority CPU (rather than just
>failing the code). However the default is to have "SWITCH_GROUP" set to
>null.
>
>To test, I assigned a user to a consumer group which was in a resource plan
>with a max_est_exec_time = 2 (meaning 2 seconds, I only run "really"
>efficient code here).
>
>After activating the plan, I connected as this user and tried to run a
piece
>of code but received the following error:
>
>ERROR at line 1:
>ORA-07455: estimated execution time (67 secs), exceeds limit (2 secs)
>
>even though the user was the only one logged on. CPU was at zip. Oracle
>aborted this sql before it even started !!
>
Received on Mon Jul 22 2002 - 00:53:48 CDT
