The Dynamic SQL Cache subsystem performance folder provides information about dynamic SQL statements that are cached for reuse. Use this information to determine cached dynamic SQL statements and the accumulated resource use for each statement. The complete cached SQL statement can also be displayed.
Select an SQL statement to view the full SQL text and explain it using the DBA Command Manager. The explain displays access path information and CA-supplied recommendations for the statement that can be used to understand the performance of the statement.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|