Title: Oracle taking 100% CPU

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

Reply via email to