3 Ways to Migrate a Non-CDB Database to a PDB Mustafa, 2022-03-252022-03-26 Hi Everyone, Time is fast and everything is changing constantly. Multi-tenant architecture has come many years ago and starting by 21c, it is the only option! So, old “non-cdb” databases must be migrated/converted to a PDB (Pluggable database). I must admin that I was being lazy for many years and… Continue Reading
How to install Oracle Database Options like Spatial, Label Security etc After DB Creation Mustafa, 2022-03-032022-03-11 Hi, yes, I am aware that title is a little bit long and too informative but I believe it is necessary because terms are complicated according to me. When you say “option” it could be many thinks like “advanced compression” option in EE or Spatial option or Partitioning option and… Continue Reading
Tables with Memoptimize for Write (fast ingest) Mustafa, 2022-02-232022-03-03 Hi There, this is the second part of this post: https://mustafakalayci.me/2022/02/15/tables-with-memoptimize-for-read/ Oracle adda new feature called memoptimized tables for mostly devices like IoTs. Fast lookup and fast ingest tables. I have already mentioned about fast lookup (memoptimize for read) tables in my previous post and now I want to write… Continue Reading
Tables with Memoptimize for Read (fast lookup) Mustafa, 2022-02-152022-02-15 Hi, I would like to share my initial thoughts about memoptimized for read (fast lookup) tables in this post. fast lookup tables came with 18c and they are here to provide faster access to a table if you are using primary key with a equality condition. this is basically single… Continue Reading
How to Restore Dropped PDB Mustafa, 2022-02-04 Hi, it seems easy, right? Well, not that much but not that hard either. if you drop a pdb in a cdb, you cannot restore it using current database because when you drop the pdb, all information about the pdb is lost. So, what is the solution? you need a… Continue Reading
CONTAINER_DATA for Common Users Mustafa, 2022-01-062022-01-06 Hello Everyone (if anyone reading this 🙂 ), it has been a long year and I am glad it is over. As always, we hope the for “a time of period” like new year, birthday etc etc but hope is the only thing that we can hold on. I hope… Continue Reading
How to Demonize Apex V Function! Mustafa, 2021-10-312021-11-04 Hi, Answer of the question in the subject is “Using too much V in SQL statements”. Let’s see why and what should you do. First things first, I am NOT a APEX developer. I am a DBA and Database Developer but some of my clients are using APEX and I… Continue Reading
Hierarchical Blocking Session List Mustafa, 2021-10-19 Hi, Today, I needed to list all blocking sessions hierarchically. As you know, all information about sessions (and blocking sessions) are in gv$session (or just v$session if you are using single instance) view. I wanted to see who is blocking who and blocker at the top. you can write simple… Continue Reading
Subquery Caching Mustafa, 2021-10-172021-11-19 Hi, I want to talk about very sweet performance “trick”. I love when I do something small and gain a lot 🙂 Today, I will demonstrate subquery caching in Oracle and try to explain how it works and it’s limitations. Probably, you are using some plsql functions in your select… Continue Reading