How to change open cursor value in Pfile into oracle

1. Create pfile=’/tmp/initcisora01.ora’ from spfile;

2. shutdown the database;

3. edit the open_cursors=400 in your pfile that is created on /tmp newly and save it.

4. open the database using newly created pfile i.e.

    Startup pfile=’ /tmp/initcisora01.ora’;

5. check whether open_cursor is reflecting 400 now.

    Show parameter open_cursors;

6. now create new spfile from newly created pfile.

   Create spfile from pfile=’/tmp/initcisora01.ora’;

7. normal shutdown and normal startup the database;