フリー問題

問題文

An application builds its statements by pasting literal values into the text. The shared pool shows thousands of nearly identical cursors. What does using bind variables change?

選択肢

1. The statements become identical text and one parent cursor is then shared which lowers the parsing work and the pressure on the shared pool.
2. The statements keep their own text and the optimizer later merges the plans which lowers the number of executions counted for each cursor.
3. The statements become identical text and one plan is then fixed forever which removes the need for statistics on the columns involved.
4. The statements keep their own text and the database then stores the literal values in a side table which shortens the time spent on each hard parse.