Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Resource Manager on 8i: an underestimated tool or what ?
In two years of asking, I've encountered 2 students who use it and are happy
with it. I know of 6 sites that backed it out after performance woes ensued
following its deployment.
All anecdotal, of course.... Point being, if you get into developing fancy plans, it can all end up being sufficient rope with which to hang yourself.
Actually, if you had 9i, I'd consider it worth investigating for its ability not to start jobs the optimiser predicts will take too long.
But I have my doubts about it in 8i.
Regards
HJR
"FC" <flavio_at_tin.it> wrote in message
news:LqOu9.38088$aL4.1165263_at_news1.tin.it...
> Hello folks,
> a search on "resource manager" in this archived newsgroup ended up with a
> handful of messages, the most interested of them being actually unanswered
> questions.
> This sounds somewhat surprising to me, as the most widely used tools or
> techniques normally bring about neverending discussions or interesting
> problems. In this case there were none.
> So, my questions follow:
> - Should I afford using this tool to balance resources among users or am I
> wasting my time?
> - Is there any danger in using the Resource Manager package on a
production
> system?
>
> I ran a few tests, very elementary indeed, and I've got positive feeling
> with this tool, I mean, my objective was to verify that with a certain
> balancing scheme a users' group was consuming a given amount of CPU
(higher
> or lower than a different group) and it worked fine, so I was about to
> deploy it, but, again, I am quite surprised to see almost no activity on
> this subject.
>
> I am speaking 8.1.7, Windows 2000-wise.
> Thanks,
> Flavio
>
>
>
Received on Sun Oct 27 2002 - 03:56:21 CST