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
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
Sessions with details Mustafa, 2023-09-212023-09-21 Hi, Today I just want to share a small select statement that I used (my original one is a little bit longer). I use this to get as much as “important” data from sessions in the database. By saying “important”, I mean the data that I use to identify the… 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
DBCA Templates and Dangerous “General Purpose” Template Mustafa, 2023-05-11 Hi, I still see that many dba is creating their databases using “General Purpose or Transaction Processing” template. Why you shouldn’t use it? Because it is way too general! if you click the “view details” on the right: Almost all the “Components” are true. So it installs everything even… 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