Conference 2008

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.
Version: 
1.0
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

Do You Need an ETL Tool?

  • Posted on: 23 October 2008
  • By: admin
The presentation looks at the role of ETL tools in Data Warehouse development. We look at the various capabilities that an ETL tool provides and compare them to ‘hand crafting’. We weigh the costs and benefits of ETL tools as compared to ‘hand crafting’ and provide guidelines for the audience to select the correct approach for their own situation. The presentation then looks at various techniques for creating a complete and professional enterprise ETL process using PL/SQL.
Version: 
1.0
Publish Date: 
20 Oct 2008
Author/Owner: 
Ben Bor
Organization: 
Ministry of Health
Presenter: 
Ben Bor
Presenter Biography: 
Ben is a Data Warehousing specialist with the Ministry of Health in New Zealand. He has over 20 years of experience in Information Management, consulting with the leading European consultancies with blue-chip international clients. Ben has been with Oracle since V5; he has been presenting internationally for the last 15 years on Information management, Oracle technology, Data Warehousing and Data Quality.
Tags: 
Conference 2008

Pages