From rabbit@emirates.net.ae Mon, 23 Jun 2003 21:25:43 -0700 From: rabbit@emirates.net.ae Date: Mon, 23 Jun 2003 21:25:43 -0700 Subject: Re: RE: SMON taking 50% of CPU and certain queries hanging Message-ID: MIME-Version: 1.0 Content-Type: text/plain By the way it was an Application upgrade not O/S or database - I should have been more clear. ----- Original Message ----- Date: Monday, June 23, 2003 10:29 pm > Sam, > > Can you check if PQ is enabled (via PARALLEL_* ) and you have > PDML/PQ in use > because of DB objects or queries? If so, the you might be > overwhelming the > number of CPUs in the system via too many PQs/PQ servers. If the > key word is > 'upgraded a test server' as in an OS upgrade on AIX, then you > should check > if you have lost previous values of AIO (configured via SMIT AIO). > > John Kanagaraj > Oracle Applications DBA > DBSoft Inc > (W): 408-970-7002 > > Grace - Getting something we don't deserve; Mercy - NOT getting > something we > deserve > Click on 'http://www.needhim.org' for Grace and Mercy that is freely > available! > > ** The opinions and statements above are entirely my own and not > those of my > employer or clients ** > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Monday, June 23, 2003 4:49 AM > > To: Multiple recipients of list ORACLE-L > > Subject: SMON taking 50% of CPU and certain queries hanging > > > > > > I recently upgraded a test server and found out today that it > was > > hanging. SQLPLUS etc... > > I checked alert log and found following errors > > WARNING: aiowait timed out 1 times > > WARNING: aiowait timed out 2 times > > > > I shutdown and restarted and since then Ive noticed that only > > certain queries hang and the SMON process is running at 50% CPU. > > > > This Test service has been running for ages, allthough I did do > an > > upgrade to the Application a week ago. > > > > Its the end of day so I will leave it running and see if SMON > > finishes. > > Ive checked space etc..checked metalink briefly but if any of > you > > can give me some suggestions I will try them. > > > > thanks > > > > Sam > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: > > 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). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: John Kanagaraj > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).