asked on

Oracle Forms 6.0 - How to see sql statements that Oracle sends on behalf of user

Hi Experts,
How can I see the sql statement that Oracle forms automatically sends when the user is entering data. Is there any trigger or a built-in I can use?
If I can see those sql statements, it will help me find a problem where I believe Oracle is sending a malformed sql statement to the database.

ASKER CERTIFIED SOLUTION

JJSmith

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

hardikbeit

U can also trace the queries by

select s.username,l.sql_text
from dba_users s, v$sql l
where s.user_id = l.parsing_user_id

this will give user name/sql query.. U can also add some more filters like owner/time..

Jay P

ASKER

I tried both of the sql but I get so many rows returned. Could I possibly limit the output to last few rows?

Also do you know if there is any way to see the outgoing sql from the Form before it goes to the server? Thanks

JJSmith

To reduce the number of rows simply add more 'filter' conditions: like a guess at the code:-

AND UPPER(SQL_TEXT) LIKE '%FROM TABX%'

To monitor outgoing statements from your form to server is starting to get a bit 'networky' - please browse:

http://www.slac.stanford.edu/xorg/nmtf/nmtf-tools.html

you might find information on monitoring your forms client connection.

Cheers
JJ

hardikbeit

Hi,
One more tool available like 'SQL Monitor' which gives SQL running by Form 6. I used this tool so many times and it is powerful tool to find out background queries which run through Oracle Forms.

JJSmith

You can try SQL Monitor for free:

http://www.toadsoft.com/downld.html

Cheers
JJ