Talk:Oracle Compatibility in DB2/Architecture/Oracle

Previous sentence was:
 * 1
 * The collection of all PGA memory areas is called the Instance PGA, although each piece is in non-shared memory and exclusive to the process it is attached to, the collective instance PGA is equivalent to the SGA in that it can be thought of as memory allocated for the instance

After some reading:

http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:30011178429375

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:17748700346068277

http://www.dba-oracle.com/tips_pga_aggregate_target.htm

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4473773580447

I believe (as of 9.2i) that the PGA_AGGREGATE_TARGET, which seems to be somewhat synonymous with our definition of Instance PGA, would not necessarily be == SGA size --Jt openscg (talk) 23:35, 22 September 2010 (UTC)

OK just tidied up your entry a bit (If you indent the first line, you get a text box type entry :-)

I read what you posted here, but I'm not sure what your intent is? Are you recommending an edit, or just giving me a FYI?? --Scifipete (talk) 00:47, 23 September 2010 (UTC)

OK, Just chatted with JT online. This is EXACTLY why I want U guys looking at this stuff. I was under the impression that the total instance PGA = SGA, and JT pointed out that it's not the case. Thx --Scifipete (talk) 00:54, 23 September 2010 (UTC)