| Explicit cursor data [message #446648] |
Tue, 09 March 2010 16:10  |
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  |
 |
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
