Rittman Mead - Delivered Intelligence

Much of my work involves designing and reviewing dimensional data models, and an interesting issue that often comes up is how to deal with data items such as invoice number, order number and so on, that are not strictly facts – you’re not going to want to add them up, or average them, or perform [...]

Niall Litchfield has started a site on working with the Oracle database. I met Niall at the last UKOUG conference and he seems like an all-round nice guy; check it out when you get a chance.

More news on the Oracle 9i 9.2.0.5 patchset, and it’s suitability for Oracle OLAP users. Anthony Waite confirms in an OTN OLAP Forum posting that the 9.2.0.5 patchset contains all of the functionality in the previous 9.2.0.4 patchset, and the 9.2.0.4.1 OLAP-specific patchset. As there are no API changes in the 9.2.0.5 release, existing tools [...]

"Larry Ellison, CEO of Redwood Shores, Calif.-based Oracle, and Michael Dell, chairman and CEO of hardware giant Dell, joined forces during a conference call with journalists and analysts Tuesday to announce that Dell will offer Oracle’s Standard Edition One database prepackaged on Dell PowerEdge 2600 or 2650 servers running on Linux and Microsoft Windows. Dell [...]

Even if you have done a superb job in installing and configuring Oracle9iAS, if the system is not always available or if the performance is poor, then you need to start looking at tuning and optimising your 9iAS instance. Being complex, an Oracle9iAS environment has a huge amount of tuning opportunities,  which essentially boil down [...]