Re: Use of direct path load
From: Dave Mausner <dmausner_at_brauntech.com>
Date: 24 Jan 1995 18:08:35 GMT
Message-ID: <3g3fn3$a0b_at_News1.mcs.com>
Date: 24 Jan 1995 18:08:35 GMT
Message-ID: <3g3fn3$a0b_at_News1.mcs.com>
In article <1995Jan23.202402.6469_at_wvus.org>, sford_at_wvus.org says...
>At any rate, we were wondering if anyone uses direct path loading. The
>Server Utilities Guide sells it as much faster than "conventional" load.
>Unfortunately, it doesn't seem to work at all for us. Once sqlload is
>started, the processor becomes pegged, no disk activity happens, no data
>whatsoever in the log file.
direct path loading starts when there are no locks on the table. if any process has cursors open, it is no go until they release.
if the machine is idle when it hangs up, and you can verify that there is enuf free space to add data, then you may be looking at a bug.
-- Dave Mausner, Sr. Consultant, Braun Technology Group, Chicago.Received on Tue Jan 24 1995 - 19:08:35 CET