RelationalDBDesign RelationalDBDesign


Table Space Management   «Prev  Next»
Lesson 8

Oracle Resource Manager Conclusion

The management of resources and tablespaces is an important first step in controlling your database.
After completing this module you should be able to:
  1. Describe the purpose of tablespace management
  2. Create locally managed tablespaces
  3. Create transportable tablespaces
  4. Describe new features for READ ONLY tablespaces
  5. Identify the enhancements to the Database Resource Manager
  6. Use the Database Resource Manager to limit resource usage

Resource Manager Changes and Features from Oracle 11g

Oracle Database 11g has included a number of new features associated with the resource manager. These new features include
  1. The ability to measure the maximum IO throughput of the system (IO calibration)
  2. The default maintenance plan
  3. Built-in resource plans
  4. Resource Manager statistic histories stored in AWR
  5. Resource Manager plan new directives

IO Calibration

The Oracle Database Resource Manager has a new procedure that allows you to run IO calibration tests on your database and review the results of that test. When run, the dbms_resource_manager.calibrate_IO procedure will generate a workload across all nodes of the cluster. The procedure takes two input parameters, and returns three values as seen in the following tables:

Input Parameters, Output parameters

Table Space Management Glossary

The following terms were defined in this module.
  1. Locally Managed Tablespace: a tablespace that manages its own storage information.
  2. Transportable Tablespace: a tablespace that can be copied (cloned) or moved (transported) from one Oracle database to another.
  3. Rowid: a hidden column in every row that contains the physical location of the row. A rowid never changes as long as the row exists.
  4. Restricted Rowid: a rowid in the format used prior to Oracle8.
  5. Extended Rowid: the Oracle format of a rowid. It contains a tablespace-relative address.
  6. Logical Rowid: a new form of rowid that uses the row's primary key values rather than its physical location to locate the row.
  7. UROWID: the universal rowid is a new datatype that can reference a traditional rowid, a logical rowid, and a rowid from a non-Oracle table.
  8. Consumer Group: a set of users defined within the Database Resource Manager.
The next module looks into improvements in SQL*Loader and table management tools and techniques.