Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle taking 100% CPU
Hello. I used to run Oracle 8.1.7 on Win2000. I had a similar problem
with oracle taking 100% CPU for no apparent reason. Check the version
of service pack, installing the latest will help.
Does Oracle archive now? Sometimes, oracle does not see if you free up space unless you reboot the server.
Hope this helps.
Sergei.
-----Original Message-----
Ahmed Qadri
Sent: Tuesday, November 12, 2002 2:19 AM
To: Multiple recipients of list ORACLE-L
HI all,
We have a development server, a replica of the production. Some process
produced a lot of archives and it ran out of archiving space. Now it was
the only location specified for the archives and it was mandatory. So
when no space was left on it to store the newly produced archives, it
should have stopped working. But it didn't. I deleted the archives and
closed every session and shut down the database and restarted it. But
eversince I restarted it, (and I have done it 3-4 times already) Oracle
is using 100%CPU. I have left the server on, without any body connecting
to it, (users can connect as the database is OPEN without any problem,
its just some transaction-cleaning or background process which is going
on) but the server remains unchanged i.e. using 100% for over an hour
(after an hour I shut it down and restarted and it still is the same)
There is no unusual entry in the alert lofile or any trace files. I
can't do any query to find out anything, as the system is so slow. There
is no problem of space either. "Event viewer" of Win2000 also shows
nothing unusual or new.
Any ideas, its somewhat urgent.
Hussain
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergei INET: sergei_at_netflip.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Tue Nov 12 2002 - 13:19:02 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |