OraFAQ Forum: Performance Tuning » Gather statistics on SYS objects

Home » RDBMS Server » Performance Tuning » Gather statistics on SYS objects (Oracle 11.2.0.2.0. Sun OS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Gather statistics on SYS objects [message #546477]

Wed, 07 March 2012 00:07

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,

Report message to a moderator

Re: Gather statistics on SYS objects [message #546484 is a reply to message #546477]

Wed, 07 March 2012 01:25

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: Gather statistics on SYS objects [message #546487 is a reply to message #546484]

Wed, 07 March 2012 01:34

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

Report message to a moderator

Re: Gather statistics on SYS objects [message #546489 is a reply to message #546487]

Wed, 07 March 2012 01:41

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: Gather statistics on SYS objects [message #552853 is a reply to message #546489]

Sun, 29 April 2012 11:15

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Thank you Michel

Report message to a moderator

Previous Topic:	Query Running for a long time in Second Schema
Next Topic:	How to change the execution order

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 07:18:23 CDT 2024