"Melanie Bieber" <Melanie.Bieber_at_bieber.no-ip.com> wrote in message
news:pan.2003.09.28.05.43.46.356127_at_bieber.no-ip.com...
> Hello guys,
>
> I am looking for a official statement of oracle,
> because one of our software developer told me to commit every
> select-statement.
>
> I think, we don`t have to do that, because you do only a read-only
transaction,
> so where is the reason for this???
>
> Thx4all hints...
>
> Melanie
Did the developer say why? I don't do that. Is this developer used to
working with SQLServer or Sybase or DB2? Perhaps that is why. In Oracle
readers don't block writers and writers don't block readers. So we don't do
commits to "release" locks on reads.
Jim
Received on Sun Sep 28 2003 - 01:37:55 CDT
