4.296 DBA_HIST_ACTIVE_SESS_HISTORY
DBA_HIST_ACTIVE_SESS_HISTORY
displays the history of the contents of the in-memory active session history of recent system activity.
DBA_HIST_ACTIVE_SESS_HISTORY
contains snapshots of V$ACTIVE_SESSION_HISTORY
. See "V$ACTIVE_SESSION_HISTORY" for further interpretation details for many of these columns (except SNAP_ID
, DBID
, and INSTANCE_NUMBER
).
Note:
If you want to perform a join with the snapshots view, use the DBA_HIST_ASH_SNAPSHOT
view instead of the DBA_HIST_SNAPSHOT
view.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
ID of the sample |
|
|
|
Time of the sample |
|
|
|
|
|
|
|
Time in microseconds since the last active session history sample |
|
|
|
Session identifier |
|
|
|
Session serial number (used to uniquely identify a session's objects) |
|
|
|
Session type:
|
|
|
|
Reserved for future use |
|
|
|
Oracle user identifier |
|
|
|
SQL identifier of the SQL statement that is currently being executed |
|
|
|
Indicates whether the SQL identifier in the |
|
|
|
Child number of the SQL statement that is currently being executed |
|
|
|
Indicates what phase of operation the SQL statement is in |
|
|
|
SQL command name |
|
|
|
Signature used when the |
|
|
|
SQL identifier of the top level SQL statement |
|
|
|
Indicates what phase of operation the top level SQL statement was in |
|
|
|
Numerical representation of the SQL plan for the cursor |
|
|
|
Numerical representation of the complete SQL plan for the cursor being executed by this session |
|
|
|
Indicates whether the SQL plan of the sampled database session is a resolved adaptive plan or not |
|
|
|
SQL plan line ID |
|
|
|
Plan operation name |
|
|
|
Plan operation options |
|
|
|
SQL execution identifier |
|
|
|
Time when the execution of the SQL started |
|
|
|
Object ID of the top-most PL/SQL subprogram on the stack (or NULL if there is no PL/SQL subprogram on the stack) |
|
|
|
Subprogram ID of the top-most PL/SQL subprogram on the stack (or NULL if there is no PL/SQL subprogram on the stack) |
|
|
|
Object ID of the currently executing PL/SQL subprogram (or NULL if executing SQL) |
|
|
|
Subprogram ID of the currently executing PL/SQL object (or NULL if executing SQL) |
|
|
|
Query coordinator instance ID |
|
|
|
Query coordinator session ID |
|
|
|
Query coordinator session serial number |
|
|
|
Reserved for internal use |
|
|
|
If If |
|
|
|
Identifier of the resource or event for which the session is waiting or for which the session last waited |
|
|
|
Sequence number that uniquely identifies the wait (incremented for each wait) |
|
|
|
Text of first additional parameter |
|
|
|
First additional parameter |
|
|
|
Text of second additional parameter |
|
|
|
Second additional parameter |
|
|
|
Text of third additional parameter |
|
|
|
Third additional parameter |
|
|
|
Wait class name of the event for which the session was waiting at the time of sampling. Interpretation is similar to that of the |
|
|
|
Wait class identifier of the event for which the session was waiting at the time of sampling. Interpretation is similar to that of the |
|
|
|
Total wait time (in microseconds) for the event for which the session last waited ( |
|
|
|
Session state:
|
|
|
|
Time that the current session actually spent waiting for the event (in microseconds). This column is set for waits that were in progress at the time the sample was taken. |
|
|
|
Status of the blocking session:
|
|
|
|
Session identifier of the blocking session. Populated only when the session was waiting for enqueues or a "buffer busy" wait. Maps to |
|
|
|
Serial number of the blocking session |
|
|
|
Instance number of the blocker shown in |
|
|
|
Indicates whether the information about |
|
|
|
Object ID of the object that the session is currently referencing. This information is only available if the session was waiting for Application, Cluster, Concurrency, and User I/O wait events. Maps to |
|
|
|
File number of the file containing the block that the session is currently referencing. This information is only available if the session was waiting for Cluster, Concurrency, and User I/O wait events. Maps to |
|
|
|
ID of the block that the session is currently referencing |
|
|
|
Row identifier that the session is referencing |
|
|
|
Oracle top level call number |
|
|
|
Oracle top level call name |
|
|
|
Consumer group ID |
|
|
|
Transaction ID that the session was working on at the time of sampling. |
|
|
|
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 information |
|
|
|
Indicates whether the session was doing connection management at the time of sampling ( |
|
|
|
Indicates whether the session was parsing at the time of sampling ( |
|
|
|
Indicates whether the session was hard parsing at the time of sampling ( |
|
|
|
Indicates whether the session was executing SQL statements at the time of sampling ( |
|
|
|
Indicates whether the session was executing PL/SQL at the time of sampling ( |
|
|
|
Indicates whether the session was executing inbound PL/SQL RPC calls at the time of sampling ( |
|
|
|
Indicates whether the session was compiling PL/SQL at the time of sampling ( |
|
|
|
Indicates whether the session was executing Java at the time of sampling ( |
|
|
|
Indicates whether the session was doing bind operations at the time of sampling ( |
|
|
|
Indicates whether the session was closing a cursor at the time of sampling ( |
|
|
|
Indicates whether the session is loading in sequence (in sequence load code) ( |
|
|
|
Indicates whether the session was querying the In-Memory Column Store (IM column store) at the time of sampling ( |
|
|
|
Indicates whether the session was populating the IM column store at the time of sampling ( |
|
|
|
Indicates whether the session was prepopulating the IM column store at the time of sampling ( |
|
|
|
Indicates whether the session was repopulating the IM column store at the time of sampling ( |
|
|
|
Indicates whether the session was trickle repopulating the IM column store at the time of sampling ( |
|
|
|
Indicates whether encryption or decryption of a tablespace occurred at the time of sampling ( |
|
|
|
Indicates whether the session is executing capture code ( |
|
|
|
Indicates whether the session is executing replay code ( |
|
|
|
Indicates whether the session is being captured ( |
|
|
|
Indicates whether the session is being replayed ( |
|
|
|
Indicates whether the session is holding a synchronization token ( |
|
|
|
Hash that identifies the Service |
|
|
|
Name of the operating system program |
|
|
|
Name of the currently executing module as set by the |
|
|
|
Name of the currently executing action as set by the |
|
|
|
Client identifier of the session |
|
|
|
Client's operating system machine name |
|
|
|
Client port number |
|
|
|
Execution context identifier (sent by Application Server) |
|
|
|
If the session is being captured or replayed, then |
|
|
|
If the session is being captured or replayed, then |
|
|
|
Time interval (in microseconds) over which |
|
|
|
Amount of time this session spent on CPU over the last |
|
|
|
Amount of time spent by this session in database calls over the last |
|
|
|
Time interval (in microseconds) since the last time this session was sampled or created, over which the next five statistics are accumulated |
|
|
|
Number of read I/O requests made by this session over the last |
|
|
|
Number of write I/O requests made by this session over the last |
|
|
|
Number of I/O bytes read by this session over the last |
|
|
|
Number of I/O bytes written by this session over the last |
|
|
|
Number of I/O bytes sent over the I/O interconnect over the last |
|
|
|
Amount of PGA memory (in bytes) consumed by this session at the time this sample was taken |
|
|
|
Amount of TEMP memory (in bytes) consumed by this session at the time this sample was taken |
|
|
|
Database operation name. If the type is SQL, the |
|
|
|
Database operation execution identifier for the current execution. If the type is SQL, the |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also:
-
Oracle Database PL/SQL Packages and Types Reference for more information about the
DBMS_APPLICATION_INFO
package