Eclipsys recently completed an SQL Performance Tuning Workshop for a major Canadian Insurance Provider

Eclipsys recently completed an SQL Performance Tuning Workshop for a major Canadian Insurance Provider – not only making recommendations to them on how to make things run faster but also teaching their staff how to do so themselves in the future. #teachamantofish https://eclipsys.ca/what-we-do/oracle-technology-services/oracle-database/… read more

Linux LVM for Oracle Database on OCI

Oracle Database as a service (DBCS) on Oracle Cloud Infrastructure (OCI) had been traditionally built based on Oracle Grid Infrastructure with ASM as the main storage layer for the database, however Oracle recently has started to offer a Linux LVM as the storage alternative. Which option is the better alternative? Let’s review some of the… read more

Oracle OCI Database service storage allocation

Today I would like to discuss the block storage allocation in a VM based Oracle DBCS system. Several times in different conversations it was mentioned that the block storage will be allocated with triple redundancy on the ASM level. Let’s check it out. If we try to allocate the minimum size volume 256GB for an… read more

GoldenGate : setup Bi-Directional Replication in Multitenant environment (PDBs)

Intro GoldenGate replication solution allows you to capture, replicate, filter, transform, and deliver real time transactional data across Oracle or heterogeneous environments. Goldengate 12c features along with Oracle multitenant architecture introduced some changes to the way replication works (see Fig-1). Another interesting fact is that few of Oracle Streams features have now found their way… read more

Known issues with upgrading ODA to 18.3 and how to avoid them

Recently, when I worked on upgrading ODA X7-2 S/M/L from version 12.2.1.4.0 to version 18.3.0.0.0. I hit two known issues after patching server components. Issue# 1: Onboard public network interfaces do not come up after patching or imaging. Issue# 2: Upgrading to 18.3 can automatically result in ADVM processes consuming Excessive CPU and IO during… read more