| Impact on a table [message #262147] |
Fri, 24 August 2007 13:02  |
mahendraabc
Messages: 12
Registered: October 2000
|
Junior Member |
|
|
I've a concurrent program which will insert into a table x(No primary key).
If I'm submitting multiple instances of the same concurrent program(Batch process) what's the impact on that table?
any dead locks or rowlevel locking only on particular row inserted.
Thanks,
|
|
|
|
| Re: Impact on a table [message #262157 is a reply to message #262147] |
Fri, 24 August 2007 13:42  |
uday001
Messages: 2
Registered: August 2007
Location: NJ
|
Junior Member |
|
|
|
Yes.. you need to handle the transaction to commit... if you dont commit table is locked and other process will be in wait status.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
