Rittman Mead - Delivered Intelligence

More details about the new Oracle 10G and Application Server 10G are becoming available the closer we get to Oracleworld, and it’s becoming clear that the ‘grid’ element of the new products is mainly an enhancement to the existing Real Application Clusters feature of 9i, with improvments to the way SQL statement are distributed amongst […]

There’s an interesting article over at informationweek.com about Java Server Faces, a proposed new standard for building browser-based interfaces in Java. According to the article
“The little-known Java Server Faces will provide a standard way to build user interfaces for Java Web applications and open the way for highly customized and specialized components to be plugged […]

A note on metalink advises that Analytic Workspaces built using Oracle 9i 9.2.0.3 will corrupt if the new 9.2.0.4 patchset is applied. According to the note;
“Please be advised that if you apply the 9.2.0.4.0 patch set to an OLAP 9.2.0.3 instance, previously functioning analytic workspaces may not be accessible after migration. It is our recommendation that OLAP […]

Standard Oracle relational theory tells you that, when putting data into a table, it doesn’t matter in which order you insert the data, as Oracle doesn’t guarantee the order in which it’s returned, unless you specifically use an ORDER BY clause. Therefore, you can’t rely on data coming back out from a table in the […]

If you’re serious about tuning an Oracle server, you’ll probably be familiar with STATSPACK, a set of Oracle-provided SQL, PL/SQL and SQL*Plus scripts which help you collect, store and analyze performance data over a period of time. Statspack primarily queries the performance v$ views and collects information on memory usage, I/O usage patterns, high resource […]

If you’re looking for some background reading on Oracle development, particulary to do with business intelligence and datawarehousing on Oracle 9i, i’ve put together a recommended reading list which you might find useful.

Ameed Taylor, Chair of the E-Business Suite Customization and Extension SIG within the Oracle Applications User Group, has started up a weblog on Oracle development.
Ameed’s aim is to try to keep his SIG members, and others with an interest in Oracle development, up to speed on the latest news etc relating to Oracle Development. Take […]

Oracle Discoverer is the primary query and reporting tool that I use on data warehousing projects, and the latest version, Oracle 9iAS Discoverer, comes bundled with the Oracle 9i Application Server. With release 2 of 9iAS, Discoverer uses the Single Sign-on server (known as SSO) within 9iAS to provide authentication and security. One thing that […]

Update on the 9i OLAP Spreadsheet Addin that was mentioned in a previous post.
Aneel Shenker has announced on OTN that a 9i OLAP Spreadsheet Addin will indeed be produced, and it’s due for release in beta form in October 2003. Functionality will be similar to the Express Excel Addin (i.e. it’ll feature a selector) but […]

SQL Plus has a useful command called COPY that until now I had no idea about. It’s an alternative to the IMP and EXP commands that lets you copy data between two SQL*Net connected databases.
Using the syntax
COPY FROM database TO database action - destination_table (column_name, column_name…) USING query
You can quickly copy data from one database […]