Home » RDBMS Server » Performance Tuning » Gather statistics on SYS objects (Oracle 11.2.0.2.0. Sun OS)
Gather statistics on SYS objects [message #546477] Wed, 07 March 2012 00:07 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

Do we need to gather statistics on SYS objects and fixed objects in 11gR2 database regularly ?

I read in some article that in 10gR2, statistics for SYS objects are by default whereas in 10gR1,
statistics for SYS objects are not by default using

dbms_stats.gather_database_stats(
...
gather_sys = False
...
)

Could you please clarify my doubts ?

Regards,
Re: Gather statistics on SYS objects [message #546484 is a reply to message #546477] Wed, 07 March 2012 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 58625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Do we need to gather statistics on SYS objects and fixed objects in 11gR2 database regularly ?


No only when there are many changes in metadata (create/drop objects, massive new statistics gathering, stored code...).

Regards
Michel
Re: Gather statistics on SYS objects [message #546487 is a reply to message #546484] Wed, 07 March 2012 01:34 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Quote:
No only when there are many changes in metadata (create/drop objects, massive new statistics gathering, stored code...).


How to find out the above changes in metadata ?

Thanks

Re: Gather statistics on SYS objects [message #546489 is a reply to message #546487] Wed, 07 March 2012 01:41 Go to previous messageGo to next message
Michel Cadot
Messages: 58625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is when you deliver a new application or upgrade a current one.

You can query dba_objects.last_ddl_time: when the number of the rows since the last gathering is quite big then you can gather them again.

Regards
Michel
Re: Gather statistics on SYS objects [message #552853 is a reply to message #546489] Sun, 29 April 2012 11:15 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Thank you Michel
Previous Topic: Query Running for a long time in Second Schema
Next Topic: How to change the execution order
Goto Forum:
  


Current Time: Wed Jul 30 15:17:44 CDT 2014

Total time taken to generate the page: 0.09530 seconds