Re: Memory issue with Oracle 10g database on Sun Server T5140 with Solaris 10

  • From: "Bradd Piontek" <piontekdd@xxxxxxxxx>
  • To: ashoke.k.mandal@xxxxxxxxxxxxx
  • Date: Thu, 16 Oct 2008 12:36:32 -0500

I"m sure you could set it to something higher than 4, but your solution
looks correct to me. As stated earlier, oracle auto-sizes a bunch of
parameters based on parameters you set. cpu_count is one of them.

Bradd Piontek
  "Next to doing a good job yourself,
        the greatest joy is in having someone
        else do a first-class job under your
        direction."
 -- William Feather


On Thu, Oct 16, 2008 at 12:16 PM, Mandal, Ashoke <
ashoke.k.mandal@xxxxxxxxxxxxx> wrote:

> Keith,
>
> You are right each thread is counted as one cpu.
> We have one T2000 server with Solaris 10 and the cpu_count is 24 and I
> didn't have problem in creating 10.2.0.4 database with SGA_TARGET as 256M
> on this server.
>
> Where as on T5140 (Solaris 10) with cpu_count 128 I am not able to create a
> 10.2.0.4 database  with SGA_TARGET as 256M. Either I have to set the
> SGA_TARGET to 900MB without changing the cpu_count parameter or change
> cpu_count to 4 and use SGA_TARGET as 256M.
>
> I can't afford to have 900MB as SGA_TARGET for each of my databases (70+)
> on the same server. So my next option is to limit the cpu_count to 4. I am
> trying to find out from the list if this is the only option (i.e.
> cpu_count=4) to overcome my problem on T5140 server or there is any other
> recommendation.
>
> Thanks,
> Ashoke
>
>
> -----Original Message-----
> From: Keith Moore [mailto:kmoore@xxxxxxxxxxxx]
> Sent: Thursday, October 16, 2008 9:32 AM
> To: Mandal, Ashoke; oracle-l
> Subject: Re: Memory issue with Oracle 10g database on Sun Server T5140 with
> Solaris 10
>
> Check the value for the cpu_count initialization parameter. I ran into a
> similar problem because some memory parameters are based on a mimum per CPU.
> On the Sun Cool Threads servers, Oracle counts each thread as a CPU.
>
> In our case, the cpu_count was 64 for a little T2000 server.
>
> Keith
>
> ----- Original Message -----
> From: "Mandal, Ashoke" <ashoke.k.mandal@xxxxxxxxxxxxx>
> To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
> Sent: Thursday, October 16, 2008 9:16 AM
> Subject: Memory issue with Oracle 10g database on Sun Server T5140 with
> Solaris 10
>
>
> > Greetings All,
> >
> > I am trying to create an Oracle 10.2.0.4 database with SGA_TARGET=256M
> > on Sun T-5140 server with Solaris 10 but getting the following error
> > ORA-00821: Specified value of sga_target 256M is too small, needs to
> > be at least 536M
> >
> > When I increased the SGA_TARGET to 536M and tried creating the
> > database then I received the following error:
> > ORA-12853: insufficient memory for PX buffers: current 0K, max needed
> > 11088K
> > ORA-04031: unable to allocate 65560 bytes of shared memory ("large
> > pool","unknown object","large pool","PX msg pool")
> >
> > When I set the large_pool_size to 11088K and tried creating the
> > database then I received the following error:
> > ORA-00821: Specified value of sga_target 536M is too small, needs to
> > be at least 548M
> >
> > When I increased the SGA_TARGET to 548M and set large_pool_size to
> > 11088K then it moves little further but failed again with the following
> errors:
> > error 4031 detected in background process
> > ORA-04031: unable to allocate 2840 bytes of shared memory ("shared
> > pool","unknown object","sga heap(1,1)","KQR XPO"
> >
> > If I specify the SGA_TARGET as 900M then I was able to create the
> > database without any problem. But I am looking for a solution so that
> > I can create
> > 10.2.0.4 database on this hardware with SGA_TARGET as 256M. T5140
> > server has total of 16 CPUs and with 8 threads it has 128 virtual
> > CPUs. We have also experimented that if we set the cpu_count to 4 in
> > the init.ora then we were able to create the database with SGA_TARGET as
> 256M.
> >
> > I am wondering if any of you have experienced such problem and have
> > recommendation to this issue as I can't afford to allocate 1GB of SGA
> > to each of  70 databases on the same server having only 64GB of RAM.
> >
> > Thanks,
> > Ashoke Mandal
> >
> >
> > [CONFIDENTIALITY AND PRIVACY NOTICE]
> >
> > Information transmitted by this email is proprietary to Medtronic and
> > is intended for use only by the individual or entity to which it is
> > addressed, and may contain information that is private, privileged,
> > confidential or exempt from disclosure under applicable law. If you
> > are not the intended recipient or it appears that this mail has been
> > forwarded to you without proper authority, you are notified that any
> > use or dissemination of this information in any manner is strictly
> > prohibited. In such cases, please delete this mail from your records.
> >
> > To view this notice in other languages you can either select the
> > following link or manually copy and paste the link into the address
> > bar of a web
> > browser: http://emaildisclaimer.medtronic.com
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: