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
This is a multi-part message in MIME format.
--=002_Dragon206281065310_=
Content-Type: text/plain;
charset=GB2312
Content-Transfer-Encoding: quoted-printable
Hussain Ahmed Qadri=A3=AC=C4=FA=BA=C3=A3=A1
=A1=A1=A1=A1Hi, take a look at what oracle is doing, from v$sql and alert=
Hussain - Once you clear up some archive space, Oracle will resume
immediately. You don't need to bounce the database.
What is the system doing besides taking 100% cpu? W2K Task Manager offers
much more information, like I/O activity and CPU by process. This may
provide more clues.
Normally
Title: RE: Oracle taking 100% CPU
The CPU becomes normal after the database is shutdown. So it's Oracle that is causing problems. I thought that it would be some rollbacking and roll-forwarding going on but, since morning, I don't think so. So I have some clues that it has something to do
Title: 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