Message-Id: <25937.338155@fatcity.com> From: "Jamadagni, Rajendra" Date: Wed, 16 Jul 2003 21:46:45 -0400 Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------=_NextPartTM-000-c9bae432-313c-4380-bc86-57b3df6c0df2 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C34C05.4760289C" ------_=_NextPart_001_01C34C05.4760289C Content-Type: text/plain; charset="iso-8859-1" it isn't binary on solaris ... pure text ... Raj -----Original Message----- From: Pardee, Roy E [mailto:roy.e.pardee@lmco.com] 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 ------_=_NextPart_001_01C34C05.4760289C Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE = in sync with INIT.ORA ?)

it isn't binary on solaris ... pure text ...

Raj

-----Original Message-----
From: Pardee, Roy E [mailto:roy.e.pardee@lmco.com]<= /FONT>
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

------_=_NextPart_001_01C34C05.4760289C-- ------=_NextPartTM-000-c9bae432-313c-4380-bc86-57b3df6c0df2 Content-Type: text/plain; name="ESPN_Disclaimer.txt" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="ESPN_Disclaimer.txt" ********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2