Display information about the procedure cache.
- 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 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.