Re: "*." prefixes init.ora parms???

"Charles Davis" <cdavis10717_at_comcast.net> wrote in message news:AY-dnQuhNIuUA2TZnZ2dnUVZ_s-dnZ2d_at_comcast.com...
> Hello, all.
>
> I've been through Oracle docs on tahiti.oracle.com and I could not find
> the answer to this question.
>
> A vendor-supplied software package came with its own init.ora file in
> which every parm is prefixed with star-dot in column 1, such as
> '*.db_files = 200', without the quotes, of course.
>
> What is the star-dot doing here, since Oracle started up just fine with
> it.
>
> Many thanks!..
>
> Charles
>

This feature exists for RAC systems.
Each instance can have its own setting for some of the parameters, using notation like:

    sid1.sessions =

Any parameter starting with "*." are common to all instance.

-- 
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html