Wednesday 30 January 2013

Oracle Server

Oracle Server is a Database Management System which manage a large amount of Data in a Multi user environment so that many user can concurrently access the Same data.

It can be categorized into Logical and Physical Database.

Logical Database includes Instance which resides on a virtual memory of your computer i.e., RAM which is further categorized into 2 different parts :

  1. Memory Structure
  2. Background Process
Whereas, Physical Database resides on physical memory of your computer i.e., Hard disk which is further categorized into 3 parts :
  1. Data files
  2. Control files
  3. Online Redo Log files
Let's first discuss the Database architecture in brief in my next upcoming post and then will explore about the various components available in logical and physical database.