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

14. 08. 2019.

Cloud – shared responsibility model, SaaS & Cloud security best practice

As industry is moving fast toward Cloud adoption, although not new (Amazon AWS platform was launched in July 2002), it’s no surprise that Cloud is still one of the hottest technologies around. Started with Simple Queue Service (first AWS service launched in November 2004), Cloud today is far away from the simple file sharing service. […]

28. 07. 2019.

How to quickly perform REST API performance test

REST API interface is dominant way of machine-to machine communication because of its flexibility, performance, simplicity and lightweight.   Recently I had to perform a quick performance test to check if response time of one application is in line with SLA (Service Level Agreement). Such performance tests are particularly important in case of SaaS architecture […]

24. 07. 2019.

SaaS related GDPR, security and architectural issues

In the age of Cloud computing one of the most important challenges is how to keep security while moving your enterprise apps in the Cloud. In this article I’m going to explain what challenges you might experience if you are blindly follow all hypes from the tech industry. Today enterprises are under tremendous pressure to […]

22. 07. 2019.

Oracle database benchmarking by using CALIBRATE_IO

CALIBRATE_IO is yet another popular database simulation/stress test utility, mainly used to perform IO benchmarks.   Procedure, that is part of DBMS_RESOURCE_MANAGER package, will generate read-only workload made up of 1 MB of random of I/Os to the database to determine the maximum number of IOPS and MB per second. You can save the following […]

17. 07. 2019.

Implement High Performance Computing tools to test cluster stability

There are many benchmark testing tools that are focusing on various fields of a cluster like computing capabilities, energy efficiency, data & storage, memory etc. In this article I’m going to use Somberero – High Performance Computing tool suitable to run a test against your home PC or cluster of supercomputers. Sombrero is particularly useful […]

07. 07. 2019.

bash history search on steroids

Today there are several hundreds (maybe even thousands) programming languages around (not to mention Domain Specific languages), but bash, with all its shortcoming, is still native language of all *nix servers around. With today’s choices you might not want to create scripts in bash, for one liners bash is still in. In this article I […]

04. 07. 2019.

When to use Manual Memory Management in Oracle

In this post I’ll explain one case when Manual memory management is superior over letting Oracle to automatically manage PGA memory. Recently I need to create a test table with 10 million rows by using CONNECT BY clause. When I issue the following DDL command: I’m getting the following error: PGA parameters where set to […]

01. 07. 2019.

Integrating BigQuery with internal on-premise apps into Hybrid Cloud solution

In previous article I’ve described how to use BigQuery by using DataGrip (cross-platform IDE for database management and development) from the client machine. This is useful when you want to quickly get result set based on the query and allows you to stay within a tool you already use. In this article I’ll describe how […]

30. 06. 2019.

Accessing Google BigQuery from your local machine

Google BigQuery is basically REST based web service to the Dremel technology (distributed system developed designed to querying large datasets).   In this article I’ll describe how to access Google BigQuery from your local machine by using DataGrip tool from JetBrains.   There are several ways to access Google BigQuery. The most obvious/official ones includes […]