| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Hanging query puzzle
Jonathan, Charlie, Denny: Thanks for the replies. Our SA's claim that
there's
nothing wrong with the EMC SAN/disk. Finally, made them give me errpt
access (they
had shut off execute privs from all but them) and got a lot of output like
below.
The SAs are saying that this is only a sporadic 'repathing' error, as we
have
4 channels to the SAN, and does not affect the data in anyway, except for
possibly
some 'speed'. Now, 'sporadic' exactly describes the problem. I tracked
down the
dates on this errpt and they do correlate to the dates when we encountered
hang
problems in the database.
What exactly would they mean by 'repathing'? Possibly related to
Jonathan's hint
on spinning on 'has the async read completed yet'?
[indysdb02][/home/tmm_dbas/u26905]>errpt IDENTIFIER TIMESTAMP T C RESOURCE_NAME DESCRIPTION
79B0DF89 0205091603 P H hdisk7 DISK OPERATION ERROR 79B0DF89 0205091603 P H hdisk8 DISK OPERATION ERROR 79B0DF89 0205091603 P H hdisk13 DISK OPERATION ERROR 79B0DF89 0205091603 P H hdisk13 DISK OPERATION ERROR 79B0DF89 0205091603 P H hdisk12 DISK OPERATION ERROR 79B0DF89 0205091603 P H hdisk11 DISK OPERATION ERROR 79B0DF89 0205091603 P H hdisk9 DISK OPERATION ERROR 79B0DF89 0205091603 P H hdisk5 DISK OPERATION ERROR 79B0DF89 0205091603 P H hdisk3 DISK OPERATION ERROR 79B0DF89 0205091603 P H hdisk6 DISK OPERATION ERROR
-----Original Message-----
Sent: Wednesday, February 05, 2003 4:20 PM
To: Multiple recipients of list ORACLE-L
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
>----- ---------------- ----------------------------------------------
-- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Jeff INET: ThomasJe_at_tce.com 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 - 17:29:51 CST
 |
 |