Oracle
-
Little things worth knowing: exp/imp vs expdp and impdp for HCC in Exadata
Do you know the difference between exp/imp and expdp/impdp when it comes to importing HCC compressed…
-
What happens in ASM if usable_file_mb is negative and you lose a failgroup
Having read the excellent post “Demystifying ASM REQUIRED_MIRROR_FREE_MB and USABLE_FILE_MB” again by Harald von Breederode I…
-
How to resolve the text behind v$views?
This is a common problem I have and I never write it down (except now). For…
-
Adaptive plans and v$sql_plan and related views
Adaptive plans are one of the coolest new optimiser features in Oracle 12c. If you haven’t…
-
Installing Oracle 12.1.0.2 RAC on Oracle Linux 7-part 2
In the first part of the article series you could read how a kickstart file made…
-
Installing Oracle 12.1.0.2 RAC on Oracle Linux 7-part 1
Now that 12.1.0.2 is certified on RedHat Linux 7 and spin-off environments it’s time to test…
-
RAC One Node 12c-revisited on ODA 12.1.2.1.0 featuring database on ACFS
Thanks to Andy Colvin (@acolvin) and the Enkitec lab I have been able to get my…
-
Adventures in RAC: gc buffer busy acquire and release
It seems that I’m getting more and more drawn into the world of performance analysis, and…
-
UKOUG post conference geek update part 1 – ACFS for Oracle databases
One of the many interesting things I heard at the conference this time around was that…
-
Little things worth knowing: creating the Swingbench order entry schema “lights out”
This is a little note, primarily to myself I guess, about the creation of the order…