Celebrating the joy and power of Oracle SQL with the Oracle Developer Advocate team

  • April 10, 2015

Head to Vegas to see the Oracle Developer Advocates speak

Chris Saxon
Developer Advocate

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.

Thu. Apr. 16 12:15 - 1:15 pm An Introduction to JavaScript Based Web Applications Using the Oracle Database - Dan McGhan

JavaScript MVC frameworks, such as AngularJS, are an increasingly popular choice for creating sophisticated web applications. Middle tiers for such applications are most commonly written using Node.js which provides developers with many tools for operations such as creating RESTful URLs, handling user sessions, and connecting to databases.

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!

If you're not able to make it Vegas, you can still see Chris' M&Ms talk online through the Plug-In to Vegas Forum Virtual Conference in the database performance track

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.