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
How to Convert LONG to Clob PART 2 Mustafa, 2022-05-062022-05-06 Hi, I just want to write a small post today. Some time ago, I shared a way to convert long to clob in a query directly:Ā https://mustafakalayci.me/2020/04/06/how-to-convert-a-long-column-to-clob-in-a-query/ Even if this method works, it works really slow and anything slow annoys me! So, I want to share another method which is much… Continue Reading
Zero Data Loss DISASTER Database for Standard Edition 2 Mustafa, 2022-04-22 Hi, As you know Data Guard is an Enterprise Edition option and only accepted method to protect your data against a “DISASTER” (DR) is data guard. How about Standard Edition 2(SE2)? Is this possible? Well I did it so, king of yes š with some risk of course. Warining: I… Continue Reading
Indexes with NOSEGMENT a.k.a Virtual Index Mustafa, 2022-03-302022-03-30 Hi, Today, an old trainee has contacted with my on linkedin and we talk about some performance issues about a query. During the conversation I suggest to use “virtual indexes” to simulate the index so I wanted to write about virtual indexes and their benefits in this post. if you… Continue Reading