The Oracle Database Server Consists of :
1)Oracle Instance
2)Physical Database
Let us discuss these components of Oracle Database Server:
1)Oracle Instance : The Instance consists of a Memory Area known as SGA(System Global Area) and the Background Processes.When a DB is started, it is the Instance which gets loaded into the RAM.Hence the SGA is provided as part of RAM.We will be discussing the SGA components and various Background processes in detail.
2)Physical Database : The Physical Database consists of OS level files termed as :
1)Oracle Instance
2)Physical Database
Let us discuss these components of Oracle Database Server:
1)Oracle Instance : The Instance consists of a Memory Area known as SGA(System Global Area) and the Background Processes.When a DB is started, it is the Instance which gets loaded into the RAM.Hence the SGA is provided as part of RAM.We will be discussing the SGA components and various Background processes in detail.
2)Physical Database : The Physical Database consists of OS level files termed as :
- Data Files
- Control File
- Redo Log Files
Besides these, there are other files like Password File,Parameter File and Archive Log Files.
Pictorial Representation of the same is as below :
I will discuss each of these Memory Structures and Background Processes in detail in my next post.
Pictorial Representation of the same is as below :
I will discuss each of these Memory Structures and Background Processes in detail in my next post.
No comments:
Post a Comment