Query to check sessions writing to flashcache on Exadata
select se.sid, sn.name, s.value, se.program from v$sesstat s natural join v$statname sn left join v$session se on (s.sid = se.sid) where sn.name in ('physical write requests optimized', 'cell writes to flash cache', 'cell overwrites in flash cache') and s.value <> 0 order by s.sid,name;