Re: Why do I get out of memory errors when 10GB memory is free?

From: Park <matthieu.atkinson_at_gmail.com>
Date: Mon, 6 Jul 2009 00:23:39 -0700 (PDT)
Message-ID: <51935d10-1c05-4290-9aa6-6652e7d869e1_at_q11g2000yqi.googlegroups.com>

On Jul 5, 4:43 am, zigzagdna <zigzag..._at_yahoo.com> wrote:
> On Jul 4, 9:15 pm, zigzagdna <zigzag..._at_yahoo.com> wrote:
>
>
>
> > 1.      gpsgetpd=>ulimit -a
> > time(seconds)        unlimited
> > file(blocks)         unlimited
> > data(kbytes)         1048576
> > stack(kbytes)        131072
> > memory(kbytes)       unlimited
> > oredump(blocks)
>
> > 2.      Some kernel parameters relevant to oracle:
> > shmmax                      25662429593  25662429593         Immed
> > shmmni                              512  512                 Immed
> > shmseg                              120  120                 Immed
> > max_thread_proc                    1024  1024                Immed
> > maxdsiz                      1073741824  Default             Immed
> > maxdsiz_64bit                2147483648  2147483648          Immed
> > maxfiles                           5120  5120
> > maxfiles_lim                       6144  6144                Immed
> > maxrsessiz                      8388608  Default
> > maxrsessiz_64bit                8388608  Default
> > maxssiz                       134217728  134217728           Immed
> > maxssiz_64bit                1073741824  1073741824          Immed
> > maxtsiz                       100663296  Default             Immed
>
> > I do not see anything wrong (low values) for ulimit or anyting wrong
> > in kernel parameters.
>
> Sorry, my mazdsiz paremetrs were changed a few days ago, but memory
> errors did not go away,
>
> maxdsiz                      4294963200  4294963200          Immed
> maxdsiz_64bit                4294967296  4294967296          Immed

Hi,

what's your PGA set to? something really big as well?

matt Received on Mon Jul 06 2009 - 02:23:39 CDT