摘自:http://www.itpub.net/220165.html
通过v$session_longops 中SOFAR TOTALWORK 等字段可以获得
This view displays the status of various operations that run for longer than 6 seconds (in absolute time). These operations currently include many backup and recovery functions, statistics gathering, and query execution, and more operations are added for every Oracle release.