Latest News

  • Due to multiple scheduling conflicts, we had to cancel the July Meeting, look for updated Oct Meeting information at end of August.
  • We have a new PO Box, its Box 324, Canal Winchester, OH, 43110, the online membership form has been updated.

Meeting Date:  Jan 21, 2010

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.

Registration:

Please register by Jan 14, 2010 by sending email to This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Meeting Cost:

$50 to become a member for the year.
$20 for non-member attendees

  • The meeting includes presentations, breakfast, lunch and snacks.
  • Gift giveaways will vary but usually include drawings for Oracle books.
  • All attendees are automatically registered in the OOUG gift drawings.
  • Occasionally, vendor representatives will offer additional gift drawings that require attendees to register directly with the vendor in order to be eligible to win a prize.
  • Registration for vendor gift drawings is entirely at the option of the attendee and is not governed by the OOUG's privacy policy.

Meeting Schedule:

  • 8:00a -  9:00a - Registration / Breakfast
  • 9:00a -  9:15a - Announcements
  • 9:15a - 10:30a - Tuna Helper - Proven process for tuning SQL
  • 10:30a - 10:45a - Break
  • 10:45a - 12:00a - Oracle 11g Results Cache
  • 12:00a -  1:00p - Lunch
  • 1:00p -  2:00p - Oracle GoldenGate Part 1
  • 2:00p -  2:15p - Break
  • 2:15p -  3:30p - Oracle GoldenGate Part 2
  • 3:30p -  3:45p - Gift Drawings, Wrap up

Presentation Abstracts:

Tuna Helper - Dean Richards

Many DBAs and Developers are faced with tuning poorly performing SQL statements. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as indexing strategies, use of histograms, SQL wait event data, column selectivity and several more that will help the you succeed on future tuning projects.

Oracle 11g Results Cache - Dean Richards

Results Cache is a new feature of Oracle 11g and it does exactly what its name implies, it caches the results of queries into a slice of the shared pool.  If you have a query that is executed repeatedly and reads data that rarely changes, this feature can increase performance significantly.  This presentation will discuss this feature in detail and show you the ins and outs of using it.

Oracle GoldenGate - Fred Louis

Real-Time Data Integration and Continuous-Availability of Business-Critical Applications:  Oracle GoldenGate allows real-time data movement between heterogeneous source and target systems with minimal overhead on the IT infrastructure, enabling real-time BI solutions, multi-directional data synchronization for distributed systems, zero downtime system upgrades, disaster recovery and migrations between heterogeneous databases, OS platforms and servers.  Description of  the technical capabilities and architecture of Oracle GoldenGate will  be covered in this session.

 

Speaker Information:

Dean Richards, Senior DBA, Confio Software

Dean Richards has over 20 years of performance tuning, implementation and strategic database architecting experience. Before coming to Confio, Dean was a technical director for Oracle Corporation managing technical aspects of key accounts and strategic alliances.  Specifically, Dean has focused his entire career on performance tuning of Oracle and SQL Server environments.

Fred Louis, Enterprise Architect, Oracle Corporation

Fred earned a BSBA degree in Information Systems from Xavier University.  His professional expertise and industry knowledge has been built over the last 27 years in software product support, database administration and customer service.  He has worked for over 16 years at Oracle Corporation helping customers in the Ohio Valley region implement database applications and information based solutions in their organizations.  By applying his experience and knowledge gained over this time, he adds value for Oracle's customers by demonstrating how Oracle products can be leveraged to improve the efficiency and effectiveness of their organization.