In this article I will tell you about Oracle Database Architecture. Oracle Database is the most preferred database in the world, especially in large scale …
Read More »Tag Archives: PGA
Oracle Background Processes
The most important two components of Oracle Instance are SGA and Background Processes. Each Oracle Database process on the operating system is responsible for one …
Read More »Oracle Memory Components(SGA and PGA)
Oracle stores the following components in Memory. Program Code Connected sessions even if not active Information required during Query Execution. For example, if the query …
Read More »