What is the architecture of Oracle Database?
An Oracle Real Application Clusters (Oracle RAC) database architecture consists of multiple instances that run on separate server machines. All of them share the same database. The cluster of server machines appear as a single server on one end, and end users and applications on the other end.
What is SGA and PGA in Oracle 11g?
The SGA is shared by all server and background processes. Examples of data stored in the SGA include cached data blocks and shared SQL areas. Program global area (PGA) A PGA is a nonshared memory region that contains data and control information exclusively for use by an Oracle process.
What is 11g database?
Version 11g of the Oracle Database, which included built-in testing for changes, the capability of viewing tables back in time, superior compression of all types of data and enhanced disaster recovery functions. The “g” stood for “grid computing,” which supports clusters of servers that are treated as a single unit.
What are Oracle 11g features?
Support for data compression is nothing new in Oracle Database, but 11g takes the concept to a new level with Advanced and Hybrid Columnar Compression. Explore SQL Result Cache, PL/SQL Function Cache, and Database Resident Connection Pooling.
What is Oracle architecture with diagram?
There are three major structures in Oracle Database server architecture: memory structures, process structures, and storage structures. A basic Oracle database system consists of an Oracle database and a database instance. The database consists of both physical structures and logical structures.
What is database architecture?
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, changed, replaced, and altered.
What is difference between SGA and PGA?
A PGA is created by Oracle when a server process is started. The information in a PGA depends on the Oracle configuration. SGA (System Global Area) is an area of memory (RAM) allocated when an Oracle Instance starts up.
What is the difference between Oracle Database 11g and 12c?
Oracle 12c is just upgraded version of the Oracle 11g with some new features like cloud support and pluggable database, kind of like master slave architecture. With the Oracle 12 c, you can plug your database to cloud anytime. It has multiple new features like JSON support, multitenant architecture and etc.
What is the major difference between Oracle 11g and 12c?
The main difference between Oracle 11g and 12c is that the Oracle 11g has no pluggable databases while Oracle 12c has pluggable databases. Moreover, Oracle 12c allows running multiple databases on the same hardware while maintaining the security and isolation among the databases.