In Oracle databases, over time, indexes are fragmented and cause serious performance issues. We should check the indexes regularly and rebuild them if necessary. Determine …

You can find information about creating SQL Database in Azure in this article. If you are creating a Stretch Database, you must first create a …

If the password file format in the 12c databases is same with the format in the 11g databases, you receive the error “ORA-28017: The password …

In Azure, you can create a virtual machine to manage SQL Server databases. In this article, I will explain how to create this virtual machine …

You may see this error in the database alert log file during upgrade from 11.2 to 12.2. [crayon-674034fa2a387911498691/] The reason for this error is that …

What is Stretch Database? If you want to archive your old data to Azure, all you need is StretchDatabase. You can then query as you …

When running Database Configuration Assistant (dbca) on Exadata compute nodes, you will receive this error if all nodes cannot connect to each other without password …

What is PolyBase? This article contains information about PolyBase in sql server. Use cases, installation steps,configuring polybase cluster. With PolyBase; We can bridge between SQL …

Enable Unified Auditing Relink is required to enable the new audit mechanism announced with Oracle database 12c (12.1). You can do this as follows. First, …

Tempdb is a very important system database for heavily used systems. If it is not configured correctly, it can cause serious performance problems in the …