Oracle Database

Introduction to Oracle Database

      It is very large and multi user Database Management System. Oracle Database is a collection of data treated as a unit. The purpose of a database is to store data and retrieve related information. 

      Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. It is the excellent database server choice for client/computing. Oracle supports in all major operating system.

      The database has logical structures and physical structures. Because the physical and logical structures are separate, the physical storage of data can be managed without affecting the access to logical storage structures.


      i – internet
      g – grid
      c – cloud


1977 : Software Development Laboratories, the precursor to Oracle is founded by Larry Ellison, Bob Miner and Ed Oates.

1978 :  Oracle Version 1, written in assembly language runs on PDP-11 under RSX in 128K of memory. Implementation separates Oracle code and user code. Oracle V1 is never officially released.

1979 : Oracle Version 2, the first commercial SQL relational database management system was released. The company changed its name to Relational Software Inc. (RSI).

1981 :  RSI Started developing tools for Oracle.

1982 :  RSI Renamed as Oracle Corporation.

1983 :  Oracle Released version 3.0 (rewritten in C language and multiple Platforms).

1984/1985 : Oracle Released version 4.0 ( Concurrency control , consistency etc)

1986 :  Oracle Released client/server relational database.

1989 :  Oracle Released version 6.0.

1997 :  Oracle Released version 8.0 (object relational).

1999 :  Oracle Released version 8i (internet) (Java Virtual Machine).

2000 :  Oracle Released Application Server.

2001 :  Oracle Released  9i (internet) Database server.

2003/2004 :  Oracle Released 10g (Grid) Database server.

2009 :  Oracle Released  Oracle version 11g (Grid) Database server.

2014 :  Oracle Released  Oracle 12c (Cloud) Database server.

Feature of Oracle Database Server

  • Portability
  • Self Managing Database
  • Concurrency
  • Read Consistency
  • Locking Mechanisms
  • SQL *Plus
  • ASM
  • Data Warehousing
  • Data mining
  • Analytic SQL
  • Partitioning
  • Resource Manager
  • Materialized Views
  • Table Compression
  • Parallel Execution

Chapters : 

Part 1 :

  1. Installation of Oracle 11g
  2. Create database
  3. Startup and Shutdown

Part 2:

  1. Architecture
  2. Schema Management
  3. Transaction Management

Part 3: 

  1. User Management
  2. Oracle Networking

Part 4:

  1. Tools in Oracle Database
  2. Backup Databases
  3. Database Recovery
  4. Cloning Databases

Part 5:

  1. SQL *Plus
  2. Oracle Enterprise Manager

Part 6:

  1. ASM and ADDM
  2. Managing and Monitoring

Part 7:

  1. SQL Query Optimization
  2. Tuning Oracle Instance