Database Tutorials

How To Find Wasted Space in Table in Oracle

Gaps occur in the blocks due to deletion operations in the tables. These spaces remain as wasted space. These spaces

With SQL Server 2016, support for automatic update statistics in Memory Optimized Tables is available. If the database is created

Oracle attempts to put a lock on the table with the foreign key if a change is made to the

When I tried to open SQL Server 2017 Configuration Manager, I received an error like the following. My problem is

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

When we create a database through SQL Server Management Studio version 17.3 and right click on it and click properties,

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

We are able to configure some critical options set at instance level, such as MAXDOP, at the database level with

If you attempt to rebuild an entire index while rebuilding a partitioned index, you may receive an ORA-14086 error.

SQL> alter index index01 rebuild;

 alter index index01 rebuild
 ERROR at line 1:
 ORA-14086: a partitioned index may not be rebuilt as a whole

SQL> alter index index01 rebuild;

alter index index01 rebuild

ERROR at line 1:

ORA-14086: a partitioned index may not be rebuilt as a whole

What is DBCC FREEPROCCACHE in SQL Server We can reset all plans in the plan cache with DBCC FREEPROCCACHE. Thus,