Display information about the statement cache, including cached SQL queries.
-
In the Perspective Resources view, right-click the server 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 enable stmt cache monitoring Adaptive Server configuration option.
-
(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.