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
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
NON-CDB to PDB Migration Horror Mustafa, 2023-04-27 Hello everyone, Lately I migrated a non-cdb to pdb for a client database and it almost become a horror movie for over 2 weeks to me. before I start, if you want to know how to migrate from a non-cdb to pdb you can check one of my previous post:… 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