Did you look at V$SESSION and/or V$SESSION_WAIT for that session?

Todd Pepling
[Email address protected]
724-766-3492

________________________________

From: Askani Chandu (CON) [mailto:oracledba-ezmlmshield-x50420876.[Email address protected]
Sent: Thu 6/28/2007 13:24
To: LazyDBA Discussion
Subject: Strange problem - sqlplus



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.









---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com <http://jobs.lazydba.com/>
To Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
To unsubscribe: http://www.lazydba.com/unsubscribe.html





Oracle LazyDBA home page