sqlloader direct path causes library cache lock?

From: Ls Cheng <exriscer_at_gmail.com>
Date: Tue, 25 Jun 2013 09:59:16 +0200
Message-ID: <CAJ2-Qb8ou5hNrXxuLSSSz1x4c_X1aAztK19rT9grG8LCZoC_nw_at_mail.gmail.com>

Hi
We have a process which load data by invoking SQL Loader and uses direct path loads. The process loads many files to a couple of partitioned tables which are being loaded by conventional insert as well (basically batch load and user load runs concurrently).

I have observed that many user session suffers library cache lock when inserting or querying the tables being touched by the SQL Loader, these tables have no constraints at all (not even not null), no triggers but do have indexes. Since it has no constraints I dont see why other session needs to wait for library cache lock when SQL Loader kicks in?

I dont observe any enqueue (such as TM). This is 10.2.0.4 Single Instance.

Thanks

--

LSC
--

http://www.freelists.org/webpage/oracle-l Received on Tue Jun 25 2013 - 09:59:16 CEST