Way to find out In which phase exactly the Query is running on database??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Way to find out In which phase exactly the Query is running on database??

  1. #1
    Join Date
    Apr 2008
    Posts
    26

    Thumbs up Way to find out In which phase exactly the Query is running on database??

    Dear all

    I wanted to Know Is there any way to find out,In which phase the current/perticular query (Running on Oracle database ) is in???

    Whether parsing,execution,fetching,what is going on??

    Among which phase the current Query is In??


    If anybody have any idea OR is there any view from which we can find out please let me know

    I'l be realy gratfull to you all
    Thanks in advace

    Rahul

  2. #2
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    You can find the PID and then use truss to see what it's doing in O/S level. BTW truss works on sun solaris.
    http://www.perf-engg.com
    A performance engineering forum

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    Quote Originally Posted by malay_biswal
    You can find the PID and then use truss to see what it's doing in O/S level. BTW truss works on sun solaris.
    and hw is that going to tell you whether it is parsing a query or not (it wont)

    the answer is you cant really

    parsing is only a miniscule time anyway so you will either be executing or fetching

  4. #4
    Join Date
    Dec 2001
    Posts
    320
    The question is why are you interested in this information?
    Anyone can hold the helm when the sea is calm.

  5. #5
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    that's correct, parsing info you will not find from truss.
    http://www.perf-engg.com
    A performance engineering forum

  6. #6
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    BTW i guess you are interested in how long all these steps took for a particular query. Is not it?
    If so, trace that session and do a tkprof that will tell you.
    http://www.perf-engg.com
    A performance engineering forum

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