쉐도잉 연습: Oracle database architecture explanation in details - 영상으로 영어 말하기 배우기

연습 모드 선택

각 모드는 전체 화면 연습실로 열립니다.

160 문장

문장이 너무 짧거나 길면 Edit를 눌러 조정하세요.

Hi friends, today in this video I am going to talk about Oracle Database.

Oracle Database is basically one of the most demanding database which has started by Oracle Corporation in 1971.

So even when you are starting your career as Oracle Database,

in most of the interview you will get so many questions from Oracle Database Architect.

So in that perspective also and even for learning Oracle Database,

this is one of the most demanding topic that you have to must learn with deep understanding.

So I am going to explain with my personal experience on Oracle Database because I am a database administrator.

So with my personal understanding,

with my personal experience, I am going to explain the whole architecture.

so yeah first of all whenever any end user wants to connect

or a database so it connects through use any client machine

or through any application end user application

or even through sql developer there are multiple platform from there you people connects to the database

so you know client machine it will create a user user process

and between user process

and server process there will be a listener listener will have information about the host

and port of an database with on the

with that it will decide which database it has to connect so it will it will generate a one dispatch

dispatcher request when that dispatcher will send that request to the server process

and server process are when

when you create a database by default it creates a dedicated server process

and server process basically sits on uh servers oracle server side

so when we create a database it will get created by default it will be a dedicated server process

and for dedicated server process it will create a PGA

that is called program global area but

if you are choosing a shared global area for that it will create UGA that is user global area.

So server process is basically responsible for making that connection to the database

because it's interact to the database so it will send

that request to the database like if we are firing any uh selected statement

or any sql on a database so from server process it will go to a

sga sga is a shared global area basically is the is it's the largest part of the database instance

and the database is basically combination of instance background process

and the physical files so physical files are basically data file redlock file

and control file so these are the physical files and yes SGA is also the combination of different sub components

so in that whenever

that request will come from server process it will it will go to share pool first of all

and in share pool there are two sub components

that one is library cache and another is dictionary cache library cache is basically information of most recently executed SQLs

so most recently executed SQLs are basically when

that request goes from server process to SGA it will do the syntax check like

if that query is selected star from employee

so syntax it will validate from there like

if you execute select from employee it will not execute because the syntax is missed here like star is missed.

So it will not it will throw the error.

So that part is happening from library cache because it will do the syntax check,

cement text check and privilege checks are happening on share pool itself.

So, when the syntax check will happen after that it will validate

if it will find

that yes this SQL is present on the buffer cache then it will fetch

that particular query output

and it will return to the server process it will return to the client machine

and that that's the same process is getting followed for in case

if that particular SQL is not present in library case then it will create a execution plan for that and also like

yes data dictionary case is a metadata of a database like

it will have a object information like table views are stored into this

so it will it will do the validation from data dictionary case as well as

when library case will will not find that particular SQL it will

generate a new execution plan that is basically goes for hard parishing and there is two words

that we use in a database when any SQL get executed on a database side,

it will go to soft parishing either it will go to hard parishing.

So, soft parishing is the first case where it will find the SQL from the library cache itself

and then it will fetch the data from memory buffer cache memory and it will return to the client.

But in hard parishing case,

will create a new execution plan and it will go for optim or through a optimization in that it will

it will it will check from the buffer case if

that not there then after creating execution plan it will then the background process will come into the picture

and db writer will fetch that

DB writer will fetch

that particular data as per the query request it will fetch the data from the data file

and it will return to the library cache and library cache will

buffer cache sorry buffer cache and then DB buffer cache will return that

to server process and server process will return to the client so that's how

it works

so the next is as we know buffer cache is doing

all the things whatever the queries are coming it is getting executed in buffer cache itself

and it stores the in case

if you are executing any like a database change statement queries like insert or create or something like any DML.

So in those situation it will do the changes on the data

and in that situation read log and online read log and buffer

read log buffer will come into the picture so there first of all buffer case will change that

after doing the modification on the query it will get converted into a dirty buffer

and that dirty buffer will get written to the online reader log it might be uncommitted transaction

or it may it may be a committed transaction

so both can be possible

and from a read a log buffer it will get written

to the read a log file through log writer log writer

is responsible it's also a background process these are basically a

mandatory background process background processes are basically two type back mandatory background process and optional background process so

library cache is a mandatory background process

which is responsible for copying online redlock buffers to the online redlock files

so here redlock files are basically two online redlocks we can create like as per need we create

