Looking for discussion on using large-ish PGA/SGA for PROD vs DEV/QA
- From: <Christopher.Taylor2@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 29 Aug 2012 09:10:21 -0500
Guys/Gals,
As a few of you know I have taken a new job and one of the applications I'm
responsible for has multiple dev and qa environments and one prod environment.
(10.2.0.4 RAC - 3 nodes in QA/Prod, 2 nodes in Dev)
We have a federal report that has started performing poorly in production and I
have a QA environment with less volume where it returns reasonably well.
One of the challenges I'm having is that the SGA in Prod is 40 GB, and PGA =
5GB. Dev GB/5GB, QA@GB/1 GB (PGA much different). (Challenges include coming
up to speed at breakneck pace on environments, environment usage, statistics
methodology (there isn't one), indexing methodology (there isn't one)...)
I think Jonathan Lewis or someone posted recently about large SGA sizes and PGA
sizes - that having gobs of memory available doesn't *necessarily* mean
automatically setting your databases up to use that large amount of memory (or
perhaps I was dreaming).
I'm wondering if I should be much concerned about the SGA sizes currently and
come back to them later, or if I should be looking at them in relation to query
performance - that perhaps the SGAs are "oversized" or if that is an idiotic
concept to begin with. I'm going to research it further but wanted to throw
that out there.
Chris Taylor
--
//www.freelists.org/webpage/oracle-l
Other related posts:
