Re: OCI DirPath

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 22 Sep 2003 00:16:54 -0700
Message-ID: <1a75df45.0309212316.29083ac9@posting.google.com>

res0nlrn <res0nlrn_at_verizon.net> wrote

> I have 2 questions for OCI DirPath:
>
> 1. I am getting following error message if I try to run multiple
> instance of cdemdplp (demo from oracle) to load data in same table:
> OCI Error -1 occurred at File cdemodp.c:868
> Error - ORA-00604: error occurred at recursive SQL level 1
> ORA-00054: resource busy and acquire with NOWAIT specified
>
> How can I resolve it.

The error is exactly what it says - resource is busy (locked) and you attempted to aquire it (lock it) without waiting for any existing locks on that resource to be freed.

What is likely happening: the direct load you're doing is locking resources. You start another copy of the same load and it too attempts to lock the same resources. It cannot as the 1st process is still busy. Thus it fails as it is using the NOWAIT option on its locking attempt.

Look up parallel loading if that is what you want to do.

--
Billy

Received on Mon Sep 22 2003 - 02:16:54 CDT