Database Management Technology

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

sessions_prim

The sessions_prim table contains database server session and associated client information.  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
client_connect 0 varchar(32) Database name opened by the client.
client_host 0 varchar(32) Host name where the client process is running.
client_info 0 varchar(128) The complete client connection string
client_pid 0 integer4 Client process id.
client_tty 0 varchar(32) Client terminal name.
client_user 0 varchar(32) Login username of the client process.
db_name 0 varchar(32) Database name opened by the session.
db_lockmode 0 varchar(32) String representation of the database lockmode.
db_owner 0 varchar(32) Owner of the opened database.
description 0 varchar(64) Session description as set by the client.
effective_user 0 varchar(32) Effective user name, this is the username specified with the -u flag.
effective_group 0 integer4 Effective session group id.
server_pid 0 integer4 Operating system process id of the server
real_user 0 varchar(32) Real username, this is the client login name.
session_name 0 varchar(32) Session name, for user sessions this is the same as the effective user.
terminal 0 varchar(32) Terminal name attached to the client process.

 


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