how does oracle store cursors in memory?
- From: "Ryan" <ryan.gaffuri@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 13 Feb 2004 20:13:13 -0500
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@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:
