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

As Sybrand says, we need more clues;
however there are two common culprits
a) A job-queue process (look at init.ora

    parameters related to job_queue). It may     be reasonable to deal with this problem     by disabling job queue processing
b) smon struggling to clear up an earlier problem

    with temporary space, and massive numbers of     extents left in your temporary tablespaces.     In which case you just have to wait for the     work to complete. In this case, make sure you     have a reasonable extent size set for your     temporary tablespaces so that you don't     end up with more than a couple of thousand     extents.

--
Jonathan Lewis

Host to The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

Seminars on getting the best out of Oracle
See http://www.jlcomp.demon.co.uk/seminar.html






Huoy-Jii Khoo wrote in message <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

>

>

>