Database Administration & Monitoring, Oracle How to configure Linux Server to run Oracle Database 19c on Persistent Memory 04.02.2022 by Oracle Team Introduction to Persistent Memory In the last few years, storage media have become more and more advanced and faster. Today, SSD disks are almost standard as storage and if an Oracle database really has an I/O critical workload, nvme storage(…)
Application integration & Middleware, Oracle ORDS with TNS 02.02.2022 by Alain Lacour The aim of that blog is to look into Oracle REST Data Services (ORDS) DB connection with TNS. This is following some experience at a customer who wanted to move to latest version of ORDS with APEX(…)
Database Administration & Monitoring, Database management, Development & Performance, Oracle Oracle Partition and Performance of massive/concurrent Inserts 24.01.2022 by Oracle Team For a customer, I had to check if partitioning improves performance of massive and concurrent inserts. The goal is to execute several Inserts in parallel via dbms_parallel_execute package (my previous blog “parallelize your Oracle Insert with DBMS_PARALLEL_EXECUTE” explains how(…)
Database Administration & Monitoring, Database management, Operating systems, Oracle Clone Oracle 21c Home 24.01.2022 by Oracle Team By Mouhamadou Diaw When deploying new Oracle Home on the same server or on a new server, you may use the downloaded Oracle binaries and do an install from scratch as usual. You may then apply any patch you have(…)
Oracle Oracle Database Appliance (ODA): Adjusting to the new ORACLE_BASE-setting from 19.11. onwards 21.01.2022 by Clemens Bleile By Clemens Bleile From Oracle Database Appliance (ODA) version 19.11. onwards the ORACLE_HOMEs and ORACLE_BASE will be created on ACFS, i.e. take space from an ASM-diskgroup instead of taking filesystem space from /u01. See this blog concerning details. If(…)
Database Administration & Monitoring, Database management, Operating systems, Oracle ODA KVM Machines : Adding a Network Interface on a Virtual Machine 20.01.2022 by Oracle Team By Mouhamadou Diaw In a previous blog , I was talking about virtual machines on ODA servers. Sometimes it comes that we want to add another network interface for other purpose. In this blog I(…)
Database Administration & Monitoring, Database management, Development & Performance, Oracle Statspack with Oracle Database 19c and Multitenant 17.01.2022 by Jérôme Dubar Introduction When it comes to performance analysis on Oracle databases, everybody think about Diagnostic Pack. This is a very complete tool and it brings much more metrics than a DBA can analyze. But there is a big drawback with this(…)
Cloud, Database Administration & Monitoring, MariaDB, MySQL, Oracle What I really like about Percona PMM 14.01.2022 by Elisa Usai Percona Monitoring and Management tool (PMM) is an Open Source product which was developed to help DBAs and developers to monitor and manage MySQL, PostgreSQL and MongoDB performances. In this blog post, we will see that we(…)
Database Administration & Monitoring, Database management, Oracle Oracle 21C Security : diagnostics_control and enable diagnostics 12.01.2022 by Oracle Team By Mouhamadou Diaw Some debug-events and debug-actions are not safe and should be exposed to users with caution. In previous releases, privilege control for the usage of these diagnostics was not sufficient. With Oracle 21c, regular users can be blocked(…)
Oracle opatch hangs while patching OEM 13.4. concerning the log4j-vulnerability 29.12.2021 by Clemens Bleile By Clemens Bleile To address the log4j-vulnerability I recently had to fix the Oracle Enterprise Manager 13.4.-installation for a customer. REMARK: Please check the following link for details concerning the log4j-vulnerability and how Oracle is affected: alert-cve-2021-44228 and(…)