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

From: John Kanagaraj <john.kanagaraj@xxxxxxx>
To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 29 Apr 2004 12:14:56 -0700

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@xxxxxxxxxxxxx 
>[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jesse, Rich
>Sent: Thursday, April 29, 2004 11:59 AM
>To: 'oracle-l@xxxxxxxxxxxxx'
>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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

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

Other related posts: