This module describes how you can use the Enterprise Manager
Database Control Home Page to proactively and reactively configure and
manage your database environment.
Viewing Screenshots
Place the cursor on this icon to display all screenshots. You can also place
the cursor on each icon to see only the screenshot associated with it.
The Database Control Home page allows you to view the current
state of the database by displaying a series of metrics that portray the overall
health of the database. The Database Control Home page provides a launch point
for the database status and administration and configuration of the database
environment. It contains four pages via subtabs with each page displaying sub-sections.
Perform the following:
1.
Open your browser and enter the following URL:
http://<hostname>:5500/em
Enter sys/<password> and specify SYSDBA
then click Login.
2.
Once you successfully login, you will see the Database
Control Home page for your database. The Homepage provides the overall
picture of your database health and activities. On the top left corner
it shows the database name you are connected to. It has following sections
General, Host CPU, Active Sessions, Space Usage, Advice, High Availability,
Job Activity, Alerts, Related Alerts and Related Links.
3.
On the Top right corner of the page you will
see the link to setup, preferences, help and logout. By using setup you
can manage administrators, notification methods, configuration of
patch management etc. Preference link provide access to managing information
preferred credentials, notification schedules, and so on.
4.
You also see different tabs. These tabs provide easy
access to information in different categories. These tabs provide direct
link to specific and detailed information on performance, administration
and maintenance. By default, you will be taken to Home Tab.
5.
This View Data drop list selection allows you
to change your data to be manually refreshed or automatically refreshed.
6.
The General section provides information about
the status of your database (up/down), where it is running (server and
Oracle home), its instance name, its version, and if there are any ORA-600
errors.
7.
The Host CPU section provides the overall CPU
utilization by the database on the host machine. It also shows the run
queue length on the CPU, as well as any paging activity on the host machine.
8.
Active Sessions shows the average number of sessions
doing work (using CPU) or actively waiting during the refresh interval,
rounded down to the whole integer. This number is generally less than
the total number of sessions connected, as session idle time is natural
and almost always present. Click on the Active Sessions link
9.
You see the Active Session history over the course of
the day so you know when the database is at peak utilization. When done,
click the Database breadcrumb then the Home tab.
10.
The High Availability section provides the information
about your database's ability to recover from instance and media failure.
It shows how much time it will take for your database to recover from
instance failure and an overview of database backups. Click on the number
of seconds related to Instance Recovery Time.
11.
You see the Mean Time to Recover. This is the estimated
recovery time for Oracle to perform Instance Recovery, on restart after
a Shutdown Abort or an Instance failure.Select
the Database breadcrumb.
12.
Because Instance Recovery Time is a Maintenance task,
you are automatically taken to the Maintenance tab. Click the Home
tab.
13.
The Space Usage section highlights if there are
any tablespaces that have run out of space, or have fragmentation issues.
14.
TheDiagnostic Summary section provides the link
to technical advice that Oracle's Automatic Database Diagnostic Monitor
(ADDM) tool generates. ADDM is a built-in performance expert that is automatically
run every 30 minutes by default. ADDM provides database-wide performance
diagnostics for both single-instance and Real Application Clusters (RAC)
databases. It not only provides "root-cause analysis" but also
provides recommendations to help resolve performance problems. Click on
Policy Violations.
15.
There are a number of violations presently. You may
review the list. When done, click the Database breadcrumb.
16.
The Alerts section shows any alerts that you
have configured to trigger a notification.
17.
The Related Alerts section shows any alerts that
are determined to be related to your configured alerts.
18.
The Performance Analysis section shows the results
from an ADDM run are stored in the Automatic Workload Repository (AWR).
19.
The Job Activity section provides the statistics
of any job activity in the system for the last 7 days.
20.
With Enterprise Manager, you
can automate the process of deploying patches to Oracle products within
your enterprise, allows you to reduce the maintenance cost of keeping
your software up to date. The Critical Patch Advisories section
allows you to ensure more timely application
of security patches, reducing your exposure to threats.
21.
The Related Links section provides direct links
to different management areas of your database.
Move
your mouse over this icon to hide all screenshots
Bookmark
