Clemens Bleile

opatch hangs while patching OEM 13.4. concerning the log4j-vulnerability

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(…)

Script to calculate the network latency between the application and the Oracle DB-server

By Clemens Bleile Network latency is crucial for applications, especially if lots of “row by row”-processing (some call it “slow by slow”-processing) is used by the application or if lots of data is transported between the database and the application.

MacOS: Reduce fan noise when using Microsoft Teams

The Laptop I’m using for the business is a MacBook Pro, model 2019 (2.6 GHz 6-Core Intel Core i7). I’m thankful to be able to choose the Hardware and OS of my business laptop at dbi services. We have collegues(…)

Exadata Cloud at Customer: Considerations for Backup & Recovery

Working in a project where the customer migrates from an on-premises environment to Exadata Cloud at Customer provides insights about the decisions to take and what to consider when using the Exadata Cloud at Customer environment. In a series of(…)

ODA 19.11.: ORACLE_HOMEs on ACFS

Introduction Beginning with Oracle Database Appliance (ODA) 19.11. the ORACLE_BASE and ORACLE_HOMEs are created on ACFS. That’s good news, because there is much more space on ASM than on the internal disks, i.e. no space issues with /u01 anymore. So(…)

Creating an Oracle Snapshot Copy PDB on top of ASM

Creating a snapshopt copy Pluggable Database (PDB) on top of Automatic Storage Management (ASM) is not possible, because you need to have a filesystem which supports sparse files. According the following MOS-Note sparse files are supported on Automatic Storage Management(…)

Parameterized Views with SYS_CONTEXT in Oracle. How can the optimizer peek values?

There was a dicsussion a couple of years ago about a mssing feature in Oracle that the Optimizer is not peeking values when SYS_CONTEXT is being used in a predicate. I.e. specifically when using SYS_CONTEXT in Views to simulate passing(…)

Adding nmon to Oracle OSWatcher

nmon (nmon is short for Nigel’s performance Monitor for Linux on POWER, x86, x86_64, Mainframe & now ARM (Raspberry Pi)) is a nice tool to monitor a Linux system. Originally it came from the AIX-platform, where it is very(…)

Oracle Blockchain Tables: COMMIT-Time

Oracle Blockchain Tables are available now with Oracle 19.10. (see Connor’s Blog on it), they are part of all editions and do not need any specific license. I.e. whenever we need to store data in a table, which(…)

Oracle autoupgrade on Windows and plugin to a Container DB with virtual accounts

In a project I recently had to upgrade an Oracle 12.2.-DB to 19.9. and at the same time migrate from the non-container architecture to the container architecture. The interesting part here is to do this on Windows. Actually both steps(…)