Group, I try to only use spfile if I HAVE TO, avoid it if possible. conservatism ? maybe. I agree with all arguments against spfile posted so far.
RAC : use a CFS and keep a single, central db.ini somewhere, link your ORACLE_HOME/dbs/initINST.ora to it. If you have to use spfiles (RAC on RAW-dev, yuk), monitor gv$parameters for any modified parameters, and report those regularly as part of your daily monitoring. Also, re-create a pfile-from-sp as you would also spool a controlfile-2-trace, and include all of this in your backup. (am I making a dinosaur-fool out of myself ? comments welcome) Wishlist: Fully Editable spfile, but only if it does not add another utility to the toolbox. Any preview on how this will be done in 10i yet ? Regards, PdV -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Piet de Visser INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
