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 …
Read More »
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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »If you attempt to rebuild an entire index while rebuilding a partitioned index, you may receive an ORA-14086 error. [crayon-68197dc7ccea3400656491/] To solve the problem, rebuild …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »“enq: SS – contention” wait event may occur in problems with temp tablespace usage in Oracle RAC databases. At the same time, SMON may be …
Read More »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 …
Read More »