High Performance PL/SQL

  • Posted on: 29 October 2008
  • By: admin
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.
AttachmentSize
File high performance plsql.pptx1.26 MB
Version: 
1
Publish Date: 
20 Oct 2008
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®.
Tags: 
Conference 2008
field_vote: