21. 02. 2020.

External C procedures – how to setup and performance boost you can expect

In this post I’ll explain what you need to do to setup external C procedure call with Oracle 18c. I’ll also show for a CPU intensive task, what performance boost you might expect. For those of you who remember how difficult it was to configure LISTENER and TNSNAMES to work with C external procedures, will […]

14. 01. 2020.

Oracle Multiversion Read Consistency and its impact on ETL

Imagine you need to create an ETL workflow that uses the Oracle database as one of its sources or even more common situation where you need to synchronize local table with table from the remote Oracle database via dblink. The most common scenario is to apply the following steps: I have a local table for […]

10. 01. 2020.

Case for using unusable index

I work with Oracle more than I can remember, but every day I find something new. This time I’m asked to drop one index on the production system, which is the simplest task you can get, right? I new there had to be a problem with that, otherwise someone else would do it. In any […]

07. 01. 2020.

Oracle database links – performance impact

In this post I’m going to explain the most important drawbacks when using db links technology for purposes for which it is not design for. To be more precise, the case in which db links are used to massively exchange data between many separate databases will be explained. In the previous post you can find […]

23. 11. 2019.

Flashgrid Skycluster – Oracle RAC in the Cloud – review

Recently I’ve completed review of the FlashGrid Skycluster, an Oracle RAC deployed (in this particular test) on AWS Public Cloud IaaS, although Azure and GCP are also supported.   Flashgrid specializes for Oracle RAC, either on-premises or in the Cloud, where all three major Cloud providers are supported. When you ask yourself what is so […]

21. 10. 2019.

Performing stress test against Oracle database that is running in a Cloud

Today majority of enterprises are moving or at least considering moving some load into the Cloud. What you need to be aware in such case, system requirements for a Cloud load are quite different when comparing with on-premises, mainly due to many new moving parts that are not present within classical environment such as sharing […]

07. 10. 2019.

Installing Oracle database on Amazon AWS

Although you can use AWS RDS service which offers PaaS architectural model of running Oracle database on top of AWS Cloud, due to many limitations (installation type, options selected etc.), many enterprises still prefer using IaaS model, where such restrictions does not exist (e.g. you can install Enterprise Edition of Oracle database, RAC, Data Guard […]

23. 09. 2019.

Running Cloud within your Data Center on-premises

Of the 350 companies surveyed, 74% had moved an application into the public cloud, and then for a variety of reasons and circumstances, decided to move it back into their on-premises or private cloud infrastructure.   More you can find on the following link: https://www.fortinet.com/blog/industry-trends/ihs-markit-fortinet-cloud-report-insights.html?utm_source=social&utm_medium=twitter-org&utm_campaign=sprinklr&utm_term=Corporate%2CThought+Leadership   The first interesting finding is the growing sense that […]

11. 09. 2019.

Who else could read your private & sensitive data stored in Cloud?

ZDNet has recently published an interesting article related to Public Cloud and GDPR related data jurisdiction – US Cloud act. Article is about digital sovereignty as more than half of European business with over 1,000 employees are using a public cloud platform, mostly AWS & Azure that dominate the Cloud market, IBM that dominates hybrid-cloud […]

23. 08. 2019.

Oracle single-threaded CPU performance reference test, native compilation and performance improvement after upgrading your database

In this article I’ll provide a very simple way of how to test Oracle CPU single-thread performance.   Apart from that, I’ll cover performance boost you might expect when upgrading your server (especially CPU), expected performance boost when performing simple upgrade of the Oracle database, and issues and workarounds related to native compilation of PL/SQL […]