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-78871ffd-779f-4c14-a40d-11d94425e7f4
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C34D42.346D2CBA"
------_=_NextPart_001_01C34D42.346D2CBA
Content-Type: text/plain;
charset="iso-8859-1"
We never have specified sid= option ... because we always use spfile.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-----Original Message-----
From: Molina, Gerardo [mailto:Gerardo.Molina_at_schwab.com]
Sent: Friday, July 18, 2003 12:15 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE
one spfile for all instances.
you use alter system but there is a sid= parameter that allows for instance
granularity.
For example,
to affect all instances:
alter system set db_cache_size = 500m scope=both sid=*;
or to affect one:
alter system set db_cache_size = 500m scope=both sid=<instance_1>;
You can also specify a list of instances.
If you don't specify any sid, then I believe it affects instance you're
connected to only.
Gerardo
-----Original Message-----
From: Jamadagni, Rajendra [mailto:Rajendra.Jamadagni_at_espn.com]
Sent: Friday, July 18, 2003 8:59 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE
Our spfile is shared by all instances in the RAC ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-----Original Message-----
From: Gogala, Mladen [ mailto:MGogala_at_oxhp.com <mailto:MGogala_at_oxhp.com> ]
Sent: Friday, July 18, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE
SPFILE is instance specific, modified by "alter system", not
by "alter database". That means that RAC doesn't affect it.
You can try with raw device for the pfile, if you can do something
like "vi /dev/rdsk/c0d1s2" (I hate ###@$!### Emacs). If you can,
please let me know which system allows that.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:mgogala_at_oxhp.com
------_=_NextPart_001_01C34D42.346D2CBA
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 5.50.4926.2500" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=739113415-18072003><FONT face="Courier New" color=#0000ff
size=2>We never have specified sid= option ... because we always use
spfile.</FONT></SPAN></DIV>
<DIV><SPAN class=739113415-18072003><FONT face="Courier New" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=739113415-18072003><FONT face="Courier New" color=#0000ff
size=2>Raj</FONT></SPAN></DIV>
<DIV><SPAN class=739113415-18072003></SPAN><FONT face="Courier New"
size=2>--------------------------------------------------------------------------------</FONT>
<BR><FONT face="Courier New" size=2>Rajendra dot Jamadagni at nospamespn dot
com</FONT> <BR><FONT face="Courier New" size=2>All Views expressed in this email
are strictly personal.</FONT> <BR><FONT face="Courier New" size=2>QOTD: Any clod
can have facts, having an opinion is an art !</FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Molina, Gerardo
[mailto:Gerardo.Molina_at_schwab.com]<BR><B>Sent:</B> Friday, July 18, 2003 12:15
PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE:
Why are SPFILEs binary anyway? (was RE: How to make
SPFILE<BR><BR></FONT></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff size=2>one
spfile for all instances.</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff size=2>you
use alter system but there is a sid= parameter that allows for instance
granularity.</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff size=2>For
example,</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff size=2>to
affect all instances:</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2>alter system set db_cache_size = 500m scope=both
sid=*;</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff size=2>or
to affect one:</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2>alter system set db_cache_size = 500m scope=both
sid=<instance_1>;</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff size=2>You
can also specify a list of instances.</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff size=2>If
you don't specify any sid, then I believe it affects instance you're connected
to only.</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2>Gerardo</FONT></SPAN></DIV>
<DIV><SPAN class=464551115-18072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Jamadagni,
Rajendra [mailto:Rajendra.Jamadagni_at_espn.com] <BR><B>Sent:</B> Friday, July
18, 2003 8:59 AM<BR><B>To:</B> Multiple recipients of list
ORACLE-L<BR><B>Subject:</B> RE: Why are SPFILEs binary anyway? (was RE: How
to make SPFILE<BR><BR></FONT></DIV>
<P><FONT size=2>Our spfile is shared by all instances in the RAC ...
</FONT></P>
<P><FONT size=2>Raj</FONT> <BR><FONT
size=2>--------------------------------------------------------------------------------</FONT>
<BR><FONT size=2>Rajendra dot Jamadagni at nospamespn dot com</FONT>
<BR><FONT size=2>All Views expressed in this email are strictly
personal.</FONT> <BR><FONT size=2>QOTD: Any clod can have facts, having an
opinion is an art !</FONT> </P><BR>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From:
Gogala, Mladen [<A
href="mailto:MGogala_at_oxhp.com">mailto:MGogala_at_oxhp.com</A>]</FONT> <BR><FONT
size=2>Sent: Friday, July 18, 2003 11:49 AM</FONT> <BR><FONT size=2>To:
Multiple recipients of list ORACLE-L</FONT> <BR><FONT size=2>Subject: RE:
Why are SPFILEs binary anyway? (was RE: How to make SPFILE</FONT> </P><BR>
<P><FONT size=2>SPFILE is instance specific, modified by "alter system",
not</FONT> <BR><FONT size=2>by "alter database". That means that RAC doesn't
affect it. </FONT><BR><FONT size=2>You can try with raw device for the
pfile, if you can do something</FONT> <BR><FONT size=2>like "vi
/dev/rdsk/c0d1s2" (I hate ###@$!### Emacs). If you can, </FONT><BR><FONT
size=2>please let me know which system allows that.</FONT> </P>
<P><FONT size=2>Mladen Gogala</FONT> <BR><FONT size=2>Oracle DBA</FONT>
<BR><FONT size=2>Phone:(203) 459-6855</FONT> <BR><FONT
size=2>Email:mgogala_at_oxhp.com</FONT>
</P></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C34D42.346D2CBA--
------=_NextPartTM-000-78871ffd-779f-4c14-a40d-11d94425e7f4
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.*********************************************************************1
Received on Fri Jul 18 2003 - 10:35:23 CDT
