How to know one query is running for how long..?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to know one query is running for how long..?

  1. #1
    Join Date
    Jul 2002
    Posts
    205

    How to know one query is running for how long..?

    How to know one query is running for how long..?

    Any one has any kind of scripts...?

  2. #2
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    V$session_longops & V$transaction
    "What is past is PROLOGUE"

  3. #3
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350

    Works with restrictions...

    restrictions being :

    a) of course, V$SESSION_LONGOPS register ONLY the long operations, if a query is working, but doing a lot of small short ops (nested loops or the like) it will NOT show in V$SESSION_LONGOPS

    b) V$TRANSACTION shows transactions, ie, DMLs, queries doing read only (no FOR UPDATE) will NOT show.

    Regards,

    Chiappa

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