Re: RE: SMON taking 50% of CPU and certain queries hanging

Hi!

Last time I saw something similar, SMON was doing parallel rollback, because some long running transaction was aborted and the instance afterwards. Parallel rollback was awfully slow for some reason (Oracle 9.2 on linux), then I set parameter fast_start_parallel_rollback to false and rollback was done serially and completed quite fast.

But the symptoms were the same, SMON taking resource and some queries hanging - probably because they couldn't do a consistent read using rollback segments..

Tanel.
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 7:24 AM

> Sorry guys I was rushing as I was leaving.
>
> The OS is Solaris 8 and Database Oracle 8.1.7.4
>
> I came in this morning and everything is okay now: But I will now try
> and find what happened and if it starts again I will inform - thanks for
> replies and any more ideas please dont hesitate
>
> thanks
>
> Sam
>
> ----- 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  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).