Oracle Troubleshooting Scripts and Tools by Tanel Poder

The aim of this training day is to make everyday Oracle troubleshooting and performance analysis easier, by providing the right tools for the right problems. It is simply not enough to optimize databases and SQL statements, you need to optimize your time as well and using the right tools allows you to perform more proactively. This session will demonstrate the main scripts and tools that Tanel uses in his everyday work to facilitate troubleshooting and performance analysis quickly and accurately. A systematic approach for diagnosing different types of performance problems will be used throughout all the demos

Focus areas:

• How to make your everyday troubleshooting and DBA work easier
• How to collect and analyze relevant performance data

Day 1:

The first part of this session will focus on optimizing your time, by showing how Tanel sets up and uses his Oracle client environment for fast action and efficient work.

Topics covered:

• How to achieve searchable command line history in SQL*Plus
• How to easily extract any SQL result set into Excel or a web browser and get tab- completion of syntax and schema object names in SQL*Plus
• SQL*Plus and shell scripting techniques for quickly creating flexible tools for troubleshooting and tuning work
• Using Tanel's famous Oracle Session Snapper tool for a wide range of performance troubleshooting tasks

Day 2:

Part 2 addresses the problem of information overload in classic performance tools and focuses on important performance data only and on systematic ways of reading it. Tanel will demonstrate multiple fundamental tuning scripts, along with providing advice and examples of how to use these for troubleshooting Oracle and SQL performance.

Topics covered:

• LatchProf v2.0 and MutexProf v2.0 which identify problem SQL in addition to blocking sessions and ‘guilty’ Oracle kernel functions. They also allow capturing latch and mutex holder data over long periods of time for post-mortem analysis and trending
• PerfSheet v3.0, which enables you to visualize performance data in Excel for trend and outlier analysis
• A free online tool for visualizing execution plans and the response time taken by individual lines in the execution plan! All of the scripts and tools demonstrated can be downloaded free from Tanel's website.

Please Note: When you register for this event it will appear you are booking for an event on the first day only. This is not an error but due to constraints within our booking system, please do proceed with your booking and you will in fact receive the access details for both days.

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Audience
Course Topics The first part of this session will focus on optimizing your time, by showing how Tanel sets up and uses his Oracle client environment for fast action and efficient work.

• How to achieve searchable command line history in SQL*Plus
• How to easily extract any SQL result set into Excel or a web browser and get tab- completion of syntax and schema object names in SQL*Plus
• SQL*Plus and shell scripting techniques for quickly creating flexible tools for troubleshooting and tuning work
• Using Tanel's famous Oracle Session Snapper tool for a wide range of performance troubleshooting tasks

Part 2 addresses the problem of information overload in classic performance tools and focuses on important performance data only and on systematic ways of reading it.

• LatchProf v2.0 and MutexProf v2.0 which identify problem SQL in addition to blocking sessions and ‘guilty’ Oracle kernel functions
• PerfSheet v3.0, which enables you to visualize performance data in Excel for trend and outlier analysis
• A free online tool for visualizing execution plans&the response time taken by individual lines in the execution plan! All of the scripts&tools demonstrated can be downloaded free from Tanel's Website

Course Objectives