Database Administration (MOSC)

MOSC Banner

disable gather stats job in 19c

edited Mar 13, 2020 10:08AM in Database Administration (MOSC) 4 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center