Collecting Schema Statistics Collectively

 

In some cases, automatic maintenance jobs are closed in databases. In this case, the schema statistics are not collected and cause serious performance problems.

It is possible to collect individual statistics of the schemas via a job. You can use the following job for this job.

Necessary job to gather schema statistics:

You can replace the USER1, USER2, USER3 schema names in the Job with schema names in your own database, or adding another schema names to the corresponding block if more schemes are required.

The job will start every Saturday at 03:30. It would be useful to create it under the SYS schema. By increasing the degree parameter you can finish it in less time.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *