Oracle Warehouse Builder (OWB) Weblog

OWB 11gR2 – Cube Organized Materialized Views

By david.allan on October 25, 2009 9:16 PM

Here we will look at building cube organized materialized views for a relational fact table. The illustration uses the Oracle OLAP 11g Sample Schema and rather than the cube organized materialized views being created via the script in the demo,...

| TrackBacks (0)

OWB 11gR2 – Bulk File Loading - more, faster, easier

By david.allan on October 15, 2009 7:11 AM

A common problem in warehouses is to load a number of similar files into the database, often the filenames are dynamic so the names cannot be hard-wired, if they are known its easy enough to configure the external table or...

| TrackBacks (0)

Batch unload and remote agents

By david.allan on September 26, 2008 11:02 AM

This post illustrates natively unloading from other database systems such as Microsoft SQL Server using the Oracle 11g database scheduler's remote agent. This is all driven from the database via PLSQL api calls. The package relies on installing the lightweight...

Comments (1) | TrackBacks (0)

Performance tuning mappings

By david.allan on May 29, 2008 3:57 PM

You can leverage the standard Oracle tuning tools for investigating set based SQL performance and PLSQL performance. There are reports in the utility exchange (see here) for reporting on the results after using the DBMS_PROFILER.The PLSQL profiles can be queried...

| TrackBacks (0)