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 […]

02. 01. 2020.

Oracle database links – locking strategy

In this post mechanism of Oracle database link technology along with locking strategy used by Oracle database will be described. Today in almost all production environments based on Oracle databases where I’ve been called to help with optimization & tuning, it is a quite common to have at least one or more db links to […]

16. 12. 2019.

Oracle RAC in the AWS Cloud – performance testing part III

This is the last part of the series called “Oracle RAC in the AWS Cloud”. In my previous article I’ve promised to put a Oracle RAC cluster under the crazy load. It was time to fulfill my promise. My previous articles you can find on the following two links: https://www.josip-pojatina.com/en/oracle-rac-in-the-aws-cloud-performance-testing-part-i/ & https://www.josip-pojatina.com/en/oracle-rac-in-the-aws-cloud-performance-testing-part-ii/ Let’s go straight […]

09. 12. 2019.

Oracle RAC in the AWS Cloud – performance testing part II

In the 2nd part of the Oracle RAC in the AWS Cloud series I’ll present test results of Oracle 2 nodes RAC databases running on AWS public cloud based on Flashgrid’s Skycluster deployment. You can take a look at my previous article that are related to how to deploy & setup environment for Oracle RAC […]

03. 12. 2019.

Oracle RAC in the AWS Cloud – performance testing part I

Last time, all components (network, storage, Grid infrastructure…) are prepared for Oracle database RAC installation with a minimal time and effort thanks to Flashgrid’s wizard which, behind the scene, is using Cloud Formation template to setup everything, including installation of all necessary patches available at the time of installation.   You can find more on […]

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 […]

20. 11. 2019.

How to install Oracle SQL Developer Data Modeler 19.2 on Ubuntu 18.04 LTS

One of the main reasons why I choose Fedora as my main operating system is due to Oracle dependency on rpm package manager and because of the bleeding edge of Open Source technology like the latest kernel version, compilers, new drivers etc. Unfortunately, very often bleeding edge means bloody edge as I have to spend […]

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 […]