A careful read of Oracle's documentation is important here. Managing Automated Database Maintenance Tasks
You find automated maintenance tasks now in dbms_auto_task_admin. There are several dictionary views related to this. Automated Maintenance Tasks Database Dictionary Views
in oracle 19, there is no GATHER_STATISTICS_JOB indeed... but im still wondering why auto optimizer_stats_collection is disabled, since its the default for oracle 11 onwards... is there any other scheduler based on the maintenance window set in the AWS RDS Configuration?
and by the way on all other RDS, the task is enabled in DBA_AUTOTASK_CLIENT ... wonder why someone jumped into this one to disable it....
Thanks Tim for the additional links. Its indeed an important matter since statistics collection is a key role in DB management. Its fine for me and probably for the other DBAs to have some tasks using Oracle's internal scheduler, and its actually working fine.... but i think that somewhere in the future there should be an integration be done between the maintenance window configuration in the RDS panel and Oracle's internal scheduler, for the sake of consistency
Relevant questions
empty get-metric-statistics
asked 6 months agoAWS automatic upgrade PostgreSQL version?
asked 4 months agoCant find my Lightsail instance on the aws console
asked 4 months agoRedshift Automatic Table Optimization and table swaps
Accepted Answerasked 2 years agoHTTP API metrics not showing in CloudWatch automatic dashboard
asked 7 months agoDirectConnect VCF utilization get-metric-statistics not returning any data
asked 7 months agocant find automatic statistics collection ow AWS RDS Oracle.
asked 20 days agoRDS Snapshot Chain - Automatic Backups Vs Manual Snapshots
Accepted Answerasked 2 years agoQuestions about request statistics in CloudWatch
asked 3 years agoWhere to find the search option
asked a year ago