Re: Resource Manager - general questions

My experience has been that Resource Manager requires a massive over-demand on CPU before the expected behaviour starts to show. Your test was with a 200% load - try 300% or 400% and you may then see that the actual split gets closer to expectation, with the lower-privileged processes losing time in a wait state whose name includes 'resmgr: ....{something}..'

I don't think the max_est_exec_time applies withing pl/sql, as I believe it is based purely on costing SQL statements individually.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )

____UK_______March
____USA_(FL)_May


Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


Ron Boggs wrote in message ...


>We just fired up the resource manager under 9i last week and I have

>some general questions.  Any feedback would be appreciated.

>

>For instance...with consumer group 1 getting 99% of the CPU and group

>2 getting 1%...I expect significant difference in actual response

>time.  I'm seeing 20-21 seconds for the first group and 22-23 seconds

>for the other.  Again, the CPU is 100% while these processes are

>running.  Any explanation is to why RM isn't having a bigger impact?

>

>2)  Does the 'max_est_exec_time' work with PL/SQL?  I can set it down

>to "1", but the PL/SQL process I'm using will still run to

completion.


>