#Introduction In this tutorial, How To Move a MySQL Data Directory to a New Location on Ubuntu. I will change…
Database Administrator
Back Up and Restore MySQL Databases with Mysqldump
Introduction In this tutorial, How to backup and restore MySQL or MariaDB databases from the command line using the mysqldump…
Reset MariaDB root password on Centos
MariaDB is free and Open-source. It is the famous fork of the MySQL database. In this tutorial, How to Reset…
Oracle notes for beginners
In this tutorial, Oracle notes for beginners. How to query commands useful in Oracle database. Oracle notes for beginners Oracle…
Oracle automatic startup on Linux
In this tutorial, How to confirm Oracle automatic startup on Linux. How to make Oracle start automatic in Linux. By…
How to connect to Pluggable Databases in Oracle 19
In this tutorial, I used the Default Service for connecting to the PDB. Made in the tnsnames.ora file that defines…
Install Oracle client 18.3 on centos 7
In this tutorial, How to install Oracle client 18.3 on Centos 7. Bach server (sqlplus,sqlldr, etc) <–> Oracle server Your…
TKPROF using trace analyzer to trace SQL
In this tutorial, How to TKPROF using trace analyzer to trace SQL in Oracle Database Server. The syntax TKPROF command…
Oracle v$system_parameter
In this tutorial, How to query “v$system_parameter” in Oracle? Oracle v$system_parameter. What does “v$system_parameter” mean? “Oracle v$system_parameter is the view…
Oracle query tablespace
In this tutorial, How do I use the Oracle query tablespace? Oracle query tablespace How to query to check tablespace…