 |
|
Oracle Tips by Burleson |
Describe Oracle File
Architecture
After completing all of the reading
assignments and exercises for this tutorial, prepare an executive
summary of less than one thousand words describing the basic
relationship between disks, data files and tablespaces, and the
important features of Oracle files and tablespace management. The
paper must include a one-paragraph discussion of each of the following
subjects and be geared toward a non-technical reader. This assignment
will be judged on the accuracy of the technical content and your
ability to explain complex features in plain English.
* Basic file/tablespace mapping
* Locally managed tablespaces
* Automatic extent management
* Multiple file blocksizes
* Multiple RAM data buffers
* File partitioning
* Oracle managed files
* Automatic extent management (bitmap
freelists)
The main points of this tutorial include:
* Oracle provides a logical tablespaces to
hold table rows and indexes. A tablespace is composed of one or more
data files.
* An Oracle data files may be created with the
“autoextend on” option, allowing it to grow on an as-needed basis.
* The Oracle data dictionary has the
dba_tablespaces and dba_data_files views to show details about file
objects inside Oracle.
* Oracle introduced locally managed
tablespaces to reduce tablespace fragmentation and provide better
internal object management.
* Oracle introduced automatic extent
management (bitmap freelists) to reduce freelist contention.
* Oracle Managed Files allows Oracle to keep
details about file names, file sizes and file locations, making it
easy to create new tablespaces.
We are now ready to move on to the next
tutorial.
For more details,
see the "Easy
Oracle Series" a set of books especially designed by Oracle
experts to get you started fast with Oracle database technology. |
