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,
|
|
|
|
|
|
|