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

From: Arup Nanda <orarup_at_hotmail.com>
Date: Wed, 16 Jul 2003 22:19:06 -0400
Message-Id: <25937.338156@fatcity.com>

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_at_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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD><TITLE>RE: Why are SPFILEs binary anyway? (was RE: How to = make SPFILE in sync with INIT.ORA ?)</TITLE> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1">

<META content=3D"MSHTML 6.00.2719.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>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.</FONT></DIV>

<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Arup Nanda</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20

style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; = BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20

  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
<A title=3DRajendra.Jamadagni_at_espn.com=20
  href=3D"mailto:Rajendra.Jamadagni_at_espn.com">Jamadagni, Rajendra</A> = </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
title=3DORACLE-L_at_fatcity.com=20
  href=3D"mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list = ORACLE-L</A>=20
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Wednesday, July 16, 2003 =
10:44=20
  PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: Why are SPFILEs =
binary=20
  anyway? (was RE: How to make SPFILE in</DIV>
<DIV><BR></DIV>
<P><FONT size=3D2>it isn't binary on solaris ... pure text ...</FONT> =
</P>
<P><FONT size=3D2>Raj</FONT> </P>
<P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>From:=20
  Pardee, Roy E [<A=20
  =
href=3D"mailto:roy.e.pardee_at_lmco.com">mailto:roy.e.pardee_at_lmco.com</A>]</= FONT>=20
<BR><FONT size=3D2>Sent: Wednesday, July 16, 2003 6:40 PM</FONT> =
<BR><FONT=20

  size=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT=20
  size=3D2>Subject: Why are SPFILEs binary anyway? (was RE: How to make =
SPFILE=20

  in</FONT> <BR><FONT size=3D2>sync with INIT.ORA ?)</FONT> </P><BR>
<P><FONT size=3D2>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?</FONT></P>
<P><FONT size=3D2>Cheers,</FONT> <BR><FONT size=3D2>-Roy</FONT>=20
Received on Wed Jul 16 2003 - 21:19:06 CDT