Oracle Database Discussions

Hi Guys,

Any idea how much memory will an open cursor consume?

My current open cursor is set to 300. Due to a particular job, i will need to set to 400. (meaning each session can use 400 if needed)

Understand that by setting it to a higher value, it simply only allocates a fixed number of slots but does not allocate memory for these slots unless it is utilized.

Just want to see if there is way to "predict" how much memory will an open cursor utilize for impact analysis.


thanks