Meetings Sponsors:

 

 

 

 

 

Meeting Sponsors: Oracle Corporation (www.oracle.com), TPSi (www.tpsinc.com), TOAD by Quest Software (www.quest.com/database-management) , Confio (www.confio.com)

                                                                                                                                               

 

January 23, 2012  --- AGENDA

 

“Tom Kyte Day”

 

 

08:00 AM – 08:30 AM         Meeting Registration / Door Prize Raffle Registration

08:30 AM – 10:00 AM         SQL Techniques (Tom Kyte, Oracle Corp.)

10:00 AM – 10:15 AM         Break

10:15 AM – 11:45 AM         Read and Write Consistency (Tom Kyte, Oracle Corp.)

11:45 AM – 11:50 AM         Sponsors Overview, Announcements (Attendees)

11:50 AM – 12:30 PM         Buffet Luncheon

12:30 PM – 01:25 PM         Versioning Of Data (Tom Kyte, Oracle Corp.)

01:30 PM – 01:45 PM         Break

01:45 PM – 02:45 PM         What Else Can I Do With System and Session Performance Data(Tom Kyte, Oracle Corp.)

02:45 PM  03:15 PM         Maximize Code Quality in PL/SQL Applications (Kuljit Sangha, TOAD by Quest Software) -  abstract

03:15 PM – 03:20 PM       Announcements / Raffle

 

 

Bio

Tom Kyte is a Senior Technical Architect in Oracle’s Server Technology Division. Before starting at Oracle, Kyte worked as a systems integrator building large-scale, heterogeneous databases and applications, mostly for military and government customers. Kyte spends a great deal of time working with the Oracle database and, more specifically, working with people who are working with the Oracle database. In addition, Kyte is the Tom behind the AskTom column in Oracle Magazine, answering people's questions about the Oracle database and its tools (http://asktom.oracle.com/). Kyte is also the author of Expert Oracle Database Architecture (Apress, 2005), Expert One on One Oracle(Wrox Press, 2001/Apress 2004), Beginning Oracle Programing (Wrox press, 2002/Apress 2004), and Effective Oracle by Design (Oracle Press, 2003). These are books about the general use of the database and how to develop successful Oracle applications.

 

SQL Techniques 1 to 1.5 hours

The presenter will describe common SQL techniques he has encountered and utilizes day to day to tune query performance. Features such as scalar subqueries, using rownum (yes, to 'tune'), analytics, some hints and more will be demonstrated. Emphasis will be on when they work (where the 'trick' applies) as well as when they don't workwhere they do not apply. Care will be taken to show these not as a "top 10 things to do" but rather techniques to keep in mind when looking at problems in general.

 

Read and write consistency 1.5 hours

Oracle's multiversioning model is by far it's most striking core RDBMS feature. We'll explore this often misunderstood database feature, both from a "read" perspective as well as some nuances you probably are not aware of in a multi-user environment. This session is probably an eye-opening experience, even for people that have been using Oracle for many many years.

 

Versioning of data 1 hour

A common requirement today is to maintain a complete history of data: every change made to a row over time, for all rows in a table or set of tables. This session explores the methods available to do this, from "do it yourself" versioning (via triggers/application code) to letting the database do it for you with workspace management. Key focuses of this session are time to develop, performance, and implementation.

 

What Else Can I Do with System and Session Performance Data – 1 hour

So you have access to information via Oracle Enterprise Manager and the management packs, but what else can you do with this data, beyond what is already exposed? You have a wealth of information in there—you just need to look at it, as you'll learn in this session.

Best Practices for Maximizing Code Quality in PL/SQL Applications

This presentation by Quest Software’s system consultant Kuljit Sangha will take you through database development best practices that empower you to write better-performing, higher-quality code with fewer bugs. He will do this by covering key functional areas that help you guarantee application success. This is includes giving you the ability to work smarter through collaboration and standardization across your development team. Kuljit will also share how, through this best practices approach, your organization can greatly reduce risks associated with bugs, performance validation, inconsistent coding standards, dispersed teams with varying skill levels, and more.

 

Quest Software

Best Practices for Maximizing Code Quality in PL/SQL Applications

This presentation by Quest Software’s system consultant Kuljit Sangha will take you through database development best practices that empower you to write better-performing, higher-quality code with fewer bugs. He will do this by covering key functional areas that help you guarantee application success. This is includes giving you the ability to work smarter through collaboration and standardization across your development team. Kuljit will also share how, through this best practices approach, your organization can greatly reduce risks associated with bugs, performance validation, inconsistent coding standards, dispersed teams with varying skill levels, and more.