In this tutorial, Oracle notes for beginners. How to query commands useful in Oracle database. Oracle notes for beginners Oracle…
Database Administrator
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…
How to check the Oracle database character set
In this tutorial, How do I use to check the Oracle query Database character set? Use “NLS_CHARACTERSET” and “NLS_NCHAR_CHARACTERSET” in…
Oracle query Database name
In this tutorial, How do I use the Oracle query Database name? Using “v$parameter” for the database name. Connect SYS…
MySQL cheat sheet
In this tutorial, I will write MySQL Cheat sheet by command line. How to Reset Root Password in MySQL? How…