Since version 1.5 the Oracle SQL Developer has the capability to view and analyze raw trace files in an interactive way. In this blog post, I will demonstrate how to use this very unknown feature.
Continue readingTag: tracing
Generate DBMS_DATAPUMP script using Data Pump trace
Starting with Oracle 10g, Data Pump can be used to export and import database objects using command-line tools expdp and impdp. Calls of these tools are mapped to the Data Pump API within the database. This blog post will demonstrate how to generate DBMS_DATAPUMP calls based on an expdp/impdp execution.
Continue reading