Why Is My Oracle E-Biz Database Slow? A Million Dollar Question

  • Posted on: 11 April 2013
  • By: milina.ristic
Why is my database slow? I bet, this would be the most common question any Oracle DBA would have come across in his/her career. After all discussions the descision is made for a database infrastructure capacity increase. This is the most common approach taken by any organization when the issue of system performance surfaces, but, what about the increase in cost? What has really gone wrong with database? What's wrong on the application side? Do we have a cost efficient way to isolate and curb this problem? It's a myth that a server capacity increase can solve performance issues. In most cases the system might be starving for a CPU or IO subsystem. My attempt would be to crack the myth and share my experience and knowledge on analyzing the mostly unexplored area of capacity and performance tuning that can proactivly avoid the potential problems immediately or in future.
AttachmentSize
PDF icon Why Is My Oracle E-Biz Database Slow A Million Dollar Question.pdf1.24 MB
Version: 
1
Publish Date: 
1 Apr 2013
Presenter: 
Ajith Narayanan
Organization/Company: 
Dell International Services
Presenter Biography: 
(1) About Me -------------- I am Ajith Narayanan from Bangalore, India having a total of 8 Years of work experience primarily on Oracle database administration and Oracle Apps administration and hands on experience in the capacity planning & Performance tuning using statistical methods on various Oracle environments. (2) About Education -------------------- As far as my education is concerned, I have done M.S., in software systems from BITS Pilani (Work integrated course), Bachelor of Engineering Degree in Electronics major, Diploma in Computer Technology. Also, currently pursuing PGDBA (Finance) by Distance Learning from SYMBIOSIS, Pune. (3) About the work experience ------------------------------ I was lucky enough to get involved in an Oracle applications implementation project right from my first project of my career, which I started as a Systems Engineer with TCS and then moved to Oracle Corporation in Feb 2008, where I was able to explore Oracle technology internals much deeper and develop a unique expertise in capacity planning & performance tuning by analyzing workload trends of various Oracle environments. Moved again on for working with J.P.MorganChase & Co, where, I was actively involved in supporting production oracle databases (quite a large number). Currently working as software architect/advisor for Oracle Apps R12 projects in Dell Inc (16 node RAC + 8 MT) (4) Oracle User Community Activities -------------------------------------- As of my Oracle community contributions, I am serving on the board of a http://www.oracleracsig.org as website chairman, and during my tenure, I had successfully migrated the www.oracleracsig.org website from APEX version 3 to APEX version 4 and continuing my support for the great user forum dedicated to RAC lovers. I can be reached anytime via my cell phone, +91 9008488882. Sincerely, Ajith Narayanan Email: ajithpathiyil@gmail.com, ajith.narayanan@oracleracsig.org Blog: http://oracledbascriptsfromajith.blogspot.com Website Chair http://www.oracleracsig.org Mobile: +91-9008488882
field_vote: