Oracle® Enterprise Manager Oracle Fusion Middleware Metric Reference Manual 10g Release 5 (10.2.0.5.0) Part Number B25987-04 |
|
|
PDF · Mobi · ePub |
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.
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. |
This category provides metrics related to the ETL definition runs.
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. |
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. |