Infrastructure at your Service

All Posts By

Lazhar Felahi

Lazhar Felahi

SELECT FROM DUAL : Oracle Performance And Tuning

By | Database Administration & Monitoring, Development & Performance, Oracle | No Comments

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 for example SYSDATE, USER or HOSTNAME. Querying DUAL table is generally faster  as we can see below: SQL> select sysdate from dual; SYSDATE ——— 05-OCT-21 Elapsed: 00:00:00.01 Execution Plan ———————————————————- Plan hash value: 1388734953 —————————————————————–…

Read More
Lazhar Felahi

From Oracle Standard Auditing to Oracle Unified Auditing

By | Database Administration & Monitoring, Database management, Oracle | No Comments

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 a multitenant environment Oracle 12c – RMAN and Unified Auditing – Does it really work ? Purging Unified Audit Trail in 12cR2 I just want to share with you the steps needed to move from Standard Auditing…

Read More
Lazhar Felahi

Oracle Data Integrator Cloud

By | Application integration & Middleware, Cloud, Database Administration & Monitoring, Enterprise content management, Oracle | No Comments

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 in the sense it integrates data in a different orders. ODI is known as en E-LT because it Extracts data from the source system and Loads and Transforms data into the target system while traditional…

Read More
Lazhar Felahi

How to migrate Oracle Reports to Oracle BI Publisher ?

By | Application integration & Middleware, Oracle | No Comments

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 customers can migrate to Oracle BI Publisher (Oracle official tool for oracle reporting) at their own place while continuing to receive extended support as specified by the Oracle Reports Statement of Direction. Oracle BI Publisher provides…

Read More
Lazhar Felahi

Migrate Oracle Database 9.2.0.6 to Oracle 19c using GoldenGate

By | Application integration & Middleware, Database Administration & Monitoring, Oracle | 5 Comments

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 out of support (final 9.2 patch was Oracle 9.2.0.8). The customer Operating Systems was AIX 7.4 and only Oracle GoldenGate 11.1.1.1.2 for Oracle 9.2 for AIX 5.3 is available on https://edelivery.oracle.com. The Patch 13606038: ORACLE…

Read More
Lazhar Felahi

Oracle REST Data Services – Create Web Services

By | Database Administration & Monitoring | No Comments

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 Web Services using PL/SQL and a browser Rest Client.. My sources are : Oracle REST Data Services documentation.  Thatjeffsmith. oracle-base. First, let’s try to REST the schema/tables “HR/EMPLOYEES” using the Auto REST feature. Auto REST feature…

Read More
Lazhar Felahi

Oracle REST Data Services – Installation and Configuration

By | Database Administration & Monitoring | 5 Comments

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 from the Thatjeffsmith website. The first step is to download the last version of ORDS from the Oracle REST Data Services download page. Unzip the zip file into a directory (or folder) of your choice :…

Read More
Lazhar Felahi

Oracle Data Pump Integration for Table instantiation with Oracle Golden Gate

By | Database Administration & Monitoring, Oracle | No Comments

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 CSN is then applied to system tables and views on the target database on the import. These views and system tables are referenced by Replicat when applying data to target database. This 12.2 feature, no…

Read More
Lazhar Felahi

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

By | Application integration & Middleware, Database Administration & Monitoring, Oracle | No Comments

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 behaviour occurs with Oracle GoldenGate Classic architecture.   Let’s start with the creation of the Extract process by clicking on the plus button :   Choose Integrated Extract and click on Next button: Fulfill all…

Read More
Lazhar Felahi

How to use DBMS_SCHEDULER to improve performance ?

By | Database Administration & Monitoring, Development & Performance, Oracle | 3 Comments

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 my example, the metadata table does not contain “directly” the data but a set a of sql statement to be executed and for which the rows returned must be inserted into the target table My_Target_Table_Serial…

Read More