Friday, January 13, 2012

How to identify the sql used by a session in oracle database

select  sql.sql_text
      from   v$session ses, v$sqltext sql
      where sql.address=ses.sql_address
      and     sql.hash_value=ses.sql_hash_value
      and     sid=&session_id
      order   by piece;

2 comments:

  1. I appreciate you sharing this article. Really thank you! Much obliged.
    This is one awesome blog article. Much thanks again.

    sap online training
    software online training
    sap sd online training
    hadoop online training
    sap-crm-online-training

    ReplyDelete
  2. I really enjoy the blog.Much thanks again. Really Great.
    Very informative article post. Really looking forward to read more. Will read on…


    oracle online training
    sap fico online training
    dotnet online training
    qa-qtp-software-testing-training-tutorial

    ReplyDelete