Hi lesstjm,

Try to look into this view v$sqlarea.I am sure it will give u ur desire information and pass your userid as parameter with parsing_user_id.

Thanks,

Mayank