Control File Enqueue Contention
Refer the article in My Oracle Support which is very useful:
How To Diagnose CF Enqueue Contention Using Systemstate dump [Video] (Doc ID 1457867.1)
1. The scope of this article is to show the reader about the diagnotic approach for CF enqueue problems using systemstate dump.
2. This article has a Video content to navigate through the systemstate dump to identify the enqueue blocker.
3. Apart from this, the article also has some general recommendations for avoiding CF enqueue contention / ORA-00494 errors.
Refer the article in My Oracle Support which is very useful:
How To Diagnose CF Enqueue Contention Using Systemstate dump [Video] (Doc ID 1457867.1)
1. The scope of this article is to show the reader about the diagnotic approach for CF enqueue problems using systemstate dump.
2. This article has a Video content to navigate through the systemstate dump to identify the enqueue blocker.
3. Apart from this, the article also has some general recommendations for avoiding CF enqueue contention / ORA-00494 errors.
