How To Choose Your Best Oracle Performance Analysis Strategy

• The phone rings • Poor performance • What is your next move? •

The phone rings. It’s an unhappy user complaining about poor performance. What is your next move? What is your best strategy to identify the issue, develop solutions and communicate that to others?

As Oracle DBAs we have two fundamental performance analysis strategies: time based and sample based (ASH). Each strategy has strengths and weaknesses. Knowing these differences and how to exploit them gives you the edge in solving the puzzle.

In this seminar, Craig introduces each strategy, highlights how they work and contrasts their differences. Then he will demonstrate each strategy. We will end with three situational videos where you choose the best performance analysis strategy. The next time you are faced with a performance challenge, you will know your best performance analysis strategy!

Members Login Become A Member Today

What You Will Learn

  • The two core performance situation types you will face
  • What is and how to do an Oracle time-based analysis
  • What is an Oracle ASH-based analysis
  • The differences between a time-based and an ASH-based analysis
  • Which performance strategy is best in any given situation
  • By watching Craig do a time-based and an ASH-based analysis
  • By watching three situational videos and choosing the best strategy
  • The available tools for both a time-based and an ASH-based strategy

Modules

  • Performance situations we all face - Introduction
  • Why do an Oracle time-based analysis and how do we do it
  • Why do an ASH-based analysis and how do we do it
  • Ways to use ASH data
  • The two core ASH reports
  • Live demonstration of an Oracle time-based analysis
  • Live demonstration of an Oracle ASH-based analysis
  • Video scenario quizzes, tools and next steps

Seminar Videos

How To Choose Your Best Oracle Performance Analysis Strategy | OraPub