RE: Problem with large SGA
- From: JayMiller@xxxxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 11 Oct 2005 17:41:51 -0400
I don't know that a large SGA in general will hurt performance but a large
shared_pool in specific can cause problems.
Jay Miller
-----Original Message-----
From: zhu chao [mailto:zhuchao@xxxxxxxxx]
Sent: Saturday, October 08, 2005 1:24 AM
To: oracledba.williams@xxxxxxxxx
Cc: Thomas.Mercadante@xxxxxxxxxxxxxxxxx; daniel.hubler@xxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: Re: Problem with large SGA
Large SGA does not hurt performance, for improvement, it depends on the
active data set.
We have case increase sga size helps a lot, also cases double sga size does
not help at all. With large SGA and large tablespace, begin backup is much
longer than before. Even if you do a full checkpoint before you begin
backup.
On 10/8/05, Dennis Williams <oracledba.williams@xxxxxxxxx
<mailto:oracledba.williams@xxxxxxxxx> > wrote:
Daniel,
> We recently increased the size of our SGA from 40gig to over 100gig by
> increasing our shared pool and block buffer cache.
> Everything has gone very well.
Have you had an opportunity to test your performance with large SGA?
I've heard tales of people who have increased the SGA to the point
that performance actually degrades. Like maybe buffer cache searches
take a long time. Never had access to enough RAM to test this myself.
Recently this list had a thread discussing solid-state disk. It seems
to me that you pretty much have that in this situation.
Dennis Williams
--
//www.freelists.org/webpage/oracle-l
<//www.freelists.org/webpage/oracle-l>
--
Regards
Zhu Chao
www.cnoug.org <http://www.cnoug.org>
-----------------------------------------
This message is confidential and sent by TD Waterhouse solely for use
by the intended recipient. If you are not the intended recipient, you
are hereby notified that any use, distribution or copying of this
communication is strictly prohibited. This should not be deemed as an
offer or solicitation, to buy or sell any product. Any 3rd party
information contained herein was prepared by sources deemed reliable,
but is not guaranteed. TD Waterhouse does not accept electronic
instructions that would require an original signature. Information
received by or sent from TD Waterhouse is stored, subject to review,
and may be produced to regulatory authorities or others with a legal
right to such.
Other related posts:
