Oracle Key Concepts - Make Sure You Know All!
The content taken from
Title: Oracle Database Administration Concepts &
Implementation Made Simple
ISBN: 0-9770739-0-4
Author: Asim Abbasi
Oracle Key Concepts - Make Sure You Know All!
21. Segments can be sitting under two or more data files under the same
tablespace.
22. Data inside the segment can reside in two or more data files with
the same tablespace.
23. Tablespace is nothing but just an alias given to the group of data
files or data file.
24. Oracle Instance updates the control file whenever the physical
structure of database is changed by DBA.
25. Data Files holds the actual data and if you keeping added records to
your database tables, the sizes of these data files increase along with
the size of redo Log files.
26. Redo Log files get utilized in a circular fashion.
27. It is recommended that Oracle should be run under “Archived Log
Mode” so that Redo Log files get copied to archived location before
getting overwritten.
28. Redo Log files along with Archived Redo Log files plays a major role
in the database recovery process.
29. A database should have at least two Redo Log groups.
30. Each Redo Log group should have two or more redo log files called
“members”
31. Redo Log files get utilized by Oracle Instance in a circular
fashion.
32. Redo Log files and Archived Redo Log files play a great role in
Oracle Database recovery in times of any kind of failure.
33. The background processes and memory architecture constitute the
Oracle Instance.
34. The background processes and memory architecture constitute the
Instance.
35. Human brain works pretty much the same way Oracle Instance works.
36. Every software that you run under any OS occupies RAM (or Memory),
so does Oracle.
37. SGA is the most important piece and it stands for System Global
Area.
38. Non-shared memory is not shared among all the users whereas shared
is shared among all.
39. Database Buffer Cache has three sub-caches.
a. KEEP
b. RECYCLE
c. DEFAULT
40. Three different states of buffers within Database Buffer Cache.
a. Dirty Buffers
b. Free Buffers
c. Pinned Buffers
Oracle Key Concepts - Make Sure You Know All!
Share with others: