Performance -> Long Ops

This view is based on v$session_longops and it shows progress of long running operations.

• SID, Serial# - Identifier of the session processing the long-running operation. If multiple sessions are cooperating in the long-running operation, then SID corresponds to the main or master session.
• Start Time - Starting time of the operation
• Finish Time - Estimated finish time
• Last Update - Time when statistics were last updated for the operation
• Operation - Brief description of the operation
• Elapsed - Amount of elapsed time from the start of the operation
• Remaining - Amount of time estimated to the end of the operation
• Progress - SOFAR/TOTALWORK UNITS from v$session_longops.
• Percent - amount of work completed in percents.