Hello Everyone,

I am glad to be back in Sydney and ready to coordinate the Meetups again ;)
This time we are going to discus a performance sensitive topic - Oracle Statistics and anything that is related to it.
Oracle Statistics gathering strateg…

There are a lot of different recommendations and strategies you can choose from. The next Meetup goal is to make a review of options available and share experience in between the members to give you a background for further improvements in that area.
I think the following topics should be covered:
- How often do we need to gather statistics (if we need to gather it at all)
- What percentage should be used to gather statistics
- Should we lock statistics for any type of objects (staging tables, temporary tables etc)
- Partitioning and copying statistics from one partition to others
- Statistics gathering time windows and related techniques
- Automatic statistics gathering (pros/cons)
- Statistics gathering features in new Oracle RDBMS versions (11GR2)
- Statistics gathering and version control
- Do we still need to use analyse command as alternative to dbms_stats?
- Stats and DEV/TEST/UAT environment. How to manage those?
- … other related questions …

If you have any experience in that area (and I am sure that most of us has ;) please get in touch with me to have a possibility to share your experience with others.
PS I will do my best to get you talking. If not I will talk :)

See you soon,
Yury