Project 2

Transcript

00:00

an 

00:01

example 

00:01

of

00:02

database 

00:02

process

00:10

requires

00:11

IP ADRESSE

00:12

Port (1521)

00:13

database name

00:14

username

00:15

password

00:16

queries

00:19

user process

00:20

server process

00:24

server process

00:25

created session

00:28

instance :

00:29

smon

00:31

pmon

00:31

reco

00:32

others

00:38

SGA

00:39

DATABASE BUFFER CACHE

00:40

REDO LOG BUFFER

00:43

SHARED POOL

00:44

LIBRARY CACHE

00:46

DATA DICTIONARY CACHE

00:50

REDO LOG BUFFER

00:50

DATABASE BUFFER CACHE

00:50

LIBRARY CACHE

00:50

DATA DICTIONARY CACHE

00:50

SHARED POOL

00:50

SGA

00:55

DBWn

00:58

CKPT

01:00

LGWR

01:00

DATA FILES

01:00

ONLINE REDO LOG FILES

01:00

CONTROL FILES

01:02

ARCN

01:04

DATA FILES

01:04

ARCHIVED LOG FILES

01:17

thanks for watching ...