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!
11. Steps to Master Oracle
a. SQL
b. DBA
c. Network Admin
d. Bkup & Recov.
e. Performance Tuning
12. Oracle database (not the Instance) has a logical architecture and a
physical architecture.
13. At the OS level, Oracle database is comprised of three different
file types i.e. Control File, Redo Log Files, Data Files. These files
make up the physical architecture of Oracle database.
14. Logically database is composed of tablespaces. Each table space can
be visualized as a department level database e.g for each department of
a company you would be having one tablespace.
15. Each tablespace is composed of segments and Oracle allots a segment
each time you create a database object e.g. tables, views etc using
CREATE statement
16. Each Segment is composed of Extents and extents are nothing but
contiguous DB Blocks.
17. DB Block is usually the even multiple of OS Block and its value is
specified in parameter file (init.ora)
18. Data inside the tablespace reside in the data files which are
physical files like all other files located on your computer.
19. Size of the tablespace and hence the size of database is not limited
to the OS marked limit on the file size.
20. Each tablespace can have one or more data files associated with it
but each data file can never be associated with more than one table
space.
Oracle Key Concepts - Make Sure You Know All!
Share with others: