You are absolutely correct. * means all instances
instance_name.parameter means just the named instance.
On 9/27/05, Paul Baumgartel <paul.baumgartel_at_gmail.com> wrote:
>
> CREATE PFILE FROM SPFILE produces this format. I think the * is meaningful
> in RAC systems where instances might share a pfile, and the * means the
> value is valid for all instances. Correct me if I'm wrong, anyone!
>
> On 9/27/05, Adams, Matthew (GE Consumer & Industrial) <MATT.ADAMS_at_ge.com>
> wrote:
> >
> >
> > Anybody ever seen a init.ora file in an init.ora file that looks like
> >
> > *.db_block_size=8192
> > *.db_cache_size=256M
> >
> > etc?
> >
> > I've never seen an asterisk and period at the beginning of a init.oraline before.
> >
> > I know this is not a spfile, because 'alter system .... scope=spfile'
> > command get ORA-32001 errors.
> >
> > What is the significance of the asterisk and period?
> >
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
>
>
>
> --
> Paul Baumgartel
> paul.baumgartel_at_aya.yale.edu
>
>
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 27 2005 - 13:47:19 CDT
