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
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
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
Expanded controlfile section n from nnn to nnn records Mustafa, 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
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
SESSION_CACHED_CURSORS Parameter and How can It Affect the Database Mustafa, 2022-07-02 Hello, Let’s talk about the SESSION_CACHED_CURSORS parameter. It might have significant affect on your system so understanding how it works and what it cause is important. This parameter limits the number of cached cursors on the session. As you know there is 2 kind of parse SOFT and HARD. Hard… Continue Reading
Marked as unrecoverable datafile in V$datafile even if they are not! Mustafa, 2022-06-292022-07-18 Hello, it has been a while since I posted. I lost a close relative to me and it wasn’t easy. So, let’s continue. I run orachk on one my development databases yesterday and result was very informative. Interestingly, I had a “FAILED” check that indicates some of the datafiles are… Continue Reading