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!