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!
101. For each index you create Oracle creates an implicit table based on
that particular column in a manner that will help it in locating records
easier.
102. Sequences are like auto-number objects. You can always get the next
number and insert it in any number datatye column, usually id kind of
field e.g. emp_id.
103. Users can be authenticated by the database or the OS.
104. Privileges can be assigned to users and roles.
105. Technique for Sub-Query Interpretation: Start from the bottom query
first, imagine what its output is would be, replace that query with its
imagined output and move to the next higher one.
106. Remember these points as it’s the steps of erecting complete Oracle
System from scratch.
107. The parameters estimated values are required before we start the
process of actually creating Oracle Database in computer.
108. Developing Primary and Foreign Key relationship between the tables
helps in reducing redundancy of information.
109. It is recommended to have at least one tablespace designed for each
department.
110. The sum of “initial” estimated sizes of all the tables within that
department will give us the initial estimated size for a tablespace.
111. The sum of all the initial estimated sizes of all the tablespaces
will give us the initial estimated size of database.
112. The sum of frequencies of growth of all the tablespace will give us
the frequency of growth of database.
113. If we know how to find out the estimated size of a table and its
frequency of growth then we can also find out the estimated size of
tablespace and frequency of its growth.
114. If we know how to find out the “initial” estimated size of a
tablespace and its frequency of growth then we can also find out the
estimated size of database and frequency of its growth.
115. Maximum number of concurrent connected users parameter helps
whether we go with Shared Server mode or Dedicated Server mode.
116. Oracle Flexible Architecture (OFA) defines the standard directory
architecture for Oracle physical files.
117. Oracle Managed Files defines the naming conventions for Oracle
physical files.
118. If use DBCA to create the Oracle database then you don’t have to
worry about OFA and OMF.
119. DBCA follows OFA and OMF automatically.
120. Oracle Server software has following three editions.
o Enterprise
o Standard
o Standard1 (Personal)
Oracle Key Concepts - Make Sure You Know All!
Share with others: