by Javier Morales Carreras | Nov 29, 2024 | Database, SQL
A few days ago, in the Café Database Discord Server Administration channel, someone asked how a chain of job executions could be implemented with DBMS_SCHEDULER. The idea is that when a task finishes, it waits two minutes and runs again. The problem is that the...
by Javier Morales Carreras | Mar 2, 2024 | Database
In 2019 they decided in Chile that the winter time adjustment would be 5 months, instead of the usual 3 months. Morocco also decided to move its time with respect to GMT from +00 to +01. These changes that you may think do not affect you in the least, unless you live...
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 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...
