Database Reference
In-Depth Information
to go to school or buy a topic entitled “English” or in Oracle
Instance case “SQL”. So after learning SQL, Aladdin will be
fully capable to command the Instance.
The Oracle Database is basically Genie's area to write
information and to make the changes permanent on the hard
disk. Just like we can remember something in our brain but when
it comes to remembering lots of stuff we have to take the help of
notebook to make things permanent otherwise we will forget.
Physical Architecture of Oracle database
Oracle Database physically composed of three different types of
files: Control file, Redo log files & Data files. We will be
discussing each of these files in great detail in the chapters ahead
but just for a brief introduction, Oracle Instance writes the
information about the structure (tables', views' etc. structure but
not data) of the database in Control file. All the changes (data
related like Update, Inserts etc) get written to Redo log files.
Data files are basically the files that contain users' data. If user
wants to write some information into the database, Oracle
instance will actually make that change permanent by writing it
to the data files.
Figure 1-2: Physical Architecture of Oracle database. Database consists
mainly of three different types of files.
Search WWH ::
Custom Search