Oracle

Oracle Community

Oracle Blogs

Steven Feuerstein
Follow /28 Aug 2015 at 9:05pm / Oracle

Optimizing PL/SQL Panel at Oracle Open World 2015 - Questions welcome!

At Oracle Open World 2014, I was a member of a panel on SQL and PL/SQL Performance. It was an awful lot of fun, but as I had expected, most of the questions focused on SQL performance, and most of them were answered by Tom Kyte (no complaints from me...
62 0 /
Iggy Fernandez
Follow /28 Aug 2015 at 1:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 39: Unfriending the optimizer statistics

Previous installment: Shakespeare’s advice for database upgrades First installment: DON’T PANIC “Heigh-ho, sing heigh-ho, unto the green holly. Most friendship is feigning, most loving mere folly. Then heigh-ho, the holly. This life...
355 0 /
Fernando Garcia
Follow /27 Aug 2015 at 10:41pm / Oracle

Ejemplos de uso de expresiones de calendario

En este artículo veremos ejemplos de uso concreto de expresiones de calendario. Este es el cuarto artículo de una serie dedicada al planificador de tareas interno de Oracle. Te recomiendo leer los artículos anteriores: Oracle...
97 0 /
Dan Hotka
Follow /27 Aug 2015 at 8:14pm / Oracle

SQL Tuning- lessons learned from a lifetime in Explain Plans (part 10)

Hi! OK, we have been discussing cardinality and the importance of order in the Explain Plan. I have shown you newer syntax (and tools that runs said syntax) that shows actual row counts (cardinality) per line of explain plan. I’ve beat round...
120 0 /
Fernando Garcia
Follow /26 Aug 2015 at 9:49pm / Oracle

Como calendarizar tareas con DBMS_SCHEDULER

En los últimos dos artículos hemos estado conociendo el planificador de tareas interno de Oracle. Al crear una tarea es indispensable que indiquemos qué hacer y cuándo hacerlo. Como en general hablamos de tareas repetitivas...
117 0 /