Control File Enqueue Contention

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.

Manually creating database in 11g

As you know Database creation is most important and primary work for DBA.
now 11g also introduce and in 11g it is take few mintues to do :) with very easy steps.

http://dbataj. blogspot. com/2008/ 05/manually- db-creation- with-11g. html

Performance Optimization by avoiding Table Locks

Performance Optimization by avoiding Table Locks

Locking is a very important part of any database system. Database table locks are coordinated through global inter-instance communication for RAC. It is the fact that properly designed applications need not to lock entire tables and therefore table locks can be disabled to improve locking efficiency with minimal adverse side effects.

Refer: http://www.articles.freemegazone.com/oracle-table-locks.php

Database Security

Database Security: Step by step guideline

As a database administrator one of my prime responsibilities is to secure my organization's database from unauthorized access. Developing a database is not difficult at all but developing a secure database is really a complicated task.

Refer: http://www.articles.freemegazone.com/databaseSecurity_guidelines.php