Oracle Performance Tuning is not tough
People say Oracle performance tuning is toughest part in database administration. My thought is different. If you are having deep knowledge of Oracle architecture, operating system basics, application awareness, and some basics of networking/storage then it won’t be tough for you. In short, you can be handle and ability to troubleshooting of performance issues.
Every version, Oracle adds some more parameters and changes behavior of old parameters. Always ask an question to yourself about performance issue that,“ why today and didn’t happen yesterday?”. If you are able to find out answer of this question then you will realize immediately what is actual problem and what will be solution of same issue.
“Do you think only experienced DBA can do Oracle Tuning?”
Do you understand my point? If not understood then I am explaining with an example.
Today we got complain from application team about slowness of database. Their all applications were stuck and some of applications failed with error ORA-0060: Resource busy. When I tried to login into Unix server then I observed terrific slowness because my login command was also stuck. I tried to execute some unix command for investigating like Top, PRSTAT, VMSTAT,SAR but output was reflecting after 5-8 minutes. Means server was busy. Due to this reason, I asked question to myself, “Why today and didn’t yesterday?”. This was new server and we upgraded database before 20 days back. From last 20 days all had been working very well. But from last 3 days new database was created and today full backup executed with presence of new database what did not exist before. Root cause found and issue resolved immediately.
If you are able to understand exact issue and circumstances of performance degrade then you will be able to address accurately. If root cause of slowness doesn’t find out then every effort will be useless and you won’t be able to solve performance issue. Due to these all reasons, performance tuning is art and science. You can be understand easily if you are having some basic and good knowledge of Oracle, operating system, storage, application trend, and networking about performance tuning. Only experienced DBAs are able to handle, it is absolutely wrong. Fresher Oracle DBA and intermediate DBA are also able to tune performance issue.
If you get involvement of server performance issues even though it is not Oracle related then you will get good idea and knowledge how to handle it. Sometimes, people are blaming to each other like application team blames to DBA, DBA blames to System admin, System Admin blames to storage, and storage blames to DBA. This is wrong situation and nobody will be able to address performance issue of Oracle server accurately.
Don’t worry if you are fresher Oracle DBA or intermediate DBA, just try to involve in this kind of critical situation and try to investigate. You will get success.
Wish you all the best.
Category: Oracle DBA Training