disable gather stats job in 19c
hi,
Anyone know how do I disable the gather stats job in 19c? (temporary for installing OEM 13c)
I'm assuming it's the first job (auto optimizer stats collection)?
SELECT client_name, status FROM dba_autotask_operation;
auto optimizer stats collection ENABLEDauto space advisor ENABLEDsql tuning advisor ENABLED
will bellow work for 19c?
exec dbms_scheduler.disable('GATHER_STATS_JOB');
single instance, 19c with one tenant pdb
19.4.0.0.0
Linux 7
Thanks