max_open_cur value in v$parameter is different to value in init.ora

[sarah.k]

Hello,

I was wondering if anyone could help me please.

Our open cursor value in the init.ora file is set to 300, however in
the v$parameter table the max_open_cur value is 600. Does anyone know
why these don't match should they be the same?

Thanks

Sarah

[AdityA]

Hi Sarah,

The below command could have been executed to modify the open_cursors
parameter:

ALTER SYSTEM SET open_cursors=600 SCOPE=MEMORY;

In the above command, the SCOPE=MEMORY tells Oracle to make the
change for the life of the instance, and to change it back to the
value (i.e. 300) the next time the database is bounced.

So, no need to worry if they do not match. Check the values again in V
$PARAMETER and init.ora file once you bounce the database.

Hope this helps.

Regards,

Aditya.