Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 266
  • Last Modified:

Gather Stats Job

I just noticed in OEM the GATHER_STATS is disabled.  I did not disable it.  What are some of the consequences of it being disabled?
0
xoxomos
Asked:
xoxomos
4 Solutions
 
sdstuberCommented:
there is only one consequence

unless you have some other processes that gather stats, your statistics on tables and indexes have been getting stale since it was disabled.


stale statistics can lead to inefficient query plans and hence poor performance
0
 
DavidSenior Oracle Database AdministratorCommented:
Which version of the DBMS?  11g and 12c both bring automated gathering to the party.

http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-bp-for-stats-gather-12c-1967354.pdf
0
 
sdstuberCommented:
It's only automated if the job is enabled

unless you're talking about dynamic sampling which isn't really  a substitute for real statistics gathering.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Devinder Singh VirdiLead Oracle DBA TeamCommented:
Do you have any process to collect stats on separate database lets say(active Standby), take export and import back in Prod?
In that case, it make sence that job is disable. Or you might have custom job to gather stats.
Disabling job is not a problem till you are collecting stats using some other method.
0
 
DavidSenior Oracle Database AdministratorCommented:
xo, please stay engaged if you want the experts to remain engaged.  We need to clarify your facts.
0
 
xoxomosAuthor Commented:
Thanks all.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now