Using MFA While Logging into the Oracle Database Mustafa, 2025-08-142025-08-21 Hello Everyone, There is another great development on security side of Oracle database users. With latest release updates (I think 19.28 and 23.9) we can now enable Multi Factor Authentication (MFA) while a user is logging into the database. That is a fantastic security feature especially for production environments. Your… Continue Reading
2 of Most Practical New Features on 23.9 Mustafa, 2025-08-09 Hi, with 23.9 I saw 2 beautiful enhancement in SQL. These are not “exceptional” things but their practical usage is a lot to me as a both developer and dba. 23.9 is already available on cloud base database systems. First, INSERT SET is here! one of my biggest complains in… Continue Reading
Milliseconds are lost after date to tz conversion on 19c Mustafa, 2025-07-15 Hi, yesterday, I found (maybe) a small bug in 19c. Whenever I deal with timestamp with time zones, I always learn something new. so, the request is as this: there is a DATE column which should be converted into a timestamp with tz but if it is null then result… Continue Reading
Is Table Unnecessary for Pipelined Function Mustafa, 2025-04-05 Hello everyone, What a busy year. I couldn’t find time to write something and so much is happening, AI models, Quantum etc. So I want to write more now. I know that many people think that blogging is dead but I don’t share this thought because AI is still not… Continue Reading
PDB Syncronization Issue Mustafa, 2024-11-19 Hello, 2024 was hell of a year for me (still is) I couldn’t even check my blog. I just want to add a post, something small. From time to time I got pdb_plug_in_violations records about sync pdb comments like grants/revokes. I use a common user to manage my pdbs. Lets… Continue Reading
How to limit DB Link Connection Timeout Mustafa, 2024-07-03 Hi, I just want to share something small that I dug to learn. I didn’t work with db links for years and now all of a sudden I have tens of them. This comes with new challenges of course. When you tried to run a query or function/procedures over a… Continue Reading
Cloud Base Database Service Mustafa, 2024-04-252024-05-14 Hi, Since I relocated to the Netherlands, I cannot find much time to write but finally I have some spare time. Recently, we migrated a client database environment to the cloud and to achieve that I started to learn cloud at the end of 2023 (I know I am “a… Continue Reading
29th of February and interval Mustafa, 2024-02-29 Hi, it has been a long time since I post something. I just relocated to a different country, the Netherlands, and I was dealing with so much paperwork and stuff. So far so good. Dutch people are so kind and warm, they help about everything. My first impression is amazing… Continue Reading
Guid vs Sequences Mustafa, 2023-12-29 Hi Everyone, I haven’t written any posts lately because there is so much going on in my life and biggest change is I am moving to the Netherlands. it is a big change for me and my family but I hope everything will be fine (if we can find a… Continue Reading