Oracle : Storage Management

STORAGE MANAGEMENT     In oracle, database space demanding objects are called segments. There are 5 different segments i.e. tables, indexes, temporary, undo, rollback segments.     Within a single server, we can create multiple database. Database contains one or more tablespace. One tablespace can… Read More


DATABASE CREATION   Oracle Database can create by using the following 3 methods Manual database creation OMF method (Oracle Managed database Files) DBCA method (Database Configuration Assistance)   Steps to create database in manual method.   Declare or specify variables or set up environmental variables:… Read More

Oracle : Oracle Server Architecture

Oracle Server Architecture   An Oracle server includes an Oracle Instance and an Oracle database. Oracle instance:  An Oracle Instance is a combination of two different sets of components. The first component includes the Memory components. That is nothing but SGA (shared global area or system global area)   The second… Read More