RE: child cursor in shared pool
- From: "Steve Adams" <steve.adams@xxxxxxxxxxxx>
- To: "'Sultan Syed'" <ssyed@xxxxxxx>,"'oracle freelists.org'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 18 Mar 2004 18:31:29 +1100
Hi Syed,
This is a gross over-simplification, but you can think of it this way: The
parent cursor contains the SQL statement text only, but no execution plan.
Execution plans are found in child cursors. Child cursors are also called
versions. There are lots of reasons why sessions might not be able to share
the same version.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.christianity.net.au/ - For all
-----Original Message-----
From: Sultan Syed
Sent: Thursday, 18 March 2004 6:01 PM
To: oracle freelists.org
Subject: child cursor in shared pool
Hi list,
Please explain what is parent and child cursor in shared pool.
Based on what, this child cursor is created.
Thanks in advance
Syed
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
