MariaDB with LZ4 Compression on Centos 7.9
I really really wanted to run the latest MariaDB with LZ4 Page Compression.. it is a game changer for many types of large databases I deal with. There isn’t a… Read more »
Oracle: How to update all sequences
Do you want update all sequences? make it simple! If you ever do data refreshes from production to development or test environments you may run into an issue where your… Read more »
Desupport of Oracle Real Application Clusters (RAC) with Oracle Database Standard Edition 19c
Oracle RAC? Oracle Real Application Clusters (Oracle RAC) is the only solution to build an active – active cluster using shared storage for your Oracle database. Up to Oracle 18c… Read more »
Oracle 19c-Rman Performance of Block change Tracking (BCT)
In this article we are going to see use of Oracle Block Change Tracking concept in 19c database. 19c-Block Change Tracking(BCT) Oracle 10g introduced the Block change tracking (BCT) feature… Read more »
Major change Oracle 19c: No RAC for Standard Edition anymore!
History Since December 2015, Oracle released Oracle Standard Edition 2 (SE2), replacing the previous Standard Edition (SE) and Standard Edition One (SE1) releases. Customers on versions before 12.1.0.2 (running Standard… Read more »
Tutorial MariaDB Columnstore for MySQL Admins
The typical MySQL DBA might be familiar working and managing an OLTP (Online Transaction Processing) database as part of their daily routine. You may be familiar with how it works… Read more »
How to display processes using swap space
Identify and print processes using swap space to get a better understanding of the Linux operating system. Display processes using swap space Use the following command to simply display processes… Read more »
Setting and Controlling IP sets using firewalld
Today we see the list of IP set types supported by firewalld, enter the following command as root. ~]# firewall-cmd –get-ipset-types hash:ip hash:ip,mark hash:ip,port hash:ip,port,ip hash:ip,port,net hash:mac hash:net hash:net,iface hash:net,net… Read more »
Move column order Oracle 12c/18c/19c
Since the release of Oracle 12c it is now easier to move columns logically. Oracle 12c added support for making columns invisible and that feature can be used to rearrange… Read more »
ORA-06512: at “SYS.OWA_UTIL”
Hi guys! Have you ever encountered this error ORA-06512: at “SYS.OWA_UTIL” during a package compilation using for example the Oracle sql developer software? Problem: line 1: ORA-06502: PL/SQL: numeric or… Read more »