Re: HV enqueue

Yo could also try to pre-create the extents and load into different table partitions to minimize the impact of the HWM "management"... we had to work out a similar trick in order to load a lot of online data coming from many different sources into a RAC system.

regards.

On 2/10/07, Sai Selvaganesan <ssaisundar_at_sbcglobal.net> wrote:
>
> thx for the reply
> the number of slaves it very high(32) for a table creation (table size at
> the end of the creation is 20GB)
> will reducing this amount of parallelsim benefit.
> regarding the question about how big a problem this HV contention is, it
> is the biggest wait event during CTAS.
> would you recommend disabling the HWM through underscore parameter or
> would you see if reducing the parallelsim along with the number of nodes
> this can run help this or increase the extent size.
> now CTAS runs on all nodes(it is a 10 node rac) with this hig a
> parallelism (i personally feel this is a baad way to do but i would love
> your recommendation)
> again
> thx a lot for your help
> sai
>

-- 
Nilo Segura
Oracle Support - IT/DES
CERN - Geneva
Switzerland

--
http://www.freelists.org/webpage/oracle-l