The primary database administration components of Oracle Enterprise Manager are contained in the DBA Management Pack, which is a suite of database administration tools and wizards bundled with Oracle Enterprise Manager.
This functionality can be accessed with the new DBA Studio tool or launched separately from the Oracle Enterprise Manager Console or operating system.
DBA Management Pack features can be used to perform most of your database administration tasks, and support all versions of Oracle databases.
DBA Studio or individual DBA Management Pack tools can be launched by either connecting to the Oracle Management Server using Oracle Enterprise Manager's three-tier framework, or by connecting directly to a database.
DBA Management Pack includes the following functionality:
- Instance Management
- Schema Management
- Security Management
- Storage Management
- SQL*Plus Worksheet
With this functionality you can:
- Complete database administration operations quickly and conveniently using a mouse rather than manually entering SQL commands
- Concurrently perform multiple tasks in multiple Oracle Enterprise Manager windows
- Administer multiple databases simultaneously
- Perform database administration tasks from a central location for both local and remote databases running on any Oracle platform in any location worldwide
DBA Management Pack also includes wizards for assisting with such tasks as importing, exporting, loading, backing up, and recovering data.