Skip to main content
Solved

IFS Job for Gather Statistics

Mohamed Infaz
Hero (Employee)
Forum|alt.badge.img+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.

 

Best answer by EntNadeeL

 
infaz wrote:

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.

 

 

View original
Cheers, Infaz.
Did this topic help you find an answer to your question?
This topic has been closed for comments

3 replies

EntNadeeL
Hero (Partner)
Forum|alt.badge.img+10
  • EntNadeeL
  • Hero (Partner)
  • 181 replies
  • Answer
  • March 4, 2021
 
infaz wrote:

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
Navinth Bakmeedeniya
Nishadi
3 people like this
  • Mohamed Infaz
    Mohamed Infaz
  • Navinth Bakmeedeniya
    Navinth Bakmeedeniya
  • Nishadi
    Nishadi
Mohamed Infaz
Hero (Employee)
Forum|alt.badge.img+10
  • Mohamed Infaz
  • Author
  • Hero (Employee)
  • 158 replies
  • March 4, 2021

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
Hero (Employee)
Forum|alt.badge.img+14

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

dsj
Mohamed Infaz
J
3 people like this
  • dsj
    dsj
  • Mohamed Infaz
    Mohamed Infaz
  • J
    jasahu
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings