Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Commit select-statement ?

Re: Commit select-statement ?

From: Eric Parker <eric.parkerthedross_at_virgin.net>
Date: Sun, 28 Sep 2003 08:58:30 +0100
Message-ID: <Jwwdb.1561$QH3.895@newsfep4-winn.server.ntli.net>

"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

Melanie

I suppose that would be a good idea if your database isolation mode was 'serializable'.
I believe very few Oracle databases run in that mode.

eric

--
Remove the dross to contact me directly
Received on Sun Sep 28 2003 - 02:58:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US