Viewing SQL Statements Stored in the SQL Command Cache

All commands after they run—SQL statements, built-in procedures, and so on—are stored in the SQL command cache, which uses temporary memory.

The commands are stored up until the limit of the SQL command cache is reached, then the new commands are stored after the last used commands are removed. You can retrieve one or more of these commands that are stored in the SQL command cache.

Note:

This section describes viewing the commands stored in the SQL command cache. For details on how to view the query plans associated with these commands, see Viewing Query Plans Associated with Commands Stored in the SQL Command Cache.

The following sections describe how to view commands cached in the SQL command cache:

• Managing Performance and Troubleshooting Commands

• Displaying Commands Stored in the SQL Command Cache