Re: Restricting user's resource access

Jonathan Lewis wrote:
>
> 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 !!
> >

Its the MAX_EST_EXEC_TIME directive...

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."