Re: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in

[Arup Nanda]

Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in sync with INIT.ORA ?)

Not true; it's binary, on both Solaris 8 and 9. By the most of the file (regardless of the OS) is still text; the non-ascii chars are present at the beginning of the file.   Arup Nanda ----- Original Message ----- From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 16, 2003 10:44 PM Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in it isn't binary on solaris ... pure text ... Raj -----Original Message----- From: Pardee, Roy E [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 16, 2003 6:40 PM To: Multiple recipients of list ORACLE-L Subject: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in sync with INIT.ORA ?) I can definitely appreciate the benefits of dynamic parameters, and of being able to persist the values of those parameters accross shutdown/startup cycles.  But I would have guessed that oracle could have gotten both of those features together without going to a binary parameter file--couldn't whatever process writes to the spfile just write to a plain text file instead?  Does anybody know what the advantage of having a binary store of params is? Cheers, -Roy