The Open SQL Monitor function is available in SAP NetWeaver Application Server JAVA and it is use to monitor the execution of SQL statements, the status of the table and catalog buffers, as well as the availability and the use of Open SQL database connections.
The page is accessible using the following URL in your browser and you may use j2ee_admin user to access it.
https://[HOST]:[PORT]/OpenSQLMonitors
The following functions are available through the Open SQL Monitors,
1. SQLTrace
On-demand trace of selected JDBC method calls that allows to track all the database accesses within the J2EE engine.
2. TableBufferMonitor
Gives an overview about the status and usage patterns of all Open SQL table buffer instances across the cluster nodes of the J2EE engine
3. SyncLogMonitor
Displays the actual contents of the table SYNCLOG which contains the buffer synchronization records.
4. DBMonitor
Able to display current exclusive database lock wait situations and current database activity.
5. ConnectionMonitor
Provides information about all currently opened database connections to Open and Native SQL data sources across the cluster nodes of the J2EE engine. Furthermore, it allows for each database connection to display the contents of the associated statement pool instance.
6. CatalogBufferMonitor
Gives an overview about the status and usage patterns of all Open SQL catalog buffers across the cluster nodes of the J2EE engine.
7. TableStatisticsMonitor
Provides statistics about database table accesses through Open SQL.
8. SQLStatistics
Provides SQL access statistics for Open SQL data sources.
