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

  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 usually occur when too many …

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

  We can use Backup Restore for many operations. Below you can find the most common reasons for using it. 1. To get a regular backup 2. To get an …

Error: When creating an Oracle database in Windows operating system: ORA-12546 TNS: permission denied ORA-12560 TNS protocol adpater error ORA-516 Permission denied From SQL * Net trace: …. nladtrm: exit …

  Single Node Architecture: when we talk about Sybase IQ architecture , We should explain about the Three important IQ stores and three main files. which plays a vital role in …

  Replication: Replication is a way of copying and distributing data and database objects from master to slave servers. These databases are synchronized to maintain consistency. Note that replication is …

  In a Master/Slave replication data consistency is a biggest concern and is very easy  to break your replication with  issues such as duplicate keys, missing rows , accidental writes from …

– Requirements This topic assumes that you have user with sudo privileges and have MySQL installed on both server(Master & Slave). If you do not have MySQL server installed, you …

  Fragmentation on MongoDB databases When we removing a large amount of data from the collection and no plan to replace it, we generate a fragmentation, to deal with it, …

It will display current running processes: [crayon-5f6f2e5412d53416624985/]   It will display processes which is running by “dbmaint” user id: [crayon-5f6f2e5412d58597109242/]   It will display databases names available on Server: [crayon-5f6f2e5412d59056792029/] …