by Javier Morales Carreras | Mar 14, 2023 | SQL
When you filter a column using a function, the optimizer does not use the indexes on that particular column because the function “transforms” the values and makes the index non useful to get the proper ROWIDs. To get around that hurdle, Oracle has...
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 | 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...
