DBMS Group

The DBMS Group displays information about the database server.

The DBMS Group has the following columns:
Table 1. DBMS Group
Column Description
Num Databases The total number of user databases.
Num Groups The total number of groups.
Num Users The total number of database users.
Num Schemas The total number of schemas in the database.
Num Tables The total number of user tables.
Num Views The total number of user views.
Num SQL Sessions The total number of current SQL sessions/connections.
Num Queries The total number of queries that have been submitted, but not completed.
Num Queries Running The total number of currently running queries.
Num Queries Waiting The total number of currently queries waiting to be run.
Num Transactions The total number of open and recent transactions that are maintained by the Transaction Manager.