how to know the recent queries fired in oracle from the front end

[HarishAg]

Hi All,

I have oracle as a database for my application. But I don't know the table structure, it's very complex. So from the front End, when I am creating any new item, or update any existing item, I want to know, what tables are being updated or in which table the record is getting inserting.

Cheers

Harish

[skid]

In a running form you can try to press F5 (if not disabled) but this shows only the block name. Get help from your DBA, they can run a script to show the SQL statements that are currently running.

[HarishAg]

Can anybody throw more light on the above query. I don't have a dba over here and my friend end is in JAVA. so i don't think pressing F5 will work

cheers

harish