Execute query ini :
select s1.username || '@' || s1.machine || ' ( SID=' || s1.sid || ' ) is blocking ' || s2.username || '@' || s2.machine || ' ( SID=' || s2.sid || ' ) ' AS blocking_status from v$lock l1, v$session s1, v$lock l2, v$session s2 where s1.sid=l1.sid and s2.sid=l2.sid and l1.BLOCK=1 and l2.request > 0 and l1.id1 = l2.id1 and l2.id2 = l2.id2 ; setelah keliatan SID yang lock-nya . tinggal kill ajah sessionnya pake alter system kill session SID . regards, indrajati chairuddin dba ms-team [EMAIL PROTECTED] http://indrajati.blogspot.com 0811223561 _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Leonard Sukendro Sent: Wednesday, January 09, 2008 11:45 PM To: [email protected] Subject: Re: [indo-oracle] status lock table to pak nhs setau saya, klo ada user yg melakukan update/delete pd suatu row, row itu kena row lock, boss.. row lock baru dlepas saat user itu commit/rollback, jadi selama bln, gk ada org yg bisa liat perubahan di row itu. utk spesifik row mana yg di lock, ilmu saya bln ampe, boss hehe... tp klo mo liat table, status, dan user yg ngelock, bisa diliat di "select * from v$lock where block=1". utk lbh jelasnya, bisa di join sama v$locked_objects, dba_objects, n v$session, boss.. moga2 membantu, boss.. regards, [L] --- Nhs <[EMAIL PROTECTED] <mailto:nhomsan%40yahoo.com> com> wrote: > hi bro semua ... > mau nanya dikit nich .. > ada yang bisa jelasin gak apa yang terjadi pada saat > 1 table di lakukan proses > update / delete . apakah status update/delete pada > table ini bisa ketahuan ...???? > soalnya saya pengen tahu jika table 'A' sebelum > saya lakukan proses update/delete rows > status untuk ROws / Record yang mau di update/delete > tsb sedang di lock atau tidak . > > mohon pencerahannya yach ... > > thankyu.. > > > > > > > > > > ________________________________________________________ > > Kunjungi halaman depan Yahoo! Indonesia yang baru! > http://id.yahoo. <http://id.yahoo.com/> com/ > > [Non-text portions of this message have been > removed] > > __________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo. <http://www.yahoo.com/r/hs> com/r/hs [Non-text portions of this message have been removed]
