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: 252
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: 24903
Registered: January 2009
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: 252
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: 63801
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: Sat Sep 24 18:03:12 CDT 2016

Total time taken to generate the page: 0.09487 seconds