To view the SQL being executed against your Oracle rdbms, the following statement seems to be useful:

select * from v$sqltext where sql_text like '%some value%'