Proactive maintenance in Oracle 10g
After completing this topic, you should be able to configure a database for proactive maintenance.
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.
|1. Click Manage Metrics|
|2. Click Edit Thresholds|
| 3. Type |
|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.
| 1. Type |
| 2. Select |
| 3. Type |
| 4. Type |
|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
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.
|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 |
|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|