| Auto stats job window details [message #623559] |
Thu, 11 September 2014 07:45  |
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 #623563 is a reply to message #623561] |
Thu, 11 September 2014 07:58  |
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 #623579 is a reply to message #623565] |
Thu, 11 September 2014 10:33 |
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 #623583 is a reply to message #623579] |
Thu, 11 September 2014 11:25 |
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:03any 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 |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
suresh.wst wrote on Thu, 11 September 2014 13:45Hi,
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
