Making Materialised Views Great Again
David Kurtz, Accenture
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.
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.