The Oracle enhancements have made the basic tasks of managing the size and location of database storage space more challenging.
For example, you have always had to determine what size to make a tablespace, but now you must also determine how the space within the tablespace is to be managed (centrally or locally),
whether the tablespace can be moved from one database to another, and more.
By the end of the module you will 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
This module describes how to use the newest tablespace and resource management features of Oracle.
Many of these features are aimed at better use of storage space and faster retrieval of data. The next lesson answers the question, What is the purpose of tablespace management?
Each database requires at least one (DBA) database administrator and an Oracle Database system 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:
Installing and upgrading the Oracle Database server and application tools
Allocating system storage and planning future storage requirements for the database system
Creating primary database storage structures (tablespaces) after application developers have designed an application
Creating primary objects (tables, views, indexes) once application developers have designed an application
Modifying the database structure, as necessary, from information given by application developers
Enrolling users and maintaining system security
Ensuring compliance with Oracle license agreements
Controlling and monitoring user access to the database
Monitoring and optimizing the performance of the database
Planning for backup and recovery of database information