Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Row values changing back to old values randomly???
DA Morgan wrote:
>> Yes, that's probably what I will do. I will install good old >> PostgreSQL and forget about Oracle. >> >> Thanks for your attention, >> >> David
Ok, can I first suggest that we cut the buying/selling/professionalism stuff and stay on the technical side because you got the situation totally wrong.
<situation>
First it's the customer's DBA who just went earlier home on Friday, but
his financial department wants to run our product on Monday. So, because
the customer's DBA wont support us on *his* DB, our options are limited
to either do his work or to install another DB for ourselves. So that's
the situation. And we are not in the U.S. so let's forget about the Feds
& Co. - I don't even know what Serbian-Ox is, and neither do I care -
the DB just has to run as expected, and the mentioned option has proven
itself as reliable numerous times.
</situation>
So back to the technical side. I though about transaction isolation levels. Is it possible that the database is configured to "READ UNCOMMITED" isolation level by default? This would mean that the TOAD is really showing data which hasn't been committed yet. Later the session disconnects and the data is converted back.
Thanks, David Received on Fri May 27 2005 - 16:44:09 CDT