Main Page

From IAOUG

Jump to: navigation, search

Iowa Oracle User's Group, Des Moines, IA USA

A core group of Oracle enthusiasts that come together to share and learn.

Mailing List

If you wish to be added to the IAOUG mailing list to learn about future meetings, please drop a note to: rouw \at\ alliancetechnologies.net

Who is Invited to IAOUG Meetings & Information About Dues

We invite any and all to attend our meeting. We do not charge dues or allow soliciting. Please come and be as involved or uninvolved as you feel comfortable. Please feel free to share this web page with anyone that would be interested in attending.

Next Meeting

Next meeting is on 16-Feb-2016 13:00 - 17:00 at the DMACC Campus, room 208 of the FFA Building.

There will be two topics

1) "Why is my Application slow? Finding SQL Problems in your Oracle database"

Dan pulls from his vast knowledge of SQL tuning topics to share scripts and details about "finding the SQL causing your performance issues."

Dan will cover:

  • Review how the CBO arrives at an Explain Plan
  • How to start/stop the CBO Trace complete with scripts
  • Content Details including
    • Oracle Working Too Hard
    • Oracle Not Allowed to Work
    • Finding the Problem SQL in the Library Cache


2) "Oracle Internals: A Close look at the 10053 Cost-Based Optimizer (CBO) Trace"

The CBO trace answers the question of why did I get this explain plan. It also shows all explain plan options considered. You should leave this presentation with a better understanding of how the CBO actually works.

  • Review how the CBO arrives at an Explain Plan
  • How to start/stop the CBO Trace complete with scripts
  • Content Details including
    • Query Transformation
    • Actual SQL submitted
    • Machine and object statistics
    • ALL init.ora settings
    • Permutation process review
    • Hint utilization


IAOUG Meetings in General

  • We try to have two - three meetings per year on topics of interest to Oracle Database Developers & DBAs.
  • All IAOUG meetings are free. There are no dues.

See IAOUG Meeting Location for address, driving directions, a map to DMACC, a map of DMACC campus.

Personal tools
Navigation