Jump to

• Request
• Response

Get all sampled session activity in the database

get

/database/performance/active_sessions_history/

Oracle Diagnostics Pack licence is required for this service. Returns all records from GV$ACTIVE_SESSION_HISTORY. A client requires SQL Administrator role to invoke this service.

Request

Query Parameters

• limit: integer(int32)
  The maximum number of records to return.
• q:
  Filtering is the process of limiting a collection resource by using a per-request dynamic filter definition across multiple page resources, where each page contains a subset of items found in the complete collection. Filtering enables efficient traversal of large collections.

  Examples

  Select an example FilterCriteriaExample OrderByPropertyExample FilterAndOrderExample

There's no request body for this operation.

Back to Top

Response

Supported Media Types

• application/json

200 Response

Description of sampled session activity in the database.

Body ()

Root Schema : PerformanceActionSessionHistories

Type: object

Show Source

• count: integer
  Total number of records in the current response.
• hasMore: boolean
  Indicates if there are more records to be retrieved.
• items: array items
• limit: integer
  The actual page size limit on number of records applied by the server.
• links: array links
• offset: integer
  The actual index from which the item resources are returned.

{
    "type":"object",
    "properties":{
        "items":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/PerformanceActionSessionHistoriesItem"
            }
        },
        "hasMore":{
            "type":"boolean",
            "description":"Indicates if there are more records to be retrieved."
        },
        "limit":{
            "type":"integer",
            "description":"The actual page size limit on number of records applied by the server."
        },
        "offset":{
            "type":"integer",
            "description":"The actual index from which the item resources are returned."
        },
        "count":{
            "type":"integer",
            "description":"Total number of records in the current response."
        },
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/LinkRelation"
            }
        }
    }
}

Nested Schema : items

Type: array

Show Source

• Array of: object PerformanceActionSessionHistoriesItem
  This object represents a sampled session activity in the database from GV$ACTIVE_SESSION_HISTORY. It contains snapshots of active database sessions taken once a second. A database session is considered active if it was on the CPU or was waiting for an event that didn't belong to the Idle wait class. The list of attributes may vary depending on database version.

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/PerformanceActionSessionHistoriesItem"
    }
}

Nested Schema : links

Type: array

Show Source

• Array of: object LinkRelation

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/LinkRelation"
    }
}

Nested Schema : PerformanceActionSessionHistoriesItem

Type: object

This object represents a sampled session activity in the database from GV$ACTIVE_SESSION_HISTORY. It contains snapshots of active database sessions taken once a second. A database session is considered active if it was on the CPU or was waiting for an event that didn't belong to the Idle wait class. The list of attributes may vary depending on database version.

Show Source

• action: string
  Name of the executing module when sampled, as set by the DBMS_APPLICATION_INFO.SET_ACTION procedure.
• blocking_hangchain_info: string
  Indicates whether the information about BLOCKING_SESSION comes from the hang chain (Y) or not (N).
• blocking_inst_id: integer
  Instance number of the blocker shown in BLOCKING_SESSION.
• blocking_session: integer
  Session identifier of the blocking session. Populated only if the blocker is on the same instance and the session was waiting for enqueues or a 'buffer busy' wait.
• blocking_session_serial#: integer
  Serial number of the blocking session.
• blocking_session_status: string
  Status of the blocking session.
• capture_overhead: string
  Indicates whether the session is executing capture code (Y) or not (N).
• client_id: string
  Client identifier of the session.
• con_id: integer
  The ID of the container to which the data pertains.
• consumer_group_id: integer
  Consumer group ID.
• current_block#: integer
  ID of the block that the session is referencing. This information is only available if the session was waiting for cluster, concurrency, and user I/O wait events.
• current_file#: integer
  File number of the file containing the block that the session is referencing. This information is only available if the session was waiting for cluster, concurrency, and user I/O wait events.
• current_obj#: integer
  Object ID of the object that the session is referencing. This information is only available if the session was waiting for application, cluster, concurrency, and user I/O wait events.
• current_row#: integer
  Row identifier that the session is referencing. This information is only available if the session was waiting for cluster, concurrency, and user I/O wait events.
• dbop_exec_id: integer
  Database operation execution identifier for the current execution. If the type is SQL, the DBOP_EXEC_ID will be NULL.
• dbop_name: string
  Database operation name. If the type is SQL, the DBOP_NAME will be NULL.
