SELECT * FROM V$SESSION WHERE SCHEMANAME='YOUR_SCHEMA'

DITTO on reply from member abhaysk