Re: CPU Usage 100%

From: Chuck <chuck_hamilton_at_yahoo.com>
Date: Thu, 29 Nov 2001 08:39:46 -0500
Message-ID: <9u5dqe$6b7sm$1@ID-85580.news.dfncis.de>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

My suggestion would be to kill the S001 process and let PMON restart it.

We see this sometimes in a dedicated server environment where a session ends abnormally. In v$session it is either no longer there or is inactive, but the corresponding server process is chewing up CPU cycles like crazy. We just do a "kill -9 pid" to clean it up.

"AnupJ" <anup_jalan_at_hotmail.com> wrote in message news:8809e8e2.0111290003.57067c63_at_posting.google.com...
> I have Oracle 8.1.7 & am using its Apache web-server, on Solaris.
>
> Some user disconnected after asking for a page that is generated
> using JSP & is based on data returned by a query.
>
> Since then, the CPU usage has gone up to 100%.
>
> I have Oracle configured to use 4 shared server processes. Unix
> command prstat shows that the server process S001 is using all the
> cpu time.
>
> This has been going on since more than 1 day, even though there are
> no users currently connected to Oracle or browsing the site.
>
> Thus, in the past 24 hours, cpu time used by the server process has
> increased by almost 24 hours.
>
> However, during the same time, Oracle v$sysstat reports total cpu
> usage has increased by hardly a few seconds.
>

Can anyone shed some light?

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPAY6m2m5A4kkb4ZsEQKriACfYc8w1kSI5DQIK7jy7t2YKj4o+S8AoOzT C6NuOS9SyFV69KxUIIrOln37
=VDf0
-----END PGP SIGNATURE----- Received on Thu Nov 29 2001 - 07:39:46 CST