Big SGA.......

[Loughmiller, Greg]

hey folks.. Hoping for a little feedback and opinion please. Having a discussion with the development group ...   The development group is thinking that a VERY LARGE SGA would solve some of their I/O problems. For example, they believe that a SGA consisting of over 8GB of db block buffers would resolve their multitude of issues. I feel that they open another can of worms with something such as this.. And granted-there hasn't really been an infrastructure evaluation-and the SA group is currently performing that review of the environment.   One could suggest that they could "cache" some very large tables in the SGA; but there seems to be some sense of a down side to this.. Could you all provide some input on "Extremely large SGA's"?  In the area of 8GB or so..  BUT, most of this would be the database blocks. Would you all be so kinds to provide your thoughts please? TIA     Greg Loughmiller Sr Manager - Enterprise Data Architecture gloughmiller (IPS) 678.893.3217 (office)