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

HADOOP MULTI NODE INSTALLATION PROCESS [ Note: I am creating multi node in most easiest way by creating and using everything in root mode on …

  You can get the below error when you run the ADDR AWR report in the Oracle Standard edition database. “ORA-13716: Diagnostic Package License is …

  Lock Compatibility provides the necessary control when multiple transactions have the same lock request (row, page). If the resource is previously locked by a …

  Some time we are facing issue like we forgot the MySQL root password. So here we are providing just some simple steps to reset …

  SQL Server implements different types of locks that determine how concurrent query requests access the data. For example, imagine that one user wants to …

Problem: If a disk previously included in an ASM disk group is attempted to be used for another disk group, it will fail with the …

  Adding Space to Sybase IQ server Little background about IQ space. In IQ 15.0 Dbspace != dbfile Under one dbspace we can have many dbfiles …

  Master-Master Replication setup Replication makes data highly available for applications and websites, master-master replication is an active-active cluster kind of solution which can be …

  The PAGELATCH_EX and PAGELATCH_SH wait types are errors that occur when writing to the same page in memory at the same time. These errors …

  If you are beginner then this post will help you to monitor the mysql server. Here I am listing some most commonly used MySQL …