long running queries
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: long running queries

  1. #1
    Join Date
    Aug 2000
    Posts
    462
    How can I query the DB to determine what queries are currently executing, particularly for long running queries?

  2. #2
    Join Date
    Feb 2001
    Posts
    389
    v$sqlarea and match it with v$session

  3. #3
    Join Date
    Aug 2000
    Posts
    462
    I apologize, but I have no idea which fields I can use to relate these views . . .

  4. #4
    Join Date
    Feb 2001
    Posts
    389
    v$sqlarea.address
    v$session.sql_Address
    v$sqlarea.hash_value
    v$session.sql_hash_value



  5. #5
    Join Date
    Aug 2000
    Posts
    462
    Thank you very much. I asked this because I recently submitted a query to the server, and it has taken a long time to run. I just wanted to check on it in any way I could to determine if there was something stopping it from completing. Any suggestions?

    I looked in v$sqlarea for fields I thought might be indicative, and here's what I have:

    sorts___executions___parse_calls___disk_reads___buffer_gets___rows_processed___optimizer_mode

    1,1,1,0,0,0,CHOOSE

    Thanks!

  6. #6
    Join Date
    Aug 2000
    Posts
    462
    Well, my query is over, and it appears to have worked just fine. Maybe I'm just too impatient. Thanks anyway.

    gpsingh, thanks for teaching me something!


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