Re: pga_aggregate_target and CBO plan

From: Alberto Dell'Era <alberto.dellera_at_gmail.com>
Date: Wed, 8 Aug 2007 20:15:44 +0200
Message-ID: <4ef2fbf50708081115u7bc1fc1oae33853be74b6547@mail.gmail.com>

And if you want to go very deep, there's another paper that explains the algorithms in a very, very detailed way:

"SQL Memory Management in Oracle9i" by Dageville et others: http://www.cs.ust.hk/vldb2002/VLDB2002-proceedings/papers/S29P03.pdf

On 8/8/07, amar kumar padhi <amar.padhi_at_gmail.com> wrote:
> Hi,
> Jonathan has a good article at
> http://www.jlcomp.demon.co.uk/untested.html that may give some good
> insight into how memory plays with different PGA settings. I believe
> this would show up on the execution plan cost.

-- 
Alberto Dell'Era
"the more you know, the faster you go"
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 08 2007 - 13:15:44 CDT