• dbreplay_call_counter: integer
  If the session is being captured or replayed, then DBREPLAY_CALL_COUNTER is the call counter of the user call that is being captured or replayed; otherwise it is NULL.
• dbreplay_file_id: integer
  If the session is being captured or replayed, then DBREPLAY_FILE_ID is the file ID for the workload capture or workload replay; otherwise it is NULL.
• delta_interconnect_io_bytes: integer
  Number of I/O bytes sent over the I/O interconnect over the last DELTA_TIME microseconds.
• delta_read_io_bytes: integer
  Number of I/O bytes read by this session over the last DELTA_TIME microseconds.
• delta_read_io_requests: integer
  Number of read I/O requests made by this session over the last DELTA_TIME microseconds.
• delta_read_mem_bytes: integer
  Number of read bytes through the buffer cache.
• delta_time: integer
  Time interval (in microseconds) since the last time this session was sampled or created, over which the next five statistics are accumulated.
• delta_write_io_bytes: integer
  Number of I/O bytes written by this session over the last DELTA_TIME microseconds.
• delta_write_io_requests: integer
  Number of write I/O requests made by this session over the last DELTA_TIME microseconds.
• ecid: string
  Execution context identifier (sent by Application Server).
• event: string
  If SESSION_STATE = WAITING, then the event for which the session was waiting for at the time of sampling. If SESSION_STATE = ON CPU, then this column is NULL.
• event#: integer
  Number of the resource or event for which the session is waiting or for which the session last waited. Interpretation is similar to that of the EVENT column.
• event_id: integer
  Identifier of the resource or event for which the session is waiting or for which the session last waited. Interpretation is similar to that of the EVENT column.
• force_matching_signature: integer
  Signature used when the CURSOR_SHARING parameter is set to FORCE.
• in_bind: string
  Indicates whether the session was doing bind operations at the time of sampling (Y) or not (N).
• in_connection_mgmt: string
  Indicates whether the session was doing connection management at the time of sampling (Y) or not (N).
• in_cursor_close: string
  Indicates whether the session was closing a cursor at the time of sampling (Y) or not (N).
• in_hard_parse: string
  Indicates whether the session was hard parsing at the time of sampling (Y) or not (N).
• in_inmemory_populate: string
  Indicates whether the session was populating the IM column store at the time of sampling (Y) or not (N).
• in_inmemory_prepopulate: string
  Indicates whether the session was prepopulating the IM column store at the time of sampling (Y) or not (N).
• in_inmemory_query: string
  Indicates whether the session was querying the In-Memory Column Store (IM column store) at the time of sampling (Y) or not (N).
• in_inmemory_repopulate: string
  Indicates whether the session was repopulating the IM column store at the time of sampling (Y) or not (N).
• in_inmemory_trepopulate: string
  Indicates whether the session was trickle repopulating the IM column store at the time of sampling (Y) or not (N).
• in_java_execution: string
  Indicates whether the session was executing Java at the time of sampling (Y) or not (N).
• in_parse: string
  Indicates whether the session was parsing at the time of sampling (Y) or not (N).
• in_plsql_compilation: string
  Indicates whether the session was compiling PL/SQL at the time of sampling (Y) or not (N).
• in_plsql_execution: string
  Indicates whether the session was executing PL/SQL at the time of sampling (Y) or not (N).
• in_plsql_rpc: string
  Indicates whether the session was executing inbound PL/SQL RPC calls at the time of sampling (Y) or not (N).
• in_sequence_load: string
  Indicates whether the session is loading in sequence (in sequence load code) (Y) or not (N).
• in_sql_execution: string
  Indicates whether the session was executing SQL statements at the time of sampling (Y) or not (N).
• in_tablespace_encryption: string
  Indicates whether encryption or decryption of a tablespace occurred at the time of sampling (Y) or not (N).
• inst_id: integer
  Instance number from which the associated GV$ACTIVE_SESSION_HISTORY view information was obtained.
• is_awr_sample: string
  Indicates whether this sample has been flushed or will be flushed to the Automatic Workload Repository (DBA_HIST_ACTIVE_SESS_HISTORY) (Y) or not (N).
• is_captured: string
  Indicates whether the session is being captured (Y) or not (N).
• is_replay_sync_token_holder: string
  Indicates whether the session is holding a synchronization token (Y) or not (N) during workload replay.
• is_replayed: string
  Indicates whether the session is being replayed (Y) or not (N).
