You can use the command line tool XCONS (database console) to view information about SAP MaxDB databases, such as:
Operating system resources used by the database system
Distribution of the database sessions to threads
Status of the active database sessions
More information: XCONS Options for Displaying Information about the Database
Recommendation
Only use XCONS in production systems if you have a sound knowledge of databases and operating systems.
You can call up XCONS from the command line, using Database Manager CLI or using the database console in CCMS (in SAP systems).
XCONS can be used on all operating systems supported by the database system. It is a component of the SAP MaxDB software.