Although passwordless ssh connection is established between compute node and cell nodes in the Exadata installation, this connection can be broken due to some problems. …
Read More »
Although passwordless ssh connection is established between compute node and cell nodes in the Exadata installation, this connection can be broken due to some problems. …
Read More »This is because the user account that the SQL Server service is running on is not authorized in the MSSQL Registry files. Solution -> Run …
Read More »Gaps occur in the blocks due to deletion operations in the tables. These spaces remain as wasted space. These spaces should be determined and shrink …
Read More »With SQL Server 2016, support for automatic update statistics in Memory Optimized Tables is available. If the database is created with compatibility level 130, nothing …
Read More »Oracle attempts to put a lock on the table with the foreign key if a change is made to the main table with the primary …
Read More »When I tried to open SQL Server 2017 Configuration Manager, I received an error like the following. My problem is solved when I follow the …
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 »