Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002

    Unanswered: problem modifying spfile "sessions" parameter

    I have a co-dba here who is having an SPFILE issue.

    First of I know the sessions parameter is not a dynamic parameter

    She is basically trying to alter the sessions parameter in her spfile.

    She says that she altered the sessions parameter first in her init.ora file from 170 to 200 and then created the spfile, however it seems that the spfile did not take the modified parameter.

    I was thinking maybe the parameter had been rolled up into the processess parameter like so many former 8i parameters have been in 9i realease 2, but she insists that it exists as its own parameter.

    I suggested that she export her current spfile into a pfile and then recreate the spfile from that pfile (we're yet to see the results of this trial).

    Yes the spfile is in the $ORACLE_HOME/dbs directory and yes its currently whats been used to start the instance.

    pls help


  2. #2
    Join Date
    Jan 2003
    Hi Wale,

    you can use the "alter system set" statement to modify the parameter in spfile.

    alter system set sessions=200 scope=spfile;

    This will modify the parameter only in spfile and not for the running instance. So with the scope option you can change static parameters only in spfiles.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts