Using the Enterprise Manager with Oracle
|Previous Top Next|
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:
Two expanded Oracle servers
As you can see in the above sample screenshot, Database Workbench detects the usuage of "rollback segments" and adjusts the available options accordingly. The first server (Oracle 10g) has rollback segments disabled, while the second one is an Oracle 8i server that uses rollback segments.
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: