May 14th, 2015 – OOUG Meeting

Mark your calendars for the Ohio Oracle Users Group Q2 General Meeting on May 14th 2015.

We are very excited to announce our guest speaker Carlos Sierra. He is the author of some popular tools for Oracle SQL Tuning: SQLTXPLAIN (SQLT) and SQL Health Check (SQLHC) among others. Carlos will be delivering a session on “Practical SQL Tuning”. Come and enjoy a full day of education and networking with The Tuning Expert Carlos Sierra. This meeting will truly enhance your oracle knowledge. We look forward to seeing you on May 14th, 2015.

Please visit the Oracle Users Group Website and Register for the event click here or, Please RSVP.

Meeting Date:  May 14th 2015

Meeting Location:

Dublin Community Recreation Center at Coffman Park
5600 Post Rd Dublin, OH 43017 (614) 410-4550
This facility provides free wireless internet access

Meeting Cost:

· Individual Yearly Membership $30
(covers all OOUG Meeting for a year – excludes premium meetings)
· $25 for non-member attendees.
· Corporate Yearly Membership $200
(allows up to 7 attendees per meeting)

Meeting Schedule:

08:00a – 09:00: Registration / Breakfast
09:00a – 09:15: Announcements -Introduction of the speaker
09:15a – 10:15: Practical SQL Tuning, Part 1
10:15a – 10:30: Break
10:30a – 11:45: Practical SQL Tuning, Part 2
11:45a – 01:00: Lunch
01:00p – 02:00: Practical SQL Tuning, Part 3
02:00p – 02:15: Break
02:15p – 03:30: Practical SQL Tuning, Part 4
03:30p – 03:45: Member Announcements, Gift Drawings

Carlos Bio:


Carlos Sierra is the author of some popular tools for Oracle SQL Tuning: SQLTXPLAIN (SQLT) and SQL Health Check (SQLHC) among others. He has been a speaker at several conferences related to Oracle performance, including HOTSOS, OOW, UKOUG, RMOUG and IOUG. Carlos currently works for the Accenture Enkitec Group (AEG), where he helps the Oracle Community as a Consultant. Prior to Enkitec, Carlos worked for Oracle for 17 years. Carlos is a frequent SQL Tuning practitioner constantly helping peers and other professionals to diagnose SQL statements performing poorly. If you want to learn more about Carlos contributions to the Oracle Community you may want to browse his blog at
Twitter: @csierra_usa

Practical SQL Tuning
SQL Tuning is a Science. SQL Tuning is an Art. You may have heard both claims. SQL Tuning can be indeed a complex task requiring the use of some attributes of both brain hemispheres: Analytical Thinking and Creativity. If we want to enhance our SQL Tuning skills we may need then to take those two into consideration…
The targeted audience for this “Practical SQL Tuning” session is both Developers and DBAs, with a desire to increase their SQL Tuning skills within a dynamic and participative environment. Open questions are welcomed and sharing knowledge and experience is encouraged and expected. In fact, those participants who register early have the opportunity to propose their own SQL Tuning case, and have it either discussed or diagnosed before or during this training session. After all this is a Practical SQL Tuning session!


February 18th, 2015 – OOUG Meeting

Don’t ASK me … Ask the Expert!

Mark your calendars for the Ohio Oracle Users Group Q1 General Meeting on Wednesday Feb 18th 2015 . We are very excited to be able to welcome Tom Kyte and Joel Kallman of Oracle for this meeting. Enjoy a full day of education and networking with Oracle Experts.

With Key speakers from Oracle, this meeting will truly enhance your oracle knowledge. Come on out and “ASK the Expert”. We look forward to seeing you again this year!

Meeting Date: Feb 18th 2015

Click here to register for meeting, paypal link to pay is below bios.

Meeting Location:

Dublin Community Recreation Center at Coffman Park
5600 Post Rd Dublin, OH 43017 (614) 410-4550
This facility provides free wireless internet access

Meeting Cost:

· Individual Yearly Membership $30 + Paypal Fee
(covers all OOUG Meeting for a year – excludes premium meetings)

· $25 for non-member attendees + Paypal Fee.

· Corporate Yearly Membership $200 + Paypal Fee
(allows up to 7 attendees per meeting)

