This website uses cookies to store information on your computer. Some of these cookies are used for visitor analysis, others are essential to making our site function properly and improve the user experience. By using this site, you consent to the placement of these cookies. Click Accept to consent and dismiss this message or Deny to leave this website. Read our Privacy Statement for more.
David Kurtz

Making Materialised Views Great Again


David Kurtz, Accenture


 

Abstract

The old mature technology still works! This is a story of how and why, in the real messy world of a live customer system, logical standby didn't deliver a reporting solution but materialized views did. On the way, I will look at some of the newer features added 11g and 12c and some ideas for managing the refresh which continue to make this mature technology relevant. 

Speaker Biography

David Kurtz has worked with the Oracle database since 1989 and with PeopleSoft ERP applications since 1996, specialising in system performance tuning. He now works for the Accenture Enkitec Group as a performance tuning consultant. David is a regular presenter at Oracle and PeopleSoft conferences. He is the author of PeopleSoft for the Oracle DBA (www.psftdba.com), and blogs about PeopleSoft (blog.psftdba.com) and Oracle (blog.go-faster.co.uk). David is an Oracle ACE Director and a proud member of the Oak Table.