(Andrejus Baranovskis) ADF 12c offers completely new way to implement UI forms. We can implement dynamic forms, based on static ADF BC components. Such approach could simplify form maintenance – when there will be changes in DB, developer would need to adjust only ADF BC EO/VO structure, without cha

(Neil Chandler) Prior to Oracle 12C, if you wanted to page through result sets only returning a bit at a time, or only wanted the first dozen lines of data, it was a right pain. Writing your SQL, then having it as an in-line view with order by, and a rownum on the outer view.

(Michael McLaughlin) Using Oracle’s Resource Manager requires you to understand the IO dynamics. The first step requires you to run the CALIBRATE_IO procedure from the DBMS_RESOURCE_MANAGER package.

(Andrejus Baranovskis) ADF 12c offers completely new way to implement UI forms. We can implement dynamic forms, based on static ADF BC components. Such approach could simplify form maintenance – when there will be changes in DB, developer would need to adjust only ADF BC EO/VO structure, without cha

(Neil Chandler) Prior to Oracle 12C, if you wanted to page through result sets only returning a bit at a time, or only wanted the first dozen lines of data, it was a right pain. Writing your SQL, then having it as an in-line view with order by, and a rownum on the outer view.

(Michael McLaughlin) Using Oracle’s Resource Manager requires you to understand the IO dynamics. The first step requires you to run the CALIBRATE_IO procedure from the DBMS_RESOURCE_MANAGER package.

(Hemant K Chitale) Here are a few methods to trace another session to capture SQL statement executions. All of these methods require the appropriate privilege — which most DBAs seem to mean using SYS (which logs in AS SYSDBA). I leave it to you to discover the privilege — save to say that you d

(Tanel Poder) In the previous article I explained that the main requirement for high-speed in-memory data scanning is column-oriented storage format for in-memory data. SIMD instruction processing is just icing on the cake. Let’s dig deeper. This is a long post, you’ve been warned.

(Natik Ameen) By default, a Replicat process ABENDS when the data being modified doesn’t exist in the target database. Learn how to troubleshoot Oracle GoldenGate Using Exception Handler mechanism.

(Hemant K Chitale) Here are a few methods to trace another session to capture SQL statement executions. All of these methods require the appropriate privilege — which most DBAs seem to mean using SYS (which logs in AS SYSDBA). I leave it to you to discover the privilege — save to say that you d