This category contains 17 posts

New Background Processes in Oracle Database 11g

Oracle Database 11g introduced 56 new background processes. Note: The following post based on the Oracle Database 11g and briefly describes some important processes. These processes are mandatory and can be found in all typical database environment. PMON – Process Monitor Recover failed user process, Releasing resource, Rollback uncommitted Transaction SMON – System Monitor Instance … Continue reading

DDL_LOCK_TIMEOUT : Initialization parameter

What happen when you perform a DML operation and an another session performing a DDL operation on the same table? Session I Session II Oracle automatically places DML locks on the table that is being modified by a transaction. So if another session/user try to execute a DDL statement (CREATE/ALTER/DROP) against the table, the request … Continue reading

Configuring Data Guard in Heterogeneous Environment

With the release of Oracle database 11g, the primary and standby database in Data Guard configuration can be created in cross-platform environment. They can have different operating systems, os binaries (32/64 bit), oracle binaries (32/64 bit) and different CPU architecture. Following is the step-by-step approach to create cross-plateform (Linux-Windows) DG configuration. Environment: The following table … Continue reading

Introduction to Data Guard

Data Guard is Oracle’s High Availability Disaster Management solution. Disaster management in terms of protecting from Human errors, Natural disasters etc. Data Guard configuration consists of at least two databases: Primary and Standby (one or more). A primary database used to create standby database which in turns can be seen as a consistent copy of … Continue reading

A Short Guide to Oracle SQL [X] – Other Database Objects (Views)

ViEWS A view in a datbase is a virtual table (logical structure) based on a SELECT statement. Although a view contains no data itself, it acts much like a table. You can use (view) as the source for query, Some even allow you to INSERT, UPDATE and DELETE operations. The query on which view(s) are … Continue reading