how to know the recent queries fired in oracle from the front end
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Apr 2002
    Posts
    4
    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

  2. #2
    Join Date
    Apr 2002
    Location
    Philippines
    Posts
    77
    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.

  3. #3
    Join Date
    Apr 2002
    Posts
    4
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width