Managing Database Resources - OCP: Oracle Database 12c Administrator Certified Professional - page 456

In this chapter, we will discuss how to most effectively manage
database storage resources. For space management, we will
discuss resumable space allocation, transportable tablespaces
and databases, and shrinking segments.
We'll cover two features (resumable space allocation and shrinking segments) for manag-
ing the efficient utilization of space resources and two features (transportable tablespaces and
transportable databases) for managing large-scale data movement. The resumable space allo-
cation feature allows you to efficiently utilize space resources and prevent transaction aborts
when space limitations are encountered. Shrinking segments allow you to eliminate white
space in a segment in place while the segment remains online and available for application
use. For large-scale movement of tablespaces from one database to another, the DBA can use
the transportable tablespaces feature. To move an entire database, even to another platform,
you can use the transportable database feature.
We will discuss storage resource management in the Oracle 12 c multitenant architec-
ture, specifically how permanent and temporary tablespaces are managed in CDBs
and PDBs.
Exam objectives are subject to change at any time without prior notice and
at Oracle's sole discretion. Please visit Oracle's Training and Certification
website ( http://www.oracle.com/education/certification/ ) for the
most current exam-objectives listing.
Managing Storage
In the following sections, we will explore resumable space allocation, transportable
tablespaces, transportable databases, and shrinking segments. Resumable space alloca-
tion allows you to temporarily suspend operations that run out of space while you correct
the space issue without aborting the operation. With the transportable tablespace feature,
you can copy a set of tablespaces from a source database to a destination database. With
the transportable database feature, you can copy an entire database from one platform to
another. And finally, you'll learn how to shrink segments dynamically.
Managing Resumable Space Allocation
If the Oracle database encounters a space problem during the execution of an operation, it can
suspend the operation and then later resume the operation. This feature is called resumable