Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Since Oracle 11g version, Data Pump allows to compress the backup before writing to dump file with “compression” parameter. The Compression parameter takes 4 values. …
Read More »
ORACLE
ORA-27104: system-defined limits for shared memory was misconfigured
In the Oracle 12c version, during database creation with dbca, this error is received because the shmall kernel parameter is not set correctly. The problem …
Read More »
What is ASM Failure Group
ASM Failure group is defined as protection against the problems in disk in ASM disk groups. Oracle provides disk redundancy with failure groups. If the …
Read More »
Cannot communicate with crsd
In Oracle RAC databases, for cluster operations, errors can be received because the crsd process is stopped or suspended. In this case, it should check …
Read More »
ORA-00600: internal error code, arguments: [kclantilock_17]
This error can be received from databases in Oracle 12.2 and later. This error causes Instance to restart. This is due to bug 27162390. The …
Read More »
ORA-00600: internal error code, arguments: [kdza_check_eq not in dictionary]
This error can be received when the HCC tables are queried or processed on databases in Oracle database 11.2.0.3 and above. It is seen because …
Read More »
Failed voting file relocation on diskgroup DBFS_DG
If access to cellnodes with voting files is not available, relocation errors can be received as follows, even if access is possible later. This error …
Read More »
How To Find Oracle Database Memory Usage(SGA and PGA)
The following query can be used to determine the memory usage rates in Oracle databases. If there is an increase in the memory values from …
Read More »
How To Find Current Open Cursors in Oracle
In Oracle, you can find the open cursors with the following query. The following error occurs when the number of open cursors reaches the open_cursors …
Read More »
How To Find Last Refresh Time of Materialized Views
The following queries can be used to determine when materialized views were last refreshed. For all times: [crayon-676c51944291d070000395/] For a specific time interval: [crayon-676c519442921702762803/] or …
Read More »