by Javier Morales Carreras | Oct 11, 2023 | GitHub projects
This one is about bad practices. The use of synonyms. If you have felt a cold sweat, you probably experienced something similar. Many users want to access application tables “transparently.” Note that I put it in quotes because calling...
by Javier Morales Carreras | Mar 2, 2023 | GitHub projects
As every year, it’s time to clean up the databases Marie Kondo style. Database administrators have to historicize, compress or delete old partitions that are no longer needed. Obviously, partitioned tables (and their local indexes) are the best place to...
by Javier Morales Carreras | Jan 22, 2023 | GitHub projects
Let’s talk about physical backups and how to get a report based on your own “safety criteria” about the successfull backups needed to ensure a safe recovery scenario. In many places, they get reports when backups end successfully, or sometimes only...
by Javier Morales Carreras | Dec 26, 2022 | GitHub projects
One of the “Mentor Dojo” students got this request from his manager. They wanted to estimate the growth of a all the objects of a certain tablespace or schema in one month. My first answer was “well, let’s assume the last month growth”,...
by Javier Morales Carreras | Nov 29, 2022 | GitHub projects
Imagine you have a disk full alert. Imagine now you have several tablespaces that have lots of free space, but when you try to shrink the tablespaces you find out many segments are placed in the last blocks of the file. Maybe you would move the last segment of the...
