Re: help: CPU usage

And you don't post any details about your Oracle version, O/S and hardware config?
Then you should expect any answers, as your question is far to general. What you describe is since the advent of the computer known as the 'Von Neumann bottleneck'
The only generic advice I can give you is somehow you need to adjust the size of each CPU timeslice.

Hth,

--
Sybrand Bakker, Oracle DBA
Dave Apple <pippin_at_xs4all.nl> wrote in message news:FU164.373$i01.18840_at_amoeba1.soneraplaza.nl...
> 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
>
>
>
>
Received on Thu Dec 16 1999 - 14:03:08 CST