I am connecting from unix using sqlplus to oracle. Then I execute a plsql
block to updating million rows( updating blob column) committing every 150
rows.

Strange thing is updates are completed in two hours. I check this from a
different session that executed the plsql block. However the session which
executed the plsql block takes eight hours to comeback to the sqlplus
prompt.



What is happening here? Thank You for your thoughts and advise.








Oracle LazyDBA home page