Installing Oracle JDeveloper on Ubuntu
To complete configuration of Ubuntu machine that I’ll use later for Oracle Development, let’s install JDeveloper, Oracle’s main Java development tool. Although JDeveloper is free, it has never had any significant traction among Java developers. In Java IDE space there are several great competitors, starting with Eclipse, IntelliJ and NetBeans. With such competition it’s difficult […]
Installing SQL Developer on Ubuntu
Today it is not necessary to introduce SQL Developer, Oracle’s main tool to work with databases. I’ve started to use SQL Developer from the beginning (2015, project Raptor, later renamed into SQL Developer). Before that, the only Oracle tool for working with it’s flagship database was SQL*Plus (and iSQL*Plus later). For that reason, most of […]
Python & Oracle Instant Client connection setup on Linux – part 2
In the previous article I’ve described how to install Oracle Instant Client and setup cx_Oracle Python driver correctly. You only need Basic package to install: Version 18.3.0.0.0 Base – one of these packages is required Basic Package – All files required to run OCI, OCCI, and JDBC-OCI applications Download instantclient-basic-linux.x64-18.3.0.0.0dbru.zip (72,794,506 bytes) (cksum – 3435694482) […]
Python & Oracle Instant Client connection setup on Linux
In the previous post https://www.josip-pojatina.com/en/python-oracle-connection-options/ you can find how to connect to Oracle database by using cx_oracle Python driver, full Oracle Client installation and Red Hat rpm based distribution (Red Hat, CentOS, Oracle Linux, Fedora). In reality, more than 90% of all Linux servers in a Cloud belongs to Ubuntu (unlike on premise situation where […]
Python as bash replacement
Even today, on many projects I can still find that many developers are still using bash & Korn shell or even Pro*C as a main tool for developing scripts that will be executed as part of batch job in one of the following ways: Unix/Linux cron Oracle’s dbms_job / dbms_scheduler commercial enterprise job scheduling software […]
How to efficiently debug PL/SQL code
Almost every day I remember proverb/adage: if you haven’t discovered anything new for a while, it doesn’t mean you know everything and there is nothing left that you can learn. It only means you stop learning. I started with SQL Developer when it was internal and later alpha project inside the Oracle with a code […]
How to quickly check disk(s) speed limit on Linux – part 3
This is the third part of a series of articles about measuring performance of disk subsystem. In the first part you can find details of how to measure disk performance by using dd command: https://www.josip-pojatina.com/en/how-to-quickly-check-disks-speed-limits-on-linux/ while in the second part you can find similar information by using the hdparm utility: https://www.josip-pojatina.com/en/how-to-quickly-check-disks-speed-limit-on-linux-part-2/ In this blog I’ll […]
How to quickly check disk(s) speed limit on Linux – part 2
In the previous part of disk speed series you can see one way to test disk speed by using special options of the dd command. In this article another utility – hdparm will be described. What is common with the previous way of testing HDD disk performance is in it’s simplicity, meaning you only need […]
How to quickly check disk(s) speed limit on Linux
Many times I can testify that IT professionals are talking about performance without even try the most simplistic tests to find out what are the HW capabilities/limits they have. One of the first things I usually do when facing with unknown environment is to run several tests to find out how much I can get […]
Bash performance tuning by example – How to delete 1 million files from file system, and how to do that fast?
In this article I’ll show my approach to solve real world performance problem by using bash scripting language. Problem statement is: How to delete 1 million files from file system, and how to do that fast? File system maintenance is important aspect of sysadmin job. It’s not only important to maintain file system, […]