The Weekend DBA
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment