SQL & PL/SQL

Hi,

I found in documentation, that the parameter session_cached_cursors could be changed by "alter session". But I want this parameter set for the system and not only for the session.

I set this parameter manually by writing it into the PFILE and then start the database with PFILE-Option.

The problems:
I use SPFILE for starting database
I need this parameter set by a script automatically, so that the customers don't need to edit the PFILE, start the database with PFILE, safe it as SPFILE and start the database again.

Any suggestion for setting this value automatically for the whole system?

Thank you in advance
Dana Mildner