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
How to Compare Two Tables Mustafa, 2023-10-262023-10-27 Hi, Few days ago, I joined Chris Saxon’s webinar about “how to compare two tables”. Chris is one of the amazing guy in Oracle community and he shared different methods about how to compare two tables and also, strengths and weakness of the methods. before reading my post, I strongly… Continue Reading
DBMS_PIPE Connecting the Sessions Mustafa, 2023-08-182023-08-18 Hi, It has been a long time since I wrote something. It is summer and I was in a long vacation. Well I worked mostly of course but at least get away a little bit. In this post I would like to talk about PIPEs in Oracle Database. It is… Continue Reading
23c is Finally Here! Mustafa, 2023-04-06 Hello everyone, Well, it is just developer version so don’t try to install on your environments 🙂 My twitter is full of 23c tweets about these days. I also downloaded immediately and tested what I wanted the most for 4-5 years! “Schema Level Privileges” and I am so excited about… Continue Reading
Not Deploying is also Important! Mustafa, 2023-03-31 Hello there, I mentioned about writing a nasty ORA-600 error and here it is; One day I woke up and one my databases was started to raise some ORA-600 errors: ORA-00600: internal error code, arguments: [ktfacht1-0], [], [], [], [], [], [], [], [], [], [], [] there were also… Continue Reading
Unique Columns For V$Sql Mustafa, 2022-11-11 Hi, Until yesterday I was saying SQL_ID and CHILD_NUMBER is enough to get a sql child cursor from V$SQL and today I know I was wrong. Probably many times you needed the sql statement that a session is running. To do that you query V$session and find the session information… Continue Reading
How to Check Empty Space in a Securefile LOB Mustafa, 2022-09-272022-10-12 Hi, PS: please check last sql statement in this post for shorter and faster solution. first sql is for showing all information about the lob. Yesterday, while checking segment space usage data in a client’s database and some of the LOB segments were absurdly big. So, I want to check… Continue Reading
catcon.pl cheat sheet Mustafa, 2022-08-262023-04-24 Hello, Oracle uses a container database architecture permanently anymore, you should be familiar with “catcon.pl” perl file. Let’s say you have container database with 10 different PDBs and you need to run a script file on all of those pdbs (maybe even in root and seed too) so what you… Continue Reading