Tuesday, 24 April 2007

Longops

Just how long do I have to wait for my long running SQL to complete?

SELECT *
FROM v$session_longops
WHERE sofar < totalwork;


Shows you what long running operations are in progress.

You can tie this back to your - or another sessions SQL.

No comments: