Message-Id: <25937.338156@fatcity.com> From: "Arup Nanda" Date: Wed, 16 Jul 2003 22:19:06 -0400 Subject: Re: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in This is a multi-part message in MIME format. ------=_NextPart_000_0041_01C34BE8.45802DF0 Content-Type: text/plain; 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 ?)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 -----=20 From: Jamadagni, Rajendra=20 To: Multiple recipients of list ORACLE-L=20 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 ...=20 Raj=20 -----Original Message-----=20 From: Pardee, Roy E [mailto:roy.e.pardee@lmco.com]=20 Sent: Wednesday, July 16, 2003 6:40 PM=20 To: Multiple recipients of list ORACLE-L=20 Subject: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in = sync with INIT.ORA ?)=20 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,=20 -Roy=20 ------=_NextPart_000_0041_01C34BE8.45802DF0 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 ?)
Not true; it's binary, on both Solaris = 8 and 9. By=20 the most of the file (regardless of the OS) is still text; the non-ascii = chars=20 are present at the beginning of the file.
 
Arup Nanda
----- Original Message -----
From:=20 Jamadagni, Rajendra =
To: Multiple recipients of list = ORACLE-L=20
Sent: Wednesday, July 16, 2003 = 10:44=20 PM
Subject: RE: Why are SPFILEs = binary=20 anyway? (was RE: How to make SPFILE in

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

Raj

-----Original Message-----
From:=20 Pardee, Roy E [mailto:roy.e.pardee@lmco.com]=20
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=20 in
sync with INIT.ORA ?)


I can definitely appreciate the benefits of dynamic=20 parameters, and of being able to persist the values of those = parameters=20 accross shutdown/startup cycles.  But I would have guessed that = oracle=20 could have gotten both of those features together without going to a = binary=20 parameter file--couldn't whatever process writes to the spfile just = write to a=20 plain text file instead?  Does anybody know what the advantage of = having=20 a binary store of params is?

Cheers,
-Roy=20