The Native DB Monitors function is a collection of database-dependent monitors for monitoring underlying databases directly. The function supports all RDMBSs that are allowed as primary databases for the AS Java.
Caution
You need appropriate authorization to use the Native DB Monitors. Without the appropriate authorization, the monitors do not work correctly.
You are in
The Native DB Monitors function consists of the following monitors:
Database Activity
Shows a database-dependent view of the current database activity. The displayed columns are different depending on the RDBMS.
Caution
Refreshing the list may take longer on databases with a high number of parallel sessions.
Current Exclusive Lock Wait Situations
Shows processes currently holding or waiting for locks.
Note
The Current Exclusive Lock Wait Situations on Database table is generally the same for all supported databases. However, the column content can have different meanings depending on the RDBMS.
Note
You cannot sort or filter the Current Exclusive Lock Wait Situations on Database table.
To view database activity for a DataSource on a underlying database, select a DataSource in the Native SQL and Open SQL Datasources screen area and choose Show DB Activity. The Current Database Activity area opens.
To view lock situations, select a DataSource in the Native SQL and Open SQL Datasources screen area and choose Show Current Exclusive Lock Wait Situations. The Current Exclusive Lock Wait Situations on Database area opens. Normally, exclusive lock situations do not last long and thus it is normal (and desired) for the table to be empty.
Note
You can use the Database Activity, Current Exclusive Lock Wait Situations, and the Connection Monitor together to investigate reasons for lock wait situations. We recommend that you open the three monitors in parallel in separate browser windows to facilitate such analyses.