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 | Mar 7, 2023 | GoldenGate
When you first start a replication deployment with Oracle GoldenGate, it’s easy that you miss one or several steps that lead you so some errors. Sometimes, the error message in GoldenGate is not so descriptive, or the implications within are not so clear, so...
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...