Re: LOCK_SGA

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<8gntju4pj7k82vcjvkcsi66j468d2nrs9s_at_4ax.com>...
> On Wed, 24 Jul 2002 09:14:59 -0400, "Harry Sheng"
> <hsheng_at_innovance.com> wrote:
>
> >Hi, group
> >
> >Does the "LOCK_SGA" parameter (Oracle8.1.7) mean anything on Solaris8 ?
> >How can I clear the ORA-27126 error when I set the "LOCK_SGA" to true in
> >my oracle parameter file ?
> >
> >
> Oracle on Solaris automatically uses I(ntimate)S(hared)M(emory).
> Hence you don't need to lock the SGA

Indeed he doesn't need lock_sga unless _use_ism is explicitly set to false. His problem is that "On Solaris the function calls that Oracle uses to fix the SGA in memory can only be done by root, but the Oracle executable is normally owned by Oracle" (Metalink note 121983.1). According to documentation about lock_sga, it's ignored if unsupported (which is on Solaris). So throwing ORA-27126 should be an Oracle bug, unless the documentation says otherwise.

Yong Huang Received on Wed Jul 24 2002 - 17:13:06 CDT