How can I query the DB to determine what queries are currently executing, particularly for long running queries?
Printable View
How can I query the DB to determine what queries are currently executing, particularly for long running queries?
v$sqlarea and match it with v$session
I apologize, but I have no idea which fields I can use to relate these views . . .
v$sqlarea.address
v$session.sql_Address
v$sqlarea.hash_value
v$session.sql_hash_value
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!
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!