How to Get Success in Oracle Performance Tuning?

This topic has been discussing so many times in different blog and different books. Every Oracle DBA is interesting to get success in Oracle performance tuning. I have published so many articles on same topic. Still I am asked same query by so many Oracle DBAs. Those Oracle DBAs are very keen to get answer to solve this mystery.

Oracle performance tuning doesn’t like mystery. Performance slowness would start in your database server and slowly it would be impacting all active sessions. Performance bottleneck doesn’t occur immediately and reflect drastically. But it started from very beginning and increasing rapidly sometimes. If you are well experienced Oracle DBA then you can judge for future impacts of some incidents. These symptoms and characteristics can be judged using constant monitoring of databases. If you are constantly monitoring your databases, then you can able to mark some incidents like buffer cache hit ratio suddenly dropped, temp segment usage suddenly improving, physical read is increasing, etc.

If you are keen in system administration then you would get these all characteristics of performance bottleneck very quickly and easily. Because in Linux and Unix environment so many utilities available to monitor Oracle server accurately about usage and load. As per my own opinion, I always use system administration tools for server monitoring like "top" command or "vmstat" command. Those are best monitoring tools.

Oracle installs on operating system. We need to concentrate on server performance and system load. If server has too much load then obviously Oracle database performance would affect. There is no question about it. So many performance issues are starting from Oracle server consumption only. It is just like health of people. If your stomach is not healthy then you would get so many health problems at any part of body.

I got one very good article on performance tuning of Oracle server from a resource. Oracle Performance Tuning Troubleshooting is art and techniques. To get expertise in tuning, you need to get various kind of knowledge like system administration, network administration, hardware, and applications. Without that knowledge, it is very difficult to understand main reason behind server slowness. In another word we can say it "without knowledge of application, system, network, hardware, Oracle server tuning becomes mystery for you".

Creator of Database Concept

Invention and creation always done by IBM for SQL or RDBMS Concept. If you study Structure Query Language then you can get more idea about invention of SQL done by IBM. Dr. E. Codd invented RDBMS Concept. And after different kind of database was developed and came in to global market like mySQL, PostgreSQL, Oracle, MSSQL, etc. But main thing is RDBMS concept. Relational Database is widely accepted in global market. Because most of of business requirements are fulfilled by this rdbms concept.

Due to these all reasons, IBM is always ahead in database invention and conceptual deployment. But unfortunately Oracle is ahead from IBM in database domain.

In past Oracle didn't have own plateform like operating system and storage plateform. But Oracle captured global market in database domain. Now after took over of Sun, Oracle has own operating system and storage plateform too. As per my thinking, Oracle would be capturing more market share than others in future.

Unfortunately, after certain important inventions in database field, IBM DB2 is not able to capture good market in global technology world. I tried to study and understand IBM DB2 database sometime back due to client's requirement of migration from DB2 to Oracle. I surprised to see so many good features DB2 have. As Database administrator and to perform good database administration we need to understand all database concepts.

For obtaining knowledge of comparision of IBM DB2 and Oracle, you can get good idea and concept from DB2 and Oracle Server comparison.

During remote database administration, database dba has to work hard and known with every concept and features of all kind of databases.