find what sql statement is being executed

[kburrows]

Hi Everyone,

I need to find out what sql statement is being executed. I seem to remember there was a dict_tble or a view, but I can't remember which ones. We are running a reporting tool and when you enter criteria it creates the sql statement for you, but you can't see it. I need to know what it has created.

Thanks
Kathy

[gsprince]

You can get this information from v$sqlarea (sql_text). You may want to join the sql_address of v$session with address of v$sqlarea.

The other table you may use, instead of v$sqlarea is v$sqltext_with_newlines

[aghosh]

Originally posted by gsprince
You can get this information from v$sqlarea (sql_text). You may want to join the sql_address of v$session with address of v$sqlarea.

The other table you may use, instead of v$sqlarea is v$sqltext_with_newlines

Thanks a lot Prince