X Forwarding for an Oracle DBA Mustafa, 2021-08-022021-08-02 Hi, It’s been a long time. I want to write something about X Forwarding. you might feel more comfortable to use a GUI instead of silent installations sometimes. if you are connecting to a linux server remotely then you must enable X Forwarding to enable GUI for Oracle product like… Continue Reading
Create a Clone DB from Backup on the Same Server (or remote) Mustafa, 2021-04-262021-04-27 Hi, I wanted to create a post series about cloning/duplicating database on the same or remote servers. There are so many options and combinations about this like rman duplicate database with/without target/source db connection, rman restore using backups, ASM to OS or OS to ASM, same server or remote server,… Continue Reading
Pragma UDF & Deterministic Mustafa, 2021-04-09 Hello everyone, I wanted to write about something simple and can improve the performance of your sql statements. Unfortunately, many database developers use too much plsql function in their SQL statements. I say too much because if you learn more about the SQL, you will use less plsql. SQL is… Continue Reading
PLSQL and Flashback Data Archive Problems. Mustafa, 2021-01-302021-01-30 Hi, I have written about flashback data archive before. if you didn’t read please check these post first. https://mustafakalayci.me/2019/03/02/goodbye-log-triggers-welcome-flashback-data-archive/ https://mustafakalayci.me/2020/09/10/flashback-data-archive-problems/ I’ve already mentioned about some problems on my second post but these are not kind of problems which will stop your work. The problem I am about talk is that… Continue Reading