Re: strange select issue

From: Tom <tomNOSPAM_at_teameazyriders.com>
Date: Fri, 19 Sep 2003 11:20:33 +0100
Message-Id: <1063966865.59360.0@dyke.uk.clara.net>

> WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
> WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
> WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
> WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
> WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
> WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1
> WAIT #1: nam='enqueue' ela= 0 p1=1397948422 p2=2 p3=1

looking for info on this i see that these could be related to locks however the docs say...

enqueue - The process is waiting on an enqueue (a lock you can see in v$lock). This commonly occurs when one user is trying to update a row in a table that is currently being updated by another user

however this is occuring when i'm trying to import the data into an empty user also? am i missing something as i don't really see where the issue is.

thanks for the inout so far.

Tom Received on Fri Sep 19 2003 - 05:20:33 CDT