Architecture of Oracle Memory Structure Oracle database creates and uses memory structures for program code, data shared among users, private data areas for each connected user, cached data. 1. System global area A system global area (SGA) is a group of shared memory structures that contain data and control informationRead More →
Oracle Oracle is relational database management system which uses relational data model. In the relational data model, data is seen by the users in the form of tables. Oracle Server Oracle server consist of an oracle instance and a oracle database. Oracle Instance Oracle instance consist of memory and process.Read More →
A database architecture is a representation of DBMS design. It helps to design, develop, implement, and maintain the database management system. A DBMS architecture allows dividing the database system into individual components that can be independently modified. Two-Tier Client Server Architecture The 2-tier architecture is same as basic client-server. InRead More →
What is DBA? DBA stands for database administration. Database administration refers to the whole set of activities performed by a database administrator to ensure that a database is always available as needed. Roles and Responsibilities of Database Administrator Installation and configuration: The DBA must install and customize the database softwareRead More →
