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. 04-04-2002, 09:25 AM #1
    HarishAg
    HarishAg is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 04-04-2002, 11:15 PM #2
    skid
    skid is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  3. 04-05-2002, 07:38 AM #3
    HarishAg
    HarishAg is offline Junior Member
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width