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

  Sometimes SQL Server becomes inaccessible and DBA cannot even intervene. In such cases, there is a back door so that DBAs can find and …

You can query errors in Alert.log by sql query. You can use the following queries for this. The following query returns with 20 rows.   …

  Hello Everyone, This is my first blog here regarding db2 database monitoring.I am going to start from the basic level ,therefore starts and learners …

  SQL Server Configuration Manager is a tool in which many settings of SQL Server are made. In this article, I’ll refer to many of …

  The error ORA-04031 occurs on the shared pool which can indicate one of two things: 1) Insufficient space for the shared pool OR 2) …

  You should read below articles before reading this article. “How to improve database performance on MongoDB part 1“, “How to improve database performance on …

  Oracle data pump is new version of imp and exp utilities. It is faster and flexible to the imp and exp utilities used in previous Oracle …

  If you have cloned an existing server as another server, even if ASM disks and all files are moved, then services like ohas css …

Before installing MySQL instance, we must evaluate the CPU, Memory, Disk IO performance, Disk size, network of the server, also the maximal QPS(Query Per Second), concurrent …

  This article is the second article of the performance series. You can find the first articles link “POSTGRESQL DATABASE PERFORMANCE – 1” In the …