Re: Init File Question

From: <fitzjarrell_at_cox.net>
Date: Thu, 06 Sep 2007 13:37:27 -0700
Message-ID: <1189111047.799021.56740@o80g2000hse.googlegroups.com>

On Sep 6, 2:09 pm, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
> Hey All,
>
> This is probably a simple question, but I've never seen this before:
>
> VOLGA2.__shared_pool_size=1073741824
> *.background_dump_dest='/u01/NI00/admin/bdump'
>
> My questions are: Why the underscored before the shared pool size?
> And, what does the asterisk mean before the background dump dest??
>
> Probably just some formatting, or does it have special meaning??
>
> Thanks!

Your init.ora was likely generated from an spfile, and the * indicates the value is intended for all instances/databases using that init.ora file. I believe this is/was intended for RAC configurations to allow one init.ora file to service all nodes, but someone else may correct me.

As to the leading underscores in the shared_pool_size parameter I've never seen that before; I find no such parameter in 10.2.0.3 listed, although I do find

_shared_pool_max_size shared pool maximum size when auto SGA enabled
_shared_pool_minsize_on shared pool minimum size when auto SGA enabled
_shared_pool_reserved_min_alloc minimum allocation size in bytes for reserved area of shared pool
_shared_pool_reserved_pct percentage memory of the shared pool allocated for the reserved area

Possibly someone else may have an idea.

David Fitzjarrell Received on Thu Sep 06 2007 - 15:37:27 CDT