22. 05. 2019.

Troubleshooting boot issues in Linux – part 2

This article is an extension of the following one:   https://www.josip-pojatina.com/en/troubleshooting-boot-issues-in-linux/   where I’ve added part that describes situation when you cannot boot your system at all, but Linux distro image DVD is still not required.   To be able to troubleshoot further what is going on, you need to start your Linux server machine. […]

17. 05. 2019.

How to change the execution plan without changing the code in Oracle 10g

Recently I had an interesting case when I’ve been asked how to change the execution plan of one complex query without changing the code. I’ve already had a lecture with similar title at 2012 in Oracle User Group Conference – more details you can find at the following link: How to change the execution plan […]

08. 05. 2019.

Processing billions of records with Python & Oracle

Suppose you want to analyze data set by using your favorite tools (Pandas/NumPy). By reading my previous article: How to efficiently load data into Python from the Oracle RDBMS , you should realize how important is to do as much of data processing at the database SQL engine layer to get out dataset suitable for […]

07. 05. 2019.

Troubleshooting boot issues in Linux

After I’ve installed one older application on Oracle Linux 7, next time I’ve tried to start it, the server refused to start. Fortunately it’s Linux, so there are many ways to recover it. The following approach should work for most cases. Try to boot into the terminal mode by editing Grub In case that previous […]

23. 04. 2019.

How to efficiently load data into Python from the Oracle RDBMS

Python has many different ways to fetch the data needed to do some processing. Although majority of examples you can find around are using CSV file load, fetching a data from the database is still the most common way in practice. For all tests I’ll use SALES table from the Oracle SH sample schema. 1. […]

26. 03. 2019.

CUDA Tuning – GPU card details

In the last post I’ve explained how to install nVidia Toolkit 10.1 on Ubuntu 18.04 LTS. Details can be found on the following pages: https://www.josip-pojatina.com/en/how-to-install-cuda-toolkit-on-ubuntu-18-04-lts/ or https://www.performatune.com/en/how-to-install-cuda-toolkit-on-ubuntu-18-04-lts/ In this article I’ll explain the most important card details you need to know. Prerequisite for this article (besides nVidia drivers and Toolkit 10.1 Toolkit installed) is to […]

23. 03. 2019.

How to install CUDA Toolkit on Ubuntu 18.04 LTS

This is the second part of CUDA-GPU tuning series where I’ll explain how to install CUDA Toolkit 10.1 on Ubuntu 18.04 LTS. In the first part I’ve described how to properly install nVidia drivers on Ubuntu 18.04 LTS Detailed instructions can be found on any of these two pages: https://www.josip-pojatina.com/en/how-to-install-nvidia-driver-on-ubuntu-18-04-lts/ or https://www.performatune.com/en/how-to-install-nvidia-driver-on-ubuntu-18-04-lts/   Although you […]

22. 03. 2019.

How to install nvidia driver on Ubuntu 18.04 LTS

CUDA, OpenCL and GPU programming in general are hot topic in today’s IT world. Main reason for that is a rise of Data Science, Artificial Intelligence and Deep Science, and many new technologies that relies on it like self driving cars, robotics etc. Traditionally main consumers of graphical cards are: gaming industry video editing professionals […]

01. 03. 2019.

Starting with Oracle Unit Testing Framework – Part 3 Automation

In this article I’ll describe how you can automate previously created Unit Test. I believe that many of the Oracle SQL Developer users use only core functionality of the tool, and have never become familiar with its more advanced features. I’ve already describes in several articles some of its advanced features (you can use search […]

28. 02. 2019.

Starting with the Oracle Unit Testing Framework – Part 2

This is a second part of the Oracle Unit Testing Framework post. In the first part I’ve created Unit Test repository and prepare everything for testing. Details you can find on the following link: https://www.josip-pojatina.com/en/starting-with-oracle-unit-testing-framework-part-1/   In this part I’ll perform actual test and show some of the numerous options that you have on disposal. […]