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

  Hello everyone, Today I want to talk about new auditing features on Oracle 12c. As you know in Oracle 11g and below versions there …

  If the connection breaks  and timeouts occurs due to network problems and you cannot convince your network team, you can monitor events between client …

  A few weeks ago a client called around 11:00 pm and said that they received an error in a very critical Microsoft SQL Server …

I will configure SQL Server AlwaysOn Availability Groups step by step in this article. First I want to tell about SQL Server Alwas ON. What …

  OPatch consists of patching utilities that help ensure your Oracle software stays current and secure. Oracle recommends that you use the latest released OPatch, …

  Displaying an execution plan is made easy if you use the DBMS_XPLAN package. This packages provides several PL/SQL procedures to display the plan from …

  In my previous article, I mentioned how to solve Oracle Password Expired Error (ORA-28001). In some cases, we must unlock user with the existing …

  There are thousands of queries submitted per minute and it is too much data. But, To avoid the performance impact on the database due …

  In this article, I will show you how to change users’ password expire policy. By default, all created users in Oracle Database will be expired …

  You may receive an error as follows when you try to install a different extension package that is not in Postgresql’s repo. To solve …