I always enjoy attending and presenting at ODTUG. So much that last year, I volunteered to help the track leaders, David Schleis , Eddie Awad , and Chet Justice organize the DB Symposium on Sunday. It will be a great day that is starting with a joint keynote with Mike Hichwa on tools generally. Then we split into the DB track where it starts the progression of blank slate , developing, testing , building , deploying and wrapping up with tuning the deployed code.
8:45 - 9:45 Keynote - Oracle Database Tools - Mike Hichwa
Mike Hichwa, vice president of database tools, will provide an insight into the latest development of database tools and the Oracle Database Cloud Service. Everybody who is currently utilizing Oracle database tools should attend this session.
9:45-10:30 -SQL Developer Data Modeler - Kris Rice
SQL Developer Data Modeler allows for easy modification of existing database objects. This session will cover how to reverse engineer, modify, and create a script of the changes. Collaboration is an important part of any development team, with built in subversion support the modeler makes collaboration possible.
10:30 - 11:00 BREAK
11:00 - 12:00 - SQL Developer -Jeff Smith
SQL Developer provides the framework for your complete PL/SQL development process. It begins with developers working together to quickly and efficiently build new applications. Versioning your code, merging in changes from other developers, pushing out the latest and greatest to your QA teams or the Cloud is all a natural part of the tool.
Of course before you publish anything to anyone, you're testing your code, right? For the folks out there that feel guilty about having their users testing their code for them, you can actually build your own test suites and identify regressions.
12:00 - 1:00 LUNCH
1:00 - 1:45 - Continuous Integration with Database projects - Kris Rice
1:45-2:45 - How to "tune" a query - Tom Kyte
I am often asked how I tune a query, or more generally - how does one "tune" a query. In this session - we'll look at how query tuning is performed. You might be surprised at the answer as it often does not involve rewriting a single query.
2:45 - 3:15 BREAK
3:15-4:00 - SQLDeveloper with Enterprise Manager: integrating changes from developer to DBA - Jagan Athreya
Developers and DBAs have usually faced conflicting changes, delayed application upgrades and production downtime due to lack of integrated tools to manage the database change lifecycle. Come to this session to see and learn about the integration between SQL*Developer and Enterprise Manager Cloud Control 12c that enables developers to define changes in SQLDeveloper and allows DBAs to promote these changes to Test and Production seamlessly via Enterprise Manager thereby reducing errors, accelerating productivity and eliminating unplanned downtime.
4:00-4:45 Oracle Optimizer - Top Tips to get Optimal SQL Execution all the Time - Maria Colgan
Simple system changes such as gathering optimizer statistics or changing a parameter value can affect SQL execution plans and therefore the performance and stability of a system. Managing such changes is an ongoing challenge for many customers. This session shows the process of analyzing and resolving the most common SQL execution performance problems including, poor cardinality estimations, bind peeking issues, selecting the wrong access method and more. With clear how-to examples you will learn how to identifying and quickly resolving these issues.