that redlock files so first it will start writing to read log one after

that once it will get filled up it will done the online read log switch will happen

and then it will start writing to second online read log so that's how whatever the change

transaction change modified data will come from online read log buffer to the

read log it will get written to log 1 and log 2

and similarly till the time after

that it will get written to through archiver process there is a optional optional background process

that is called archiver with with the help of

100

that it will get written to the archive read log

101

that we'll use for our backup

102

and recovery of our database in case i am our database fails

103

or it get crashed for any reason so that will be used for recovery so yeah so the next is

104

assist if we focus of our mandatory background process

105

so as one is system monitors as money is basically used for instance recovery

106

and yeah even for temporary table space management also it

107

will be responsible PMON is responsible for our transaction transition rollback

108

and for PMON is process monitor which is responsible for user session recovery

109

and doing the cleanup or even rollback statements this is responsible for making those cleanups on database

110

and yeah check pointer is a background process which is updating the scn number to data file and on

111

control control control file control file is a brain of a database

112

which will which will have information about the database creation and all the data file information and detail about the database.

113

So, this control file will be considered as a brain of a database.

114

So, SCN number whenever SCN number is getting generated very frequently through whenever the check pointer occurs,

115

the time SCN number is getting generated and

116

that is getting updated to the header of a data file

117

and control red log control file so yes there are some condition

118

when the log writer writes log writer writes whenever the online red log is more than 1 GB

119

or its one third full

120

or even every 3 second log writer writes the data on the buffer read log buffers to the online read log files.

121

So similarly there are few condition on

122

that basis DB writer writes those online read logs to the

123

online buffer cases changes to the data file like whenever the buffer case dirty buffer is filled up

124

or even its its there is no space left in the buffer cache

125

or even whenever any trunk truncate or any drop statement table space drop

126

or truncate statements are getting executed or even for every commit basically the DB writer writes and log writer

127

before the DB writer so that is also one condition

128

when log writer writes so these are the condition

129

when the log writer writes so apart from there is a parameter file

130

and password file parameter file is basically a file

131

which will it's a file which stores the information of every component which is

132

showing on the figure as a shared pool sga sga max sga target

133

and buffer cache a red log java pool large pool this

134

uh parameters uh this this components are uh declared into a

135

parameter file with how much size we we need it so those things are declared all the instance related come

136

parameters are declared into parameter file

137

so parameter files is two type like one is P file

138

and the another is SP file P file we we called it any dot aura file

139

and the this file is basically a static file

140

and SP file is a dynamic file so

141

if we are doing any change in p file for

142

that we have to restart our database

143

and basically for for starting our instance p file is responsible to to allocate the sga

144

so p file is equally important without p file we our database cannot run

145

and the next is password file it is used for user authentication

146

so this is the whole thing about the database in

147

that data file is actual physical file

148

and read lock files are all the change transactions are getting stored into

149

that and control file already I explained it

150

so this is the whole thing about the database

151

and this all components are like very much important yeah Java

152

pool basically this Java pool are getting used at the time

153

when you execute a statement with jvm or java related uh statements for

154

that case java pool is getting used

155

and large pool is getting used at the time

156

when uh we are performing any uh arman backup with i um higher higher io

157

and for our recovery um yeah for database recovery

158

in those conditions large pool is getting utilized

159

so this is the whole database instance that i have explained

160

if you any doubt please comment below thanks for watching till here

앱 다운로드

유창하게 말하는 데 필요한 모든 것

AI 발음 평가문장마다 점수 확인

IPA 발음 연습모든 소리 마스터

단어 학습나만의 단어장 만들기

단어 게임놀면서 외우기

QR 스캔

Download on theApp Store Get it onGoogle Play

FOR YOU

이 비디오로 스피킹 연습을 해야 하는 이유는?

오라클 데이터베이스 아키텍처에 대한 이 비디오는 기술적이고 전문적인 내용을 다루고 있어, 비즈니스 및 IT 관련 영어를 연습하고자 하는 학습자에게 적합합니다. 이 비디오를 통해 얻을 수 있는 가장 큰 이점 중 하나는 영어 회화 연습입니다. 특히, 데이터베이스 관련 용어와 개념을 설명하는 데 사용된 표현들은 실제 업무 환경에서도 접할 수 있는 언어이기 때문에, 이러한 맥락에서의 대화 기술을 습득하는 데 큰 도움이 됩니다. 또한, 전문 용어를 익히면서 자연스럽게 영어 스피킹 능력을 향상시킬 수 있습니다.

