Rebalance DataFiles in SQL Server
Hi friends! In today’s post we are going to see how to rebalance large datafiles or several smaller ones of equal size. This task optimizes the disks, allowing the information …
Virtual columns in Oracle. Use and limitations
Hello everyone, today we wanted to refresh with you a utility of Oracle that although it is very powerful we usually use it little, virtual columns . Virtual columns are …
How to monitor GAP in AlwaysOn?
Good morning everyone! Today we will see how to monitor GAP in AlwaysOn to be able to react quickly and minimize the impact of recovering to the hardening point. This …
Conversions with CAST in PostgreSQL
Hello everyone, today we wanted to share with you an entry on how to make CAST conversions in PostgreSQL . This command exists in all databases and is used to …
Bug when creating a DB in RAC with dbca
Hello everyone, today we are going to talk about a bug that happened to our team in a client a few days ago. Occurred when creating a DB in RAC …
SQL Macros in Oracle Database 21c
Hello everyone. Today we wanted to discuss with you one of the new functionalities of Oracle 21C (although we have already started to see it from the 20th with limitations), …