Re: hung Oracle PL/SQL process during "insert"

Alex Glaros <alexg_at_xsurfermall.com> wrote in news:41663556.4DB567BD_at_xsurfermall.com:

> Does anyone have any idea on what could be causing an insert statement
> to hang?
>
> There doesn't seem to be any tables dead-locking, and when I run a
> diagnostic tool to show me where in the SQL code it's hanging, it shows
> the following:
>
> INSERT INTO WLL_COPY_LICENSEE_LINKS_ERRORS
> (
> cle_css_copy_id,
> agency,
> license_type,
> license_number,
> cle_license_number,
>
>
> There are no records in the table above. Could it be waiting for a
> commit from another table? Any general ideas would be appreciated.
>
> Thanks,
>
> Alex Glaros
>
>

select SID,TYPE,ID1,ID2,LMODE,REQUEST from v$lock where type='TX';

You are probably suffering from enqueue waits & need to increase INITRANS Received on Fri Oct 08 2004 - 09:01:46 CDT