Oracle taking 100% CPU
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
Re: Oracle taking 100% CPU
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= log file , or analyze the redo log (archivelog via logmnr). Knowing what oracle is doing, and you can manage to let= oracle work for you again. Good luck. =3D=3D=3D=3D=3D=3D=3D=3D 2002-11-12 02:18:00 =C4=FA=D4=DA=C0=B4=D0=C5=D6=D0=D0=B4=B5=C0=A3=BA =3D=3D=3D=3D=3D=3D=3D=3D 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 =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2 =C0=F1=A3=A1 =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1chao_ping [EMAIL PROTECTED] =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-11-12 --=002_Dragon206281065310_= Content-Type: text/html; charset=GB2312 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META content=3Dtext/html; charset=3Dgb2312= http-equiv=3DContent-Type META content=3DMSHTML 5.00.3315.2870 name=3DGENERATOR/HEAD BODY bgColor=3D#eaeaeaFONT size=3D2FONT face=3D=CB=CE=CC=E5Hussain Ahmed= Qadri=A3=AC=C4=FA=BA=C3=A3=A1/FONT /FONT DIVnbsp;/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2=A1=A1=A1=A1Hi, take a look at what oracle is= doing, from v$sql and alert log file , or analyze the redo log (archivelog via logmnr)./FONT/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2nbsp;nbsp;nbsp; Knowing what= oracle is doing, and you can manage to let oracle work for you again./FONT/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2nbsp;nbsp;nbsp; Good= luck./FONT/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2nbsp;nbsp;nbsp; /FONT/DIV DIVnbsp;/DIV DIVFONT face=3D=CB=CE=CC=E5 size=3D2=3D=3D=3D=3D=3D=3D=3D=3D= 2002-11-12nbsp;02:18:00nbsp;=C4=FA=D4=DA=C0=B4=D0=C5=D6=D0=D0=B4=B5=C0=A3=BA =3D=3D=3D=3D=3D=3D=3D=3D/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2 TABLE width=3D100% TBODY TR TD width=3D100% BLOCKQUOTE style=3DBORDER-LEFT: #00 2px solid; MARGIN-LEFT: 5px;= MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px PFONT size=3D2HI all,/FONT /P PFONT size=3D2We 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)/FONT/P PFONT size=3D2There 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./FONT/P PFONT size=3D2Any ideas, its somewhat urgent./FONT= /P PFONT size=3D2Hussain/FONT /P/BLOCKQUOTE/TD/TR/TBODY/TABLE/FONT/DIV DIV PFONT face=3D=CB=CE=CC=E5
RE: Oracle taking 100% CPU
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 Oracle will take care of itself without intervention. My first thought is that you had a lot of pending work since it couldn't archive. Then you killed sessions which means Oracle must roll back transactions. Offhand it sounds like Oracle is still recovering. Look for heavy disk activity. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 12, 2002 4: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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle taking 100% CPU
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 with Temporary tablespace as it had gone up to 10GB and all of it was being used. Although now temporary TS is down to 50% usage but smon is taking hell of a long time to clean up, don't you think. So that's why, as per my discussion with Regis, I have created another temporary tablespace and assigned it to all the users and trying to drop the old temporary tablespace, but haven't had much luck with it. Any ideas -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 12, 2002 5:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle taking 100% CPU 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 Oracle will take care of itself without intervention. My first thought is that you had a lot of pending work since it couldn't archive. Then you killed sessions which means Oracle must roll back transactions. Offhand it sounds like Oracle is still recovering. Look for heavy disk activity. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 12, 2002 4: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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle taking 100% CPU
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 free up space unless you reboot the server. Hope this helps. Sergei. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hussain Ahmed Qadri Sent: Tuesday, November 12, 2002 2:19 AM To: Multiple recipients of list ORACLE-L Subject: 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
