I will continue to explain Oracle database architecture in this article. I’m adding the following image to be memorable. If you didn’t read the first …
Read More »Tag Archives: Redo log buffer
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 »