Hotsos Symposium Speaker – Abel Macias

Abel Macias is a new Hotsos Symposium presenter.

Biography

Abel MaciasMr. Macias has been a speaker at Oracle Open World 2008 and 2009 on the Real World Performance Group Panel and Support Stars Bar.

Presentation Title

The Sins of SQL Programming that Send the DB to Post-Upgrade Performance Purgatory

Abstract

A "Sin" in this case, is a bad practice that causes great hardship to the business during database upgrades.

This paper shows examples of real world cases submitted to support "Sinful" queries giving wrong results or unexplainable data error messages usually after an upgrade. These practices can have a negative effect on the performance of the queries after the migration, too, so learn to recognize them and avoid purgatory.

The usual argument from customers is that "it used to work".

Presentation Materials

Presentation materials are available online to attendees only.

Schedule

The speaker schedule is as follows: