Iendtifying what the autotasks do
From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Wed, 5 Mar 2008 16:59:40 +0000
Message-ID: <5e317f310803050859o5b97f1fdjf8cf4779864a8b02@mail.gmail.com>
Date: Wed, 5 Mar 2008 16:59:40 +0000
Message-ID: <5e317f310803050859o5b97f1fdjf8cf4779864a8b02@mail.gmail.com>
Hi,
Oracle 11.1.0.6.0
In dba_auto_task_client I can see a few client_names:
auto optimizer stats collection
auto space advisor
sql tuning advisor
How do I work out exactly what jobs and what code these run?
For example I assume that the optimizer one runs GATHER_STATS_PROG, but I cannot verify that.
--
Regards
Pete
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 05 2008 - 10:59:40 CST