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

With the disable_archive_logging parameter, which is a feature introduced with Oracle 12c, we are able to import without producing redo in a database in archivelog …

There are many hidden parameters in Oracle databases. These parameters should be changed if required by Oracle. Unconscious change of these parameters can be a …

Before you start reading this article, I suggest you read the article “Index Concept and Performance Effect on SQL Server” for more detailed information about …

oratop is a utility that provides a general knowledge of database performance, similar to the top command in linux systems. When used with the Top …

Find a Column Name in Whole Database Sometimes you may want to search for a column name in whole database. Instead of looking all the …

During the database shutdown process, this alert is written to the alert log file because the processes of the running jobs cannot be propagated. The …

In particular, if you are using Always On Availability Group and you haven’t included some of your databases to an always on availability groups, in …

With a feature that introduced with 12c R2, we can see the history of Sqlplus and run the commands we have run without rewriting. By …

One of the first steps a good database administrator should take when looking at a database system is to find and remove unused indexes and …

It is possible to forget the passwords of the users in the DB Links created for the communication between Oracle databases. These users’ passwords can …