Re: Memory Problems

I have seen process memory demand for parallel query slaves in particular running up to hundreds of megabytes.

Is your CTAS using a group by or set or bitmap indexes, or doing a select from a partition view, perhaps.

I do not recognise the exact details of the HPUX error, but it may simply be that your PQ slave is demanding much more memory than your system configuration allows by default.

Try

    ps -efl and look at the SZ (or maybe SIZE) column. This is the     number of 4K pages of memory the process has claimed.     Alternatively the sizing column in 'top'.     Or Max Session PGA/UGA memory in v$sesstat.

If the numbers are ridiculously large, you may have hit an Oracle bug.

(BTW - allow for the hash_area_size or sort_area_size when deciding if the memory demand is huge).

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Scott Johnson wrote in message <376A811E.DBAD8A9F_at_loudoun.com>...
>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
>
>
Received on Sun Jun 20 1999 - 03:34:58 CDT