Oracle Server Tuning Skills
Everybody presume Oracle tuning is toughest part of Oracle database administration. Do you think same? Off course Oracle tuning is difficult and vital task for Oracle DBA.
If you are concentrating following tasks of Oracle database then tuning becomes easier and more effective. If you are working on largest Oracle database which is running 24/7 then tuning mission is more critical and obscure. Oracle DBA doesn't have any kind of magic stick that he or she can use to improve performance of Oracle server quickly. This is more complex and important task. Tuning database level for only one report or query is no way to tune Oracle database. For improving performance of single report or query, the whole database will be affecting after tuning database level.
Following basic concepts are more important and playing major role in Oracle database server tuning.
Large and critical database needs to be monitored constantly. Database trends and wait event analysis is more important to check daily and constant. Remote database monitoring is more effective because databases are residing in data center and Oracle DBA is managing more databases. Constant checking wait events, latch contentions, disk io, memory contentions, growth of database, growth of system resources, increase the demand of space, increase the demand of memory utilization, locking activities are monitoring of critical and 24/7 running databases. Here we are not discussing about important of database because once data is stored in database then important of database is increasing because it is collection of all data.
Oracle Performance Tuning: Improve your Oracle server tuning skills. View large
Operating system monitoring is equally important in compare of database monitoring. Memory utilization, swapping, physical disk io & disk usages, operating system logs, space usage are important part of Oracle database administration. These tasks are also responsible to degrading performance of Oracle server. If any other applications are running on Oracle database server then it should be needed to monitor for effecting database performance. I have seen lots of Oracle DBAs, who are not looking this area and trying to tune Oracle database without any knowledge of operating system issues. Your all efforts might be waste if you are not looking into operating system issues.
Network monitoring is also requiring. If network is becoming slow and TNS packet failure are increasing then performance of Oracle database server is degrading. This is the important factor because all transactions, queries and reports are depending on network connectivity and using network protocol for satisfying data request.
Nowadays large databases are residing on storage server. Storage becomes common requirement for Oracle database server. Oracle database is located on either SAN or NAS. Basic concept of storage is necessary for Oracle DBA. As Oracle DBA you should at least know that where my databases are locating. I don't say that we have knowledge of storage but some knowledge is necessary.
As Oracle DBA we should need strong knowledge of Oracle database architecture and concept. If we don't have this knowledge or we have average knowledge then you won't get success in Oracle performance tuning. Strong and deep knowledge of Oracle fundamental is key requirement. Nowadays Oracle provides so many performance monitoring tools like AWR, STATSPACK reports, Data Dictionary views etc. All things depend on your way of understand those tools. If you check AWR report and see only top 5 wait events, then it is not sufficient. Otherwise Oracle doesn't provide other statistics in same report. Means we should need to consider all wait events statistics.
Oracle DBA has little bit application knowledge too. If you have some concept about your application, especially application flow then Oracle tuning is becoming more effective and easier. Without application knowledge sometime we are searching needle in darkest room without torch. Sometime for improving performance of single report, other report is affecting adversely because we do not know application flow.
Secret of Oracle is the hidden parameters and default setting of those parameters. If you have good knowledge of some hidden parameters then you are able to judge root cause of performance bottleneck. Without investigating root cause of performance degradation, our tuning task not becomes more effective.
If we need to concentrate above all components then our Oracle database server performance tuning techniques will be effective and useful. If we don't consider above parts during our performance tuning goal achievement then may be our tuning task fail to improving Oracle database performance or it will be temporary solution. Therefore, we can say that performance tuning of Oracle is the art and science both. There are so many factors affecting on Oracle database server. For tuning Oracle database server we need consideration of each and every component which are directly or indirectly involve with Oracle database server. If we consider these all parts and keep all things in our mind then and only Oracle tuning is becoming more effective. Otherwise our all efforts are becoming useless. Sometime we got success but it is not final result of improving Oracle performance.
We have Oracle certified expert team and we are specialist in Oracle performance tuning. We are offering emergency Oracle support for your any critical issues and performance problems. We are offering our excellent remote database support & Remote database services with guaranteed response time using SLA & cost effective remote dba plans.Gitesh Trivedi