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).
Received on Mon Jun 23 2003 - 23:25:43 CDT
