Blogs

Iggy Fernandez
Follow /24 Nov 2014 at 1:00am / Oracle

OT: Trip Report: Managing the Largest OLTP Database in the World

At the NoCOUG fall conference at the eBay town hall in San Jose, we got a first-hand look at the workings of some of the largest and most challenging database environments in the world. The first presentation that stood out for me was on “sharding...
872 0 /
Iggy Fernandez
Follow /13 Nov 2014 at 8:35pm / Oracle

OT: Toad University at NoCOUG fall conference

The NoCOUG fall conference featuring Toad University will be held at the eBay Town Hall in San Jose, CA on Wednesday, November 19. If you have never attended a NoCOUG conference in the 28-year history of NoCOUG—yes, that’s how long NoCOUG...
2887 0 /
Iggy Fernandez
Follow /29 Oct 2014 at 5:00pm / Oracle

OT: 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 live in the San...
291 0 /
Iggy Fernandez
Follow /29 Oct 2014 at 3:00am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 26: Answers to the Final Exam! (Part IV)

Previous installment: Answers to the Final Exam! (Part III) First installment: DON’T PANIC Here are the answers to the problem in Part 22 of this series “ We Don’t Use Databases; We Don’t Use Indexes .” External tables...
402 0 /
Iggy Fernandez
Follow /28 Oct 2014 at 12:00am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 25: Answers to the Final Exam! (Part III)

Previous installment: Answers to the Final Exam! (Part II) Next installment: Answers to the Final Exam! (Part IV) First installment: DON’T PANIC Here are the answers to the third problem in Part 21 of this series. Here is the SQL query and it’s...
261 0 /
Iggy Fernandez
Follow /26 Oct 2014 at 4:30pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 24: Answers to the Final Exam! (Part II)

Previous installment: Answers to the Final Exam! (Part I) Next installment: Answers to the Final Exam! (Part III) First installment: DON’T PANIC Here are the answers to the second problem in Part 21 of this series. Here is the SQL query and its...
264 0 /
Iggy Fernandez
Follow /25 Oct 2014 at 11:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 23: Answers to the Final Exam! (Part I)

Previous installment: The story so far (Part 11–22) Next installment: Answers to the Final Exam! (Part II) First installment: DON’T PANIC Here are the answers to the first problem based on the following query and execution plan in Part...
288 0 /
Iggy Fernandez
Follow /28 Sep 2014 at 4:30pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN: The story so far (Part 11–22)

Previous installment: The Final Exam! (Part III We Don’t Use Databases; We Don’t Use Indexes) Next installment: Answers to the Final Exam! (Part I) First installment: DON’T PANIC Before continuing with this series, please take a minute...
241 0 /
Iggy Fernandez
Follow /27 Sep 2014 at 5:30pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 22: The Final Exam! (Part III We Don’t Use Databases; We Don’t Use Indexes)

“Books to the ceiling, Books to the sky, My pile of books is a mile high. How I love them! How I need them I'll have a long beard by the time I read them” — Whiskers and Rhymes by Arnold Lobel Previous installment: The Final...
402 0 /
Iggy Fernandez
Follow /26 Sep 2014 at 5:30pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 21: The Final Exam! (Part II)

“Books to the ceiling, Books to the sky, My pile of books is a mile high. How I love them! How I need them I'll have a long beard by the time I read them” — Whiskers and Rhymes by Arnold Lobel Previous installment: The Final...
319 0 /