I’ve just found out over the past couple days that a nomination for me to be made an Oracle ACE Director has been accepted by Oracle Corporation. It’s always pleasing to have your efforts acknowledged and appreciated by the Oracle community and so it’s really nice to be recognised in this manner by Oracle.
The Oracle ACE Program was setup a [...]
11g has many new and potentially useful features which I’m slowly investigating and evaluating.
One feature that has the potential to be particularly useful where I work is “Oracle Total Recall“. It provides the facility to automatically capture all changes to any tables you choose, in a “secure, tamper proof” manner. This enables all changes to [...]
Cary Millsap has written a great blog entry, A Lesson In Writing From 1944. It’s a fascinating read regarding letters written by General Eisenhower prior to the D-Day Normandy landings in dark 1944 and how they were subtly modified by the author from “Passive” to “Active” voice. Cary then very nicely discusses how the use of active voice [...]
I write this post whilst listening to Pink Floyd’s masterpiece “The Dark Side Of The Moon” while sadly lamenting the passing away of Richard Wright. RIP and thank you for all the great musical gifts you’ve given me over the years.
In my last post I highlighted an example of where Index Monitoring doesn’t show how [...]
One of the questions asked of indexes is are they actually being used or are they sitting there looking pretty not being used, wasting valuable resources and storage.
One possible method of determining whether an index is being used is to set the MONITORING USAGE attribute of the index. This will place the index in the v$object_usage [...]