The session_stats_prim table contains database session server session statistics. One row is returned for each session connected to each server in the current IMA management domain.
| Attribute Name | Key | Datatype | Description |
| server | 1 | varchar(64) | Database server name. |
| session_index | 1 | integer4 | Internal index for the current session. |
| session_id | 0 | varchar(16) | Internal identifier of the database server session |
| activity_detail | 0 | varchar(128) | Detailed description of the current session activity. |
| activity | 0 | varchar(64) | String description of the current session activity. |
| appl_code | 0 | integer4 | Current session application code. |
| connect_limit | 0 | integer4 | Session connect time limit, -1 is unlimited. |
| facility_index | 0 | integer4 | Server facility the session is currently in, numeric. |
| facility_name | 0 | varchar(12) | Server facility the session is currently in. |
| assoc_id | 0 | integer4 | Global Communication Facility (GCF) association id. |
| idle_limit | 0 | integer4 | Session idle limit. |
| curr_connect_limit | 0 | integer4 | Initial connect time limit. |
| curr_idle_limit | 0 | integer4 | Current idle time limit. |
| sec_label | 0 | varchar(64) | Initial session security label. |
| priority | 0 | integer4 | Current session execution priority. |
| priority_limit | 0 | integer4 | Highest execution priority for the session. |
| query_text | 0 | varchar(1024) | Query string, if no query is executing this will be blank. |
| role | 0 | integer4 | Current session role. |
| curr_sec_label | 0 | varchar(64) | Current security label. |