HV enqueue

From: Sai Selvaganesan <ssaisundar_at_sbcglobal.net>
Date: Fri, 9 Feb 2007 22:21:15 -0800 (PST)
Message-ID: <480343.21244.qm@web81614.mail.mud.yahoo.com>

i am on a 10gr2 (102.0.2) rac environment and i see enq :HV contention a lot when direct inserts happen (either ctas or insert /*+ append ). The data i am loading is into a LMT of 4m and the amount of data is about 20GB.

has anyone seen this contention? if so what does this mean and where am i really hitting a bottleneck.

  please let me know
  thx
  sai

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

Received on Sat Feb 10 2007 - 00:21:15 CST