I am being asked to increase the cursor count from the default amount of 300 to 1,000 and i am not confident on which way to go about this.
I see that you can do this by either one of these statements:
ALTER SYSTEM SET OP_CURSORS=3000 SCOPE=SPFILE;
OR
ALTER SYSTEM SET OP_CURSORS=3000 SCOPE=BOTH;
After doing some research on the internet, i guess depending on how your database is started, depends on which command you use?
I did a query on the database and it appears that we are starting the database using a SPFILE.
I am thinking that i should use the 'ALTER SYSTEM SET OP_CURSORS=3000 SCOPE=BOTH;' command but am worried about the database not starting back up.
Can someone give me guidance on which way i need to proceed please?
Thanks
Deanna