Blogs

Iggy Fernandez
Follow /28 Jan 2015 at 9:00pm / Oracle

OT: Pictures from the NoCOUG winter conference at Oracle HQ

There were 130 attendees at the NoCOUG winter conference on January 27 at the Oracle conference center in Redwood City. There was a fantastic breakfast spread. The registration desk was a marvel of neatness. Delphix sent its most photogenic...
351 0 /
Iggy Fernandez
Follow /27 Jan 2015 at 2:00am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 32: Pretzels created by someone experimenting with hallucinogens?

Previous installment: How to Avoid a Salted Banana First installment: DON’T PANIC In an interview for the NoCOUG Journal , Steven Feuerstein was asked: “SQL is a set-oriented non-procedural language; i.e., it works on sets and does not...
897 0 /
Iggy Fernandez
Follow /26 Jan 2015 at 1:00am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 31: How to Avoid a Salted Banana

Previous installment: Throw Away That EXPLAIN PLAN! (Part IV) Next installment: Pretzels created by someone experimenting with hallucinogens? First installment: DON’T PANIC In the February 2015 issue of the NoCOUG Journal , Lothar Flatz introduces...
830 0 /
Iggy Fernandez
Follow /3 Jan 2015 at 6:00pm / Oracle

OT: Win a free NoCOUG membership for yourself and three friends

You can win a free membership in the Northern California Oracle Users Group (NoCOUG) for yourself and three friends by correctly identifying the colorful objects on the front cover of the winter issue of the NoCOUG Journal and where the picture was taken...
324 0 /
Iggy Fernandez
Follow /31 Dec 2014 at 5:00am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 30: Throw Away That EXPLAIN PLAN! (Part IV)

Previous installment: Throw Away That EXPLAIN PLAN! (Part III) Next installment: How to Avoid a Salted Banana First installment: DON’T PANIC The execution plans in the last post were interesting—especially the one in which the child table...
523 0 /
Iggy Fernandez
Follow /30 Dec 2014 at 12:00am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 29: Throw Away That EXPLAIN PLAN! (Part III)

Previous installment: Throw Away That EXPLAIN PLAN! (Part II) Next installment: Throw Away That EXPLAIN PLAN! (Part IV) First installment: DON’T PANIC As I said, the second query is a performance hog beause it deletes all orphans created by the...
442 0 /
Iggy Fernandez
Follow /28 Dec 2014 at 6:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 28: Throw Away That EXPLAIN PLAN! (Part II)

Previous installment: Throw Away That EXPLAIN PLAN! (Part I) Next installment: Throw Away That EXPLAIN PLAN! (Part III) First installment: DON’T PANIC You may have noticed that the purported Oracle script written by the application developer...
538 0 /
Iggy Fernandez
Follow /28 Dec 2014 at 1:00am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 27: Throw Away That EXPLAIN PLAN! (Part I)

Previous installment: Answers to the Final Exam! (Part IV) Next installment: Throw Away That EXPLAIN PLAN! (Part II) First installment: DON’T PANIC We tend to overuse any tool—EXPLAIN PLAN in this case—that we are most familiar with...
584 0 /
Iggy Fernandez
Follow /8 Dec 2014 at 5:00pm / Oracle

Repost: Oracle Trivia Quiz

All the answers to the quiz are in the November 2014 issue of the NoCOUG Journal . I am the editor of the NoCOUG Journal. What’s NoCOUG, you ask? Only the oldest and most active Oracle users group in the world. If you have not attended...
416 0 /
Iggy Fernandez
Follow /29 Nov 2014 at 3:00am / Oracle

OT: Career Advice for Oracle Database Beginners

Excerpted from the February 2011 issue of the NoCOUG Journal The latest issue of the NoCOUG Journal can be downloaded from http://www.nocoug.org/Journal/NoCOUG_Journal_Latest.pdf and a five-year archive is available at http://nocoug.wordpress...
1310 0 /