Solved

IFS Job for Gather Statistics

  • 4 March 2021
  • 3 replies
  • 400 views
Mohamed Infaz
Rank
Userlevel 5
Badge +10

Hi All,

 

Question : 

It’s mentioned in the IFS documentation that there is a Oracle Job for gathering table statistics from Oracle 10g, and also an IFS job probably triggers this oracle job. It’s advised to use only one. Where can i find IFS related scheduled job which is responsible for gathering statistics? 

 

Answer :

 

“In Oracle10g there is a predefined Oracle job for gathering statistics. The job is called GATHER_STATS_JOB and can be seen in the view Dba_Scheduler_Job. You shall either use the Oracle job or the IFS job for gathering statistics, not both. You turn off the Oracle job by using Dbms_Scheduler.Stop_Job('GATHER_STATS_JOB');”

 

There is a form called Oracle Objects in IFS applications.

 

This can be used to analyze a performance issue whether the statistics are old. Also you can select specific object and gather statistics if you are facing a problem in a certain DB object.

 

Hope this helps.

 

icon

Best answer by EntNadeeL 4 March 2021, 09:08

View original
Cheers, Infaz.
This topic has been closed for comments

3 replies

EntNadeeL
Rank
Userlevel 5
Badge +9
 

Hi All,

 

Question : 

It’s mentioned in the IFS documentation that there is a Oracle Job for gathering table statistics from Oracle 10g, and also an IFS job probably triggers this oracle job. It’s advised to use only one. Where can i find IFS related scheduled job which is responsible for gathering statistics? 

 

Answer :

 

“In Oracle10g there is a predefined Oracle job for gathering statistics. The job is called GATHER_STATS_JOB and can be seen in the view Dba_Scheduler_Job. You shall either use the Oracle job or the IFS job for gathering statistics, not both. You turn off the Oracle job by using Dbms_Scheduler.Stop_Job('GATHER_STATS_JOB');”

 

There is a form called Oracle Objects in IFS applications.

 

This can be used to analyze a performance issue whether the statistics are old. Also you can select specific object and gather statistics if you are facing a problem in a certain DB object.

 

Hope this helps.

 

Hi @infaz ,

See if below helps you.

 

 

Nadeesha Liyanage - https://www.linkedin.com/in/nadeeshaliyanage/
Mohamed Infaz
Rank
Userlevel 5
Badge +10

Hi Nadeesha,

Thanks for the elaboration. I actually identified the job itself in the post, but you have put it more elaboratively. 

Cheers, Infaz.
Navinth Bakmeedeniya
Rank
Userlevel 6
Badge +12

@infaz : IFS job for gather statistics is built based on the guidelines by Oracle. But the Framework usually recommends the usage of Oracle job over IFS job for gathering statistics for Oracle objects since Oracle job is native. If the Oracle job cannot be used due to some reason then can move for the IFS job. 

Oracle job is enabled by default. You can check with below.
 


Note that “auto optimizer stats collection” is the specific job for stats gathering.

If it is not enabled, you can use DBMS_AUTO_TASK_ADMIN.ENABLE to enable the job.

Terms & ConditionsCookie settings