문법 및 표현 분석

이 비디오에서 사용된 핵심 구조 중 일부를 살펴보겠습니다:

동사 시제의 사용: 예를 들어, "Oracle Database is basically..." 같은 문장이 있습니다. 현재형을 사용하여 정보를 전달하고 있습니다.
조건문: "if we are firing any selected statement..."와 같은 문장은 조건의 결과를 설명하며, 반응이나 결과를 예상하는 방식으로 구성되어 있습니다.
전치사의 활용: "between user process and server process"에서 전치사를 통해 두 개체 간의 관계를 명확히 하고 있습니다.

이러한 표현들은 IELTS 스피킹 시험 준비에도 유용하며, 실무에서 협업 시에도 사용될 수 있습니다. 특히 shadow speech 기법을 통해 이러한 문구들을 반복적으로 연습하면 기억에 남기 쉬운 효과를 줍니다.

일반적인 발음의 함정

비디오에서 주의해야 할 발음 관련 함정은 다음과 같습니다:

Oracle: '오라클'이 아닌 '오레클'로 발음할 수 있어 주의가 필요합니다.
Process: '프로세스'를 '프라세스'로 잘못 발음할 수 있으니 연습이 필요합니다.
Request: '리퀘스트'와 '리퀘스트'의 발음을 반복적으로 연습하여 정확도를 높여야 합니다.

이 비디오에서 배운 내용을 shadowspeaks 방식으로 연습하면 더 큰 효과를 볼 수 있습니다. 프레젠테이션뿐만 아니라 깊이 있는 발음 연습으로 이어질 것입니다.

이 영상의 문법

화자가 가장 많이 쓰는 문형을 영상 속 실제 표현과 함께 정리했습니다.

문형	영상 속 표현
수동태 be + 과거분사 — 누가 하는지보다 무슨 일이 일어나는지에 초점	is called · is selected · is missed
관계절 who / which + 절 — 사람이나 사물에 대한 추가 정보	database which has · monitor which is · process which is
현재완료 have/has + 과거분사 — 과거의 일이 지금도 관련이 있을 때	has started · have explained

쉐도잉이란? 영어 실력을 빠르게 키우는 과학적 방법

쉐도잉(Shadowing)은 원래 전문 통역사 훈련을 위해 개발된 언어 학습 기법으로, 다언어 학자인 Dr. Alexander Arguelles에 의해 대중화된 방법입니다. 핵심 원리는 간단하지만 매우 강력합니다: 원어민의 영어를 들으면서 1~2초의 짧은 지연으로 즉시 소리 내어 따라 말하는 것——마치 '그림자(shadow)'처럼 화자를 따라가는 것입니다. 문법 공부나 수동적인 청취와 달리, 쉐도잉은 뇌와 입 근육이 동시에 실시간으로 영어를 처리하고 재현하도록 훈련합니다. 연구에 따르면 이 방법은 발음 정확도, 억양, 리듬, 연음, 청취력, 말하기 유창성을 크게 향상시킵니다. IELTS 스피킹 준비와 자연스러운 영어 소통을 원하는 분들에게 특히 효과적입니다.

섀도잉 방법: 단계별 전체 가이드 읽기 →

쉐도잉 연습: Oracle database architecture explanation in details - 영상으로 영어 말하기 배우기

연습 모드 선택

앱 다운로드

추천 영상

Solving Easy SQL Interview Questions on Analyst Builder

Uber Data Engineering Mock Interview - Ride-Sharing Data Warehouse Schema

PostgreSQL Architecture Explained: Deep Dive for Beginners

Anthropic's CCA Exam as a Field-Guide for Agentic Engineering — Frank Coyle, UC Berkeley

IT System Administrator Interview Questions and Answers | How to Pass an IT System Admin Interview

english interview p1

API Gateways in System Design Interviews w/ Ex-Meta Staff Engineer

How to ACTUALLY Get a DevOps Job in 2026

Google Interview Tips That Actually Get You Hired

Distributed Task Scheduler: System Design Interview (Stripe & Amazon Offers)

Excellent 2 Years AWS DevOps Engineer Mock Interview with Questions and Answers | Cloud | Docker

Data Structures Explained for Beginners - How I Wish I was Taught

이 비디오로 스피킹 연습을 해야 하는 이유는?

문법 및 표현 분석

일반적인 발음의 함정

이 영상의 문법

쉐도잉이란? 영어 실력을 빠르게 키우는 과학적 방법