Re: Serializable transactions get rolled back while there are no other transactions running?!

Hi Mark!

This was more a theoretic question: Is it possible a transaction in isolation mode "serializable" gets rolled back becasue it can not be serialized when there is *no other* transaction running in parallel?

Is it? With Oracle 10g?

Cheers,

Oliver

Mark C. Stock wrote:

> "Oliver Zeigermann" <oliver_at_zeigermann.de> wrote in message
> news:2jd0l9Fvcic3U1_at_uni-berlin.de...
> | Folks!
> |
> | Is it possible a serializable transaction gets rolled back becasue it
> | can not be serialized when there is *no other* transaction running in
> | parallel?
> |
> | Because I get those transactions rolled back for that reason and toad
> | keeps telling me there is no other connection and then no other
> | transaction running on it.
> |
> | Is toad trustworthy? Am I going crazy?
> |
> | Thanks for any help (any psychiatrists around)?
> |
> | Oliver
>
> please supply more details.... versions, error messages, sample statements
>
> ++ mcs
>
>
Received on Thu Jun 17 2004 - 04:23:25 CDT