Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » RDBMS Server » Server Administration » Related to Cursor
Related to Cursor [message #318604] Wed, 07 May 2008 04:54 Go to next message
user1985
Messages: 3
Registered: August 2007
Location: Bangalore
Junior Member
Hi,

Could any one explain,how the Memory allocation will be done for Cursor?


Thanks,
Razz
Report message to a moderator
Re: Related to Cursor [message #318607 is a reply to message #318604 ] Wed, 07 May 2008 05:22 Go to previous messageGo to next message
JRowbottom
Messages: 2663
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
With regards to what in particular?
Report message to a moderator
icon10.gif  Re: Related to Cursor [message #318612 is a reply to message #318604 ] Wed, 07 May 2008 05:39 Go to previous messageGo to next message
eoracle
Messages: 2
Registered: April 2008
Location: pune
Junior Member
whenever a cursor is processed private sql area of memmory is allocated automatically by oracle server ,where the rows in cursor are processed
Report message to a moderator
Re: Related to Cursor [message #318618 is a reply to message #318604 ] Wed, 07 May 2008 05:56 Go to previous messageGo to next message
user1985
Messages: 3
Registered: August 2007
Location: Bangalore
Junior Member
Hi,

How much sql area of memory is allocated(if it depends on any Parameters,can u share to me)?
Is the private sql area will contains all records return by SQL Query of Cursor??

As i know The cursor Retrieves Chunk of Records and process those and then after retrives next chunk of records.
correct me if i am wrong in above,For this i need more information,could any one explain and provide any documentation if u had.

Thanks in advance
Report message to a moderator
Re: Related to Cursor [message #318664 is a reply to message #318618 ] Wed, 07 May 2008 08:53 Go to previous messageGo to next message
S.Rajaram
Messages: 516
Registered: October 2006
Location: United Kingdom
Senior Member
Check this link. It explains briefly how cursor works. In a brief note oracle will do what you ask it to do. It won't do anything more or anything less.

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/sqloperations.htm#i45288

Last but not least spend some time in reading the forum guidelines.

Regards

Raj
Report message to a moderator
icon10.gif  Re: Related to Cursor [message #318778 is a reply to message #318664 ] Wed, 07 May 2008 23:32 Go to previous messageGo to next message
eoracle
Messages: 2
Registered: April 2008
Location: pune
Junior Member
thanks raj
Report message to a moderator
Re: Related to Cursor [message #319971 is a reply to message #318778 ] Tue, 13 May 2008 09:28 Go to previous message
user1985
Messages: 3
Registered: August 2007
Location: Bangalore
Junior Member
I read the link but not got any info related to internal operation.
Could you explian the same i.e "How much sql area of memory is allocated(if it depends on any Parameters,can u share to me)?
Is the private sql area will contains all records return by SQL Query of Cursor?? As i know The cursor Retrieves Chunk of Records and process those and then after retrives next chunk of records."


Thanks .
Report message to a moderator
Previous Topic:During ADD Constraints
Next Topic:ASM on Suse linux 10
Goto Forum:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Sat May 17 05:43:56 CDT 2008

Total time taken to generate the page: 0.04186 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.