Re: Calling all Resource Manager Users...

One feature of Resource Manager I have heard about (but not tested) is the fact that you should now install Oracle with the o/s privilege level that allows it schedule itself, rather than being scheduled by the operating system. (On HPUX this is requires the RTPRIO, RTSCHED and one other privilege).

Apparently if Resource Manager is handling the scheduling, then Oracle will not suspend a process that is holding a latch. In theory this should make time lost due to latch contention a thing of the past (no more sleeps).

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

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

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Howard J. Rogers wrote in message <3ba83a0d_at_news.iprimus.com.au>...


>Does anybody actually use Resource Manager?  Does anybody salivate at the

>prospect of being able to set up active session pools or undo limits per

>Consumer Group in 9i?

>

>I ask because I have to teach it (ie, 9i New Features) next week, and for

>the life of me, I can't work out what new features are to die for, and what

>are yawn material.

>

>In particular, I haven't had a Performance Tuning course yet where people

>got excited about Resource Manager -and that was the 8i version.  So can

>anybody tell me how it actually changed their lives?   If you can, I'm

>particularly interested in what run-arounds you went through before

Resource


>Manager made life so much easier.  I'm also interested in Resource Manager

>horror stories.

>

>Regards

>HJR

>

>

>