RE: Oracle/Windows question

  • From: "Sweetser, Joe" <Joe.Sweetser@xxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 12 Aug 2005 13:06:34 -0700

Whew!  This is getting a little nutty.  I now know more about Windows
memory and how it plays with Oracle than I ever really thought I would
need to know in order to be a happy person.

A few more questions:  Would the size of the data set being operated on
have any bearing on the memory usage?  This problem is happening in a
data warehouse that grows each month.  And it has been happening more
frequently each month.  I think the queries themselves stay the same,
but more data may be being returned as time goes on.

I saw on Metalink Note:271072.1 that the init.ora processes has no
impact on this situation because it doesn't take in any resources.
Agreed?

If my best immediate solution is to reduce the size of the SGA and I
have these values set (I inherited this db so can't address why values
where changed):

shared_pool_size = 300000000             #previous value: 40000000
shared_pool_reserved_size = 3000000     #previous value: 2000000
log_buffer = 1048576                    #previous value: 163840

any idea where I might get the most "bang for the buck"?

thanks,
-joe
--
//www.freelists.org/webpage/oracle-l

Other related posts: