In summary, you should avoid soft and hard parses as
much as possible because they inhibit the scalability of applications.
The result of a parse operation is a parent cursor and a child cursor stored in the
library cache.
The key information related to a parent cursor is the text of a SQL statement.
Therefore,
several SQL statements share the same parent cursor if their text is exactly the same
posted on 2010-04-08 14:08
JavaCoffe 閱讀(182)
評論(0) 編輯 收藏 所屬分類:
Oralce&&PL/SQL