Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
PROBLEM: The error “java.sql.SQLException: OALL8 is in an inconsistent state” is being retrieved when the query is executed. REASON: The database version is incompatible with …
Read More »
ORACLE
Oracle Redo Log And Archive Log
Oracle uses Redo Logs and Archive Logs to ensure that the data written to the database will not be lost once it has been written …
Read More » Oracle Background Processes
The most important two components of Oracle Instance are SGA and Background Processes. Each Oracle Database process on the operating system is responsible for one …
Read More »ORA-00600: internal error code, arguments: [kpoal8-1]
Problem: When attempting to pull data from sql server with db link in Oracle database, ORA-600 error occurs. Reason: Setting the cursor_sharing parameter to force …
Read More »ORA-04052: error occured when looking up remote object
When using dblink in Oracle 11.2.04, we get ORA-04052 error when we want to create an object with the query result from dblink. To …
Read More »
Oracle Memory Components(SGA and PGA)
Oracle stores the following components in Memory. Program Code Connected sessions even if not active Information required during Query Execution. For example, if the query …
Read More »How To Run Backup Job Manually On Oracle
First, We connect to the node that the database is running with ssh. We see a list of backup jobs with the following command. …
Read More »How To Change Backup Retention AND Delete Obsolete Backup On RMAN
First, we connect to the node where the database is located with ssh. After loading the database’s profile, we connect to RMAN with the …
Read More »How To Check If There Is a Dictionary-Managed Tablespace On Oracle Database(Extent Management Control)
Extent Management Control can be LOCAL or Dictionary Based. If local, the information in the bitmaps in the datafile is used. If Dictionary Based, …
Read More »How To Move The Temp Tablespace to Another Diskgroup On Oracle
In some cases, you may need to move the TEMP tablespace to another diskgroup if there is no space left in the ASM or because …
Read More »