RelationalDBDesign RelationalDBDesign

Managing Storage   «Prev  Next»
Lesson 7

Oracle Features Conclusion

This module was an overview of the features and enhancements that were implemented with the latest release of Oracle.
Now that you have completed this module you should be able to:
  1. Identify new features for installation, configuration, and migration
  2. Describe new features for tablespace and resource management
  3. Describe new features for large databases
  4. Describe new features and enhancements for security management
  5. Identify new Internet-related features
In the next module you will have the opportunity to practice installing and configuring the database using the new Oracle features.

Data Movement Features

Moving data from one Oracle database to another is often a requirement when using distributed databases, or when a user wants to implement multiple copies of the same database in multiple locations to reduce network traffic or increase data availability. Youcan export data and data dictionaries (metadata) from one database and import them into another. Oracle Database 10g introduced a high-speed data pump for the import and export.
Oracle also offers many other advanced features in this category, including transportable tablespaces, Advanced Queuing/Oracle Streams, and extraction, transformation and loading (ETL) solutions. We introduce these next.

Oracle Database Admin 18c

Using Multiple Tablespaces

Using multiple tablespaces allows you more flexibility in performing database operations. When a database has multiple tablespaces, you can:
  1. Separate user data from data dictionary data to reduce I/O contention.
  2. Separate data of one application from the data of another to prevent multiple applications from being affected if a tablespace must be taken offline.
  3. Store different the datafiles of different tablespaces on different disk drives to reduce I/O contention.
  4. Take individual tablespaces offline while others remain online, providing better overall availability.
  5. Optimizing tablespace use by reserving a tablespace for a particular type of atabase use, such as high update activity, read-only activity, or temporary segment storage.
  6. Back up individual tablespaces.
Some operating systems set a limit on the number of files that can be open simultaneously. Such limits can affect the number of tablespaces that can be simultaneously online. To avoid exceeding your operating system limit, plan your tablespaces efficiently. Create only enough tablespaces to fulfill your needs, and create these tablespaces with as few files as possible. If you need to increase the size of a tablespace, add one or two large datafiles, or create datafiles with autoextension enabled, rather than creating many small datafiles. Review your data in light of these factors and decide how many tablespaces you need for your database design.

Oracle Enhancements - Quiz

Click the Quiz link below to test your understanding of the concepts presented in this module.
Oracle Enhancements - Quiz