Home » RDBMS Server » Performance Tuning » Explicit cursor data (Oracle10g)
Explicit cursor data [message #446648] Tue, 09 March 2010 16:10 Go to next message
shrinika
Messages: 266
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 #446650 is a reply to message #446648] Tue, 09 March 2010 16:14 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
> In which memory oracle keeps all the explicit cursor data?
PGA
Re: Explicit cursor data [message #446653 is a reply to message #446650] Tue, 09 March 2010 16:27 Go to previous messageGo to next message
shrinika
Messages: 266
Registered: April 2008
Senior Member
Thanks!!!
Re: Explicit cursor data [message #446677 is a reply to message #446648] Tue, 09 March 2010 23:01 Go to previous message
Michel Cadot
Messages: 64140
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
Previous Topic: sga
Next Topic: Update statement resulting time out
Goto Forum:
  


Current Time: Fri Dec 09 03:37:56 CST 2016

Total time taken to generate the page: 0.16628 seconds