Get all long running operations for a session
get
/database/monitoring/sessions/{sid},{serial_number}/long_running_operations
Returns all records from GV$SESSION_LONGOPS for a specific session. A client requires SQL Administrator role to invoke this service.
Request
Path Parameters
-
serial_number(required): number
Session serial number.
-
sid(required): number
Session identifier.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
200 Response
Information on long running operations for the session.
Root Schema : MonitoringSessionsLongRunningOperationItem
Type:
object
This object represents operations for a specific session that run for longer than 6 seconds (in absolute time).
Show Source
-
con_id: integer
The ID of the container to which the data pertains.
-
context: integer
Context.
-
elapsed_seconds: integer
Number of elapsed seconds from the start of the operations.
-
inst_id: integer
Oracle Real Application Clusters instance number for which this data relates to. In a non-RAC database this number will be 1.
-
last_update_time: string
Time when statistics were last updated for the operation.
-
links: array
links
-
message: string
Statistics summary message.
-
opname: string
Brief description of the operation.
-
qcsid: integer
Session identifier of the parallel coordinator.
-
serial#: integer
Serial number of the session processing the long-running operation. If multiple sessions are cooperating in the long-running operation, then SERIAL# corresponds to the main or master session. SERIAL# is used to uniquely identify a session's objects. Guarantees that session-level commands are applied to the correct session objects if the session ends and another session begins with the same session ID.
-
sid: integer
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.
-
sofar: integer
Units of work done so far for the operation specified in the OPNAME column.
-
sql_address: string
Used with sql_hash_value to identify the SQL statement that is currently being executed.
-
sql_exec_id: integer
SQL execution identifier; NULL if SQL_ID is NULL or if the execution of that SQL has not yet started.
-
sql_exec_start: string
Time when the execution of the SQL currently executed by this session started; NULL if SQL_ID is NULL.
-
sql_hash_value: integer
Used with SQL_ADDRESS to identify the SQL statement that is currently being executed.
-
sql_id: string
SQL identifier of the SQL statement that is currently being executed.
-
sql_plan_hash_value: integer
Used with the value of the SQL_ADDRESS column to identify the SQL statement associated with the operation.
-
sql_plan_line_id: integer
SQL plan line ID corresponding to the long operation; NULL if the long operation is not associated with a line of the execution plan.
-
sql_plan_operation: string
Plan operation name; NULL if SQL_PLAN_LINE_ID is NULL.
-
sql_plan_options: string
Plan operation options; NULL if SQL_PLAN_LINE_ID is NULL.
-
start_time: string
Starting time of the operation.
-
target: string
Object on which the operation is carried out.
-
target_desc: string
Description of the target.
-
time_remaining: integer
Estimate (in seconds) of time remaining for the operation to complete.
-
timestamp: string
Timestamp specific to the operation.
-
totalwork: integer
Total units of work for the operation specified in the OPNAME column.
-
units: string
Units of measurement.
-
username: string
User ID of the user performing the operation.