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
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
Damaged rowid is referenced! Health Monitor Mustafa, 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, 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