Infrastructure at your Service

Tag

Oracle Archives - Blog dbi services

Lazhar Felahi

Parallelize your Oracle INSERT with DBMS_PARALLEL_EXECUTE

By | Database Administration & Monitoring | No Comments

One of the challenge of all PL/SQL developers is to simulate the Production activity in a Non Prod. environment like for example different Insert executed by several sessions. Different tools exist like Oracle RAT (Real Application Testing) but under license or you can create your own PL/SQL package using DBMS_SCHEDULER or DBMS_PARALLEL_EXECUTE packages. The aim of this blog is to show you how to use DBMS_PARALLEL_EXECUTE to parallelize several INSERTS commands through different sessions. My…

Read More
Marc Wagner

Upgrade AHF and TFA on an ODA

By | Oracle | 4 Comments

TFA (Trace File Analyzer) is part of AHF (Autonomous Health Framework). Those tools are preinstalled and part of ODA (Oracle Database Appliance). As you might know patching and upgrading are normally always going through ODA global Bundle patches. AHF can, without any problem, be upgraded independently. In this blog I wanted to share with you how I upgraded TFA with latest v21.4 version. The upgrade is performed with root user. This version addresses CVE-2021-45105/CVE-2021-44228/CVE-2021-45046. For…

Read More
Joël Cattin

When unreachable NFS share mess up your Dbvisit Standby configuration

By | Database management, Hardware & Storage, Operation systems, Oracle | No Comments

If I had to rank my favorite Oracle-related tools and software, Dbvisit Standby would likely be at the top of the list. You are reading this post, so you probably know that Dbvisit Standby is a Disaster/Recovery solution for Oracle Database Standard Edition (aka Data Guard for poor people 😛 ). The reasons why I like this product are mostly related to the following points (non-exhaustive list) : Ease of installation and configuration Ease of…

Read More
Jérôme Dubar

Move a PDB from a server to another one using NFS

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

Introduction Multitenant brings new possibilities regarding Oracle databases, and one of them is to move a database from a container to another quite easily. When containers are on the same server, it’s very easy, but when the containers are on different servers, you will need to use a database link or an RMAN restore. But there is also another solution if you don’t want to use the previous ones: using a NFS volume. Test lab…

Read More
Jérôme Dubar

5 things that aren’t true about RMAN

By | Database management, Oracle | No Comments

Introduction RMAN backups are not a hot topic today. This is because it didn’t evolve that much in 12c/18c/19c, and most of the databases are now protected by a good backup strategy since years, and no changes are needed. Furthermore, Disaster Recovery solutions are more and more deployed, and all the flashback technologies embeded in the database are well known. This has pushed the need for RMAN restore to the very latest option in case…

Read More
Lazhar Felahi

Improve Oracle Insert Performance with BULKCOLLECT and FORALL

By | Database Administration & Monitoring | No Comments

As specified by Steven Feuerstein into the Oracle Blog Website the bulk processing features of PL/SQL are designed specifically to reduce the number of context switches required to communicate from the PL/SQL engine to the SQL engine. Using BULK COLLECT plus FORALL instead of standard Insert statement to insert data improve performance dramatically, let’s me show you : Here is a customer case on how using BULK COLLECT plus FORALL to improve Insert operations for…

Read More
Alain Fuhrer

DataPump and the Transform option – Not very well known, but it can be useful

By | Database Administration & Monitoring | No Comments

I work with Oracle Databases and Datapump for more than 10 years but still I find some datapump options that I did know and in some cases can be very helpful. For a customer we did a migration of a 2TB database from AIX to Linux which means we had to change the endianness of the data. We decided to perform the Migration with Full Transportable database, convert the database files with rman and afterwards…

Read More
David Hueber

ODA update-server to 19.12 fails on Patch GI with RHP

By | Database Administration & Monitoring, Hardware & Storage, Operation systems, Oracle | No Comments

Sometimes giving a workshop is a good opportunities to test new things…this what happened to me today…  🙂 While giving an ODA workshop, I thought it was a good opportunity to test patching to the new 19.12 release. However during the update-server process we got a failure on the our ODA update to 19.12 failing on GI patch using RHP. Let’s see how we fixed it…

Read More
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
Marc Wagner

Nutanix Era with oracle databases : Part 1 – Introduction

By | Oracle | No Comments

I’m currently setting up a lab for Nutanix Era in order to be able to provide some presentation on this subject and see how Nutanix Era interacts with Oracle databases. I therefore thought it would be certainly helpful and a good opportunity to share the feedback I’m getting from this experience. The lab has been built using Nutanix Cluster free trial integrated with our AWS Cloud account. This fist blog intends to provide only a…

Read More