SPM and schema virtualization

I received a lot of feedback and a fair number of good questions on my session on SQL Plan Management for the
0 comment

Gartner releases its 2014 Magic Quadrant for x86 Server Virtualization Infrastructure

Gartner has released its annual Magic Quadrant for x86 Server Virtualization Infrastructure, again positioning VMware and Microsoft in the leaders Quadrant. Leaders in this market have a clear strategy...
0 comment

OTN Virtual Technology Summit

On July 9th, 2014, I presented for the Oracle Technology Network Virtual Technology Summit. My first presentation was in the Systems track titled, “Troubleshooting Techniques and Alternative Methods...
0 comment

Invoker Rights in Oracle Database 12c : Some more articles

I wrote about the Code Based Access Control (CBAC) stuff in Oracle Database 12c a while back. Code Based Access Control (CBAC) : Granting Roles to PL/SQL Program Units in Oracle Database 12 Release 1...
0 comment

Oracle Linux and MySQL : Progress

A few months ago I wrote about some MySQL on Oracle Linux migrations we were working through. It’s been a long time coming, but last weekend was the go-live for this batch of migrations. So far so...
0 comment

Pro-active AWR Data Mining to Find Change in SQL Execution Plan

Many times we have been called for the poor performance of a database and it has been narrowed down to a  SQL statement. Subsequent analysis have shown that the execution plan has been changed and a...
0 comment

SQL Plan Baselines

Here’s a thread from Oracle-L that reminded of an important reason why you still have to hint SQL sometimes (rather than following the mantra “if you can hint it, baseline it”). I have...
0 comment

Adjusting Histograms

This is a quick response to a question on an old blog post asking how you can adjust the high value if you’ve already got a height-balanced histogram in place. It’s possible that someone...
0 comment

Release: Oracle VM 3.3

Oracle has released version 3.3 of its enterprise virtualizatoin solution. The virtualization solution is available for both x86 and SPARC based processor architectures and uses the Xen hypervisor technology,...
0 comment

Design for complex ATG applications

Overview Needless to say, some ATG applications are more complex than others.  Some ATG applications support a single site, single language, single catalog, single currency, have a single development...
0 comment