18. 08. 2021.

Functional monitoring of Microservices architecture by using Apache Superset

Many of you who have started to develop modern apps by using Microservices approach, have already learned that development tools, debuggers, performance monitoring and tracing lag behind the desired architecture. Situation is even worse when it comes to functional monitoring, where your goal is to find out what is going on with your system from […]

04. 05. 2021.

Tuning Connection pool in modern Microservice architecture

Connection pool has always been a great way to ensure a low latency when establishing connection with a database, while at the same time keeping the number of open sessions under control. It’s one of the best ways to balance speed with resource consumption. With connection pool in place, connection is already established and ready […]

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