Oracle-L: Re: Hanging query puzzle

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 05 Feb 2003 13:20:05 -0800
Message-ID: <F001.00544FF4.20030205132005@fatcity.com>

It looks like your process really is stuck in a way that has nothing to do with the Oracle code directly.

You might look at the CPU usage of your
session and its shadow using an O/S
utility, but I suspect it would show
zero CPU. Perhaps truss (or the AIX
equivalent) might show your process
spinning on whatever call equates to
'has the async read completed yet'.

You could try doing three processstate
dumps with 5 second intervals to see if
the processstate shows any changes
which might give you a hint - but again
I'd GUESS that you'll find nothing happening.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

____UK_______March 19th
____USA_(FL)_May 2nd

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: 05 February 2003 21:05

>Still sitting there, while we try to figure out exactly why it's
waiting.
>
>
> SID Username EVENT
>WAIT_TIME STATE SECONDS_IN_WAIT
>----- ---------------- ----------------------------------------------

>---------- ------------------- ---------------
> 1 pmon timer
>0 WAITING 79579
> 5 smon timer
>0 WAITING 80
> 12 slave wait
>0 WAITING 199
> 13 slave wait
>0 WAITING 199
> 14 slave wait
>0 WAITING 262
> 15 slave wait
>0 WAITING 199
> 28 NIK db file scattered read
>0 WAITING 20119
>
>-----Original Message-----
>Sent: Wednesday, February 05, 2003 2:58 PM
>To: ORACLE-L_at_fatcity.com
>Cc: Thomas Jeff
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

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: ListGuru_at_fatcity.com (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 Wed Feb 05 2003 - 15:20:05 CST