I am facing a problem in my application, when a table having no index and locking scheme as pagelevel , which contains only one row being accessed by one program (select stmnt) causing problems (locking and not allowing the other to update) to another process trying to update the table.As far as i know, read operations will be of isolation level 1 and write operations will not be affected due to read operations then its due to index problem or some other problem.As i am not familiar with DBA could u provide me some explanation on the sameJeya

Interview Candidate
Jul 11th, 2006
3
1581

Showing Answers 1 - 3 of 3 Answers

jaya

May 29th, 2007

Hi,

It seems your application is using a cursor with for update clause , where the other transaction (DML) will wait until the current one gets end.

check the code , if this is not the case then there may be mutating table issue.

Mutating table is one While doing DML , the trigger on the table will throw error as the table is mutating.