class busy

 select a.snap_id, destins,srcins,class, crblk+crbusy+crcongst "CRB-Recd", round(crblk/(crblk+crbusy+crcongst) *100,2) "%Immediate", round(crbusy/(crblk+crbusy+crcongst) * 100,2) "%Busy", crntblk+crntbusy+crntcongst "CRNTBlk-Recd", round(crntblk/(crntblk+crntbusy+crntcongst) *100,2) "%Immediate", round(crntbusy/(crntblk+crntbusy+crntcongst) *100,2) "%Busy"
from (
select snap_id, class, destIns, srcIns, crblk - lag ( crblk) over ( partition by class order by class,DestIns,SrcIns,snap_id ) crblk , crbusy - lag ( crbusy) over ( partition by class order by class,DestIns,SrcIns,snap_id ) crbusy , crcongst - lag ( crcongst) over ( partition by class order by class,DestIns,SrcIns,snap_id ) crcongst, crntblk - lag ( crntblk) over ( partition by class order by class,DestIns,SrcIns,snap_id ) crntblk, crntbusy - lag ( crntbusy) over ( partition by class order by class,DestIns,SrcIns,snap_id ) crntbusy, crntcongst - lag ( crntcongst) over ( partition by class order by class,DestIns,SrcIns,snap_id ) crntcongst
from (
select di.snap_id,class, di.instance_number DestIns, instance SrcIns, sum(cr_block) crblk, sum(cr_busy) crbusy, sum(cr_congested) crcongst, sum(CURRENT_BLOCK) crntblk, sum(CURRENT_BUSY) crntbusy, sum(CURRENT_CONGESTED) crntcongst
from DBA_HIST_INST_CACHE_TRANSFER di
where snap_id between 42255 and 42266
--and class='data block'
--and instance_number =1
group by di.snap_id,class, di.instance_number, instance order by class,di.instance_number, instance,snap_id ) ) a
where a.snap_id > 42255 and crblk+crbusy+crcongst >0 and crntblk+crntbusy+crntcongst >0
--order by snap_id, destins,srcins,class, crblk+crbusy+crcongst
order by a.snap_id, destins, crntblk+crntbusy+crntcongst + crblk+crbusy+crcongst desc , class, srcins