SELECTs across DBLinks locking rollback segs
Came across this is a Distributed Systems Doc:
Why? I can understand how, maybe, a 'SELECT FOR UPDATE' might lock rollback, but why a 'simple' SELECT?
When you issue a SELECT statement across a database link, a transaction lock is placed on the rollback segment. To release the segment you must issue a COMMIT or ROLLBACK.
SELECT a, b, c
BTW - The quote is from the Ora9.2 guide to 'Developing Applications for a Distributed System'.
Click Here to Expand Forum to Full Width