Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Responsiveness of Server at high CPU load
"Rick Denoire" <100.17706_at_germanynet.de> wrote in message
news:bptutv4qmvps97fbo234irlh7dhd8pqg4m_at_4ax.com...
> (Excerpt from a TAR - still open)
>
> From time to time, our Oracle test server (9.2.0.4 on Intel/Linux, 2
> CPUs) got unusuable at CPU load of 99% as shown by top; in this state,
> nothing else could be done with Oracle, even trying to connect via
> sqlplus took about 1 hour (assuming one would wait that long).
> Processes running were Oracle processes and kswap (meaning that
> swapping was heavily taking place).
>
> After analyzing lots of things we found out that nothing seems to be
> wrong with the database - it is just that a very inefficient query is
> running which blocks the Oracle server and avoids any other activity.
My limited exposure to Oracle 9 on RH Linux would suggest one, and quite possibly all, of the following, in order: