Oracle Database Architecture

Rameshdba.com

 The contents are of my own testing and deployments. Not guaranteed that these might work in your environment. Please test before usage.


Oracle Database Architecture

In this article I will explain the Oracle Database Architecture,

1)Oracle Database is the most preferred database in the world, especially in large scale projects

2)To be able to learn the Oracle Database in detail, the first thing that should be done is knowing the Oracle Database architecture. 

3)So what happens in the background when the user starts a transaction.


Overview

1)When Oracle Database is running, a memory space that we call the shared global area (SGA) on the operating system is allocated to Oracle. 

2)At the same time, some processes that we call background processes are started by Oracle to meet the demands of the database. Oracle Instance consists of SGA + Background processes. 

3)The following image shows the Oracle Database architecture beautifully. I’ll explain all the concepts through this image.





                                                                        Thanks for the time!!


1 Comments

DELETE Statement in ORACLE DB— Step by Step Internal Flow with classroom example.

by
Imagine your Oracle database like a school, and you’re Teacher decides to remove a student (row) from the classroom(table). Let’s see how the journey works step by step: 1)Classroom = Oracle Table 2)Students = Rows (Records) 3)Class Teacher = Oracle Server Process 4)Attendance Register = Data Dictionary User fires DELETE statement: DELETE FROM students WHERE grade = 'D'; Internal Processing Steps: Client Process Sends DELETE Statement to Server Process The teacher receives a request to remove a student from the classroom. Syntax Check (Parsing) The teacher checks if the request is grammatically correct — proper command, keywords, and a semicolon. Semantic Check Teacher verifies if the classroom exists and whether the condition (like grade = 'D') makes sense. Object Resolution Teacher confirms that the ‘students’ classroom (table) exists in the school records (data dictionary). Optimization Decides the fastest way to find those students — by roll number, grade, or al...
Image