-V$SQLAREA : Contains one row for each parent cursor
-V$SQL : Contains one row for each child cursor
Relation between parent to child cursor would be one to one or one to many.
V$SQL_SHARED_CURSOR shows the reason why the statement cannot be shared.
– To enable sharing of parent cursors we should follow code formatting standards
– To enable sharing of child cursors we should ensure that
. Optimizer mode is not changed in sessions.
. Length of bind variables used should be same.
. Values of NLS parameters should be same.