Howard J. Rogers wrote:
>
> 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
I've backed it out of 2 sites if thats what you mean by "use". They
were pretty raw (using the default delivered 'system_plan'), but because
they had several archive locations and remote transfer to standby et al,
we observed that whenever the background processes got busy (like
multiple arch's etc), the user processes basically got zilch cpu and
thus the database "hung" where "hung" means the users scream but gee
great, our archives made it over the standby in record time...!
Cheers
Connor
--
==============================
Connor McDonald
http://www.oracledba.co.uk
"Some days you're the pigeon, some days you're the statue..."
Received on Thu Sep 20 2001 - 16:52:21 CDT
