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

Thread: performance tuning

  1. #1
    Join Date
    Jun 2003
    Location
    australia
    Posts
    74

    performance tuning

    hi all oracle guru's,
    iam a chicken in this database field and i was wondering if anyone of you could help me. I have a front end application for which i dont have the source code and i want to see how a certain form (the query) is getting executed (the explain plan). can anyone tell me how can i see what tables it is accesing and what indexes are being used?????


    any help would be gr8 full.

    rajorcl

  2. #2
    Join Date
    Apr 2003
    Posts
    353
    use the v$session to find the sid

    use the following query to find the sql query
    the session is running

    select sid, sql_text, piece from v$sqltext t,
    v$session s where s.sql_address = address and
    sql_hash_value = hash_value and sid = &sid;

    use explain plan for optimising.

    Regards
    giri

  3. #3
    Join Date
    Jun 2003
    Location
    australia
    Posts
    74
    thanx heaps mr. giri
    it just worked fine and i'm really impressed by the fast response in this site.
    rajorcl

  4. #4
    Join Date
    Jul 2003
    Posts
    59
    See my response to this thread to see how to capture *all* the SQL that a session is submitting:

    http://www.dbasupport.com/forums/sho...threadid=37833
    Tom Best

  5. #5
    Join Date
    Mar 2003
    Location
    Dallas, TX
    Posts
    12
    I built an integrated set of GUI tools to manage, monitor and tune the Oracle database. One of the many monitoring functions allows you to list all the active sessions, you can then click on any session, to view the SQL statement being executed, and with another click you can analyze that statement. It is particulary usefull when you don’t have the source code. The link is http://www.barsoft.net and it is free.
    Michel Bartov
    http://www.barsoft.net/

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