The session_os_stats table contains database server session resource usage statistics. One row is returned for each session connected to each server in the current IMA management domain. Delta columns represent changes in counter values since the last interval.
| Attribute Name | Key | Datatype | Description |
| timestamp | 0 | date | Date and time the data was collected |
| delta_seconds | 0 | integer4 | Elapsed time (seconds) since the previous refresh. |
| server | 1 | varchar(64) | Database server name. |
| session_index | 0 | varchar(16) | Internal index for the current session. |
| session_id | 2 | varchar(16) | Internal session identifier. |
| scb_owner | 0 | integer4 | Internal identifier for session block owner. |
| pid | 0 | integer4 | Process id of the database server. |
| ppid | 0 | integer4 | |
| session_type_s | 0 | varchar(32) | Session type for the current session. |
| session_type | 0 | integer4 | Numeric session type for the current session. |
| comm_ios | 0 | integer4 | Count of messages exchanged between the client and the associated server session. |
| comm_ios_d | 0 | integer4 | Count of messages exchanged between the client and the associated server session in the last interval. |
| client_type | 0 | integer4 | Client type associated with the current session. |
| condition | 0 | integer4 | Current session condition. |
| connect_time | 0 | integer4 | Timestamp when the connection was established. |
| cpu_used | 0 | integer4 | Cpu time consumed by the session in 10 millisecond ticks, divide by 100 to get cpu seconds. |
| cpu_used_d | 0 | integer4 | Cpu time consumed by the session in 10 millisecond ticks in the last interval, divide by 100 to get cpu seconds. |
| disk_ios | 0 | integer4 | Count of physical disk I/O operations initiated by the current session. |
| disk_ios_d | 0 | integer4 | Count of physical disk I/O operations initiated by the current session in the last interval. |
| kernel_cpu_used | 0 | integer4 | Kernel mode cpu ticks consumed by the current session. |
| kernel_cpu_used_d | 0 | integer4 | Kernel mode cpu ticks consumed by the current session in the last interval. |
| lock_count | 0 | integer4 | Count of locks currently held by the session. |
| lock_count_d | 0 | integer4 | Number of locks acquired in the last interval |
| session_mask_s | 0 | varchar(64) | Session mask for the current session. |
| stack_size | 0 | integer4 | Execution stack size for the current session. |
| current_mode | 0 | integer4 | Current session mode. |
| next_mode | 0 | integer4 | Next session mode. |
| session_state_s | 0 | varchar(64) | Current session state. |
| session_state | 0 | integer4 | Current numeric session state. |
| username | 0 | varchar(64) | Real user name of the client associated with the current session. |
| session_mask | 0 | integer4 | Numeric mask for the current session. |
| wait_reason | 0 | varchar(16) | If the session is in a wait state this is the wait reason. |