RE: Modify init.ora

[Hsu, Anthony C., ,CPMS]

In 9i, a new parameter file called SPFILE is introduced. A SPFILE enable you to self-tune the parameter values that are recorded in the file. You can use ALTER SYSTEM parameter = value  [ SCOPE=MEMORY|SPFILE|BOTH] command to change the values of the dynamic instance parameters.   Thanks.   Anthony -----Original Message----- From: Naveen Nahata [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 10:18 AM To: Multiple recipients of list ORACLE-L Subject: RE: Modify init.ora INIT.ORA is looked up at the time of STARTUP only.   PROCESSES cannot be changed until the DB is bounced. To see whether a particular parameter can be modified without bouncing the DB query the V$PARAMETER view   Regards Naveen -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 6:54 PM To: Multiple recipients of list ORACLE-L Subject: Modify init.ora Hi! DBAs,   If I modify the "Process" in init.ora after database was created and running for quite a long while, is it true that the maximum of the process will increase as what i changed? do i need to change anything?   init.ora will be used everytime the database start, right? or just for the initialization for db creation?   thanks in advance.