Using the Enterprise Manager with Oracle
|Previous Index Next How To Use|
From the Enterprise Manager, you have access to all functionality related to Oracle.
In the Servers treeview, expand the registered server. This will show the following treenodes:
An expanded Oracle servers
Clicking the Connect As node will open the Connection Profile dialog.
Connection Profile Dialog
In this dialog, you can enter the username and password you're using to create an Oracle session. From the drop-down box for username, you can select a previous profile if you like. Once connected, the Enterprise Manager will add your newly created profile to the Connect As tree-node. You can double click a connection profile to create an Oracle session.
Three different connection profiles
Double clicking a database will connect and open a Database Navigator window.
After connecting, Database Workbench will ask you if you want to modify the schema-filter. You can also reach this functionality by right-clicking a connection profile and selecting Options.
This will display the following dialog:
Connection Profile Options
As you can see, you can filter the visible schemas and enter other options.
The Security node
If Database Workbench detects that your Oracle server doesn't use Rollback Segments, then this node will not be visible.
Under this node, you can find two items to monitor your Oracle server.
For more information, see: