SGA & shared pool size

  • From: Ram Raman <veeeraman@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 15 Apr 2010 20:55:38 -0500

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.

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2010