Introduction to Enterprise Manager for database Oracle9i

Oracle Enterprise Manager is a management framework that enables you to manage a Complete Oracle environment, including databases, iAS servers, applications, and services.

Diagnose, modify, and optimize multiple databases. Tasks are scheduled at different intervals on multiple systems. Manage database conditions through the network. Manage multiple network nodes and services from many locations. Share tasks with other administrators. Combine related services to facilitate task management. Start integrated Oracle and third-party tools.

The database folder contains all the databases you can access. You can expand a specified database to manage the following objects: routines, including startup, shutdown, and initialization. Solution, including tables, indexes, and all other solution objects. Security, including user accounts, roles, and permissions. Storage, including tablespaces, data files, and rollback segments. Replication, including multi-entity and materialized view replication. Oracle JVM, including namespace, CORBA and EJB components, and their licenses. Workspace, a virtual environment that one or more users can share to make version changes to data. Other database features depend on the products installed with your database.

Enterprise Manager includes three optional management software packages, including some advanced database management tools. For the Diagnostic PackTuning PackChange Management Pack, use "Routine Management" to execute the following tasks: Start and close the database. View and edit routine parameter values. Manage user sessions and view the currently running SQL statements and their explain plans. Manage pending transactions. Monitor operations that require long running. Manage and process resources through resource plans. Manage stored configurations. Manage the locks and sessions that occupy the most resources (if Diagnostics Pack is installed ).

Use solution management to manage solution objects, such as tables, indexes, and Oracle8 objects. You can use solution management to create solution objects. Change Plan object. Delete the solution object. Displays the relevance of the solution object. Use security management to create users, roles, and profiles. Change the user, role, and profile. Delete users, roles, and profiles. Grant permissions and roles to database users. Use "Storage Management" to manage storage objects such as tablespaces, rollback segments, data files, and redo logs. You can perform the following operations: Create a storage object. Add data files and rollback segments to the tablespace. Delete A storage object. Bring objects online or offline. Displays the correlation of objects. Replication is the process of copying and maintaining database objects (such as tables) in multiple databases that constitute a distributed database system.

You can use the Console to perform the following tasks: perform multi-body replication by selecting "multi-body replication" in the navigator. Select "materialized view copy" in the navigator to copy the materialized view. Oracle9i provides integrated data warehouse support through the OLAP Service and OLAP metadata stored in the database. To manage OLAP services, right-click the OLAP folder to start Oracle OLAP Instance Manager.

To manage OLAP metadata, expand the OLAP folder. Oracle JVM (Java Virtual Machine) stores and executes the CORBA and EJB components written in Java. The client application uses the name service to access these components. By using JVM, you can perform the following tasks: Manage namespaces. Browse the CORBA and EJB components in the namespace. Change the release component license. Execute the Java class and view its output. A workspace is a virtual environment shared by one or more users to change data in the database. Workspace management involves managing one or more workspaces that can be shared by many users. Use Workspace Manager to execute the following tasks: Enable and disable table versioning. Create, edit, and remove a workspace. Roll back or refresh the sub-workspace. View the differences between two workspaces, or the differences between two storage points in a workspace. View and resolve conflicts between a child workspace and its parent workspace. Assign or revoke the Workspace Manager permissions of a user. A workspace is a virtual environment shared by one or more users to change data in the database. Workspace management involves managing one or more workspaces that can be shared by many users. Use Workspace Manager to execute the following tasks: Enable and disable table versioning. Create, edit, and remove a workspace. Roll back or refresh the sub-workspace. View the differences between two workspaces, or the differences between two storage points in a workspace. View and resolve conflicts between a child workspace and its parent workspace. Assign or revoke the Workspace Manager permissions of a user.

(