SGA & shared pool size
From: Ram Raman <veeeraman_at_gmail.com>
Date: Thu, 15 Apr 2010 20:55:38 -0500
Message-ID: <w2oeffc058d1004151855r1fe6e50dw5460ab4ed7e1f7_at_mail.gmail.com>
I saw a big database today with an SGA size of 56GB and a shared pool of 12Gb. The SGA_TARGET was set to 0. This database size is a few terabytes. I have not heard of such big SGA or SP sizes. I thought having big memory sizes may cause latch contention and CPU issues.
Date: Thu, 15 Apr 2010 20:55:38 -0500
Message-ID: <w2oeffc058d1004151855r1fe6e50dw5460ab4ed7e1f7_at_mail.gmail.com>
I saw a big database today with an SGA size of 56GB and a shared pool of 12Gb. The SGA_TARGET was set to 0. This database size is a few terabytes. I have not heard of such big SGA or SP sizes. I thought having big memory sizes may cause latch contention and CPU issues.
What is the maximum SGA and SP sizes of DBs that you have seen.
Thanks.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 15 2010 - 20:55:38 CDT