Oracle Server Architecture

  • There are two tiers in oracle client tier and server tier.
  • Client tierconsist of two components they are
    1. User
    2. Processes
  • Server tierhas three components they are.
    1. Server Process that execute SQL
    2. The Instance
    3. The Database itself
  • Each user will interact with -> user process.
  • Each user process interact with -> a server process
  • Each sever process interact with -> instance and database
  • User& server makeup as a session launched on demand of user
  • Instance & memory structure are launched by DB Admin
  • User processit can be any client-side softwarecapable of connecting to oracle server process. Eg:- SQL*Plus & SQL Developer.
  • RACReal Application Cluster it provide more flexibility performance& zero down time, It can ability to add dynamically more instance running on more node to DB.
                                                              Oracle Server Architecture
Previous
Next Post »