-
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|