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

You might want to consider re-evaluating your hardware. Have you looked at your probable licensing costs with that sort of configuration? I dont think its going to cost effective.

On Thu, Oct 16, 2008 at 3:12 PM, Crisler, Jon <Jon.Crisler_at_usi.com> wrote:

> This is unrelated, but I wanted to warn you of a possible issue on this
> machine if you are using any sort of compression programs, such as
> compress, gzip, RMAN using compressed backup sets. Programs that make
> extensive use of floating point operations tend to run slower on these
> boxes, sometimes dramatically slower. The design of the processors put
> emphasis on other areas of performance, with the result that floating
> point performance was deemphasized.
>
> In one particular test, I have a 170gb database in 10g. Backing that db
> up via RMAN compressed backup sets to disk, using 8 streams, takes 12+
> hours. Running the same backup without compressed backupsets takes 30
> minutes (and takes twice the disk space). I am getting some positive
> news from coworkers when using pbzip2 on this class of Sun servers.
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mandal, Ashoke
> Sent: Thursday, October 16, 2008 10:16 AM
> To: oracle-l
> 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
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l