![oracle database architecture 11g oracle database architecture 11g](https://blogs.sap.com/wp-content/uploads/2015/04/oracle12c_694716.png)
- #Oracle database architecture 11g how to
- #Oracle database architecture 11g archive
- #Oracle database architecture 11g password
SGA is allocated when an Oracle instance (database) is started up,based on values specified in the initialization parameter file (either PFILE or SPFILE).
#Oracle database architecture 11g how to
It also stores parameters to specify how to startup a database however, its parameters can be modified while the database is running.Ĭollection of some process which will be running in background and some memory will be allocated inside the RAM is called instance. The spfile.ora is a dynamic parameter file. For example, some parameters will specify how to allocate memory to the various parts of the system global area. It contains parameters that specify how the database instance is to start up. The init.ora file (also called the PFILE) is a static parameter file. Parameter File-there are two types of parameter files.Alert and Trace Log Files – these files store information about errors and actions taken that affect the configuration of the database.Archived redo log files-these are copies of the redo log files and are necessary for recovery in an online, transaction-processing environment in the event of a disk failure.
#Oracle database architecture 11g password
Password File–authenticates special users of the database –specifies which *special* users are authenticated to startup/shut down an Oracle Instance.Redo log files – these contain a chronological record of changes made to the database, and enable recovery when failures occur.
![oracle database architecture 11g oracle database architecture 11g](http://www.premieronlinetrainings.com/assets/img/dbarchitecture11.jpg)
Control files – these are used to synchronize all database activities and are covered in more detail in a later module.Datafiles – these contain the organization’s actual data.The Oracle server also accesses parameter files and password files.Īs was noted above, an Oracle database consists of physical files.