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: 4
Registered: August 2007
Location: Bangalore
Junior Member
Hi,

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


Thanks,
Razz
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: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
With regards to what in particular?
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: 4
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
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: 4
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
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: 1027
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
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: 4
Registered: April 2008
Location: pune
Junior Member
thanks raj
Re: Related to Cursor [message #319971 is a reply to message #318778] Tue, 13 May 2008 09:28 Go to previous messageGo to next message
user1985
Messages: 4
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 .
Re: Related to Cursor [message #321488 is a reply to message #318604] Tue, 20 May 2008 08:00 Go to previous messageGo to next message
user1985
Messages: 4
Registered: August 2007
Location: Bangalore
Junior Member
Could any one clarify me

Thanks in advance.
Re: Related to Cursor [message #321666 is a reply to message #321488] Wed, 21 May 2008 00:21 Go to previous message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

Quote:
Is the private sql area will contains all records return by SQL Query of Cursor
All the data (roIs the private sql area will contains all records return by SQL Query of Cursorws/records) retrived by your cursor (implicite or explicite) are stored in database buffer cache, not in the private sql area. Private SQL area contains the information specific to the sql statements executed by user like bind variables used by the statement.



Quote:
How much sql area of memory is allocated

It depends on the sql statement you are going to execute.
Private Sql area is the part of PGA and a DBA can specify the total size dedicated to PGA memory for the Oracle instance by setting the initialization parameter PGA_AGGREGATE_TARGET. The end user need not to worry about the size of memory allocated to his statement for execution in the form of private sql area.

Hope this helps you make you concepts clear.

Regards.
Previous Topic: Alter Initial Extent Size
Next Topic: IS and AS
Goto Forum:
  


Current Time: Fri Dec 09 13:32:38 CST 2016

Total time taken to generate the page: 0.12770 seconds