Oracle datapump Internals

In this series we’ll share the internals of the Oracle datapump, how to improve performance of a datapump job, how to monitor datapump jobs, how to read the header information from the dump file. Please feel free to comment if you want any other details regarding datapump to be covered. Datapump Architecture & Internals. How…

Oracle datapump Architecture & Internals

Oracle Datapump was introduced with 10gR1 as a replacement to the classic export/import utilities. In this post we’ll go through the internals of Datapump to see how it works. Oracle added two new packages DBMS_DATAPUMP & DBMS_METADATA which forms the base for the datapump export import operations. So either you use the command line functionality or…

Listener Issues ORA-12505/TNS-12505 or ORA-12514/TNS-12514

This post details how to resolve listener connection issues when DB & listener are started but still connect fails with following errors:- ORA-12505 TNS:listener could not resolve SID given in connect descriptor TNS-12505 TNS:listener could not resolve SID given in connect descriptor ORA-12514 TNS:listener could not resolve SERVICE_NAME given in connect descriptor TNS-12514 TNS:listener could…

12c New Features – Database In-Memory

Here comes the most awaited feature with the release of 12.1.0.2 patchset – Database In-Memory. In this post we will first dwell upon the internals of this feature and then enable this feature in our test environment to benchmark the performance gain. This article assumes that the reader is well aware of the Oracle 11g Memory…