Skip Headers
Oracle® Enterprise Manager Oracle Fusion Middleware Metric Reference Manual
10g Release 5 (10.2.0.5.0)

Part Number B25987-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

15 Oracle BI DAC Server Metrics

Data warehouse Application Console ( DAC) is used to create and schedule ETL taskflows for Informatica server. It manages data warehouse processes including scheduling, loading of the ETL, and configuring the subject areas to be loaded.

You can use the All Metrics page of this target to view the metrics that have been collected for this target by Oracle Management Agent.

ETL Performance Metrics

This category provides metrics related to the ETL performance.

Default Collection Interval — Every 15 minutes

Table 15-1 ETL Performance Metrics

Metric Description

Completed tasks

Shows the completed ETL tasks in the DAC repository. The status is 'Completed'.

Failed tasks

Shows the total number of failed ETL tasks in the DAC repository. The status for failed tasks is 'Failed'.

Queued tasks

Shows the queued up ETL tasks in the DAC repository. The status is 'Queued'.

Runnable tasks

Shows the runnable ETL tasks in the DAC repository. The status is 'Runnable'.

Running tasks

Shows the currently running ETL tasks in the DAC repository. The status is 'Running'.

Total tasks

Shows the total number of ETL tasks in DAC repository.


ETL Runs Metrics

This category provides metrics related to the ETL definition runs.

Table 15-2 ETL Runs Metrics

Metric Description

Completed Steps

Shows the number of steps in the ETL run that completed successfully.

ETL Definition

Shows the name of the ETL definition.

Failed Steps

Shows the number of steps that failed in the ETL run.

Running Steps

Shows the number of steps currently running in the ETL run. The status is 'Running'.

Status

Shows the status of the ETL definition run.

Total Steps

Shows the total number of steps in the ETL definition.

End Time

Shows the time when the ETL process actually ended or failed.

Start Time

Shows the time when the ETL process started.


Failed ETL Runs Metrics

This category provides metrics about the failed ETL runs.

Table 15-3 Failed ETL Runs Metrics

Metric Description

Completed Steps

Shows the number of steps that were completed successfully in the ETL run.

ETL Definition

Shows the name of the ETL definition that failed.

Failed Steps

Shows the number of steps that failed in the ETL run.

Running Steps

Shows the number of steps in the ETL run that are in 'Running' state.

Status

Shows the status of the ETL run that failed. The status can be failed or stopped.

Total Steps

Shows the total number of steps in the ETL definition.

End Time

Shows the time when the ETL process actually ended or failed.

Start Time

Shows the time when the failed ETL process actually started.


Response Metrics

This category provides status metrics for Oracle BI DAC Server.

Default Collection Interval — Every 50 minutes

Table 15-4 Response Metrics

Metric Description

Status

Shows the current status of the DAC server. The status can be Agent Unreachable, Under Blackout, Metric Collection Error, Up, Down, Partially Up, Agent Down, or Status Pending.


ETL Run Log Metrics

This category provides details about the ETL run.

Table 15-5 ETL Run Log Metrics

Metric Description

ETL Log

Shows a log for the ETL run.