I have tried to understand to check current status of long running query by executing below query.


Suppose one of unix shell script is calling t1.sql in it.

when t1.sql is trying to load data from temp table (nearly 100,000 records minimum),

Now this query was going on , unix sun solaris platform, oracle  9.2.0.7i

sql> select * from v$session_longops where time_Remaining >0

sofar,
blocks,
load time
end time
buffered