DBA_PARALLEL_EXECUTE_TASKS - Task History?
From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Tue, 14 Sep 2021 15:56:31 -0400
Message-ID: <CAP79kiRJ+fFsvCuiK5HV0pqzx34xYqepX6QVwKW7GG2NF8ttYw_at_mail.gmail.com>
I've been looking (Google and query the data dictionary) but I'm curious if anyone knows where the TASK History might be for DBA_PARALLEL_EXECUTE_TASKS?
Date: Tue, 14 Sep 2021 15:56:31 -0400
Message-ID: <CAP79kiRJ+fFsvCuiK5HV0pqzx34xYqepX6QVwKW7GG2NF8ttYw_at_mail.gmail.com>
I've been looking (Google and query the data dictionary) but I'm curious if anyone knows where the TASK History might be for DBA_PARALLEL_EXECUTE_TASKS?
IF you're not familiar with this view, it contains programs that are assigned a TASK_PREFIX and a TASK_NAME. The TASK can then execute in parallel and the parallel executing tasks will show up in DBA_SCHEDULER_RUNNING_JOBS as TASK_PREFIX_*n .*
But I'm looking for a history view that shows the elapsed times of the TASK_NAMES but I can't seem to put my hands on it (if it exists).
Anyone know?
Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 14 2021 - 21:56:31 CEST