Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

  In some cases, automatic maintenance jobs are closed in databases. In this case, the schema statistics are not collected and cause serious performance problems. …

  Tail Log Backup takes the backup of log records that have not yet been backed up. We can use this backup to return to …

  If you receive errors in the form of ORA-20005 and ORA-06512 during the collection of the table statistics, you must unlock the relevant table …

DBCC CHECKTABLE is used to test the consistency of a table or indexed view. The DBCC CHECKTABLE command performs the same operations as the DBCC …

  In the Replication Monitor, you can see a message for a long time in the tab “Distributor to Subscriber History”. When you see this …

  In some cases, depending on the corruption of the binary files, strange behavior can be observed in the program. It’s possible to encounter strange …

When the database is created or manually increased in size or when it grows with auto growth, it allocates a space over the disk. With …

  In the previous post we discussed how it is possible to extract your Integer values from IBM’s new Db2 table as of Db2 for …

  ERROR MESSAGE: “The database must be online to have a database snapshot.” EXPLANATION: You may encounter an error message when you create the Database …

  Indexes are usually not maintained in Oracle databases. But indexes need to be checked regularly. If an index is created and not checked, it …