(Andrew Reid) For a long time I have had a note on my task list to learn about index organized tables. I never got round to doing it because I thought I would never see one. However, I came across several in a 3rd party application recently.

(Luc Bors) In this post I describe how I implemented an interesting Use Case where the customer wanted to have an alternate message in the LOV when there is no data found.

(advait) Latches are low level serialization mechanism which protects memory areas inside SGA. They are light wait and less sophesticated than enqueues and can be acquired and released very quickly.

(connormcdonald) As a DBA, its awesome when you have the Partitioning option at your disposal. So many cool things suddenly become either possible or easier. For example, all of a sudden you can separate the data of different time ranges into different partitions.

(Jsavit) The previous article in this series described goals for virtual machines in the cloud, and CPU and memory recommendations to help achieve them. This article will go into more detail for Oracle VM Server for x86 CPU and memory management:

(Tariq Farooq, Sridhar Avantsa, Guy Harrison, Syed Jaffar Hussain, Charles Kim and Nitin Vengurlekar) The Exadata Database Machine combines Flash solid-state disks with more -traditional magnetic disks in order to achieve economic storage of large datasets together with the ability to achieve low la

(Hemant K Chitale) I received a question about why Trace Files are useful.

(Stefan Knecht) Oracle 12c introduced a new capability to move a partition online, without any interruptions to DML happening at the same time. But, there’s a catch. So far we’ve been able to use basic table compression without having to worry about any extra licensing – it was just a plain EE featu

(Jeff Smith) I went to link to this post earlier today, and was shocked to discover I hadn’t actually written it yet.

(Dan Hotka) Dan Hotka introduces his video course in this excerpt from Oracle SQL Performance Tuning for Developers LiveLessons (Video Training), Downloadable Version.