Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Long running select statement and v$session_longops

user13080027Aug 24 2011 — edited Aug 24 2011
Oracle Version: 10.2.0.4

I've a long running sql query that takes the estimated 6 minutes to complete and return the result.
While it's running I'd like to observe it into the view v$session_longops.

I altered the session that runs the query with 
  ALTER SESSION SET timed_statistics=TRUE;
The tables it queries have gathered statistics on them.

However I don't see any rows in the view v$session_longops for the respective SID and serial#. Why is that? What am I missing?

Thank you!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2011
Added on Aug 24 2011
9 comments
445 views