Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Gather Statistics from Active Data Guard

Franck PachotJan 15 2019 — edited Jan 18 2019

Hi, Statistics gathering can be a challenge: the window where there's no business activity is quite short. And concurrent statistics gathering can consume resources (I/O and CPU) which competes with online activity. In a Data Guard configuration, the hard job (read, sort, hash) could be done on the standby and statistics updated in the primary. Maybe with the possibility to gather them pending and publish them during a specific .

Comments
Post Details
Added on Jan 15 2019
8 comments
3,062 views