Explicit cursor data [message #446648] |
Tue, 09 March 2010 16:10 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shrinika
Messages: 306 Registered: April 2008
|
Senior Member |
|
|
Hello,
I have table called EMP and it has 10,000 records. Now i have PLSQL and opens
the explicit cursor and fetch all the data from EMP table. In which memory oracle
keeps all the explicit cursor data? Shared pool?
|
|
|
|
|
Re: Explicit cursor data [message #446677 is a reply to message #446648] |
Tue, 09 March 2010 23:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Cursor data means cursor information needed to continue the execution and fetching database data, it does not mean database data that is it does not contain EMP table.
Regards
Michel
|
|
|