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
Received on Fri Feb 13 2004 - 19:13:13 CST
