Home » RDBMS Server » Performance Tuning » Auto stats job window details (Oracle 11.2.0.4 on Enterprise linux 6)
Auto stats job window details [message #623559] Thu, 11 September 2014 07:45 Go to next message
suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad
Member
Hi,

How to find whether daily automatic stats gather job window is sufficient to gather stats for all tables (which are applicable to gather stats) or not?

Thanks in advance for your help.

Best Wishes,
Suresh
Re: Auto stats job window details [message #623561 is a reply to message #623559] Thu, 11 September 2014 07:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Have you any performances issue?

Re: Auto stats job window details [message #623563 is a reply to message #623561] Thu, 11 September 2014 07:58 Go to previous messageGo to next message
suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad
Member
No performance issue. But I noticed few tables in DBA_TAB_MONITORING and they are not gathered as part of regular auto stats gather job. More importantly the tables belongs to SYS and SYSTEM schema.

So I would like to check if these are skipped due to insufficient auto stats window.

Suresh
Re: Auto stats job window details [message #623565 is a reply to message #623563] Thu, 11 September 2014 08:34 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
The automatic job gathers stats on system, which includes SYS owned tables. Unless if you disable it, you need to do it manually.

Some useful suggestions by Tom here https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:238646300346359117

[Updated on: Thu, 11 September 2014 08:35]

Report message to a moderator

Re: Auto stats job window details [message #623568 is a reply to message #623565] Thu, 11 September 2014 08:59 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> But I noticed few tables in DBA_TAB_MONITORING and they are not gathered as part of regular auto stats gather job.
Do NOT tell us, SHOW us.
How do we see what you claim exists?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/
Re: Auto stats job window details [message #623579 is a reply to message #623565] Thu, 11 September 2014 10:33 Go to previous messageGo to next message
suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad
Member
HI Lalit,

No tables are excluded purposefully. The tables I noticed contains $ in it (eg. AQ$_QUEUES).
By the way, any idea how to check whether auto gather stats window is sufficient or not?
Many sites are blocked in my working environment, so cannot copy list of tables.

Thanks for your help.

Suresh
Re: Auto stats job window details [message #623582 is a reply to message #623579] Thu, 11 September 2014 11:00 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> But I noticed few tables in DBA_TAB_MONITORING and they are not gathered as part of regular auto stats gather job.
explain how & why you conclude "they are not gathered as part of regular auto stats gather job."
Re: Auto stats job window details [message #623583 is a reply to message #623579] Thu, 11 September 2014 11:25 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
suresh.wst wrote on Thu, 11 September 2014 21:03
any idea how to check whether auto gather stats window is sufficient or not?


In your topic, there are two parts, whether automatic stats gather happens, and, whether it suffices.

Regarding the former part, as I said, if it is enabled, the automatic job gathers stats on system, which includes SYS owned tables. For the latter part, I honestly have NO answer, since I am not the one who developed it.
Re: Auto stats job window details [message #623597 is a reply to message #623559] Thu, 11 September 2014 13:12 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
suresh.wst wrote on Thu, 11 September 2014 13:45
Hi,

How to find whether daily automatic stats gather job window is sufficient to gather stats for all tables (which are applicable to gather stats) or not?

Thanks in advance for your help.

Best Wishes,
Suresh
Look at dba_autotask_job_history.
Previous Topic: Materialized view
Next Topic: High insertion on the database | Tuning parameters
Goto Forum:
  


Current Time: Thu Mar 28 15:36:40 CDT 2024