Display information about the procedure cache.
-
In the Perspective Resources view, right-click the server you want to monitor and select Monitor.
-
In the left pane, select Caches.
-
Click Procedure Cache.
-
(Optional for Adaptive Server cluster configurations) Select a specific cluster instance.
The Cached Procedures table shows all the procedures for the selected instance.
For more information on the procedure cache, see Adaptive Server Performance and Tuning Series: Basics.