That's right, next week Chris and Dan will be presenting at Collaborate 15 in Las Vegas. The slots for our session are:
Mon. Apr. 13 12:00 - 12:30 pm Finding All the Red M&Ms: A Story of Indexes and Full Table Scans - Chris Saxon
"Why isn't my query using an index?" is one of the most common questions beginners have when tuning SQL. This talk explores the factors that influence the optimizer's decision behind this question. It does so by comparing fetching rows from a database table to finding all the red M&Ms across a number of bags of sweets.
It then compares this to index lookups and full table scans in explain plans giving an understanding on how to answer this question. It finishes with some thought experiments, showing how changing how M&Ms are placed in bags and the relative size of bags to sweets affect the effectiveness of indexes.
And yes, there will be chocolate ;)
Wed. Apr. 15 4:30 - 5:30 pm Maintain Application Uptime When Deploying PL/SQL Using Oracle's Edition Based Redefinition - Chris Saxon
Releasing code changes to PL/SQL in heavily executed packages on databases with high uptime requirements brings many challenges. It's not possible to gain the DDL lock to compile a package while it's being executed, so how do you do so without downtime?
In 11gR2, Oracle introduced edition-based redefinition (EBR). This allows you to deploy multiple versions of PL/SQL objects in the same database. Using EBR, you can release PL/SQL easily without downtime.
This talk discusses earlier methods to tackling this problem and shows how EBR is superior. It steps through the process of creating and using editions. It also investigates some of the downsides to using EBR and techniques you can use to mitigate these.
Oracle offers several technologies, some quite new, that greatly assist in the development of these types of applications including the Oracle Node.js Driver, Oracle REST Data Services, new JSON capabilities in the SQL engine and more. In this session attendees will learn about these new technologies and how they can be leveraged to help create modern web applications with more power and flexibility ever before.
We'd love it if you're able to join us for these sessions and look forward to meeting you!