Iendtifying what the autotasks do

  • From: "Peter Hitchman" <pjhoraclel@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 5 Mar 2008 16:59:40 +0000

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2008