Is there a way to find out the Long running queries.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Is there a way to find out the Long running queries.

  1. #1
    Join Date
    May 2001
    Location
    Dallas, US
    Posts
    78

    Lightbulb Is there a way to find out the Long running queries.

    Hi Gurus,
    Is there a way we can find out the Long running queries in the begining, while you start executing the queries.
    Here is my concern, i need to set some kind of thresh hold values (may be in the combination of COST, Consistent gets, and Physical reads..etc ) for longer running queries..
    For example, if the current running query statistics values exceeds the thersh hold values, than the user in front wants to have alert about that query will take long time finish the process like that..

    Can i any one helpme out on this.

    Thanks.
    Regards,
    RP Kumar
    RP Kumar
    You Can Win, if u believe Yourself

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    One way...
    Query from v$session_longops view and report to user.

    Do you collect "system statistics" ?

    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