Infrastructure at your Service
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…
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…
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…
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…
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…
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…
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…
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…
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 —————————————————————–…
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…
