BE SHARING

Lazhar Felahi

SELECT FROM DUAL : Oracle Performance And Tuning

05.10.2021 by Lazhar Felahi

The DUAL table is automatically created by Oracle and contains one column (DUMMY) and one row (x value). This table is often used by SQL developer in PL/SQL code (Package, Functions, Trigger) to initialize variables storing technical information such as(…)

Database Administration & Monitoring

From Oracle Standard Auditing to Oracle Unified Auditing

05.10.2021 by Lazhar Felahi

In this post, I will not show you all advantages related to Oracle Unified Auditing. For that, read the oracle documentation. You can also read the blogs written by my colleagues : Oracle 12c Unified Auditing Feature in(…)

Application integration & Middleware

Oracle Data Integrator Cloud

24.03.2021 by Lazhar Felahi

Data and applications integration is always a technical challenge for most of the companies. All data integration tool ensures that information is timely, accurate, and consistent across complex systems. Oracle Data Integrator (ODI) is different than traditional data integration tools(…)

Application integration & Middleware

How to migrate Oracle Reports to Oracle BI Publisher ?

14.03.2021 by Lazhar Felahi

According to the Oracle Lifetime Support Policy , Oracle is not planning any functional enhancements for Oracle Reports in its terminal release, or any subsequent releases. Oracle Fusion Middleware 12cR2 (12.2.1.3.0) will be Oracle Reports terminal release. Oracle Report(…)

Application integration & Middleware

Migrate Oracle Database 9.2.0.6 to Oracle 19c using GoldenGate

30.12.2020 by Lazhar Felahi

When a customer wanted to take the challenge to migrate an oracle database 9.2.0.6 (the prehistory in the Oracle world) to Oracle 19c using Oracle GodenGate, I saw more problems than add value for different reasons: Oracle 9.2.0.6 database is(…)

Database Administration & Monitoring

Oracle REST Data Services – Create Web Services

08.09.2020 by Lazhar Felahi

In my previous blog Oracle REST Data Services – Installation and Configuration : We have installed ORDS in standalone mode. Configured ORDS to be administer by SQL Developer In this blog, we will explain how to create simple RESTful(…)

Database Administration & Monitoring

Oracle REST Data Services – Installation and Configuration

07.09.2020 by Lazhar Felahi

The goal of this blog is to install and configure Oracle REST Data Services 19.2 in Standalone mode into an oracle database 12.2. The official documentation is stored here and you will find a lot of resources and examples(…)

Database Administration & Monitoring

Oracle Data Pump Integration for Table instantiation with Oracle Golden Gate

19.08.2020 by Lazhar Felahi

From Oracle GoldenGate (OGG) version 12.2 and above, there is a transparent integration of OGG with Oracle Data Pump as explained in the Document ID 1276058.1. The CSN for each table is captured on an Oracle Data Pump export. The(…)

Application integration & Middleware

Oracle GoldenGate 19c: Cannot register Integrated EXTRACT due to ORA-44004

29.06.2020 by Lazhar Felahi

The global_name in an oracle database has a direct impact on the Golden Gate Extract process registration we need to do when we create an Integrated Extract. In my example below, I use Oracle GoldenGate MicroServices architecture but the same(…)

Database Administration & Monitoring

How to use DBMS_SCHEDULER to improve performance ?

24.05.2020 by Lazhar Felahi

From an application point of view, the oracle scheduler DBMS_SCHEDULER allows to reach best performance by parallelizing your process. Let’s start with the following PL/SQL code inserting in serial several rows from a metadata table to a target table. In(…)