Oracle Warehouse Builder (OWB) Weblog

Table Functions as Source and Target

By david.allan on June 3, 2008 12:13 AM

Using table functions is a useful way to both boost performance and extend the source/target capabilities in OWB. Here we will see how to setup table functions as a source and a target in OWB. Table functions let you define...

| 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)