 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 5 - Oracle Database
Objects
Oracle Tablespace Changes
The Oracle Database Fundamentals I (1Z0-031) and the Oracle Database
Performance Tuning (1Z0-033) certification tests will have numerous
questions on Oracle tablespaces. Test candidates should have a
thorough understanding of Oracle tablespaces and datafiles. This
knowledge should include:
-
CREATE tablespace syntax
-
Locally managed vs. dictionary managed
tablespaces
-
Datafile fragmentation
-
Extent allocation in tablespaces (know how
autoallocate and uniform size allocate extents)
-
High-water marks
-
Temporary tablespaces
-
Permanent tablespaces
-
Tablespace quotas
-
What happens when a tablespace is set offline
Locally Managed System
Tablespaces
Locally managed tablespaces allow the Oracle
system to automatically manage an object's extents. Locally managed
tablespaces track object information in bitmap structures stored in
the tablespace itself. Oracle states that locally managed
tablespaces provide increases in the concurrency and speed of space
operations and generally have a positive impact on application
performance.
The above text is
an excerpt from:
OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database
Administration Techniques
ISBN 0-9744355-3-8
by Christopher T. Foot
http://www.rampant-books.com/book_2003_2_OCP_print.htm
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
