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

  This is probably one of the trickiest question that as DBA I get, and trust me, it happens very often and the funny thing …

  When you set the resource_limit parameter to true in the database and set the idle_time parameter in the profiles to a value other than …

  No one should be authorized at server level on instance except DBAs. In some cases, as an exception, you may be granted some users …

  You cannot always work with gui with DBCA. You can also perform all your operations in slient mode when you need to work from …

  If Goldengate doesn’t start with errors like this, the solution is very easy. Possible errors: Not enough database memory to honor requested MAX_SGA_SIZE of …

  With the help of the following script, you can find the date of the last backup of each database on that instance. ‘L’ indicates …

One of the information I needed most is the file version. You can learn this in unix systems with the following command. [crayon-6741b6a380f56775927830/]

  Policy-Based Management is a feature that introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …

  If you are wondering which execution plan the query is using when you run a query, you must run the command “set autotrace on …

  First of all, don’t forget to take backup for the security of your data. You can change the database’s collation with the following code. …