select ge.grantype,ct.component , ge.grannum, ge.grannext,ge.granprev, lpad(' ',level) ||level
from x$ksmge ge, x$kmgsct ct where ge.grantype=ct.grantype
start with granprev=0 connect by ge.grantype=prior ge.grantype and prior grannum= granprev;
This query will give the granules allocation status as well as the allocation link list. If the default buffer cache is too much for the output. Add grantype!=6 to the query.
