Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

Enqueues are shared memory structures that serialize access to database resources.(locks) They can be associated with a session or transaction. HW (high water mark) is …

When we create a database through SQL Server Management Studio version 17.3 and right click on it and click properties, we receive this error. To …

An active request represents a client- or application-centric view of I / O requests processed by the cell node. You can view active requests on …

We are able to configure some critical options set at instance level, such as MAXDOP, at the database level with Database Scoped Configurations feature of …

If you attempt to rebuild an entire index while rebuilding a partitioned index, you may receive an ORA-14086 error. [crayon-6768bd63a352e748140713/] To solve the problem, rebuild …

What is DBCC FREEPROCCACHE in SQL Server We can reset all plans in the plan cache with DBCC FREEPROCCACHE. Thus, each stored procedure has to …

If there is a session that uses the temp tablespace you are trying to drop, the drop operation starts waiting. The drop operation is completed …

What is dbcc clondatabase in SQL Server DBCC ClonDatabase announced with SQL Server 2014 SP2. We are able to create a copy of the database …

“enq: SS – contention” wait event may occur in problems with temp tablespace usage in Oracle RAC databases. At the same time, SMON may be …

We have been able to use Control Server Permission since SQL Server 2005. You can use this permission as an alternative to sysadmin. But it …