cant find automatic statistics collection ow AWS RDS Oracle.

0

Hello

Currently working on Oracle19c

I cant find either the automatic table data statistics enable both ways

  • DBA_AUTOTASK_CLIENT auto optimizer_stats_collection is set to disabled
  • DBA_SCHEDULED_JOBS there is no entry for GATHER_STATISTICS_JOB

Neither i can find a concise documentation in the guides for RDS standard tasks for such important recurrent task

Is there a reason for none of them is activated? Does the statistics collection obey the maintenance windows set in the AWS console and not in Oracle schedulers?

Thanks Alexandre

4개 답변
2

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

profile pictureAWS
답변함 2년 전
0

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?

답변함 2년 전
0

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....

답변함 2년 전
0

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

답변함 2년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인