batch processnya ngapain koq sampe lockingnya satu table penuh bukan satu row saja? kalau yang di lock satu row, kan bisa gantian sama OLTPnya?
Locking adalah salah satu cara Oracle untuk menjaga data consistency. Kalau kita mau kutak katik, nanti datanya ngga konsisten lebih berabe. Mungkin ada yang nambahin :) cheers 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. Yes, if you put the lock mechanism in the row level not in the table level. 2) It's possible that user performs a transaction while a batch process is running. (Those processes use the same table). What kind of transaction? Possible? yes. Again depend on what is your batch process doing. If your batch process consume a lot of resources, then better to pending the OLTP like what happen with the Banking during Month End. Anyway, Is there any action to avoid deadlock in Oracle Side ? Any configuration belong to oracle that should be changed ? Normally, deadlock is caused by bad transaction management not because of DB Parameter. ----- Original Message ----- From: Moch Firman N To: [email protected] Sent: Friday, August 14, 2009 4:37 AM Subject: [indo-oracle] DEADLOCK..... ? 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] ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.392 / Virus Database: 270.13.54/2300 - Release Date: 08/13/09 06:11:00 [Non-text portions of this message have been removed]
