| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE
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.
------_=_NextPart_001_01C34D3F.87EF3E6C
Content-Type: text/plain
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
-----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_01C34D3F.87EF3E6C
Content-Type: text/html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2716.2200" name=GENERATOR></HEAD>
<BODY>
<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>
 |
 |