Materialized Views and Locks
I've been researching mviews and the types of locking that it does on the detail tables. Thus far, I've found some information says it does do some sort of locking, but I cannot find any specifics. The reason for the research is that I'm running into a problem and here's some specifics in case anyone has a comment to share. The data in my table "X" is set in stone. Never changes. "X" is used as a detail table in several materialized views (about 8 of them.) I have 1 refresh call for all the mviews and when it started running, I got an error in a trace file saying that a SELECT could not be performed on X because there was a deadlock.
So this raised questions: Why would a simple SELECT end up in a deadlock? Does the refresh of the mviews have anything to do with it?