I'm guessing library cache waits. Usually a very bad idea to keep
committing inside a pl/sql block. If you aboslutely must track the
progress through commits, set a counter in your loop and insert the
counter into a junk table with an autonomous transaction.

All the committing is huge overhead, plus what happens if your update
fails with all your commits inside the loop. Are you going to know what
data is valid or not? Very bad to commit inside a transaction.

Cheers

>>> "Todd Pepling "
<oracledba-ezmlmshield-x85589426.[Email address protected] 6/28/2007 2:46
PM >>>

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






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




Oracle LazyDBA home page