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

  With SQL Server Startup Parameters, the location of certain files in the startup phase of the SQL Server service, and some conditions in the …

  Note: These tips were based on upgrades from 11.2.0.4 to 12.1.0.2 (Linux and Solaris ONLY) OS user grid was the “owner” of the Grid …

  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 …