I was a part of a unique Oracle training seminar that happened in Munich, Germany last week.
This is a Day of Real World Performance Tour seminar given by: Andrew Holdsworth, Tom Kyte, Graham Wood. These 3 well known Oracle experts are key members of the Real World Performance Team that consist of about 25 database experts who focus on Oracle database performance tuning, creating live demos and teaching customers how Oracle perform and how they should write the optimal code.
The format of this Oracle event is very unique. The entire seminar day Andrew, Tom and Graham are continuously on stage sharing in the conversational format very unique technical material debating (sometimes in a funny form) with each other and the audience. There are three screens in the seminar room and every instructor drives his own projector. They show the quite interesting live demos loading terabytes of data and manipulating with billions of rows in just several minutes on their own Exadata systems.
Interesting enough that these guys consider performance tuning aspects of the same problem from different angels sometimes contradicting each other but finally giving concrete solutions and best practices to follow. After those tests and lessons learned you definitely change your mind in terms of database and application performance tuning.
This training seminar makes interesting not only the unique technical material but also all three very different personalities of the instructors and their backgrounds. Tom has never been a DBA but he represents mainly Read more »
Performance problems occur when a task takes longer to perform than the time allowed and uses excessive resources. If the database seems to be running very slow or a command seems to take a long time to respond, an experienced DBA can try to diagnose this runtime problem and fix it.
Performance tuning is a complex process requiring collaborative efforts from DBA and Application team. Thus, to make the tuning exercise efficient and minimize the effort required, the performance issues should be clearly defined. The more precise and detailed you can answer below questions, the easier and faster the tuning process will be for a DBA. Read more »
Database performance tuning can be complicated even for a DBA. In many cases a database just seems like as a big black box. Recently I’ve had a chance to review database software called Embarcadero DB Optimizer XE that tries to open that black box for database developers and a DBA. Read more »
I always thought Oracle database performance tuning was more an art than a science. Being an Oracle performance tuning expert you have to recite not only database manuals but know how the database really works. Besides, you have to understand the core principles of performance management, including a time-tested methodology that is utilized to determine, investigate, and implement efficient solutions to real performance problems. Read more »