Oracle DBA Tutorial

This tutorial gives you an overview and talks about the fundamentals of Oracle DBA.

ORACLE DATABASE 12C ARCHITECTURE

This section highlights the concepts and a general overview of the players that deliver this proprietary database management system. These players fall into three main categories:

Shared memory a section of the host server’s memory through which all the data passes and the applications’ code is stored and executed

System support infrastructure a mix of background and foreground processes that perform the tasks required to facilitate the application interaction with the 12c database

Operating system files a suite of no less than ten files that play individual roles as the database runs.

The next three sections address these players and provide a bird’s-eye view of what they do.

SHARED MEMORY

Shared memory is nothing more than a newfangled name for what was and is sometimes still referred to as RAM—random access memory. As the 12c database is started, a handful of entries in its system parameter file contribute to the size of memory allocated to the instance. Many adopters of the Oracle technology use the words “database” and “instance” synonymously. There is a fundamental difference between the two.

* A database is an assortment of files that store data plus a handful of worker files that facilitate application access.
* An instance is a segment of shared memory and support processes that provide the capability for applications to work with the data stored in the database. Once the instance is started, the following areas of shared memory play a role in database management activities:
* The system global area, or SGA, contains data and control information from a single database instance.

The program global area, or PGA, is part of the memory allocated to a 12c instance as it is started. Unlike the memory in the SGA, PGA memory is not shared. It contains data and control information specific to server processes, not the instance as a whole.

*The user global area, or UGA, is memory associated with each user session.
*Even though it is allocated from PGA memory, the UGA is discussed as one of the four main memory components.
*Software code areas are where SQL code is prepared for execution and sits in memory until used.
*It would be impossible to get into the details of each of these components; as you encounter the memory structures that  support a running Oracle instance, the terminology will not be brand new. Below Figure is a graphical representation of the  bullet points just discussed with minimal drill-down.

For more information visit Mindmajix