You determine that database performance is sub-optimal due to hard parsing statements. Automatic Shared Memory Management (ASMM) is disabled for your database instance. Which tool would you use to…

The Memory Advisor for the PGA focuses on the Program Global Area, which is primarily used for session-specific operations like sorting and hashing, not directly for mitigating hard parsing statements in the shared pool.

The SQL Access Advisor recommends and evaluates access structures like indexes and materialized views to improve SQL statement execution, rather than advising on memory component sizing.

Hard parsing statements are highly dependent on the size and efficiency of the shared pool within the System Global Area (SGA). The Memory Advisor for the shared pool analyzes shared pool usage and provides advice on optimal sizing, which can significantly reduce hard parsing and improve overall database performance. This advisor helps in manually tuning the shared pool when ASMM is not managing it automatically.

The SQL Tuning Advisor focuses on improving the execution plan of individual SQL statements, not on the overall memory configuration of the shared pool to reduce hard parsing.