Oracle Database Discussions

i'm getting deal lock in my process , this is comming when i'm trying to calculate ID/primary key valuce
from ID table , we maintain a table for PK each time we need we read the value and increament the value by one for the next procuess . but here u seen for deadlock blocker and witer is same
and dead lock i comming at same line every time
line is select ... from id table for update of id ;
please help me why it is comming
Trace file:ORACLE.GPRD.OSDI.TRACE.T1930834.G0010010

information may aid in determining the deadlock:
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-00020017-000282b2 18 19 X 18 19 X
session 19: DID 0001-0012-00000035.session 19: DID 0001-0012-00000035
Rows waited on:
Session 19: obj - rowid = 00001209 - AAAEiHAA0AAACCyAAd
(dictionary objn - 4617, file - 52, block - 8370, slot - 29)
Information on the OTHER waiting sessions:
End of information on OTHER waiting sessions.
Current SQL statement for this session:
SELECT NEXT_ID, UPDATE_DT_TIME, UPDATE_USER_ID FROM ID_V WHERE UPPER(TABLE_NAME)

SELECT NEXT_ID, UPDATE_DT_TIME, UPDATE_USER_ID FROM ID_V WHERE UPPER(TABLE_NAME)
---------------------------------------------------------------------------------
Trace file:ORACLE.GPRD.OSDI.TRACE.T1930834.G0010012

information may aid in determining the deadlock:
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-00140021-0002d6d0 20 22 X 20 22 X
session 22: DID 0001-0014-00002734.session 22: DID 0001-0014-00002734
Rows waited on:
Session 22: obj - rowid = 00001209 - AAAEiHAA0AAACCyAAd
(dictionary objn - 4617, file - 52, block - 8370, slot - 29)
Information on the OTHER waiting sessions:
End of information on OTHER waiting sessions.
Current SQL statement for this session:
SELECT NEXT_ID, UPDATE_DT_TIME, UPDATE_USER_ID FROM ID_V WHERE UPPER(TABLE_NAME)

--------------------------------------------------------------------------------
Trace File:ORACLE.GPRD.OSDI.TRACE.T1930904.G028000A

deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-00120026-00028b60 12 14 X 12 14 X
session 14: DID 0001-000C-00002913.session 14: DID 0001-000C-00002913
Rows waited on:
Session 14: obj - rowid = 00001209 - AAAEiHAA0AAACCyAAd
(dictionary objn - 4617, file - 52, block - 8370, slot - 29)
Information on the OTHER waiting sessions:
End of information on OTHER waiting sessions.
Current SQL statement for this session:
SELECT NEXT_ID, UPDATE_DT_TIME, UPDATE_USER_ID FROM ID_V WHERE UPPER(TABLE_NAME)
---------------------------------------------------------------------------------
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-00120026-00028b60 12 14 X 12 14 X
session 14: DID 0001-000C-00002913.session 14: DID 0001-000C-00002913
Rows waited on:
Session 14: obj - rowid = 00001209 - AAAEiHAA0AAACCyAAd
(dictionary objn - 4617, file - 52, block - 8370, slot - 29)
Information on the OTHER waiting sessions:
End of information on OTHER waiting sessions.
Current SQL statement for this session:
SELECT NEXT_ID, UPDATE_DT_TIME, UPDATE_USER_ID FROM ID_V WHERE UPPER(TABLE_NAME)
--------------------------------------------------------------------------------
Trace file:ORACLE.GPRD.OSDI.TRACE.T1930834.G005000C

Resource Name process session holds waits process session holds waits
TX-0007002c-000282f7 14 13 X 14 13 X
session 13: DID 0001-000E-00000023.session 13: DID 0001-000E-00000023
Rows waited on:
Session 13: obj - rowid = 00001209 - AAAEiHAA0AAACCyAAd
(dictionary objn - 4617, file - 52, block - 8370, slot - 29)
Information on the OTHER waiting sessions:
End of information on OTHER waiting sessions.
Current SQL statement for this session:
SELECT NEXT_ID, UPDATE_DT_TIME, UPDATE_USER_ID FROM ID_V WHERE UPPER(TABLE_NAME)
--------------------------------------------------------------------------------
Trace File:ORACLE.GPRD.OSDI.TRACE.T1931520.G002000D

deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-0005000a-0002d905 15 16 X 15 16 X
session 16: DID 0001-000F-00004F28.session 16: DID 0001-000F-00004F28
Rows waited on:
Session 16: obj - rowid = 00001209 - AAAEiHAA0AAACCyAAd
(dictionary objn - 4617, file - 52, block - 8370, slot - 29)
Information on the OTHER waiting sessions:
End of information on OTHER waiting sessions.
Current SQL statement for this session:
SELECT NEXT_ID, UPDATE_DT_TIME, UPDATE_USER_ID FROM ID_V WHERE UPPER(TABLE_NAME)
--------------------------------------------------------------------------------
trace File:ORACLE.GPRD.OSDI.TRACE.T1930834.G001000E

deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-00170013-000284f7 16 17 X 16 17 X
session 17: DID 0001-0010-00000039.session 17: DID 0001-0010-00000039
Rows waited on:
Session 17: obj - rowid = 00001209 - AAAEiHAA0AAACCyAAd
(dictionary objn - 4617, file - 52, block - 8370, slot - 29)
Information on the OTHER waiting sessions:
End of information on OTHER waiting sessions.
Current SQL statement for this session:
SELECT NEXT_ID, UPDATE_DT_TIME, UPDATE_USER_ID FROM ID_V WHERE UPPER(TABLE_NAME)
--------------------------------------------------------------------------------
Trace File:ORACLE.GPRD.OSDI.TRACE.T1930834.G0010011

deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-00140026-0002d681 19 20 X 19 20 X
session 20: DID 0001-0013-00000013.session 20: DID 0001-0013-00000013
Rows waited on:
Session 20: obj - rowid = 00001209 - AAAEiHAA0AAACCyAAd
(dictionary objn - 4617, file - 52, block - 8370, slot - 29)
Information on the OTHER waiting sessions:
End of information on OTHER waiting sessions.
Current SQL statement for this session:
SELECT NEXT_ID, UPDATE_DT_TIME, UPDATE_USER_ID FROM ID_V WHERE UPPER(TABLE_NAME)
--------------------------------------------------------------------------------