Re: Error: resource busy and acquire with NOWAIT specified

From: Adrian J. Shepherd <theshepherds_at_hotmail.com>
Date: 2000/04/18
Message-ID: <ue5L4.94$16.2075@wards>#1/1

If there is such a solution, it had better be quick before PMON cleans the dead process out.

Adrian...
...yadba

"Roger" <NOrgSPAM_at_mcs-hh.de> wrote in message news:8dc0f0$e87$1_at_garnet.hamburg.cityline.net...
> Hi,
>
> after a session crashed I now receive " resource busy and acquire with
> NOWAIT specified" when I try to access some tables. I know that I can kill
> specific sessions. Is there another solution since killing a session will
> rollback all other changes the session made after the last commit.
>
> Regards
> Roger
>
>
>
Received on Tue Apr 18 2000 - 00:00:00 CDT