Old Obsolete Backup is not Deleted Mustafa, 2023-01-232023-01-23 Hi, Happy new year (after almost a month). I was quite busy and lazy to write a new blog post but today I found the energy. What I realized newly is a little bit shocking for me because I had no idea! Maybe this is just an ignorance of me… Continue Reading
Autoupgrade doesn’t Upgrade Timezone Version While RU Patching Mustafa, 2022-11-162022-11-18 Hi, during some tests, I realized that autoupgrade tool (the magic tool for upgrade and patching) doesn’t upgrade timezone version of database. here is the environment: Oracle Linux 8.6 ORACLE_HOME 1 :/u01/app/oracle/product/dbhome_1/dbhome_19_3 Database orcl created in 19.3 with default time zone version (V32) ORACLE_HOME 2 :/u01/app/oracle/product/dbhome_1/dbhome_19_16 Time zone version is… 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
Should Run datapatch After DBCA Mustafa, 2022-11-032022-11-03 Yesterday, I was testing some stuff in database and I needed to create new homes/new databases (new life new beginning). at a point I realized that something is not right about database. One thing to another I found the reason and it was interesting to me. I used DBCA to… Continue Reading
APPLY with status WITH ERRORS in the PDB Mustafa, 2022-10-29 Yesterday, I was doing some tests about noncdb to pdb conversions and during one of these tests I got a strange error. By the way, I am doing those tests because of a side effect of noncdb to pdb. I have already created an SR about it and write a… 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
Audits are not Purged Mustafa, 2022-07-302022-07-30 Hello, This week I realized that some of my databases’ audit data are not purged and audit tables get bigger. I already have a scheduler job to purge my audit records but somehow job has been completed successfully but audit records are not deleted. This is 19.15 version, NON-CDB databases…. Continue Reading
lsnrctl or new db connection is too slow Mustafa, 2022-07-202022-07-21 Hello everyone, I know this is not new but I haven’t seen this problem for a long time and it takes a while to find out it. A team leader (who is an elder brother to me) from the company I started to my first job called me and asked… Continue Reading