select count(*) from x$kcbwh; select count(*) from x$kcbsw; select count(*) from x$kcbuwhy;
select wh.kcbwhdes des, sw.other_wait, wy.why0, wy.why1, wy.why2, wy.why3, wy.why4 from x$kcbwh wh join x$kcbsw sw on wh.indx = sw.indx join x$kcbuwhy wy on wh.indx = wy.indx order by sw.other_wait desc;