select sql_text, module, action from v$sqlarea
cheers John Scoles -- //www.freelists.org/webpage/oracle-l