Oracle
-
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…
-
Concurrent statistics gathering in 12.1.0.2
Prompted by an actual task at hand I spent some time investigating an 11.2.0.2 feature – concurrent…
-
Little things worth knowing: ORACLE_SID, instance_name and the database names in Clusterware
If you ever wanted to know how Clusterware works with registered database resources, read on! It…
-
Interesting observations executing SLOB2 with ext4 and xfs on SSD
My lab server has 2 SSDs, one is connected using SATA 2 and another is connected…
-
Exadata and Virtual Private Database: will it offload my query?
During one of the classes I taught about Exadata optimisations I had an interesting question: If…
-
Little things worth knowing-troubleshooting parallel statement queueing
This is yet another one of these posts that hopefully help you as much as they…
-
Interesting observation about standby redo logs in Data Guard
Some of you might have followed the discussion around the number of standby redo logs on…
-
Can you have high redundancy files in a normal redundancy diskgroup?
One of the perks of teaching classes is that I get to research questions asked. In…
Martins Blog 