PARENT AND CHILD CURSORS IN ORACLE

-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.

Brief
– 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.

http://oracleinaction.com/parent-child-curosr/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s