for dsuva:
from v$sqltext you get the ADDRESS, than join from v$session by SADDR, you can get the username.