Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Database slowed down and consistently taking up 25% of the CPU; like a zombie.

Re: Database slowed down and consistently taking up 25% of the CPU; like a zombie.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 23 Jun 2001 07:23:38 +0200
Message-ID: <tj89qmm2q20de7@beta-news.demon.nl>

"Huoy-Jii Khoo" <khoo_at_mcw.edu> wrote in message news:9h0g1d$mou$1_at_wiscnews.wiscnet.net...
> Another question will be anyone out there encountered problem like this?
>
> It doesn't matter what I do... I ever try to reboot the machine that
 hosted
> the Oracle DB (8.1.6 on Sun Solaris 2.7). From fresh, I startup the DB....
> then there is this process that belongs to oracle user starts using up to
 a
> max of 25% of my CPU power (and stay at 25%). The process just keep going
> and going and going.... never ends... like a zombie process....
>
> It slowed down everything and nothing much seems to respond in oracle. I
> can't ever do a shutdown immediate from svrmgrl....
>
> Thanks again in advance!
> khoo
>
>
>

Which process? What is it's name according to v$process and v$session. (The spid column in v$process is the Unix pid) Otherwise there aren't any clues to resolve your problem.

Hth,

Sybrand Bakker, Oracle DBA Received on Sat Jun 23 2001 - 00:23:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US