Or you may have "set pause on" on sqlplus and it did not give you the
prompt again, until you hit <CR>.

"Patrick Moran " <oracledba-ezmlmshield-x67554275.[Email address protected]
wrote on 06/28/2007 03:34:21 PM:

> 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
>
>
>
>
>
> ---------------------------------------------------------------------
> 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
>
>


---

This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.

Oracle LazyDBA home page