Re: HV enqueue
- From: "Nilo Segura" <nilosegura@xxxxxxxxx>
- To: ssaisundar@xxxxxxxxxxxxx
- Date: Sat, 10 Feb 2007 20:31:08 +0100
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@xxxxxxxxxxxxx> 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
Other related posts:
