Re: kill rock(transaction)?

heoseong-

Normally, a row level lock is released after either a "commit" or a "rollback" of the holding session. Sometimes a session ends suddenly without doing either a commit or rollback, in which case PMON is supposed to clean the lock up. Sometimes PMON cannot figure out that a session is dead, so the shadow process continues to run and hold the lock, yet the client process is dead and will never release the lock voluntarily.

In order to get rid of a "hung" row lock, you will have to kill the transaction to which it belongs, which means killing the session and process. If you are using dedicated non-MTS servers, you will probably want to find the operating system process id and kill it at the operating system level. In UNIX, this usually means "kill -9 <process id>" from a command line.

• ricky

ps: I still think you have a catchy tune going there. :-)

heoseong wrote:
>
> yes, locked row
>
> "Buck Turgidson" <jc_va_at_hotmail.com> wrote in message
> news:A47M7.65007$fm5.8589059_at_typhoon.southeast.rr.com...
> > Do you mean "lock" as in a locked row?
> >
> >
> > "heoseong" <hersung_at_hotmail.com> wrote in message
> > news:9to258$t3r$1_at_news1.kornet.net...
> > > I'm DBA.
> > > But, I don't know
> > > How can i kill rock?
> > >
> > > And,
> > > my friend make rock
> > > But, she don't know.
> > > How can she stop?
> > >
> > >
> > >
> >
> >
Received on Mon Nov 26 2001 - 08:22:34 CST