Using the Database Performance Page

Using the Database Administration Page

Using the Database Maintenance Page

Perform the Installing Oracle Database 10g on Windows tutorial.

Open your browser and enter the following URL (Replace <hostname> with your own host name or IP address):

http://<hostname>:1158/em

Enter sys as User Name, oracle as Password, SYSDBA in the Connect As field, and click Login.

If this is the first time, that you log into Enterprise Manager as this user, click I agree to acknowledge the Oracle Database 10g Licensing Information.

The Database Home page provides the overall picture of your database health and activities.

In the top left corner is the name of the database you are connected to. The tabs below provide easy access to information in different categories, directly linking to details and tasks on performance, administration, and maintenance. By default, you are taken to the Database home page.

On the top right corner of the page, you see the links to the Setup, Preferences, Help, and Logout pages.

• By using Setup, you can manage administrators, notification methods, configuration of patch management, and so on.
• The Preference link provides access to managing information, preferred credentials, notification schedules, and so on.
• The Help link provides context-sensitive help from Oracle Enterprise Manager Online Help.
• The Logout link immediately disconnects you from Enterprise Manager.

Click Setup to view your Enterprise Manager administrators.

Use the Back button of your web browser to return to the Database home page.

This View Data drop-down list selection enables you to change your data to be manually refreshed or automatically refreshed.

Scroll though the Database home page and examine the various categories. The General section provides information about the status of your database instance (Up or Down), its name, version and links to the Host homepage and the Listener home page.

Click the Host link.

Four tabbed pages: Home, Performance, Targets and Configuration, organize the host related information for you. Review all information that interests you.

Click on the Configuration tab.

The Host Configuration page displays information grouped as: Hardware, Operating System, Oracle Software, and OS-Registered Software. When you finished reviewing the information, click on the Database tab in the top right corner, to return to the Database Home page.

The Host CPU section on the Database home page provides the overall CPU utilization by the database on the host machine. The Load and Paging fields values are derived from the Host Performance page.

Active Sessions shows the average number of sessions working (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 the session idle time is natural and almost always present.

If you set up a baseline and track a set of SQL statements, then the SQL Response Time is displayed. (The lower the current response, the more efficiently the SQL statements are executing.)

The Space Summary section helps to identify storage-related issues and provide recommendations for improved performance. It highlights whether there are any tablespaces that have run out of space, or have fragmentation issues.

The Database Size value is derived from the total size of the tablespaces.

The dump area stores dump files created by background and user processes, as well as core dump files. Dump Area Used (%) is an alert threshold that you can edit.

The High Availability section provides information about your database's ability to recover from instance and media failure. It shows when the last database backup was taken and whether Flashback Logging is enabled. Click on the number of seconds related to Instance Recovery Time.

You see the mean time to recover. This is the estimated recovery time for o perform Instance Recovery on restart after a Shutdown Abort or an Instance failure. Click the Database Instance locator link.

Because Instance Recovery Time is a Maintenance task, you are automatically taken to the Maintenance tab. Click the Home tab.

The Alerts section shows all open alerts for the database.

The Related Alerts section shows alerts for related targets.

The Job Activity section provides the statistics of any job activity in the system for the last seven days.

The Related Links section provides direct links to different management areas of your database.

Click the Performance tab.

The Performance page appears. On Windows the Hosts chart displays CPU Utilization (on some operating systems, it displays load average).

Select Historical from the View Data drop-down list.

Notice the Historical Interval Selection appears which allows you to slide focus to a different day and time.

Move the slider to a different day and time, and note how the chart below changes.

Then click the CPU Utilization link.

The Host Performance page appears with charts indicating CPU Utilization, Memory Utilization and Disk I/O Utilization. Also the top 10 most consumptive processes are displayed.

Click your web browser's Back button to return to the Database Performance page.

The Average Active Sessions chart on the Performance page displays the load on the instance. The "wait classes" on the right of the graph show how much of the database is waiting for a resource, such as CPU or disk I/O. Click on one of the icons below the chart.

The Automatic Database Diagnostic Monitor (ADDM) page appears. Review what interests you, and click your web browser's Back button to return to the Database Performance page.

The Instance Disk I/O chart on the Performance page displays the rate at which the database instance issues read/write requests. Physical reads and writes correspond to the data block reads and writes in the database. An increase in other reads and other writes indicates a backup, archiving, or file transfer activity that is occurring in the database. Scroll down the Performance page.

The Instance Throughput charts show any contention that appears in the Sessions chart.

The Additional Monitoring Links provide direct links to additional performance information.

Click the Administration tab.

The Administration page appears. It provides links which enable you to perform various DBA tasks. The following are examples of some Database Administration tasks:

• To manage the storage and size of the database, use links in the Storage section.
• To configure database parameters, use links in the Database Configuration section.
• To schedule and monitor jobs, use links in the Database Scheduler section.
• To manage snapshots in the Automatic Workload Repository (AWR), that are used for performance tuning, use links in the Statistics Management section.
• To change the space management for your database, use links in the Change Database section.
• To monitor and manage the database resources, use links in the Resource Manager section.
• To enable or disable policy rules (which exist for different target types, such as hosts, Oracle databases, and listeners), use the Policies section.

Scroll down the page.

The following are examples of some of tasks involving Schema objects:

• To create a database link, (that is, to designate a connection between two physical database servers allowing a client to access them as one logical database), use the Database Objects section.
• To search for invalid packages, use the Programs section.
• To configure an Oracle XML DB protocol server, use the XML Database section.
• To allow access to a database user, use the Users & Privileges section.
• To add a materialized view to a data warehouse, use the Materialized Views section.
• To configure a database for business intelligence applications, use the BI & OLAP section.
• To create a variable array or nested table (that maps to an array in Java), use the User Defined Types section.

Scroll down the page.

The following are examples of some of Enterprise Manager Administration tasks:

• To setup database users for performing Enterprise Manager administrative tasks, use the Administrators link.
• To monitor e-mail notification for specific database conditions, use the Notification Schedule link.
• To suspend data collection for special cases (to get a more accurate, long-term picture of the daily performance), use the Blackouts link.

As an example, of a DBA monitoring task, view the smallest segments of the EXAMPLE tablespace. Click the Tablespaces link.

On the Tablespaces page, select the EXAMPLE tablespace, then select Show Tablespace Contents from the Actions drop-down list, and click Go.

The segments of this tablespace are displayed in descending sort order. Change the order to ascending, by clicking the sort order icon (the triangle behind "Size (KB)" ).

Now the smallest segments are displayed first. Click the Database Instance locator link to return to the Administration page.

Click the Maintenance tab.

The High Availability category provides entry points for tasks related to backup and recover. For example, you may want to use the Backup wizard to backup the contents of your database to disk, tape or both.

The Data Movement category provides links for tasks related to moving data between Oracle databases, as well as in and out of them. For example, the export and import links allow you to use Enterprise Manager's graphical interface for the data pump tools. "Load Data from User Files" connects you to SQL*Loader (a tool used to load data from flat files into an Oracle database) .

The Software Deployments category simplifies your software and patch maintenance. Click Apply Patch.

Ignore the error which you will receive, if you are not connected to Oracle Metalink, or there are no patches available for your database release.

Review the workflow on top of Patch: Select Patch page, then click the Database tab to return to the Database home page.

Note the "Error" message does not mean that there is anything wrong.  It simply means, when this screenshot was taken, there were no patches for Oracle Database 10.2.0.1 on Windows.