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

  There may be a slowdown when you query dba_free_space or tablespaces via Toad on 12C databases. The slowness is due to the fact that …

  The “Select Top 1000 Rows” and “Edit Top 200 Rows” options in SSMS are known to many people interested in SQL Server. I never …

  EXP Functions calculates the exponential value of a parameter that has the float data type. This function’s return data type is float. Below you …

You can see “WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.” warnings at certain intervals in the database alert log file. …

  Most companies have a backup strategy, maintenance procedures. In my article “SQL Server Maintenance“, you can find details about maintenance on sql server. Therefore, …

  The CEILING function returns the smallest integer value greater than a number. If the number is already an integer, it returns the same number …

  If the RMAN restore hangs with the “starting implicit crosscheck backup” error and has not been completed for a long time, you may have …

  Checksum and TornPage Concepts are Page Verify Options. Page Verify is a SQL Server Database Property. Both are methods used to discover and report …

The ABS function returns the positive value of a negative number. The return data type is the data type of the input parameter. The ABS …

  Because the cluster_interconnects parameter is set incorrectly in the database instances on Exadata, one or more of the instances can be closed with the …