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

With SQL Server 2017, a new dmv named sys.dm_tran_version_store_space_usage was announced to find out which database uses how much space due to row versioning in …

When the Exadata database is upgraded to version 12.2, “gc cr request” and “gc buffer busy acquire” wait events occur in many operations in the …

Tables created with SELECT INTO prior to SQL Server 2017 could not be created on a filegroup other than the PRIMARY filegroup. Now we can …

During the index rebuild process, if some of the blocks belonging to the index are on a corrupted datafile, you receive the error “ORA-08102: index …

What is Automatic Tuning in SQL Server? Automatic Tuning is announced with SQL Server 2017. Automatic Tuning is a database feature that identifies potential performance …

Due to an unknown situation in Oracle 11g databases, “ORA-00600: internal error code, arguments: [qcsprfro_tree: jrs present]” error is received during refresh of some materialized …

What is GraphDB? GraphDB introduced in SQL Server 2017. We will examine GraphDB with examples in this article. At the end of the article, we …

What is Resumable Index? When rebuilding indexes online, index rebuild process could be fail for reasons such as failover, disk failure, manual stop (PAUSE). In …

With the DBMS_REDEFINITION package in the Oracle database, it is possible to modify the structure of the tables online. We can convert a non-partitioned table …

Being a DBA we must know the difference between the SQL profile and the baselines. To start with we know that optimizer uses the information …