DBCC CHECKFILEGROUP checks the consistency of all tables and indexed views on the filegroup. To examine in more detail what Filegroup is, you can read …

  We can change the size of the ACFS file system online without requiring any umount or disable volume. We use the acfsutil tool for …

The DBCC CHECKDB command is used to detect and repair logical and physical errors that occur in the database. When you run the DBCC CHECKDB …

  In busy databases you may encounter this wait event. The general reason is the low redo log I/O performance or the slow interconnect connection. …

  DBCC UPDATEUSAGE Detects and corrects errors in Page and row numbers. Prior to SQL Server 2005, the number of rows of some of the …

  The default is case sensitive, so the following query returns no lowercase. In this case, the returned result will contain missing data. [crayon-674119a5f3267951600834/] If …

DBCC CHECKCATALOG performs various consistency tests between system metadata tables. If you run DBCC CHECKDB, you do not need to run DBCC CHECKCATALOG. For details …

  Oracle ASM Cluster File System (ACFS) is used to create a cluster file system via ASM. The created file system will use the space …

  When we create our tables, we set some columns to be null, so that some columns are never null. If the columns that we …

  There are many tables and views in Oracle database that we can get information about with locked objects. You can access a lot of …