How to know only the SQLs running in a session
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to know only the SQLs running in a session

  1. #1
    Join Date
    Jul 2002
    Posts
    205

    How to know only the SQLs running in a session

    Hi,

    If I run the trace of session. After I use TKPROF to translate it , it shows me the EXPLAIN plan also. I only need the SQLs run by the seesion, in the sequence it is running. Is there any way..?

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Don't give explain=user/passwd in the tkprof command.

    If you want to know the order of sql statements executed, then the command is:
    $tkprof trace_file output_file

    Tamil

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