sharing pengalaman aja mas, indexing yang salah, deasain aplikasi dan table jg bisa jadi biang masalah, khusus untuk indexing mungkin ada di table tersebut type index yang di peruntukan untuk table read only(hanya proses insert dan select) seperti bitmap index yang melakukan block level locking. untuk desain aplikasi & table mungkin ada update counter tidak menggunakan sequence , tapi menggunakan select max(column).. ini cuma sebagai contoh aja .. CMIIW rgrd adie
--- Pada Jum, 14/8/09, Moch Firman N <[email protected]> menulis: Dari: Moch Firman N <[email protected]> Judul: [indo-oracle] DEADLOCK..... ? Kepada: [email protected] Tanggal: Jumat, 14 Agustus, 2009, 3:37 PM Dear all, I am going to ask of deadlock process in Oracle. *Assumed:* a. There are 2 process as following : 1) Batch schedule process 2) Online process (screen) b. There is not problem in batch schedule process, all processes work properly. *Question:* In case of online process (screen), I can not avoid if from deadlock in consideration of : 1) It's possible that system performs many transactions which use the same table in the same time. 2) It's possible that user performs a transaction while a batch process is running. (Those processes use the same table). Anyway, Is there any action to avoid deadlock in Oracle Side ? Any configuration belong to oracle that should be changed ? *For ur information: * Here is my reference (http://www.dba- oracle.com/ t_deadlock. htm) .. but still confusing *:(* Hoping someone will give me the explanation *:D* Thanks and best regards -:Piping:- [Non-text portions of this message have been removed] Berselancar lebih cepat. Internet Explorer 8 yang dioptimalkan untuk Yahoo! otomatis membuka 2 halaman favorit Anda setiap kali Anda membuka browser. Dapatkan IE8 di sini! http://downloads.yahoo.com/id/internetexplorer [Non-text portions of this message have been removed]
