- There are two tiers in oracle client tier and server tier.
- Client tierconsist of two components they are
- User
- Processes
- Server tierhas three components they are.
- Server Process that execute SQL
- The Instance
- 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.
- RAC– Real 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
ConversionConversion EmoticonEmoticon