DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: find what sql statement is being executed

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    175
    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

  2. #2
    Join Date
    Aug 2000
    Posts
    194
    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

  3. #3
    Join Date
    Sep 2000
    Posts
    41
    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

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