I THINK:
The low 4 digits is the slave number of the blocker.
(as in Pnnn, not the SID) or FFFF for the query
coordinator.
Somewhere in there, there is a clue about the
wait time - and I think it depends on the top
bit: there is a 'non-contentious ' wait time of
200 centiseconds, (0xC8) and any other time
is a contentious time. (A 'non-contentious '
wait time example: if the QC is reading
an order input from the slaves, the first will be
supplying, and the others will be idling with a
2-second wakeup, awaiting there turn)
So if you can see the slave that 's being wait for,
and a 0xC8 in the high word, then the slave
is twiddling it 's thumbs waiting to be told that
it is time to supply date.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users ' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated May 1st
-- -- Original Message -- --
From: "David Sharples " <dsharples@(protected) >
To: <oracle-l@(protected) >
Sent: Wednesday, June 09, 2004 1:46 PM
Subject: PX Deq wait
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
