High Performance PL/SQL

Each release of the Oracle RDBMS is associated with dramatic improvements in PL/SQL performance. However, the ultimate performance of any PL/SQL program is still in the hands of the PL/SQL programmer.  This presentation will examine trends in PL/SQL performance, look at tools to identify and tune problematic PL/SQL, and examine PL/SQL performance best practices. Topics will include opportunities for improving SQL performance by using PL/SQL code, measuring and diagnosing PL/SQL performance issues, best practices for writing high performance PL/SQL, and the use of 11g optimizations to further turbo-charge application code.

Bio
Guy Harrison is a senior director of research and development at Quest Software, and has more than twenty years of experience in database design, development, administration, and optimization. Guy is an Oracle ACE, and is the author of the Oracle Performance Survival Guide (Prentice Hall, 2009) and MySQL Stored Procedure Programming (O’Reilly with Steven Feuerstein), as well as other books, articles, and presentations on database technology. Guy is the architect of Quest's Spotlight® family of diagnostic products, and has led the development of Toad® for Cloud Databases. Guy can be found on the Internet at www.guyharrison.net, on e-mail at guy.harrison@quest.com, and is @guyharrison on Twitter.

Register: https://www3.gotomeeting.com/register/510532206