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

Thread: SQL QUERIES

  1. #1
    Join Date
    Jan 2001
    Posts
    10

    Angry

    HI..
    JUST A QUERY CAN ANY BODY HELP ME
    I WANT TO SEE THE SQL QUERIES FROM AN APPLICATION
    WHICH ARE EXECUTED IN THE ORACLE DATABSE
    IS THERE ANY WAY TO SEE WHAT ALL QUERIES ARE EXECUTING ON THE DATABASE FROM A PERTICULER APPLICATION FOR A PERTICULER USER
    PLEASE GET BACK
    THANKS AND REGARDS
    BAKSHI


  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you can join v$session and v$sqltext

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Or, you can attach a trace to the session once the application has already started by using dbms_system.set_sql_trace_in_session. See http://otn.oracle.com/docs/products/...4_str.htm#8760 for details...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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