Related to Cursor [message #318604] |
Wed, 07 May 2008 04:54 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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,
|
|
|
|
|
Re: Related to Cursor [message #318618 is a reply to message #318604] |
Wed, 07 May 2008 05:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #319971 is a reply to message #318778] |
Tue, 13 May 2008 09:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #321666 is a reply to message #321488] |
Wed, 21 May 2008 00:21 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
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.
|
|
|