Oracle Notes Part-5

CURSOR: A cursor is a temporary work area created in the system memory when a SQL statement is executed. A cursor contains information on a select statement and the rows of data accessed by it.This temporary... Read more

Oracle Notes Part-4

Oracle Memory Architecture: Oracle memory architecture is divided in following memory structure:- System Global Area (SGA):- This is a large, shared memory segment that virtually all Oracle processes will access at one point or another. Process Global... Read more

Oracle Notes Part-3

A Snapshot is a recent copy of a table from db or in some cases, a subset of rows/cols of a table. They are used to dynamically replicate the data between distributed databases. Snapshot connected... Read more

Oracle Notes Part-2

Redo:In the Oracle RDBMS environment, redo logs comprise files in a proprietary format which log a history of all changes made to the database. Each redo log file consists of redo records. A redo record, also called a redo entry, holds... Read more

Oracle Notes Part-1

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. Oracle 9i is an... Read more