Halo Mas Adi, Thanks ya, sharing experience nya.... *:)* * * Ada yang menarik dari reply Mas Adi : "*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*" ==> Statement di atas, bisa di elaborate lagi ?
Thanks and best regards Piping On Fri, Aug 14, 2009 at 4:56 PM, adi rahadian < [email protected]> wrote: > > > 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]<mochfirman%40gmail.com>> > menulis: > > Dari: Moch Firman N <[email protected] <mochfirman%40gmail.com>> > Judul: [indo-oracle] DEADLOCK..... ? > Kepada: [email protected] <indo-oracle%40yahoogroups.com> > 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] > > > [Non-text portions of this message have been removed]
