Community

Speeding up the gathering of incremental stats on partitioned tables

(John Hallas) 11G introduced incremental global stats and the table WRI$_OPTSTAT_SYNOPSIS$ contains synopsis data for use in maintaining the global statistics. This table can grow very large and Robin Moffat has produced a good blog post about the space issues – note we both worked at the same s

Read More - Register for Free Membership

Tags: