High Performance PL/SQL

Submitted by admin on Wed, 29/10/2008 - 13:02.

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. In this presentation we’ll examine trends in PL/SQL performance, look at tools to identify and tune problematic PL/SQL and examine PL/SQL performance best practices. The presentation will include discussions of profiling, code optimization, in-lining, native compilation and the new 11g function cache.

Author Information
Author/Owner: 
Guy Harrison
Organization: 
Quest Software
Presenter: 
Guy Harrison
Presenter Biography: 

Guy Harrison is a chief architect for database solutions at Quest Software, and is a recognized expert with over 15 years experience in application and database administration, performance tuning and software development. Guy is the author of Oracle SQL High Performance Tuning (Prentice Hall), Oracle D esk Reference (Prentice Hall) and MySQL Stored Procedure Programming (O’Reilly with Steven Feuerstein), and is a regular speaker at trade shows and event. He is chief architect of Quest's Spotlight® family of diagnostic products and has contributed the development of other Quest products such as Foglight® and Quest Central®.

File Information
Version: 
1
Publish Date: 
20 Oct 2008
No votes yet
AttachmentSize
high performance plsql.pptx1.26 MB