Removed descriptions from toResultWaitChains (server tuning / blocking locks).

[Gerard H. Pille]

To get a result that is readable (the descriptions should be used as column headers):

SELECT
osid W_PROC,
i.instance_name INSTANCE,
'INST #: '||instance INST,
decode(blocker_osid,null,'',blocker_osid)||'@i:'||blocker_instance BLOCKER_PROC,
num_waiters waiters,
decode(p.spid,null,'', p.spid)||' from Instance '||s.final_blocking_instance FBLOCKER_PROC,
p.program image,
wait_event_text wait_event,
wc.p1 p1,
wc.p2 p2,
wc.p3 p3,
in_wait_secs Seconds,
time_since_last_wait_secs sincelw,
chain_id ||': '||chain_signature chain_signature,
decode(blocker_chain_id,null,'',blocker_chain_id) blocker_chain
FROM v$wait_chains wc,
gv$session s,
gv$session bs,
gv$instance i,
gv$process p
WHERE wc.instance = i.instance_number (+)
AND (wc.instance = s.inst_id (+) and wc.sid = s.sid (+)
AND wc.sess_serial# = s.serial# (+))
AND (s.final_blocking_instance = bs.inst_id (+) and s.final_blocking_session = bs.sid (+))
AND (bs.inst_id = p.inst_id (+) and bs.paddr = p.addr (+))
AND ( num_waiters > 0 OR ( blocker_osid IS NOT NULL AND in_wait_secs > 10 ) )
ORDER BY chain_id, num_waiters DESC

[Ivan Brezina]

cau you please turn it onto a patch?

PS: I moved the project partially onto Github.

[Gerard H. Pille]

Sorry Ivan, only now I saw your message. But I hate patching on GitHub, let alone patching a "partial" project. What does that mean?