Damaged rowid is referenced! Health Monitor Mustafa Kalaycı, 2023-02-23 Hi, a quick note! today while checking health monitor results, I found this: SQL dictionary health check: objauth$.grantor# fk 246 on object OBJAUTH$ failed Damaged rowid is AAAAA9AABAAATI1AAa – description: Object MY_OWNER.SOME_VIEW is referenced I replaced actual owner and view name with “MY_OWNER.SOME_VIEW”. Health check is telling me that a… Continue Reading
Old Obsolete Backup is not Deleted Mustafa Kalaycı, 2023-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 Kalaycı, 2022-11-16 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 Kalaycı, 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 Kalaycı, 2022-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 Kalaycı, 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 Kalaycı, 2022-09-27 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 Kalaycı, 2022-08-26 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
Expanded controlfile section n from nnn to nnn records Mustafa Kalaycı, 2022-08-10 Hello everyone, I have been already write revealing information that control file stores: https://mustafakalayci.me/2020/08/11/control-file-content-and-the-limits/. Data in control file is separated into "SECTIONS" and you can see those sections name (type) via V$CONTROLFILE_RECORD_SECTION view. for example, database separates a section for "BACKUP SET"s. every section has a record size limit …. Continue Reading
Audits are not Purged Mustafa Kalaycı, 2022-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