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 »Database Scoped Configurations in SQL Server 2016 and SQL Server 2017
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 »ORA-14086: a partitioned index may not be rebuilt as a whole
If you attempt to rebuild an entire index while rebuilding a partitioned index, you may receive an ORA-14086 error. [crayon-66279dbcefdda979487145/] To solve the problem, rebuild …
Read More »DBCC FREEPROCCACHE and DBCC DROPCLEANBUFFERS
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 »Drop Temp Tablespace Taking Long Time
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 »DBCC clondatabase in SQL Server
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
“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 »Differences Between sysadmin and CONTROL SERVER in SQL Server
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 »How To Connect To Oracle Cloud Database using SSH
We can connect to database servers in Oracle Cloud environment or other linux servers using ssh private key. After creating a server or database deployment, …
Read More »How To Create SSH Key Pair for Oracle Cloud
We connect to all servers that we create in Oracle Cloud environment with ssh public and private key. When creating our database server or normal …
Read More »