Martin Bach
-
Little things worth knowing: Is there a penalty in establishing a connection to Oracle using the MAA connection string? Part 2
In the very lengthy previous post about the MAA connect string I wanted to explain the…
-
Little things worth knowing: Is there a penalty in establishing a connection to Oracle using the MAA connection string?
Sorry for the long title! I had a question during my session about “advanced RAC programming…
-
Little things worth knowing: what does opatchauto actually do?
I recently applied system patch 20132450 to my 12.1.0.2.0 installation on a 2 node RAC system…
-
Little things worth knowing: direct path inserts and referential integrity
This is another post to remind myself that Oracle evolves, and what I thought I knew…
-
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…
-
Understanding enhancements to block cleanouts in Exadata part 2
In part 1 of the series I tried to explain (probably a bit too verbose when…
-
Understanding enhancements to block cleanouts in Exadata part 1
Travel time is writing time and I have the perfect setting for a techie post. Actually…
-
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…