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]
