Which of the following memory components of the SGA contains parsed SQL and execution plans for statements already run against the database?
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- When a statement is executed, Oracle looks for an identical statement/execution plan in which of the follow...
- Which component of the SGA contains the parsed SQL code?
- Which of the following memory components of the SGA prevents SQL statements from being repeatedly parsed th...
- Which of the following caches in SGA is responsible for storing and reusing frequently used SQL statements,...
- Which of the following memory components of the SGA stores all the changes made in the database?
- Which of the following memory components of the SGA consists of blocks that hold data dictionary informatio...
- Which of the following memory components of the SGA is a circular buffer that contains redo entries, which ...
- Which of the following memory components of the SGA is used to hold data blocks read from data files by ser...