| re: Deadlock Occur [message #61471] |
Tue, 27 April 2004 07:56  |
Raymond
Messages: 30
Registered: September 2000
|
Member |
|
|
Hi recently i have hit a error message something like this " deadlock occur it is due to application not Oracle. "..
Here is from of the v$ view i get from my client sites
SID BLOWAI
---------- --- ---
12 YES NO
13 YES NO
8 NO YES
13 NO YES
9 NO YES
10 NO YES
Current Active User(s)
8 PROC Active YES Update 18:24:36
9 PROC Active YES Update 18:23:51
10 PROC Active YES Update 18:23:47
11 PROC Active NO Unknown 18:25:03
12 PROC Active NO Unknown 18:22:58
13 PROC Active YES Update 18:23:21
17 PROC AZAHARY Active NO Unknown SDPRO 18:17:11
Current Active SQL or PL/SQL Code
PROC(11,13275) ospid = program =
Tuesday 18:25 Tuesday 18:25 last et = 14
SELECT L.BRNCD,L.MODCD,L.ACNO,L.CHKDGT,S.SIDAY FROM LNMAST L,LNSI01
S,LN99SICD C WHERE S.BRNCD = :b1 AND S.BRNCD = L.BRNCD AND S.MODCD = L.MOD
AND S.ACNO = L.ACNO AND S.CHKDGT = L.CHKDGT AND L.CRLINE = :b2 AND L.ACSTS
'A' AND S.SIFA
PROC(8,13063) ospid = program =
Tuesday 18:24 Tuesday 18:25 last et = 42
UPDATE LNSI01 SET SIEXTDT=:b1 WHERE BRNCD = :b2 AND MODCD = :b3 AND ACNO
:b4 AND CHKDGT = :b5
SKSPROC(9,13001) ospid = program =
Tuesday 18:23 Tuesday 18:25 last et = 86
UPDATE LNSI01 SET SIEXTDT=:b1 WHERE BRNCD = :b2 AND MODCD = :b3 AND ACNO
:b4 AND CHKDGT = :b5
PROC(10,13251) ospid = program =
- Tuesday 18:23 Tuesday 18:25 last et = 90
- UPDATE LNSI01 SET SIEXTDT=:b1 WHERE BRNCD = :b2 AND MODCD = :b3 AND ACNO
- :b4 AND CHKDGT = :b5
- PROC(13,13097) ospid = program =
- Tuesday 18:23 Tuesday 18:25 last et = 116
- UPDATE LNSI01 SET SIEXTDT=:b1 WHERE BRNCD = :b2 AND MODCD = :b3 AND ACNO
- :b4 AND CHKDGT = :b5
- PROC(12,13255) ospid = program =
- Tuesday 18:22 Tuesday 18:25 last et = 140
- SKSPROC(17,437) ospid = B67SDPRO program = SDPRO
- Tuesday 18:17 Tuesday 18:25 last et = 488
- begin BJOB_PERIODIC . BJOB_MAIN ( 'SOD' ,:b1 , 'ICBAOPR' ) ; END ;
it is running in MVS environment , we did't change an y of the program from Feb- apr 04, but this program happen in feb04-apr04
the program is calling a procedure which done something like this
procedure si_extdt
UPDATE lnsi01
SET
SIEXTDT = add_on_functions.change_day_component(
pi_process_date, siday)
WHERE
brncd = pi_branch_code AND
sifaccd <>'11' AND
(brncd, modcd, acno, chkdgt) IN
(SELECT brncd, modcd, acno, chkdgt
FROM lnmast WHERE crline = pi_crline AND
brncd = pi_branch_code and acsts = 'A');
What might be the course of this error ? It look like this procedure just doing a direct update to lnsi01 table using information from lnmast table ???
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
