You may receive this error when there are multiple IPs on the same server that use the same port. In this case, you cannot run …

With DBCC SHOW_STATISTICS we can get detailed information about a statistic. As many of you know, statistics have one of the most important roles in …

To perform various operations on database objects, system and object privileges must be assigned to users. Each system privilege allows a user to perform certain …

You can find the undo usage of a session with the following query. Historical information is also available. You can find the undo usage of …

Its is a feature announced with SQL Server 2014. It can be very useful if you have a partition in your database. If you don’t …

You may need to enable trace for a session for many reasons. For example, you may need to determine which queries run in a session. …

COLUMNSTORE_ARCHIVE option was introduced with SQL Server 2014. If we want to archive ColumnStore Tables or Indexes, we can compress our columnstore tables or indexes …

The PDB$SEED or SEED database is a pluggable database template for pluggable databases to be created by users. Used as a template to create new …

WAIT_AT_LOW_PRIORITY is a feature introduced with SQL Server 2014. We can control the Online Index Rebuild and switch partition operations. For example, suppose we perform …

You can query the CDB column in the V$DATABASE view to see if a database is CDB. If the current database is CDB, the column …