Tree output in wait chain sql

[ghost]

Hi Tanel, Would it be possible to have tree-like output in wait chain scripts? below link has an implementation idea -

https://github.com/hyee/dbcli/blob/master/oracle/ora/ash/ashchain.sql

Sample Output: ============== Leaf Pct AAS EXECS AAS IO TOP_CURR_OBJ# WAIT_CHAIN EVENT_CHAIN FULL_EVENT_CHAIN -------- --- ----- ---- --------- --------------- ----------------- ----------------------------------------- --------------------------------------------------------------------------------------- 37.5% 3 1 0 408.00 KB (3) x$kglst#2 adzjh275fvvx4 library cache load lock library cache load lock | 12.50% 1 1 1 320.00 KB (1) 11613 | cvn54b7yz0s8u | db file sequential read library cache load lock > db file sequential read | 12.50% 1 1 1 320.00 KB (1) 11613 | cvn54b7yz0s8u | ON CPU [file# block# blocks] library cache load lock > ON CPU [file# block# blocks] | 12.50% 1 1 1 296.00 KB (1) 11613 | 3ktacv9r56b51 | ON CPU [file# block# blocks] library cache load lock > ON CPU [file# block# blocks] 25.% 2 2 0 1.02 MB (2) 122 0b0wj2ykgnnzg enq: TM - contention enq: TM - contention | 25.00% 2 2 2 108.68 MB (1) 4 | 1b28hzmjun5t0 | db file sequential read enq: TM - contention > db file sequential read 12.5% 1 1 0 0 B (1) 12442 (Mnnn) (Mnnn) library cache pin (Mnnn) library cache pin | 12.50% 1 1 0 8.00 KB (1) 5944 | (CJQn) | (CJQn) rdbms ipc reply (Mnnn) library cache pin > (CJQn) rdbms ipc reply | 12.50% 1 1 1 72.00 KB (1) -1 | (DBRM) | (DBRM) resmgr:internal state change (Mnnn) library cache pin > (CJQn) rdbms ipc reply > (DBRM) resmgr:internal state change 12.5% 1 1 0 96.00 KB (1) data block 32hbap2vtmf53 read by other session [data block] read by other session [data block] | 12.50% 1 1 1 120.00 KB (1) 162 | 32hbap2vtmf53 | db file sequential read read by other session [data block] > db file sequential read 12.5% 1 1 1 944.00 KB (1) -1 92b382ka0qgdt rdbms ipc reply > (Remote) rdbms ipc reply > (Remote)

[tanelpoder]

Would the use case be to just have narrower (but taller) output?

I've been thinking of doing some more work on the wait chains analysis in general and could add this into my todo list.