• is_sqlid_current: string
  Indicates whether the SQL identifier in the SQL_ID column is being executed (Y) or not (N).
• links: array links
• machine: string
  Client's operating system machine name.
• module: string
  Name of the executing module when sampled, as set by the DBMS_APPLICATION_INFO.SET_MODULE procedure.
• p1: integer
  First wait event parameter (in decimal).
• p1text: string
  Description of the first wait event parameter.
• p2: integer
  Second wait event parameter (in decimal).
• p2text: string
  Description of the second wait event parameter.
• p3: integer
  Third wait event parameter (in decimal).
• p3text: string
  Description of the third wait event parameter.
• pga_allocated: integer
  Amount of PGA memory (in bytes) consumed by this session at the time this sample was taken.
• plsql_entry_object_id: integer
  Object ID of the top-most PL/SQL subprogram on the stack; NULL if there is no PL/SQL subprogram on the stack. Maps to DBA_OBJECTS.OBJECT_ID.
• plsql_entry_subprogram_id: integer
  Subprogram ID of the top-most PL/SQL subprogram on the stack. Maps to DBA_OBJECTS.DATA_OBJECT_ID.
• plsql_object_id: integer
  Object ID of the currently executing PL/SQL subprogram.
• plsql_subprogram_id: integer
  Subprogram ID of the currently executing PL/SQL object.
• port: integer
  Client port number.
• program: string
  Name of the operating system program.
• qc_instance_id: integer
  Query coordinator instance ID. This information is only available if the sampled session is a parallel query slave. For all other sessions, the value is 0.
• qc_session_id: integer
  Query coordinator session ID. This information is only available if the sampled session is a parallel query slave. For all other sessions, the value is 0.
• qc_session_serial#: integer
  Query coordinator session serial number. This information is only available if the sampled session is a parallel query slave. For all other sessions, the value is 0.
• remote_instance#: integer
  Remote instance identifier that will serve the block that this session is waiting for. This information is only available if the session was waiting for cluster events.
• replay_overhead: string
  Indicates whether the session is executing replay code (Y) or not (N).
• sample_id: integer
  ID of the sample.
• sample_time: string
  Time at which the sample was taken.
• seq#: integer
  Sequence number that uniquely identifies the wait (incremented for each wait).
• service_hash: integer
  Hash that identifies the Service.
• session_id: integer
  Session identifier; maps to GV$SESSION.SID.
