Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database slowed down and consistently taking up 25% of the CPU; like a zombie.
"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