HOUG Spring 2015 has ended
Heartland OUG Conference = May 21, 2015
Oracle Database [clear filter]
Thursday, May 21

9:15am CDT

Achieve Maximum Oracle Database High Availability

To keep your business systems and applications up and running, you need an easy way to ensure Oracle® database high availability. And while high availability means different things to different organizations — some measure it by the response time in a given application, and others continually sample transaction or network throughputs — the ultimate goal of a highly available environment is to maximize the time it’s accessible and operational. Because any IT system downtime incurs serious costs.

In this educational session you’ll learn simple methods to:

  • ·        Improve scalability, availability and data integration.
  • ·        Affordably replicate Oracle data on-premises, remotely or in-the-cloud.
  • ·        Improve performance of OLTP systems by offloading reporting.
  • ·        Minimize risk and downtime during migrations and upgrades.
  • ·        Optimize analytics and the use of business intelligence applications by copying Oracle data to Hadoop® and other non-Oracle DBMS systems.
  • ·        Quickly migrate from the now deprecated Oracle® Streams® to an easy-to-use, low-cost solution that includes everything you need to meet your data-sharing 


Thursday May 21, 2015 9:15am - 10:30am CDT

9:15am CDT

MySQL for the Oracle Professional
Whether merging technologies or making a complete migration to MySQL, there are definite design and language differences to consider for the Oracle professional.
This session is designed to help ease the burden by walking through major paradigm shifts to the MySQL world.
Topics covered will include:
- Things which may be missed, such as packages and DB links.
- Alternative design patterns to make up for the lack of encapsulation.
- What MySQL can do... just differently.
- "Gotcha's" and caveats


Thursday May 21, 2015 9:15am - 10:30am CDT
Nebraska Auditorium

10:45am CDT

Understanding Explain Plans
This presentation is a must-see for anyone doing SQL tuning. Dan has a thorough understanding of how the Cost-Based Optimizer works and shares that knowledge in this presentation.

Dan covers:
· Useful Explain Plan tools and scripts
· Understanding Oracle Explain Plan
· How the CBO makes its decisions
· Query Transformations
· How tables are processed/joined
· How Indexes are processed
· Explain Plan Line Items
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. Dan is an experienced trainer with considerable knowledge on this topic. The attendee will gain valuable insights as to how Oracle processes SQL and many tips on how to improve SQL performance.

Thursday May 21, 2015 10:45am - 12:00pm CDT
Nebraska Auditorium

1:00pm CDT

Strategic Operationalization of MySQL and MySQL Performance Tuning and Benchmarking
MySQL operationalization. Differences in MySQL and Oracle 12C database approach. Cross technology fits. MySQL 101 and installation. Reduce database TCO with MySQL.


Thursday May 21, 2015 1:00pm - 2:15pm CDT

2:30pm CDT

Oracle on VMware Licensing: From Zero to Expert in 40 Minutes
Many organizations that run, or plan to run, their Oracle Business Critical Applications on VMware virtualization do not understand that the Oracle contract is agnostic to VMware and how that translates to their infrastructure and purchasing. We invite you to join this session for a frank presentation and conversation about Oracle on VMware licensing by the contract.

This session includes Oracle representatives’ Oracle-on-VMware assertions that:

• Soft-partitioning, a host-level concept, is disallowed

• Soft-partitioning may also be a cluster-level concept

• vSphere sub-cluster licensing is disallowed

• The so-called 10-Day Rule is moot

• Licensing of all SAN or NAS-attached vSphere hosts
is required as of vSphere 5.1

• Enterprise-wide licensing is required as of vSphere 6

We will outline the terms that have improved and gotten worse through the last two decades of contract history, and disclose what relevant case law has been uncovered by House of Brick clients' legal teams.


Houseof Brick Technologies

House of Brick Technologies


Dave Welch

CTO and Chief Evangelist, House of Brick Technologies

Thursday May 21, 2015 2:30pm - 3:45pm CDT

2:30pm CDT

Oracle12 New Features with Release 2 Updates
This presentation is a must-see for anyone supporting applications! The presentation will be broken into 4 parts:

· Pluggable Database
· New SQL Syntax
· New PL/SQL Syntax
· New Oracle Optimizers Features

Summary: Dan will cover quite a number of new features of the Oracle12 database that should be of value to developers and DBA’s.

Thursday May 21, 2015 2:30pm - 3:45pm CDT
Nebraska Auditorium
Filter sessions
Apply filters to sessions.