Database Management Technology

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

dbms_servers_prim

The dbms_servers_prim table contains basic database server configuration information, including the listener address and the session and transaction limits.  Given a vnode IMA domain this table will return one row for each running database server.

 
Attribute Name Key Datatype Description
server 1 varchar(64) Server name.
server_pid 0 integer4 Operating system process id of the server
process 0 integer4 Pointer to cs_process function.
server_name 0 varchar(64) GCA server name, ie server listener name.
session_max 0 integer4 Maximum number of user sessions allowed.
tx_max 0 integer4 Maximum active threads.
max_cursors 0 integer4 Number of active cursors per session.
q_per_sec 0 integer4 Number of quantums per second.

 


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