Rittman Mead - Delivered Intelligence

"I am trying to link 2 databases through Business Objects to enable Bus Obs users to run their own reports (querying data from both databases ‘simultaneously’) and have reached a stumbling block because (as I’m sure you’re aware) database links between Oracle and another database (SQL Server in this instance) is an ‘elaborate’ process which, [...]

DBAZine are currently running an extract from Dennis Shasha and Philippe Bonnet’s book, "Database Tuning: Principles, Experiments, and Troubleshooting Techniques" on data warehouse tuning and optimisation. The extract looks at how data warehouses differ from transactional databases, and how they are tuned for optimal performance.

A problem that often seems to happen when Oracle 9iAS 9.0.2 crashes is that you can’t seem to restart OID using OIDCTL. For example, a situation might arise when a server is bounced without 9iAS being shut down cleanly. When you reboot the PC, and use DCMCTL to check the status of the OC4J instances [...]

One question I’m often asked is "Apart from the inclusion of Oracle OLAP and Oracle Data Mining, what are the benefits of upgrading an Oracle 8i database to Oracle 9i?". Well, I recently came across an article on this subject by Don Burleson, which is worth taking a look at to get a high level [...]

“Once again, marketing alchemists have cooked up a bowl of confusion with only a few simple ingredients. Everyone in the business intelligence (BI) space is wild about dashboards, but few proponents are talking about the same thing.” writes Stephen Few for IntelligentEnterprise.com.