Re: Modify init.ora

The parameter will take effect only the next time you start the database instance. Till then,
the instance will continue running with the value that was set when the instance was last
started.
You can change init.ora parameters [except for DB_BLOCK_SIZE and DB_NAME] after the
database has been created -- this is sometimes required in tuning. DB_BLOCK_SIZE
cannot be changed unless you recreate the database. DB_NAME can only be changed
with a re-creation of the controlfiles.

Hemant
At 05:23 AM 08-10-02 -0800, you wrote:
>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.

Hemant K Chitale
My web site page is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).