Re: Faster index creation

From: Mladen Gogala <>
Date: 15 May 2008 18:22:03 GMT
Message-ID: <482c7f4b$0$30635$>

On Thu, 15 May 2008 09:55:56 -0700, Mark D Powell wrote:

> Mladen, has the 5% of pga_aggregate_target for the sort area for a
> session limitation been lifted?

Mark, to my knowledge it is lifted in 10.2. There is a hidden parameter _PGA_MAX_SIZE which regulates how much memory can be consumed by a single process. Of course, there are also some bugs associated with the mechanism. Look at the note 5947623.8. Granted, it's for hash join, not for the sort/merge, but the same thing probably applies to both. They tell me that will be completely bug free.

Received on Thu May 15 2008 - 13:22:03 CDT

Original text of this message