Databases Reference
In-Depth Information
Using the Oracle Enterprise Manager Tools
One of the tools available with Oracle Enterprise Edition is OEM, which allows
you to manage Oracle components and to control and configure one or more
Oracle databases from one console.
The OEM console has two panes. The Navigator pane on the left provides a
hierarchical view of all of the databases and other Oracle-related services on the
network. Clicking one of the nodes in the Navigator pane brings up the status
and contents of that node in the pane on the right. Using OEM, you can easily
browse objects and characteristics of the database, such as tablespaces, user
accounts, datafiles, and configuration parameters of the instance.
Janice, the DBA, wants to get a quick overview of the tablespaces that exist in
the database that has a connect descriptor of or92. She starts OEM under
Microsoft Windows by selecting Start
All Programs
Oracle - OraHome
10g2
Enterprise Manager Console. She enters her username, her password,
and the connect descriptor.
The next screen shows the different kinds of functionality available to Janice in
the Navigator pane of OEM. She expands the Storage branch by double-clicking
and then clicks Tablespaces. She notices that the EXAMPLE tablespace is at full
capacity, which is fine since it is used for training and will not have any new
objects. However, she does need to look into expanding the size of the SYSTEM
tablespace, since it is 99.39 percent full.
