Hi Mary, 5th May 2001 16:24 hrs chennai

The one thing you can do is linking the particular transaction with the number of blocks used in the RBS.

>SELECT S.USERNAME,T.USED_UBLK,T.START_TIME FROM V$TRANSACTION T,V$SESSION S WHERE T.ADDR=S.TADDR

Cheers

Padmam