Fall 2012 Quarterly Meeting (Nov 12, 2012)

8:30 – 9:00

Registration and Networking

9:00 – 9:45

Welcoming Remarks and Announcements - Lelanie Moll, Matt Kalal, Seth Miller

Introduction from Cargill

9:45 – 10:45

Edward Whalen - Performance Tuning Corporation, "Oracle Enterprise Manager Cloud Control 12c Performance Monitoring Enhancements"

Oracle Enterprise Manager Cloud Control 12c is the latest in Oracle’s management tool. This tool provides monitoring, management and performance tools that provide extensive insight into how your Oracle database is running and performing.  This presentation provides a brief overview of OEM Cloud Control 12c as well as a tutorial on how to take advantage of two of the powerful performance monitoring and debugging tools; SQL Monitoring and ASH Analytics.  SQL Monitoring allows you to see which SQL statements are running in the system and how they are currently performing as well as viewing dynamic execution plan information.  ASH Analytics allows you to drill down into ASH data and determine which users, applications and SQL statements are consuming resources in the system.  Specific emphasis is placed on how to determine heavy I/O consumers.

10:45 – 11:00

Break

11:00 – 12:00

Dan Hotka, "Understanding Explain Plans"

This is a live-demo presentation.  Dan shows how to work with Explain Plans then goes into considerable detail about exactly how Oracle arrives at an Explain Plan. The attendee will gain valuable insights as to how Oracle processes SQL and many tips on how to improve SQL performance. The presentation will include details on useful Explain Plan tools and scripts, how the CBO makes its decisions, Query Transformations, How tables are processed/joined, How Indexes are processed and Explain Plan Line Items.

12:00 – 1:00

Lunch

1:00 – 2:00

Tom Kyte – Oracle, "Some Things about the Next Generation Oracle Database"

We'll be taking a look at what was previewed at Oracle OpenWorld 2012 for the next generation of database, 12c. Tom will detail new database architectures, security, ease of use and performance features.

2:00 – 2:15

Break

2:15 – 3:15

Tom Kyte – Oracle, "Ask Tom: Q&A with Tom Kyte"

This is your chance. The one and only Tom Kyte will take questions from you. Please submit your questions before the meeting. You can send them to Seth Miller (vp@tcoug.org) before November 10th and they can be asked on your behalf or anonymously.

3:15 – 3:45

Giveaways and Prizes!