A default installation of Oracle provides the DBA with a good starting point, not only creating
an OFA-compliant directory structure but also segregating segments into a number of tablespaces
based on their function. We??™ll review the space requirements for each of these tablespaces and
provide some tips on how to fine-tune the characteristics of these tablespaces.
At the end of the chapter, we??™ll provide some guidelines to help place segments into different
tablespaces based on their type, size, and frequency of access, as well as ways to identify hotspots
in one or more tablespaces.
Tablespace Architecture
A prerequisite to competently setting up the tablespaces in your database is understanding the
different types of tablespaces and how they are used in an Oracle database. In this section, we??™ll
review the different types of tablespaces and give some examples of how they are managed.
In addition, we??™ll provide an overview of Oracle??™s Optimal Flexible Architecture and how
it provides a framework for storing tablespace datafiles as well as Oracle executables and other
Oracle components, such as redo log files, control files, and so forth. We??™ll also review the types
of tablespaces by category??”SYSTEM tablespaces, the SYSAUX tablespace, temporary tablespaces,
undo tablespaces, and bigfile tablespaces??”and describe their function.
Tablespace Types
The primary types of tablespaces in an Oracle database are permanent, undo, and temporary.
Pages:
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158