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 »
Oracle 12c/18c/19c: Advanced Network Compression
Starting with Oracle 12c, Oracle supports Advanced Network Compression. Too bad, it is available as part of Advanced Compression option. Oracle compresses the data to be transmitted over network at… Read more »
How to change hostname in ORACLE ASM
Pre-Tasks If you root then execute su – oracle Then > . oraenv Write down: +ASM Before start with the Oracle Restart process you must stop the listener: [oracle@DB ~]# crs_stat… Read more »
JDBC and UCP New Features in Oracle Database 19c and 18c
Oracle Database 19c and 18c JDBC drivers and Java connection pool (UCP) introduce several new features in the performance, high availability, security, and scalability areas. New connection and security features… Read more »
How to purge the Oracle unified audit trail
The unified audit trail, which resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace, makes this information available in a uniform format in the UNIFIED_AUDIT_TRAIL data… Read more »
Automatically and Manual Purging Alert Log and Trace files with ADRCI
Automatically purging Sometimes we are facing with space related issues due to the huge number of trace file generation. Automatic purging can help us in this situations if set short… Read more »