The management of resources and tablespaces is an important first step in controlling your database.
After completing this module you should be able to:
Describe the purpose of tablespace management
Create locally managed tablespaces
Create transportable tablespaces
Describe new features for READ ONLY tablespaces
Identify the enhancements to the Database Resource Manager
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
The ability to measure the maximum IO throughput of the system (IO calibration)
The default maintenance plan
Built-in resource plans
Resource Manager statistic histories stored in AWR
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:
Table Space Management Glossary
The following terms were defined in this module.
Locally Managed Tablespace: a tablespace that manages its own storage information.
Transportable Tablespace: a tablespace that can be copied (cloned) or moved (transported) from one Oracle database to another.
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.
Restricted Rowid: a rowid in the format used prior to Oracle8.
Extended Rowid: the Oracle format of a rowid. It contains a tablespace-relative address.
Logical Rowid: a new form of rowid that uses the row's primary key values rather than its physical location to locate the row.
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.
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.