How good is Oracle's Resource manager and do people really use it.

I havent heard a lot about it. Can you please share your sucess stories or failure stories while working with Resource Manager.

We are thinking of using it in our office thats the reason i just wanted a heads up on it.