Meeting Schedule:

08:00 AM – 09:00 AM: Registration / Breakfast
09:00 AM – 09:05 AM: Announcements / Introduction of the Speakers
09:05 AM – 10:05 AM: Joel Kallman – What’s the Big Deal about Oracle Application Express and Why Should I Care?
10:05 AM – 10:15 AM: Break
10:15 AM – 11:15 AM: Joel Kallman – Revolutionary Oracle Application Express 5.0
11:15 AM – 12:00 PM: Lunch
12:00 PM – 01:00 PM: Tom Kyte – What’s New in Oracle Database 12c Release
01:00 PM – 01:15 PM: Break
01:15 PM – 02:15 PM: Tom Kyte – Securing Data in Oracle Database 12c
02:15 PM – 02:30 PM: Break
02:30 PM – 04:00 PM: Tom Kyte – SQL Plan Management: Finally consistent query performance!
04:00 PM – 04:10 PM: Gift Drawings

Speakers BIO


Tom Kyte – Senior Technical Architect at Oracle

Tom Kyte is a Senior Technical Architect in Oracle’s Server Technology Division. Tom is the Tom behind the AskTom column in Oracle Magazine, answering people’s questions about the Oracle database and its tools ( He is also the author of Expert Oracle Database Architecture (Apress, 2005/2009), 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.

Session Title: What’s New in Oracle Database 12c Release
Oracle Database 12c Release is out. This session will explore some of the new capabilities found in this release including In-Memory optimizations, Attribute Clustering and enhancements to Oracle Multitenant.

Session Title: Securing Data in Oracle Database 12c
Oracle Database has a long history of security ‘firsts’. In this session, we’ll take a look at the current state of the art security features to be found in Oracle Database 12c. Both new and old capabilities will be covered.

SQL Plan Management: Finally consistent query performance!
The performance of any database application heavily relies on consistent query execution. While the Oracle Optimizer is perfectly suited to evaluate the best possible plan without any user intervention, a SQL statement’s execution plan can change unexpectedly for a variety of reasons. This potential for change makes even the most experienced DBAs and developers nervous. SQL Plan Management (SPM) offers an ideal solution to this conundrum by preserving the current execution plans amidst environment changes, and only allowing plans to change if it results in improved performance. This presentation will provide a detailed explanation of how SPM works, along with step by step instructions on how to capture your existing execution plans. We will also cover how to test and verify any newly found plans, as well as explaining in detail how SPM interacts with other plan stability features such as SQL profiles, SQL patches and adaptive cursor sharing.


Joel Kallman – Director APEX Development Oracle Corporation

Joel R. Kallman is Director of Software Development for Oracle’s Server Technologies division at Oracle America, Inc. He is responsible for the development and product management of Oracle Application Express. Joel has been at Oracle since 1996 and is the co-creator of Oracle Application Express. He is a contributing author of several books on Oracle technology, including Expert One on One Oracle, Beginning Oracle Programming, and Mastering Oracle PL/SQL: Practical Solutions. Joel holds a Bachelor of Science degree in Computer and Information Science from the College of Engineering, Ohio State University.
Session 1: What’s the Big Deal about Oracle Application Express and Why Should I Care?
Oracle Application Express (APEX) is the native Web development environment of the Oracle Database. And guess what? You’re licensed for it already! This session will cover the history and architecture of APEX, cover a large number of use cases, and will primarily consist of live demonstration.

Session 2: Revolutionary Oracle Application Express 5.0
Come learn about what’s coming in Oracle Application Express in 2015, from the wildly productive and graphical Page Designer to the modern, responsive and easily customizable Universal Theme. Web applications against your Oracle Database have never looked so good!


October OOUG Meeting

The Ohio Oracle Users Group (OOUG) is very excited to announce Oracle Corporation’s  Maria Colgan, “The leading Lady for the Oracle Optimize” and  “The Optimizer Queen”  at the Oct 9th OOUG meeting.  Don’t miss this opportunity to spend the day with Maria for a mind-blowing experience and the opportunity to deepen your skill set and expand your knowledge of In-Memory features.
Maria’s Presentation will explore the powerful capability of the Oracle “In- Memory” 12C features.

Fw_ OCT 9th meeting - approval needed

Maria Colgan is a master product manager at Oracle Corporation and has been with the company since version 7.3 was released in 1996. Maria’s core responsibility is the Oracle Database In-Memory Option. Based on Maria’s extensive experience in Oracle’s Server Technology Performance Group – where she conducted competitive customer benchmarks and tuning sessions – and the Optimizer Group, Maria creates material and lectures on the Oracle Database In-Memory Option and the best practices for incorporating it into Oracle environments. She is also a contributing author to the Oracle Optimizer blog  and the new Oracle Database In-Memory blog .

Date:  10/09/2014
Time: 9:00 am – 3:30 pm

Meeting Cost:
OOUG Members: Free.
Non-Members: $20

The Conference Center at OCLC
6600 Kilgour Place
Dublin, OH 43017-3395
Phone: 614-761-5077

Meeting Schedule:

Time Topic
8:00a-9:00a Registration / Breakfast
9:00a- 9:15a Announcements
9:15a-10:15a In Memory – Maria
10:15a-10:30a Break
10:30a-11:45a In Memory – Maria
11:45a-1:00p Lunch
1:00p-2:00p In Memory – Maria
2:00p-2:15p Break
2:15p-3:30p In Memory – Maria
3:30p-3:45p Member Announcements, Gift Drawings

Fees will be collected at the door.

October meeting RSVP

Rich Niemiec Speaking on Oracle12c in Columbus, OH

Aug 27, 2014

4:30 pm – 7:00 pm

Columbus Brewing Company


Rich Niemiec

Rich Niemiec is a world renowned Oracle Expert, and currently serves as an Executive Advisor to Rolta International Board of Directors. Rich is an Oracle Ace Director and was a co-founder and the CEO of TUSC, a Chicago-based systems integrator of Oracle-based business solutions started in 1988. TUSC was named Oracle Partner of the Year, 6 times.

Rolta is an international market leader in IT-based geospatial solutions, and caters to the diverse industries of infrastructure, telecom, electric, airports, defense, homeland security, urban development, town planning and environmental protection.

Rich is part of an elite group of only six originally honored worldwide Oracle Certified Masters. In 2012, he authored the #1 Oracle bestseller “Oracle 11g Release 2 Performance Tuning Tips & Techniques”, an update of his previous 3 Oracle best sellers on OracleBi, Oracle9i and Oracle 10g Performance Tuning. Rich was inducted into the Entrepreneurship Hall of Fame in 1988. Don’t miss out on joining Rich Niemiec on August 27th at the CBC.

Register Today!

Questions? Please contact Liz Kolbe at or (614) 202-7330

July 2014 Meeting

Craig Shallahamer

Training Day :    Go Faster: Make Oracle Work For You!

Date :  July 17th, 2014

The OOUG would like to welcome you to our Go Faster: Make Oracle Work For You training day. This is a great one-day training session about Oracle database performance taught by Craig Shallahamer, an ACE Director. The class is perfect for Oracle Database versions 8i, 9i, 10g, 11g and 12c.  We hope you can join the seminar!

Location :    Dublin Community Recreation Center at Coffman Park
5600 Post Rd  Dublin, OH 43017 (614) 410-4550

To register: or email

Cost:  $350 for non-members, $300 for members
Bonus:  All attendees will get a coupon for 10% off Craig’s online video training as well.

Go Faster: Make Oracle Work For You

Oracle DBAs find it difficult to get complete and correct information about how the database engine works. Even when bits of truth are collected, consolidating the data into a useful performance optimizing solution is complicated. When a diagnosis is incomplete or the DBA doesn’t understand why a solution improves performance, solution creation becomes a guessing game resulting in haphazard performance improvements.
In this seminar you will learn how selected areas of Oracle work together. The topics are updated constantly (including Oracle 12c) to make this seminar fresh for each audience. Care is given as to why performance solutions work and how to make them usable and practical in a complex and highly available production environment.
Craig is a long time Oracle DBA (1989) who specializes in Oracle performance. He is also an Oracle ACE Director, performance researcher and blogger, consultant, author of two books (Oracle Performance Firefighting, Forecasting Oracle Performance), an enthusiastic conference speaker, and a passionate teacher to thousands of Oracle professionals. He is the founder and president of OraPub, creator of the performance analysis tool, Stori, and clearly pushes the teaching envelope with his online seminars.  His blog, A Wider View, is where to find his most recent public performance research.

Registration :

April 2014 Meeting

Ohio Oracle Users Group  April 17th 2014

The Ohio Oracle Users Group (OOUG) is very excited to announce Oracle Corporation’s  Jeremy  Schneider  and Fuad Arshad at our April 17th  meeting. The  following   topics will be presented:

  • Data Processing Intro: From Mainframes to Big Data
  • Proactive Diagnostic utilities
  • Case Studies in Troubleshooting and Performance
  • Workload Management with Services and Server Pools

If you get the opportunity don’t miss this meeting!  We look forward to seeing you again!

Meeting Date:  April 17th 2014

Event Specifics click here

Collaborate Conference in April 2014

As a member of Ohio Oracle Users Group, we know that the latest education on Oracle technology and applications is important to you and your organization. COLLABORATE 14 – IOUG Forum presents a unique opportunity to get cutting-edge training on topics like Database PerformanceBusiness IntelligenceBig Data and so many more.

Join us in Las Vegas from April 7-11, and you will be able to walk right up to Oracle ACE speakers and industry experts and receive hands-on training from the best of the best. If 12is on your mind, then COLLABORATE 14 – IOUG Forum has to be your next stop as it is the first major conference that will dive into the real-world usage of 12c.

For as low as $1,710, you will obtain the most up-to-date training from technology experts in your particular area of focus and have the opportunity to network with more than 5,500 Oracle expert users.

Download this letter to help justify your attendance and show your organization why COLLABORATE 14 – IOUG Forum is the event you need to be at!

IOUG Attendee Exclusives:

IOUG registrants gain access to these exclusive educational and networking opportunities:

Pre-Conference Workshops – Join us on Monday, April 7 for a complimentary day of Oracle deep-dive training. Pre-conference Workshop topics include:

  • Security
  • Performance and Internals
  • Oracle Database – New Features
  • Maximum Availability Architecture
  • Cloud Consolidation
  • WebCenter

IOUG’s Strategic Leadership Program  – Get strategic with the IOUG community! This program is geared towards the Senior DBA, IT Manager and seasoned professional interested in getting a seat at the table with senior IT management discussing corporate strategy. Expect to refine and improve your skills at influencing without authority, present business cases and help develop business solutions for your company. (By invitation only; please indicate your interest during registration.)

IOUG Expert Sessions – At the IOUG Forum you have the chance to attend more than 15 expert-led, two-hour sessions that delve further into various Oracle topics. Here is a sneak peek at our stacked deck of Oracle experts:

  • The Best Oracle Database 12c New Features – Rich Niemiec, ROLTA
  • Certifying Application Performance on Exadata – A Real-World Case Study – Gaja Vaidyanatha, DBPerfMan, LLC
  • 12 Things about 12– Tom Kyte, Oracle Corporation

Take an even closer look at all of the great content and networking that COLLABORATE 14 – IOUG Forum has to offer and download the advance program, an in-depth preview of this top Oracle user conference.

Register for the conference today to save up to $600 on cutting-edge, user-driven education you can’t find anywhere else.


Reward yourself for all of your hard work by registering for COLLABORATE 14 – IOUG Forum.

Your career, your boss and your database will thank you for it.

Jan Meeting





The Ohio Oracle User Group (OOUG) is very excited to announce “ASK Tom” Day at our Feb 13th, 2014 meeting. Oracle Corporation’s Tom Kyte will be our guest speaker.


His presentations will cover the following topics :

”The Five Best Things to Happen to SQL”,

“All about Statistics”,

“What Do I Really Need to Know When Upgrading?” and

“Tom’s Top 12 Things about the Latest Generation of Database Technology”.

This will be your chance to “ASK Tom” all your questions, so don’t miss this meeting.

We The Ohio Oracle Users Group look forward to seeing you again!


February meeting info/RSVP

The Ohio Oracle Users Group is dedicated to helping Oracle professionals throughout Ohio increase their Oracle knowledge and experience.