What about Oracle DB mv/SQL access advisor & online redefinition team?

Anyone know something about this team? What skill can I expect learn from it? Thanks!