11.2 : library cache: mutex X
groxySep 16 2009 — edited Apr 4 2011Hi,
I am using 11.2 on Linux Redhat 5.3 (64-bit)
I have simple scenario. I am performing many (~10.000 ) insertions to a table e.g. TEST_TABLE and after insertion of a single row, a commit is issued. On the table TEST_TABLE, a on-commit materialized view is built. During the process the performance of the database decreases ( starting from 10 commits per second down to 1 commit). Which finally causes the database to be “saturated” Restart of the database solves the problem till next "insertion operation"
I reply the scenario on the same machine having installed Oracle 10.2.0.4 and the problem does not occur. During the whole insertion, there is constant number of transaction per second and it does not decrease!
In 11.2 I am getting the following waits (in WaitHistory):
- library cache: mutex X
- db file sequential read
In 10.2.0.4 only:
-db file sequential read
What can cause the difference? Any initialization parameters may help?
Please help
Regards
Groxy