RelationalDBDesign 





Managing Storage   «Prev  Next»
Lesson 3 New features for tablespace and resource management
Objective Understand Oracle tablespace and resource management.

Features for Tablespace and Resource Management in Oracle

New types of tablespaces

The tablespace features give you greater flexibility in controlling the physical location and availability of specific portions of the database. Tablespace improvements allow faster and easier backups, better capabilities to change the status of tablespaces, and more choices for tablespace management.

Database Administrators

Each database requires at least one database administrator (DBA). An Oracle Database system can be large and can have many users. Therefore, database administration is sometimes not a one-person job, but a job for a group of DBAs who share responsibility. A database administrator's responsibilities can include the following tasks:
  1. Installing and upgrading the Oracle Database server and application tools
  2. Allocating system storage and planning future storage requirements for the database system
  3. Creating primary database storage structures (tablespaces) after application developers have designed an application
  4. Creating primary objects (tables, views, indexes) once application developers have designed an application
  5. Modifying the database structure, as necessary, from information given by application developers
  6. Enrolling users and maintaining system security
  7. Ensuring compliance with Oracle license agreements
  8. Controlling and monitoring user access to the database
  9. Monitoring and optimizing the performance of the database
  10. Planning for backup and recovery of database information
  11. Maintaining archived data on tape
  12. Backing up and restoring the database
  13. Contacting Oracle for technical support
Look at the slide show below to see an illustration of the new tablespace enhancements now available with Oracle.


Tablespace enhancements

Enhancements to the Resource Manager

In addition to these features for tablespace management, the tool called the Database Resource Manager has been enhanced to allow the database administrator to control operating system resources. For example, the DBA can limit a user so the user is not allowed to use more than 40 percent of the CPU at any time. This prevents one user from "hogging" the CPU and causing other users to experience long waits for services from the database. We will look into these features and improvements in a later module of this course.

About the Elements of Resource Manager

The elements of the Resource Manager include resource consumer groups, resource plans, and resource plan directives.
Resource Manager
Resource Manager
You use the DBMS_RESOURCE_MANAGER PL/SQL package to create and maintain these elements. The elements are stored in tables in the data dictionary. You can view information about them with data dictionary views. The next lesson describes storage-handling and space-handling efficiencies that have been added in Oracle.