RE: child cursor in shared pool

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Thu, 18 Mar 2004 18:31:29 +1100
Message-ID: <008601c40cbb$079a0ad0$ae8735cb@ixora.com.au>

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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Mar 18 2004 - 01:30:51 CST