Introducing Oracle Net Services Oracle Net services are often used to enable network connections for applications or different clients to connect to databases. Allows connection …

In this article I will explain how to configure SQL Server Instance through SSMS. Right-click on the instance via SSMS and click properties. You will …

What is a Multitenant Database? As of version 12.1, you can design your databases as a multitenant database (CDB). It consists of a container database, …

With SQL Server 2017, a new dmv named sys.dm_tran_version_store_space_usage was announced to find out which database uses how much space due to row versioning in …

When the Exadata database is upgraded to version 12.2, “gc cr request” and “gc buffer busy acquire” wait events occur in many operations in the …

Tables created with SELECT INTO prior to SQL Server 2017 could not be created on a filegroup other than the PRIMARY filegroup. Now we can …

During the index rebuild process, if some of the blocks belonging to the index are on a corrupted datafile, you receive the error “ORA-08102: index …

What is Automatic Tuning in SQL Server? Automatic Tuning is announced with SQL Server 2017. Automatic Tuning is a database feature that identifies potential performance …

Due to an unknown situation in Oracle 11g databases, “ORA-00600: internal error code, arguments: [qcsprfro_tree: jrs present]” error is received during refresh of some materialized …

What is Resumable Index? When rebuilding indexes online, index rebuild process could be fail for reasons such as failover, disk failure, manual stop (PAUSE). In …