PX Deq wait

From: David Sharples <dsharples_at_cerebrussolutions.com>
Date: Wed, 9 Jun 2004 13:46:12 +0100
Message-ID: <EA29A3FCC723674293FD6286D3F0513E77C0CA@louis.cerebrus.com>

Hi, had a little problem today.

Had a process which had been running for over 24 hours (should take about 15 secs) it was waiting on PX Deq Credit: send blkd.

It was a job which did some inserts, statspack was telling me no i/o was being done on the objects at all. Is it possible that the parallel slaves had died so my process never knew it had finished, no trace files were generated and nothing in the alert log, killing the process and restarting it fixed it

Is there somewhere else I can look next time to see what has really happened?

Thanks

---

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 Wed Jun 09 2004 - 07:39:57 CDT