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.

What is the maximum SGA and SP sizes of DBs that you have seen.

Thanks.

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 15 2010 - 20:55:38 CDT

Original text of this message