Row-X (SX) lock on materialized view

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 3 Jun 2009 10:24:19 -0700
Message-ID: <4a26b1c3$1_at_news.victoria.tc.ca>

I am examining a database. The tables are all replicated to a second database every ten minutes (so the users can do ad-hoc queries without touching the real database).

When the user's have a form open then the record they are editing is locked. I can run a query against v$lock (etc) and see who has what tables locked. Mostly, everything is as expected.

My question revolves around the following.

For one particular table, the materialized view log has also turned up in the lock list some times (Row-X (SX), same ctime as the data table). I haven't seen that for other tables.

Is that normal? Perhaps the other snapshot logs are locked and I just don't happen to see it ever. Is this something that needs investigating?

Opinions welcome.

Thanks, Malcolm Dew-Jones Received on Wed Jun 03 2009 - 12:24:19 CDT