//
archives

Archive for

A Short Guide to Oracle SQL [X] – Other Database Objects [Index]

Indexes are optional database objects that (if used properly) can increase the performance of queries. When retrieve data from the table Oracle has two options to do, First reads every row in the table (Full Table scan) or use the index to find the relevant rows quickly. Full table scan in itself is a resource … Continue reading

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

PL/SQL New Feature : CONTINUE statement

CONTINUE statement is finally comes with Oracle 11g. It comes in two forms: CONTINUE Continue statement terminates the current iteration of the loop and passes the control to the next iteration of the loop. NOTE: CONTINUE statement condition evaluates with the help of IF statement. CONTINUE WHEN Same as CONTINUE statement. But the condition in … 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