When posting a question such as yours it would be best
to qualify whether local or distributed transactions are
being employed. Locking behavior changes somewhat
based on the isolation level. As distributed transactions
run at 'READ SERIALIZABLE', the characteristics will be
significantly different than 'READ COMMITTED'.
--
Michael D. Long
http://extremedna.homestead.com
"Jack" <No_at_Mail.Please> wrote in message
news:gCZ65.5733$uO1.42486_at_news1-hme0...
> How does Oracle compare with Sql7 as regards Locking problems.
>
> For instance, does Oracle put locks on Select statements, what Locks does
it
> put on Update and Insert statements?
>
> Sql7 puts 'read only' Shared locks on all the above statements (default
> Isolation mode) but converts the Update and Insert statements (after
> satisfying the Insert and Update conditions) into Exclusive locks in order
> to do the actual Insert and Update operations. This 'conversion' often
> causes deadlocks.
>
> How about Oracle does it have 'Lock' problems?
>
> Thanks
> J
>
>
Received on Sun Jul 02 2000 - 00:00:00 CDT
