Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Is it bad if there is records in v$lock?

Re: Is it bad if there is records in v$lock?

From: MarkP28665 <markp28665_at_aol.com>
Date: 1997/11/25
Message-ID: <19971125222700.RAA12545@ladder01.news.aol.com>#1/1

From: Casper Thrane <ct_at_benau.dk>
>> I have 8 records in my v$lock which will not disappear.
Is it bad? <<

Probably. You should trace the locks back to the owning process. If it is a 24 hour process then this may be OK if the locked resouce is used only by this process. If the owning process is a run-away process you can kill it: "alter system kill session 'sid,serial#'; " If the owning process is gone, but Oracle does not recognize that it no longer exists then you will probably have to shutdown and restart Oracle. Note that sqlnet is supposed to look for and clean up from failed processes, but some version had occassional trouble in this area. We had this situation happen once or twice back with either 7.1.3 or with 7.0.16, but that was long ago.

Hope this helps.

Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Tue Nov 25 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US