Now that Oracle Database 11g Release 2 is out, more and more folks are considering upgrading to 11g. However, if you are currently on Oracle 9i then you will have to tackle both the upgrade to a new release and the migration from the Rule-Based Optimizer (RBO) to the Cost-based Optimizer (CBO). The RBO was [...]
I returned from OAUG/Collaborate with a cold and multiple overlapping development crises. Fun. Now that those are (mostly) out of the way, it’s time to get back to clearing out my article backlog. Premier Support for the 10gR2 database ends in July 2010. If you haven’t already started planning your 11g database upgrade, we recommend [...]
Last time I wrote about the use of replication to provide a source for realtime BI. This time I am going to look at putting data in to a data warehouse in “realtime”. Note the quotes, when we speak of realtime there is always some degree of latency: the time from the source transaction to [...]
This posting is slightly edited to clarify that the majority of the post is about using transactional or transactionally structured sources for reporting. One of the points I make early on in my talk “Getting Real Data Warehouse Loading as it Happens” is that realtime business intelligence is not the same as realtime data warehousing; [...]
Now that Oracle Database 11g Release 2 is out, more and more folks are considering upgrading to 11g. However, if you are currently on Oracle 9i then you will have to tackle both the upgrade to a new release and the migration from the Rule-Based Optimizer (RBO) to the Cost-based Optimizer (CBO). The RBO was [...]
We promised in an earlier post to cover some of the questions from the Optimizer round table discussion at Oracle Open World. Here’s our first in a series of posts that will address these questions. Q: When moving from 10g to 11g, should hints in existing SQL be removed? A: I was glad to see [...]
The Word from the Web – 11/20/2009 We’re winding down our Around the World series for this year. Take a look at some of the latest nuggets from the 2009 show. If you’ve been part of a discussion that’s been going since the It’s a Wrap party, let us know about it in the comments. [...]
Last week the patchset 10.2.0.4 was released by Oracle. This patchset not only contains bugfixes but also comes with a number of New Features. One of the highlights is the possibilty to capture a workload in a 10.2.0.4 database and ship it to an 11g database for testing. Only with this feature in … Link [...]
Leng Leng Tan announced in her presentation yesterday, that patchset 10.2.0.4 which will be available very soon!!! which will allow to mask sensitive data in a captured workload so it is not possible to read the data in plain in the testing environment, but still run the workload for testing anyway. This will definitively make … Link to the [...]
I’ve been meaning to write up my thoughts from this years IOUG Collaborate event. Ian Abramson, the president of the IOUG, has a nice series of write ups on the event itself – starting with day 1 through day 3 and then a wrap-up post. He describes it as a three day event – but [...]