Hello om bapux, Terima kasih atas tanggapannya. Informasi yang om sampaikan sudah saya lakukan sejak dulu. Sekarang saya sedang buat program pl/sql untuk dapatkan user mana yang sedang lock di row yang mau saya update/edit.
-- Best regards, Wadi Achmed --------------Original Message-------------- Friday, May 11, 2007, 1:02:06 AM, you wrote: Halo Pak Wadi Saya mau mencoba jawab pertanyaan bapak, biasanya di tempat saya pake program Knowledge Xpert yang Oracle Administration, terus connect as system, nah bapak coba cari topik listnya Active Analysis-Show locks Held by User, terus jalankan Run Analysis System, nanti kelihatan user id yang lock. Biasanya software ini nempel di toad dari quest software. Semoga membantu Hendra Wadi Achmed <[EMAIL PROTECTED]> wrote: Hello All, Mau tanya dong, gimana caranya mengetahu row mana dari suatu table yang sedang dilock sama salah satu user/session? Misalnya salah satu user ngelock dengan command: select * from table1 where rowid = ..... for update nowait; Thanks sebelumnya. -- Best regards, Wadi mailto:[EMAIL PROTECTED] --------------------------------- It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar. [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
