long running queries

[kmesser]

How can I query the DB to determine what queries are currently executing, particularly for long running queries?

[gpsingh]

v$sqlarea and match it with v$session

[kmesser]

I apologize, but I have no idea which fields I can use to relate these views . . .

[gpsingh]

v$sqlarea.address
v$session.sql_Address
v$sqlarea.hash_value
v$session.sql_hash_value

[kmesser]

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!

[kmesser]

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!