select 
         Y.NAME,src_site,state,count(*)
    from V$SESSIONs      x,
         sys.dpc_bp_raft y
   where sf_get_ep_seqno(x.rowid) = y.raft_id
     and X.SRC_SITe=65535
group by sf_get_ep_seqno(x.rowid),
         Y.NAME,
          src_site,state