Posts

ETL process and concepts

Master Data Management (MDM)

Slowly Changing Dimensions and Surrogate Keys.

ACID properties of DB.

NULLS LAST

UTL_FILE.

SYS_GUID.

Global Temporary Tables.

SQL Trace facility and TKPROF

DBMS_TRACE

DBMS_PROFILER

The V$ Dynamic Performance Views

Oracle Data Dictionary