Oracle

Oracle Community

Oracle Blogs

Iggy Fernandez
Follow /28 Aug 2014 at 5:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 18: Practice Exam III

Previous installment: Practice Exam II First installment: DON’T PANIC Every time the optimizer chooses to join two data sets using the hash-join method, it has to decide which of the two data sets will be the in-memory lookup table. The smaller...
53 0 /
Kellyn PotVin
Follow /27 Aug 2014 at 6:01pm / Oracle

The ALS Ice Bucket Challenge, the DBA Kevlar Way

I believe you do your best when you follow in what you believe. Kellyn’s # ALSIceBucketChallenge …. Hold the ice…:) https://www. youtube.com/watch?v=cawQjZ RCyok Tags: Del.icio.us Facebook ...
53 0 /
Iggy Fernandez
Follow /27 Aug 2014 at 5:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 17: Practice Exam II

Previous installment: Practice Exam I Next installment: Practice Exam III First installment: DON’T PANIC Here is the second practice exam. This time, we use the following hints in the query. Instead of the USE_NL hints that you saw in the previous...
103 0 /
Sten Vesterli
Follow /27 Aug 2014 at 1:12pm / Oracle

Beware of the Business User Who Knows Outer Joins

System requirements should specify what the user needs, not how to implement it. Unfortunately, requirements are often written by very expert users whose ideas about how to do things seep into the requirements. I was recently involved with a project that...
149 2 /
Deiby Gomez
Follow /26 Aug 2014 at 8:54pm / Oracle

How to migrate disks from ASM Filter Driver to ASMLib (GI Standalone Environment)

What about if you didn't like AFD and you want to come back to ASMLib? Well just follow the following steps and you will have all your diskgroups using ASMLIB again [root@db12102 ~]# crsctl stop has CRS-2791: Starting shutdown of Oracle High Availability...
62 0 /