Replicate Objects

Only replication will create locks on replicated objects. Read operations (for example, SELECT statements) on replicate objects will generally not be blocked by locks. In other words, locking on replicated objects should not be an issue for replicate objects. You are also unable to create indexes for replicated objects. As a result, you may find yourself in a position where you lack the indexing to support your query. You can list indexes for views using the DBA_INDEXES and DBA_IND_COLUMN tables if you are uncertain about which columns are indexed in each view.