to isolate errors i want to query v$sqlarea for the query that is fired as soon as an application user takes a particular action.
as v$sqlarea is a view iam unable to use rowid and rownum to get to the last few rows.
iam unable to make out the table from where v$sqlarea derives the sql_text.

how to handle?