Im trying to do an insert and its hanging, which means there is a lock. So we are killing all the sessions. Now noone has issued an explicit lock table when when you do an 'insert' you are adding a row so how could the table be locked?

Is there a way to time out an insert statement that is blocked due to a lock? I know with Select you have to explicitly issue a 'NOWAIT' in order to have your query wait without timing out. Or am I wrong on that one?

Oracle LazyDBA home page