 |
|
Oracle Tips by Burleson |
Database Table
Administration
Overview
This tutorial introduces the general concepts
behind relational tables and explores the internal table storage
mechanisms used by Oracle. These concepts include standard tables,
indexed organized tables, single table clusters, and all specialized
permutations of table structures that are allowed within the Oracle
database engine.
The focus on this tutorial is on Oracle table
internals, examining the parameters PCTFREE, PCTUSED, MAXTRANS,
MINEXTENTS, MAXEXTENTS, BUFFER_POOL, INITTRANS, FREELISTS and FREELIST
GROUPS, with a focus on how these parameters affect the behavior of
the Oracle database.
The topics will include the proper ways to
allocate Oracle tables, and a discussion of how indexes can
dramatically improve the performance of certain types of Oracle
database queries. This tutorial also examines Oracle multi-table and
single table clusters, and demonstrates how table clustering can help
reduce disk I/O for complex systems.
This tutorial also involves table monitoring,
and the student will learn to write scripts against the Oracle data
dictionary to display tables and their salient characteristics from
the data dictionary. This tutorial wraps up with a discussion of
Oracle table reorganization techniques, and the student will be
exposed to all the methods used in Oracle table reorganizations
including export/import, “create table as select”, and “alter table
move” syntax.
Learning Outcomes
Upon completion of this tutorial, you will be
able to:
* Describe the Oracle table architecture
* Explain Oracle table internals
* Allocate Oracle tables
* Use index-organized tables
* Create cluster tables
* Monitor Oracle table statistics
* Perform Oracle table reorganization
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. |
