From time to time we have to check the integrity of our bases for any corruptions. In this article we will see the easiest and most efficient way to check for corruption in all instance databases. This… read more
How can we connect Oracle Database to SQL Server using Oracle Gateway on Windows
In a previous article we saw how we can run queries on a remote SQL Server from an Oracle Database located on Linux through Oracle Database Gateway. In this article we will see how to install Oracle Gateway respectively... read more
How can we get email whenever PGA memory exceeds a limit in Oracle database
When an Oracle database is heavily used by many connections / sessions, one or some of them may consume a large percentage of memory (RAM). If there is a problem and it is not addressed due to lack of memory it may… read more
How to bulk detach / attach databases in SQL Server
Sometimes we will need to move databases to SQL Server. This process can also be done with backup / restore or by changing the status of the base to offline, but in the article we will deal with the detach and attach processes. read more
How to enforce password policy in an Oracle database
As we know in an Oracle database through User Profiles we can set restrictions on user groups regarding when and if a password expires (PASSWORD_LIFE_TIME), how many days it can be changed before it stops... read more
How do we change the name of the user / schema in an Oracle database
Using an Oracle Database we may at some point need to change the name of a user and a schema. Until version 11g this was not possible and we would have to create a new user and export/import with remap_schema. We can… read more
How we collect deadlocked queries via Extended Event and how we read its data
In an earlier article we saw how we create an Extended Event to see queries with a long duration. In this article we will build Extended Event that records deadlocks. All we need to do is create it with a T-SQL command. After… read more
How do we apply a patch in an Oracle Data Guard environment (even online)
In a previous article we saw how to patch an Oracle database. In this article we will see the same process in an Oracle Data Guard environment on a UNIX operating system. The steps we will follow allow us to… read more
How can we from SQL Server read Excel / CSV / TXT and insert the records into a table
SQL Server allows us to read and import files at will without the use of SSIS (Integration Services) and Wizard packages. This process is done using the OPENROWSET function and the BULK INSERT. We can… read more
