RE: INSERT...SELECT pegs CPU, but is waiting on scattered read?

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Thu, 29 Apr 2004 12:14:56 -0700
Message-ID: <35CFD500D7BDCE43B9030BBA5979DC18015A35C1@ussccem13.hds.com>

Rich,

Can you do a quick snapshot-type comparison of v$sesstat values for that session (from another session of course)? This might show up Stats that may show what's occurring... I have used STATSPACK can snapshot a _session_ but don't have the details at the top of my head... (I think this is available in the STATSPACK readme file).

John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Disappointment is inevitable, but Discouragement is optional!

The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jesse, Rich
>Sent: Thursday, April 29, 2004 11:59 AM
>To: 'oracle-l_at_freelists.org'
>Subject: RE: INSERT...SELECT pegs CPU, but is waiting on
>scattered read?
>
>
>To make matters worse, the process is completely hung now,
>being 100% CPU
>bound with zero I/O:
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Apr 29 2004 - 14:09:17 CDT