Password Rollover Time in Seconds Mustafa, 2024-11-26 Hello, Today, I was working on a new client database security issues. one of the first thing I checked is profile of DBA or highly privilged users. While setting PASSWORD_ROLLOVER_TIME limit in profile, I realized that even if I set it to 1 day, in DBA_PROFILES view it is listed… 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
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
Querying CDB_* Views Generates Audit Records Mustafa, 2023-10-04 Hi, I would like to share a small problem I had on one of my databases. I had a common user on my CDBs to manage the databases (version is 19.20). On my databases, I use unified auditing and traditional audit is off. ORA_LOGON_FAILURES and ORA_SECURECONFIG policies are only enabled… 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