RE: how does oracle store cursors in memory?

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Fri, 13 Feb 2004 20:29:38 -0500
Message-ID: <D91D9D5A73FC694BBC52F1EB26AD410FA2E4AD@MSGBOSCLD2WIN.DMN1.FMR.COM>

They are not pointers to data, they are pointers to parsed/pinned sql in the shared_pool.

Regards

Waleed

-----Original Message-----

From: Ryan [mailto:ryan.gaffuri_at_cox.net] Sent: Friday, February 13, 2004 8:13 PM
To: oracle-l_at_freelists.org
Subject: how does oracle store cursors in memory?

I know that data blocks are stored in the sga in linked lists. When hash maps are created the data blocks are stored in the pga as part of the hash map in arrays/linked lists.
How are cursors stored? Now the data for the cursors is going to be in the SGA. Is a cursor just a pointer to the memory location of the data in the SGA? Now I know a 'REF' cursor is basically a named pointer. Am I correct? What data structure does oracle use to store cursors?

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


-----------------------------------------------------------------

----------------------------------------------------------------

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 Fri Feb 13 2004 - 19:29:38 CST