Re: Memory Problems

Scott Johnson wrote:
>
> I'm running Oracle 7.3.3 on an HP-UX 10.20. During our daily process
> of data, specifically, during a CTAS (create table as select), UNIX
> generates the following messages in the syslog. The PID relate to and
> Oracle parallel query process. Anyone know what might cause this?
>
> Jun 18 13:06:21 spider vmunix: process pid == 19988 does not have memory
>
> Jun 18 13:06:21 spider vmunix: locking privileges required for using
> Jun 18 13:06:21 spider vmunix: large text pages in this system version
>
> Jun 18 13:06:21 spider vmunix: see setprivgrp(1m)
> Jun 18 13:10:21 spider vmunix: process pid == 20008 does not have memory
>
> Jun 18 13:10:21 spider vmunix: locking privileges required for using
> Jun 18 13:10:21 spider vmunix: large text pages in this system version
>
> Jun 18 13:10:21 spider vmunix: see setprivgrp(1m)
> Jun 18 13:10:21 spider vmunix: process pid == 20011 does not have memory
>
> Jun 18 13:10:21 spider vmunix: locking privileges required for using
> Jun 18 13:10:21 spider vmunix: large text pages in this system version
>
> Jun 18 13:10:21 spider vmunix: see setprivgrp(1m)
> ->
>
> Thanks all

Oracle is trying to lock it's memory. By default the group that oracle belongs to (dba in or case) does not have memory locking privilages.

use the following:
setprivgrp dba MLOCK

then create the file /etc/privgroup with the following entry dba MLOCK

the /etc/privgroup file gets read at boot time and locking privs are given to the oracle group.

Matt Reller Received on Sun Jun 20 1999 - 11:45:09 CDT