Proactive maintenance in Oracle 10g

Learning objective

After completing this topic, you should be able to configure a database for proactive maintenance.

Exercise overview

In this exercise, you're required to configure a database for proactive maintenance in Oracle Database 10 g.

This involves the following tasks:

• setting a critical threshold
• setting a metric baseline
• detecting and correcting storage inefficiencies

Task 1: Setting a critical threshold

As a Database Administrator, you want to monitor your database proactively so that you can fix common problems before they affect users.

First you want to set a metric threshold. In Enterprise Manager, you have navigated to the Related Links section of the Administration tabbed page.

Configure your system to alert you with a critical warning if the Archive Area Used is greater than 85 percent.

Steps list

Instructions
1. Click Manage Metrics
2. Click Edit Thresholds
3. Type 85 in the Critical Threshold field of the Archive Area Used (%) row
4. Click OK

Task 2: Setting a metric baseline

Suppose you want to set a metric baseline.

In Enterprise Manager, you have already navigated to the Create Metric Baseline page.

To begin, you have entered the date 25-Aug-2004 in the Date field.

Define a baseline for all metrics called Total_Baseline. Specify 2 AM as the given hour. Then configure the system to use the value 10 percent to calculate suggested warning metric thresholds, and 20 percent to calculate suggested critical metric thresholds.

Steps list

Instructions
1. Type Total_Baseline in the Name field
2. Select 2 from the Hour of day drop-down list
3. Type 10 in the Warning Percentage field
4. Type 20 in the Critical Percentage field
5. Click Go
6. Click OK

Task 3: Detecting and correcting storage inefficiencies

You want to use the segment advisor to detect storage inefficiencies in the EMPLOYEES table of the HR schema.

In Enterprise Manager, you navigate to the Segment Advisor page.

Use the segment advisor to check for storage inefficiencies in the EMPLOYEES table in the HR schema. Set the advisor mode to limited, then navigate to the page where you can run a search for HR schema objects, and select the EMPLOYEES table. Choose the standard schedule type and create the segment advisor task to run with an unlimited time for analysis.

Steps list

Instructions
1. Select the Schema Object s option
2. Select the Analysis Based on Available Statistics (Limited) option.
3. Click Continue.
4. Click Add
5. Type HR in the Schema text field, and click Search
6. Select HR.EMPLOYEES, and click OK
7. Click Next
8. Click Next
9. Select Standard from the Schedule Type drop-down list
10. Click Next
11. Click Submit