Display information about the statement cache, including cached SQL queries.
Note: To enable the Statement Cache tab, the statement cache must be configured in Adaptive Server
and
the enable stmt cache monitoring option must be turned on in Adaptive Server. Turning on the enable stmt cache monitoring option is not necessary to enable monitoring of an Adaptive Server.
- In the Perspective Resources view, select the server to monitor, click the drop-down arrow, and select Monitor.
- In the left pane, select Caches.
- Click the Statement Cache tab.
The Statement Cache tab is disabled if statement cache monitoring is not enabled. Statement cache monitoring is controlled by the two Adaptive Server configuration options enable stmt cache monitoring and statement cache size.
- (Optional for Adaptive Server cluster configurations) Select a specific cluster instance.
The Cached Statements table shows all the statements for the selected instance.
- Select a statement in the Cached Statements table.
The SQL query appears at the bottom of the screen.
- Click the tabs to display pool information or details about cached objects.
For more information on the statement cache, see Adaptive Server System Administration Guide, Volume 2.