Are you getting execution performance bottlenecks in your PL/SQL code and not sure what to do? This video shows how to detect and report on a performance bottleneck using profiling techniques.
About the Author
John Pocknell is a senior market strategist at Quest Software and part of the Information Management business unit. Based at the European headquarters in the U.K., John is responsible for synthesizing analyst data and customer interviews in order to create and evangelize solutions-based stories and messaging which relate to major IT initiatives for our extensive portfolio of database products, worldwide. He has been with Quest Software since 2000, working in the database design, development and deployment product areas and spent over 10 years as product manager for the Toad product line. John has been successfully evangelizing Toad and other database solutions at various conferences and user groups around the world for the last 19 years as well as writing blogs and technical papers both internally and for the media. John has worked in IT for more than 30 years, most of that time in Oracle application design and development. He is a qualified aeronautical engineer with more than 10 years of experience in provisioning IT consultancy services and implementing quality assurance systems to ISO 9001.
Related Articles
Oracle 12.2 New Features: Scheduler, Data Pump, and More
Hi, I’ve written a lot of articles on Oracle12 new features. This article will conclude the series with a list of miscellaneous new features for the various other tools like data pump, the scheduler,...
Optimize SQL (Plan Control)
Using Plan Control mode in Optimize SQL consists of two steps. In the first step, SQL Optimizer generates execution plan alternatives for your SQL statement without changing the source code. You can t...
Be first to try our newest Toad!
Want to apply Toad's robust development features to your MySQL environments? Well now you can! We have released a our new Toad Edge product initially focused on the MySQL platform, Toad Edge is a next...