Featured

How to install Android x86 6.0, 7.0 on VMWare ESXi. Warning, many screenshots.

I don’t know why, but installing Android x86 6.0 and 7.0 on VMWare ESXi is not quite simple as it should be. The short story 1) Correctly make bootable disk2) Install Android3) Modify GRUB with “nomodeset xforcevesa” parameters to boot android4) Fix parameters in GRUB after android loads And the long story First, download Android …

How to install Android x86 6.0, 7.0 on VMWare ESXi. Warning, many screenshots. Read More »

Comparing Apache mod_php, fcgid, proxy_fcgi + php-fpm with different MPMs for a WordPress blog.

WordPress platform is very popular for personal sites and blogs. In this article I will stress-test my own site in order find best performance CGI and MPM. All test was performed on low-end droplet from DigitalOcean:1 CPU, 512 MB RAM, 20 GB SSD Apache 2.4.10, PHP 5.6.20, MySQL 14.14 Distrib 5.5.49 was installed.Opcache was enabled …

Comparing Apache mod_php, fcgid, proxy_fcgi + php-fpm with different MPMs for a WordPress blog. Read More »

Oracle DB. Changing and fixing query execution plan using dbms_spm.

Oracle Query Optimizer generally works well, but sometimes it makes your fast and polished queries slow down. Often, you can not simply add hints and recompile them on production environment. In such case be ready to use dbms_spm package. Don’t forget about appropriate grants.grant select on V_$SESSION to test;grant select on V_$SQL_PLAN to test;grant select …

Oracle DB. Changing and fixing query execution plan using dbms_spm. Read More »

Oracle DB. Using dbms_alert for queuing and parallel data processing.

Oracle has an interesting package to provide an event-based logic named dbms_alert. In this article I will use it to create a classic queue processing. First, we need to create a simple table, which store queue message ID and creation time. create table t_queue ( id_queue number primary key, d_add timestamp default systimestamp not null …

Oracle DB. Using dbms_alert for queuing and parallel data processing. Read More »

Oracle DB. Advanced Queuing. Simple subscriber example.

In this article I will show you how to create Oracle queues, pull messages and push them using subscriber. Before we begin, please, grant dbms_aqadm and dbms_aq execute privileges to user. Queue table use an object data type to transfer message data. Let’s create it first. create or replace type tp_queue as object(n number); Second, …

Oracle DB. Advanced Queuing. Simple subscriber example. Read More »