Database Management Technology

Architecture | Monitor | Sentinel | Query | Testimonials | Documentation | Downloads
Courses | On-Site Courses | Course Schedule | Testimonials |
DBAnalyzer | JVM
Contact Info

session_os_stats_prim

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.

 


About DMT | Contact Us | ©2004 Database Management Technology, Inc. All rights reserved.