• session_serial#: integer
  Session serial number (used to uniquely identify a session's objects); maps to GV$SESSION.SERIAL#.
• session_state: string
  Session state.
• session_type: string
  Session type.
• sql_adaptive_plan_resolved: integer
  Indicates whether the SQL plan of the sampled database session is a resolved adaptive plan or not.
• sql_child_number: integer
  Child number of the SQL statement that the session was executing at the time of sampling.
• sql_exec_id: integer
  SQL execution identifier.
• sql_exec_start: string
  Time when the execution of the SQL started.
• sql_full_plan_hash_value: integer
  Numerical representation of the complete SQL plan for the cursor being executed by this session.
• sql_id: string
  SQL identifier of the SQL statement that the session was executing at the time of sampling.
• sql_opcode: integer
  Indicates what phase of operation the SQL statement was in.
• sql_opname: string
  SQL command name.
• sql_plan_hash_value: integer
  Numeric representation of the SQL plan for the cursor. This information might not be available for all session samples.
• sql_plan_line_id: integer
  SQL plan line ID.
• sql_plan_operation: string
  Plan operation name.
• sql_plan_options: string
  Plan operation options.
• temp_space_allocated: integer
  Amount of TEMP memory (in bytes) consumed by this session at the time this sample was taken.
• time_model: integer
  Time model information.
• time_waited: integer
  If SESSION_STATE = WAITING, then the time that the session actually spent waiting for that event (in microseconds). This column is set for waits that were in progress at the time the sample was taken. If a wait event lasted for more than a second and was caught waiting in more than one session sample row, then the actual time spent waiting for that wait event will be populated in the last of those session sample rows. At any given time, this information will not be available for the latest session sample.
• tm_delta_cpu_time: integer
  Amount of time this session spent on CPU over the last TM_DELTA_TIME microseconds.
• tm_delta_db_time: integer
  Amount of time spent by this session in database calls over the last TM_DELTA_TIME microseconds.
• tm_delta_time: integer
  Time interval (in microseconds) over which TM_DELTA_CPU_TIME and TM_DELTA_DB_TIME are accumulated.
• top_level_call#: integer
  Oracle top level call number.
• top_level_call_name: string
  Oracle top level call name.
• top_level_sql_id: string
  SQL identifier of the top level SQL statement.
• top_level_sql_opcode: integer
  Indicates what phase of operation the top level SQL statement was in.
• user_id: integer
  Oracle user identifier; maps to GV$SESSION.USER#.
• wait_class: string
  Wait class name of the event for which the session was waiting at the time of sampling.
• wait_class_id: integer
  Wait class identifier of the event for which the session was waiting at the time of sampling.
• wait_time: integer
  Total wait time for the event for which the session last waited if the session was on the CPU when sampled; 0 if the session was waiting at the time of sampling.
• xid: string
  Transaction ID that the session was working on at the time of sampling.

{
    "type":"object",
    "description":"This object represents a sampled session activity in the database from GV$ACTIVE_SESSION_HISTORY. It contains snapshots of active database sessions taken once a second. A database session is considered active if it was on the CPU or was waiting for an event that didn't belong to the Idle wait class. The list of attributes may vary depending on database version.",
    "properties":{
        "inst_id":{
            "type":"integer",
            "description":"Instance number from which the associated GV$ACTIVE_SESSION_HISTORY view information was obtained."
        },
        "sample_id":{
            "type":"integer",
            "description":"ID of the sample."
        },
        "sample_time":{
            "type":"string",
            "description":"Time at which the sample was taken."
        },
        "is_awr_sample":{
            "type":"string",
            "description":"Indicates whether this sample has been flushed or will be flushed to the Automatic Workload Repository (DBA_HIST_ACTIVE_SESS_HISTORY) (Y) or not (N)."
        },
        "session_id":{
            "type":"integer",
            "description":"Session identifier; maps to GV$SESSION.SID."
        },
        "session_serial#":{
            "type":"integer",
            "description":"Session serial number (used to uniquely identify a session's objects); maps to GV$SESSION.SERIAL#."
        },
        "session_type":{
            "type":"string",
            "description":"Session type."
        },
        "user_id":{
            "type":"integer",
            "description":"Oracle user identifier; maps to GV$SESSION.USER#."
        },
        "sql_id":{
            "type":"string",
            "description":"SQL identifier of the SQL statement that the session was executing at the time of sampling."
        },
        "is_sqlid_current":{
            "type":"string",
            "description":"Indicates whether the SQL identifier in the SQL_ID column is being executed (Y) or not (N)."
        },
        "sql_child_number":{
            "type":"integer",
            "description":"Child number of the SQL statement that the session was executing at the time of sampling."
        },
        "sql_opcode":{
            "type":"integer",
            "description":"Indicates what phase of operation the SQL statement was in."
        },
        "force_matching_signature":{
            "type":"integer",
            "description":"Signature used when the CURSOR_SHARING parameter is set to FORCE."
        },
        "top_level_sql_id":{
            "type":"string",
            "description":"SQL identifier of the top level SQL statement."
        },
        "top_level_sql_opcode":{
            "type":"integer",
            "description":"Indicates what phase of operation the top level SQL statement was in."
        },
        "sql_opname":{
            "type":"string",
            "description":"SQL command name."
        },
        "sql_adaptive_plan_resolved":{
            "type":"integer",
            "description":"Indicates whether the SQL plan of the sampled database session is a resolved adaptive plan or not."
        },
        "sql_full_plan_hash_value":{
            "type":"integer",
            "description":"Numerical representation of the complete SQL plan for the cursor being executed by this session."
        },
        "sql_plan_hash_value":{
            "type":"integer",
            "description":"Numeric representation of the SQL plan for the cursor. This information might not be available for all session samples."
        },
        "sql_plan_line_id":{
            "type":"integer",
            "description":"SQL plan line ID."
        },
        "sql_plan_operation":{
            "type":"string",
            "description":"Plan operation name."
        },
        "sql_plan_options":{
            "type":"string",
            "description":"Plan operation options."
        },
        "sql_exec_id":{
            "type":"integer",
            "description":"SQL execution identifier."
        },
        "sql_exec_start":{
            "type":"string",
            "description":"Time when the execution of the SQL started."
        },
        "plsql_entry_object_id":{
            "type":"integer",
            "description":"Object ID of the top-most PL/SQL subprogram on the stack; NULL if there is no PL/SQL subprogram on the stack. Maps to DBA_OBJECTS.OBJECT_ID."
        },
        "plsql_entry_subprogram_id":{
            "type":"integer",
            "description":"Subprogram ID of the top-most PL/SQL subprogram on the stack. Maps to DBA_OBJECTS.DATA_OBJECT_ID."
        },
        "plsql_object_id":{
            "type":"integer",
            "description":"Object ID of the currently executing PL/SQL subprogram."
        },
        "plsql_subprogram_id":{
            "type":"integer",
            "description":"Subprogram ID of the currently executing PL/SQL object."
        },
        "qc_instance_id":{
            "type":"integer",
            "description":"Query coordinator instance ID. This information is only available if the sampled session is a parallel query slave. For all other sessions, the value is 0."
        },
        "qc_session_id":{
            "type":"integer",
            "description":"Query coordinator session ID. This information is only available if the sampled session is a parallel query slave. For all other sessions, the value is 0."
        },
        "qc_session_serial#":{
            "type":"integer",
            "description":"Query coordinator session serial number. This information is only available if the sampled session is a parallel query slave. For all other sessions, the value is 0."
        },
        "event":{
            "type":"string",
            "description":"If SESSION_STATE = WAITING, then the event for which the session was waiting for at the time of sampling. If SESSION_STATE = ON CPU, then this column is NULL."
        },
        "event_id":{
            "type":"integer",
            "description":"Identifier of the resource or event for which the session is waiting or for which the session last waited. Interpretation is similar to that of the EVENT column."
        },
        "event#":{
            "type":"integer",
            "description":"Number of the resource or event for which the session is waiting or for which the session last waited. Interpretation is similar to that of the EVENT column."
        },
        "seq#":{
            "type":"integer",
            "description":"Sequence number that uniquely identifies the wait (incremented for each wait)."
        },
        "p1text":{
            "type":"string",
            "description":"Description of the first wait event parameter."
        },
        "p1":{
            "type":"integer",
            "description":"First wait event parameter (in decimal)."
        },
        "p2text":{
            "type":"string",
            "description":"Description of the second wait event parameter."
        },
        "p2":{
            "type":"integer",
            "description":"Second wait event parameter (in decimal)."
        },
        "p3text":{
            "type":"string",
            "description":"Description of the third wait event parameter."
        },
        "p3":{
            "type":"integer",
            "description":"Third wait event parameter (in decimal)."
        },
        "wait_class":{
            "type":"string",
            "description":"Wait class name of the event for which the session was waiting at the time of sampling."
        },
        "wait_class_id":{
            "type":"integer",
            "description":"Wait class identifier of the event for which the session was waiting at the time of sampling."
        },
        "wait_time":{
            "type":"integer",
            "description":"Total wait time for the event for which the session last waited if the session was on the CPU when sampled; 0 if the session was waiting at the time of sampling."
        },
        "session_state":{
            "type":"string",
            "description":"Session state."
        },
        "time_waited":{
            "type":"integer",
            "description":"If SESSION_STATE = WAITING, then the time that the session actually spent waiting for that event (in microseconds). This column is set for waits that were in progress at the time the sample was taken. If a wait event lasted for more than a second and was caught waiting in more than one session sample row, then the actual time spent waiting for that wait event will be populated in the last of those session sample rows. At any given time, this information will not be available for the latest session sample."
        },
        "blocking_session_status":{
            "type":"string",
            "description":"Status of the blocking session."
        },
        "blocking_session":{
            "type":"integer",
            "description":"Session identifier of the blocking session. Populated only if the blocker is on the same instance and the session was waiting for enqueues or a 'buffer busy' wait."
        },
        "blocking_session_serial#":{
            "type":"integer",
            "description":"Serial number of the blocking session."
        },
        "blocking_inst_id":{
            "type":"integer",
            "description":"Instance number of the blocker shown in BLOCKING_SESSION."
        },
        "blocking_hangchain_info":{
            "type":"string",
            "description":"Indicates whether the information about BLOCKING_SESSION comes from the hang chain (Y) or not (N)."
        },
        "current_obj#":{
            "type":"integer",
            "description":"Object ID of the object that the session is referencing. This information is only available if the session was waiting for application, cluster, concurrency, and user I/O wait events."
        },
        "current_file#":{
            "type":"integer",
            "description":"File number of the file containing the block that the session is referencing. This information is only available if the session was waiting for cluster, concurrency, and user I/O wait events."
        },
        "current_block#":{
            "type":"integer",
            "description":"ID of the block that the session is referencing. This information is only available if the session was waiting for cluster, concurrency, and user I/O wait events."
        },
        "current_row#":{
            "type":"integer",
            "description":"Row identifier that the session is referencing. This information is only available if the session was waiting for cluster, concurrency, and user I/O wait events."
        },
        "top_level_call#":{
            "type":"integer",
            "description":"Oracle top level call number."
        },
        "top_level_call_name":{
            "type":"string",
            "description":"Oracle top level call name."
        },
        "consumer_group_id":{
            "type":"integer",
            "description":"Consumer group ID."
        },
        "xid":{
            "type":"string",
            "description":"Transaction ID that the session was working on at the time of sampling."
        },
        "remote_instance#":{
            "type":"integer",
            "description":"Remote instance identifier that will serve the block that this session is waiting for. This information is only available if the session was waiting for cluster events."
        },
        "time_model":{
            "type":"integer",
            "description":"Time model information."
        },
        "in_connection_mgmt":{
            "type":"string",
            "description":"Indicates whether the session was doing connection management at the time of sampling (Y) or not (N)."
        },
        "in_parse":{
            "type":"string",
            "description":"Indicates whether the session was parsing at the time of sampling (Y) or not (N)."
        },
        "in_hard_parse":{
            "type":"string",
            "description":"Indicates whether the session was hard parsing at the time of sampling (Y) or not (N)."
        },
        "in_sql_execution":{
            "type":"string",
            "description":"Indicates whether the session was executing SQL statements at the time of sampling (Y) or not (N)."
        },
        "in_plsql_execution":{
            "type":"string",
            "description":"Indicates whether the session was executing PL/SQL at the time of sampling (Y) or not (N)."
        },
        "in_plsql_rpc":{
            "type":"string",
            "description":"Indicates whether the session was executing inbound PL/SQL RPC calls at the time of sampling (Y) or not (N)."
        },
        "in_plsql_compilation":{
            "type":"string",
            "description":"Indicates whether the session was compiling PL/SQL at the time of sampling (Y) or not (N)."
        },
        "in_java_execution":{
            "type":"string",
            "description":"Indicates whether the session was executing Java at the time of sampling (Y) or not (N)."
        },
        "in_bind":{
            "type":"string",
            "description":"Indicates whether the session was doing bind operations at the time of sampling (Y) or not (N)."
        },
        "in_cursor_close":{
            "type":"string",
            "description":"Indicates whether the session was closing a cursor at the time of sampling (Y) or not (N)."
        },
        "in_sequence_load":{
            "type":"string",
            "description":"Indicates whether the session is loading in sequence (in sequence load code) (Y) or not (N)."
        },
        "in_inmemory_query":{
            "type":"string",
            "description":"Indicates whether the session was querying the In-Memory Column Store (IM column store) at the time of sampling (Y) or not (N)."
        },
        "in_inmemory_populate":{
            "type":"string",
            "description":"Indicates whether the session was populating the IM column store at the time of sampling (Y) or not (N)."
        },
        "in_inmemory_prepopulate":{
            "type":"string",
            "description":"Indicates whether the session was prepopulating the IM column store at the time of sampling (Y) or not (N)."
        },
        "in_inmemory_repopulate":{
            "type":"string",
            "description":"Indicates whether the session was repopulating the IM column store at the time of sampling (Y) or not (N)."
        },
        "in_inmemory_trepopulate":{
            "type":"string",
            "description":"Indicates whether the session was trickle repopulating the IM column store at the time of sampling (Y) or not (N)."
        },
        "in_tablespace_encryption":{
            "type":"string",
            "description":"Indicates whether encryption or decryption of a tablespace occurred at the time of sampling (Y) or not (N)."
        },
        "capture_overhead":{
            "type":"string",
            "description":"Indicates whether the session is executing capture code (Y) or not (N)."
        },
        "replay_overhead":{
            "type":"string",
            "description":"Indicates whether the session is executing replay code (Y) or not (N)."
        },
        "is_captured":{
            "type":"string",
            "description":"Indicates whether the session is being captured (Y) or not (N)."
        },
        "is_replayed":{
            "type":"string",
            "description":"Indicates whether the session is being replayed (Y) or not (N)."
        },
        "is_replay_sync_token_holder":{
            "type":"string",
            "description":"Indicates whether the session is holding a synchronization token (Y) or not (N) during workload replay."
        },
        "service_hash":{
            "type":"integer",
            "description":"Hash that identifies the Service."
        },
        "program":{
            "type":"string",
            "description":"Name of the operating system program."
        },
        "module":{
            "type":"string",
            "description":"Name of the executing module when sampled, as set by the DBMS_APPLICATION_INFO.SET_MODULE procedure."
        },
        "action":{
            "type":"string",
            "description":"Name of the executing module when sampled, as set by the DBMS_APPLICATION_INFO.SET_ACTION procedure."
        },
        "client_id":{
            "type":"string",
            "description":"Client identifier of the session."
        },
        "machine":{
            "type":"string",
            "description":"Client's operating system machine name."
        },
        "port":{
            "type":"integer",
            "description":"Client port number."
        },
        "ecid":{
            "type":"string",
            "description":"Execution context identifier (sent by Application Server)."
        },
        "dbreplay_file_id":{
            "type":"integer",
            "description":"If the session is being captured or replayed, then DBREPLAY_FILE_ID is the file ID for the workload capture or workload replay; otherwise it is NULL."
        },
        "dbreplay_call_counter":{
            "type":"integer",
            "description":"If the session is being captured or replayed, then DBREPLAY_CALL_COUNTER is the call counter of the user call that is being captured or replayed; otherwise it is NULL."
        },
        "tm_delta_time":{
            "type":"integer",
            "description":"Time interval (in microseconds) over which TM_DELTA_CPU_TIME and TM_DELTA_DB_TIME are accumulated."
        },
        "tm_delta_cpu_time":{
            "type":"integer",
            "description":"Amount of time this session spent on CPU over the last TM_DELTA_TIME microseconds."
        },
        "tm_delta_db_time":{
            "type":"integer",
            "description":"Amount of time spent by this session in database calls over the last TM_DELTA_TIME microseconds."
        },
        "delta_time":{
            "type":"integer",
            "description":"Time interval (in microseconds) since the last time this session was sampled or created, over which the next five statistics are accumulated."
        },
        "delta_read_io_requests":{
            "type":"integer",
            "description":"Number of read I/O requests made by this session over the last DELTA_TIME microseconds."
        },
        "delta_write_io_requests":{
            "type":"integer",
            "description":"Number of write I/O requests made by this session over the last DELTA_TIME microseconds."
        },
        "delta_read_io_bytes":{
            "type":"integer",
            "description":"Number of I/O bytes read by this session over the last DELTA_TIME microseconds."
        },
        "delta_write_io_bytes":{
            "type":"integer",
            "description":"Number of I/O bytes written by this session over the last DELTA_TIME microseconds."
        },
        "delta_interconnect_io_bytes":{
            "type":"integer",
            "description":"Number of I/O bytes sent over the I/O interconnect over the last DELTA_TIME microseconds."
        },
        "delta_read_mem_bytes":{
            "type":"integer",
            "description":"Number of read bytes through the buffer cache."
        },
        "pga_allocated":{
            "type":"integer",
            "description":"Amount of PGA memory (in bytes) consumed by this session at the time this sample was taken."
        },
        "temp_space_allocated":{
            "type":"integer",
            "description":"Amount of TEMP memory (in bytes) consumed by this session at the time this sample was taken."
        },
        "con_id":{
            "type":"integer",
            "description":"The ID of the container to which the data pertains."
        },
        "dbop_name":{
            "type":"string",
            "description":"Database operation name. If the type is SQL, the DBOP_NAME will be NULL."
        },
        "dbop_exec_id":{
            "type":"integer",
            "description":"Database operation execution identifier for the current execution. If the type is SQL, the DBOP_EXEC_ID will be NULL."
        },
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/LinkRelation"
            }
        }
    }
}

Nested Schema : links

Type: array

Show Source

• Array of: object LinkRelation

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/LinkRelation"
    }
}

Nested Schema : LinkRelation

Type: object

Show Source

• href(required): string
• rel(required): string

{
    "type":"object",
    "properties":{
        "rel":{
            "type":"string"
        },
        "href":{
            "type":"string"
        }
    },
    "required":[
        "rel",
        "href"
    ]
}

Back to Top