When subqueries are not flattened or materialized, a subquery cache is created to store results of earlier executions of the subquery to reduce the number of expensive executions of the subquery.
See “Displaying subquery cache information” on page 138 in the Performance and Tuning: Optimizer and Abstract Plans for information on using this option.
