Re: help: CPU usage

Dave Apple wrote:
>
> Hi folks
> any ideas?
>
> our application is running fine, with statements tuned as much as possible
> but there is still a problem with what looked like locking when multiple
> users were active.
>
> after investigation, it turned out that the CPU was simply busy with the
> first request so could not process the second until the first was complete.
>
> I am surprised by this as of course i need all the users to get good
> response times and not be 'queued' for the cpu.
>
> is there any way to limit/smooth the cpu usage for the users? (not an
> absolute max returning an error like from the profile, but a high watermark
> so no one user can clog up the system)
>
> thanks
>
> Dave

DAve
What O/S are you on? If its one the modern Unix's (Solaris 2.6 or greater can do it and others can prob do it as well). If one process is clogging the system, how are your locks set during this time, and what sort of parallalism have you got set in Oracle and how many CPUs in the host itself.

martin Received on Thu Dec 16 1999 - 03:25:07 CST